SUMMARY

• ETL/Informatica Developerand Data WarehouseConsultant and with 9+ years of IT experience in design, development, and implementation of CoreERP conversion project from SAP to Oracle EBS using ETL toolset of Informatica Power Center, Oracle database, SQL server Database, UNIX and scheduling tools like UC4.
• Industry/ Domain Knowledge - Oil & Gas Industry, Cloud Computing, Financial Banking, Oil and Gas Industry, Payroll Applications and Human Resource Development domains
• Informatica Administration experience in Installation, Configuration, Maintenance and Administration of Informatica Power Center on Client/Server environment.
• ORACLE / SQL development experience in SQL, PL/SQL, Procedures, Functions, and Packages for creating framework for pre and post load processes including but not limited to Index rebuilds, Database Stats collection, partition creations, table and partition truncates, data de-duplication, and data purging.
• UC4, TIDAL experience for job/workflow scheduling.
• Technical documentation experience in writing Technical specifications using the available Functional specifications,such as Conversion Execution Protocol (Source to Target Mappings), ETL Design document, Unit Test Protocols, Deployment Checklist, and Production support run book. Good experience in providing duration estimates for the WBS activities involving ETL effort.
• Well-versed with Configuration Management using version control systems and working under structured and controlled Change Management system.
• Team player working within and across BUILD, PLAN, TEST, Infrastructure and Operation teams.
• Solid hands-on experience in advanced reports development and Microsoft SQL development. Key strengths include Microsoft SQL server, Crystal Reports, Business Objects, project management, team leadership and problem resolution.

TECHNICAL SKILLS

ETL Tools: Informatica(Power Exchange/Power Center 9.1,8.6,8.5,8.1.1)

RDBMS: Oracle 11g/10g/9i, Microsoft SQL Server 2008 R2, SQL Server Management Studio, PL/SQL, Teradata

Operating Systems: UNIX (HP UNIX, SUN Solaris, LINUX), Windows NT/98/95, WIN 2000

Data Modeling: CA Erwin Model Navigator 7.3.11, ERWIN 3.5.2/4.0, ER/Studio

Other Tools: Toad for Oracle 12.0/11.2, Visual Basic 5.0

Reporting Tools: OBIEE 11g, MSRA 02.07.0000 , Business Objects XI R2

PROFESSIONAL EXPERIENCE

Senior Applications Developer

Confidential, Houston, TX

Responsibilities:

• Involved in the conversion of data from SAP and other legacy Source systems to Oracle EBS using Informatica Power Center 9.1.
• Worked closely with Business Analysts to understand the requirements and carried out the analysis and design of the ETL process.
• Experience in basic Report buildings, Dashboards etc.
• Performed ETL activity along with functional analysis of wide variety of ERP data (RICEW Objects) involving Accounting to Close (ATC), Human Resource (HTR), Projects to Close (PTC) and Procurement to Pay (PTP).
• Design, development of mappings, transformations, sessions, workflows and ETL batch jobs to load data from Source to Target using Informatica, Oracle PL/SQL.
• Create SAP ABAP test documentsand work closely with SAP ABAP developers in promoting the Informatica SAP code to SAP QA4, QAS and Production environments before the CAB meetings.
• Documentation of Source to Target mapping in the form of Technical Specifications (Conversion Execution Protocol) and develop Unit test plans.
• Involved in Data loading to staging tables and from staging tables to Target tables i.e. Data loading from SAPR/3 (source) to Oracle EBS (target) Database.
• Unit test processes to ensure proper functioning, and collaborate with other team members during system and Integration testing phases to ensure proper functioning of the ETL code as part of the entire framework.
• Migration of Informatica code using Informatica migration tool from Development to QA and Production.
• Created Informatica mappings using various transformations like SAP BAPI/RFC, Source Qualifier, Expression, Lookup, Aggregator, Stored Procedure, Update Strategy, Joiner, Filter and Router.
• Adhere to Informatica SDLC, policies, procedures and Industry best practices with respect system design, architecture naming and coding standards.
• Worked closely with business application teams, business analysts, data architects and database administrators to ensure the ETL solution meets the Business requirements.
• Help Business users reconcile Source data (SAP) and the converted data.
• Performance improvement changes to the existing code of Informatica, queries using explain plan. Well versed with database partitioning and Informatica mappings performance improvement using partitioning.
• Scheduling the Informatica workflows using UC4 scheduler and trouble shooting any issues related.
• Attend various team meetings to meet deadlines at regularly intervals. Attend daily status call with off-shore support team members in explaining and clearing any doubts they may have in any area related to the conversion project.
• Developed project plans with manager and team members to ensure ETL solutions are executed and delivered as per the plans with good quality. Mentor team members in the design and development of mappings & workflows.

Environment: Informatica Power Center 9.1/9.0.1, Oracle 11g, OBIEE 11g, SAP R/3, UC4

Sr. Informatica Developer

Confidential, Redmond, WA

Responsibilities:

• Analyzed business process workflows and developed ETL procedures to move data from source to target systems.
• Extensive use of Informatica Power Center tools Designer, Workflow Manager, Workflow Monitor, Debugger and Reusable transformations.
• Extracted data from Flat files, SQL server, legacy systems like Azure database, Office 365, MS Salesand load them into SAP R/3through Informatica
• Loaded data into SAP 5.0 using IDOC’s, LSMW, BAPI and function modules
• Performed Data cleansing activities like Data Enhancement, Parsing, Matching and Consolidation.
• Created mappings using function modules, BAPI, LSMW, IDOCS’s
• Processed IDOC’s manually in SAP 5.0
• Used BI connect and uploaded the data into SAP thru Informatica
• Developed LSMW’s to migrate the processed data from Informatica to SAP R/3 for objects like EDI partner profiles, Text, Sales Orders, PO’s.
• Worked on performance improvement in Informatica for loading data into SAP
• Migration of ETL objects from Dev server to test servers
• Conceptualized and developed initial and incremental data loads in Informatica using Update Strategy
• Utilized lookup and update strategy transformations to lookup values from different tables and update slowly changing dimensions.
• Involved in creating, scheduling and running a number of sessions in complex workflows.
• Currently handling the tasks of conducting peer designing, code reviews, Standard documentation and ETL procedures.
• Review and participate in team meetings involving Revenue STM mappings for Fact and Dimension Tables pertaining to the Microsoft Finance data being available in the Cloud platform.
• Involved in migrating the data from Informatica 8.6.1 to Informatica 9.1.0
• Used TIDAL scheduler to schedule and automate the workflows to load on daily/weekly/monthly basis.
• Extensively used Informatica Debugger to debug the code and fix the CRs.
• Created stored procedures using PL/SQL and implementing them through Stored Procedure Transformation for Maintenance Tables.
• Used Mapping Wizards in creating type2 slowly changing dimensions tables to facilitate maintenance of history.
• Install patch and hot fixes onInformatica Integration Environment
• Performed Informatica Admin work, like installing EBF patches, upgrading from version 9.0.1 to 9.1
• Coordinate with Informatica Support on internal issues
• Extensively used version control while making changes in the Microsoft Sharepoint, Visual Studio, Informatica Power Centre and other tools.

Environment: Informatica Power Center 9.1/9.0.1, CA Erwin Model Navigator 7.3.11, SQL Server 2008 R2, SQL/T-SQL, Microsoft OLAP SQL Server, MSRA 02.07.0000 , Microsoft Visual Studio 2010, Microsoft Sharepoint 2010, Flat files, XML

Data Warehouse Consultant

Confidential, King of Prussia, PA

Responsibilities:

• Involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target using Ralph Kimball Data Warehouse methodology.
• Involved in the design and implementation of data warehouse architecture for the corporate circulation data warehouse that became the standard for divisional data warehouses. Subsequent data marts, extracts and reports were sourced from this architecture of conformed Facts and Dimensions.
• Extracted source data using power exchange from legacy systems such as VSAM and ADABA files, and implemented CDC.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected and Unconnected Lookup, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Automated the load process using UNIX shell scripts.Developed UNIX scripts and PERL scripts for pre data manipulation.
• Developed Multi load and Fast Load scripts to load data from pipe delimited files into Teradata Staging area.
• Experience in working knowledge of Informatica Data Services
• As part of Informatica Data Services, we had to merge data across various Systems so as to form a unified system where the Data could be accessed by the Business users as well as the IT team.
• Worked on SQL optimization, Identified bottlenecks and performance tuned the Informatica mappings/sessions.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Developed process for error handling and auto reloading.
• Created reusable objects in Informatica for easy maintainability and reusability.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Responsible for Unit testing the ETL jobs before moving to Test and to production migration.
• Supported migration of ETL code from development to QA and then from QA to production.

Environment: Informatica Power Center 9.1/8.6/8.5, Power exchange 8.6, Erwin, Teradata, DB2, VSAM, TOAD, PL/SQL, Flat files, XML, Oracle 11i/10g, Unix.

Data Warehouse Consultant

Confidential, Waukegan, IL

Responsibilities:

• Responsible for gathering the user requirements and discuss with Business Analysts to acquire the functional and Technical specifications
• Analyzed the source data coming from Oracle ERP system to create the Source to Target Data Mapping.
• Interacted with the Data Architect in Creating and modifying Logical and Physical data model.
• Used Informatica Repository Manager to create Repositories and Users and to give permissions to users.
• Worked with DBA’s in optimizing the Major SQL Query’s in the process of performance tuning.
• Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Responsible for identifying the bottlenecks and tuning the performance of the Informatica mappings/sessions.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Designed and developed mapping using various transformations like Source Qualifier, Sequence Generator, Expression, Lookup, Aggregator, Router, Rank, Filter,Update Strategy and Stored Procedure.
• Worked with Tidal Enterprise Scheduler to schedule jobs and batch processes.
• Experience in using AppWorx software to schedule and run jobsfor custom writtenprograms.
• Worked Extensively with Informatica Power Exchange in extracting the data from Mainframes
• Used Autosys and Informatica Scheduler to schedule jobs for the files and other sources to be extracted and load to target EDW on a daily/weekly/monthly basis.
• Created Unit Test plans and involved in primary unit testing of mappings.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.

Environment: Informatica Power Center 8.6.1/8.5,Crystal Reports v10, Power Exchange, Oracle 11g, SQL Server 2005/2008, Mainframes, Flat files, Autosys, Erwin 4.0, TOAD 8.6, UNIX.

Informatica Developer

Confidential, Skillman, NJ

Responsibilities:

• Analysis of Source requirements in existing OLTP systems and Identification of required Dimensions and Facts from the Database.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Parsing high-level design specs to simple ETL coding and mapping standards. Designed Mapping document, which is a guideline to ETL Coding.
• Extensively used Informatica to load data from Flat Files to Oracle and then to EDW.
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, and Stored procedure transformations
• Worked with various Informatica Power Center tools - Source Analyzer, Mapping Designer and Workflow Manager.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Fine-tuned Transformations and mappings for better performance.
• Used Informatica Designer to design mappings, extracting data from DB2 instance, flat files, that were delivered to Decision Support System, DSS
• Writing Stored Programs(Procedures & Functions) to do data transformations and integrate them with Informatica programs and the existing application
• Used workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Batches and Sessions, and scheduled them to run at a specified time.
• Performed unit testing and Involved in tuning the Session and Workflows for better performance.

Environment: Informatica Power Center 6.2.1/7.1.1 , Workflow Manager, Workflow Monitor, Erwin 4.0/3.5.2, TOAD, PL/SQL, Flat files, Cobol/400, Oracle 8i, Power Exchange (Striva 5.0 power connect).