SUMMARY:

• Hands - on data warehouse, architect, and developer with 11 years of experience in SQL BI, ETL, ETL.
• Over 14 years’ experience developing on SQL Server with focus on creative solutions to complex information needs.
• Extensive knowledge of SQL Server T-SQL, stored procedures, functions, performance tuning, and partitioning.
• Experience in PowerShell scripting to automate and improve processes, both within databases and for ETL.
• Third tier DBA as well as DBA for database development teams and creating DevOps procedures.
• Over 10 years SQL Data Warehouse development, including ETL, ELT processes, and OLAP solutions.
• Designed, implemented, and provisioned ETL engines for complex data warehouses, including delta loads.
• Designed data warehouses and marts, including both relational and dimensional modeling, star and snowflake schemas, common and specialized dimensions, and fact tables, using both Kimball and Inmon dimensional architectures.
• Worked with cross-functional business and website teams and data warehouses supporting website solutions.
• Ensured quality and accuracy of data in the data warehouses, including distributed enterprise systems.
• Effectively communicated with C level leaders and with technical and non-technical staff.
• Specialized in integrating broad range of tools and solutions, including SQL development, data warehousing, database and Business Intelligence (BI) engineering, data architecture, multidimensional cube and tabular models, analysis of subject data, reporting, system architecting, and design and implementation of logical and physical databases, and data infrastructures.

TECHNICAL EXPERIENCE:

• SQL Server (2014 - 4.x)
• Oracle
• T-SQL
• SQL
• PL/SQL
• SQL*Plus
• Windows Shell Script
• PowerShell
• SSIS
• SSRS
• SSAS
• Git
• TOAD
• CVS
• PVCS
• MS VSS
• ERwin (4.x
• 3.x)
• Rational Rose
• UML
• Unix
• Ultrix
• Linux. (SQL Developer)

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Sr. Database Architect and SQL Developer

• Designed and developed advanced components for existing and new database applications.
• Maintained real-time databases, including component updates and new functionality implementations.
• Developed of ad-hoc analysis of data from various sources to expose differences, similarities and QC issues.
• Architected and developed ETL processes for new database warehouses, including coding the core processes.
• Participated in team architecture and design projects for real time database processes for Web based applications.
• Reverse engineered database systems to implement updated functionality and to address functionality shortcomings.
• Addressed advanced needs of customers for specialized database needs.
• SQL Server (2014 - 2012), Oracle (10g - 9i), T-SQL, SQL, PL/SQL, SQL*Plus, PowerShell, CVS, Linux, Solaris.

Confidential, Seattle, WA

Sr. Data and Database Architect, Analyst and Engineer; SQL Developer

• Designed and developed advanced components for SQL Server system, including at-rest and in-flight encryption architecture.
• Developed of ad-hoc analysis of data from various sources to provide actionable insights and to locate data QC issues.
• Created ETL functionality for a store-and-forward hyper-data warehouse, including programming and unit testing.
• Analyzed high maintenance complex data acquisition procedures for process improvement.
• Created automated ETL, data mapping and cleaning processes using MS PowerShell to replace high cost manual procedures.
• Analyzed changes in incoming data, rapidly creating automated process adjustments, saving 70% of FTE time.
• SQL Server 2012, Windows Server 2008, Red Hat Linux, Ingress, SSIS, PowerShell, Excel. (SQL BI Developer)

Confidential, Seattle, WA

Care Analyst and Caregiver

• Researched, analyzed and provided to medical staff data and understanding of innovative medical treatment options.
• Worked closely with medical staff on medical treatment choices, with exploration of risks and benefits, pointing the way toward new life-saving treatment options for generations of patients.
• Provided analysis, understanding and clarifying into actionable items of ill-defined needs and directions.
• 24x7 caregiving for a severely ill child member of the family.

Confidential, Bellevue, WA

Sr. Consulting Database Engineer (SQL Developer)

• Designed a unified ETL process and database system to incrementally refresh warehoused data as well as store business rules and collateral information, including programming and unit testing.
• Implemented database structures and scripts (over two thousand code lines) enforcing complex business rules based on metadata.
• SQL Server 2005, Windows XP, Windows Server 2005, UML. (SQL Database Programmer) (SQL Developer).

Confidential, Bellevue, WA

Sr. Database Engineer and Developer (PL/SQL and SQL Developer)

• Utilized OOA and OOD to design Oracle modules and applications for management of customer mobile phones data services usage and design of data warehouse ETL.
• Implemented OO designs translating the OO logicals into relational implementation.
• Produced review, acceptance and maintenance documentation for the modules.
• Created scripts and frameworks and implemented insertion of these modules into a live nationwide phone network system.
• Mentored development and QA/QC staff in database systems and their development.
• Championed team-wide versioned code storage methodology and practices.
• Oracle 10g and 9i, UNIX, Windows XP, ERwin, TOAD, CVS, UML. (SQL Database Programmer) (SQL Developer).