Having more than 6 years of IT experience and proven record in Analysis, Design, Development and Implementation of adaptive High Performance GUI Applications and Relational Databases (OLTP) using C#, VB,ASP.NET,Web services,SharePoint,windows services, Infragistics, Oracle and SqlServer .In-depth knowledge in Client/Server Applications using Object Oriented programming.
Technical Proficiency:
? 6 Years of Experience in C#,VB.NET and ASP.NET,Sharepoint,XML by the virtue of working with highly resilient Web Applications ? Worked in Latest .NET Technologies like .NET 3.0,3.5,VS 2008,WCF,SOA,Remoting and WPF ? Have more than 4 years of US Experience ? Microsoft Certified (MCP), Developing and implementing web applications with MS Visual C# .Net and Microsoft VisualStudio.Net. ? More than three Years of IT Experience in Market research and Banking, Financial Service and Insurance domain. Two years of Experience in Utility Industry. ? Have Industry Experience in working as Business Systems Analyst to identify business requirements for IT projects. Was Awarded “Star performer of the year” in 2007 ? Experience in Analysis, Design, Development, Implementation and Testing of Client/Server Applications and Business Intelligence solutions. ? Microsoft certified professional -Transcript ID (752743) ? Brain bench Certification in ASP.NET- Transcript ID (5754209) ? Industry experience with ORACLE in Information Technology ? Created high quality and standards complying web designs with CSS and HTML ? Strong skills in Visual Studio.NET-(C#, ADO.NET, ASP.NET), webservices, windows services, JavaScript, IIS, SQL Server, MS Access, CSS, Infragistics controls and Charting components. ? Expertise in Web Technologies HTML, Java Script, UML and ASP ? Strong experience in TSQL, SQL, PL/SQL Procedures/Functions, Triggers and Packages. ? Hands on experience in development lifecycle including analysis, design, development, testing, debugging, enhancements and maintenance for various application systems. ? Experience in Third party tools such as Infragistics Controls and charting components such as Dotnet charting, Infragistics Charting and Dundas Charting ? Worked on version control software such as Visual SourceSafe and CVS ? Extensive understanding of Business processes & interface with IT ? Expertise in End-User training, User documentation and Application/Product Demos ? Team Player, Short learning curves and Self Starter with Excellent Interpersonal and Communication Skills.
Technical Skills
Operating Systems : Windows XP/2000/NT/98. Domain : Market Research, Banking, Financial Services, Insurance and Utilities Languages : VB, ASP.NET C#, SQL, PL/SQL, VB.NET, Windows and Web Services Web server : IIS 6.0, IIS 7.0 Framework : .NET 1.0, 1.1, 2.0, 3.0 and 3.5 Development Tools : Visual Studio.NET 2003, 2005, 2008 and Visual Studio 6.0, Sharepoint Databases : Oracle9i, SQL Server 2000&2005, MS-Access. Methodologies : Star schema, Snowflake schema. Web Tools : CSS, HTML, ASP, JavaScript, VB script. Bug Reporting : Bugzilla Version Control tools : CVS and Visual Source Safe Third Party Tools : Dundas Charting, DotNetCharting Charting, Infragistics Controls Packages : MS Office 2000/XP (Word, Excel, Power Point), Lotus Notes
Educational Profile
Bachelor of Engineering in Computer Science Engineering
Projects
Asp.NET Developer American Electric Power ,Columbus
Project : DWMS WEB TOOL OCT'08 --Present Client : American Electric Power Domain : Electrical power Environment : Windows 2003, ASP.Net 3.0,VS2005 SP1, C#.NET, Infragistics Controls,CSS,HTML, Infragistics Charting Control ,Oracle 10g, Windows Vista SDK for .Net 3.0 development, Visual Studio 2005 extensions for WCF & WPF,Sharepoint 2007, Visual Studio 2005 extensions for Workflow
ARCHITECTURE -- Common Solution Platform Distribution Work Management System (DWMS) The Distribution Work Management System (DWMS) web tool is a set of processes and software programs implemented to streamline Distribution work. These standardized processes and highly effective tools allow Distribution to better track and expedite work -- benefitting both AEP customers and employees. DWMS also enables Distribution to better utilize its assets and to return greater value to AEP's shareholders. Included in the DWMS software programs: • STORMS - A resource management tool allowing jobs to be initiated through interfaces in the Customer Solutions Centers (CSC), Distribution Dispatch Centers (DDC) or any employee with access to STORMS.
• SPECTRUM -A mobile application allowing field personnel to receive and complete jobs while tracking their progress in near real time.
The purpose of this project was to greatly improve the usability, functionality, and maintainability of the DWMS Webtool browser by rewriting the tool using an AEP standard technology set. Additional reporting on event counts is being added to provide useful measurements for load models and for use by Support for tracking system activity.
A cross-referenced WR or External System Primary Key lookup is being added to give a complete audit of messages related to a WR or External System Primary Key. Several queries for order tracking in SIM are being added for trouble shooting and support of that system.
These new features in combination with various usability changes will bring the Webtool forward and will greatly enhance the user experience with this tool.
Responsibilities:
• Worked with the Business analysts for Supporting User query.
• Used a newly Devised Architecture in AEP called as “Common Solution Platform”.
• The Dot net module developed in C#.NET takes care of reporting and data entry part of the software.
• Created Packages in Oracle9i to be accessed by the C#.NET module.
• Used Infragistics AJAX controls for Ultrawebtree, UltraChart.
• Developed number of Complex GUI's using HTML, CSS and Infragistics AJAX.
• Visual C#.NET and web services is used to implement the Business Logic
• Collaboration Data Objects is being used to access underlying objects of Microsoft Outlook Object Library 11.0 for development of E-Mail, Appointment and related module
• Involved in massive data cleansing of the production data load
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule
• Analyzed the systems, contacted with end users and business units in order to define the requirements.
• Worked with different Sources such as Oracle, SQL Server Excel and Flat files.
• Written documentation to describe program development, logic, coding, testing, changes and corrections
Role: Requirement Analysis, Design, Coding, Unit Testing & Integration Testing and Implementation.
Business System Analyst/Developer American Electric Power ,Columbus
Project : Special Contracts Billing Engine May'08 --Present Client : American Electric Power Environment : VB6, VB.NET, Windows 2003 server, Sheridan, Oracle 10g, Visio Description:
The Special Contracts Billing Engine (“SCBE”) is an innovative database application that manages standard and complex billing for large utility customers. The system was derived from an existing Microsoft Access system (“SBE”) and re-engineered into a client server application utilizing an Oracle database. System Components There are several components to the application: The SCBE Main application -- The SCBE Main application consists of several Visual Basic projects. It is a 3 tier project with a User Interface tier, a Business Objects tier and a Database Objects tier. In addition, there are separate projects for the Invoice creation, billing determinants calculations, and batch submissions of calculations, invoices and postings to the Customer Information System. . Sheridan Active Suite is needed to support the ActiveListBar
This project was an enhancement of the security and Invoice template control features.
Responsibilities:
• Involved as the BSA.Interacted with Business units and Users to get the requirements for this enhancement project
• Preapred a High level estimate for the project and other prilimnary analysis documents.
• Performed Requirement analysis and Design .
• Interacted with the devolopers and guided them throught the lif cycle of the project.
• Created, updated and maintained technical documentation.
• Involved in regular interaction with the Business Units to get various requirements clarified.
• Involved in creation of the Datbase design for this particular enhancement and also was involved in Project performance discusions.
• Responsible for Creating solutions for Business Requirements.
• Involved in formal reviews at all steps of the project.
Project : Customer Communication System June'07 --April'08 Client : American Electric Power
Environment : ASP.Net, VB.NET,C#, Sql Server 2000, Windows 2000, ASP.Net 1.1,VS2003, C#, SOA,Remoting, Infragistics,XML
The Customer Communication System (CCS) is an Internet-based, interactive energy information system designed to provide the necessary flow of information between AEP and its customers. CCS supports three main services: • Interruptible Services • Special Services • Real Time Pricing (RTP) The new Kentucky Power Company Experimental Real-Time Pricing Tariff is available to customers normally taking firm service under Tariffs Q.P. or C.I.P-T.O.D. for their total capacity requirements from the Company. The customer will pay real-time prices for load in excess of an amount designated by the customer. This experimental tariff will be limited to a maximum of 10 customers. This tariff will be offered on a pilot basis for a three-year period. The RTP Tariff will offer customers the opportunity to manage their electric costs by shifting load from higher cost to lower cost pricing periods or by adding new load during lower price periods. It will also offer the ability to experiment in the wholesale electricity market by designating a portion of the customer's load subject to standard tariff rates with the remainder of the load subject to real-time prices. AEP already has a system in place, the Special Contract Billing Engine (SCBE), for billing Oklahoma Real-Time Pricing customers. This Project outlines the functional and non-functional requirements related to enhancing CCS to bill Kentucky Power Real-Time Pricing customers.
Responsibilities:
• Involved in the analysis, design and development of all the interface's.
• Was one of the lead Developers and actively involved in mentoring other junior developers .
• Created the Detailed Design Document of about 100 pages .
• Developed standard and re-usable components in the project.
• Created, updated and maintained technical documentation.
• Created procedures and packages.
• Was part of review teams and Testing teams.
• Managed software releases after each stage of the testing and defect removal.
Project : Market Analysis Reporting Tool (MART) May'06 --June 07 Client : TIAA-CREF Domain : Banking Financial Services and Insurance Environment : Windows 2003, ASP.Net 3.0,VS2005, C#, Infragistics Controls,CSS,HTML, Dundas Charting Control ,Oracle 9i, SQL Server 2000, TOAD.
MART
MART- Management Analysis Reporting Tool provides a standardized management information display of executive performance measures and actionable initiatives. MART Insight will allow users at the clinic level to create and display measures that have local management relevance and that link to executive Balanced Scorecard (BSC) measures. MART caters to the BI needs of companies. The most attractive feature of this product is customization of functionalities based on the business operations of our clients. MART Insight: Provides real-time, actionable data to help direct management's efforts • Provides monitoring of key data to increase performance accountability • Helps leadership identify performance trends for appropriate action MART captures and validates data from Multiple and Variable sources using ETL tools such as Informatica. This robust repository offers more than TB's of records on-line with many years of data. The MART is the single point for: • Data integration • Data quality edits • On-line and near-line data storage • Reports, dashboards and Charts
Responsibilities:
• Worked with the Business analysts for Supporting User query from various countries.
• Lead a team of four in developing a Module using C# Dot net.
• The Dotnet module developed in C#.NET takes care of reporting and data entry part of the software.
• Created Packages in Oracle9i to be accessed by the C#.NET module.
• Used Infragistics AJAX controls for Ultrawebtree.
• Created users, Groups, Assigning users to groups and grant privileges and permissions to groups and Folders.
• Developed number of Complex GUI's using HTML, CSS and Infragistics AJAX.
• Visual C#.NET and web services is used to implement the Business Logic
• Collaboration Data Objects is being used to access underlying objects of Microsoft Outlook Object Library 11.0 for development of E-Mail, Appointment and related module
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule
• Analyzed the systems, contacted with end users and business units in order to define the requirements.
• Worked with different Sources such as Oracle, SQL Server Excel and Flat. Used Informatica to extract data into Data Warehouse.
• Written documentation to describe program development, logic, coding, testing, changes and corrections
Role: Requirement Analysis, Design, Coding, Unit Testing & Integration Testing and Implementation.
Asp.NET Developer Dexterity Business Analysts (P) Ltd, Chennai
Project : Temo Kone Jan'06 --April'06 Client : Dapresy Research AB Environment : ASP.Net, C#, Windows 2003 server, IIS 6.0, SQL Server 2000,CSS, Java Script,HTML, Ajax Description:
? This project is to enhance an existing asp.net application Temo Kone programmed to perform as a reporting tool based on the selections on screen.
? The application uses a third party components DotNetCharting and dundasCharting, which is used to display the report as a chart.
? The data for the chart is present in SQL Server and is sent to the component formatted, after the calculations present in stored procedures.
? The system has different web pages to display the report as charts, tables, excel sheets, Downloadable word document and PDF documents.
? The selections in the screens required for presenting the reports were time consuming and the main scope of the enhancement was to the change the existing selection from List boxes to Infragistics 6.1 ultra Web Tree using AJAX and implements certain Layout changes. Role: Requirement Analysis, Coding, Unit Testing & Integration Testing.
Oracle Developer Dexterity Business Analysts (P) Ltd, Chennai
Project : SIRVAL Feb'05 --Dec'05 Client : AC NIELSEN, Italy
SIRVAL The Project SIRVAL stands for Standard Input Record Validation system that creates the gateway for the data into the data warehouse system (Called NRSP designed and developed by ORACLE Corp) to support business intelligence needs of the client's. SIRVAL loads a huge volume of data, to the tune of many TB's of raw data, into the NRSP Factory data scopes. This application involves extracting data from various sources like store data from mainframes (As Flat file), cross coding data from EIMDB and Sample data from SCDB. Later data marts are created for various services from these data, after applying the validations and business rules. Validation is the core functionality of the system which involves complex statistical models and algorithms.
Last stage of this system involves loading the data into NRSP and NSLP data scopes. Output is delivered in three methods: DBlink, Oracle advanced queue and FTP.
Responsibilities:
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Oracle.
• Involved in the analysis, design and development of all the interface's using Informatica Powermart tools in interface team and interfaced with all the other tracks for business related issues.
• Used Debugger to test the mappings and fix the bugs.
• Created mappings to move from Various Systems (OLTP) to Transaction History database (Reporting Database).
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Created, updated and maintained ETL technical documentation.
• Created procedures and packages.
• Was part of scripting team to automate and migrate data from ODS to Data warehouse.
• Responsible for Creating business solutions for Incremental and Full loads.
• Loaded Aggregated fact tables.
• Managed software releases after each stage of the testing and defect removal.
Asp.NET Developer Dexterity Business Analysts (P) Ltd, Chennai Project : TWR Tool Oct'04 --Feb'05 Client : Dapresy Research AB Environment : ASP.Net, C#, Windows 2003/XP, IIS 6.0, SQL Server 2000, and Java Script, XML, HTML, CSS, Infragistics Controls, Dundas Charting Control, DChart Charting Control, Obout Tree Control. Description:
? To develop a web application, TWR Tool which creates setup files to TWR Online systems.
? The TWR Online will also develop into managing PowerPoint based deliveries of the result of a project at the same level as Autograph deliver today.
? TWR Tool is a system developed to organize survey data from Temo into a structured format as required by the TWR Online system.
? TWR Tool is developed as a tool to automate the structuring of data in an easy and efficient manner, which is currently done manually at Temo and Dapresy.
? TWR Tool will now enable Temo users to upload Survey data into this system, clean and weight the data, define question areas, define reports, define indexes and arrange order of reports in TWR Online system.
? In short, TWR Tool is set up tool to convert survey data into a structured reporting data.
Role: Involved in Requirement Analysis, Database Design (SQL Server Jobs), Coding, Unit Testing & Integration Testing.
VB/ORACLE Developer Dexterity Business Analysts (P) Ltd, Chennai
Project : LogisticDB (LDB) April'04 -- Sept'04 Client : AC NIELSEN Italy. Environment : Visual Basic - 6.0, ORACLE -- 9i, Sheridan, Spread Controls. LDB LogisticDB is an application to maintain details of relationship with collaborators, tracking hardware details which were distributed to the recruited collaborators for the purpose of tracking their consuming behavior and managing rewards (points & gifts) for their sustained relationship with the company. There are three modules SETUP - which maintains details of source of information, type of audit methodology used to collect the information
? HARDWARE MAINTENANCE - which maintains details of hardware's distributed to the collaborators
? HELPDESK-which maintains data which helps in supporting relationship with collaborators - by reminding them to send data, conduct adhoc surveys, reward them.
The application was not able to display and save the date related details properly, because of the third party date control whose date format was affected by the system date format settings with no regards for the date format selected by the user in the GUI and that the inbuilt visual basic function - format$ was unable to handle this issue.
Responsibilities: • Responsible for creation of logical data models based on entity-relationship diagrams. The models were developed in accordance with the rules of referential integrity and normalization. • Involved in interacting with the business community to understand their requirements. • Design and developed PL/SQL procedures, packages and triggers to be used by team members. • Created materialized views to increase the speed of queries. • Created test databases to test and tune the queries. • Designed and implemented user interface with various VB Controls and Components. • Implemented various types of Reports on date, amount and quantity criteria.
Role: Implemented custom functions to maintain the date formats in the required format.
Java/Sql Developer Dimensions Cybertech India Pvt, Techno park, Trivandrum
Project : ProTrac-T Feb'03 --April'04 Client : Dimensions Cybertech India Pvt, Techno park, Trivandrum Environment : Java 1.5, JFC Swing, Windows XP, SQL Server 2000, MySql 3.1 Description:
? Developed a web application, Protrac-T which is a complete project management toll.
? A feature-rich web-based project manager software that remains simple and easy-to-use.
? Packages are suitable for all-sized businesses, whether they need a low volume or a high volume of users or storage space.
? It has plenty of project management features such as time tracking, Gantt charts, calendars and document management.
? Pre-formatted templates, that will save time writing project documentation. And also gain all of the project management tools needed to initiate, plan, execute and close projects efficiently.
Role: Client interaction and coordination, Requirement Analysis, Database Design, Coding, Unit Testing & Integration Testing.
Certifications
See above
CONTACT DETAILS
You must be logged in and have a current resume access subscription. Login or Register »