SUMMARY

• 12 years of professional experience in Requirement Gathering, Analysis, Design and Development, Testing , Implementation and Production Support, Documentation and Delivery.
• Strong programming skills with diverse computer science experience.
• Sound analytical and problem solving skills with a good exposure to the key facets of leading teams to meet set objectives and ability to learn new technologies quickly.
• Strong ETL experience using Informatica Power Center 10.x/9.x/8.x/7.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations.
• Worked on Reporting tools including Business Object XI 3.1 and Cognos 8.x.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server .
• E xperience with specialization in Data Warehousing, Decision support Systems and extensive experience in implementing Full Life cycle Data Warehousing Projects.
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations/ Stages like Joiner, Transformer, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
• Expertise in tuning existing mappings, identifying and resolving performance bottlenecks at various stages.
• Hands on working experience in Metadata Manager (MM) using Oracle and Informatica. Which will give the complete data lineage and proper data flow
• Used Tableau server to publish and share the reports with the business users.
• Lead team of 10+ onshore and offshore team comprising of ETL developers, Data Modelers and Data Architects.
• Have experience in Quality Assurance in Information Technology, involving analysis, both Manual and Automation testing of client server and web applications.
• Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
• Strong knowledge of Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, Support).
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Experience in preparing test reports from Quality Center and prepared daily test status reports to communicate the test status with the team.
• Assign and monitor progress of development tasks and proactively identify any impediments to meeting quality and schedule objectives.
• Actively participate in agile scrum review and planning sessions.
• Actively lead regular code reviews and maintenance of code and process documentation.
• Thoroughly proficient in SQL and PL/SQL development in Oracle 8i/9i/10g.
• Extensive experience in writing/debugging Oracle Back-end PL/SQL development by writing Packages, Stored Procedures, Functions and Triggers.
• Strong knowledge in using Oracle built-in packages, Cursor management and Exception handling.
• Experienced in creating and maintaining Database Objects like Tables, Views and Materialized views, Indexes, Constraints, Sequences, Synonyms and Database Links and Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic.
• Designed and developed Data Marts by following Star Schema and Snowflake Schema Methodology , using industry leading Data Modeling tools like ERWIN
• Experienced in Tuning application using Advanced PL/SQL (Analytical Functions,
• Worked more than a decade with client Confidential (General Electric) under different units like Energy, Corporate and Healthcare etc.
• As of now working for Cisco on a Capital PC reporting where we are using Informatica with reporting layer as well.

TECHNICAL SKILLS

ETL: Informatica Power center 10.x/9.x/8.x/7.x, Informatica Metadata Manager (IMM)

Reporting Tools: Business Objects XI-r3, Cognos 8.x, and Tableau

Cloud Tools: Dell Boomi

Scripting Unix:

Tools: SQL Developer 11.6, Toad 12.9, WinScp, Putty, TES Scheduler

Databases: Oracle 10g/9i/8i; SQL/PLSQL

PROFESSIONAL EXPERIENCE

Confidential

DW Project Lead

Responsibilities:

• To make sure we surpass proper coding standards and follow accurate naming terminologies in entire code
• Responsible for leading the design of prototypes and determining final design to ensure client satisfaction with product.
• Conduct impact assessment with business in order and determine high level design and size of effort based on requirements.
• Lead and guide an Informatica based ETL architecture to handle complex business rules while balancing the fulfillment of stringent performance requirements.
• Drive design and determine the ETL requirements for BI projects.
• Perform an active, leading role in shaping and enhancing overall ETL Informatica architecture, including ETL standards, patterns and best practices.
• Ability to quickly grasp problems and issues and communicate effectively with other team members.
• Understanding of development using SCRUM and Agile practices
• Possess good communications skills and Partner with Leadership team to ensure the successful delivery of projects.

Environment: Informatica Power Center, Business Objects XI-R3 Oracle 10g, PL/SQL, UNIX, Windows XP, Support Central, WinSCP, Putty.

Confidential

Informatica Upgrade & ETL Tester

Responsibilities:

• Gather all the interfaces which needs to be tested and need to be migrated to the next environment
• Attending the daily status calls with IM and business people to know the functionality of different interfaces
• Perform all the necessary connectivity checks like Oracle, SAP, Web services, Teradata, SFTP and ODBC.
• Developed Test Plans, test scripts and executed the test scripts for FedEx Freight - OPM DW Project.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared test plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
• Extensively worked with flat files and excel sheet data sources.
• Wrote scripts to test the flat files data in the databases,
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts

Environment: Informatica Power Center, Oracle 10g, PL/SQL,Unix, Windows XP, Support Central, WinSCP, Putty.

Confidential

Team Lead

Responsibilities:

• To ensure to take the input and deliver the deliverables to the customer at right time.
• Handling quick approach to the end user (business) where they will be free without any issues which handling the day to day meetings.
• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Worked on issues with migration of Data from development to QA-Test Environment
• Extensively tested several Business Objects Reports - Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.
• Handling quick approach to the end user (business) where they will be free without any issues which handling the day to day meetings.
• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Actively participated in discussion sessions to design the ETL job flow.

Environment: Informatica Power Center, Oracle 10g, PL/SQL,Unix, Windows XP, Support Central, WinSCP, Putty.

Confidential

DW Lead & MM Developer

Responsibilities:

• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Actively participated in discussion sessions to design the ETL job flow.
• Compiled source to target mapping documents to design the ETL jobs.
• Prepared detail design documents which contain job designs and functionality of each job.
• Transformer, Lookup, Merge, Join, Aggregator, Sort, Filter and Remove duplicates stages were extensively used to Cleanse/Transform the data extracted into staging.
• Coordinated tasks with onsite and offsite team members.
• Provided 24x7 production supports.
• Trained end users on application.
• To ensure to take the input and deliver the deliverables to the customer at right time.
• Attending the daily status calls with IM and business people
• To make sure we have delivered bug free code once we tested.
• Handling quick approach to the end user (business) where they will be free without any issues which handling the day to day meetings.

Environment: Oracle 10g, PL/SQL, Metadata Manager (MM) , Unix, Windows XP, Support Central, WinScp, Putty, Tableau and Micro strategy

Confidential

DW Sr. Developer

Responsibilities:

• To ensure to take the input and deliver the deliverables to the customer at right time.
• We have implemented new Incremental logic depending on the column ‘last update date’ to run the load if it gets failed and shared the same to business too.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Handling quick approach to the end user (business) where they will be free without any issues which handling the day to day meetings.

Environment: Oracle 10g, PL/SQL, Unix, Support Central, WinSCP, Putty.

Confidential

DW Support

Responsibilities:

• Participated in all aspects of the software development Life cycle, design the solution, present for design review, develop code, perform unit/integration testing and support the product by serving as the top-tier customer support.
• Responsible for extracting, transforming and loading data Using UTL FILE, SQL LOADER.
• Working on any new enhancements for this data mart which includes the ETL part in creation of new mapping and session.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Worked on enhancement for creating new reports in BO 6.5
• Performance Tuning for ETL loads running in production

Environment: Oracle 8i, SQL, TOAD, Windows 2000, UNIX, BO 6.5, HPSD