Reports Analyst

Cicely Smith

Bristol, PA 609-***-**** ***********@*****.***

Extensive experience with gathering requirements, translating requests into efficient workflow, and integrating data across applications to address in/external customer concerns.

Work Experience

FMTalent, Information Management Analyst (Nov 2024-May 2025), Federal Contractor at Office of Head Start, Philadelphia, PA

Demonstrated proficiency in utilizing a variety of web-based and commercial off-the-shelf data management software packages, including BI Dashboard, to suit changing customer requirements. Demonstrated ability to aggregate, analyze and present data gathered from multiple sources. Performed data management and manipulation by maintaining weekly and monthly updates across roughly 30 Smartsheet grids. Implemented Smartsheet automation to streamline task assignment, reduce manual effort, and address customer complaints.

APN, Data Quality Analyst (Dec 2023-June 2024), Consultant at American Red Cross, Remote Work

Monitored compliance of data flows against data quality standards. Resolved data quality problems, identified via customer complaint, through in depth analysis and appropriate process design strategies using Salesforce Lightning. Reviewed root-cause analysis associated with data integrity issues and implemented best practices using Donor Data Portal, to suit changing customer requirements. Performed data management and manipulation by creating MS Excel reports using pivot tables, v-lookups, and functions, based on business needs (data mining).

Javen Tech, Global Product Content Specialist (Sept 2020-Feb 2023), Consultant at 3M, Remote Work

Responsible for driving global product content digitization efforts between business group divisions and global teams. Implemented content management process through systems specifically designed to proactively manage ecommerce and digital product content, to address customer complaints. Performed data management and manipulation by exporting data from SAP Hybris and creating MS Excel reports using pivot tables, v-lookups, and functions, based on business needs (data mining) and to suit changing customer requirements. Resolved data quality problems through in depth analysis and suggesting appropriate process design strategies by creating and shepherding issues/tickets in Jira.

Modis, Data Analytics (Mar 2019-July 2019), Consultant at ETS, Ewing, NJ

Responsible for managing assigned customer data by creating ad hoc data mining tools in MS Access, based on changing business needs (data mining) and to suit changing customer requirements. Provided day-to-day support of the data management hub, and responsible for reviewing and resolving data governance issues related to data cleansing, matches, merges, and master data records. Created v-lookups and pivot tables in Excel.

PepBoys, Store Inventory/Replenishment Analyst (Mar 2017-Jan 2019), Philadelphia, PA

Responsible for the recurring processes required to create/maintain reporting analysis of store inventory and assortment outputs to aid in the execution of store merchandising activities in support of overall company sales goals and to suit changing customer requirements. Provided store level inventory and assortment analysis, as well as troubleshooting, for unproductive store inventory levels and to respond to customer complaints. Created VB macros, v-lookups and pivot tables in Excel. Created ad hoc data mining tools in Hyperion Brio and MS Access based on business needs (data mining).

Quad656, Data Analyst (June 2016-Nov 2016), Consultant at CBIZ Savitz, Philadelphia, PA

Responsible for the recurring processes surrounding the maintenance, update, and reconciliation of retiree health plan data, enrollment, and billing transactions. Implemented data extraction processes from multiple SAP Business Objects modules including report creation and facility tracking. Created VB macros, v-lookups and pivot tables in Excel. Created ad hoc data mining tools in MS Access and MS Excel based on business needs (data mining).

Infotek, Business Analyst (Mar 2016-May 2016), Consultant at TD Bank, Mt Laurel, NJ

Created ad hoc MS Access tools and MS Excel macros and pivot tables based on business needs. Implemented data extraction and reconciliation processes from multiple Tririga modules including invoice creation and survey tracking. Manipulated complex datasets with a variety of tools around the Tableau product set.

Mondo, Data Quality Analyst (Nov 2015-Feb 2016), Consultant at Harte Hanks, Trevose, PA

Ran batch data extracts and updates in Excel, using VB macros and pivot tables. Implemented data extraction processes from multiple SAP Business Objects modules including report creation and facility tracking. Researched failed transactions, reporting software bugs or data errors upon discovery.

Insight Global, Systems Analyst (Aug 2015-Oct 2015), Consultant at PHH, Mt. Laurel, NJ

Provided analysis, document preparation and requirements gathering. Created ad hoc MS Access tools to manually scrub data and resolve errors within large data sets. Created VBA macros, MS Excel reports and pivot tables based on business needs (data mining).

Insight Global, Systems Analyst (Mar 2015-July 2015), Consultant at IBC, Philadelphia, PA

Created ad hoc MS Access tools to manually scrub data and resolved errors within large data sets pulled from Teradata. Documented and reviewed data requirements for creating tools (SSIS to create ETL packages), VBA macros, MS Excel reports and pivot tables based on business needs. Implemented data extraction processes from multiple SAP Business Objects modules including report creation and facility tracking.

Greenline, Business Analyst (May 2014-Dec 2014), Consultant at Karcher, Blackwood, NJ

Provided analysis, document preparation and requirements gathering; worked with multiple stakeholders to synthesize information across departments. Created ad hoc data mining tools in MS Access and MS Excel reports based on business needs. Support and manage supply chain purchasing operations, source new vendors and manage existing vendor relationships.

KForce, Data Analyst (March 2014-Apr 2014), Consultant at Heffler, Philadelphia, PA

Manually scrubbed data and resolved errors within large data sets. Created ad hoc reports (SSRS) based on business needs. Implemented data extraction processes from multiple SAP Business Objects modules including report creation and facility tracking.

Select Group, Research Analyst (Oct 2013-Jan 2014), Consultant at Elsevier, Phila, PA

Manually scrubbed data and resolved errors within large data sets, requiring the collection of confidential data from external sources. Created ad hoc data mining tools in MS Access and MS Excel reports based on business needs. Implemented data extraction processes from multiple SAP Business Objects modules including report creation and facility tracking.

Skills

Data Mining – Extensive experience with gathering customer requirements, translating requests into efficient workflow, and integrating data across applications to address in/external customer concerns.

Data Reconciliation - Experience in querying, data extraction and data transformations. Ability to interpret and reconcile underlying data.

Business Process Flow - Providing analysis, document preparation and requirements gathering; working with multiple stakeholders to synthesize information across departments.

SmartSheet - Implemented Smartsheet automation to streamline task assignment and reduce manual effort. Updated Dashboards as needed. Maintained weekly and monthly updates across grids.

Microsoft Excel – Skilled at creating large spreadsheets including importation and management of data, v-lookups, h-lookups, and processing of primary data to create reports and pivot tables. Experience working with large data sets of 10K+ lines.

Jira - User Role - Experience with resolving data quality problems through in depth analysis and suggesting appropriate process design strategies by creating and shepherding issues/tickets.

Salesforce Lightning - Production and Fundraising modules. Experience with creating custom reports to query large datasets, responding to case updates, and validating data between modules.

SAP Hybris, now known as SAP Commerce Cloud - Experience with data management and manipulation by exporting data to create MS Excel reports using pivot tables, v-lookups, and functions, based on business needs.

Microsoft Access – Strong grounding in the synthesis of data into valuable and accessible reports for users at multiple levels. Experience with designing and executing databases and modifying structures to suit changing customer requirements.

SAP Business Objects – Familiarity with inserting, extracting and manipulating data, creating data matches and applying resolution procedures.

Hyperion Brio - Skilled at designing and developing various types of reports (Pivot, Tabular, Chart and OLAP Query reports) to import, extract and manipulate data (ETL).

Donor Data Portal - Experience with creating links between Donors and Gifts, validating data, and tracking down errors.

Education

Kean University, Union, NJ (1992-1998) - Earth Science - Geology. Dean’s List 4 semesters, Theta Phi Alpha National Service Sorority.

Leadership

Nolose, Inc - (2015 - 2020) - Board of Directors - Secretary, Grant Review

PTWC, Mazzoni Center - (2013 - 2018) - Steering Committee - Co-Chair

Contact this candidate