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

PROFESSIONAL EXPERIENCE

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

●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 data 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 - American Red Cross Remote December 2023 – June 2024

Data Quality Analyst (Consultant)

●Monitored compliance of donor 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 and SAP Business Objects modules, to suit changing customer requirements.

●Performed data management and data manipulation by creating MS Excel reports using pivot tables, v-lookups, and functions, based on business needs (data mining).

Javen Tech - 3M (HealthCare Division) Remote September 2020 – February 2023

Global Product Content Specialist (Consultant)

●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 data 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 - ETS Ewing, NJ March 2019 – July 2019

Data Analytics (Consultant)

●Managed 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, mergers, and master data records.

●Created v-lookups and pivot tables in Excel.

PepBoys Philadelphia, PA March 2017 – January 2019

Store Inventory/Replenishment Analyst

●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 - CBIZ Savitz Philadelphia, PA June 2016 – November 2016

Data Analyst (Consultant)

●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 - TD Bank Mt Laurel, NJ March 2016 – May 2016

Business Analyst (Consultant)

●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 - Harte Hanks Trevose, PA November 2015 – February 2016

Data Quality Analyst (Consultant)

●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 - PHH Mt. Laurel, NJ August 2015 – October 2015

Systems Analyst (Consultant)

●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 - IBC Philadelphia, PA March 2015 – July 2015

Systems Analyst (Consultant)

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

ADDITIONAL EXPERIENCE

●Greenline - Karcher Business Analyst (Consultant) (May 2014 – December 2014)

●Kforce - Heffler Data Analyst (Consultant) (March 2014 – April 2014)

●Select Group - Elsevier Research Analyst (Consultant) (October 2013 – January 2014)

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.

●Smartsheets: 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 data 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) - Coursework toward Bachelor of Science in Earth Science - Geology and Bachelor of Arts in Philosophy and Religion. Dean’s List 4 semesters

Pemberton Twp High School, Pemberton Twp, NJ (1990 - 1992) - High School Diploma

LEADERSHIP

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

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

Contact this candidate