Kenneth J. Ambrose
Microsoft Certified SQL Server Professional
**** ***** *** #****, *** Vegas, NV.
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.
Bay Area Association of Database Developers
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.
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
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.