Data Sap

Greg Allen

***********@*****.*** Charlotte, NC **203 980-***-****

Summary

Accomplished leader with 10+ years of progressive ERP (Enterprise Resource Planning) functional support in a manufacturing environment. Proven track record of providing value to business leaders through analytical, strategic and technical support. Objectively seeking a position as an independent ETL Developer consultant.

Academic Background

Bachelor of Science, Finance concentration High Point University, High Point, NC 2008

Technical Skills

ETL Tools: Pentaho Data Integration/Kettle 7.1; Microsoft SQL Server Integration Services (SSIS); SAP LSMW

ERP Software: SAP; S/4 Hana, R/3, 4.0/5.0/6.0, MDG 7.0, BW 3.0/BI 7.0; JD Edwards; Epicor; SAGE

MDM Tools: SAP NetWeaver Business Client; SAP MDG version 7.0; SAP SQL Server 2008 R2

Reporting Tools: JIRA, Pentaho Report, MS Excel; MS SQL Server tools

Database Tools: MS SQL Server Management Studio 2012, 2008 R2; MS Access; Teradata SQL Assistant 14.01

Other Tools: MS Visio, Office, SharePoint, Project; HP ALM QC; Serlio CaseComplete; Siemens Team Center

Professional Profile

Camso Inc. (Optomi LLC), Charlotte, NC

Data Migrator (Consultant) 03/2017 – Present

Utilize Pentaho Data Integration/Kettle to design all ETL processes and to extract data from various ERP systems and external files, cleanse and load data into target enterprise data warehouse.

Extract master and transactional data from existing legacy ERP systems (i.e. Epicor, SAGE) using Pentaho Kettle ETL tools.

Transform data into templates for upload into SAP S/4 Hana using SQL queries and Java scripts.

Coordinate with project team members using JIRA agile project management software with daily Scrum updates.

Maintain defect logs during the testing and maintenance phase of development.

Extensive master data management (MDM) experience in Development, Test and Production environments.

Experience in full life cycle including project scoping, requirements gathering, system analysis, design, development, testing, implementation and maintenance.

Bank of America Corporation (Apex Systems), Charlotte, NC

AML Business Data Analyst (Consultant) 08/2016 – 12/2016

Established and communicated Enterprise Data Management (EDM) standards to business partners and track adherence.

Leveraged Teradata SQL Assistant to query, model and analyze results from databases across several platforms.

Ensured the metadata is captured accurately and help with providing sustainable solution to maintain accurate metadata on an ongoing basis by working with individual Front Line Units (FLUs) and AML program partners.

Drove Governance routines and provide status on effectiveness of Data Governance & EDM engagement within Corporate Compliance and AML programs.

Established Issue Management routines for tracking and reporting Data Incidents.

Maintained enterprise data mappings consistent with internal policies and standards.

Assisted with ongoing examinations and make recommendations for improved data management and/or reporting.

Established KPIs and provided transparency through KPI measurement / reporting.

Ensure Application teams adhere to data governance polices driven by EDM requirements

Coca-Cola Bottling Company Consolidated (Beacon Hill Technologies), Charlotte, NC

Master Data Supervisor (Consultant) 05/2016 – 08/2016

Industry: Beverage

Responsible for Material/Vendor master data conversion from SAP legacy system to SAP MDG 7.0 and NetWeaver Business Client

Responsible for the maintenance of master data records in SAP to the highest level of accuracy

Ensured the team configures and maintains standard and custom tables, and background data feeds

Established standards, process, and governance procedures to ensure data accuracy, validity and completeness

Actively supported the correction of master data related system interruptions with a heighten sense of urgency

Worked closely with business process owners to ensure consistency and maximum leverage of master data

Responsible for overseeing the launch of new products and the SLAs and quality standards were met

Electrolux North America (TekPartners), Charlotte, NC

Sr. Master Data Analyst (Consultant) 03/2015 – 03/2016

Industry: Appliances

Processed reference and master data maintenance request as appropriate within the Finance area

Utilized SQL queries to extract and consolidate data from sales order processing systems (SAP, JD Edwards, etc.) and warehouse management systems (WMS)

Used advanced excel functions such as Pivot Tables, V-lookups and embedded SQL queries for data modeling purposes

Developed, maintained and implemented appropriate metadata schemas and data dictionaries

Regularly reviewed and ensured master and reference data were up-to-date and accurate in all systems

Ensured established controls and processes were followed

Compiled month end financial reports for upload to various systems

Honda Aircraft (DataMasters), Greensboro, NC

Master Data Analyst (Consultant) 01/2014 – 01/2015

Industry: Aircraft – Light jet manufacturing

Ensured SAP master data accuracy and completeness

Verified master data within (Siemens) TeamCenter for product lifecycle management (PLM)

Facilitated master data management and data governance team for Honda’s commercial aircraft division

Developed and implemented new technical functionality for SAP system to meet business requirements

Utilized Visual Basic macros for routine functions

Prepared documentation and training for Customer Service procedures

Became a system business process owner for all master data processes for materials, vendors, and customers

Provided support as needed to business users, including cost analysis, cost control, claims administration and Service Center personnel

Developed and implemented governance oversight and metrics to successfully manage operations to achieve financial, operational and customer service objectives

ConvaTec Inc., Greensboro, NC (AeroTek)

Global Master Data Analyst (Consultant) 07/2013 – 01/2014

Industry: Pharmaceutical – Wound Therapy, Ostomy

Supported Global Master Data Manager in projects relying on SAP supply chain data

Liaised with finance, change control, logistics and other internal and external contacts to obtain master data information

Extended, created and updated bill of materials and routings for new and existing products in coordination with manufacturing plants

Entered transfer prices, purchased info records, sales price condition records and freight condition records in SAP

Performed scheduled audits on item and other supply chain related master data at a global and client level to ensure accuracy and compliance and manage updates as required

Honda R&D Americas (InfoVision/NEC), Marysville, OH

SAP Business Analyst (Consultant) 01/2013 – 04/2013

Industry: Transportation – Commercial nonphysical research

Defined metadata in the process of mapping legacy source and SAP target systems

Wrote test scripts and documentation for system and regression testing in an SAP environment

Elicited, composed and presented Business Requirement Documentation (BRD) defining the project scope and expected deliverables

Created and managed agile use cases and software requirements in (Serlio) CaseComplete 2012 R2 for shared projects

Exported requirements, use cases and test scripts to HP ALM - Quality Center 11.0 (HP-QC)

Assisted in SAP migration using Warehouse Management (WM) and Materials Management (MM)

Participated in the Extraction, Transformation, Loading (ETL), Legacy System Migration Workbench (LSMW), testing and migration process of data from legacy systems to SAP

Conducted and supported User Acceptance Training (UAT) as the Information Technology liaison

Polo Ralph Lauren, High Point, NC

Data Analyst (Contract) 01/2012 – 12/2012

Industry: Textile – Apparel, Clothing

Provided data maintenance and support for conversion from Business Warehouse (BW) 3.0 to Business Intelligence 7.0

Involved in production support issues like performance tuning of query and loading of data for optimization into the SAP SRM 5.0 module

Created and designed standard and customized SAP BW reports and BRD documents for purchasing decision making after eliciting requirements from department heads and end users

Coordinated Vendor Maintenance processes and SRM Catalog management

Created and maintained vendor master data and ensured data integrity and conformance

Performed mass updates and uploads of vendor and supplier master data using Legacy System Migration Workbench (LSMW)

Provided support, resolved issues, monitored workflows, managed reference tables and mapped data

Syngenta Crop Protection, Greensboro, NC

Business Process Analyst (Contract) 08/2011 – 09/2011

Industry: Agribusiness

Identified opportunities to improve finance master data maintenance processes as part of a project team

Developed and adapted desktop and standard operating procedures for User Acceptance Training (UAT)

Successfully implemented master data changes and UAT from SAP ECC 5.0 to SAP ECC 6.0 for facilities in

Europe and Mexico

Removed incorrect, incomplete, improperly formatted, or duplicated data as part of the cleansing process and uploaded to SAP Business Warehouse (BW)

Informed and trained the finance user community in various countries via Microsoft SharePoint software

Pepsi Beverages Company, Winston Salem, NC

Senior Business Analyst 01/2011 – 04/2011

Industry: Beverages, Soft Drinks

Served as SAP ECC 6.0 process functional expert liaison and assisted in the Equipment Service Management (ESM) Implementation project and SAP CRM Release 6 upgrade

Assisted in successful integration and testing of the in-house ERP (SAP) system with the external EDI system utilizing Software Development Lifecycle (SDLC) from a functional standpoint

Utilized advanced SAP Business Explorer (BEx) for reporting and analysis

Formulated and executed SAP Business Explorer (BEx) queries for data extraction and verification

Worked with bottlers for EDI conversion and inventory management via SAP, EDI, and middleware systems

New Breed Corporation, High Point, NC

Business Reporting Analyst 03/2008 – 01/2009

Industry: Logistics, Supply Chain

Consolidated and composed reports relevant to 3PL for the Verizon Wireless Reverse Logistics program

Streamlined the reporting process for customer to enable increased accountability

Aggressively pursued improvement in validations, controls, timeliness, procedures, etc

Created detailed BRD documents clearly summarizing the month end reporting results

Utilized SAP R/3 Business Information Warehousing 3.0 (BW) module to consolidate data sources

Composed and executed SQL queries for data extraction and verification prior to Legacy System Migration Workbench (LSMW) upload to SAP

Archived data using SAP Business Intelligence (BI) tools

Worked with Business Explorer and Web Application Designer for integrating reports to web

Performed extensive ad hoc reporting, data extraction and data modeling

RF Micro Devices, Greensboro, NC

SAP Master Data Analyst (Contract) 11/2007 – 03/2008

Industry: Semiconductor, Integrated Circuits

Participated in a master data conversion project utilizing SAP ECC 4.0

Successfully completed a master data conversion of two smaller companies post acquisition

Utilized SAP Materials Management (MM) module to create Bill of Materials (BOMs), raw material and finished

goods masters for wafer chip components used in cellular devices

Created and maintained Material Masters and Customer masters

Maintained SOPs and processes for ensuring ongoing master data integrity

Implemented Engineering Change Orders (ECOs) within the material master for routings

Participated in Supply Chain Management (SCM) team objectives

GAI Finance, Greensboro, NC

Finance Recruiter (Consultant) 05/2005 – 10/2007

Industry: Staffing, Recruiting

Conducted executive search and placement of finance and information technology professionals

Networked with other recruiting firms in securing candidate job opportunities and split placements

Performed all contract negotiation, review and approval for contingency job orders

Facilitated client and candidate interviews

Volvo Trucks North America, High Point, NC

Business / Financial Analyst 01/2000 – 04/2005

Industry: Commercial Transportation

Managed SAP/R3 Finance and Controlling (FI/CO) conversion project to automate vendor payments and financial

reporting in SAP Business Warehouse (BW) resulting in $1 MUSD efficiencies

Created glossaries to define metadata definitions including tables, columns, data types, procedures, functions and triggers

Worked with Legal and Purchasing for contract reviews and negotiation

Managed printer, copy and fax conversion project resulting in $5 MUSD cost reductions

Managed FedEx online shipping project resulting in $2.5 MUSD cost savings

Composed and managed $15 MUSD expense and $50 MUSD capital budgets

Created standard and ad hoc report extracts from SAP drilldowns and queries and SAP BW 3.0 reports

Adhered to Sarbanes-Oxley (SOX) compliance to achieve corporate objectives

Utilized Internal Rate of Return (IRR), Net Present Value (NPV) and sensitivity analysis for capital investments

Conducted financial forecasting, account reconciliation, variance analysis, general ledger analysis

Contact this candidate