Sales Project

Julie McVicar

248-***-****

abzmk5@r.postjobfree.com

EXPERIENCE SUMMARY:

• Perform in the following Information Technology positions such as a 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),

• Performed extensive coding, testing, and implementing of projects and systems

• Created documentation (including business, technical and functional specifications, use cases, project

charters, process flow charts, user manuals and system operations manuals)

• Created and conducted user and student training (including individual, small group and classroom).

• Supported many industries such as the automotive industry in the sales and marketing, order entry,

warranty, advertising, accounting, and finance departments for GM, Ford, Chrysler, VW, Mazda;

telecommunications industry in the billing system; the insurance industry in the life insurance system; the

healthcare industry for a pharmacy benefit management company, and computer integration in the

operating systems and utilities.

• Provide technical expertise on mainframe systems using such software as DB2, COBOL, and IMS

DB/DC; provide technical expertise on client/server using such software as UNIX, Oracle, Java, Perl, and

C/C++; provide technical expertise on business intelligence software such as Tableau and Qlikview.

• Supported systems internationally in Netherlands 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 SUMMARY:

Certifications: UNIX, C, MCDST, A+, Network+, HDA, CSS

Hardware: IBM 3090, PC, Unisys A series

Languages: COBOL II, HTML, XML, CGI/Perl Script, C/C++, JAVA, J2EE, ASSEMBLER,

Operating Systems: OS/390, MVS, UNIX, Windows, MCP

Databases: ORACLE, DB2 (QMF and SQL), SQL Server, IMS DB/DC (MFS), VSAM

Communications: CICS

Utilities: File-Aid, Abend-Aid, Expediter

Methodologies: Object Oriented (UML), System Development Life Cycle

Business Intelligence Tools: Cognos, Tableau, Qlikview

Ancillary Software: Microsoft Office Suite, Vi, Ed, PL/SQL, MS Visio, MS Project, DataDirect

Shadow and Shadow Studio, TSO, ISPF, JCL, CA7, CA11, Caliber

SOFT SKILLS SUMMARY:

Industries: Automotive, Telecommunications, Insurance, System Integration, Healthcare

(pharmacy)

Functions: Programmer/Analyst, Business Analyst, Trainer/Mentor, Team Lead, Manager

Applications: Sales and Marketing, Warranty, Order Entry, Advertising, Accounting/Finance, Life

Insurance, Billing, Operating Systems

EDUCATION:

Master of Business Administration, Finance, Saginaw Valley State College (1987)

Bachelor of Science, Data Processing, Saginaw Valley State College (1979)

PROFESSIONAL EXPERIENCE:

General Motors, Detroit, MI 08/12 - Present

Data Analyst Engineer

• Design and develop a data warehouse using the identity management database as a base for the Identity

Management Data Quality team

• Work as a database administrator in training while managing and maintaining the internal identity

management data quality database

• Work with Tableau to create a weekly dashboard of areas of concern or interest within the group

• Perform cleansing and data analysis with MS Excel and MS Access using complex functions, macros and

some VBA coding

• Technical environment is Tableau, Oracle, MS Excel, MS Access, PL/SQL

Strategic Staffing Solutions, Detroit,MI 04/12 – 08/12

Business Analyst at Blue Cross Blue Shield of Michigan

•Worked on creation of business use cases and preliminary test cases for the the Servicing business

requirements in regards to the Patient Protection and Affordable Care Act (PPACA) project

• Attended customer meetings to obtain project information and help in understanding process and

requirements in the creation of the business requirements documentation

• Technical environment is MS Project, MS Word, MS Visio

Capgemini, Southfield, MI 02/11 – 02/12

Senior Consultant

• 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

• 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

• Worked on the NGSR system as the report lead for the first iteration of construct to close; assist in the

generation of metadata, ETL, and reporting using COGNOS BI Tools

• Technical environment is UNIX, Oracle, COGNOS, Tableau, Qlikview, MS Project, MS Visio.

GalaxE Solutions, Detroit, MI 11/10 – 02/11

Sr. Business Analyst

• 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 use cases, business and functional requirements documents and then presented these documents to

the customer for approval.

• Acted as a liaison between the business and technical staff in order to help with technical requirements and

specifications.

• Aided the technical staff in the writing of technical specifications

• Technical environment is IBM mainframe, AS 400, COBOL, IMS, DB2, MS Project, MS Visio.

Aquent Corporation, Southfield, MI 5/10 – 11/10

Business Data Analyst

• Supported the Vehicle Sales North America (VSNA) and North America Sales Reporting (NASR) systems for

GM Vehicle Sales, Service and Marketing division by acting as a liaison between GM business team, GM IT,

and Capgemini technical team.

• Performed tasks required to report monthly sales using Cognos, internal tool, and MS Excel (with macros

and functions)

• Wrote ad hoc reports for field and corporate staff using Cognos BI tool

Julie McVicar 248-***-****

abzmk5@r.postjobfree.com

• Wrote testing specification documentation for the Geographical Objectives project

• Tested system related changes to VSNA and NASR

• Created operations documentation for the Business Data Analyst position

• Worked on updating the Sharepoint site with current systems documentation and data load files

• Technical environment is UNIX, PowerBuilder, Oracle, PL/SQL, COGNOS, MicroStrategy, InfoBuilder, MS

Excel and Windows 7 and XP.

Progress Software, Inc, Bedford, MA

Senior Solutions Consultant 05/08 – 02/10

• Performed the installation and proof of concepts (POCs) at perspective customers using Progress® Shadow

and Shadow Studio resulting in four customers signing agreements to purchase software for $1M

• Performed professional services including programming with Shadow, Java and .NET and mentoring at

customers using Progress® Shadow and Shadow Studio for six customers for $750K

• Technical environment is IBM 3090, COBOL, VSAM, DB2, CICS, IMS, JCL, Visual Studio .NET, Java,

Shadow, Shadow Studio and Windows XP.

Capgemini, Southfield, MI 11/06 – 05/08

Senior Business Analyst

• Supported the Vehicle Sales North America (VSNA) and North America Sales Reporting (NASR) systems for

GM Vehicle Sales, Service and Marketing division by acting as liaison between the GM customer, GM IT and

Capgemini team

• Wrote project specifications based on client requirements, including business requirements, use cases and

test cases; tested and implemented system changes

• Trained client on changes as needed

• Worked with Oracle DBA to enhance the performance of the database and system response

• Supported extracting of data from the mainframe using COBOL, JCL, and DB2

• Supported the loading and reporting of data using UNIX, PowerBuilder, Oracle, and PL/SQL

• Completed data models of the Oracle data of VSNA and NASR using Visio

• Constructed ETL for data mapping/mining using Cognos and Oracle

• Led a team of four offshore developers

• Technical environment is UNIX, PowerBuilder, Oracle, PL/SQL, COGNOS, IBM 3090, COBOL, VSAM, DB2,

JCL and Windows XP.

Techni-Serve. Inc, Troy, MI 07/06 – 11/06

Business Analyst

• Supported the cemetery and property management systems by meeting with clients

• Wrote business and technical specifications based on client requirements

• Programmed, tested and implemented client changes

• Trained client on changes as needed

• Technical environment is MS Access, UNIX, MS SQL, VB6, VBA, COBOL, and Windows XP.

Acutech Resources, Flint, MI 05/06 – 07/06

Systems Analyst

Assigned to GM Service and Part Organization

• Created and implemented global parts list system which allowed global dealers to have high volume parts

available more readily for repairs (MS Access, VBA based)

• Extracted data from the IBM mainframe using Java based program

• Technical environment was MS Access, VBA, VB6, Windows XP, and IBM mainframe.

Express Personnel, Shelby Township, MI 11/05 – 04/06

Analyst

Assigned to SKF-TCM

• Supported the Accounts Payable and Accounts Receivable system

3

• Provided support by designing, programming and implementing the maintenance request which prevented

costly repairs of equipment system (MS Access, VBA based).

• Technical environment was MS Access, MS Excel, VBA, and Windows XP.

Cook Systems, Memphis, TN 09/05 – 10/05

Programmer/Analyst

Assigned to Commonwealth of Kentucky, Commonwealth of Technology

Tax Modernization Project

• Provided project support for the Individual Income Tax System by meeting with client/customer

• Wrote business and technical specifications based on information gathered

• Programmed, tested and implemented changes; and trained customer on changes

• Technical environment was COBOL II, IMS, TELON, DB2, SQL, and JCL on an IBM mainframe.

Vastera Incorporated, Dulles, VA 05/04 – 12/04

Senior Systems Analyst/Team Lead

• Provided support for the TradeSphere Importer system by meeting with customers

• Wrote UML based specifications passed to development team

• Tested the changes from development team

• Trained customer on changes; implemented additional sections of TradeSphere Importer software as

required by customers’ needs.

• Technical environment was Java and XML.

Oakland University, Rochester, MI 09/02 – 04/06

Instructor

• Taught Object Oriented Systems Analysis and Design using UML VISIO, MS Access, Java and C++ on a

part time basis.

• Technical environment was Java, C++, MS Project, MS Visio, MS Access and Oracle.

Oakland Community College, Auburn Hills, MI 01/01 – 01/04

Technical Lead Support Analyst

• Taught Database Design Processing using Visio for data modeling using VISIO, Oracle, MySQL, and

MSAccess

• Taught Object Oriented Systems Analysis and Design using UML, VISIO

• Taught Java I, Microsoft Office Suite, and Introduction to Computers classes

• Resolved computer and network related problems encountered by students in the lab as well as assisted in

their understanding of the computers and its applications

• Led a team of 5 student assistants

• Technical environment was Windows NT, Windows XP, Java, C/C++, Visual Basic, Perl, HTML, FrontPage,

MS Office XP, and ORACLE.

Computer and Engineering Systems, Rochester, MI 05/99 – 08/99

Senior Systems Programmer/Team Lead

Assigned to Daimler Chrysler

Depot Code Expansion Project

• Provided support by reviewing all programs used by client/customer

• Wrote technical and functional specifications passed to development team

• Technical environment was COBOL, DB2/Stored Procedures, IMS DB/DC, TSO/ISPF, JCL, and

CICS on IBM mainframe.

CDI, Troy, MI 05/98 – 02/99

Senior Programmer/Analyst

Assigned to Ford Motor Credit

Red Carpet Lease System

Julie McVicar 248-***-****

abzmk5@r.postjobfree.com

• Provided support for the Red Carpet Lease by meeting with client/customer

• Wrote business, technical and functional specifications

• Programmed, tested and implemented changes

• Trained client/customer on changes

• Technical environment was COBOL II, IDMS, GTFM, DB2/Stored Procedures, SQL, and JCL on

an IBM mainframe.

Perot Systems, Auburn Hills, MI 11/95 – 05/98

Specialist/Business Team Lead at Volkswagen

Warranty System Rewrite Project

• Provided the use case analysis and design (UML) specifications

• Aided in the creation of the data modeling, data warehouse, and object model designs using

ORACLE and Data Architect for California Air Resource Board (CARB) subsystem as well as the Warranty

Information Network System rewrite

• Met with client/customer to help gather requirements

• Created and loaded database with customer production data using Oracle PL/SQL

• Tested programs and system when programmers completed the changes

• Led a team of 2 business analysts and 15 programmers

• Technical environment was ORACLE, Rational Rose, PL/SQL, JAVA, CORBA, and C/C++ on a

DEC Alpha Server.

Analyst

Warranty Systems for Volkswagen

• Provided analysis and proposal for the Warranty system implementation in Mexico which was

$3M

• Provided analysis, design, programming, testing and implementation support for the CARB

reporting system

• Provided support to Warranty Information System by meeting with client/customer

• Wrote business, technical and functional specifications

• Programmed, tested, and implemented changes

• Trained client/customer on changes

• Technical environment was COBOL II, IMS DB/DC, DB2/Stored Procedures, SQL, JCL,

Procedures and CICS on an IBM mainframe.

Alexander Hamilton Life Insurance, Farmington Hills, MI 05/94 – 11/95

Systems Analyst

• Provided maintenance support for the LIFE COMM system by meeting with client/customer

• Wrote business, technical and functional specifications

• Programmed, tested and implemented changes to LIFECOMM system

• Extracted data and produced reports using SAS and QUIKJOB

• Trained client/customer on changes

• Technical environment was ASSEMBLER, COBOL II, JCL, DB2, SQL, SAS, QUIKJOB,

Procedures and CICS on an IBM mainframe.

Various Consulting Companies 06/93 – 05/94

Programmer/Analyst

• At Ford Motor Company in the Body and Assembly General Offices, designed, coded, tested, and

implemented portions of the Convert 6 to 12 car lines project using COBOL II, IMS DB/DC and DB2 and in

the Sales and Marketing area, analyzed and designed the Dealer News Bulletin.

• At Alexander Hamilton Life Insurance, coded, tested and implemented year-end report changes and

analyzed a cash disbursement problem.

• At Mazda Corporation, coded, tested, and implemented the batch portion of the Ship to Europe project using

IMS DB and COBOL II.

5

• At Chrysler Corporation analyzed and designed the forecasting release of parts subsystem for the Parts

Group.

• Technical environment for all these positions was IBM 3090 using COBOL II, IMS DB/DC, SQL, and DB2.

Julie McVicar 248-***-****

abzmk5@r.postjobfree.com

Electronic Data Systems, Plano, TX 09/89 – 06/93

Systems Engineer/Team Lead

General Motor Dealer Information Database (GMDID) System

• Provided team leader and production maintenance support for the General Motor customer on GMDID and

DNPS Dealer Network Planning System) systems by meeting with client/customer

• Wrote business and technical specifications

• Tested, and implemented changes; Trained client/customer on changes

• Led a team of 2 systems engineers

• Technical environment was TELON, COBOL II, QMF, and DB2 on IBM mainframe

Chevrolet Preference Systems

• Provided programmer/analyst by meeting with customer/client

• Wrote business and technical specifications

• Used SAS to extract data for reporting purposes

• Tested, and implemented changes; Trained client/customer on changes

• Led a team of 4 systems engineers

• Technical environment was IBM 3090 using COBOL, IMS DB/DC, SAS, and PL/I on IBM mainframe.

7

Contact this candidate