Daniel Leopold Email & Phone Number

Pittsburgh, PA, US

Pittsburgh, Pennsylvania, United States

Greater Chicago Area

• Drove a 400% increase in application processing by establishing a repeatable end to end process and pipeline for TDM Treatments of SQL Server Applications acting as the lead project manager
• Partnered with senior leadership to set up a Test Data Management practice to mask sensitive client data; 600+ sensitive data elements were masked.

Pittsburgh, Pennsylvania, United States

United States

• Led the conversion of a portfolio of commercial insurance policies for a multi-billion client involving interfacing with client, mapping business and systems requirements, performing system conversion and quality.
• Completed the conversion of several hundred past claims and established several new templates and best practices for PMO office to improve efficiencies with remaining claims conversion efforts

Raleigh-Durham, North Carolina Area

• Partnered with team on a comprehensive analysis to identify the strongest predictors of employee attrition: gathered historical data, cleansed the data for statistical modeling, built multiple regression model in R.
• Wrote SQL queries to pull data for dashboards: created and re-engineered regular and ad-hoc Excel and Tableau based dashboards to showcase and report corporate trends in attrition, hiring, and diversity, reducing time.
• Automated and standardized the global process of projecting total costs for new jobs: built VBA macros and excel dashboards to project talent costs across all divisions and geographies, establishing uniformity and.

Raleigh-Durham, North Carolina Area

• Designed and developed the division’s $700 million variable compensation model increasing the amount and accuracy of data provided to senior management, allowing for better decision making
• Spearheaded and automated a refreshed excel-based year-end Reporting Pack using VBA macros to pull data from company servers and provide C-suite leaders with additional exhibits while reducing completion time by 50%
• Designed and implemented a new database to track special compensation, improving the accuracy of payments and increasing the amount of data provided to senior management.
• Prepared annual financial projections monthly for review with analysts and management to better determine the year’s variable compensation pool
• Overhauled excel-based salary model to reduce errors in predicting salary growth; made recommendations to senior leaders which reduced errors by 80%

Chicago

• Analyzed and improved strategy, finances, costs, revenue projections, and mission statement for the confectionary consulting start-up, resulting in profitability in one year
• Researched and built client relationships, created Excel dashboards and data, and advised on strategies increasing revenue by 20%

Bloomington, Indiana Area

• Launched the first microfinance program at Indiana University to lend money to small business owners.
• Defined fund lending standards after researching comparables.
• Formed a client referral and fundraising partnership with IU Credit Union.
• Established 501(c)(3) non-profit status for the organization.
• Designed training curriculum for operation and lending, creating a new Kelley class
• Crafted fundraising processes to comply with regulatory standards.

Detroit

• Extracted and organized internal data for analysis
• Utilized data analytics and provided recommendations to reform the training team’s compensation scheme
• Created template for accounting to implement new, recommended compensation scheme
• Researched and designed new hire procedure for mortgage operations
• Coordinated with internal programmers and recruiting to implement new hire protocol

Master Of Business Administration - Mba, Business Analytics & Strategy Consulting

Activities and Societies: Consulting Club Business Analytics Club

Bachelor'S Degree, Finance, General

Activities and Societies: Hoosier Social Impact Fund, Student Accounting Society