Created data warehouse to roll up multiple fact tables, merging data from multiple sources into a one stop source for reporting. Data sources included Teradata, flat file, salesforce, and third party proprietary sources. ETL performed using MS SQL Server. Data included detailed sales data with lead, sale, attempt, and service connect data reportable from the hour level and up. Created type 2 employee dimension using the Kimball Method to track employee status changes through time. Dimension allowed reporting that was previously unavailable.Produced detailed documentation of existing ETL processes in data warehouse. Prior to my taking the position, the inner workings of the ETL inputs, outputs, database structure, and logic were a black box; undocumented and unknown to the larger team.Reverse engineered company standardized employee attrition reporting from a multiple team manual process to a streamlined SQL server ETL process.Reverse engineered company standardized employee attrition reporting from a multiple team manual process to a streamlined MS SQL server ETL process.Reverse engineered MicroStrategy cloud-based XML reports to create tailored situation, specific reporting and visualizations.Converted legacy MS SQL Server SSRS reporting into data flows for Tableau.Used Power Query to generate dynamic sales dashboard reports. Reports used a combination of Microsoft SQL Server stored procedures, SQL Server tables, and local excel data tables to generate at a glance summary data for customer sales, connections, presentations, and dispositions.Tested Power BI to generate sales dashboards similar to the existing excel dashboards and existing Tableau dashboards to determine Power BI prospects as a suitable replacement to Tableau for visualization.

Redesign, modify, and debug existing SQL ETL stored procedures to update EDW data logic for existing company needs and decrease runtime to meet Business Intelligence service level agreement company standards.Validate, investigate, and verify MicroStrategy reporting functionality and data for the merged legacy Charter, Time Warner, and Bright House Networks Field Operations Data for Business Intelligence.Designed Key Operating Metric SharePoint library. Management initiative to document the calculations for all key metrics and all the reports required the site to allow for multiple draft versions of KOM documents and approval states while keeping the documentation fluid during the information gathering and sharing processes.Developed multi-phase auditing process for Enterprise Data Warehouse. Created processes to allow for validation checks at the ETL layer, database layer, and report presentation layer. Designed, coded, and tested SQL procedures in Teradata that use Holt-Winters seasonal forecasting and Interquartile Range modeling to flag unexpected data outcomes. IQR modeling had 23 second per metric average run-time (based on 10,000 runs of data), allowed for flexibility of quantity of historical data required, and was made easilty adaptable across multiple disparate data sets. Converted existing Excel and PDF based reports to MicroStrategy Desktop for Narrowcast distribution.

Maintained and updated automation of 500+ reports on legacy systems. Wide range of report generation and delivery including Forest & Trees SQL executables, Toad SQL automation, batch files, and Monarch text file to spreadsheet conversion delivered via email and SharePoint.Reports were launched with combinations of task scheduler and PowerShell. The reports were cataloged and data users were consulted as part of a clean-up process to add efficiency, reduce duplication of effort, and streamline company reporting.Reverse engineered approximately thirty MicroStrategy XML based reports to be automatically delivered via email using combinations of Oracle and Teradata back-end data storage, Toad automation SQL scripts, and Excel VBA macro.The adoption of MicroStrategy cloud reporting allowed users to create and generate their own reporting from the Enterprise Data Warehouse, business needs required that key reports be deliverable driven instead of user generated to smooth the transition. The reports were originally created and delivered manually using copy paste from the MicroStrategy interface. Removed the human interaction of report creation and distribution using VBA that mirrored the complexities of the prior human created data presentation for each. Reports ranged in subject matter from customer level of service reporting for management to reporting data to Finance and Accounting for use in government and investor quarterly reports.Created and oversaw deliverable for the highly-sensitive Executive Bonus Plan reporting. Data merged from multiple systems on a monthly basis and delivered to Executive leadership

Created macro based data miner that interacted real time with web based Coaching Feedback Portal. Coaching Feedback portal was used company-wide to provide learning opportunities to representatives based on employee-to-employee feedback . Data harvested was used to create reporting from the portal that was otherwise unattainable through the interface. Evolved this system to MS SQL Server based reporting system that offered real-time reporting to more efficiently satisfy business needs.Served as arbitrageur for direct sales representatives commission disputes. Direct sales representatives disputed their commissions via a web based system. Disputes were cross referenced against billing system front end data and Oracle based back end data to mitigate the differences. Resolutions were communicated from sales representative to executive level, depending on the gravity of the dispute.Created and maintained SalesForce dashboards that provided at-a-glance view of the key metrics used to monitor the success of the Two Year Price Guarantee program. Created reports using the SalesForce interface that allowed management level users to deep dive the data. Reports were made available on demand or via email subscription.Served as subject matter expert for Credit Assessment and COD process and reporting. Created documentation materials for both representative level order entry process and programmer level that translated the code from SQL to plain English for the project stakeholders. Provided multistage reporting from the billing system level to the in-house Coaching Portal level where the details of the Credit Assessment and COD metrics were merged with other key metrics and roll-up reporting.

Maintained, monitored, and added functionality to enterprise-wide work order auditing database. Provided one-on-one coaching sessions to technical representatives to teach technical service troubleshooting for internet and video services. Provided similar sessions to sales agents to help them maximize their revenue per call by engaging the caller in needs-based conversation, interpreting customer cues, and offering matching products and services. Served as subject matter expert for order flow processes/procedures and call quality both in-house at WI and MI call centers, and for internationally outsourced call centers. Designed teaching material and lead presentations for order processing and call quality. Provided follow-up conferences to share best practices and maintain the momentum of the skills transfer.