Project Sales

Summary of Qualifications

. Skilled IT professional with over 10 years of experience

. Experienced in all phases of systems development life cycle

. Business Analyst for major projects at Ford Motor Company and R. L. Polk

. Test lead for major projects at Ford Motor Company and R. L. Polk

. Expertise in programming, systems analysis, development, re-engineering,

coding, support, documenting, testing, implementing

Technical Summary

Languages: C, Java, HTML, CSS, VB.net, COBOL, CICS, IMS, JCL

Operating Systems: Windows, MVS/TSO, Sun Solaris UNIX

Databases:

DB2, Oracle 10g, MS SQL Server, MS Access, IMS

Tools: Oracle Discoverer, ISPF, Toad, Visio, MS Office, Lotus Notes,

Outlook, JGrasp

Educational Summary

Wayne State University Detroit, MI

. Bachelors, Computer Science

Wayne State University Detroit, MI

Henry Ford Community College Dearborn, MI

. Additional classes in VB.NET, Visual Studio, JavaScript, Java, C, HTML,

CSS, XML, Website Design, Business and Systems Analysis

Experience

Henry Ford Community College Dearborn, MI

2009 - present

Student

. Used the slow economy as an opportunity to return to school and gain

additional Information Technology skills.

La-Z Boy Monroe, MI 2008

Developer (via TEK Systems)

. Wrote complex SQL/ETL (DB2 to MS SQL Server) queries to create

intelligent data used by management to analyze sales. Tested, and

implemented scripts into production utilizing SQL and stored procedures.

. Modified, tested, documented, implemented software for Financial Systems

(Account Receivables Purchase Order) utilizing COBOL, DB2.

. Gathered requirements, performed systems analysis, wrote technical design

for program modifications utilizing MS Visio.

. Designed test plans, test cases, UAT for projects and executed with user

participation for modified programs.

Blue Cross Blue Shield of Michigan Detroit, MI 2007 - 2008

Business/Programmer Analyst (via Computer Aid, Inc.)

. Analyzed, coded and tested modifications to Common Grouper System

utilizing COBOL, DB2.

. Wrote test scripts, SIT, UAT plans for DRG and Common Grouper. Created

test data.

. Participated in Service Level Agreements (SLA) meetings for ASC claims

system.

. Provided production support for ASC and External Pharmacy Claims system.

. Performed systems analysis on Diagnostic Related Group (DRG) project

- designed simple alternative to proposed solutions that had unnecessary

complexity.

. Wrote and presented high level functional requirements.

. Wrote detailed level functional requirements and Technical Design

document for DRG project.

. On team that performed data modeling: designed new DRG DB2 tables/

views. Assisted DBA with creation of views. Created test data and

tables.

. Estimated tasks, duration, deadlines for DRG project utilizing MS

Project.

DaimlerChrysler Auburn Hills, MI 2006

Business Analyst (via The Epitec Group, Inc)

. Wrote project charter for Global Purchasing System including project

scope, objectives.

. Analyzed, organized, project documents for Quality and Sarbanes-Oxley

(SOX) reviews.

R.L. Polk Company Southfield, MI 2002 - 2006

Business/Tester/Programmer Analyst

. Designed, coded, tested automotive intelligence reports using COBOL

Documented software utilizing Visio

. Lead Tester: wrote test plan for modified WEB based Commercial Vehicle

System. GUI screens were modified and tested for usability/stress.

Results of tests - R. L. Polk received fewer complaints; customers had a

better opinion of R. L. Polk team.

. Member of team that performed data modeling that created new Oracle

tables for After Market team.

Defined fields/formats, relationships between tables - primary/foreign

keys, indexes/constraints.

. Collaborated with Sales to develop new way to process catalog merge. New

product increased sales and revenue in department.

. Wrote training documentation for a variety of audiences. Trained

business customer, technical staff,

management on new process.

. Project coordinator for catalog project

. Processed XML to handle automotive part catalog for beta test.

. Wrote software documentation, training manuals and presented for

customer, technical staff, management.

Ford Motor Company Dearborn, MI 1998 - 2002

Business Analyst /Tester/Programmer (via The Epitec Group, Inc)

. Developed, coded, test, documented, implemented programs for Warranty

System utilizing COBOL, SQL, DB2, JCL

. Developed, coded, test, documented, implemented programs for MTM

System utilizing COBOL, SQL, DB2, JCL

. Facilitated business/systems analysis meetings for DRS (Direct

Replenishment Solution) project, a major rewrite of a Supply Management

system which resulted in a new process that saved Ford inventory cost and

time.

. Some resulting artifacts of business analysis meetings -

o High-level business requirements, present/ future states of

business, gap analysis, functional/non-functional

specifications, entity relationship diagram, sequence diagram,

context diagram, logical scope, decomposition tables.

. Wrote project charter including scope, deliverables, approach.

. Lead Tester for DRS2, the second phase of DRS.

. Designed test plan, test scripts, functional test, SIT, UAT

o Testing required collaboration/ interfaces with cross-functional

teams such as Purchasing, Ordering, Financial, Inventory,

Forecasting, vendors.

. Project Coordinator for DRS

. Analyst on Dealer System utilizing Business Objects, Teradata, Erwin.

Tracked and prioritized issues and repairs.

American Mutual Insurance Company Livonia, MI 1997 - 1998

Programmer Analyst (via Analyst International Corp)

. Wrote program specifications for Claims and Membership.

. Modified programs for Y2K project. Coded programs and performed

functional, regression, system, integrated testing utilizing COBOL, DB2.

. Performed production support. Resolved problems. Enhanced systems.

Contact this candidate