SUMMARY

• Over 10+ years of experience in information technology, worked as a EIM/ETL Lead Consultant with specialization in SAP Data Services/ BODS/ Information Steward/HANA and Data Quality Tools and SAP Data Migration/Data Conversion.
• Certified SAP Data Services Consultant with area of expertise in SAP Data Migration / Conversion for various modules utilizing SAP best practices/ASAP methodology. Extensive knowledge of AIO Methodology (SAP RDS Package) for Data Migration Process & working with RDS templates in Date Services for Data Migration and Data Warehousing.
• Certified SAP HANA Consultant with experience in Loading Data in HANA and BI environment using SLT and/or SAP Data Services (BODS) and working with HANA STUDIO.
• Experienced Data Quality consultant utilizing SAP best practices using BODS Address and Data Cleansing packages and Information Steward.and other Data Warehousing projects.
• Conversion Specialist for SAP Modules like MM, SD, FICO, CRM among others with extensive experience implementing Customer/Vendor/Material Master Data.
• Conversion Specialist for Transactional Objects like Sales Orders, Purchase Orders, Inventory Balances among others
• Experience in loading data into SAP MDG using SAP Best Practices.
• Experience creating ETL solution where out of box SAP solution does not exist, replicating Best Practices as per business requirements.
• Experience co - coordinating mapping workshops and detailed documentation knowledge to provide Mappings and Technical Specs for Data Migration.
• Solid SQL basics to support ETL process with added expertise in SAP HANA and related applications. Added Data Analysis knowledge to run queries and scripts to analyze the legacy/transformed data at back end before loading in SAP
• Solid Functional knowledge to verify loaded data in SAP for various modules. Working knowledge of ABAP Programming for master data/transactional data conversions using LSMW, BAPIs & IDOCS.
• Strong Technical knowledge around SAP Configuration Data, Sap Check Tables and Pre Validations required for successful conversion and loading of various objects.
• Experience in loading Data from SAP/Non-SAP/Excel sources in ECC directly through BODS using regular or customized IDOCS/Function Modules or creating Flat Files and loading using pre built Programs/ LSMW, BAPIs.
• SME for Data Health Assessment using SAP Information Steward(Data Insight )
• Strongdataoriented skills with special expertise indatatransformation,dataanalysis,data profiling,dataquality anddatamigration
• Team Player having a solution oriented approach and ability to lead and achieve goals with dedication and sincerity, believing in strong communication with client.

TECHNICAL SKILLS

ETL / Data-Quality: Data Integrator/Data ServicesXI3.0/4.0,4.1,4.2 Information Steward/Data Insight, LSMW

Programming: Business Objects 5.1/6.0/6.1a/6.1b/6.5/XIR2BOXI 3.1, Web Intelligence 2.7/6.0/,, ECC 6.0, SAP

Database: ORACLE 11/10g/9i/8i/7i, MS SQL Server 2008 R2, Ms-Access, TOAD.

Operating Systems: MS Windows 2000/NT/98/XP/7 UNIX, MSDOS.

Programming: SQL, PL/SQL,ABAP

Extensive experience: in PL/SQL and SQL and in performance tuning SQL queries in TOAD,HANA,SQL Developer and Microsoft SQL Server

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP Data Lead / BODS Architect

Responsibilities:

• SAP Data Services Specialist/Architect supporting Conversion Programs and Post Go Live Interface Programs using BODS and other tools.
• Developed and Managed Co-Existence Post Go Live Programs for Program Mercury using BODS, LSMW & IDOCS
• Developed AR, AP. Engagements (Projects) Load Programs to support conversion and post go live activities using SAP best practices
• Data Lead handling Integrated Testing cycles, troubleshooting errors and resolving Issues.
• Providing validation and error reports to the management on weekly & daily basis.
• Worked with Functional Leads to understand requirements and facilitated mapping workshops.
• Worked on various Change Requests with Offshore and Onshore teams.

Kimberly Clark

Role(s): Sr. SAP Data Quality Lead / DS / IS Consultant Duration: May 2016 - Dec 2016

Responsibilities/Deliverables

• Sr. Data Quality Lead managing Data Quality Projects.
• Information Steward Architect. Designed and Implemented Data Quality Scorecards and Dashboards.
• Technical Lead Global Data Management for Marketing Teams. Delivered Cyclone Project Validation Reports, Custom Rules and Profiling Reports.
• SAP Master Data including Material Master, Customer Master, Vendor Master and FICO Data profiled and validated.
• SAP Data Redundancy, Data Integrity Checks. SAP configuration validation.
• USPS Address Validation on US Customer and Vendor Data. Custom and Standard Data Services Reports and ETL validation. SAP transactional intergrity Data validation.

Confidential

Sr. SAP Data Lead / SAP Data Services Architect

Responsibilities:

• SAP Data Lead for SAP ECC Data Migration - S/4 HANA Implementation
• Technical Lead for Migration of Objects for ECC for SAP SD,SCM,CRM,PP,PS modules using Data Services/IDOC/LSMW utilizing SAP RDS solutions and Best Practices.
• Leading team of onsite and offshore developers for migration and management of various Master and Transactional objects required for Successful Go-Live.
• Technical Lead for Migration of Objects for ECC for SAP SD,SCM,CRM,PP,PS modules using Data Services/IDOC/LSMW utilizing SAP RDS solutions and Best Practices.
• Data Services Architect for 1ERP project at NEC, deployed SAP RDS Package for ECC Migration for Master Data and Transactional Data and Master Data conversion to SAP MDG.
• Data Migration Project Planning, Resource Planning, Reporting to Senior Management at NEC
• Responsible for Loading data into HANA for reporting and Data Modeling for various Accounting Data Models.
• Developed LSMWs for various objects like Routing, Inspection Plans, WMs, AMPL etc.
• Aligning the Object Migration with MDG Master Data and HANA Reporting Environment
• Development of various transactional objects like BOMS, Sales Orders, Purchase Orders, Inventory etc.
• Implementation of MDG for Customer, Vendor and Material Master. Migration of Data from Legacy Systems like Focus, PS etc.
• Development of Real-time Inbound and Outbound jobs for interfaces and Dual Maintenance with MDG using XML, IDOCs and BAPI's.
• Data Profiling and Data Quality Analysis for various legacy objects using BODS, Information Steward Etc.
• Providing Data Validation and Data Quality Reports to Program Leadership using Data Services and Information Steward

Confidential

Sr. SAP Data Management Consultant

Responsibilities:

• Providing/Implementing SAP Rapid Deployment solution for Data Migration/Data Management using SAP Data Services and Information Steward.
• Data Migration SME for Customer Master from Legacy Systems to SAP.
• Data Services and Information Steward Specialist providing support for various conversions across US.

Confidential

Sr. SAP Data Services/Data Quality Lead

Responsibilities:

• Data Services technical Lead with responsibilities including training client employees, designing Data Services Jobs and overall Architecture.
• Technical Lead for Customer Master Conversion for various Legacy Systems to SAP to support MDG and various external Systems for Successful Implementation.
• SME for Customer Master Data Conversion and Configuration.
• Data Migration Specialist for SAP Customer Master Module migration from PeopleSoft to SAP ECC.
• Data Quality Lead for Data Cleansing, Standardization as per USPS directories, Data De Duplication using complex Business Scenario and Requirements.
• Designed and Developed Customer Master, Customer Contacts and Customer Hierarchy ETL Jobs for migrating data from PeopleSoft to ECC. Additional coding responsibilities for Hot Manufacturing Material Master Objects
• Providing Data Validation and Data Quality Reports to Program Leadership using Data Services and Information Steward.
• Implemented AIO Lookup Jobs and setup AIO framework for Validations through lookup and check tables.
• Implementation of Successful Loading Process using IDOCS,LSMW and BAPI to support on going and future Data Processes

Confidential

SAP Data Services Technical /ETL Architect

Responsibilities:

• Responsibilities as BODS technical lead under SAP leadership; involved in full Conversion life cycle from Blueprint to Go Live.
• Data Migration Specialist for SAP Project & Assets Module migration from PeopleSoft to SAP ECC 6.0.
• Interacted directly with Verizon Business Leads to understand Conversion Requirementsand designed BODS Technical Specification documents as per various business requirements.
• Loaded Legacy Asset Master Data using custom/modified IDOCs directly from BODS into ECC.
• Loaded Legacy GL, Transactional Data into HANA using SAP Data Services.
• Interaction with Verizon HANA team with conversion Related Issues.
• Worked on Material Master, Customer Master and Transactional Custom ETL in BODS
• Prepared Validation Reports through all test cycles for Business Leads and rectified pre-load errors.
• Responsible for Custom Lookup Jobs setup in Data Services for pre-validation of various objects. Also Responsible for AIO Framework Setup and knowledge transfer for the same.
• Tracked and Resolved various conversion related data/code defects using HPQC and Solution Manager.
• Trained Client employees in SAP BODS 4.0 & Information Steward during initial deployment. Responsible for Knowledge Transfer sessions for Client Employees for SAP AIO Methodology.
• Undertook training Sessions for Client employees for Creating Custom AIO jobs and creation of Technical Specification Documents
• Responsible for Initial data Profiling and Data health assessment for various objects
• Participated/Coordinated in Mapping Workshops & Functional specification Reviews.
• Communicated directly with business for Mapping Requirements & Development Issues
• Created Technical Specification documents as per SAP AIO Methodology

Confidential, Chicago IL

Sr. BODS Architect/Consultant

Responsibilities:

• Data Migration Lead providing SAP and Data expertise using Utopia’s Enterprise Data Lifecycle Management Methodology.
• Implemented AIO Lookup Jobs and setup AIO framework for Validations through lookup and check tables.
• Setup BODS connectivity with Client’s SAP Application using FTP Transfer Method & extracted all the Check Tables in Staging Area.
• Facilitated use of SAP Lookup Jobs & Migration Services Among the data migration team.
• Facilitated Data Migration/Conversion Process from Legacy to SAP
• Coordinated with client & provided DS documentation for all the objects and process logic being followed in data services.
• Designed Material Master Job in DS from Legacy to create Delimited LSMW Load Files.
• Pre - Assigned new SAP number to legacy materials to be loaded in SAP
• Designed, Developed & Implemented BODS-Workflows for Media Master, Media Family, Media Products & Media Issues (Hierarchical Master Objects)
• Developed Complex Sales Contract Validations & created Sales Contract Load files.
• Implemented De-Duping Process & other validations among various Objects.
• Developed Jobs & Validations for Series Product Hierarchy & Material Determination Objects and created LSMW load files.
• Worked with Data Extraction team to address the issues & exceptions caught in DS during conversion process.
• Worked along with SAP Techno Functional guys for streamlining the Loading of Various objects & implementing various business logics in Data Services.
• Developed PL/SQL queries to analyze the data and verify results in Microsoft SQL Server.
• Created Load files from various sources such as EXCEL, delimited files & Oracle .

Confidential . Baltimore, MD

Sr. BOBJ Data Services/ETL Consultant

Responsibilities:

• Coordinated with Data Integrator teams in resolving issues with data sources.
• Data Analysis of source systems to develop ETL business rules in SAP Data Services.
• Migration of ETL jobs from Data Integrator XI to Data Services 3.1.
• Migration of Data from Oracle 10g to Oracle 11g.
• Performed Unit Testing on SAP Data Services ETL jobs.
• Developed Dimensional Model and incorporated new dimensions in Star Schema.
• Developed PL/SQL stored procedures to incorporate complex business rules.
• Performed the duties of Data Services 3.1 Administrator in creating repositories and new users.
• Performed troubleshooting data discrepancies and mappings in existing ETL jobs.
• Coordinated with the Client in resolving issues with data sources.
• Worked closely with business analysts and project managers to definemigrationrequirements, transformation business rules, resource levels, estimates, dependencies and project plans.
• Implemented metadata standards for the developers to ensure completeness and accuracy.
• Assisted BO Data Services team in troubleshooting data discrepancies and mappings.

Confidential, Philadelphia, PA

Sr. Business Objects /Data Integrator Consultant

Responsibilities:

• Involved in complete SDLC of reports lifecycle.
• Installed and Configured Business Objects development and testing environment.
• Analyzed and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with ETL and Reporting system and also to successfully implement business logic.
• Experienced in loading from various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, MS Access, COBOL files & XML Files.
• Transformed data from various sources like excel and text files in to reporting database to design most analytical reporting system.
• Initiated the data modeling sessions, to design and build/append appropriate data mart models to support the reporting needs of applications.

Confidential, New York, NY

Sr. BODI/ Business Intelligence Consultant

Responsibilities:

• Designed business intelligence solution for full life cycle development of Service Provider reports and universes.
• Performed data quality analysis from source and target systems.
• Migration of legacy data into SAP environment which involves leading in the execution and documentation of the data migration process from legacy systems to SAP. And also Creation and management of various data governance processes and creation of procedures to govern data within the organization.
• Developed complex mappings utilizing built in Data Integrator functions, including reverse pivots, table comparisons, map operations, and SQL transforms
• Assisted Business Analyst in data quality analysis.
• Translated business requirements into architecture and functional requirements
• Analyzed report requirements and reformatted reporting layouts.
• Performed data mapping of Business Objects Universes in XIR2.
• Extensively used TOAD to performance tune reports SQL.
• Involved in troubleshooting issues during report migration from development to production.

Confidential

Business Objects Developer

Responsibilities:

• Developed SQL Queries and Reports for Business.
• Performed data quality analysis from source and target systems.
• Created Data warehouse using BO Data Integrator
• Worked with business on Data Mapping and Requirements.
• Worked with business on Data Mapping and Requirements.

Confidential

Business Objects Developer

Responsibilities:

• Worked with ETL team for setting up the event based trigger to write to BO server and scheduled reports based on the flag.
• Worked on various Data integrator jobs to change the current mapping of the existing tables or adding new tables in the database creating data flow for them.
• Extract Transform and Load was performed using BODI (Data Integrator).
• Reviewed business cases and managed report development schedule from design to release.
• Involved in design/approach, project team calls and meetings.
• Translated business requirements into architecture and functional requirements.
• Addressed system-specific issues, and evaluated alternate approaches and new additional requirements
• Involved in documenting alternate approaches for data consolidation for different business units.