Jeffrey Stone Email & Phone Number

Atlanta, Ga, Us

Atlanta, Ga, Us

Data Engineer managing the Sales Analytics data pipeline consisting of AWS Redshift, S3, Snowflake, R-Studio, and Power BI Workspace.In charge of Data Governance and ETL Pipeline of Sales Analytics data assets in Snowflake and Redshift. Used Python and EC2 to build an automated ETL pipeline to load data and leverage Splunk to monitor QA and track performance.Migrated Legacy ETL system off NodeJS and Redshift to a more modular one using Python and Snowflake which eliminated downtime.Built models to identify prospective clients and determine opportunity based on KPIs to help sales and marketing plan campaigns and close deals. Automated existing models and ETL process to reduce manual work and changes to code reducing downtime and eliminating opportunity for errors. Managed AWS environment used build propensity and opportunity models leveraging Redshift, Jupyter Notebooks, Python, Snowflake, and S3.

Atlanta, Ga, Us

Data Engineer for the Sales Analytics and Sales Enablement team. The primary focus was automating the ETL pipeline and providing technical support to the Analysts building the critical opportunity and segmentation models.Led effort to define data assets and build a comprehensive data dictionary for to enable self service analytics by the sales team, and standardized data and KPIs.Built an automated ETL pipeline leveraging AWS S3, Redshift, Flat files, Snowflake powered by Python to deliver a single comprehensive sales tool utilization dashboard which allowed Sales leaders to make data driven decisions and ultimately saved the company millions in needed software.Lead data engineer on multiple Proof-of-Concept projects including a Client Profitability dashboard that delivered actionable insight and became a full funded initiative in 2021.Managed a Client Profile dataset that pulled in Client metrics and KPIs from all of Cox Automotive’s Business Units into a single comprehension dataset that could be leveraged by the Sales team to get a complete profile for each Client.Automated data QA process using Python and Splunk freeing 15 hours a month the team used to shorten the release cycle and improve data quality.Administrator for the AWS environment managing Redshift, S3, Sagemaker, and EC2 instances used as part of the tool set to produce models. Managed Summer Interns for the Sales analytics team, and guided them through building a solution to a current problem and presenting their work at the company showcase. Provided actionable insights using Power BI Dashboards and ad-hoc reporting to the Sales team used in quota setting, client health scorecards, and identifying opportunities to partner with clients to increase retention.Provided ad-hoc analytics for the front-line sales team and consulted on data visualization for Power BI dashboards embedded in Salesforce, streamlining data access for team members.

Atlanta, Ga, Us

Splunk Administrator, Evangelist, and Data Engineer focus on increasing the use of Splunk to automate data analytics and monitoring for the IT operations team and EOC. Partnered with Technology Team to improve data quality by standardizing data governance methodology. Built Custom Splunk Data Inputs for critical legacy technology using Python to enable ingestion data from IBM AS400, custom applications, and ETL Pipelines.Built dashboards in Splunk ITSI to monitor the network and audio/video stream performance in use at our online auctions reducing MTTR.Automated Splunk configuration and application deployment using Fabric and Github to streamline setup and maintenance of on-primise Splunk infrastructure and forwarders. Led effort to make operations data more accessible to field locations enabling them to take a data-first approach to service management.

Atlanta, Ga, Us

Data Engineer and Analyst providing support to the Application Support and Site Ops teams managing all the online websites for Cox Automotive.Built a pipeline to pull in data from Microsoft CRM, Oracle, MySQL, and Postgres data sources, and provided greater reporting around incidents that ultimately reduced the MTTR on critical outages.Coached and Mentored System Engineers providing tier 2 support for escalated issues from the front -line customer care department. Built web-based tool for the Customer Care team giving representatives direct access to fix common issues reducing call escalations to Tier 2 support by a little more than 60%. Eliminated weekly downtime of a custom Amazon cloud-based web application by automating the restart of failed data services.Designed and automated a weekly digital scorecard to highlight opportunities to improve IT service pulling data from Manheim CRM and Service Now producing trends that enabled.

Atlanta, Ga, Us

Oversaw the Information Technolgy support for two Manheim field locations in Denver.Data Analyst for Management Team producing ad-hoc reports, performance KPIs, and dashboards using PHP which provided a live view into auction performance for the management team.Secured funding to acquire portable terminals and integrated the technology on the lot increasing the rate at which cars could be processed at arrival and departure.

Atlanta, Ga, Us

Led two critical departments: a team of 4 technology specialists supporting a 22 lane auction site covering 136 acres and the Purchasing Department consisting of 7 employees responsible for purchasing and inventory control.Oversaw the effort to implement a new purchasing tracking system that reduced expenses by moving to a just-in-time model for body shop parts and supplies. The program was a model for the development of a corporate-wide initiative. Worked with Carmax to plan and develop a web-based tool using PHP to streamline their onsite buying and post-processing workflow, increasing their purchasing capacity.Reduced tickets by 32% by implementing a local intranet site focused on self-service. Oversaw the technology infrastructure expansion as part of a $5 million building addition.

Atlanta, Ga, Us

Part of the Regional Management Group that worked closely with the Regional Vice President to improve the customer experience. Developed the field technology support team at 31 operation locations throughout the Midwest, Southwest, Southeast, and Florida. Managed the relationship between Corporate Technology Groups and Auction Management.Auction Advocate in Corporate Technology InitiativesTrained and Mentored new Auction Technology employeesDesigned new Administrator Training ProgramPresented a plan to double IBD over five years to the Manheim Executive team using Technology to reduce expenses through automation and increase capacity to maximize revenue.

Atlanta, Ga, Us

Led a team of two responsible for supporting Auction desktop and server infrastructure. Oversaw the transition from IBM Thin Clients to full desktop PCs.Managed and Administrator for Windows Domain controller and Exchange mail server.

Plano, Tx, Us

Bachelor'S Degree, Information Technology

Environmental Biology