Experienced Data Analyst with a demonstrated history of working in the information technology and services industry. Skilled in Analysis, Intelligence, Operational Planning, VBA and Power Bi. Strong information technology professional with a Master of Business Administration (MBA) focused in Information Systems Security from Colorado Technical University as well as a Bachelors of Science focused on Software Engineering also from Colorado Technical University.
-
Data AnalystPerformance Review Institute (Pri) Dec 2022 - May 2023 -
Senior Data AnalystSodexo | Roth Oct 2022 - Dec 2022Youngstown, Ohio, United States -
Data AnalystSodexo | Roth Sep 2019 - Oct 2022Youngstown, Ohio, United States• Collecting data from multiple company data services on a daily basis in order to design data collection techniques that are bringing efficiency to the company including: Conduct quality checks of data and data systems to ensure accuracy in reports.• Using Power Bi software to organize and analyze large volumes of data and present the data in meaningful ways to include: Identifying trends and anomalies in data to assist business members in decision making. Working with team members to outline the specific data needs for Quarterly Board Reviews (QBR) and special client requests based on SLA’s/KPI’s. Preparing various statistical reports on operational performance on monthly, quarterly and annual basis. Interfacing with the various work streams to ensure business strategy. -
Sr Problem AnalystProgressive Insurance Nov 2017 - Oct 2018Mayfield Heights Ohio• Support multiple divisions in tracking software issues from problem detection, to fix, to avoidance. • Using BMC Remedy to analyze data/charts to identify trends or errors. • Querying data to produce reports with graphs, charts, and supporting description of the information analyzed.• Grouping Remedy data in recurring reports as well as performing ad hoc requests to include Importing the data into Excel to create charts from tables/pivots.• Improving existing reports to automate, reduce prep time, and provide more actionable information.o Automating the reporting process using VBA in Excel thus improving speed and accuracy. Reports that took 8 hours to generate now take 15 minutes. • Automating the SharePoint site to sync with data from Remedy regarding tickets. Previously, tickets were updated on the SharePoint site manually and not reflective of data contained in Remedy.• Organized team meetings to discuss how the product was identified, what could be done in the future to prevent it from happening again, and what is the status of the ticket daily. Managed teams to provide access to information and other teams as necessary. -
Network EngineerMicro Doctor It Apr 2017 - Sep 2017Warren, Ohio• Supported 150 small business customers via inbound technical support calls and inbound email tickets.• Regularly performed hardware and software maintenance of client systems.• Provided helpdesk support to end-users through remote applications such as Team Viewer and Continuum.• Documented all issues in ConnectWise ticketing system and generate reports detailing problems and resolutions.• Provided support for client SonicWall devices including updating and installation.• Installed new desktop systems, servers, routing cable, connecting intercoms and troubleshooting of security camera systems.• Assisted clients with installation of off the shelf software including QuickBooks. Aided in setup and troubleshooting. -
Ecommerce Data AnalystParker Hannifin Aug 2016 - Feb 2017• Compiled and generated spreadsheets capturing key data related to company’s active inventory.• Utilized advanced functions of MS Excel to analyze 80,000 attributes associated with over 400,000 products to determine most common instances to each product for use on website. Resulted in a narrowing down to 875 useful attributes. Evaluated the values of product attributes to remove any redundancy. • Compared results against competitors’ known attributes for same or similar products and recommended use of attributes more common in market but less common to our products. Further recommended that those products not bearing less common suggested attributes be updated to reflect them. • Identified missing data links and strategically recreated them by researching data in provided spreadsheets.• Used pivot tables to achieve analytical goals.• Designed macros to automate data entry inputs as well as to run reports. • Utilized OpenText CMS to create, edit, and merge various corporate web pages.• Managed a project involving the merger of 19 Parker division web presences into 7. Task involved creation of entirely new home pages, merger of division product portfolio and web pages, and merger of divisional online support documents including redirects of old links that become broken due to being relocated.• Trained and assisted others in the ongoing maintenance of the newly created Parker division pages. -
Data Recovery AnalystDeutsche Bank Aug 2014 - Oct 2015Jacksonville, Florida Area• Conducted computer forensic investigations, data recovery, and electronic discovery of documents, photos and e-mails on computer hard drives and other data storage devices• Retrieved data from various archives to present for legal, audit and compliance cases. • Utilized various proprietary tools based on SQL queries to search databases for custodian information.• Analyzed data and evaluated its relevance to the case under investigation.• Coordinated searches between various global teams in order present a complete unified search result to the client. • Ensured accuracy of gathered results as well as integrity of gathered information ensuring that only the requestor sees the final data and that that data is transferred securely in a format suitable for legal purposes.• Maintained complete caseloads between 20 and 200 custodians requiring between 80 and 1600 database searches. • Supported the project manager by communicating the progress and any issues of all assignments. -
Support SpecialistEnhanced Recovery Company, Llc Mar 2013 - Mar 2014• Responsible for creating SQL queries that verify created documents match data contained in database. • Operated tools like SQL Server Integration Services (SSIS), Excel, and CSV.• Executed stored procedures to extract report from and to SQL Server Database.• Generated, diagnosed and maintained accuracy of daily, weekly and monthly reports.• Preparing small computer software using MS Excel for various departments.• Install and configure PC’s and equipment in a Microsoft Windows environment. • Validate monitoring alerts, create support tickets as required and execute predefined troubleshooting procedures -
Quality Assurance AnalystSaft Mar 2012 - Feb 2013Jacksonville, Florida Area• Inspected and screened results of all reporting entities, outlined and modified data for accuracy.• Evaluated and formulated reports using SQL queries.• Operated tools like SQL and Excel.• Executed stored procedures to extract report from and to SQL Server Database.• Generated, diagnosed and maintained accuracy of daily, weekly and monthly reports.• Preparing small computer softwares using MS Excel for Quality Assurance department• Helping various departments in fetching the desired data -
Information Systems Technician 2Nd ClassUs Navy Jan 2002 - Nov 2011• Managed LAN operations for over 200 users on both secure and unsecure Networks. Duties included creating and maintaining user accounts in Active Directory on Windows Server 2003, and conducting daily, weekly, and monthly backups on both networks using VERITAS software. • Operated master consoles to monitor the performance of computer systems and networks.• Monitored the work of others and provided technical coaching and mentoring as well as train staff and users to work with computer systems and programs.• Personally managed hundreds of customer service and troubleshooting needs on all Windows based machines including conferring with customers either by telephone or in person to create accounts, cancel accounts, and to obtain details of complaints regarding various account and network issues.• Thorough understanding of all aspects of computer operations, hardware and software setup, and commercial off-the-shelf software.• Managed all daily communication operations of a communication shop including daily logs and maintenance records.• Provide staff and users with assistance solving computer related problems, such as malfunctions and program problems.• Test, maintain, and monitor computer programs and systems, including coordinating the installation of computer programs and systems.• Coordinate and link the computer systems within an organization to increase compatibility and so information can be shared.• Determine computer software or hardware needed to set up or alter system.• Analyze information processing or computation needs and plan and design computer systems, using techniques such as structured analysis, data modeling and information engineering.• Responsible for carrying out a disaster recovery plan and continuous testing of that plan.• Created, tested, and maintained the website for USS Klakring through HTML coding and SharePoint.
Joe S. Education Details
-
Healthcare Administration -
Computer And Information Systems Security/Information Assurance -
Software Engineering -
Computer Science -
Ellet High School
Frequently Asked Questions about Joe S.
What is Joe S.'s role at the current company?
Joe S.'s current role is Career Data Analyst..
What schools did Joe S. attend?
Joe S. attended Colorado Technical University, Colorado Technical University, Colorado Technical University, The University Of Akron, Ellet High School.
Not the Joe S. you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial