Nicholas Schroer's Location
Cincinnati, Ohio, United States, United States
Nicholas Schroer's Contact Details
Nicholas Schroer work email
- Valid
- Valid
- Valid
- Valid
Nicholas Schroer personal email
n/a
Nicholas Schroer phone numbers
About Nicholas Schroer
With almost 10 years of professional experience, I have built a wealth of knowledge and experience in data analysis, documenting standard operating procedures, user training, software development/testing, process improvement, project management, and report writing. I'm proficient with software like Crystal Reports, Epic Hyperspace 2015 & 2017, Epicor ERP 9, 10 & Kinetic, Power BI, SSRS, and Tableau. My analytical language of choice is SQL.I currently work for Trew Automation as a Senior Data Analyst and hold a Bachelor of Business Administration (BBA) in Marketing with Academic Minors in Information Systems and Business Analytics from the University of Cincinnati's Carl H. Lindner College of Business.
Nicholas Schroer Work Experience Details
-
Senior Is AnalystMidwest Filtration Aug 2024 - PresentCincinnati, UsCODING AND SOFTWARE USAGEEpicor Kinetic (2024.1.10), Microsoft Office Suite, Microsoft Power BI, Microsoft Project, Microsoft SharePoint, Microsoft SQL Server Management Studio (v20.0), Microsoft Teams, UKG -
Senior Data AnalystTrew Jan 2024 - Aug 2024West Chester, Ohio, UsCODING AND SOFTWARE USAGEAutodesk AutoCAD, Azure Synapse Analytics, Hubspot, Microsoft Office Suite, Microsoft Power Apps, Microsoft Power BI, Microsoft Project, Microsoft SharePoint, Microsoft SQL Server Management Studio (v20.0), Microsoft Teams, Netsuite, SmartSheet, TeamSupport, UKGACCOMPLISHMENTS• TREW Project Reporting Data Model Optimization (Power BI)• HubSpot & TeamSupport Data Integration• Customer Health Scorecard Visualization (Power BI)• Data Warehousing (NetSuite Saved Searches)• Power BI Directory & Definitions -
Senior Erp Applications AnalystCincinnati Test Systems Aug 2022 - Dec 2023Harrison, Ohio, UsGlobally supporting seven manufacturing facilities on Epicor 10 and Kinetic, while in parallel, participating in implementations in the United States, UK, and Europe. -
Erp Technical AnalystCincinnati Test Systems Jul 2020 - Jul 2022Harrison, Ohio, UsCODING AND SOFTWARE USAGEEpicor 10 (10.2.400.14), Kinetic, Microsoft Office Suite, Microsoft Power Apps, Microsoft Power BI, Microsoft SharePoint, Microsoft SQL Server Management Studio (v18.6), Microsoft Teams, Parallels Client (v17 & v18), ZoHo Service Request System, ZoomHELP DESK STATISTICS• Completed: 1,875• Average Tickets Completed per Day: 2.105 Tickets• Users Assisted: 252• Average Tickets per User: 7.157ESTIMATED COST SAVINGS• 2023 YTD - $484,764.85• 2022 YTD - $375,894.45• 2021 YTD - $330,065.32ACCOMPLISHMENTS• REST API Report Conversion• BPM and Customization Creation, Implementation, and Maintenance• User Management (AD Accounts, User Accounts, Person/Contacts, Employees, Work Forces, etc.)• Update and Support Power Apps/Power BI Processes (Sales)• Manage SQL Stored Procedures & Securities (Email Notifications, Debug Emails, User Roles, etc.)• External Reporting/Processing Conversion to Epicor Based Reporting/Processing• Executive Level Summative Data Reporting (Web API)• Dashboard Creation and Upgrades• Database Management, SharePoint Integration, and UI Design and Introduction (Full Stack)• Epicor Configurator Design• New Company Setup and Implementation (Quote to Cash)• HubSpot/Epicor Integration• Quote to Cash Process Mapping/Gold Standard Establishment• Power BI Integration (Requirements Planning, Proof of Concept, Data Review, Implementation, Improvements)REASON FOR LEAVING:I was laid off during a corporate restructuring across multiple companies owned by the same parent company. I received a severance package, my accrued vacation was paid out in full, and I left in good standing.
-
Business System Developer (Short Term)Apex Supply Chain Technologies, Llc May 2020 - Jul 2020Mason, Ohio, UsCODING AND SOFTWARE USAGEEpicor 10 (10.2.300.31), JIRA, Microsoft Office Suite, Microsoft SharePoint, Microsoft SQL Server Management Studio, Microsoft Teams, Node.js, Parallels Client (v17), React, Service Now Request System, ZoomESTIMATED COST SAVINGS• 2020 YTD (3 months) - $36,114.00ACCOMPLISHMENTS• Led the Epicor setup, conversion, and implementation of a dual company environment in under two months. (formerly a single company environment)REASON FOR LEAVING:I was approached by the Director of IT at Cincinnati Test Systems with an opportunity to be a part of an established ERP group supporting five sites across the continental United States. Additional opportunities for career development, and advancement, made this an opportunity I couldn't pass up. Interviews were conducted in the middle of COVID-19 shutdown when most companies had put a freeze on hiring processes and were even laying off current employees. -
Business System AnalystTect Power, Inc. Sep 2017 - Feb 2020Fort Mitchell, Kentucky, UsCODING AND SOFTWARE USAGEActive Directory, Citrix Workspace, Epicor 9 (9.05.702), Epicor 10 (10.2.300.11), FileZilla, Microsoft Office 2016, Microsoft Power BI, Microsoft SQL Server Management Studio, Microsoft Visual Studio 2015, SQL Server Reporting Services, SAP Crystal Reports XI, WinSQLIT REQUEST STATISTICS• Completed: 539• Adhoc Requests Completed: 87• Average Tickets Completed per Day: 0.971 TicketsACCOMPLISHMENTS• Created an Asset Management System for tracking items such as CPUs, Docks, Laptops, Monitors, and Cell Phones• Introduced Serial Number Tracking at our Wichita Turning facility• Created a full custom Part Profit/Loss statement report to be used during upper level management decision making processes• Assisted with the introduction and integration of Epicor 10 at five sites across the country• Settled $300,000+ of delinquent/slow moving AP Invoices (175+ invoices)• Created standard operating procedures for Quote to Cash processes including Job Creation/Closing, Labor Reporting, Shipping/Receiving Reconciliation, and AP/AR Invoicing.• Created BPMs and module customizations to improve the end user experience• Assisted with Physical Inventories at our Thomasville, GA and Cleveland, OH facilities (2019 & 2020)REASON FOR LEAVING:I was laid off during the acquisition of TECT Power by the Whitcraft Group. I received a severance package, my accrued vacation was paid out in full, and I left in good standing. -
Data Analyst IiSt. Elizabeth Physicians Nov 2016 - Aug 2017Erlanger, Kentucky, UsCODING AND SOFTWARE USAGEEpic Hyperspace 2015, Epic Hyperspace 2017, Microsoft Office 2013, Microsoft Office 2016, Microsoft SQL Server Management Studio 2012, Microsoft SQL Server Management Studio (v17), Microsoft Visual Studio 2010, SAP Crystal Reports 2013REPORT REQUEST STATISTICS• Completed: 78• Average Reports Written per Week: 1.951 ReportsACCOMPLISHMENTS• Produced and managed monthly reports and databases, specific to department functions• Created, reconciled, and validated 3rd party extracts via ETL methods (Crimson, Anodyne, Press Ganey, etc.)• Validated and created automated processes through Microsoft SQL Server Integration Services• Automated the collection, transformation, and integration of Press Ganey data that was used for St. Elizabeth's Value Based Incentive program• Streamlined reporting methods used by St. Elizabeth's Service Recovery Department to focus on tangible and measurable goals• Introduced report tracking methods and established information to be documented for accurate and precise archiving (no formal report tracking system previously)• Updated and improved reporting methods, via SAP Crystal Reports, for St. Elizabeth's Diabetic Research Center, resulting in department wide elimination of offline Excel spreadsheet use and a large increase in data accuracyREASON FOR LEAVING:I was approached by TECT Power's Director of HR with an opportunity to perform the same job I had while in Kansas with TECT Aerospace. I co-oped with TECT Power and was returning to an office with established and maintained relationships. -
Business System AnalystTect Aerospace May 2016 - Oct 2016Wichita, Kansas, UsCODING AND SOFTWARE USAGEAdobe Coldfusion, Citrix, Epicor 9 (9.05.701), JIRA, Microsoft Office 2016, Microsoft Power BI, Microsoft SharePoint 2016, Microsoft SQL Server Management Studio 2014, Microsoft Visual Studio 2013, Tableau, Vantage 8ACCOMPLISHMENTS• Prepared, maintained, and kept updated IT procedures and documentation related to our processes and platform operations• Configured and troubleshot software and hardware enhancements, application deployments, and infrastructure upgrades• Trained new users on proper techniques of system usage in accordance with TECT Aerospace Rules and Regulations• Improved methods for reporting and forecasting sales through the use of an Integrated Total Sales Revenue Projection system (ITSRP); Contributed during each phase of the SDLC, with a focus on Analysis and Design, Implementation and Training (Documentation), and Sustainment• Streamlined document generation through the use of Crystal Reports and an Enterprise Resource Planning platform (Epicor 9 and Vantage 8.03)• Resolved IT requests through effective utilization of coding background, knowledge, and skills (SQL/Java/ColdFusion)• Combined site process change requests and CNC programming requests into a single interface for easier user interactions and data miningREASON FOR LEAVING:I moved from Wichita, KS to Cincinnati, OH. -
Sales And Marketing Analyst (Co-Op)Tect Power, Inc. May 2015 - Aug 2015Fort Mitchell, Kentucky, UsCODING AND SOFTWARE USAGEAdobe Coldfusion, Epicor 9, Java, Microsoft Visual Studio 2013, Vantage 6, Vantage 8• Worked with Sales Team members to support, develop, and enhance the use of Epicor and the Sales Intranet Planning Module, which included leading the development of a comprehensive training program• Compiled, analyzed, and presented aviation market data from various sources, both external and internal• Provided sales growth by increasing visibility of sales plans and execution against those plans• Developed and implemented sales tools and analytics software to monitor and analyze sales activity against company goals• Prepared reports and planned/executed weekly Tactical/ Backlog management meetings in conjunction with monthly Sales and Operations Planning meetings• Set appropriate metrics for reporting performance and maintained a level of accuracy and integrityREASON FOR LEAVING:The Cooperative Education Program is intended to integrate school and work in alternating semesters. This was a single rotation, 4 months, which ended with me returning to the University of Cincinnati to finish my education.
-
Ecommerce Online Market Analyst (Co-Op)Axcess Financial Jan 2014 - Aug 2014Cincinnati, Oh, Us• Developed reports and identified trends, issues and opportunities to improve online traffic, sales and service, site performance and the overall user experience through the analysis of web and other digital metrics• Conducted competitive analysis and provide strategies, tactics and tools necessary to drive traffic to website• Created and maintained user interface design specifications (detail documentation of interface design, including aesthetic guidelines and screen‐level interactions)• Interacted with web development team to ensure successful and accurate transition of user interface designs to production and ensured execution of the final user interface as intended• Improved SEO Optimization, Analytics and managed web site campaigns – including website analysis, keyword analysis, SEO copywriting, ad writing, and research search engine guidelines• Produced weekly, monthly, quarterly and yearly ROI reports and implemented multiple strategies to optimize organic rankings• Social Media Marketing – marketed products to consumers via social media environments (Facebook, Twitter, blogs, YouTube, Linked In)REASON FOR LEAVING:The Cooperative Education Program is intended to integrate school and work in alternating semesters. This was a double rotation, 8 months, which ended with me returning to the University of Cincinnati to finish my education. -
Student Orientation LeaderUniversity Of Cincinnati Apr 2013 - Sep 2013Cincinnati, Ohio, Us• Served as a representative of the University of Cincinnati and as a resource to new students and their guests• Facilitated transitional programs centered around academic planning and student involvement for all first-year students including freshman, international, and transfer students and their parents• Assisted academic advisors in the presentation of academic planning information sessions and supported students during the registration process• Developed expertise in multiple areas of academics in order to assist students with advising and registration• Lead workshops, presentations, and discussions that provided students and their families with information and perspectives on campus life• Portrayed the University of Cincinnati, its policies, agencies, services, and campus life in a professional manner to first-year students and parents• Worked on a team of 39 (2 bosses, 6 coordinators, and 31 SOLs) to successfully orientated 7,700+ first-year students
Nicholas Schroer Skills
Microsoft Office
Social Media
Marketing
Customer Service
Public Speaking
Time Management
Advertising
Microsoft Excel
Sales
Public Relations
Powerpoint
Leadership
Data Analysis
Active
Teamwork
Microsoft Word
Talkative
Communication
Sociable
Dedicated
Responsive
Web Design
Cooperative
Customer Relations
Retail
Computer Hardware
Photoshop
Microsoft Sql Server
Tableau
Sharepoint
Active Directory
Java
Business Analysis
Project Management
Business Intelligence Tools
Business Intelligence
Data Governance
Data Warehousing
Python
Cascading Style Sheets
Html
Ruby On Rails
Javascript
Sql
Epicor
Software Development Life Cycle
Sql Server Integration Services
Troubleshooting
Nicholas Schroer Education Details
-
University Of CincinnatiMarketing
Frequently Asked Questions about Nicholas Schroer
What company does Nicholas Schroer work for?
Nicholas Schroer works for Midwest Filtration
What is Nicholas Schroer's role at the current company?
Nicholas Schroer's current role is Senior IS Analyst.
What is Nicholas Schroer's email address?
Nicholas Schroer's email address is sc****@****.uc.edu
What is Nicholas Schroer's direct phone number?
Nicholas Schroer's direct phone number is +131642*****
What schools did Nicholas Schroer attend?
Nicholas Schroer attended University Of Cincinnati.
What skills is Nicholas Schroer known for?
Nicholas Schroer has skills like Microsoft Office, Social Media, Marketing, Customer Service, Public Speaking, Time Management, Advertising, Microsoft Excel, Sales, Public Relations, Powerpoint, Leadership.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
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