ROLES:

Business Analyst

HR/Payroll Analyst

Project Manager

Business Intelligence

Systems Administrator

SQL DBA

Business Continuity

Security

HR Administration

Compliance

Recruiting

TOOLS/METHODS:

Dynamics GP

Dynamics NAV

Dynamics CRM

PeopleSoft

ADP

Kronos WFC

SQL Server

SSRS/SSIS/SSAS

Active Directory

MS Access

MS Office

Camtasia

Hirsch Velocity

INDUSTRY APPLICATION:

Accounting

Sales

Inventory

Manufacturing

Logistics

Healthcare

Human Resources

Banking

Government

Retail

EDUCATION:

B.S. Business Administration, Indiana University

ADDITIONAL TRAINING:

Dale Carnegie Graduate

- Human Relations

- Management Training

EXPERIENCE SUMMARY

MS Dynamics ERP Analyst with strong background in system upgrades, security, troubleshooting, Business Intelligence and systems support. Skill set covering Accounting, HR/Payroll, Sales/CRM, Inventory, Manufacturing and Logistics. 15+ years leading ERP rollouts, upgrades, maintenance, MS SQL support, SSRS Report Server administration, user support, and software development lifecycle management. Project Manager/BA skilled in gathering business rules, workflow, creating and leading teams spanning concurrent projects over multiple business units.

SKILLS INVENTORY

Project Manager, ERP Systems Implementation, Maintenance and Upgrades

Install/maintain Financial, Manufacturing, Sales, HR/Payroll systems

Develop project plans & timelines

Design statistical reports, regression models

Analyze Finance, Inventory, customer service and logistics

Develop plans timelines and labor estimates

Develop test methodology and procedures

Create and lead project teams

Coach, provide feedback, analyze bottlenecks

Update management, stakeholders and team members

Analysis/Client Interface:

Interview clients to obtain functional/technical requirements

Assess/compile project requirements

Analyze workflow and ongoing processes

Write test scripts, coordinate teams and evaluate results

Recommend remediation and develop progress reports

MS Dynamics ERP/CRM/Business Intelligence:

Develop SQL-based data sources for reports

Set up data warehouses/data marts

Create SQL integrated Excel worksheets

Write Ad-Hoc reports or modifications to standard reports

Write code to automate data entry and data migrations

Create and maintain security profiles

Manage Integrations for CRM and Financial System

Set up scheduled processes to automate data transfers

Set up Report Servers, SSRS Reports and data driven subscriptions

Manage and develop reports in Visual Studio

Use Crystal Reports, MS Access and other reporting tools

Facilitate upgrades from legacy to current platforms

Chronological Summary of Experience

Quality Engineer

Zimmer/Biomet, Warsaw, IN

June, 2017 – Current

Quality Engineer – Configuring test scripts using InfinityQS system, work with development team to generate documentation per FDA guidelines for all Zimmer/Biomet manufactured goods. Use Infor XA system to manage medical parts development process. Use Siemans Team Center, to maintain manufacturing process per engineering guidelines using blueprints and specification documents. Set up projects in InfinityQS system to create routines for line engineers to use during parts inspection process. Implement Engineering Change Requests in InfinityQS system. Interface with Line Engineers to obtain test specifications using parts blueprints, gauges and related documentation. Interface with Offshore Engineering Team during test development project builds.

Business Systems Analyst

Lincoln Financial Group, Fort Wayne, IN

Feb, 2017 – May, 2017

Business Systems Analyst – Lead teams of Project Managers and Developers in multiple software development projects. Projects involve support and new feature development for Enterprise Business Systems across multiple departments and business units.

Business Metrics – provide analysis and reporting of activity of project groups and developers to account for project status and adherence to project budgets.

Project Maintenance – field requests from multiple business units for support and development and schedule hours to new projects. Setup new projects and determine scope, baselines, tier estimates, business requirements, and design, QA, UAT and deployment schedules.

Project Guidance – meet regularly with PM’s, Developers, Business and Management to keep projects on track during various phases of project lifecycle. Analyze variances from baseline and perform root-cause analysis.

Senior Software Developer

Maple Leaf Farms, Inc. Leesburg, IN

May, 2016 – October, 2016

SQL Developer – Wrote queries, views, stored procedures and scheduled processes to supply data sources for reports and SQL integrated Excel spreadsheets. Configured Kronos WFC system to properly handle business rules governing benefits and taxes for multiple pay groups.

System Integration – Configured Kronos Workforce Central© V7 system to take advantage of data hosted on other business platforms. Wrote custom routines to supply data for spreadsheets and reports.

Business Intelligence – Developed new queries, views and stored procedures for reports and dashboards capturing payroll & headcounts, production statistics and performance metrics. Provided KPI reports to Finance, Inventory, Operations and Production departments.

Systems Administration – Create and maintain scheduled processes, maintenance routines, and custom procedures to gather system events to monitor server condition and spot errors that need immediate attention. Configure tables and indexes,

Business Analyst

Tippmann Sports LLC, Fort Wayne, IN

June, 2014 – May, 2016

System Administrator – Full responsibility for daily administration, troubleshooting, development, user support, project management and periodic system upgrades.

Integration Management – Wrote integrations using SmartConnect©, GP Macros, EOne Extender© and SQL import routines. Manage documents in support of Sales, Inventory, Purchasing, Finance and other administrative functions using GP ReportWriter.

SQL Server Database Manager – Host SQL Server environment, providing backup and recovery, test environments, SSRS© Report development and Report Server administration.

Sales & Production Planning – Working with Sales, Inventory and Production management, Operate Manufacturing Demand Planning system using DemandCaster© statistical forecasting software platform

Third-Party Applications – Maintain third-party software in support of Warehouse Management system (Accellos©), Credit Card Transactions (Nodus Credit Card Advantage ™), Sales Document distribution to customer base (Liaison Messenger), EDI Sales Support (Gentran©), Check Printing (Check Factory©) and other software packages to support daily operations.

SR. Software Analyst

MorphoTrust USA, Fort Wayne, IN

July, 2012 – March, 2014

ERP Analyst – MS Dynamics Great Plains full-range technical support for line-of-business software - Accounting, Inventory Control, AR/AP, Manufacturing, Field Services, Project Accounting, Purchasing. User Account maintenance, Security management. Troubleshoot user issues across all modules and phases of user experience. Work with Microsoft and other vendors to develop solutions. Test and deploy solutions according to Change Management policy.

Payroll System Support - Maintain Business Portal Time & Expense platform and support for 1500+ users. Manage accounts in Active Directory and keep synchronization across applications. Manage 3rd Party software packages tied to GP System including WorkPlace© (Paramount Software) Purchase Requisition system.

Database Management – Manage SQL Server side of business in support of GP System including writing SQL code for remedying GP software errors, building SmartLists (GP custom reports), importing data, writing custom GP macros, writing stored procedures for SSRS reports, analyze & troubleshoot day to day issues.

Manage Test Environment – Build and maintain QA Environment - essentially mirroring the Production environment to support roll-to production of solutions developed in support of daily operations. Build VMWare©-based servers, SQL databases, Web Servers and desktops.

QA Software Development Analyst

October 2011 – July, 2012

ECI (Electronic Commerce Industries), Elkhart, IN

Software Testing Analyst – Develop test cases for Payroll/HR SAAS systems to analyze performance of software in development cycle. Analyze requirements and specifications to create specific test case scenarios depending on stage of projects. Analyze errors event logs and debug windows in Visual Studio to determine breakpoints in code that is showing error. Make recommendations to Code Developer based on nature of errors shown in debugging dialogs.

Database Setup/Configuration – Set up databases and test environments. Create test data to perform software validation. Modify databases to suit customer-specific requirements or Government mandates.

Documentation & Benchmarking – Produce benchmarks and test results and create documentation to use during development cycle. Regularly team with developers to coordinate project goals.

Report Programmer/Business Analyst

October 2005 – October 2011

Otis R. Bowen Center for Human Services, Warsaw, IN

Kronos WFC V6 Project Manager – Manage rollout of Kronos Workforce Central© V5 to service 600 employees State-wide with web-based time & attendance system. Coordinated with HR and Payroll departments to configure system to smoothly interface with existing MS Dynamics GP financial system. Set up Pay Groups, Pay Rules, Workflows, Approval Routing and wrote integration routine to transfer data between Kronos system and Dynamics HR/Financial system. Coordinated multi-site installation of Kronos 4500 clock units with biometric security. Set up collection routines for multi-site two-way data transfers. Installed configured and maintained communication package to transfer data using WAN via Ethernet and modems. Managed upgrade project to WFC V6. Created training program for employees, Supervisors and Managers using Camtasia for customized interactive screens and videos. Created custom reports for payroll analysis, time and attendance and performance metrics.

SQL Server Administrator – Design and maintain all SQL Server 2000/2008 Databases - medical, payroll, financial and HR (MS Dynamics GP) reporting using SSRS (SQL Reporting Services), Crystal Reports, MS Access, Cognos and MS Office. Apply periodic software upgrades, patches, and perform scheduled maintenance based on vendor recommendations and/or licensing requirements. Set up Data Warehouse to support analysis, business metrics and clinicians/doctor performance statistics

Business Intelligence Analyst – Develop business intelligence solutions using Visual Studio/Business Intelligence Development package to automate the generation and delivery of reports via MS Exchange or file server on scheduled basis. Create reports from scratch or modify/upgrade existing reports. Use SSRS in conjunction with SQL scheduled processes to automate frequent processing tasks. Write SQL stored procedures and maintain or upgrade existing code to support reports and data exchange routines.

Training System Project Manager – Set up web-based (Essential Learning©) system to automate and manage training curriculum, course schedules and clinician progress to fulfill position-based and regulatory agency credentialing and licensing requirements. Work with HR and other departments to coordinate ongoing maintenance of e-learning system and reporting on course progress.

MS Office/Access Developer – Maintain MS Access databases to support ad-hoc reporting systems not supported by enterprise systems. Such systems include Safety/Risk Management, Event Reporting required by Joint Commission on Accreditation of Healthcare Organizations (JCAHO) and Prescription drug tracking, client medication refill schedules, Pharmacy mailing databases and reorder/medications due reporting.

Contact this candidate