Jon Roloff Email & Phone Number

Saint Paul, Mn, Us

St. Louis, Missouri, Us

ArchKey Solutions is a Top 10 services provider of new installation, facilities services and program management solutions for electrical, technologies, and specialty systems. Our legacy spans nearly a century of helping to deliver The Power of Scale.- Database and integration software developer. Excel VBA, SQL (versions 2012, 2016, 2019), Power Query, Power BI, Power Platform, and Azure cloud hybrid.- Data analytics using Power BI and Tableau. I am the primary creator of datamart views and report validation and visualizations.- Business optimization and process improvement. I helped payroll save a full time employee by creating a database connected refreshable report with timesheet validation. All because I struck up a conversation next to a printer.- Designed software to integrate 6 accounting databases and 40 files from clients and internal sources. This effort provided a single operational viewport through a Dashboard and Scorecard system capturing missed opportunities, sales to project lifecycle pipelines, and financial analysis.

- Team leader for Electrical Design team performing design-build projects for 750k+ SqFt distribution centers, Arc Flash analysis, and Building Automation Systems for Fortune 50 companies.- Performed Voice Of Customer interviews reducing schedules by 50% and increased profits by 10%.- Developed client facing Roadmaps improving relationship by providing metrics, task assignments, and project pinch points for increased transparency.- Perform research and development for electrical code compliance, new product offerings, cross-sell of services, and interfaced with marketing to design assets for production.

Fargo, Nd, Us

Manager in the PMO. A key provider for technical expertise during IT development and systems integration initiatives, quality process improvements, and a primary mentor and trainer.- Manager of 8 team members across 3 states, furnishing professional and career development, and building their ability to drive project success throughout 7 portfolios.- Provided leadership for continual improvement programs in the areas of quality, client engagement, team building, and routine minimum viable product assessments.- Created an assessment dashboard utilizing imported data from Deltek Vision. Currently used by PMO staff to analyze portfolio, project, and client performance data.- Successfully turned a negative client into a positive supporter by effectively communicating expectations and delivering optimized business to business functions, increasing revenues by over 1000% in a single program.- Led the employee engagement survey effort, acting as liaison between management and staff.- An active member of quality assurance, IT development, and culture committees.- Trainer of onboarded project management staff, and provider of mentoring and training workshops on department procedures, contracts, accounting software, MS Office, and data analysis techniques.

- Hardware design and production manager for team of 7 technicians and 4 mechanical designers. Responsible for all phases of product launch including warranty and post-warranty customer needs. Worked directly with customers, sales, project managers, designers, and manufacturing vendors to ensure contractual technical specifications are met or exceeded.- Manager of production and design standards, Engineering Change Requests and Orders (ECR/ECO), material component lists and Bill Of Materials (BOM) for both electrical and mechanical assemblies. Monitored component congruity in 10 product lines across 12 aircraft types.- Performed analysis and feasibility studies supporting engineering criteria to accommodate customer experience, systems integration, and component level specifications.- Selected and managed outsourced electronic and mechanical engineering firms. Determined technical specifications and international regulatory requirements, handled logistics in/out of 30 countries, estimating contracts of $1M+, and created budgets for 12 person department.- Wrote VBA and SQL scripts integrating MS Dynamics Solomon with SolidWorks, MS Project, Excel, and Access. Reports were used for P&L and Percentage Of Completion by VP and CEO.- Technical writer covering contractual technical specification documents, production, troubleshooting, customer manuals, SOP, and hardware to software integration discrepancies for engineering staff during in plant and onsite inspections.

Moorhead, Mn, Us

- Managed specialized electrical construction projects of budgets greater than $1M. - Estimated and negotiated change orders, redline prints, and filing of AIA billing statements.- Developed analytics and information management system by using VBA to interface MS Dynamics Great Plains, Tradepower Electrical Estimation, MS Project and Office, and created mechanisms to allow field staff to collect data as feedback to support estimates.- Saved over $750,000 on multiple projects by using specialized equipment to save labor, optimized mobilization time and material delivery strategies, decreased administrative requirements through automation, and increased accuracy of bid estimates.- Primary contact during Otter Tail Power’s Sarbanes-Oxley reviews, internal project, and department audits for project cost accounting.- Coordinated high and low volt electrical, underground, and heavy equipment operators unions.

Grand Forks, Nd, Us

- Sole administrator of 5 companies across 4 locations using Windows and Linux servers to maintain 5 domains, web, email, FTP, and Active Directory.- Managed network services for integration with company’s future expansion plans via cost analysis reports, budget schedules, routine maintenance schedules, and technology utilization reports.- Developed risk management system for disaster recovery and documentation control.- Optimized servers reducing system reboots from 6-10 times weekly to once a week or less.- Designed custom servers using GE Cimplicity for Fanuc Programmable Logic Controllers for both building automation and food processing equipment projects.- Trained office staff on computer use, resulting in 80% less call volume and significantly happier staff.

Richfield, Minnesota, Us

- Worked as Computer Sales, Technician (pre-Geek Squad), lastly as Lead Sales Representative for the Digital Imaging department.- Gained knowledge of retail sales, inventory, and marketing.- Assisted in several district and regional sales awards for our store.- Trained employees, wrote quick reference guides for staff and customers, and maintained inventories.

- Managed production department, trained new employees, maintained inventory, budget, and manufacturing schedules.- Wrote documentation for technicians, on-site support staff, and customers covering maintenance schedules, troubleshooting, and operation and maintenance manuals.- Troubleshot and documented defects to mechanical and electrical engineers.- Translated German technical documentation into English, and was technical liaison for Austrian engineering team.- Created telephone and onsite technical support for customer base.

Bismarck, North Dakota, Us

- Instructed workshops at Technology And Teaching (TNT) conferences in 98 and 99.- Responsible for district wide PC based computer support, lab creation, and transition of all Apple to PC based computer systems and infrastructure.- Network installer of ring, AppleTalk, Ethernet, fiber, CCTV, and telephone infrastructure.- Phone and on-site support of administrative staff and teachers.

Tutored Triginometry, Calculus, and Electronics.

Bs-Mcis, Management/Computer Information Systems

Aas, Flight Simulation Maintenance

Diploma, Electronics, Mathematics, Physics