Personal Profile
Prakash Bom, 30-57 14th Street, Astoria, NY 11102Now working in Manhattan and living in Astoria, Queens, New York, USA for last four years. Independent consultant in data management and warehousing on SQL Server databases; design and development of SQL Server database, SQL scripting and Transact SQL programming. Implementation of database replications, DTS packages and other components; manage data import, export and migration; & administer SQL server database
PROFESSIONAL
SKILLS
·
Proficient in SQL Server database installation, implementation and
administration
·
Qualified in providing assistance for Win2k network
implementation, and administration.
·
Skilled in SQL Server databases replications, backup and DTS
Packages automation
·
Experienced in data migration, data cleaning and data organization
between SQL Server database, Access and Excel
·
Capable of understanding RDBMS, ER data modeling and data
warehousing for query and analysis
·
Competent in SQL command, Transact SQL – stored procedures,
triggers and queries
·
Knowledge of HTML, ASP, Visual Basic, C, and C++
Katherine Gibbs NYC Schools,
Manhattan, New York
(Jan 2004 – Present)
Position: Consultant Data manager & proctor: Monitor and management software
driven college level test program, and migrate Gibbs NYC General Education tests
results data per quarter semester from campus database to manage data for
overall general education’s performance report analysis for instructors’
tally, curriculum effectiveness and students’ skill development analysis
reports
Dynasty Belts, Inc. Long Island City, NY
(Feb 2004 – Dec 2004)
Position: IT & office manager: Provided windows XP desktop support to
computer based office management. Setup, upgrade and maintained the network system.
Configured, supported and maintained computer systems and applications.
Developed and maintained MS Access company database, set up and edited MS
Excel worksheets, Acrobat documents, graphic photo and digital camera snaps
online management for sales and marketing – full time
Professional Support Services,
Cherry Hill, NJ
(2001 – 2003)
Service: IT Support: Designed, developed and maintained databases in MS Access
for importing different forms of data (Text, OCX, XLS, HTM) filtering and
sorting for members to search data as per their need; wrote documents and
trained members how to use database programs.
Video Pipeline Inc. Haddonfield, NJ
(1999 – 2001)
Position: IT
Support: Installed,
and upgraded PC hardware, peripherals and windows (from Win9x to WinNT);
installed and Implemented Windows NT local network system that provided file
servers, streaming video servers, and SQL Server databases; Installed WinNT
Servers in Dell Dimension Servers for IIS Servers and Streaming Video Servers as
web server; designed SQL Server DTS packages for importing and exporting data
into MS Access; programmed Visual Basic routines for Access database to clean up
client data; programmed HTML, ASP, JavaScript, SQL Script web pages.
AON Consulting, Inc, Conshohocken,
PA
(1998 – 1999)
Position: Associate DBA Programmer. Maintained and programmed actuary database
programs in MS FoxPro, Access, and Excel.
Export and Import data immensely from different programs and different
data formats. Converted
actuary programs from C to FoxPro and wrote technical manual for the program.
Olga’s World Wide Travel,
Philadelphia, PA
(1996 - 1998)
Position: IT Consultant.
Designed and implemented ‘Travel Reservation’ database in MS Access
to keep sales and reservation records for generating invoices, customer records,
and sales reports; trained staffs how to use the database, and other software
such as MS Word, Excel, Outlook and Internet Explorer (still provide support on
call).
EDUCATION
MC3 College –
Philadelphia University (AFFLT), Blue Bell, PA:
Associate in Computer Science
Tribhuvan University, ZZ, NP: Master's degree in English (equivalent to accredited university of the United
States of America Bachelor’s degree in English)
CompTLA, USA: Certification: A+ 2001 & Attended Microsoft classes for MCSE Win2k & MSDBA SQL Server 2000 certifications in progress