New York Sql Server Developer .Net Manager Data

IRINA DROT **** Bay Pkwy Apt * D

Brooklyn, NY *1214

347-***-**** - cell

SUMMARY: Application developer analyzes requirements and develops

Windows and Console applications. Experienced in full project

life cycle, has excellent coding and debugging skills, database

design, data manipulation and user interface responsibilities.

Writes, compiles and runs applications and reports using C#

.NET, MS SQL Server, MS Reporting Services and Crystal Reports.

OPERATING SYSTEMS, SOFTWARE & SKILLS:

VISUAL STUDIO.NET, C# .NET, MS SQL SERVER, LINQ,

SYBASE, MS REPORTING SERVICES, VISUAL BASIC, XML,

CRYSTAL REPORTS, ACTIVE DYNAMIC REPORTS,

MS ACCESS, EXCEL, XML, WINDOWS, CITRIX

EXPERIENCE: 10/2006 - 10/2009 - Business Intelligence Associates New York,

NY

Application developer.

Worked as an application developer and data programmer in litigation

support environment. Designed, implemented, tested and deployed

applications involved in EDD process and load files creation. Handled user

requests, problems and troubleshoot them.

As a part of the team was responsible for:

. C# .NET Win-forms and Console applications development.

. Building C# classes and inheritance hierarchies.

. Creating custom and user controls.

. Designing MDI and Outlook-style applications.

. Working with databases using ADO.NET and Language

Integrated Query (LINQ).

. Various .net patterns.

. Data binding with generics and ADO.NET Data Sources.

. Managing databases. Creating and updating database

objects.

. T-SQL: writing queries, stored procedures, triggers,

views for data manipulation.

. Reflection.

. Using MS Outlook object model and MS Office, Excel and

Lotus Notes automation through .NET

. Data Export/Import using SQL Server, MS Access and

Excel.

. Files I/O.

. Regular Expressions.

. Automating documentation with XML.

. MS Reporting Services 2005.

. Litigation support applications: Concordance, Summation.

. Strong troubleshooting and technical support skills.

02/2006 - 10/2006 DOAR Litigation Consulting Lynbrook, NY

Data Programmer

Worked in Litigation Support Department of the company as a data

programmer.

Performing tasks associated with data processing, quality control and

client data delivery processes. Involved in client/server Windows

application development and maintenance.

As a part of the team is responsible for:

.

. Software utility creation using C# Win-Forms, Visual

Basic 6 and VBA.

. T-SQL: stored procedures, triggers, views.

. Data Export/Import using SQL Server, MS Access and

Excel.

. Preparation of client deliverables, including images,

data files for loading into specific litigation support

application databases.

. Data Formatting.

. Litigation support applications: Concordance, IPRO,

Summation.

. Files conversion and manipulation.

. Creating and modifying databases using MS SQL Server

2000 Enterprise Manager and MS Access.

. XML Processing.

. Crystal Reports.

. MS Access Reports.

. Third Party Controls.

07/1999 - 11/2005 SKADDEN, ARPS, SLATE, MEAGHER & FLOM LLP New York, NY

Senior Programmer

Developed software client-server applications for automation projects of

Litigation Technology Department and Administrative Departments. Consulted

with clients to gather information about program input and output

requirements. Analyzed requirements for data, workflow, logic and

integration with other systems. Designed and coded screen layouts and

graphical user interfaces. Run tests to find errors and confirm programs

meet specifications. Wrote and maintained documentation to describe program

development, coding, testing and changes. Provided users or Technical

Support Staff application training.

As a part of a team was responsible for:

. Application analysis, design, development, maintenance,

testing, deployment, distribution, upgrade and support

of Windows applications.

. Writing programs to integrate with such litigation

support applications as Documatrix, Live Note and

Concordance.

. MS SQL Server 2000 Enterprise Manager, Transact-SQL,

ISQL, ODBC, Sybase.

. Stored Procedures, Triggers, Views.

. Data Export/Import, Formatting.

. Creating GUI using C# or Visual Basic 6 as a front-end

tool and SQL Server or Sybase as a back-end tool.

. Using C#.NET Win-Forms and Controls.

. VB.Net Components.

. Accessing databases using DAO, RDO and ADO in VB6 and

ADO.NET and OLEDB in Visual Studion.NET environments.

. XML Processing.

. Implementation of DLLs and OLE between various Windows

applications.

. MS Access.

. Crystal Reports.

. MS Reporting Services.

. Active Dynamic Reports.

. Using Object Oriented technology to build reusable

components.

. Collections.

. User Controls.

. Writing program specifications and documentation.

01/98 - 05/99 DEBARI ASSOCIATES ACQUISITION CORP. New York, NY

Senior Programmer

Worked on litigation support projects to provide the user with a

searchable

databases. Each database made up of bibliographic data records linked to

the group of images associated with that record. The image-enabled

database

is a good tool for a user who wants a quick and capable method of

retrieving

paper files. As a part of a team was responsible for:

. Design, coding and applications maintenance.

. Implementing a database design on MS SQL Server 6.5.

. Designing and using tables, views, stored procedures,

triggers.

. Creating GUI using Visual Basic 5 as a front-end tool

and SQL Server 6.5 as a back-end tool.

. MS Access

. Preparing reports for management using Crystal Reports.

. Preparing program specifications.

. Classes.

. Third party controls.

01/88 - 10/92 Aeroflot, Ashgabad, Turkmenistan

Programmer

Involved in the development of the Flight tracking system. This system

provides users with flights schedule and flights accounting information.

EDUCATION:

2009 Learning Tree International, New York, NY

Certified in LINQ and extended C# features.

2008 Learning Tree International, New York, NY

Certified in .NET Best Practices and Design

Patterns.

2007 Learning Tree International, New York, NY

Certified in Microsoft Reporting Services 2005.

2007 NYU, New York, NY

Certified in Systems Analysis and Design.

2003 Learning Tree International, New York, NY

Certified in Developing .NET Applications

2000 Sybase, New York, NY

Certified in Advanced Transact SQL

1999 Allaire, New York, NY

Certified in Fast Track to Cold Fusion

1994 - 1996: Hunter College, New York, NY

Classes in Computer Science

1983 - 1987: Aircraft College. Ufa, Russia

Degree: BS in Electronics & Computer Science

REFERENCES: Will be furnished upon request

Contact this candidate