SUMMARY:

• Over 9 years of experience in Information Technology with a strong back ground in Analyzing, Designing, Developing, Testing, and Implementing of Data Warehouse development in various domains such as Banking, Insurance, Medical, Health Care, Telecom
• Over 9 years of Data Warehousing experience using Informatica Power center 9.x/8.x/7.x/6.x, Informatica Power Mart 7.x/6.x, Power Connect, Power Exchange.
• Expertise in Database development skills using Oracle SQL, PL/SQL stored procedures, Functions, Packages, Triggers, Cursors
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling and Dimensional modeling techniques, Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs)
• Extensively worked on various Data warehouse projects using Informatica Client Tools - Source Analyzer, Transformation Developer, Workflow Manager, Workflow Monitor, Server Manager, Mapping Designer, Mapplet Designer and Warehouse Designer
• Expert knowledge in Trouble shooting and performance tuning at various levels such as source, mappings, target and sessions
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with administrator functions of Repository Manager
• Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys
• Expertise in designing and Developing complex Mappings using Informatica Power Center Transformations -Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, Sequence Generator and Slowly Changing Dimensions.
• Working experience in using Informatica Workflow Manager to create Sessions, Batches and schedule workflows and Worklets, Developing complex Mapplets, Worklets, Re-usable Tasks, Re-usable Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings & Workflows, Backup & Recovery, Power Exchange.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Data loading using UNIX Shell scripts, SQL*Loader
• Experience in dealing with various databases like Oracle … SQL Server … DB2Excel sheets, Flat Files and XML files
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Experienced in Data warehousing design concepts like star schema and snow flake schema
• Experienced in different kinds of OLTP and OLAP Systems
• Experienced in Analyze and preparing the Dashboard specification document
• Having good knowledge on BI Analytics
• Developing Abinitio Generic Graphs, psets, xfr's to SFTP files from various DDE server's to IDQ server
• Having good knowledge on Business objects, Qlikview, Tableau
• Strong communication and Interpersonal skills with capacity to collaborate with various stakeholders

TECHNICAL SKILLS:

ETL: Informatica 9.x/8.x/7.x/6.x, Ab-Initio and Business Objects Data Services (BODS 3.x)

Databases: Oracle 12g/11g/10g/9i/8i, SQL Server (2012), DB2, SAP BW and MS Access, Teradata V2R5/V2R6

Business Objects Suite: Business Objects 4.1/4.0/3.1/3.0/ R2 (Desktop Intelligence, Web Intelligence, Infoview /Launchpad, universe/Information Designer, Lifecycle Manager, CMC, QAAWS, Live Office, Crystal Reports, Dashboards)

BI Tools: Qlikview, Tableau

Software &Tools: SQL Server, TOAD, SQL Tools, Db visualizer

Scheduling tools: Autosys, Tivoli

Operating Systems: Windows NT/2003/2008R2/ Windows7/8, UNIX

PROFESSIONAL EXPERIENCE:

Confidential,Owings mills,MD

Sr. ETL Consultant

• Requirements Analysis, cost estimates, technical design creation and design reviews
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Extracted data from various centers with the data in different systems like Mainframe files and Flat files loaded the data into oracle staging using Informatica Power Center 9.1
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router and Update Strategy
• Implemented the concept of slowly changing dimensions (SCD) Type I and Type II to maintain current and historical data in the dimension
• Worked on BI Analytics for the data analysis
• Created critical re-usable transformations, mapplets and worklets wherever it is necessary
• Integrated IDQ mappings, rules as mapplets within Power Center Mappings
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL
• Wrote complex SQL Queries involving multiple tables with joins and also generated queries to check for consistency of the data in the tables and to update the tables as per the Business requirements
• Extensively used SQL tools like TOAD, Rapid SQL and Query Analyzer, to run SQL queries to validate the data
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data
• Implemented restart strategy and error handling techniques to recover failed sessions
• Used Unix Shell Scripts to automate pre-session and post-session processes
• Used Autosys scheduler to schedule and run Informatica workflows on a daily/weekly/monthly basis
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated
• Reviewed the defects raised by the UAT team and following up on the critical defects with the team to ensure to fix the defects

Environment: Informatica 9.1, Informatica Power Exchange, Oracle 12g, DB2, UNIX, SQL, PL/SQL, Db visualizer, Putty, Mainframe, Teradata

Confidential,San Francisco,CA

Sr. ETL Consultant

• Requirements Analysis, cost estimates, technical design creation and design reviews
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Extracted data from various centers with the data in different systems like Oracle Database and SQL Server and loaded the data into Teradata staging using Informatica Power Center 9.5.
• Involved in Migration from Informatica Power Center 9.3 to Informatica Power Center9.5
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Normalizer, Lookup, Filter, Joiner, Rank, Router and Update Strategy.
• Implemented the concept of slowly changing dimensions (SCD) Type I and Type II to maintain current and historical data in the dimension.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, duplicate elimination and exception handling and monitoring capabilities of IDQ.
• Created critical re-usable transformations, mapplets and worklets wherever it is necessary
• Integrated IDQ mappings, rules as mapplets within Power Center Mappings.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Wrote complex SQL Queries involving multiple tables with joins and also generated queries to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Extensively used SQL tools like TOAD, Rapid SQL and Query Analyzer, to run SQL queries to validate the data.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Used Autosys scheduler to schedule and run Informatica workflows on a daily/weekly/monthly basis.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated
• Reviewed the defects raised by the UAT team and following up on the critical defects with the team to ensure to fix the defects

Environment: Informatica 9.3/9.5, Informatica Data Quality (IDQ) Business objects, Oracle 11g, UNIX, PL/SQL, SQL, TOAD, Putty, Teradata

Confidential,Redwood city, CA

ETL Developer

• Interacted with Business Analysts for Requirement gathering, understanding the Requirements, Explanation of technical probabilities and Application flow.
• Developed ETL mappings, transformations using Informatica Power Center 9.1
• Extracted data from flat files, DB2 and loaded the data into Oracle staging using Informatica Power Center.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions (SCD) and also performed reading and loading high-volume Type 2 dimensions.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Implemented Incremental loading of mappings using Mapping Variables and Parameter Files.
• Experienced in designing and developing Informatica IDQ environment.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, duplicate elimination and exception handling and monitoring capabilities of IDQ.
• Used Mapping Parameters and Mapping Variables based on business rules provided.
• Wrote PL/SQL Procedures for data extractions, transformation and loading.
• Assisted in Data Modeling and Dimensional Data Modeling.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Scheduled workflow daily basis for incremental data loading.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements
• Scheduling jobs using Autosys to automate the Informatica Sessions.
• Provided Production Support at the end of every release.

Environment: Informatica Power center Designer 9.1, IDQ, Business objects(WebI), Oracle 10g/9i, Sql Server2000,Rapid-SQL, Toad, SQL *Loader, SQL, PL/SQL

Confidential

ETL Developer

• Used Informatica Power Center 8.6 for migrating data from various OLTP databases and other applications to the Radar Store Data Mart
• Worked with different sources like Relational, Mainframe (COBOL), XML, flat files (CSV) loaded the data into Oracle staging
• Created complex Informatica mappings with extensive use of Aggregator, Union, Filter, Router, Normalizer, Java, Joiner and Sequence generator transformations
• Created and used parameter files to perform different load processes using the same logic
• Extensively used PL/SQL for creation of stored procedures and worked with XML Targets, XSD's and DTD's
• Filtered Changed data using Power exchange CDC and loaded to the target
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables
• Used different Tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event-Wait and Control) in the creation of workflows
• Utilized the new utility Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE) that came up with Informatica Version 8
• Performed performance tuning of source level, target level, mappings and session
• Involved in modifying already existing UNIX scripts and used them to automate the scheduling process
• Coordinated with testing team to make testing team understand business and transformation rules being used throughout ETL process

Environment: Informatica Power center 8.6, Informatica Exchange, Oracle 9i, XML, UNIX, PL/SQL, Windows 2000/XP, Business objects

Confidential

ETL Developer

• Interacting with the end users to get all the incomplete requirements and developed client satisfied code
• Performed Source System Data analysis as per the Business Requirement. Distributed data residing in heterogeneous data sources is consolidated onto Teradata staging using Informatica Power Center 8.3
• Used heterogeneous data sources Oracle, DB2, and XML Files, Flat Files as source also imported stored procedures from Oracle for transformations.
• Developed Mappings, Sessions, Workflows and Shell Scripts to extract, validate, and transform data according to the business rules
• Identify the Fact tables and slowly changing dimensional (SCD) tables
• Extensively used SQL tools like TOAD, Rapid SQL and Query Analyzer, to run SQL queries to validate the data
• Sourced the data from XML files, flat files, SQL server tables and Oracle tables
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects. Partitioned the sessions to reduce the load time
• Performed data cleansing and cache optimization
• Change Data Capture for Incremental Aggregation
• Involved in review of the mappings and enhancements for better optimization of the Informatica mappings, sessions and workflows
• Extensively worked in performance tuning of programs, ETL procedures and processes
• Performed Unit, Systems and Regression Testing of the mappings. Involved in writing the Test Cases and also assisted the users in performing UAT
• Extensively used UNIX shell scripts to create the parameter files dynamically and scheduling jobs using Autosys
• Created integration services, repository services and migrated the repository objects
• Written PL/SQL procedures for processing business logic in the database
• Provided production support and maintenance for all the applications with the ETL process

Environment: Informatica Power Center 8.3, Oracle 10g, Teradata, SQL, PL/SQL, TOAD,UNIX, Windows 2000/XP

Confidential,Nashville,TN

ETL Developer

• Involved in requirements gathering, developing detailed designs and technical specifications
• Used Informatica as an ETL tool to extract data from multiple source systems by creating mappings using various transformations
• Developed and tested mappings, sessions, worklets and workflows
• Developing and modifying changes in mappings according to business logic and also tuned them for better performance
• Worked on complex data loading (implemented the batch data cleansing and data loading)
• Used BCP utility to publish table output to text files
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database to SQL Server
• Used Modification Language (DML) to insert and update data, satisfying the referential integrity constraints
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation
• Maintained a good client relationship by communicating daily status and weekly status of the project

Environment: Informatica Power Center 7.1.1, UNIX, Shell Scripting SQL Server 7.0/2000, Oracle 8 Enterprise Manager, SQL Profiler, DTS, PL/SQL, Replication

Confidential

ETL Developer

• Extensively worked on Power Center Client Tools like Repository Admin Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Analyzed the source data coming from different sources (Oracle, DB2, XML, QCARE, Flat files) and worked on developing ETL mappings
• Developed complex Informatica Mappings, reusable Mapplets and Transformations for different types of tests in research studies on daily and monthly basis
• Implemented mapping level optimization with best route possible without compromising with business requirements
• Created Sessions, reusable worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency
• Worked on fixing invalid Mappings, testing of Stored Procedures and Functions, and Integration Testing of Informatica Sessions
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level
• Worked extensively on SQL, PL/SQL, and UNIX shell scripting
• Generated XML files to deliver to Thompson Reuters
• Performed Data profiling for data quality purposes
• Proven Accountability including professional documentation, and weekly status report
• Performed Quantitative and Qualitative Data Testing
• Documented flowcharts for the ETL (Extract Transform and Load) flow of data using Microsoft Visio and created metadata documents for the Reports and the mappings developed and Unit test scenario documentation for the mentioned

Environment: Informatica Power Center 7.1.1, UNIX, Shell Scripting, Oracle 8 Enterprise Manager, SQL Profiler, DTS, PL/SQL, Replication

Confidential,Canada

Developer

• Involved in requirement gathering, documentation, change requests, designing, testing overseeing the development of agreed solutions and implementing new systems to meet the client business needs use the Advanced analysis for OLAP tool to create reports
• Negotiating to build a final consensus on a common set of requirements from all clients/stakeholders &defining scope of the project
• Fixing all the bugs that arises in production
• Deployment of the enhanced modules
• Perform regression testing on the deliverables preparation of the technical design documents interaction with the team members to track the progress of tasks
• Prepare the technical and business process documents for Bug fix, maintenance and development work

Environment: Business Objects 3.1, Web Intelligence 3.1, Desktop Intelligence, Oracle 10g

Confidential

Associate ETL Developer

• Extensively worked on Power Center Client Tools like Repository Admin Console, Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Analyzed the source data coming from different sources (Oracle, DB2, XML, QCARE, Flat files) and worked on developing ETL mappings
• Developed complex Informatica Mappings, reusable Mapplets and Transformations for different types of tests in research studies on daily and monthly basis
• Implemented mapping level optimization with best route possible without compromising with business requirements
• Created Sessions, reusable worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency
• Worked on fixing invalid Mappings, testing of Stored Procedures and Functions, and Integration Testing of Informatica Sessions
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level
• Worked extensively on SQL, PL/SQL, and UNIX shell scripting
• Generated XML files to deliver to Thompson Reuters
• Performed Data profiling for data quality purposes
• Proven Accountability including professional documentation, and weekly status report
• Performed Quantitative and Qualitative Data Testing
• Documented flowcharts for the ETL (Extract Transform and Load) flow of data using Microsoft Visio and created metadata documents for the Reports and the mappings developed and Unit test scenario documentation for the mentioned

Environment: Informatica Power Center 7.1.1, UNIX, Shell Scripting, Oracle 8 Enterprise Manager, SQL Profiler, DTS, PL/SQL, Replication