SUMMARY

• Hands on 10 years of work experience in the field of analysis, design, development, testing and implementation of Data Warehouses using Powercenter Informatica, IDQ tool, MDM and Oracle, Netezza, Teradata, DB2, SQL Server database.
• Worked Extensively on Informatica PowerCenter 7.x/8.X/9.x/10, IDQ, IDD and MDM.
• Worked on PL/SQL programming, Analytical SQL Query & Stored procedures, Packages, Triggers and Cursors, Shell Scripting etc.
• Conscious towards coding standards, documentations and proper architecture of application.
• Developed Informatica solutions for complex and large volumes of data using SQL Server, Oracle fixed width and delimited files.
• Developed Proof of concept in IDQ and Powercenter for HTTP transformation, Web Service Consumer Transformation, Java Messaging service etc.
• Expertise in translating user requirements (business requirements) to basic system requirements specifications as input to developers.
• Highly experienced in developing data source, target mapping, sessions and workflows using Informatica.
• Extensive hands on experience in ETL designing.
• Good knowledge of Slowly Changing Dimensions, Star and Snow Flake schemas.
• Extensive exposure in performance tuning of ETL code.
• Knowledge of Dimensional Data Modeling, Erwin 4.0, Dimensional Modeling, Ralph Kimball Approach, Star Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De Normalization Concepts.
• Experience in preparing the ETL Design Documents like High Level and low - level Design documents. Involved in the Unit testing, integration testing, System testing and UAT using Quality Centre.
• Worked with Insurance, Investment, Retail Banking domains and Agricultural Domain for some reputed clients like Confidential, Confidential, Barclays, Confidential, and ADM.
• Experience in Equities, Derivatives, FISS reports, Basel of Banking Domain
• Excellent team player with excellent analytical, strategic planning and interpersonal skills.
• Well-organized, efficient, quick learner with excellent ability to plan, organize, prioritize my work and to meet deadlines.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, Shell Scripts

Databases: Oracle 9i, Oracle 10g, Netezza, Teradata, Sql Server, DB2

Web Technologies: HTML, XML

Tools: Informatica PowerCenter 7.x/8.X/9.x/10, Informatica Data Quality, Informatica master data management 10.1 SQL Developer, PL/SQL Developer and TOAD

Operating Systems: UNIX, Linux, Windows

Scheduling tool: Autosys, Control M, Informatica Scheduler.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Technical Lead

Responsibilities:

• Creating mapping to read data from various sources like Flat files, Oracle and feed files and load into master data hub.
• Involved from the design phase of the project.
• Used Supplier 360-degree data model for MDM HUB
• Analysis of source system using Informatica IDQ tool.
• Applying the file level validations e.g. Header, Footer, Count Validations.
• Applying the field level validations, data constraint validations as per design document.
• Created UNIX script for importing and exporting the Informatica objects to and from the repository.
• Designed and developed Power center/IDQ/MDM/IDD
• Played an extensive role in business requirement gathering, requirement analysis and data rules creation in IDQ and Powercenter development.
• Configured relation among table to obtain LKP.
• Performance tuning mapping and database.
• Working on reference tables.
• Create trust on records.
• Using Match and merge rules generate the golden records.
• Designed processes for the framework which include processes for Data Cleansing and Quality checks (De-duplication, Format Checks, Valid Value Checks, Enrichment), Data Conforming System, Error Event Handler (Exception Handling), Auditing System (Operational Runtime Statistics), Data Archiving.
• Designed generic process outside of standard framework for requirements not fitting standards.
• Created low level designs for ETL processes which are generic in nature and completely metadata driven using Informatica. (Applied Rules for checks required)
• Used Advanced Informatica feature like Concurrent Workflow execution to have one code base and enable to handle multiple feeds using metadata.
• Created work breakdown structure and helped create project plan with resource allocation.
• Executed multiple feeds in the Gateway across various phases of SDLC, from requirement analysis to development, SIT, UAT and Production.
• Loaded the landing tables with the help of ETL jobs and IDQ mappings and workflows
• Created mapping applications in IDQ for landing table data.
• Developed mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc. and having files as a source and targets along with database objects
• Create the store procedures.
• Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
• Effectively involved in test data preparation and code review.
• Attending Daily defect calls for Project discussion
• Onsite coordination, Preparation and deliver Daily/Weekly Status Report
• Created knowledge base and induction framework for new resources coming in the project.

Environment: Informatica Power Center 10.1, IDQ, Oracle, MDM and IDD, Autosys,Unix scripting, FTP,Flat files

Confidential, Pittsburgh, PA

Technical Lead

Responsibilities:

• Creating mapping to read the risk and trade data from various sources like Flat files, Oracle and feed files and load into data warehouse for further reporting purpose.
• Involved from the design phase of the project.
• Analysis of source system using Informatica IDQ tool.
• Applying the file level validations e.g. Header, Footer, Count Validations.
• Applying the field level validations, data constraint validations as per design document.
• Created UNIX script for importing and exporting the Informatica objects to and from the repository.
• Created objects migration script.
• Developing queries for various feeds.
• Follow the required coding standards and implement non-functional standard requirements in process.
• Performed Unit Testing for developed mappings.
• Designed end to end ETL framework for the Gateway.
• Designed generic processes outside of standard framework for requirements not fitting standards.
• Creating Reusable Component for the Data quality check rules.
• Creating low level designs for ETL processes which are generic in nature and completely metadata driven using Informatica.
• Used Advanced Informatica feature like Concurrent Workflow execution to have one code base and enable to handle multiple feeds using metadata.
• Created work breakdown structure and helped create project plan with resource allocation.
• Executed multiple feeds in the Gateway across various phases of SDLC, from requirement analysis to development, SIT, UAT and Production.
• Created process for handling multiple code bases and their migration across environment.
• Based on Phase one experience helped create estimation sheets for fresh development and handling CRs.
• Work on scripting and scheduling for Autosys jobs.
• Involved in writing UNIX scripts.

Environment: Informatica Power Center 9.6.0, Toad, Flat Files and Oracle 10g

Confidential

Technical Lead

Responsibilities:

• Creating mapping to read the risk and trade data from various sources like RRS, Atlas, Sophis and feed files and load into data warehouse for further reporting purpose.
• Created PL/SQL analytical queries for the existing process Sophis system.
• Involved from the design phase of the project.
• Applying the file level validations e.g. Header, Footer, Count Validations.
• Used Advanced Informatica feature like Concurrent Workflow execution to have one code base and enable to handle multiple feeds using metadata.
• Created work breakdown structure and helped create project plan with resource allocation.
• Executed multiple feeds in the Gateway across various phases of SDLC, from requirement analysis to development, SIT, UAT and Production.
• Created process for handling multiple code bases and their migration across environment.
• Analysis and refinement of business requirements. Direct Interaction with client and business on BI design.
• Owning the responsibility of all the ongoing developments and fixes.
• Design and Development of complex Informatica mappings.
• Worked on scheduling workflows with Autosys.
• Design Use Case and Sequence diagrams as per requirements.
• Created High Level and Low-Level design document for development team.
• Developed Informatica solutions for complex and large volumes of data from DB2, SQL Server and flat files.
• Provided effort estimation and timeline settling for various projects and enhancements.
• Tuning the existing Informatica mappings to maximize performance to reduce run times.
• Ensure the code standards recommended by Informatica are implemented to maximize the performance.
• Enhancement of existing components in the application and ensure the new component will not affect existing application.
• Extensive experience in preparing CMMI level documentation i.e. High-Level Design, Detail Level Design, Unit Test Plan, Unit Test Cases, Integration plan, Implementation and Transition Plan.
• Involved in project meetings for getting signoffs on CMMI documents and project status meetings.
• Simultaneously worked on multiple business units like GB, GRS and Individual Business.

Environment: Informatica Power Center 9.6.1, IDQ,SQL developer, FTP, SFTP, and Shell Scripts with Oracle 11g and Netezza 7.0.x

Confidential

Senior Developer

Responsibilities:

• Designed end to end ETL framework for the Gateway.
• Dimensional Data Modeling experience on Data modeling, Conceptual, Physical & Logical data modeling.
• Prepare the HDL (High level Design) and LLD (Low Level Design)
• Create PDM (Physical Data Model).
• Requirement Analysis through business model and functional model.
• Developed a Metadata as per the data model for Project work.
• Performance tuning.
• Designed processes for the framework which include processes for Data Cleansing and Quality checks (De-duplication, Format Checks, Valid Value Checks, Enrichment), Data Conforming System, Error Event Handler (Exception Handling), Auditing System (Operational Runtime Statistics), Data Archiving.
• Designed generic processes outside of standard framework for requirements not fitting standards.
• Created low level designs for ETL processes which are generic in nature and completely metadata driven using Informatica. (Mapplet for checks required in gateway)
• Used Advanced Informatica feature like Concurrent Workflow execution to have one code base and enable to handle multiple feeds using metadata.
• Created work breakdown structure and helped create project plan with resource allocation.
• Executed multiple feeds in the Gateway across various phases of SDLC, from requirement analysis to development, SIT, UAT and Production.
• Created process for handling multiple code bases and their migration across environment.
• Based on Phase one experience helped create estimation sheets for fresh development and handling CRs.
• Onsite coordination, Preparation and deliver Daily/Weekly Status Report
• Created knowledge base and induction framework for new resources coming in the project.
• Mentored new team members on FSG design/ Standards assigning tasks and reviewing deliverables

Environment: Informatica Power Center 8.6.1, SQL Developer, Java, and Shell Scripts, Control M., Oracle 10g and DB2.

Confidential

Senior Developer

Responsibilities:

• Design and developed the Informatica mapping and PLSQL script used in ETL.
• Designed end to end ETL framework for the Gateway.
• Done the Data Profiling in IDQ 9.0.1.
• Dimensional Data Modeling experience on Data modeling, Conceptual, Physical & Logical data modeling.
• Prepare the HDL (High level Design) and LLD (Low Level Design)
• Create PDM (Physical Data Model).
• Requirement Analysis through business model and functional model.
• Developed a Metadata as per the data model for Project work.
• Performance tuning.
• Designed processes for the framework which include processes for Data Cleansing and Quality checks (De-duplication, Format Checks, Valid Value Checks, Enrichment), Data Conforming System, Error Event Handler (Exception Handling), Auditing System (Operational Runtime Statistics), Data Archiving.
• Designed generic processes outside of standard framework for requirements not fitting standards.
• Created low level designs for ETL processes which are generic in nature and completely metadata driven using Informatica. (Mapplet for checks required in gateway)
• Used Advanced Informatica feature like Concurrent Workflow execution to have one code base and enable to handle multiple feeds by using of metadata.
• Created work breakdown structure and helped create project plan with resource allocation.
• Executed multiple feeds in the Gateway across various phases of SDLC, from requirement analysis to development, SIT, UAT and Production.
• Created process for handling multiple code bases and their migration across environment.
• Based on Phase one experience helped create estimation sheets for fresh development and handling CRs.
• Onsite coordination, Preparation and deliver Daily/Weekly Status Report
• Created knowledge base and induction framework for new resources coming in the project.
• Mentored new team members on FSG design/ Standards assigning tasks and reviewing deliverables.

Environment: Informatica Power Center 9.0.1, IDQ, SQL Developer, FTP, SFTP Shell Scripts, Text Editor, Oracle 10g and SQL Server.

Confidential

ETL Developer

Responsibilities:

• Carry out the impact analysis for implementing the process.
• Preparation of Technical design document to the new requirements.
• Responsible for developing some scripts and mapping in the process.
• Unit testing, preparation of UTC/ UTRs.
• Monitoring the Dashboard DAC.

Environment: Informatica Power Center 8.6.1, OBIEE (reporting Tool), SQL Developer, Shell Scripts and Oracle 10g.

Confidential

ETL Developer

Responsibilities:

• Developing complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Router and SQL transformations.
• Coordinating with Infrastructure and DBA teams to sync up the data and the components within the different environments (DEV/QAT/PRD).
• Integrating and unit/system testing the various components and documenting the unit test results and system test results.
• Maintaining the history of defect logs with proper resolutions and addressing issues.
• Checking the performance of the applications in various environments like Development, QAT.
• Coordinating with Onsite support team for client-side resolution.

Environment: Informatica Power Center 8.6.1, SQL Developer, Java, and Shell Scripts, Autosys and Oracle 10g.