Sr Software Engineer - RPGLE/SQL

Steve McDaniels

Phoenix, AZ ***** 602-***-**** *************@*****.***

Professional Summary

Motivated Senior Software Engineer with 30 years’ experience developing new systems while supporting and fixing issues in older legacy applications running on an IBM Iseries platform.

Proficient in both RPGLE/SQL and all associated versions since the System 36 was around and currently using the Agile/Scrum methodology.

Results-oriented with excellent communication skills to transform non-technical stakeholder requirements into complex technical requirements of the project.

Excellent record of leading and developing teams in enterprise-wide development projects.

Skills

Hardware: IBMi, Iseries HA, AS400, system 38/36, Sql Server and Postgres

Languages / Software / Tools: RPG Freeform, RPGIV ILE, SQL, RPG400, RPG3, CL, IFS usage, Qshell, Java400, Microsoft Office Tools, Some Excel Upload Macros, FTP, Embeded Sql, Turnover and Aldon Source Management, Haweye object Analyzer, XML, DBU and DBVIS.

Systems: I have worked on ALL areas of support for Automotive Retail for 30 years. From Accounts Payable, Lawson Financial/Hr, to Warehouse Operations and everything in between.

Skills: Programmer Analyst, Mathematics Analyst, Software Developer, Troubleshooting, Communication Skills, Business Analyst, DB2 Database Design, Technical Design, Project Lead and 18 years as a Manager.

Work History

Sr Software Engineer, 01/2016 to 04/2020

O'Reilly Auto Parts – Springfield, MO

In this position I executed all steps of the project development life cycle daily. Attlasian Tools used to manage task, issues, time management. Learned and supported all systems under the Pricing Team umbrella.

Enterprise, Market, Bid, Formula and Segment Pricing flavors supported

Created multiple XLSM Macro Uploads (VB Script) to push csv to IFS for import Procesing

PROS Pricing System (analytics and more) support all feeds from Iseries uaing xml(.gz) for updates

Designed and built a whole backend for the Labor Claims system including a Scoring Engine Procedure deciding what level of approval will be needed to process the Claim

On Call Support

Applications Development Manager, 07/2011 to 12/2015

O'Reilly Auto Parts – Springfield, MO

Promoted to Applications Manager after assuming the role without title Mid 2011.

Managed all Development (Front and Back End) in support of Professional Sales and Marketing stakeholders whose initial focus was to build a new B2B website for our Professional Customers to look up and order their own parts. Most applications have an Iseries backend with stored Procedures executing business logic and returning the data to the calling service.

Accomplishments:

Built team from 6 to 19 at one point. RPG/Java/UI/UX/DBA

Built B2B firstcallonline.com (FCO) early 2013 using Spring/J2EE. Increased electronic sales by 300% in the first 2 years. Site averaged 1.3mm a day mid 2015

SupplyLINE - Vendor Oreilly Portal - Completely rewrote and skinned while upgrading to WebSphere

Online Credit Application - Created an Online Credit Application for our customers to request or change a charge account. System feeds to back end systems to process credit checks etc

Shop Referral - New Professional Customer application to capture every type of information about our customer and their shop. The data is presented on our Ecommerce site as "Find a Shop/Mechanic"

Rewrote Customer Rebates and added Tiered Sales Goals &created a new Earnback System feeding credits to Lawson

Multiple Marketing Promotional systems with Web GUI Interface within FCO and Iseries backend feeding credits to Lawson Financials

My Director Retired and Mgmt decided to move all IT management to be based out of Springfield. My FCO front end Team incorporated into the Ecommerce Team under a new director. All FCO back end systems, Team members and myself was moved to the IT Pricing Team as Sr Software Engineer.

Sr Systems Analyst II, 01/2010 to 06/2011

O'Reilly Auto Parts – Springfield, MO

First promotion since the merger with CSK. An older flavor of the project development life cycle used back then. a Project Document was always required needing signoff before development begins. Starting to use Jira and Confluence to track tasks and projects.

Rewrote Store Turns business logic in a procedure. Modified all 3 Turns systems execute same newly defined logic

Lawson Upgrade from 8 to 9 and then to V10 most currently.

Rewrote Gross Profit System

Began rewrite Professional Customer Rebates. Complete cleanup / rewrite incorporating Tiered rebates by sales volume into all of the different variations of Rebates

I was moved to lead the FCO team and launch the new B2B site as long as I finished the Tiered Rebate rewrite which was done and successful.

Sr Systems Analyst, 01/2008 to 12/2009

O'Reilly Auto Parts – Springfield, MO

O'Reilly Auto parts purchases CSK Auto Inc.

Titled down from Sr Manager of Applications Development to Sr Systems Analyst on the Finance/DataWhse team. Report to Director of Financial Systems.

First year was involved in all the store conversions to the new hardware and software and data conversions

Supported many systems under the Finance umbrella

Pipe updates to the stores from Corporate using old Socket technology

Built quite a few data sets used by the Supplier Portal to view Sales, Trends, Projections.

Sr Manager Applications Development, 01/1997 to 12/2007

CSK Auto Inc – Phoenix, AZ

Support Professional Sales and All Special-Order Systems and the Electronic Parts Catalog. CIO directive, added Hand Held PDA (Java) Development under my teams umbrella early 2000's.

Built multiple PDA device applications used by both the Field Professional Sales Force and Store Management to increase sales and present information to our customers real time

The Java directive morphed into more Java Sales/Inventory Dashboard site for Executive Management team. Really cool stuff at the time

CSK Auto purchases Murray's Discount Auto Parts located in the Midwest. Headquarters Detroit MI. Lead the team to get the CSK Electronic Catalog up, checking their inventory and ordering parts from the Murray's Store Locations

State of the art Electronic Parts Catalog - Used by O'Reilly to this day

Designed and wrote a Tiered Commercial Pricing system

Built an Automated Store Special Order system that can view real time Quantity on Hand from Surround Stores, Hub Store, DC and hundreds of Vendors. O'Reilly just deployed an internal only system

Education

2008

RPG Teacher / Mentor - Phoenix Region Office, AZ

When O’Reilly purchased CSK Auto, CSK had a 24/7 Computer Operations Center which was going to be dissolved as part of the merger. I was asked to put certain Computer Operators through an RPG for Dummies training course. They first did an online course to get the basics from zero knowledge.

I wrote a 12 Test Training course with everything from Parameter, Arrays, DS, Klist,Reads, Chains, Batch updates, Simple screens and multiple subfiles with Position To /Fold and all sorts of goodies.

Out of 6 participants 4 passed and became all different levels of developers. Two of them are still team members and one retired.

References

References available upon requested.

Contact this candidate