• Program/Project Manager for the Business Intelligence and Reporting applications using PowerBI, Reporting Services (SSRS), and Looker• Interface with project teams to implement enhancements and onboard clients to the BI and Reporting platforms, including data modeling and processing recommendations• Architect and Manager of the SQL Server Data Warehouse used for Internal and Client Reporting • Manage the data-driven processes that extract, transform, and load data from company sources• Responsible for resource allocations, backlog management, and status reporting• Analyze existing code and architecture for performance improvements and data quality initiatives• Consolidate all documentation, communications, and procedures regarding company data operations• Member of the Data Governance board to establish and regulate the Company guidelines and standards for data retention, use, and accessibility

Senior Data Architect & Team Lead• Designed an Enterprise Data Warehouse inside the Greenplum appliance (PostgreSQL) for the storage and management of Medicare and Medicaid claim data• Created the design for the ETLs that will move the legacy data into the new EDW• Modeled the Operational Data Store and oversaw the integration with the services layer • Modeled the Operational Data Mart (ODM) to meet the business reporting needs

• Designed and deployed a Perioperative Data Warehouse that is fully operational and integral to the executive reporting of the Hospital and adhering to Institutional and HIPAA requirements and standards for managing Protected Health Information• Responsible for the design/development of Business Intelligence software and tools supporting the Data Warehouse objectives; Managed the design and deployment of Tableau reports• Coordinated and performed end-to-end testing of all Data Warehouse processing and logic• Developed security policies to manage and enforce security of the warehouse data, ensuring patient data is protected according to HIPAA and Institutional standards for access and retention, and routinely audit database access and activity• Project Manager for all technical projects: Assessed new requirements and scoped out all aspects of work; Coordinated with outside groups (upstream/downstream dependencies); Assigned projects to staff and managed the progress though completion and delivery

• Application Manager for Licensing Data Warehouse and Financial Reporting database ~ Managed initiatives and roadmaps across Engineering and Business teams for Functional and Schedule alignment with impacting and dependent applications ~ Managed multi-million dollar budgets and resource allocations for projects that spanned multiple releases and consecutive years ~ Coordinated all release efforts with the Development and Test teams, as well as the Support Team, Program Managers and Release Managers for each project ~ Project Manager and Functional Analyst for the application responsible for the financial calculations that Microsoft uses to report its monthly, quarterly and yearly revenue figures • Technical Designer for Licensing Data Warehouse ~ Managed the upgrade of all Production servers to SQL Server 2008 and implemented new features including Reporting Services, Database Compression, MERGE statements and Resource Governor ~ Re-architected existing schema to support both Data Warehouse (DW) customers and Operational Data Store (ODS) Customers ~ Introduced a subscriber model and automated SSIS packages for customers to easily onboard and retrieve Warehouse data without having to write their own code ~ Re-architected the licensing refresh jobs which reduced the average run time from 3+ hours down to just 18 minutes, drastically improving downstream application performance• Subject Matter Expert for Licensing data and architecture. Assisted other teams in the organization where required, including: ~ Worked on escalations from the Tier 2 Production Support teams to troubleshoot failures and resolve issues ~ Assisted the Systems Integration Testing (SIT) and User Acceptance Testing (UAT) teams in building out End-to-End environments. Included Windows Server configuration, SQL Server database restore and configuration, setting up user/group security permissions and configuring and running data flow jobs

• SQL Server Administrator for the Licensing Data Warehouse (Production and UAT servers)• Managed SQL jobs/DTS/SSIS Packages/Stored Procedures which import and merge data from numerous source systems throughout Microsoft • Managed and Audited the security for the Production servers, to ensure they are SOx compliant• Managed an OLAP application for business reporting• Flattened and rebuilt UAT environments for Quarterly Release testing (database move/restore, configuration)• Developed several .Net web sites for use with IT and business reporting (C# and VB)

• Managed pricing data for FPP and Open programs across the US, Canada and Latin America• Used SQL to create 40+ quality control metrics to ensure price list data integrity and accuracy• Created a website using VB.Net to manage changes for the FPP price lists and to provide users a tool where they can query non-pricing information (Weights & Measures, Version Returns, etc.)

- Worked extensively integrating data between several database warehouses within the company (DB2, MS Access and Sybase) using several different tools, including Compuware’s File Aid Express, VB, SQL and COBOL.- Customized a Siebel eBusiness application using Siebel Tools, Visual Basic and C++