Experience Summary

• 8 years of total IT experience in Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL and Web applications on Windows and Unix platforms in various verticals such as Banking and Retail.
• Data warehousing experience using Informatica PowerCenter 9.1/8.6/8.1/7.2/6.1, Power Exchange/Navigator 8.1 (Creation of Data Maps to connect to VSAM Sources), ETL, Data Mart, OLAP, OLTP, Control M. Experience in Performance Tuning of sources, targets, mappings, transformations and sessions. Knowledge of Partitioning Data and session partitions.
• Strong Business Analysis experience on Data Analysis, Business Requirement Documents, Data Migration Documents, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis, Impact Analysis Documents.
• Experience in Data modeling, Erwin 4.5, Dimensional Modeling, Ralph Kimball Approach, Inmon, Hybrid, Star/Snowflake Modeling, DataMarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Database experience on Oracle 10g/9i/8i/8.x/7.x, Teradata V2R5, DB2, MS SQL Server 2005, SQL, XML, Stored Procedures and Triggers, SQL*Plus, SQL*Loader, Windows 95/98/2000.
• Experiences with databases with over 10 TB of data.
• Experience in Tuning Database using EXPLAIN PLAN, TKPROF, SQL TRACE and HINTS.
• Experience with Unix and Windows environment.
• Having Projected Scoping, Team Lead, Project Estimation and Project Execution Experience.
• Strong communication skills and project management capabilities.

ETL: Informatica 9.x/8.x /7.x/6.x(Power Center, Power Exchange), SQL Server 2005
Database: Oracle 9i/8.x, Teradata, DB2, MS SQL Server 2003/2005
Scheduling Tool: DAC (Data Warehouse Admin Console), Control M
Reporting Tool: Oracle Business Intelligence (OBIEE) 10.1.3X
Other Tools: TOAD 8.6, Unix Shell Scripting, SQL*Plus, MS Visio
Operating Systems: UNIX, Windows 95/98/NT/2000/XP/7, OSX
Misc: Agile Methodology, SDLC

PROFESSIONAL EXPERIENCE

Confidential,GA
ETL Developer

8/2010 – Till Date

Key responsibilities:

• Worked as developer managing multiple projects and also supporting monthly data loads in production.
• Creating technical specifications, reviewing source code and system test scripts and documenting the same in Quality Center.
• Member of the warehouse design team, assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings
• Creating UDF’s using mapping designer for Data Quality
• Development of mappings as per the technical specifications approved by the client.
• Created reusable transformations and mapplets to use in multiple mappings.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Extensively used type 1, type 2 and type 6 slowly changing dimensions to load data from various source systems, type 1 on daily basis.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in fine tuning queries for better performance using and using indexing and pre-joining and materializing views
• Involved in Unit testing, Integration testing and System testing of Informatica mappings.
• Extensively used Xml source qualifier, Mid-stream XML parser transformation, Mid-stream XML generator transformations, as one of our source type was XML Files.
• Implemented Error handling logic to capture the invalid data.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer
• Implemented various session tasks such as email task, command task etc. using workflow manager.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Worked on Control M tool for Enterprise wide job scheduling
• Design and Data load into Staging, Data warehouse and Data mart for Various reports.
• Creating the catalogs and analyzing the joins.
• Extensively used OBIEE for report generation.

Confidential,MN
Sr. ETL Developer

3/2009 – 7/2010

Key responsibilities:

• Involved in data analysis and development.
• Prepared mapping specifications documents, unit testing documents for developed Informatica mappings.
• Prepared mapping documents for loading the data from legacy system, flat files to staging area.
• Generated flat files using Informatica power center and extracted data from XML sources.
• Involved in parsing of XML documents to fetch the data from xml through PL/SQL and store in oracle tables.
• Prepared mapping documents for loading the data from staging area to ODS.
• Defined Target Load Order Plan for loading data into different Target Tables.
• Worked on Informatica Power center 8.5.1 Tool – Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformation.
• Involved in the design and development of mappings from legacy system to target data base.
• Involved in performance tuning of the mappings by doing necessary modification to reduce the load time.
• Defined test cases and prepared test plan for testing ODS jobs.
• Optimized Query Performance, Session Performance and Reliability.
• Used pmcmd, mailx command to execute jobs from UNIX platform.
• Coordinated with DBA team to resolve issues pertaining to load timings and any other database related issues which are hindering performance of loads.
• Supported UAT testing and production testing by identifying the bugs and also helped to resolve various Data issues, Load Issues.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Used Informatica debugger for data fixes. Coordinating with offshore team to resolve mapping and functional related issues.

Confidential,MI
ETL Developer

12/2007 – 3/2009

Key responsibilities:

• Reviewed the functional specification documents and involved in documenting technical specification.
• Development, testing and implementation of Informatica transformations and workflows for extracting the data from the multiple sources.
• Developed 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, Normalizer, Rank, and Router transformations.
• Used Power Exchange for SAP to load the transactional data into the Microsoft SQL server database through Informatica Power Center.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Used session partitions, dynamic cache memory, and index cache to improve the performance.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
• Implemented efficient and effective performance tuning procedures.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Automated load run on Informatica sessions through UNIX cron, PL/SQL scripts and implemented pre and post-session scripts, also automated load failures with successful notification through email.
• Used debugger to test the mapping and fixed the bugs.
• Developed SQL, PL/SQL stored procedures, database triggers and packages.
• Optimized SQL queries for better performance.
• Developed UNIX shell scripts for scheduling the workflows executions.

Confidential,India
Database Developer

10/2006 – 11/2007

Key responsibilities:

• Involved in developing Data warehouse using Star and Snow-flake Schemas.
• Involved in conversion process of historical data.
• Coordinate with team members to deliver products on timely basis, resolving issues to help in smooth development process
• Providing support for Integration testing, UAT, Regression testing
• Responsible for effective communication between the project team and the customer.
• Provide day to day direction to the project team and regular project status to the customer.
• Translate customer requirements into formal requirements and design documents, establish specific solutions and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Utilize in-depth knowledge of functional and Technical experience in Informatica and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Reviewing the Informatica mappings, sessions and workflows and database objects for standards.

Confidential,Banglore, India
Database Developer

8/2004 – 10/2006

Key responsibilities :
Developed SQL queries to check the database.
Creation of Triggers, Stored Procedures, Tables, Indexes, Rules, Defaults etc.
Interaction with users and getting the enhancement requirements.
Implementation and maintenance of the product in client sites.
Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Transformations Developer.
Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units info in tables.
Creating mappings and different kind of transformations like Source qualifier, Aggregators, lookups, Filters, Sequence Generator, Stored Procedure and Update strategy.
Involved in writing SQL Stored procedures to access data from Oracle 7.x

Education & Training

Bachelor of Technology