Greg Lopez Email & Phone Number

Santa Clara, California, United States

• Supported sales team of roughly 120 territories & 17 districts and partnered with SFDC admin team for daily requests ranging from account transfers, account deduplication/hierarchy requests, to split credits in SFDC.• Collaborated with sales managers and other analysts to consolidate utilized and requested views into as few dashboards as possible in SFDC to support as many districts as possible.• Reduced weekly forecast update workload from 2 hours to 10 minutes by utilizing a… Show more • Supported sales team of roughly 120 territories & 17 districts and partnered with SFDC admin team for daily requests ranging from account transfers, account deduplication/hierarchy requests, to split credits in SFDC.• Collaborated with sales managers and other analysts to consolidate utilized and requested views into as few dashboards as possible in SFDC to support as many districts as possible.• Reduced weekly forecast update workload from 2 hours to 10 minutes by utilizing a BigQuery data pull and formula-driven spreadsheet to streamline the process.• Consolidated roughly 120 territory plans into 17 district plans in order to pass along key accounts using a bottoms up approach to partner with marketing and other partner teams. Show less

Remote

- Developing automated solutions for KPI needs of Sales Leaders using Google Spreadsheets & Salesforce reporting- Building dashboard views on Looker & Tableau for self service charts on different metrics- Presenting finding of ad hoc requests through Spreadsheet charts & Google Slides- Writing/adapting queries in Snowflake to pull necessary data updates on charts or ad hoc requests

-Write and update SQL scripts to pull specific data or to create custom tables that would be used to pull data for data analysis and visualization-Utilize spreadsheets to clean, manipulate, and chart out data to inform stakeholders regarding their questions about individuals, teams, or regions -Build and update dashboards to visualize data and translate insights regarding varying views of data for different levels of leadership to view and use

- Compiled data from 20+ schools regarding students in order to furnish charts and reports to help understand student activity ranging from struggling demographics to efficiency of programs- Manipulated SQL Queries and Aeries Web Queries to pull necessary data based on project needs- Built templates for reports in Excel to increase efficiency and organization of different data driven projects- Utilized Google Suite products to improve sharing of data and/or results specific to a… Show more - Compiled data from 20+ schools regarding students in order to furnish charts and reports to help understand student activity ranging from struggling demographics to efficiency of programs- Manipulated SQL Queries and Aeries Web Queries to pull necessary data based on project needs- Built templates for reports in Excel to increase efficiency and organization of different data driven projects- Utilized Google Suite products to improve sharing of data and/or results specific to a range of customers generally based on site- Prepared data and utilized R to help determine statistical significance of the effects of math support services and special math programs- Assist multiple managers for ad hoc data requests and projects Show less

San Leandro

• Automated Excel and PowerPoint reports into dynamic dashboards utilizing Tableau• Performed data analysis for various ad hoc requests customizing the cuts and slices depending on the ask, while maintaining as much accuracy as possible with the multiple large scale database changes that occured• Created and updated, based on requests, Quarterly Business Reviews for Directors of Sales of each 7 verticals of business within the company• Built, customized, and ran reports using… Show more • Automated Excel and PowerPoint reports into dynamic dashboards utilizing Tableau• Performed data analysis for various ad hoc requests customizing the cuts and slices depending on the ask, while maintaining as much accuracy as possible with the multiple large scale database changes that occured• Created and updated, based on requests, Quarterly Business Reviews for Directors of Sales of each 7 verticals of business within the company• Built, customized, and ran reports using SalesForce in order to update or create spreadsheets/PowerPoint Decks (PPDs)• Compiled a 250+ page weekly report(Control Book) for the Senior Vice President of Sales comprised of reports and PPDs that were updated weekly, monthly and quarterly• Updated on a weekly basis, a week-over-week headcount forecasting and analysis report and PPD Show less

Dual Certificate Of Specialization In Data Science And Big Data, Data Science & Database Programming

Bachelor Of Arts (B.A.), Computational Mathematics, Graduate

Bachelor Of Arts (B.A.), Business/Managerial Economics, Graduate