Data Analyst Financial

Sandra Miller, MBA

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

Procurement Analyst

Data Analytics Decision Analytics 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

●Supply Chain Analyst who designs processes to reduce mistakes, automate tasks, & boost efficiency

Professional Experience

Promotional Analyst II Contractor Jun 2024 – Feb 2025

CVS Woonsocket, RI

Analyzing large data sets to produce error free reporting for Demand Planners.

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

Impacting and influencing others - how to get buy in from Category Managers for the metrics being supplied

Tracking inventory data via proprietary inventory system.

Clinical Supply Data Entry Specialist May 2023 – May 2024

Seattle Genetics 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.

SCM Procurement Financial Analyst - IT May 2022 – Jul 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 a transitional dashboard for KPIs that utilized complicated formulas to develop a multi-faceted series of workbooks intended for use by demand planners.

Supply Chain Financial Analyst -IT

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.

Analyzing requests for proposals from various vendors.

Worked with all areas to resolve data issues and identify root causes to assist demand planners.

Skills: Data Manipulation · Dissemination · Data Analytics · Dashboard Building · KPI Dashboards · Data 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 Finance, Corporate Treasury, and Corporate Credit for consolidate loan trial balance as well as other required month-end operational reports; simplified processes to increase efficiency.

Senior Financial Analyst Treasury Ops Sep 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.

Managed cash flows and daily transactions related to credit card payments.

Consumer Payments and Treasury Operations projects (ATM, Lottery, Slot Machines)

Consultant: Report Analyst – HRIS - IT Jun 2016 – Aug 2016

Northeastern University Boston, MA

Provided support for Argos/Ellucian/Banner reports, creating cubed reports and dashboards for use within the HR Department. Updating database for new roles and transfers, updating responsibilities, and adjusting permissions.

Creating multi-layered dashboards for use by HR using a variety of tools, including SQL queries.

Creating ad hoc reports, as needed.

Worked here previously, during Add/Drop sessions

Consultant: Supply Chain Management Procurement Analyst - Logistics 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.

●Analyzing requests for proposals for various vendors.

●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.

Corporate 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 and then querying HFM to obtain calculated data for reporting Profit and Loss 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.

●Participated in Month End closing for trade accounts and reconciliations of GL accounts.

●Supply Chain Analytic for P&L for 13 regions and corporate, plus handling CAPEX and OPEX transactions.

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

●Calculated analytics for Logistics, including Freight on Board, cross-docking, and optimizing truck loads.

Financial Analyst & Operational Accountant, Univest Corporation, Bank Holding Company Souderton, PA Aug 2004 – Jun 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.

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

●Created most of the tables and charts for 10K, 10Q, working with Treasury and Finance.

●Calculated Haircut for risk related stocks and assets for stock exchange filings.

●Calculated Mortgage Servicing Rights for mortgage assets

●Performed EDGAR filing for SEC

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

Accounting: Successfully passed all four parts of CPA exam

Contact this candidate