AREAS OF EXPERTISE:

• Advanced Analytics: Statistical Framework Design Root Cause Analysis
• Project Management - Cross Functional Teams
• Strategic BPI and Technology Planning
• SDLC expertise (LEAN, AGILE, SCRUM)
• Data Architecture, Dimensional Modeling (Kimball, Inmon)
• Advanced SQL coding (Oracle, SQL Server, Teradata, Scope)
• BI Platforms- SQL Server 2008-2014 Data Tools (SSIS, SSAS, SSRS, Power Pivot, Power BI); SAP/ BO, Crystal, Everest; Cognos; LOGI Info Studio, Tableau
• Technical Authoring - ER Diagrams, Data Models, System Specs, Technical Manuals
• ETL Development (SSIS, Attunity CDC, Big Data pipelines: Cosmos, ETL Manager,Redshift, JobMan, Metrics Explorer)
• Data Flow & Operational Process Mapping
• Healthcare
• Biotechnology
• High Tech
• Non-Profit
• Wireless
• E-commerce
• Global Supply Chain
• Web analytics
• Telecom

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Lead Architect Consultant

Responsibilities:

• Provided end-to-end vision to translate Logical design to Physical design and how data should flow through different stages
• Created optimal and scalable solutions for data migration, including: Validation, Clean-up, and mapping processes
• Created focus and gravity towards Standards & Best Practices

Confidential, Seattle, WA

Senior Business Analyst / Data Engineer II Consultant

Responsibilities:

• Identified BPI opportunities and provided evidence for ROI support & root cause analyses
• Used advanced SQL to merge disparate datasets
• Provided ad-hoc analyses, Tableau and Excel-based reporting solutions
• Overhaul of Reporting and Data Asset infrastructure, authored processes and set guidelines for deployments

Confidential, Seattle, WA

Senior Strategy & Analytics Consultant

Responsibilities:

• Identified hot spots in utilization and medical claims flow for deep dive analysis
• Identified BPI opportunities and provided evidence and ROI support analyses
• Used advanced SQL to merge disparate datasets and eliminate manual chart manipulation
• Provided ad-hoc analysis, SSRS and Excel-based reporting solutions
• Overhaul of Reporting and Data Asset infrastructure, authored processes and set guidelines for deployments

Confidential, Seattle, WA

Senior Technical Analyst/Developer

Responsibilities:

• Successful deployment of new reporting solution, providing new levels of accuracy and granularity to executives and field teams abroad
• Drove contemporary data warehousing, governance and stewardship principles to transform non-conformed and disparate data sources into a scalable and manageable data asset framework
• Provided immediate value by filling in on other BI teams to perform technical analysis and SQL development

Confidential, Seattle, WA

Senior BI Consultant

• Performed functional analyst and solution architect roles for redesign of web analytic data pipeline for 100,000+ server cluster.
• Design abstraction and aggregation strategy for 2.4 billion rows/day of web analytics data
• Designed a big data to mono-server database architecture to allow reporting of large datasets, sliceable by many dimensions and grains; consumable by standard reporting tools

Confidential

Senior BI Consultant

Responsibilities:

• Provided analysis and direction for measuring success of campaigns and new customer experiences
• Drove contemporary data warehousing, governance and stewardship principles to transform non-conformed and disparate data sources into a scalable and manageable data asset framework
• Worked with engineering teams and product managers to implement new web analytics technologies

Confidential

Senior BI Consultant Big Data Analytics

Responsibilities:

• Gathered business and technical requirements product managers and OSD leadership
• Worked with multiple SMEs to understand business requirements
• Designed and built visually appealing and intuitive automated reports and Excel based reporting solutions for ongoing measures and BPI initiatives
• ETL for aggregation of petabyte sized data streams into Microsoft BI stack
• Designed dimensional data warehouse (Inmon) to feed cubes and ad-hoc data needs
• Effected changes in Scorecard measures making them more consumable and specific
• Provided ad-hoc analysis; maintenance of existing solutions

Confidential, Seattle, WA

BI Consultant

Responsibilities:

• Gathered business and technical requirements from Solavei leadership team
• Overcame technical shortfalls and knowledge gaps associated with startup environments
• Worked with multiple SMEs to understand business requirements
• ETL for Mirror and Production Data warehouses
• Created DW structures to integrate and perform validation across multiple vendor systems
• Provided ad-hoc analysis, SSRS and Excel-based reporting solutions

Confidential, Seattle, WA

BI Report Developer Analyst

Responsibilities:

• Gathered business and technical requirements from Microsoft’s EduTracker team
• Worked with Microsoft statistician to tie DW and dimensional model to SPSS system
• Provided interactive reporting via Power Pivot in Excel

Confidential

Senior Analyst, Business Systems

Responsibilities:

• Worked with Channel Management team on a major corporate initiative around customer experience.
• Performed rapid sizing and lift determination of potential advertising campaigns and internal process reworking based upon statistical analysis of ERP, GIS, engineering and customer survey data sources.
• Worked with DT statisticians in the creation of an analytical framework for research data to assure accuracy and reproducibility of research findings.
• Creation of cutting edge BI reporting solutions and visualizations in SSRS and Excel.
• Gathered business and technical requirements across different arms of the organization
• Researched key data elements and reconciled numerous, disparate, and Big Data business systems into a conformed data analysis framework
• Designed and built visually appealing and intuitive automated reports and Excel based reporting solutions for ongoing measure of BPI initiatives
• ETL for manipulation of data to provide automated reporting from big datasets
• Replaced existing manual, analyst intensive spreadsheet solutions
• Facilitated data and UAT for reports to ensure accuracy

Confidential

Senior BI Report Developer Analyst

Responsibilities:

• Worked with Microsoft marketing team to achieve global alignment of business processes by creation of contemporary BI reporting solutions and visualizations.
• Aggregate and compile campaign data related to Microsoft’s Partnership programs to ensure they are aligned with the partner campaigns and campaign effectiveness.
• Gathered business and technical requirements from Microsoft’s Partnership team
• Overcame roadblocks of understanding of key measurements to ensure appropriate representation of stakeholder business needs
• Researched key data elements to feed into data requirements
• Designed new measures in SSAS for production reporting
• Designed and built automated Excel based reports using PowerPivot to analyze key business objectives across multiple domains of information and systems
• Facilitated data and user testing for reports to ensure accuracy

Confidential, Portland, OR

Business Intelligence Developer / Technical Business Systems Analyst

Responsibilities:

• Spearhead best practices for the BI team at a billion dollar, 6-continent corporation.
• Evangelized BI solutions to business domains.
• Developed scorecard measures for extremely complex global supply chain logistics.
• Implementation of next-generation data driven decision making tools: BI workspaces, dashboards, scorecards, and automated reporting.
• Migration of Oracle, Everest, and other unsupported solutions to Microsoft BI Stack and SharePoint BI architecture.
• Creation of a contemporary dimensional data warehouse with cross-domain interoperability and conformed dimensions.
• Requirements gathering and analysis of complex business systems
• Propose solutions to shortfalls and technical issues in business systems
• Consensus building to overcome organizational roadblocks
• ETL of existing Oracle data warehouses into MS BI Stack
• Migrate extremely complex unsupported data sources into BI Platform
• Design scorecards and dashboards within SSRS, Power Pivot and SharePoint for Strategic Objectives, Innovation Improvement & Quality, Sales & Marketing, Supply Chain, and EHS business domains
• Design of new BI Data Warehouse, Staging Area, and ODS from multiple existing data warehouses
• Conform existing OLAP/ Dimensional models to governance model
• Implementation of Change Data Capture/ near-real time data warehouse to overcome globalized information needs

Confidential, Portland, OR

Technical Business Systems Analyst

Responsibilities:

• Provided integration and reporting solutions during BI implementation for a grant administration trust.
• Assisted trade allies including Lockheed Martin, Solar City, PGE, and NWN with data analysis and contract compliance.
• Worked with Business Systems Team, Application Development Team and Operational Managers to achieve optimal data structures and reporting solutions in SSRS and Crystal Reports.
• Development of BI-optimized reporting structure to supplant existing report repository
• Design of Logical Data Model/Schema, Operational Data Store/staging processes
• Data transformation into flattened hierarchal structure and conformed dimensionality for BI Reporting
• Integration of web form data into BI platform
• Liaise with outside project coordinators to gauge shortfalls and discrepancies in operational data, propose and enact solutions
• Migrate unsupported data sources into BI Platform

Confidential, Hillsboro, OR

Clinical Intelligence Specialist / Data Mining Analyst

Responsibilities:

• Championed and developed KPI and Dashboard measures under Balanced Scorecard Strategy Map as Measure Analyst
• Analyst/Developer for JAD team- designed functional specifications, underlying OLAP structure; developed query logic for the more advanced/difficult reporting solutions
• Achieved intra-departmental consensus of data standards for sales, management accounting, operational, and business partner performance data
• Led cross-functional teams to conduct ROI, cost/benefit, and root-cause analysis for enterprise system re-engineering and business process improvements.
• Transformed processes/toolsets of geographically dispersed business units into a cohesive, standardized set of solutions that elevated efficiency and accuracy company-wide
• Conceptualized and developed new measures of operational processes which brought average clinical access times down by 35%
• Developed automated solutions for previously manual, time-consuming processes to drive gains in data tracking/accuracy, workgroup efficiency and profitability
• Identified and provided solutions for numerous discrepancies and flaws in the existing Data Warehouse/OLAP structure
• Worked with business stakeholders to provide support for migration of unsupported/siloed data sources into IT infrastructure
• Serviced ad hoc reporting needs of senior management. Consistently stayed ahead of schedule to ensure high satisfaction rates by providing definitive results and anticipating future needs of stakeholders