Jeffrey Shepherd Email & Phone Number

Scottsdale, Az, Us

New York, Ny, Us

Philadelphia, Pa, Us

Analytics Consultant utilizing database knowledge and business process to perform advanced descriptive and predictive analysis. Completing critical data-related projects for top clients, which require the use of data warehousing, business intelligence, and dashboard development. System knowledge of SQL, Power BI, Tableau, advanced Excel, and Python. Currently point of contact for project details and requirements, working with a wide variety of different industry clients such as retail & e-commerce, financial services, and manufacturing.• Recognized by leadership as top performer on the team.• Developed reporting in Tableau which measured Non-Compliant Programs and the condition of data, resulting in over 40% increase in data quality improvement.• Designed and implemented best reporting practices for the ECM Insights and Analytics department. Updated all existing Tableau and Power BI Reports to reflect best practices.

Irving, Texas, Us

Senior Lead analyst for managing customer business process and analytics, working with partners to manage overall program health and functionality. Performed analysis on internal and external data sources to track customer performance. Performing SQL data queries, collaborate with clients on complex reporting requests, drive innovation by searching for and evaluating new tools, processes, and ways of thinking about data. Created dynamic dashboards and reporting using Tableau. Identified and recommended opportunities for process improvement and development of new custom workflows.• Worked with drug manufacturers to develop cost analysis reporting on Copay and Insurance programs, resulting in 15% reduction in drug costs.• Created custom heat-map and waterfall reporting to help identify market trends, which produced a 30% increase in Doctor/Patient drug usage.• Developed strong cross-functional relationships with large clients and lead a team of Junior Analysts.

Us

Responsible for ticketing and sales analysis which includes management of Microsoft Dynamics CRM system, analysis of ticketing projects, generation of latest sales leads using SQL, and developed reporting on different ticketing revenue channels in Tableau. Completed essential functions such as creating activity reports in CRM of all ticketing departments, maintain a clean Datawarehouse of ticket buyers that contain key data points for targeting different segments. • Generated over $1,000,000 in incremental revenue by creating strategic sales campaigns.• Maintained and cleaned data warehouse resulting in 60% increase in data accuracy and completeness.• Developed custom workflows to segment fans based on certain criteria.

Scottsdale, Arizona, Us

Hired to develop facilities maintenance services reporting process, designed to increase business insights on preventative maintenance opportunities to increase net margins. Assigned as the Lead Analyst to develop processes and analytical models to measure historical business trends to aid in improving sales positioning for additional equipment coverage.• Recognized for increasing net margins over $5M by identify preventative maintenance opportunities.• Significant contributor in developing business analytics that resulted in $30M in revenue growth with existing customer base.• Managed asset analytics and reporting for key customers that resulted in a 7% reduction in cost of sales• Led analytics and reporting of customer quarterly business reviews (QBRs) resulting in 5 year customer contract extension. Created and distributed reports to internal and external executives for strategic decisions.• Developed ad hoc analysis models to be used in customer reviews and sales presentations.

Oo

As a Sales Operations Analyst, provided detailed analysis of world-wide revenue, expense and headcount reports to measure sales productivity. Tracked sales performance and created executive summary reports showing Cost of Sales vs. Return on Investment for each sales person and sales channel. Monitored the sales data integrity for the entire sales organization and was also an administrator for SalesForce.com. Designed and provided ad hoc reports, weekly revenue and flash reports. Also, created financial and incentive models in a Microsoft Access database.• Improved sales data integrity by over 50% by implementing data governance rules into database.• Identify root cause errors and corrective action plan for reporting accurate regional sales commissions.• Assigned as key business stakeholder that tested CRM data migration from legacy system to Salesforce environment. Assisted in creating field sales training content and delivered programs.

Randolph, Nj, Us

As a Data Analyst, I analyzed complex international asset management data for a major Telecommunications Service Provider. Duties include data collection, analysis, and reconciliation of assets to ensure they are correctly identified in an international asset tracking database. The results of my data analysis was used for assessing the financial impact, cost of ownership and predictive modeling for managing capital assets as they are deployed across the Service Provider's global network.

Master Of Science - Ms, Business Analytics

Bachelor Of Science - Bs, Accounting