SUMMARY:

• SAP Data Services Consultant with 20 plus years of design and development experience for Data Conversion, Data Integration, MDM, DWH and Confidential projects.
• SAP Data Services (BODS) developer experienced in 5 SAP IS - U/ERP implementations across Utilities, Retail, Manufacturing and Telecommunications verticals.
• SAP BODS SME in designing ETL jobs using Data Integrator, Data Quality, Platform and Text Data Processing transforms across workflows, dataflows using custom functions.
• SAP Data Quality (DQ) expert in implementing BODS DQ transforms in BODS jobs.
• SAP Information Steward (IS) expert in Data Insight, Metapedia, Metadata and Cleansing Package modules to assist with data mapping and data quality workshops.
• SAP Enterprise Information Management Techno-Functional consultant with expertise across SAP BODS/SAP EI/SAP DQ modules for data conversion and data integration projects across SAP and non-SAP data sources.
• Hands on SQL expert in writing SQL Scripts for database tables and index optimizations.
• Data Architect with ability to identify data points and data patterns across the enterprise and create design documents, data and process models and data dictionaries
• Expert Enterprise Data Management practitioner, metadata lineage expert, data quality driver experienced in executing data process workflows across data applications.
• Experienced data parsing solution specialist for structured and unstructured data sets.
• Experienced in Entity Extraction and Fact Extraction parsing using capabilities of SAP Data Services platform for customer and product ROI sentiment analysis.
• Delivery lead experienced in managing matrix global delivery teams.
• Experienced Data Conversion lead for On-Premise, IaaS, PaaS, SaaS implementations.
• ETE functional, configuration and data conversion hands-on resource skilled in ERP, cloud implementations.

TECHNICAL SKILLS:

Business Applications: SAP S/4HANA, SAP C/4HANA, SAP ECC, SAP CRM, SAP SRM, SAP BW, Sandhill B2B, Infinity QS, MCI OM, Dynamics CRM, SPSS, Quicken, Fujitsu Glovia ERP.

Confidential Applications: SAP Data Services, SAP Information Steward, SAP DQM, SAP Data Hub, SAP BO Data Insight, SAP BO Metadata Manager, Firstlogic ACE, Firstlogic IACE, Firstlogic Match Consolidate Firstlogic IQ Insight, Firstlogic DQ XI, Firstlogic IQ Watch.

Databases: SAP IQ, SAP HANA, SAP ASE, SQL Server, Oracle, Teradata.

File/Message Type: TXT, CSV, XML, XLS, XLSX, Cobol, iDoc, JSON.

Desktop Applications: MS office, MS Project, MS Visio, SAP Crystal Reports, SAP Lumira.

Platforms: Windows, Linux, AIX, Mac OS, AWS, Azure, Dockers.

Languages: SQL, Python, Java, HTML, VBA, COBOL, Perl, Shell, C.

METHODOLOGIES & PROCESSES: ACCN ADM, BO BISA, PMI, COTS, TQM, SAP Activate.

WORK EXPERIENCE:

SAP Data Services Consultant

Confidential

Responsibilities:

• Developed SAP BODS objects using DS transforms, functions and custom scripts.
• Worked with Emigall team lead to define and generate BODS conversion load files.
• Conducted data mapping sessions with legacy functional data owners.
• Conducted metadata and data analysis across legacy and SAP ERP/IS-U platform to identify data lineage issues and implement mitigation strategies, for date conversion jobs .
• Owned BODS design and development of 25 plus data conversion objects from legacy until EMIGALL load process across Devices, Billing, Installation and Meter Reads objects.
• Analyzed SAP Emigall data load logs to resolve higher level data object issues.
• Worked as BODS SME assisting other team members implement best practices.
• Optimized BODS jobs, workflows and dataflows for multiple data conversion objects.
• Worked with Functional teams to debug post data load issues using SAP T-Codes.
• Assisted Solution Architects to improve BODS SLA's for mock and cutover phases.
• Enabled adoption of master data and transactional data conversion best practices.
• Extracted executions metrics from BODS platform to optimize cutover timelines.
• Utilized SAP Information Steward platform for data profiling activities to identify DQ issues and metadata variations between source tables for same master, transactional data sets.
• Provide estimates to project leads to align deliverables with RICEF test phases.

Confidential

SAP BODS/DQM Lead

Responsibilities:

• Managed design, development and go-live of BODS ETL, A2A, data lake and DQM projects .
• Conducted workshops with functional teams to complete data mapping designs .
• Designed and developed BODS batch jobs with 1TB plus data set for ML initiatives.
• Optimized application performance issues to meet existing integration SLA's.
• Enhanced MDM architecture for Customer, Vendor, Material Master and Meter data.
• Participate & lead Business Requirements, Solution Design and Customer workshops.
• Developed BODS ETL jobs to de-dup BP data incorporating text parsing and DQ scores.
• Assisted business leads to solution data conversion requirements for M&A projects .
• Managed BODS matrix team across multiple project work streams.
• Regenerated SAP BODS ABAP programs for transition of SAP BW to Hana DB.
• Upgraded BODS 3.2 jobs to BODS 4.2 version using BODS upgrade utilities.
• Customized BODS 4.x including DQM adaptor ETL jobs for BP address cleansing.
• Developed BODS batch interface to load Billing data into SAP IQ DWH.
• Developed BODS Meter Data synchronization interfaces across two SOE/SOR systems.
• Designed BODS interfaces to load data into SAP BW from non-SAP sources.
• Optimizing SAP Data Services data quality platform for existing DQ framework for CDM.

Confidential

SAP BODS Conversion Lead

Responsibilities:

• Provided SAP BODS solution best practices to leverage data conversion and data quality capabilities across Data Conversion activities.
• Assisted program delivery lead to architect and deliver SAP DQM RICEF objects.
• Enabled adoption of customer data management practices using SAP DQM.
• Worked with legacy business data owners for conversion and A2A deliverables .
• Worked with EMIGALL development teams to generate BODS data conversion load files.
• Worked with BP leads to synchronize US Address rules for conversion and interfaces.
• Resolved BODS job performance issues to meet data conversion cutover time lines.
• Utilized SAP Information Steward platform for BP data profiling activities to identify DQ issues and then use BODS/DQM platform to develop address data parsing jobs.
• Conducted metadata and data analysis across legacy and SAP ERP platform to identify data lineage issues and also recommend mitigation strategies, for date conversion design.
• Owned ETE technical development and delivery of BODS technical objects for 80% of conversion objects.

Confidential

SAP BODS Lead

Responsibilities:

• Provided SAP BODS solution architect leadership to leverage Data Services integration and DQM capabilities across SAP implementation project.
• Worked with legacy data owners to finalize functional requirements and then own technical delivery of assigned objects from inception to transition to data conversion support teams.
• Implemented Rapid Data Migration for SAP Billing for Utilities framework for BODS.
• Customized BODS batch jobs leveraging SAP IS-U Data Migration framework.
• Analyzed Emigall logs to identify data load issues and make required BODS code changes.
• Optimized BODS objects including DQM adaptor real-time jobs for SAP.
• Drove adoption of customer data management practices for customer data across business owners to enable customer data quality alignment with regulatory requirements .
• Worked within Enterprise Integration team to develop integration patterns for batch data Integration across the enterprise between SAP and non-SAP systems.
• Conducted metadata and data analysis in ECC and CRM to identify data quality issues and also recommend mitigation strategies based on SOE/SOR for BP data.
• Delivered BODS/DQM 4.X POC solution and technical architecture landscape artifacts.
• Lead BODS application upgrade POC's from 3.x to 4.x and migration RFI responses.
• Migrated and optimized code for BODS 4.x platform for critical interfaces.
• Developed and migrated code from Informatica ETL platform to BODS platform as part of application rationalization project.
• Managed ETE ownership and delivery of documents including Technical Architecture, Functional Design, Data Mapping, Technical Design and Run Books.
• Managed ETE ownership and delivery of BODS technical objects, batch and real-time jobs.

Manager, SAP Confidential

Confidential

Responsibilities:

• Defined client executive leadership’s “Data Asset” organization strategies.
• Worked with client business units in implementing MDM best practices.
• Architected and managed delivery of batch data Integration blueprints and artifacts.
• Worked in technical architecture lead roles for solution delivery with core capability focus on SAP Data Services, Data Insight, Metadata Manager applications for data integration and data quality, from POC phase to delivery including SAP Hana/BODS POC’s.
• Worked as an organization wide SAP Confidential SMA assisting multiple projects RFP's/RFI's.
• Lead and Developed enterprise wide training program for SAP BODS application.
• Implemented SAP BO Data insight and Metadata Management applications.
• Implemented DQ rules and created scorecards in Data Insight.
• Created implementation plans, design documentation, data and process models.
• Worked with solution architects to design the data migration solutions.

Confidential

Data Integration Architecture lead

Responsibilities:

• Architected ETL data Integration solution for big data program requirements.
• Evaluated data sources in scope from data management, data quality and data integration.
• Conducted source system metadata and data dictionary analysis
• Conducted analysis on the necessary integration approach and patterns.
• Led Confidential version capability analysis between 3.x and 4.x platforms for BODS, DQM and IS.
• Produced the Interface Inventory including volumes, sizing, frequency
• Managed all resourcing aspects for data integration project team.
• Validated solution approach with client enterprise architecture guidelines.

Confidential

SAP Confidential / BODS Architect

Responsibilities:

• Coordinated review & approval of BODS application architecture.
• Worked on SAP Confidential POC's across client technical and business teams to introduce new platform capabilities for metadata management, data profiling, data quality and batch integration for business master data issues across SOE and SOR applications.
• Identified data quality issues and metadata variations across customer and material data.
• Participated as technical developer lead to showcase platform data quality capabilities.
• Worked with enterprise architecture to draft application roll out plan to connect to SOE and SOR to develop metadata artifacts.
• Leveraged SAP Confidential Data Insight capabilities to define data cleansing and matching rules.
• Created customized dictionaries for Product names and related name parsing rules.
• Defined weighted scores in DQ match jobs to create master record for MDE.
• Created CRUD matrix for master data entities.
• Worked with data stewards to create alerts in data insight.
• Created custom cleansing packages and published for usage in Data Services.
• Used BO Metadata Management capabilities to capture data entity metadata from enterprise applications.
• Worked with Business Units teams to create enterprise data terminology in Matapedia.
• Leveraged BOMM impact and lineage capabilities to do impact analysis for Data Model changes.

Confidential

SAP Confidential Delivery Lead

Responsibilities:

• Managed global matrix teams during all phases of the projects for successful delivery.
• Architected ETL data Integration solution for batch data integration requirements.
• Designated as program SMA for all SAP Confidential applications
• Produced the Interface Inventory including volumes, sizing, frequency.
• Managed all project resourcing aspects from analysis to go-live phase.
• Validated solution approach to align with enterprise architecture guidelines.
• Implemented SAP BO Data Insight data profiling rules across master data.
• Implemented SAP Confidential DQ practices for data conversion and data integration projects.

Confidential

SAP Confidential Solution Architect

Responsibilities:

• Coordinated review & approval of BODS application architecture.
• Defined ETL Batch Architecture framework which became the foundation of all batch integration projects across the enterprise to be used by all BODS ETL interfaces.
• Supported the analysis, functional design and architecting of multiple project interfaces.
• Rolled out BODS training programs for new integration team members.
• Removed data profiling activities show stoppers by introducing best practices.
• Participated as solution lead t o design program architecture deliverables.
• Worked on BODS POC's across the enterprise with technical and business teams to introduce new platform capabilities.
• Implemented DQ rules and created scorecards using Data Insight profiling capabilities.
• Leveraged Metadata Management module for existing data sets to analyze data lineage.
• Configured various source system and implemented profiling tasks like Column, Address and Uniqueness
• Conduct data discovery sessions with business and IT stakeholders.
• Identified data sets, developed data flows and analyzed data-related processes.
• Updated of enterprise data flow diagrams and enterprise data dictionaries

Confidential

Data Management Lead

Responsibilities:

• Identified business drivers with senior executives for Confidential initiative.
• Worked with enterprise architecture in defining Confidential solution architecture.
• Worked across business lines in prioritizing enterprise master data.
• Worked with business units in defining data governance model for critical master data.
• Analyzed existing operational applications from MDM architecture perspective.
• Evaluated operation applications and data integration points across the enterprise to fulfill reporting requirements.
• Worked on SAP Confidential POC's for business units to implement Data Governance across SOE/SOR applications.

Data Management Consultant

Confidential

Responsibilities:

• Identified business drivers and prioritized master data for MDM initiative.
• Worked with Enterprise Architecture in defining MDM architecture.
• Worked with Business units in optimizing data governance structure.
• Analyzed existing applications from MDM architecture perspective.
• Evaluated applications and data points across the enterprise for CRUD analysis.
• Analyzed lack of MDM strategy impact on Vendor, Customer, Product and Store entities.
• Evaluated MDM architecture for prioritized Master Data shared by SBU's.
• Worked with business to define MDG roles and responsibilities for identified MDE.
• Assisted in identifying MDM architecture style for prioritized MDE's.

Staff Consultant

Confidential, California

Responsibilities:

• Architected and managed deployment for Confidential /Firstlogic Confidential applications.
• Managed data integration/data quality and data conversion code and related deliverables.
• Installed, configured SAP BODI and FL DQM applications.
• Created data store configurations and developed ETL jobs using Platform/DI/DQ transforms.
• Implemented application architecture, ETL Architecture and DQ best practices.
• Provided strategic input for data sourcing initiatives to fulfill business user requirements.
• Solutioned and delivered data management processes using DQ tools.
• Assisted Practice Directors in completing estimates for RFP's and SOW's.

Confidential

SAP BODS Data Quality Consultant

Responsibilities:

• Defined SAP Data Conversion solution architected Data Services ETL and Data Quality capabilities for SAP implementation project.
• Worked with legacy data owners to implement MDM best practices to mitigate DQ issues.
• Created BODS/DQ artifacts leveraging Confidential framework for assigned objects.
• Drove adoption of data quality practices of data cleansing and best record generation.
• Managed ETE ownership of assigned artifacts leveraging SAP BODS platform.
• Lead BODS ETL and Data Quality POC's to assist business units for LSMW processes.
• Created and conducted training sessions for client resources and third party SI teams.

Confidential

Data Quality Consultant

Responsibilities:

• I mplemented best practices for customer data management.
• Worked with customer data stewards to define cleansing rules and best record process.
• Created data quality artifacts using SAP Data Quality platform.
• Managed ETE ownership of assigned artifacts including KT to production support teams.
• Lead data quality POC's to assist multiple business units with MDM processes.
• Customized data quality rules based on metadata analysis of the source systems.
• Created customized dictionaries for Company names and related name parsing rules.
• Worked with business data stewards to implement MDG processes for MDE.

Confidential

Data Quality Consultant

Responsibilities:

• Implemented best practices for duplicate data identification for customer data warehouse.
• Worked with customer data stewards to define cleansing rules and best record process.
• Created data quality artifacts using SAP Data Quality platform for Confidential identification.
• Lead data quality POC's to assist multiple business units with data pattern definitions to identify same data sets across the enterprise.
• Architected, installed and configured data quality ETL applications in client environment.
• Implemented best practices for master data sets based on data pattern identification.
• Worked with data stewards to define cleansing rules and duplication process.
• Created and documented ETL/data quality artifacts using SAP BO Data Quality platform.
• Lead data quality POC's to assist multiple business units with MDM processes.
• Customized data quality rules and parsing directories to meet end client requirements.
• Optimized Workflows and Dataflows to meet SLA benchmarks.
• Implemented data pipelines for address data using in-built and custom operators .
• Worked with data stewards to define cleansing rules and duplication processes .
• Created and documented data quality artifacts using Information Quality platform.
• Customized data quality rules and parsing directories to meet end client requirements.
• Optimized base IQ matching algorithms to improve similarity scores.

IS Analyst

Confidential, California

Responsibilities:

• Assisted ROI teams identify new revenue stream by delivering data integration processes.
• Implemented Statistical Process Control (SPC) and CRM application enhancements.
• Created Information management strategies incorporating FDA and ISO 9001 guidelines.
• Coordinated data process re-engineering initiatives impacting data collection points.
• Developed plant quality rating application in excel improving productivity by 400%
• Developed ERP pricing application in Access for a functionality for a COTS ERP.
• Defined enterprise data standards for customer service and quality assurance initiatives for prioritized master and transactional data driven by metadata analysis.
• Developed data conversion jobs and scripts to generated load files.
• Recommended SPC application to executive leadership after an RFP/RFI process.
• Managed SPC application POC's to enable benchmarking against business and architecture requirements to align with C-Suite and Manufacturing Plant requirements.
• Worked with selected vendor to define the application and technical architecture.
• Worked with business units to cleanse plant and product master data.
• Lead application functional configuration and data conversion activities.
• Created global plant roll-out plan for the SPC application including end user training.
• Worked to streamline business process at the shop floor and plant teams with application capabilities to enable integration with ERP and reporting applications.
• Analyzed existing CRM system capabilities to identify functional capabilities.
• Documented functional requirement for enhancements.
• Identified data integrity issues by conduction data profiling activities within and against identified SOE/SOR application.
• Expanded CRM to cover sales, marketing and customer support teams in South America, Asia and Europe.
• Designed and delivered application training to end users and administrators.
• Worked with application vendor to enhance application data integrity checks.
• Defined data steward roles and responsibilities to improve data quality.
• Created custom operational reports from backend using SAP BO Crystal Reports.

Implementation Engineer

Confidential, California

Responsibilities:

• Defined implementation project methodologies for data migration/data quality processes.
• Acted as data steward for marketplace customer, product, pricing master data.
• Designed training methodologies and mentored new team members.
• Assisted clients in defining metadata enterprise standards and data dictionaries.
• Worked on data conversion for structure, unstructured and image data.
• Created data conversion ETL jobs using custom and BO ETL platform.
• Cleaned customer and vendor address data using Firstlogic applications.
• Created data conversion processes from paper forms for data conversion activities.
• Defined specifications for real time data integration using BizTalk platform.
• Worked with Data Stewards to implement data processes for master data sets.
• Used Firstlogic DQ platform to standardize customer and vendor addresses.
• Generated B2B sentiment analytical metrics using Firstlogic parsing platform.
• Worked with sales teams to identify applications in RFP and SOW scope.
• Worked as application functional lead to configure application for admin and end users.
• Worked on defining SQL data extraction requirements from client source systems.
• Used ETL and Data quality tools to cleanse and load data into marketplace databases.
• Defined and implemented data governance rules for marketplace administrators.
• Worked with product teams to define application enhancements requests.
• Worked as QA signoff lead for defect fixes required for successful implementation.
• Worked with training teams to customize training content for each customized marketplace.
• Worked with Data Stewards to implement master data approval workflow processes.
• Worked with architecture teams to validate infrastructure readiness.
• Worked with marketplace owners and product sales teams to configure supplier buyer relationships and pricing aspects of the supplier buyer relationships.
• Worked as application functional lead to configure application for admin and end users.
• Worked on defining SQL data extraction requirements from client source systems.
• Used ETL and Data quality tools to cleanse and load data into marketplace databases.
• Defined and implemented data governance rules for marketplace administrators.
• Worked with product teams to define application enhancements requests.
• Worked defining and testing real time data integration requirements using EDI and XML.