John Mccarty Email & Phone Number

Fairborn, Ohio, United States

• System Engineer for the Keystone (KDSS) / Command Management System (CMS) project, an Air Force Materiel Command data warehouse system using Agile software development practices• Acted as KDSS / CMS Information Systems Security Officer (ISSO). Responsibilities include overseeing project and user security, and writing system Security Technical Implementation Guides (STIGs)• Responsible for 100% of project SAP BusinessObjects Business Intelligence (BI) Platform design, development, and implementation• Designed and created SAP BusinessObjects universes using SAP Universe Design Tool and SAP Information Design Tool software• Designed and created SAP BusinessObjects reports using SAP Web Intelligence version 4.3• Designed and created SAP dashboards using SAP Lumira software• Designed and implemented IBM Planning Analytics (TM1) data cubes and web sheets for Keystone's Budget Development Tool (BDT) project, using IBM / Cognos TM1 software including TM1 Architect, TM1 Web and TM1 Perspectives• Composed and executed Oracle database SQL statements using Oracle SQL Developer and TOAD for Oracle software

Beavercreek, Ohio

• Senior Knowledge Management Developer for the Keystone (KDSS) / Command Management System (CMS) project, an Air Force Materiel Command data warehouse system using Agile software development practices• Responsible for 100% of project SAP BusinessObjects Business Intelligence (BI) Platform design, development, and implementation• Designed and created SAP BusinessObjects universes using SAP Universe Design Tool and SAP Information Design Tool software• Designed and created SAP BusinessObjects reports using SAP Web Intelligence version 4.3• Designed and created SAP dashboards using SAP Xcelsius, SAP Dashboards and SAP Lumira software• Coordinated and implemented successful migrations of multiple SAP BI platforms, from SAP BusinessObjects 6.5 through SAP BusinessObjects 4.3• Designed and implemented IBM Planning Analytics (TM1) data cubes and web sheets for Keystone's Budget Development Tool (BDT) project, using IBM / Cognos TM1 software including TM1 Architect, TM1 Web and TM1 Perspectives• Performed as backup support for daily and monthly data warehouse data loads using Informatica PowerCenter software• Assisted in the design and support of Oracle data warehouse tables• Completed Amazon Web Services (AWS) training and received multiple AWS certifications for future AWS cloud database services implementation• Composed and executed Oracle database SQL statements using Oracle SQL Developer and TOAD for Oracle software• Graduated from the CACI Emerging Leaders program• Member of the CACI Mentorship program

Gahanna, Ohio

• Designed and created SAP BusinessObjects 6.5 universes and reports for the Consumer Data Marketing Services (CDMS) data warehouse project• Designed and created ETL jobs using DataStage for CDMS data warehouse• Created UNIX scripts to execute DataStage jobs in a production batch environment• Designed and created MicroStrategy projects for CDMS data warehouse• Created MicroStrategy reports for sales projections, market analysis, and product analysis• Helped design data model for CDMS data warehouse using Informix database software

Cleveland, Ohio

• Designed, coded, and implemented programs for General Electric’s Global Financial Measurements System (GFMS) and System 4000 (Sales Incentives system) using COBOL and SAP BusinessObjects 5.6• Primary production support contact for GFMS and secondary support for System 4000• Helped design data warehouse tables using DB2 database software• Primary system support contact for General Electric - Lighting’s Legal department• Completed General Electric Six Sigma Green Belt training

Columbus, Ohio

• Designed, coded, and maintained project systems using COBOL programming and DB2 SQL• Designed, coded, and maintained customer correspondence system• Maintained Design/1 and Install/1 repositories• Maintained project codes tables• Coordinated and performed database releases• Performed project migrations• Primary system support contact for production migrations and production operations• Gave Design/1 and Install/1 training to new employees• Mentored new team employees

Athens, Ohio

• Supervised IBM PC computer lab• Assisted in Computer Science classes using Microsoft Office software package• Tutored students in Computer Science 120, Introduction to Computer Science

Brecksville, Ohio

• Served as a liaison between National City Bank and customers to ensure payment of loans• Responsible for 70-100 installment loans per day