SUMMARY

• Perform in the following Information Technology positions such as a process manager, systems programmer, an application programmer, a business analyst, a trainer/mentor, a team leader and manager for over thirty years.
• Responsible for using multiple life cycle methodologies to perform such tasks as analysis, design, business requirements gathering, technical and functional specification gathering (including use cases for other programmers to follow),
• Perform extensive coding, testing, and implementing of projects and systems
• Create documentation (including business, technical and functional specifications, project charters, process flow charts, user manuals and system operations manuals)
• Create and conduct user and student training (including individual, small group and classroom).
• Support many industries such as automotive, telecommunications, insurance, and healthcare; supported computer integration in operating systems and utilities.
• Provide technical expertise on mainframe systems, on client/server systems, on SharePoint, and on business intelligence systems
• Supported systems internationally in Netherlands, Hungary, Germany, and Mexico.
• Demonstrate excellent written and verbal communications skills.
• Managed a union staff of five people and a non - union staff of three operators and two programmers; led teams of size from two to fifteen.

TECHNICAL SKILLS

Operating Systems: Unix, OS/390, MVS, Microsoft Windows 10, Windows 7, Linux, MCP

BI Tools: COGNOS, Tableau, Qlikview, Business Objects

Desktop Applications: Microsoft Word, Excel, Power Point, Outlook, Visio, and Project

DB Language: PL/SQL

Computer Languages: HTML, XML, CGI/Perl, C/C++, Java, COBOL, ASPX, .NET, CICS

Methodologies: Agile, Waterfall, Object Oriented (UML)

Applications: Infor ERP LX, Infor PLM Discrete, QAD, DataDirect Shadow/Studio, Caliber

Ancillary Software: Vi, Ed, TSO, ISPF, JCL, CA7

Industries: Automotive (Sales and Marketing, Warranty, Order Entry, Billing, Accounting/Finance), Life Insurance, Health Insurance, Operating Systems

PROFESSIONAL EXPERIENCE

Confidential, Saginaw, MI

Database Financial Analyst

Responsibilities:

• Perform as a database architect and developer for the Driveline and Steering Finance teams on projects such as the Manufacturing database, QAD, Checkbook, Volume Forecasting, and Pricing/Mix Reporting.
• Create high level process flow charts, business requirements, logical and physical data models, test plan and test cases for the Driveline and Steering Finance teams for QAD and other financial information.
• Create and maintain Power BI dashboards, reports and datasets including the data sources, relationship models, and measures.
• Work as the Driveline and Steering Finance Information Technology point of contact

Environment: SQL Server, QAD, MS Visio, MS Project, MS Office Suite, Power BI.

Confidential, Southfield, MI

Business Analyst

Responsibilities:

• Supported the applications and infrastructures, including QAD, PLM
• Supported the corporate intranet site using SharePoint Designer, ASPX and HTML
• Developed process flow charts and business requirements for the upgrading of ERP and PLM systems
• Determined and recommended process, systems or enhancements changes using LEAN and/or Six Sigma methodologies.

Environment: QAD, Trans4M, Infor PLM Discrete, SharePoint Designer, MS Office Suite, MS Visio, MS Project, and SQL Server 2015.

Confidential, Auburn Hills, MI

Project Manager

Responsibilities:

• Performed as a point of contact for R&D; acted as project manager for the R&D department on projects such as the ERP, Vehicle Project tool, Product Lifecycle Management, Product Architecture system and Sample Request system.
• Created high level process flow charts, business requirements, use cases, logical and physical data models, test plan and test cases for R&D team for ERP and EDI information, traveled to sites outside US as needed
• Determined and made process, systems or enhancements changes using LEAN and/or Six Sigma methodologies.
• Designed, developed, and maintained InfoPath forms and SharePoint content for R&D team

Environment: SQL Server, SharePoint, InfoPath, BPCS, Infor ERP LX, QAD, SAP, MS Office Suite.

Confidential, Detroit, MI

Data Analytics Architect and Specialist

Responsibilities:

• Designed and developed a data warehouse using the identity management database as a base for the Identity Management Data Quality team using SQL packages, stored procedures and functions.
• Worked as a database administrator in training while managing and maintaining the internal identity management data quality database
• Worked with Tableau to create a weekly dashboard of areas of concern or interest within the group
• Performed cleansing and data analysis with PL/SQL, MS Excel and MS Access using complex functions, macros and some VBA coding and PowerPivot

Environment: Tableau, Oracle, MS Excel, MS Access, PL/SQL, Suse Linux and Windows Server 2008.

Confidential, Detroit, MI

Business Analyst

Responsibilities:

• Worked on the Servicing business requirements in regard to the Patient Protection and Affordable Care Act (PPACA) project; attended customer meetings to obtain project information and help in understanding process and requirements

Confidential, Southfield, MI

Senior Consultant

Responsibilities:

• Worked on the Next Generation Sales Reporting (NGSR) system as a business and technical subject matter expert and as a liaison between the business and technical staff; and then with the report lead for the first iteration of construct to close; assist in the generation of metadata, ETL, and reporting using COGNOS BI Tools
• Assisted in the creation of the NGSR logical and physical data models and in the creation of the reporting data warehouse for Oracle and COGNOS; assisted in the creation of high-level process flow charts, documentation such as business requirements, use cases, test plan and test cases
• Attended customer meetings to present project information and help in understanding process and requirements

Environment: UNIX, Oracle, COGNOS, Tableau, Qlikview, MS Project, MS Visio.

Confidential, Detroit, MI

Sr. Business Analyst

Responsibilities:

• Supported the consolidation of the eligibility and client billing/reporting systems for a pharmacy benefits management firm by meeting with the customer, mapping data between client’s multiple systems,
• Wrote functional requirements documents and then presented these documents to the customer for approval; aided technical staff in writing of technical specifications

Environment: IBM mainframe, AS 400, COBOL, IMS, DB2, MS Project, MS Visio.