2008 Microsoft Enterprise Insight Award for Business Intelligence Implementation was awarded for a recent implementation at a client.
Proven ability to partner with the business and translate complex business problems into effective technical solutions.
Honesty, integrity, work ethic, encouraging and mentoring others are as important to me as my technical strenghts.
·Oracle and SQL Server Database and Data Warehouse Architect and Developer with expert skills in Database Design, ANSI SQL, PL/SQL, and T-SQL.
·ETL Design and Development using Informatica and SSIS.Experienced in developing sophisticated workflow, data mapping, and transformation pipelines from diverse sources.
·Multi-Dimensional OLAP Cube Design and Development using SSAS.Experienced in cube partitioning, Dimension processing, and support for incremental cube update processing.
·Operational and Analytic Reporting Design and Development using SSRS, Crystal Reports, and Tableau.
·Data Modeling using Enterprise tools such as PowerDesigner and Oracle Designer.
·Data Warehouse Architecture, Design and Development.Experienced in building both Inmon (CIF) and Kimball DW architectures utilizing 3NF, and star/snowflake schema dimensional models.
·Building sophisticated Executive Dashboards and Analytics in Qlikview and Tableau.
·15 years experience in developing Commercial OLTP and OLAP Solutions, sold to Fortune Companies, such as Rexall Vitamins, Tupperware, and Retek.
Solutions built and successfully deployed include:
·A data warehouse and BI solution complete with Executive Dashboards and Analytics for a retail company with over 300 stores.This solution enabled business executives to spot key sales, revenue, and cost trends that were not visible in the operational store data.
·A data warehouse and BI solution complete with Executive Dashboards and Analytics for a major fast food franchisor.This system was used to audit the revenue and compliance of franchisees. This solution could potentially help save the company millions of dollars.
·A pharmaceutical data warehouse for a major hospital authority.The warehouse was used to show analytics and trends for inpatient and outpatient pharmacy records, and to help identity improvements in prescribing generic drugs over non generic drugs.
·The backend database architecture for a major commercially sold document management system for the trucking industry.This solution enabled the business to provide online document management to their major customers.
·A CRM Application enabling campaign management, call center order management and customer care. This solution was used by customers with the call centers, such as Nikon.
·A commercially sold and supported order and sales commission management application utilized by companies such as Tupperware, Rexall, UniCity, and Retek.Tupperware alone used this system to calculate commissions and compensate over 25,000 representatives each month.
·A commercially sold Hotel Property Management System, in production at hundreds of hotels.This solution automated reservations, front and back office for the hotels, significantly increasing productivity and reducing overall costs.