SERGEY LIFTON
Morganville NJ *7751
********@*****.***
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