Alex Kramer Email & Phone Number

San Francisco, California, Us

● Explored and analyze CDC data on tobacco use/smoking trends from 2011-2019. Leveraged Python (Pandas, Seaborn, Matplotlib) to clean the data, perform exploratory analysis, and create initial visualizations. Imported the CSV file into Tableau to recreate and improve visualizations. Successfully identified trends across key locations and demographic groups to suggest future targeted anti-smoking campaigns.● Evaluated data from a chemical company to determine growth & divestment opportunities among their existing product lines and customer markets. Uploaded CSV file into Tableau to perform descriptive analysis and create dashboards and story presentation. Identified an underperforming product line with over $15K in losses as well as an industry and target region with strong growth potential. ● Inspected data from a water desalinization company to evaluate the cost-effectiveness of their facilities and identify lowest impact times for maintenance. Utilized Excel functions like SUMIFS, AVERAGEIFS, as well as visualizations (Scatter Plots, Line Graph, Bar Charts, etc.) to identify market trends, product elasticity, and perform what-if analysis. Determined facilities to be profitable and identified Q4 as the lowest impact time for maintenance.Focus areas:• Framing Structured Thinking – Problem Solving Frameworks (e.g., HDEIP Framework, 7-Step Problem Solving Framework), Issue Trees, Hypotheses Threes, Value Driver Trees• Analyzing Business Problems – Creating evaluation models in Excel (e.g., revenue and operational cost modeling), Financial Concepts, Economic Concepts, Statistical Concepts & Descriptive Statistics• Communicating Analyses – Visualization tools (i.e., Power BI and Tableau), PowerPoint, Communication Strategies, Presentations to technical and non-technical stakeholders, Presentation Practice• Connecting Data Using SQL – Queries, DA/BA tools, Databases, Set Theory

Denver, Colorado, Us

● Built recruitment marketing strategy to expand online presence. Leveraged marketing/SEO data from Moz and SEMrush, audited the company site, reviewed company’s Google Analytics performance data, and created engaging content via Canva. Grew company LinkedIn following by 10,000 users and provided actionable recommendations to management.● Utilized recruiting best practices to source, qualify, and place candidates at various clients. Managed stakeholder relationships through the entire recruiting lifecycle and successfully negotiated contract and pay rates. Generated over $1M dollars in revenue.● Reviewed performance data from Bullhorn CRM to identify trends across clients and build out ideal customer profile. Exported data into Excel to do exploratory analysis. Successfully identified key indicators for sales team to target with prospects.

Denver, Colorado, Us

Pittsburgh, Pennsylvania, Us

● Analyzed client performance data to identify opportunities for improvement. Reviewed client-provided dashboards from Beeline to identify and maintain positive KPIs within a competitive VMS program. Successfully maintained a 100% response rate, 15-20% fill rate, and 20%+ fill rate on aged reqs.● Promoted to Team Lead to manage recruiting team and drive performance for the company’s flagship account. Trained new hires in recruiting best practices, set expectations, and pulled performance data from Bullhorn CRM to identify opportunities for improvement. Successfully onboarded 3 recruiters and managed a team of 6 to achieve a fill rate growth of over 100%.● Managed stakeholder relationships to provide quality candidates, excellent candidate experience, and profitable margins while satisfying a demanding metrics-driven MSP program.

Pittsburgh, Pennsylvania, Us

Data Analytics Career Track Certificate

Bachelor'S Degree, History