Summary :

• Oracle certified professional DBA with 12 years of solid experience in Information Technology.
• DBA skills include, but are not limited to Backups, DB Exports, Disaster recovery, upgrading to new version, creating test environment, migrating databases from one server to another, restoring and recovering databases and creating standby environments.
• Excellent programming expertise in web-based apps using PL/SQL gateway, HTML, Oracle PL/SQL, Oracle Fusion Middleware, ASP, JavaScript and VBScript.
• Microsoft Certified Professional in VB 5.0 and VB 6.0
• Extensive experience in developing reports using Oracle and Crystal
• Excellent communication skills and work ethics
• US Citizen. No visa sponsorship required

Technical Skills :

Languages: Oracle PL/SQL, Visual Basic 6.0, Visual Basic 5.0, SQL, HTML, VBScript, JavaScript
Environments: Windows 95, Windows 2000, Windows NT, Windows XP, Windows Vista
Databases: Oracle 9i, 10g, 11gR2, SQL Server, Sybase 4.0, Microsoft Access 2002
Other: SQL Navigator, Oracle Fusion Middleware specializing in Oracle 10g Report Builder and Oracle Discoverer 10g, ETL, Active Server Pages, ADO, COM, Seagate Crystal Reports, Active Reports, MS Office, MS Front Page, MS Visual Source Safe, Documentation of business requirements(Use Cases, Screen Mockups etc..)

Certifications :

Oracle 10g Certified Professional DBA July 2009
Oracle 9i PL/SQL April 2002
Microsoft Certified Professional (Visual Basic 6.0) August 1999
Microsoft Certified Professional (Visual Basic 5.0) October 1998

Professional Experience : (12 years)

Senior Consultant - Confidential, September 2001 - Current

Project 1 Description : A web-based Capital Program Information and Control System which is currently being used by The Chicago Department of Aviation for airport construction management
Skills Used : Oracle PL/SQL, Oracle 9i, 10g and 11gR2 Databases, HTML, JavaScript, Oracle Fusion Middleware specializing in Oracle 10g Report Builder and Oracle Discoverer 10g
Responsibilities :

• Installed, configured and upgraded Oracle Databases for development and production environments
• Established sound backup and recovery policies and procedures
• Installed, configured and upgraded Oracle Application Server 11g
• Identified, categorized and documented internal client requests through clear and well structured detailed business requirements and specifications (use cases, screen mockups etc...)
• Created tables, users, constraints, roles and indexes
• Performed database and application tuning and performance monitoring
• Refreshed the development database with live data periodically
• Designed and developed html pages for the user interface using Oracle PL/SQL gateway and javascript
• Wrote stored procedures , views, triggers and packages
• Extracted, transformed and loaded data from excel file into Oracle tables
• Developed reports using Oracle Reports Builder 10g
• Wrote queries in Oracle Discoverer 10g for adhoc reports
• Interfaced with Oracle Corporation for technical support
• Tested and debugged code.

Project 2 Description : A VB application which is currently being used by The Chicago Department of Aviation for airport construction management
Skills Used : Visual Basic 6.0, Oracle 9i, 10g and 11gR2 Databases,Middleware VB components(RDO), Crystal Reports 7.0, Crsytal Reports XI, Visual Source Safe

Project 3 Description : A VB application to be used by The Department of Aviation for document control. The application captures a scanned document, performs an OCR on it and stores the scanned files to the database which could later be retrieved by searching for the document using Oracle Intermedia
Skills Used : Visual Basic 6.0, Oracle 10g Database, Oracle Intermedia

Responsibilities (common to the above 2 projects) :

• Designed and developed Visual Basic Forms, Classes and Modules
• Developed dynamic link libraries
• Created and maintained reports using Crystal reports
• Wrote stored procedures, views, triggers and packages
• Extracted, transformed and loaded data from excel file into Oracle tables
• Created and maintained Setup.exe for installation of the program on user machines

Consultant - Confidential, September 2000 - March 2001

Project 1 Description : An online loan application to be used by M & I Mortgage customers to apply and get approval for home loans.
Skills Used : Visual Basic 6.0, HTML, ASP, VBScript,SQL Server,Middleware VB components(ADO), MTS
Responsibilities :

• Designed and developed middleware Visual Basic components
• Wrote stored procedures
• Developed ASP using VBScript and HTML
• Used MTS to manage database transactions
• Tested and debugged code.

Technical Consultant, Confidential, March 1999 - May 2000

Project 1 Description : An online catalog for Lawson products using which customers could view product details and place orders.
Skills Used : Visual Basic 6.0, HTML, ASP, VBScript,SQL Server,Middleware VB components
Responsibilities :

• Designed and developed middleware Visual Basic components using ADO
• Wrote stored procedures
• Developed ASP using VBScript and HTML

Project 2 Description : A Visual Basic application for Lawson that provided a complex pricing system for Lawson products based on several factors.
Skills Used : Visual Basic 6.0, Microsoft Access
Responsibilities :

• Designed and developed User Interface modules using Visual Basic 6.0
• Imported data into Excel form Microsoft Access
• Created dynamic Active Reports

Project 3 Description : A Visual Basic application that provided Cash Register Reconciliation for the ExperimentalAircraft Association.
Skills Used : Visual Basic 6.0, Microsoft SQL Server 7.0
Responsibilities :

• Designed and developed User Interface module using Visual Basic 6.0
• Designed and developed middleware Visual Basic components using ADO
• Wrote stored procedures
• Designed and created dynamic Active Reports

Consultant, Confidential, December 1998 - March 1999

Project 1 Description : A Bidding System for a Construction Company called Payne And Dollan that allowed them to place bids for construction projects to the state government.
Skills Used : Visual Basic 5.0, Crystal Reports, ADO, SQL Server, Watcom SQL
Responsibilities :

• Designed and created reports (using Seagate Crystal Reports) that can be called from Visual Basic 5.0
• Designed and developed classes using Visual Basic 5.0 and ADO to access data from SQL Server 6.5.

Software Engineer, Confidential,India August 1995 - February 1998

• Inventory System for a Manufacturing Company.

The inventory system was based on a Windows 95 platform and consisted of a Visual Basic 4.0 front-end and Microsoft Access back-end.
Skills Used : Visual Basic 4.0, Microsoft Access, SQL
Responsibilities:

• Designed and maintained database schema
• Designed and implemented the front-end using Visual Basic.
• Sales Order System for an Advertising Company

The system used Visual Basic 4.0 as the front-end and Sybase as the back-end. The application was built on a Windows 95 platform.
Skills Used : Visual Basic 4.0, Microsoft ODBC, SQL
Responsibilities:

• Designed and developed Visual Basic forms and modules.
• Used Microsoft ODBC and SQL to connect to the database and perform database operations.

Education :
Diploma in Computer Proficiency
Bachelor of Engineering