Post Job Free

Resume

Sign in

Sql Server Customer Service

Location:
Alpharetta, GA, 30022
Posted:
August 23, 2013

Contact this candidate

Resume:

ANNA SLUCHOK

***** ******** ***** **********, ** 30022 (ph) 770-***-****

(e-mail)

ab5iaq@r.postjobfree.com

OBJECTIVE: A Professional Position in IT Operations, with special

skills in IT

Support, Systems Design and Software

Development

HARDWARE: IBM PCs and compatibles

SOFTWARE: SQL Server 6.5/7.0/2000/2005/2008 (9 yrs), Oracle 9,10 and

11,

MS Access 7.0 (6+ YRS), MS VB6 (6Y),

VBA, Crystal Report 4.5, MS Word, Delphi 3.0,

4.0, HTML, ASP,

IIS, MS Windows 95, 98, XP, NT (3+Y)

EXPERIENCE:

04/2012 - 07/2013 Contractor/Sedgwick

Atlanta, GA

Primary Responsibilities:

. Performs a variety of tasks.

. T-SQL to include stored procedures, functions, views XML,

SSIS, SSRS

. Prior Conversions. Convert data from different clients to

SQL Server 2005 tables

. Updating Data Mapping documents.

. Support production databases

. Work with parameters. Create scripts for add/update/delete records

from database by client request.

. Monitor job and transfer queues to ensure they are functioning as

expected.

10/11 - 03/2012 Contractor/Riskconnect

Atlanta, GA

. Create SSIS packages for load data to SQL Server 2005 database

. Create Stored Procedures and views.

. Create reports using SSRS

. Create and run jobs on VisualCron

. Validate data. Create support documents.

11/10-09/11 Contractor/Myers & Stuffers

Atlanta, GA

SQL Developer

Work on client site. Create stored procedures and

complex queries

for download different type of files to SQL Server 2008

database using SSIS.

. Identify potential fraud and overpayments using SQL Server to

identify claims paying contrary to written policy

. Perform analytical reviews on large data sets and make recommendations

based on results

. Evaluate business processes to identify opportunities for automation

and optimization of human and/or physical resources

. Effectively identify and document business requirements for projects

. Work in multi-discipline teams to solve common business problem

. Maintain security and confidentiality of all protected health

information encountered during performance of other essential

functions

. Additional responsibilities as assigned

03/07- 11/10 EDI Watch Inc.

Atlanta, GA

SQL Developer

The responsibilities include:

. Analyze end-user requirements and prepare all reports accurately.

. Troubleshooting Intelligent Investigation application.

. Provide technical support.

. Update database with reference data by client request.

. Update Application screens.

. Prepare reports and evaluate output to support investigations.

. Research and prepare special studies as required.

. Product development using Oracle 10, 11, PL SQL, Jasper Report

(iReport).

01/05 - 03/07 Contractor/Travel Agency

Atlanta, GA

Consultant

. Business requirements analysis;

. Support and develop web form applications using Visio, VB, ASP, .Net;

. Support existing SQL Server and MS Access databases.

. Create new SP, T-SQL and DTS.

05/04 - 12/04 Adecco/UPS

Atlanta, GA

Programmer/Database Analyst

. Business requirements analysis;

Development of DTS packages, stored procedures; T-SQL

Full life cycle development of operational requirements and technical

specification;

Unit testing and creating documents.

11/01- 05/04 Star Choice Enterprise

IT Consultant

Atlanta, GA

. Support MS Access databases. Responsible for database

automation needs. Create heavy queries, reports.

Run reports for sales and billing

departments. Participated in several programming

projects, utilizing VBA,

VB 6.0, Excel 8.0.

3/01-11/01 OLS TELECOM, INC

Atlanta, GA

System programmer

. Responsible for the design and development of customer service and

billing applications. Duties included the design and

creation of customer

databases using SQL Server 7.0 as well as the user interface

using custom DTS tasks in Visual Basic 6.0

. Developed store procedures using Visual Basic and database triggers

using

T-SQL.

. Created reject, service fees, and credit reports for departments using

MS Access and Visual Basic.

Environment: SQL Server 7.0, MS Access, Visual Basic 6.0, Windows 98/NT/XP.

4/00-3/01 MCI WORLDCOM

Atlanta, GA

Database analyst/programmer

. Responsible for the production support of several production databases

and the commercial vendor billing systems that invoiced over

$72M in

annual revenue.

. Responsible for database automation needs for SQL SERVER and Access

databases. Performed database creation, maintenance, interface

forms,

stored procedures, triggers, created queries, and reports.

. Ran reports for sales and billing departments. Support Web Page

applications.

. Participated in several programming projects utilizing MS SQL Server,

MS Access, VBA, Visual Basic 6.0, ASP, Delphi 4.0, Crystal

Report 4.5,

and Windows 98/NT.

10/98- 4/00 Intown Suites, Inc.

Atlanta, GA

Programmer

. Designed and developed database for Accounting

and Operation Department. Responsible for the development of

interfaces for the input and maintenance of data to the database.

. Environment: Visual Basic, Access 97, HTML, DHTML.

6/97-6/98 Modern Software

Atlanta, GA

VB Programmer

. Designed and developed a scheduling application,

which allowed storing client information in a database, scheduling

appointments and notify users of upcoming events, using VB 5.0 and

MS Access. Participated in several programming projects, utilizing

VB,

Sybase SQL Server, and MS Access.

1994-1997 South Eastern Health Service

Atlanta, GA

Database Operator

. Retrieve and download customers' information files.

. Analyze Medical Claims

. ICD-9 AND CPT-4 Coding

. Maintenance database.

EDUCATION: JAVELIN TECHNICAL TRAINING CENTER, ATLANTA, GA

MCDBA Certification Program

KIEV TECHNOLOGY COLLEGE, Kiev, Ukraine

BS, Engineering and Microbiology

LANGUAGE SKILLS:

English, Russian, Ukrainian.

PERSONAL: US Citizen.



Contact this candidate