Resume

Sign in

SQL Server

Location:
Oakland, California, 94605, United States
Posted:
November 07, 2016

Contact this candidate

James H. Robinson

(415) ***-****

acxevt@r.postjobfree.com

PROFESSIONAL SUMMARY

Over a decade of experience in database warehouse requirements gathering, source to target mapping documents for ETL (Extraction, Transformation, and Loading) and writing specification documents. Has implemented business intelligence systems in all phases of the Software Development Life Cycle (SDLC). Certified and experienced scrum master (CSM).

SOFTWARE and TOOLS

Database Technologies:

Microsoft SQL Server,

SQL Server Integration Services (SSIS),

SQL Server Analysis Services (SSAS),

WinSQL

Netezza,

Oracle

Business Intelligence Tools:

Microsoft Power BI,

Tableau,

TOAD for Data Analysts,

SQL Server Reporting Services (SSRS),

Birst

Collaboration and Project Management Tools:

Jira,

MS Project,

MS Team Foundation Services (TFS),

SharePoint Online/OneDrive for Business

Query Languages:

Transact SQL (Microsoft SQL Server),

XML,

PL/SQL (Oracle)

Visual Modeling Tools:

TOAD Data Modeler,

Visio,

Erwin

EXPERIENCE

Ross Stores, Inc. – Dublin, CA

Contract Position – BI Developer

8/2016 Present

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 Ross Stores’ buyer/sales organization.

Created a batch file and a stored procedure to process and track SSAS cubes.

Gap, Inc. – San Francisco, CA

Contract Position – BI Developer

2/2016 8/2016

Created a Big Data Proof of Concept (POC). The goal of the POC is to use ODBC to connect a Hortonworks Hadoop/Hive NoSQL cluster to the SQL Server Analysis Services 2014 Tabular model for real-time Inventory Management.

Created conceptual Power BI dashboards as part of the POC.

Avanade, Inc. – San Francisco, CA

Full Time Employee (FTE) Position – Senior Consultant, Data & Analytics

6/2015 1/2016

Interviewed users to derive requirements for migration.

Created functional and technical specifications 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 Avanade clients on the relative merits of Microsoft Power BI versus Tableau, gaining more training about both tools in the process.

Method360 – San Francisco, CA

Contract Position – Business Intelligence Analyst

3/2014 6/2015

(Logistics/Shipping Industry)

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.

(Health Care Industry)

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.

Birst – San Francisco, CA

Contract Position – Implementation Developer

7/2013 3/2014

(Software as a Service/Cloud BI Startup)

Incorporated SQL Server Analysis Services databases into Birst’s SaaS product.

Converted a Tableau dashboard into a Birst dashboard.

Benefit Cosmetics – San Francisco, CA

Full Time Employee (FTE) Position – Project Manager/Senior Data Architect

1/2012 6/2013

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 Athena 2.0. Coordinated the company’s internal IT team and outside consultants to complete project.

Wrote the technical project plan using Microsoft Project.

Aided consultants with the high-level logical design using Microsoft Visio. He designed the physical data model using Toad Data Modeler.

Built the star-schema database based on the physical design using SQL Server 2008 R2.

Modis – San Francisco, CA

Contract Position – ETL Consultant

9/2010 12/2011

(Computer, Smart Phone, and Tablet Accessories Industry)

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.

CoreLogic – San Francisco, CA

Full Time Employee (FTE) Position– Cross-Platform Database Architect

11/2008 09/2010

Took ownership of and reverse-engineered every stored procedure, user-defined function, and view of a SQL Server database to write a 300-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.

Magenic Technology – San Francisco, CA

Full Time Employee (FTE) Position – Senior Consultant

1/2007 9/2008

(Health Insurance Industry)

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.

Performed data analysis/quality checks on the data being migrated from the source to make sure the data was in compliance with the data mapping spreadsheet and the database model.

(Non-Profit Health Care Provider)

Re-created Crystal Reports as SSRS reports.

Wrote reports against an OLAP Data Warehouse, which was a relational de-normalized (star schema) SQL Server 2005 database.

(Dental Technology Industry)

Wrote the ETL portion of the Software Design Specification and the Software Requirements Specification.

Constructed the mapping spreadsheet for ETL based on client input.

LifeMasters Supported Self Care, Inc. – South San Francisco, CA

Full Time Employee (FTE) Position – BI/Reports Analyst

7/2006 1/2007

Generated reports and other BI documents using SQL Server 2005 Reporting Services (SSRS) based on a SQL Server-based data warehouse and SQL Server Analysis Services (SSAS) cubes.

Updated and delivered Excel spreadsheets containing pivot tables, using secure FTP to deliver the spreadsheets to clients.

Booz Allen Hamilton McLean, VA

Full Time Employee (FTE) Position – Associate (Level III)/ETL Team Leader

1/2005 5/2006

Led the data migration team that extracted, transformed, and loaded data from an older SQL Server database into the new system.

American Federation of Teachers (Artisys Corporation) Washington, DC

Full Time Employee (FTE) Position – BI Developer

6/2002 1/2005

Created the original database design for data warehouse.

Generated the entity relationship diagram (ERD) and data flow diagram using both Visio and Erwin and then built the prototype database based on the ERD.

EDUCATION

Certification: Certified Scrum Master, Scrum Alliance

Certification: Microsoft Certified Professional (MCP) Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition (Exam 70-229)

Degree: M.A., Virginia Polytechnic Institute and State University (VPI & SU)

Degree: B.A., University of Virginia



Contact this candidate