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.

Professional experience

Confidential 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.

Confidential

• 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.

Confidential 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.

Confidential 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.

Confidential 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.

Confidential 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.