SUMMARY:

• Over 7+ years of experience in field of I.T in Analysis, Design, development, testing, and Implementation of Business Intelligence solutions using Data Warehouse/Data mart design, OLAP, ETL, Client/Server applications, Decision Support Systems (DSS) and Metadata repositories.
• Over 7 Years of extensive experience in ETL process using Informatica PowerCenter 8.6, 8.1/7.1/6.2/6.1 , Oracle SQL Tuning.
• Excellent working experience on complex DSS (Decision Support Systems) applications, directly responsible for the Extraction, Transformation and Load (ETL) of data from Legacy Systems using Informatica.
• Experience in Dimensional data modeling, Star schema modeling, Snowflake modeling, FACT and dimensional tables, Physical and logical data modeling, and primarily used Erwin for Data modeling.
• Proficient in understanding business processes / requirements and translating them into technical requirements and to estimate the required size of Database.
• Excellent verbal and communication skills clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Worked extensively with complex mappings using different transformations like Router transformations, stored procedure transformations, Source qualifiers, Union, Update strategy, unconnected & connected lookups, aggregator, and SCD type2.
• Experienced with session partitions using Informatica to increase the load performance and to meet the SLA time.
• Good working experience in creating and executing BTEQ scripts on Teradata environment and optimizing the queries for handling billions of data records on Teradata.
• Experienced with Informatica Power analyzer to generate the reports by accessing the metadata repositories.
• Extensive experience in Developing, debugging Informatica mappings. .
• Experienced in Data analysis, Data cleansing for maintaining data quality using Informatica Data quality and Data Explorer,Data Flux and trillium software.
• Experienced in Developing and Monitoring Nightly Batch Jobs using Autosys and UNIX Shell Script.
• Extensive experience in Performance Tuning using various techniques like Indexes, Hints, Partitioning, Data Analysis, Optimization, Tuning queries and Normalization techniques.
• Proficient in setting up Materialized Views/Snapshots for data replication across databases.
• Experience in data migration from legacy system to Oracle RDBMS.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Knowledge of ETL tools like Sql*Loader, Erwin.
• Proficient working experience in SQL, PL/SQL (Client and Server side Procedures, Functions, Packages, Objects, Triggers), Views, Relational Databases, MS SQL Server, MS Access and DTS (Data Transfer Services).
• Wrote UNIX shell scripts to encrypt flat files that are created by Oracle Job’s and to upload FTP the flat files to the designated server.
• Expertise in performance tuning using Explain Plans and Trace File methodologies (Used Toad Software for some clients).
• Written several SQL stored procedures while integrating Oracle data into the warehouse and for updating the Job entries.
• Worked with DBA for performance tuning of Informatica session for large data files.
• Extensively worked with large size Databases in Production environments.
• Experienced with Informatica versioning to maintain the different versions of mappings, sessions and workflows.
• Prepared the UTC documents and capturing the UTC results to validate the data after loading.

OLAP & Reporting Tools: Business Objects 6.5/5.1.6,Hyperion Brio, Oracle Reports 6i. Super Glue 1.5/2.x,Informatica Metadata manager

Language: Oracle PLSQL, Unix, Perl, Java, C,C++

Databases, Oracle 10g/9i, DB2, Sybase, MS SQL Server, Teradata V2R6.1, Teradata SQL Assistant 7.1, 12,13, MS Access

ETL Tools: Informatica PowerCenter 9.1,8.6, 8.1/7.1.3/6.2.2

Databases: Oracle 11g,10g/9i, DB2, Sybase, MS SQL Server, Teradata V2R6.1, Teradata SQL Assistant 7.1, 12,13, MS Access Server.

ENGAGEMENT SUMMARY:

Company: Confidential

Title: Senior ETL Developer.

Roles & Responsibilities:

• Implement and Enhance ETL programs using Informatica Power Center and Informatica Power Exchange against the Oracle 10g Data Warehouse.
• Contribute to technical architectural planning, data modeling, process flow documentation and the design and development of innovative solutions for the business.
• Create technical designs and mapping specifications.
• Work with both technical staff and business constituents to translate business requirements into technical solutions.
• Perform unit and system test/validation tasks.
• Maintain technical and user documentation.
• Provide on-call support of the Data Warehouse nightly processing
• Be an active participant in both technology and business initiatives.

Environment: Informatica Power Center 9.1, Oracle 10g/9i Erwin, Autosys, UNIX, Windows XP.

Confidential

Title: Senior ETL Developer.

• Designed ETL processes to load data from File source and Oracle into the target Teradata.
• Provide technical leadership to other support team members and resolution of technical issues
• Well versed in Informatica Partitioning concepts.
• Debugged mappings by creating Informatica Row Error Logging, sending error rows to error table so that they can be corrected and re-loaded into a target system
• Tuned existing Complex Informatica Mappings for Performance Optimization.
• Resoloved complex mappings/sessions issues coded using Informatica power center 7.1.3 and 8.6 for data loading.
• Fixed the invalid mapping's and troubleshoot the technical problems of the database.
• Good experience in creating BTEQ scripts using Teradata SQL assistant 7.1.
• Versatile in creating Mload and Fload scripts in UNIX environment for the sources being flat files and also for generating extract files.
• Involved in loading huge volume of data into teradata environment using T-Pump utility.
• Have good experience in teradata tuning the queries against huge volume of tables over tera-warehouse environment.
• As part of ETL CDE History load, loaded millions of rows from Teradata to Oracle database using Informatica Parition logic.
• Created JIL scripts for Autosys Scheduler.
• Proficient experience in working on conceptual, physical and logical data models(3NF) using various Data Modeling tool like Power Designer.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
• Involved in completely in Analysis and Development of modules Employee Summary of the project.
• Created and reviewed Logical and Conceptual Model with Business users, DBA’s and testing team.

Environment: Informatica Power Center 8.6.1, Teradata RDBMS V2R6, Oracle 10g/9i Erwin, Autosys,UNIX, Windows XP.

Company: Confidential, Boston, MA

Title: Senior Software Enigneer

Responsibilities:

• Participated in Logical data modeling sessions and provided the inputs to data modeler about the functionality of applications
• Involved in Source system analysis and history system analysis.
• Prepared Technical and ETL Design documents.
• Involved in Data profiling to maintain the data quality using Informatica Data quality tool.
• Prepared the Error handling and Audit strategy documents.
• Created the Informatica mappings using various transformations to maintain the history of the data.
• Extensively used parameter files to implement Incremental logic.
• Extensively used Test director to document test cases and Test results
• Created the work lets and workflows to run the jobs.
• Preparing the Deployment plan for moving the code to production environment.
• Supported the business after went go live.
• Created the metadata repository for managing the business terms, synonym sets product hierarchies, data sets and business rules.
• Created the change management requests for moving new attributes to the production environment.
• Good experience in creating BTEQ scripts using Teradata SQL assistant 7.1.
• Versatile in creating Mload and Fload scripts in UNIX environment for the sources being flat files and also for generating extract files.
• Involved in loading huge volume of data into teradata environment using T-Pump utility.
• Have good experience in teradata tuning the queries against huge volume of tables over tera-warehouse environment.
• Involved in resolving various data performance issues during development as well as in production.
• Experienced with IDQ 8.6 to maintain the data quality before loading into datawarehouse.

Environment: Informatica PowerCenter 8.6, Informatica Data Explorer, Informatica Data quality, Oracle 10g/9i Teradata V2R6,Teradata SQL Assistant, Business Objects, Erwin 4.1.4,Toad, UNIX, Windows XP.

Company: Confidential

Role: ETL Developer

Responsibilities:

• Participated in the data extraction from the different source legacy systems into the staging area.
• Prepared the Technical Specification document and participated in design review with Business analysts and Data architects.
• Creating the indexes based on the reporting requirement to speed up the query performance.
• Involved in Data profiling using Informatica Data explorer and Trillium tools.
• Involved in the ETL Design and testing the mappings in Test Repository.
• Moving the mappings from Dev to Test Repository.
• Created and loaded the summary tables using informatica for reporting users to increase the query performance.
• Preparing the Unit test case documents.
• Preparing the Deployment plan for moving the code to production environment.
• Supporting the business after went to live.
• Providing the Reporting solutions to the Business users.
• Analyzing the tables and materialized views and doing sanity checks.
• After Refresh from Production database, identifying the indexes created in logging mode and recreating the indexes.

Environment: Informatica7.1, Informatica Data Explorer , Data Quality, Oracle 9i, Toad, Business Objects, UNIX, Windows NT.

Company: Confidential

Role: ETL Developer

Responsibilities

• Gathering the requirements and doing the data analysis.
• Converting the requirements into high level design documents.
• Preparing the low level design documents and creating column to column mapping documents.
• Involved in Data profiling using Informatica Data explorer and Trillium tools.
• Involved in the ETL Development and testing the mappings in Test Repository.
• Moving the mappings from Dev to Test Repository.
• Created and loaded the summary tables using informatica for reporting users to increase the query performance.
• Scheduled the Informatica jobs through Informatica scheduler.
• Preparing the Unit test case documents.
• Preparing the Deployment plan for moving the code to production environment.
• Supporting the business after went to live by doing job monitoring and fixing the issues on priority basis to meet the Service level agreement.
• Creating the indexes based on the reporting requirement to speed up the query performance.
• Providing the Reporting solutions to the Business users.
• Creating the universes for different subject areas.
• Creating the complex reports based on the user requirements.

Environment: Environment: Informatica 7.1, MS SQL Server, SQL Navigator, Business Objects, Windows, Unix, Toad. Client:

Role: ETL Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
• Designed and developed ETL Processes based on business rules using Informatica Power Center.
• Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, and lookup and update strategy transformations.
• Was part of scripting team for shell script to automate and migrate data from ODS to Data warehouse.
• Created test cases and test scenarios and documented actual results.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.

Environment: Informatica Power Center 6.2.2, MS SQL Server, Oracle 9i/8.1.7, SQL Plus, PL/SQL, UNIX Shell Scripting,