TECHNICAL SKILLS

• Database Development using T - SQL
• Microsoft BI stack using SSIS & SSRS 2005, Visual Studio 2005 Database Edition & BIDS 2005, SQL Server Backup/Restore, Business Continuity & Disaster Recovery Setup, SQL Server Installation, Architecture, in-place and side-by-side Version Upgrade, SQL Server Database Archiving, Testing & Consultation, SQL Server 2000 to SQL Server 2005, DTS 2000 to SSIS 2005 Conversions, SQL Server Performance Tuning Optimization utilizing Query Execution plans, Activity Monitor, Dynamic Management Views, Database Tuning Advisor, SQL Profiler & PerfMon, Feed Aggregation (Thompson Reuters, Russell Investment, IDC, Cyber Source, Morning Star, Google Analytics and Adobe Omniture), ETL development for XML, Flat Files, Raw Files and Excel files
• 6+ years in Database and Server Administration and Management, IIS, Visual Studio 2008 Database Edition, BIDS 2008 R1/R2, SQL Server 2005 to SQL Server 2008 Migration, SSIS/SSRS 2005 to SSIS/SSRS 2008 R1/R2 Conversions, Logical & Physical Data Modeling on SQL Server, SQL Native, Quest LiteSpeed, RedGate SQL Backup & HyperBac backup tools
• RedGate sqlTOOLBELT: SQL Compare, Data Compare, SQL Prompt & Source Control, Source Control tools: VSS 6.0, TFS 2005/2008, SQL Server Database Snapshot, Log Shipping, Mirroring, Replication & Clustering, Backup & Data Compression, Table Partitioning, MDW, CDC and Change Tracking
• Integration with MS-Access 2000, MySQL, Oracle, PostgreSQL, Teradata & IBM DB2 VMS/UDB/AS400, SharePoint 2007/2010, OLAP/SSAS 2008, Visual Studio 2010, ReportViewer 2010, TFS 2010, WCF, SQL Monitoring tools: Quest SpotLight/FogLight, Red Gate SQL Monitor, Idera SQL Diagnostics, SQLIO, MelissaData, NCOA/CASS, Experian QAS and OneSource iSell reference data providers, VLDB (5TB and less), SSIS/SSRS 2005/2008 R1/R2 to SSIS/SSRS 2012 Conversions, SQL Server 2012, SSIS 2012, SQL Server Data Tools, DQS, FileStream & FileTable, Conversion of VB.NET/VBScript based reporting platform to SSRS 2008 w/ReportViewer, PowerShell
• ASCI ActiveBatch, PowerBI, SSMS 2014/16/17, SSDT 2014/16, SSIS 2014/16, SSRS 2014/16, VMware Hypervisor

PROFESSIONAL EXPERIENCE

Confidential, Woodland Hills, CA

Principal Database Engineer

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 a.k.a. CDC to support auditing needs

Confidential

Sr. Database Warehouse Architect

Responsibilities:

• 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#
• Sales and Marketing optimization for Vein Clinics of America:
• 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#
• Miscellaneous:
• 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

Confidential, Woodlands Hills, CA

Sr. SQL Server Consultant / IT Program Manager

Responsibilities:

• Department of Justice (DOJ) and Consumer Financial Protection Bureau (CFPB) metrics:
• Created new tests per new mortgage compliance regulations
• Modified existing tests to align with mortgage compliance regulation changes
• SQL Server SME:
• 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
• Sample Automation Framework:
• 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
• Ad-hoc querying guide:
• 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
• Test User Access Check:
• Analyzed requirements
• Created a solution to capture all the server and database access related problems (per user)
• Documented the solution
• Sample Dependency Framework:
• 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
• Server Migration (moving team databases from one server to another):
• 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
• New Team Member Hiring:
• Helped to define the job description
• Assisted in dissecting required and optional skills from a large list of skills
• Performed technical interview to potential candidates
• Provided detailed feedback to the hiring manager

Confidential, Santa Monica, CA

VP, Data Architecture

Responsibilities:

• Technologies: C#, FileTable, SQL Server 2008R2 & 2012, T-SQL, SSIS, Windows 1251: Cyrillic
• Google Analytics, Adobe Omniture
• Managing 4 offshore (Eastern Europe) developers