Igor Spektor

Summary

IT PROFESSIONAL

 System Development, Administration, & Maintenance  System Improvements  Functional & Business Requirement Gathering  User Training  Testing  Quality Assurance  Customer Service

Creative, focused IT professional. Possess exceptional communication skills. Offer a progressive track record of success developing and administering systems critical to high operating efficiencies. Resourceful and inventive leader adept at building superior relationships with clients, implementing superior process and procedures, and troubleshooting and resolving issues quickly and efficiently. Able to consistently deliver projects on time and to high quality standards. Empathetic customer service provider and troubleshooter.

CORE TECHNICAL COMPETENCIES

 Data & Systems Analysis  Business Analysis  Database Modeling  Data Migration SQL Server 6.5/7/2000/2005

 SQL Server Reporting Services (SSRS) Oracle 11i  ERWin  TOAD 7.6  VBA  VBScript / JavaScript

 ASP/ASP.NET  HTML/DHTML  Crystal Reports  Oracle Discoverer 9.0  Access 2/95/97/2000/XP/2003/2007 Windows 9x/NT/2000/XP/Vista

Work History

Work History

SYSTEM ANALYST III

TYCO HEALTHCARE - MALLINCKRODT

Responsibilities:

Development, , implementation, and maintenance of a global web based information system utilizing a 3-tier architecture. The application was used to manage registrations of Tyco-Mallinckrodt drugs and medical devices around the world, direct clinical studies conducted by Mallinckrodt and relevant FDA registrations.

Tools: SQL Server 7/2000, Visual InterDev 6, HTML, DHTML, ASP, VBScript, JavaScript, Crystal Reports 8, Access 97/2000, VBA, Erwin 3.5 in Windows 95/2000 environment.

Deliverables:

- Developed functional and technical requirements.

- Conducted facilitation sessions with business owners and performed business process and data analysis.

- Developed logical and physical database models.

- Migrated data from legacy Access applications to centralized SQL Server databases.

- Designed and developed web based Graphical User Interfaces (GUIs) for web based applications.

- Created system documentation, managed quality testing, facilitated user training and provided application support.

IT CONSULTANT

METRO Saint Louis (BI-STATE DEVELOPMENT AGENCY)

Responsibilities: Developing functional and technical requirements for custom Oracle reports. Documenting and analyzing legacy reports, developing custom Oracle reports using Oracle Discoverer.

Tools: Oracle 11i, Toad 7.6, Discoverer 9.0, Oracle Forms 9.04 in Windows 2000 environment.

Deliverables:

- Analyzed and documented legacy mainframe reports.

- Delivered technical specifications for over 100 custom Oracle, Oracle Discoverer, and FSG reports.

- Designed SQL queries for data exchange between MS Access and Oracle Financial (Oracle Migration Workbench).

- Developed custom Oracle Discoverer financial reports.

- Designed change management procedures for existing reports.

Jan 2009 - Present

IT CONSULTANT

Kelly IT

Clients:

Sigma – Aldrich Corporation

US Bank CorporationSaint Louis, Missouri

Responsibilities: Development of an Audit Management Tool for the Trade Compliance Department at Sigma-Aldrich Corp.

Implementing 3rd party ProLink Finance application (Lenders/Projects tracking) at US Bank

Deliverables:

-System generated comparison analysis between customs broker data and US Border Control.

-Identification of high risk import transactions. Managing audits and corrective actions.

-Writing T-SQL code and developing custom reports using SQL Server Reporting Services (SSRS).

Oct 2006 - Present

SENIOR OPERATIONS ANALYST

Bank of America

Responsibilities:

Development and implementation of a tracking application to manage multiple stages of the debt recovery process for the Financial Liability Risk Management Services department. Provided technical and customer support of legacy databases. Performed data conversions between legacy databases and newly developed applications.

Tools:

SQL Server, Access 97/2000/2003, MS Project 2003, Visio, Visual Source Safe, BASS, DocumentDirect, Toad in Windows XP environment.

Deliverables:

- Created multiple modules, GUI forms, financial reports, SQL Server tables, views, stored procedures, functions. Designed DTS packages for Mainframe-SQL Server data exchange.

- Conducted facilitation sessions with business owners.

- Generated DDL and DCL scripts for production server.

- Analyzed data integrity from multiple streaming data sources (mainframe, client feeds, ODBC sources) into validated internal SQL Server databases.

- Upgraded and maintained legacy systems.

Jan 2004 - Present

IT CONSULTANT

EXCEL HOME CARE

Responsibilities:Development, implementation, and maintenance of a SQL-Server based application for managing comprehensive business information in one location. This application compiled schedules, delivered business data through custom forms and reports.

Tools: SQL Server 2000, Access XP, VBA in Windows XP environment.

Deliverables:

- Performed business and data analysis and delivered functional and technical requirements for the RDBMS.

- Developed tables, stored procedures, functions, views, GUI forms, reports.

- Conducted user training, provided support and performed systems administration and maintenance.

Apr 2007 - Dec 2008

IT CONSULTANT

CITY OF SAINT LOUIS BOARD OF PUBLIC SERVICES

Responsibilities:

Development and implementation of an application designed to manage multiple phases of construction projects, contracts, budgets, etc. Designed a financial module to track fund, cost-center, accounts, purchase orders, payments, and vouchers associated with projects and contracts.  Developed a SQL Server database for tracking permits issued by the Streets Department.

Tools: SQL Server 2000/2005, MS Access, ASP.NET in Windows XP environment.

Deliverables:

- Developed functional and technical requirements. Conducted facilitation sessions with business owners.

- Performed business process and data analysis. Developed logical and physical database models.

- Created SQL Server tables, views, stored procedures, and custom SQL functions.

- Performed data mapping and designed DTS packages to transfer data from legacy Access databases to SQL Server.

- Designed and developed front-end applications, financial reports, and online help modules.

- Conducted user training and provided daily support and application administration functions.

Nov 2006 - Mar 2007

DATABASE ADMINISTRATOR

WASHINGTON UNIVERSITY IN SAINT LOUIS

Tools: SQL Server 2000/2005, Access 2003, WebFocus, Hyperion in Windows XP environment.

Responsibilities: Transfer and convert data from source systems into SQL database structures to support financial reporting, budgeting and planning, grants analysis, faculty productivity reporting, tuition analysis and compensation analysis for the School of Engineering and Applied Science.

Deliverables:

- Developed and implemented Stored Procedures, SQL Functions and DTS Packages to transfer and synchronize data between mainframe and SQL Server databases.

- Designed an application to automate the annual Budget Planning process

Education

Education
Sep 1979 - Jun 1984

BS in Civil Engineering

Voronezh State University of Architecture and Civil Engineering

Skills

Skills

Crystal Reports

ASP • ASP.NET

ERWin

Database Modeling

Oracle 11i

Oracle Discoverer

TOAD

MS Access/VBA

Data Migration/Transformation

SQL Server Reporting Services

SQL Server 2000/2005

Business Analysis

Data & Systems Analysis