Consolidated Pipe and Supply, Birmingham, AL • 2014 - Present
Manufacturer, distributor, and service provider of pipe solutions
Sr. Systems Analyst
- Served as the sole technical design and programming resource for all facets of data migration from a homegrown IBM iSeries-based system to a SaaS ERP solution (IFS). The resulting system achieved the following implementation results: ➢ Less than 60 of 50M exported records required manual corrections ➢ On-hand variance from $250M in inventory was less than $2,200 ➢ System downtime was less than 12 hours ➢ Account receivables migrated with no deviations
- Utilized swim lane and ERD diagrams to document the source- and destination-system data models along with their associated business processes.
- Implemented automated quality feedback loops for monthly ERP “go-live” simulations used to verify the continued integrity of the data migration processes.
- Acted as a manufacturing subject matter expert in evaluating requirements ERP fitness configuring and verifying the production control and capacity planning parameters for all engineer-to-order, make-to-stock, and make-to-order pipe manufacturing environments.
Skills: IFS ERP • RPG III/IV/Free • SQL • Procedures • Modules • Service Programs • Binding Language • CL • Hawkeye • RPG Toolbox • Excel • Visio • Jira • SharePoint
Hibbett Sports, Birmingham, AL • 2013 - 2014 and 1999 - 2004
Athletic-inspired fashion retailer with over 1,100 stores
Sr. Systems Analyst
- Provided 24/7 IBM iSeries-based software support to a 400k square foot distribution center servicing over 950 retail outlets
- Evaluated and recommended vendor-based software solutions to senior-level management
- Served as software change management coordinator
- Ensured interface quality between warehouse management, merchandising, and transportation management systems
Skills: PkMS WMS • Island Pacific Retail • JDA Retail • RPG III/IV/Free • CL • Hawkeye • Aldon • RPG Toolbox • DBU • Excel • Visio
Protective Life, Birmingham, AL • 2010 - 2013
Life insurance and annuity underwriter
Reinsurance Systems Manager
- Led a team of analysts responsible for creating, maintaining, and auditing acquired reinsurance contracts totaling $600 billion in ceded life reinsurance coverage
- Provided data mapping and testing support for system conversions involving $500 million in life insurance premium
- Identified integrity issues in legacy mainframe systems before transferring data to target systems
- Implemented a secure SharePoint-based system of searchable PDF files of reinsurance contract parameters
Skills: TAI Reinsurance • IBM JCL • Oracle • Access • Excel • Visio
Cinram, Alsdorf, Germany • 2005 - 2010
Formerly a manufacturer and distributor of digital media
Sr. AS/400 Programmer Analyst
- Led the implementation of WMS modifications specific to the implementation of a new European-based distribution center
- Optimized the processes associated with picking, put away, location setup, cross-docking, and inventory tracking
Skills: RPG III/IV • CL • Hawkeye • Implementer • DBU • Excel
Vesta Insurance, Birmingham, AL • 1995 - 1999
Formerly an underwriter of property and casualty insurance
Sr. AS/400 Consultant
- Converted a legacy property and casualty policy rating system to ILE RPG and reduced implementation and testing time from six months to three weeks.
- Worked with actuaries in developing reports for pricing analysis, loss reserve and financial statement accruals, retention analysis, and financial modeling.
- Developed reinsurance reporting system.
Skills: RPG III/IV • CL • Hawkeye • Turnover • DBU • Excel