Candidates About

Frederick D. Gillespie 

Qualifications

 A highly experienced, flexible individual who requires minimal supervision, adapts quickly, possesses outstanding analytical, interpersonal, and communication skills, and meets deadlines.   Mr. Gillespie has an established track record of quickly learning new skills and assuming multiple roles in dynamic work environments.  His experience encompasses the entire software development lifecycle.

·         Systems/business analysis - data gathering; requirements collection, definition, analysis and documentation; data analysis; formal project planning; software tool and technology evaluation.

·         Programming and computer operations – analysis, design, coding, testing, documentation, user support, program management support, and release management.  Experienced in ETL development, Enterprise Data Warehouse (EDW), Oracle ERP and CMMI Level III environments. 

·         Business/Test analysis - preparation, execution and validation of test cases, procedures, and test plans based upon system requirements; identification and documentation of software defects. 

·         Documentation - composition of all lifecycle documents - development plans, system requirements, SOWs, turnover documents; conformation with MIL SPEC documentation standards (498 and 7935).

Languages:                    SAS, PCSAS, SQL, SQR, COBOL, PL/SQL, Pro C, HTML, UNIX shell scripting,  

                                        JCL, Assembler, PL/1, BASIC, FORTRAN, CA/DATAQUERY, ColdFusion.

Databases:                      SQLServer 2008, Teradata, Oracle 10g, CA-Datacom, Ingres, IMS, HPIMAGE.

Systems/environments: UNIX-AIX, Linux, SQLPLUS, MVS/XA, TSO/ISPF, ROSCOE, CICS/VS, VMS.

Computer hardware:    IBM 30XX, DEC VAX, HP3000, personal computers.

Tools:                              Data Integrator, Visio, Toad, HP ServiceCenter, Rational Clearquest, XPEDITER,

                                         FILE-AID, VMAN, ABENDAID, PANVALET, PowerPoint, Excel, ENDEVOR. 

Education and Certification

Education:       Bachelor of Science in Applied Science - Systems Analysis, Miami University, Ohio

Certification:  IT Infrastructure Library (ITIL) V3 Foundation Certification

Training:         Informatica (2010), Java (1999), C++ (1998)

Professional experience

Caresource Management Group Inc, Dayton, Ohio  August 2011 – Present     ETL Data Analyst

      As an ETL Data Analyst at Caresource – a major non-profit public-sector managed health-care company - is a key player in the migration of an existing SQLServer Facets database to a new Teradata Enterprise Data Warehouse. 

• Designs, documents, constructs and executes ETL software (Pervasive Data Integrator) to perform extraction and transformation of data from Facets and varied other source formats for load to the Teradata EDW; Serves as SME resource in use of tool and associated extraction.
• Provides mentoring to less-experienced team members in the use of the ETL tool.

Environment: Pervasive Data Integrator (9 and 10), SQL, Base and Macro SAS,  SQLServer 2008, SQLServer Management Studio (SSMS), Teradata SQL Assistant, XML.     

Frederick D. Gillespie (continued)

Wellpoint, Inc. (Anthem), Mason, Ohio,   June 2007 – July 2011   Senior Developer

      Wellpoint is the leading health plan in the U.S. and the largest member of the Blue Cross/Blue Shield Association.  As a Senior Developer, worked in Eligibility Reconciliation for  Med D; Proserv Claims Reporting; and Served as a Business Systems analyst for Benefit Builder.

• Performed ETL software development functions, including analysis, design, coding, documentation and testing of software for mainframe and client/server platforms;
• Designed and coded ad hoc reporting software in PC-SAS and mainframe SAS platforms;
• Served in Pre-Screening role, verifying SOX compliance in software turnover;
• Served in business analysis support role - composed requirements and turnover Documents, Test and Implementation plans, and approach documents. Interacted extensively with user community.

Environment:  SAS, PCSAS, UNIX, MVS, SQL, Oracle 10g, JCL, TSO, COBOL, Windows Server.

Miami University, Oxford, Ohio,   March 2006 – June 2007   Applications Analyst

      Miami University is a mid-sized public university in the state of Ohio.  As an applications analyst:

• Supported academic software, primarily the Banner academic ERP system.  Developed and maintained SQL scripts for Oracle database, composed Unix shell scripts, and developed academic support software in PL/SQL, Pro C, ColdFusion, and SQR.
• Interacted extensively with users to insure requirements were met.  Composed requirements and specifications documentation for new development.

Environment:  SQL, PL/SQL, SQR, Brio, UNIX-AIX, Oracle 10g, COBOL, Pro C, ColdFusion.

JXT Applications, Inc., Beavercreek, Ohio   June 2004 - August 2005   Sr. Software Engineer

      The C2I (Command and Control Interface) system was a client/server prototype intended to enhance coordination between members working in virtual teams.  As a senior software engineer:           

• Completed hardware/software requirements analysis and software tool evaluation, drafted project Requirements Specification documentation, and evaluated Integrated Development Environments (IDEs) for use in the project. Prototyped user interfaces using the Borland JBuilder IDE.

Environment:  Linux, SQL, Java j2EE, JBuilder, XML, Firebird.

Northrop Grumman Corp., Dayton, Ohio   November 2000 – September 2003   Sr. Technical Analyst

The Requirements Management System (RMS) is a U.S. Air Force mainframe application which tracks equipment inventory at each AFMC (Air Force Materials Command) and determines current and future needs for each.  As a senior technical analyst:

• Interacted extensively with users to insure requirements were met.  Excelled at requirements analysis and documentation, system design and documentation, coding and test analysis.  
• Served as system test analyst as needed - composed test plans and tested software modules.
• Shared technical lead duties on a rotational basis, relieved group manager of administrative duties, and ensured that team members complied with programming and documentation standards.
• Prepared technical reports and related documentation.  Performed presentations as required.

Environment:  IBM MVS/XA, COBOL, ROSCOE, CICS, JCL, CA-Datacom.

AT&T, Cincinnati, Ohio   May 1997 – November 2000   Technical Staff Member

The Trunk Integrated Record Keeping System (TIRKS) is a mainframe circuit provisioning system which tracks telephone trunk circuit availability. As a technical staff member:

• Designed, coded, maintained and tested TIRKS mainframe computer software modules. 
• Served as Release Manager.  Coordinated development tasks, scheduled release of new versions of TIRKS to production environment, and maintained Release Management web site.
• Served as system test analyst as needed - composed test plans and tested software modules.

Environment:  IBM MVS/XA, Assembler, COBOL, PL/1, HTML, TSO/ISPF, IMS, JCL,

                          MQSeries, File-Aid, Xpediter, SAS.

Frederick D. Gillespie (continued)

Battelle Memorial Institute, Dayton, Ohio   January 1991 – May 1997   Sr. Systems Analyst

As a senior systems analyst, participated in multiple Department of Defense programs  including the Central Procurement Accounting System (CPAS), Requirements Data Bank (RDB), and Stock Control System (SCS).

• Demonstrated superior skills in full development lifecycle tasks, including business and system requirements analysis and documentation, translation of requirements into code specifications, programming, maintenance, and documentation of complex large-scale U.S. Air Force logistics and financial software systems.
• Provided direct user, production and computer operations support to government personnel.
• Provided direct senior-level program management technical and acquisition support to the Joint Logistics Systems Center (JLSC) in the Defense Enterprise Integration Services (DEIS) I project. 

Environment:  IBM MVS/XA, COBOL, ROSCOE, CICS, CA-Datacom, JCL, PANVALET.

Cimspec, Inc.  Middletown, Ohio   June 1990 – October 1990

As a contract programmer, was assigned to Lehr Precision, Inc.

• Programmed inventory control and payroll software using the Cognos PowerHouse 4GL tool set.

Environment:  DEC VAX 3600, VAX VMS, Cognos PowerHouse 4GL.

Kelly Services, Inc.  Cincinnati, Ohio   June 1989 – June 1990

As a contract programmer, was assigned to Siemens Energy and Automation, Inc. 

• Collected, refined and documented business and system requirements for an order inquiry system for the in-house marketing team.
• Designed, coded and tested the order/inquiry system using the INGRES 4GL tool set.
• Co-designed, created, and administered the database for the order/inquiry system.
• Successfully implemented new software development tools while concurrently developing the order/inquiry system in those tools. Converted existing software to the new tools.

Environment:  DEC Micro VAX, Ingres 4GL, SQL, Ingres RDBMS, FORTRAN, VMS, FMS.

Western and Southern Life Ins. Co.  Cincinnati, Ohio   July 1987 – December 1989

Sales and service of life and health insurance accounts.  Also licensed for property/casualty lines.

Armco Steel, Inc.  Middletown, Ohio   August 1985 – July 1987

As a programmer/analyst on a small staff in the Research division, performed multiple duties in support of a 200+ member user community:

• Collected, refined and documented business and system requirements for a Purchase Order System and Machine Shop Task Tracking System.
• Designed, coded, tested and implemented the Purchase Order System using PowerHouse 4GL.  Designed, implemented and administered the database for the system.
• Provided user training for the Purchase Order System, successfully converting the user community from the decades-old "carbon copy and typewriter" methodology to a new, entirely on-line system.
• Designed, coded, tested and implemented the Machine Shop Task Tracking system using the PowerHouse 4GL.  Designed and implemented its database.
• Provided in-house user support and help desk functions.
• Successfully completed the office automation project, installing personal computer systems while implementing a PC-host environment. 
• Shared system administration duties in Unix and MPE environments.

Environment:  HP 3000, HP 9000, MPE V, FORTRAN IV, HP IMAGE DBMS, HPQUERY, 

                          Cognos PowerHouse 4GL (QUICK, QUIZ, QTP).

Frederick D. Gillespie (continued)

Science Applications International Corp.  Dayton, Ohio   April 1984 – August 1985

As a scientific programmer/analyst with SAIC Performed analysis, design, coding and test of simulation software, modeling air-to-air missile defense systems. 

Environment:  DEC VAX 11/780, VAX VMS, FORTRAN-77.

Financial Planning Consultants, Inc.  Middletown, Ohio   March 1983 – April 1984

As a programmer, worked exclusively on  proprietary financial planning software applications.

Environment:   Micromation Mariner PC, IBM PC, BASIC, DOS, MP/M.

Harrison Radiator, Inc.  Dayton, Ohio   March 1982 – September 1982

As an entry-level temporary employee, participated in coding engineering applications software.

Environment:   DEC PDP-11, RSX11-M, FORTRAN, BASIC.