• Actively Managed a 150M Budget and 400+ Applications for the Research IT organization
• Created and executed on a work force optimization plan of over 100+ internal resources
• Developed a proprietary Total Cost of Ownership cost model for our Application Portfolio
• Established a streamlined end to end process for collection and submission of quarterly forecast cycles to FP&A
• Designed and implemented an automated forecasting process that aligned to our actuals
• Built out reporting for our 25M+ AWS Cloud spend to support a variety of savings & optimization programs
• Implemented a process to support our internal software rationalization efforts that led to a 3M+ savings
• Partnered with Leadership to help measure and track qualitative and quantitative benefits realization from Investments
• Provided ongoing support to the organization through technical expertise, financial analytics, and operational excellence capabilities to drive positive outcomes and data improvements.

• Provided Financial and Operational insights to Senior Leadership of the IT R&ED Function
• Assisted delivery teams throughout the budgeting lifecycle
• Partnered with Leadership to help measure and track qualitative and quantitative benefits realization from Investments
• Built and maintained analytical reporting capabilities that support the mission of the Finance and Operations function as well as the broader R&ED IT organization
• Created frameworks to collect, cleanse and consume data into our target reporting tools/repositories
• Developed modeling capabilities in support of strategic objectives/programs of the organization.
• Identified actionable results thru data correlation findings
• Supported ad-hoc projects and requests that are assigned to the Finance and Operations function
• Research, identify and resolved root causes driving financial variances
• Translated and correlated complex data points into summarized consumable material.

• Oversaw the entire end to end IT organization's financials
● > $1.5B)
• Reconciled Celgene's SW budget (post-merger BMS/Celgene) and identified $30M in initial savings
• Focused on centralizing operations to promote efficiency and financial transparency to inform decision making and governance
• Built Power BI dashboards around Project Spend Metrics for ITLT
• Established a snapshot process able to derive KPIs and other metrics from ServiceNow project data
• Created a Project Financials Reconciliation Process from SAP to ServiceNow for month close
• Initiated a process to capture SAP general ledger error-transactions and import into ServiceNow
• Designed a What if Analysis tool in Power BI for impact of Ideation projects on current and future Portfolio
• Managed project financials within ServiceNow
● for the IT project portfolio
● > $500M)
• Drive process improvements for project financials in ServiceNow, and manage and maintain the PPM module financial components
• Crea

• Designed (in Power BI) a tool for Service Owners to view contract terms to improve their planning and compliance for hardware and software
• Developed and maintained a Power BI dashboard for:
• analysis and tracking of IT GPT's $120
● Budget
• tracking IT GPT projects for budget and date changes and for status of Change Requests
• Created and maintained a Power BI dashboard for CIO, FP&A and ITFM to track the IT budget and identify KPI's
• Oversaw budget and forecast cycles for GPT
● • Provided Service Owners with forecasting and variance drivers for Quarterly Adjustment projections
• Worked with Service Owners on the Value Cost Analysis for M&A activities
• Developed and maintained Oracle queries to resolve financial data gaps
• Developed a SharePoint library to store all SOWs and PDDs for Service Owners
• Developed a tool to forecast operational spending to improve accuracy of the accrual process and Year-end Close
• Wrote Excel macros and other ad-hoc reports for GPT C

• Created Template for Value Cost Realization for IT PMO
• Produced weekly report to track the status of projects (Planned, In-flight, or Complete)
• Worked monthly with Portfolio Managers to produce actions to resolve the project data gaps
• Perform, as-needed, QA for dashboards supporting the CIO and ITSL Team
• Developed Snap-Shot Tool which is a set of macros to track:
• Project durations
• EPM Database changes (e.g. financials, start/end dates)
• Persistent deltas between Oracle and EPM databases
• Vendor Management Team purchase order status
• Developed Power BI dashboards for IT GPO:
• Vendor Management Team to track labor categories in People Tracker and TAPFIN
• Contract Management Team to track contract from initial request through final approval
• Developed Power BI dashboards for IT PMO:
• Quarterly performance survey of portfolio and project managers
• Developed Power BI dashboards for ITSLT encompassing the IT PMO's Top Project Report
• ad hoc duties includ