PROFESSIONAL SUMMARY:

• Overall 10+ years of experience in the role of Project manager/Integration Manger, implementing Interface development, Data migration, Data Ware Housing applications using ETL tool like SAP BODI/BODS, Informatica Power center 8.6, Oracle.
• Extensive experience in ETL using SAP BODI/BODS, Informatica.
• Worked with different data sources like SAP BW, Teradata, Vertica, Oracle, SQL server and Flat Files.
• Knowledge in design of Extract, Transform and Load environment using both SAP BODI/BODS and Informatica Power Center.
• Creating and executing JOB, Workflow, and Dataflow etc. in SAP BODS tool in SAP BW and Teradata environment.
• Diverse background with fast learning skills and creative analytical skills.
• Good communication skills, Interpersonal skills, Team co - ordination and versed with Software Development processes.
• Having Experience on Oracle database.
• Extensive Knowledge of Data Warehousing Concepts.

TECHNICAL SKILLS:

ETL Tools: SAP BODS/BODI, Informatica Power center

RDBMS: Oracle, SQL Server, Teradata, Vertica

Operating Systems: MS DOS, Windows 98/2000, XP, UNIX /LINUX(basic commands)

Development Tools: TOAD

Reporting Tools: BO-Xcelsius Dashboard, Qlikview (Basic)

PROFESSIONAL EXPERIENCE:

Confidential

Environment: SAP BODS, Oracle 11g, Sybase IQ

Project Lead

Responsibilities:

• Preparing design documents.
• Development and Execution of ETL Jobs in BODS.
• Converting Sybase IQ queries to SAP BODS jobs.
• Load Data from Sybase to Oracle.
• Assisting fellow team members in troubleshooting issues and peer review
• Interacting with the onshore team and offshore team for getting the task completed and timely basis.

Confidential

Environment: SAP BODS, Qlikview, SQL server

BI Lead

Responsibilities:

• Development/enhance BODS jobs
• Production support activities.
• Monitoring Data migration activities.
• Issue log maintenance and provide resolution
• Manage Change Request (CRs)
• Manage and Monitor post migration validation and troubleshoot.
• Worked on various report generation requirement
• Extensively worked with CareFusion USA team in various Bods related assignment.
• Overseen and manage BODS team and BW team in KL and India.
• Prepared knowledge transfer plan from US/INDIA/MALAYSIA BODS team
• Hiring and manage resources in MALAYSIA and India
• Manage, coordinate BODS support team in India to provide operation support and issues solving.
• Monitor and control resource workload. Develop resources allocation and project assignment plan.
• Helps junior colleagues identify capability gaps and appropriate growth opportunities.
• Assists in the definition of short- and long-term strategic plans
• Provides input into the talent planning process and remains actively involved in the identification and selection of talent both internally and externally
• Effectively communicates the vision and business need for change to others and maintains a positive perspective

Confidential

Environment: SAP (FICO, SD, PP, PS, QM, and MM) and Data migration (Using SAP BODS

Integration Manager (BI)

Responsibilities:

• Project Management and delivery.
• Cut-Over planning and activities.
• Monitoring Data migration activities.
• Issue log maintenance and provide resolution
• Manage Change Request (CRs)
• Manage and Monitor post migration validation and troubleshoot.
• Worked on various report generation requirement
• Extensively worked with both client’s PMO team and our functional/technical team to suggest the best solution as per the client’s requirement.

Confidential

Environment: SAP BODS, MS Project, MS Excel

Integration Manager

Responsibilities:

• Project Management and delivery.
• Modules involved -
• Policy issuance
• Premium calculation
• Maturity and Coupon calculation
• Customer Account Details
• Premium discount etc.
• Requirement gathering, Project planning, Project budgeting, and project costing.
• Developed ETL jobs using SAP BODS for data migration purpose.
• Resource planning and time line management.
• Manage Change Request (CRs)
• Prepare and plan for UAT executing test plan.
• Plan and coordinate with Team Lead on Implementation/Fallback Plan.
• Manage post implementation Support
• FRS integration to the sap system.
• Worked on various report generation requirement
• Extensively worked with both client’s finance team and our technical team to suggest the best solution as per the client’s requirement.

Confidential

Environment: DTS packages, SQL Server 2000, SSIS 2005, SQL Server 2005

Technology Integration Manager

Responsibilities:

• Data Migration using SAP BODS tool.
• Project Management and delivery.
• Project planning, Project budgeting and project costing.
• Resource planning and time line management.
• Application migration requirement gathering, Application support management. DR planning and implementation.
• Worked and managed the data migration team.
• Extensively worked with solution centre and project management team to ensure the GDC migration happened properly.
• Vender Management.
• Migration planning document etc.

Confidential

Environment: SAP BODS, BO Dash boarding

SAP CONSULTANT (BODS Lead)

Responsibilities:

• Manage ETL team
• Worked on ETL development and troubleshooting in SAP BODS.
• Worked on Production support and operation whereas my daily work is to extract data from AMDOC- Oracle source and load the data to Vertica database by using BODS jobs.
• Resolve ETL issues on priority based on tickets.
• ETL job enhancement and performance analysis of the jobs.
• Worked with flat file source.
• Worked on multiple transformations like Query, Case, Hierarchy Flattening, Merge, Pivot (Columns to Rows), Reverse Pivot ( Rows to Columns), SQL etc.
• Use of Row Generation, Date Generation, Map Operation, Map CDC Operation, Effective Date, Validation Transform, Table Comparison, History Preserving, Key Generation, XML Pipeline, Address Enhancement, Match Merge
• Creating Interface design, Interface specific table in ORCLE and VERTICA database.
• Preparing ETL specific design document, Preparing Test case document and Operational Guide document etc.

Confidential

Environment: SAP BODS

Responsibilities:

• Worked on extraction data from oracle Database, SAP BW source date, flat source.
• Worked with flat file.
• Worked on multiple transformations like Query, Case, Hierarchy Flattening, Merge, Pivot (Columns to Rows), Reverse Pivot ( Rows to Columns), SQL etc.
• Use of Row Generation, Date Generation, Map Operation, Map CDC Operation, Effective Date, Validation Transform, Table Comparison, History Preserving, Key Generation, XML Pipeline, Address Enhancement, Match Merge, Name Parsing
• Creating Interface design, Interface specific error table
• Preparing IDD (Interface specific design document), Preparing unit test case document.

Confidential

Environment: Informatica, SAP BODS

Responsibilities:

• Worked on extraction data from oracle Database.
• Worked on develop ETL jobs using Sap BODS for SAP source system and Informatica for non-SAP and flat file source.
• Worked with flat file.
• Worked on multiple transformations like Source qualifier, Expression, Lookup, Stored procedure, Update strategy, Filter transformations etc.
• Stored procedure transformations are used as source preload and Confidential post load.
• Lookup transformations to compare the source and Confidential values and Update strategy transformations are used for Update or Delete the records.

Confidential

Environment: SAP BODS

Responsibilities:

• Use the Repository Manager to create, organize, and maintain the repository. Repository administration tasks include repository creation, folder creation and organization, and configuring permissions and privileges for users and groups.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to Confidential systems using BODS designer.
• Performed data cleansing and transformation.
• Worked extensively with Designer.
• Created data mappings to extract data from different source files, transform the data using Query, merge, case, validation, table comparison Transformations and then loaded into data warehouse.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Preparing IDD (Interface specific design document), Preparing unit test case document.
• Resolve ETL issues on priority based on tickets.
• ETL job enhancement and performance analysis of the jobs.

Confidential

Environment: Informatica

Responsibilities:

• Worked on Informatica Designer Tool’s components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Involved in the development of Informatica mappings and also tuned for better performance. In the Mappings most of the Transformations were used like the Source Qualifier, Expression, Filter, Aggregator, Look Up, Update, and joiner, Sequence Generator, Sorter, Rank and Router.
• Used Unconnected Look Ups with the combination of Update Strategy to implement Type 2 Warehouse.
• Lookup tables were implemented at the staging level for the faster response time of Lookups.
• Extensively used Informatica Workflow Manager & Workflow Monitor tools to Load data from MS SQL Server, Oracle OLTP sources into the Confidential Oracle 9i Data Ware House.

Confidential

Environment: OracleRole:SSE

Responsibilities:

• Receipt (PO) conversion from legacy system to Oracle.
• Item & Item Category Conversion from legacy to Oracle.
• Supplier Data migration to Oracle.
• Development of various SQL Loader control files to load data.
• Development of various PL/SQL procedures to validate the Data coming from legacy systems.
• Development of various PL/SQL procedures to populate Base Tables using various Interface tables for populating and fetching relevant data.