Andy Corson Email & Phone Number

Shelton, Connecticut

Shelton, Ct

•Created data solutions and complex audits for Supply Chain using SQL (queries, stored procedures), Excel, and browser-based reporting tools (SSRS, Power BI), including writing SQL code, designing interfaces (form layout and VBA coding), creating data connections, publishing solutions to eRoom/SharePoint and SSRS. •Maintain Supply Chain datawarehouse mirroring data in JDE ERP system, Worldwide item database (WID), and Manugistics Global Planning System (GPS) in near real-time, including updating data, new data integration (table creation, ETL process using SSIS, database enhancements), database maintenance (rebuilding indexes), creating custom views for users.•Ensure continuity in reporting (consistency in data sets, column names, etc) and maintain structure of reporting folders, files, etc. •Managed data synchronization process for all product lines and retail trading partners in order to maintain accurate product data.•Developed Business Intelligence tool for data reporting within Supply Chain and Network Inventory group.•Worked closely with marketing team and custom project coordinators to manage the new item life-cycle.•Designed and managed Supply Chain SharePoint sites and coordinated with IT on testing, implementation, and development, including site use strategy and workflow development.

Shelton, Connecticut

Newtown, Ct

•Worked closely with clients and client managers to gather requirements and write specifications formanual and automated reports; wrote SQL code and conducted quality control testing.•Took lead BA role on multiple major client implementations, conducting data analysis, data mappingfor ETL builds/troubleshooting, gap analysis, building client-specific reports (benefits tracking, monthlybilling/usage, exception reports).•Produced ad-hoc inventory and billing reports with strict deadlines using complex SQL queries andExcel.•Created dynamic SQL scripts for auditing client monthly spend and contract rates.•Documented process flows for reporting, data loading, and business-as-usual activities using Visio,Word, and OneNote.•Liaised with internal Analysts and Offshore vendors to trouble-shoot ETL process for client data loading.

Newtown, Ct

• Gathered internal client requirements and developed custom automated reporting solutions and ad hoc reports using SQL, ProClarity and Excel, including pivot tables with stored procedures, for direct marketing, circulation, finance and accounting departments. • Exceeded internal client expectations by developing reports in half of the time typically required. • Acted as liaison between IT, Accounting, Customer Service and Marketing to support business needs for company’s order processing and e-commerce systems. • Designed and executed use cases and user acceptance test plans for system enhancements and changes.• Significantly improved project tracking by developing and managing Microsoft SharePoint team site and integrating SQL queries, automated workflows, Access databases and pivot tables into SharePoint site. • Trained managers of other departments to create SharePoint content and use workflows.• Managed multiple team projects simultaneously by effectively delegating tasks, coordinating with internal teams and documenting progress. Presented concise resolutions to management prior to implementation.• Recognized by VP of Customer Service for outstanding documentation of system troubleshooting using Word, OneNote and Excel.

Newtown, Ct

• Conducted detailed analyses on new business and renewals for Direct Marketing department and issued reports to all levels of franchise management. • Forecasted revenue, ran what-if scenarios for quarterly budgets and projected new business orders (direct mail, magazine inserts) using financial and circulation modeling software.• Produced accurate and timely ad hoc marketing reports using ProClarity and Excel.• Managed profitable subscription agency business by negotiating higher than normal remittance rates.

Shelton, Ct

• Conducted detailed audits on publishers’ circulation databases and audience reach claims. Reviewed circulation and marketing practices for adherence to audit bureau standards.• Motivated and managed a team of 4 auditors to complete over 150 audits per six month audit cycle, consistently lead audit team to strong closings by exceeding goals.• Ensured superior customer service by managing client relationships throughout the audit process. • Improved Latin American client relationships by reducing audit time due to knowledge of language and cross cultural etiquette.

Greater St. Louis Area

• Supported software testing/quality control team by developing business requirements documentation, maintaining accurate test data, and converting data from Excel to an Access database.• Created use cases and executed test plans for customer billing software.

Ba, Germanic Studies

Activities and Societies: Graduated Magna Cum Laude with honors in Germanic Studies, Phi Beta Kappa, Minors in Spanish.

Education record