SUMMARY:

• Over 13+ years of total IT experiences and 11+ years of progressive experience in full life cycle development (SDLC) of Data warehouses (Analysis, Design, Modeling, Development, Implementation and Testing) as an ETL developer, Informatica Team Lead and Data Integration/Migration Lead.
• Solid understanding and Development experiences in Data Warehousing, Business Intelligence, Data Migration, Data Integration, using various RDBMS (Oracle, MS - SQL Server, DB2, MySql) and SAP, Java, Web based and other applications.
• Expertise includes Data Analysis, Data Modeling, Data Cleansing, Data Transformations, Integration, Migration, Data import/Export, Conversion using ETL tool like Informatica, SSIS and SSRS.
• Experience in Conceptual, Logical & Physical Data modeling using tools like Erwin; Data Analyzing and Validating with tool like Toad and SQL Developer.
• Experience in Dimensional Data Modeling such Star & Snow Flake Schema, Fact & Dimension tables.
• Strong ETL experience in using Informatica Power Center 9.x/8.x/7.x, Power Exchange for SAP/R3 or BCI (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Informatica cloud to Develop, Test, Debug and Tuning mappings, Sessions and Workflows for ETL Process.
• Strong experienced in handling XML files and Web Service with Informatica.
• Strong experience on IDQ (Informatica Data Quality) which involves developing plan for Analysis, Standardization, Matching and Consolidation of data by using different component.
• Strong experience in handling various databases like DB2, Oracle 11g/10g/9i/, SQL Server 2004/2008, MySQL and MS Access.
• Extensive experienced in PL/SQL Cursors, Procedures/Functions, Triggers and Packages.
• Experience in writing UNIX shell scripts for ETL jobs automation, file transfers, file manipulation and Pre-Session and Post-Session Command.
• Experience in performance optimization/tuning of Database and ETL process.
• Experience in scheduling toll like Auto-Sys, Tidal.
• Entry level of experience on Hadoop, Spark, Scala, Hive, Pig, MongoDB.
• Extensively worked in SAP Integration/Migration Project using ETL (Informatica); Built Interfaces (Inbound/Outbound) or Data migration using BCI, LSMW, RFC, BAPI, Win Shuttle and IDoc through Informatica to load data into SAP-CRM, SAP ECC ( MM. PS, SD, AP, GL, AR ) from heterogeneous Source System Mainframe.
• Proven problem solving skills with excellent analytical, communication and interpersonal skills.
• Excellent ability to lead a group or work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Hands on experience on loading data in SAP through LSMW, Custom Program, BODS, IDoc and testing data in SAP using different transaction code.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/ 8.x/7.x, Power Exchange 9.x/8.x, (Designer, workflow manager, Monitor and Repository Manager, SSIS, SSAS and SSRS.

Database: Oracle 12c/11g/10g/9i/8i/8.0, MS SQL Server 2004/2008/2012, DB2, MySQL

Programming Languages: J2SE, Python, SQL,T-SQL, PL/SQL, C++, C#.

Scripting Language:: UNIX Shell Scripting (Bash and Korn Shell), Perl.

Data Modeling Tool: Erwin 4.1/3.7

Other Tools: TOAD, SQL Developer, Erwin, Eclipse, Rational Rose, MS Visio 2007, MS Project 2003, MS Visual Studio, Tidal, Auto-Sys, Control-M.

Testing: Test Scripts, Test Cases, Unit Testing, Functional Testing, Integration Testing, Black-box & White-box, Smoke Testing.

Operating Systems: Microsoft Windows (x), Windows Server, UNIX, Sun Solaris 5.8. Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Issaquah, WA

Data Integration/Migration/ETL Lead

Responsibilities:

• Leading Conversion/Interface team (Onsite/Offshore) of various fields like I-Series, ETL (Informatica, BODS) and SAP.
• Supervising the whole conversion process for all rehearsals/cycles as Data Migration/Integration lead.
• Overseeing the inbound and outbound interfaces development process by closely working with functional, developer and tester.
• Conducting/Attending Regular/Adhoc meeting with project teams to update daily status, or escalate issues and concerns.
• Conducted team meeting/Conference call (with Offshore) with team member to assign the work and get the update of assigned task.
• Helping PMO with the creation of Project time and resources Management.
• Involved with the Business analysts in requirements gathering, analysis, testing and project coordination.
• Prepared standard design documents FD, Technical Specification TD, ETL Specifications and Migration documents.
• Designedand reviewed the Interface/Conversion ETL code before move to QA to ensure design standards are met.
• Maintained daily Tech Tracker/Issue logs for the updates and issues related to objects and progress.
• Designed and implement scheduler to run the interfaces at different time using Shell Scripting in UNIX.
• Solved various performance and complex logic related issues with effective and efficient solution in the ETL process (performance tuning) and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.
• Developed Workflow, Session and Mapping, Mapplet to load data from heterogeneous to SAP using BAPI's, RFC’s and IDOC's with Power Center (9.6.1) & Power exchange (9.6.1).
• Used different transformations like Connected & Unconnected Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator, Transaction Control Transformations to data conversion before loading to Target.
• Created Mapping to extract data from SAP (ECC) tables using SAP/R3 and from SAP data sources using BCI for outbound interfaces.
• Load data into SAP using Win-Shuttle, LSMW, Custom Programs and by creating and Processing IDoc.
• Design Star and Snow Flake schema and write ETL code to load data to Dimensions and fact tables.
• Design the validation process for conversion//migration using BODS for data accuracy and consistency.
• Designed naming and design standards document for future enhancement for interfaces.
• Performed various Performances Tuning activities at Database level (source, target, Look Up tables), Informatica level (workflows, mapping and session) using Sql developer and T-SQL.

Environment: Informatica Power Center 9.6.1/9.5.1, Informatica Power Exchange 9.6.1/9.5.1, Oracle 11g/12c, SAP R/3 7.1,SQL Server 2008, T-SQL, DB2, PL/SQL, AS400, SQL developer, AIX/UNIX.

Confidential, Burbank

Sr. Informatica Consultant (Lead)

Responsibilities:

• Designed the Whole EAI (Middleware) Architecture for the Project COSMOS based on given requirement in compliance with IMCC (Information management Competency Center) standard.
• Managed a team of 4-6 resources (Onsite/Offshore). Attended Regular/Adhoc meeting with project team to update daily status, or escalate issues and concerns.
• Conducted team meeting/Conference call (with Offshore) with team member to assign the work and get the update of assigned task.
• Involved with Business analysts in Requirements gathering, Analysis, Testing, and Project coordination.
• Leading the ETL (Informatica) team to convert Legacy data to SAP applying given business logic.
• Designed and developed the Interfaces by implementing given business logic within the given time frame.
• Maintained daily Tech Tracker/Issue logs for the updates and issues related to objects and progress.
• Designed and implement a scheduler to run the interfaces at different time using Shell Scripting in UNIX.
• Solved various performance and complex logic related issues with effective and efficient solution in the ETL and Database process and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.
• Responsible for Data Cleansing and Data Quality checks using Informatica Data Quality (IDQ).
• Developed mapping to load heterogeneous data into SAP using BAPI'S, RFC’s and IDoc's with Power exchange.
• Use Transformation for XML and Web service for data conversion.
• Responsible for create mapping for Hand shaking within the Legacy-Middleware EAI-SAP.
• Created Mapping to extract data from SAP (CRM, ECC) tables directly using SAP/R3.
• Extracted data from various sources such as SQL server, DB2UBD, Flat Files, Mainframe, Oracle and SAP
• Used Java Transformation by written java code in Informatica to implement Complex Business Logic.
• Used different transformations like Connected & Unconnected Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator, Transaction Control Transformations to data conversion before loading to Target.
• Created Reusable Mapplet for time saving development.
• Created and Monitored workflows/sessions using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Performed various Performances Tuning activities at Database level (source, target, Look Up) and Informatica level (mapping and session) with T-SQL and Sql Developer and Toad.
• Perform production support for the stabilizing period. Resolving production issue (ITSM) retest and deploy to Production.

Environment: Informatica Power Center 9.6.0/9.5.1/8.6.1 Informatica IDE/IDQ 8.6, Informatica Power Exchange 9.6.0/ 8.5.1/8.6.1, Oracle 10g/11g, SAP R/3 7.1, SQL Server, DB2, PL/SQL, AIX/UNIX, WindowsNT4.0.

Confidential, Chicago

Informatica Consultant (Team Lead)

Responsibilities:

• Interacted with the Business client to gather and Analyze the business requirements and translate them to the technical requirements.
• Lead a team of 4 (onsite/Offshore) for the enhancement project.
• Attended Regular/Adhoc meeting with project team to update daily status, or escalate issues and concerns.
• Conducted team meeting/Conference call (with Offshore) with team member to assign the work and get the update of assigned task.
• Designed different Cubes, Fact and Dimension tables according to the business requirement for enhancement.
• Implemented Slowly Changing Dimensions (SCD2). Used Type 2 dimension to keep the history changes.
• Designed and built Simple to complex mappings to populate all those Fact and Dimension tables using various transformations like Source Qualifier, Filter, Expression, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner, Router, SQL and Transaction control Transformation.
• Developed Mapping, Session, Workflow and other component in Informatica using Source Analyzer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Wrote pre-session and post-session Stored Procedures/SQL to drop the indexes, to re-create the indexes, and to joins in the database.
• Extracted data from multiple sources like Oracle, SQL Server and Flat files.
• Used DB tools like TOAD to run SQL queries and verify and validate the loaded data in target tables.
• Involved in identifying Performance issues, bug and fixing them in existing mappings by analyzing the data flow, evaluating transformations to eliminate inconsistency and inaccuracy and latency.
• Involved in Debugging, Troubleshooting, Testing, and Documenting to the built application.
• Fine tuned the existing Informatica mappings to improve the performance.
• Translate lots of Store Procedures and Functions to Informatica Code.
• Wrote Shell scripts to scheduled workflow in Scheduler.
• Supported the current Production System in resolving the ITSM Tickets.

Environment: Informatica Power Center 8.6.1, DB2 UDB, Oracle 8i/9i, SQL/PLSQL, UNIX Shell Programming, UNIX and Windows 2000 Server.

Confidential, Burbank

Sr. ETL CONSULTANT (TEAM Lead)

Responsibilities:

• Designed the Whole EAI (Middleware) Architecture for the Project COSMOS based on given requirement.
• Involved in Requirements gathering, Analysis, Development and Project coordination.
• Prepared standard design documents, Technical Specification, ETL Specifications and Migration documents.
• Designed and implement a scheduler to run the interfaces at different time using Shell Scripting in Unix.
• Designed all the Interfaces/Conversions with implementing given business logic within the given time frame.
• Maintained daily Tech Tracker/Issue logs for the updates and issues related to objects and progress.
• As team lead attended Regular/Adhoc meeting with project team to update daily status, or escalate issues and concerns.
• Conducted team meeting/Conference call (with Offshore) with team member to assign the work and get the update of assigned task.
• Solved various performance and complex logic related issue with effective and efficient solutionin the ETL process (performance tuning) and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.
• Developed Mapping, Session, Workflow, and Worklet to load data from heterogeneous source to SAP using BAPI'S, RFC’s and IDoc's using Power exchange.
• Responsible for create mapping Hand shaking within the Legacy Middleware EAI and SAP using SAP/R3.
• Responsible for Data cleansing and Data quality checks using Informatica Data Explorer and Informatica Data Quality 8.6 (IDQ).
• Designed and maintained naming and design standards document for future enhancement.
• Used Java Transformation by written java code in Informatica to implement Complex Business Logic.
• Used different transformations like Connected & Unconnected Lookup, Connected & Unconnected Stored Procedure, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, Aggregator and Sequence generator, Transaction Control transformations to data conversion before loading to Target..
• Performed different type testing proactively to identify data anomalies and inaccuracies
• Performed various performances tuning activity at source, target, mapping and session level.

Environment: Informatica Power Center 8.6.1/8.6.0 Informatica IDE/IDQ 8.6, Informatica Power Exchange, 8.5.1/8.6.1, Oracle 10g/11g, SAP R/37.1,SQL Server, DB2, PL/SQL, AIX/UNIX, WindowsNT4.0.

Confidential, Fort Worth, TX

Sr. Informatica Developer

Responsibilities:

• Involved with the Business analysts in requirements gathering, business analysis, testing and translating Business requirement to Technical requirements.
• Responsible for Designing Interfaces/Conversions program as an SME in Informatica..
• At one point of the project Worked as Team lead of 5/6 (Onsite/Offshore) Informatica developer.
• Attending regular meeting with managers and resources on updating progress and Issuess.
• Maintained daily Tech Tracker for the updates from the team regarding their objects, issues and progress.
• Provided various insights into how to manage performance in the ETL process (performance tuning) and identified various bottlenecks and critical paths of data transformation in sessions for different Interface.
• Responsible for create Mappings, Sessions, Worklets, Workflows to loading the data into SAP using BAPI'S, RFC’s and IDoc's.
• Developed Mapping (Out bound) to extract data from SAP to legacy system using SAP/R3 and BAPI.
• Used Informatica B2B Data Transformation for comprehensive transformation of unstructured data.
• Used Informatica power exchange to extract the data from Mainframe based on data set.
• Extracted data from various sources such as Flat Files, Mainframe, DB2UBD, SAP and Oracle.
• Implemented Complex Business Logic using java Transformation by writing java Code in Informatica.
• Used different transformations like Connected & Unconnected Lookup, Router, Aggregator, Normalizer, Joiner, Expression, Update Strategy, Aggregator, Sequence generator and other Transformations.
• Created Reusable Mapplet for time saving development.
• Performed Acid Tests on Functional Specifications and Technical Specifications.
• Involved in performance tuning in Informatica at source, target, mapping and session level.
• Design and implement Error handling system (EEMS) and Auto recovery system.
• Provide 24/7 production support at post go-live and Technical support to the junior team members.

Environment: Informatica Power Center 8.5.1/8.6.1, Informatica IDE/IDQ 8.6, Informatica Power Exchange, 8.5.1/8.6.1, Oracle 10g/11g, SAP R/37.1, SAP, DB2UBD 4.0, PL/SQL,UNIX, WindowsNT4.0.

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Extensively involved in gathering Business requirements and translating them into Technical requirements.
• Designed and developed Informatica mappings for data loads to staging.
• Extracted data from various sources such as Flat Files, Oracle, DB2 and MySQL.
• Developed Mapping, Session and Workflows for populating Dimension and Fact tables based on the mapping sheet applying business logic.
• Wrote SQL and PL/SQL to test and validate loaded data.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Involved in performance tuning at source, target, mapping and session level.
• Written shell scripts to extract feeds, pattern matching/parsing Source feeds and automate processing.
• Delivered and sign-off of deliverables pertaining to the Operational Data warehouse.
• Prepared design documents, ETL Specifications and migration documents.
• Offered 24/7 production support for the application on a time-time basis.

Environment: Informatica Power Center 8.6, DB2UBD, Oracle9i, PL/SQL, Toad, Unix, WindowsNT4.0, Tidal.

Confidential

Software developer

Responsibilities:

• Involved in building Enterprise wide Logical and Physical models using ERwin.
• Understanding of business information requirements for data models.
• Discussed business requirements and mapped business needs.
• Designed and constructed the pre-staging tables to populate from different source system.
• Created and managed the local & global repositories and permissions and assigned privileges to users and groups using Repository Manager.
• Written PL/SQL packages, procedures and functions and developed Informatica Mappings to perform test loads.
• Involved in Preparing Source-Target Mappings documents to provide the logic for Informatica mappings development.
• Used Transformations like Source Qualifier, Joiner, Aggregator, Expression, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Created tasks, workflows and worklets using workflow manager. Monitored workflows and worklets using workflow monitor. Tuned Mappings and Sessions by identifying the bottlenecks for optimal performance.

Environment: Informatica PowerCenter 5.0 ERwin 3.5.2, MS SQL Server 7.0/2000, Oracle 8i, Shell Scripting, SQL, PL/SQL, Autosys, Toad, Sun Solaris 2.6, Windows 2000 Server