Sql Server Data

Vadim Saakov * Cypress La, Marlboro, NJ *****

Tel: 732-***-**** E-Mail:********@*****.***

HARDWARE: PC Client/ Server, DEC ALPHA, VAX, UNIX, MICRO VAX, PDP-11, GOULD

SOFTWARE:VBA, MS Office: (MS Access, Excel, MS Word, Macros), MS SQLServer 2003, SQL, HTML,

XML, FTP, SMTP,NDM / Direct Connect,MQ, DCL, FORTRAN-77, Firefox macros

EXPERIENCE:

October 2013–November 13 2013 Programmer (consultant)

Kelly Services.

client:

Standard and Poor’s Capital IQ –Global Market Intelligence 55 Water St, NY

Responsible for requirements, design, development, and implementation of an automated

process of importing financial data from multiple sources into MS Word based reports for S&P

Capital Global Market Intelligence clients - a daily Consensus Earnings report and weekly

Investor Relation Report. The workflow has been based on existing business flow of daily

production of Consensus Earnings Report of S & P 500 constituents using multiple steps of

manual copy and paste involving many man-hours.

• Reviewed original requirements, met with CAP IQ representative, reviewed

limitation of the existing CAP IQ basic version of reports and created linking rules

between MS Excel based fields and MS Word based reports

• Designed and developed set of VBA Macros automation modules to complete

subsequent steps of loading Cap IQ financial data into multiple Ms Excel spreadsheets

and then into final staging summary spreadsheet used by internal business analysts and

then into a final version of reports in MS Word for outside clients

• Developed design of the MS Access based database representing S&P500 Industries, its

subcategories (Consumer Discretionary, Consumer Staples, Energy, Financials,

Healthcare, Industries, Information Technology, Materials, Telecommunication

Services, Utilities)

2005-September 2013Programmer/ Business Analyst

(Online Travel Company – VacationTravelHolidays.com)

Responsible for Analysis, Design, Implementation and Support of E-commerce workflow for online travel

company as well as various reporting functionality as well as analyses of existing data and email

marketing.The modifiedcomputerized automated process replaced the multiple business steps of

obtaining data from different sources in different formats, validating numbers and loading data

intoMSAccess database.

• Gathered business requirements, reviewed the previous software developed based on

MS Access forms with VBA, reports, and queries.

• Designed, developed and implemented unified algorithm to load data from various Travel

Companies such as Apple and Funjet. Data inputs included export/import data via API, various

XML based data files, automated data extract via sending key strokes, screen scraping routines

and so forth.

• UsedVBA code to develop routines to parse hundreds of flat data input files per day,

validate contents and input data to MS Access database. Generated various reports for

monitoring data upload results.

• Using VBA code and MSAccess SQL queries to developan optimization algorithm for

finding the best price based on the variety of parameters such as departure and destination cities,

region, type and level of a resort, number of nights, airfare, and individuals resorts’ promotions,

and many others. Created a process to automatically generate HTML pagesusing predefined

templates,output of optimization program and SQL processing. Setup the upload process to copy

created HTML pages into the public website.The upload process was designed to utilize one

dynamic procedure running on demand or automatically based on the schedule,using VBA, MS

Access, MS Excel,HTML, and XML.

• Created queries and reports to analyze the customers’ data based on the various criteria

for business management. Developed email notification procedures based on rules specified for

various advertising campaigns.

• Currently is working on the project to replace MS Access database processing with MS

SQL Server database server. The project includes redesign MS Access database by replacing

tables, converting all query definitions and views into MS SQL Server stored procedures and

views as well as using triggers, compound indexes and database validations and other options

available in MS SQL Server. The new software will also utilize ADO access to MS Access forms,

new reporting capabilities based on MS SQL Server, and new mass mail options.

1987-2005 Technical Officer / Programmer

(Manufacturers Hanover Trust, Chemical bank, Chase bank, JP Morgan

Chase)

• Worked on all cycles of SDLC in the development, maintenance and support of Broker Dealer

Automation System (BDAS). BDASwas a full trading system that performed clearance of Mortgage

Backed securities via Federal Reserve Bank, provides loan collateralization for different types of financing

for government securities and other fixed income products. It supported various intra-day queries and

updates of positions, loans & transactions for an individual dealer or a whole group, on interactive and

batch input (customer links) and provided hundreds of different end-of-day reports. This system also

supported funds transfer payments.

• Provided Production Support to the 100 users that included assisting customers with production

issues both connectivity and data, answering questions regarding security data elements in numerous

record layouts, coming in thru different setups depending on client, side using FTP, Reflection - FTP

Suite, NDM, MQ Series, LU6.2, Fortran-77, DCL.

• Responsible for the test system and customer testingsupport, copy production data to test and act

as counterparty by entering data via online functions. Performed Network Administrator role for the test

system entitlements.

• Designed through implementation of various BDAS applications, mostly in securities trading as

well as money wires & pair-offs both interactive and overnight batch processing. Provided ongoing

maintenance and enhancement for the automatic reception and posting of newly issued securities from

the FRB, and automated posting of trades form major clients (i.e. Merrill Lynch, First Boston, etc.).

• Performed an independent user assisted project of automation of coupon payments for the

mortgage backed securities. Automation of funds disbursement for dividends, P & I, and coupons.

1985-1987 Software Engineer

(Advanced Systems Development, Inc.)

• Participated in the design through implementation of Radar Simulation System / EW.Radar

Simulation System was a real-time system used in a B1 simulator and aircraft. On-line product contains

many subsystems developed and customized in several hardware environments including VAX, Micro

VAX, Gould, & IBM PC. The application was developed in FORTRAN 77 in a VAX, Micro VAX, and

Gould environment. It was originally developed for Loral Electronics Systems and later major

customization efforts resulted in similar systems for clients including Boeing Military Aircraft Corporation,

U.S Air Force, and allies.

• Responsibilities also included development of an on-line debugging facility/new language

interpreter, development of real-time graphics subsystems and upgrades to existing systems, training of

client technical staff on the use of the system.

EDUCATION: Brooklyn College B.S., Computer & Information Science (1985)

LEGAL STATUS: Married, U.S. Citizen.

SPECIAL SKILL: Bilingual - English / Russian

HOBBIES: Reading, Exercise, Piano playing, Skiing, Small craft Sailing

REFERENCES: Furnished Upon Request

Contact this candidate