Wrangling data for the Worldwide Operations team.

Environment: SQL Server Reporting Services (SSRS), Tableau, SQL, SQL Server, Oracle, Netezza, SAP HANA• Consult and counsel on execution of Program and Product initiatives from a systems and data perspective (designing implementation of program offerings in the context of current systems/data, and identifying when changes to systems or new data are necessary)• Contribute to Generics IT strategy development and act as subject matter expert on • Create complex ad hoc and scheduled analyses/reporting to support business initiatives• Define and apply best practices for data and report management• Manage, recruit, and mentor data analysts and data scientists• Maintain generic drug equivalency framework and act as subject matter expert on related third party data sources (MediSpan, First Databank, etc.)• Primary analytics and implementation resource for generic drug RFPs bringing McKesson over $400M in value annually.

Environment: Business Objects Enterprise (Desktop Intelligence - Deski, Web Intelligence - Webi), MicroStrategy, SQL Server Reporting Services (SSRS), SharePoint, Excel, Attensity, SQL, Teradata, Oracle, SQL Server• Manage, recruit, and mentor a reporting and business intelligence team that delivers ad hoc and custom reporting solutions to meet constantly evolving business needs• Manage priorities with business users and executives to better allocate workload for the team via informal and formal priority meetings, as well as project and incident tracking software (JIRA)• Manage projects related to the delivery of reports and data to end-users, both external and internal• Design and maintain reports using Business Objects, MicroStrategy, SSRS, SQL, and Excel• Develop complex SQL scripts to support reporting needs and ETL processes• Act as QA/Peer Review/Tester for other Business Intelligence and ETL developers• Report, research, and correct data governance issues within the data warehouse• Act as subject matter expert for Customer Care, Partner Care, Product Onboarding, Product Fulfillment, and International knowledge areas• Successfully transitioned supported departments from Business Objects Enterprise to MicroStrategy• Successfully transitioned external partner-facing reporting from Business Objects Enterprise to SharePoint and SSRS• Promoted to role in 2011

Environment: Crystal Reports Enterprise XI, Excel, Query/400, AS/400 SEQUEL, MS Query, SQL, VBA, DB2, Lawson, Access, Paradox, SharePoint• Serve as one of five regional experts responsible for developing standards and processes for the guidance, training, and development of junior systems analysts• Act as a team leader, mentor and second level support contact for system analysts throughout the country. Delegated assignments and projects to system analysts and other IT resources• Develop and implement company-wide training policies. Develop training materials for end-users of all levels, including online video training, instructor guides, exercises, and testing. Train staff of all levels on topics ranging from business process to technology• Assess worth and impact of emerging software and hardware. Report evaluations and recommendations to business leaders. Manage software and hardware deployments for regional staff• Provide end-user support for application and reporting issues related to Crystal Reports Enterprise. Train junior analysts and other staff to design and build reports using Crystal Reports and SQL• Design reports and data entry tools for Accounting, Marketing, and Circulation departments using Crystal Reports, Access, AS/400 SEQUEL, Query/400, Excel, VBA, and SQL• Built and maintained technical relationships with delivery partners (Miami Herald, Chicago Tribune, Milwaukee Journal-Sentinel, South Florida Sun-Sentinel, Tampa Tribune). Analyzed and improved data exchange processes with key delivery partners• Promoted to role in 2000