SUMMARY

• 12 years of IT experience with specialization in Data Warehousing, Decision support Systems and extensive experience in implementing Full Life cycle Data Warehousing Projects.
• Strong ETL experience using Informatica PowerCenter 10.x/9.x/8.x/7.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations.
• Have worked on Reporting tools including Business Object 6.5 and Cognos 8.x.
• Extensiveexperience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server .
• 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.
• Had very good hands on Metadata Manager (MM) using Oracle and Informatica. Which will give the complete data lineage and proper data flow which would be very helpful for Top level functional consultants
• Main responsibilities listed on a Tableau Developer resume include consulting with business clients, creating Tableau dashboard reports, collaborating with developer teams, using data visualization tools, and using the Tableau platform to create business intelligence visualizations.
• Utilized 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.
• Work with Project Managers, Business Analysts and Systems Analysts on understanding deliverables from a Development perspective.
• Identify and document all development tasks required to meet business requirements.
• 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).
• As a QA Analyst - Worked on various industry verticals - Supply Chain, Financials, Telecommunications andRetail.
• 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.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• 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.
• Exceptional analytical and problem solving skills. Good team player with the ability to communicate effectively at all levels of the development process.
• Worked more than a decade with client Confidential under different units like Energy, Corporate, Healthcare etc.
• As of now working for Confidential on a Capital PC reporting where we are using Informatica with reporting layer as well.

TECHNICAL SKILLS

ETL: Informatica 9.x/8.x/7.x,Metadata Manager

Databases: Oracle 10g/9i/8i, MS Access

Operating Systems: Windows XP/NT/2000/98

BI Reporting Tools: Business Objects 6.x, 7.x, Cognos 8.x, Tableau &Microstrategy

Languages: C, C++, SQL, PL/SQL

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

DW Project Lead

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.
• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the 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.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)
• Defects identified in testing environment are communicated to the developers using Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• 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
• 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.
• Compiled source to target mapping documents to design the ETL jobs.

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.
• Compiled source to target mapping documents to design the ETL jobs.

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 Microstrategy