Sql Server Professional Experience

Yuriy Popytayev

**** **** **** *** *** Long Island City, NY 11106 917-***-**** *****.*********@*****.***

A

ccomplished information systems professional in development, data, and project management. Proven ability to provide full lifecycle support from initial concept creation to deployment of finished project. Has successfully performed multiple Business Analyst responsibilities.Effective and creative working both as a team player and individually.

Key Skills

Business Intelligence Development/Management

Web Development

SQL

SQL Server Database Administration

Business Analysis

JD Edwards

SSIS/SSRS expertise

C#, VB.NET

MVC, JavaScript, JQuery

Crystal Reports

Project Management

Network Automation

Professional Experience

LOEWS CORPORATION. [Corporate Office] – NY, NY

Lead Business Intelligence and Application Developer, Systems Analyst 5/09 to Present

Lead developer of all in-house financial applications utilizing C#, ASP.NET, JavaScript, JQuery, SQL Server.

Developed hundreds of complex stored procedures and the screens with complicated business logic

Defined and enforced coding standards, and best practices

Developed multiple scripts handling and execution of SQL Server Agent jobs utilizing PowerShell

Educated developers on best practices

Created 50+ SSIS packages for in-house applications, Financial and Audit Reporting for Financial Applications

Standardized the process of maintaining SSIS packages in different environments through configuration files

Responsible for SOX reporting of financially material applications including JD Edwards and Hyperion

Responsible for JD Edwards Security Administration

Performed data analysis and translated business needs into functional specifications

Responsible for Security Administration of the main Financial Accounting System

Responsible for Audit reports development and delivery of the Company’s Scheduling System

Automated creating of IRS and Internal Audit reports for Chart of Accounts, Trial Balance and Journal Entries

Introduced SSRS as a robust reporting tool alternative and utilized it in creation of over 100 financial and audit reports

Automated Audit reporting for the Enterprise scheduling software and created multiple workflows

Has integrated the company Additions, Retirements and Accumulated Depreciation Fixed Assets reports into one report that would reconcile the numbers and indicate any exceptions

BULOVA CORPORATION. [Corporate Office, Woodside, NY

Programmer Analyst/Web Developer/DBA 5/99 – 4/09

Defined designs and built in-house SQL Server databases Performed DBA responsibilities for all SQL Server databases in Bulova Corporation. Designed and developed Product Specification system for modeling and creating watch specifications. Designed and developed company’s Intranet which has improved interoffice business communication and enabled remote access for the sales force across the country, abroad branches, and remote employees. Designed and developed Locator system that has enabled an easy tracking and billing for remote warehouse location where the shipment would be scanned and put to the location. Designed, developed and trained the company national workforce from all over the country for Sales

Professional Experience (continued)

Call log application that enabled the salespeople to effectively track their activity and receive the reports in the timely manner; developed the interface that would upload the numbers to the main Financial System. Designed and implemented electronic ordering through Excel template.

Education

POLYTECHNICAL UNIVERSITY – Saint-Petersburg, Russia

Bachelor of Thermodynamics of Physics faculty, 1995

BROOKLYN COLLEGE –Brooklyn, New York

Bachelor of Computer Science 2004

917-***-**** *****.*********@*****.***

Contact this candidate