PROFESSIONAL SUMMARY:

Over a decade of experience implementing business intelligence systems in all phases of the waterfall - based Software Development Life Cycle (SDLC) and with Agile methodologies. Certified and experienced scrum master (CSM). Experience includes data profiling, data architecture, and data analysis.

SOFTWARE AND TOOLS:

Database Technologies: AWS RedShiftPostgreSQLMicrosoft SQL ServerAzure Data WarehouseAzure Analysis ServicesSQL Server Integration Services (SSIS)SQL Server Analysis Services (SSAS) TabularNetezzaOracle

Business Intelligence Tools: Microsoft Power BITableauAlteryxTOAD for Data Analysts

Collaboration and Project Management Tools: JiraMS ProjectMS Team Foundation Services (TFS)

Query Languages: ANSI SQLTransact SQL (Microsoft SQL Server)PL/SQL (Oracle)

Visual Modeling Tools: TOAD Data ModelerVisioErwin

EXPERIENCE:

Confidential, San Francisco, CA

Consultant

Responsibilities:

• (Data Visualization Project, Power and Gas Company) Used Power BI to answer client questions about Microsoft Exchange mailbox/delegate data, to assist them in migrating to Office 365. Also, used Confidential to cleanse data in CSV file for import into Power BI.
• (Data Analysis/Governance Project, Power and Gas Company) Root-cause data analysis of an Oracle database using Toad for Oracle. Also, merged and imported data using Confidential .
• (Customer Relationship Management Project, Software Company) Data profiling and data quality checks on PostgreSQL data. Used Confidential ’s fuzzy matching capability to more accurately find duplicate customer data.
• (Revenue Forecasting Project, Software Company) Created a proof of concept using Azure Analysis Services in partnership with Microsoft. The source data was in Hadoop/Hive; there were roughly 620 million rows.
• (Customer Value Forecasting Project, Retail) Analyzed Omniture (Adobe Marketing Cloud) data in an AWS RedShift data warehouse. Provided the source data used to determine customer forecast models to derive customer lifetime value and to determine the effectiveness of digital marketing channels. Provided data for Tableau dashboards.
• (Internal Corporate) Created an Azure Data Warehouse and an Azure SQL Database to compare cost vs. performance. Migrated data from on-premises SQL Server to both the data warehouse and the SQL database.

Confidential, Dublin, CA

BI Developer

Responsibilities:

• Created a batch file and a stored procedure to process and track SSAS cubes.
• Analyzed and modified Netezza views. Those views provide data for SQL Server Analysis Services (SSAS) Tabular models. The SSAS Tabular models are designed to support Confidential ’ buyer/sales organization.

Confidential, San Francisco, CA

BI Developer

Responsibilities:

• Completed a Big Data Proof of Concept ( Confidential ). The goal of the Confidential is to use ODBC to connect a Confidential Hadoop ( Confidential )/ Confidential cluster to the SQL Server Analysis Services 2014 Tabular model for real-time Inventory Management.
• Created conceptual Power BI dashboards as part of the Confidential .

Confidential, San Francisco, CA

Senior Consultant, Data & Analytics

Responsibilities:

• Interviewed users to derive requirements for migration.
• Created functional and technical specifications such as Source To Target Mappings ( Confidential ) using pseudo code for the offshore team to follow. Then met with the offshore developer team to discuss those specifications, answer questions, coordinate and verify work.
• Verified data from the client’s legacy AS/400 system and newer ERP system into a data warehouse.
• Consulted Confidential clients on the relative merits of Microsoft Power BI versus Tableau, gaining more training about both tools in the process. This was part of the Confidential pre-sales process to bring more business into the firm.

Confidential, San Francisco, CA

Business Intelligence Analyst

Responsibilities:

• Interviewed business users to derive report requirements and translate them into Business Requirements Documents and T-SQL for the IT team.
• Created user stories, tasks, and bugs in Visual Studio Online.
• Confirmed data directly from the source SQL Server databases by writing T-SQL queries.
• Optimized the SQL Server scripts into speedier stored procedures. Those stored procedures ran automatically based on a SQL Agent job and what once took days now takes a few short hours.
• Served as Scrum Master, providing project support, creating and maintaining developer sprints. This was part of converting waterfall into Scrum Agile methodology.
• Used Jira to coordinate the team.

Confidential, San Francisco, CA

Implementation Developer

Responsibilities:

• Incorporated SQL Server Analysis Services databases into Confidential ’s SaaS product.
• Converted a Tableau dashboard into a Confidential dashboard.

Confidential, San Francisco, CA

Project Manager/Senior Data Architect

Responsibilities:

• Completed version 1.0 of the Data Warehouse project, which replaced Accelerated Analytics (Point of Sale Business Intelligence). The company saved approximately $2,500 per month as a result.
• Inherited project management responsibilities for Confidential 2.0. Coordinated the company’s internal IT team and outside consultants to complete project.
• Wrote the technical project plan using Microsoft Project.
• Met with the steering committee consisting of the Director of IT, the General Manager of North America, and the CIO to understand their requirements and goals.
• Built the star-schema database based on the physical design using SQL Server 2008 R2.

Confidential, San Francisco, CA

ETL Consultant

Responsibilities:

• Created SQL Server 2008 R2 Integration Services (SSIS) packages to Extract, Transform and Load data from an Oracle 11i transactional database into a Microsoft SQL Server data warehouse. The SSIS packages used SSIS slowly changing dimension and Kimball method slowly changing dimension transformation (now Pragmatic Works Task Factory Dimension Merge SCD) objects for updating data.
• Verified data in the SQL Server data warehouse with the Oracle 11i source using Oracle PL/SQL queries and he used WinSQL Professional to write the Oracle queries for data analysis and verification.
• Created an SSIS package to extract Salesforce data into a SQL Server database. Used the CozyRoc Salesforce adapter to connect the package to Salesforce.

Confidential, San Francisco, CA

Cross-Platform Database Architect

Responsibilities:

• Took ownership of and reverse-engineered every stored procedure, user-defined function, and view of a SQL Server database to write a 240-page document for business and technical users. He also created data warehouse data dictionaries.
• Created data-definition language (DDL) scripts for Vertica and Netezza databases based upon the architecture of pre-existing Oracle databases. This was accomplished using the WinSQL database tool.

Confidential, San Francisco, CA

Senior Consultant

Responsibilities:

• Constructed a staging database including stored procedures, staging tables, and error tables.
• Created a Package Configuration table (SSIS Configurations) for SSIS packages to set the source and destination connections dynamically.
• Re-created Crystal Reports as SSRS reports.
• Wrote the ETL portion of the Software Design Specification and the Software Requirements Specification.
• Constructed the mapping spreadsheet for ETL based on client input.