MAURICE MORDECAI

*** ****** ******** ***** ~ Canton, GA 30115 ~ 678-***-**** ~ad24ks@r.postjobfree.com

Qualifications for

DATA ANALYST/BUSINESS ANALYST

PROFILE

An accomplished professional with 20 years’ experience in the Information Technology field. A self-motivated

business professional with a history of excelling in multi-tasked positions within fast-paced environments.

COMPUTER SKILLS

Tableau

Salesforce

MS PowerPoint 2019

MS Access 2019

Microsoft Excel 2019

Power BI

Google Analytics

Visual Studio 2008

SQL Server 2008

SharePoint 2019

PROFESSIONAL HISTORY

VIVA USA - (Baxter International) Atlanta, GA

Sales Operations Data Analyst Sept 2022 – Jan 2024

Create weekly/monthly reports to reconcile various historical reports for each hospital.

Import and query data within Cognos to retrieve the recent work order status from field techs.

Consolidate data from various sources to analyze and communicate metrics to several stakeholders.

Collaborate with service teams to manage information portal content and drive requirements for enhancements.

Accumulate and summarize large data sets from various spreadsheets using vlookup, pivot tables, and linking cells.

Create, revise, and query large data sets from Tableau into MS Excel to present metrics on medical devices status.

ROSE INTERNATIONAL – (Mastercard) Atlanta, GA

Business Analyst Aug 2022 – Dec 2022

Documented and consolidated customer contractual terms and pricing change notifications.

Recommended to Regional teams and/or Account teams on contracts that should be updated.

Audited 1000’s of contract and made sure each client was being charged the correct fees and annual charges.

Recommended to Regional teams and/or Account teams on contracts that should be updated.

Accumulated financial revenue data per customer on each service provided and ran GAP analysis vs previous months.

Created, revised, and queried large data sets from Tableau into MS Excel to present metrics on medical devices status.

Lumens Atlanta, GA

Sales Lead Data Analyst Oct 2020 – May 2022

Pulled customer information from SAP to verify correctness and forward the information to Sales Account Manager.

Collected lead data and input all attributes and field data into Salesforce and delegate leads to appropriate Sales AM.

Append weekly and monthly data into Excel and create monthly charts and produce trendlines to show progress.

Accumulated financial revenue data per customer on each service provided and ran GAP analysis vs previous months.

Prepared and audited large data sets for duplicates using various excel formulas, macros, and pivot tables

Created and updated Power BI dashboards for Account Managers showing key metrics and Sales per Month per Region.

Inserted multiple crosstabs in Excel with data from multiple sources, added info fields with information on the

data sources and filter status using SAP Analysis for MS Office.

PYRAMID CONSULTING - (UPS Corporate Headquarters) Roswell, GA

Sales Operations Data Analyst Mar 2017 – Aug 2020

Updated PowerPoint presentation decks containing monthly Sales and Cost.

Updated weekly and monthly ad hoc reports for Directors and the Senior VPs.

Managed and Governed SharePoint sites, files, folders, and updated data sources.

Compiled financial cost data and ran analysis reports on the cost data vs quarterly budget.

Prepared meetings and schedules for executives from the Enterprise Account groups to meet with top UPS leadership.

Created, revised, and updated Tableau dashboards for individual users showing sales metrics and KPI’s.

Collected Enterprise Account data from Salesforce and inform Account Executives on expiring contracts.

Modified SQL scripts to collect and compile financial services and budgets of various Enterprise accounts.

Updated data tables in Access and created queries to give updates on performance metrics on each enterprise account.

Accumulated and summarized large data sets from various spreadsheets using vlookup, pivot tables, and linking cells.

MAURICE MORDECAI

611 Hidden Branches Trail ~ Canton, GA 30115 ~ 678-***-****

TEKSYSTEMS - (CDC/Northrop Grumman) Decatur, GA

SharePoint Governance Administrator May 2016 – Nov 2016

Reviewed data for completeness and accuracy and developed reports for internal CDC use.

Uploaded data from SharePoint into Excel to update operational reports for senior management.

Designed and implemented new reports / dashboards to meet changing business requirements.

Governed classified files and sites that have restricted access and granted access to individuals that were approved.

Gathered submissions from Ebola site visits and updated the requirements needed to get Hospitals Ebola compliant.

DELL SECUREWORKS Dunwoody, GA

Sales Reporting Analyst / Customer Master Data Nov 2015 – Mar 2016

Updated customer profiles in Database by researching information on Dun & Bradstreet and Zoominfo.

Pulled reports for clients from SAP and exported the data tables into Excel using Winshuttle and SAP BODS.

Created MS Access databases to compile and organize data into tables to produce various forms and reports.

Cleansed prospect data of duplicates and invalid data and identified data integrity and quality issues in Salesforce.

Worked on data migration from databases to SFDC using Data Loader to extract and load data from (CSV) files.

Imported monthly excel reports into Tableau Workbooks and Dashboards to perform YTD, QTD and MTD analysis.

Administrated and monitored the department’s Salesforce CRM application by creating profiles, roles based on organizational role hierarchy, and implemented record-level and field-level security.

CADILLAC JACK Duluth, GA

Data Analyst/Project Manager Aug 2005 – Sep 2015

Managed SharePoint access within the project management and marketing department.

Tracked, compiled, and forecasted revenue numbers and presented data to Sr. Financial Analyst.

Created macros to compile data and produce various pivot tables, charts, heat maps, and reports.

Recommended promotional insights to Marketing Department for newly released products and oversee product performance before and after promotions.

Imported and compiled data from ODBC sources into MS Access and Excel to produce various reports.

Created and modified SQL scripts to collect data from Servers at various casinos for performance analysis.

Collaborated with field personnel of how many replacement parts needed each week per location and forecast how many parts needed to keep inventory at an acceptable level.

Planned and executed monthly audits of revenue collected and verified for accuracy of each invoice per customer.

Analyzed product performance data and made recommendations to improve product performance over 70 Casinos locations in Mexico and the US.

COCA-COLA BOTTLER'S ASSOCIATION Atlanta, GA

Database Analyst / Web Page Design Feb 1998 – Jun 2005

Designed, revised, and updated the company's web page site using HTML and FrontPage 2000.

Remotely administered files and user security using Microsoft Access.

Created and maintained databases, forms, tables, queries, and reports for a variety of projects.

UNITED STATES MARINES Oahu, HI

Base Communications Analyst Nov 1990 - Nov 1995

Inventoried and tracked all communication equipment such as pagers, phones, and cellphones.

Tracked all cellphone and long-distance usage for the entire Marine Corp base at Kaneohe Bay, HI.

Provided voicemail, PBX support and maintained efficient communication for more than 2,000 individuals.

Analyzed expenses for each battalion per month and notified Commanding Officers of any questionable charges.

Analyzed and modified communication expenses, resulting in savings of $250,000 per year.

EDUCATION AND CERTIFICATIONS

Hawaii Pacific University Kaneohe Bay, HI

1993 - 1994

Sheffield State University Sheffield, OH

Bachelor of Science 2014-2016

Major: Information Technology

Contact this candidate