Sql Server Developer
Resume:
Sergey Petushkov ** Brook Rd, Sharon, MA, *****
****.*********@*****.***
Microsoft Certified Professional ID: 7363165
Microsoft certified SQL Server developer
SQL Server Developer/Analyst with experience with MS Visual Studio, MS SQL server, MS SQL Server BI
Development studio (2000-2008). Extensive experience with T-SQL, SSIS, SSRS, stored procedures, user-
defined functions and views. Experience of Microsoft web application development including ASP.Net and
ADO.Net.
Strong analytical skills, work well in team setting and independently. Hard worker, fast learner, detail-oriented
professional.
Technical Skills
Platforms: Windows, IBM z/OS
RDBMS: MS SQL Server 2000/ 2005/2008, IBM DB2
Languages: VB.Net, VBScript, T-SQL, SQL, XML, COBOL, PL1, Assembler OS/360
Tools: MS Visual Studio 2005/2008, SQL Server Business Intelligence Development Studio 2008,
ADO.Net, ASP.Net, DTS, SQL Server Integration Service, SQL Server Reporting
Service, stored procedures, view and triggers,
ISPF, File Aid, JCL, Change man, EZTRIEVE, FTP, QMF,TSO, MS Office, Mercury test
director
Professional Experience
MetLife
Employee as Business System Application Developer 2005-2008
Role: SQL Server developer
The Customer Information Management (CIM) System is the repository of all the Client data for the insurance and investment
products. CIM has data warehouses and staging tables for Annuities, Insurance and Mutual Fund and Brokerage and Front-end
tables which are accessed by ETL tools like SQL Server SSIS. The warehouses are updated and inserted with the feeds from
various upstream systems; the bridge programs run on the warehouse tables and update the front-end tables.
• Developed and updated multiple stored procedures in SQL SERVER for business system “NEFConnect”.
SQL Server 2000/2005/2008
• Developed and support multiple business reports using SS Reporting Service for Marketing subsystem.
SQL Server 2005/2008 SSRS, Report Builder, Report Manager
• Designed, coded, tested and implemented Client Server internal application to create statistic reports.
Create dynamic SQL queries, retrieve data from SQL server DB, create reports using Crystal Report and
e mail the reports to end customers
SQL Server 2005, VB.Net, ADO.Net, embedded Crystal Report
• Tuned SQL queries for AD HOC reports.
SQL Server 2005/2008, Profiler, DataBase Engine Tuning Advisor
• Creating mainframe application loaded data from outside vendor to DB2 for Distributed Agency System. Creating
sets of SSIS packages to extract data from DB2 and load to SQL Server 2005
SQL Server 2005, SQL Server Integration Service (SSIS), DB2, Cobol.
• Developing SSIS packages to extract SQL Server data to Excel.
SQL Server 2005/2008, SQL Server Integration Service (SSIS)
• Participating in Web Client Purification unit project. Developed, coded, tested Java based interface between
middleware and front end using XML and hash tables technology for 3 tiers Web Application in Web Sphere
environment. Creating business specification, designed, coded and tested set of stored procedures provided
back end business functionality for the WEB application
WebSphere, Java, XML
New England Financial
Consultant based via ADEPT.Inc 1997-2000 and
Metlife
Employee as a Business System Application Developer 2000-2005
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, 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.
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