Designed database, ETL processes, and dashboards to perform benchmarking analysis of lead generation programs.Developed new data quality process to validate the phone numbers and email addresses of prospective leads.Used Tableau to create an interactive dashboard benchmarking the performance of multiple lead generation programs, including how lag time between prediction and qualification affected conversion.Installed and initialized MySQL, Oracle Express, and PostGreSQL databases to expedite data analysis.Utilized tools such as Talend Open Studio, SAS, and SQL scripts to nearly fully automate scrubbing and validation rules for lead prospect lists.Employed RapidMiner to assess the impact of inputs on demand generation programs and evaluate the performance.Identified and resolved data integrity issue inside Google Analytics that prevented proper lead and cost attribution to the appropriate program.Diagnosed and fixed problems within a vendor’s prospect disposition feed, leading to more reliable lead information in the present and future terms.Aligned disposition data from qualification vendors with data in internal Hadoop Hive database allowing for continuing more detailed analysis.Made use of data in Google Analytics and Hadoop Hive to track first attribution through to lead generation.Established data feed to lead generation vendor along with recommendations for model improvement.Designed and implemented processes to deliver data to a demand management platform (DMP) to improve targeting.

Proposed, created and demonstrated a tool for improved knowledge management within the company.Altered a Variable Response Smoothing clustering algorithm using RapidMiner (SAS alternative) to give a lower Davies Bouldin score and improve forecasting accuracy by more precisely predicting what the effects of various promotions would be.Created new Tableau reports to deliver a customer’s desired information in a more meaningful way.Produced calculated fields within Tableau to calculate vital information for a customer based off of dynamically changing data at a product/distribution center/week level.Connected Tableau to a SQL database using both live and custom SQL connection criteria to give a better perspective of the information sought by the customer.Initiated and developed formal documentation for configuration processes. This documentation will be used towards training of new consultants and user experience developers.Configured o9’s integrated planning tool “mPower” for existing customers as well as prospective customers.Interpreted customer requests and guided developers towards reaching that goal. Generated new templates and macros to expedite the configuration process.Analyzed customer data and used business intelligence tools and techniques to improve forecast accuracy.Met with customers face to face, over the phone, through emails, and through Cisco’s “Webex” to gather requirements, showcase capabilities, suggest enhancements and improve customer satisfaction.Constructed a mapping table in Excel 2013 using a combination of index match functions and string manipulation to align multiple data sources into one cohesive whole to give a customer a better perspective of their business.

Intern of the WeekInstrumental in finalizing merger of Nortel into Ericsson. Instructed legal and project management teams on new access methods. Received “Intern of the Week” accolade. Reconciled developer requests with internal specifications into creation of a BOM. Pulled raw data from live Verizon network to collate and analyze equipment utilization performance. Assembled market brief detailing state of customer networks. Extension offered but declined in preference to education.