Richard L. Keating

aduds3@r.postjobfree.com 302-***-**** Middletown, DE

linkedin.com/in/richkeating

Consummate professional possessing excellent communication skills & an exceptional ability to deliver solutions.

Core Competencies

Business Analysis System Design Software Development

Clearance

Active TOP SECRET (TS)/Sensitive Compartmented Information (SCI)

Education

BS Professional Aeronautics, Wilmington University, Dover Delaware

AAS Information Technology, Delaware Technical & Community College, Wilmington Delaware

AAS Transportation, Community College of the Air Force, Maxwell AFB - Gunter Annex, Alabama

Certifications

Project Management Professional (PMP), Project Management Institute (PMI)

Project Management, University of Delaware, Newark Delaware

Webmaster Certified, University of Delaware, Newark Delaware

Professional Scrum Master, Scrum.org

CompTIA Security+, DOD IAT Level II

ITILv4, PeopleCert.org

Professional Experience

GDIT, Program Manager, March 2021 – Present

Providing program management and oversite for the Business Application Sustainment and Support (BAS2) program supporting the Communications-Electronics Command (CECOM), Software Engineering Center (SEC) customer applications and outside organizations including Army Materiel Command (AMC), Department of the Army (DA), Department of Defense (DoD) and other Government agencies.

Perform management and oversite for thirty-three-million-dollar task order and twenty-five employees, ensuring delivery of all deliverables and adherence to contract framework.

Responsible for planning, coordinating, and directing the activities of administrative, program control, and technical personnel involved in providing services in fulfillment of the contract.

Exercise understanding and experience with Department of Defense (DOD)/Army plans, policies, standards, acquisition methods, support of software and computer resources for Army systems and the complete military software lifecycle.

Managing and controlling schedules and costs to provide on time, within budget, performance of all aspects of the contractual effort.

Providing direction for operations and ensuring compliance with all management policies, plans, and procedures.

Delivering recommendations for resolution of technical problems.

Acknowledged role model to subordinate employees, providing mentorship, workforce motivation, and constructive criticism.

GDIT, Senior Software Developer, February 2020 – March 2021

Provided analytical support for the sustainment of business applications within Communications-Electronics Command (CECOM), Software Engineering Center (SEC) customer applications and outside organizations including Army Materiel Command (AMC), Department of the Army (DA), Department of Defense (DoD) and other Government agencies.

Performed design and development of SEC Licensing web application and its integration into the Financial Management Information Systems (FMIS) solution.

Acknowledged subject matter expert (SME), Interfacing with the customers, internal development teams, business units as well as third party contractors, ensured work progressed, within scope, quality standards and on time.

Lead meetings and workshops with stakeholders to evaluate business rules, identified and validated new business requirements, system interdependencies, cross-functional dependencies and potential risks involved with developing a new software licensing system.

Leveraged Agile Scrum framework articulating complex interdependent business requirements into clear concise user stories, ensured acceptance criteria could be readily translated into automated test cases.

Ensured all Scrum rituals were scheduled and performed, helped customers, development teams, business units and contractors understand the Scrum process.

CGI Federal, Senior Business Consultant/Scrum Master, August 2019 – February 2020

Facilitated workshops for the redesign of CMS’s (Centers for Medicare and Medicaid Services) PECOS (Provider Enrollment Chain, and Ownership System) database.

Senior Business Consultant and Scrum Master for the Data Modeling Team, responsible for the design and development of a new data model.

Responsible for team adherence to SCRUM process, ensuring all rituals were performed and artifacts were created and delivered.

CyberData Technologies, Inc., Software Developer/Database Administrator, November 2018 – August 2019

Subject matter expert responsible for operation, maintenance and troubleshooting of the Defense Health Agency’s (DHA) Navy Bloodborne Infection Management Center’s (NBIMC) HIV Management Services (HMS) eAccess website and operational data store (ODS) storing and reporting HIV and retroviral test results.

Performed SQL Server Database administration activities inclusive of design, data modeling, installation, configuration, backup, restoration, migration, and performance monitoring ensuring 100% system availability of mission essential naval readiness system.

Daily review of SQL Server event logs, investigating and reporting all issues to client, detailing event and resolution in error tracking system providing reference information for rapid remediation of future reoccurrences.

Performed all levels of data research, analysis, and data quality oversight.

Analyzed data from multiple sources, evaluating quality and recommending improvements.

Performed daily analysis and reporting in direct of support business operations.

Translated data into business intelligence in support of decision-making.

Designed business rules to minimize erroneous data and replication within the databases.

Developed and implemented custom SQL Server reports as needed.

Maintained processes for data file transfers to and from system.

Assessed data models and made recommendations for adjustment to support new initiatives.

Installed OS service packs, SQL Server service packs, hot fixes, and security patches delivering system to a state of readiness, achieving a mandated ATO (Authorization to Operate) designation.

Maintained HMS eAccess website and custom reports utilizing MS SSRS, ASP, JavaScript, VB 6.0 and C++.

Maintained, Updated and Modified the NBIMC HMS private website.

Maintained and implemented system change requests approved by NBIMC.

Performed installation, maintenance and troubleshooting of HMS web architectural software updates.

Maintained operational functionality and troubleshooting issues on legacy Data Load System

Reviewed and updated existing requirements, changes, or corrections weekly; as evaluated against actual operational performance logs, reports, and system enhancements.

Implemented features to return HIV results to submitting activities.

Ensured system interoperability with all authorized bi-directional interface systems.

CGI, Senior Business Consultant, October 2017 – November 2018

Led workshops, authored Migration Plans, Data Mappings, Data Quality Assessments, and Data Conversion Summary Reports. Ensured migrations met relevant corporate, regulatory, compliance and GxP guidelines.

Managed multiple pharmaceutical projects ensuring migration of critical Regulatory Content and Quality Documentation from legacy FirstDoc/Documentum to the Veeva Vault platform, leveraged extensive industry experience to minimize delays and maximize efficiency.

Completed comprehensive data analysis, evaluating the quality of client data, and assessing associated meta-data for viability the new document repository.

Created detailed reporting on all data analytics for project management and the migration team.

Gathered, refined, and validated complex business requirements, interdependencies, cross-functional dependencies and potential risks and issues.

Interfaced with internal teams/developers, clients (other internal business units as well as third party development teams), ensuring work was completed on time, within scope, and quality standards.

Assisted in process design/redesign, authoring business/functional requirements documentation.

Acrometis, Senior Business Analyst/Software Engineer, October 2015 – October 2017

Senior Business Analyst

Collaborates with end users, business teams, and Information System teams in all stages of project life cycle including discovery, design, construction, transition, implementation, and support.

Designed and developed business analysis documents to be utilized as the artifact templates for the new corporate SDLC.

Implemented the use of Agile methodologies user stories articulating requirements in a clear concise manner facilitated 25% reduction test cases.

Met with offsite clients, authored functional requirements & detailed design specifications for essential client ETL data integrations.

Led business analysis on critical redesign of legacy claim analysis system, rapidly & fully defined all requirements. Analysis consistently completed ahead of schedule averaging a 20% schedule gain.

Authored functional requirements for ClaimExpert adhering to the corporate technology roadmap for compatibility with Acrometis’s standard PC image eliminating proprietary technologies to ensure availability of qualified staff onsite.

Lead execution of UAT testing programs, led daily status meeting with stakeholders directly improving communication & impelling defect turnaround in less than 12 hours

Software Engineer

Designs, develops, implements new development and updates to ClaimExpert, a client facing Website and MS SQL Server database solution containing 10K+ rules for evaluating medical claims.

Developed enhancements to Websites, utilizing C#, ASP.NET, SQL Server, HTML5, and JavaScript.

Partnered with stakeholders in product design, defined requirements and authored required System Life Cycle (SLC) artifacts, resulting in faster deployments with minimal rework.

Evaluated current operational state of host environment and recommended remediation steps to mitigate vulnerabilities and manage cyber risk resulting in new vendor selection for hosting applications.

Designed and implemented all client reporting and XML data file extracts utilizing MS SSRS, removing the need for custom application development.

AstraZeneca, Technical Project Manager, December 2014 – May 2015

Provides project, resource, and budget management for the decommissioning and archival of validated, GxP, and clinical data from the acquisition of Amylin Pharmaceutical, ensuring retention and legal hold policies are accommodated. Establishes a communication plan for sharing the assessment approach and migration methodology with stakeholders.

Authored project charter, data assessment, migration methodology, and schedules, ensuring all project artifacts are complete, approved and loaded to teams SharePoint Site.

Point of control for all project communications, maintain accessibility, fielding questions, and reducing user anxiety, allowing for a smooth archival.

CACI, Lead Business Systems Analyst, October 2014 – May 2015

Lead business systems analyst for the reengineering of the Secretariat Automated Resource Management Information System (SARMIS). The Department of the Navy, Assistant for Administration (DON/AA) legacy system for annual budget formulation, execution and reporting and triannual review processing.

Performing the DoD Business Process Reengineering (BPR) analysis & reporting, required for approving projects when funds exceed $1 million.

Mapping existing “As-Is & To-Be” processes using Business Process Model and Notation (BPMN) and Universal Markup Language (UML).

Generating supporting viewpoints using the department of Defense Architecture Framework (DoDAF) Six step process.

Lead and support functional requirements elicitation sessions and solution meetings with stakeholders and subject matter experts (SME).

Coordinated and supported high visibility client facing conferences and meetings between the Pentagon staff and remote stakeholders.

Translated complex and interdependent business needs into clear, concise, and testable business requirements.

Created swim-lane diagrams and other process documentation to visually interact with a diverse customer base composed of executives, managers, and subject matter experts from multiple government communities.

Astellas Pharmaceutical, Senior Business Analyst, April 2014 – October 2014

Business analyst supporting the Model N Revenue Management Enterprise team.

Authored functional requirements and detail design specifications for Cognos metrics reports, replacing legacy reporting, significantly enhancing business intelligence and operational reporting.

Coordinated reporting across business areas, utilized data analytics to extract, categorize, and identify data irregularities, created exception reports identifying erroneous data, empowering effected business area to proactively correct their data.

ManTech International Corporation, Senior Business Analyst, January 2014 – April 2014

Senior business analyst supporting the Army’s Software Engineering Center (SEC) & Global Support Centers (GSC), Aberdeen Proving Ground, MD.

Merck, Software Engineer, June 2013 – December 2014

Senior software engineer leading a diverse team of 4 experienced software engineers in the design, development & implementation of Managed Markets, Revitas CARS & iHealthEx system enhancements.

Merger with Schering Plough added Revitas Cars as an additional Managed Markets system to Merck’s software inventory. Proposed updates necessitated a new CARS’s test environment. Architected the construction of a critical Revitas CARS Linux & Oracle test environment. Ensured all servers, services & database objects were efficiently & effectively deployed. Construction & data loading was completed 30% ahead of schedule, releasing resources & conserving budget.

Wholesale customers generated 3 separate EDI streams to facilitate a chargeback, a stream to Merck legacy, one to ModelN & finally CARS. Redundant processing called for a new approach requiring the design, development & implementation of an EDI consolidated chargeback submission system processing 10K+ daily 844, 845 & 849 transactions. Process enhancements allowed customers to create a single transmission file, having data automatically allocated between the legacy IBM mainframe chargeback system & its 3rd party replacement, Model N & Revitas CARS. Eliminated redundant processing by 50% & increased performance 20%.

Engineered a new data model for the iHealthEx mission essential reporting dashboard. The new design leveraged a Teradata database for a 30% performance gain with a 25% reduction in tables. Reengineered the new data model from Oracle to Teradata, encompassing a complete redesign of data objects.

Sole development resource & subject matter expert for the legacy IBM mainframe chargeback system. Provided 24/7 on-call technical support & maintained all COBOL II, CICS & DB2 application code & JCL.

Developed a custom COBOL, DB2 report engine generating critical government price reports, standardizing formats & maximizing accuracy. Reports detailed average manufacturers price (AMP), best price (BP) & average sales price (ASP), non-federal average manufacturers price (NFAMP), federal Ceiling price (FCP), monitoring compliance with government price mandates & minimizing risk.

Sole development resource & subject matter expert for the legacy IBM mainframe chargeback system. Provided 24/7 on-call technical support & maintained all COBOL II, CICS & DB2 application code & JCL.

Developed a custom COBOL, DB2 report engine generating critical government price reports, standardizing formats & maximizing accuracy. Reports detailed average manufacturers price (AMP), best price (BP) & average sales price (ASP), non-federal average manufacturers price (NFAMP), federal Ceiling price (FCP), monitoring compliance with government price mandates & minimizing risk.

Designed 300+ test cases from functional requirements specifications. Cases were loaded to HP Quality Center, facilitating effective requirements testing & defect management.

Led execution of 3 UAT testing programs, led daily status meeting with stakeholders directly improving communication & impelling defect turnaround in less than 12 hours.

Merck Pharmaceutical, Senior Business Analyst, October 2010 – June 2013

Business analyst & subject matter expert for the integration of legacy IBM mainframe applications with Model N Revenue Management Enterprise software.

Led business analysis on 4 critical legacy systems, rapidly & fully defined all requirements. Analysis consistently completed ahead of schedule averaging a 20% schedule gain.

Implemented the use of Agile methodologies user stories articulating requirements in a clear concise manner facilitated 25% reduction test cases.

Analyzed & redesigned the award winning eContracts website to leverage an open-source Java platforms reducing cost & eliminating proprietary software leveraging a plethora of affordable developers.

Led a team of 4 business analysts in creation of 200+ test cases & validation scripts supporting the eContracts vendor web portal.

Authored functional requirements & detail design specifications for 6 essential business integrations, artifacts were vetted & adopted by the QA team as the master templates for project Align.

Security manager for user access & roles for 160 users across 15 distinct Model N test environments directly improved personnel onboarding, offering a specified single point of contact for testing teams.

Led ETL architects in efficient deployment of 4 CSV & XLM integrations between Model N & legacy systems.

United States Naval Reserve, Aircrew Instructor/Loadmaster, October 2008 – October 2010

Mobilized in support of the Global War on Terrorism as a C-130T Loadmaster, Aircraft Avionics Division Manager & Naval Air Training & Operating Procedures Standardization (NATOPS) Department Manager.

Technical expert on C-130T aircraft, systems & logistics. Role model & mentor for junior employees.

Led Avionics Department of 20+ technicians, achieving a mission completion rate of 91% up from 82%.

Led 15+ NATOPS Department, aircrew training & flight pay center employees thru a new scenario based Naval Squadron Readiness Exercise. Squadrons only department to achieve a 100% proficiency rating.

Additional qualifications as an SH-2H Helicopter Rescue Swimmer, P3-BMUP Sensor Operator, Anti-Submarine/Anti-Ship Surveillance and Targeting operator.

Merck Pharmaceutical, Software Engineer, June 2007 – October 2008

Architected a Dashboard application facilitating real-time data capture, converting it to crucial metrics supporting the Executive Steering Committee during vendor selection for a $100+ million Revenue Management project.

Designed & developed the Dashboard in MS VB 6.0 adhering to the corporate technology roadmap for compatibility with Merck’s standard eCore PC image & ensuring qualified staff for future enhancements.

Dynamically retrieved IBM DB2, Oracle, MS SQL Server & MS Access data for viewing, printing or emailing MS Excel reports in 15+ formats.

AstraZeneca Pharmaceutical, Web Developer/Software Engineer, August 2006 – June 2007

Architected & administrated 100+ product information web sites ensuring optimal performance of all web servers, hardware & software, maintaining 100% availability in all global markets.

Led product teams in developing & executing web-based initiatives designed to exceed customer expectations resulting in substantial customer growth & prospect engagement.

Implemented web analytics for aggregating metrics across sites, achieving significantly improved performance, marketing effectiveness & increased customer engagement +10%.

Managed social marketing, search engine optimization (SEO) & vendor relations, maximizing return on investment.

Software Engineer for project Pegasus, a tool utilized by Managed Market promotions & Sales teams to plan, communicate & evaluate effectiveness of promotional strategies.

Developed & implemented the application utilizing MS Visual Studio ASP.NET, VB.NET & MS SQL Server.

Enabled 320+ Managed Market Promotion & Sales team users to evaluate promotional plan spending, measure effectiveness & calculate return on investment (ROI)

Bank of America, Software Engineer, February 2006 – August 2006

Software engineer for TestNet, a web-based management tool for control, coordination & tracking communications, hardware & servers in multi-tier test environments.

Enhanced the user interface utilizing classic ASP, Java Scripting & MS VB 6.0, imposing a uniform interface across all screens.

Managed MS SQL Server 2000 programming & support services for creating, managing & optimizing stored procedures, functions, views, triggers & indexes.

Ensured strict adherence to BOA System Life Cycle (SLC) & Standard Operating Procedures (SOP’s).

AstraZeneca Pharmaceutical, Software Engineer, February 2005 – January 2006

Architected enhancements & upgrades to CipherVISION a web based competitive intelligence workflow tool utilized by sales teams to collect analyze & disseminate competitive intelligence to the AstraZeneca community.

Reengineered the user interface utilizing MS ASP.NET, VB.NET, ADO.NET & Java Scripting, enhanced interface allowed additional data fields, improved workflow design, with increased productivity.

Developed upgrades & enhancements to MS SQL Server 2000 stored procedures & tables, adding new fields supporting user interface updates allowing users to enter additional intelligence.

Redesigned & developed new process of loading field agent entered data & automated news feeds. The collected data followed a proprietary process of categorization & verification prior to analyst dissemination, resulting in improved market competitiveness.

Designed & developed an automated MS Exchange data extraction utility in MS VB 6.0 allowing immediate assimilation of emailed intelligence & accelerated distribution to analysts.

Merck Pharmaceutical, Software Engineer, April 2002 – January 2005

Designed a comprehensive chargeback analysis solution for Managed Markets customer service that eliminated 10 separate reporting applications, consolidated functionality & simplified maintenance.

Programmed the solution in MS VB 6.0, the user interface dynamically retrieves data from existing mainframe DB2 & Oracle database leveraging +90% of existing data infrastructure.

New solution dynamically generated, loaded & formatted reports in MS Excel, removing legacy limitations requiring report file downloading, opening in MS Excel & reformatting columns individually.

Updated code eliminated department’s unacceptable reliance on third party controls by upgrading code to leverage Microsoft’s native control libraries, freeing budget & ending a persistent loss of software licensees.

Supported a beleaguered development team by developing application enhancements & fixes on the legacy mainframe chargeback system using COBOL II, CICS & DB2 negating the need to add additional staff.

Programmed a MS Windows XP conversion & testing program for all Managed Market client-server applications. Logged, prioritized & resolving issues as they arose, reporting daily status to management.

AstraZeneca Pharmaceutical, Software Engineer, November 2001 – March 2002

Upgraded the Trading Partner Database System to comply with Federal Drug Administration (FDA) Title 21 CFR Part 11: Electronic Records Electronic Signatures (ERES) requirements.

Designed & developed ERES compliancy in the Trading Partner Database System, a MS VB 6.0 application providing a repository of readily accessible corporate customer data.

Developed & implemented database enhancements providing data acquisition, data management & data delivery functionality, aligning system with FDA regulatory compliance.

Reengineered data acquisition implementing an MS ADO 2.0 layer over mainframe DB2 & HP9000 (HP-UX) Oracle 8.1 database increasing performance 20% & offering enhanced functionality.

Optimized batch scheduling for NOMAD2 updates & tuned mainframe SAS programs for greater efficiency, providing concurrent job execution & dramatically reducing batch windows.

Minimized risk by introducing software version control using MS Visual SourceSafe 6.

GlaxoSmithKline Pharmaceutical, Business Analyst/Developer, March 2001 – October 2001

Analyzed legacy processes, creating documentation & programming enhancements to minimize risk during a scheduled merger of Glaxo Wellcome, Inc. & SmithKline Beecham’s order entry systems.

Performed business analysis on legacy systems, authoring functional requirements & detail design specifications on SAP/R2 & ancillary system integrations, delivering a foundation for an SAP/R3 upgrade.

Programmed enhancements using COBOL II, CICS, DB2, CSP & ABAP/4 programming languages filling the role of subject matter expert (SME) for all questions pertaining to mainframe development.

F. Schumacher & Company, Software Engineer, May 1998 – March 2001

Designed & developed warehouse automation solutions for the leading distributor of fine wall coverings & fabrics through workflow analysis & innovative software design.

Developed perpetual inventory system for 17 showrooms, replacing an obsolete manual system with laser scanners that allowed real-time inventory analysis, facilitating dynamic stocking & reallocations regionally, saving time & negating gratuitous inventory.

Programmed the showroom inventory system as a network client-server application utilizing Symbol laser scanners for data collection, MS VB 6.0 for the GUI, MS Access for reporting, EHLLAPI & TC/IP windows sockets for CICS integration. New code averaged a 90% increase in restocking speed.

Reengineered year-end physical inventory for national distribution centers. Replaced a paper system with WIFI laser scanners running 3270 emulations with custom CICS screens. Created custom COBOL CICS for data collection/verification & a supporting batch process generating custom Easytrieve reports. The new perpetual process eliminated a 7-day warehouse shut down & located $7 million in unaccounted for inventory.

Developed a real-time shipping label application that printed bar-coded labels for outbound packaging. Shipping staff can now create new or replicate existing labels by entering shipment numbers or scanning existing labels, ending a decade old practice of Xeroxing, cutting & taping reprints.

Coded the labeling application in MS VB 6.0, leveraging BarTender bar-coding software for a print engine. Shipping data was dynamically retrieved via ODBC connectivity with Oracle, reusing existing data sources.

AstraZeneca Pharmaceutical, Software Engineer, January 1997 – May 1998

Sales force automation application developer responsible for the design, development & integration of all sales, prescriber & call planning data for the sales & marketing team.

Governed the Oracle 7.3 database of sales force data. Disseminating daily prescriber data to the sales & marketing team via scheduled uploads to SAS datasets on the mainframe & Crystal reports, providing timely feedback on sales team effectiveness.

Engineered an improved data integration from the sales force’s MS VB 4.0 laptop application to the Oracle database, eliminating recurrent load failures & improving data integrity.

Maintained SAS programs & JCL job streams, creating new SAS datasets as requested by marketing teams.

Computer People, Inc., Software Engineer, October 1997 – January 1997

Sales force automation consultant designed, developed, and implemented data analysis reporting system utilizing OSVS COBOL against a TOTAL database.

Programmed new & enhanced COBOL sales reports & supporting JCL job streams.

F. Schumacher & Company, Software Engineer, December 1992 – October 1997

Provided enhancements and replacements of aging Anderson DCS Legacy systems. Performed EDI mapping and data integration functions, moving data from value added network (VAN) to internal database. Redesigned an obsolete accounts payable reporting system with a Visual Basic, Crystal reports and Oracle 7.3 solution.

Expert in coding Anderson Distribution Control System, a COBOL CICS warehouse & inventory system. Replaced Anderson’s proprietary file access methods with native COBOL CICS calls

Created & integrated numerous support systems using Easytrieve, MS VB 4.0, MS Access, EDI, ANSI X12, Oracle, SQL, TCP/IP & EHLLAPI.

Led the EDI mapping & ETL integration team, introducing QA practices & procedures as a tool to reduce errors & eliminate incessant daily fines imposed by large retail customers. This simple procedure saved $25K in the first month as the imposed fines were greater than many purchase orders.

Programmed an improved accounts payable reporting system with MS VB 4.0, Crystal reports & Oracle 7.3, replacing an obsolete & inflexible legacy IBM COBOL, Easytrieve batch process. The new solution provided a greater variety of reports with enhanced distribution options including email & remote printing.

Hospital Billing & Collection Service, Application Developer, October 1990 – December 1992

ETL application developer accountable for formatting & loading client data.

Developed & coded programs to convert client data to HBCS’s proprietary data format using COBOL, Easytrieve, VSAM, Panvalet & JCL.

Chase Manhattan Bank, USA (NA), Software Engineer, December 1987 – December 1990

Designed, developed & installed multiple applications in a financial environment, inclusive of Systematics Software’s General Ledger (FMS), tax and Savings Time (ST) & Demand Deposit Accounting (IMPACS).

Installed, customized & maintained Systematics Software’s comprehensive mainframe suite of retail banking applications including, demand deposit accounting (IMPACS), general ledger (FMS), tax & savings time (ST) financial applications, eradicating error prone legacy applications.

Contact this candidate