SERGEY LIFTON

** ******** *****

Morganville NJ *7751

732-***-****

ac6bcs@r.postjobfree.com

Summary: 15+ years of experience in commercial data processing covering all stages of full project life cycle,

Requiring strong analytical and programming skills for a range of financial and business applications, extensive database administration experience and high performance and high availability database solutions in a large scale, high transaction environment.

Software: Informatica Power Center 10.1/9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), Microsoft SQL Server 6.0 - 2017, SSIS, SYBASE IQ, SYBASE 15.2, VISUAL STUDIO,

tSQLt Framework

Experience:

02/17 – Present ISC Advisors, New York NY

Senior consultant

Responsible for design, development and consulting of data warehouse for Mackenzie Investments. Data warehouse is containing positions data for number of teams inside the firm.

Design logical and physical database model

Generate list of SSIS packages to load source datasets into data warehouse

Create stored procedures, functions and views to manipulate data in the data warehouse

Develop the number of inspection procedures using tSQLt framework

Responsible for preparing and executing the release process

Provide operational and production support

Exceptional skills in Agile and Test Driven Development

07/05 – 02/17 ITG New York, NY

Principal Informatica Developer

Responsible for building and supporting Informatica preprocessors for TCA (Transaction Cost Analysis) System. TCA helps ITG clients to assess desk, broker, trader performances and implicit costs under various market conditions, and reduce trading costs and boost fund performance.

Managed team of 5 Informatica developers to build the custom preprocessors to load client’s data into TCA.

Lead new technology research and proof of concept projects. Involved in functional discussion meetings to translate business into technical design and work with developers for new models

Coordinated business, QA and technical teams from US, London and Asia, prioritized the tasks based on business requests and recourses

Executed Global Production Support and Development

Designed and developed linker for Charles River Order Management System, Line Data Order Management System, and TCA XIP Order Management System using Informatica, PL/SQL and Unix Scripts

Created data reconciliation engine with Informatica to improve by cleaning and monitoring data quality

Developed ETL design, including process flow, data flow, source -to-target mappings, physical database designs, data models, and reusable Unified data model process to create releases, decisions, time shifting and security validation

Involved in Informatica releases, configuration and deployment of a highly distributed enterprise scale application. Implemented naming and coding standards, deployment procedures around Informatica repository

Experienced in Informatica Administration, backup and restore Informatica repository, manage and administer system performance including on-going optimization and tuning of Informatica environment

In charge of a technical team in creating logical and physical data models with part dimensional and part relational database design principles

Lead the Informatica upgrade from version 8.6.1 to 9.5.1

Created UNIX shell scripts to schedule and run the workflows, Modify and Archive target files after ran

08/03 - 06/05 Vital Mortgages, Princeton, NJ

Database Developer, Programmer/Analyst

Designer and developer of Mortgage Company web site, which provide information about company, services and mortgage programs. Written in ASP.net, C++ and MSSQL Server 2000. Participated in cross functional projects to develop new and enhance existing technology solutions based on Visual Basic, ASP, SQL Server, and VBScript Technologies.

Performed logical and physical database design. Implemented data models and database designs, data access and table maintenance codes

Developed Entity Relationship model and prepared data dictionary

Responsible for monitoring database performance issues, database capacity issues

Wrote stored procedures, queries, views and triggers to provide optimization in web project

Provided technical analysis, review application design and recommend optimal database solution in meeting business requirement

Created procedures for disaster recovery, disk management, and performance tuning, capacity planning and space management

Performed new code enhancements for new and existing systems

Designed and created web pages interfaces

Maintained daily scheduled job for error order monitoring

Performed data collections through the use of Excel spreadsheets. Wrote macros and formulas for data manipulations

04/01-06/03 Beacon Management Corporation, Princeton, NJ

Programmer/Analyst, Database Administrator

Main developer and designer of Beacon Investment Tracking System (“BITS”). This tracks investments income, account balances, and investment performance for firm clients. Written in VB 6.0, C++, MSSQL Server 2000, FORTRAN and Crystal Reports 8.0.

Designed and created database structure for BITS

Responsible for performance tuning, capacity planning, space management, table creation, disaster recovery, disk management and product support

Resolved database performance issues, database capacity issues, replication, and other distributed data issues

Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the company database

Designed full backup strategy and procedures

Wrote a number of the DTS packages to perform the data consolidation. The packages were scheduled by SQL Agent to run periodically in order to import data from Microsoft Excel spreadsheets and Microsoft Access 2000 database into SQL Server

Wrote procedures to download prices from CQG using price data and account information from BITS

Modified existing software to generate daily buy and sell orders for each account

Used client feedback to determine user requirement and troubleshoot problems regarding process automation and improvements to existing reporting system

Designed reports for calculations and delivering account performance data

Created procedures to download brokerage statements via FTP and automatically reconcile with BITS data

05/99 –04/01 SS&C Technologies, New York, NY

Programmer/Analyst

Key team member involved in maintenance of Antares System, a comprehensive trading, order management and real time reporting system for the multi-currency of equities, fixed-income instruments, futures, options, stocks, bonds, currency forward and financing transactions including financing agreements and buy/sell agreements. System written in VB 6.0, C++, MS SQL Server 7.0 and SYBASE 11.5.

Responsible for technical support of Antares System

Developed procedural and functional add-ons to the system that provided users with browse and on-line update capabilities and navigation through result sets of data using Microsoft RDO Object Library

Improved security through database structural modifications

Analyzed stored procedures, queries, views and triggers to provide scalability in Antares system

Wrote procedures for sending email and fax from Antares System using ActiveX controls

Created custom reports using Formula1 as reporting tool

01/97-05/99 Market Data Corporation, Westchester, NY

Programmer/Analyst

Database maintenance for Medical Internet services including:

Conversation of data from MS Access, Text and binary formats to SQL Servers

Creation of processes to format data into HTML

Generated programs to add new anchors

Created reporting system using Crystal Reports 4.6 and 6.0

Designed and conducted Help Desk System for supporting previously released software system and documenting errors for further processing. The system was written in VB 5.0 and MS SQL server 6.5 utilizing Sheridan third party controls and Crystal Reports 4.6.

Designed and created database to use as a server in Windows NT network

Developed stored procedures to extract data from database for populating spreadsheets

Built GUI, backend and security modules for entire system

Created a lookup portion to search on client and software information: by date, by status and by department number of most recently involved programmer

Participated in development and maintenance of Purchase/Order System-Inventory System to document purchases and orders as well as full inventory of equipment for the Company. The system was implemented in VB 4.0 and SQL Server 6.0.

Designed data entry screen spreadsheets and reports displaying orders and inventory numbers

Developed and implemented a number of Data Grid forms using Sheridan DB Grids

Wrote numerous stored procedures in MS SQL Server using joins and temporary tables insert and modify data in database across several tables

Created a number of reports using Crystal Report 4.0

08/95-01/97 CITIBANK, New York, NY

Programmer/Analyst

Involved in developing and documenting Charge Allocation System (CAS), used for allocation and monitoring of Actual Expenses and Projected Budgets at departments levels for managements staff. The main goal of the system was to guide department manager in process of allocation their budget and offsetting it with charges for provided services. Client/server environment implementation used SQL Server 6.0 and Visual Basic 4.0. The (CAS) system utilized Remote OLE Automation to provide Windows 3.1 as well as Windows NT and Windows 95 users with access to remote Server application.

Developed a number of procedures and functions on server side to extend Browse and on-Line Update capabilities using Microsoft RDO Object Library

Created a number of reports using Crystal Report 4.0

Designed new partition of the system, which called Crystal Report Object from application by initializing and activating it in program’s code

Conducted and tested numerous stored procedures, triggers and views

07/94-08/95 NYU Medical Center, New York, NY

Programmer/Analyst

Involved in developing and documenting Customer Information System used by Customer Service Department to register, store and process Customer Information and requested by the phone. The system was implemented in PC/Mainframe environment utilizing VB 3.0 as a development language on PC site. The entries were made to Mainframe CICS program that screen was mapped using QuickApp IRMA Control.

Education:

1989-1994 BS Degree in Mathematics

Technical Academy, Moscow, Russia

Contact this candidate