SUMMARY:

• Passionate Oracle database developer with Agile mindset
• Over 20 years of continuous experience in analysis, design, and development of database applications using PL/SQL, T - SQL, SQL, SQL*Plus, SQL Navigator, SQL Developer, TOAD
• Experience in developing Functions, Procedures, Packages, DDL and DML Triggers, partitioned tables and indexes, sub-query factoring
• Experience in Cognos 8 BI Reports Authoring and Metadata modeling
• Experience in supporting Epic Clarity ETL daily operations
• Experience in gathering and evaluating requirements, data analysis, QA, database processes’ issues resolution, data extract and load processes

PROFESSIONAL EXPERIENCE:

ORACLE DATABASE DEVELOPER/ CLARITY ETL ADMINISTRATOR

Confidential, Renton, WA

Responsibilities:

• Administered multiple Clarity database schemas and security configurations to supportdata loads and reporting development
• Developed data cleansing, validation, and error processing routines to ensures data is loadedinto database correctly and completely
• Developed process to monitor data load from three environments into single target database
• Developed process to monitor ETL status of Clarity tables which will trigger reporting tables load upon all corresponding underlying data sources readiness
• Implemented process to send alerts about ETL and data load problems to mobile phone
• Developed process to compare results of parallel Clarity ETL during transitioning to new database server and new version of Oracle database
• Modified several ETL load processes as well as long running reports’ SQL in order to improve performance and meet SLA
• Developed and implemented process for creation of compound triggers to enablerow change tracking functionality for Clarity derived tables
• Monitored scheduled processes and fixed detected errors
• Provided assistance and knowledge sharing to report developers in PL/SQL and SQL areas
• 24x7 on call rotation for Clarity ETL support

SENIOR DATABASE DEVELOPER

Confidential, Redmond, WA

Responsibilities:

• Converted base ARMS functionality from Oracle to MySQL
• Developed MySQL functions, procedures, object’s upgrade routines
• Developed process to extract customer data from MySQL database into Json formatted fileto merge multiple data repositories
• Supported all stages of the application development lifecycle using PL/SQL and T-SQL
• Developed ETL processes to support Product Traceability application to lineage product fulfillment and final delivery to customer
• Developed data migration and ETL process from legacy Web Vitals (UC Davis) application to ARMS
• Developed data dictionary driven process to synchronize client database with master environment regardless of target (client) version
• Verified and tested programs logic and resolved issues discovered during UAT
• Participated in the overall systems testing and errors fixes during the implementation into production
• Performed limited DBA tasks (backup, restore, clone) in support of development, QA, and UAT environments
• Supported changes to database objects based on application requirements
• Created processes to generate and load sample data for full demonstration of various applications functionality

ORACLE PL/SQL DEVELOPER

Confidential, Seattle, WA

Responsibilities:

• Supported current and developed new functionalities for clinical data research, medical samples inventory, and medical samples flow using PL/SQL and Oracle Clinical
• Participated in weekly meetings with project’s managers to ensure compliance of technical design with business requirements
• Completed technical specifications of APEX application using Visio
• Implemented standard errors handling

ORACLE PL/SQL DEVELOPER

Confidential, Richardson, TX

Responsibilities:

• Supported back end data collection processes for Introscope - dashboard system
• Developed data collection processes to satisfy new requirements
• Re-engineered long running queries to improve performance as requested
• Completed code, unit tests, and technical documentation for Enabler, OMS, and CRM reports
• Proposed APEX as system for proof of concept and developed prototype of APEX reporting application including underlying database objects
• Provided subject matter expertise and help to other team members

ORACLE PL/SQL DEVELOPER

Confidential, Bellevue, WA

Responsibilities:

• Participated in development, unit, and system test of the processes to synchronize data in three independent Oracle databases that support MyBusiness application - Siebel online account management
• Developed Health Checks, participated in production support, defect tickets resolution, and data errors fixes
• Developed changes to the daily incremental ETL process to include selected elements on demand
• Proposed changes to one of the monthly data load processes and developed working prototype using partitioning to increase performance as it suggested by Oracle best practices
• Used Dynamic SQL in the developed code for on the run modifications of data and for other tasks
• Used SQL* Loader to move data from external files to Oracle database
• Worked on production call tickets to enhance performance of long running processes and other production issues

ORACLE PL/SQL DEVELOPER

Confidential, Bothell, WA

Responsibilities:

• Supported test environment for conversion projects by creating processes to load, modify, and verify data to be used by new application modules
• Worked on resolution of production software defect tickets, issues, and support of existing code and errors fixes according to specifications
• Developed process to compress archived tables which resulted in reduction of disk space consumption
• Re-engineered Data Mediation archive process using DBMS DATAPUMP, DBMS JOB, and DBMS SCHEDULER
• Streamlined and re-factored package for automated handling of adding/removing daily partitions by following best practices guidelines
• Wrote shell scripts and PL/SQL procedures to query and modify data in tables containing tens of millions of records per daily partition
• Developed data upgrade scripts

ORACLE PL/SQL DEVELOPER

Confidential, Seattle, WA

Responsibilities:

• Supported existing implementation of Capital Market Research Group Data Mart by handling multiple requests for ad hoc queries and analysis
• Developed PL/SQL procedures, functions, and triggers to query and modify data
• Created and maintained packages, views, partitioned tables and indexes, and performed other tasks as assigned
• Completed performance tuning of queries and procedures
• Performed basic database administration and maintenance tasks

Cognos REPORTS DEVELOPER/ORACLE PL/SQL DEVELOPER

Confidential, Rockville, MD

Responsibilities:

• Provided programming and business analysis support for the design, development, testing, and implementation of Operational Reports for a Washington State MMIS (Medicaid
• Management Information System) using Oracle 10g PL/SQL, TOAD, and Cognos tools Created packages, stored procedures, triggers, and functions during development of simulation process to mimic future production environment to be used for reports design Prepared functional and technical report requirement packages to be used by team leads during reports design sessions with their state counterparts

TECHNICAL CONSULT

Confidential, Needham, MA

Responsibilities:

• Customized and integrated the Windchill Project Data Management application for the Future Combat Systems program Confidential Boeing Developed and altered several functionalities per client s requests for application enhancements using JSP, Java, Java Script, and InfoEngine Installed and configured PTC software. Installed and configured requisite third party software (ORACLE, LDAP, Retrieval Ware, etc.) as applicable to the client s solutions

SENIOR CONSULTANT

Confidential, Fairfax, VA

Responsibilities:

• Proposed, designed and developed enhancements to Cognos data model, created stored procedures, functions, views; developed technical requirements, solutions, and reports during implementation of AMS Advantage ERP for Los Angeles County Contributed to overall continued standardization and consistency of approval processes and procedures by proposing, gathering business requirements, and developing automated Expense Report Approval Workflow Proposed solution, completed business analysis, and developed tool to provide disconnected option of recording and uploading expenses to traveling users who may not have regular access to the web in a cost effective, maintainable, and serviceable
• Identified functional requirements and developed Per Diem functionality in full compliance with GSA code Proposed solution, validated the design with key stakeholders through design reviews and developed Expense Adjustment Tool to initiate cost adjustments and balance CFS data with data held in XMS database Provided subject matter expertise for engineering solutions during implementation process Provided production support through problem analysis and resolution to correct deficiencies