Steven Rappaport

Process Improvement Engineer

Excel Application Programmer, VBA

Professional

Data Analyst

Report Writer / Creator

Education:

DeVry University, Irving, Texas -- Major: Telecommunications Mgmt.

Johnson & Wales University, Virginia Beach, Virginia -- Major: Culinary Arts

Christopher Newport University, Newport News, Virginia -- Major: Management

Computer Applications:

MS Excel (Super User, see note at bottom of document)

MS Access (Advanced) – Publishing forms to Internet for data collection and dynamic

reporting. Integration with Access, Excel and Outlook. Creation of web pages.

MS Word (advanced) – Mail Merge for both print and email use. Integration with

Access, Excel and Outlook.

Google Sheets, SQL, JavaScript (Apps Script), MS PowerPoint, MS Visio, Microsoft

Query, MS Macros (Power User), Aspect, SAP, Big Query, Double Helix, Fiserv,

DebtMaster (collections software system), Jiva (patient records) and MEDai (medical

predictive software – an SAP service)

Programming Languages: Visual Basic for Applications, HTML-5, Angular JS,

JavaScript (App Script), SQL

Experience:

2014-2015 – Telecom Data Analyst

Google Contractor

Data Design Team, Large Scale Design Team, Operation Clean Sweep

• Dashboards for DDT Team

o Helped debug new software for mass release

o Process and procedures used company-wide

• BI operations using Pipewrench, #PLX and Google Dashboards

• Process documents

• Meetings with engineers and network designers around the globe

• Created custom queries from Big Query using SQL

• Working with datasets of over 5 Million Records

o Cleansed data using formulas and VBA

o Parsed information for executive level reporting

• Created Double Helix ready CSV files from unordered / unsorted information

through automatic processes (VBA)

• Participated in meetings regarding the redesign of Google Backbone as well as

upgrades and naming convention changes

• Cleaned Databases and correcting Fallouts

• Apps Script Utilities, Web Apps and Dashboards

2014 Caliber Home Loans – IT Analyst III

Contractor 60-Day Contract

• The creation or editing of form letters for this very large mortgage company.

o Mail Merge with Calculations

o Coordinating offsite printing with three companies

• Creation of a tool to validate data for client update into Fiserv

o Adjusting field length to maximum requested size

o Changing date formats

o Ensuring leading or following blank spaces

• The auditing of 1,056 scripts using:

o Fiserv & SharePoint

• Collecting of antiquated data for regulators

2014 McKesson Contractor

120-Day Contractor

• In three months, saved the company over $100,000 in staffing (2.25 FTE x

$40,000, as per internal numbers) through Process Improvement and

Automation!

• Designed an online database to collect schedule requests using MS Access

o Resides on internal Web Server for all employee use

o Single User and File Upload for entering data

o Easy reporting and Export for Upload into SAP

• Designed a system to report on new client’s calls into the Help Desk

• Automated AutoShip Process:

o Collects emails from Account Reps

o Process data by Distribution Center

o Goes Online to check Distribution Center Inventory

o Creates Formatted Uploads for SAP

o Sends emails to all relevant parties

• Created Email Analysis Tool:

o Pull all emails out of every Email Box / Folder

Analyze by Month, Chain Length, Flagged Agent, Sender, First Response

o

Interval and Total Volume

o Numeric and Graphical Reporting *See Figure 1

o Built-In Error Checking

• Automated Business Effectiveness Dashboard:

o Imported data from 3 sources – Automated Custom SQL Query

o Updated data for 5 groups

o Built-In Error Checking

o Customized Reporting *See Figure 2

Speedometer Charts (custom designed)

Daily, Monthly & Yearly Reporting

• Manager Reporting

o Created Team Expense Reports

o Automated productivity data

o Productivity Norms for Director level reporting

• Client Ordering Analysis ($100mil company)

o Analyzed orders in three month increments

o Reported on order statistics based on requested criteria

Sorted by Location, NDC# & Month

Identified items ordered only in last of three month cycle (not in

previous two months)

• Assisted many with Excel Formula creation

• AdHoc Reporting

2012 -2014 HealthSmart Holdings

Predictive Modeling

• Importing data from various sources and converting to standard protocols for

upload

• Deeper Dives for client company trends

Operations Supervisor

• Managed the patient population/enrollment of the Disease Management

Department (55,000 patients across 86 groups)

• Reported on a daily, monthly, weekly, quarterly and yearly basis for all levels of

management

• CQI reporting and department audits

• AdHoc reporting and statistical analysis for UL Management.

• Analyzed data for trends (found a process error that saved the company

$5,000/month)

• Created and generated reports for several department heads.

• Managed the data for the company wide Healthy-15 Challenge (525 participants)

with emails to three different group levels

• Training of five Nurses and three Nutritionists for department and company policy

• HIPA and PHA trained.

2009 - 2012 RaceTrac Petroleum

Analytics

• Used Microsoft Excel, Microsoft Query and elaborate custom imbedded functions

(using Excel macros) I access 85 data sources to create regular reports for all

levels of management regarding store:

o Overall sales as well as Department sales

o Operation “Hot Points” including: margin, labor and inventory

o Analyze segment performance for year over year and quarter over

quarter; and compare Store vs Store within individual areas as well as

Area vs Area analysis

• Mentored / Led team of four in Excel/Database usage and best practices.

• Designed tools for store level reporting, being used by the entire D/FW Region.

• Composed yearly forecasts for all stores in the D/FW Region using custom

algorithms to predict future trends based on historical data and company goals

• Analyzed how actual performance tracks to the forecasted goal

• Managed the Region's Database. Ensure backups, access controls (security)

and data integrity are maintained

• Used Excel I automatically pull data from company websites, sort, analyze and

email reports to stores

• Practiced CQI (Continuous Quality Improvement)

2009 Mobile Services, Inc.

Sales Manager

Email Marketing: I maintained an automated MS Excel based email marketing

program which I designed using Visual Basic for Excel.

News Letter: Based on customer information I sent out targeted newsletters

customized with customer (and potential customer) demographic information - all

from Excel.

Cold Calling: Performed targeted phone calls using industry research to generate

new leads and business potential.

Close Rate: Maintained an 80% close rate for meetings scheduled.

2008 - 2009 RiverWalk Holdings

Analytics Department

Analysis: Using Microsoft Excel I prepared weekly, monthly and quarterly reports

for department heads, the Vice President, the Owners, investors and financial

institutions regarding the remittance from 50 collection agencies for accounts

owned by the company. I tracked over $500 million dollars of investment

monies for placement activity and liquidity

Development: Made tools (both auto-launching and user- initiated) for other

departments to enhance their reporting ease and accuracy as well as

customizing them to meet specific needs and changes in business

Training: Trained department heads on how to use both my tools as well as other

network resources and software/hardware utilities. Additionally I mentored

Department Heads on how to train their subordinates in their use

Email Campaign: Created & manage two large customized email campaigns

based in Microsoft Excel using Excel Visual Basic for collection agency

remittance on weekly and monthly basis

Automation: Used Microsoft Office (specifically Excel) I automated “often

repeated” functions for all areas of the office saving approximately 80 hours

per week man-hours

Account Manager: Managed the placements and activities for $2 billion (face) of

portfolio debt for liquidity and agency activity for accounts we place with other

companies (Third-Party Collections) through large batch import/exports using

Excel and Microsoft Query

Other: Inputted and tracked all Settlement Requests, Direct Pays, Borrowing

Base & Amortization on Debt Statistics, Schematics and any other analytic or

procedural issues for the company

2002 - 2007 Sonny Bryan’s Smokehouse

Assistant to CFO / General Manager, Trainer

P&L: Design of completely new P&L for this 12 store company. Using Microsoft

Excel to track sales, taxes, discounts, invoices, budgets and forecasting, sales

mix ratios, labor and cash accountability as well as daily and weekly reporting

to company through auto-generated emails

Catering Database: Used Microsoft Access for all inclusive catering databases.

SQL and Visual Basic with extensive multi-level queries produced customer

tracking, production sheets and invoices with Access Reports, automatic email

notification with Microsoft Outlook and scheduling using Microsoft Outlook

Spreadsheet Tools: Creation of an Excel spreadsheet to assist in ordering and

maintaining proper inventory levels through the use of par levels determined

by examining historical inventory information and historical data. Also creation

of standard inventory spreadsheets for the entire company.

Company Trainer: Went through Micros POS training to maintain registers,

internet connectivity and technical issues for entire company. Presented

training seminars for up to 75 people using PowerPoint and hand-outs for new

technological issues.

1999 - 2001 WorldCom

Broadband Circuit Design Engineer

• Programmed long distance circuits for client offices on long-distance fiber (DS3

to OC12)

• Maintained and issued regular/incremental improvements to Microsoft Access

multi-team/department database for issuing work assignments and monitoring

progress

• Created network availability database in Microsoft Access used across a Wide

Area Network

• Wrote Visual Basic scripts to communicate with the mainframe for visual

representations of the MCI Long Distance Backbone Network for optimization

purposes

Excel Super User. Perform single & multi-conditional counting and summing, advanced

look ups (Vlookup/HLookup) as well as the more dynamic Index/Match function-

combination and Pivot Tables. The programmatic creation of dynamic ranges that

adjust automatically for growing/shrinking data sets. Integration with Outlook (Email &

Scheduling), PowerPoint (presentations) and Word (Mail Merge).

MACRO and VBA programming for elaborate automated functions & Windows File

manipulation and SQL for hardcore Data Mining.

Contact this candidate