Data Conversion Software Development

Scott E. Thomas

Frisco, TX ***** 773-***-**** **************@*****.***

SAP Data Conversion Manager

Efficiency-focused solutions manager with 15+ years of SAP ECC/S4 data conversion experience, including vendor, customer and materials. Strong understanding of coding languages, report creation and automation, and software development. Recognized for saving $600K+ by creating reports identifying duplicate payments to vendors, as well as for improving delivery time for SACCAF W4s by automating scorecards and improving HR applications. Skilled in process optimization, database management, and reporting.

Software Development Auditing Data Conversion Global Project Management Migration Leadership Automation Process Improvement Quality Control Calendar Management Cross-Collaboration Database Management Process Optimization Back End Management Delivery Systems Report Creation

Technical Skills

SQL, SAP - 16 years HANA SQL - 7 years BODS (ETL) - 9 years Informatica (ETL) - 5 years Tableau (Working Knowledge) - 2 years Pentaho (Open Source - ETL) - 4 years Teradata - 8 years Visual Basic, DOS Scripting, Batch Files, SSIS, SSRS - 13 years Excel and Access VBA - 15 years .NET, Oracle, C# - 4 years

Professional Experience

PepsiCo, Inc. Frisco, TX 10/2022 – 4/1/2024

SAP Technical/Functionall Lead

FDL (Functional Data Lead) Be responsible and take ownership for the end-to-end delivery of the Supplier Object from Extraction through Transformation and Loading including testing and validation of the solution including Business Sign off through all test cycles and go live.

Lead data conversion activities (validation, cleansing, identify omissions, fill gaps, eliminate duplicates and mapping) to ensure valid and accurate data by target data with business sign offs and support data cut over activities.

Partner with Business Data Team, Legacy, deployment, and cutover teams to ensure conversion FMDs are associated to the correct deployment to support the business processes.

Deliver PQGC Data Acceleration FMD's and CDD documents for all sources (MFG Pro and ECC).

Identification of Data Quality rules to ensure integrity of Supplier Data in PQGT (cleansing, pre load, and post load).

Work with GDQ to ensure cleansing rules, pre-load and post-load rules are accurate and useful objectives.

PepsiCo, Inc., Chicago, IL & Frisco, TX 2007 – Present.

SAP Conversion Manager (Technical Conversion Lead) (ESSA, FLNA and Quaker), PTP - RTR Domains 2018 - Present

Managed development team on SAP Data Conversion Project including project planning, to transports of development and changes from the development environment into the production environment for ESSA and FLNA conversion project.

Responsible for the analysis, design, customization, and operations of PTP legacy systems into S4.

Managed Team to deliver source to target transformation conversion from legacy extract, HANA SQL views and BODS used for ETL.

Managed Developers and provided design and requirements to handle multiple source systems (Poland (ECC), Poland (Oracle), UK (Oracle)) on ESSA conversion project.

Managed multiple source systems (Frito US and Frito Canada) with the functional team to create and provide Field Mapping Documents (FMD) to conversion development team on FLNA conversion project.

Actively involved in the planning and execution of sprints in Azure ADO.

Worked closely with value stream and attended sign off meetings on business requirements (Functional Mapping Design).

Technical Lead, HR Data Conversion into Salesforce

Manage global HR data cleansing project by overseeing UI and SQL back end, writing over 5K rules.

Worked with Salesforce team to create flat file templates to migrate data into Salesforce.

Cleansed and migrated HR data into Salesforce.

Technical Lead, MDMR 1&3 Domains 2015 - 2018

Develop UI platforms for SAP conversions, supporting data cleansing and verification for SAP releases 3-6. Optimize operations by developing ad hoc reports as well as centralizing reporting processes. Improve delivery time for SACCAF W4 by automating scorecards and utilizing existing process to centralize delivery of reports through existing GDQ scorecard. Deliver all MDM work intakes to plan, supporting MDM report requests, QAR, and FLASR.

Scott E. Thomas 773-***-**** Page 2

Spearhead program development by designing and developing transactional vendor and customer reports, as well as creating VERKBELEG supply chain transactional reporting.

Revamped complex project at risk of failure by identifying, documenting, and resolving issues.

Serve as primary IT contact for end-to-end delivery of two offshore projects, overseeing a team to provide baseline support across North American and global data quality suites.

Lead tech team ETL and UI for cleansing as well as the conversion and verification of scorecards to support start-up business operations, overseeing deployment of supporting activity to ensure accountability.

Developed FLNA quality assurance reporting (QAR) to validate legacy systems to SAP ECC (.net SQL).

Technical Delivery Lead, Release 7.2 - 7.5 2010 - 2014

Develop UI platforms for SAP conversions, supporting data cleansing and verification for FLNA 7.2 and 7.5 releases. Lead baseline work by managing tickets associated with project deliveries. Certified compliance with internal company requirements by developing PFSS audit reporting.

Implemented reporting initiatives by designing and developing tax delivery system for IRS audits using Informatica to convert to BODS with SQL server as back end.

Led tech team of up to six on end-to-end development for R7.2 through R7.5 data cleansing, verification, and post-production audit sync reports, delivering solution within time and budget constraints.

Led migration with Teradata by collaborating cross-functionally and attending ORT meetings, ensuring that solution design and project plans aligned with strategic business goals.

SAP Data Conversion & Development 2007 - 2010

Optimized data refreshing and restoring by streamlining end-to-end processes. Created COPA mapping report to identify planning errors, providing baseline support for 300+ active QARs and automating QAR processes. Supported business data cleansing, verification, and legacy system conversion by creating UIs, supporting SAP data conversion for releases 3-6 by utilizing MM, CM, and VM loads.

Developed complicated HR application by utilizing C# to design database model and ASP forms, leveraging database and Excel data management to compare FTE hours against projects.

Saved $600K+ by supporting PFSS, creating buildout reports to show duplicate payments made to vendors and identifying potential duplicates before delivery.

Previous Professional & Consulting Positions

Excelon/ComEd, Oakbrook, IL 2005-2007

Business Analyst & Developer

Designed and developed residential and commercial electricity billing application for 100+ users. The application allowed the user to pull into their que to work account. The tool also had very robust dashboard driven reporting capabilities. Microsoft Access and VBA were used.

Quill Corp, Lincolnshire, IL

Business Analyst & Developer

USG, Chicago, IL

Data Analyst & Developer

Contact this candidate