OBJECTIVE:

Enterprise Application Developer / Designer / Architect. Seeking a position requiring broad and deep knowledge of object - oriented and functional programming, expert database design, performance diagnostics and tuning, technical writing/editing, speaking and leadership skills, to implement high-performance enterprise information systems at the lowest possible development and maintenance cost.

SUMMARY:

• Technical Leadership
• Oracle Certified Professional Java SE 8 Programmer
• Versatile programmer in Object-oriented and functional programming: Java, JEE, Servlets, Spring Boot, JSON, JSP, XML, JDBC, ORM, HTML forms, CSS, Javascript, Apache Tomcat
• Lead Oracle Database designer, developer, SQL and PL/SQL programmer and performance tuner
• Author of 2012 book ‘Java Web Database Application Development’
• (see: JavaWebDB.Wordpress.com)
• Reviewer of code prior to production deployment
• Trainer and mentor of junior associates
• Technical interviewer
• Security administrator
• Author of multiple Java- and PL/SQL-based database application utilities and frameworks:
• Automated generator of standard DB CRUD API packages
• Relational database schema browser, persistence engine, prototyping and design validation tool.

WORK HISTORY / EXPERIENCE:

Confidential

Technical Consultant

Responsibilities:

• Training, tutoring and small project consulting in Oracle database and Java application development and performance tuning.
• Oracle database design, PL/SQL programming, Java SE, JEE, Servlets, Spring, JSON, JSP, XML, Tomcat, JDBC, HTML, AWR, wait event diagnosis.

Confidential

Oracle Database Specialist / PLSQL Programmer

Responsibilities:

• Debug backlog of technical support tickets.
• Trace processing from UNIX shell scripts, O/S files to PL/SQL stored procedures, staging tables to application tables.
• Recommend techniques for improvement of performance of long-running batch jobs.
• Enhance documentation of complex processes.

Confidential

Contractor

Responsibilities:

• Lead Design and Code review for Oracle databases and SQL and PL/SQL artifacts across the Mortgage division.
• Develop Java web database applications for internal project management systems.
• Review, configure and approve rules to be utilized in automated code review tools.
• Monitor, tune and troubleshoot Oracle 11g and 12c/Exadata database and data warehouse query performance utilizing Automated Workload Repository (AWR) snapshots, EXPLAIN PLAN/SQL execution plan) data access and join methods, indexing and partitioning strategies, Automated Database Diagnostic Monitor (ADDM), wait event and load metrics and ratios, Oracle Enterprise Manager (OEM), Autotrace, Toad, etc.
• Compose strategic documentation manuals on design and coding standards, performance tuning diagnostics, case studies, frequently encountered issues.
• Consult and troubleshoot production database emergencies.
• Develop Testing/QA strategy and plans for Data Virtualization and Data Warehouse project on a platform of Oracle and Cisco Composite, in context of Agile project methodology.
• Present webinar conferences on technical design concepts and methodologies, metadata-driven code generation, specialty tools.

Confidential

Senior Systems Engineer

Responsibilities:

• Administer security for Hyperion Planning financial Essbase dimensional database system; groups, roles, users, dimension member access, filters, applications: Shared Services, Workspace, Essbase Administrative Services (EAS).
• Utilize proprietary Java-based Confidential - Confidential tool for Hyperion security administration.
• Reverse-engineer and document database schema and PL/SQL logic in Oracle Financial Services Applications (OFSA) to automate expense allocation forecasting.
• Write reports in Oracle Hyperion Financial Reports against Hyperion Essbase dimensional database.
• Develop Sharepoint applications for tracking defects in financial data migration project.
• Streamline integration of financial spreadsheets and eliminate manual data entry.
• Execute enterprise data system integration / Extraction Transformation and Loading (ETL) with UNIX shell scripts, Oracle SQL*Loader, Oracle SQL and PL/SQL, Appworx.

Confidential

Java Web Database Application Development

Responsibilities:

• Step-by-step tutorial and sample applications demonstrating how to stitch together SQL, JDBC, JNDI, connection pooling, web/application servers, Java Server Pages (JSP) / Servlets, Javabeans, XML, HTML, Javascript and CSS to develop database functionality.

Confidential

Vice President, Database Administration / Development

Responsibilities:

• Lead database development for NexOS/iOriginate mortgage loan origination system project from inception through production deployment to maintenance.
• Lead teams of database developer/DBAs at multiple office locations within and outside the United States; Oracle PL/SQL and logical/physical database design with Embarcadero ER/Studio, Quest Toad, Unix shell scripts, Perl scripts, Java, C#, ASP, .Net etc.
• Conduct interviews, train/mentor and supervise new team members, subordinates and junior colleagues.
• Develop, publish and enforce database design and PL/SQL coding standards and best practices, naming conventions, etc.
• Utilize proprietary Java-based Confidential - Confidential tool for development team management.
• Design, implement and maintain PL/SQL code generation systems for high-performance, high-productivity database application programming interface (API) in a high-volume Oracle 10g Real Application Clusters (RAC) environment with replication via Oracle Streams.
• Develop and implement strategies for high-availability, 24/7/365 operations with minimal downtime.
• Design and supervise development of internal subsystems for database application performance monitoring, purging obsolete data, and track multiple database SDLC environments, applications, schemas, and release/build status.
• Write detailed documentation of database API specifications and case studies/training materials for several distinct specialized applications.
• Develop and deliver of training seminars on database design principles, relational key design strategies, design patterns, active/passive enforcement of complex business rules, performance optimization etc.
• Design and implement formal Code Review protocol, recording and reporting system and act as lead code reviewer for all database change builds.

Confidential

Database Developer / DBA

Responsibilities:

• Database design with Computer Associates (CA) ERwin.
• Data warehouse design and maintenance; Fact tables, conformed dimensions; Stored procedures, SQL DML, DDL, DCL; Extraction, Transformation and Loading (ETL).
• Database programming in Oracle SQL, PL/SQL (using Quest TOAD), SQL*Loader, stored procedures etc. to optimize interfaces among multiple corporate systems.
• Performance tuning of batch processes, reducing execution time by up to 95%.
• Project management for new warehouse reporting initiatives; requirements analysis, definition of tasks, scheduling of resources, management of dependencies.

Confidential

Database Architect, Administrator and Application Developer

Responsibilities:

• Database design with ER/Studio and Oracle Designer.
• Design and develop Java Data Cache Object (‘ Confidential ’) and reference-version UI known as ‘ Confidential ’:
• General-purpose relational database schema browser, application prototyping system and object-relational persistence engine.

Confidential

Responsibilities:

• Manage multi-developer application configuration of database designs and code modules with Oracle Designer (formerly Designer 2000).
• Oversee development of barcode labeling system for pharmaceutical clinical trials; Lead team of Oracle and Java developers in offshore development operational model.
• Troubleshooting Oracle Forms & stored procedures, Java applications, and Zebra and Printronix printers in a Citrix Metaframe-centered application architecture.
• Manage multiple concurrent production and development product versions.
• Implement internationalization of application, supporting Western and Eastern European languages, Hebrew and Arabic right-to-left scripts, and Asian (Chinese, Japanese, Korean) pictographs, implemented in Unicode on Windows 2000, UTF-8 character set in Oracle, with some parts backward-compatible with 16-bit DOS.
• Develop web application development framework compatible with J2EE standards, with emphasis on Oracle, Java Servlets, Enterprise Java Beans (EJB) and JDBC technology.
• Implement proof-of-concept object-oriented attribute inheritance and polymorphic entity relations in a relational database application.
• Enigma Digital / Clear Channel Communications. - November 2000 - October 2001
• Refine design and layout of data models specified in Oracle Designer and implemented in Oracle8i. Operational models use normalized entity-relation rules; data warehouse employs star schema dimensional modeling rules.
• Design, construct and test PL/SQL stored procedures for data manipulation, transaction and concurrency management, business object rules and user interface; automate the generation of the database transaction API.
• Automate generation of low-level Oracle PL/SQL API packages via metadata and standard coding patterns.
• Develop operational application modules using Oracle8i and Java Servlets.