Professional Summary

• 8 years of total IT experience in the business requirements analysis, application design, dimensional data modeling, data modeling, designing, coding, development, testing and implementation of business applications with RDBMS, Data Warehouse/Data marts, ETL, and client/server environment applications for insurance, pharmaceutical, financial and hospitability.
• 6 years of experience working on End-To-End implementation of Data warehouse
• 6six years of strong experience in Data Warehousing and ETL using InformaticaPowerCenter9.1/8.6/8.1/7.1.3/7.0/6.2/5.1, InformaticaPowerMart6.2/5.1/4.7.
• Strong experience in designing the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake,data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT dimensions tables, physical logical data modeling.
• Good programming experience in Transact SQL, SQL, PL/SQL, Complex Stored Procedures, Triggers.
• Three years of hands on experience working with scheduling tools like Auto sys, Control M.
• Experience in working with multiple RDBMS including Oracle 11i/9i/8i, SQL Server, Teradata and MS Access.
• Strong expertise on the various data design models like Star Schema and Snowflake models.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development process

Technical Skills:

• ETL: Informatica Power center 7.1.2/6.x/5.x
• Databases: Oracle 11.i/9.i/8.x/7.i, Teradata, SQL Server, DB2, MS Access.
• Packages: SQL PLUS, Toad 7.x, SQL Navigator 4.
• Languages: C, C , Visual Basic, SQL, UNIX Shell Ksh/Csh , PL/SQL. Operating system: Windows 95/98/00/XP, vista , WinNT, UNIX.
• Data Modeling Tools: ERWIN 4.5/4.0/3.5/3.2.,ER Studio.
• GUI: Visual Basic 6.0/5.0.
• Web technologies: HTML, DHTML, XML.

Professional Experience:

Confidential

Role: ETLDeveloper

Responsibilities:

• Contacting the Business Analysts/Users to develop, document and to evolve process and data models based upon their input and feedback
• Working with different source systems like SAP R3 , AS400 , flat files, Oracle
• Worked as lead for the particular schema development, team consists of 4 developers.
• Experience in Agile methodology
• Experience translating business requirements into Conceptual and Logical Process and Data Models.
• Experience in preparing Logical data models as well as Physical data models and document the same
• Created reusable transformations for converting varchar into upper case and string to date
• Created Mapplet for history management dates ,ETL Process status
• Created mapping for error handling sessions
• Participated in Data modeling meetings, helped to identify the relationship between tables according to the requirements
• Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart and refresh strategies
• Created mapping for creating a parameter file
• Worked with DBA's to design and build the Staging/Target databases
• Assisted business users for data cleansing and user acceptance testing
• Worked in Informatica for the Extraction, Transformation and Loading from various sources to the enterprise datawarehouse
• Developed and tested extraction, transformation, and load ETL processes
• Working with Control-M scheduling tool to schedule the production jobs.
• Involved in change data capture CDC ETL process
• Created sessions and workflows for the source to staging data flow and staging to Target loading
• Implemented TypeII changes for different Dimensions
• Developed functions and stored procedures to aid complex mappings

Environment: Informatica Power Center 9.1, 8.6, Oracle 9i, SQL developer, TOAD, Control-M, Windows NT/XP, HP Quality center 10.0.

Confidential

Role: Informatica Developer

Responsibilities:

• Interacted with Business analyst, SAP developers, Clarify Customer service team developers and SAP Functional consultants to identify the business requirements and data realties.
• Worked with Functional consultant and SAP developers to design the function modules for extract the data from SAP R3 systems.
• Imported Source/Target tables from the respective SAP R3 and BW systems and created reusable transformations Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator inside a mapplet and created new mappings using Designer module of Informatica Power Center to implement the business logic and to load the customer healthcare data incrementally and full.
• Created Complex mappings using Unconnected Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Worked on SQL tools like PLSQL Developer/SQL Plus/MS SQL Visual studio to run SQL queries and validates the data.
• Used Control-M as a scheduler tool to schedule the production workflows.
• Oracle and then loading to external targets like SQL Server and Flat files.
• Transparent Z Table in SAP tables for Migration /Loading of Data from SAP R3, SAP BW to
• Extensively used Experience in working with SAP Developers to create Function modules or
• Used Shortcuts Global/Local to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Worked along with SAP Functional team on SAP Solution manager and service manager tool for transferring or Transporting programs from one level to another level in SAP Landscape like Development, UAT, Regression testing and Production .
• Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions by creating multiple sessions on primary key values by using partition query.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Provided production support by monitoring the processes running daily.
• Scheduled the Jobs by using Informatica scheduler.

Environment: Informatica PowerCenter 9.0.1/8.6.1/7.1.4, IDQ 9.0.1/8.6.1, Power Mart, IDE, Power center Repository Manger, Designer, OLAP, Service Manager, Workflow Monitor, Workflow Manager ,Business Objects XI/6.0,Cognos 7,Control-M, Erwin 4.5,Oracle 11.5/10g, SQL, PL/SQL Developer, WINSQL, MS SQL Server 2005/2000,SSIS,Database Systems, Flat Files, Siebel, SAP ABAP, Windows XP, UNIX Shell Scripting, Perl, Autosys, SQL Loader, Microsoft visual studio, HTML 4,DT and DX, Syncsort for UNIX/Windows.

Confidential

Role: ETLDeveloper

Responsibilities:

• Attend meetings and gathered business requirements.
• Design, develop and implemented of the SSRDM.
• Use debugger to test the mapping and fixed the bugs.
• Working with UNIX shell scripting.
• Develop Mapplets using corresponding Source, Targets and Transformations.
• Tune Informatica Mappings and Sessions for optimum performance.
• Solely responsible for IMS Data and converting those to require structure using Informatica.
• Working on TIBCO for data integration.
• Develop and tune all the Affiliations received from IMS and other data sources using Informatica and tested with high volume of data.
• name containing duplicate rows which are deleted using aggregator.
• In a map I had to load department table and employee table .Under constraint based loading first it loads employee table and then department table as it contains the foreign key.
• I have validated the address of pharmacists and hospitals using trillium.
• In sales table if we find more employees selling the same product and I used rank transformation to find the first 10 employee who is selling more products.
• Use power exchange CDC which captures changes in the sources and loads those changes into the customer dimension.
• Working with control-M scheduler.
• Create database triggers for Data Security.
• Using Data Flux in data management software and business consulting services.
• Assist in writing project documentation used Microsoft Visio for different diagrams.

Used Autosys for scheduling the jobs. Environment: Informatica Power Center 8.6, Informatica PowerConnect, Repository Manger, Designer, Server Manager, Workflow Monitor, Workflow Manager , PowerExchange, Superglue, ETL, Flat files, Oracle 11g/10g, MS SQL Server 2008, PL/SQL, Autosys, Shell Programming ,TIBCO,SQL Loader, Toad, Excel and Unix scripting, Sun Solaris, Windows 2002.

Confidential

Role: DW Informatica Developer

Confidential has a long and unrivaled history as a provider of financial services throughout the worldConfidential offers their customers personal service and the advantages of a local bank, while their global platform allows them to introduce a continuous stream of new and innovative products quickly and more cost-effectively than their competitors. This project is developed for Sales Marketing and Finance Departments to assist them in their business Analysis.

Responsibilities:

• Attend meetings and got the business requirements.
• Update maps, sessions and workflows as a part of ETL change.
• Develop and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Wrote UNIX shell scripts for various purposes.
• Create maps, sessions, tasks and workflows as a part of starcom and aero plan project.
• Schedule the workflows in the workflow manager.
• Call stored procedures in oracle as pre sql session.
• Create reusable failure and success email tasks.
• Lead the team in my projects.
• Did production support for all starcom and aeroplan jobs.
• Cached up all informatics jobs along with my team.
• Use trillium software to remove duplicates from the data.
• Good knowledge on Informatica administration work.
• Used Control-M scheduling tool in Preprod repository to run the workflows.
• ETL Job daily verification.
• Design and develop Oracle PL/SQL Procedures and wrote SQL, PL/SQL scripts code for extracting data to system.
• Work on SQL tools like TOAD to run SQL Queries to validate the data.
• Create job status report in excel sheet during weekends.
• Working with slowly changing dimensions type 1,2,3.
• I had to used change data capture to get only new and updated records from ODS and load the shadow table.
• Modifications to existing ETL Code and document the changes.
• Download Informatica power center 8.6 clients.
• Downloadoracle10g client and toad 9.0.
• Upgrade from Informatica power center 8.1 to Informatica power center 8.6.

• Create repositories in development, QA and production environment.

Environment: Informatica Power Center 8.6, Informatica Power Connect, Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager , Power Exchange, Power Analyzer, ETL, Oracle 11g/10g,Teradata V2R5, PL/SQL,ODI, Unix commands, Trillium 11,Control-M Excel and shell scripting, MS Windows XP professional 2002,UNIX.

Confidential

Role: DW InformaticaDeveloper

Responsibilities:

• Analyze the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Tune Informatica mappings for optimum performance.
• Provide Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mapping.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic. Created Mapplet and used them in different Mappings.
• Create events and tasks in the work flows using workflow manager.
• Use shell scripts for automating the execution of maps.
• Design and developed Oracle PL/SQL Scripts for Data Import/Export, Data Conversions and Data cleansing.
• Did data cleansing using trillium such as converting male into M and female into F.
• Generate reports using Cognos Impromptu tools querying database.
• Design and deployed in Perl.

Environment: Informatica PowerCenter 5.1/6.2, Server Manager, Power Connect, Erwin 3.5, Control M, Siebel 2000, PL/SQL, Oracle 8i, SQL Server 2000, DB2 7.0, HP-UX 10.20, Windows NT 4.0.

ETL Developer

Responsibilities:

• Creating Database objects and managing the resources.
• Exporting and importing data using Export/Import utilities.
• Using Explain Plan and oracle optimizer hints to enhance performance of SQL statements.
• Implementation of a backup strategy.
• Generate completion messages and status reports using Informatica.
• Tune ETL procedures and STAR schemas to optimize load and query Performance.
• Design and tested the dimensional tables, ODS tables.
• Built interface with existing Legacy system.
• Carried out weekly reviews, technical reviews, made weekly progress reports.
• Act as primary point of contact between customer and core development team.
• Acting as configuration controller.
• Configuring TNSNAMES.ORA and LISTENER.ORA for Client Server Connections.

Environment: Win NT/00, Oracle 8.1, Informatica, Oracle Developer 2000 Forms and Reports.

ETL Developer

Project Description

Responsibilities:

• Analysis of the specifications.
• MaintainMeta data in the repository.
• Document all Meta data dictionary.
• Designer Mapping Designer and Mapplet, and Transformations.
• Preparing mapping documents.
• Extracting Data from source to target using Informatica
• Testing - unit testing integration testing.
• UNIX and Perl scripts for Screen Door Programs.

Environment: Flat files, MS SQL Server 2000, PL/SQL, Reporting Services 2000, Autosys, DOS commands, Excel and batch scripting, DOS, MS Windows 2000.