Responsibilities include:

Managing and defining data solutions for internal ExxonMobil projects.

Designing and modeling databases using ER/Studio for internal projects utilizing a multitude of tools like Access, SQL Server Management Studio, Tableau, SAP Business Objects Data Services (BODS), etc.

Received EBX by Orchestra Networks Data Management Software Training.

Received Python Training.

Data Lead on Project to de-merge Company Code for all Retail Locations in Germany. Physical Business locations moved to a Branded Wholesaler model and the country was split into 8 regions and 11 company codes from just 1.

Data design lead to move SCADA Pipeline readings from an ACCESS DB to a new SQL Server DB. I created the data model in E/R Studio and built the new DB in SQL Server Management Studio. I created 3 new forms in the ACCESS application and linked to SQL Server with ODBC.

Data lead on new Sales Opportunity application in Salesforce which is taking over from existing Seibel CRM system. Data from the Seibel system and from SAP is staged in a Data Hub and views created in SAP S4 HANA to feed the data through the Mulesoft ESB to the Salesforce tables for Products and Accounts.

Created BODS Jobs with over 700 Workflows to pull SAP ERP tables’ data and write to SQL Server Database for Auditing Group.

SAP Data lead on ERP Transformation Project. Client is moving from SAP ECC 6.0 to Cloud-based SAP S/4 HANA1610.

Responsibilities include:

 Managing the creation of Function Specification documents for 87 Migration Objects by the Functional Team.

 Managing the creation of Technical Field Mapping documents for 87 Migration Objects by off-shore Development Team
in India.

 Deciding migration methodology for 87 Migration Objects. Tools being used are SAP LSMW, BODS/IDOC (SAP Data Services), and the S/4 HANA 1610 Migration Cockpit.

 Making changes to S/4 HANA delivered Migration Cockpit Objects using the Data Modeler inside the tool for adding fields and/or creating new objects for Hershey’s Migration Objects that are not included in the delivered S/4 HANA Migration Cockpit product.

 Assisting Hershey with the mapping of the SAP ECC 6.0 data to the new S/4 HANA 1610 system. This include both the MDG (Master Data Governance) tables inside S/4 HANA as well as the S/4 HANA tables.

SAP Data lead for IS-A-DBM client. Responsibilities included:

 Project Manager for roll-out of SAP UEM by KNOA software

 Project Manager for rollout of SAP Single Sign-On (SSO)

 Data Lead on all Dealership/Branch Go-Lives (every 2 months for last 4 years) for all Master Data loads in all modules, including, assets, customers, vendors, vehicles, parts/materials, pricing types, condition records and procedures, info records, contracts, employees, user id’s, and user security roles, along with all Data Governance guidelines.

 Led effort for development of methodology for removing duplicate customers and the way conversions from the legacy system will be done moving forward.

 Responsible for converting all Zip Codes to +4 to accommodate roll-out of SABRIX tax solution. Done with MELISSA address standardization program.

 Responsible for maintaining Users and User Security Roles through SU01, SUIM, and PFCG.

 Occasionally debugging and fixing Enhancement Z-programs in User Exits by coding ABAP changes and modifying Z-tables

• Corporate Project Data Lead at Fortune 200 Energy company, AES, in Arlington, Va. I was responsible for developing overall methodology for data migration as well as coordinating the delivery of functional and technical specifications to the offshore teams in Beunos Aires, Argentina and India for all conversion objects as well as time and budget estimates for each. Responsibilities also include writing of all Data Cleansing Procedure documents, and all Data Migration Procedure documents for the methodology approved by the steering committee. I also helped in the data cleansing with the Business Owners of the legacy systems’ data and converting legacy data into SAP Configuration values to prepare the data for the LSMW load programs for the following objects

• GL balances to ECC 6.0
• GL historical balances to BW
• Material Master
• Vendor master
• Cost Center upload
• Profit Center upload
• Intercompany customers
• Assets master data and balances
• HR Organizational data upload
• HR Employee master data upload