Yyyyyy x. yyyyyy

Details-Focused, Highly Accomplished Business Intelligence Leader who delivers dynamic end-to-end data solutions and design and implementation of cutting-edge technologies in alignment with a company s vision, value, and goals. Ambitious Self-Starter who offers performance-centric critical thinking for insightful, change-driven results. Visionary Professional who has been honored with a Personal & Team Commitment Award for rising above challenges to achieve winning outcomes, including quickly adapting to evolving scenarios to reach high productivity levels. Excellent Communicator who develops synergistic relationships with executive decision-makers, IT / business teams, and customers, and who leads peers by example and with integrity.

Manager Supply Chain Business Intelligence ￨ Data Strategies (2015 Present)

Capitalize on the opportunity to lead high-profile, customer-centric projects, including promoting excellence in Inventory Valuation Dashboard, Supply Chain Data Lake, and Reverse Supply Chain Dashboard initiatives.

Inventory Valuation Dashboard

  Led data preparation initiatives and created Microsoft OLAP cube.

  Collaborated with business functional leads to understand data and reporting requirements.

  Trained and managed super user and analyst community to do self-serve analysis, critical insight requests, and data extractions, and led translation of business requirements document.

  Created Tableau Inventory valuation dashboard to strategize store vs. warehouse stock levels and optimize inventory; achieved fewer out-of-stock for stores and increased customer value.

Supply Chain Data Lake

  Designed near real-time In-Transit Dashboard to xxxxxxin seamless product movement.

  Developed mobile alerts for wide-ranging job completion emails and / or data load status.

  Created Big Data Hadoop Data lake (HDFS) with Scoop and Attunity as ETL tools, Hive as a SQL query tool, KYVOS as a OLAP data modeling / cube tool, and Tableau 10.1 as a reporting tool.

  Created Data Dictionary for business process attributes, metrics definitions, KPIs, and formulas.

  Led Train-the-Trainer sessions in BI best practices, architectures, tools, methodologies, and software, and directed team discussions and project workshops on requirements xxxxxxthering, report / dashboard design, and business metadata collection to advance a BI platform.

  Developed and presented Data Lake Architecture to business and senior leadership to support structuring and analysis of large quantities of data and business information.

  Evaluated data storage hardware, ETL tools and techniques, data profiling and data governance tools, data query tools, and high-performance OLAP modeling tools.

Reverse Supply Chain Dashboard

  Served as an SME to create requirement documents and functional / technical specs.

  Led SAP BW data models and analysis for reporting initiatives for return warehouse of Verizon.

  Trained and coached end users in SQL query, ad hoc analysis, and Tableau self-serve platform.

  Designed and developed Tableau Reverse supply chain dashboards (i.e. Iconic Launch, Bid Sale).

Senior Business Intelligence Lead Enterprise Data Warehouse BI (2011 2015)

Strategically steered mutually beneficial relationship-building among internal business partners and external vendors, including collaborating with business stakeholders to translate business issues into technology solutions. Expertly identified and mitixxxxxxted project risks, and worked to develop database objects, T-SQL, SSAS, SSIS, SSRS, and Teradata. Developed, implemented, administered, and supported ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), DTS, and SSIS. Collaborated in the OLAP cube design and development, and migration of the Essbase and Cognos cubes to SSAS 2008 cube structure.

Yyyyyy x. yyyyyy ￨ Page Two ￨ (xxx-xxx-xxxx

Senior Business Intelligence Lead Enterprise Data Warehouse BI (continued)

Designed, developed, modified, and tested a performance dashboard. Created OLAP data models using ERWIN. Offered skill with data loads, database integration / conversions, performance tuning, and optimization of BI Applications, and with administration tasks of 8+ Executive BI Applications securities, roles, and access.

  Expertly developed and debugged Stored Procedures, Views, and Triggers.

  Created measures and dimension models using multidimensional expression, MDX.

  Led design and architecture of advanced Dimension Hierarchies and Attribute relationships.

  Optimized performance by redesigning old models using Star Schema and Snowflake Schema.

Project Lead

  Currently working on SQL 2012/2014 Migration.

  Created a new architecture to support Reseller (RSS) Reporting platform in Cognos 10.1/10.2.

  Microsoft Analysis Cubes Revenue, Revenue Account-Level, and Revenue Adjusted to the COO s yearly, quarterly, and monthly business objectives to improve core growth and revenue.

  Created and led 24x7 4 of 5 reporting sources for ARPA, APRU, and Total Service Revenue KPIs.

  Developed, supported, and managed Equipment Cube and Dashboard for HQ Finance reporting.

  Served as major point-of-contact for Reseller Finance Cube updates and Reconsolidation process.

Project Contributor

  2005 to 2008r2 SQL Upgrade ￨ Cognos 8.5 to 10.1/10.2 Upgrade

  B2B & Consumer Cube & Dashboard ￨ ETNI Cube ￨ Hyperion System 11 Upgrade

  MAM Cube & Dashboard ￨ Administrator of EDW BI Cognos 10.1 Multi-Server Environment

  Churn Dashboard Multiple cubes to support corporate-wide churn reduction of less than 1%

SQL Server BI Programmer Analyst (2008 2011)

Drove project success in the migration of databases to SQL Server 2005/2008 and generated databases and OLAP Cube Model Schema using MS Analysis services 2005/2008. Xxxxxxthered requirements from business users, and wrote user requirements documents based on functional specs; designed physical and logical data models (OLAP) using Erwin; and created DDL scripts, tables, views, SQL joins, and other T-SQL and PL/SQL code. Defined time series calculations to attain high-level reporting needs, including percentage comparisons.

  Enhanced data retrieval by fine-tuning database objects, partition tables, and cubes.

  Pulled data from multiple sources by working on Teradata FastExport scripts and UNIX.

  Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views, and SQL joins and statements for business applications, and developed SSIS Package for Data Cleaning, Data Transformation, and Loading into different sources for use in diverse BI projects.

SQL Server BI Programmer Analyst

Utilized broad scope of industry knowledge toward creating analysis layer and cubes using SSAS 2008 and Cognos BI, and created dashboards and scorecards using SSRS 2008 R2. Led requirements xxxxxxthering from business users, and wrote user requirements documents based on functional specs. Designed physical and logical data models (OLAP) using Erwin tool. Developed DDL scripts to create database schema and database objects, and created tables, views, SQL joins, and other T-SQL and PL/SQL code to implement business rules.

  Defined time series calculations for model to achieve high-level reporting needs.

  Efficiently migrated ESSBASE and COGNOS cubes to SSAS 2005/2008 cube structure.

  Developed custom project status KPIs as Executive Dashboard Parts for team projects.

  Developed financial and business module cubes using Microsoft analysis services (SSAS 2005/2008); end users used them as a dashboard tool application using SQL server 2005/2008.

  Worked on Teradata FastExport scripts and UNIX to pull data from different sources and UDM.

Yyyyyy x. yyyyyy ￨ Page Three ￨ (xxx-xxx-xxxx

MS SQL Analysis Services Developer

Played a vital role in migrating databases to SQL 2005 and generating databases for analysis using Analysis Services 2005. Led requirements xxxxxxthering from business users, updated functional specs and technical design documents, and wrote scripts for client requirements. Collaborated with developer in creating Stored Procedures, DTS packages, triggers, cursors, tables, views, and SQL joins and statements for applications. Designed and developed data marts and dimensional members using multi-dimensional models (MDX) (i.e. Star Schemas and Snowflake Schemas). Defined reference relationships with measure groups and fact tables.

  Personally handled Process Database Objects Security role.

  Designed physical and logical data models (OLAP) using ERWIN.

  Developed custom project status KPIs SharePoint Web Parts for project teams.

  Defined Dimension Granularity within a measure group and drill through actions.

  Created OLAP data models and cubes with parallel processing of cubes with SSAS 2005.

Master s Degree in Electrical & Communications Engineering College or University Name

Bachelor s Degree in Electrical Engineering College or University Name

Certified Business Intelligence Professional (CBIP) Business Analysis

Microsoft Certified Professional (MCP) SQL Server Business Intelligence (SSAS, SSIS, SSRS)

MDX OLAP Modeling Language ￨ IBM SPSS Mining Tool

Cognos Architect Design & Modeling ￨ Transformer OLAP Cubes

Microsoft SSIS ETL Tool 2012 ￨ Microsoft SSRS Reporting Tool 2012

Advanced SQL Writing ￨ Tableau Reporting ￨ Oracle Database Design

Microsoft SQL Server 2008 Database Implementation & Maintenance

Basic Data Scientist Training ￨ Agile Methodologies ￨ Advanced Excel 2010

Cognos Dashboard & Reporting ￨ Cognos TM1 Financial Planning & Analysis Tool

Implementing & Maintaining Microsoft SQL Server 2008 Reporting & Integration Services

Teradata SQL V2R6 ￨ Teradata Physical Implementation ￨ Teradata Performance ￨ Teradata Aster

Microsoft SQL Server 2014 (SSAS & In-Memory Cubes)

SQL Server 2008 R2 ￨ SQL Analysis Services (SSAS)

SQL Server Reporting Services (SSRS) ￨ SQL Server 2012

Visual Studio 2008 ￨ SQL Server Management Studio (SSMS)

Microsoft Office Professional ￨ Microsoft Visio ￨ Microsoft OneNote

Power BI ￨ SQL Server Integration Services (SSIS) ￨ SQL Query Analyzer

IBM Cognos 10.1 Query Studio Report ￨ TM1 ￨ SPSS

Framework Manager ￨ Transformer ￨ Analysis Studio

Enterprise Data Management Collibra ￨ Microsoft Master Data Services (MDS)

Data Warehouse Teradata SQL Assistant ￨ Fast Export ￨ BTEQ ￨ Multiload ￨ ASTER

SAP SAP BW HANA ￨ BW Cube Models ￨ Analysis for Office

Oracle Business Intelligence RPD ￨ Essbase ASO / BSO Cubes ￨ OBIEE 11G Reporting

Hortonworks Data Lake in Hadoop Big Data ￨ HDFS ￨ Attunity ￨ Scoop ￨ Hive ￨ Kyvos

Additional Proficiencies T-SQL ￨ MDX ￨ OLAP Data Models ￨ InetSoft ￨ Clarity ￨ HP ALM ￨ QlikView

Oracle SQL Developer ￨ Tableau 8.0 / 9.0 / 9.3 / 10.1 / 10.1 ￨ ESRI ￨ ERWIN ￨ Unix

Yyyyyy x. yyyyyy

Date

Hiring Agent Name

Company Name

Address

City/State/Zip Code

Dear__________________:

I am exploring a new career opportunity within a challenging [ Insert Job Title ] role, and I believe that I can make a positive contribution to your success.

To acquaint you with my background, I offer proven experience in Business Intelligence, Multi-Project Management, End-to-End Solutions, Team Building, End User / Super User Training, and Process Optimization. I am also highly skilled in Enterprise Data Warehouse, Strategic Analysis / Planning, Trends Tracking, Agile Methodologies / Best Practices, Customer Relationship Management, Partner / Vendor / Stakeholder Relations, Risk Mitixxxxxxtion, and Critical Workflow Prioritization, among other areas.

Currently, as a Manager of Supply Chain BI and Data Strategies for Verizon Wireless, I successfully lead multiple high-profile, customer-centric projects, including promoting excellence in Inventory Valuation Dashboard, Supply Chain Data Lake, and Reverse Supply Chain Dashboard initiatives.

A brief sample of accomplishments across each these three high-value projects include:

Inventory Valuation Dashboard

  Training and managing a super user and analyst community to do self-serve analysis, critical insight requests, and data extractions, and translating a key business requirement document.

  Creating a Tableau inventory valuation dashboard to strategize store vs. warehouse stock levels and optimize inventory; achieve fewer out-of-stock for stores; and increase customer value.

Supply Chain Data Lake

  Creating Big Data Hadoop Data Lake (HDFS) with Scoop and Attunity as ETL tools, Hive as SQL query tool, KYVOS as a OLAP data modeling / cube tool, and Tableau 10.1 as a reporting tool.

  Leading Train-the-Trainer sessions in BI best practices, architectures, tools, methodologies, and software, and directing team discussions and project workshops on requirements xxxxxxthering, report / dashboard design, and business metadata collection to advance BI platform.

Reverse Supply Chain Dashboard

  Serving as an SME to create requirements documents and functional / technical specs.

  Training and coaching end users in SQL query, ad hoc analysis, and Tableau self-serve platform.

Please note that I earned a Master s Degree in Electrical & Communications Engineering from College or University Name, and a Bachelor s Degree in Electrical Engineering from College or University Name. I also attained credentials as a Certified Business Intelligence Professional (CBIP) Business Analysis and Microsoft Certified Professional (MCP) SQL Server Business Intelligence (SSAS, SSIS, SSRS).

As this is just an example of my abilities, please refer to my enclosed resume for additional Senior BI Lead, SQL Server BI Programmer Analyst, and MS SQL Analysis Services Developer experience with high-profile Verizon, ESM (A Xerox Company), and Merrill Lynch.

I am eager to discuss how my qualifications uniquely match your current and future needs, and look forward to interviewing with you soon.

Sincerely,

Yyyyyy x. yyyyyy