Sql Server Developer

Vlad Rafalovich

Ph. 813-***-****; E-mail: ********@*****.***

**** ******** *****, ****** ******, FL 33545

Microsoft Certified in SQL Developing

T-SQL (12 years)

SQL Server 6, 7, 2000, 2005, 2008 (10 years)

SSRS/SSIS (8 years)

Sybase (2 years)

Btrieve (3 years)

MySQL (3 years)

Visual Basic (6 years)

VB.NET (4 years)

ASP.NET (4 years)

ASP (6 years)

C# (4 years)

PHP (1 year)

VBA, Access, Excel (10 years)

Cold Fusion (1 year)

Telerik Reports (2 years)

Crystal Reports (10 years)

Win NT Development (6 years)

Delphi (10 months)

United States Citizen

Local to Tampa/St. Petersburg

Summary of qualifications

Programmer/Analyst in NET, VB6, Access, SQL Server, Sybase, Btrieve. Proficient knowledge of math and statistical methods, strong analytical skills. Fast learner, dedicated, self-motivated. Author of technical articles in journals and a book.

Languages and Tools

SSRS, Crystal Reports, Jasper/TIBCO Reports, C#, VB.NET, Visual Basic 4.0, 5.0, 6.0, VBA, SQL, Microsoft Internet Technology, HTML, VBScript, CGI/VB, ASP, IIS 4.0, ODBC, ADO, ISAPI, OLE, ActiveX, PHP, ColdFusion, Visual Interdev, Excel

Databases

Access, Sybase, SQL Server, Pervasive, PostgreSQL, MySQL

Operating Systems

MS Windows, NT Windows, MS-DOS

Work experience

April 2010 - Present Molina Healthcare, Inc / Tampa, FL

Consulting, SQL Developer

Creating claims, billing, providers and other reports using Crystal Reports (XI/2008) and SSRS Reports

Maintained automated report subscription over the company’s recipients.

Troubleshooting installed system and 2 tier applications

Analyzing data source files and building ETL/SSIS processes to import data for reports

Migrate data from the iSeries, flat files, XML files, FoxPro, MS Access and etc into the SQL database, using SSIS

Creating complicated queries and stored procedures to run reports

Database maintaining (backup/restore, data import/export, creating and scheduling jobs, maintenance plans and etc.)

SQL Servers and windows workstation administration

Optimizing stored procedures, indexes, SQL performance to speed up reports

Creating Data Warehouses for data analyzing and optimizing reports run

Using Data Mining add in for Excel for analyzing and data prediction using different statistical models

Using XML files, text files, Excel files, Access db, SQL Server as data sources

Creating jobs to run nightly SSIS processes

Using Clouds platforms (AWS, Azure) to keep some client’s databases. Involved in process of moving most clients into to clouds platform.

May 2007 – April 2010 Creative worlds/EMR Team / Hollywood, FL (remote)

Consulting/SQL Developer

Creating Crystal (X, 2008) Reports to support TIER application for mental institutes

Building reports for EMR processing and documentation

Using ClaimTrak for building custom reports for the system

Build custom TIER forms to support new EMR documents

Building stored procedures to support reports and front end forms

Create SSIS packages to move data (Dictation Notes and other big volume files) from files to database and vice versa. Set up jobs to automate nightly processes.

Improving performance of slow running processes.

November 2006 – May 2007 JPMorganChase, Tampa

Consulting, SQL Developer/DBA

Creating scripts for generating standardized stored procedures

Creating SSIS (DTS) packages for moving data from one data source to warehouse (SQL Server 2005), for data mining processes, analyses and etc.

Creating database schema and scripts

Monitoring database activity, jobs processing, database and transaction log growth

Developing ASP.NET interface for data presentation

Some UNIX file downloads.

January 2006 – October 2006 MyCustomerFirst, Inc Chicago, IL (remote)

Consulting, Project Leader

Creating web based business reports for customers using Crystal/ASP.NET.

Building company’s web site

Creating utilities using web services (C#, VB.NET)

Heavy use of DTS, Stored procedures, functions and other SQL tools to clean data before moving it from flat files to db

Monitoring database activity, manage and monitoring data growth

Tuning sql queries performance

August 2004 – December 2005 Brac Informatics Centre, Ltd, Cayman Islands (remote)

Project Leader/Consulting

Creating C# utilities for disaster recovery systems.

Developing ASP.NET interface with SQL Server on the back end.

Developing Web Services (C#) for the Java front end.

Creating web reports using Crystal and ASP.NET

Database backups, scripting changes in the database structure and data

Developing and supporting products for Insurance company (C#, SQL Server, ASP)

Supporting different software products for the company’s clients (.NET, SQL Server).

July 1998 – June 2004 The Sembler Company, St. Petersburg, FL

Contractor

Creating different financial reports for the accounting department using Access and Excel on the front end and Btrieve/SQL Server on the back end. Those reports to compliment YARDI system reports.

Created user interface with password protection, menus and data entry forms using VB.NET/C#

Conversion back end database from Btrieve to SQL Server

Fixing data conversion problems, writing VB procedures for data transfer

Created stored procedures in SQL Server to speed up some reports

Developing financial/accounting reports in Access

July 2001 – August 2002 LegalWise, Inc., Tampa, FL

Senior Software Engineer

Maintaining current Access/SQL Server production application for insurance company

Creating and developing stored procedures, triggers and etc.

Moving current application from Access to VB.NET front end (with use COM+, ADO). Redesign database and functionality.

Maintaining company website (IIS, ASP, MTS). Creating ASP.NET/Crystal Reports (8, 8.5) production reports for viewing through browser and locally.

.

April 1999 – July 2001 Cox Target Media, Inc Largo, FL

Senior Software Engineer

Working on VB6.0 project with group of programmers. Front end via network or dial-up connected with Sybase on the back end.

Project includes 80 forms, 20 modules, and 10 modules-classes, heavy use of COM object model.

Project heavily utilizes stored procedures on the back end, SQL through DAO and ADO for database access, Crystal Reports (6, 7). Other third party tools: TrueGrid 5

February 1998 – April 1999 Briggs Corporation Tampa, FL

Project Leader

Managed web project for the company. Tasks included creating CGI and ASP applications for corporate web site, cutting edge ActiveX technology for viewing Access reports over the Internet, which were updated daily.

SQL Server as a backend database. Connected graphical data representation to the database. Project in VB5, VB6.

Creating different utilities for internal company use using VB, OLE Automation/COM applications.

Managing small group of programmers working with Web project.

Creating windows programs for accessing AS400 database files using third party ActiveX controls. Heavy use of COM components.

Heavy use of third party controls (Sheridan and Crescent)

Created stored procedures in SQL Server to run from VB program.

December 1996 – February 1998 i2 Technology, Inc Cambridge, MA

Software Engineer

Education

September 1995 – December 1995 Clark University Cambridge, MA

Client/Server

Certificate courses in Client/Server programming including ORACLE, SYBASE, ACCESS

1988-1993 Rostov State University Rostov on Don, Russia

MS in Physics and Applied Math

Contact this candidate