SUMMARY

• Around 8 years of work experience in IT Industry in Analysis, Development, Functional Studies, Quality Reviews, Testing and Maintenance of various software applications in Data warehouse environment.
• Strong experience in providing Business Intelligence solutions using Informatica Power Center 9.x/8.x.
• Extensively worked in creating PL/SQL Stored Procedures, Functions, Cursors, Indexes and Triggers and involved in Query Optimization in SQLServer 2012/10/08/05/00 .
• Good knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate keys.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, XML files, Main Frame (Power Exchange) and worked on integrating data from flat files like fixed width and delimited.
• Strong experience in activities related to the development, implementation and support of ETL processes for large-scale data warehouses using Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse/Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifier, Expression, Filter, Joiner, Router, Union, Unconnected/Connected Lookups and Aggregator.
• Strong Experience in developing Sessions/Tasks, Workflows, Worklets, using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Good at CRM knowledge and Understands the basic components of CRM system like Account, Contact, Users, Call Center, Book and Product etc.
• Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session Partitioning, Load Strategies, Commit Intervals and Transformation Tuning.
• Experience in using the Informatica command line utilities like PMCMD (both Command Line and Interactive modes) to control the workflows and PMREP (both Command Line and Interactive modes) to manage the Repositories in non-windows environments.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Good experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Gained exposure on other ETL tools like SQLServer - DTS, SSIS, Import and Export Wizard.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Experienced at Learner level in creating personalized version of reports in Business Objects (XI R2) as well as statements for customers using the data from Informatica metadata.
• Good team spirit and organized working habits with a willingness to learn new concepts
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x, SQLServer - DTS, SSIS, Import and Export Wizard

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2012/10/08/05/00

Procedural Languages: PL/SQL, T-SQL

Scripting: UNIX Shell Scripting

Operating Systems: Windows NT/9x/2000/XP/7

OLAP Tools (Learner level): Business Objects (XI R2), Crystal Reports, Cognos

PROFESSIONAL EXPERIENCE

Confidential

Associate - Projects/ETL Developer

Responsibilities:

• Involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, data architects and application developer to develop a data model.
• Involved in designing the Fact and Dimensions Tables.
• Prepared the required application design documents based on functionality required.
• Created Entity Relationship (ER) diagrams based on requirements.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using SQL Procedures for populating the desired.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems according to the user requirements.

Environment: SQLServer 2012, SQL, PL/SQL, Windows XP/7

Confidential

Associate - Projects/ETL Developer

Responsibilities:

• Understanding business process and user requirements.
• Involved in creating the Design and Mapping specifications for the ETL process based on Functional specifications.
• Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to Staging and Staging to target database.
• Analyze the existing process for product specific and design for enhancements.
• Attending to Change Requests and Issues in existing frameworks.
• Performance tuning of long running Informatica jobs and SQL queries.
• Utilized Informatica, UNIX and Oracle in combination with our internal tools E-Tracker, AQUA and Q-Smart for carrying out software quality assurance activities.
• Prepared the Test Plan and Test Cases as part of unit testing
• Took part in migration of Informatica components from 8.6.1 to 9.0.1.
• Creating relevant understanding documents for newly developed systems and process.
• Responsible for mentoring and providing KT to PATs joining the project.

Environment: Informatica Power Center 8.6.x/9.x, Oracle 10g/11g, UNIX, SQL, PL/SQL, Windows XP/7

Confidential

Programmer Analyst/SQL Developer

Responsibilities:

• Involved in discussions held with the onsite coordinators during analysis and design phase and documented them.
• Planned and managed daily meetings with the team and in status call with the onsite team on meeting the requirements
• Played the role of Developer and involved in analyzing the Technical Design document
• Developed Crystal Reports and BO reports, SQL Procedures as per the specifications and involved in reviewing the SQL code and whole report
• Involved in developing SSIS packages.
• Involved in preparation of test plans and test cases as a part of unit testing
• Coordinated Off-shore and Onsite activities

Environment: PL/SQL, SQL Server 2005, SSIS, DTS, Import and Export wizard, Business Objects (XI R2), Crystal Reports, Windows XP

Confidential

Senior Software Engineer/SQL Developer

Responsibilities:

• Responsible for Development & Enhancement of Informatica mappings, SQL Procedures and BO reports.
• Handled tickets and enhancements that come from users through Clarify tool ( Confidential provided tool for ticket tracking).
• Played an active role in Requirement Analysis and Estimation for mappings and reports.
• Responsible for monitoring data warehouse loads in Informatica that involves scheduling for Informatica mappings.
• Created new Informatica mappings based on the user requirement and did minor enhancements and break fixes in the existing mappings.
• Involved in the preparation of Test Cases for individual mappings that are developed.
• Documentations created as per the user requirement.
• Involved in peer review of BO reports and Informatica mappings.
• Created and maintained several custom reports for client using BO.
• Design new as per the user requirement and break fixes the existing report.

Environment: Informatica 8.1, PL/SQL, SQL Server 2008/00, SSIS, DTS, Import and Export wizard, Business Objects (XI R2), Edit plus, Windows XP