SUMMARY

• Over 9 years of IT experience in Analysis, Design, Development and Maintenance for Data warehouse and related applications using ETL and BI tools. Experience working in Banking, Financials, Healthcare, Pharmaceuticals and Insurance sectors.
• Expert level experience in implementing advanced ETL methodologies for corporate wide - ETL solution using Informatica Power Center 9.6.1/9.5.1 /9.1/8. 6/7. x/6.x
• Hands on Data modeling knowledge of Ralph Kimball’s Dimensional Data Modeling using Star Schema and Snow-Flake Schema.
• Hands on experience in user interaction to gather and analyze the project requirements.
• Strong expertise in design, development and integration of complex ETL processes.
• Hands on experience in Informatica Data Quality (IDQ) processes.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Solid experience in performance tuning of ETL Mappings involving ETL Sources, Targets, Transformations and at system level.
• Excellent analytical, problem solving, communication skills and a committed team player with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.5.1 /9.1/8. x/7.x/6.x, Informatica Power Mart 5.0, Informatica developer 9.6.1/9.5.1 , Informatica Power Exchange.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2 8.x, Teradata 14.0

Reporting Tools: Oracle BI Apps, OBIEE (10.x), Cognos

Data Modeling: Erwin 3.5/4.0, UML.

Data Modeling Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Life Cycle.

Programming Languages: SQL (DDL and DML), PL/SQL, C, Java

Operating Systems: UNIX, Linux, MS Windows 2000/NT/XP/VISTA/7.

Other Tools: TOAD, VISIO, SQL * PLUS, SQL * PLUS Loader

PROFESSIONAL EXPERIENCE

Confidential, Portland, ME

Sr. Informatica Developer

Responsibilities:

• Contributed in creation of the BRD/functional and technical design document after having multiple sessions with business user’s team.
• Responsible for designing the ETL framework for the Proof of concepts from different data sources to Teradata 14.0 and DB2 8.x database/sandbox.
• Assisted Data analysts in creating logical data objects (LDO’s) to be used in mapping specification in Informatica Analyst for source to target mappings.
• Worked with data analysts in building common business rules in Informatica developer pertaining to subject area for reusability across all the sources.
• Created Logical data object models in Informatica developer and trained the data analysts in creating the logical data object models in Informatica Analysts.
• Profiled the data using Informatica Developer and worked with analysts and business users with data quality issues.
• Loaded the target data and provided the logical objects for the analysts and users to preview the data for data quality purpose in Informatica Analyst (IA)
• Developed Change Data Capture (CDC) mappings using Informatica Power Exchange 9.6.1
• Loaded data into Teradata tables for I3 application based upon SCD Type 2 by doing full and delta loads for each feed.
• Worked in real time environment by creating CDC mappings and loaded the Topics (Queues) by using them as staging area and built secondary ETL process to read data from the Topics and Loaded the Teradata database for I3 application as per business needs.
• Wrote complex PLSQL scripts /functions/procedures/packages.
• Involved in Performance tuning of multiple Informatica jobs to improve performance. The factors involved were PDO (Push down optimization), bulk loading and also adding indexes on the staging tables.
• Actively participated in code reviews, mentored the developers and users in understating the tool and business logic.

Environment: Informatica Power Center 9.6.1/9.5.1 , Teradata14.0, DB2 8.x, SQL server 2008, MDM,Teradata SQL Assistant, Power Shell scripting, Cognos, QlikView, PL/SQL, Control -M, Informatica developer 9.6.1/9.5.1 , Informatica Analyst 9.6.1/9.5.1 (IA)

Confidential, Buffalo, NY

Sr. Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Interacted with business users, architects, business analysts in gathering requirements, prototyping on a timely manner.
• Created technical specs and mapping documents to outline data flow from sources to targets.
• Developed mappings to load data into staging tables and then into Dimensions and Facts.
• Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Implemented various error handling strategies.
• Wrote Pl/sql stored procedures to move the data from staging tables to base tables in warehouse.
• Utilized IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Developed rules to validate the data using (IA) before sending it to Federal Reserve for CCAR (Comprehensive Capital Analysis and Review) regulations. Rules, Profiles and Scorecards
• Responsible for writing Power shell scripts to automate the jobs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Actively participated in code reviews with peers before the code gets moved to QA.
• Involved in unit testing of the mappings and mentoring the developers and the QA’s in understanding the business logic.
• Co-ordinate with different teams in problem identification and resolution - QA, DBA and Business Analysts
• Migrated repository objects, services and scripts from development to staging environment. Actively involved in troubleshooting and solving migration issues.

Environment: Informatica Power Center 8.6/9.1, SQL server 2008, Oracle 11g, TOAD 9.x, Batch scripting, PowerShell scripting, OBIEE 11g, PL/SQL, Windows-XP, Opcon, IDQ 8.6.1, Informatica Analyst 9.1(IA)

Confidential, Boston, MA

Sr. Informatica Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for data warehouse and prepared the functional and technical designs, test cases, and user guides.
• Helped in developing Star Schema by following referential integrities among Facts and Dimensions.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
• Mentored Informatica developers on project for development, implementation, performance tuning of mappings and code reviews.
• Developed Informatica jobs and automated data loads using UNIX shell scripts.
• Involved in debugging mappings, recovering sessions and developing error-handling methods.

Environment: Informatica Power Center 8.6, DB2, Oracle 10g, TOAD 9.x, Oracle Financials, Shell Scripting, Oracle SQL *Loader, OBIEE, PL/SQL, Sun Solaris UNIX, Windows-XP, Visio, IDQ, Autosys.

Confidential, Fairfield, CT

Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications.
• Assisted Data Architects using Erwin for Logical and Physical database modeling of the warehouse.
• Extracted data from source system and loaded the dimensions and fact tables.
• Co-ordinated with off shore team and provided training in understanding business requirements and performed code reviews.
• Created stored procedures to extract data from various data sources like Oracle and SAP.

Environment: Informatica Power Center 8.1.1, Oracle 10g, SQL Server 2005, Windows XP, UNIX, SQL Developer, SQL, PL/SQL, Oracle SQL *Loader, QTP, Erwin 4.0, Trillium, OBIEE.

Confidential, Dublin, OH

Informatica Developer

Responsibilities:

• Created ETL process to generate Claim extract XML files for vendors from Base tables using Informatica.
• Designed mapping templates and developed Several Informatica Mappings to populate the data into dimensions and fact tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Involved in creating/modifying reports using Business Objects and Web Intelligence.
• Developed PL/SQL scripts to move historical data from ERP sources to BOW.

Environment: Informatica Power Center 7.1.2, Oracle 10g, Business Objects XI R2, Web Intelligence 2.5, PL/SQL, TOAD, SQL*Plus, Erwin, Windows, UNIX HP UX, Control M.

Confidential, Malvern, PA

Informatica Developer

Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Designed the process and developed a number of Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
• Used UNIX shell scripting for Scheduling Informatica Workflows.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Wrote complex SQL queries and stored procedures in PL/SQL.

Environment: Informatica Power Center 7.1, MS SQL Server 2005, SSIS, Oracle 9i, ERWIN 4.0, WINDOWS XP, DB2, PL/SQL, SQL, Cognos.

Confidential, Seattle, WA

ETL Informatica Developer

Responsibilities:

• Developed ETL mappings by making use of various transformations in Informatica.
• Developed mappings to implement type 2 slowly changing dimensions
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions
• Used various Informatica Error handling technique to debug failed session.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.

Environment: Power Center 6.2, Oracle9i, SQL Server 2000, SQL,PL/SQL, shell scripts, Mainframe DB2, MS Visio, Toad 8.0, Windows 2000,XML,UNIX.