Data Management & Business Intelligence Professional
Resume:
C. KEVIN KELLOGG
Aurora, CO *****
*.*****.*******@*****.***
DATA MANAGEMENT AND BUSINESS INTELLIGENCE PROFESSIONAL
PROFESSIONAL EXPERIENCE
BAE Systems - Space & Mission Systems (formerly Ball Aerospace)Oct 2020 - Jan 2025 Project Engineer, Mission & Process Analytics - Information Governance Provide best practice recommendations towards establishing and maturing a sector-wide data management practice. Served as Data Management workstream technical lead and project engineer for the Digital Engineering & Manufacturing platform upgrade (from Oracle Agile to Dassault Enovia/3DExperience).
● Act as Data Management Product Owner in developing product goals.
● Integrate Data Management product goals across multiple product workstreams. Groom and prioritize backlog items to ensure data needs are met per iteration.
● Cost Account Manager for six full-time resources and approximately $300,000 release 1 labor dollars.
● Department mentor and lead for two Information Governance resources.
● Liaison with external data governance consultants in building data management roadmap and analyzing results of internal data management maturity assessment results.
● Collaborate with business leadership and subject matter experts in defining data domains, data subdomains, critical data elements, and establishing data owners and data stewards for each.
● Interface with corporate level Data Governance resources (post-acquisition) in communicating current sector-level data management priorities and best practice recommendations regarding their current areas of focus.
● Analyze existing Reporting & Analytics data security access model, propose changes to the access model to simplify the implementation and improve the maintenance and auditability. Access Data Consulting Corporation July 2019 - Oct 2020 Senior Consultant, Agricultural Banking and Leasing Provide QA and TA services for multiple project workstreams, in support of a multi-year effort to replace an outdated mainframe leasing system with a modern solution.
● Wrote the ETL QA test plan for the Data Migration workstream.
● Created SQL scripts to test the results of the stage-to-stage ETL packages for the Data Migration workstream. Executed scripts, recorded results, and logged defects as required. Developed testing status metrics and dashboard (Excel).
● Provided TA services in analyzing UNIBASIC code to document transformation logic of a legacy data warehouse for the Reporting workstream.
● Created SQL scripts to test the results of the Enterprise Data Warehouse staging layer to integration layer ETL packages for the Reporting workstream. Executed scripts, recorded results, and logged defects as required. Developed testing status metrics and dashboard (TFS/Azure DevOps).
● Coordinated additional onshore and offshore QA resources in support of the Enterprise Data Warehouse ETL QA efforts for the Reporting workstream. Responsible for validation and triage (Data Modeling, Source to Target Mapping, ETL) of defects raised by offshore QA resources. C. Kevin Kellogg Page 2
Setpoint Systems Corporation April 2018 - July 2019 Solutions Architect
Deliver technology solutions and support as required to achieve enterprise objectives.
● Wrote REST API, ETL package, and created Power BI dashboard and reports to automate publication of email marketing campaign metrics.
● Developed data architecture, application, ETL, datamart, and reporting assets in support of Setpoint’s customer training program.
● Green field implementation of Master Data Management initiative defining sources of truth, integration connections, and an initial round of operational data stores and datamarts.
● Led the implementation, migration, roll-out, and ongoing administration of Salesforce Professional Edition. Independent Contractor Nov 2015 - April 2018
Solutions Architect
Provide data architecture design, user experience recommendations, functional and technical requirements, application reporting, platform infrastructure, and unit testing for a startup Mobile Application venture. Independent Contractor Feb 2014 - Oct 2015
Solutions Architect
● Responsible for Netsuite deployment, configuration, administration, development, and training for a Professional Certification Management company. Duties included SuiteScript development, access/privacy models (roles and permissions), workflows, dashboards, public/private reporting, and saved searches.
● Provided JavaScript development, Wordpress administration, Moodle development and administration, YourMembership development and administration, website maintenance and development, data migration, customer support, and employee training for a Professional Test Development company. Apex Systems July 2013 - Feb 2014
Senior Consultant, Hospital and Health System
Responsible for the initial launch, continued operation, and system-wide roll out of the Enterprise Reporting & Analytics Portal for the Enterprise Intelligence department of a large healthcare system.
● Wrote QA and UAT test plans for the Enterprise Reporting & Analytics Portal, and additional application documentation (e.g. application flow, business process flow, FAQs, feedback discussion board).
● Developed training materials and delivered training sessions for specific application roles as well as a general overarching session for ongoing training.
● Created application metrics, reporting, and analytics.
● Responsible for application user support and user experience. Sumtio July 2012 - Feb 2013
Senior Consultant, Telecommunications Provider
Responsible for addressing and resolving customer system problems, maintaining appropriate service levels, and quality control standards. Manage technology solutions in support of the customer care experience.
● Managed the migration of existing customer tools from the client’s .COM site, involving new customer acquisition, to their .NET site, focusing on existing customer support.
● Improved IVR utterances tree by routing to specialized call queues, resulting in fewer agent transfers.
● Modified processes and systems to support the launch of Windows 8 and IE 10 for customers. Independent Contractor Jan 2012 - March 2012
Data Warehouse Developer
● Developed data integration solution connecting client CRM data with DoubleClick Search data from Google, and reporting tools, for a Search Engine Marketing company. C. Kevin Kellogg Page 3
Denver Health and Hospital Authority Apr 2008 - Dec 2011 Director, Data Warehousing and Business Intelligence Managed a mid-size team of data warehouse analysts, architects, and developers, as well as the resources responsible for Denver Health’s internal and external web presence. Oversaw design and development of multi-purposed chronic disease and cancer screening registries. Managed 18 resources and an annual budget of $2,000,000.
● Developed a Clinical Quality Scorecard, which received the 2010 National Association of Public Hospitals and Health Systems President’s Award for using health information technology to advance performance.
● One of twelve finalists for the 2011 Healthcare Informatics IT Innovator Awards.
● Designed and developed the Denver Health Meaningful Use Eligible Provider Reporting module, which was certified by CCHIT as a modular EHR (CC-1112-100012-1) for incentive reimbursement.
● Served as the Co-Chair of the Denver Health Data Governance Council and was an active member in the Change Advisory Board.
Ajilon Consulting Sep 2006 - Apr 2008
Consultant, Oil and Gas and State Government Clients Enhanced mid-level customer relationships, provided consulting expertise on engagements, and identified new target application opportunities within accounts. Interfaced with analyst groups, and provided researched information to the development group for current and future applications.
● Created a custom database application to maintain and report pipeline integrity tracking information.
● Implemented a drinking water quality database and developed an efficient reporting infrastructure. SourceCorp July 2002 - Jun 2006
Strategic Planning and Workflow Manager
Provided workflow analysis, process improvement, and program refinement to address quality, service level agreement compliance, and system and project design. Managed 35 resources and an annual budget of $3,600,000.
● Managed the design and operation of a business unit providing mailroom operations, document scanning, data capture and transmission, physical and data security, and financial tracking for a large advertising client.
● Served as the primary Technology Liaison for a client task force on digital image management. New Mexico Medical Review Association Aug 1998 - Apr 2002 Database Administrator/Director, Analytic Services and Information Systems Managed and participated in activities of a diverse department encompassing the analysis of large databases, database management, and information systems. Managed 9 resources and an annual budget of $800k.
● Active member of the New Mexico Health Policy Commission Data Use and Access advisory board; New Mexico coalition to support Health Insurance Portability and Accountability Act (HIPAA) compliance; and New Mexico House Joint Memorial (HJM) 20, Health Information Privacy Act.
● Served as Co-Chair of the American Health Quality Association (AHQA) Information Technology network. Intel July 1990 - Apr 1998
Facilities Engineer (Contracted through BPLW Architects and Engineers for 3 months) Managed the Engineering Systems Team of the Facilities Engineering department for Fabs 9.2, 9.25, 9x, and 11. Responsible for $500,000 annual budget. Served as Chairman of Intel New Mexico Site CAD Standards Committee.
● Project Manager responsible for the development and vendor compliance with the graphical and electronic standards of the construction documents for Fab 11, Fab 11 CUB, EP Support building, and RR5.
● Developed engineering library database application for the inventory and location of construction blueprints, equipment startup procedures, electrical panel schedules, operation and maintenance manuals, and warranties. C. Kevin Kellogg Page 4
Electro-Magnetic Applications, Inc.July 1986 - June 1990 Technical Drafter/Engineering Support Analyst
Provided technical drafting services using both Pro-Design and AutoCAD. Assisted engineers in developing and entering two-dimensional and three-dimensional grids for modeling complex electro-magnetic wave phenomena.
● Developed program to plot electric and magnetic wave data in simulating underground nuclear tests.
● Developed document control database to inventory and track access for DOE classified materials. Protectors Insurance Agency Jan 1985 - Feb 1986
IT Technician/Database Developer
Provided office network and desktop support. Took over database application development for internal agency management software program.
● Created or completed agency management modules covering customer information, company information, policy details, accounting data, claims, and payroll. Texas Tech University, Department of Mathematics June 1984 - Aug 1984 Summer Intern/Data Processing Specialist June 1983 - Aug 1983 Provided general computer operations and word processing services.
● Converted paper copies of staff members' CVs to electronic versions using WordStar.
● Trained department clerical staff on the usage of the word processing, electronic storage, and printing systems. EDUCATION
University of New Mexico, Bachelor of Arts, Liberal Arts Dec 2021 PUBLICATIONS AND PRESENTATIONS
● Cited in “Strategies and Best Practices in Implementing Healthcare Data Analytics at a Major Urban Medical Center: Denver Health’s Experience Using Siemens Decision Support Solutions,” 11/2011.
● Cited in case study on Denver Health “Business Intelligence and Analytics for Healthcare Organizations,” Ark Group Publishing, 2011.
● “Dashboards and Scorecards: Advanced Data Facing Methods,” Siemens Innovations Conference, 08/2010.
● “Leveraging Decision Support Solutions (DSS) to Increase Operational Efficiency and Improve Patient Care,” Siemens Innovations Conference, 08/2009.
● “Patient Acquisition and Tracking System (PATS) – What is it, and why do I need it?” AHQA Technical Conference, 08/2001.
● “A Procedures-Based Approach to Department Operations,” AHQA Technical Conference, 02/2001.
● “Community Acquired Pneumonia in New Mexico: A Data-Driven Success,” Tri-Regional Conference, 06/1999.
Contact this candidate