SUMMARY

• Results - focused, self-directed professional with more than 16 years of experience working with Oracle databases. Extensive experience in data analysis, database design, development of database-centered applications, performance tuning, maintenance and user support. Capitalizes on extensive background as both Oracle developer and Oracle DBA to design and implement highly functional, well-performing Oracle-based applications.
• Record of successful project implementation and experience throughout the software development life cycle from working with stakeholders on documenting requirements to designing solutions and writing code to testing, debugging, and implementation.
• Has in-depth understanding of designing and creating relational databases.
• Utilizes excellent, hands-on knowledge of SQL and PL/SQL to write complex, well-organized and well-performing code.
• Specializes in quickly identifying problems with existing code and designing/implementing cost-effective solutions that significantly improve response time, avoid downtime, and enhance overall performance.
• Life-long learner who actively investigates, quickly learns, and successfully applies new technologies.
• Works well independently or in a team setting, drawing on interpersonal skills to drive project objectives, promote client satisfaction, and ensure team success.

TECHNICAL SKILLS

RDBMs, DW SQL ENGINES: Oracle 12c/11g (Exadata), Oracle10g/9i/8i, PostgreSQL, Apache Impala, Apache Hive

OS, FS : UNIX (Sun Solaris, Oracle Solaris), Linux (RedHat Enterprise), Windows NT/7 Professional, HDFS, Amazon S3

Software : Quest SQL Navigator, PL/SQL Developer, SQL Developer, SQL*Plus, SQL*Loader, Oracle Developer Suite, Oracle OEM, Apache Hue, Beeline, Impala Shell, CA ERwin Data Modeler, Java 2 SDK, JBuilder, BEA Weblogic AS, VanDyke SecureCRT languages : SQL, PL/SQL, HiveQL, UNIX shell (Korn, Bourne), HDFS shell, Java, J2EE (EJB, JDBC, JSP), Pro*C

PROFESSIONAL EXPERIENCE

SOFTWARE Developer

Confidential

Responsibilities:

• Redesigned the existing database to incorporate new application modules and ensure data integrity (logical and physical data modeling).
• Merged a legacy application into the new enhanced financial system: created new database objects, implemented additional functionality through PL/SQL packages and performed complex data conversion.
• Wrote SQL scripts to create or modify various schema objects: tables, indexes, views, materialized views, sequences.
• Created, tested and tuned complex SQL scripts (queries, DML statements).
• Implemented business logic through PL/SQL packages, stored procedures, functions and triggers. Utilized cursors, referential cursors, user-defined types, records, collections, bulk processing (BULK COLLECT, FORALL), pipelined table functions, dynamic SQL and PL/SQL built-in packages.
• Created a library of views combining data from OLTP and Data Warehouse tables for sales/account managers and data analysts.
• Tuned SQL queries and PL/SQL code for optimal performance; in many cases, achieved a significant performance improvment.
• Created multiple PL/SQL packages supporing data extraction and loading processes.
• Created multiple UNIX shell scripts for data migration and batch processing.
• Ensured data integrity through referential integrity constraints and database triggers.
• Implemented auditing for all application tables.
• Wrote technical documentation for the new version of the application.

Oracle developer

Confidential

Responsibilities:

• Participated in all stages of application development life cycle: analysis, design, development, testing and implementation.
• Worked directly with case managers to determine requirements for the new module and translated them into technical specifications.
• Assisted with redesign of existing Case Manager database; designed new schema to hold database objects for HRMS application.
• Wrote SQL (DDL) scripts to create multiple schema objects; created and tested complex SQL scripts (queries, DML statements).
• Implemented business logic through PL/SQL packages.
• Tuned SQL statements and PL/SQL code for optimal performance.
• Assisted with migration of TeleHealth database from SQL Server to Oracle; supported its integration into HRMS system by creating PL/SQL packages that prepared data for hospitalization risk analysis.
• Developed PL/SQL packages critical to application’s main feature; designed algorithm that analyzes factors contributing to hospitalization risk, calculates patient’s risk score, and automatically generates the appropriate care protocol. Created database triggers that performed cascade updates when patient’s hospitalization risk score was updated.
• Wrote PL/SQL code for medication management module that performs multilevel analysis of patient’s medication list using data from 3 Oracle databases utilizing materialized views.
• Implemented business logic for the Intensive Case Management module that helps the agency provide comprehensive care to at-risk patients and for the Care Transition module that generated special care protocols to reduce hospital re-admission rates.

Oracle Developer

Confidential

Responsibilities:

• Functioned as an Oracle developer and, later, as an Oracle database administrator, overseeing all aspects of asset life cycle and managing numerous database/application migrations, upgrades, patch applications, and performance optimization.
• Participated in full project life cycle of Affiliate Enterprise Management System (AEMS). The system was based on PL/SQL packages and EJB deployed to BEA WebLogic AS. It was accessing data stored in multiple Oracle databases via JDBC connections.
• Designed (logical and physical design) and implemented three Oracle databases - dbUsers, dbSRM, and dbASM.
• Authored SQL (DDL) scripts that created schema objects such as tables, indexes, views, materialized views, sequences.
• Implemented complex business logic through PL/SQL packages, stored procedures, functions and triggers.
• Developed multiple Java server-side application modules (Session and Entity EJB as well as utility packages).
• Improved performance and enhanced reporting capabilities of the mission-critical AdManager/DART Enterprise application.
• Oversaw migration of AdServer DB, the main production database, from MS SQL Server to Oracle.
• Performed database and application performance tuning.
• Set up a standby database, implementing Oracle Data Guard.
• Automated some of the maintenance and reporting functions by creating a library of UNIX shell and SQL scripts.
• Performed daily administration tasks for multiple databases, including monitoring database performance, performance tuning, implementing backup procedures, checking alert logs, monitoring log processing, and adding new data files as needed.
• Created multiple on-demand reports for management, accounting and campaign operations.
• Served as mentor for 4 developers, providing training on SQL and PL/SQL.