Steven Bugge Email & Phone Number

● Technical Capabilities: Data Visualization · Dashboard Creation · Statistical Analysis · Metric Reporting · Customized Technical Trainings · Scripting Customized Computer Codes · Design and Revamp Tracking Tools · Data Forensics · Data Cleansing and Forecasting · Researching Legislative Compliance ● Client Portfolio: CitiBank (Tableau / Data Visualization) · Fitch Training (Excel / Statistics) · Teladoc (PowerQuery / Salesforce) · Deloitte (Excel / VBA) · Marriott (VBA) · New York State Attorney General’s Office (Federal Tax Compliance) · PraxAir (VBA / Excel) · U.S. Army (Financial Modeling / Excel) · Department of Defense (XML / Excel) · eConsulting Group (PowerBI / Tableau / Excel) · Department of Homeland Security / Lutheran Social Services of the National Capital Area (MS Access / Excel) · UCSD Extension (PowerBI / Excel / Business Intelligence) · SeniorQuote (Excel) · Evari GIS (VBA)· SynergyBIS (XML / Excel) · Chesapeake Hospitality (Human Resources / Compliance / Excel) · ESW Associates (PowerBI / Excel) · Cecelia Healthcare (Excel) · Ukulele Manufacturing Group (MS Project / Excel)

La Jolla, Ca, Us

Instructor - Business Intelligence with Advanced Microsoft Excel

Atlanta, Ga, Us

● Review legislative business-related tax requirements and automate ETL related tasks accordingly for reporting and analysis ● Designed K-Means cluster analysis tools to identify and recommended requirements for writing codes used to flag datapoints● Designed reporting methods and recommended new/update requirements gathering to enhance productivity● Script queries for extracting data from IRS systems via SQL & BOE. Data refined in Excel and results distributed accordingly● Aggregated and reported, Housing Finance Agency data for NIBP & TCLP bond programs: Single-family & Multi-family Loans● Aggregated and reported, National Public Pension Plan data, for all US Municipalities, review Annual Required Contributions, Pension Benefit, Obligations, Pension funding shortfalls etc. Create heat maps based on Census Bureau T.I.G.E.R. data files● ACCOMPLISHED – Improved efficiency of generating IRS notices with VBA code to self-populate, thus saving taxpayer dollars

Mclean, Va, Us

● Exercising agile methodology and waterfall methodology in daily production of PCR, IFM, and CCR.’s● Manage all Excel databases, aggregating overall production with analysis, research & reporting of overall department production● Analyze data of PCR inflow and processing activities; confirming bank regulations and c standards are upheld and/or addressed● Audit, update and create policy & procedure documents for utilization by both internal and external parties● Audit Visio & PowerPoint presentations created by team, coaching team members on presentation skills

Dallas, Tx, Us

● Created and taught companywide MS Excel classes; Beginner, Formula, Pivot Table, Chart/Graph classes. Total attendees 350 +● Managed $2 million+ weekly billing, utilizing APeX, PeopleSoft, PeopleClick, Excel for internal & external vendors/customers● PowerPoint presentations to senior management on detailed maps of travel nurse industry using ArcGIS technology● ACCOMPLISHED - (Percent of Production Calculator) Invented interactive calculator that considers numerous variables to determine correct billing. Now used by numerous departments. Saving 15 minutes per invoice

● Generated reports from ‘Anasazi’ medical software used for billing, auditing, analyzing service trends● Audited all medical charts for proper billing. Found and reconciled over $10,000.00 in missed / incorrect billing● Developed customized Likert scale surveys for clients, results to be reviewed with clinicians for improved services● ACCOMPLISHED - Designed and created MS Excel databases and dashboards for management, analysis, and reporting purposes

San Diego, Ca, Us

● Trained employees on Excel and Anasazi Medical Billing software. Provided database management creation & support● Analyzed budgets and reconciled them with reports from other departments. Utility, leasing, maintenance costs etc.● Aggregated data from 32 satellite sites used to generate company’s key monthly ‘Scope Report’ showing YTD productivity● Exercising Agile Methodology extracting data from Anasazi Software to generate important reports such as ‘Scope Report’

● Reconciled invoices with purchase orders, updating GP MATE inventory computer software● All A/P was reviewed with 3/Way reconciliation. Information was organized before being presented to office manager● Created and distributed instructional training manuals to colleagues. Prepped conference room for staff training

Selden, New York, Us

• Lead Tutor in Accounting, Business, Business Math, Economics, Microsoft Office, Computer Technology.• Collaborated with all tutors and students for the best scheduling and subject match.• Treasurer for the “Student Business & Accounting Club”, which is an important prerequisite of the Lead Accounting Tutor position.

Certificate In Business Intelligence, Business Intelligence

Associate'S Degree, Economics

Business Administration And Management, General

Certificate, Geographic Information Systems

Geographic Information Science And Cartography

Accounting

International Business