Benjamin

Contact: Benjamin Cooper Data Analyst | BI Analyst | Analytics Engineer I’m a senior-level data analytics professional known for my technical expertise in Excel, SQL, Python, Power BI, and Cloud Computing. My experience includes working extensively in mature app development, Agile methodologies, and procurement teams, where I have consistently demonstrated my ability to analyze and develop data solutions for Fortune 500 companies. My personal curiosities have also seen me begin the construction of a comprehensive GitHub portfolio where I’m completing projects and demonstrating more self-taught abilities. I am committed to creating valuable solutions that benefit everyone, and I am recognized for my proactive approach in going beyond the scope of the job description to achieve exceptional results. Thank you for taking the time to review my background. ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● October 2021 – Present December 2020 – October 2021 Developed cross-functional Power BI dashboard to track spend, vendor KPI, and other multi-million-dollar project aspects Built RFI/RFQ applications in Excel, bringing a data-forward culture to the team and improving project procedures and best practices Spearhead effort in departmental contract compliancy goal by managing Power BI dashboard, resulting in 98% compliance Procurement Data Analyst ZIM Shipping – Hybrid Work Model Old Dominion University Bachelor of Science Business Analytics, Finance Norfolk, VA — May 2019 Clubs: Strome Sales Club (President), Analytics Club, Finance Club MOS Excel Expert (365 Apps) PMC Level 1 (Pragmatic) Worked as lead analyst on application development product team that creates hospital claim audit applications Served as lead CCA analyst on AI docs project, performing data validation, requirements analysis, and Confluence space support Analyze and gather business requirements for highly technical web applications Authored SQL Server queries to perform ad-hoc and root-cause analysis on audit data and ServiceNow tickets, respectively Super admin for audit web applications, troubleshooting user access and diagnosing backend account issues Constructed Python script that queried SQL Server database to gather data for Power BI dashboard Work with IT developers to manage Jira backlog, refine issues, connect to Confluence pages, and write test scripts to be used in feature releases Strategic Sourcing Analyst Dollar Tree, Inc. – Hybrid Work Model Education: Certification: Work Experience Agile Business Analyst Elevance Health, Inc. – Remote Work Model Virginia Beach, VA--linkedin.com/in/benjcooper1 June 2019 – December 2020 Overhauled department’s analytical process end-to-end, from BI system data pulls, through transformation, and into dashboards Authored Excel VBA scripts that improved vendor KPI scorecard creation time by 90% Constructed Excel data model utilizing advanced relationships eliminating tedious lookup functions Developed RFI/RFQ products in Excel with 500+ vendors, analyzing KPI data, cost, and other metrics to bolster contracting confidence Improved vendor KPI review process by building Excel dashboard that visualized vendor statistics and cost opportunities Constructed multiple linear regression models in Excel that analyzed vendor data to aid in setting of target pricing for RFQ bid Routinely collaborated with developers and senior leadership to innovate and improve data handling/sourcing practices Knowledge: Industry: Data Engineering Life Cycle Software Dev Life Cycle Agile Methodology Dev/Data Ops Security & GRC Cloud Platforms Applied Statistics Technical: ETL Pipelines Data Visualization SQL Querying Schema Design/Modeling APIs & Connectors Statistical Analysis File Staging Python Scripting Task Automation Data Cleaning Cost/Budget Monitoring Data Integration Tools/Software: Microsoft Excel Power BI Tableau Databricks Postman SQL Server MS pgAdmin Snowflake MySQL Workbench Jupyter Notebook Microsoft Azure Google Cloud Languages: SQL (T-SQL, PostgreSQL, MySQL, SnowSQL, MongoDB) Python (basic syntax, pandas, numpy, matplotlib, seaborn, scrapy) DAX (Power BI)