Patrick Mccann Email & Phone Number

Raleigh, North Carolina, United States

Durham, North Carolina, United States

• Deliver recommendations and products to clients relating to Data Architecture, Governance, Reporting, and Analytics
• Configure Data Factory Pipelines and Azure SQL Database Tables to curate and store client data from disparate sources
• Develop scripts in Python to automate work for clients, including Data Queries, Report Generation, and File Transfers
• Build dashboards in Power BI to reveal most important and actionable insights determined from client interviews
• Initialize and administrate Power BI Workspaces, creating infrastructure to allow for automatic report refreshes
• Implement and optimize Salesforce instances: streamline flows, consolidate reporting, and conduct metadata analyses

Raleigh-Durham-Chapel Hill Area

• Developed and maintained reporting for Special Markets sales division, utilizing a combination of SQL Server, Power BI, Excel, and Python automation
• Created customized reporting and predictive models for fastest-growing partner, collaborating to merge internal and client data to determine factors that facilitate further growth
• Presented insights, prioritized projects, and reported progress in weekly meetings with sales stakeholders
• Created a series of regression and machine learning models that approximated the effect of an underutilized education program, suggesting a strong potential sales lift for teen customer segment
• Conducted ROI Analysis on Sales Staff expansion to inform decisions on hiring – A/B test comparing baseline period to post-expansion

Raleigh-Durham, North Carolina Area

• Provided business operations leaders with data-driven insights in an internal consulting role
• Queried and processed data using tools such as SQL and Alteryx to generate reports on a routine and ad-hoc basis
• Developed and maintained Tableau dashboards to depict real-time progress toward yearly business goals
• Composed supplemental insights documentation to enhance data understanding and offer suggestions to business leaders
• Built a predictive model using Python (sklearn, statsmodels) to quantify the effects of the Covid-19 pandemic on claims inventory

Raleigh-Durham, North Carolina Area

• Short-term subcontractor role, serving as a consultant for both client and internal data projects
• Constructed comprehensive dashboards in Power BI for management consumption, presenting data related to revenue growth and contract processing in a concise and interactive manner

Raleigh-Durham, North Carolina Area

• Two-month consulting project which served as the Capstone of the MQM Program
• Conducted deep descriptive analysis of Duke Health urology surgery data, offering actionable insights to improve scheduling and avoid delays
• Tested a variety of unsupervised learning techniques to cluster ~400 unique procedures into a workable set of categories
• Evaluated modelling techniques including linear, logistic, gradient boosting, and random forest regression
• Presented results to a board of stakeholders including physicians and schedulers, advising how to better predict procedure times

Durham, NC

• Examined process of migration to new enrollment system for Affordable Care Act members, providing real-time design feedback to system developers for new enrollment maintenance applications
• Coordinated with management, customer service, and teammates to ensure an efficient enrollment process for the Blue Cross membership database
• Identified and suggested fixes for system errors and automation possibilities
• Trained ~40 colleagues on new standard operating procedures in both formal and informal settings
• Collaborated with technical writers to compose documentation to enhance training

Master Of Science In Quantitative Management, Business Analytics (Strategy Track), 3.51/4.0

• STEM-Designated data analytics program with a specific focus on strategic applications • Merit scholarship recipient

Bachelor'S Degree, Economics, Political Science, 3.72/4.0

Activities and Societies: Senior Honors Program in Economics• Graduated with Honors and Distinction