Quality Assurance Project

George Zilberman

**** ******** *****, ********** ** 22314

Telephone: 718-***-****

***************@*****.***

SUMMARY OF QUALIFICATIONS

• Senior Level Expert in MS Access development.

• Extensive and successful experience in design and development of business client/server applications using

Visual Basic/VBA under all MS Windows versions.

• Full life-cycle development encompassing database design, tool selection, prototyping, programming, testing,

installation, and implementation

• Strong planner, organizer, and leader who can work independently or as part of team, master new concepts

quickly, incorporate the latest technology, train and supervise personnel, direct complex projects from inception

through completion, and develop IT strategies that dramatically increase efficiency and productivity.

• Thorough knowledge of data access technologies in client/server development using ODBC, DAO, RDO, ADO

against MS SQL server, Oracle, and MS Access databases.

• Excellent knowledge of Excel and other MS Office tools

• Excellent communication, interpersonal, and analytical skills. Able to establish productive rapport with diverse

individuals and staff levels, from end users to senior executives.

TECHNICAL SKILLS

Software: Visual Basic, VBA, MS Access all versions, MS Excel, SQL Server 6.5/7.0, Oracle 7.3/8, SQL Plus,

SQL, T-SQL, MS Windows 3.x/9x/NT/2000/XP, MS Office, DOS, Microsoft Project, Visio

CAREER HIGHLIGHTS

P.A.I. November 2012 to Present

Consultant

Working as a consultant with the US Navy. Developing A Cost Projection Model using MS Access for Front and Back Ends.

• Created a Database Schema for acquisition and retention of Navy maintenance costs currently being stored in various

databases. (Using MS Access 2007)

• Created a User Interface that allows Navy personnel to easily view, drill down, and acquire maintenance data. (Using

MS Access 2007)

• Participated in numerous data analysis and created project architecture design

• Created Projection analysis that allows the Navy to project maintenance costs 5 years into the future.

• Created an interface that pulled data from various sources including Excel and text data files

• Interfaced with senior Navy personnel to get requirements and arrange project scope.

• Provided analysis and advised the Clients as to the best tools and technologies to achieve success in the project.

• Created control analysis matrix using Excel and Access

ITT-Exelis October 2008 to November 2012

Senior Systems Analyst/ Senior Systems Architect.

Working as a Senior Systems Analyst; responsible for maintaining, supporting, and designing mission critical applications.

(Using MS Access, VBA and Visual Basic 6)

• Participated is System Design and Architecture, including Database Architecture, System and Business Analysis, Tool

Selection, Documentation, Test Protocols, Integration of divergent data sources. (Using MS Access 2003 and SQL

Server)

• Participated in translating Business Rules and Requirements into Technical Specifications.

• Helped to establish rules for Production Change Control.

• Resolve data, technical, user error issues under extremely tight deadlines and critical circumstances.

• Developed strategies for enhancements in application security

• Developed Data Analysis reports (MS Access Reports)

• Provided custom queries exported to Excel for further analysis by business leaders.

• Worked with business users in establishing business rules and work flows.

• Trained and supervised new developers.

• Provide Technical support for many mission critical applications

Wellconnected June 2007 to August 2008

Systems Analyst/Team Leader

Worked as a Systems Analyst/Team leader, in a highly demanding and challenging environment; proposing, developing, and

implementing projects, and overseeing their full life cycle.

• Managed the entire Computer Infrastructure. Supervised 2 people in Data Processing, Backups and LAN management.

• Developed overall Database and System Architecture (Using Access 2003)

• Developed Graphical User Interfaces) Using Access 2003)

• Developed long term strategic software planning for IT operations and data management

• Developed mission critical applications and oversaw their full life cycle. Created Technical and Functional

documentation

• Improved the process of Data transfers to China factory. This translated into a much more efficient and reliable and

streamlined operation, resulting in very significant savings for the company.

• Developed reconciliation tools.

• Managed data flows of the company

• Resolved expeditiously and accurately all critical data problems, insuring smooth operations in our China factory.

• Trained employees in the use of new software

• Maintained vendor relations; negotiated terms of contracts. Determined service levels.

Epicor - CRS October 2005 to June 2007

Systems Analyst

Worked in a highly integrated team environment to modify and correct systems for large retail chains. Deliver code to customer

satisfaction in a very tight deadline setting. Using Visual Basic 6 and SQL –Server 8.5

• Design specifications and testing protocols for modification of highly complex management systems.

• Research code archives (using vibes) for identification of potential fixes for customer and QA reported problems with

the systems

• Synchronized CRS development environment to customer production environment using VM. This ensured full

customization and integration of the software delivered to the client.

• Created customization modules for clients using VB 6 and SQL server.

• Modified and improved Point Of Sale (POS) software according to customer needs.

• Worked with Data Modeling architecture to design reports (Crystal Reports)

• Improved data flow and reporting of retail transactions.

LOR Medical PC, Brooklyn NY September 2003 to July 2005

Consultant

Worked with medical professionals to develop systems and databases for reference of Patient, Supplier, and Referral Data.

• Designed and coded a system for data entry and retrieval of patient data using VB and Access

• Designed and coded a system that tracked expenses and accounts payable using VB and Access. The system was

linked to the Supplier database for timely invoice handling.

• Created an Employee database (Access)

TIAA-CREF, New York NY February 2000 to September 2003

Systems Analyst

Worked with the Treasury department to facilitate data feeds from multiple financial areas into an XRT system (vendor

product).

• Managed ongoing support and problem resolution for the time critical/mission critical financial data feeds. Resolved

issues with various company business units as well as Bank of NY and Deutsche Banks.

• Created an application that automated these loads.

• Administered Crystal Info Desktop system that provided Treasury reports to about 500 users.

• Created a system that tracked and analyzed performance of Treasury analysts.

• Created a system that allowed portfolio managers to determine if they have available cash.

Worked with Equities Lending department.

• Took over and finished ahead of schedule an incomplete project that established data links with Chase Manhattan and

Deutsche Bank. This project automated equities lending information exchange.

• Developed reporting system for Accounting that extracted Lending data from KTEK system.

Maxim Group, Morristown NJ August 1997 to January 2000

Consultant: Hoffman la Roche

VB, Access

• Was responsible for full life cycle development of several mission critical applications.

• Developed a personnel management system for Quality Assurance division. (This product worked so well and was so

versatile that it was “sold” to other areas of the company)

• Developed a system for tracking and allocating of research and marketable product books as part of Quality Assurance

compliance with Food and Drug Administration.

• Developed a system for proper storage of lot samples, chemicals and controlled substances in compliance with the

Drug Enforcement Agency.

Consultant: Exxon

VB, Access

• Designed and managed the complete life cycle of a project for the storage of International Economic data using Visual

Basic and Access This program analyzes reports generated by an IMF program and converts the information into a

database format for analysis and determination of financial viability of various global projects.

• Designed a database for storage of historical financial data

• Created procedures for the transfer of data from an old non-relational database to a new structure where the data was

arranged in a completely different order

• Designed GUI interface for the new database.

• Interfaced regularly with the clients, translated their ideas into the design of the application, created specs, and

implemented complete life cycle of the project.

• Designed and created a system, for the tracking of uncompleted tasks from Exxon projects around the world (This

software was distributed to all Exxon sub-Contractors for reporting their incomplete

Education

Brooklyn College, Major in Business Management

Contact this candidate