Johnny Simmons Email & Phone Number

Charlotte, Nc, Us

Charlotte, Nc, Us

- This position transforms raw data into a customer-consumable format for the delivery of business intelligence.- Deliver work products in a time-sensitive manner to fulfill the demands of the Crime Analysis Division as defined by the Charlotte-Mecklenburg Police Department (CMPD).- Assignments require in-depth knowledge of CMPD data stores and, in some cases, developing a detailed understanding of vendor databases with limited documentation.- Work products include reports, automation of manual processes, technical documentation, data quality assurance, and making recommendations for police data analytics and crime analysis workflows.

Charlotte, North Carolina, Us

- Responsible for creating and maintaining Dashboards, visual reports, and data output files for over 1,000 sales reps and managers all across the United States through Oracle Analytics.- Developed client-facing dashboards to help sales reps increase revenue by 50 million dollars (40% increase) from 2020 to 2021.- Create, modify, and troubleshoot SQL queries through subqueries, temp tables, control flow statements (IF/ELSE), CASE WHEN Statements, various join (INNER, OUTER, LEFT, RIGHT, FULL,) combing results (UNION & UNION All).- Maintaining 99% accuracy when calculating and tracking commissions for sales reps every month while communicating these trends to sales management and other stakeholders.- Assisted sales management by developing comp plans and building out sales territories through Sales Territory Mapping Software (AlignMix).

Glen Allen, Va, Us

- Joined the Enterprise Platform Team to continue to build out the Capital Markets Application Support Team

Blacksburg, Va, Us

- Provide marketing team with a monthly SEO report by visualizing data through an Excel Dashboard from google analytics data utilizing Python (NumPy, Pandas, Seaborn), resulting in a 60% decrease in time needed to infer insights to develop marketing strategies for websites.- Automated task of copying and pasting custom web tokens and SQL scripts into Database with Python (GUI Automation), completing this task 87% faster than expected.- Cultivated my project management skills by implementing 24 websites over an 8-month period to improve user interface and grow marketing value by increasing the total number of sessions by 54%, and the number of page views by 50%.- Maintaining daily updates for web-based applications, modifying customer relationship management systems, and configuring back-end changes to databases for front-end users, managers, clients, and vendors.- Direct webinars for end-users to improve their usability of customer relationship management tools, while explaining how to understand the data from their perspective to make informed decisions to eliminate delays, unexpected costs, and quality deficiencies.

- Utilized web-based technologies through designing, developing, testing, and publishing a fully responsive website within budget and time.- Gained over 30% growth in total productivity during weekly meetings with clients during a 4-month timeline.- Assisted the client in being accepted into 50% more film festivals and increased client base by 400% in a 2-month span of the website being published.

Rockville, Md, Us

- Effectively implemented strategies that helped several young adults with disabilities the past 3 years to instill independence through the Montgomery County School System in weekly projects and assisted activities. - 15-20 hours per week during college

Chicago, Il, Us

- Responsible for 20-30 first graders in a 1-year span as an after school and summer counselor for the local Harris YMCA during high school.- 15 hours per week during high school and 40 hours per week during summer break

Charlotte, Nc, Us

- Achieved over $50,000 in sales with over 50% gain in productivity in 8 months as a Red Shirt Employee for Autobell Carwash as my first job during high school.- 20 hours per week during high school

Business Information Technology: Decision Support Systems, Business

High School Dilpoma