SUMMARY:

• A highly experienced, flexible individual who requires minimal supervision, adapts quickly, possesses outstanding analytical, interpersonal, and communication skills, and meets deadlines.
• Confidential 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; software tool and technology evaluation; preparation, execution and validation of test cases, procedures, and test plans based upon system requirements; identification and documentation of software defects. IT Infrastructure Library (ITIL) V3 Foundation Certified.
• Programming and computer operations - analysis, design, coding, testing, documentation, user support, and program management support.
• Experienced in ETL development, Enterprise Data Warehouse (EDW), Oracle ERP and CMMI Level III environments.
• Confidential has in-depth experience in the Pervasive/Actian Data Integrator V9 /DataConnect V10 Tool sets.
• Documentation - composition of all lifecycle documents - development plans, system requirements, SOWs, turnover documents; conformation with MIL SPEC documentation standards (498 and 7935).

TECHNICAL SKILLS:

Languages: SAS, PCSAS, SQL, SQR, COBOL, PL/SQL, Pro C, HTML, UNIX shell scriptingJCL, 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, VMSIBM 30XX, DEC VAX, HP3000, personal computers.

Tools: Informatica, Pervasive Data Integrator, Visio, Toad, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential, Mason, Ohio

Senior Developer

Responsibilities:

• Designs, documents, constructs and executes EDI software (Informatica, Pervasive Data Integrator, and Actian DataConnect V10) to perform extraction and transformation of data from the Oracle database to build data feeds for distribution to various clients; Serves as SME resource for the Pervasive/Actian tools. Provides Actian Dataconnect server administration as needed.
• Provides mentoring to less-experienced team members in the use of the Pervasive Data Integrator/Actian dataconnect V10 tool.
• Composes UNIX and DOS scripts as needed.

Environment: Informatica, Actian DataConnect V10.4, Pervasive Data Integrator (9), SQL, Oracle 11g, SQL Developer, UNIX, XML.

Confidential, Dayton, Ohio

ETL Data Analyst

Responsibilities:

• Designed, developed and executed 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; Served as SME resource in use of tool and associated extraction.
• Provided mentoring to less-experienced team members in the use of the ETL tool.
• Maintained associated BASE and MACRO SAS software as needed.

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

Confidential, Mason, Ohio

Senior Developer/Reporting Analyst

Responsibilities:

• Designed, developed, documented, and tested data feeds, periodic reports, and ad hoc reports for mainframe and client/server platforms, primarily using mainframe SAS and PC-SAS;
• Occasionally served as technical business systems analyst in a utility role - composed requirements and turnover documents, Test and Implementation plans, and approach documents. Performed QA testing. Interacted extensively with user community in this role;
• Served in Pre-Screening role, verifying SOX compliance in software turnover.

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

Confidential, Oxford, Ohio

Applications Analyst

Responsibilities:

• 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, MicroFocus COBOL, 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, Beavercreek, Ohio

Sr. Software Engineer

Responsibilities:

• 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, Dayton, Ohio

Sr. Technical Analyst

Responsibilities:

• Interacted extensively with users to insure requirements were met. Excelled Confidential 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, Cincinnati, Ohio

Technical Staff Member

Responsibilities:

• 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, JCLMQSeries, File-Aid, Xpediter, SAS.

Confidential, Dayton, Ohio

Sr. Systems Analyst

Responsibilities:

• 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.
• Programmed inventory control and payroll software using the Cognos PowerHouse 4GL tool set.

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