SUMMARY

Confidential is a project manager and solution architect with over 15 years experience in the design and delivery of results-focused, cost-effective Business Intelligence/Data Warehouse BI/DW applications. Kelley possesses strong communication, consensus-building, and problem solving skills necessary to manage delivery of solutions to emergent business drivers for multiple levels of management across vertical organizations within Fortune 500 and U.S. Department of Defense DOD clients. She adopts a business-centric approach to drive solution design and her experience illustrates her adept ability to combine business acumen and technical knowledge to architect scalable solutions that deliver maximum Return on Investment ROI . Kelley's customer-centric focus and delivery successes generate profitable, long-term, client alliances.

SKILL HIGHLIGHTS

• Over 20 years total experience developing solutions with Oracle products and databases
• Over 15 years experience as a BI/DW Solution Architect for enterprise-wide, high availability, high volume systems
• Over 15 years experience in performance tuning for large OLTP and BI/DW solutions in Oracle databases
• Over 10 years Full Life Cycle Project Management for BI/DW solutions with multiple SDLC methods including Agile
• Microsoft SQL Server DBA, database architect, and performance tuning for DW/BI applications.

RELATED WORK EXPERIENCE

Confidential

DATA WAREHOUSE PROJECT MANAGER

Project Manager for a 14 member development team for a high availability, high volume, Operational Data Store ODS and Data Warehouse at Department of Homeland Security, US Citizenship and Immigration Services USCIS . Successfully navigated 3 month transition from prior firm on an ODS/DW with multiple application sources and database types IDMS, Oracle, and Pervasive that utilized multiple ETL and/or Replication mechanisms PL/SQL, Oracle Materialized Views, Oracle Streams, and Informatica . Ensured risks and issues were mitigated by creating much needed documentation and Operations Maintenance O M Standard Operating Procedures for each component. Managed team as they took on concurrent efforts to perform O M activities, support migration of ODS/DW components to a new data center, upgrade Informatica PowerCenter and PowerExchange for IDMS data sources from 8.6.1 to 9.5.1, and develop new datamart components. Worked with team to evaluate technical shortcomings in the existing environment and make recommendations to improve performance that balanced often competing criteria for getting data into the ODS/DW and getting data from the ODS/DW. Participated in Agile Scrum planning sessions as client transitioned from waterfall delivery methods and began educating team members on the nuances of DW/BI development via Agile Scrum. Developed high level estimates for ODS and DW efforts for the remainder of the 2013 fiscal year and resource plans for 4 concurrent Scrum teams assembled to complete those efforts.

Confidential

DW/BI CONSULTANT temporary assignment

Supported Pacific Fleet to review and document functionality of the Obligation Validation Review OVR module developed for another organization and recommend how application can be utilized to fit Pacific Fleet needs. Additionally, met with team to discuss general BI/DW best practices and methods applicable to their specific environment with Oracle and Cognos Business Intelligence.

Confidential

BUSINESS INTELLIGENCE CONSULTANT

Architected solutions for and managed implementation teams of 2-4 to deliver Balanced Score Card and Business Intelligence applications for Commander, Naval Installation Command's CNIC Headquarters using Microsoft SQL Server and Cognos Business Intelligence Framework, Query Studio, Report Studio, and Analysis Studio via Lean Agile delivery methodology. Implememtation tasks conducted included SQL Server Database administration, Database design and implementation, developing complex ETL modules using T-SQL, design and implementation of Cognos Framework components, design of Cognos reporting and .Net components, and testing at all stages of development including troubleshooting issues with Cognos reports. Helped architect and implement internal tool written in SQL Server, and .NET to manage Lean Agile and Agile Scrum requirements backlog and 'grooming' process, stakeholders roles and responsibilities for requirements, Service Level Agreements SLAs , Testing, etc. and manage SDLC development, testing, and deployment efforts during an Agile Sprint or Lean delivery cycle. Implemented the Senior Leadership Customer Survey SLCS Business Intelligence module, which was deployed to CNIC's iShore environment, using Microsoft SQL Server, IBM Cognos Business Intelligence, and IBM InfoSphere DataStage. In addition to similar implementation roles described during the Balanced Scorecard/ BI applications, designed, implemented and tested IBM DataStage ETL components, analyzed XML data feeds and architected solution to store XML data as attribute-value pairs to accomodate current surveys that were subject to change without affecting existing code as well as set a flexible foundation to process future survey data.

Confidential

DATA WAREHOUSE ARCHITECT Data

As BI/DW team lead for Fleet Forces Command FFC , worked with clients to analyze existing processes to identify areas for automated improvement, document project scope and requirements, and architect technical software solutions. Management activities included managing concurrent and single-threaded efforts, developing and maintaining project plans, reporting project status, conducting client presentations during project life-cycle, and managing project development to ensure delivery on time and within budget. Designed and implemented database structures, complex Extraction, Transportation, and Load ETL modules and end-user reporting interfaces. Utilized knowledge of DOD financing to design a solution to automate and streamline Obligation Validation Review OVR business processes in a manner that met DOD financial regulations. The OVR solution utilized both DW and OLTP data and laid the foundation to support previously expressed business requirements, in addition to OVR, without impacting cost and delivery. Initiative taken to implement a flexible design led to three additional projects in following fiscal years. Development tools included Oracle Database 10g, 11g, , Discoverer, Oracle Warehouse Builder OWB , and Jdeveloper J2EE . Provided full Software Development Life Cycle SDLC support through testing, delivery and post-production support, including training, performance monitoring, application tuning, and problem resolution.

Confidential

PROJECT MANAGER

While managing 5-10 concurrent projects, activities included financial forecasting, managing contract and budget adherence, identifying opportunities for growth, staffing projects and managing client relationships.

PRACTICE

Confidential

Attended sales team meetings with potential clients to discuss high level business processes, management reporting needs, and immediate business drivers in preparation for software and consulting engagement proposals that included BI/DW technology. Developed and documented high-level BI/DW application designs, project plans, key team member skill requirements, and 'man day' estimates for client proposals. Also contributed to and participated in Proposal Presentations to clients as an Oracle software and BI/DW expert. Additionally, served as team lead and implementation specialist to develop 'proof of concept' applications that demonstrated product capabilities and consulting service solutions, which successfully led to client purchases of software and services.

COMLANTFLT, BI/DW Project lead and Architect:

Worked closely with key stakeholders to define requirements to report Key Performance Indicators KPIs for the U. S. Navy Atlantic Fleet Comptroller. Following requirements phase, designed solution BI/DW technical architecture, ETL modules, reporting interfaces, and multi-dimensional data models. Also mentored implementation teams of 4-6 on DW-specific techniques. Introduced time-boxed Agile method via Dynamic Systems Development Method DSDM MoSCoW to accommodate client aversion to documentation while also meeting expectations for incremental delivery of content. Wrote requirements for re-engineer and convert existing Oracle Forms Financial modules to J2EE and wrote test plans to meet agreed upon requirements, SLAs and OLAs. Project management activities included: managing resources and delivery efforts for concurrent and single-threaded efforts, maintaining client relationship, coordinating solution delivery, managing risk, issue resolution, and preparing weekly reports detailing project status, plans, and costs for client and Oracle management. Developed applications using Oracle database, Discoverer, and OWB.

Defense Supply Center, BI/DW Pre-Sales Team member:

Developed a 15 Gigabyte operational data store and 10 Gigabyte 'star schema' data mart to demonstrate Oracle database, OWB, and Discoverer capabilities for a Navy Supply Center 'proof-of-concept'. Mentored technical client team about Oracle products and BI/DW techniques required to deliver BI to their large, world-wide, user community. Successfully met project goals to sell Oracle development applications, database licenses, and consulting services.

MANAGING PRINCIPAL CONSULTANT

Confidential

Revisited prior client to develop several, concurrent, follow-on DW application modules for a retail data warehouse that supported Navy Exchange Command NEXCOM buyers and business analysts. Technical responsibilities included: documenting requirements, assessing business processes associated with inventory and retail sales analysis, defining process KPIs and hierarchical business entities as relational star schemas, designing ETL modules, and implementing the end-user interfaces that required extensive use of Oracle Analytic Functions within MicroStrategy. Mentored 8-12 team members with little or no BI/DW experience and managed development effort to ensure the projects delivered on time and within budget. Was an early adopter of Oracle's Fast Track DW methodology to deliver incremental value in shorter periods of time focused on components required for current effort while keeping overall requirement in mind by implementing 'placeholders' for future efforts For example, fields in fact table to keep granularity of fact without implementing dimension for the current delivery.