883 Sparta ct
Vernon Hills, IL 60061
(847)837-9960
[Send email using form at bottom]

OBJECTIVE
		
IT professional seeking a telecommuting position in a Client/Server environment
to utilize and enhance skills and proficiencies while providing timely and
efficient support in business management.

PROFILE

Over 10 years of Client/Server/Internet/Intranet software and database
development.
Over 7 years of Database Design and Architecture for database and data
warehouse.
Ability to anticipate problems and needs before they arise.
Strong work ethic: flexible, analytical and organized.
Committed to high quality work and attentive to details.
Represent company with dignity and professionalism.

SKILLS

•	Programming languages: Visual Basic 5.0/6.0/.NET, ASP, ASP.NET, C, SQL, T-SQL,
PL/SQL, XML/XSLT, HTML, DHTML, JavaScript, VBScript, MDX.
•	Software:  ActiveX, COM/DCOM, TCP/IP, RDS, RDO, ADO, DAO, OLAP, ODBC, IIS,
MTS, VSS, Microsoft FrontPage, Microsoft Excel, Microsoft Project, Microsoft
Visual Studio 6.0/2005, Microsoft Commerce Server, Crystal Reports 8.5/10, Visual
Interdev, Microsoft Visio, Docent, FCP, BI Designer, Developer 2000,
InstallShield, Wise, BizTalk Server 2004, SQL Reporting Services, Integration
Services, Analysis Services, SQL Diagnostic Manager, RedGate, LiteSpeed for SQL
Server
•	Databases: MS SQL Server 7.0/2000/2005, Oracle 8i, 9i, Access 8.0/2000, Lotus
Notes 4.5 Approach.
•	Operating systems: Windows XP, Windows 2000, Windows NT, Window Server 2003,
Windows 95, and UNIX.
•	Home Office Includes: Windows XP, Fax, Printer, High-Speed Internet, and
Telephone.

WORK HISTORY

Database Administrator						
ASAP Software/DELL 								    03/2007 - present
eSmart Project
•	Responsible for supporting the company’s SQL Server Databases comprised of
terabytes of data including troubleshooting, performance tuning, security
planning, monitoring critical events, impact analysis, database migrations,
capacity, availability and scalability planning and implementation
•	Document the data architecture and environment; ensure the success of
enterprise-level application rollouts.
•	Maintain the data integrity of a highly complex, clustered and replicated SQL
Server environment.
•	Monitor the production databases; participate in on-call rotation of
production operations and other environments.
•	Develop and implement replication, archiving and backup and recovery
strategies. 
•	Optimization and tuning of ETL process by identifying transformation errors
and improved the overall ETL process time.
•	Design OLAP /Analysis services cubes, jobs, MDX scripting and OLAP cube
performance tuning.

Data Architect								
Career Education Corporation							01/2005 – 03/2007
Chefs Project
•	Collaborate with project managers and business management for all enterprise
data projects. 
•	Implement the tools, software, applications, and systems to support data
goals.
•	Manage and create database schemas, optimizing efficient index maintenance,
storage allocation.
•	Create plans for data security, backup, disaster recovery, business
continuity, and archiving.
•	SQL Server installation, configuration, maintenance including clustered and
stand along server, administrating, performance tuning.
•	Monitor the production databases.
•	Design BizTalk solution for orders processing and inventory.
•	Develop financial and Product Sales reports using SQL Reporting Services,
Analysis Services and Integration Services.

Consultant										
Titan Technology Group     							01/2005-06/2005
NIS Project
•	Work with Applications Data Architect to resolve issues during requirements
phase.
•	Design OLAP data objects: Cubes, dimensions, calculated members; functional
and technical design of Excel pivot table reports based on OLAP cubes.
•	Implement batch job for loading and transform data in data warehouse. Tune the
Analysis server to requirements.
•	Creating reports per user request using Crystal Reports 10.0

Senior Software Analyst						
Accenture									 06/2000-01/2005
DSC Project
•	Interfacing with Project Sponsor, Technical Architect and other SMEs to
document and refine their business problems.
•	Analyzed site effectiveness by running Commerce Server reports.
•	Design DSC website pages.
•	Developed Subscription Mail Merge component using Visual Basic 6.0.
•	Backend Export Translate and Load (ETL) data objects including SQL views based
on SQL queries.
•	Design and schedule DTS packages to load data from multiple areas.
•	Execute Component Test Plans related to new release.
FinMaint Project
•	Build application modules and user interfaces using Visual basic 6.0.
•	Responsible for database conversion; daily maintenance.
•	Software installation, monitoring and tuning 
•	Writing SQL scripts to automate process generating new invoices; design forms

•	used by the finance. 
•	Enhanced and expanded in-house reporting mechanism, using MS Access and
Crystal Reports. 
•	Create and execute Component Test Plans related to new release functionality.
LMS Project
•	Participated in full development cycle and implementing user’s requests for
enhancements. 
•	Designed and coded set of Forms to manage enrollment. Forms are being
implemented as MDI child windows. Database access is being implemented via DAO.

Consultant     										
ERT Consulting									 12/1999-05/2000
•	Developed software projects for Inventory Management, Sales and Order Entry
Systems utilizing Visual Basic as front-end. 
•	Meetings with clients throughout the project and ensured that developed
application reflected program specifications.               
•	Development of systems modules that include vendor and contact information,
product allocation process, automatic and manual order entry, inventory control.
•	Developed tools to update, search and extract data from Oracle database.
•	Maintain program and system documentation.

EDUCATION

Certifications: Microsoft Certified Technology Specialist SQL Server 2005
Microsoft Certified IT Professional Database Administrator SQL Server 2005

IMG University Arlington Heights, IL 
Core Distributed Application development with Microsoft Visual Studio 2005

IMG University, Chicago, IL
ASP.NET, VB.NET, 2002

Productivity Point, Chicago, IL
Advanced HTML, Java Script, 2000

State Polytechnic College, Odessa, Ukraine
Client/Server Application Development Program, 1995		

University of Finance and Economics, Odessa, Ukraine
BS in Finance and Accounting, 1987-1991		


*References available upon request.