Sales Project
Resume:
Julie McVicar
*****.*******@*******.***
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-***-****
*****.*******@*******.***
• 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-***-****
*****.*******@*******.***
• 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-***-****
*****.*******@*******.***
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