SUMMARY

• 8+ years of IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems
• Expertise in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 9.6/9.5/9.1/8.6/8.5/8.1.1/7.1.3/7.1.1/7.0 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer).
• Experience in creation of reusable objects Mapplets & Transformations using Mapplet Designer and Transformation Developer
• Knowledge in designing and developing Data marts, Data warehouse using multi - dimensional Models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems. Experience in working with FACT & Dimensions tables.
• Oracle11g/10g/9i/8i and Teradata14/13for querying data using SQL, T-SQL, DB2 and BTEQ.
• Working knowledge on Business Objects XI R2maintained various reports using Business Objects
• Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Functions and Triggers.
• Extensively worked with Data Extraction, Transformation, and Loading (ETL) tools to extract data from various sources including Oracle, Teradata &Flat files.
• Experience in Performance tuning of Sources, Targets, Mappings and Sessions using Session partitioning & Push Down Optimization
• Worked with Oracle Stored Procedures and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL *Loader. Extensive Expertise with error handling and Batch processing
• Good understanding of Data Models (Dimensional & Transactional), Conceptual/Logical & Physical Data Models, DWH Concepts, ER diagrams, Data Flow Diagrams/Process Diagrams.
• Strong knowledge of Software Development Life Cycle (SDLC) with industry standard methodologies like Waterfall and Agile including Requirement analysis, Design, Development, Testing, Support and Implementation.
• Experience with TOAD, SQL Developer to test, modify and analyze data, create indexes, and compare data from different schemas.
• Experienced in UNIX Shell scripting and PL/SQL Functions & Stored Procedures.
• Experienced working with job schedulers Autosys, WLM.
• Experienced in working knowledge on Datastage, Business Intelligence experience usingCognos, and Working knowledge of Business Objects XI R2.
• Worked in 24/7 production support of ETL and BI applications for large Insurance & Banking data warehouses for monitoring, troubleshooting, resolving issues.
• Excellent soft skills and able to interact effectively with other members of Business Engineering, Quality Assurance, Users and other teams involved with the Software Development Life cycle.
• Developed plan processes and procedure in Mainframes for preparing the data and merchandize for an accurate conversion with more impact to operations.
• Fast Learner, good communication and presentation skills, ability to quickly adapt to the technical environment
• Experience in OBIEE/BI Apps (OBIA) with Sales Analytics, Financial Analytics, Supply Chain Analytics, Procure and Spend Analytics and HR Analytics.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.

PROFESSIONAL EXPERIENCE

Confidential, NEW JERSEY

Senior ETL Informatica Developer

Responsibilities:

• As an ETL SME involved in preparation of the ETL specification document by working closely with the business team
• Provided Guidance in Performance tuning of Informatica mappings and DB2 SQL
• Prepared the Code Review Checklist, Standards document and Reusable components to be used across multiple projects.
• Analysed the data and provide resolution by writing analytical/complex SQL in case of data discrepancies.
• Created Informatica Mappings to load data and used transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy and XML transformation
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer
• Extensively worked on UNIX Shell scripting
• Involved in Performance Tuning (Both Database and Informatica) and there by decreased the load time.
• Implemented Session Partitioning and used Debugger to analyse the mappings and improve performance.
• Worked with business SMEs on developing the business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Presented Data Cleansing Results and IDQ plans results to the OpCos SMEs.
• Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Implemented optimization technique like PUSH DOWN optimization from Informatica.
• Involved in Design review, code review, Performance analysis
• Updated the schedule of the jobs to maintain business functionality in Tidal.
• Created SQL for data migrations and handled Re-Org of DB2 tables.
• Worked with DB team and Informatica team for migrations across multiple environments.
• Trouble shot the defects encountered in SIT & UAT and provided resolutions.

Environment: Informatica Power Centre 9.1/9.6, DB2, SQL Server, TOAD, TIDAL, UNIX, XML, COBOL

Confidential, CONNECTICUT

Senior ETL Developer

Responsibilities:

• Took active part in getting the requirements and converting them to ETL specification documents.
• Created Source - Target documents for assisting the ETL loads and to help QA team to build their test cases
• Worked with DBA’s to have the required scripts in place for the seamless process flow and batch triggering
• Created workflows and maintained the schedules using Autosys
• Used Autosys to schedule the jobs and make box out of the depending jobs
• Created Informatica Mappings to load data and used transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy and XML transformation
• Wrote sql queries for assisting the data load and for performance tuning the source data extraction
• Part of deployment team to monitor the code moving across multiple environments
• Worked on design changes according the new CR’s and implement them effectively
• Developing mapping &Optimizing the mapping for better performance
• Implemented SCD type-1 and type-II for the dimension load
• Involved in Unit Testing and System Testing as well as preparing the low-level ETL design documents and the Unit testing documents and system testing documents

Environment: Informatica Power Centre 9.1, DB2, SQL Server, TOAD, TIDAL, UNIX, XML, Autosys.

Confidential, NEW YORK

Senior ETL Informatica Developer

Responsibilities:

• Actively involved in creating design specifications and ETL design documents
• Preparation of the shell scripts for running the Informatica programs in Autosys Scheduler.
• Preparing UNIX scripts for triggering Teradata load utilities like Fast load and Mload.
• Optimized the process using table driven approach
• Implemented the reusability of mappings by creating mapping shortcuts
• Analysed the data and provide resolution by writing analytical/complex SQL in case of data discrepancies.
• Provided guidance in performance tuning of Informatica mappings & Teradata BTEQs
• Troubleshoot the defects encountered in SIT & UAT and provided resolutions.
• Created Informatica Mappings to load data and used transformations like Stored procedure transformation, Connected and Unconnected lookups, Source Qualifier, Expression, Sorter, Aggregator, Joiner, Filters, Sequence, Router and Update Strategy and XML transformation
• Extensively worked on UNIX Shell scripting and BTEQs to extract the data from the warehouse
• Involved in Performance Tuning and Data Quality (Both Database and Informatica) and there by decreased the load time
• Involved in Design review, code review, Performance analysis.
• Used Metadata Manager to establish the relation between metadata in the designed model

Environment: Informatica Power Centre 8.1/8.5, Oracle 10g, SQL Server, TOAD, Micro strategy, Teradata, Autosys and Solaris, UNIX.

Confidential, BOSTON

ETL Informatica Developer

Responsibilities:

• Worked on design changes according the new CR’s and implement them effectively
• Scheduling the workflows via autosys and trouble shooting
• Creating Scripts in Unix to assist Informatica loads as per the requirements
• Migrating the code from INF 7.1 to INF 8.1
• Developing mapping &Optimizing the mapping for better performance
• Did PLSQL coding required for loading of targets according to the business requirements
• Worked on PLSQL objects like packages, triggers, stored procedures, functions and used oracle threads to use parallel mechanism
• Performing debugging & tuning of mapping
• Implemented SCD type-1 and type-II for the dimension load
• Involved in Unit Testing and System Testing
• Upgraded the scheduling mechanism from Informatica scheduler to Control-M

Environment: PL/SQL, Informatica Power Centre 7.1/8.1, Oracle 9i, TOAD, UNIX

Confidential, WASHINGTON

ETL Informatica Developer

Responsibilities:

• Preparing ETL design documents as per the business requirements.
• Used workflow Manager to create, execute and monitor sessions that perform source to target data loads.
• Developed mappings to transform extracted data into Facts & Dimension tables.
• Designing mapping as per the ETL Specifications.
• Designed views for SAS Reporting.
• Developing mapping & Optimizing the mapping for better performance.
• Performing debugging & tuning of mapping.
• Part of deployment team to monitor the code moving across multiple environments (Dev, QA, UAT and PROD)
• Created SQL for assisting in data loads.
• Troubleshoot production defects and fixed Cognos reports.
• Involved in Unit Testing and System Testing as well as preparing the low-level ETL design documents and the Unit testing documents and system testing documents

Environment: Informatica Power Centre 7.1.1, Oracle 10g/9i, TOAD, Cognos and UNIX (HP).