SUMMARY:

Over 30 years of experience as a IT Manager, Business Analyst, Systems Analyst, business solutions provider, and software developer, including 20+ years’ experience in Management, analysis, design, development, implementation, customization, and migration of several ERP products. Several years’ experience in database management and Network installation and configuring and security.

TECHNICAL SKILLS:

Databases: SQL Server, Oracle, MySQL, MS Access, Sybase

SOFTWARE: MS Project, MS Office, Business analysis design tools, Microsoft Dynamics AX, BaaN, ERP LN, Confidential XA, SAP, Syteline, PeopleSoft and Oracle

Operating Systems: Microsoft Windows and Unix

WORK EXPERIENCE:

ERP/Applications Manager

Confidential

Responsibilities:

• Manage ERP’s including Microsoft Dynamics AX, Baan, SAP, Oracle, MacPac, and Mapics
• Manage the development, roll - out and ongoing support of new applications, systems software, and enhancements to existing applications in and pertaining to the ERP system used in the various enterprises.
• Developer and Business analyst for Dynamics AX, Baan, Confidential LN, SAP and Oracle.
• Functional expert in Dynamics AX, Baan, Confidential LN, SAP and Oracle
• Administer SQLServer, Oracle databases
• Develop and deliver status reports, proposals, consolidated requirements documentation and presentations to senior management and the board of directors.
• Integrated systems with Salesforce.
• Develop programs within ERP’s (Dynamics AX, SAP and Baan) to fit business needs.
• Design and developed new processes within Microsoft Dynamics AX, SAP and Baan.
• Develop and manage business analysis and requirements gathering processes to ensure consistent and scalable execution.
• Define project scope, metrics, goals and deliverables that support business goals.
• Coach, mentor, motivate and manage team members and influence them to take positive action and accountability for their assigned work.

Senior Development Business Analyst

Confidential, Columbus, OH

Responsibilities:

• Develop Integrations to several ERP’s.
• Develop business requirements documentation
• Developed ERP’s and integrations for several cloud based and on premise products.
• Analyze systems and create business requirements documents for ERP’s such as Microsoft Dynamics AX/NAV, BaaN, Confidential LN, Confidential XA, Confidential M3, Syteline, SAP, Oracle and JDE.
• Facilitate daily Scrum activities such as: Stand-Up’s, updates to Burn-Down spreadsheets and charts, Backlog reviews, and meetings as needed
• Manage a team of analysts and developers across the organization.
• Managed enhancements development group. The group is responsible for integration to several ERP products. This requires ERP code to be changed and functionally tested to ensure product functionality remains intact. This requires business analysis, design, development, process improvement and product testing.
• Maintain expertise in the application and use of systems, tools, and processes within the department's scope
• Administer several databases throughout the company, such as Oracle, SqlServer and Sybase.
• Responsible for business requirements, functional specifications, technical specifications, and advising business on options, risks, and costs versus benefits of various solutions.
• Generating innovative plans to increase the productivity of the organization
• Utilized Agile, Waterfall and Kanban techniques to accomplish goals for Integration, Design and Development.
• Provide performance evaluations for team members and provide path for success
• Estimate projects for length and cost to customer, as well as develop resource plans.
• Manage and design security for cloud based and on premise products.

Lead Analyst

Confidential, Columbus, OH

Responsibilities:

• Led teams and participated in business analysis, design and process improvement of multiple software systems utilizing both agile and waterfall methodologies.
• Develop business requirements documentation
• Develop and create design documents for ERP’s such as BaaN, Dynamics AX and SAP.
• Work with users to design process improvements, requirements and train users on processes.
• Managed and developed projects. Business analysis through testing of processes.
• Analyzed, developed and designed several new processes for customer satisfaction and process improvement (both security and process enhancements).
• Work with users to design a new customer processes in the cloud.

IT Manager/Director of Applications

Confidential, Dublin, OH

Responsibilities:

• Led, designed, coded and architected Project to convert six different ERP systems to a common platform.
• Led teams and participated in business analysis, design and process improvement of multiple software systems
• Lead groups that consisted of six offices across the US
• Led development efforts, as well as developing for existing Oracle, Ecommetry, Syteline and Baan environments.
• Analyze systems, create business requirements documents and develop for ERP’s such as Microsoft Dynamics AX, BaaN, Confidential LN, Syteline, and JDE.
• Led business and technology to standardize processes between our six companies.
• Architected and developed multiple web applications and several web interfaces to integrate ERP sessions to enable faster and more accurate data entry of items and orders.

Senior Baan Analyst/Developer

Confidential, Marysville OH

Responsibilities:

• Part of a team converting from Baan to GPCS.
• Software Developer for Baan
• Function and technical lead for existing Baan issues and projects.
• Develop business requirements documentation for modifications to Baan.
• Provide functional support for Baan issues.
• Using Baan MS SQL Server, Created new 4GL Reports, Sessions, Forms, Menus, as well as, change existing ones as needed to fulfill user requests and needs until Confidential system is launched.
• Led and architected the integration to the Confidential system to enable the multiple plants to operate independently while plants go live on new system

Senior Analyst/Administrator

Confidential, Portland, OR

Responsibilities:

• Led the team for conversion of Baan V to SAP.
• Led the technical and function staff on existing Baan projects
• Created new reports and forms for new SAP system to ensure valid data was migrated to SAP.
• Using Baan V and MS SQL Server, Created new 4GL Reports, Sessions, Forms, Menus, as well as, change existing ones as needed to fulfill user requests and needs while new SAP system was launched.
• Developed and tested several Hyperion reports for requested financial reports
• Developed and tested several sessions to use RF guns to read barcodes to increase receiving proficiency.
• Lead team that analyzed requirements and trained end-users in Distribution, Manufacturing and Finance Modules.

Senior Baan Developer/Administrator

Confidential, Scottsdale, Arizona

Responsibilities:

• Developed and tested several Sessions to use RF guns to read barcodes to increase shipping and receiving efficiency.
• Using Baan and ORACLE, Created new 4GL Reports, Sessions, Forms, Menus, as well as, change existing ones as needed to fulfill user requests and needs to abide by companies business model.
• Architected and created a new cycle counting process for warehouses to increase performance and accuracy.
• Implemented change control, QA and Development processes across the company.

Senior Developer/Administrator

Confidential, Southfield, Michigan

Responsibilities:

• Team lead and senior analyst for the Baan Archiving Project.
• Lead Team that analyzed requirements and trained end-users in Distribution, Manufacturing and Finance Modules.
• Implemented EDI to accurately process blanket orders
• Led, architected and developed programs to map data from Baan to the SAP Business Warehouse product for business reporting.
• Created a web based reverse auctioning tool to enable our suppliers to bid on items that utilized Baan Open World for real time Baan information.
• Responsible for setting up and maintenance of VRC structures and Baan DEMs to ensure proper security and roles of users.
• Installed and developed the Merkur Fax Software that allows users to fax Baan reports directly from their desktop.
• Using Baan and ORACLE, Created new Reports, Sessions, Forms, Menus, as well as, change existing ones as needed to fulfill user requests and needs.
• Managed the PMC module within Baan to load Customizations and patches into Baan production. The PMC module was setup to automatically email the administrator of any customizations that needed to be moved to production.
• Created a process to Import data from Human Resource MS Access database to populate the hours accounting data in Baan for reporting purposes.

Lead Analyst/Developer

Confidential, Livonia, Michigan

Responsibilities:

• Led and architected the installation and customization of the Baan Software package after the company separated from Ford Power products.
• Lead a team to Developed and Test a website to integrate Baan with the Internet. Allowing Customers to access their accounts in real-time and create orders online.
• Developed and tested several Sessions, Forms and Reports within the Finance, Distribution and Manufacturing Modules of Baan utilizing Baan Tools.
• Implemented EDI transactions to process Dispatch Advice (856), Sales Order (850), Receiving Advice (861), Shipping Schedule (862), Purchase Order Change (865) and Demand Forecast (830).
• Installed and utilized Harbinger for the EDI transactions to translate the X12 and various formats into a flat file format that Baan could accept.
• Architected and developed a new Quotation process for the business that increased the accuracy for the business
• Lead a team that designed and programmed a new Claim tracking log process within Baan.
• Led the upgrade to newer version of BAAN (4b2 to 4c4) and designed new VRC system structure for the testing procedures and data security in Oracle.

Senior Programmer Analyst

Confidential, Michigan

Responsibilities:

• Launched an integrated website that used both the PeopleSoft ERP product and legacy Mainframe to access Chryslers Human Resource and Benefits information from the Internet for Union employees. This website was written with HTML, JAVA and C++ programming languages.
• Coded all scripts for employee and supervisor access to database using Active Server Pages (ASP) for Server side database access and client side functionality with DHTML and JavaScript.
• Developed an interface using open client server technology to synchronized data from Sybase Server into DB2 and vice-versa. The process of synchronizing data from Sybase to DB2 was written using C, Sybase stored procedures in a UNIX environment and from DB2 to Sybase was done by writing a set of programs using COBOL, DB2, and CICS with embedded calls to the Sybase database engine.
• Served as the Oracle DBA for the test environment.
• Upgraded processing ability on Solaris Sun Server for added customer support.
• Upgraded PeopleSoft from release 5 to release 7.
• Managed the upgrade of the Salary Biweekly Payroll interface to third party payroll system. Utilizing SQR, Oracle, and the PeopleSoft HR System.
• Supported the development of customized reports and queries.
• Wrote reports to generate Seniority listing within Financial Organization Code or within location and Department Codes.
• Created interface to extract Budget information from excel to GLD tables.

Environment: PeopleSoft ERP, Oracle, and Unix.

Programmer Analyst

Confidential, Troy, Michigan

Responsibilities:

• Responsible for the Cash Receipt Application Interface.
• Responsible for exporting and importing components, Audit Management, Patch Management, User and Authorizations Management, Device Management, Database Management, and Database Reconfiguration.
• Designed and implemented shipping functionality.
• Responsible for Socket programs using C Language
• Documented functional and technical specifications.

Programmer Analyst

Confidential, Kalamazoo, Michigan

Responsibilities:

• Utilized an IBM 3090 Model OS/MVS/XA Operating system with Confidential, TSO/ISPF and Panvalet to write programs in COBOL/COBOLII to access data in VSAM, and Sequential Files and IMS.
• Designed, coded, tested and implemented a pay return system that was used for customer overdrafts and balancing. This system utilized both batch and on-line CICS programs. Other responsibilities included the maintenance of approximately 40 COBOL/COBOL-II programs that ran on a daily, weekly, monthly, and yearly basis. Also wrote several other new programs for reporting, balancing, auditing, and other purposes.
• Migrated from Panvalet to Changeman.

Environment: IBM Mainframe, PC.