Sql Server Engineer
Resume:
Elena Krasnova-Sokolova
***** ******** ******, *** *****, CA 92129
**********@*****.***
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