PROFESSIONAL EXPERIENCE

Confidential

Solution Architect

Responsibilities:

• Led team of (3) developers and system analysts to successfully deliver Business Intelligence solutions validate financial data from Meditech system.
• Architected and designed Operational Data Store (ODS) and Enterprise Data Warehouse for the analysis of charges across 12 dimensions using CA Erwin Data Modeler 9.6.
• Validated the timely and accurate data produced from ODS and EDW with Excel PowerPivot report for FY2014 and FY2015.

Confidential

Solution Architect

Responsibilities:

• Led team of (5) developers, project managers and analysts to successfully deliver Business Intelligence solutions to the Originations and Servicing departments for Exeter.
• Architected and designed data warehouse environment for migration from Microsoft SQL Server (SMP) to Microsoft Analytical Platform System (MPP) using Visio Enterprise Architect.
• Performed cost benefit analysis of the existing SMP environment vs. MPP. Led the key IT stakeholders through the overall TCO calculation to save $1.5M over a 3 year commitment.
• Designed and architected the data model supporting PowerPivot reports for Personal BI Solution for Risk Analyst team including the reporting of loan applications and quotes at various stages in the Originations process.
• Designed and architected the ETL processes, source to target maps and data model supporting the (10) operational reports of the Servicing department. Facilitated working sessions with 7 - 8 subject matter experts from IT and the business to define requirements for the entire lifecycle of a loan from Boarding to Payments, Promises to Reposession, Deferrments and Reinstatement, Charge-offs and Bankruptcies.

Confidential

Sr. Architect

Responsibilities:

• Improved the overall system performance by ensuring all data contracts returned in less than 3 seconds. Reduced the response time of the system from 49s to 1-3 seconds for most key transactions.
• Led the transactional database redesign of AKELA in supporting of the migration project from Oracle (PAS) to SQL Server 2008R2 using ERWin Data Modeler. Designed the key schemas including Organization, Persons, Registration and Training.
• Designed and developed the front-end and back-end system for measuring Trained Leader and Youth Protection Compliance. Developed Dashboards standards to ensure ease of use and adoption using Microsoft Visual Studio 2010, Integration Services 2008R2 and Analysis Services 2008R2. Responsible for the overall user experience to render clear and concise information at a glance for Council Executives and District Commissioners.

Confidential

Data Team Lead

Responsibilities:

• Led team of (6) Data Analysts and (1) DBA in the transformation of the ETL process for 12 Healthcare Clients using a myriad of file formats. Improved the overall processing time from 3 weeks to 4-5 days for 9 of 12 clients using Microsoft Business Intelligence Developer Studio (BIDS) 2008.
• Redesigned the file import database to allow for data cleansing and transformation tasks to improve the overall data quality and reduce the number of clarifications required out to the client.

Confidential, Dallas, TX

Sr. Business Intelligence Developer

Responsibilities:

• BI Team Lead for development of spend analytical platform supportingMedAssets, a major healthcare supply chain management provider. Designed OLAP schema for Teradata data mart and Microsoft SSAS back-end. System analyzed over $60B in spend and approximately 1.5TB multi-dimensional data stored in (2) cubes.
• Designed test lab for performance benchmarks of MOLAP and ROLAP storage designs. Recommended hybrid approach to meet all requirements including dynamic user settings and line item vetos.

Confidential

Sr. Business Intelligence Developer

Responsibilities:

• Draft functional and technical specifications for Integrated Operations and Sales and Delivery content areas for enterprise wide SAP implementation. Responsible for the development of conversions to transform data from legacy mainframe and DB2 systems to SQL Server database running BackOffice software.
• Performed custom development of SSIS packages for archival of IMS data (mainframe) using Microsoft SQL Server Integration Services (SSIS).
• Trained in EZ-Map, Data-Profiler and Data Staging Warehouse tools of the BackOffice suite.

Confidential, Fort Worth, TX

Sr. Business Intelligence Developer

Responsibilities:

• Designed and architected enterprise-wide Cargo Dashboard in SQL Server 2005 for revenue performance, capacity alerts and operational performance and monitoring for over 2500 users.
• Designed and developed Teradata data mart as source repository for revenue information for all Cargo air waybills using ERWin Data Modeler. Used star-schema design to load both current and historical data going back 7 years.
• Designed SSIS solution involving multiple data sources including:
• XLS file from Finance department for monthly revenue plan.
• Data extraction from Teradata data mart for revenue actual.
• Designed and developed Location Tracking Scanner Compliance report in support of enterprise-wide business transformation and re-engineering project using SQL Server 2005 Reporting Services.
• Designed SSIS solution for the near real-time monitoring of capacity and loads on wide-body aircraft. Converted legacy DTS packages to Microsoft SQL Server Integration Services (SSIS).

Confidential, Fort Worth, TX

Sr. Consultant

Responsibilities:

• Designed and develop Grade Reporting and Analysis data warehouse system for 75 teachers and 10 administrators and support personnel. Production system designed using Classic ASP (front-end) and Microsoft SQL Server 2000 (back- end) and SQL Server 2000 Analysis Services for cube development.
• Iterative releases incorporated the use of stored procedures and triggers to perform ADD, UPDATE, and DELETE operations from the database.

Confidential, Washington, DC

SENIOR CONSULTANT

Responsibilities:

• Designed, developed and implemented Knowledge Management solution (K21) for estimated 750 users of US Marine Corps Contracts community. Implemented replication of production database to ensure data redundancy.
• Analyzed production database environment and designed optimization plan to allow for the future redesign and implementation of Joint Electronic Document Access (JEDA) for the Department of the Navy and the Department of the Air Force Acquisition communities. Redesigned legacy data warehousing application from Netscape Server to a Microsoft Windows DNA 3-Tier framework.

Confidential, Washington, DC

TELECOMMUNICATIONS OFFICER

Responsibilities:

• Planned and coordinated the migration and deployment from standard workstation 2 (SWII) to standard workstation 3 (SWIII). The operating system for SWIII was Microsoft Windows NT version 3.51. Major projects included Oracle 5 migration and functional rewrite of the Incident Reporting Information System (IRIS) used to support National Response Center (NRC) mission.