Solely responsible for creating, maintaining, and enhancing the WPIS Enterprise Data Warehouse (EDW) including the nightly ETL processes (SSIS) and internal and client multidimensional (OLAP) and Tabular SSAS cubes. Duties include:• Enhance the EDW to include new and current clients in support of changing reporting requirements• Create and maintain complex stored procedures• Develop logical and physical data models including multidimensional and tabular data cubes and metadata definitions• Analyze and troubleshoot complex data cleansing, data integration, and data warehouse system issues, identify the reasons for problems, failures and malfunctions and develop optimal solutions.• Monitor data integration and reporting anomalies and make adjustments as required.• Create and maintain on-premise Tabular cubes in support of ongoing major business initiative to transition from existing legacy reporting system.

Provider of Information Technology consulting services specializing in data conversion and mapping from legacy systems into current relational database systems to make client operations more efficient, robust, and profitable. Expert in database development, custom client/server applications, and Project Management via PMI-compliant processes. Recent projects include:United States Department of Agriculture (USDA), Center for Nutrition Policy and Promotion (CNPP): Perform all database development and administration for the SuperTracker application (www.supertracker.usda.gov). Created tables, stored procedures, functions, SQL Agent jobs, SSRS Reports, etc. Provide support for requirements definition/validation, system architecture, application design, and database design. Perform DBA duties (backup/restore, index maintenance, etc.)Subject Matter Expert (SME) – FDIC: Analyzed and converted existing ETL process using SQL Server Integration Services (SSIS) 2010 into SQL Server 2012 stored procedures for the Federal Deposit Insurance Corporation (FDIC). Analyzed and documented existing SSIS packages (with custom components) in order to “reverse-engineer” the requirements. Created new stored procedures that replicated the existing SSIS ETL packages. Validated and verified results including integration with existing SSAS cubeSubject Matter Expert (SME) – Dept. of Treasury: Provided short-term subject matter expertise to prime contractor (Smartronix, Inc) for the development and maintenance of the data warehouse used for the USASpending.gov website for the U.S. Dept. of the Treasury. Responsible for performance tuning of the USAspending data warehouse. Re-wrote portions of stored procedures and created/maintained indexes of multiple tables to improve performance. Analyzed and offered corrections to the ETL processes (using SQL Server Integration Services (SSIS)) to achieve closer alignment with source data.

Directed all technical and operational aspects for national IT contractor serving the U.S. Federal Government. Performed as 1 of 4 executive members of senior management team, participated in development of strategic business plans, bids, proposals, and partnerships. Identified contract and teaming opportunities. Provided expert consultation on technology investments and projects technical direction. Maintained corporate infrastructure. Designed and maintained procedures, processes, and templates for CMMI and ISO-9001 compliance. Created Internet, email, and software usage policies. Interviewed potential technical and/or management employees. Led and managed multiple technical projects for the U.S. Department of Agriculture, Commerce, and Interior; the Environment Protection Agency (EPA); the FDIC; and Exostar LLC (a B2B collaboration solutions provider). Special projects included ITIL/ITSM implementation, data center evaluations, IPv6 assessments, enterprise VoIP recommendations, Cyber Security strategic planning, CMMI implementation. Instrumental in growing business from < $1 million to over $30 million annual revenue and over 300 employees.

Headed daily operations of all technical staff and help desk personnel for Fatality Analysis Reporting Program (FARS) project with U.S. Department of Transportation for national government IT contractor with 100 employees and $9M in revenue. Oversaw all Windows NT servers including MS SQL Server, Internet Information Server, Netscape Commerce Server, MS Exchange server, and Oracle. Led development and maintenance of the FARS MDE system, Internet/Intranet sites, Quality Control applications, and reporting tools.Corporate Contributions:• Acted as lead developer for MDE system, converting to 32bit Windows system; architected design in all 50-states and Puerto Rico, providing real-time data accessibility.• Co-designed FARS website, implementing ad-hoc query capability and pre-defined reports.• Orchestrated web-based dashboard, expediting and improving data analysis.

Oversaw all design and development of the Percutaneous Electrical Muscle Stimulator (PEMS), collaborating with Principal Investigator (PI), for Life and Microgravity Sciences (LMS) Mission. Led team in fast-tracking PEMS through NASA’s system. Ensured adherence to all Spacelab and scientific requirements. Interfaced with European Space Agency (ESA), maintaining fulfillment of Spacelab, instrument technical, and financial agreements. Performed ground-based experiments, collecting baseline data. Trained LMS Payload crew members on PEMS instrument. Major Contributions:• Achieved NASA safety compliance, successfully fast-tracking PEMS through system.• Expedited project through design phase, subcontractor management, testing, document creation, and safety reviews, delivering completed prototype to NASA in 1-year.