SUMMARY

• 9 years of work experience in software development with 4 plus years of onsite experience.
• Over 5+ years of IT experience in analysis, design, development, testing and implementation of data warehouses as an ETL Developer using Informatica.
• Expertise in data warehousing and data mart concepts using different Methodologies experience with domain knowledge of Insurance.
• Experience in Analysis, Design, Development, Implementation, Testing and support of Data Warehousing and Data Integration solutions using Informatica PowerCenter
• Extensive Knowledge on the development life cycle process from requirements gathering to deployment of code to production and good knowledge on the Dimensional modeling
• Experience in Extraction, Transformation and Loading of data from various sources into Data Warehouse using Informatica PowerCenter ( Repository Manager, Designer, Workflow Manager and Workflow Monitor)
• Creating mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner and stored procedure transformations
• Developed Reusable objects, transformations and mapplets using Mapplet Designer and Transformation Developer
• Have extensive knowledge in full SDLC life cycle development of Data warehousing
• Experience with dimensional modeling using star schema and snowflake models
• Proficiency in developing SQL with various databases like SQL Server and Teradata
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
• Experienced in Performing Unit testing, system testing, regression testing, and smoke testing and system integration testing.
• Excellent team player with problem - solving and trouble-shooting capabilities
• Proven track record of completing and managing large, complex, multiple and aggressive projects on schedule with limited resources and environment with tight schedules.
• Leading a Team, Managing different modules, Project Implementation, Testing the product/application (Functionality Testing, Unit Testing and QA Testing) and Defect Tracking and Fixing are some of the main responsibilities executed
• Expert in documentation of the quality based process approach like preparing Design Documents, Presentations using Visio and PPT, Weekly Reports, Traceability Matrix, Code Review Documents, Unit Test plan, System Test Plan, etc.
• Eager to learn new things and strive for continued excellence.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.6.1 (Designer, Workflow Manager, Workflow Monitor, Mapplet, Transformations), Data mart, OLAP, OLTP

Dimensional Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Microsoft Visio 2010

Databases: Oracle 11g/10g/9i, MS SQL Server 7.0/2008/2005 , My SQL, DB2, MS Access, Teradata, VSAM, IMS.

Tools: & Utilities: SQL*Plus, Teradata, SQL Navigator, Toad, SQL tools, Autosys, MS-Office, Xpeditor, File-Aid, FTP, CONTROL-M, $AVRS, ISPF, SDSF, Panvalet, Endeavor.

Programming: SQL, PL/SQL, MS SQL, UNIX Shell Scripting, COBOL, JCL, CICS, Easytrieve

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , Windows 2000, Windows XP, Unix, MVS/ESA, OS 390.

Tools: Informatica PowerCenter 9.1, SQL Developer, TOAD, MS Office, Visio

PROFESSIONAL EXPERIENCE

Confidential

ETL/Informatica developer

Responsibilities:

• Extensively worked with the Dimensional Data Modeling methodology Star models using Ralph Kimball and W.H Inmon methodologies.
• Responsible to develop logical and physical data models to support design and development of data warehouse and data marts.
• Worked with Business and gathered the Analytics requirements and created the Business Model using Star schemas.
• Involved in data integration, transformations, and load processes using Informatica.
• Involved in Data Quality Analysis to determine the cleansing requirements.
• Involved in the mapping and workflow specifications.
• Created numerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, and Sequence generator, Sorter, Joiner and Update Strategy.
• Created UNIX scripts to auto generate the parameter files
• Expertise in developing SQL and Oracle PL/SQL code as procedures functions, packages and triggers in SQL to implement the business logic and for various data cleansing activities.
• Created Mapplets and reusable transformations to be re-used during the development life cycle.
• Implemented slowly changing dimensions type1 and Type 2 using date.
• Used Parameter files to define values for parameter and variable used in the mappings and sessions.
• Created session and Worklets in Workflow manager having event tasks like e-mails.
• Extracted data from source systems like Teradatafiles and loaded to a relational Data Warehouse.
• Worked on performance tuning by finding out the bottlenecks in various mappings.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization.
• Responsible for determining Incremental Loading mappings using Mapping Variables and Parameter Files.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization.
• Used Informatica Scheduler for scheduling the workflows.
• Leading First Response (FR) Team and hosting the huddle calls for the FR status and involved in business triage (ticket intake) meetings.
• Responsible for Production Support and Issue Resolutions using Session Logs and Workflow Logs.
• Worked on Monitoring workflows.
• Coordinated offshore team and communicating with Business.

Environment: Informatica PowerCenter 9.1, WINDOWS, PL/SQL, Remedy, Teradata, DB2, CA-ESP

Confidential, Chicago, IL

Senior Programmer Analyst

Responsibilities:

• Analysis, design, preparation of the functional specifications documents. Code reviews and test reviews.
• Validation and Verification of data to various systems like CIMS and Merlin.
• Development of new programs and Enhancement to existing system using detailed design documents, conducting reviews and interacting with offshore team on the feedback provided by the client.
• Used COBOL extensively to do code changes for all the enhancements and maintenance projects.
• Worked with Cobol-IMS, Cobol-DB2 programs, copybook layout changes. Compiled the changes to do unit testing of the code changes and then moved the compile code for QA testing.
• Involved in RSD reviews and interacted with business people to get the clear requirements
• Involved in Release coordination to deal with different teams like Quality Analyst, Solutions, Business, and DBA.
• Debugged the code written for defect analysis and fixed the defects.
• Status reporting to Client in daily status meeting.
• Prepared new job flows and scheduling changes as per the requirements
• Migration of code from Development to Testing and Production environment
• Interacted with the company vendors for their requirement changes.

Environment: COBOL, JCL, CICS, Easytrieve, Endevor, SQL, SQL Server 2005, VSAM, DB2, IMS

Confidential, LOUISVILLE, KY

Responsibilities:

• Get the requirements from clients, created documents and pass the information to offshore.
• Involved in production support resolving various critical errors and hence maintaining smooth flow of the cycle.
• Validated and analyzed the missing date to the other systems and fixed them as and when required.
• Fixed the production defects that required code changes to COBOL programs and fixed them to work smoothly in Production environments.
• Involved in code reviews with the clients to approve the changes made to Cobol Batch and Online programs.
• Involved in unit testing of the COBOL and Easytrieve components using JCL, VSAM, PANVALET, etc.
• Involved in writing SQL queries for data extraction to test the code changes with specific data.
• Involved in coding COBOL-DB2 programs for new programs which involved in creating new reports for the business users.

Environment: - COBOL, JCL, EASYTRIEVE, SQL, SQL Server 2005, DB2, VSAM, File-Aid, PANVALET, SDF II, ISPF, MVS/ESA

Confidential

Responsibilities:

• Development of new programs and Enhancement to existing system using detailed design documents.
• Maintain the existing functionalities and to help synchronize the data between ODS and other platforms.
• Turn process. Involved in fixing lot of defects in Batch programs which updates the Core Database from several Systems.
• Code changes were all done using COBOL programming language.
• Also involved in Analyzing DB2 tables for proper data using SQL queries.

Environment: - COBOL,JCL,EASYTRIEVE, SQL, SQL Server 2005, DB2, File-Aid, PANVALET, SDF II, ISPF, MVS/ESA

Confidential

Responsibilities:

• Analysis, design, preparation of the functional specifications documents. Code reviews and test reviews, Turn process.
• Analysis of Data provided by different systems like CI, MTV, ODS, etc for the development of functional specifications documents.
• Development of new programs and Enhancement to existing system using detailed design documents, conducting reviews and interacting with offshore team on the feedback provided by the client.
• Loading data into Oracle Database
• Testing of stored procedures for correction of Web application errors.
• Involved in working with COBOL components, stored procedures and communicating Oracle Databases for Tracking System.

Confidential

Responsibilities:

• Analyzing the data from each system feeding Recon data
• Development of new stored procedures and Enhancement to existing system
• Testing of stored procedures in different regions provided by each system and the Turn process.

Environment: - COBOL, JCL, EASYTRIEVE, SQL, SQL Server 2005, DB2, File-Aid, PANVALET, SDF II, ISPF, MVS/ESA

Confidential

Responsibilities:

• Analysis, design, preparation of the functional specifications documents. Code reviews and test reviews, Turn process.
• Development of new programs and Enhancement to existing system using detailed design documents, conducting Peer reviews and working on the feedback provided by the client.
• Responsible for analysis of the service requests, Problem identification and fixing the root-causes
• Testing Cobol Batch components in the various Testing regions and Training regions for Region Building.
• Coordination with offshore though all the phases of task.

Environment: - COBOL, JCL, EASYTRIEVE, SQL, SQL Server 2005, VSAM, DB2, File-Aid, PANVALET, SDF II, ISPF, MVS/ESA

Confidential

Software Developer

Responsibilities:

• Analysis, design, preparation of the functional specifications documents and detail design documents Design and Development of database.
• Development of new programs and Enhancement to existing system using detailed design documents, conducting Peer reviews and working on the feedback provided by the client.
• Used COBOL extensively for development and enhancement tasks.
• Responsible for analysis of the service requests, Problem identification and fixing the root-causes.
• Provisioning of appropriate recommendation(s) for a permanent solution, monitoring the batch scheduler (OPC, CTM) error queue for batch run.
• The permanent solution included changes to existing Cobol Batch programs and fixing them in Production.

Environment: - COBOL, CICS, JCL, EASYTRIEVE, VSAM, Changeman, Xpeditor, File-Aid, OPCA, CTM, $AVRS, MVS/ESA