Post Job Free

Resume

Sign in

Data Analyst Developer

Location:
Livonia, MI, 48152
Posted:
February 17, 2020

Contact this candidate

Resume:

Daniel R. Nolan

Howell, Michigan *****

248-***-****

adbtnf@r.postjobfree.com

Professional Profile

Extensive experience in the IT industry and have worked as a Project Leader, Instructor and Programmer/Analyst in the automotive, manufacturing, education, insurance, health care and banking industries.

Programming and Development Analysis – Involved with all phases of the System Development Life Cycle (SDLC). Gathered requirements, designed programs, developed and tested.

Project Leadership – Led a team of 12 programmers. Involved in the System Development Life Cycle of a nationwide inventory system used to keep track of repairable assets using multiple Oracle Tools.

Training and Mentoring – Trained entry-level programmers, preparing them for various positions with multiple clients. Created all training materials for the 3-5 month training sessions. Guided the trainees through the life cycle of a system utilizing COBOL, IMS and DB2.

Industries – Automotive, Manufacturing, Education, Insurance, Health Care, Banking and Government.

Area of Expertise – Application Development, Application Support, Documentation, Testing, Coding and Debugging, Design Specification, Software Evaluation, Supervisor, Test Plan Development and Training.

Experience and Skills – SAS, PC SAS, VB Scripting, Oracle, Oracle Reports, Oracle Forms, SQL, PL/SQL, Toad for Oracle, MicroFocus COBOL, COBOL/COBOLII, DB2, JCL, Xpediter/TSO, File-AID, Panvalet,

Microsoft Word and Microsoft Excel.

Chronology of Experience

DMI Digital Management Inc. (previously Compuware Corporation) April 2000 to June 2019

Industry: Government – City of Detroit, Department of Transportation (DDOT) Sep 2016 to Mar 2019

Position: Developer/MIS Support

Environment: Microsoft Windows and Mainframe

Tools: Oracle, SQL Server, COBOL, Microsoft Word and Microsoft Excel

Successfully Implemented a new Fleet Management System from a Mainframe Legacy System.

SME with the Fleet Management System, Vehicle Maintenance/Inventory of AssetWorks M5.

Enhanced and maintained the AssetWorks M5 Vehicle Maintenance/Inventory System, Data Analyst for all projects.

Developed and modified all ADHOC reports for vehicle maintenance, inventory and purchasing in AssetWorks M5 system.

Developed and modified scripts as well as created ADHOC reports in SQL Server.

Design developed an internal Intranet in HTML using Paintbrush to create graphics.

Gathered all documentation from business units as a business analyst.

Industry: Insurance – Blue Cross Blue Shield of Michigan June 2013 to Jul 2016

Position: Developer/Business Analyst

Environment: Mainframe and Microsoft Windows

Tools: SAS, Oracle, SQL Server, DB2, JCL, COBOL and Microsoft Excel.

SME with the PC SAS using SQL Server and Oracle.

Met with clients and gathered all required documents as a business analyst.

Enhanced and maintained the Business Intelligence Request & Tracking (BIRT) System.

Utilized Mainframe with COBOL and SAS to generate data from DB2 tables to create reports.

Utilized Client/Server and PC SAS to generate data from SQL Server and Oracle to create reports.

Developed and maintained ADHOC report programs and Data Feeds to assist customers in-house and at Support Centers in business decisions.

Developed and maintained ADHOC reports for third party customers that depended on recurring Monthly, Quarterly, Semi-Annual and Annual Reports and data feeds to support end clients using COBOL and Client/Server applications.

Wrote and maintained system documentation and process instructions for the entire BIRT system.

Industry: Banking – Flagstar Bank Oct 2010 to May 2013

Position: Data Analyst/Developer/Business Analyst

Environment: Microsoft Windows and Mainframe

Tools: Director 5.1 Scripting, VBScript, Microsoft Excel and On-Line Letter Writer (OLLW).

Flagstar Bank implemented a new Mortgage Servicing Package (MSP) through Lender Processing Services (LPS) from a mainframe system.

Mapped all Legacy COBOL Data to new Oracle System as a Data Analyst.

Met with all business units and gathered requirements for development as a business analyst

While working within the Loss Mitigation Department I Developed maintained and documented VBScripts.

Wrote VBScripts to automate their manual processing such as Foreclosure Referrals, Hazard Insurance issues, ACH Bill Payments, Escrow Analysis and all other aspects of the Loss Mitigation processing areas.

Industry: Automotive – Volkswagen Jan 2010 to Oct 2010

Position: Data Analyst

Environment: Microsoft Windows

Tools: JIRA and Microsoft Excel

Analyzed and ensured data integrity for the new VW builder application.

Cross referenced several client documents to eliminate data redundancies.

Made modifications to any data requirements from for VW Model Year 2011.

Uploaded mass data using Excel spreadsheets.

Industry: Automotive – Volkswagen Jan 2009 to Dec 2009

Position: System Developer

Environment: Microsoft Windows and MySQL

Tools: XML, JIRA and phpMyAdmin

Developed and made modifications for the Model Year 2010 VW Builder website using phpMyAdmin.

Performed quality assurance testing and peer reviews.

Generated and bundled xml code.

Industry: Insurance – Blue Care Network Dec 2007 to Dec 2008

Position: Application Support

Environment: Microsoft Windows 2000

Tools: Toad for Oracle, PowerCenter8 and Quick Start for Informatica

Monitor EDI jobs that processed claims.

Wrote several SQL scripts to run reports in Toad for Oracle.

Documented Existing systems that were written in Oracle to do a proper shut down.

Documented 70-80 existing BCN systems that were written in Informatica.

Industry: Insurance – American Community Mutual Insurance Company Jan 2006 to Nov 2007

Position: Programmer/Business Analyst

Environment: IBM Mainframe MVS

Tools: Xpediter/TSO, Panvalet, File-AID/MVS, COBOL, JCL and Microsoft Word

Supported production and enhancements to claims applications.

Analyzed, designed, coded and tested COBOL/CICS and Natural programs utilizing VSAM and ADABAS.

Gathered all requirements as a business analyst from the business units for development.

Developed and modified JCL.

Developed requirements and design documents for new and existing systems.

Industry: Health Care – Mount Clemens General Hospital Jun 2005 to Dec 2005

Position: Project Lead/Setup Analyst

Environment: Microsoft Windows 2000

Tools: Oracle Forms, Oracle Reports and J-Initiator

Developed and installed an inventory organization to interact with an existing system using inter-org transfers

and internal requisitioning.

Setup functionality for planning, cycle counting and physical inventory.

Developed all documentation and training manuals.

Trained users in requisitioning, purchase orders and receipts.

Trained users in miscellaneous issues, receipts and return to stock.

Industry: Automotive – Ford Motor Company Feb 2002 to Jun 2005

Position: Configuration Analyst

Environment: Microsoft Windows 98/2000

Tools: Oracle Forms, Oracle Reports and J-Initiator

Traveled to Ford non-manufacturing sites gathering data to load into the new Oracle purchasing system.

Worked with controllers and financial analysts.

Created special files to add new users and create hierarchy approval chains.

Manually created and maintained hierarchy approval chains and users through production support.

Produced Oracle reports for the controllers.

Industry: Automotive – Ford Motor Company Jun 2001 to Jan 2002

Position: Team Leader/Trainer

Environment: Microsoft Windows 95/98

Tools: Oracle and J-Initiator

Trained area managers, superintendents and supervisors throughout North America on a new Occupational Health and Safety Investigation Module that related to property damage, human injuries and hazardous conditions.

Industry: Software Development – Compuware Corporation Apr 2000 to Mar 2001

Position: Installation and Assurance Technician

Environment: Microsoft Windows 98/NT

Tools: TrackRecord, BoundsChecker, SmartCheck, CodeReview, TrueCoverage, TrueTime, Jcheck and FailSafe

Trained customers on DevPartner tools, traveling to client sites for 1 to 5 day engagements.

Shadowed senior technicians to learn the installation and assurance techniques for clients requiring assistance and training.

Phillips Service Industries June 1998 to April 2000

Industry: Manufacturing

Position: Project Leader/Business Analyst

Environment: Microsoft Windows 98/NT and Mainframe

Tools: Oracle Forms 4.5, Oracle Reports 2.5 and Oracle 7

Developed and implemented a national in-house Repairable Asset Control (RAC) system designed to track

the status of critical production parts repair, inventory control, financial and warranty work from a COBOL Legacy system.

Utilized Oracle Tools and technologies to link RAC to the Oracle system for status reporting.

Gathered all requirements as a Business Analyst from the RAC Supervisors

Supported 10 RAC supervisors and 40 coordinators who provided services at the customer site.

Trained key RAC management and supervisors responsible for the delivery of services to customers such as General Motors Corporation, Ford Motor Company, Chrysler Corporation, American Axle and Phillip Morris.

Trained the sales organization.

Developed the appropriate system documentation, user manuals, and marketing brochures that described new system features.

Computer Methods Corporation April 1993 to June 1998

Industry: Consulting – Computer Methods Corporation Duration: 4 Years, 7 Months

Position: Group Leader/Trainer

Environment: MS Windows 95/NT

Tools: MicroFocus COBOL, XDB2, IMS, SPF/PC, Oracle Forms 4.5, Oracle Reports 2.5, Oracle 7

Developed and implemented an Educational Training Center for mainframe and client/server system development.

Recruited recent college graduates and taught mainframe and client/server languages.

Instructed COBOL and Oracle seminars.

Established a testing process for trainees.

Created all training manuals

Industry: Insurance – Blue Cross and Blue Shield Duration: 8 Months

Position: Programmer/Analyst

Environment: MS Windows 3.0, UNIX

Tools: COBOL II, Oracle Forms 3.0 and Oracle 7

Gathered program specifications and allocated programming resources.

Reviewed all coded programs prior to testing and reviewed test results.

Control Data Institute December 1989 to March 1993

Industry: Education

Position: Instructor

Environment: MS Windows 3.0, MS-DOS, CDC110

Tools: COBOL, MS DOS

Taught Problem-solving concepts, structured analysis and design, COBOL and Basic programming.

Conducted COBOL seminars to aid and support student class projects.

Created all training manuals

Industry: Education

Position: Programmer/Analyst

Environment: MS Windows 3.0

Tools: COBOL, DBASE IV

Maintained and modified Student Scheduling System.

Maintained the Student Management System.

Industry: Education

Position: Programmer/Analyst

Environment: MS Windows 3.0

Tools: COBOL, DBASE IV

Designed, developed and tested an in-house Financial aid System that recorded student information such as collected and outstanding tuition and other student loan information such as transcript records of previous schools and kept a mailing list.

Professional Education and Training

Education and Certifications

Oracle Developer 2000 Master Certificate

Control Data Institute – Programmer/Analyst

Instructor Led Training – SAS/PCSAS, Oracle Developer 2000 Suite, Oracle Forms 4.5, Oracle Forms 5.0, Oracle Reports 2.5, Oracle Reports 3.0, Oracle Alerts, SQL, PL/SQL, SQL*Plus, Visual Basic 4.0 Beginning, Visual Basic 4.0 Intermediate, VBScripting, Director 5.1 VBScripting and Introduction to JAVA.

Computer Based Training – Oracle Database Modeling, Oracle Database Warehousing, PowerCenter8 Quick Start for Informatica, Toad for Oracle, JAVA Programming for Beginners, Microsoft Word and Microsoft Excel.



Contact this candidate