Leading and managing the technology teams comprised of 20+ developers and analysts that support the Centers for Medicare & Medicaid Services (CMS) Enrollment Resolution & Reconciliation (ERR) and 1095-A Data Reconciliation and Reporting business areas. Responsible for providing technical direction and guidance to support the eligibility reconciliation process for multiple stakeholders and continuous process improvement of the reconciliation process. Provides content to and for collaboration with other staffs involved in the reconciliation process. Development teams function in an agile environment that support eight (8) distinct business work-streams, each with their own business workflow and application development teams . Applications and SQL Server databases are maintained in a Microsoft Azure cloud environment along with a series of local VMs and servers. Support is provided for a Microsoft Dynamics 365 CRM application, nightly SSIS ETL processing, Tableau and PowerBI reports, machine language based data analytics and APIs. Collaborate daily with leaders from the DevOps, PMO, business and QC teams.

Evaluates mission requirements and current technology capabilities to develop optimized platforms and services to support the Armed Forces Health Surveillance Branch (AFHSB) health surveillance mission. Leads, manages and mentors a dedicated team of technologists who execute AFHSB’s data-centric information technology mission. Plans, designs, deploys, supports and manages the full life cycle of technologies, applications and environments to support client's mission. Solves data management issues and adapts to provide short term solutions, when appropriate.• Supports all Informatica ETL operations to load and maintain data in the Oracle databases that support the mission to conduct surveillance and analysis of Department of Defense health-related information of U.S. service members.• Develops ETL and data warehouse strategies and performs data analysis to optimize legacy processes.• Leads a team of .NET developers who support applications that provide health information analysis to the Department of Defense (DoD) policymakers, military commanders, healthcare providers, public health officers, and researchers.• Leading a major initiative to simultaneously upgrade operating systems (Red Hat Linux and Windows), databases (Oracle and SQL*Server) and Informatica.

I led multiple agile development teams responsible to build and maintain SOAP/REST APIs and web services applications that interface with external asset and income vendors using JSON and XML files that are delivered to the core Freddie Mac mortgage processing engine. Developed a technology strategy defining the future direction of application design, development and testing. Supervised multiple project teams, leveraging project managers to manage costs, staffing, and execution across multiple projects while working with tech leads, directors, business owners and other senior management to develop technical program level plans and roadmaps. Responsibilities included:• Champion and influence technology decisions with business partners.• Provide direct supervision to multiple levels of the internal development team, responsible for their career development, performance management, coaching and mentoring.• Set project priorities, define team structure and direct development teams.• Review and approve user stories, story point assignments, burn down charts, product backlog and iteration retrospectives.• Ensure that requirements / use cases are fully developed, communicated and understood.• Provide guidance to the team on high level design, ensuring that the design is consistent with the approved architecture and aligned to the forward-looking technology roadmap.• Using Version1, PlanView and HP ALM as scrum management tools.

Responsible for the overall planning, design and implementation of the Reporting Data Store data warehouse, the Oracle Supercluster database supporting customer reporting through the Plan View Portal application. My team developed a star schema database design to support a Microstrategy user interface that provides reporting and analytical functionality for external customers and internal analysts. The ETL is designed and developed using Informatica Powercenter.• Managed a diverse technical team’s activities accountable for the end-to-end solutions delivery, including promotion to the production environment. Team includes developers, business analysts, ETL architects and database architects.• Led the technical solutions effort from inception to final business acceptance and implementation while serving as a consultant and partner to the business community sponsor to identify and prioritize opportunities for utilizing technology to achieve the goals of the enterprise.• Responsible for partnering with the Program Management Office, business leaders and other technical teams to ensure alignment with organizational and project objectives.• Developed and maintained the Microsoft project schedule, Risk and Issues Log and RACI chart.

Program Manager for the Food and Drug Administration (FDA) National Food Safety Data Exchange (NFSDX), responsible for delivering a tool that will allow the exchange of food safety information between national regulatory agencies. Located on the FDA extranet, the application will utilize XML and web services to provide a vehicle for efficient data sharing between the FDA and local regulatory bodies.• Develops and maintains an agile project structure built to deploy multiple production releases.• Built an application development team comprised of Business Analysts, a Solutions Architect, a Technical Lead, Developers, Test Engineers and a Technical Writer.• Responsible and accountable for project planning, sprint development, team management, and project execution according to the Statement of Work and the project budget.• Maintains and manages project risks and issues.• Serves as single point of contact authorized to interface with the FDA Contracting Officer’s Representative (COR) and project stakeholders.

Senior Project Manager in the Data and Personalization Team, responsible to deliver Big Data Projects utilizing Netezza and IBM Big Insights Cloud storage solutions. • Led the migration of multiple terabytes of data from a Netezza warehouse to a Hadoop / Big Insights user-defined analytical platform.• Directed project to adhere to strict Software Development Lifecycle (SDLC) guidelines and rules.• Led a group of service provider project teams ensuring that project design and architecture is properly aligned with user requirements and corporate architecture guidelines and standards.• Improved Project Management Effectiveness for the Data and Personalization group from 33% to 100% compliance based on standard project management deliverables as measured by an independent Marriott project audit group.Program Manager for a multi-million dollar transactional data collection and analysis system; directed activities pertaining to technology and business unit projects with multiple releases and work streams. • Verified project goals are accomplished and in line with business objectives. • Managed large service provider teams that develop and deploy data warehouse solutions. • Performed Information Technology (IT) project planning, identified and developed goals, strategy, staffing, scheduling, risks contingency plans and deliverables to meet business need.• Led Solutions Architecture and Infrastructure teams in procuring, designing and implementing new development, test, performance test and production environments.• Developed User Acceptance Test plans and coordinated user acceptance testing activities with internal Marriott technology teams responsible for .com and mobile applications.

A Specialist Master / Manager in Deloitte Consulting’s Federal Services Information Management (IM) Group focusing on Big Data, Data Warehousing and Business Intelligence.Supported the Navy as a Data Warehouse Technology Specialist and as a Technical Project Manager managing a staff of consultants, responsible for the planning, execution and completion of a Technology and Data Strategy Assessment and a Data Quality Mitigation Strategy. Additionally, provided business intelligence, ETL and data warehousing expertise for the development of a human capital workforce health OBIEE dashboard built from Navy Manpower Programming and Budget System data.Supported the IRS, working to guide the client through all SDLC milestone checkpoints by developing business requirements and design documentation for an Oracle to Greenplum migration. Managed all Deloitte activities from initiation and planning to post-deployment activities including on-boarding of resources, client interactions, scope planning, requirements and design drill-down, data modeling and ETL analysis. Created project schedules to conform with the IRS' SDLC (ELC) process as well as best practices from industry.Provided technical input to define the overall Solution Architecture for the IRS implementation of the Affordable Care Act (ACA) as it relates to the collection, storage and distribution of new data sources including the identification of Pivotal Data Analytics platforms and tools used to perform IRS advanced batch and on-demand analytics.Facilitated a Big Data / Greenplum learning presentation for Deloitte IRS practitioners.

Led the technology team responsible for Market Regulation Data HUB application, data gold source used to surveil NASDAQ, NYSE and DirectEdge stock markets. The application loads, transforms and summarizes over 5 terabytes of data daily using requirements collected from over 200 surveillance business intelligence (BI) programs and on-line queries.• Led the technology team responsible for development and maintenance of data warehousing applications supporting over 600 terabytes (TB) of on-line historical data on big data storage platforms such as Netezza, GreenPlum, Hadoop, Oracle, and NAS.• Designed data storage and ETL architectures using Python scripting and multiple storage platforms.• Provided a flexible data management structure to ensure data storage and database design provided optimal data retrieval by downstream users.• Ensured data was timely, accurate, and met all service level agreements by deploying SQL based off-line data quality monitor subsystem.• Defined and planned ETL projects, and created / maintained project schedules and roadmap, allowing FINRA to plan surveillance deliverables and meet regulatory responsibilities.• Reported project status and financials to senior technology and business management, raising risks and issues and obtaining input and approval for mitigation strategies.• Managed $6M budget and directed an employee / contractor team of 15 analysts, developers, DBAs, and QC testers by assigning tasks per project schedule.• Confirmed data was readily accessible across all platforms through the generation and distribution of daily load status reports.• Migrated data from Oracle legacy to Netezza and GreenPlum platforms using off-hours and weekends to complete data exports and loads to target environments.• Recommended performance improvements resulting in measurable decreases in data load times and query response times.• Completed multiple data center migrations.• Successfully passed multiple internal and SEC project audits.

Health and Human ServicesLed a team in development of a federal healthcare agency to consolidate data from all bureaus within the agency from various disparate data sources and provide an OLAP reporting user interface to be used by all employees within the agency as well as the general public.Tools utilized: SQL*Server 2000, ERWin, Brio Intelligence, Business Objects WebIntelligence, Informatica PowerMart, OLAP design, star schema data model.

NCRDeveloped a Point of Sale data warehouse and analytical application for the United States Postal Service. Developed a Microstrategy front-end and a multi-terabyte Teradata database has been developed using a star-schema design to provide a wide range of analysts with the ability to perform sales and inventory analysis for all U.S. Post Offices throughout the country. Primary responsibilities include development of ETL scripts using Teradata FastLoad and BTEQ (Basic Teradata Query Language) tools and the design of all Microstrategy components required to produce a web-based front-end analytical application. Additional responsibilities involve performing similar ETL and Microstrategy tasks for the development of a new Financial Data Mart that is being designed as a subsystem to the primary Point of Sale application.Tools utilized: Microstrategy 7, ERWin, Teradata, FastLoad, BTEQ scripting, ETL development, OLAP design, star schema model.CONCERTDesigned and implemented a Financial Analysis Reporting application for a major telecommunications company. This application utilized an Oracle 8i data warehouse and the Microstrategy 7 platform of analysis tools for use by over 300 worldwide department managers. As the primary ETL and data warehousing architect, the tasks performed involved assembling the star-schema based dimensional data model using ERWin; designing and developing the ETL process using Oracle PL/SQL stored procedures, packages and triggers; and designing and developing a ROLAP solution using Microstrategy 7 Desktop, Intelligence Server and Web. Additional responsibilities included database design and tuning, customer interaction and some project management.Tools utilized: Microstrategy 7, ERWin, Oracle 8i, PL/SQL, partitioning, stored procedures, SQLLoader, triggers, ETL development, OLAP design, star schema model.

TeligentServed as a data warehousing consultant and ETL expert responsible to design and develop a data warehouse for a major telecommunications company. This included using the Informix RDBMS to develop a data warehouse that served as the primary source of data for a Microstrategy based e-commerce application that provides billing analysis information to external customers. ETL processing was delivered using custom scripts and the Informix Datastage ETL tool. Developed entire database architecture and ETL design.Tools utilized: Informix 7.3, stored procedures, triggers, DataStage, Unix shell scripting, Microstrategy 6, ERWin, OLAP design, star schema data model.Baltimore Gas and ElectricProvided technical consulting services and performed full life-cycle design and development for a Baltimore based client to deliver a business intelligence based Cost Management application. This included using Microsoft SQL*Server, Microsoft Data Transformation Services (DTS) and Microsoft OLAP Services to develop a web-based OLAP application that provided rapid analysis of cost versus budget versus resource allocation data as well as project scheduling and coordination with the internal IT staff. Developed entire system architecture and application design.Tools utilized: SQL*Server 7, Microsoft Data Transformation Services (DTS), Microsoft OLAP Services, OLAP design, star schema data model.

Nasdaq Assistant Director/Technical Team LeadDirected the development of two mission critical applications: The Web Issuer Services DataMart, an Oracle based application that served as the primary source of data for external market web sites; and The Risk Scoring Compliance System, an Oracle and NT based application that performed numerical analysis, generates 'risk' scores and provided user access through a web-based user interface developed in HTML and ASP. NASD Regulation Business-Line Project ManagerInformation Technology DeveloperResponsible for the delivery and maintenance of the Research and Data Analysis Repository data mart and client/server system, a 1995 Smithsonian Award winner for innovative use of information technology. Contributed to the successful design and delivery of major enhancements to a system that was designed and developed using ApplixWare GUI development skills, data modeling knowledge, Oracle PL/SQL relational database design and data warehousing expertise. Served as the Project and Technical Lead for a Corporate Bonds Compliance application and Lead Programmer for a District Management Information System utilizing INFORMIX 4GL and ESQL on a SUN / UNIX platform. During this tenure at The Nasdaq Stock Market and The National Association of Securities Dealers, was the recipient of 1994 Excellence in Service Award, an honor presented annually to approximately 3% of all non-upper management employees throughout the corporation to recognize and reward employees who demonstrate continual superior performance.