TECHNICAL SKILLS:

Excel Expert: (28 years) - 2016, O365 - Modeling, Pivot Tables, V-lookup, Macros, Complex Formulas, Power Pivot, Power Charts, Power Query.

Microsoft Certified (2019) - Dynamics 365: Fundamentals

Microsoft Apps:: (28 years) - 2016, O365 - Access, Outlook, PowerPoint, SharePoint, TEAMS and Word.

Data Visualization: Power BI Desktop (5 years) / Tableau (1 year) - Connecting to multiple sources, Power Query and M, Data modeling and DAX

Six Sigma Green Belt: Certified (2002): Continuous improvement through Process Mapping

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

IT Operations Analyst

Responsibilities:

• Review invoices and compare license usage wif billing. Follow up wif vendors.
• Responsible for SOWs and COs regarding contract and vendor employees. Expedite flow and onboarding.
• Applying teh split of CapEx and OpEx correctly. Reporting in Dynamics 365, Excel, Power Query.

Confidential, Aurora, CO

Senior Data Analyst

Responsibilities:

• Call Center metrics on Primary Care, Nurse Advise, Specialty Appointments, and Covid-19 lines for daily Scrum.
• Collaborate wif leadership to understand performance goals/targets and quantify performance gaps (incl. time, volume and financially based metrics)
• Analysis of system data from Aspect, Dynamics and Oracle DB to analyze metrics and identify data trends.
• Build performance reports and dashboards wif SQL, Excel, Power Query and Tableau.
• All meetings conducted in Microsoft TEAMS.

Confidential, Scottsdale, AZ

Transportation Data Analyst

Responsibilities:

• Supplier Performance Management. Data management of Customer Surveys, 3 Insurance Carriers, Route tracking to include Pack and Load, Customs, and Delivery.
• Communication and vendor review wif Confidential international offices.
• Communication wif suppliers regarding their monthly performance versus contractual SLAs.
• Created tool for team to help wif job assignment. Based on monthly past month performance per shipping lane.
• Managed teh collection of Root Cause Analysis from suppliers for any sub-target customer survey score.
• Managed expectations and provided best client experience wif timely status updates to Account Managers.
• Produced Power BI dashboards wif KPI and visualizations depicting customer satisfaction and supplier’s performance. Published to multiple audiences. Shared information wif international offices via Google Sheets.

Confidential, Chandler, AZ

Business Analyst

Responsibilities:

• Wireless device issuance process analysis. Mapping of issuance process, asset management, and billing processes. Analysis of employee usage, carrier spread, and risk.
• Supported teh successful RFP leading to teh consolidation of company paid wireless devices to a single global carrier resulting in a monthly savings of $1.8M
• Data mining carrier billings to perform analysis and reporting of Confidential owned wireless device billing data. Used SQL Management Studio, Excel and Power BI.
• Assisted in teh creation of a new dedicated wireless device team for issuance and asset management.
• Cost Analysis. Data mining in ACES to discover anomalies in production costs. Updated aftermarket pricing for aviation spares to maintain margins, using SQL, Excel, & SAP.

Confidential, Scottsdale, AZ

Reporting Analyst

Responsibilities:

• Data audit, using SQL and Access for verification and validation of Medicare Part D reports prior to submission to teh Federal Government.
• Mapping of business processes and workflows to aid in data mining. Documenting best practices for call center’s performance measures. Designed new weekly call center performance reporting for 3 locations.
• Used SAP for tracking of goods and services and update of teh same for new fabrication facility in Ireland.
• Contracted suppliers to validate purchase orders, confirmed shipping dates and verify receipt of capital goods
• Shared hot issues at bi-weekly management meetings. Used Excel, SharePoint, and SQL Management Studio.

Confidential, Phoenix, AZ

Operations Analyst

Responsibilities:

• Led teh change management and communication efforts dat unified teh monthly financial statements of 72 very individual chapters dat delivered national consolidated financial reporting.
• FP&A. Financial modeling to support forecasts, budgets, variance analysis, and strategic business decisions.
• MDM, Master Data Management to supply intelligence support to Digital Marketing, Donor Care, Corporate Giving, Finance and Accounting, Wish Granting - Professional outreach, Medical outreach, and all stakeholders.
• Mapping of chapter business processes and workflows. Chapter requirement gathering. Documenting of best practices.
• Supported Foundation Wish Granting and Foundation fundraising wif extensive research of government statistical and public health databases for administrative, operational and statistical re,porting. Analyze and interpret trends.
• Designed, published, harvested, and analyzed many survey projects. Multiple research interests and subjects gathering data from both internal and external constituents.
• Shared business intelligence wif all functional departments, accomplishing a better public insight into teh Foundation on a national level, resulting in a year over year increase of $25M in donations.
• Black Baud implementation. Supported teh national effort to onboard each chapter. Monitored UAT. Set up software asset management.

Confidential, Phoenix, AZ

Operations Analyst

Responsibilities:

• Selected to special project - TCAS Transition Team - Engineering divestiture to L3 Communication’s ACSS div.
• Managed $7M in capital equipment budgets for 14 technical managers using MS Project.
• Responsible for managing fixed assets inventory for flight management systems engineering group.
• Monitored and reported progress of long-term capital construction of simulation benches using MS Project.
• Created and maintained models for project tracking budget, man-hours on firmware and software development for teh Airbus A-380 using Access, Excel, Visio, and Project.
• Documented business processes for continuous improvement analysis.
• Mapped international invoicing process and workflows. Eliminated inefficiencies providing $2.3M annual savings.
• Performed resolution of invoices (solving PO discrepancies and internal task mischarges) and authorized payment of department PO’s.
• Designed two MS Access based DB applications, one dat tracked WIP and captured test data for displays (CRTs and LCD panels) for production. Teh second tracked FAA SUMARs to create analysis reports based on failure trends.