EXPERIENCE SUMMARY

• Experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
• Experience on Scripting and Programming using Unix Shell, HTML, DHTML, PL/SQL Stored Procedures, Triggers and Functions.
• 3 years of experience in Data modeling and architecture - Strong understanding of OLTP/OLAP System Study, Star schema, Snow flake schema, Conceptual, Logical Physical data modeling, Dimensional Modeling using ERwin
• Strong experience in installation, configuration and administration of Informatica Power Center and Power Mart Client, Server and designing/developing complex mappings, from varied transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Normalizer, Stored procedure, B2B transformation and more.
• Proficient in using Workflow Manager Tools such as Task Developer, Workflow Designer and Worklet Designer. Experience in performance tuning of sources, mappings, targets and sessions.
• Experience in working with various versions of Informatica Powercenter 9.1/8.6/8.5/8.1/7.1/6.2 Oracle warehouse Builder 10.2 Client and Server tools.
• Expertise in tuning the performance of mappings and sessions in Informatica and determining the performance bottlenecks.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2, Mainframes, xml templates.
• Strong experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T-SQL, DTS.
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.
• Thorough Knowledge of different OLAP's like DOLAP, MOLAP, ROLAP, HOLAP.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and knowledge in microstrategy.
• Knowledge in Installation and configuration of Informatica server with sql server, oracle and able to handle the Informatica administrator tasks like Configuring DSN, creating Connection Strings, copying moving mappings, workflows, creating folders etc.
• Experience includes thorough domain knowledge of Business Financial system, Banking, healthcare information technology, Insurance Reinsure, Pharmacy claims systems, Telecom Industry.

TECHNICAL SKILLS

Professional Experience:

Confidential

Lead ETL Developer

Confidential consists of multiple databases and application that convert data from transactional systems stored in oracle databases into a dimensional format stored in an oracle database. Added SFS accounting data to the data warehouse system. Confidential includes seven sub-models, tested SCD functionality.

Responsibilities:

• Modified/created database objects in target environment to match source environment.
• Changed processing strategy from truncate/insert to incremental load.
• Created a front end to write, generate, and deploy code.
• Provided an extensible environment openbookny.com , which allows relatively easy introduction of new resources.
• Captured and displayed the metadata that supports the ETL process.Created oracle procedure, mappings using OWB 10.2.
• Designed the ETL Specification for STG and DW Areas.
• Designed the ETL processes using OWB 10.2 to load data from multiple sources into the staging area.
• Developed mappings using OWB for data loading. Created Process flow, scheduled monitored session.
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Implemented various Performance Tuning Techniques on Sources, Targets, Mappings, Process flows and DB tuning.
• Troubleshooting database, workflows, mappings source and target to finds out the bottlenecks and improved the performance.

Environment: Oracle Warehouse Builder 10.2, Oracle 11, Lotus Notes8.5, Toad 6, SQL, PL/SQL, IBM AIX 5.3, Web Intelligence, XML, TOAD and UNIX Shell Scripts

Confidential

BI/Etl Developer

Confidential is a leading provider of insurance and other financial services throughout the world. The primary objective of this project is to develop Tampa DataMart for investment like securities and bonds using existing DWH. DM is developed in such a way that adjustments are applied directly by users with GUI.

Responsibilities:

• Involved in design development of operational data source and data marts in Oracle
• Reviewed source data and recommend data acquisition and transformation strategy
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle.
• Used Power mart Workflow Manager to design sessions, event wait/raise, and assignment, e-mail, and command to execute mappings
• Created parameter based mappings, Router and lookup transformations, Data transformations.
• Created mapplets to reuse the transformation in several mappings.
• Used Power mart Workflow Monitor to monitor the workflows.
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression and Lookups, b2b transformation.
• Created daily and weekly workflows and scheduled to run based on business needs.

Environment: Data modeling, Informatica PowerCenter 9.0, SQL Server SSIS,SSRS, Oracle 10g, Teradata 6, XML, TOAD,SQL, PL/SQL,IBM AIX, UNIX Shell Scripts, Web Intelligence, DSBASIC, Cognos, Erwin, STAR team, Remedy, Maestro job scheduler, Mercury Quality Center,Control-M

Confidential

BI/ETL Developer

Confidential is the leading direct provider of individual life insurance. The company, with its subsidiaries and affiliates, offers insurance products, investment products and advisory services that address client needs for financial security and protection, capital accumulation, asset distribution and estate preservation. This Data warehouse Application was built for the project was aimed at building a data mart for sales analysis which is called Sales Performance data mart . This ETL initiative gets data feeds from 9 source systems across the globe.

Responsibilities:

• Worked on Informatica Power Center 9.1 Source /targets /Transformations /Mappings /Mapplets/Sessions/Worklets/Workflows
• Implemented Business rules and logic using Source Qualifier, Expression, Filter, Lookup, Joiner, Rank, Router, Sequence Generator, Normalizer and Update strategy transformations.
• Developed MS-SQL procedure to implement the business rules.
• Optimized Informatica/SQL code performance by using best in SQL Informatica features
• Created Session tasks, workflows and worklets to execute mappings.
• Operations production support for ETL applications.
• Responsible for requirement gathering, analysis, estimation preparation for the bug fixes and enhancements.
• A single point of contact and responsible for deliverables.
• Responsible for management activities like status tracking, metrics gathering, preparation of status report, etc.
• Written shell scripts in UNIX to execute the workflow.
• Written shell scripts to run the workflows and automated them through maestro job scheduler.
• Responsible for submitting DBA requests, following up with data base DBA's and Informatica administrators, creating remedy ticket, handling all the singoff's for the production, updating all changes with new versions using START team, creating test cases using Quality Center.
• Written SQL Queries, Triggers, PL/SQL Procedures to apply and maintain the Business Rules.
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Defects were tracked, reviewed and analysed.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Development of Business Intelligence reports using BI tools Business Objects XI.

Environment: Data modeling, Business Objects XI ,data marts, Informatica PowerCenter 8.6,9.1, SQL Server 2008, Oracle 10g, Teradata 6, Web Intelligence, Toad 6, SQL, PL/SQL,IBM AIX, UNIX Shell Scripts, Cognos, Erwin, STAR team, Remedy, Maestro job scheduler, Mercury Quality Center

Confidential

ETL Specialist

Confidential warehouse is built to load the data of Customers, Loan Plans and Transactions from different sources through Informatica server and generating reports on quarterly basis to help the business Analysis's.

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouse.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files, XML files, and load into Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used DTS package to import and export data to from the data base.
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Worked with Reporting team to Generate reports using Cognos.
• Collaborated with Informatica Admin in process of Informatica Upgradation from PowerCenter 7.1 to PowerCenter 8.1.
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.
• Development of Business Intelligence reports using BI tools Business Objects XI.

Environment: Data modeling, data marts, Business Objects XI, Informatica PowerCenter 8.1, Data Stage 8.x, DSBASIC, XML, TOAD, Web Intelligence, Oracle 9i, Teradata, PL/SQL, SQL Server 2005, Flat files, Sql loader, UNIX Shell Scripts, Microstrategy 8,Data quality.cognos 8,control-M

Confidential

Informatica Developer

Confidential is one of the largest publicly traded global asset management firms in the world. The primary objective of the project was to construct an aggregated data warehouse DWH for analytics and reports used by business, risk management, asset management groups.

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Made use of mapping variables, mapping parameters and variable functions.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Export/Import data from different data bases, flat files using DTS package and BCP by defining source and target.
• Written SQL Queries, Triggers, PL/SQL Procedures, Packages and UNIX Shell Scripts to apply and maintain the Business Rules.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Generated reports using cognos.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
• Created reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports

Environment: Informatica PowerCenter 7.1, Informatica Power Exchange, Data Stage 7.x, SQL Server 2000, Teradata 6, Oracle 9i, XML ,Toad , DB2,SQL, PL/SQL, Mainframes, Sun Solaris2.6, UNIX Shell Scripts, Business Cognos 8, Erwin, Autosys, Remedy.

Confidential ETL Developer

Confidential is a research-based company engaged in the discovery, development, manufacturing and marketing of pharmaceutical products worldwide. The project primarily dealt with building sales data warehouse, creating sales reports.

Responsibilities:

• Designed technical layout considering Standardization, Reusability, and Scope to improve if need be.
• Documented the purpose of Data Warehouse including transformations, mapplets, mappings, sessions, and batches so as to facilitate the personnel to understand the process and incorporate the changes as when necessary.
• Developed complex mappings to extract source data from heterogeneous databases SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and pl/sql code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT User Acceptance Testing with user community.
• Developed to run from Informatica pre-session, post session commands. Set up on Success and on Failure emails to send reports to the team.

Environment: Informatica PowerCenter 7.1,Oracle Warehouse Builder 9.2, Oracle9i, SQL Server 2000, XML, TOAD, HP Unix, sunopsis, Cognos Report Net.

Confidential ETL Developer

Confidential is an Offshore outsourcing Company Headquartered in Chennai, India providing IT services

Responsibilities:

• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Created new mappings according to business rules to extract data from different sources, transform and load target databases.
• Debugged the failed mappings and fixed them.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Modified the mappings according to the new changes and implemented the persistent cache in several mappings for better performance.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Identified the issues in sources, targets, mappings and sessions and tuned them to improve performance.
• Created and used reusable mapplets and worklets to reduce the redundancy.
• Developed robust Informatica mappings and fine-tuned them to process lot of input records.

Environment: Informatica power center 6.2, Oracle9i, SQL, PL/SQL, Solaris2.5, MS Vision, Ms-Access