Sergey Petushkov

** ***** **, ******, **, *****

l83gp7@r.postjobfree.com

508-***-****

I’m looking for SQL server/BI developer position in Massachusetts.

SQL Server Developer/Analyst with experience with MS Visual Studio, MS SQL server, MS SQL Server BI Development studio (2005/2008).

Extensive experience with T-SQL, SQL Server Integration service, SQL Server reporting service, stored procedures, user-defined functions and views.

Experience with Microsoft Windows Client/Server application development including ADO.Net, and Crystal Reports.

Some experience with ASP.NET, OLAP and data mining,

Strong analytical skills, work well in team setting and independently. Open to new experiences and new technologies.

Technical Skills

Platforms: Windows, IBM z/OS

RDBMS: MS SQL Server 2000/ 2005, IBM DB2

Tools: VB.Net, T-SQL, SQL, XML, HTML, CSS, JavaScript, MS Visual Studio 2005,

SQL Server Business Intelligence Development Studio 2008, ADO.Net, DTS, SSIS, SSRS,

Stored procedures, view and triggers, Start Team, Mercury test director, MS Word, Excel, Visio,

Cobol, Pl/1, OS/370 Assembler, JCL, TSO, FileAid, VSAM

Professional Experience

MetLife (Insurance, Financial) 2005-2008

Role: SQL Server application developer

• Worked on all phases of SDLC, from gathering requirements to testing, implementation, and support.

• Designed and developed SSIS packages, store procedures, configuration files, tables, views, and user defined functions

• Developed and updated multiple stored procedures in SQL SERVER 2005

• Transfer set of stored procedures and DTS packages from SQL 2000 to SQL 2005.

• Developed and support the business reports using SQL Server Reporting Service for Marketing subsystem.

• Designed internal WinForms application to create dynamic SQL queries, retrieve data from SQL server DB, create reports using Crystal Report and e-mail the reports to end-customers

• Responsible for implementing and deploying various aspects of reporting in the Data warehouse systems.

• Data Analysis

• Performed tuning of database applications

• Provide on-call support to production system to resolve any issues.

MetLife (Insurance, Financial) Application Developer 1997-2007

Role: Mainframe developer

Primary responsibilities: Analysis, developing, testing, documentation of a new and existing on-line and batch business systems on mainframe environment. All stages of SDLC of various projects.

• Developed DB2 Stored Procedures and triggers for Consolidated Investment Data Warehouse Project. The project involves capture of daily changes from a remote database to local database using IBM replication and remote DB2 programs triggered by changes to control tables using Revolving Schedule.

Cobol, DB2, JCL, TSO, Spufi, SQL, FileAid, DB2FileAid etc.

• System Requirement, Analysis, System Delivery specifications, user interaction. design, technical specifications, technical review, code walk-through, coding DB2, CICS programs, debugging, unit testing, writing test cases and test plans, performance tuning, production and post-implementation support for numerous business systems based on mainframe environment.

Cobol, DB2, JCL, TSO, Spufi, SQL, FileAid, DB2FileAid etc.

Scientific Production Association (Production),

St-Petersburg, Russia 1990-1997

Software engineer

Role: Application developer (mainframe and Windows environment)

Primary responsibilities: Support OS/360 as system programmer and application developer

• Designed, coded, tested and implemented applications for the Accounting system using ASSEMBLER, CICS, ISAM, and JCL on OS/370 platform.

• Designed, coded, tested and implemented applications for Navy notification system using Borland C, Oracle 4.0

Education and Training

• Bachelor of Science in Applied mathematics State University of Electrical Engineering, St-Petersburg, Russia

• Developing on SQL Server 2000 New Horizons Computer Learning Centers, Boston - 2004

• WSAD 5 for J2EE developers New Horizons Computer Learning Centers, Boston - 2006

• Fundamentals of XML New Horizons Computer Learning Centers, Boston - 2007

• MCTS Microsoft SQL Server 2008, Business Intelligence Development and Maintenance – 2010

Microsoft Certified Professional ID: 7363165

Awards and Status

“Certificate of Excellence” and “Certificate of Accomplishment” for analytical and problem-solving skills.

US Citizen

Contact this candidate