We provide IT Staff Augmentation Services!

Lead Architect Consultant Resume

Seattle, WA

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

Hire Now