SUMMARY:

• As a Sr. SAP Data Migration / Data Services (BODS) / Data Quality Management (DQM) / Information Steward (IS) / SAP ABAP Lead Consultant, I have been actively involved in the IT industry since 2000.
• In my career, I have been an ABAP Programmer/Team Lead, an SAP Data Migration Lead, a DQM Consultant, a Data Services ETL Consultant, a Technical Analyst, an ABAP Performance Analyst, an LSMW/Migration Cockpit/BODS/RDS Data Migration Consultant, an Oracle/SQL Server Programmer & a Trainer - a good team player with strong technical, communication & leadership skills.
• I have been involved in over twenty full life cycle ECC R/3 & S/4 HANA Greenfield Implementations as a Data Migration and a Technical Architect, in SAP Production Support projects, in Support Pack upgrade projects, Data Services/BW ETL Integration projects & Data Analysis/Cleansing (Information Steward/Data Services)/Migration projects, spread across various industries including Manufacturing, Public Sector Utilities, Aerospace & Aviation, Insurance, Threat Detection & Security, Textiles, Apparel, Power and Automation, Telecommunications & Biomedical Instruments, among others.
• To be part of an SAP implementation team in either of these capacities:
• Lead a Data migration team starting with the initial extraction strategy by working with the business/IT team to understand the various legacy sources/unstructured data/excel sheets, connection parameters to the legacy systems, thru to the mapping/profiling phase to understand the object/table/field/value level mappings/transformations, data cleansing strategies including Master Data Management, De-duplication/golden record identification, data Standardization/Enrichment and thru to strategies for logging load statistics/run times for cutover planning, reconciliation strategies at every stage from legacy to extraction to conversion to the load file, and with SAP for all Master & Transaction data objects, including balancing financial accounts, inventory balance reconciliations (stock quantity & value), etc., through to planning test cycles, cutover strategy, FUT/IT/UAT testing, and Production Loads/Validations/Reconciliations.
• Lead an SAP ABAP Technical team through the initial system/client landscape, object/transport naming conventions/transport strategies, determine development standards/interface/conversion strategies/tools, gathering user requirements thru functional specifications, designing the technical approach, optimizing performance, thru to realization - building WRICEFF development objects using SAP best practices - writing testable code using ABAP Unit Testing for trackable unit test plans/string test plans/test execution, taking it thru functional unit testing/integration testing/user acceptance testing, creating technical and unit test documents, deploying the solution in Production, and taking it successfully through hyper care & stabilization.
• To be part of an ETL/Data integration team working to design/code/automate/move/integrate data from one or more sources through Data Services to a Business Warehouse or another Reporting system, through various Data Services development stages including Batch/Real-Time Jobs, Staging/Conversions/Transformation, all the way thru to a robust error handling strategy.
• To be a Data Quality Management (DQM) consultant, configuring Data Services (BODS) & Information Steward (IS) to perform data profiling, conducting data quality assessments to identify data quality exceptions and prepare mitigation plans, lead data quality workshops to review quality exceptions and develop business rules, working with the data/process owners and the project team.
• Configured SAP Data Services and Information Steward to perform data profiling
• Worked extensively with profiling/cleaning SAP Customer & Vendor Master Data objects.
• A good understanding of SAP OTC & Purchasing processes.
• Worked extensively on address cleansing using various Data Services address cleanse transforms, both from an initial migration perspective & an ongoing/scheduled data quality management perspective.
• Experienced in profiling various master data objects and in identifying data quality exceptions
• Have conducted data quality assessments to identify quality exceptions and preparation of mitigation plans
• Have lead data quality workshops to review data quality exceptions and develop business rules for data
• Configure connectivity within SAP Data Services and Information Steward to source data
• Develop data quality mitigation/remediation plans
• 12+ years of experience performing Data Migration and Data Integration activities within large scale complex SAP programs and projects, including using Data Services, Data Quality Management, Information Steward, Rapid Deployment Solutions, MDG, ILM
• Extensive experience migrating data through Data Services Rapid deployment solutions (RDS), all the way from data extraction, data cleansing, data standardization, de-duplication, data validation & IDoc loading & data reconciliation. Extracted data from multiple systems/databases including Oracle, AS/400, Sybase, etc.
• Experienced in Data cataloguing, data lineage analysis.
• Experienced in using SAP Accelerator for Data Migration by BackOffice Associates & in using the Data Stewardship Platform by BackOffice Associates to organize and setup an In-Context Project Management Console to manage project hierarchy, project waves, managing users & their permissions, managing worklists & in tracking the status of individual tasks, enabling an easy centralized management of migration objects.
• In my most recent project at Confidential Group, I was Involved in leading the stabilization of the data migration processes, including fine tuning the processes/programs/methods/team used to load data. Validations/error logging/run statistics/reconciliation strategy were all implemented in a structured way to move the team away from a reactionary mode to a pro-active mode, to successfully hit the next planned go-live date.
• Technical expertise in: Data Models, Database Design Oracle SQL, Siebel SQL, Access queries & report writing
• Coordinate the formal capture, analysis and remedial action of data related faults found as part of the testing cycles, & also co-ordinate data cleansing activity
• Execute Data Migration test cycles & test scripts in accordance with agreed ERP testing and Data Migration strategies
• Experienced doing multiple Customer/Vendor Master (BP’s in S/4 HANA 1511) & Material Master Loads. And in other Master & Transaction data spread across SD, MM, FI, CO, PP, LE, PM, WM, IM, QM in ECC R/3 / HANA S/4 (1511) / IS-U in objects such as Pricing, PIR’s, BOM’s, Routings, Open Sales/Production Orders, etc., using LSMW, Custom ABAP/BAPI’s, BODS/Rapid Deployment Solutions, S/4 HANA Migration Cockpit.
• Execute Extract, Translate and Load (ETL) processes and protocols e.g. data repositories, extract histories, error trapping conventions, error resolution processes and sign-off criteria, operating on the agreed ETL toolset and processes
• Upload programs were built both to support data migration activities (repeatedly used across multiple roll-outs), as well as for ad-hoc loading of BOM/s, Routings, Component Allocations, BP Partner Profile updates, Warranty claims, etc., all to be used as needed in the Production environment.
• Extensive experience in staging/converting/loading data using various tools including BODS - experienced with BPDM’s, Rapid Deployment Solutions, Designer, Data Quality/Integrator/Platform Transforms, DQM’s, Data cleansing/profiling/standardizing, address cleansing using Match transform break keys & address directories and used Information Steward to work on data profiling/data quality monitoring & metadata analysis.
• Data Migration from Legacy systems using LSMW, EMIGALL, SAP Data Services (BODS), Cransoft/DSP, Winshuttle - Multiple end-to-end ECC/CRM Master data loads including Customers, Vendors, Materials (all views), Pricing, BOM’s, Routings, WorkCenters, Account Master, Contacts Master, Opportunities using LSMW/BAPI’s/IDoc’s/BDoc’s/BODS & IS-U migration using EMIGALL/BODS
• Update test rig to capture test scripts, sequencing, faults, patches and remedial actions as a result of data related faults
• Was leading an ABAP team since May 2016, implementing S/4HANA across multiple business units with a technical team strength of 10 off-shore and 4 on-site developers - developing Reports, Interfaces - Scanner interface, Checks/ Confidential /Positive Pay/Payment advice interfaces, Multiple Enhancement types, Adobe Interactive Forms, Fiori Apps, RF developments to support WM picking/put away & Conversion programs to support data migration. We successfully rolled out our templates and completed 6 S/4 HANA 1511 implementations in 18 months, going through blue print, realization, integration/regression testing, go-live, hyper care, stabilization & production support.
• HANA Architecture, Creation of Core Data Services, HANA Modelling, System Landscape Transformations, Writing OPEN SQL’s, New Enhanced SQL’s, Overall Integration, HANA Studio, Eclipse
• Experienced across modules FI, CO, PS, SD, MM, PP, LE, WM, IM & systems ECC R/3, HANA S/4 (1511), IS-U
• 15-20 successful ECC R/3 & HANA S/4 end to end implementations in varying capacities across a wide range of industries, as an ABAP Technical Lead
• 5 years of multiple IS-U Utilities implementation & development in FI-CA including Billing and Invoicing, Device Management, Customer Service, PM, etc.
• Main enhancements include building Vehicle Management Systems (VMS) Action Codes, Old material number substitution BAdI’s/Associated MATMAS extensions to support data migration and interfaces, COOIS field additions, FBL3H role based enhancements/additions, GGB1 Finance substitution rules, VOFM pricing routines, etc.
• File based interfaces include AP Checks, Positive Pay, Confidential, EDI’s 850/862/856/810 (we didn’t have a middleware in REV, so we processed our files thru an external translator to convert to EDI format, hence file based), Inbound/Outbound delivery confirmation from/to an external warehouse provider, etc.
• Bolt-on interface developments include Paymetrics for Credit card processing, GenSuite for dealer purchase portal & Vertex for Tax processing.
• Adobe form developments included everything from a Purchase Order to Picking/Packing lists, Invoices, Order Confirmation, etc.
• Main reports include the Daily Material flow analytical report (built in ABAP because we didn’t have a BI system in place), Trial Balance report (used parallel cursors to optimize performance, processing data from ACDOCA), Routing Analysis report to accurately reconcile the planned/actual working hours, multiple report enhancements/additions.
• Fiori developments were mainly centred around configuring and activating 10-20 standard Finance apps, but also built a couple of custom apps for a Transfer Order Confirmation, as well as one for a Bin-to-Bin Transfer to support material put-away after processing a GR thru MIGO.
• Creating Screens, Function Modules, Enhancements to support wireless RF terminals and devices to support WM processes, including GR, GI, Put Away & Picking for Delivery.
• Experienced Programming in ABAP Objects, GUI controls of the Control Framework (CFW), Composing Interfaces, Event Handlers, etc.
• System enhancements including Classic/Kernel-based Business Add-Ins (BADIs), Explicit/Implicit Enhancement Options, Enhancement Framework, User exits
• Performance Optimization including evaluating SQL/Buffer/HTTP/ABAP/RFC/Enqueue Performance Trace, Introscope Trace, Code Inspector, Single-Record Statistics & End-to-End Runtime Analysis
• Advanced Error Handling & Testing concepts including Assertions, Class-Based Exception Handling, Module Testing Tools including ABAP Units, Memory Inspector & Runtime Analysis
• Experienced in Support pack upgrades & Enhancement Packages - using SPAU & SPDD to process/reconcile standard/custom code & data dictionary objects.
• Dynamic Programming including Run Time Type Services (RTTS), Dynamic Token Specifications, Transient/Persistent Program Generation
• 5 years of multiple IS-U Utilities implementation & development in FI-CA including Billing and Invoicing, Device Management, Customer Service, PM, etc.
• Multiple CRM Enhancement developments, including making fields mandatory in a business transaction, defaulting values in a business transaction, updating values in one transaction based on the value entered in another transaction, using custom date rules, performing partner determination, determining organizational models, etc.
• Creating, coding and configuring custom IDocs and extending standard IDocs, across standards X12/EDIFACT and transactions 846, 850, etc.
• Internet Communication Framework (ICF), Synchronous/Asynchronous Remote Function Calls, Complete Inbound/Outbound External File Interfaces, Web Dynpro applications - WD component/view/view context, configured & built Custom IDOCs from scratch, & have extended multiple standard IDOC’s, ABAP Web Services
• SAP NetWeaver AS ABAP’s & S/4 HANA’s Workbench Tools including Data Dictionary, Function Builder, Class Builder, Menu/Screen Painter, Object Navigator, Business Object Builder, BAPI Explorer, Authorization Objects, Form Printout’s including Adobe Forms, SAP script & Smart Forms

PROFESSIONAL EXPERIENCE:

SAP Data Migration Lead

Confidential, St. Louis, MO

Responsibilities:

• Validate Information Platform Services and Data Services installation and make environment recommendations
• Validate and advise on storage and deployment strategy, based on requirements
• Provide guidance on integration exception reporting and recovery processes
• Configure data stores to support source/target connectivity to Informix and SAP HANA
• Coach Client teams on effective requirements gathering and key design considerations
• Discuss best practices on integration and determine appropriate design model templates
• Build prototype artifacts using masked/mock data (POC)

SAP ABAP Technical Lead

Confidential, Milwaukee, WI

Responsibilities:

• I am the ABAP Tech lead, leading a group of 5-13 on-site & off-shore consultants working on implementing / rolling out S/4 HANA 1511 across these business units
• We went live with 5 manufacturing locations & with Confidential.
• I was involved in working with the functional consultants/business to understand the requirements/design & build technical specifications & the programs needed, including Workflows (for Engineering Change Management), Reports (mostly Finance reports, but being increasingly replaced by Fiori apps), Interfaces (mostly for positive pay, Confidential, checks, credit card processing, tax), Conversion Programs (for the data team if they run into challenges with some transaction data), Enhancements, Adobe forms, MICR Check Printing, OMLV/OPK8 print settings, etc.

SAP Data Migration Lead

Confidential, Milwaukee, WI

Responsibilities:

• Involved in leading the stabilization of the data migration processes, including fine tuning the processes/programs/methods used to load data.
• Validations/error logging/run statistics/reconciliation strategy were all implemented in a structured way to move the team away from a reactionary mode to a pro-active mode, to successfully hit the next planned go-live date.
• Made a decision to move away from BODS to LSMW, in consideration of the short time involved between the roll-out’s (usually a few months), & also the objects/volumes we were trying to load.
• We had outsourced our BODS support to an external company, & found that every small tablespace overrun or some other job failure reason needed a 24-hour turnaround time to fix because of the different time zones we were working in, & we were losing valuable time because of this. We moved to building a few LSMW programs (temporarily turning off data loads from BODS - using BODS only for data profiling/cleansing) & delivered all objects in a few weeks & were able to keep the planned go-live date.

SAP BODS/DQM Lead

Confidential, Columbus, OH

Responsibilities:

• I was building a custom tool involving BODS/DQM to clean Address Master records in SAP – be it Customer / Vendor or any other addresses in the system, using Data Quality Management (DQM) / Information Steward (IS) & various address cleansing transforms & directories in BODS to pull data from either SAP and/or non-SAP systems – as part of a migration process or a production support process - to cleanse/de-dup/standardize and load the addresses back to SAP. With very little customization, this application can be implemented across multiple customer systems and landscapes to cleanse US & international addresses.

SAP Data Migration / BODS / DQM Consultant

Confidential, Falls Church, VA

Responsibilities:

• Responsible for coding and unit testing of applications capable of handling large volumes of data
• Experienced in analysing & debugging ETL job failures, data replication jobs and resolving job failures in a time critical load environment.
• Extensively used data stores, work flows, data flows, & various transformations in designing jobs.
• Used break keys in match transforms with other address cleansing data quality transforms to cleanse/standardize/de duplicate & validate customer addresses.

SAP ABAP / Data Migration Lead

Confidential, Vista, CA

Responsibilities:

• I was also involved in setting up data for a BW environment using BODS – pulling data from multiple legacy sources and from SAP, writing into a SQL server database target, from which BOBJ universe drew reports. Created SmartForms for picking & packing list.

SAP ABAP Lead

Confidential, WA

Responsibilities:

• I created/modified new/existing Web Dynpro applications, & backend RFC’s in SAP for various customer actions like scheduling payments, reversing a previously scheduled payment, etc.
• I was also building interfaces to process the credit card payments thru an external vendor, & building programs to support customer communications management that send out emails & mobile texts when customer payments become due.

SAP ABAP Lead

Confidential, Boise, ID

Responsibilities:

• I was supporting the NetWeaver BW 7.3 implementation at Confidential by enhancing standard extractors, writing BAdI enhancements & utility programs, and by managing the transport process.
• I was also involved in tuning the performance of a bunch of pre-existing programs.
• I was also involved in setting up data for BW from legacy systems, using BODS to integrate/move data.