SUMMARY:

• Over 8 + years of experience in all phases of the Data Warehouse life cycle involving, design, development and Implementation of Data warehouses/Data marts using, Data Modelling for Finance and Insurance sectors.
• Ability to efficiently handle Project Enhancements and Production Operations, with strong trouble shooting and problem solving techniques.
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process with excellent analytical/communication skills and good team spirit.
• Strong experience in RDBMS Concepts, Dimensional Data Modeling (Star Schema, Snow - flake Schema, Fact and Dimension tables), Logical and Physical Data Modelling.
• Strong experience in using ETL technologies Informatica Power Center 9.x/8.x/7.x,Power Exchange for Mainframe
• Experienced in leveraging ETL Transformations to meet the business requirements (Source Qualifier, Aggregate, Lookup, Rank, Joiner, Filter, Router, Sorter, Sequence Generator, Union, Update Strategy etc..).
• Proficient in building reusable components like transformations, mapplets, worklets.
• SQL developer experience in writing complex SQL queries, PL/SQL Scripts and conduct query optimizations.
• Extensive experience in performance tuning, identified and fixed bottlenecks, and tuned complex Informatica mappings for better performance.
• Extensively worked with Slowly Changing Dimensions (Type I, Type II and Type III).
• Worked with multiple data sources (Oracle, DB2, SQL server, Sequential Files, Teradata, Xml Files) and integrated them into centralized DW database.
• Experience in designing Tables, Views, Stored Procedures and other PL/SQL statements for various applications.
• Technical hands-on expertise using OLAP tool Cognos 8.0 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio)
• Worked with complex queries involving multiple table inner and outer joins and optimizing the queries by creating various clustered, non-clustered indexes and indexed views with the help of DBA.
• Experience in Unix Shell Scripting and Autosys for scheduling the workflows.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/8.6/8.1/7.1 (Repository Manager, Mapping Designer, Workflow Designer and Workflow Monitor) Power Exchange ((Navigator, Data Maps).

Database & Related Tools: Oracle 11g/10g/9i, MS SQL Server 2005/2008, Teradata, UDB, Mainframe (Sequential Files)

BI & Reporting Tools: Cognos 8.0

Languages: SQL, PL/SQL, Unix Shell Scripting

Operating Systems: Window 95/98/2000/2003/ XP, Unix.

PROFESSIONAL EXPERIENCE:

Confidential, MI

ETL Developer

Environment: Windows, AIX 6

Responsibilities:

• Involved in all phases of project starting from planning phase and contributed towards project scheduling and implementations.
• Involved in detailed analysis of business requirements and produced requirement artifacts.
• Collaborated with business and applications team in designing ETL solutions to meet the business requirements.
• Worked with Data Architect on the design of Data Marts, levering the concepts of Star schema and support OLAP reporting teams.
• Prepared ETL design specification documents to meet the desired outcome and provided them to ETL development team.
• Prepared Unit test cases, executed them and documented the test results. Managed defect tracking log and resolved defects arising during UAT phase.
• Prepared deployment plan and go-live check list for streamlined code promotions and avoided any issues which might arise during go-live activities.
• Prepared Operations Manual for transitioning the project activities to Operations Team.
• Worked with multiple RDBMS and flat file sources (UDB, Oracle, fixed-width files). Imported the source & target definitions in a shared folder and leveraged short cuts in various mappings and folders.
• Developed complex mappings using various transformations (Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations) to meet the ETL design specifications.
• Leveraged dynamic lookup cache and persistent cache for SCD mappings.
• Executed various troubleshooting techniques and resolved issues, utilized debugger and break points, identified performance bottlenecks.
• Utilized mapping parameters and variables wherever possible for reusability and ease of enhancements.
• Prepared shell scripts and control files to control the load process into staging, DW and Data Marts.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like email, decision, command and pre/post SQL.
• Prepared command line programs using PMCMD for execution & automating of scheduling via R11 Autosys.
• Created Records and Tables Definitions of Mainframe Files using Navigator (used Copybooks if available else created manually).
• Imported Power Exchange Source definitions and integrated into Power Center for further processing.

Confidential, IA

Environment: Windows, AIX 5.3

Responsibilities:

• Extracted data sources from Operational Source systems and other data stores.
• Created Informatica Folders with proper permissions (both personal and project folders).
• Maintained Groups and Users and assigned proper privileges depending on roles and responsibilities in the project.
• Implemented the Versioning feature and created Deployment Groups (both static and dynamic) for moving the objects from development to Production.
• Improved Performance by utilizing the partitioning option on the DB2 Databases.
• Automated Scheduling of Sessions using Scheduler and use of triggering mechanism.
• Worked on the cleanup process of reducing the redundant objects such as Source Definitions, Database connections etc., by using shortcuts and removing excess definitions and connections.
• Created reusable objects such as (Mapplets, Worklets, Transformations, Commands etc.) so that they can be reused in multiple projects.
• Established ETL development guidelines to enable common practices across all the programmers which helped in consistent coding methodologies.
• Extensively worked with all the transformations (Expression, Lookup (Connected and Unconnected), Joiner, Union, Normalizer, Update Strategy) etc., to meet the business requirements.
• Created reusable Transformations mainly Lookup, Sequence Generator and expression and used across multiple projects as they share common logic between them.
• Created complex Mappings and used reusable Transformations for efficient dataflow between Source and Target Definitions.
• Used Source Qualifier for overriding the SQL and applying Source Filter at the beginning of the process for improving the performance.
• Implemented Slowly Changing Dimensions in the mappings as per the data model of the Data mart.
• Extensively used Debugger Process in resolving issues in Development and Testing phases.
• Utilized Database Partitioning option with DB2 partitioned databases to increase the performance significantly.
• Created sessions, worklets and workflows and organized the processes according to· the requirements.
• Created Pre / Post Session Instructions using a command Task and embedded them in the workflow.
• Extensively used Timer, Command, Event Wait and Email tasks within the workflow to automate the process to the maximum extent.
• Worked with the project team and business counterparts in gathering project requirements and deliverables.
• Proactive in communicating and collaborating with various business units to analyse information needs, functional and system requirements.
• Assisted in obtaining the project estimates from the appropriate team members to ensure project is on track.

Confidential

Environment: Windows NT/2003, Oracle.

Responsibilities:

• Attended Subject Matter Experts (SME) meetings for requirements gathering, analysis and involved in preparation of functional specifications and technical specifications.
• Analysed existing system and developed business documentation on changes required.
• Fine-tuned mappings, transformations, various aggregations and workflow requirements to load the data warehouse as per business processes, data flow logic and technical requirements.
• Developed complex mappings and SCD type-I, Type-II and Type III mappings to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Assigned appropriate memory (Caches) requirements for Lookup, Aggregator and Rank caches for Optimum Performance.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata.
• Fine-tuned existing mappings for performance optimization.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Extensively used Debugger Process in resolving issues in Development and Testing phases.
• Executed sessions for proper execution of mappings and performed event based scheduling
• Automated the jobs through scheduling using built in Informatica scheduler, which runs every day by maintaining the data validations
• Involved in the Unit testing, Integration testing and System testing.
• Extensively involved in testing the system from beginning to end to ensure the quality of the adjustments made to oblige the source system up-gradation.