SUMMARY:

• Over NINE years of experience in Informatica - Data Warehouse and ETL Tool
• Extensively worked on Data Integration and data migration using Informatica Power Center for the Extraction, transformation and loading of data from various database source systems, flat files and mainframe Cobol/VSAM files
• Good knowledge on Oracle, DB2 and SQL Server
• Well versed in TSQL, SQL, UNIX Shell Script
• Over NINE years of experience in Health care domain of the major Health Insurance customer
• Above SEVEN years of experience in leadership position including Onsite coordinator, Technical lead, Business Analyst, Project lead
• Experience in direct interaction with Business Stake holders in requirement study
• Solid communication, interpersonal, leadership, and collaborative skills
• Proficiency in handling the complete SDLC for adopting & keeping abreast the latest IT trends/ technologies
• Experience in Agile and scrum methodologies

AREAS OF EXPERTISE:

• Strong skills in Requirement gathering and study, actively involved in preparing Proposals and Project Plans, strong skills in solution Design Phase, preparing Business Requirement document, Low and High Level Technical Design Document, Process diagrams.
• Participated in all phases of the development lifecycle, with significant participation in the data integration design and development, advocating for standardization, reviewing performance results, and preparing for implementations.
• Experience in Informatica mapping specification documentation, performance tuning mappings
• Expert skills in performance tuning, monitoring, and troubleshooting data integration solutions
• Experience in SQL Server, ORACLE, DB2 Databases
• Demonstrated ability for creative problem solving of business and technical challenges
• Handled testing phase of the project including Unit testing, Integration testing, System Integration testing, ensuring all necessary data are extracted, transformed and loaded to the target system
• Closely work with users in successfully completing the User Acceptance Testing
• Achieved customer satisfaction by ensuring service quality norms and building the brand image by exceeding customer expectations

TECHNICAL SKILLS:

Tools: Informatica Power Center 9.x/8.x/7.x, TOAD, SQL Developer, MS Visio, Clear quest, Squirrel, SSIS

Operating Systems: DOS, Windows, Linux.

Languages: TSQL, SQL, VB Script, UNIX Shell Script.

Database: Oracle 8i/9i/10g, SQL Server 2008, DB2

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Technical Lead

Responsibilities:

• Involved in gathering requirements and Business Analysis
• Design the proposal and solution, and present it to client
• Design the mappings using JAVA transformation, Look up and all other complex transformations
• Create the mappings, workflows, UNIX
• As a Technical lead, guide team in designing and developing optimized ETL mappings
• Fine-tune Informatica maps for performance optimization using the Partitioning
• Perform Unit testing, System testing and Integration testing

Environment: Informatica PowerCenter 9.6, Oracle 10g, DB2 V9, SQL Server 2008, Putty, TOAD, Squirrel, WinSQL, UNIX Script, TSQL, SQL, SSIS

Confidential, Newport News, VA

Technical Lead

Responsibilities:

• Involved in gathering requirements and Business Analysis
• Design the proposal and solution, and present it to client
• Design the mappings using JAVA transformation, Look up and all other complex transformations
• Create the mappings, workflows, UNIX
• As a Technical lead, guide team in designing and developing optimized ETL mappings
• Fine-tune Informatica maps for performance optimization using the Partitioning
• Perform Unit testing, System testing and Integration testing

Environment: Informatica PowerCenter 9.1, Oracle 10g, DB2 V9, Putty, TOAD, Squirrel, WinSQL, UNIX Script, TSQL, SQL

Confidential, Newport News, VA

System Analyst and IT Lead

Responsibilities:

• Involved in gathering requirements and Business Analysis
• Design the proposal and solution, and present it to client
• Designed the mappings using Custom Transformation and Java transformation
• As a Technical lead, guide team in designing and developing optimized ETL mappings
• Fine-tuned Informatica maps for performance optimization
• Involved in generating UNIX scripts to validate the input files and create reports to be sent to stake holders
• Reviewed the Unit testing, System testing and System Integration testing

Environment: Informatica PowerCenter 8.6, Oracle 10g, DB2 V9, SQL Server, Putty, TOAD, WinSQL, UNIX Script, SQL, Windows 2000, VB Script, SSIS

Confidential, Los Angeles, CA

System Analyst and IT Lead

Responsibilities:

• Involved in gathering requirements and Business Analysis
• Designed the mappings using Custom Transformation and Java transformation
• As a Technical lead, guide team in designing and developing optimized ETL mappings
• Fine-tuned Informatica maps for performance optimization
• Involved in generating UNIX scripts to validate the input files and create reports to be sent to stake holders
• Reviewed the Unit testing, System testing and System Integration testing

Environment: Informatica PowerCenter 8.6, Oracle 10g, DB2 V9, Putty, TOAD, WinSQL, Sybase, UNIX Script, PERL Script, Trillium Scripts, SQL, Windows 2000, Mainframe Cobol/VSAM Files.

Confidential, Los Angeles, CA

System Analyst and IT Lead

Responsibilities:

• Involved in gathering requirements and Business Analysis
• Direct interaction with Stakeholders to know their requirements
• Coordinated with offshore in design, coding and testing
• As a Technical lead, guide offshore team in designing and developing jobs in an optimized manner
• Reviewed the Unit testing, System testing and System Integration testing
• Succeeded in Meeting deadlines for each module without compromising quality norms
• Served as Single Point of Contact / interface for supporting Client

Environment: IBM DataStage Infosphere 8.6, SQL, Windows 2000, Mainframe Cobol/VSAM Files.

Confidential, Los Angeles, CA

System Analyst and Technical Lead

Responsibilities:

• Involved in gathering requirements and Business Analysis
• Direct interaction with Stakeholders to know their requirements
• Coordinated with offshore in design, coding and testing
• As a Technical lead, guided offshore in designing and developing ETL mappings in an optimized manner
• Fine-tuned Informatica maps for performance optimization
• Involved in generating PERL Scripts to convert the Excel files to CSV files
• Involved in generating UNIX scripts to create reports to be sent to Business
• Reviewed the Unit testing, System testing and System Integration testing
• Scheduled the process in Work load manager
• Succeeded in Meeting deadlines for each module without compromising quality norms
• Served as Single Point of Contact / interface for supporting Client

Environment: Informatica PowerCenter 8.6, SQL Server, UNIX Script, PERL Script, SQL, Windows 2000, SQL Stored Procedure, SSIS

Confidential, Los Angeles, CA

Senior ETL Lead Programmer

Responsibilities:

• Involved in gathering requirements and Business Analysis
• Created design documents and mapping documents
• Involved in design and development of complex ETL mappings in an optimized manner
• Fine-tuned Informatica maps for performance optimization
• Involved in generating PERL Scripts to convert the Excel files to CSV files
• Involved in generating UNIX scripts to create reports to be sent to ESI Business
• Involved in the Unit testing, System testing and System Integration testing
• Best performer award from the Account Manager for the leadership skills demonstrated in Rate Load Project

Environment: Informatica PowerCenter 8.6, Oracle, UNIX Script, PERL Script, SQL, Windows 2000.

Confidential

Senior ETL Programmer Lead

Responsibilities:

• Detailed analysis of System and developed Estimate
• Requirement analysis and Design the application from the existing DTS, SSIS packages
• Developed jobs based on user requirements
• Involved in Unit and System testing
• Generated queries and executed in MS Access to unit test huge volume of data in .MDB format
• Used OpenProj, an Open Source application that provides project scheduling and management functionality
• Served as Single point of contact for supporting Client and Lights - on team, until Warranty period of the project
• Used Tortoise SVN as a configuration management tool
• Used Autosys for scheduling and automation

Environment: Informatica, Oracle, Windows 2000, MS Access, MS - DTS, Teradata, SSIS, Autosys

Confidential

Senior ETL Developer and Module Lead

Responsibilities:

• Involved in gathering requirements and Business Analysis
• Created design documents and mapping documents
• Involved in design and development of complex ETL mappings in an optimized manner
• Used Normalizer transformation to generate reports with history data
• Developed IDQ Plans to cleanse the data and integrated it in Power center mappings
• Fine-tuned Informatica maps for performance optimization
• Extracted data from Mainframe Cobol/VSAM copy books using Normalizer, transformed and loaded data to Mainframe using FTP Scripts
• Generated report with previous unclean data and current integrated data for Clients’ reference
• Involved in Unit testing and System testing
• Used Tortoise SVN as a configuration management tool

Environment: Informatica PowerCenter 8.1.1, Informatica Data Quality, SQL Client, Windows 2000, DB2, Mainframe VSAM/Cobol Files and UNIX.

Confidential

Senior ETL Programmer Lead

Responsibilities:

• Detailed analysis of System and developed Estimate
• Requirement analysis and Design the application
• Developed Informatica mappings, sessions and workflows based on user requirements
• Used Dynamic Look up and update strategy transformations in maps to update the LGM DB
• Involved in Unit and System testing
• Used OpenProj, an Open Source application that provides project scheduling and management functionality
• Served as Single point of contact for supporting Client and Lights - on team, until Warranty period of the project
• Used Tortoise SVN as a configuration management tool

Environment: Informatica PowerCenter 8.1.1, Oracle Client, Windows 2000 and UNIX.

Confidential

Project Lead

Responsibilities:

• As a Project Lead during warranty period
• Support the mainframe team in data fetching
• Post implementation Support

Environment: Informatica PowerCenter 7.1.3, Oracle, Mainframe VSAM/Cobol Files, Windows 2000.