Elena Krasnova-Sokolova

***** ******** ******, *** *****, CA 92129

858-***-****

aco75p@r.postjobfree.com

Software engineer with more than 15 years of hands-on experience in

various enterprise multi-tier applications. Ability to learn and

adapt to new things quickly. Highly motivated self-starter and

problem solver. Excellent team player. Seeking for a software

engineer position in a stable dynamically growing company.

TECHNICAL SUMMARY

Languages: C#, Java Script, JQuery, VB.NET, VB 6.0/ VBScript, Regular

expression.

Technologies: .NET 1.0, 1.1, 2.0, 3.5, 4.0, MVC, Kendo UI, CSS, HTML,

Resharper, Bootstrap, Web API, DEV Http Client, ASP.NET,

ADO/ADO.NET, WCF, Windows Forms, TFS, Urban Turtle, XML, XSLT, .NET

Web Services, ASP, COM, BizTalk, Rational Clear Case and Clear Quest,

Perforce, SQL Server Reporting Tool, Crystal Reports 8.0, Oracle

Developer 2000(Oracle Forms, Oracle Reports)

Database/Data Access: MS SQL Server 2012, 2008, 2005, 2000, Oracle

10g, 9i, SQL Plus, PL/SQL, Toad, Microsoft Access, ODBC, OLEDB, ETL,

SSRS.

Agile (Scrum methodologies). Waterfall development process.

EXPERIENCE

Senior Developer, Matrix Medical Network (Ascender) San Diego, CA

12.14- 03.15 (Contract)

Participated as a team member in BIA (Business Intelligence

Analytics) group. Working on a variety projects to support HRA

(Health Risk Assessments) research. Analyzed health care data for

different clients using SQL Server 2008 and 2012. Extracted and

transformed the data from the different client's databases. Created

very complex stored procedures for the reports to provide the

information for the clinical research and analyze performance for the

medical workers (primary care providers, nurse practitioners, etc.)

Participated in all phases of SDLC using Agile development process:

from system analysis and architecture thru development and test to

deployment and support. Developed and unit tested SQL Server objects

(tables, views, stored procedures, functions) of a system and ensure

seamless integration with other sub systems. Extensively used CTE,

pivot tables, rollups, etc. Troubleshot any complex issues during the

project and provided solutions to solve them.

Senior Software Engineer, Epsilon Inc. (Aspen Marketing Services),

San Diego, CA 07.11- 07.14

Participated as a team member, project lead, and scrum master in

development and maintenance of the e-Strike, using C #.NET, ASP. NET,

MVC, Web Forms, Web API, JQuery, JavaScript, Kendo UI, CSS,

Bootstrap, WCF, Web Services, Windows Services, SQL Server, SQL

Server Reporting, Oracle.

e-Strike is a web based tool, which car OEM and dealership can use to

create customized sales and service emails quickly and easily to send

to their customers. The e-Strike email templates have been designed

with the same look and messaging as national campaigns and contain

strong calls-to-action to entice customers to visit the Dealership or

service shop instead of competitor's.

As a team member and project lead, responsible for architectural

design, implementation, maintenance and code review of the e-Strike

Next Generation (NxGen). Successfully transferred the biggest clients

to the new platform (General Motors, Volvo, and Ford). The new role

based system allows clients based on their role have different

privileges and abilities in new web version to create, edit and view

e-Strike campaigns, view and drilldown reports. Done by using C#

.NET, Web API, ASP.NET, JQuery, JavaScript, CSS, JSON, SQL Server,

SQL Server Reporting, Chrome DEV HTTP Client for Web Api JSON Unit

test.

As a team member participated in architectural design and

implementation of the new Admin web site to support e-Strike web

application. Admin site contains all parts for the e-Strike templates

to create campaign. Such as Email Subject Lines, Images, Offers, etc.

This web application is written by using C# .NET, WEB API, JQuery,

JavaScript, Bootstrap, Kendo UI, SQL Server, DEV HTTP Client for Web

Api JSON Unit test.

Participated in a maintenance and enhancement for the windows service

for the submitted campaigns. Wrote unit tests to troubleshoot and

maintained it. The service is written by using C# .NET, WCF for the

3rd party products, which are sending customer's emails, SQL Server

and Oracle databases.

Extensively used SQL Server to support the back end process. Wrote

and enhanced, stored procedures, functions, triggers, created tables,

views. For production support wrote a lot of sql scripts to fix data.

Used ETL to get the data from the application SQL Server databases

and load it to SQL Server Reporting database to use it for the SSRS.

Our team extensively used Agile methodology. Scrum master role was

rolled over between team members. As a scrum master was responsible

for writing User Stories based on a BA requirements, creating

developer, deployment, unit test, code review tasks. Estimating story

points and working hours. As a scrum master responsible for

scheduling and leading sprint planning, daily scrum and sprint review

and retro meetings (discussion what was good, what we need to change,

etc.)

Extensively used TFS and Urban Turtle (Web based version) for

creating User Stories, Tasks and Issues. As a project lead was

branching and merging project's code. Deployed branches to

development and QA environments by using Nolio deployment tool.

As a problem solver leading production support for the e-Strike

applications. Implemented Error Handling by using 3rd party Gibraltar

logging and error management tool to analyze the problem during the

maintenance.

Worked really closely with different teams of the company such as

product management regarding requirements for the new features.

Provided technical support to QA and BA team.

Senior Developer, RefWorks-COS, a ProQuest Company, San Diego, CA

07.10- 06.11

Participated as a team member in creating a new features in new

version of RefWorks, using C# .NET, ASP.NET, JQuery, JavaScript, Web

Services, XSLT, XML, SQL Server, as well as maintaining the classic

version using JavaScript, ASP, SQL Server. RefWorks is a web based

system - an online research management, writing and collaboration

tool, designed to help researchers easily gather, manage, store and

share all types of information, as well as generate citations and

bibliographies.

Responsible for writing technical specifications, architectural

design and implementation RefWorks 2.0 new features. Created and

maintained JQuery light boxes, API functionality (middle tier,

written in .NET C#, ASP.NET, Web Services, classic ASP), SQL Server

stored procedures, functions, tables, triggers to support new and

existing functionality.

Implemented new features in RefWorks 2.0 for the advanced search of

references, import new references from files to the users databases,

highlighting the searches in found references, exporting references

in a different types of files, format references by using different

custom output styles.

Analyzed requirements, created specifications, architected and

implemented RefShare (reference share) options for the RefShare 2.0

web project, created for users, who has a read only access to the

RefWorks owners databases. By using this project, database owners

have an ability to choose reference fields and options to show,

export, print, create bibliography for all of the reference types.

Responsible for all parts for this project (front end using JQuery,

JavaScript, XSLT, XML, middle tier using C#, ASP, back end using SQL

Server). Created tables, stored procedures, functions in SQL Server

for this project.

Created specifications, architected and fully implemented the

default template for the Refshare 2.0 project, By using this template

users are able to set the refshare options to show, hide some

reference fields, options, copy the values to the individual share

options, get default setting for the individual share options,

overwrite all individual shares with the default settings. The

project was implemented by using JQuery, JavaScript, XSLT, XML for

the front end, C#, ASP for the middle tier and SQL Server as a back

end.

Communicated with different teams of the company such as customer

support, product management regarding requirements for the new

features. Provided technical support to QA team and client services

team.

Senior Software Engineer, Audatex a Solera Company, San Diego, CA

05.08- 06.10

As a member of the team participated in design, and implementation of

the web-based claims manager solution. Project lead in production

support and deployment for the Claims Manager system.

As a team player responsible for the architectural design, analysis

of the specification's requirements for the main web Claims Manager

system. Created and maintained ASP.NET pages, user and custom

controls, .NET Web Services, business and data layers using C#.

Created SQL Server objects such tables, views, stored procedures and

triggers to support the data coming from the 3rd party company to

transfer the data from and into the main Audatex Oracle database.

Created ASP.NET web application to support the data retrieval from

the archived claims database.

As a project lead responsible for production support of the Claims

manager system for the all components written in .NET ASP.NET/C#,

classic ASP/VB and JavaScript.

Created a lot of T-SQL scripts to fix the production data in Oracle.

SQL Server databases.

Interacted with product managers regarding project specifications,

with QA and configuration management teams to provide technical

support.

Using Perforce and TFS as a source control tools, Pall Banyan log

system to maintain the production environment.

Senior Software Engineer, Metavante/ BenSoft Inc., San Diego, CA

05.07- 05.08

Responsible as a team player for specifications, design and

implementation of the web-based Software-as-a-Service solution

designed specifically for Third Party Administrators, health plans.

Participated in conversion of ASP to ASP.NET 2.0. Key role in

troubleshooting of the existing application, interaction with

business owners regarding project specifications. Responsible for

design and implementation of the following components and support

applications, developed in ASP.NET 2.0, web services, C#, SQL Server

2005:

A single sign on (SSO) user authentication component.

Application-wide notification module.

Used ETL for synchronization of internal data with debit card

providers' information.

Export client's information from MS SQL to Microsoft Access format.

Windows form support application for uploading data from internal

repository to providers.

Created 50 tables 70 complex views, 100 stored procedures and 50 user

defined functions.

Senior Software Engineer, Kintera Inc., San Diego, CA

07.05- 04.07

Analysis of the specification, design and implementation of the web-

based solution for non-profit organizations, provide post-

implementation support to resolve all the issues in a timely manner.

Key role in design, implementation, unit testing and developing of

web application created in ASP.Net, C#, SQL Server to enable the non-

profit organizations in managing their tasks and appointments,

integrating with Outlook calendar.

Designed, developed, unit tested of the web application to help non-

profit organizations to communicate with their clients. Used ETL to

transfer the data from customer's data files to the internal

database. Wrote the engine to generate CSV and PDF files to help

users to get their data and put it in the template. Created complex

views and stored procedures. Done by using ASP.Net, C#, SQL Server.

As a team player participated in design, development and unit testing

of the Transaction Platform component, used as a middle tier to be

utilized by web application.

Interacted with product managers regarding project specifications,

with QA and configuration management teams to provide technical

support.

Senior Programmer-Analyst, RFPExpress Inc., San Diego, CA

07.1999 - 07.05

Key role in design, development and performance tuning of a web-based

business-to-business RFP (Request For Proposal) solution for individual

hotels and hotel's chains.

Participated in design of the component-based application based on NET

2003, C#, ASP.NET, Microsoft Application Blocks (Data Access, Exception

Management).

Key role in design and implementation of a base component for dynamic

generation of web controls (server/asp, html and validation). This design

utilized a combination of XML serialization and data-driven approach.

Wrote complex stored procedures, triggers, views, user-defined functions.

Optimized database design and implementation to maximize performance (MS

SQL Server 2000, 2005).

Worked in a team that designed and implemented a web-based system for

travel industry utilizing ASP 3.0, Visual Basic 6.0, SQL Server

2000/2005 (beta), maintained and enhanced SQL Reporting database for

SSRS, Crystal Reports 8.0 MS Access Reports.

Defined and edited document schema for any structured document type,

including XML, electronic data interchange and flat files using

BizTalk Editor. Built document maps that allow applications with

different document definitions to communicate with each other using

BizTalk Mapper and BizTalk Messaging Manager.

Extensively used SQL Server ETL to migrate data from more than 70

companies, over 65,000 hotels and motels worldwide and many of the

largest travel agencies and travel management companies databases to

internal database. Also produced files to migrate the data from

internal database to these companies back.

Maintained C# and VB-based COM applications, which allow integration

of Internet, fax and e-mail technologies.

Interacted with the end users and provided technical support to

customer service.

Programmer/Analyst. Alpha Mechanical Inc., San Diego, CA

02.1998 - 06.1999

Participated in design and implementation of a Job Control System.

The user-friendly interface developed using Visual Basic 5.0 and

Oracle Forms allowed convenient navigation through the different

components of the applications (Oracle 8.0).

Maintained vendor, customer and employee data. Created weekly,

monthly and annual reports using Crystal Report and Oracle Reports.

Participated in the design of the in-house Estimating System.

Application was developed using Visual Basic 5.0 and Oracle Forms as

the front-end, Microsoft Access and Oracle database as a back-end.

EDUCATION

MCSD/MCAD .NET 1.0, MCTS .NET 2.0 Web Applications, MCTS .NET

2.0 Distributed Applications.

UCSD, San Diego, CA

. C#, Advanced ASP.NET, WCF, .NET Web Services, Macromedia Flash

. BS in Computer Science. Polytechnic Odessa State University,

Odessa, Ukraine.

Contact this candidate