SUMMARY:

• 10+ years IT experience including focusing on Data warehousing, Data integration, Data Migration, ETL process and Business Intelligence .
• Expertise in Informatica ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools
• Strong understanding of Data Modelling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.
• Experience in system analysis, design, coding and testing
• Extensively created and tuned mappings using Informatica Power Center 7.x, 8.x,9.x
• Worked with different sources like COBOL Data, ORACLE, SQL Server, CSV Flat Files data
• Performance & Tuning at Database side and Informatica Power Center side.
• Peer reviews and system testing and developing complex mappings.
• Developed PL/SQL scripts to move historical data from different sources to staging database
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, and Stored Procedure
• Developed slowly changing (TYPE2) dimensions mappings to keep history
• Used debugger to test the data flow and fix the mappings
• Working with Offshore team and handling ETL Load bottle necks
• Monitored production load and resolve Production issues
• Involved in Unit testing and documentation, Created plan for Performance Testing, parallel process, integration testing
• Developed Informatica code which conforms to a set of standards and velocity best practices
• Worked on Agile methodologies & Kimball bus Architecture, (Confirmed Dimensions & Facts), Start Schema, Snow Flake schema data models
• Strong communication skills, decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and also in a team by helping to troubleshoot technology and business related problems

TECHNICAL SKILLS:

Operating Systems: UNIX, AIX, Windows 2K, NT & XP, Windows 7

Language: C, JAVA, J2EE, EJB, & SQL, PL/SQL

RDBMS: ORACLE, MS ACCESS, SQL SERVER and DB2

Environment: Data Warehouse, Mainframe, Web and Client/Server

TOOLS: QTP, Test director, Rational tools, Auto Sys, Control - M

ETL Tools: Informatica PowerCenter 7.x, 8.x,9.x, OWB 10g, PL/SQL, SSIS

PROFESSIONAL EXPERIENCE:

Confidential,Vienna,Va

• Working with business users and business analyst for requirements gathering and business analysis.
• Involved in designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Extracted data from different flat files, Oracle and transformed the data based on user requirement using Informatica Power Center and loaded data into target, by scheduling the sessions.
• Worked on Informatica Power Center 9.6.1 tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and also in tuning of mappings for better performance.
• Created reusable mapplets and Transformations. Starting concurrent batch process in server and did backup, recovery and tuning of sessions.
• Created sequential batches and concurrent batches for sessions.
• Developed PL/SQL procedures/packages to kick-off the SQL Loader control files/procedures to load the data into Oracle.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Supporting daily loads and work with business users to handle rejected data.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
• Done automation of file provisioning process using UNIX, Informatica mappings and Oracle utilities.

Environment: Informatica 9.6.1, OBIEE 12c, Oracle 12c DB, SQL Developer, SharePoint

Confidential,NY

Data Warehouse

• As part of transition, I involved in gathering all the information about the project like Data, source systems, Data marts and the load process and reports. Document all the information gathered from NG and provide the documentation to PSEG. I am responsible for system testing the different data marts to ensure that the all the data and code is transferred from NG to PSEG by comparing data against their system. As one by one data mart is transitioned, data integration should be tested. And make sure all the code is functional.
• Developed test scripts based on the business requirements.
• Prepared test data and validating business requirements
• Developing SQL and/or Unix scripts for test data generation or test harness automation
• Execute regression, functional, and system testing
• Verifying results and producing test summaries and defect reports
• Identifying defects and requirement discrepancies
• Generating defect change requests and reporting discrepancies
• Perform load test using load runner to check the reports runtime during peak load time when all users are running data at the same time.

Environment: Informatica 9.6.1, Power Exchange, MicroStratagy 9.4g, UNIX, Oracle 11g, Mainframe, SQL Developer, Citrix, SharePoint, Serena Version manager tool

Confidential, Vienna,VA

ETL ELIS - TPO RFA

• Experience with conducting Data Analysis and identified Data issues and resolutions. Design and develop ETL solutions for a large scale data warehouse using Informatica.
• Developing Mappings, Sessions, Worklets, Workflows, and processes in the Informatica/Oracle/UNIX environment
• Develop detail-level ETL design including data capture, integration, data staging, transformation and aggregation.
• Develop ETL workflows and mappings using Informatica PowerCenter.
• Design and develop ETL failover mechanism, recovery, and exception handling. Conduct analysis of ETL processes and suggest improvements.
• Work with client technical representatives to validate requirements and design decisions.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance .
• Followed Informatica recommendations, methodologies and best practices.
• Developing and maintaining the test cases and test results
• Creating Test plan and Test scripts and validate data.
• Excellent problem solving skills and strong attention to detail.
• Excellent communication and collaboration skills with business and technical communities.
• Experience working in agile environments is a strong plus.
• Work with internal teams, communicating design plans and monitoring implementation.

Environment: Informatica 8.6.1/9.x, Power Exchange, OBIEE 10g/11g, UNIX, Oracle 11g, Mainframe

Confidential,Columbus,OH

Informatica Developer

Responsibilities:

• Performed Source system analysis, analyzed the business rules and implemented business logic in the mappings.
• Worked on Planning, Budgeting and Allocations modules and maintained the Historical Data.
• Developed ETL specifications to apply business rules in the Informatica mapping.
• Worked with CSV and Fixed width Flat File Sources and Targets and also worked with oracle Sources and Targets.
• Worked with all the transformations like Lookup, Joiner, Filter, Router, Sorter, and Aggregator. Source qualifier, Expression, Update Strategy and Normalizer and Sequence generator Transformations.
• Created error tables and implemented error handling to handle the null values.
• Developed mapplets to make the reusable objects.
• Worked with parameters and variables at mapping level.
• Created and Monitored Workflows and Tasks using Informatica Power Center Workflow Manager and Workflow Monitor.
• Involved in Performance tuning of the mappings to improve the performance.
• Performed Unit Testing and prepared unit testing documentation.
• Fixed the Bugs which came from Testing Environment.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, Toad, Flat Files, SQL, PL/SQL, UNIX and Windows XP.Top of Form

Confidential,Cleveland,OH

Informatica Developer

Responsibilities:

• Developed ETL specifications to implement the business rules and developed mappings..
• Extracted data from various sources like DB2, Flat Files and loaded the data into Oracle staging and into the Data warehouse.
• Transformed data using Informatica transformations Lookup, Joiner, Filter, Router, Sorter, Aggregator, Source qualifier, Expression, Update Strategy Transformations.
• Implemented Delta process to implement the incremental loads.
• Worked with shared folders, shared objects and reusable objects.
• Developed slowly changing dimensions mappings to keep the history of the data.
• Developed mapplets to make it reusable in different mappings.
• Created and Monitored Workflows and worklets using Informatica PowerCenter Workflow Manager and Workflow Monitor.
• Scheduled Tasks and Workflows on the Informatica Workflow Manager.
• Involved in Performance tuning of the mappings to improve the performance.
• Performed Unit Testing and prepared unit testing documentation. Developed the Test Cases and Test Procedures.

Environment: Informatica Power Center 8.1, Oracle 10g, SQL Server 2000, DB2, Visio, Toad, SQL Assistant, UNIX and Windows XP.

Informatica Developer

Confidential,Cleveland,OH

• Conduct user interviews and data analysis review meetings.
• Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Implemented the Data quality strategies to resolve data related issues.
• Data analysis, Data Quality and ETL design that feeds the logical data models.
• Profile source data to suggest candidate keys, detect data patterns, evaluate join criteria
• Defining of key facts and dimensions necessary to support the business requirements.
• Develop prototypes for validating technology strategy and proof of Concept.
• Provided Design overall ETL process and developed ETL mappings.
• Developed ETL routines using PL/SQL stored procedure
• Review all systems design, assuring adherence to defined requirements.
• Created plan for Performance Testing, parallel process, integration testing.
• Performed detail data analysis and Data Quality testing.
• Analyzes and designs new business reports using Business Object.

Environment: SQL Server, DB2 UDB, DB2 Mainframe, UNIX, NDM process, Informatica PowerCenter 7.x, Data Profile, PVCS, Business Object XI, PL/SQL.

Sr QA Automation Test Engineer

Confidential,Medina,OH

• Executing the complete test cycle to test the functionality:
• Analyzed the specs and created functional test plans with detailed Test requirements, test procedures using Test Director.
• Created multiple test cases for all the business rules and for different boundary values.
• Analyzed and understand the change requests or business requirements.
• Automated the test scripts using Win Runner TSL for regression testing.
• Used Winrunner to run INIs to create new Policies and scrape the entered policies
• Write Scripts for the application Manually using the Win Runner TSL. Used Rational Clear case for the version control of the automated scripts.
• Interacted with developers on concerned issues and bugs/defects found in course of testing.
• Used Test Director to run test cases .
• Defects were tracked, reviewed, analyzed and compared.
• Performed manual testing for time dependent scenarios.
• Executed the internal User Acceptance Test (UAT) scripts and over night regression.

Environment: Test Director, Win Runner, Rational Clear Case, Java, J2EE, JSP, EJB, Oracle, MS office, Web-Sphere, Web-Logic

Test Analyst

Confidential,Cleveland,OH

• Testing e-greetings, Web applications, server side tests .
• Assist in the planning and development of test plans, cases using the reqirement specification document. Ensure alignment with business requirements;
• Develop and execute detailed test cases. Document test results;
• Maintain test plans, environment, data and tools for system enhancements and corrections; Identify and prioritize issues with testing and system behavior.
• Used Ticket builder for tracking the defects.
• Assist in maintaining accurate testing records for each customer
• Performed regression and integration testing to check the integrity of the new application in the development process.
• Document the testing results using MS Office. Quick grasping power and adopt the new functionality easily.

Environment: Java, J2EE, JSP, EJB, XML, Oracle, I Macro, Manual Test