Ben Jackson Email & Phone Number

Atlanta, Georgia, Us

ETL: automated the process of loading, quantifying, and reporting supplier risks to $8.2B line of business. Equipped management team to identify, evaluate, and prioritize risk exposure areas in the supply chain. SQL: Coded easily maintainable ETL processes in SQL via SSMS and SSIS utilizing correlated subqueries, table variables, and pivot tables. Data Testing Environment: Implemented methodology for promoting project changes from Dev to QA to Prod. Interviews: Performed technical interviews for nearly a dozen analyst candidates Timelines: Partnered with management in setting timelines for two signed SOWs

Atlanta, Georgia, Us

Atlanta, Ga, Us

• Currently utilizing SSMS, SSIS and VS to develop Enterprise Data Warehouse consolidating data from numerous company acquisitions into single data warehouse. • Gave company automated visuals for first time on percentage of customers retained during provisioning process.

Boston, Massachusetts, Us

• Partnered with Business Intelligence Analysts to redesign twenty-report Microsoft Excel and Word process. Increased efficiency by reducing four step process into automated one-click report package with standardized formatting. First time this was ever completed. Hosted on proprietary Report Gateway tool. Power user of Microsoft Visual Studio, SQL Server Management Studio and SQL Server Reporting Services.• Led effort to enable customizable formatting for entire report package completely eliminating formatting errors and allowing for uniform professional look and feel.• Served as main point of contact for troubleshooting 35 queries and Report Gateway platform issues. Utilized temp tables, subqueries and complex joins with parameter within UDF functions.

• Compiled list of twenty-seven stakeholders (report users) across two departments having data migrated to Duck Creek data.• Interviewed all stakeholders to compile comprehensive list of thirty-three reports used.• Identified RDL files and extracted SQL code for each report used by stakeholders, creating a list of 340 data elements used across all reports.• Created list of nineteen distinct data elements requiring escalation to the internal migration team and Duck Creek for inclusion in database prior to report development and data migration. • Collaborated with SQL developers to ensure new Duck Creek reports functioned the same and returned accurate data compared to previous SSRS reports.• Performed regression testing in Tableau Server for sixteen reports using migrated Duck Creek data.• Collaborated with stakeholders to perform User Acceptance Training of new reports using Duck Creek data.• Collaborated with Project Manager to track progress on all reports, ensure timing was on-track for scheduled delivery, and escalated any roadblocks.

Contract Position - Senior Analyst• Coded back-end SQL queries in Teradata and Microsoft SQL Server for integration in Tableau interface.• Developed ten management dashboards analyzing call volume by phone split, vector, agent and supervisor, dollars scheduled, payroll, quality and service level metrics queried from Sharepoint, Tableau Server, Teradata, and SQL Server.• Blended thirteen different data sources seamlessly into a single dashboard with upload times of less than thirty seconds.• Organized all data by custom fiscal calendar used by Home Depot (4-4-5 M-Su fiscal calendar beginning in February)• Developed wireframe of various dashboards to senior management to assist in requirement gathering.

Worthing, West Sussex, Gb

Business Intelligence Analyst – Product Management and Development• Served as Business Analysts and Developer twenty-three enterprise reports delivered to over one hundred clients using the Exago tool. Reports used for analysis of invoicing, payroll, management financials, commissions, benefits, sales, government reporting, and recruiter/account manager activity metrics. Also integrated reports with third-party partners such as Peoplenet, Global Cash Card, Essential Staffcare and Maximus• Developed billable custom reports for over a dozen clients with wide-ranging reporting needs • Developed and presented customized training classes for internal and external team BI training • Collaborated with customer-facing Implementation Engineers, Product Owners, Quality Assurance and Exago (OEM) to ensure reports meet specs and function correctly• Serving as level three support for customer reporting and analytics issues• Collaborated with sales team to provide feasibility analysis and cost estimates for prospective customers’ reporting needs• Partnered with development team to create over a dozen metadata tables populated with hundreds of attributes for use in Exago tool. Also researched and documented which SQL Server tables and fields were used for each metadata table and attribute.• Attended over eight hours of CBT Nugget SQL training.• Created payroll document listing which tables and fields are populated with how many records during the entry, proof, post, payroll and billing stages as well as entries for payroll adjustments and voided checks• Collaborated with sales team to provide feasibility analysis and cost estimates for prospective customers’ reporting needs

Atlanta, Georgia, Us

• Developing Tableau reports linking to Teradata for equipment utilization, order fulfillment, and idle day analyses. Used by operations personnel for day to day equipment monitoring as well as historical performance reporting for marketing meetings with customer• Led team of 6 programmers developing and deploying department-wide Microsoft Access based UI and Teradata UserDB backend system for $400M annual asset budgeting process• Reduced mechanical repair expenses by 60% at major automotive distribution hubs in the Midwest through collaboration with a Big 3 automotive manufacturer and railroad operation and marketing departments• Managed fleet sizing needs of 2,700 Automotive Parts Boxcars in addition to handling preventative maintenance, storage and de-racking requirements• Created automated reporting structure for customer order fulfillment and train cancellation annulment reports • Created service improvement opportunities map in Google Earth, partnering with IT for integration to company-licensed ESRI software• Partnered with service measurement department to develop automated plan adherence reporting system providing increased accuracy for management and saving salaried staff 5 hours per month of manual preparation• Developed map of Inbound/Outbound GPS locations across the NS-system enabling user to view train departure points at division, yard and ground level.• Maintained accurate customer, route, and demurrage notification profiles for over 1,200 facilities• Developed and presented the Customer Service Records Management training presentation• Developed and presented graphical analyses of RIT (Remote Intelligent Terminal) device usage for management.