Dan McCormick

Manager, Fp & a @Genpact

Dublin, OH, US

Provides analysis of customer profitability and financial performance to senior sales leadership for Genpact’s pharmaceutical and healthcare services client.\\\\n• Leverages Anaplan financial planning system to track, analyze, and forecast financial impact of customer contract renewals for Retail Chain, Alternative Care, Mail Order, and Hospital pharmaceutical segments.\\\\n• Generates the budget, creates quarterly forecasts, and provides monthly reporting and analysis for the Hospital segment’s $35M in annual SG & A expense; manages booking of accounting accrual for trade sales commissions and booking accounting entries for sales’ monthly auto and lease expenses.\\\\n• Wrote SQL queries to pull sales and profitability data from separate Teradata databases for 340b government customers; leveraged Alteryx to create a workflow that joined the two tables for reporting.\\\\n• Performs quarterly audit of customer financial performance to confirm sales and sell margin performance align with customer contracts.\\\\n• Completed Genpact Advanced Analytics Course focusing on SQL, Python, PowerBI, Excel, and flow charts (finished #1 of 17 classmates).\\\\n \\\\n\\\\n \\\\n \\\\n\\\\n \\\\n

The Ohio State University Fisher College of Business

Bachelor of Science in Business Administration, Finance and Economics, Cum Laude