Data Scientist Warehouse

CHARLES R. SMITH

Cumming Georgia ***** 404-***-**** *****.*********@*****.*** linkedin.com/in/charles-smith-277a10100/

DATA SCIENTIST

Driven to deliver data-driven insights with over 7 years of experience in data science and analytics, focusing on operational, executive-level, and web-based reporting. Developed and implemented reporting solutions using advanced tools like Google BigQuery, Tableau, SSIS, and Qlik, resulting in significant revenue improvements and operational efficiencies. Led projects that identified cost-saving opportunities, including initiatives that reduced call-in rates and saved Verizon over $500,000 annually. Adept at translating complex data into actionable business strategies, improving decision-making capabilities for senior leadership and cross-functional teams. Highly skilled in managing multiple projects simultaneously and ensuring timely delivery to meet critical business needs.

KEY SKILLS & CERTIFICATIONS

Data Mining Transact/ MS SQL Teradata Data warehouse SSIS Teradata SQL Certification MS Office

Visual Studio Google Big Query Qlik Problem – Solving Cross Collaboration Growth Mindset Efficiency

PROFESSIONAL EXPERIENCE

Verizon, Alpharetta, Georgia January 2018 - September 2024

Engr III Spec-Data Science

Created Google Cloud Platform reporting using Big Query to provide automation for Qlik Dashboard. By creating this automation Verizon managers were able to receive key reporting metrics that they were able to share with senior leadership on key initiatives regarding effective coaching tools. As a result of this report, we improved the utilization of the coaching tool for the retail and care centers.

Frequent Caller reports SSIS job creation. With the creation of this job automation in SSIS Verizon was able to create automated dashboard reporting that identified customers calling in >50 monthly and saving Verizon $500,000 annually.

Provided QlikView Data files in Qlik creation support that assisted the Governance Team. Created QlikView Data files allowed Qlik developers in Verizon to consolidate data from multiple data sources in Verizon into apps that produced single source executive-level reporting that would otherwise be captured in multiple reports. This automation allowed executives to snap-shot reporting and gave them quicker decision-making choices rather than going to multiple reports and combining data to make decisions.

Verizon, Alpharetta, Georgia January 2017 - January 2018

Consultant Data Analytics

Data Analytics Consultant with primary responsibilities of producing web analytics reporting to track and gauge shopper trends, and web behaviors such as call-in rates, and promotional take rates. Extensive use of various reporting tools such as Teradata, Tableau, Adobe, Data Warehouse, and Microsoft products to produce reports. Other tools used are Aster and Microsoft SQL Server.

Developed new Call in Rate Tableau Dashboards that allowed managers to effectively isolate specific web pages that had higher call volumes to the Verizon Call Centers which subsequently led to lower call-in rates to our centers.

Developed Tableau Speech Analytics Dashboards: Developed web page visit reporting that connects specific call drivers in speech analytics data for managers to listen to call drivers that had higher volumes. This report allowed Verizon managers to determine primary reasons for calling and target those reasons on the front-end interactions that lead to lower call-in rates to our care centers.

Developed promotional level reporting via Data Warehouse: This provided Verizon managers the ability to track take rates, year-over-year lift from similar promotions, and reporting that tracks customers’ visits to our websites and subsequently makes their final purchases in one of our retail outlets. By using this reporting we are able to target seasonal specific promotions behaviors of our customers that lifted our take rates year over year for two years.

Verizon, Alpharetta, Georgia May 2014 - Jan 2017

Consultant Reporting

Provided center-level reporting that consisted of daily, weekly, and monthly reports of equipment and accessory orders. Also provided financial audits for credits issued by our customer service representative’s billing transactions.

Completed equipment and accessory audits. This report provided a detailed analysis of equipment and accessory level sales for call center representatives, which drove decisions regarding representative sales per call and opportunities for increased revenue for Verizon. We were able to increase sales per representative year over year for the duration of producing this report.

Participated in the creation of an Executive Level port in analysis reporting that provided detail daily incoming volumes and outcoming volumes of ports that allowed Verizon to compare our port ratio to our competitors. Verizon was able to adjust its port strategies on a real-time basis which allowed us to be the industry leader.

Provided supervisory-level financial audits for credits pertaining to each supervisor team which enabled Verizon to provide coaching to representatives who were issuing high-volume credits to consumer accounts. With this reporting, Verizon saw an increase in revenue as a result of revenue loss due to high-volume representatives issuing high dollar credit amounts.

EDUCATION

Bachelors of Business Administration (BBA) in Marketing

Middle Tennessee State University

Master of Business Administration (MBA) in Management

Strayer University

Contact this candidate