SUMMARY

14 years of extensive experience in end - to-end software developmentweb applications and database administrationEducation

TECHNICAL SKILLS

Operating Systems: Windows, Red-Hat Linux, Unix Solaris

Databases: Oracle 7/8/8i/9i/10g,11g, Sybase, MySQL, SQL Server 6.5/7.0, MS Access, PostgreSQL, PostGIS

Languages: PL/SQL, Java, C++, PHP, VBScript, Pascal, SQL, SQL*Plus, some SPIM

Software: Oracle Developer/2000 (Forms, Reports, Graphics), Oracle Forms 6i, 9i, 10g, Oracle Reports 6i, 9i, 10g, Oracle 10g Enterprise Manager (OEM) Grid Control, NetBeans 4.1 IDE, Eclipse, WebLogic, ERwin Data Modeler, Oracle SQLDeveloper, Toad, PowerBuilder 6.5, MS Visual Studio 2005, MS Visual Studio 2008, MS Visual InterDev 6.0, Oracle JDeveloper, Borland JBuilder 3&4, MS Word, MS Visio, ESRI ArcGIS, ArcMap, GPSMapEdit, Subversion, OpenOffice, VMWare

Graphics: Macromedia Flash 5, MS PowerPoint, QuarkXPress, Paint Shop Pro, Adobe Photoshop, AutoCAD 12-14, MS Visio, ESRI ArcGis, ArcMap, GPSMapEdit, Garmin Mapsource

Web Technologies: Hibernate, Spring, Seam, Ant, JSP (Java Server Pages), Servlets, MVC, J2EE, XML, Apache HTTP Server, Apache Tomcat, PHP, CSS (Cascading Style Sheets), GeoServer, MapServer, Open Layers, Tilecache, HTML, JavaScript, VBScript, ASP (Active Server Pages)

PROFESSIONAL EXPERIENCE

Confidential, VR

Oracle PL/SQL Developer & Database Administrator

Responsibilities:

• Maintaining round-the-clock availability of databases in development, testing and production environments
• Managing a replicated standby production database using Oracle DataGuard for quick recovery in case of database or network crash
• Ensuring daily database backups of data and logs are performed, using Oracle Recovery Manager (RMAN)
• Using Oracle Enterprise Manager (OEM) Grid Control for monitoring and ensuring database connectivity and availability at all times for both developers and end users
• Providing database flashback mechanisms to enable developers conduct repeated unit and system testing
• Monitoring and administration of database space requirements, increasing flash recovery space as needed, or altering tablespaces and creating data files
• Recreating development and testing databases as needed, using RMAN and a backup copy of production database
• Designing and prescribing the most efficient scripting standards for the project and guiding junior PL/SQL developers to conform to these coding standards to ensure maintainability, uniformity, code reuse and fewer bugs
• Writing advanced PL/SQL scripts in the form of stored procedures, packages, functions
• Troubleshooting issues arising from customer bug reports
• Providing technical support to end-users

Confidential, CA

Software Development Analyst

Responsibilities:

• Rapid prototype development of parts of the application in J2EE with Spring MVC, Hibernate, Eclipse, JUnit, Ant, XML, JSP, Servlets, HTML, CSS, and deployed on Apache Tomcat.
• Analysed legacy back-end code (PL/SQL) and redesigned various parts to support the web implementation.
• Employed an agile programming and development process (XP, AMDD) to ensure quick prototype delivery.
• Prepared project architecture to employ Spring MVC pattern.
• Developed JUnit test classes.
• Documented software design process using UML diagrams where necessary.
• Assisted in maintaining legacy Oracle Forms and Reports application development.
• Conducted user requirement analyses, database architecture, software architecture, user interface design and implementation, troubleshooting and maintenance of existing systems.
• Database and user interface development using PL/SQL, SQL*Plus, Forms and Reports.
• Introduced audit logging into the application by writing database triggers and packages in PL/SQL
• Developed automated SMTP email notifications in database using PL/SQL.
• Implemented Oracle row-level security with contexts, stored procedures, database level triggers and Oracle’s DBMS RLS package.
• Database object administration using Toad.
• Duties involve implementing PL/SQL packages, procedures, functions, triggers.

Confidential, Haymarket, VA

Co-Founder & GIS Application Developer

Responsibilities:

• Duties involve implementing PL/SQL packages, procedures, functions, triggers.
• Mobilized and trained field personnel in collection of GIS data in Ghana.
• Used batch files, PHP, PostGIS, PostgreSQL to perform ETL on field data.
• Digitized maps using ESRI ArcMap, ArcGIS, ArcCatalog
• Compiled Garmin-compatible personal navigation maps using GPSMapEdit and custom programs written in PHP.
• Worked on a team to develop web version of the routable map, search engine, and vehicle tracking using PHP, Javascript, XML, AJAX, HTML, CSS.

Confidential , Washington, DC

Senior Oracle & Java Developer

Responsibilities:

• Worked with software engineering team to design an ETL (extract, transform, load) application to automate source file loads into the database using various mechanisms such as Oracle SQL*Loader, Java classes, scheduled jobs. Source files were in the form of live traffic and associated flight data derived from radars, the Enhanced Traffic Management System (ETMS), and other pertinent databases.
• Developed the ETL application on Oracle RDBMS, in the back-end, and Java Servlets and JSP for the user interface.
• Built entire database for ETL application consisting of tables, views, PL/SQL packages, functions, procedures.
• Developed DBMS SCHEDULER jobs in the database to schedule database transactions such as overnight data loads and output file generation.
• Implemented and configured Quartz Scheduler, an open source Java-based scheduler, to automate data loads and log-file management.
• Built automated SMTP email notification in the database.
• Wrote stored procedures using Oracle Spatial for storage, retrieval, update, and query of spatial features.
• Programmed query algorithms that cross-reference visual target information with security pertinent data for comprehensive reporting to support situational-awareness.
• Analyzed new user requirements on a day-to-day basis, enhance and maintain existing applications.
• Performed database administration (DBA) tasks such as backups, export/import, maintenance of schemas, user accounts, and database objects using Oracle Grid Control.
• Assisted regularly in troubleshooting of web servers, database servers, connectivity issues.

Confidential, Arlington, VA

Senior Oracle Designer/Developer

Responsibilities:

• Built automated SMTP email notification in the database.
• Redesigned architecture of application and moved all database interaction code from front-end into the back-end resulting in much lighter front-end Forms, faster user navigation, better error-handling and a more robust application
• Wrote database stored procedures, functions, table triggers and packages
• Introduced audit logging into the application by writing database triggers and packages in PL/SQL
• Developed automated SMTP email notifications in database using PL/SQL
• Reduced application processing time by implementing Oracle Advanced Queuing (DBMS AQ) between database transactions and email server to decouple email initiation from the SMTP relays
• Wrote PL/SQL procedures to employ DBMS JOB built-in package for transaction scheduling
• Designed user interfaces and reports using Oracle Forms and Reports
• Administered user accounts, database access and security using Oracle Enterprise Manager
• Responded to user help calls, conducted trainings, and product demos to new clients and current users
• Designed, wrote and edited training manuals for the application users
• Conducted performance-tuning of database code and SQL queries
• Performed data modeling and reverse engineering to produce ER diagrams (ERwin Data Modeler)
• Used PL/SQL to create custom object libraries and PL/SQL libraries to modularize software components, ensure uniform GUI design standards and encourage code re-use
• Utilized Java Server Pages, HTML, Java, Javascript to develop servlets, Java beans and web user interfaces to convert the client/server application into a web application
• Migrated client/server Forms and Reports application to web on OracleAS 10g
• Assisted DBA in the installation and configuration of Oracle 10g Application Server infrastructure and middle tier on Sun Solaris 9
• Installed and configured Oracle Internet Directory (OID), Oracle Single Sign-on (SSO) on application server infrastructure
• Configured Reports Server to use Single Sign-on between Forms and Reports applications
• Deployed web-enabled Forms and Reports to Application Server to use Secure Socket Layer (SSL)
• Built portal pages using Oracle Portal 10g
• Used OID Self Service Console to manage and administer user accounts, RADs, and groups
• Managed certificates with OracleAS Certificate Authority (OCA)
• Used LDAP, OID command-line tools and Oracle Directory Manager (ODM) to manage OID data
• Supervised a team of developers on the Joint Personnel Adjudication System (xJPAS) Data Warehouse project
• Redesigned a Java web application to employ Model-View-Controller (MVC) pattern to produce reusable and more easily maintainable code
• Prepared software design documentation in Unified Modeling Language (UML) (including class diagrams, sequence diagrams, and component diagrams)
• Wrote Java classes, designed web pages using JSP, Servlets, HTML, Javascript, and XML

Confidential, Alexandria, VA

Director of Information Systems

Responsibilities:

• Worked on INFACTS database and front-end application, an inmate tracking MIS for Rhode Island Department of Corrections (RIDOC) using Oracle database, PL/SQL, SQL*Plus and PowerBuilder
• Renormalized the entire database to introduce a new primary key (incarceration number, instead of inmate ID) for tracking inmate records
• Performed regular backups of the database, routine recompilation and re-analyzing of data dictionary objects, and optimization of SQL code using Oracle Enterprise Manager
• Created and managed tables, views, triggers, packages, procedures, synonyms and all other data dictionary objects using SQL*Plus and PL/SQL
• Wrote SQL scripts and project documentation in preparation for application deployment
• Used Oracle SQL Loader for loading data from ASCII files into databas