SUMMARY:

• Reduce cost and help drive business decisions based on science/data
• Data Architecture, Database Development and Administration, Business Intelligence and Data Warehouse on a SQL Server platform
• Strategical thinker, energetic leader a passionate Microsoft Data Platform enthusiast

PROFESSIONAL EXPERIENCE:

Principal Database Engineer

Confidential, San Diego, CA

Environment: SQL Server 2012, SSIS 2012, C# with SSMS 2017, TFS 2015

Responsibilities:

• Familiarity with TriZetto QNXT database schema
• Built up to 10 reports using SSRS 2014
• Leveraged OFFSET and FETCH to support database - based paging
• Utilized SYNONYMs to save time by shortening and obfuscating database object names
• Employed MERGE for daily data refreshes
• Evaluated Change Data Capture Confidential . Confidential to support auditing needs

Confidential, Westlake Village, CA

Environment: SQL Server 2016, SSIS 2016, C# with SSMS 2017, TFS 2015

Responsibilities:

• Created 25+ reports using T - SQL for Excel-based consumption
• Developed 20+ reports using SQL Server Reporting Services 2016 (drill-through, charts, etc...)
• Built packages using SQL Server Integration Services 2016 to consume data from SAP ECC
• Created ad-hoc queries using PL/SQL, Oracle SQL Developer to consume data from SAP Hybris

Sr. Database Warehouse Architect

Confidential

Responsibilities:

• SQL Server 2008/2008R2/2012/2014
• Windows command line, Batch files, 7z, osql, sqlcmd, bcp, coreFTP
• T - SQL, BULK INSERT, LogShipping, trn files, RESTORE WITH RECOVERY/NO RECOVERY/STANDBY
• PowerBI, Visual Studio 2015, SSIS 2016/C# 2015, SSIS 2014/C# 2012, SSRS 2014/2016, SSMS 2014
• Sales and Marketing optimization for Weissman Dance Costumes:
• Implemented BlueHornet ESP Web API using SSIS 2014, C#, and XML
• Developed a custom SSIS XML Source Data Flow control to parse XML files
• Leveraged SSIS 2014 and SQL Server 2014 to load the data
• Consumed IIS 8.0 weblogs using SQL Server 2008, SSIS 2014, C#
• Ingested Retail Activity (Orders, OrderLineItems, and OrderCharges) text files using SQL Server 2014, SSIS 2014, C#

Confidential

Responsibilities:

• Automated daily backup files SFTP download based on CoreFTP core functionality
• Architectured a synchronization of 2 databases between 2 disparate physical locations (Chicago and Los Angeles)
• Leveraged Transaction Log Backup files with SQL Server 2008 R2/2014, SSIS 2014 to keep it in - sync
• Enabled Log Shipping in STANDBY mode to support simultaneous reads/writes
• Ingested various lead generation sources using SQL Server 2014, SSIS 2014, C#
• Consumed various Media campaigns sources applying SQL Server 2014, SSIS 2014, C#

Confidential

Responsibilities:

• Leveraged C#/CSC.exe/DLL/CLR for string manipulations
• Employed SQL Server Spatial data and functions to match DMA areas based on longitude and latitude
• Utilized ASCI ActiveBatch: Folders, Plans, Jobs, Queues, and Triggers, Variable, and System Views

IT Program Manager

Confidential

Responsibilities:

• Created new tests per new mortgage compliance regulations
• Modified existing tests to align with mortgage compliance regulation changes

Confidential

Responsibilities:

• Guided developers on the latest T - SQL best practices
• Improved existing code-base by providing feedback to developers thru a peer review process
• Provided ongoing mentoring, coaching & knowledge transfer on SQL Server to Bank s employees
• Co-authored department-wide 40+ pages long best practices document
• Created an Audit Trail mechanism to log all the database object level/DDL changes

Confidential

Responsibilities:

• Automated over 150 manual T - SQL-based test scripts
• Identified staging table candidates from commonly used tables to reduce resource contention
• Enhanced and added new features to an automated sampling SSIS framework
• Identified all the user permissions and mapped them to a service account
• Promoted the process to a fully automated and scheduled execution using SQL Server Agent

Confidential

Responsibilities:

• Authored a comprehensive 35+ pages long user guide
• Expanded on various access techniques: Linked Server, OPENROWSET, OPENQUERY
• Compared side - by-side static and dynamic SQL methods (accompanied by code samples)
• Highlighted the differences between Windows and SQL Server authentications
• Incorporated detailed comparison between each access and authentication approaches
• Included code snippets to speed up reuse, adoption, and implementation

Confidential

Responsibilities:

• Analyzed requirements
• Created a solution to capture all the server and database access related problems (per user)
• Documented the solution

Confidential

Responsibilities:

• Gathered and analyzed requirements
• Designed & created a solution that uses C#, SQL Server 2012 and SSIS 2008 to stage the data
• Leveraged SSIS to integrated various data sources: DB2 iSeries, Teradata, Oracle, SharePoint
• Provided centralized staging and reporting
• Verified the data using Teradata SQL Assistant, Oracle SQL Developer
• Leveraged a CodePlex SP List Adapter for SSIS to source the data from SharePoint 2010
• Enabled fail - safe execution of dependency processes (stored procedure and/or SSIS package)
• Created a daily HTML-based email report with color-coded status table
• Enhanced the process with parallel execution to save time
• Upgraded from SSIS 2008 to SSIS 2012
• Documented the solution

Confidential

Responsibilities:

• Analyzed requirements and prepared the migration plan
• Gathered necessary server, database, users, and roles permissions
• Cloned and synced all the database objects
• Enabled side - by-side runs of both old and new servers
• Monitored and fixed any data discrepancies