SUMMARY:

• 0ver 10 years of experience in Analysis, Design, development and implementation of Client/Server and Data warehousing using Informatica Power Center 9x/ 8.5.1/8.1.1 /7.1.4/7.1.2/6.2/6.1/5.1 , Power connect 8.1.1, Power Mart 6.1/5.1(Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations), ETL, OLTP, OLAP and Erwin, Business Objects, OBIEE and Oracle and Oracle Business Intelligence, MS SQL server applications on windows
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.
• Experience in integration of various data sources like Oracle, SQL server, Teradata and MS access into staging area and involved in SDLC for the projects.
• Expertise experience in design and development of decision support systems (DSS) and experience in Release management and Production Deployment activities, Production support.
• Expertise in Data warehousing, Data migration and Data modeling
• Data Modeling knowledge using Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables.
• Experience in Business Objects5.1 (supervisor, designer, and reports), data integrator Experience in Hyperion Essbase (Analyzer, Reports, Intelligence)
• Experience in working with Oracle BI/Siebel Dashboards, Oracle BI Answers, Oracle BI Publisher, Oracle BI Delivers and Oracle BI iBots.
• Extensive knowledge in Customizing repository(Rpd), configuring Metadata objects (Subject Area, Logical tables, Column) and Web Catalog Objects (Dashboards, Pages, Folders, Reports).
• Experience in configuring Interactive Dashboards with drill-down capabilities using Filters and Dashboards Prompts, OBIEE Security Setup (groups, access privileges).
• Scheduled and managed Informatica Tasks and workflows in Siebel Oracle BI using the Siebel DAC (Data Warehouse Application Console)
• As a part of universe development, created classes, different kinds of objects, cardinalities, strategies using designer in business objects.
• Experience in Migration from ONYX to SFDC. Experience with Outlook implementations.
• Involved in configuration and customization with SF.com
• Extensively worked on SAP r/3 source system (ABAP Functional Modules)
• Extensively worked on BAPI mappings and RFC enabled functional modules using Informatica Power connect adaptor.
• Extensively worked on Salesforce, apex explore. Designed and developed Informatica Mappings for salesforce. Built Informatica mappings to migrate data from Sql server,
• Oracle and Flat files into salesforce Sandbox & production using the informatica Power Center with salesforce power connect adaptor
• Experience in handling with large company deployments.
• Exposed to XML and RDBMS and MQ Series.
• Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages Confidential database level and form level using PL/SQL
• Hands on experience in writing Bteq, Mload, Fload, Fexport scripts in Teradata.
• Strong in design, development and implementation of applications on Microsoft technologies using different versions of MS Operating Systems.
• Excellent communication and interpersonal skills starter and Team player, capable of working independently and motivating a team of professionals.
• Power Center Mapping Design Certification.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9x/ 8.5.1/8.1.1 /7.1.4/7.1.2/6.2/6.1/5.1 , Power Mart 5.1/6.1, Power Connect 8.5.1/8.1.1

OLAP/DSS Tools: Hyperion Essabase 7.2 Business Objects6.5.1, Supervisor, Designer, COGNOS (Impromptu6.1, Transformer and Power Play 6.1), crystal reports 8.1, crystal enterprise, OBIEE 10.1.3.4.1

CRM Software: Salesforce.com, Onyx

Database Modeling: Erwin3.5.2/4.0

Databases: Oracle 8i/9i/10g, 11g Teradata, SQL Server 2000, MS Access 2000

GUI: VisualBasic6.0, Developer2000 (Forms 4.5/5.0/6.0/6 i and Reports 2.5/3.0/6.0/6 i)

Languages: SQL, PL/SQL, C, COBOL, JAVA, C++

DB Tools: Toad, Sql Developer, SQL* plus, SQL* Loader, Import, Export

Web Tools: HTML, XML, JavaScript, VBScript, ASP

OS: Windows 2000/NT/98/95, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr.ETL Developer

Responsibilities:

• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Various kinds of transformations were used to implement simple and complex business logic. Transformations used are: Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc.
• Created and Configured Sessions to load the data in to target tables and parameterized all variables, connections Confidential all levels in UNIX.
• Automated Batch and Session schedule using PMCMD and Unix Shell scripts.
• During development used Workflow Manager to schedule and run batches and sessions as well as to check session logs and other session related activities.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Interacted with metadata to trouble shoot session/batch related issues as well as global performance issues. Tuning of Applications using Explain Plan and SQL TRACE.
• Coordinated with testing team in all three phases of testing and their end-to-end testing. shared the development effort to design the audit control mechanism to track the defects
• Wrote number of stored procedures to validate the complex mappings and automated the validation process.
• Maintained different versions of technical specifications & mappings documents, promptly resolved and gave explanations for defects assigned from business users as well QA team through test director.

Environment: Informatica Power Center 9.5.1, ETL, Oracle 11g, DB2 UDB V8.x,Sql Server 2008, Cognos,HP - Unix, Sun OS, Erwin, Oracle ERP .

Confidential, ATLANTA, GA

Sr.ETL Developer

Responsibilities:

• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process. Designed Source to Target mapping from primarily Flat files, Sql Server, Oracle, Netezza using Informatica Power Center and Dmexpress.
• Various kinds of transformations were used to implement simple and complex business logic. Transformations used are: Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc.
• Created and Configured Sessions to load the data in to target tables.
• Automated Batch and Session schedule using PMCMD and Unix Shell scripts.
• During development used Workflow Manager to schedule and run batches and sessions as well as to check session logs and other session related activities.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Interacted with metadata to trouble shoot session/batch related issues as well as global performance issues. Tuning of Applications using Explain Plan and SQL TRACE.
• Coordinated with testing team in all three phases of testing and their end-to-end testing.
• Shared the development effort to design the audit control mechanism to track the defects
• Wrote number of stored procedures to validate the complex mappings and automated the validation process.
• Maintained different versions of technical specifications & mappings documents, promptly resolved and gave explanations for defects assigned from business users as well QA team through test director.

Environment: Informatica Power Center 8.5.1/9 x, ETL, Netezza, Oracle 11g/10g,DB2 UDB V8.x,Sql Server 2007, HP - Unix, Sun OS, Erwin, Dmexpress .

Confidential, Atlanta, GA

Sr. ETL Developer/Analyst

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into BID.
• Extracted the data from Flat files, Oracle, Teradata and load the data into flat files, Oracle and Teradata Using Informatica Power center
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Designing and developing ETL solutions in Informatica Power Center
• Designing ETL process and creation of ETL design and system design documents.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files from web servers and hosted files.
• D eveloped Informatica mappings, enabling the extract, transform and loading large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window.
• Effectively used all the kinds of data sources to process the data and finally creating load ready files (LRF) as out bound files which are inputs to the BID.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, and sequence generator.
• Created Workflows, Worklets and Tasks to schedule the loads Confidential required frequency using Maestro scheduling tool. Created Maestro control files to handle job dependencies.
• Assisted in performance testing, data quality assessment, support & product deployments.
• Expertise in writing BTEQ scripts in Teradata and running them by writing korn shell scripts in HP UNIX and Sun OS environments
• Expertise in creating MLOAD, Fast load control scripts to load data to the BID.
• Worked on Parameterize of all variables, connections Confidential all levels in UNIX.
• Involved in jobs scheduling and production deployment activities creation of the deployment guide migration of the code to production

Environment: Informatica Power Center 8.5.1/9 x, ETL, Teradata V2R12, Oracle 11g/10g, DB2 UDB V8.x, HP - Unix, Sun OS, Erwin, PL/SQL, Maestro scheduler.

Confidential, ADDISON, TX

Sr.ETL Developer/Analyst/OBIEE

Responsibilities:

• Design and Development of Data warehouse by integrating data from Heterogeneous application sources using Extract, Transform and Load (ETL) Technique utilizing Informatica as an ETL Tool and Leading the team and also Involved in full project life cycle - from analysis to production implementation and Worked closely with offshore to get the requirements and for development of the project.
• Design the complex application and perform structured analysis, Data Modeling and also created database objects like Tables, Views, Materialized Views to hold the data and process the business rules.
• Interact with the Business stakeholders to analyze the current infrastructure used by different departments, collect the business requirements and design the Interface layer develop ETL modules for the projects.
• Interacted with Data modular and DBA and analyzed the current data stores, address the Data quality issue, and optimize the load technique; Change data capture technique to capture source changes incrementally.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Extracted the data from Flat files, Oracle EBS, Sql server, DB2 and load the data into flat files, Oracle and Using Informatica Power center
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Created automated shell scripts to transfer files among servers using FTP.
• Used mapping parameters and variables
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, and sequence generator.
• Created Workflows, Worklets and Tasks to schedule the loads Confidential required frequency using Informatica scheduling tool. Created workflows to handle job dependencies.
• Wrote Confidential -SQL and PACKAGES, PL /SQL Stored Procedures based on the Requirements.
• Assisted in performance testing, data quality assessment, support & product deployments.
• Worked on different modules (GSI Reports and Financial Reports (HRMS)).
• Created and modified repositories Physical Layer, Business Model and Mapping Layer and Presentation Layer using Oracle BI Administration Tool.
• Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard Pages.
• Created and Customized various reports (Table view, Pivot table view, Chart view, View Selector) using Oracle BI Answers.
• Involved in jobs scheduling and production deployment activities creation of the deployment Guide migration of the code to production, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center /8.6.1, ETL, OBIEE 10.1.3.4.1 , Oracle 10g/11g, Sql Server 2005, DB2 UDB V8.x, HP - Unix, Sun OS, Erwin, PL/SQL, Informatica scheduler.

Confidential, Atlanta, GA

Sr. ETL Developer/Analyst

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into BID.
• Extracted the data from Flat files, XML, Oracle, Teradata and load the data into flat files, Oracle and Teradata Using Informatica Power center
• Based on the business requirements created Functional design documents and Technical design specification documents for ETL Process.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Designing and developing ETL solutions in Informatica Power Center
• Designing ETL process and creation of ETL design and system design documents.
• Developing code to extract, transform, and load (ETL) data from inbound flat files and various databases into various outbound files using complex business logic.
• Created automated shell scripts to transfer files among servers using FTP, SFTP protocols and download files from web servers and hosted files.
• D eveloped Informatica mappings, enabling the extract, transform and loading large volumes of data into target tables.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load window.
• Effectively used all the kinds of data sources to process the data and finally creating load ready files (LRF) as out bound files which are inputs to the BID.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, and sequence generator.
• Created Workflows, Worklets and Tasks to schedule the loads Confidential required frequency using Maestro scheduling tool. Created Maestro control files to handle job dependencies.
• Assisted in performance testing, data quality assessment, support & product deployments.
• Expertise in writing BTEQ scripts in Teradata and running them by writing korn shell scripts in HP UNIX and Sun OS environments
• Expertise in creating MLOAD, Fast load and Confidential Pump control scripts to load data to the BID.
• Worked on Parameterize of all variables, connections Confidential all levels in UNIX.
• Expertise in creating control files to define job dependencies and for scheduling using maestro tool.
• Involved in jobs scheduling and production deployment activities creation of the deployment guide migration of the code to production, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 7.1.4/8.5.1 , ETL, Teradata V2R6.2, OBIEE 10.1.3.2, Oracle Business Intelligence Applications 7.9.4, Oracle 10g/9i,DB2 UDB V8.x, HP - Unix, Sun OS, Erwin, PL/SQL, Maestro scheduler.

Confidential, Bartlesville, OK

Senior Informatica Developer

Responsibilities:

• Based on the business requirements, designed and developed Informatica Mappings for SAP BW and ODS and other INTERFACES. Involved in full project life cycle (SDLC)- from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data ODS.
• Extracted the data from Flat files,XML,Sql Server, Oracle,DB2,Sybase and load the data into flat files, Oracle and Sql Server, SAP BW Using Informatica Power center with SAP power connect Adaptor.
• Created shortcuts for source and target and also created Reusable Transformations, mapplets in Shared folder.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, SQL transformation, Java Transformation and sequence generator.
• Used mapping parameters and variables
• Creating sessions, worklets and workflows for carrying out test loads.
• Extensively worked on SAP r/3 source system (ABAP Functional Modules)
• Developed mapping based on ABAP Functional modules developed by ABAP developers and closely co-coordinated with them in migrating the data to staging tables using Informatica Power connect adaptor.
• Extensively worked on BAPI mappings and RFC enabled functional modules using Informatica Power connect adaptor. performed the performance evaluation of the ETLs for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex
• Problem troubleshooting.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better
• Performance. Involved in Production support.
• Automated and scheduled the workflows using PMCMD and UNIX Shell scripts in Control-M for daily loads and monthly loads.Involved in production deployment activities creation of the deployment guide migration of the code to production, monitoring and production support in a 24/7 environment.
• Wrote Confidential -SQL and PL/SQL Stored Procedures based on the Requirements.

Environment: Informatica Power Center 8.1.1/8.5.1 , Oracle 10g, SQL Server 2005,DB2 UDB,Sybase ASE,Toad 8.6,DB visualizer 6.0.10,Unix Shell Scripts, Unix Server, AIX 5.4,SAP, MS Office Visio 2003,Control-m,Web Submit.

Confidential, Denver, CO

Senior Informatica Developer

Responsibilities:

• Based on the business requirements, designed and developed Informatica Mappings for salesforce and Developed data integrations between legacy custom applications and SF.com
• Built Informatica mappings to migrate data from SQL Server, Oracle and flat files into salesforce Sandbox & Production using the Informatica Power Center with the salesforce Power Connect
• Configured and Customize SalesForce.com to meet business requirements.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, and sequence generator.
• Creating sessions, worklets and workflows for carrying out test loads.
• Loaded data using scripts from legacy application to SFDC. performed the performance evaluation of the ETLs for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex
• Problem troubleshooting.
• Scheduled the workflows using Autosys for daily loads and monthly loads and extensively worked on UNIX.
• Automation of job processing, establish automatic email notification to the concerned persons.

Environment: Informatica Power Center/Connect 8.1.1 Oracle 10g, Toad 8.6, Unix Shell Scripts, Unix Server, HP-UX 11i, Sun Solaris 5.4,Onyx,SQL Server 2000, SQL,SFDC, MS Office Visio 2003

Confidential, SFO, CA

Senior ETL Developer/Analyst

Responsibilities:

• Based on the business requirements created High level and low level Design Documents.
• Coordinated with team and Performed code review
• Interacted with Data modular and DBA and Source systems and resolved the Issues.
• Designed and Developed Informatica mappings serving as interfaces between ISchwab and IDW.
• Involved in creating informatica mapping to populate staging tables and data warehouse tables from Mainframe sources.
• Extensively involved in writing ETL Specs for Development and conversion projects.
• Created shortcuts for source and target and also created Reusable Transformations, mapplets in Shared folder.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, and sequence generator.
• Creating sessions, worklets and workflows for carrying out test loads.
• Wrote PL/SQL Stored Procedures based on the Requirements.
• Extensively created BTEQ scripts to implement post load processes.
• Extensively created MLOAD, FLOAD and TPUMP control files to load data in to IDW tables.
• Extensively used FAST EXPORT script to unload data from IDW and send them to other systems to use them as source.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex
• Problem troubleshooting.
• Scheduled the workflows using Autosys for daily loads and monthly loads.Involved in production deployment activities creation of the deployment guide migration of the code to production, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 7.1.4 Oracle 9i/10g, DB2 UDB,Teradata, ERWIN 4.0, Toad 8.6, Unix Shell Scripts, Unix Server, HP-UX 11i, Sun Solaris 5.4, SQL, MS Office Visio 2003