SUMMARY

• 8+ years of IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Financial, Pharmaceutical, Insurance and Telecom Industries.
• Informatica: 6 years of Data Warehousing experience using Informatica Power Center 8.6.1/8.1.1/7.1.1/7.0/6.1 , PowerMart5.1.1/5.x,WarehouseDesigner,Power Exchange, OLAP, OLTP, Autosys, Control M, Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Data Analysis strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Data Modeling experience on Data modeling, ERwin 7.1/4.5/4.0/3.5.5/3.5.2 , Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.
• Data Cleansing experience using Trillium 7.6/6.5 (Converter, Parser, Converter & Geocoder), Firstlogic 4.2/3.6, UNIX Shell Scripting and SQL coding.
• Business Intelligence experience using OBIEE10.1, Cognos Series 8.3/7.0, Business Objects XI R2/6.5/5.1, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), SQL Server Integration Server (SSIS), MS Access Reports.
• Methodologies: Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Databases using Extract data Oracle 11g, Oracle 10g/9i/8i/7.0, DB 2 8.0/7.0/6.0 , MS SQL Server 2005/2000/7.0/6.0 , Teradata V2R5/V2R4/V2R3, MS Access 7.0/2000.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.6.1/8.1.1/7.1.2/7.1.1/7.0/6.1 , Power Mart5.1.1/5.x, Informatica Power Connect, Informatica Designer, Workflow Manager, Work flow Monitor, Datamart, OLAP, OLTP,Mapplet, Transformations, Autosys, Control M, SQL*Plus, SQL*Loader, Netezza 6.0

Data Analysis: Requirement Analysis, Business Analysis, detail design, data flow diagrams, data definition table, Business Rules, data modeling, Data Warehousing, system integration.

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7.1/4.5/4.0/3.5/3.2

BI Tools: OBIEE10.1, Cognos Series 8.3/7.0

Databases: Netezza 6.0, Oracle Exadata 11g, Oracle 10g/9i/8i/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/ 2000/7.0/6.0 , Teradata V2R6/V2R5 MS Access.

Programming GUI: SQL, PL/SQL, SQL Plus, Unix Shell Scripting, PERL Programming

Environment: Sun Solaris 2.6/2.7/2.8/8.0 , HP-UX 10.20/9.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, Sun Classic, HP9000, RS6000, Win 3.x/95/98, Win 2000, Win XP. MS-Dos

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Experience with implementing ETL processes and Data Warehousing methods and technologies.
• Used Informatica client toolsSource Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository ManagerandInformatica Workflow Managerand OBI Tools.
• Create mappings with shared objects/Reusable Transformations/Mappletsusing Mapping/Mapplet/Parameters/Variables.
• Cleansing and processing data from stage toData martsusing Informatica transformations.
• DesignedSCD Type 1andType 2mappings.
• Extensively used transformations like lookup, Router, Aggregator, sequence generator, filter, update strategy, joiner.
• Using Incremental method strategy for all Informatica mappings.
• Used SQL to query the database and involved in SQL optimization of existing queries.
• Extensively worked in the performance tuning of programs,ETL proceduresand processes.
• UsedDebuggerto test thedata flowandfix the mappings.
• Develop high level and detailed level technical and functional documents and data modeling document. Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, mask the data needed and Load it into data marts.
• Bulk load the database tables from flat files usingOracle SQL Loader.
• Provide test data inQA/UATfor the downstream application testing.
• Created SSIS Packages to migrate slowly changing dimensions.
• Worked on usingSSIStools like Import and Export Wizard, Package Installation.
• Integrated various sources into the Staging area in Data warehouse
• Provided production support to schedule and execute production batch jobs and analyzed log files in Informatica8.6/& 9.1Integration servers.
• Experience in writing Business System Design Documents (BSD).
• Designed a process using GPG commands and Informatica command prompt to encrypt and decrypt the files.

Confidential, MD

Senior ETL Consultant

Responsibilities:

• Extensively Working on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Using InformaticaPowercenter8.6and9.1to make the changes to the existing ETL mappings in each of the environments.
• Involved in the migration ofInformatica8.6workflowsintoInformatica9.1version.
• WrotePL/SQLprocedures which are called fromStored Proceduretransformation to perform database actions such as truncate the target before load delete records based on a condition and rename the tables.
• Create ETL mappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter,Normalizer,SQL Transformation,Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.
• Extensively worked on building workflows, worklets, sessions, command tasks etc.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Proficient in implementing all transformations available on the SSIS toolbox.
• UsingSourceQualifier&Lookup SQLoverrides,Persistentcaches, Incremental Aggregation, Partitions, Parameter Files etcfor better performance.
• Created sessions to usepre & post sessions stored proceduresto truncate the tables, drop & create indexes on tables for bulk loading.
• Working on change requests to the existing processes in production.
• Created SSIS Packages to migrate slowly changing dimensions.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• UsedEvent wait Task, Control Task, Email Tasks, Command Tasks, Link conditionsin workflows.
• Bulk load the database tables from flat files usingOracle SQL Loader.
• Working on creating & modifying theunix shell scripts.
• Development of dashboards, reports and OBIEE repository.
• Provide test data inQA/UATfor the downstream application testing.
• Worked on setting up column level security for the OBIEE Reports and also handled the security and privileges from the Database to the Oracle repository.
• Extensively worked on the Repository Manager to create/modify/delete users/group/roles.
• Involved in running the loads to the data warehouse and data mart involving different environments.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, mask the data needed and Load it into data marts.
• Extensively used PL/SQL, TOAD programming in backend and front-end functions, procedures, packages to implement business rules.
• Integrated various sources into the Staging area in Data warehouse
• Provided production support to schedule and execute production batch jobs and analyzed log files in Informatica8.6/& 9.1Integration servers.
• Developed shell scripts to automate the data loading process and to cleanse the flat file inputs

Environment: Informatica Power Center 9.1, Netezza, Oracle11g/10g, OBIEE, SQL, PL/SQL, SQL*Loader, Toad, UNIX Shell Script, Win XP, Business ObjectsXiR2.

Confidential, Richmond,VA

ETL/Informatica Developer

Responsibilities:

• Wrote unix scripts to call the files from Landing zone and process the files.
• Created PRE ETL scripts to validate the files and file format which we receive from the Source system.
• Extracted data from flat files applied business logic to load them in the staging database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.6.1.
• Wrote Oracle packages and functions to implement business rules and transformations after staging is done.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Used Informatica Power Center 8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented populate slowly changing dimension to maintain current information and history information in warehouse tables.
• Used SSIS packages to load date from spreadsheet into the database and also used packages to move data between databases (oracle, flat-files) on different servers.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Worked on different data sources such as Oracle, Teradata, Flat files etc.
• Created complex mappings in Power Center Designer using Normalizer, Aggregator, Router, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner.
• Developed Jil files for scheduling the informatica configuration in Autosys.
• Created Informatica Mappings to populate the data into dimensions and fact tables using Oracle BI Apps.
• Working knowledge on DataWareHouse Admin Console (DAC) to schedule jobs for Fact and Dimension tables.
• Wrote Oracle packages and functions to validate the Pre and Post Exceptions in the process of sending Exception files and Response files to Source System.
• Extensively used Java and CLOB files to Extract the files in the process of sending files to Source System.
• Wrote scripts to transmit Exception and Response files back to source system using NDM/FTP processes.
• Created Tables, Views and Packages in DEV and SIT environment.
• Created Load Status Report, Load Status Report - Detail, Load Distribution Report, Load Performance Report to find the status of jobs across all verticals using OBIEE.
• Implemented DataLevel Security and Purging in OBIEE using appropriate Hierarchy joins.
• Responsible for validated System Integration Testing for the code developed.
• Used HP Quality Center 9.2, prepared test case documents, test plans and validated the test cases in HP Quality Center 9.2
• Prepared Technical design documents, High Level Design documents and Low Level Design Documents.

Environment: Informatica Power Center/ Power Mart 8.6.1, Oracle Exadata 11g, Teradata, OBIEE, Oracle BI DAC, SSIS, Erwin, Toad, HP Quality Center 9.2, Autosys, Team Foundation Server (TFS), WinSCP, Filezella, Windows 2003, UNIX, LINUX, Microsoft Visio.

Confidential, Chicago

Sr Data warehouse Developer (ETL / Informatica)

Responsibilities:

• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 7.1.4/8.6.0.
• Knowledge in upgrading from Informatica version 7.1.4 to 8.6.0.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.0./7.1.4 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center/ Power Mart 8.6.1/7.1.4 , Oracle 10g/9i, Erwin, UDB DB2 8.1, Windows 2003, UNIX,PL/SQL

Confidential, VA

ETL/DW Developer

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles
• Extracted data from different sources likeDB2, Sql server, flat files and loaded into DWH
• Created complex mappings in Power Center Designer usingExpression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables
• Wrote SQL, PL/SQL, stored proceduresfor implementing business rules and transformations
• Used data miner to process raw data from flat files
• Used the update strategy to effectively migrate data from source to target
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Used Informatica PowerCenter Workflow to create sessions and run the logic embedded in the mappings.
• Created test cases and completed unit, integration and system tests for Data warehouse

Environment: Informatica PowerCenter 8.1.1/7.x (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Cognos Series 8.3/7.0, Teradata, Flat files, DB2, SQL server 2005, SSIS, SQL, PL/SQL,Win 2000.

Confidential

PL/SQL Developer

Responsibilities:

• Created database objects like tables, views, synonyms, indexes, and sequences. Developed PL/SQL procedures and functions to migrate data between Oracle Databases.
• Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors and loops. Loaded and unloaded data sets from or to Oracle Databases using TOAD.
• Worked on Performance tuning and optimization of SQL Statements using Explain Plan
• Experience in testing the module, creating test plans and technical design specification documents.

Environment: Oracle8i, PL/SQL, TOAD, Test Director.

Confidential

Software Test Engineer

Responsibilities:

• Understanding the Scenarios based on Joint Requirement Document.
• Involved in Daily status calls held with Onshore Business Team, SME and off shore Development Team.
• Actively involved in Preparing Scenarios, Preparing and executing Test Cases, Defect Tracking.
• Responsible for Sanity Testing, Regression testing and Functional Testing, Browser Compatibility Testing, Accessibility Testing.
• Preparing Daily Status Reports.
• Coordinating with different teams like development, testing teams of different integrated applications and also the data team, as many teams are involved in it.
• Helping other teams of project like Progression and Regression in planning and execution phase.
• Analysis of the specifications provided by the clients and coordinating with onsite coordinator for the same.
• Performed Sanity testing, Ad-Hoc testing of the application builds,
• Involved in defects tracking and Defect Verification activities for the web based application.
• Involved in adding the requirements in Requirements tab and done the requirement mapping for the planned test cases in QC.

Environment: Java, Oracle, HP ALM (Testing tool)