John O'Gorman Email & Phone Number

Austin, Tx, Us

Austin, Texas, Us

Austin, Texas, Us

Austin, Texas, Us

Scaling both a product and an Inside Sales Team from the ground up. Maintaining a close partnership between Sales, Product, Marketing, and Bizops.•Grew a new Inside Sales Team to over 300 headcount within 9 months, covering all areas of the business including: sales support, sales operations, sales strategy, salesforce admin work, launching marketing campaigns, building sales rep activity reporting, sales x product collaboration, and ad hoc analytics to drive Senior Leadership decision making. •Wrote a Python cron job connecting various SQL databases to form a clean data model to be consumed by Tableau. Designed and distributed Tableau Dashboard for Sales Reps to navigate and prioritize accounts in their book of business, Coverage Summary for Sales Directors, and more. •Developed Python+SQL code to build rep books by identifying opportunity in the CRM, cleansing for agreed business rules, and developing/automating prioritization logic based on perceived propensity•Ideating and creating targeted Salesforce Opportunity objects using Python+SQL for sales reps using data to identify where reps should prioritize their time•Writing and maintaining multiple ETL python scripts to feed SQL data models to support multiple Sales Dashboards and other data needs•Creating and maintaining product-minded metrics on sales motion efficiency through activity conversion from Outreach Call to Closed Won•Automating Salesforce Lead Qualification to adhere to business rules and quality standards using Python•Developing metrics and reporting for Salesforce Lead Creation, Qualification, Routing, and Engagement •Managed Salesforce Admin relationship for entire instance of Salesforce, prioritizing and planning projects, workflows, and data capture•Regularly writing and presenting broad communications to entire sales team on updates to Salesforce, new Opportunities Loaded, or any other updates needed

Austin, Texas, Us

Strategist on Sales Effectiveness with the mission to help Indeed's Inside Sales teams go faster and grow faster. Acting as an embedded partner and liaison between Sales, Product, and Marketing for Indeed’s primary revenue generating product. •Commanding use of Python (pandas), MySQL, postgreSQL, IQL (Imhotep Query Language), Tableau, Advanced G Suite and MS Excel, Raven (indeed mail-merge tool), Marketo, and JIRA. •Working across disparate data sources in various databases using different languages. Quickly understanding big complex data ranging in granularity and subject matter covering revenue performance, sales interactions, sales lead routing, product performance, in product client behavior, marketing performance, and product testing.•Ad Hoc analytic investigation of sales, product, and marketing data. Working to solve problems across all affinities of the business. •Standing up A/B testing with Inside Sales reps, cohort baseline analysis, determination of layout for statistically significant results, cultivating mechanical operation of the testing environment using python, all with the goal of finding hidden pockets of opportunity in the CRM. •Influencing Product Managers using data insights and analysis to prioritize key initiatives. •Supporting Account Based Marketing efforts to drive Sales engagement by defining success metrics, campaign and testing design, pre campaign opportunity analysis, and pulling data and scrubbing into target lists to be read by Marketo. •Driving Inside Sales efficiency through first-touch email automation using internal databases and mail merge tools. Owning ongoing monitoring, analysis, and tweaking subject lines and content based on testing results for the highest impact engagement for conversion.

Houston, Texas, Us

Provide critical business intelligence and analytic support on an ad hoc and recurring basis. Blending multiple sales and workforce databases including, Anaplan, Workday, Salesforce.com, and rep/account performance data to offer the full story to our sales leaders. • Supporting the setup, maintenance, and continuous improvement for an internal SQL Server Database. • Writing and designing SQL queries on big data sets to develop data backed insights linked to Excel and Power BI outputs for consumption by 150+ Sales Leaders, Sales Planners, and the Strategy Analytics Team• Cleaning, testing, and blending complex data sets developed from multiple systems for data analysis using SQL and DAX to cut the noise and draw out salient insights• Creating Sales Coverage Deployment metrics to understand and analyze how to drive positive sales outcomes• Continuous ad-hoc storytelling to solve complex sales deployment problems using data driven insights, translating detailed data points into fundamental business insights• Ad Hoc Analytic support on change-management, organizational restructuring, and other large scale organizational changes that require complex and custom data views

Houston, Texas, Us

Manage global Enterprise Group Sales Reporting & Analytics Human Resources processes including monthly HC, attrition, hiring, and metric trend reporting. Work directly with the VP of EG Global Sales HR to oversee select projects analyzing the global workforce and setting programs into enablement to improve sales force organization, processes, and performance. • Regarded as subject matter expert for EG Sales headcount on a global scope. Worked cross function to manage data for projects that require multitudinous cuts spanning headcount trends, attrition, sales performance, HR/Finance organization, geography, and sales role. Consistently utilizing a breadth of data sources to assemble meaningful, accurate, and impactful insights to drive decision making abilities of Sales HR leadership. • Managed EG Sales Performance Management Quarterly process actively enabling managers to better communicate, coach, and performance manage their employees for the continuous improvement of the EG Sales bottom line. • Ensured consistent data integrity across all form factors in order to provide the most accurate view of sales headcount for both reporting and analysis. • Interfaced with global sales operations, Region HRBPs, Finance, and other global functions to accomplish successful projects and processes to aid the momentum of the business. • Managed monthly reporting of sales workforce metrics and present analysis to a global and cross functional leadership audience in order to drive logical business decisions and strategy planning.

Houston, Texas, Us

Enabled success of the Hiring Excellence PMO through project management and support spanning all facets of the Human Resources portfolio including onboarding, location strategy, attrition analysis, Grad/Early Career hiring/recruiting, competitive hiring, generational gap analysis, and the development of role success profiles. • Managed and executed global workforce transformation initiatives aligned to EG business strategies. Supporting the Hiring PMO by maintaining weekly project status dashboards, managing the SharePoint, and fulfilling Ad Hoc data and administrative requests to enable HRBPs and work stream leads to complete deliverables.• Supported region HR leadership with workforce metrics analysis, reporting, and presentation in order to drive high level decisions. • Collaborated with WFP performance & analytics team on complex projects reviewing the EG workforce to generate critical insights for future program direction and EG leadership strategy.

Austin, Texas, Us

- Performed data entry, data retrieval, and formatted data for evaluation- Examined FAFSA/1040 tax forms for accuracy- Executed ad hoc daily tasks for Financial Aid Officers

Fremont, California, Us

- Attained weekly quotas and personal sales goals- Facilitated lasting customer relationships through effective communication and sales- Expanded my personal professional network- Ability to understand and attend to the needs of each customer