***********@*******.***

Dmitriy Zamoshchin

***** *. ****** ***** ******, Colorado 80015 E-mail: ***********@*******.***

Cell: 720-***-****

OBJECTIVE

Software Professional seeking to broaden experience in the Project Management.

SUMMARY:

A technically well-rounded Software Professional with over 10 years of hands-on experience in Database and Application business analysis, project management, design, development, testing, and maintenance. A detail-oriented professional who leverages strong mathematical, logical, analytical, and problem solving skills to produce high-quality applications.

Languages:

T-SQL, DDL, DML, SQL* Plus, XML, HTML, DHTML, MDX, VBScript, JavaScript, Visual Basic 6.0, VB.NET

Software:

SQL Server 2000/2005/2008

StarTeam

SQL Server Reporting Services

Vault

SQL Server Integration Services

EDI

Red Gate SQL Compare Suite

ADO.NET

VS 2005 Database Professional

Remedy Help Desk

Team Foundation Server

MS Project

OLAP

MS Access

Oracle 7

SQL Server Analysis Services

Wiki

PerformancePoint Server 2007

Visio

Classic Active Server Pages 3.0

IIS

PROFESSIONAL EXPERIENCE

TSYS iSolutions, Golden, Colorado 2009

SQL Server Developer / Project Manager

• Performed full software development life cycle Project Management in Agile/ SCRUM environment.

• Worked side-by-side with end client in UK to define requirements and design specifications for business-to-business (B2B) file transfers between accounting systems.

• Complex T-SQL development, QA testing, and troubleshooting for a company, which handles large volumes of credit card processing.

• T-SQL code was coupled with XML build files to generate custom reports.

• Offered technical mentoring to a team of C# developers who were less adept in T-SQL.

Sogeti USA, Greenwood Village, Colorado 2008

Senior Consultant

• Designed and delivered targeted business and technical solutions based on specific business requirements, and provides technical direction to other team members.

• Achieved high client satisfaction.

• Demonstrated good consulting foundation skills - analysis, critical thinking, communication, flexibility, time management, problem solving.

Mercury Companies, Denver, Colorado 2007-2008

SQL Server Database / Datawarehouse Developer

• Worked in a team to develop business requirements into conceptual, logical, and physical data models and development of services to expose the data for business analysis.

• Developed a variety of transactional, warehousing and reporting applications to be used within mission-critical business applications.

• Developed, unit tested, and debugged code in SQL Server 2005 and 2000 databases.

• Applied Microsoft Database Security Principles.

• Developed data warehouse and reporting systems using SSIS and SSRS including Report Builder and Report Models.

• Developed and maintained Stored Procedures, Views, Indexes, Jobs, and User-Defined Functions.

• Enhanced database performance through analyzing and re-factoring procedures and schema as needed.

• Managed Database Code Releases using Red Gate SQL & Data Compare Suite.

Aluron, Inc., Aurora, Colorado 2007

Project Manager/Database Architect

• Defined business processes and developed business requirements.

• Focused on meeting the business system needs related to data administration, architecture, modeling.

• Designed, developed and implemented Database solution with MS SQL Server 2005.

• Developed and maintained customized SQL queries and reports on an expert level.

• Performance tuning of SQL Server.

Accruit LLC, Lakewood, Colorado 2006

Software Developer (MS SQL Server and ASP)

• Supported, maintained, and enhanced an existing web-based application for highly complex Internal Revenue Code business.

• Responsibilities included writing and executing custom T-SQL scripts and Stored Procedures to maintain large production Database, and enhanced an existing application utilizing VBScript, ASP, JavaScript, and HTML.

• Completed projects in VB.NET.

Signal Behavioral Health Network, Denver, Colorado 2001-2006

Software Engineer

Developed and maintained an ASP based web application using SQL Server 2000 and IIS to manage client data on-line for 200 users.

• Responsibilities included development of Signal’s information system and directed project development using MS Project.

• Developed and maintained stored procedures, triggers, views, diagrams, jobs, DTS, and user defined functions (scalar and table-valued).

• SQL Server Backup and Restoration.

• Performance tuning of SQL Server (use of indexes and queries optimization).

• Generated required customized SQL queries and reports to the state, internal, and external users.

• Provided technical assistance and training to the user community.

• Wrote on-line user and system documentation (using Wiki).

• Translated client side code from VBScript to JavaScript with resulting web data entry browser independence.

• Secured ASP pages against SQL Injection and Cross-Site scripting.

• Experience with HIPAA-compliant EDI 837 transactions files.

• Created corporate information systems policy, procedures, and priorities.

eCollege.com, Denver, Colorado 2000-2001

Software Engineer

Analyzed, designed, developed and maintained applications for the intranet system using HTML, DHTML, ASP, CSS, and VBScript. Designed and built databases using SQL Server 7 and MS Access.

• Significantly increased operation efficiency of managing contracts with clients and automated this process by developing web based applications for legal department.

• Generated required customized reports using Crystal Reports.

• Developed a contract tracking and notification system, which collected all new contract information and notified all involved departments and clients via e-mail (CDONTS used). This tool streamlined client contract process, ensured quality and shortened processing time by 40%.

Rhythms NetConnections, Inc., Englewood, Colorado 1999-2000

Application Support

• Designed and developed an intranet web site for application support group. The site contains a knowledge base and allows Help Desk personnel to submit automated requests via e-mail for specific support tasks.

These automated requests assure that the information provided is complete, validate information against a database and reduce resolution time for support personnel by up to 50%.

(MS Visual InterDev, HTML, DHTML, ASP, VBScript, JavaScript, and Oracle 7 used)

• Provided level 2 support on a 7 day, 24 hour basis for specific company applications.

• Maintained in-depth knowledge of application platforms, business functions and users, and required

corrective actions.

• Coordinated application bug fix activities between end users, Help Desk, development, and production technical services. Investigated and follow-up application software system failures (problem determination / problem source identification).

• Designed and implemented databases in MS Access.

InterTechnoSource, Inc., Denver, Colorado 1998–1999

Programmer / Web Developer

• Designed and developed web applications in Visual InterDev using HTML, ASP, VBScript, and JavaScript.

• Performed full life cycle Visual Basic programming.

• Designed business service and data access tiers using ADO 2.0 and SQL.

• Implemented stand-alone components in Visual Basic (ActiveX Controls, COM, and DLL).

• Designed and implemented databases in MS Access.

Preferred Mold & Engineering, Inc., Denver, Colorado 1993–1998

Design Engineer

• Designed and developed applications to accelerate engineering and calculations using Visual Basic.

• Performed conceptualization, design, detailing, and follow up of plastic parts and plastic injection molds using CAD.

EDUCATION

MS Office PerformancePoint Server 2007 Planning Series Training 2008

AMERITEACH, Denver, Colorado

Visual Basic .NET Programming 2005

COMMUNITY COLLEGE OF AURORA, Colorado

Web-Development (InterDev, ASP, HTML, VBScript, JavaScript) and

Visual Basic 6.0 Courses 1998-1999

ITS INSTITUTE, Denver, Colorado

Master of Science in Engineering, Minor in Computer Science 1979-1984

STATE TECHNOLOGICAL UNIVERSITY, Russia

Contact this candidate