Summary
Overview
Work History
Education
Skills
Timeline
Hi, I’m

Steven Sawyer

Euless,TX
Steven Sawyer

Summary

Analytical Business System Analyst with 20 years of experience building business strategy and developing creative plans for financial and operational success. Well versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities.

Overview

20
years of professional experience

Work History

Septuagint Solutions/QML Taxi
New York, NY

Business Analyst Consultant
05.2020 - Current

Job overview

  • Oversaw NetSuite implementation, assisted with implementations for JustCall (VOIP), Front (CRM), Salesforce, Tableau, Snowflake, Snaplogic
  • Developed metrics used to determine inefficiencies and areas for improvement.
  • Created and executed marketing and PR campaigns for new product introductions and existing product development.
  • Managed projects and served as primary liaison between client and multiple internal groups to clarify goals and meet standards and deadlines.
  • Redesigned processes to maximize benefits and quantifiable improvement in business metrics and illustrate roadmaps to future projects.
  • Collaborated with stakeholders to define features, integrations and partnerships.
  • Developed innovative, fact-based and achievable strategies and operating models based on evaluations.
  • Defined key data points and data sources to track against measurable performance indicators and produce useful reports.
  • Performed statistical data analysis to inform customer groups.
  • Remained current on latest IT developments and advancements to automate and modernize systems.
  • Surfaced insights and findings to support business and technical decisions.

ROJO Endeavors Inc.
Euless, Texas

Owner/Data Integration Specialist
08.2016 - Current

Job overview

ROJO Endeavors Inc, is a business intelligence consulting company.

We work with our clients to extract useful information from the numerous system reports they have access to.

ROJO is also able to assist in researching and guidance for new software/app purchases, whether they are marketing, sales, inventory, POS, and financial software as well.

Operational experience in installations and conversions for:
Salesforce
NetSuite ERP
Quickbooks Online-Full
Quickbooks Enterprise
Pipedrive-Sales/Marketing
ADP-Payroll
Oracle Financials-Including Perpetual Inventories from raw materials
InfoGenesis-POS/Inventory Management
OracleMicros POS

Snaplogic

Muelsoft

Google Analytics

Facebook Advertising

  • Increased team productivity and automated repetitive tasks with batch files, PowerShell and VBScript.
  • Created online documentation to help employees resolve day-to-day issues.
  • Conducted basic troubleshooting to isolate and diagnose common system problems.
  • Adhered to company, contract and regulatory requirements when performing data management activities.
  • Performed data analysis using statistical programs and generated reports for review.
  • Prepared materials to complete transactions and underpin successful deals.
  • Created detailed technical reports highlighting findings to diverse stakeholders.
  • Informed investment decisions by analyzing financial information to forecast business, industry or economic conditions.
  • Interpreted data on price and yield future investment-risk trends, economic influences and other factors affecting investment programs.

Crosslake Technologies
Charlotte, NC

Enterprise Systems Business Analyst
05.2022 - 02.2023

Job overview

  • Main POC for NetSuite, OpenAir, Salesforce, PowerBI, MuleSoft
  • Oversaw MuleSoft integration with Salesforce, OpenAir, NetSuite, Inhouse Bespoke SQL Database
  • Managed team of 3 Project Coordinators/Managers
  • Consulted users to determine areas in need of improvement.
  • Submitted recommendations regarding infrastructure overhauls.
  • Analyzed financial data to identify trends, patterns and strategies.
  • Summarized financial information to clearly relay concepts and drive understanding of non-financial leaders.
  • Supported projects and analyses to drive consistency and accuracy within financial models.
  • Determined and devised CSAT survey collection, research techniques and data interpretation for analysis purposes.
  • Created financial models to assess opportunities for profitabilty.
  • Administered and maintained data to facilitate tracking and trending analysis.
  • Developed business metrics and reporting processes to align with company strategy.
  • Conducted audits and reported findings to facilitate research and resolution.

Frontier Payments
New York, NY

Business Data Analyst
11.2016 - 11.2020

Job overview

  • Developed process improvements and troubleshot database issues.
  • Maintained data integrity and performed routine data audits.
  • Examined financial statements and income statements to review company's financial performance.
  • Collected and assembled financial data to analyze costs on year-to-year basis relative to fiscal planning and budgeting activities.

Newtek Business Services Inc.
Little Neck, NY

Business Intelligence Data Analyst
04.2019 - 01.2020

Job overview

  • Analyzed business requirements into technical requirements for reporting and visualizations, data models and databases.
  • Assisted development teams with analysis and design for new or existing systems.
  • Conducted trend evaluation and forecasting.
  • Analyzed marketing information and translated it into strategic plans for store operations.
  • Created media campaigns and analytics reports to inform account managers.

Deloitte University (Benchmark Hospitality Int)
Westlake, Texas

Director of Purchasing
05.2011 - 08.2016

Job overview

Created Purchasing Department from ground up in Pre-Opening

Managed 2 Salaried employees with a team of 15 hourly employees

Roll out of Inventory Management System (Responsible for $20 MM in purchases yearly)

Implementation of POS, Purchasing, Accounting, and Labor Systems (Sourcing and Implementation), Recipe costing

Forecasting and Budgeting of all Restaurants, Banquets, and Capital Expenses

Labor Analytics for Food and Beverage Division along with Retail Division

Weekly, Monthly, Quarterly Vendor Business Reviews

Monthly Revenue and Cost Analysis for Food and Beverage as well as Retail Division

Generated over $500K in savings annually by data driven reports and vendor business reviews/negotiations

Gaylord Texan Resort & Convention Center
Grapevine, Texas

Cost Control Manager
02.2004 - 02.2011

Job overview

Responsible for Cost Control for: Retail Outlets, Restaurants, Banquets and Convention Services, Relache Spa, Engineering, House Keeping, Public Space - Restaurant revenues totaling 55 million & retail revenues totaling 2.5 million

New Gift Card Program-Increased Gift Card sales by $100k annually.

Automatic In-House Charges Program resulting in an overall savings of $200k annually

Established new comprehensive report "F&B Cost Report" for managing purchases and assisting in reducing F&B cost by 2% or $600k annually

Main liaison for entire resort for cost control, POS, Corporate Reporting for F&B and liaison between outside vendors and purchasing department of Gaylord Texan Resort

Resort Admin for: POS, Oracle Purchasing System, Labor System,

Education

Tarrant County College District
Fort Worth, TX

from Hotel Restaurant Management

University Overview

Skills

  • System Diagnostics/System Administration/Technical Liasion
  • NetSuite Implementation
  • Infrastructure Architecture
  • Data Modeling
  • API Creation/Maintenance
  • Data Administration
  • Project Planning/Execution
  • Forecasting/Budgeting
  • Data Analysis
  • Technical Liaison
  • Data mining
  • Product management
  • Long Range Planning
  • Marketing/Revenue Management
  • Payment Processing Analysis
  • Snowflake
  • PowerBI/Tableau
  • Snaplogic/Mulesoft
  • Financial strategy management
  • Logistics coordination
  • Inventory coordination
  • Building Materials/Manufacturing Supply Chain
  • Price negotiations
  • Risk management
  • Sarbanes-Oxley regulations
  • GAAP guidelines
  • Account reconciliation expert

Timeline

Enterprise Systems Business Analyst
Crosslake Technologies
05.2022 - 02.2023
Business Analyst Consultant
Septuagint Solutions/QML Taxi
05.2020 - Current
Business Intelligence Data Analyst
Newtek Business Services Inc.
04.2019 - 01.2020
Business Data Analyst
Frontier Payments
11.2016 - 11.2020
Owner/Data Integration Specialist
ROJO Endeavors Inc.
08.2016 - Current
Director of Purchasing
Deloitte University (Benchmark Hospitality Int)
05.2011 - 08.2016
Cost Control Manager
Gaylord Texan Resort & Convention Center
02.2004 - 02.2011
Tarrant County College District
from Hotel Restaurant Management
Steven Sawyer