Sandra Miller, MBA

Woonsocket, RI 401-***-**** ad2ryh@r.postjobfree.com https://www.linkedin.com/in/sandra-miller-0552a412/

Data Visualization Analyst

Data Analytics Business Analysis Accounting Information Technology

Summary of Qualifications

●Skilled Operational Accounting/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 Continuous Improvement Statistical Modeling Financial Data GAAP

Technical Skills: Argos AS/400 l BIDS/SSRS/Report Builder Cognos Crystal Reports Data Warehouse Ellucian/Banner Argos l Great Plans Kinaxis Jack Henry JD Edwards Margin Miner/Salient MicroStrategy MySQL/PL SQL/T SQL Oracle Financials PeopleSoft Financials Power BI SAP SOX SSRS / SSIS Snowflake Synergy/Xperience Tableau Kinaxis Nexus

Professional Experience

Clinical Supply Data Entry Specialist May 2023 – Present

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 Analyst 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 transitional dashboard for KPIs that utilized complicated formulas to develop a multi-faceted series of workbooks intended for use by planners.

Suppply Chain 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.

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

Operational 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 and Corporate Credit for consolidate loan trial balance as well as other required month-end operational reports; simplified processes to increase efficiency.

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

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

Consultant: Report Analyst – HRIS 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.

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

Corporate Senior Financial Procurement 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.

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

Additional Experience

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

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

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