DBA Developer, VB programmer

Henry Shvarts

***** ******* **

Woodland Hills CA 91367

Tel: 818-***-****

Fax: 818-***-****

E-mail: *********@*****.***

PROFESSIONAL PROFILE:

Enthusiastic, supportive individual, who examines all the logical

consequences, then takes a participative stance in directing people and

projects, allowing complex challenges to be resolved correctly and

efficiently. A leader, who can present a proposal or guide a group

discussion, with ease and tact. Creative, self-motivated, results oriented

decision-maker, who can learn and adapt quickly to any new situation and

environment.

SUMMARY OF QUALIFICATIONS:

. An accomplished IT professional with over 19 years of practical

experience as a software and data base developer, mentor and hands-on

leader.

. Uniquely qualified with a rare balance of technical expertise and

business aspect, able to bridge the gap between business strategy and

technology, communicate effectively with business leaders as well as

technical staff.

. Working closely with CIO's, Controller, Director of Marketing, QA, HR

and other senior leadership of multiple departments.

. Extensive experience in all areas of full life cycle application

software development. Able to contribute technical, process and

leadership to help deliver quality solutions on time.

. Ability to teach and transfer skills, can effectively communicate the

intricacies of products and technologies to development teams as well

as to non-technical staff in understandable terms.

. Experienced in MS SQL Server, MS Access, Visual Basic, ADO Engine,

ODBC, Visual Basic Data Reporting, Windows 98, 2000, 2007 Windows NT

Server/Workstation 4.0, 2000

. Roles included; Operations and Project management, Business analysis,

IT strategies, Data management, DB Administrator/Developer, Technical

writing, Contingency planning.

BUSINESS EXPERIENCE:

02/00 - present NOVACAP, Inc., Valencia, CA.

Progressed through a series of increasingly recognizable positions,

starting as a Programmer through Project Manager, DB

Administrator/Developer, Business Analyst and Department Manager.

Department Manager:

. Shipping and Receiving Department.

. Oversee day-to-day operations to come up with more efficient process.

. Schedule software development projects across the all processes of the

department.

. Instituted processes and management techniques to align staff and

create organizational efficiencies.

. Dramatically increased service levels, credibility and technology

awareness within the department.

Business Analyst:

. Learning the process by working with the personal for the specific

manual work procedures.

. Reorganize the process to find more efficient way to perform this

procedure.

. Come up with computerized solution process and develop the system.

. Writing procedures and training of the personal.

. Internal Audit

Project Manager:

. CPG (Ceramic Products Group) combined sales data for 4 companies.

. Managing documenting requirements and tracked development timelines,

arranged product design, approved interface. Database on MS SQL

Server, programming in Visual Basic.

DB Administrator/Developer:

. Date to date backups and management of Jobs and Activities.

. Monitored SQL Server Logs and Security Logins.

. Table, Stored Procedures, Triggers and Views creation.

Programmer / Analyst:

. Responsible for project coordination, software and database

development using Visual Basic 6 and MS SQL Server 7.0 and MS SQL

Sever 2008, testing, client presentations, documentation, progress

reports, and user training / support.

. Converted business requirements into technical specifications and

design recommendations.

. Planned and organized the meetings with the clients for user

acceptance.

Developed complete systems:

Corrective Actions - keeps track of all internal and major client

issued actions.

Customer Complains - keeps track of all Customers issued complains.

Document Control - keeps track of all Internal Procedures and

Documents.

Stamps - keeps track of internal personal Id Stamps.

RMA - keeps track of all generated RMA's.

Employee Training - keeps track of Internal School training.

Sales Rep - keeps track of all sales rep in the field.

Quotes - keeps track of all generated quotes for the outside

customers.

Purchase Order - creation and tracking of purchasing orders.

Invoice Payable - payment system for purchasing orders.

Receiver - keeps track of receiving goods based on purchasing orders.

RMA Receiver - keeps track of receiving RMA's.

Carrier Tape - inventory and usage of the build materials.

In Sales Rep - repository of all the reps.

Backlog Comb Reporting - Crystal reports with backlog calculations.

Parts Spec - Customer Part Number Inquiry with Remarks.

POS - Point of Sales system. Commissions pay system.

Employee Time Sheet - Record daily time for Salaried Administrative/

Hourly Non-Exempt employees.

Evaluation Review - Alerts supervisors for upcoming employee review.

Employee GM - HR repository collection of all the Mexico employees.

Stamps - Stamps inventory

Preventive Action - keeps track of all Preventive issued actions.

11/95 - 02/00 American International Group, Inc., New York, NY.

Programmer/Analyst/DBA

Short Term Disability Project:

. Acting as a DBA Administrator to the Server

. MS SQL Server 7.0 (installation), Logical and Physical database

design.

HIPAA Certificate Project:

. Design, development and implementation of the Travis Cobra Interface

to HIPAA system (vendor package).

. System to produce the by-weekly information to feed a vendor package,

which can produce HIPPA certificates.

. Create the history database, processing steps (queries, modules, and

macros, forms as GUI interface) and balancing reports.

. Y2K testing and preparing documentation.

. Responsible for queries, modules, and macros changes and maintenance

of the database.

Corporate Business Directory System:

. CBD is a centralized Database for providing related information about

an employee for e.g. Business location(s), Phone / Fax number(s) etc.

Participate in CBD Y2000 System Behavior.

. Demonstrating of System behavior in response to employee Additions,

Modifications, Deletions, through the CBD Client and HR Import

Routine.

. Presently responsible for front-end changes and acting as a DBA

Developer / Administrator to the CBD Server.

Employee Profile Project:

. Involved in development Human Resources Repository system. System is

used to track Employee Profile like (Education Info, Salary Info, Job

Info, Bonus Info, Sick/Vacation Info, Benefits Info, Comp/Department

Info)

. Writing stored procedures, triggers, rules; designing tables, views

and relationships; maintaining database security.

. Designed and implemented front-end and multiple reports.

. Responsible for User and System Support (creating new reports

modification in front-end and back-end), installations.

Requisition Project:

. Participate in design, development of Requisition System (tracks open

and closed position requisitions within the company)

. Assisted users, performed troubleshooting and prepared user manuals.

07/92 - 11/95 Quanta Microsystems Inc., Somerset, NJ

Consultant

. Participate in design, development and maintenance in multi-user,

client/server environment.

. Responsible for GUI interface and preparation of program

specifications, data prototyping and query design.

. Writing stored procedures, triggers, rules; designing tables, views

and relationships; maintaining database security.

EDUCATION:

Moldova State University. Kishinev, Moldova

B.S. in Computer Science / Electrical Engineering

New York City Technical College. Brooklyn, NY.

A.A.S. in Computer Science / Electrical Engineering

S.C.S. Business and Technical Institute. NY., NY.

DIPLOMA IN Digital Electronics and Computer Technology

PROFESSIONAL TRAINING:

Microsoft and Other Certificate of Achievement:

. Cannon Copier

. Wang Lab., Hewlett Packard and Banyan

. Mastering Microsoft Visual Basic 6.0 Development Course

. Microsoft SQL Server 6.5 System Administration and Implementation

Course #933

. System Administration for Microsoft SQL Server 7.0 Course #832

. Microsoft SQL Server 2008 R2 Analysis Services, Database

Administration, Integration Services, Reporting Services, Transact-SQL

Programming

. ISO 9001:2000 Internal Quality System Auditor

. SARBOX Internal Controls Project

. Code of Business Conduct and Ethics Course and Certification

. Gifts: Giving and Receiving

. Gifts: Client Meals

. Gifts: Why Don't You Take It?

. Global Competition

. UK Bribery Act

. Data Protection and Privacy

. Global Anti-Bribery

. Export Controls: Recognizing Conflicts of Interest

. Preventing Sexual Harassment Part I CA Edition

. Preventing Sexual Harassment Part II CA Edition

. Preventing Sexual Harassment Part III CA Edition

. Preventing Sexual Harassment Part IV CA Edition

. Understanding the Foreign Corrupt Practices Act

REFERENCES:

. Furnished upon request.

Contact this candidate