OBJECTIVE:

• Seeking a technical position at a dynamic company where I can utilize my extensive analytical and communication skills where I can contribute successfully to all levels of management within the company.

TECHNICAL SKILLS:

Skills: SQL Server, SQL, MS Windows, MS Office, SQL Analyzer/Profiler, Citrix, TCP/IP, NetSuite, Magic, Word Perfect, Peach Tree, Great Plains Dynamics, Qualcomm, PcMiler, Rand McNally, POS Systems, Aloha, CISCO, Oracle, Visual Studio, TFS

PROFESSIONAL EXPERIENCE:

Confidential

Data - Business Systems Anaylst

Responsibilities:

• Communicated deliverables, project status and testing timelines to Directors and Business Units as well as the development team Gathered and documented business requirements from clients and communicated to development team Created Ad-Hoc Reports Documented user stories Wrote the process for change control and implented throughout development utilizing Visual Studio 2017 and TFS Heavy database analyzing to ensure data integrity Made recommendations on where to improve in daily business by analyzing various reports looking for trends Identified areas throughout the new software to increase efficiency and automation of processes using tools to automate processes where needed Managed Core Team to ensure timelines were met and communicated all issues to development and tracked progress to ensure timelines were met Heavily involved in ETL testing to ensure data matched the data warehouse and reported any load issues Heavily involved in EDI REGRESSION TESTING
• Created various user windows and processes for EDI-documented and trained end users on functionality
• Documented mapping of events for EDI client Reporting for the new data warehouse Trained end users on the converted software for go-live Assisted in Great Plains conversion Wrote sql queries to ensure data integrity Manipulated data using sql Testing and QA responsibilities to solve bug issues SQL Queries and management reporting Communicated bug fixes and program enhancements between developers and end users Gathered required documentation needed for change management Wrote all documentation for users and development Defined new processes and enhanced current processes Worked closely with data conversion team to identify potential issues

Confidential

Business Systems Analyst

Responsibilities:

• Wrote sql queries to ensure data integrity
• Manipulated data using sql
• Testing and QA responsibilities to solve bug issues
• SQL Queries and management reporting
• Communicated bug fixes and program enhancements between developers and end users
• Gathered required documentation needed for change management
• Wrote all documentation for users and development
• Maintain mileage database using PcMiler and Rand McNally
• Maintain vehicle specifications
• Route and Support dispatch issues
• Support Great Plains for the Accounting Department
• Resolve software issues with their TMW Software System
• Train dispatchers on proper use of dispatch system
• Troubleshoot and resolve billing and driver settlements
• Maintained rates for both billing and settlements

Confidential

System Administrator

Responsibilities:

• Manipulated data using sql
• Wrote reports as needed using sql
• Served as the main contact point for required documentation
• Tested and documented all enhancement and bug fixes
• Gathered all required documentation needed for both testing and development
• Responsible for supporting Great Plains Regionally-including setup and
• Hardware and Software testing
• Maintain and create documentation
• Maintain Active Directory
• Setup Email Accounts
• Troubleshoot and solve Network and software issues
• Route and escalate Help Desk tickets
• Install necessary software and hardware for PC's and laptops
• Setup and trouble shoot mobile devices, including iPhone, iPads and all Android devices
• Trouble shoot and configure all PC's and laptops
• Managed and created all documentation involving resolving software and hardware issues
• Maintain and issue all passwords and setup users on DNS
• Maintain and update all licensing keys
• Responsible for ordering all hardware and software for the region
• Monitor daily and weekend backups and resolve any issues or errors that arise

Confidential

Database Developer Analyst

Responsibilities:

• Used Active Directory and VPN
• Installed various network printers remotely
• Developed and created SQL Automated jobs through SQL, and proficient in SSIS, streamlined processes according to business needs.
• Monitored all daily and nightly jobs and troubleshoot any errors to ensure all processes completed.
• Developed new processes- to effectively streamline daily business practices.
• Managed and analyzed all Databases to seek out any potential issues.

Confidential, Westlake, Ohio

Tier I and II Technical Support

Responsibilities:

• Installed Printers remotely used VPN and Active Directory
• Responsible for ensuring a down site was up and running quickly to continue business as usual.
• Utilized and maintained Sharepoint, helped convert all data to Sharepoint.
• Extensive trouble shooting and monitoring of Batch Processing jobs.
• Solved all issues reported and reported possible flaws in the Batch Processing system.
• Supported over 200 sites all Hardware and Software issues on both Linux and Sql Platforms.
• Supported ALOHA System and all POS IBM Registers as well as software.
• Supported all communication and server related issues remotely using FTP, and filezilla when needed.
• On call 24/7 support working from home via laptop with remote connection to the server
• Ensuring all Gas and Diesel pumps were up and running fully as all sites were open 24 hours.
• Onsite and offsite installations as required by site needs

Confidential, Beachwood, Ohio

Tier II Technical Support

Responsibilities:

• Managed individuals to be sure they were utilizing time efficiently.
• Created and ran monthly and daily productivity reports.
• Mapped implemented support procedures from the initial call, through final delivery to the customer.
• Solving support issues for suite of Power Builder SQL Server (ERP) applications
• Application include invoicing, settlements, dispatching, & asset planning
• Solve bug/enhancement issues for 500+ clients
• Responsible for solving support issues for 3rd party add-on software applications including the following:
• Great Plains Accounting System PCMiler Mileage and Mapping System PeachTree Accounting system ALK Mileage and Mapping System EFS Fuel Management System IAI Food Brokerage Management System Comdata Fuel Management System
• Supported both clients and end users
• Typically closed 30+ calls per day, working multiple calls at once
• Monitored Batch Proceeses and solved any issues found when a job failed.
• Trained junior support staff on all aspects of the Trucking software, to include setup, and installation including third party packages
• Workflow process from a test environment to a live environment of new clients
• Facilitated test environment for both the company and the client
• Manually tested bugs throughout the entire software package
• Interacted with upper management to ensure needs of clients were met
• Received and submitted requests from the advisory board to development and QA
• Utilized Net Suite Call Tracking System
• Logged calls and solutions with extensive detail to provide a database for customers to access online

Confidential, Independence, Ohio

Technical Support/Trainer

Responsibilities:

• Supported and trained clients on Food Brokerage software, started with UNIX and helped implement their new software on SQL platform.
• Responsible for solving complex issues with software and hardware, worked closely with QA to solve bug issues and also communicated enhancements to the software according to client specifications.
• Responsible for solving issues between the software as well as third party software packages including report writing through access, and accounting software.
• Traveled to client sites to help solve complex issues to the bigger client base, dealt with Presidents and VP’s of most of their clients.

Confidential, Maple Hts., Ohio

Marketing Assistant, Perishables

Responsibilities:

• Assisted Marketing director in creating weekly advertisements, proof read all ads before submittal to printer.
• Managed and entered weekly price changes to all stores.
• Worked directly with the Director of Advertising to ensure all ads were submitted in time and no changes were necessary.

Office Manager

Confidential, Macedonia,Ohio

Responsibilities:

• Payroll, Financial Reporting, AR/AP using Great Plains Dynamics, Peachtree, and Quickbooks. tax reporting preparation including filing taxes, and experience in bank financing including the application process, tracking down liens, removal of liens and any duty needed to get the customer financed through various financial institutions. Set up most environments from ground level.
• Experience in trouble shooting the software as well as being an everyday user.