Derick Benedict Email & Phone Number

Detroit, Michigan

Detroit, Michigan

Process and Data Analyst

Warren

Transformation Analyst

• Management, development and implementation of custom database systems and MS Access to schedule, route and collect product installation data for energy optimization programs for local utilities. Improved reporting.
• Create and identify validation and business rules for call center activity screens and remote crew tablet software user interfaces.
• Document business processes using Visio and update Policy & Procedures manuals for proper training of all employees to ensure standard work instruction.
• Identify and reduce waste through use of Continuous Improvement tools including documenting processes and supporting and implementing improvements identified during these activities.
• Design and test delivery of XML through Single Object Access Protocols to ensure secure transfer of sensitive data.
• Work with local utilities representatives to create daily custom reports to support their Energy Optimization requirements for the state of Michigan.

• Coordinated online marketing and advertising campaigns to develop new clients and prospective candidates. Sent out 35,000 direct emails per week.
• Created and used data tracking tools/analytics for process improvement. Identified and implemented strategies to increase direct email open rate from 10% to 20%.
• Managed multiple data bases including Brightmove, HyperTek and Savvy Sender. Included maintaining Subscription and Do Not Call lists. 170,000 total contacts.
• Conducted extensive internet searches to gather market data and tracking trends. Utilized Boolean search techniques.
• Located new candidate and client sources online. Used Broadlook tool, resulted in 3,000 potential new contacts per week.
• Developed strategies with the Recruiting and Sales Department to increase market penetration. Team efforts increased direct hire rate by 500%.

• Administered all aspects of order fulfillment including contract review, freight quoting, production scheduling, order entry, customer service, billing and logistics.
• Facilitated collection efforts by locating misplaced shipments.
• Managed cross-functional business unit relationships to achieve goals. Business units included: materials management, scheduling, sourcing, costing & design, engineering, and manufacturing.
• Software used: Oracle, AS400, JD Edwards, PeopleSoft, Siebel, SalesForce.com

• Order Entry, Contract Review, Customer Service, Freight Quoting and Production Scheduling.
• Responsible for database transition from AS400 and JD Edwards to Siebel. Responsible for data migration, user training, and process documentation, including creating user manuals.
• Siebel Database Manager for multiple Inside Sales Groups. Created and maintained database.
• Improved the accuracy of opportunities in the database to promote communication across product lines to increase sales.
• Coordinated marketing campaigns for Inside Sales Groups
• Facilitated internal communications with monthly publication of Inside Sales Group News Letter.