SUMMARY

• System architect with a distinguished career that has consistently resolved complex business problems with innovative technical solutions.
• Successfully designed, constructed, and delivered Business Intelligence (BI) solutions in business - to-business, financial services, insurance, healthcare, retail electricity, and gaming and hospitality industries.
• Possesses the complete package of problem-solving, analytical and technical abilities, and business acumen enabling the translation of even the most complex business domain into a successful BI architecture.
• Utilizing strong verbal and written communication skills with all stakeholders and team members, successfully delivers maintainable and extendable solutions.
• Frequent contributor to the Microsoft SQL Server Analysis Services (SSAS) forums and was awarded a Microsoft Community Contributor Award for both 2011 and 2013.

TECHNICAL SKILLS

Relational Databases: SQL Server, Oracle, DB2(AS/400)

OLAP Databases: SQL Server Analysis Services (SSAS), Essbase

Reporting Tools: Tableau, SQL Server Reporting Services (SSRS), Excel, ExcelWriterCrystal Reports, ProClarity, BusinessObjects

Master Data Management: Master Data Services (MDS), Kalido

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS)

Programming Languages: Transact SQL (T-SQL), C#, PL/SQL, Visual Basic .NET

SCM Tools: Git, Team Foundation Server (TFS), PVCS

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Application Developer Lead Global Technology Infrastructure

Responsibilities:

• Architected an ETL framework based on the SQLBI methodology that allowed incremental loading of over 30 sources and facilitated the rapid onboarding of additional data.
• Implemented an innovative modeling of a rapidly changing organizational structure that allowed for accurate historical reporting of employee counts and improved financial allocations.
• Architected, implemented, and augmented an SSAS cube that facilitated near real-time reporting on several key source systems permitting the application to operate in both analytical and operational capacities.
• Integrated MDS into dimensional ETL processes allowing for self-service modifications to SSAS hierarchies based on frequently changing business requirements.
• Extended SSAS functionality enabling clients to retrieve detailed information on aggregated data which allowed the application to fulfill both executive and operational reporting demands.

Skills Used: Kimball Methodology, SQL Server 2012, SSIS, SSAS, MDS, C#

Confidential, Las Vegas, NV

Application Developer

Responsibilities:

• Implemented an SSIS ETL Framework to extract patron credit data from an iSeries DB2 database into a SQL Server staging database that allocated payments to markers resolving data discrepancies between operational reports and financial statements that had existed for over seven years.
• Implemented a Global Credit data mart and SSAS cube that facilitated self-service reporting.
• Implemented a Master Data Services solution that allowed Direct Marketing to track and maintain exclusion lists.
• Integrated email marketing response data into the data warehouse that allowed Direct Marketing to evaluate the effectiveness of marketing campaigns.

Skills Used: SQL Server, MDS, SSIS, SSAS, SSRS, SharePoint

Confidential, Houston, TX

Senior Data Warehouse Architect

Responsibilities:

• Utilizing the Kimball methodology, designed, developed, and deployed a logical and physical data model that consolidated data from multiple source systems providing for the first time, a single trusted source of information.
• Developed SSIS packages to extract, transform, and load claims payments, member eligibility, call center consults, and facility site survey data providing reliable and easily maintainable operational processes for loading of the primary data marts.
• Developed SSIS packages to construct secondary data marts that encapsulated business definitions dependent upon data from multiple business providing a source of consistent and centralized business metrics.
• Designed, developed, and deployed a single SSAS cube composed of measure groups for claims, member eligibility, radiation consults, and facility assessments that facilitated the rapid construction and delivery of Tableau dashboards and reports.
• Designed, developed and constructed report procedures against SSAS utilizing ExcelWriter templates which automated and replaced existing manually produced reports allowing for analysts to focus on interpretation of the results rather than the integration of disparate data sources.

Skills Used: Kimball Methodology, SQL Server, SSIS, SSAS, ExcelWriter, MDX, Tableau

Confidential, Houston, TX

Data Warehouse Architect/Database Analyst

Responsibilities:

• Designed a common data interface for incorporating line of business policy and claim data into an enterprise data warehouse streamlining incorporation of future acquisitions.
• Constructed a single set of SSIS packages shared by all subsidiaries to load data into the data warehouse, incorporate reinsurance consistently, and standardize unearned premium and IBNR calculations.
• Designed, constructed, and implemented an Analysis Services cube defining a single gateway into the data warehouse and providing a rapid delivery of information.
• Constructed an initial set of reports in Reporting Services to facilitate reconciliation with line of business systems and financial closing.
• Designed and constructed a .NET application to create and maintain treaty information including accurate handling of reinsurance commutations and cutoffs significantly reducing the manual effort previously required.

Skills Used: Dimensional modeling, SQL Server 2005, SSIS, SSAS, SSRS, MDX, .NET

Confidential

Responsibilities:

• Collected data from several business processes and used DTS to transform and load the information into a single SQL Server customer profitability data mart.
• Developed a solution combining DTS, Excel, and MapPoint that enabled business analysts to redefine customer sales territories by required level of service and sales responsibilities.
• Designed, constructed, and published Analysis Services cubes and a SQL Server DataMart enabling financial analysts to identify less profitable customers using ProClarity or Access.
• An executive reporting application was constructed to consolidate financial profitability information for the Shell Oil Products merger with Pennzoil-Quaker State (PQS). The system was used to track bottom-line financial performance of the major product divisions as well as monitor the financial performance of major market segments.
• Rewrote existing SQL Server procedures obtaining an 85% reduction in the required time to allocate financials.
• Reengineered a poorly performing Analysis Services cube reducing total processing by more than 50% while improving query responsiveness by more than 90%.
• Implemented Type 2 SCD techniques and Kimball helper tables in the account dimension to prevent restatement of profitability allocations in prior months with on-going account changes.

Skills Used: Dimensional modeling, T-SQL, SSAS, DTS, ProClarity, MDX, MapPoint, Access