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
• 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.

-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.

- 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.

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
• 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

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