Rod Ritchie Email & Phone Number

Milwaukee, Wi

Long-term engagement to decommission legacy business applications, including the archival of associated data, in the event of future litigation. Responsible for migration from Proof of Concept environment to a full-featured, production-level environment and process.• Decom Execution Analyst and Decom Tools Support resource for a team of five, ultimately responsible for the decommissioning of approximately 800 legacy applications.• Performed application and data analysis to develop an application decommissioning strategy, and associated data archival plan.• Interacted with application stakeholders to obtain approval of the decommissioning and data archival plans.• Coordinated IT resources and managed the formal change process for the removal of applications from the production and supporting environments.• Worked with DBA resources to perform legacy data capture, validation, and final archival, including the assignment of data retention rules.• Developed and enhanced multiple MS Access and VB.Net tools to aid in the validation and archival of legacy data, including the handling of global data and the associated character sets, in Oracle and MS SQL Server environments.

Chicago, Il

IT Director • 1990 – 2006Managed all aspects of the Information Technology department, supporting $75-million in annual sales for wholesale sporting goods distributor. Responsible for company-wide needs analysis, requirements gathering and business process design for all mission-critical systems.• Technical lead in all aspects of application design, development, implementation and support• Instituted a full-featured EDI program in support of major retailers such as Sears, Target and Meijer.• Spearheaded committee of user representatives in the development of a RFP, which served as the template for selection of a $2.5-million commercial ERP software solution.• Served as liaison between the software vendor and corporate department heads, facilitating the design and development of $500,000 in Informix-based software modifications.• Developed a suite of approximately 100 Cognos Impromptu reports and PowerPlay cubes, in support of corporate BI requirements, addressing areas such as category profitability and inventory management.• Developed MS Access and Visual Basic applications to serve as a real-time interface between internal order processing systems and Internet fulfillment sites.• Provided ongoing support and enhancement of Informix 4GL programs, extending the capabilities and performance of the corporate ERP system.• Lead a business relocation project, including transfer of office operations, design and development of new operational processes and supporting applications, and transfer of $15 million of sporting goods inventory.Senior Programmer Analyst • 1982 – 1990Instrumental in the development and implement of custom-coded enterprise system in a COBOL / CICS / IMS environment. Progressively assigned more complex application development projects, and continually assumed additional analysis, design, development, and operational responsibilities. Fulfilled the database and system administration roles in the IBM VSE environment.