NIRMAL K. GHOSH

*** ****** *** *** ***, Silver Spring, MD 20910 • 301-***-**** • acflo1@r.postjobfree.com

ACTIVE TOP SCRET CLEARNCE FROM 2010

SKILLS SUMMARY:

A Senior Data Specialist with more than 15 years using SQL and 4 years PL/SQL /DBA experience

and Oracle tools. I have a proven ability to analyze processes, functions, procedures and clearly report

their impact on operations and logistics. In addition, I have extensive experience in computer

programming, developing commercial software and scheduling operations.

CORE COMPETENCIES

• Oracle, SQL, PL/SQL • Oracle DBA • TOAD

• UNIX /LINUX • Data Modeling • ORACLE FORMS

• ORACLE REPORTS • Microsoft Office • HTML

• Shell Scripting • MS SQL

HIGHLIGHTED CAREER TRAINNING

Learning Tree International

Rockville MD

Oracle PL/SQL Hands On Training

DBA University

Chicago (On Line)

Oracle DBA Hands On Training

University of Maryland University College

College Park, Maryland

Database Management Certification

PROFESSIONAL EXPERIENCE

Syneren Tech Corporation (US Navy) Nov 2013 Present

Database Engineer

• Developed and performed test plans.

• Wrote PL/SQL scripts to manipulate data and generate tables.

Nirmal K. Ghosh

Senior Programmer Analyst

• Wrote SQL and PL/SQL scripts that included variables, cursors, loops and

exception handlers as well as procedures and functions.

• ORACLE database server software installation.

• Database Creation .

• Database configuration assistant (DBCA).

• Managing tablespaces and datafiles.

• Managing Database users, privileges and role authorization.

• Managing online redo log files and archivelog mode.

• Administrated the existing databases, monitored the database performance.

• Oracle Job Scheduling.

• Oracle database cloning (Using Hot Backup).

• Oracle Database Cloning (Using RMAN Backup)

• Oracle Data Movement (Data Pump Export and Data Pump Import)

• Performance Tuning, Tracking database sessions.

• SQL Statement execution Plan (Explain Plan) and Optimizer Statistics.

• Oracle 12c R1 Database Software Installation.

• 12c R1 Database Creation USING DBCA (Non-Container Database)

• Converting A Non-CDB into a pluggable database(PDB)

• Work experience in AGILE and Waterfall methodologies.

• Ut ilized the Web logic interface to monitor reports/forms usage.

• Ut ilized load (Oracle SQL Loader utili ty) process to upload Financial Accounting

data.

HARRIS IT Services (US Navy NRL)

Software Engineer Nov 2012 – October 2013

• Wrote SQL and PL/SQL scripts that included variables, cursors, loops and exception

handlers as well as procedures and functions.

• Physical Database Backup and recovery (Hot and Cold Backups) and Logical Backup.

• Database L inks, Creating and Managing Table spaces and Data files, Creating and

Rebuilding Indexes, Managing Database Security.

• Creating Database users and granting roles.

• Handling Import/Export like schema, table, full database etc.

• Troubleshooting and maintenance of Oracle Database.

Nirmal K. Ghosh

Senior Programmer Analyst

• Handling space issues.

• Attend daily change requests for production database.

• Responsible for developing and maintaining client server and web based application

by using Oracle Forms and Reports.

• SQL Statement execution Plan (Explain Plan) and Optimizer Statistics.

• Moved data between databases and external files using SQL Loader for the bi-weekly

O H Budget and Financial Cost Accounting.

• Wrote PL/SQL scripts to manipulate data and generate tables.

• U tilized the Web logic interface to monitor reports/forms usage.

• U tilized load (Oracle SQL Loader utili ty) process to upload Financial Accounting

data.

General Dynamics IT (US Army) 2002 – Oct 2012

Programmer Analyst

• Developed, maintain, schedule and monitor ETL process.

• ORACLE database server software installation.

• Wrote SQL and PL/SQL scripts that included variables, cursors, loops and

exception handlers and wrote procedures and functions.

• Responsible for the review, evaluation and determination of usability of data

contained in the multiple Oracle databases.

• Composed Oracle SQL and PL/SQL of stored procedures, triggers, functions,

packages 10g/11g.

• Developed excellent analytical skills.

• Gained experience with Performance Tuning (Database).

• SQL Statement execution Plan (Explain Plan) and Optimizer Statistics.

• Skilled in Tuning of PL/SQL code using Index, and Hints etc.

• Experienced in working with Linux Operations environment and Windows

Development environment

• Responsible for the review, evaluation and determination of usability of data

contained in the multiple Oracle databases.

• Produced products that serve the more than 320,000 globally dispersed

customers reporting to the15 Regional Personnel Offices.

• Used ODBC drivers to transfer files from an ORACLE database into a Microsoft

Access database

• FTP’d large volumes of data using SQL-LOADER and TOAD to transfer the files

from the MS Access environment into an ORACLE database residing on an HP

UNIX server.

• Repository extensively and designed, and implemented a new universe to

support the user requirements.

• Wrote SQL/PLSQL scripts to generated outputs for user

Nirmal K. Ghosh

Senior Programmer Analyst

• Conducted daily, weekly, and monthly database loads from input sources.

• Supported monthly, quarterly, and annual reports and extract files generation.

• Maintained the development and production database

• Provided full-scale Technical support to users

• Generated daily, monthly, quarterly and yearly reports

• Provided full-scale Technical support to users

• Provide full-scale support to UNIX/LINUX operations.

• Performed the database maintenance & administration activities

• Troubleshot all database problems associated with the loading of data into

tables

• Coordinated with system administrator for maintenance and tuning of hardware

• Administrated the existing databases, monitored the database performance

• Wrote SQL/PLSQL scripts for database activity monitoring

• Documented the existing application systems

• Conducted regular backup of the database

• Maintained large volume database

2000 – 2002

FC Business Systems (US Army)

Production Support Specialist

• Was responsible for large scale initial review, evaluation and determination of usability of data

• Used ODBC driver to transfer files from ORACLE database to Microsoft access database

• FTP’d large volume data from MAINFRAME to UNIX, used SQL LOADER to transfer files

from UNIX to ORACLE database.

• Wrote SQL and PL/SQL to create reports and moved reports to Microsoft access database and

excel spreadsheets. My specific responsibilities include

• Used Business Object Universe, Business Objects Reports and Business Objects repository

extensively and designed, and implemented a new universe to support the user requirements.

• Support monthly, quarterly, and annual reports and extract files generation.

• Maintain development and production database.

• Provide full scale Technical support to users.

• Performed the database maintenance & administration activities.

• Troubleshot all database problems associated with the loading of data into tables.

• Coordinated with system administrator for maintenance and tuning of hardware.

• Administrated the existing databases, monitored the database performance.

• Wrote SQL/PLSQL scripts for database activity monitoring

Network Specialty Group Inc – Oracle Application Developer 1995– 1999

• Wrote SQL and PL/SQL scripts that included variables, cursors, loops and exception handlers

• Wrote procedures and functions, as well as used Oracle Forms 5.0 and Oracle Reports 3.0 to

accomplish these tasks

Nirmal K. Ghosh

Senior Programmer Analyst

• Gave presentations on projects development progress

• Provided end user support in the form of formal training and telephonic support

EDUCATION

Bachelor of Science in Accounting, University of Calcutta, India 1984

Contact this candidate