Data Analyst Business Partner

Gregory Bonner

SUMMARY

• Experienced Data Analyst responsible for Performing Data Mapping, Data Clean up, Data design (Data Modeling) to integrate the data across the multiple databases.

• Collected and cleansed data used in the POS systems for sales team, employee offers, severance pay, and vacation payout.

• Proficient in data mapping for integration of systems, conversion, and acquisition related projects

• Responsible for cleanse employee data housed in excel spreadsheets, stored via SharePoint-lookups via excel for business Partner cross company reports.

• Managed quality of employee data records and proactively monitored data alignment.

• Developed Data Migration and Cleansing rules for the Integration Architecture

• Responsible for Data Mapping/ Data Alignment/Data Cleansing

• Stibo Systems for MDM & PIM, used in Data maintenance and quality.

• Reviewed, edited, and posted to Excel spreadsheets accurately. TECHNICAL SKILLS

• Workday/ Remedy

• Optymze

• SYNYGY Sales Performance System

• Microsoft Excel, Word and PowerPoint

• Windows XP, 7, 8, and 10

• SharePoint

• Access

• Peoplefluent

• Org Modeler

• Org Publisher

• Transaction Manager/ Office 365/ Outlook

• Org Modeler / AON Strategic Services

• Data Mapping/ Data Alignment/Data Cleansing

CORE COMPETENCIES

• Proficient with the data management policies, procedures and common technical tools.

• Strong analytic, evaluation and interpretation skills.

• Excel Data Mapping, Data Migration, monitoring data alignment accuracy.

• Ability to exercise and control the executed tasks with the planned activities.

• Ability to work as part of a team and on own initiative, ability to work to deadlines. PROFESSIONAL EXPERIENCE

Goat National – Philadelphia, PA

June 2019 – February 2025

Sr. Analyst Ecommerce Inventory

• Responsible for listing products across all properties and creating growth strategies for new products by developing strong marketing campaigns

• Develop marketplace and digital advertising promotional campaigns to grow sales.

• Support a collaborative, innovative, and results-oriented environment with a cross-functional team focused on driving e-commerce business

• Work closely with supply chain and operations teams to optimize product availability and manage inventory flow

• Analyze historical data and current trends to identify risks and opportunities for current sales trends. Johnson & Johnson Depuy Synthes – West Chester, PA February 2018 – April 2019

Compensation Analyst

• Payroll validation thru excel in comparison to Synygy v11 reporting.

• Audit reporting adjustments validations for Trauma / CMF SYNYGY to OPTYMZE Legacy systems.

• Creating reports from Legacy systems for Field Managers balances down to consultant level.

• Administrator for network access thru One-Identity Manager Portal.

• Data Validation thru excel across multiple Legacy Comp Systems

• Creating EIB for mass upload to Workday

Iron Mountain - Remote

March 2017 - February 2018

Data Analyst

Cleansed and collected data on the case report form and submitted to the sponsor in electronic format.

Data Validation thru Access exported to Excel for AON reports.

Ensured Data Accuracy across multiple corporation platforms in Human Resources.

Monitored sharepoint site as administrator for cleansed uploads to AON. ShirePharmaceuticals Exton PA

June 2016 – March 2017

Sr. Data Analyst

• Cleanse employee data housed in excel spreadsheets, stored via SharePoint-lookups via excel for business Partner cross company reports.

• Ensuring that the data sets are being mapped correctly from Peoplefluent to Workday

• Manage quality of employee records.

• Perform auditing activities to ensure accuracy and compliance of data; update records as needed.

• Proactively monitored data alignment.

• Proficient in data mapping for integration of systems, conversion, and acquisition related projects

• Performed the Data Mapping, Data design (Data Modeling) to integrate the data across the multiple databases in to EDW

• Generate basic data reports as requested and assist in process documentation/updates.

• Ensure quality and accuracy. 40% Inquiry Management & Issue Resolution

• Performed data cleanse, and Data mapping for EIB uploads via Excel for Workday.

• Support employee data changes in Workday, Org Publisher, Transaction Manager as

• Super User Admin Role including but, not limited to mass changes/uploads, re-organizations, etc. GlaxoSmithKline - Philadelphia, PA

April 2014 – May 2016

Sr. Data Analyst

• Provided detailed reports in excel format that assisted GSK in the acquisition on Novartis.

• The lead analyst on all data between the two companies, whereas my role was multifaceted consisting of cleansing data, cross referencing data by use of creating data tables and V-lookups.

• Managed a team consisting of 5 Analyst and 2 Human resource representatives.

• Collected and cleansed data used in the process of creating employee offers, severance pay, and vacation payout.

• Consulted on Novartis processes during the transition over to client, via data alignment, and data mapping over to the new company.

• Collected and cleansed data used in the POS systems for sales team, employee offers, severance pay, and vacation payout.

• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).

• Assisted in detail oriented projects that required knowledge of the two companies processes, and acquired additional resources which I managed when needed to complete large projects on short time lines. Jefferson University Physicians - Philadelphia, PA Feb 2010 – Feb 2014

Data Analyst

• Collect data in form of reports from different departments of the organization and compiled them together to prepare a summarized report.

• Interpreted the collected data and make comparisons with the planned activities.

• Checked for deviations or alterations.

• Complied and analyzed patient data and provided statistics of facility attendance and product usage.

• Cleansed and collected data on the case report form and submitted to the sponsor either electronically or paper format.

• Stored data in Microsoft Access created database.

• Paper cases stored and cleaned in Microsoft Excel Analytics Tablets.

• Scanned reports and patient EOB’s onto servers and convert to pdf file format. MasTech - Philadelphia, PA

May 2005 – Jan 2010

Data Analyst

• Discussed business intelligence needs with internal staff and external clients.

• Collected and collated appropriate data for use in databases and conducted related research.

• Generated reports using IT / database systems and assisted in their analysis.

• Assisted in marketing support roles, prepared and made presentations.

• Monitored and maintained the quality of database systems and secured access and use.

• Assisted in the upgrade and development of database and analytical techniques.

• Created and manipulated query database in Microsoft Access.

• Transferred and stored stats in created Excel analytical tablets. Quest Diagnostics - Norristown, PA

June 1999 – Feb 2005

Data Analyst

• Assessed, processed, coded, and tracked patient billings and reimbursements; captured and analyzed charges for inpatient and/or outpatient visits and procedures.

• Reviewed, edited, and posted to Excel spreadsheets accurately.

• Maintained knowledge base of correct coding practices and registration requirements.

• Updated fee schedules. Scheduled contractor appointments to review data and tests as prescribed using computerized scheduling system.

• Analyzed patients' demographics, insurance, pre-certification status, and referral information.

• Accurately compiled data for contracted insurance carriers. EDUCATION

• BA Business Management in Information Technology from Lincoln University in Lincoln University, PA - May 1999

Contact this candidate