Benjamin K. Williams

• Worked with Business and Strategic Partners for the ERP implementation (Epicor Kinetic Cloud)
• Managed a team of thirteen, including two interns; team members worked in Azure, within a Data Vault 2.0 Data Warehouse, within Epicor Kinetic Cloud
• Oversaw development of Hytrol CPQ and Hytrol CPQ API.

• HR manager for five employees
• Performed technical interviews for job applicates in both IT and PMO department

• Worked with Business and Strategic Partners to implement ERP (Epicor Kinetic Cloud)
• Oversaw and approved of Technical Specification documents
• Managed the Azure Cloud instance including resource creation, IAM, and budgets
• Created multiple applications to pull from as400/iSeries, REST/OData APIs, and application backend database; saving the data into a data lake
• Created multiple applications to read from the data lake and write to a SQL Server 2022 based DataVault 2.0 Stage area which then loads data into the Raw/Business vaults
• Optimize query performance from Powever BI against DataVault Raw/Business vaults.
• Built out a Jupyter Notebook collection against the data lake to aid in data science, ML, and AI work.

• Wrote software to parse x9.37 files within data pipelines
• Wrote software to export data from Salesforce and create csv files from the data
• Wrote software to convert csv files to parquet files
• Wrote logic to send files to Google Cloud Storage buckets
• Wrote software to export data from AS400 and SQL Server and create parquet files from the data
• Designed and built an application to consume JSON formatted files from Qualys; loading the data into a database
• Wrote a bi-directional file translator between Finastra's PAYplus USA MAX Interface format and ISO 20022 PAIN 001/002 XML format
• Oversaw and coordinated DataStage ETL development (11.7.x)
• Oversaw, coordinated, and developed the SSIS and DataStage ETL jobs to populate the company-wide CRM solution (hosted on Salesforce)
• Lead redesign of vendor supplied ETL DataStage jobs to reduce run time from 9 hours to 3 hours
• Developed several business focused extracts from the AS400 into either Microsoft SQL Server or Flat File via SSIS
• Guided projects toward Tableau for their reporting and analytics.
• Wrote software that interfaced with flat and XML files to allow easier processing with SSIS
• Served on the Problem Advisory Board
• Created Tableau dashboards for data warehouse jobs, iSeries reporting, ITIL (Incident, Service Request, Change) reporting
• Designed the logical and physical ETL flows for CRM

• DevOps ETL/API for pulling Tyson sales data from WalMart's Retail Link service into in-house Tyson Retail Analytics data warehouse
• Overhauled the data restatement process from a blanket time based pull to a targeted pull based on differences between internal data and Retail Link; allowing data to match over all larger time range.
• Developed reporting to monitor the Retail Link users' item, fineline, and department access within Retail Link and show changes over time
• Built a "dual path" method to pull data from Retail Link that leverages both Web Scraping the main site and the SOAP API so data can be continued to be pulled when one method is down.
• Built a C# ASP.NET Web API to expose both Data Warehouse and live Retail Link data allowing it to be pulled and consumed by reporting applications or other systems without needing direct database access or external internet access.
• Built data extract processes to download, store, and report on OTIF scores and the underlying data that supports the score. This decreased or eliminated the amount of time that business had to work on Sunday and allows for identify operational changes during the current week to keep the score high.

• Developed and implemented technology reports and reporting APIs.
• Oversaw APIs connected multiple internal and cloud databases into API framework with private, limited access, and public calls allowing faster reporting by multiple technology teams.
• Built upon API of LeanKit, Jira, Visual Studio Team Server, and Remedy accessed by Tableau, Alteryx, Power BI, and in-house Angular/Loopback web site to display data at various updated speeds and to various audiences.
• Customized divisional reports consumed by technology, home office, and leadership.

• Designed, built, and maintained business intelligence reports for ITIL divisional management in Excel and Tableau.
• Built and maintained data loads from various systems into Hadoop and Greenplum for centralized reporting.
• Supervised data analyzed by ISD teams to determine priority/urgency and fed into executive dashboards to provide deeper insight into technology for vice presidents and executives.

• Oversaw LeanIT transformation and cross team collaboration.
• Served as ITIL problem coordinator, ITIL known error coordinator, and Lean KanBan champion.
• Coordinated 50 problems/known errors reducing year over year incident weekly rate by 1,000.
• Orchestrated work efforts with strategic vendor partners with efforts increasing gross profit by $800,000 to $1,400,000 per month.

• Directed assignments to team members and vendor partners in store systems supports including incidents, problems, change requests, training, ticket reduction, and workflow improvements.
• Provided subject matter expert level insights in POS code, site operations, and ITIL processes.
• Trained and documented as well as provided documentation to vendor partners and field services.

• Designed and managed support tasks and change operational flags for United States and international stores and clubs, about 10,000 sites and 206,000 registers.
• Oversaw donate prompt on registers for Children's Miracle Network Hospital fundraiser for US and Canada stores.
• Enabled Walmart.com functionality in neighborhood markets and select TLE registers.
• Added and updated PLU item selections for Japan sites.
• Developed support documentation and playbooks for team members involved in store system support POS.
• Served as member of POS/CASH ticket reduction task force designed and proposed projects and changes reducing incoming incident tickets by either process improvement or problem management.

• Developed software for point of sale system used in United States and internationally, about 10,000 locations.
• Supported US and Canada Walmart Stores and Sam's Clubs 2012 Black Friday event.
• Provided technical feedback during design sessions for projects entering production in 2013.
• Designed and coded several US and international projects entering production in 2013.
• Built process updating applications via TeamForge. 
  

• Oversaw numerous projects requiring expertise in software design, systems architecture, and data warehousing in SAP, Microsoft, and Oracle environments.
• Revived and designed PL/SQL processes computing financial data for major tobacco company.
• Updated SQL and recommended changes decreasing time needed to run financial calculations in CAS 6 environment of major television and film production and distribution company.
• Orchestrated and led two team members in data warehouse solutions in SQL Server 2008 for Innovative Systems' eLation for local telecommunication company.
• Built internal application and database for major healthcare brand development company.
• Architected and implemented database in SQL Server 2008 used by major agriculture company.
• Guided developed of better coding standards and hiring tests for SAP and T-SQL.
• Conceived several SAP conversion programs for major medical devices company.
• Led six-member team for development of SAP conversion programs.
• Composed SAP custom program with ability to output multiple reports.
• Created custom SQL Server backup solution in C#.
• Customized material reports in SAP for major medical devices company.
• Developed coding standards for reports having ALV requirements.

• Built MedEvolve's "eCeno", client/server solution written in Delphi 6 with SQL Server 2000 backend.
• Customized reporting done via SQL server analysis services.
• Resolved trouble tickets involving bad data or Windows configuration.
• Updated customer’s database and OLAP configuration on version changes of eCeno.
• Integrated changes to stored procedures to increased performance.

• Developed "AutoMailPRO 7", three tier C# 2.0 Winforms application using Access 2003 as backend.
• Facilitated support for Postal Services’ OneCode Solution.
• Integrated with Pitney Bowles’ VeriMove web service.
• Customized software to automate testing by comparing test data with known good values.
• Wrote software to convert program setting from one version of software to another.
• Spearheaded changes in both C# and Jet SQL to increase performance.
• Directed changes to business and database logic to support mailings of over 100,000 mail pieces.

Oversaw daily activities of five photo lab associates, trained associates on company policy and lab safety, ordered retail items and lab supplies, and performed maintenance on lab equipment.  Checked out customers, helped with purchases, resolved customer issues, and helped coordinate vendor demonstrations.  Led between five and ten remodel associates in daily activities, trained associates on company policy and workplace safety, and worked with remodel managers in planning assignments.  Collaborated alongside associates in cleaning, setup, moving, and zoning of retail areas.