Kenneth J. Ambrose

Microsoft Certified SQL Server Professional

**** ***** *** #****, *** Vegas, NV.

925-***-****

adcabo@r.postjobfree.com

SUMMARY:

oSenior developer experience expert level TSQL, SSIS, ETL, and SSRS report design/development. Design and implementation for data warehouse using star schema data models, data integrations, and analytical deliverables.

oRelational database design theory and relational DB implementation for both OLTP and OLAP database.

oData modeling and software development requirements analysis and SDLC.

oIndustry standard documentation notations and methods-Use Case Analysis, Data Flow Diagramming, data mapping and transformation documentation.

Education and Training:

U.C. Berkeley, Berkely, CA. Certificate Program in Computers and Information Systems

Microsoft Certified Professional: Sql Server Design and Implementation

Oracle University- PL/SQL Programming

Sql Server Integration Services training certificate

Pervasive Data Integrator training certificate

Foothills College- C#, ASP.Net, Windows Presentation Foundation.

Professional Affiliations:

Bay Area Association of Database Developers

PROFESSIONAL EXPERIENCE

Gordon,Rees, San Francisco, CA.

National Law Firm 8/2013-5/2018

Senior TSQL, SSRS, SSIS developer

Designed and implemented new ETL for human resources system transition, new TSQL business rules engine for integration with two 3rd party systems (accounting and Lawyer time tracking), new custom generalized query tool for general employee use, SSRS reports. Developed powershell application monitoring system for web apps and accounting system data quality.

ROKU, Saratoga, CA.

Streaming device manufacturer 5/2013 – 8/2013

Senior TSQL, SSRS, SSIS developer

Designed and implemented new data warehouse type 2 subject area with associated ETL processing and reports to support sales, marketing, and customer service departments.

McKesson, San Francisco, CA.

Pharmaceuticals 6/2012 – 5/2013

Senior TSQL, SSRS,SSIS developer

Designed and implemented SQL procedures for rebate calculations and data imports and exports. Developed and maintained SSRS reports for customer facing and internal analytics. Designed and implemented automated release deployment solution as a complete replacement for previous manual technique. Designed and implemented over 100 regression testing SQL procedures for testing data warehouse processes, with Nunit .net application as wrapper to support automated execution.

INTEL, Santa Clara, CA.

Chip manufacturing 12/2010 – 6/2012

Senior TSQL developer, SSIS developer

Designed and implemented SQL procedures and functions for ERP and financial forecasting based on business requirements. Designed and implemented performance fixes and operational debugging for all TSQL and SSIS packages for data marts. Designed SSIS coding and design standards for data mart team.

Stanford Linear Accelerator, Palo Alto, CA.

Energy/Research Industry 4/2010 – 10/2010

Contract Oracle and C# Web developer

Designed and implemented C# asp.net web applications and Oracle database structures, PL/SQL, and triggers for hazardous materials online tracking database and protection equipment online tracking database.

8/2009– 10/2009

Designed and implemented C# asp.net web application and Oracle database structures, PL/SQL, and triggers to persist Dosimeter and ID Badge applications and records.

Lifemasters Supported Self Care, SSF, CA

Medical / Health Services Industry 10/2007 – 2/2009

Data Integration Claims Analyst

Designed, implemented, debugged, and optimized TSQL and SSIS ETL and data analysis processes for VLDB medical claims data warehouse on Sql Server 2000 and 2005 platforms.

Analyzed and documented requirements, designed and programmed unit and integration tests, and deployed new ETL implementations for medical claims data warehouse.

Analyzed and documented historical data anomalies and performed root cause analysis, designed, tested, and deployed remedial data updates to warehouse.

Planned Parenthood Federation of America 1/2004 – 3/2007

Medical / Health Services Industry

Data Warehouse Administrator/Architect/Developer

Designed and implemented star schema data warehouse measures and dimensions.

Designed and coded SSIS ETLs for data imports from clinic practice management systems into PPFA data warehouse.

Designed and implemented numerous SSRS compliance reports meeting state and federal specifications.

Developed and documented ETL programming and specifications, test data sets, and final acceptance tests for SSIS integrations, as well as 3rd party contracted data integrations implemented in Pervasive Data Integrator.

Designed and implemented functional and regression testing for PPFA data warehouse configuration and individual data marts.

Developed ETL, datamart and data warehouse functional specifications and project documentation (Use cases, data flow diagrams, data mapping documentation, functional and non-functional specifications, data models, data quality requirements analysis, and reporting requirements).

Zonelabs, San Francisco, CA 1/2001 – 4/2002

Internet Security Software

I.S. programmer/analyst

Design, develop, test and deploy SQL, triggers, and stored procedures for data integration and cleansing, audit trails, and real-time analysis of Zonelabs web store.

Design and implement automated ETL procedures to migrate legacy web store data to Oracle.

Full life cycle development for SqlServer/ASP solutions for both customer facing and internal applications for License Key distribution, remote Call Center, Customer Service, Marketing, and Product testing data access and updating with full audit trail for all internal Zonelabs customer and order data.

Contact this candidate