Sql Server Data
Resume:
OLGA BLINTSOVSKAYA
Brooklyn, NY *****
SQL Developer with in-depth knowledge of SQL Server Database and Software Development Life Cycle and exceptional analyzing, problem solving and troubleshooting skills. Expert level in designing and developing of SQL Server Reporting Services applications, experience in generating on-demand and scheduled reports for business analysis or management decision using Database Engine and SSIS. 20 years of development and production support of high volume financial data processing platforms including database design for combined relational database implementations and non - relational FAME database. Agile team player with excellent communication skills and ability to work independently.
TECHNICAL SKILLS
OS: Windows, Unix
Tools: SQL Server 2000, 2005, 2008,2012, Integration Services (SSIS) and SQL Server Reporting Services (SSRS) packages.
Languages: MS SQL Server, Oracle, Sybase, VB, VBA, MS Access, Java
Scripting Languages: Perl, Unix Shell Scripting, Python
PROFESSIONAL EXPERIENCE
FIS Global (merged with Sungard) 1998 - 2016
Worked in different Sungard divisions on development and support of financial software applications
CostBasis project 2012 – 2016
Involved in data modeling of systems, tuning of the database for performance, creating scheduled SSIS jobs.
Managed the design, testing and maintenance of advance SQL queries, stored procedures, triggers.
Created tables, performed DDL changes
Worked with ETL (SSIS, SSRS), data integration, and data quality.
Involved in all aspects of the data modeling life cycle (business/conceptual/logical/physical).
Supported legacy CostBasis application; developed new modules and changed existing modules to
comply with current IRS regulations
Designed and developed custom reports using SSRS
Worked with business analysts, client managers and business users to understand user/functional requirements and translated them into technical specifications for designated components
Wrote installation instructions and user manuals for file translation modules
Technology: MS SQL server, SSIS,SSRS, BCP, Perl
Cliq project 2010 – 2012
Back office clearing software application
Participated in design sessions of overall system architecture, including Oracle Db tables and full back-end functionality
Created detailed technical specification for designated components
Implemented several core modules
Technology: Java 1.6, Oracle, IBATIS, Drools Rule Engine, Quartz scheduler
ReferencePoint (rP) 2006 – 2010
Enterprise data processing, cleansing and distribution system
Participated in high level design sessions of overall system architecture
Created detailed technical specification for some of the main components: job scheduling, data feed files' processing, data transfers to FAME or to mirror rP system
Implemented and documented major components
Provided programming support for most of the system components and participated in production integration of the entire system
Created new data products, such as data processing for HBOS, IBES, IDC and Bloomberg feeds
Converted and released into production Reuters DataScope data feed processing from obsolete
DataFactory platform to rP
Was responsible for new data development and supported existing systems and data products; trained and consulted overseas data development team
Technology: Java 1.5, Perl, FAME database engine and FAME TimeIQ, MySQL, Hibernate
DDTK (data development toolkit) 1998 – 2005
Generic Data Loader (GDL) - Metadata driven ETL tool for financial and energy data processing. GDL introduced a single data development platform capable of updating FAME and relational databases
Participated in design, implementation, testing and production support of GDL, IBES Consensus, IBES History, S&P GICS
Converted existing data products - Russell, Oindex, IDC
Supported and optimized data products that were developed by Ann-Arbor, MI and Pune, India teams
Technology: Java, VB, Perl, Sybase, FAME database engine and FAME TimeIQ, FAME 4GL, XML
EDUCATION
St. Petersburg Polytechnical Institute, St. Petersburg, Russia
MS in Economics and Computer Science
REFERENCES Available upon request
Contact this candidate