SUMMARY

• 20+ years IT experience
• 10+ years Data Modeling, Data Warehouse architecure, and Dev. experience (SQL - 7, 2000, 2005, 2008, 2012, 2014) as well as Azure Data Warehouse.
• Exprience with Teradata development less than 1 year
• Experience with Oracle, using TOAD, less than 6 months
• ETL experience starting in 1997 with DTS (precursor to SSIS) allthrough to SSIS 2012
• Wherescape Red (for ETL) Less than 6 months.
• Relational and Dimensional Modeling experience with SQL Server, SSIS, and SSAS-- Multi-dimensional OLAP, Tabular OLAP
• 17 years combined OLAP experience (Grange Insurance, North West Behavioral Services, Confidential, etc.)
• 7+ years of experience working with SPSS- experience is dated, but can ramp up easily
• 1+ year working with SAS ( Confidential ) - experience is dated, but can ramp up easily
• Some familiarity with R statistical programming, but never used it extensively, professionally
• SSAS Data mining > 3 years
• Some experience with C# > 1 year
• Some experience with Erwin in the past, but most recently VISIO
• Average communication skills - accent, but fluent English

TECHNICAL SKILLS

Database: Data Warehouse, BI

MS SQL: 15years (Modeling/Architecture using mostly KIMBALL, but also INMON)

Analysis Services: 13 years (MS-OLAP, MS-SSAS 2000, SSAS 2005, SSAS 2008, SSAS 2012, MDX)

SQL: Server Reporting Services(2000, 2005, 2008, 2012) 8years SSRS

Power: PIVOT /PowerBI > 3 years

Statistical Programming: SPSS (Parametric/NonParametric) 7years; SAS 2years; R < 1 year; SSAS Data Mining > 3 yrs.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Senoir Business Intelligence Consultant

Responsibilities:

• Maintenance of existing ETL processes (SSIS packages, and SQL jobs) for loading data from multiple servers SQL Server (2012, 2014, 2016).
• Maintenance of existing Multi-dimensional OLAP cube for Motorsport games.
• Create a new TABULAR model for Multiple Motorsport games, using Azure Analysis Services.
• Create Azure Data Factory (ETL) and Model refresh processes using C# Console Application, Azure functions.

Confidential, Kent, WA

Senoir Business Intelligence Developer

Responsibilities:

• Maintenance of existing Meta-data driven ETL processes (SSIS packages, and SQL jobs) for loading data from ERP system (QAD) into SQL Server (2008, 2014).
• Developed Self-Service utility (Tabular Model/Excel/PowerPivot/PowerBI)
• Developed ETL for Operational Analytics(Procurement data management).
• Maintenance of data marts for varying reporting needs (e.g. Inventory tracking, Customer analytics, Procurement analytics).
• Maintained and modify SSRS Reports/ dashboards.
• Recommend and develop business intelligence analytics, using Power BI (similar to Tableau).
• Developed SSIS package for SFTP data processing for bank payment transactions (using WinSCP, C#, SSIS 2014).
• Managed Database Replication.

Confidential, Seattle, WA

Business Intelligence Developer

Responsibilities:

• General architecture and modeling of data warehouse/data mart, as well as ETL design and Integration processes.
• Relational and Dimensional reporting architecture.
• Developed data mart (multi-dimensional modeling) for the Merchant Analytics team (T-SQL, Teradata Database).
• Re-engineered data mart and data load processes for Customer Analytics (T-SQL, Teradata Database, some Oracle using TOAD).
• Provided maintenance and revision of Fulfillment Analytics (facts/metrics, KPI) (T-SQL, Teradata Database).
• Developed data mart for Leased Boutique Reports (T-SQL, Teradata Database, Wherescape RED).

Confidential, Redmond, WA

Business Intelligence Developer

Responsibilities:

• Used EIP (a Custom ETL tool) to extract and load data into Data Warehouse.
• Created views for data mart use.

Confidential, Redmond, WA

Senior Business Intelligence Developer

Responsibilities:

• Perform Maintenance of existing OLAP cubes (StayCurrent, Build)
• Perform maintenance of ETL (SSIS, Data mart based on Kimball architecture)
• Perform Maintenance of existing SSRS report on ReportServer and Sharepoint
• Developed new OLAP cubes

Confidential, Redmond, WA

Senior SQL Developer/Data Analyst

Responsibilities:

• Architecture and modeling of reporting data mart (relational and dimensional modeling).
• Responsible for ETL architecture and Integration Processes (using SSIS).
• Architecture and design of SSAS/OLAP cube.
• Developed ETL (SSIS, Datamart--Kimbal Architecure), and SSAS Cube for HDInsight Service Utilization analysis.
• Built reporting/analytics applications (SSRS) using Multi-dimensional OLAP as well as TABULAR OLAP (BISM), using PowerPIVOT, precursor to PoweBI.
• Developed data validation stored procedure and SSIS Package for processing and validating data from MDS (Master Data Service--Billings, Fabric Controller data, etc.) data source into the WACAP data warehouse.
• Developed SSIS Package for processing and validating data from Fabric Controller data source into the WACAP data warehouse.
• Developed SSIS package to automate update of weekly performance scorecard. The scorecard/dashboard was built using PowerPIVOT, precursor to PoweBI.

Confidential, Redmond, WA

Senior Systems Analyst

Responsibilities:

• Create KPIs for Core Business Scorecards (SQL-2008, SSAS 2008, Excel PivotTable)
• Create and maintain Excel Web Parts for scorecards
• Deploy and maintain scorecards on Sharepoint Server

Confidential, WA

Senior Software Developer

Responsibilities:

• Architecture and modeling of reporting data mart.
• Architecture and design of OLAP cube.
• Developed Claims Data Warehouse using SQL-server 2000 and 2005. This data warehouse(based on INMON) was then combined with the premium data warehouse to develop enterprise OLAP application, using SSAS 2005 and 2008. Client interfaces included Proclarity and MS-Excel pivot table.
• Using the OLAP application mentioned above, I developed Perspectives for different users—Claims, Actuary, etc.
• Optimized and Maintained (OLAP) application previously written in SSAS 2000 for insurance premium Data. I improved the original ETL(SSIS) which reduced the entire ETL and OLAP processing to a couple of days, instead of the previous two weeks. I also re-wrote MDX queries—especially for calculated measures
• Using Reporting Services 2000, 2005, 2008 developed Reports for different group of users including: Accounting, Actuary, and Claims departments
• Report projects were generally based on two sources—Datawarehouse, where T-SQL (with SSIS) was used since the data source was relational database; Analysis Services Cube, where MDX was used, since the data source was multi-dimensional data.

Confidential, WA

Software Developer

Responsibilities:

• Developed SQL-Server/VB Application for testing MSO ( Confidential Server Object) for SQL-Server 2005.

Confidential, WA

Information Systems Analyst II

Responsibilities:

• Developed SQL-Server/VB application for the study of marine fish.
• Enhancement programming of water sampling application (SQL/Access/VB-COM).
• Developing organization-wide project tracking application (SQL/VB).

Confidential, WA

Database Developer

Responsibilities:

• Developed SQL-Server databases for a Web-based Report Application (MediaReports Versions 2.0, 2.1, 2.1.1, 2.5).
• Performed logical and physical database design, modeling, and coding.
• Wrote Stored Procedures, Triggers, and views for report requirements.
• Performed SQL-Server database administration (performance tuning, optimization, back and recovery, granting/revoking rights, etc.).
• Managed Crystal Reports development project.

Confidential, WA

Programmer

Responsibilities:

• Performed maintenance programming for Human Resources Application (SQL-Server, VBA-Access).
• Developed Benefits Plan (Stock options) Application (SQL-Server, VBA-Access/Excel).
• Developed Financial/Billing Report Application (Oracle, VBA-Access).

Confidential, WA

Programmer

Responsibilities:

• Object Oriented Programming--OOP (Used VB6 to develop parts of business objects used for inventory management system).
• Upgraded VB4 Applications to VB6.
• Developed Vendor Tracking Application (VBA-Access, DAO, FTP).
• Performed maintenance programming for Retail/Inventory Application (VB6, VBA-Access).
• Developed Benefits Plan (FMLA) Application (VBA-Access).

Confidential, WA

Application Developer

Responsibilities:

• Developed Utilization Report Application (SQL-Server, VB4, Crystal Reports).
• Developed OLAP (MS-SQL 7.0) application for Mental Health services.
• Developed Billing/Revenue Report Application (SQL-Server, Crystal Reports).
• Customized SQL server Database, using stored procedures, triggers, etc.
• Developed data mart using views, and stored procedures.
• Developed Visual Basic application front end to optimize Crystal Reports.

Confidential, WA

Data Analysis

Responsibilities:

• Performed Systems Analysis.
• Designed and Managed Access Database.
• Developed Reports, using Crystal Reports and Access
• Developed User Interface, using Visual Basic4 (DAO).

Confidential, WA

Health Information Analyst

Responsibilities:

• Used SAS (v. 6.10) for Statistical Analysis of Data from SQL-Server databases as well as Flat files.
• Developed Utilization Report Application (SAS 6.10, VBA-Excel).
• Developed Financial Report Application (SAS 6.10, VBA-Excel).
• Used CHARS data to perform statewide analysis of in-patient hospital utilization.

Confidential, WA

Data Analysis

Responsibilities:

• Performed Systems Analysis
• Designed and Managed Databases for publicly funded HIV/AIDS prevention programs (VBA-Access).
• Developed Report Applications for publicly funded programs (VBA-Access).
• Developed User Interface, using Visual Basic4.

Confidential, Tacoma, WA

Data Analyst

Responsibilities:

• Managed all department projects on outcomes measurement and analysis, resource utilization, and physician profiling,
• Performed research design and analysis of continuous quality improvement (CQI) projects, as well as patient satisfaction surveys.
• Used SPSS-PC to design, and analyze databases for clinical outcomes.
• Generated reports and statistics for several ad-hoc projects.
• Statistical models routinely used included: Chi-Square, T-test, One-way analysis of Variance (ANOVA), Multiple regression analysis, Kruskal-Wallis etc.

Confidential, Lincoln

Research Assistant

Responsibilities:

• Generated reports, charts, and statistics for social research projects.
• Used SPSS for research and statistical analysis.
• Wrote, administered and analyzed survey questionnaires.
• Research projects included: Social program evaluation, analysis of political and economic developments.