PROFESSIONAL SUMMARY:

• Around 8 years of experience in all the phases of Data Warehouse Life Cycle involving design, development and analysis and testing in various areas of Data Warehousing.
• 8 Plus years of IT industry experience in working with various domains like Insurance, Finance,pharmaceutical, Retail and Banking.
• Experience in Development and Design of ETL methodologies using Informatica Power Center 8.x/7.x/6.x/5.x with real time exposure to business.
• Experience working on various Relational Database systems (Oracle, Sql Server, DB2) and Flatfiles.
• Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Cursors, Stored Procedures, Functions and Triggers.
• Experience working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Hands-on experience with Informatica Power Center - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extensively worked on Informatica Designer components – Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Good experience with Informatica Performance Tuning.
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, slowly changing Dimensions using Erwin and Microsoft Visio.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Designed the mapping with a Slowly Changing Dimension Type2 and Type1 to keep track of historical data and current data.
• Designed, Developed and involved in OLTP applications, ROLTP, MOLAP, ROLAP and HOLAP implementations.
• Good experience with ETL scheduling tools.
• Preparation of Technical documents including mapping documents, test cases and test scripts along with design documents for CDC (change data capture) strategy so that any developer can start designing the mappings based on the documentation created.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server.

TECHNICAL SKILLS:

• Data Warehousing Tools: Informatica 8.6.1/8.1.1/7.1/6.1
• Dimensional Data Modeling Tools : Erwin 4.1/4.0
• Languages: Java, SQL, PL/SQL PHP, Xml, Shell Scripting
• Operating Systems: UNIX (IBM AIX/HP-UX/Sun Solaris), Win XP/ NT/ Vista/7
• Database: Oracle 9i/10g, My SQL, SQL Server 2005
• Job Scheduling: CA Autosys, BMC Control M, Informatica Scheduler
• DB Utilities: Putty, TOAD, SQL*Loader, SQL assistant.

EDUCATION:

Bachelors in Computer Science

Related Coursework: Advanced Databases, Operating System, Database Management System, Data Structures, Distributed System, Internet and Higher Layer Protocol, Data Mining and Project Management.

PROFESSIONAL EXPERIENCE:
Client: Confidential,NYC
Project: Enterprise Data Warehouse (EDW)
Duration: June 2009- Present
Title: Sr. Informatica Developer

Responsibilities:

• Extensively worked on Power connect/Power Exchange 8.6.1 for SAP R3.
• Worked with Business Analyst in gathering the requirements and prepared Source to Target Mappings which helpful in designing and developing Enterprise Information Store.
• Developed Mappings which loads the data in to Teradata tables with SAP definitions as Sources.
• Installed ABAP programs on SAP server using Infa Power connect/Power Exchange 8.6.1.
• Worked with different sources like SAP R3, Teradata, .csv files, oracle, SQL Server.
• Developed Error handling mechanism and delta logic in different mappings.
• Extensively worked on Teradata tables to decrease the skew factor which increases the performance.
• Extensively used Teradata Parallel Transformer (TPT), a new feature of Power center 8.6.1
• Worked on Push down Optimization (PDO), which improves the mapping performance.
• Extensively worked on tuning the indexes on Teradata tables.
• Developed different mappings by using transformations like expression, router, normalizer, lookup, aggregator, filter.
• Prepared mapping specification documents for EDW project.
• Developed technical design documents of EDW.
• Scheduled different workflows using Informatica scheduler.
• Developed workflows using different tasks Decision, Email, Command, Event wait.
• Designed and Deployed extract-transform-load (ETL) processes using Informatica and Teradata SQL.
• Worked along with the DBA to resolve performance and tuning issues.

Environment: Informatica Power Center 8.1/8.6.1, Power Exchange 8.1/8.6.1, SAP R3, Power Connect/ Power Exchange, SQL Server 2005,Oracle 10g, Teradata, SQL Assistant, Erwin, Enterprise Architect, ER studio, TPT

Client: Confidential,NJ
Project: Patient Accounting - Enterprise Data Warehouse (EDW)
Title: Sr.Informatica Developer
Duration: April 2007-June 2009

Description:
Enterprise Data Warehouse (EDW) houses the homogenized data from all of BJC entities using one logical data model to support analytical processing. This initiative will provide caregivers and managers real-time access to relevant, fact-based information on different Scorecards that allows them to make informed decisions to provide best-in-class care in a safe and cost effective environment. As part of Patient Accounting (PA), data feeds from different source systems like patient encounters, demographics, charges, payments, plans, diagnosis, and physician’s information are cleansed and loaded to EDW.

Responsibilities:

• Involved in analysis of three different source systems and prepared technical specifications for the ETL
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW
• Involved in enhancing the data model for new additions of dimension and reference tables
• Responsible for data migration in order to achieve an automated migration.
• Involved in all stages of data migration.
• Extracted data from various heterogeneous sources like Sybase, Flat Files and COBOL (VSAM) using Informatica
• Power center and loaded data in target database DB2.
• Used Normalizer Transformation for Cobol (VSAM) sources.
• Collaborated with other team members to create technical specifications for ETL/ELT processes based on functional specifications and Developed ETL/ELTs based on the technical specifications.
• Extensively worked with Power Connect to import sources from external systems like ERP.
• Created SSIS Packages to migrate slowly changing dimensions.
• Worked with the Debugger Wizard in debugging the mappings.
• Used Workflow Manager for creating workflows, Worklets, email and command tasks
• Involved in tuning Informatica Mappings and Sessions by implementing parallelism, partitioning and caching
• Tivoli workflow scheduler (TWS) was used as part of scheduling and performed Unit Testing and Integration Testing on the mappings.

Environment: Informatica Power Center 7.1.1, Teradata, SSIS, Erwin, XML, Oracle, SQL, BTEQ, Power Connect, PL/SQL, SAP, UNIX, C#, SQL Server 2005, Windows XP, TOAD

Client: Confidential,MA
Title: Informatica Developer
Duraton: Feb 2005- Mar 2007

Description:
Worked as a member of the OMS and Customer development organization team and was responsible for performing the following activities as part of the data migration work-stream for the implementation phase of the project and also responsible for the design, implementation, and maintenance of ETL process development using Informatica. The development included Informatica mappings, sessions, workflows, PL/SQL and supporting scripts. Duties also included data modeling and design. In general, the role was responsible for the design, development, coding, testing, debugging and documentation of applications to satisfy the requirements of one or more user areas.

Responsibilities:

• Defined technical approach/architecture for the transformation and load steps.
• Participated/facilitated design sessions to define the source-to-target data mappings.
• Assisted in setup of technical environment for development for the data migration effort.
• Developed unit data migration code (i.e. scripts, mappings, procedures, etc.)
• Monitored the performance tuning of data migration transformation and load processes.
• Participated in data reconciliation activities with client to assess and validate data migration results.
• Provided implementation and post-production support for live data migration to production environment.
• Clear understanding of source systems thoroughly by going through the functional specification documents and one-to-one interaction with the business team.
• Developed data mapping documents that contain transformation rules to implement the business logic.
• Tested the data and data integrity among various sources and targets. Used debugger by making use of breakpoints to monitor data movement, identified and fixed the bugs.
• Coordinating work between the offshore and onsite team to meet the deliverables.
• Development of PL/SQL and database support.

Client: Confidential,India
Title: Informatica Developer
Duration: Jan 2003-Dec 2004

Responsibilities:

• Worked on various data warehousing implementations such as Star Schema and Slowly Changing dimensions to reference historic data.
• Performed business analysis and developed data flow diagrams and mapping specifications.
• Interacted with the technical architects for design of ETL processes and their schedules Performed analysis for the CDC (change data capture).
• Designed and created mappings for the source to target by making sure the process executes faster or equal to the SLA agreed upon.
• Gathered and translated business requirements into technical models and processes.
• Responsible for monitoring the Production Status and ensure the ETL process works as expected.
• Handling customer communication around production issues.
• Research and resolve production issues with ETL workflows.
• Perform root cause analysis and identify and implement corrective and preventive measures.
• Deploying/Migrating the code to different test environments.
• Created Normal, Expedited and Emergency change request to meet the Business demand.
• Preparation and submission of Weekly/Monthly status reports to Customer.

Environment: Power Center 8.6 (ETL), Oracle 10g, ERWIN 4.0, Cognos, BI, SQL, PL/SQL, Windows XP