Financial Data Analyst with 20+ Years Experience

Sandra Miller, MBA

Woonsocket, RI 401-***-**** *****.*********@*****.*** www.linkedin.com/in/miller-sandra

Financial Business Analyst

Data Analytics Business Analysis Accounting Information Technology

Summary of Qualifications

●Skilled Data Analyst

●Data Analyst with 20+ years’ experience in financial accounting and 15+ in data analysis with data visualization.

●Experienced Accounting Professional who creates queries in SAP, SQL, HFM and other expense reporting software

●Continuous Improvement Specialist who designs processes to reduce mistakes, automate tasks, & boost efficiency

Areas of Expertise

Data Visualization Process Optimization Business Analysis FP&A GAAP

Technical Skills: AS/400 l BIDS/SSRS/Report Builder Cognos Crystal Reports Data Warehouse Argos l Great Plans Kinaxis Jack Henry JD Edwards Margin Miner/Salient MicroStrategy MySQL/PL SQL/T SQL Oracle Financials PeopleSoft Financials Point-of-Sale Power BI PowerPoint SAP SOX SSRS / SSIS Snowflake Tableau Workday

Professional Experience

Grant Specialist Contractor Aug 5, 2025 – Jan 16, 2026

DCYF Providence, RI

·Worked to convert to new billing and payment system

·Entering grants and contracts into new system ensured proper coding

·Finding and correcting discrepancies

·Tracked all payments from start to finish, gathering signoffs from required personnel

·Sent payments to vendors

Financial Analyst II Contractor Jun 3, 2024 – Feb 28, 2025

CVS Woonsocket, RI

Analytical rigor – capability to analyze large data and produce error free reporting

Excel knowledge – ability to develop reporting for all levels of the organization –utilizing reports and capability to develop data models

Impacting and influencing others - getting buy in from Category Managers for the metrics being supplied

Process improvement, driving results - Facilitate training/engaging Category Managers with PA tool

Working collaboratively cross functionally with multiple departments

Innovation

Clinical Supply Chain Data Specialist May 15, 2023 – May 31, 2024

Seattle Genetics/Pfizer Bothel, WA

Responsible for the day-to-day administration of the data entry requirements for client’s Forecasting and Demand planning management tools. Including all aspects of the data management process.

Working with a large data set to migrate data from one system into another within the monthly forecasting cycle, to identify inaccuracies within a large data set, and working within a very structured monthly forecasting cycle.

Led efforts to elevate the overall user interface and user experience of financial models, focusing on streamlining processes, improving accessibility, and enhancing the visual representation of financial data.

·Exhibited competency in integrating data and processes between Excel and Google Sheets, showcasing proficiency in leveraging diverse technological tools for enhanced efficiency.

·Established a meticulous approach to identifying and rectifying errors promptly, ensuring the highest levels of accuracy and precision in business case development and reporting.

SCM Procurement Financial Analyst May 18, 2022 – Jul 27, 2023

Siemens Healthcare East Walpole, MA

Served as owner of SAP key tactical activities and provided support for daily reports, logistics, and SAP maintenance. Provided resolution for escalations from order/management and sales team. Collaborated with key stakeholders in sourcing, manufacturing, distribution/logistics, finance, and IT to enable delivery of goals and targets by creating dashboards using T-SQL, NOSQL, Power BI, Snowflake, and Tableau for data visualization.

●Created transitional Tableau dashboard for KPIs that utilized complicated formulas to develop a multi-faceted series of workbooks intended for use by planners.

● Implemented robust data mining and transformation strategies, leveraging advanced techniques to extract valuable insights and ensure data accuracy for informed decision-making.

● Explored and implemented integrations between Tableau and external systems, facilitating the import and export of financial data for a holistic analytical approach.

●Implemented a continuous improvement mindset to optimize financial modeling processes, identifying areas for enhancement and implementing solutions for increased efficiency.

Supply Chain Financial Analyst

APN Software Services, Inc.

Siemens Healthcare East Walpole, MA Mar 2021 - May 2022

Collaborated with key stakeholders in Sourcing, Manufacturing, Distribution/Logistics, Finance, and IT to enable delivery of goals and targets by creating dashboards using T-SQL, NOSQL, Power BI, Tableau.

Provided support on tactical activities such as daily reports, logistics follow up and SAP maintenance.

Answered escalations and requests from order management/sales teams during demand and supply gap environments.

Owner of SAP key tactical activities during allocation periods with evening work required during these periods.

·Worked with all areas to resolve data issues and identify root causes.

oOwner of SAP key tactical activities during allocation periods with evening work required during these periods. Worked with all areas to resolve data issues and identify root causes.

· Implemented robust data quality assurance measures, ensuring the integrity and reliability of data inputs crucial for accurate financial analysis.

· Led efforts to elevate the overall user interface and user experience of financial models, focusing on streamlining processes, improving accessibility, and enhancing the visual representation of financial data.

Skills: Data Manipulation · Dissemination · Data Analytics · Dashboard Building · KPI Dashboards · Business Analysis

Operational Financial Reporting Analyst II Feb 2020 – Jan 2021

Brookline Bancorp Lincoln, RI

Developed, tested, & validated standard reports/dashboard based on business requirements using T-SQL to create dynamic data visuals. Served as SME on data, data structure, and data flow processes within Jack Henry (Silverlake, JhaKnow and Cognos) products or similar core application/system experience. Developed/validated reports, supported existing Access databases, & performed validation function for new enhancements or functionality to JhaKnow or Cognos, including cubes/new reports.

●Participated in month-end closing process in conjunction with Corporate FP&A and Corporate Credit for consolidate loan trial balance as well as other required month-end operational reports; simplified processes to increase efficiency.

●Implemented robust data governance frameworks, ensuring compliance with data management policies and standards to maintain data accuracy and security.

Senior Financial Analyst Treasury Ops Aug 2018 – May 2019

CVS Health Woonsocket, RI

Organized CVS data via SAP Business Objects, AD400, and Access. Maintained and enhanced database that was used as system of record for Credit Card Merchant ID numbers for CVS Health (PL/SQL). Aided with annual budget and monthly P&L forecasting and reporting for treasury operations; assisted with monthly treasury operations P&L close and monthly accounting functions using Tableau to illustrate data.

●Developed and maintained database, data visuals, and reporting to identify various component costs for each payment type and brand in Access, including credit, debit, contactless, mobile, checks, etc.

●Developed and maintained database and reporting to identify payment utilization trends by payment type, store and area (region, district, and state)

●Selected to assist with Consumer Payments and Treasury Operations projects (ATM, Lottery, Slot Machines)

● Integrated diverse data sources into Tableau, creating unified and comprehensive datasets to support detailed financial analyses and reporting.

● Explored and implemented integrations between Tableau and external systems, facilitating the import and export of financial data for a holistic analytical approach.

●Developed custom calculations in Tableau to address specific business requirements, tailoring the analytical capabilities of Tableau to the unique needs of financial modeling.

●POS Analysis

Consultant:Audit Analyst

DEPUY-SYNTHES, a division of J&J (contract) Raynham, MA Feb 2017 – Mar 2018

Audit Support for Sales Consultants for assigned Trauma/CMF territories from pre-audit planning phase through completion of audit and summary of audit results using multiple sources to include SAP queries, AS400, and Excel. Created Access Reports for use to partially automated scheduling processes. Participated in pre-audit planning meetings with sales consultants and third-party vendor. Setup territory audit tracking schedule in Outlook. Ran book inventory reports from ERP system., using SAP to pull data for analysis. Pulled reports from third party auditor portal. Communicated third party auditor count data to sales consultants for assigned territories. Prepared variance reports and isolated discrepancies of count vs. book inventory.

●Resolved count discrepancies with sales consultants in accordance with required timeline, ensure sufficient evidence is available to close reconciliation (i.e.: photos, count sheets).

● Followed protocol to develop & archive required audit files to serve as evidence of completed audits.

●Supported team lead in gathering data to support internal audit and external audit requests.

Business Analyst

Clean Harbors Norwell, Ma Nov 2016 – Feb 2017

·Working with QA to test software bugs and issues for supply chain rollout

·Coordinating with development teams to highlight issues with rollout and discuss methods to correct these issues.

·UAT for software project management, systematic testing steps for issues and concerns.

·Collaborated closely with business stakeholders to gather requirements and translate them into data solutions.

·SQL query writing to run diagnostics on process changes

·Creating PowerPoint documentation of all aspects of Supply Chain Inventory Management processes for use by all members.

·POS and SKU Optimization

Consultant: Supply Chain Management Analyst Apr 2015 – Jul 2016

CVS Health Woonsocket, RI

Gathered large data sets from an Oracle data warehouse, performed analysis, and provided analytics and reports via extensive Pl/SQL, T-SQL, and query writing code. Utilized Excel, Access, and PowerPoint to summarize findings.

●Reduced overstock by $57M by using complex SQL queries to work around database limitation; revealed low-selling products that were subsequently discontinued to prevent continued revenue loss.

●Resolved error in calculations for rate determination in credit card costs, which saved revenue.

●Recruited to work with manager, business, & vendors to provide analytics on inventory, supply chain, & sales.

● Spearheaded initiatives to enhance and optimize existing financial models, introducing advanced calculations and KPIs for more accurate and insightful value consulting engagements.

●Explored and implemented cloud-based solutions for financial modeling, enhancing accessibility, stakeholder collaboration, and real-time updates for stakeholders.

Reporting Analyst Sep 2014 – Apr 2015

Santander Bank Dorchester, MA

Created an entirely new process for obtaining reports after a new flat file conversion using a cleaner process than had been previously used. Gathered large sets of data and correcting an incorrect new file that was not repeatable. Updating the entire process using the KPIs needed to perform reporting and analytics.

·Trained staff to use new platform.

Corporate Senior Financial Supply Chain Analyst/Accountant Dec 2008 – Sep 2014

Bimbo Bakeries USA (Bakery Manufacturing) Horsham, PA

Created deep level analytics using Hyperion to load data for calculations. Reporting P&L for 13 regions plus corporate level data visualization. Calculated foreign currency exchange and created balance sheet and P&L reconciliation of foreign shared services. Cleared misallocated items during monthly close process and provided AR/AP reconciliations for $57M trade accounts.

●Involved heavily with complex conversion from PeopleSoft to Oracle and solved accounting data integrity issues created by difficult migration.

● Conducted in-depth quantitative analyses to provide robust decision support, utilizing advanced analytical methods to derive actionable insights that directly contributed to strategic business decisions by leveraging MS Excel macros and altering VBA scripts.

● Developed intricate formulas within Excel to address complex financial scenarios, demonstrating a deep understanding of mathematical concepts and financial modeling principles.

●Optimized VBA macros for enhanced performance, reducing processing times and improving the overall efficiency of automated tasks within financial models.

Additional Experience

Financial Reporting Analyst & Operational Accountant, Univest Corporation, Bank Holding Company Souderton, PA 2004 – 2008

Providing SEC related notes and tables for 10K, 10Q, and 8K notes and tables. Month Ending responsibilities, including complicated reconciliation of insurance, banking, and AR/AP accounts, GAAP, SOX.

●Created process and validated consolidated financial statements for intra-company financial reporting, for both Balance Sheet and P&L accounts.

●Developed custom functions using VBA to address specific business requirements, adding tailored functionalities to Excel models for improved analysis capabilities.

Education

Master’s in Business Administration: Concentration in Information Systems DeSales University Center Valley, PA

Bachelor of Science in Accounting DeSales University Center Valley, PA

Contact this candidate