Data Sql Server

MARINA YEPIFANTSEVA

**** ****** ***** **, ***** Creek, GA, 30022 • mobile: 678-***-**** • ******.************@*****.*** https://www.linkedin.com/in/marina-yepifantseva-b06b544/ Professional Summary

Highly dedicated, enthusiastic, and professional Sr. Programmer Analyst /.NET/SQL Developer with more than 15 years of experience in developing, managing/testing code, maintain database programs, creating SQL data tables, stored procedures, views, triggers, functions, maintaining and documenting computer programs, as well as full system development (Dev, Test, Prod). Expertise in .NET, SQL, C# developing, testing, debugging, and modifying system programs as well as possess excellent analytical, problem-solving and programming skills. Competent project leader as well as an effective team player with exceptional people skills

Skills

• Strong hands-on experience in software

development using Microsoft stack (C#,

ASP.NET, SQL Server, etc.)

• Experience with Agile development processes,

methodologies, and tools

• Excellent understanding of Object-Oriented

software design

• Excellent knowledge of HTML, CSS,

JavaScript, SQL, and Web Services

• Analytical skills for performing systems

analysis

• Full-stack .NET development with broad

experience in designing and developing .NET

applications

• Strong knowledge in writing complex

Database Queries, Stored Procedures, Views,

Triggers, Temp tables and Functions using

Microsoft SQL Server 200x

• Relational & transactional databases and data

architecture: Building entire features across all

layers (database, services, and Web UI)

• Familiar with concepts of MVC, ETL

• Windows/Web applications

• Business Intelligence, Reporting Services

report writing

• Organizational skills with ability to adapt to

new environments

• Understanding of n-tier architecture

• (presentation, logic and data layers) Project

• High-level understanding of Web based

software technology in a Microsoft

environment

• Source code control systems and concepts

• Back-end database testing on SQL server

• Documentation and debugging skills

• Leadership, Team Player

• Attention to Detail

• Customer Service

• Oral Communication

• Problem Solving

Technical Skills

• Programming Languages: C#; VB.NET; VB6; SQL; Transact-SQL, JavaScript

• Reporting/Visualization Software: Microsoft SQL Reporting Services (SSRS); Tableau; Crystal Reports

• Technologies: ADO.NET, HTML; ASP.NET; XML; Microsoft .NET Framework; CSS; Web Services; n-tier Architecture

• Tools: Microsoft SQL Server 200x; Microsoft Visual Studio 2017/2013/2010; SQL Server Management Studio 2014/2019; Embarcadero Rapid SQL; MS Office 2016/2010/365; Telerik controls, SQL Server Integration Services (SSIS), data extraction, transformation and loading (ETL), MySQL

• Version control technologies: Visual Source Safe; Vault Professional Client; Git.

• Software Processes/Methodology: Full System Development Life Cycle (Dev, Test, Prod), Software Development Life Cycle (SDLC); Software Testing Life Cycle (STLC); Agile Methodology; Web Services: IIS 6 & 7

Work History

American Cancer Society – Global Headquarters, Atlanta, GA Sr. Programmer Analyst/SQL Server Developer, 01-2001 – 06-2020

• Successfully developed an Application Tracking Program (ATPi), the fifth major revision of custom software, a significant milestone in transitioning from a windows to web-based software product. Server-side code is written in Visual C# and server-side markup is ASP.NET, SQL. On the client, HTML, CSS, JavaScript and jQuery are all used.

• Successfully developed fourth major revision of ATP, called ATPNET, a n-tier Windows Forms desktop application, which was written in VB.NET and SQL.

• Successfully led, designed and fully developed the Electronic Research Application (ERA), the main automated data entry process of entering/manipulating/transferring data into the SQL server relational database after exporting the raw data from the external source “proposalCentral” web service. Thereby fundamentally improving the entire process by greatly reducing the creation of duplicate records. This process was originally written in VB.NET and SQL, later rewritten and improved in C# and SQL.

• Led, designed and performed the process and technical actions necessary to export data from research grant Application Tracking Program (ATP) to the company CRM system (Siebel) and Health Research alliance. This process was written in VB.NET and SQL.

• Led and designed the SSIS package to move data from ATP database to a destination with no transformations to support Research Department SSRS Reports on cancer.org.

• Supported MySQL, the Transactional database (scientific data storage).

• Led design and development of Automated Data Consolidation processes to eliminate Person duplicate and Institution duplicate records in the ATP database/system. This process originally was written in VB.NET and SQL, later rewritten and modified in C# and SQL.

• Led and designed the SQL database migration/transaction process from old ATP4 to new redesigned ATPNET SQL database. To accomplish this process, wrote hundreds of stored procedures and several tools/utilities based on technical necessity and requirements.

• Created and managed User Security accounts on SQL Server.

• Performed SQL Database Synchronization process, by synchronizing Test and Development databases with Production database on SQL Server, Monitor SQL server performance.

• Led the development and implementation of more than 150 custom SSRS reports.

• Developed and maintained appropriate stored procedures/ad-hoc data queries/custom functions/triggers/views/ and solved data related issues for business handling of data.

• Provided all data validation through SQL queries.

• Managed code, including performing code review.

• Gathered requirements from users for development/modifications and enhancements to the existing Research Information System and performed the analysis and programming needed to implement the requirements.

• Assisted ATPNET Custom Software users in assessing their needs and providing information/assistance/troubleshooting.

• Wrote technical documentation of software development.

• Supported multiple concurrent projects enabling delivery efficiencies and technical resolutions.

• Translated technical concepts and information into terms all parties could easily comprehend.

• Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements.

• Liaise with Corporate IT leadership as appropriate. A-Soft, Inc. Atlanta, GA

Programmer/Analyst, 1999-09 - 2000-09

• Participated in design, coding and testing of Sales Data Analysis System.

• Participated in design and maintenance of sales databases.

• Created reports by Divisions, Periods, Customers, Product Groups, Workshops and Orders; Storehouse inventory with reports by Product Groups, Orders, Materials and Equipment. Used MS Access, VB 6.0, MS SQL.

• Participated in creating web projects such as Customer Login, Setup, Upgrades, Checking Membership Status, etc. Used ASP, VB Script.

• Used Microsoft Access 97, VB to build GUI (Graphic User Interface), generated reports and MS SQL database to store customer data. Used SQL to transfer data from the MS SQL database to Access. Education Certifications

Master of Science: Computer Information Systems Franklins (franclins.net) VB.NET Master Class Georgia State University - Atlanta, GA

Master of Science: Mechanical Engineering

Rostov Technical Institute - Rostov-on-Don, Russia

Contact this candidate