Candidates About

Ilya Ioffe

Summary:

• 15 years’ experience as SQL Developer and Administrator.
• Fifteen years of data processing experience in a SQL Server and Oracle environments as a Database Developer/Administrator
• Responsible for full lifecycle development of large and very large databases (over one terabyte), from initial requirement gathering to design, coding, testing, upgrading, documentation and implementation.
• Vast expertise in designing and building ETL processes built on Microsoft SQL Server, configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Participated in the development and support of ivolatility.com website - one of the world's leading financial and analytical portals.
• Developed Logical and Physical data model using ERwin, MS Visio and mapped the data into database objects.
• Proficient in installing, configuring, managing, monitoring and troubleshooting SQL Server Services
• Excellent skills in database structure designing, writing stored procedures, query optimization, creation of jobs and replication services, writing SSIS packages, generating SSRS reports, creating OLAP cubes using SSAS, managing Big Data environment.
• My technical expertise includes cross-platform proficiency (Windows, Unix, Linux), fluency in programming languages (including T-SQL, PL/SQL, HQL (Hive), Visual Basic, Python, Shell, С/С++) and advanced knowledge of developer applications, tools, methodologies and best practices (including OOD, client/server architecture and self-test automation).
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expertise in generating sub reports, cross-tab, conditional, drill down reports, drill through reports and parameterized reports using MS SQL Server Reporting Services (SSRS).
• Understand Database Backup, Recovery and highly experienced in investigating and applying necessary SQL Server database Service packs, hot fixes and Security Patches.

Technical Skills:

• Database designing, development and administration
• Experience with the following software:
  • Windows OS, MS SQL 2000, 2005, 2008, 2012 (T-SQL, DTS, Profiler), MS Visual Studio 2008/2013, MS Access, PowerShell.
  • Linux OS, Oracle 8, 10, 11, Hadoop environment, Hive databases development and administration.
• Proficiency in the following programming languages:
  • T-SQL, PL/SQL, HQL (Hive), VB.NET, C#, Visual Basic, Python, Shell, C/C++, VB Script

Work experience:

QualCare Inc, Piscataway, NJ.                                                                          Jan 2016 – Present

SQL Developer

QualCare Inc. is one of the region's leading providers of health care coverage. It covers over 100 acute, special and rehabilitation hospitals, as well as over 31000 physicians and other ancillary providers across New Jersey, New York and Pennsylvania.

Responsibilities:

• Designing and developing data storage for health care data.
• Creating data-related documentation: data files descriptions, table relationship descriptions and schemes, etc.
• Query optimization, writing stored procedures, writing SSIS packages, supporting and creating jobs and replication services.
• Designing database structure, writing database documentation, supporting remote data supply systems.
• Designed ETL process using SQL Server 2014 SSIS Packages which the data sources include Flat files, Access, and Excel.
• Writing VB.NET and C# scripts in SSIS packages for dynamically accessing variables, logging and producing custom messages. 

EGAR Technology, New York, NY                                                                  Aug 2002 - Jan 2016

SQL Developer

EGAR Technology is an international company specializing in software development, system integration and delivery of IT services to businesses in various sectors of specialization, primarily to financial market participants.

Ivolatility.com is the most complete and accurate source of option prices and implied volatilities available, used by the leading firms all over world. 

Responsibilities:

• Designing, developing, and administering of large databases for one of the leading option trading portals (ivolatility.com)
• Creating data-related documentation: data files descriptions, table relationship descriptions and schemes, etc.
• Query optimization, writing stored procedures, supporting and creating jobs and replication services, writing SSIS packages.
• Designing database structure, writing database documentation, supporting remote data supply systems.
• Designed ETL process using SQL Server 2012 and Oracle SSIS Packages which the data sources include Flat files, Access, and Excel.
• Designing, developing, administering of hadoop big data system, integrating it with MS SQL.
• Writing Hadoop Mapreduce applications on Python
• Consulting and support of web and database clients.
• Installing and configuring MS SQL Server 2005, 2008, 2012.
• Maintaining MS SQL Server 2000, 2005, 2008, 2012, 2014 including security, configuration and installing service packs upgrades.
• Upgrading a significant number of small, big and very big databases from MS SQL Server 2000 to more late versions of MS SQL Server
• Upgrading DTS packages to SSIS packages manually and using DTS xChange tool, from MS SQL 2000 to 2005 and 2008
• Using Powershell for MS SQL Server administering.
• Generating different types of reports using SSRS.
• Creating OLAP cubes using SSAS.
• Planning and implementing migration of SQL Server databases from one server to another.
• Creating and maintaining replication services between different databases and servers.
• Writing complex stored procedures, functions, views, database triggers, assemblies, sequences and other programmability objects.
• Optimizing complex T-SQL queries, building and maintaining indexes (updating statistics, defragmentation).
• Solving database and Restfull web services API performance problems, using profiler, logging and other performance tools.
• Extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server
• Designing and building ETL processes utilizing SSIS and DTS packages, including FTP data from remote location, transforming it, and providing it to bulk data clients.
• Designing and support of MS Access views and queries.
• Performing data integrity checks by scheduling jobs and stored procedures.
• Migrating large databases between different DBMS (relational and non-relational, like Hadoop).
• Configuring and maintaining SQL Server Log shipping between different servers.
• Performing consulting and support of web and database clients.

Haifa University, Haifa, Israel                                                                                        1996 - 2002

Instructor of Statistics and Sociology; Teaching Assistant

• Teaching courses in statistics and sociology.
• Technical and logical support of SAS and SPSS systems, and Oracle 8i database.

Additional Information:

• Military Service with the Israeli Defense Force (1996-2001)
• Fluent in Russian and Hebrew.

Education:

• B.Sc. in Electrical Engineering, Department of Automation and Telemechanics, Moscow Institute of Transport Engineers (MIIT), 1983 – 1988
• B.A. in Computer Science, M.A. in Sociology, Haifa University, Department of Social Sciences, 1992 – 1998
• School for Oracle Database Programmer, Ashrot College of Haifa, 2000 – 2001