Financial Analyst Data Entry

Sandra Miller, MBA

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

Senior Data Analyst

Financial Analytics Accounting Information Technology

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 SQL Oracle Financials PeopleSoft Financials Power BI SAP SOX SSRS / SSIS Snowflake Synergy/Xperience Tableau

Professional Experience

Financial Analyst II Contractor Jun 2024 – Present

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

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.

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

Supply Chain Financial Analyst

APN Software Services, Inc.

Siemens Healthcare East Walpole, MA Mar 2021 – Jul 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.

Operational Financial Reporting Analyst II Feb 2020 – Jan 2021

Brookline Bancorp Lincoln, RI

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

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

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.

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

●Heavily involved in Month End activities, clearing of suspense accounts, and auditing corporate charges.

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 and external financial reporting, for Cash Flows, Balance Sheet, and P&L accounts.

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

●Calculated Mortgage Servicing Rights for mortgage assets

●Performed EDGAR filing for SEC

●Month End Closing and reconciliation of GL 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