Lead design and architecture of global AWS data warehouse for world-wide financial services organization. Worked with senior management on SOW’s and planning plus data architecture plan for both data warehouse, data lake and analytics via Amazon AWS. Analyzed existing systems and worked with reporting and data management SME’s plus management to define requirements assist with prioritization of data flows. Data architecture plan to include data analytics data lake and BI reporting for different international business units including the implementation of a data governance and data stewardship plan. Works with CIO, Global Data Director and Director of Data Engineering on a daily basis.

Provided Data Warehouse, Master Data Management & Business Intelligence solutions for a large national multi-functional health care provider. Lead an effort to initiate a data governance and data stewardship methodology across a splintered organization with concepts of Master Data Management. Analyzed existing operational applications and provided a road map and possible implementation plan to meet BI and reporting needs for the entire organization. Implemented a cross-organizational operational and revenue data warehouse with a dimensional model to support BI solutions via SQL Server 2014, Power BI, Tableau 2018, SSAS and SSRS. Works with the CIO and Senior Management throughout the business on a daily basis. Executed a Master Data Management initiative for the organization. Implemented a new Sales Commission system integration and Learning Management system. Provides IT management expertise in standard SDLC best practices for projects across the organization. Manages both direct and offshore technical resources with Agile.

Provided data warehouse and Business Intelligence solutions for the Federal Facilitated Marketplace (FFM) changes to the CMS National Data Warehouse. Leads the analysis of all aspects including business operations, ETL, BI reporting and Data Model re-designs for the team. Provides a detailed analysis and recommendations to the customer as well as a road map and implementation plan. Works with all levels of management on a regular basis. Meets directly with CMS in order to obtain feedback and requirements. - Managed the day to day operations of the implementation of the Federal Facilitate Marketplace (FFM) reporting solutions for the CMS National Data Warehouse (NDW). This included the complete SDLC for data integration and the development and implementation of multiple Dashboards and Heat Maps. Works closely with CMS senior management to define the scope and understand requirements. Manages multiple work plans as well as risk and issue matrix. Provides continual progress reports to management. Leads discussions with team leads on a daily basis. Provides technical advice and vision to the customer and program on a regular basis.

Lead a team of BI professionals on architecture, planning and implementation of BI Reporting. Manages the operations and development (both ETL and BI reporting) of a financial data warehouse. This includes making necessary ETL changes and design and implementation of dimenionalized data tables in order to allow for actionable business intelligence. Utilizes IBM DataStage 8.x, Cognos 10 and PeopleSoft.EPM. Manages multiple projects and works effectively with a professional team in a complex and challenging environment.

Performs business analytics on data warehouse to create dashboards and scorecards. Conducts analyses using Informatica tools, Oracle 11g and Microstrategy 9.x. Responsible for summarizing results and providing business presentations to the client and internal technology teams. Evaluates data warehousing tools and technologies in a controlled environment and develops comparisons with other tools and technologies. Conducts statistical analysis and data mining analyses and create executive summaries. Works closely with business users to perform detailed business analyses and identify and present industry best practices. Performs data quality analysis including identifying data quality issues and develop approaches to improving data quality. Identifies data quality rules, creating data quality dashboards for profiling and monitoring overall data quality process improvement. Identifies industry trends and best practices for call center data warehouse and create presentations to other team members. Identifies Key Performance Indicators (KPIs), common metrics, and output requirements and expectations to meet outlined business goals. Collaborates with NDW team leaders to prioritize data warehouse best practice recommendations and develop detailed implementation plans.

Implemented the complete FADS solution for the State of Iowa as the lead Project Manager/Technical Architect for the Design, Development and Implementation (DDI) of the Fraud Analytics Detection System (FADS) for the State Iowa Medicaid. This includes the system design, data analysis and data mapping, datamart creation, Business Intelligence and programming efforts. Handled risk analysis and issue escalation as well as the day to day project workplan. Meets with executive management on a regular basis. Responsible for all resource allocations as well as time management for the entire team. Draws from technical experience to work together with product managers, technical professionals, third party consultants as well as State employees to bring the FADS suite of products and analytics on-line to surpass customer expectations. Familiarity of source Medicaid MMIS systems as well as defining metadata and medical coding as required. -Regularly assists management with pre-sales efforts including RFP/RFS responses, technical proposals for the FADS product in addition to data architecture and technical drawings and summaries as necessary. Attends formal presentations as required.

- Architect and design warehouse schemas and ETL/ELT Microsoft SQL Server SSIS in order to integrate it to their existing infrastructure for a number of clients including the Government of Bermuda Department of Statistics and the Department of Tourism utilizing industry standard Service Oriented Architecture (SOA) methodologies. - Architect of Business Intelligence environments for multiple integration platforms via Microsoft SQL Server Reporting Services and Business Objects.- Lead a team to fulfill overall project obligations within time and budget including business analysts, dba’s, developers, project managers and sales staff as well as other technical consultants.- Lead pre-sales technical efforts in the areas of data integration and business intelligence for the company. - Analyzed customer requirements and lead development of formal technical responses with all parties. - Prepared and delivers tailored system demonstrations to customers and executive management as required. - Worked with customers to define and document and implement their data integration and BI requirements.

- Managed data warehouse development including data modeling, data analysis/design, cube building and ETL. Utilized Oracle, Informatica and other proprietary ETL tools as well as Business Intelligence applications such as Hyperion Brio/EssBase, Oracle Discoverer, and Crystal Reports. Worked with Senior Management, third party consultants, programmers, DBA’s and data warehouse analysts on a daily basis to assign tasks and run large and complex projects on-time and on-budget.- Lead Data Architect on Business Intelligence & Reporting projects in order to leverage the use of the data warehouse within the organization. - Cut professional consulting costs by managing the development side of a company-wide data warehouse including data analysis, data integration and all ETL functionality.- Mapped over 1500 fields from multiple sources including legacy systems, SAS extracts, Oracle and Sql Server databases as well as other network based applications.- Managed the development, implementation and administration of the Oracle Financial Services Application Suite (OFSA) for a multi-billion dollar financial institution. - Worked with Senior Management to implement a Funds Transfer Pricing (FTP) process for all banking products in the organization in order to manage costs across the company. - Supported Senior Management in the collection and distribution of data structures for critical external sources including government regulators and investment banks.