SUMMARY:

• 9.3 years of work experience as a Senior Informatica ETL Developer in the development of Data warehousing/ Business Intelligence systems
• Good understanding with all stages of Software Development Life Cycle (SDLC) Cycle including Requirement analysis, Application Design, Development, Testing, Implementation and Maintenance
• 9 years of ETL development experience using Informatica in Oracle DB and Unix environments
• 6+ years of Oracle Database experience with expertise in developing Oracle PL/SQL Packages, Stored Procedures and Functions
• Good hands on experience in Unix shell scripting
• Responsible for developing Informatica workflows to collect data from multiple data sources (Flat Files, Relational sources, VSAM, XML, etc.,) into Enterprise Data Warehouse(EDW) and Operational Data Store(ODS) based on the Mapping Specifications
• Strong development experience using Informatica v10.1 and v9.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager and Workflow Monitor
• Effectively involved with development of mappings using Informatica PowerExchange Datamaps as sources
• Good Experience in Oracle Performance Tuning and optimization of SQL queries
• Actively involved in Informatica Folders migration from v9.1 to v10.1
• Experience in job scheduling, monitoring and debugging of issues
• Strong experience in supporting System testing, User Acceptance testing and review test results.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting skills
• Self-starter with strong personal drive and ability to co-ordinate with multiple team environments
• Excellent data analytical skills and problem solving skills
• Strong customer relationship skills, interpersonal and communication skills
• Ability to prioritize competing demands, manage multiple concurrent tasks and able to Experience in supporting Offshore-Onshore delivery process
• Experience with managing team as a lead and guided from a technical perspective to ensure delivery of the module
• Ability to work in diverse environments and self-motivated to contribute towards team/company goals, in addition to individual commitment towards excellence

TECHNICAL SKILLS:

Operating Systems: Windows 7/98/2000/XP/Vista, Linux Server 6.6 x64

Programming Languages: C, HTML, SQL, PL/SQL

Databases: Oracle 11g, Oracle 10 g, Microsoft SQL Server 2008, Teradata 13

Tools: /Software/Browser: Informatica PowerCenter 10.1/9.1/8.6.1/8.1.1 , Toad 11.6.1.6

Other Utilities: HP ALM, HPSM, Mercury QC 9.0, WINSCP, Putty, SmartFTP, Telnet

EMPLOYMENT HISTORY:

Confidential, Denver, Colorado

Technology: Informatica PowerCenter v10.1 and v9.1, Informatica PowerExchange Navigator v10.1,Oracle PL/SQL, Unix

Tools: TOAD 11.6.1.6, SQL*Plus, SQL Developer, WinSCP, Putty, CA WA Workstation (ESP), CA SCM Workbench, U-Deploy

Responsibilities:

• Responsible for analysis, design, develop and implement highly efficient and highly scalable ETL process
• Strong technical knowledge in ETL Design, Development and Database (Oracle) utilities
• Responsible for data analysis and development of mappings to extract the data from flat files and other RDBMS databases into Data warehouse.
• Worked extensively in reading the data from Information Management System (IMS) database to Operational Data Store (ODS) via Informatica PowerExchange Change Data Capture (CDC) process.
• Effectively coordinated for IMS Datamap changes
• Designed Application Design specification document for the project and successfully presented to Business partners in Design summit
• Actively involved in Informatica Folders migration from v9.1 to v10.1
• Collaborated with source systems with migration activities of file transmission to new linux servers

Confidential

Technology: Informatica PowerCenter 9.1, Oracle PL/SQL, Unix

Tools: TOAD 11.6.1.6, SQL*Plus, SQL Developer, WinSCP, Putty, CA WA Workstation (ESP), CA SCM Workbench, U-Deploy

Responsibilities:

• Strong working experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Informatica PowerCenter
• Strong ETL Development experience with good understanding of data model from a business standpoint
• Worked closely with System analysts and Architects to understand the requirements and to build the technical specifications
• Participated in design sessions with ETL developers, report developers, DBAs and Business Analysts
• Extensive experience of mapping development from wide range of sources such as Flat Files, VSAM files, XML sources, Relational sources and MQ Payload
• Strong technical knowledge in the area of mapping variables, workflow variables
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements
• Supported actively in CDC to Golden Gate Project Migration
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects via Udeploy tool
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting
• Performed unit testing at various levels of the ETL and actively involved in team code reviews
• Develop an ETL mapping as per Business requirement, developing SQL queries to perform audit between source, staging and Target data
• Responsible for identifying the error validations and generating the count statistics. Created reusable Mapplet, transformations, XSD's and scripts to be used across interfaces
• Developed reusable mapplets and utilized across 700+ mappings and thus effectively delivered the code and received appreciation from the business
• Knowledge transfer to client employees and create documentation as necessary to reflect any additions or changes to existing systems
• Coordinate and develop process automation/job scheduling, perform testing and defect analysis

Confidential

Technology: Informatica PowerCenter 9.1, Oracle PL/SQL, Unix

Tools: TOAD 11.6.1.6, SQL*Plus, SQL Developer, WinSCP, Putty, CA WA Workstation (ESP), CA SCM Workbench, U-Deploy

Responsibilities:

• Analyzed and Re-engineered the workflow and laid out the steps for the data extraction and business logic implementation
• Worked on the Application Design Specifications documentation for the project
• Designed Process Flow diagrams and DDL changes
• Developed mappings in Informatica to load the data from various sources and involved in the performance tuning of the existing approaches
• Designed new approach for the Audit Process as a value add to the project
• Involved actively in requirement analysis and design sessions of various phases of the project
• Coordinated with Confidential SME’s to understand the new functional requirements of the project
• Worked on the Mapping Documents and Technical Design Specifications for Dental and Medical EFT/ERA Modules based on the requirements
• Actively involved in design and code reviews to ensure that the coding is strictly in accordance with Business standards
• Developed functional specifications, use cases and designed workflow sequence diagrams.
• Sound Knowledge in Facets Provider Database
• Co-ordinated with Informatica Admins to create relational connections strings and project specific folders in both Informatica and Unix Servers
• Contributed to the development of ETL mappings using Informatica Power Center
• Extensively supported for the System testing, Integration and UAT Testing
• Extensively worked on defect triaging and RCA for Production and Non-Production issues
• Co-ordinated with the source systems (CPF & iProvider) team to ensure the source files are received in appropriate format and in timely manner
• Significantly contributed in Performance Volume Stress (PVS) Testing
• Actively worked on scheduling, maintaining and deploying ETL jobs
• Primarily responsible for all the Code Deployments activities via UDeploy Process
• Effectively worked on Scheduling tool (ESP) and involved in Development, Scheduling and Monitoring of ETL Workflows and XPF Batch jobs
• Extensively worked on developing ESP Runbooks and XPF Batch jobs and worked on various troubleshooting of the batch load failures

Confidential

Technology: Informatica PowerCenter 9.1, Oracle 11g, PL/SQL, Unix

Tools: TOAD 11.0.0.116 , SQL*Plus, SQL Developer, WinScp, Putty, HP ALM

Responsibilities:

• Strong working experience in Development, Implementation and Testing of Data Warehousing using ETL Informatica
• Analyzed the requirement documents and laid out the steps for the data extraction, business logic implementation & loading into targets
• Performed extraction, transformation and loading of data from different sources like Message Queues, XML as a BLOB column from oracle table sources in accordance with requirements
• Worked on UNIX shell scripts and stored procedures to perform tasks like Purge process, scheduling workflows, error handling and email notifications
• Strong Experience in creating XML Parser Transformation in Complex Mappings to extract the XML file from BLOB column from oracle table source and convert it to CLOB to load into multiple targets
• Effectively and extensively used complex transformations like XML Parser, Transactional Control, Joiner, Aggregator, Union, Sorter, Connected and Unconnected lookups, Filter, Stored Procedure, Update Strategy, and Router
• Worked independently with guidelines, responsible for initiating, planning, executing, controlling application
• Excellent technical, logical, code debugging and problem solving capabilities and easy adaptability to new technologies
• Worked on creating ETL design and Run Book support document for the project
• Involved in system testing support and User Acceptance testing support

Confidential

Technology: Informatica PowerCenter 9.1, Oracle 11g, PL/SQL, Unix

Tools: TOAD 11.6, SQL*Plus, SQL Developer, Putty, HP Quality Center

Responsibilities:

• Understanding existing business model and customer requirements
• Analyzing the functional requirements & Business Specification Documents
• Extensively worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier
• Involved in preparing component list for the migration

Confidential

Technology: Informatica PowerCenter 9.1, Oracle 11g, PL/SQL, Unix

Tools: TOAD 11.6, SQL*Plus, SQL Developer, Putty, HP Quality Center

Responsibilities:

• Involved in requirement analysis and understanding of requirements identify the flow of information and analyzing the existing systems
• Analyzed and Reviewed the Business Specification Documents
• Preparations of Technical Design Documents from the Functional Design Documents
• Analyze the new change request, estimate the new change and design the same
• Performed Unit and Integration testing and wrote test cases
• Worked extensively in defect remediation and supported the QA testing
• Played a crucial team lead role & mentored Junior Informatica developers and motivated performance of the team through reviews, coaching and development

Confidential

Technology: Informatica PowerCenter 9.1, Oracle PL/SQL, Unix

Tools: TOAD, SQL*Plus, SQL Developer, Putty

Responsibilities:

• Worked primarily Oracle PL/SQL Developer for the project
• As a team lead, participated in requirements gathering and prepared functional requirement understanding document
• Designed Mappings Specifications and Process Flow diagrams for new requirements
• Motivated performance of the team through reviews, coaching and development

Confidential

Technology: Informatica PowerCenter 8.6.1, Oracle PL/SQL, Unix

Tools: SQL*Plus, SQL Developer, Putty

Responsibilities:

• Worked on development and testing environment and migrated the workflows to the production environment
• Involved in writing UNIX shell scripts, PL/SQL procedures, Pre-session and Post- Session Scripts
• Worked in Performance and Tuning techniques used to improve the load
• Involved in the Testing phase of the project and worked primarily on defect fixing, troubleshooting the failure cases and redeploy the code
• Extensively used Quality Center to track/update the status of logged defects in testing phase
• Prepared the Implementation plan for the code migration to QA/Production
• Scheduled the jobs through ctrl-m for daily loads
• Handled issues and provided additional support by monitoring the daily processes running in Production
• Provided Warranty Support for the project

Confidential

Technology: Informatica PowerCenter 8.6.1, Teradata

Tools: Putty, WinSCP

Responsibilities:

• Worked primarily as a BI-DEVELOPER for this development project
• Variance analysis of Key metrics between source system and EDW
• Identifying the root cause of the variance and provide remediation solutions.
• Developed Mappings using Informatica and supported System testing

Confidential

Technology: Informatica PowerCenter 8.6.1, Oracle PL/SQL, Unix

Tools: TOAD 7.2, SQL*Plus, SQL Developer, Putty

Responsibilities:

• Working primarily as a ETL developer and involved in Waterfall project methodology
• As a team lead, participated in requirements gathering and analysis and convey the same accurately to the team
• Worked on functional requirement analysis documents
• Motivated performance of the team through reviews, coaching and development
• Designed Mappings Specifications for the new requirements in the project
• Designed Process Flow diagrams for the new requirements in the project
• Participated and contributed to design reviews with the customer
• Mentored team from a technical perspective to ensure delivery of the module
• Involved in multiple discussions and ensured customer satisfaction

Confidential

Technology: Informatica PowerCenter 8.1.1, Oracle 10g, PL/SQL, Unix

Tools: TOAD 7.2, SQL*Plus, SQL Developer, Putty

Responsibilities:

• Worked in Informatica and Oracle enhancements for the project
• Involved working in the Oracle 10g database, ETL Informatica and UNIX scripting
• Developed new mappings for the enhancements
• Done Oracle code changes and UNIX script changes for enhancements
• Done coding, debugging, unit testing and tuning of PL/SQL codes and supported UAT

Confidential

Technology: Informatica PowerCenter 8.6.1, Microsoft SQL Server 2008, DB2

Tools: Putty, WinSCP, Telnet

Responsibilities:

• Worked as an Informatica developer and developed mappings to Extract, Transform and Load data for both incremental and historical data load
• Responsible for production load monitoring and resolved priority issues within SLA
• Coordination & analysis of data quality issue
• Provided complete knowledge transfer about application to the customer maintenance team and explained in detail about the complete functionality of the development activities, production incremental and historical load monitoring
• Involved in report comparison between the existing DB2 application and new ISDM environment and solved the data mismatch between two environments
• Received client appreciation for the successful delivery of knowledge transfer to customer maintenance team