Overview

• More than 10 Years of experience in software development and programming
• More than 3 years of DBA experience in Oracle 8/8i/9i/10g/11g and RAC
• Implemented Data replication using Quest Shareplex and Oracle Streams to achieve high availability for critical databases
• PL/SQL tuning using hints, creating indexes and parallel query
• Upgraded multiple databases from Oracle 8,9i,10g to Oracle 11g
• Performed feasibility analysis and upgraded oracle forms and reports 6i to Oracle Application server environment
• Wrote annual budget proposals for the Oracle shop
• Negotiated prices and terms with vendors like Oracle and Quest Software during upgrades
• Expertise in developing applications using PL/SQL, Developer 2000 and Oracle Application Server (Forms 6i-11g, Reports 6i-11g)
• Extensive Knowledge on Forms 4.5,6,9i ,11g and Report 2.5,6,9i,11g
• Conversant with all phases of software development cycle involving system analysis, design, development and implementation
• Worked Exhaustively on Types, Objects and Object Views, Dynamic Views, Snapshots, etc.
• Well experienced in Query Optimization and Tuning
• Worked on implementation of Security, Audit at various levels by using coded security module, auditing, DDL Triggers
• Solid experience in redesigning and de-normalization of database
• Involved in rigorous testing process
• Extensive experience writing Stored Procedures, Functions, Packages, Recursive PL/SQL Routines, Database Triggers, Pro * C, Shell-Scripting, TOAD 7.6, SQL Loader, PL/SQL Navigator
• Gone though each and every phase of software development life cycle for a significant period of time
• Involved in design and development of a ERP package for Indian Industries, Team Technologies
• Excellent programming and problem analysis skills proven under high-pressure environments
• Project Management knowledge and experience
• Well developed Interpersonal, Analytical and Communication Skills
• Developed PL/SQL Packages and Libraries

Skill Summary

Operating Systems:

Windows 7/Vista/Xp/2000/NT/98/95, Unix, Linux, Solaris

Databases :

Oracle 8/8i/9i,10g, 11g, RAC, SQL Server 2008

Languages :

COBOL, C, C++, Java2.0, Shell Scripting, Pro* C,IDL, Python

Front End Tools :

Oracle Forms (4.5, 6, 6i, 9i, 11g-OAS), Visual Basic 6.0

Reporting Tools :

Oracle Reports (2.5, 6, 6i, 9i, 11g-OAS), Crystal Reports

Graphics Tools:

Oracle Graphics 6i.

ETL and BI Tools:

Oracle Data Warehouse and Oracle Business Intelligence

Database Tools:

Toad, OEM, Spotlight, Shareplex, Oracle Streams, Oracle Advanced Replication, SQL Navigator 4, RMAN, Data Guard

Version Control:

SVN, Mercurial

Other:

Computational Fluid Dynamics software- CFX, CCD image analysis software for astronomy –IRAF, AUTOCAD, ZEMAX

Experience

Confidential,Augusta, Maine March 2012- Present
Title: Applications DBA Consultant
Environment: Oracle 9i, 10g, 11g, RAC, Forms 6i, Reports 6i, Forms and Reports Services 11g, Oracle Application Server, TOAD, Windows 2003 Server, Windows 7, UNIX, Linux and Solaris

The Department of Administrative & Financial Services (DAFS) is an innovative organization that coordinates a number of central services for departments within Maine State Government. To accomplish its various tasks and responsibilities the DAFS\' service bureaus seek to work in partnership with other state agencies. Additionally, the Department works to provide quality services to Maine citizens and continues to establish processes that will ensure accountability in the State\'s financial performance that will warrant the highest level of public confidence.
Responsibilities:

• Database administration tasks
• Act as the point of contact for different development teams needing information and advise on database related issues
• Identify, prioritize, and act upon opportunities for performance improvement
• Monitored the databases performance during high peak times
• Design and development of the front end screens and menus as per the requirements
• Design and development of advanced report customizing tools and the reports
• Technical documentation and user documentation

Confidential,Tenerife, Spain March 2010- March 2012
Title: Marie Curie Postdoctoral Fellow
The IAC is one of the leading research centers in Spain covering theoretical and observational research and instrumentation across most areas of Astrophysics. The Spanish Government has selected it as one of only eight “Severo Ochoa Centers of Excellence” in astrophysical research.

Relevant Responsibilities:

• Cross-matched different astrophysical databases containing millions of records with star data to extract information on interesting targets for follow-up observations with world-class telescopes
• Wrote grant and telescope time proposals which compete internationally
• Give talks and presentations of research in international conferences
• Publish articles in peer-reviewed journals

Confidential,Orlando, Florida January 2007-March 2010
Title: DBA & Applications Systems Analyst
Project: Complete upgrade of all of the Oracle products
Environment: Oracle 9i, 10g, 11g, RAC, Forms 6i, Reports 6i, Oracle Application Server, TOAD, Shareplex, Spotlight, Windows 2003 Server, UNIX, Linux and Solaris

Orange County Supervisor of Elections (OCSOE) is a county office. The voter registration database and the front-end programs use oracle products. The in-house voter registration database is in-sync with the statewide system (Florida Voter Registration System, FVRS). Any changes in the Florida legislation should reflect in the county’s system immediately. The OCSOE is very progressive in the use of technology to make voting as quick as possible at different steps of the process

Responsibilities:

• Database Administration
• Upgraded the Oracle 8 database to the latest 11g as per the upgrade path
• Upgraded the Oracle 6i forms to the Oracle 11g Application Server environment
• Acted as the interface between the voter services department and the information services department to design and implement new systems or changes to the existing system
• Acted as the interface between the state and the county for implementing changes and design new data transfer protocols
• Compared various high availability options (RAC, Data-Guard, Oracle Advance Replication, Oracle Streams, Sharepelx) available in the market and implemented Shareplex replication system to have two in-sync databases servers separated physically
• Performed daily backup operations for the database and the forms and reports files
• Optimized queries and tuned the performance of the database
• Monitored the database(s) performance during high peak times (such as during county-wide elections)
• Design and development of the front end screens and menus as per the requirements
• Design and development of a security system which is enforced on the screens and menus
• Design and development of advanced report customizing tools and the reports
• Participated in code reviews as well as in meetings to discuss software solutions and development issues
• Technical documentation and user documentation

Confidential,Florida August 2003- December 2006
Title: Research Associate
Relevant Project: Monte-Carlo Simulations of comet jets in IDL; Data Reduction and analysis of scientific CCD data
Environment: Fedora-core 8.0, IDL, Python, IRAF, perl scripting

Confidential,Greenbelt, Maryland April 2001-July 2002
Title: Programmer/Developer
Project: Motor Vehicle Management System (MVMS), Department of Treasury, Washington D.C.
Environment: Oracle 9i, 10g, Forms 6i, Reports 6i, TOAD, PL/SQL Navigator, PL/SQL, Windows 2000 Advanced Server, UNIX

Office of Asset Management, Department of Treasury needed to import the motor vehicle information from USSS, TIGTA, IRS, USCIS and ATF into their database. MVMS enables them to validate and import data from text files. The database is optimized for efficient reporting and hence providing information for monitoring, cost control, and budgeting.

MVMS acquires data from different files on a monthly basis from the different departments and stores in the database and generates various reports as needed. A very tight security module is also integrated in the system.
Responsibilities:

• Database Design
• Developing PL/SQL Procedures and Functions
• Worked with PL/SQL REF cursors
• Design and development of all the front end screens and menus
• Contracting out the reporting module
• Overall reduction of manual input by implementing automated processes
• Design and development of a security system which is enforced on the screens and menus
• Design and development of advanced report customizing tools and the reports
• Participated in code reviews as well as in meetings to discuss software solutions and development issues
• Technical documentation and user documentation

Confidential,India October 1998-April 2001
Title: Programmer/Developer
Project: Team ERP
Environment: Oracle 8 Enterprise, SQL Navigator 4, PL/SQL, Windows 2000 Advanced Server, Forms 5, Reports 5

This is an ERP package product for Indian industries tailored to meet Indian taxation and other industrial regulations.
The product is a watered down version of oracle EBS in functionality.

The package includes the following modules:

• Materials and Inventory Management
• Production Management
• Finance and Costing Management (Accounting)
• Human Resource Management and Payroll
• Multi-level Security Module
• Reports for each modules

Responsibilities:

• Database Design
• Involved in creating the user interface, writing the business logic component and writing stored procedures
• Managed a group of 10 individuals for 1 year for development of different modules
• Participated in code reviews as well as in meetings to discuss software solutions, development issues, and testing

Education

Doctor of Philosophy (PhD) in Astronomy

Masters Degree (Masters of Science) in Physics
Bachelors Degree (Bachelors of Technology) in Mechanical Engineering

Other Courses

Oracle Application Server I – 2008 – Oracle Education, Reston, VA
Oracle Application Server II – 2008 – Oracle Education, Bridgewater, NJ