PROFESSIONAL SUMMARY:

• Around 14+ years’ experience as Data Migration & Data Quality lead & SAP Techno - Functional Consultant with expertise in Implementation, Data Migration, Upgrade and Support
• Skilled in aligning end-user needs with long-term resolutions to complex IT challenges, architecting ETL solutions to meet customers’ unique business requirements..
• Experienced withDifferent source systems like Oracle, MySQL,Sales Force, Flat files, Excel files and Json files .
• Experienced in Data Migration from Oracle,Sales Force, My SQL Using Talend DI
• Experienced in Data Migration from Oracle to SAP ERP and SAP ABAP programs for modules Sales & Disturbution, Finance& Controlling, Material Master, Bill of Materials, Master Recipe’s.
• Expert in using different components in Talend like Processing Components (tFilterRow, tAggregateRow, tSamplerow, tFilterColumns, tMap and tJoin),Logs&ErrorComponents(tDie,tLogCatcher,tLogRow
• Database Components (tOracleInput, tOracleOutput, tOracleCommit, tOracleConnection), Data Quality Components (tSchemaComplianceCheck, tUniqRow)
• Data Quality Components (tFuzzy Match,tFuzzy Join) & TAC Scheduling
• Loading the data into AWS, Sales Force, Snowflake
• Efficiency & Quality Improvements: Built reusable framework for all business units requiring minimal modifications for local use. Developed Metadata-driven solution for error tracking, reporting, and .csv file generation. Created automated and repeatable processes and re-usable global conversion and cleanse components.

TECHNICAL SKILLS:

ETL: Talent DI . Informatica,BODS,SLT,SDASAP BW HANA, SAP S/4 Hana, SAP BW4 HANA, SAP ABAP .

Reporting: Bex Query Designer, Bex Analyser, Business Objects -BO (Webi Reports, Analysis Edition), Tableau.

Database: Oracle, SQL Server, IBM DB2, MS Access,PL /SQL

Operating Systems: Windows, MSDOS, Linux, Unix, Sun Solaris

Functional Experience: SD-Sales Disturbution, FI-CO,MM,HR,C0-PA,FSCM

PROFESSIONAL EXPERIENCE:

Confidential --Nashville

Talend Consultant

Responsibilities:

• Analysing the Business Requirement Documents (BRD) and laid out the steps for the data extraction,business logic implementation & loading into targets.
• Migrated the data from Sales Force, Oracle,My Sql to Central DataBase.
• Worked on Talend ETL and used features such asContext variables, Database components liketDBinput,tDBoutput,tDBRowfile components, ELT components etc.
• Responsible for Developing, support and maintenance for the ETL (Extract, Transform and load) processes Using Talend DI
• ImplementedErrorhandlingin Talend tovalidatethedata Integrity and data completeness for the data from theFlatFile
• Developed Talend jobs mappings and also in tuning of mappings for better performance.
• Extracted Data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Talend DI and loaded data into target, by windows scheduler
• Designed the ETL mappings between sources to operational staging targets, then to the data warehouse using Talend DI .

Confidential

Data Migration Consultant

Responsibilities:

• Migrated the data from SQL Sever to Oracle .
• Responsible for Business Analysis and Requirements Collection Conducting the workshops to Identifying the KPI for the business owners
• Maintained stored definitions, transformation rules and targets definitions using Informatica .
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Lookup, and tAggregateRow to create robust mappings in the Informatica Designer
• Creating jobs using components tAggrgateRow, tMap, tJoin, tUnite, tReplicate, tRunjob, tLogRow, tOracleInput, tconvert type and tlog catcher and bulk Execution components
• Create and maintain Talend jobs to extract data form the source and load into Target fact tables used for reporting
• Exception Handling in Talend using tDie, tlogcatcher components.
• Involve in performance tuning for better data migration process.
• Involved in Unit testing and system integration testing (SIT) of the projects.
• Assist the team members with the mappings developed as part of knowledge transfer.
• Understanding the business process and creating the technical and functional specifications documents.
• Conducting the workshops to Identifying the KPI for the business owners
• Created Open ODS View,Composite Provides,Advanced Data Store Objects.
• Developed few report to Display Sales Order which are Back Order.
• Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load.

Confidential

SAP-BW Consultant

Responsibilities:

• Implemented Layered Scalable Architecture for the consolidated systems .
• Build a Framework that can be reusable for all Business units with minimal changes as per local requirements.
• Migrated the SAP BW to SAP BW on HANA.
• Converted the Standard Dso to Advanced DSO, Cube.
• Created Open ODS View,Composite Provides,Advanced Data Store Objects.
• Conducting the workshops to Identifying the KPI for the business owners .
• Understanding the business process and creating the technical and functional specifications.
• Developed the tableau dash board reporting for monitoring the supply chain for the orders. Integrated different views in to single dashboard report.

Confidential -Boston

SAP-BW/HANA Consultant

Responsibilities:

• Migrated the SAP BW to SAP BW on HANA.
• Understanding the business process and creating the technical and functional specifications documents.
• Was responsible for converting the Dynamic Ax based reports to SAP-BI/BOReports
• Was part of the project for developing a consolidation system for North America.
• Data Auditing/Reconciliation reports
• Part of the project for implementing the SAP-BW on Hana.
• Build a Open hubs in BW and down load the data for the Customer, Vendor, Material Master for NAM Reporting System.

Confidential

SAP-BW Consultant

Responsibilities:

• Presented the overall POC presentation with the client with the key advantages for arhiving data and performance improvement areas on their existing system.
• Handled CR’s and PR’s as part of Enhancement work for GFS 6.7, 6.8, 7.0, 7.1 and 7.2 Releases
• Analyzed the existing BW system and identified the key Models with huge volumes of data in terms of perfomance.
• Developed Multi Provider, Virtual Info Cube to accommodate the archived data from PBS with SAP BW data into the respective reports.
• Modified the respective settings on the Bex Query Designer to accommodate the NLS data into the respective reports.
• Presented the overall POC presentation with the client with the key advantages for arhiving data and performance improvement areas on their existing system.