MSBI, SQL Server, SSIS, SSAS, SSRS, Power BI

Ron Cash

at: https://www.roncashconsultant.com

ac7ucg@r.postjobfree.com

ac7ucg@r.postjobfree.com

925-***-****

DEGREE: Bachelor of Arts

SUMMARY:

Highly proficient BI Architect/Data Warehouse Architect

Database Expert

Data Modeling

Power BI Visualizations

C# when needed

At Pfizer Pharmaceuticals Implemented Data Warehouse BI & internal reporting, Architected Data Environment, reduced man hours, increased production, improved user experience.

Real estate loan portfolios for Bank of America were enhanced with real time BI analytics, saving dozens of hours in manual compiling of data.

Solid development experience with Microsoft technologies, especially SQL Server

Solid background in relational database design, table design, query/view design, stored procedures, form design, report design, T-SQL, user friendly interfaces

A former corporate controller with a strong understanding of the financial side of business

PROFESSIONAL EXPERIENCE:

Chevron, Inc. MSBI - Full Stack Developer, Power BI Jul 2018 – Oct 2018

Implemented Chevrons Environmental Management Power BI platform and Azure SQL Server backend.

Used SSAS cubes in as primary data source.

Designed the Strategy to bring Power BI Analytics to the entire Environmental company for improved analytics on worldwide operations of Site and Project management.

Implemented Power BI Strategy across the enterprise.

Brought Power BI live metrics directly to Product Mangers, Project managers and Project Analysts for real time monitoring of Sites and Projects.

The Power BI environment is Azure Data Factory, Azure SQL Server, Azure Data Lake. All of this pulling from multiple data sources through-out the enterprise including multiple instances of SAP.

Helped finance reduce manual processes for reconciliations from 4 hours to 3 seconds.

Delicato Family Vineyards – Senior Data SQL Server BI Architect Mar 2018 – Apr 2018

Results:

Lead the initiative for architecture and design in SQL Server, of the Enterprise Data Warehouse and of Business Intelligence, Metrics, Analytics and platforms across the organization.

Methodology:

Translated requirements into scalable DW architecture, for actionable business intelligence. Defined, Designed and implemented standards and best practices involved in BI, analytics, data modeling, for logical architectures.

Designed for use with SSAS cubes.

Worked with various stakeholders by applying knowledge of best practices to guide the DW initiative.

Developed enterprise conceptual, logical data models and semantic views across organization. Supported efforts to define, implement enterprise logical models.

Provided data definitions, domain values, data relationships, business rules, sources and data integration for the DW.

Provided ETL data integration for the DW using SSIS.

Boral Roofing, Inc. - BI Engineer/Power BI Developer/Senior Architect Nov 2017 – Mar 2018

Results:

Designed and Implemented a comprehensive enterprise Power BI platform, SQL Server.

Used DAX, MDX, SSAS

Provided new insights with Data Visualizations into Help Desk metrics using Power BI.

Set up automated report refresh schedule.

Implemented DEV, TEST and Production code promote environments.

Provided financial with Data Visualizations metrices for sales and revenue.

Set up automated data delivery with SSIS/ETL.

Created numerous SSIS/ETL processes to populate ODS and Data Warehouse from numerous sources, SAP, Oracle, SQL Server, Dynamics, etc.

Methodology:

I lead the strategic design and maintenance of business intelligence applications for the enterprise BI needs.

Integrated existing on-premise systems and data sources such as Data Warehouse data marts and cubes.

Worked on Identifying, researching, and resolving technical problems.

Acted as project lead for the overall corporate BI initiative!

Implemented BI cloud environment and related processes to allow users to develop, publish and share Power BI reports with departments located in countries around the world.

Provided new analytical services, reports, analysis, interpretation of data, and related strategies.

Lead initiatives to accomplish BI project goals for the entire enterprise.

Malwarebytes, Inc. - BI Engineer/Senior Architect Jun 2017 – Oct 2017

Results:

Worked to ensure the use of business intelligence applications enhances business decision making capabilities.

I Implemented a comprehensive enterprise Power BI platform.

Provided new insights into corporate budgets and planning by providing departmental insights to department managers which they did not have previously. This helped to reduce overall costs and provided effective future planning of financial resources.

Methodology:

Lead the development and implementation BI cloud environment and related processes to allow users to develop, publish and share Power BI reports with departments located in countries around the world.

Provided for and advised on business products, analytical services, reports, analysis, interpretation of data, and related strategies.

Strategic design and maintenance of business intelligence applications for the enterprise BI needs.

Worked on Identifying, researching, and resolving technical problems.

Acted as project lead for the overall corporate BI initiative!

Exercised independent judgment to accomplish BI project goals for the entire enterprise.

Roku, Inc. - BI Engineer/Senior Warehouse Architect Dec 2016 – May 2017

Los Gatos, CA

Results:

Saved tens of thousands in dollars by creating automated billing of web-based purchases for devices and services ordered on Sling, Hulu, Disney, etc.

Methodology:

Creating Data Warehouse and Business Intelligence system for financial analytics for global operations, using the Microsoft Business Intelligence stack.

Integrating data into data warehouse using SSIS for SQL Server. Consolidating financial systems into an integrated analytic system. Converting Oracle, MySQL, and NetSuite data into a dimensional model.

SSAS Analysis Services for multi-dimensional cubes.

This involves extensive system analysis, data modeling and data discovery of multiple systems to create a dimensional model for use with Microsoft analytic tools.

Technologies Utilized:

SSIS/ETL, SQL Server, SSIS, MDX, DAX, Power pivot, T-SQL, .NET, Office 360, Azure

Pfizer Pharmaceuticals - BI Engineer, Senior Data Warehouse Architect, SSIS/ETL Engineer Aug 2016 – Nov 2016

San Francisco, CA

Results:

Improved BI internal reporting, Architected Data Environment, reduced man hours, increased production, improved user experience. Created Power BI reports metrics to simplify user dashboards.

Methodology:

Integrating data into data warehouse using SSIS for SQL Server. Creating Data Warehouse and Business Intelligence system for financial analytics for global operations, using the Microsoft Business Intelligence stack. Consolidating Oracle and Hyperion financial systems into a unified integrated analytic system. Converting Hyperion Essbase cubes to a dimensional model.

This involves extensive system analysis and data discovery of multiple systems to create a dimensional model for use with Micro Strategy analytic tools.

Technologies Utilized:

SSIS/ETL, SQL Server, MDX, DAX, Power pivot, T-SQL, .NET, Office 360, SQL Server, Azure, Yardi, Agiloft

Shorenstein Realty - BI Engineer, Senior SQL Server Developer Feb 2016 to Apr 2016

San Francisco, CA

Results:

Improved internal reporting, reduced man hours, increased production, improved user experience. Pre-aggregated metrics were provided with Power Bi

Methodology:

Worked with Yardi Voyager for Real Estate and SSIS and SQL Server Management Studio extracting and integrating data with for data consolidations and business intelligence analytics.

Worked on Data Warehouse Integration using Informatica Cloud, SSIS and FTP sites. They have a cloud based help desk application. I integrated the cloud based database back end to extract real time and relevant data to be used in the company’s consolidated data store. This involved SSIS/ETL, data modeling, requirements gathering, capacity planning and data mapping to Informatica Cloud and using Informatica Cloud for integrating data to the company’s data stores.

Tested BigQuery for analytics.

Worked on process analysis and made recommendations when appropriate for enhancements to systems and processes. Worked on creating and documenting plans to implement enhancements for existing systems.

Worked with training needs of users. Designed training documentation and worked with users to enhance their effectiveness.

Provided Help Desk support for various internal applications.

Technologies Utilized:

SSIS/ETL, SQL Server, T-SQL, .NET, Office 360, SQL Server, Azure, Yardi, Agiloft, MS Access, VBA

Wells Fargo – Tableau, BI Jan 02016 to Feb 2016

San Francisco, CA

Results:

Creating Data Mart improved data process for online fraud, which showed ways to reduce online fraud, provided ways to validate trends.

Methodology:

Incorporated a Tableau BI dashboard for multiple Online Fraud applications and system data.

Worked with data warehousing, data architecture, data quality processes ETL processes.

Used various data sources and databases to blend data in Tableau. Also set up ETL routines to consolidate data into various data marts.

Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries.

Experience designing and developing data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching.

Ability to read, analyze and digest what the client wants to accomplish with its data, and design the best possible ETL process around those goals to discover new opportunities.

Experience with data modeling, especially using some or all of the following: Unified Modeling Language (UML), including Entity-Relationship Diagrams (ERD), Sequence Diagrams, and Dataflow Diagrams (DFD)

Created ETL integration for cross functional teams.

Experience developing executive dashboards and implementing design requirements based on discussion with an understanding of technical and visual design considerations.

Interacted with business users to identify dashboard strategies, report layouts, analysis and presentations.

Migrated existing legacy reports into Tableau while building new reports from our formal data warehouse initiative.

Technologies Utilized:

Tableau, SQL, Visual Studio, Teradata, SAS, ERD

Certain.com - BI Engineer/Senior Data Warehouse Architect Jan 2015 to Oct 2015

San Francisco, CA

Results:

Implemented database Data Warehouse BI, gave customers an online BI dashboard, improved customer experience and retention.

Methodology:

Certain.com is a web based event management company (SAS), which is a comprehensive event management platform is built for marketers and event professionals, such as Oracle, Harvard, Microsoft, etc.

Extensive SQL Server Management Studio work, involving heavy use of CTE’s, complex query development with outer joins, joins back to CTE’s, inner joins, unions, excepts and intersects.

Transferred data to Big Query for analysis.

Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.

SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type

conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.

Used C# for scripting task in SSIS, SSAS, SSRS, SSMS and Visual Studio.

I also worked on SQL Server backend architecture and extensive query performance tuning. The queries were initiated from the web interface, so they needed optimal performance to enhance the customer experience, when using the app.

All of this done in junction with Business Analysts, DBA and the testing group.

As lead SSIS Engineer I provided an ETL platform for customer analytics, which would be part of the web based customer experience. I automated data integration into a web based analytics tool (BIRST/Tableau) for web based

business intelligence, customer dashboards, reports, charts and graphs. And of course, this allowed for the customer to filter data, say for a region or the country. They can slice and dice the data on their customer web portal.

I also saw the need for a data warehouse and an ODS, Operational Data Store, which I architected and deployed using Microsoft SSIS. I also initiated the use of SSAS and cubes for the purpose of customer analytics. This was all part of a

“platform” initiative to improve overall companywide performance of the application, with the real goal of customer retention. It worked! ClickView reports used for fixed custom reports.

Technologies Utilized:

SSIS/ETL, SQL Server, T-SQL, Python, Visual Studio, .NET, BIRST, SSAS, Azure, MDM, DQS, Toad Data Modeler, Tableau

Ports America - BI Engineer /Senior Data Warehouse Architect Mar 2014 to Dec 2014

Alameda, CA

Results:

Improved company organization by giving real time insights into shipping operations in the loading yard. Gave corporate a consolidated view into port operations across the United States.

Methodology:

I provided Business Intelligence and Executive Dashboards for consolidation of numerous business units within the Ports America Portfolio of Companies. This enabled instant access to information for the entire portfolio of companies, enabling a more nimble and well-informed decision process for the entire enterprise.

Developed SQL Server Management Studio and SSAS cubes and Power BI for West Coast operations! Work closely with developers of the Port Manager software to determine analytics to integrate into SSAS. I worked with Union Contracts to determine labor costs to integrate into SSAS.

Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.

SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.

Used C# for scripting task in SSIS, SSAS, SSRS, SSMS and Visual Studio

Worked with Business Analyst to create user requirements and complex queries for data analysis.

Technologies Utilized:

SQL Server, MDM, DQS, Visual Studio, .Net

Yellow Pages - BI Engineer Senior Data Warehouse Architect Jan 2013 to Mar 2014

San Francisco, CA

Results:

Improved company operations by creating applications such as detecting robo calls, fax spam calls, etc. This created a better customer experience.

Methodology:

Using SQL Server Management Studio created and optimized stored procedures. Troubleshoot pre-existing stored procedures. Create and deploy tables, views, stored procedures, triggers, functions. Make changes on all database schemas with DDL scripts. Work with cross functional teams to architect database designs for custom in house applications. Recommend best practice designs for SQL Server.

Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.

SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.

Used C# for scripting task in SSIS, SSAS, SSRS, SSMS and Visual Studio.

Ron Cash Resume – (Yellow Pages Continued)

Added indexes where appropriate for optimized queries, defrag and rebuild indexes if needed. Developed complex queries, incorporating CTE’S.

I used SSIS for data warehouse environments accessing Oracle, Vertica, Teradata databases. Created SSIS packages for cross functional teams, such as email marketing. Implemented SQL Agent jobs and scheduled jobs. Used C# for scripting task in SSIS.

Technologies Utilized:

Daily use of T-SQL for schema changes, analytics, BI, data modeling, data cleansing, SSIS, Python.

Acco Brands - BI Engineer/Senior Data Warehouse Architect Dec 2011 to Oct 2012

Redwood Shores, CA

Results:

Consolidated financial data for 24 companies owned by Acco Brands. Gave better insight to corporate operations.

Methodology:

ACCO Brands Corporation is one of the world's largest suppliers of branded office products, which not many have even heard of. They market products in more than 100 countries through their own sales force and distribution networks. They have approximately 24 different companies, such as Kensington computer products, Wilson Jones, Cambridge, Swingline, Day-Timer, etc.

A global data warehouse improved financial understanding of the worldwide enterprise and gave them the ability to streamline operations and effectively compete in a competitive global market.

Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.

SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.

Used C# for scripting task in SSIS, SSAS, SSRS, SSMS and Visual Studio.

I worked extensively with SQL Server Management Studio in a global warehouse environment. I was responsible for setting up and managing connections to ERP systems in Europe, Australia, Mexico, Brazil, Columbia and Asia. I also created hundreds of SSIS packages to pull data from SAP, Oracle, SQL Server, DB2, Microsoft Dyanmics and various ERP systems for data consolidation in the enterprise. Implemented and enforced Master Data Management principles.

I leveraged SQL Server, SSIS, SSRS, SSAS and Cubes to consolidate data across the enterprise. SharePoint Server was also incorporated for a complete global solution.

Technologies Utilized:

SQL Server 2008, SSIS - BIDS 2008, SQL Server, MDM, DQS, SSRS, SSAS, T-SQL, XML, .Net 4, Stored procedures, Tableau

Bank of America - Senior SQL Server SSIS/ETL Developer Aug 2011 to Nov 2011

Concord, CA

Results:

Real estate loan portfolios were enhanced with real time analytics.

Methodology:

As Application Developer, I used SQL Server Management Studio & SSIS to create database tables and ETL packages to create a large Data Mart

Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.

SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.

Used C# for scripting task in SSIS, SSAS, SSRS, SSMS and Visual Studio.

SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type

Data conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.

Used C# for scripting task in SSIS, SSAS, SSRS, SSMS and Visual Studio...

I also created stored procedures, views and Sql scripts in support of business partners for financial analysis. I created an ASP.net interface. Used ADO to pull data directly into Excel based on multiple criteria selected in the Excel sheet.

Reports and calculations were made for reporting rates on interest and mortgages. Worked within a strong environment of Master Data Management while enforcing the Banks data policies.

Technologies Utilized:

SQL Server 2008, SSIS BIDS 2008, SSRS, T-SQL, XML, .Net 4, Stored procedures, VBA, ASP.NET

511 Tactical - Senior SQL Server and SSRS Developer Mar 2011 to May 2011

Modesto, CA

Results:

Thousands of dollars were saved by helping streamline inventory control.

Methodology:

With SQL Server Management Studio created SSRS inventory management reports, focused on finding and saving the company millions in proper inventory management. Identified slow moving inventory to facilitate converting it to sold items with SSRS dashboards. Created databases to track project management to help with managing contractor’s Ron Cash

Projects, hours and billing. Created SSAS cubes for analysis. Also created numerous SSRS reports to implement on the web for various business groups. Modified cubes for reporting

Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.

SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.

Used C# for scripting task in SSIS, SSAS, SSRS, SSMS and Visual Studio.

Used DDL, indexing, stored procedures and tuned queries to improve SSRS performance. Interacted with users for requirements gathering. Used SSIS to create data stores from diverse data sources. Participated in design meetings and code reviews.

The North Face - Senior SQL Server Developer Nov 2010 to Feb 2011

San Leandro, CA

Results:

Saving thousands of hours in time and labor, thereby reducing costs in the millions over time.

Methodology:

SQL Server Management Studio used to develop a custom database to use for consolidating products to update and use on the company website. The product lines and feeds are gathered from various sources and imported into a consolidated database. This is currently being done manually with Excel files.

Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.

SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.

Used C# for scripting task in SSIS, SSAS, SSRS, SSMS and Visual Studio.

Technologies Utilized:

Qlikview, Tableau, SQL Server, XML, SQL Azure, MS Access, MS Access VBA, MS Excel, MS Excel VBA

Technical Skills - Summary:

T-SQL, SSIS, SSAS, SSRS, Data Modeling, Relational Design, Dimensional Modeling, SQL Server Management Studio, Complex T-SQL queries, Stored procedures, functions, Indexes and views, Architecture SQL Server, Backup and Recovery, Diagnostic abilities in database management and data analysis, Resolved data issues per business needs., Performed performance monitoring on database, Report development, SQL Server ver. 2008 to ver. 2000 - Database Development, T-SQL, Stored Procedures, Backup & Recovery, Security, OLAP, MDM, Triggers and Constraints, ETL, Data loading, Data cleansing

Design and deployed database DDL & DML changes. Design and deployed data table structures, forms, reports, and queries. Used elastic search to optimize data retrieval.

SQL Server stored procedures, Views, Indexed views, Create Tables, User Defined Functions, Triggers, Temp Tables, Dynamic T-SQL, Bulk Inserts, Dynamic T-SQL, Data Modeling, Data Analysis, Linked Servers, Data Type conversions, T-SQL Merge, T-SQL Table Types, T-SQL Performance tuning, Execution Plan analysis, Indexes, Foreign Key constraints, Clustered Indexes, etc.

Used C# for scripting task in SSIS, SSAS, SSRS, SSMS and Visual Studio.

Technical Skills - Additional:

Visual Studio, .Net, .Net, Yardi Voyager, Tableau Developer, QuickBase, Big Data, Pentaho, NoSQL, Big Data, Oracle, Cognos, SharePoint, Access ver. 2007, Access ver. 2003, Access ver. 2002, Access ver. 2000, Access ver. 97

Contact this candidate