Sql Server Microsoft Office

GENE DAVYDOV

**** ******** ***** *****: 858-***-****

San Diego, CA 92122 Email: ************@*******.***

PROFILE: Experienced in database design, database development, database administration, analysis and technical data processing, programming. Collaboration in all phases of system life cycle development and support in on-line, client/server, server/server and data warehousing environments as well as applications design responsibilities. Capable of working efficiently in team, independently, remotely. Quick learner with strong organizational skills.

SKILLS: Windows, SQL Server Development and Database Administration, SQL Server Integration Services, SQL Server Reporting Services, ETL Data Warehouse/Marts with “Star” and “Snowflake” schemas, Microsoft Visual Studio, VB.NET, Crystal Reports, Microsoft Office, Oracle, T-SQL, PL/SQL, Serena Dimensions Lifecycle Configuration Management System, Microsoft Visual Source Safe, Subversion, VBScript.

EXPERIENCE:

2013 – 2017 TransCore – SQL Server Developer/DBA, Software Engineer

New York City Department of Transportation Traffic Management Center achieved progress in gaining easier and faster access to automatically archived data via reports and excel file attachments in email notifications, as well as through coordinating data communication with Metropolitan Transportation Authority of New York City

Led the team in the Data Archiving System project to automate data population and its retrieval

Analyzed, designed, developed and maintained Data Archiving System that extracts, transforms and loads (ETL) data in the data warehouse to integrate data from multiple data sources (different flat-file formats and various database platforms) into new SQL Server databases

Designed, advanced and maintained Graphical User Interface (GUI) application for on-demand removal of already archived aged records

Designed, developed and maintained Transit Signal Priority Reports

Monitored and maintained production servers with SQL Server databases on a daily basis

Established and sustained scripts for daily backups and restores

Developed and maintained scripts to archive aged records, according to retention periods

Managed and advanced failover and failback procedures between production Traffic Controls system and backup Traffic Controls system

Preparation and installation of quarterly upgrades of the “TransSuite®” software on Production and Backup System environments

Developed and maintained Graphical User Interfaces and web applications for the License Plates Recognition Reports

Utilized Microsoft Visual Studio (VB.NET), Microsoft SQL Server, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Report Services (SSRS) and Microsoft Office

New York State Department of Transportation Joint Transportation Management Center reached its goal to speedup reporting processes of viewing searched data via client/server application with reports

Developed and upheld extract, transform and load (ETL) for a few Graphical User Interface (GUI) applications with Crystal Reports for Event Management System and Traveler Information System

Upgraded and maintained Crystal Reports for Variable Message Signs

Utilized Microsoft Visual Studio (VB.NET), Microsoft SQL Server, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Report Services (SSRS), Business Intelligence SAP Crystal Reports and Microsoft Office

Performed users trainings

1999 – 2012 TransCore – Software Engineer, Configuration/Release Engineer

New York State Department of Transportation Joint Transportation Management Center accomplished requirements to receive daily email notifications with an attached excel file for specific logging information regarding networking system and video cameras, which enabled the team to review and take quick action to address an issue and/or fix any problem

Designed, developed and maintained applications for Networking System Logs and Video Cameras Communication Failures Logs reviews with extract, transform, load (ETL) to/from the data warehouse

Architect, managed and sustained Graphical User Interface (GUI) applications for Incident Management System and Traveler Information System reports

Utilized Microsoft Visual Studio, Microsoft SQL Server, Microsoft SQL Server Integration Services (SSIS), Business Intelligence SAP Crystal Reports and Microsoft Office

Configuration Management support (San Diego, CA)

Provided builds, distributions and installs of a few different software applications (that were created and/or modified by the development teams) to the Production and Test environments

Promoted and maintained Web Reports used by developers and testers to retrieve searched data from Oracle databases

Optimized and performed Build Interfaces

Utilized Serena Dimensions Lifecycle Configuration Management System, Microsoft Visual Studio, Oracle, Active Server Pages

Violation Processing System software (San Diego, CA)

Developed new customized Graphical User Interface applications and batch jobs

Optimized existing Graphical User Interface applications

Improved existing database objects, such as tables, indexes, stored procedures, functions, triggers

Administered Microsoft SQL Server databases for development and test environments

Managed Violation Processing System software builds, distributions and installs to the development, test and production environments

Utilized Microsoft Visual Studio, Oracle, Microsoft SQL Server, Serena Dimensions Lifecycle Configuration Management System, Crystal Reports and Microsoft Office

Performed users trainings

1990 - 1994 State Publishing Concern of Uzbekistan – Programmer and DBA

Analyzed, designed and developed a multi-tasking integration system to control publishing products on press machines

Developed Graphic User Interface applications and Oracle reports to the system functionality and database content

Implemented data schema and data layouts

Utilized Microsoft Visual Studio, Oracle and Oracle Forms

Performed users trainings

EDUCATION:

1983 – 1984 Tashkent State Technical University (Uzbekistan), Faculty of Electronics and Automation

1986 – 1990 Tashkent Institute of Textile and Light Industry (Uzbekistan). M.S. in Industrial Engineering

1994 – 1995 English Language College (San Diego, CA)

1997 – 1999 Advanced Institute of Technology (San Diego, CA). Programmer and DBA

PROFESSIONAL DEVELOPMENT:

1991 – 1993 Tashkent Computer Center (Uzbekistan). Programmer

2000 – 2002 SQL Server Administering, UCSD Extension courses (San Diego, CA)

2003 – 2004 .NET Programming, UCSD Extension courses (San Diego, CA)

2006 – 2010 Online training sessions for Visual Studio, SQL Server, Agile Platform and Subversion

2012 – 2013 Windows and Microsoft SQL Server seminars and conferences

2013 – 2014 Big Data and Storage related seminars and conferences

2014 – 2016 IT/Dev Connections Conferences – technical trainings for SQL Server and Business Intelligence

Contact this candidate