PROFESSIONAL SUMMARY

• Over 8+ years of dynamic experience in Information Technology involving analysis, design and integration of Datawarehouses using ETL, Data Warehousing tools and Web applications.
• Extensive experience in analysis, design, development, testing and maintenance of ETL using Informatica PowerCenter 8.x/9.x.
• Expertise in Informatica PowerCenter Designer, Mappings, Mapplets, Transformations, Worklets, Workflows, Workflow Manager, Workflow Monitor and Repository Manager
• Good Knowledge on Physical modeling, logical modeling, Relational modeling, Dimensional modeling (Star Schema, Snow Flake Schema)
• Strong working experience with Data Extraction, Transformation, and Loading (ETL) from disparate sources having Multiple Relational Databases like Oracle 9i/10g/11g, MS SQL Server 2005, DB2 UDB, Teradata and worked on integrating data from flat files, COBOL VSAM into a common reporting and analytical Data Model using Informatica.
• Expertise programming skills in developing Stored Procedures, Views, Sequence, Triggers and Cursors using PL/SQL in Oracle and T - SQL in SQL Server.
• Utilized Teradata Fast Load and Multi Load utility in loading flat files/tables into Teradata through Informatica external loading.
• Comfortable with working with UNIX shell commands.
• Tuning techniques of Informatica sources, targets, mappings, sessions and Oracle PL/SQL, SQL Server T-SQL objects.
• In Depth knowledge in Data warehousing concepts with emphasis on ETL Life Cycle Development (SDLC) including Requirement analysis, Design, Development, Optimization, Testing and Support.
• Self motivated, excellent problem solving, good team player and an independent worker
• Experience in Banking and Finance, Manufacturing, and Airlines industry business domains.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Proactive attitude with excellent analytical, communication and inter-personnel skills and open to learn new technologies.
• Currently working for Confidential as a Sr. ETL Analyst for a language migration project.

TECHNICAL SKILLS

ETL TOOLS: Informatica PowerCenter 7.x/8.x/9.x

DATABASES: Oracle 9i/10g/11g, SQL Server 2005, DB2 UDB, Teradata 12.0

LANGUAGES: SQL, PL/SQL, T-SQL

DB TOOLS: SQL Server Management Studio, SQL Plus, Teradata Utilities - BTEQ scripts, Multi Load, Fast Load

OPERATING SYSTEMS: UNIX (Solaris, HP-UX), Windows XP/2000/NT,MS-DOS

OTHER TOOLS: MS Visio, Ultra edit,Putty, SVN, Autosys, Informatica Work Flow Scheduler, Control-M

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

ETL Lead

Responsibilities:

• Modeling and populating the business rules using Informatica mappings into the Repository.
• Experience in analyzing the existing mainframe legacy system, understanding the business functionality
• Understand the business needs and implement the same into a functional database design.
• Used Use cases for documenting the functional specifications. Initiated Use cases that provided framework for potential use.
• Developed Informatica workflows according to business requirements.
• Utilized most of Informatica transformations and utilities in performing the workflow development.
• Coordinated with offshore developers for prioritizing and translating requirements, defects and enhancements into ETL code.
• Worked on loading data from different sources like Oracle, DB2, VSAM files (created copy book layouts for the source files), ASCII delimited flat files to Oracle targets and flat files.
• Performed Tuning of the developed Informatica Mappings and Sessions by identifying and eliminating the bottlenecks for improving the performance.
• Experience in creating ETL deployment groups and ETL Packages for promoting up to higher environments.
• Performed and documented the unit testing for validation of the mappings against the mapping specifications documents.
• Created tasks such as command task, email task, Control task, and Timer tasks in the workflow manager.
• Developed, implemented and enforced ETL best practices standards.
• Involved in code review and design review processes.
• Designed and developed process to handle high volumes of data and large volumes of data loading in a given load window

Environment Informatica PowerCenter 9.5.1, Oracle 11g,Unix

Confidential

ETL Developer

Responsibilities:

• Data load into BI EDW and staging tables using Informatica workflows.
• Implemented business logics while creating mappings.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Implementing enhancements and change requests in the existing mappings/workflows raised by the business users.
• Monitoring workflows scheduled and supporting the data load jobs for any failure.
• Used Autosys as scheduling tool to control and monitor the execution of jobs.
• Created reusable transformations and mapplets to implement the business logic for loading to the target database.
• Delivered code as per quality and coding standards, prepared unit testing cases.
• Created several Design patterns, Standards documents, ETL strategies.
• Extensively used Informatica debugger to validate Mappings and to gain troubleshooting Information about data and error conditions.
• Modified the mappings according to the new changes and implemented the persistent cache in mappings for better performance.
• Worked on Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and Server Manager to create and monitor sessions and batches.

Environment ;Informatica PowerCenter 9.0.1, Teradata SQL Developer., Unix

Confidential

ETL Developer

Responsibilities:

• Data load in BI data-warehouse using Informatica workflows.
• Implemented business logics while creating mappings.
• Implementing enhancements and change requests in the existing mappings/workflows raised by the business users.
• Creation of Dimension and Facts mappings in Informatica.
• Monitoring workflows scheduled and supporting the data load jobs for any failure.
• Conversion of Cognos DSS builds and job-streams into Informatica.
• Support given by solving remedy tickets raised for any job failure or data issue.
• Worked on Type1 and Type2 Slowly Changing Dimensions.
• Involved in the Data Analysis for source and target systems and good understanding of Data Warehousing concepts, Staging Tables, Dimensions, Facts and Star, Snowflake Schemas.
• Created test cases for Unit testing and System testing.
• Also tested the Databases using PLSQL and analyzed several mapping scenarios.

Environment Informatica PowerCenter v8.6,,MS-VSS, PL-SQL developer to connect Oracle 10g.

Confidential - CRM Finance, Netherlands

ETL Developer

Responsibilities:

• Used Informatica to load data in staging area (ODS) and in Siebel EIM tables. The application was Siebel CRM Finance and it used to get all the customer data from flat files generated by different sources.
• Ensuring the Daily and weekly data load in Siebel EIM using Informatica workflows.
• Sending data from text files to different Siebel DB2 databases.
• Collecting change requests from the business users and developing Impact analysis and Effort Estimation documents.
• ODS maintenance.
• Used Informatica while loading data in Operational Data Store from flat files, determining the delta and loading data from ODS to EIM tables.
• Implemented business logics while doing the load in mappings and enriched and transformed the data.
• Implemented data enrichment while loading data in the staging area by doing lookups.
• Extensively performed unit testing and system testing.

Environment Informatica PowerCenter v8.6, Siebel 8.5, DB2 UDB, Windows server 2003, WinSQL

Confidential

Application Developer and Onsite coordinator

Responsibilities:

• Creating and monitoring batches and their logs in SQL Server.
• Requirement gathering and Business Analysis.
• Managing databases of 27 Concord establishments and managing the logs of jobs running for each database.
• Collecting change request from the business users and developing Impact analysis and Effort Estimation documents.
• Testing & Deployment of the change requests.
• Created the architecture to migrate the databases from existing SQL Server 7.0 to SQL Server 2005.
• Creating different users and user profiles for data accessing and setting authorization for them on different modules of the system.
• Responsible for writing stored procedure re-designing and development.
• Providing business users with reports and data extracted from the existing databases.
• Creating mail operators, database maintenance plans, backups, replication, etc.

Confidential

Developer

Responsibilities:

• Coding in VB .NET
• Screen Designing.
• Writing Stored Procedures.
• Making graphs using third party DLL and plotting different kinds of graphs for different screens.
• Responsible for development, unit test of each program, debugging program and handled change requests.
• Reviewing code and facilitating Code Walk through with the offshore deliverables

Confidential

Developer

Responsibilities:

• Making activity diagrams & use cases while understanding business requirements
• Documenting business requirements and creating functional specification documents.
• Writing design documents;
• Coding in VB.NET and Interface designing;
• Writing Stored Procedures.
• Unit testing and Review of the programs.