PROFESSIONAL SUMMARY:

• Strongly focused and knowledgeable SQL Database Developer / Database Administrator with a wide breadth of software installation and maintenance knowledge.
• Expert communicator of complex technological concepts to professional and non - professional audiences.
• Expert level developer of database objects (tables, views, stored procedures), SSIS packages and SSRS reports.
• Adept at analyzing high-level data; Logical Thinker that transforms code into logical patterns;
• Problem Solver that articulates potential concerns and creates solutions before they become problems.
• Meticulous approaches to database administration keeping in mind minute attention to detail.

TECHNICAL SKILLS:

• Visual Studio.NET 2015, 2012, 2010, 2008 (Visual BASIC.net, C#)
• SQL Server 2016, 2014, 2012, 2008 R2
• SQL Server Analysis Services (SSAS)
• SQL Server 2012 BISM Cube Development
• SQL Server Reporting Services
• SQL Server Integration Services
• Office 365, Microsoft Office 2013
• Crystal Reports 7.0 - 10
• Crystal Enterprise 10
• SPSS v 7.5
• Windows 10, Windows 7
• Windows Server 2016, 2012 R2, 2008 R2

PROFESSIONAL EXPERIENCE:

Sr. SQL Database Developer / DBA

Confidential, Walnut Creek, CA

Responsibilities:

• Acted in the capacity of production DBA / BST Accounting System Administrator since May 2017. Installed SQL services (DBMS / SSAS / SSIS / SSRS), configured security and restored databases over various servers. Created linked servers for inter-server communications. Conducted server performance and recommended resource upgrades.
• Recommended hardware specifications and disk configurations to support new OS (Windows Server 2016) and new SQL Server version (2016).
• Project lead for the upgrade of various servers running SQL Server 2008 R2 using in-place upgrade technique. Migration of existing production server (2008 R2) databases to new production database server running SQL Server 2016.
• Reengineered SSIS packages to use SQL Server 2016 SSISDB environments as well as for execution speed enhancement and maintainability.
• Configured / upgraded SQL SSRS services, set-up SSRS report data sources, deployed over 200 reports and folders using Visual Studio 2015. Original reports developed using VisualStudio 2008 were upgraded to VisualStudio 2015 to take advantage of parameter placing and data environment access inside Integration Services Catalog.
• Developed automated billing process for large contract that usually took a FTE over 20 hours / month to produce. Data sourced from BST 8.5.1.6 and rendered using SSRS reports.
• Designed and implemented new ETL process for the updating BST accounting system employee demographic data from new HCM system (Ultimate).
• Programmed SSRS labor reports sourced from SSAS cube data using MDX and SQL stored procedure.
• Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
• Managed internal databases, from planning and testing stages through implementation and support.
• In-depth understanding of security and backup / restore procedures to ensure database integrity and disaster recovery with minimal down time.
• Enhanced various stored procedure for execution performance speeds using T-SQL enhancements with SQL Server 2016 (Column Store indexes, Memory-optimized tables).
• Implemented temporal tables for row historical tracking.
• Mentored those developers and QA personnel in the use of advanced T-SQL programming techniques, SSRS report development, SSIS package development and basic DBA database backup / restore operations using CommVault and SQL Server native commands.

Sr. SQL Database Developer / Development DBA

Confidential, Naperville, IL

Responsibilities:

• Completed the development of various SSRS reports and associated stored procedures and supporting database objects. Installed and configured SSRS services.
• Improved performance of various existing stored procedures and views using established proven coding methodologies.
• Developed SSIS ETL packages for extraction of data from various database tables, conversion into XML files and FTP to remote site for issuance of ecommerce account information.
• Enhanced current database processing using table row compression and non- clustered index page compression. Performance improved over 45%.
• Mentored those developers and QA personnel in the use of advanced T-SQL programming techniques.
• Acted in the capacitance of development DBA. Restored databases, cloned database based on existing database backups.
• Improved performance of SQL instance by explicitly indicating memory maximum limit. Server performance improved over 50% since the operating system was not being choked of resources.

Sr. SQL Database Developer / Sr. SQL Business Intelligence Developer

Confidential, Reston, VA

Responsibilities:

• Developed complex database applications used for reporting Equity stock performance, Fixed Income bond returns and other data points used for strategic stocks and bonds purchase decisions.
• Responsible for the maintenance of complex SSRS reports and their associated SQL stored procedures. Existing stored procedure were enhanced for speed improvement, on the order of 50% to 75% speed increases.
• Programmed new analysis services cube using SQL Server 2012 BISM model. Access was performed using Excel 2010.
• Constructed data ETL bridge for extracting Oracle 11g data and transferring / transforming into SQL Server 2012 database for client stock holdings reporting purposes.
• Improved execution speeds of existing stored procedure, views, functions and triggers using 1-fetch methodologies and either table variables or temp tables based on the number of rows returned for initial fetch.
• Established SQL coding best practices standards for maintainability of readability of database objects.
• Improved table query response times by using SQL profiler and re-organizing table structures for clustered / non-clustered indexes using identity columns for clustered indexes and natural keys for non-clustered indexes. Table row level compression was applied with index page level compression.

Sr. SQL Database Developer / SSIS ETL Developer

Confidential, Napa, CA

Responsibilities:

• Primary responsibility was the improvement of the ETL process of receiving wine order depletions (sales to distributors) for statistical reporting purposes.
• Re-engineered existing BDN (Beverage Data Network) and TDLinx (Retail Outlet) processing systems. This involved rewriting existing SQL stored procedures and re-programming existing SSIS ETL packages.
• Instrumented the development of new Visual Studio web applications using Silver Light technologies.
• Developed proof of concept database table schemas for the new wine sales pricing application. Application was developed outside of company by orbinary.com.
• Mentored those team members who needed additional tutelage in the workings of T-SQL 2008.

Sr. SQL Database Developer / Sr. SQL Business Intelligence Developer

Confidential, Oakland, CA

Responsibilities:

• Primary responsibility was the analysis of business and functional requirements and the improvement of the SQL Server Analysis Services existing cubes and development of new SSAS cubes using Performance Point server as the presentation layer.
• Identified SQL Server configuration issues that caused servers to function inefficiently. Appears the original SQL DBA set the memory allocations for the SQL services to use 15,000,000 GB RAM instead of setting the high limit to 11,000 MB (11GB). Once this had been corrected and the servers rebooted, the machines functioned extremely well and efficiently.
• Mentored those team members who needed additional tutelage in the workings of T-SQL 2008.

Sr. SQL Database Developer / ETL (SSIS) Developer

Confidential, San Francisco, CA

Responsibilities:

• Responsible for analysis of the business and functional requirements for developing SQL scripts used to validate data information in various formats and environments.
• Developed test plans, test cases and detailed data sets for system, integration and UAT testing. External data feeds came from various .csv files for one accounting system and the other feed consisted of AS/400 DB2 data.
• Actively participated in test plan meetings.
• Performed data analysis for accuracy of data propagating from ODS to stating to data warehouse environments.
• Assisted in the debugging and performance enhancements of existing SQL scripts and SSIS packages.
• Tracked down bugs and created testing and UAT issues that were forwarded to the development team and to the SQL architect.
• Corresponded among QA managers, Project managers, developers and other team members.

ETL Programmer / Analysis Services Cube Developer / Sr. SQL Database Developer

Confidential, Oakland, CA

Responsibilities:

• Re-engineered existing ETL process used to determine recommended on-hand quantities of various auto parts based on previous sales and other metrics. Original process executed in 8 hours; new process executes in 1.5 hours
• Re-engineered existing ETL process used to analyze current auto part prices and adjust those prices based on discounts or lack of discounts taken at time of sale.
• Completed the development of an Analysis Services cube to be used by franchisees for research of part sales movements. Assisted in the development of web application for accessing Analysis Services cube used by franchisees.
• Developed new Analysis Services cube used by marketing analysis to determine if actual on-site visits to customers or lack of on-site visits increased / decreased sales to those customers.
• Developed Integration Services packages to automate re-engineered ETL processes and also to process the new Analysis Services cubes.

Solutions Architect / Data Warehouse Architect / Data Warehouse Developer

Confidential, Napa, California

Responsibilities:

• Developed three-tiered Data Warehouse (Staging / Data Warehouse / Data Mart) / ETL processes using Kimball methodology (star-schema design).
• Performed complex multi-year data analysis to determine data integrity and incorrect data validation rules, resulting in the discovery of the misreporting of over 290,000 cases of various wine products over a period of 5 years.
• Implemented referential integrity rules between SQL tables and established data contracts between Confidential ’s and external data providers, resulting in stable data receiving and accurate reporting of product depletions.
• Responsible for the development and maintenance of SQL Server 2005 Analysis Services cubes.
• Developed new and enhanced existing T-SQL stored procedures and SQL 2005 SSIS packages used to populate fact and dimension tables of data cubes from various SQL databases and external data sources.
• Responsible for developing / maintaining solutions for the receiving and processing of Nielsen distributor / retailer product depletion information (TDLinx and BDN - Beverage Data Network).
• Developed off-line database application solution using SQL Server 2005 Express where off-line databases are re-synchronized with master database at application start-up. This method allowed our sales personnel to work off-line with complete databases pertinent to their own individual access rights, i.e., which brands and market areas the individuals had rights to.
• Produced detailed process documentation and data flow diagrams for existing software solutions. Data flow diagrams were developed using Microsoft Visio.

Senior Project Lead, Financial Systems Developer

Confidential, San Francisco, CA

Responsibilities:

• Lead the conversion of the legacy Flexi financial accounting system to the new JD Edwards OneWorld XE ERP 8 Financial Accounting System. Duties included extrapolating existing General Ledger financial information, A/R customer / open invoice information and A/P vendor information. Post conversion, duties included DBA functions for the support of the JD Edwards system databases (backup/restore/table & index modifications), liaison between external consulting companies used for maintenance of JD Edwards proprietary software and Textainer, data analyst for accounting staff.
• Participated as one of four senior project leads who developed a web-based shipment container tracking / ordering system for the United States Department of Defense (Surface Deployment and Distribution Command). Software was developed using C# 2.0 with a SQL Server 2005 backend.
• Developed a web-based C# 2.0 application for accessing and extracting data directly from a AS/400 DB2 database. Data access was accomplished by using the DataDirect .net data provider. User experience enhancements to the asp.net interface was accomplished using the Infragistics NetAdvantage 2006 v3 development tools.
• Developed a web-based application to enhance the access and report generation of various reports stored in Crystal Enterprise 10 and rendered in Internet Explorer.
• Developed interface applications for the preparation and extraction of information from the existing AS/400 DB2 database environment into JD Edwards format using SQL/400 stored procedures.
• Developed a software bridge to combine classic ASP and .NET ASPX applications on existing web sites. This bridge would script off all session variable information to a SQL database table, keyed by the user id encrypted to 64 bits. The user id would be passed on the URL line encrypted and ASP classic session variables would be refreshed when execution was transferred from .NET to classic ASP.
• Developed Client / Server applications using Visual Studio.NET C# and Crystal Reports 10. Data access was accomplished using stored procedures located inside SQL 2000 database.
• Developed Client / Server applications using Visual BASIC 6.0, Crystal Reports 7 and SQL Server 2000. All reports were launched from within the Visual BASIC application.