Sql Server System
Resume:
Vadim Nazaroff
Brooklyn, NY 11229
Home: 718-***-****
Cell: 917-***-****
E-mail: *********@*****.***
OBJECTIVE: To obtain a Programmer/Analyst or Crystal
Reports Developer position in organization where I can apply my
knowledge,
skills and experience with
the opportunity to learn and grow.
HARDWARE: IBM-PC and compatible, Sun Sparc Workstation
SOFTWARE: Visual Basic 5.0/6.0, MS SQL Server 6.5/7.0/2000/2005,
Advantage Data Architect 8.1, MS Access 97/2000/2003,
MS Word, MS Excel, HTML, ASP 2.0,
VBScript, JavaScript, MS IIS 4, VB.Net, ASP.Net, XML,
FrontPage 2000, MS Visual InterDev 6.0, Seagate Info 7,
Crystal Reports 6.0/8.0/8.5/10, Interworld Commerce
Exchange 4.0, HomeSite 4.5, Adobe Photoshop 6.0, MS Visio
2000, Windows 95/98/NT4/2000/XP/Vista, Unix (SunOS V,
Solaris 2.6)
EXPERIENCE:
05/08-05/09 American Language Communication Center
(New York, NY)
Site: http://www.learnenglish.com
SQL/DB Programmer
Designed and developed custom Crystal reports to
accommodate company reporting needs utilizing Seagate
Crystal Reports 8.5 and Advantage Data Architect 8.1.
Developed custom reports for Agent's department (Agents'
due, agent's students list, posting confirmation receipts)
Developed custom reports for Sales department (info calls,
appointments by sale employee, info call analysis by
language).
Developed custom reports
for bursar department (credit card transactions, attendance history,
certificates, receipt
list).
Developed custom reports for Educational department
(waiting students, teachers list, teacher daily
substitutions).
Developed custom reports for I20 department (students
payment history, attendance history, list of re-
registration students).
. Created complex preprocessors and SQL statements to be
used in the reports.
. Created parameterized Crystal reports and customized
existing reports using Cross-Tab reports, sub-reports,
grouping and sorting, graphical, charts, Summaries,
Running Totals, Visual Basic syntax to create custom
formulas for the reports.
. Generated monthly/weekly/daily activity reports for all
departments in the school.
. Integrated reports into ALCC client for access to the
end user.
. Created documentation for the definition of the SQL
tables.
01/03-02/08 Catholic Charities Brooklyn and Queens
Site: http://www.ccbq.org/
Programmer/Analyst
Processed Medicaid electronic remittance files using Med835
Software (HIPAA-compliant Application by Paul T. Graham).
Analyzed Medicaid payment information and created reports
using Microsoft Excel for the Office of Finance.
Designed and developed custom Crystal reports to
accommodate agency reporting needs utilizing Seagate
Crystal Reports 8.5 and MS SQL Server 2000/2005 as back-
end. Developed custom reports for HR department (employee
Medical and Dental Plans for Multiple companies, pensions,
benefit confirmations, bonus vacations, census, dependents,
mailing labels and etc. reports). Developed custom reports
for Payroll department (Biweekly funding, disability,
Pretax and Post tax deductions reports and etc.).
. Working knowledge in Ceridian Source 500 HR/Payroll.
. Worked with MS SQL Server Database to create and
maintain SQL statements, stored procedures for Crystal
Reports.
. Created parameterized Crystal reports and customized
existing reports using Cross-Tab reports, sub-reports,
grouping and sorting, graphical, charts, Summaries,
Running Totals, Visual Basic syntax to create custom
formulas for the reports.
. Integrated the reports into Ceridian Source 500 for
access to the end user.
. Wrote specifications and gathered requirements from the
users to develop Crystal Reports as per the needs of the
client and maintain documentation of the reports for
future reference.
. Supervised the transmission of payroll related data from
Ceridian.
. Trained users to run reports from the system.
. Created and maintained HIPPA database using MS Access
2003. Modified the database as needed.
Created and ran reports using MS Access Reports.
. Created and modified Billing PL (Profit and Loss)
reports using MS Excel 2003. Created macros
for data retrieval from Macola 7.5.
. Created and maintained 9/11 Client database using MS
Access 2000, modified the database using
MS SQL Server 2000 as backend. Ran reports using MS Access
reports.
10/00-10/01 eB2B Commerce - New York City, NY [NASDAQ: EBTB]
Site: www.eb2b.com
Web Developer
Designed, developed, maintained and supported the
Interworld Commerce Exchange 4.0
for EB2B Release 2.0 and 2.5 Tradegateway applications. The
system was implemented
using MS SQL Server 7.0 as the back-end, Interworld Commerce
Exchange 4.0 and Java Script 1.2
. Working knowledge in Commerce Exchange 4.0 (a sell-side
e-commerce tool by
Interworld Corp.) on object-oriented processes,
templates, and stored procedures.
. Designed, developed, and modified the business process
flow utilizing InterWorld process flows,
templates, database schema enhancements and SQL
stored procedures.
. Responsible for data migration to Staging server.
. Interacted with core team members to study their current
business process.
. Created technical specifications documentation.
. Created screen flows using MS Visio 2000.
. Interacted with developers, testers and management to
enhance current version of company web site.
Analyzed, designed, implemented and maintained automation
of online customer registration procedures.
The scope of this project was to gather customer
information and populate it into the database.
The system utilized Java Script 1.2, VB Script and ASP on
front end and MS SQL Server 7.0 on back end.
. Created tables, stored procedures.
. Tested stored procedures and analyzed them for optimal
performance
. Designed ASP Pages currently running on the WEB Server
Modified and redesigned chain drug and general merchandise
private exchanges running on
EDIxchange application software. These applications are
used by clients to access their PO's,
invoices, ASN's and Remittances. The system was implemented
using Perl Script, JavaScript
and HTML pages running on a UNIX Server with a Oracle 8.0
database.
12/99-09/00 Sterling Testing Systems, New York, NY
Site: http://www.sterlingtesting.com/
Programmer/Analyst
Analyzed, designed, implemented and maintained Web-based
LabCorp Drug System.
This system utilized Java Script 1.2, VB Script and ASP on front end,
and MS SQL Server 7.0
Running on NT Server for back end.
. Participated in design and implementation of referential
integrity of database.
. Created application in VB 6 to prepared files for
downloading on beck end.
. Designed HTML Pages currently running on the WEB Server.
. Created and tested code in Java Script, VB Script and
ASP for Client and Server Sides which
allowed to bring and retrieve data between the client
side and MS SQL Server.
. Created Components in VB 6 currently running on the
Server site.
. Created, designed and tested Reports using Crystal
Report 8.0
> Designed and implemented Pharmchem Drug System including
database design. The system extracts decrypted files
from an FTP server, imported it into a database and
printed drug results reports. The system was implemented
Using MS SQL Server 7.0 as the back-end, MS Visual Basic
6.0 as the front-end and Crystal Reports 6.0.
> Designed and implemented Connecticut Criminals System
including database design. The system extracts files
from CD and imports it into a database. The system was
implemented Using MS SQL Server 7.0 as the back end, MS
Visual Basic 6.0 as the front end.
. The system automatically ran on server and updated
records in the database with "No Criminal
Conviction Found" if the name of person for the
requested order does not exist in the database.
. The system allowed users to update requested order
with NCCF or CCF.
> Created Reports to accommodate all needs of the company
using Seagate Info 7.
09/99--12/99 CAMBA INC, Brooklyn, NY
Programmer/Analyst
Participated in design and development of the Job
Placement and Rotation (JP&R) for Office of CAMBA.
This is a Web-based application utilizing MS SQL Server 7.0
as the back end and Internet Information Server 4 as the
middle-tier deployment platform. JP&R is an application
that maintains and provides all needs and requirements of
the Office. The system has over two hundred users.
Created and tested tables, indexes, stored procedures, and triggers
Designed HTML Pages currently running on the WEB Server
Created and tested code in VBScript, JavaScript and ASP for Client and
Server-Sides which allows
to retrieve and
update data between the Client-Side and MS SQL Server
09/98--06/99 Office of Alumni Affairs, Brooklyn College, Brooklyn, NY
Programmer/Analyst.
An Application for Office of Alumni Affairs to accommodate
all needs of the Office. The front-end was developed using
VB 5.0 accessing data stored in SQL Server 6.5. The system
allow user to enter, modify delete information, perform
search, and print out any needed reports created in Crystal
Reports 4.6
Participated in design and created referential integrity of database
Created tables, indexes, stored procedures
Tested stored procedures and analyzed them for optimal performance
Designed GUI utilizing MDI form
Created Class module to generate reports (Reports using Crystal Reports
4.6)
Communicated with Client representatives
Provided Training to system users
02/98--06/99 Computer Center, Brooklyn College, Brooklyn, NY
Computer Consultant
C/C++ program debugging and verification
Tutored students in the use of UNIX operating system
Tutored students with programming assignments
Used different software packages on various platforms
EDUCATION:
03/02-07/02 DCIC Business Institute, Brooklyn, New York
(Professional training course for VB.Net, ASP. Net, XML)
02/95--06/99 Brooklyn College, CUNY, Brooklyn, New York.
B.S. in Computer and Information Science
09/89--06/93 Kiev Technical College of Radio
Electronics.
Kiev, Ukraine.
Associate in Applied Science/Electronics Engineering
Technology
REFERENCES: Available upon request.[pic]
Contact this candidate