Sql Server Software Engineer

VADIM RAPOPORT

**** ********* ***, ***. * cell phone: 310-***-****

Encino, CA 91316 email: *****.********.***@*****.***

QUALIFICATIONS PROFILE

Solutions-oriented Programmer with over 10+ years of IT experience in all aspects of Development, Testing and Troubleshooting.

- Highly adept at promptly and thoroughly mastering new technologies and adapting to existing corporate infrastructures, producing results immediately on hire in cross-functional IT roles.

Technical Background

Platforms: UNIX, LINUX, WINDOWS.

Databases: MS SQL Server 2000/2005/2008, MySQL, Ingres, InterBase.

Languages: C++, Visual Basic, Shell scripting, PERL, PYTHON, RUBY, HTML, XML, XSD, VB .NET, C#, JavaScript, LINQ, JQUERY

Tools: Microsoft Office Suite, SQL Server MS, MS Visio, Visual Studio

2005/2008/2010, Borland Delphi 4/5/2006, InstallSheild, Crystal Reports, MS Reporting

Services.

Testing Tools: IBM Rational Robot, WinRunner.

DBA\Developer skills:

- Design, document and implement complex databases or modifications to existing ones.

- Implement process and/or manage transfers of data between external data structures (e.g. flat files, Access, Excel files) and existing databases.

- Backup, create, copy, move and perform other maintenance operations on existing databases.

- Development and implementation of operational policies and procedures.

- Developing, implementing and testing backup schedules and recovery procedures.

- Writing and utilizing operations based scripts and tools.

- Troubleshooting.

- Windows and Web Applications using the latest technology.

Ad Hoc Reporting Tools:

- Crystal Reports, MS SQL Server Reporting Services, Access, Excel.

Configuration Management\Version Control tools: VSS, TFS, Star Team Professional, Perforce SCM, PVCS, Jedi VCS.

PROFESSIONAL EXPERIENCE HIGHLIGHTS

Software Developer InsuranceLeads.com (acquired by AllWebLeads) – North Hollywood, CA September 2008 –Present

SQL Server 2008 database design, develop and administration within a high volume, transaction-oriented web environment. Respond to production and/or mission-critical eCommerce applications issues and needs on 24x7 basis. Responsible to design, develop, review, and administer of all databases, database jobs, packages, stored procedures.

Create, modify, build, and daily support database-driven web applications and web services (www.2insure4less.com, www.insuranceleads.com, www.leadsclearance.com) using the latest technologies.

Create and add new web pages (report, account, billing, profile, etc.) to existing web sites from design web pages, coding, debugging to publishing web sites. Design and modify SQL tables, stored procedure, triggers using MS SQL Management Studio 2005/2008/2010.

Integrate (mapping and posting) insurance leads between Insuranceleads.com and other main companies in the insurance leads industry: InsWeb, InsureMe, NetQuote, QuoteWizard, PreciseLeads, LowerMyBills, etc.

Coordinate integration and testing between affiliates and InsuranceLeads.com. Validate incoming data, monitor error log, and final approval before going to production.

Use classes generated from schema and LINQ to build XML files and post data to: Allstate, 21st Century, UnitrinDirect (all of them use ACORD), eFinancial, AIS, Esurance, WellPoint, Assurant, and other insurance companies.

Integrate and upload insurance leads to the different Leads Management systems including: Blitz Management System, SilverPlume, Vertafore PL-Rating, AgencyIQ, Leads 360, Astonish, EFIN, EZlynx, Acxiom (for Allstate), Apollo Interactive, InsideLeads, QuoteIt, CreativeMarket, ProspectPlus, WellPoint, State Farm, etc. using client specifications. Build a bridge between InsuranceLeads.com and AllWebLeads.

Report to Director IT Department, VP of Business Development, VP of Corporate Department.

Sr. Programmer Analyst Cels Enterprises – Los Angeles, CA March 2007-September 2008.

I was responsible for implementing new requirements and supporting POS (Point-of-Sale) for Retail store and internet sale. The programs are written using standard 3-tier architecture utilizing CodeGear Delphi 2007, third-party components, and MSSQL 2005 as a database server. Created reports using Crystal Reports and Excel.

Created the watch dog application that checks nightly for new orders from internet, checks database warehouse for availability (AS400, the interface to the AS400 database was wrapped as a web service), sends requests to VeriSign for credit card authorization, updates POS database and prints reports with approved and declined orders.

Communicated with managers and VPs of the company and end users to collect and verify requirements as well as to present proposed solutions and designs. I reported directly to CIO.

Software Analyst AIM Group, Cedars-Sinai Medical Center, Los Angeles, CA May 2005 -March 2007

Supported and tested the medical cardiac applications

Created the scripts for automated build (include VCBuild), testing and email notification using Ruby, Python and MySql. Wrote the scripts for regression testing. Managed the group bug system, the build machine and the Perforce SCM.

Software Engineer OTMP (Media Services), Los Angeles, CA February 2000 - April 2007

Participated in developing and testing in-house client-server Payroll application using Visual Basic .NET, ADO.NET, and MS SQL 2000. Applications provide full payroll support for the company’s accounting department. I was responsible for developing and debugging tax calculation modules. The modules provide the screens and allow to setup, modify, calculate city, state and federal taxes, and were utilizing the application security infrastructure to check roles and privileges of users to access different features of the screens.

Participated in developing of the client-server Bank Reconciliation application using Borland Delphi 4.0/5.0. Developed the program for data conversion from the BAI file submitted from City National Bank to the company database. Performed debugging and bug's fixing.

Reproduced, diagnosed and documented software defects. Verified new feature requirements in each release. Maintained and managed bug lists, collected and recorded software defects in reporting system, offered suggestions, collected and reported quality metrics. Created and maintained automated scripts.

Was responsible for building of the project (getting and installing latest version of files from VSS, rebuilding database, backup and restore database, compilation of the project, creating an installation program using InstallShield). Created batch files. Created reports using Crystal Report.

Jr. Programmer Analyst, Diamond Bar, CA October 1998 – February 2000

Responded to Systems and Programming Action Requests by preparing feasibility study reports; performed coding and debugging, unit and system testing of Facility Permit Process System (FPPS), integration Fee Modules (ActiveX Controls) and NSR (Visual Basic OCX Control), fixing bugs using Visual C++ 5.0, Visual Basic 6.0, JavaScript. Assisted the Programming Manager in the evaluation of software packages (overseeing the flow of software to and from production), reviewed and evaluated new and existing programs; and planed and scheduled input/output. Analyzed and evaluated existing data processing procedures and made recommendations to improve division operations affiliated with a specific system under study; defined problems, prepared flow charts and draw block diagrams to indicate essential data processing operations.

Wrote UNIX shell scripts for Change of Ownership program (Trading System).

Provided programming support for Facility Permit system and the annual permits printing.

EDUCATION

BS in Engineering (with honor), Ural State Technical University, Russia.

Contact this candidate