Design Sql Server

SERGEY DRUYAN

**** * **** **, #*** • Brooklyn, NY 11229 • 516-***-**** • *******@*****.***

OBJECTIVE

To obtain a full-time position in a field of computer science where my knowledge and skills can be fully utilized, at the same time providing excellent service for the employer.

STRENGTH

Strong experience in design, development, maintenance and support of financial and business applications.

Proficient in full project life cycle approach and structured methodology.

Well versed in development of high performance/high availability architectures.

RELEVANT SKILLS

Languages: C#, ASP.NET, JavaScript, UNIX Shell, PowerBuilder 9/11, HTML, JQuery, JSON, REST, CSS, Bootstrap

Frameworks: Visual Studio 2010/2013, PFC

Technologies: .NET, Dynamics CRM 2011/2013, XML, SSRS, Scribe

Application Servers: WebLogic, Tomcat

Platforms: Sun’s Solaris, Windows NT

Database Management Systems: Sybase 11/12/15, SQL Server2008, DB2/UDB, Oracle 8, Access DB

Communication Tools: Telnet, FTP, Reuters Messaging, Skype for Business

Courses: C#, ASP.NET, Sybase, XML, TCP/IP, Advanced SQL Queries, PowerBuilder 9.

PROFESSIONAL EXPERIENCE

6/2018 - Present REINFOREST ALLIANCE, 233 Broadway, New York, NY 10279

Data integration project, including restructuring database and reporting module.

Redesign, implementation and enhancement of Tea Web Storage project. It is based on Dynamics CRM 365 On-line.

Technologies: Microsoft SQL Server, Dynamics CRM 365, Scribe.

4/2011 – 11/2017 US FUND FOR UNICEF, 125 Maiden Lane, New York, NY

Design, development, deployment and support of the Grant Management (GM) System – the back office accounting and donor data management system. The responsibilities are: creating CRM entities, implementing business rules, creating CRM workflows/processes, creating Scribe jobs and developing custom intermediate database. Integrated SharePoint into the system.

Technologies: Microsoft Dynamics CRM 2013 (plugins, workflows, Java Script), Microsoft SQL Server, Scribe (data migration), eConnect (transaction integration between Dynamics GP and Dynamics CRM)

Design and development of the Pool of Funds and Voucher modules of the GM system – the gift and grant generation and processing tools.

Technologies: Microsoft SQL Server, Scribe (data migration), ASP.NET

Design, development, deployment and support of the Budget Expenses and Revenue System – revenue and expenses booking and management system for various departments.

Technologies: Microsoft Dynamics CRM 2011/2013. JavaScript,, CSS, Bootstrap, ASP. NET, SQL Server 2008.

Design and development of the Major Gifts and Special Events modules of the Revenue system – the revenue calculations and projections based on fund designation.

Technologies: Microsoft SQL Server, ASP.NET, JavaScript, CSS, Bootstrap

Development and support of the Finance Department reporting system.

Technologies: SQL Server Reporting System (SSRS)

Development and support of the Credit Card Masking Application – valid credit card numbers identification and masking application for Compliance Department.

Technologies: ASP.NET

Design, development and support of the IT Asset Management – equipment tracking system.

Integrated SharePoint into the system

Technologies: Cloud based Dynamics 365 CRM (online development), JQuery, JSON, REST, SQL Server 2008

Participation in Dynamics CRM 2011 to Dynamics CRM 2013 conversion project. The responsibilities are: creating solutions and administration.

3/2000 – 12/2010 INVESCO, Inc., New York, NY

Participated in design and restructuring Investment and Asset Management (IMS/AMS) systems into .NET platform. The responsibilities are: gathering business requirements, designing and development GUI, implementing business logic in the database objects and creating data feeds.

Technologies: C#, ASP.NET, JavaScript, Sybase 15.

Design, development and support of the IMS/AMS system – the bank loan transaction management system allowing portfolio managers and account officers to enter and settle transactions, rollover contracts, keep track of facility prices, maintain accounts / issuers / issues information and generate projection and compliance reports as Accrual, Cash Projection, Gain/Loss, Interest Due Date.

Technologies: PowerBuilder 9.0, PFC, Sybase 11

Design and implementation of the algorithm for prorating pending trades against existing lots executed before loading trades from QTEC to IMS.

Technologies: Sybase 11

Design and development of the compliance module of the Emerging Market system. The module evaluates holding portfolios against security information from MOODY, S&P and Fitch to provide bond characteristics for Fixed Income analysts to make business decisions.

Technologies: Access DB

Design enhancements of a File Management System using OLE Automation. The system allows users to store client documentation in the database repository. The documents are loaded from files of different formats and stored as Binary Large Objects. The user authorization mechanism is implemented to control access rights. The system processes Excel documents and faxes them to the brokers. Based on the predefined macros Excel documents are reformatted at a run time using OLE- DB. Windows API was used for Excel format manipulation.

Technologies: PowerBuilder 9

JP MORGAN CHASE, Hicksville, NY, January 1996-March 2000

Migrated all PowerBuilder based applications from PB 5 to PB 6.5.

Participated in design, development and implementation of the TAGIMS (Tracking & Analysis Information Management) system that allowed users identifying, marking and keeping track of selected account subsets in the data warehouse for the mail response rates, performance, behavior and profitability analysis. I developed a GUI for the users to identify subset of accounts that satisfied entered criteria.

Technologies: JavaScript, HTML, Java Servlets Visual Age 2.0, WebSphere, JDK 1.1.6B2/UDB.

Participated in design, development and implementation of the Security System that was a core authorization and authentication system across a number of applications.

Technologies: PowerBuilder 5/PFC, Oracle 7.2, DB2/UDB, Business Object.

Participated in design, development and implementation of the Probe System for users to create and run dynamic queries against the data warehouse. The system combined, saved and modified user-defined and pre-defined queries for research and forecasting purposes.

Technologies: PowerBuilder 5/6.5, PFC, DB2/UDB

EDUCATION

-Belorussian Polytechnic Academy, Minsk, Belarus

BS in Electrical Engineering/Computer Science.

-Cope Institute, New York.

Contact this candidate