Ronald Drake Email & Phone Number

Shakopee, Mn

• Created production kitting and shipping documents as well as associated electronic files• Analyzed, Extracted, Transformed and Loaded (ETL) structured and unstructured client data for internal production documents• Collaborated with Sales, Project Managers, Kit Engineering and Kitting to eliminate ambiguity• Managed multiple domestic and international projects with fixed deadlines• Streamlined consolidation of Veracore Inventory reports in to Excel, reducing work-time by… Show more • Created production kitting and shipping documents as well as associated electronic files• Analyzed, Extracted, Transformed and Loaded (ETL) structured and unstructured client data for internal production documents• Collaborated with Sales, Project Managers, Kit Engineering and Kitting to eliminate ambiguity• Managed multiple domestic and international projects with fixed deadlines• Streamlined consolidation of Veracore Inventory reports in to Excel, reducing work-time by 66%• Created documentation for internal processes Show less

Eden Prairie, Mn

• Supported successful company-wide transition from Cognos Impromptu 7.2 to Cognos BI 10.2 (reporting tools)• Coached non-IT employees transitioning from Cognos Impromptu to Cognos Report Studio• Prepared weekly / monthly reporting for 16 seasonal holiday promotions, delivered 3 versions of metrics to Corporate, Sales and Accounting

Eden Prairie, Mn

• Developed, documented and delivered standard and ad hoc reports to senior management, domestic and international sales teams, and other company departments using Cognos Impromptu with Excel• Scheduled and ran 200+ automated Cognos Impromptu reports on daily, weekly and monthly basis distributed to network or SharePoint locations in Excel or Adobe PDF format• Created an Excel solution to combine 36 report outputs into 1 at the touch of a button• Sales incentives: Interpreted… Show more • Developed, documented and delivered standard and ad hoc reports to senior management, domestic and international sales teams, and other company departments using Cognos Impromptu with Excel• Scheduled and ran 200+ automated Cognos Impromptu reports on daily, weekly and monthly basis distributed to network or SharePoint locations in Excel or Adobe PDF format• Created an Excel solution to combine 36 report outputs into 1 at the touch of a button• Sales incentives: Interpreted promotion intent, collaborated with other departments to finalize specifications. Calculated and published promotion goals as required. Accrued monthly rebate values for Finance and provided Finance final rebate values to be paid.• Designed, tested and deployed an integrated Microsoft Excel and Access solution for sales promotions reporting and rebate accruals• Collaborated on an Excel solution to pull images into a report with the option to set image size and destination column.• Created and provided Excel training to other departments• Created Anagram specific documentation for new Impromptu users• Item master data: verified compliance with company standards, initiated correction as needed• Evaluated software for possible deployment (Tableau 7.0 Desktop, Hyperion Interactive Reporting Studio 9.3 Desktop Show less