Mark Stetson Email & Phone Number

Deployed new and modified code to improve supply chain in-bound processing. Documented business requirements (functional and systems). Insured completeness of SOX compliance. Conducted walk-through reviews to obtain signoff from business, technical and management stake holders. Deployed a modification to the web based furniture sales channel incorporating web, client server and main frame applications. This allowed consumers to shop on line and then be referred to the nearest store which had samples of the furniture they had chosen. Coordinated on-shore, off-shore, vendor and corporate development resources.Deployed an account receivable system which used web based front end to allow salvage customers to select, reserve and pay for salvage merchandise. As an Operations Advocate, coordinated and enforced quality control insuring the successful migration of new and modified code from initial conception into production. Documented use cases and test scenarios. Developed requirements for test data and facilitated ETL of test data from production to test environments; from unit testing through user acceptance testing; and post production issue resolution including issue tracking, root cause analysis.Mentored new Operations Advocates.

Deployed Phase 3 of the enterprise level Direct to Consumer Strategic Growth Initiative (DSGI). Enforced compliance with change control and quality assurance guidelines. This phase brought the warehouse management system on line.Administered mainframe test regions by maintaining the Configuration Management Database and producing daily audit reports of test environments for the enterpriseDocumented processes and procedures used in developing and maintaining test environmentsEdited Business Continuity Documentation to insure compliance with enterprise standards. Compiled an inventory asset checklist for building environments to support testing needs.

Created queries to reconcile two legacy sales reporting systems, Margin Minder and BASIS, with the Enterprise Data Warehouse daily and resolved any discrepancies noted. Efforts saved company approximately 400 man-hours dailyReverse engineered Teradata reports into Margin Minder reports.Using Remedy, provided resolutions to simple and complex end user generated change requests and problem tickets for over 18,000 Margin Minder users.Data StewardMonitored and maintained automated daily sales reporting updates to the Teradata Enterprise Data Warehouse (containing all the sales information for CCE for three years) including 24 X 7 on call first line support.Contributed to monthly payments of several million dollars through producing and validating weekly EDI transmissions of sales information from Teradata Enterprise Warehouse to Coca-Cola and Dr. Pepper.Produced, from the Enterprise Warehouse, and transmitted monthly case sales report to Dr. Pepper. Report facilitated payments from Dr. Pepper that generated approximately 8% of Coca-Cola Enterprise's sales revenue.

Managed an on-line automobile insurance claim database on a Teradata database computer. Maintained system availability at over 99% during 24 X 7 operations.Extracted, transferred and loaded data; researching and resolving issues as they arose.Acted as Database Administrator to maintain and quality assure over 11,000,000 claims with over 7,000,000 monthly updates.

Collaborated, as a Subject Matter Expert, on the design, development and testing of a prototype automated Quality Assurance program. Savings from implementation of the program were estimated to be over $1 million/year.Monitored and resolved escalated issues for the enterprise consumer credit reporting database involving customer reported consumer information while insuring compliance with all federal, state and local regulations.Managed national and regional account relationships by facilitating the transfer of account receivable data from credit grantors to the national credit reporting system.Developed and maintained largest regional database for company. Quality of database resulted in maintaining a market share of over 90% despite the entry into the region of the two largest national competitors.

Foreign and Domestic Assignments