SUMMARY

• Over 7+ years of work experience in developing large - scale Data warehouse projects, including Data Profiling, Data Modeling, Data Migration, Database Design and Development, Integration, Testing, SDLC, Project Management and Production Support.
• Core competency in Business Requirement Analysis, Modeling, Design, Development, Testing, Supporting and Documentation in the field of Data Warehouse.
• An expert in the ETL tool Informatica which includes components like Power Center, Power Exchange, Power Connect, Designer, Workflow Manager, Workflow Monitor.
• Worked on Star Schema, Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Experience in working with Oracle, SQL Server and DB2 databases.
• Experience in integration of data sources like Oracle 11G, IBM DB2, MS SQL Server, Flat Files.
• Experience in using Informatica Utilities like Pushdown optimization, Partition and implemented slowly changing dimensions Type1, Type2 methodology for accessing the full history of accounts and transaction information.
• Experience in testing mappings in Informatica Power center and reports in Cognos.
• Experience in SQL, PL/SQL, TOAD, Crystal reports and Unix Shell Scripting and working knowledge of various platforms like Windows NT/XP/2000/98, Sun Solaris, HP-UX, and Unix-AIX & knowledge of SQL Server Integration services (SSIS).
• Good understanding of Software Development Life Cycle (SDLC), Data warehousing concepts and RDBMS concepts.
• Experience inAdministration activitieslike Creating and Managing Repositories, Users, User Groups, Folders, Working with administrator functions of Repository Manager.
• Strong Understanding of Data Warehouse concepts, ETL, OLAP, OLTP, Star Schema, Snowflake, AS-IS TO-BE models, KPI's, BPM, FACT & Dimensions tables, Conceptual, Physical & Logical Data Modeling. Providing ongoingtroubleshootandsupport for maintenanceandenhancingthe applications to meet the changing business requirements through a Change Management process.
• Experienced in Installation, Configuration, of Informatica PowerCenter on Client/Server environment. Experience in Debugging/Optimizing/Tuning flag 836 Informatica 9.x, 8.x, 7.x mappings for better Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Performed system Analysis and QA testing and involved in Production Support.
• Worked on PLSQL, Stored Procedures, Packages, Views, Synonyms, and Triggers.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.x (Power Center/Power Mart/Power Exchange) (Designer, Transformations, Workflow Manager, Workflow Monitor, Source Analyzer, Repository Manager, Mapping Designer, Mapplets) Power Analyzer, OLAP, OLTP.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Databases: Oracle10g/9i, MS SQL Server, DB2, MS Access, SQL, PL/SQL, SQL*Plus.

Reporting Tool: Cognos, Crystal Reports

Operating System: UNIX, Windows.

Programming: SQL, PL/SQL, SQL*Plus, HTML, C, C++, Java

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Sr.Informatica Developer

Responsibilities:

• Extracting and transforming data from Flat Files, SQL Server and then loading into database using informatica in MPP environment.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Widely used the Informatica Power Center Client Tools like Designer, Workflow Manager, and Workflow Monitor & Repository Manager.
• Extensively used Major transformations using Power Center Designer like Source Qualifier, Lookup, Expression, Aggregator, Update Strategy, Sequence Generator, etc…
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows.
• Gather requirements from business users to build new Data Warehouse applications
• Coordinate multiple architects responsible for development, integration, administration, and evolution of the data warehouse
• Develop standards and processes to insure best practices in development and operations
• Communicate physical database designs to database administrator
• Work with business requirements analyst to identify and understand source systems
• Prepare design document for the data flow from Offer, EB, CTO, Platform, OLM and cross channel
• Map source system data to data warehouse models
• Define metadata associated with ETL processes
• Adapt ETL processes to accommodate change in source systems and new business user requirements
• Work with Project Manager to identify tasks and timelines for projects.
• Create documentation/release notes for each release.
• Ensure quality deliverables through unit testing, regression testing and other quality control processes.

Environment: Informatica Power Center 9.x, Oracle, Control M, SQL Server, PL/SQL, Flat files, UNIX shell scripting, Windows, Toad

Confidential, Los Angeles CA

Sr.ETL Developer

Responsibilities:

• Worked with business and data analysts during requirements gathering to translate business requirements into technical specifications.
• Coordinated with Data modeling team and architect team to close the Mapping Spec and source to target mapping related queries.
• Understand and discuss the ETL requirements with the Business Unit and preparing the detail design documentation according to the standards.
• Prepare design document for the data flow from Extract team to the ADS or ODS tables.
• Responsible for developing Mappings for Membership and Medical Claims Subject Area.
• Responsible for developing Mappings to load aggregate tables for reporting ease.
• Responsible for unit testing and unit test cases preparation.
• Perform code Reviews and Internal Quality checks on mappings created by the team.
• Responsibility to create documentation/release notes for each release.

Environment: Informatica Power Center 8.x, Oracle 9i, SQL Loader, Confidential, PL/SQL

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.
• Created the data model structure and E-R modeling with all related entities and relationship with each entities based on the rules provided by the business manager.
• Coordinating with the client and gathering the user requirements to create mapping specifications.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations
• Worked on flat files as sources, targets and lookups
• Developed ETL and source to target mappings
• Created Several Informatica Mappings to populate the data into dimensions and fact tables
• Involved in the development of Informatica mappings and mapplets and also tuned them for optimum performance, Dependencies and Batch Design
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator
• Tuned the workflows and mappings
• Coordinated with OBIEE Team regarding the reporting data for Answers and BI Publisher reports and also for the Dashboard Designs.
• Used Informatica designer for designing mappings and mapplets to extract data from Oracle sources
• Used Various Transformations like Expression, Filter, Router, Joiner, Look Up, and Update strategy, Source Qualifier in many mappings
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping
• Executed Workflows and Sessions using Workflow Monitor
• Partitioned Sessions for concurrent loading of data into the target tables
• Executed the workflow using pmcmd command in UNIX
• Involved in identifying the bottlenecks and tuning (flag 836) to improve the Performance
• Developed shell scripts to automate the update process.

Environment: Informatica Power Center 8.1, Oracle 9i, PL/SQL, SQL, TOAD, SQL*LOADER, UNIX Shell Scripting.

Confidential, Monroe, Louisiana

Informatica Developer

Responsibilities:

• Prepared ETL process flow documents based on the present process flow and business functionalities.
• Created mappings with heterogeneous sources like flat tiles, oracle databases and created targets in oracle using Informatica Mapping Designer.
• Developed Mappings/Workflows/Scheduling ETL process.
• Frequently using import and export utility to migrate session from developers folder to subject folder.
• Developed Re-usable piece of code like Mapplet to use across various modules.
• Used Power Exchange interface to extract the legacy data.
• Developed UNIX Shell Scripts to schedule the Informatica jobs.
• Involved in design changes specific to releases.
• Designed mapping templates to specify high-level approach.
• Designed the mappings between sources (files and databases) to operational staging targets.
• Used Aggregator, sequence, look up, expression, filter, Joiner, Rank, Router, Sequence generator, Update Strategy transformations in populating the data process.
• Designed and developed the Informatica workflows/sessions to extract, transform and load the data into oracle Server.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.

Environment: Environment: Informatica Power Center 8.1.1/7.1.3 , Informatica Power exchange 8.1.1, Oracle 10g, SQL*Loader, Shell Script, Toad

Confidential

ETL Developer

Responsibilities:

• Designed the Data Warehouse (logical and physical models), designed and developed the dimensional data models (star schema), and supported the UAT and production phases.
• Created the Transformation Rules, Mapping Specifications and Workflow Specifications.
• Involved in doing the Impact Analysis of the changes done to the existing mappings and providing the estimations.
• Created the design specs for loading the data from OLTP to STG Schema, STG schema to DWH Schema.
• Migrated mappings from Development Repository to Test Repository and also from Test Repository to Production Repository.
• Extensively worked on tuning and improving the Performance of Mappings.
• Created utility programs for file manipulations, pre-session, post-session using shell scripts.
• Performed ETL testing, created Unit test plan and Integration test plan to test the mappings and created the test data.

Environment: Informatica Power Center 7.1.2, Oracle 9i, SQL, PL/SQL, SQL*Plus, TOAD, Windows 2000, UNIX.