PROFESSIONAL SUMMARY:

• 23 years of experience as an Oracle Database Developer and 15 years of experience as an Oracle Database Administrator
• 7 years of experience with Oracle 11g and 5 year of experience with Oracle 12c
• 23 years of experience with PL/SQL, 5 years TSQL
• 23 years of experience developing Oracle packages, procedures, programming and data structures
• 21 years of experience conducting performance tuning with Oracle databases
• Multilingual Army Veteran

TECHNICAL SKILLS:

• PL/SQL
• Oracle DB
• UNIX Shell Scripting
• Oracle Enterprise Manager Grid Control
• Oracle Diagnostics Pack
• Oracle Performance Pack
• Oracle Forms
• Oracle Reports
• ADDM
• AWR
• ASH
• ERWin
• TOAD
• SQL*Net
• SQL*Plus
• SQL*Loader
• Navicat
• ER Studio
• Iron Speed
• SQL Server
• TSQL

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Developer/BI Specialist

Responsibilities:

• Oracle 12c, PL/SQL - Working with Procedures, Functions, Dynamic PL/SQL, Oracle built-in packages (DBMS SQL), Bulk Collection, PL/SQL and SQL Tuning
• SQL Server and TSQL
• Ad-Hoc reporting using Oracle BIEE, SQL Developer, SQL, Toad
• ETL and Data Warehouse process using PL/SQL and TSQL

Confidential

Senior Database Developer/BI Specialist

Responsibilities:

• Oracle 11g, PL/SQL - Working with Procedures, Functions, Dynamic PL/SQL, Oracle built-in packages (DBMS SQL), Bulk Collection, PL/SQL and SQL Tuning
• Ad-Hoc reporting using Oracle BIEE, SQL Developer, SQL
• ETL and Data Warehouse process using PL/SQL

Confidential

Senior Database Developer

Responsibilities:

• Part of the Migration team to move over 30 Oracle Database from legacy DB to AWS
• Migration of PL/SQL from 11g to 12c
• Creation and configuration of multiples Oracle DBs - 11g and 12c
• Recreation of DDL from 11g to 12c, roles and synonyms recreation by Dynamics SQL
• Integration of Linux with Oracle DBs environment
• Use of Datapump and PL/SQL for data migration

Confidential

Senior Database Developer

Responsibilities:

• Part of the Migration team as Oracle Database Developer for the Confidential - PRISM migration project
• Data Modeling, Data Migration and Data Conversion
• Oracle 11g, PL/SQL - Working with Procedures, Functions, Dynamic PL/SQL, Oracle built-in packages (DBMS SQL), Bulk Collection, PL/SQL and SQL Tuning
• Develop security and operation modulation capability to all database process
• Oracle DML and DDL
• Oracle DB Objects Documentation and business rule enforcement
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database
• Involved in creating Database Design (Physical and logical) as per the requirement given by the business
• Wrote custom database documentation and error handling modules for database
• Performed ongoing tuning of the database instances and SQL statements
• Used and developed ETL process for data extraction and data transformation

Confidential

Senior Database Developer

Responsibilities:

• Part of the analytical and developer team for Confidential & Confidential Saas projects
• Developed capacity and performance metrics as well as maintained, analyzed, and reported on a scheduled periodic basis to management on development progress
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database
• Involved in creating Database Design (Physical and logical) as per the requirement given by the business
• Created and implemented report modules from client’s database
• Wrote custom database documentation and error handling modules for database
• Performed ongoing tuning of the database instances and SQL statements
• Responsible for SQL Server (2014) database design and management in Microsoft Azure and Arvixe Cloud services
• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• Used IronSpeed and C# to develop web and cellular applications
• Used and developed ETL process for data extraction and transformation with MS SSIS
• Part of the Reporting team. Created reports and data presentations using MS SSRS and Telerik
• Worked creating Procedures, Functions, Dynamic PL/SQL, Oracle built-in packages (DBMS SQL), Bulk Collection, Oracle Global Temporary Tables, Oracle External Tables and SQL*Loader

Confidential

Database Developer/Migration Specialist

Responsibilities:

• Part of a Datamart project team as a database developer, data migration and data conversion specialist. This datamart was created for Cellular Apps access
• Improved the quality of customer support and delivered service request processing in an efficient and timely manner
• Responsible for Datamart development using Oracle NO/SQL database back-end
• Responsible for creating and modifying the PL/SQL (Bulk Collect, Dynamic PL/SQL and DBMS SQL) and SQL for procedures and functions according to business requirements
• Involved in creating Database Design (Physical and logical) as per the requirement given by business
• Performed ongoing tuning of the database instances and SQL statements
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
• Performed ongoing tuning of the database instances and SQL statements
• Modified database structures as required by developers due to business or application requirements, cloned development databases for testing and training
• Developed capacity and performance metrics as well as maintained, analyzed, and reported on a scheduled periodic basis to management on development progress
• Implemented Oracle External Tables and SQL*Loader script creation to load data into/from legacy system

Confidential

Database Developer

Responsibilities:

• For the Domestic Violence System - Recovered the Oracle Application Server and migrated from Linux to MS
• Rewrote, debugged and deployed enterprise applications using Oracle Forms and Oracle Reports. Wrote PL SQL statements, stored procedures and functions, following best practices regarding QA and implementation standards
• Migrated database from Oracle 10g-Linux to Oracle 11g-Microsoft using Transport table space TTS-export
• Involved in creating Database Design (Physical and logical) as per the requirement given by business
• Created procedures for custom updates for the Criminal Background Check System, improved database components, process re-engineering and improved business process
• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• For the Sexual Crimes Department system:
• Created full life-cycle application support and reporting by interviewing and surveying end-users to satisfy their needs
• Part of the Implementation team for a customized system in the Domestic Violence Department. My duties in this project were Database Developer and Data Modeler. The system database uses Oracle 10g in Linux Red Hat 5. The front end software was Oracle Form and the report tool was Oracle Report. Also, involved in analysis, design, coding and Testing
• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• Involved in creating Database Design (Physical and logical) as per the requirement given by business
• Involved in developing Oracle Reports which are further added to Web pages
• Set up backup and maintenance plans and trained employees on how to use the new system

Confidential

Business Intelligence Consultant

Responsibilities:

• Created full life-cycle application support and reporting by interviewing and surveying end-users to satisfy their needs
• Successfully installed and configured Oracle 11g on a Linux Server
• Successfully installed and configured Oracle BIEE
• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• Involved in creating Database Design (Physical and logical), data migration and data conversion as per the requirement given by business
• Responsible for creating and modifying the PL/SQL procedures and functions according to business requirements
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the legacy database to a Report Database Server
• Responsible for creating and modifying the PL/SQL (Bulk Collect, Dynamic PL/SQL and DBMS SQL) and SQL for procedures, functions according to the business requirement

Confidential

Developer Consultant

Responsibilities:

• Created full life-cycle application support and reporting by interviewing and surveying end-users to satisfy their needs
• Part of the Implementation team for a customized system in the Domestic Violence Department. Duties in this project were Database Developer and Data Modeler. The system database uses Oracle 10g in Linux Red Hat 5. The front end software was Oracle Form and the report tool was Oracle Report. Also, involved in analysis, design, coding and Testing
• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• Involved in creating Database Design (Physical and logical) data migration and data conversion as per the requirement given by business
• Involved in developing Oracle Reports which are further added to Web pages
• Provided Oracle DBA support, backup and restore, performance monitoring and tuning; Experience using Oracle Enterprise Manager (OEM) Grid Control
• Monitored database activity and file usage, and ensured necessary resources were present so that databases functioned properly, by removing or deleting old or obsolete files

Confidential

Database Developer Consultant

Responsibilities:

• Worked as Database Consultant providing services in different Confidential clients
• Successfully installed and configured Oracle RAC, ASM and non-RAC database on Microsoft, HP-UX, Linux, IBM-AIX and VMware; implemented data files using either ASM or on raw devices for some projects
• Provided physical and logical design and database creation for production, standby, and historic databases and DSS, loaded legacy data into the historic databases
• Modified database structures as required by developers due to business or application requirements, cloned development databases for testing and training. Extensive data migration and data conversion for multiple system
• Developed capacity and performance metrics as well as maintained, analyzed, and reported on a scheduled periodic basis to management on development progress
• Provided Oracle DBA support, backup and restore, performance monitoring and tuning; Experience using Oracle Enterprise Manager (OEM) Grid Control and OEM installations
• Responsible for creating and modifying the PL/SQL procedures and functions according to business requirements
• Installed and implemented Oracle Collaboration Suite
• Responsible for creating and modifying Oracle Portal and business intelligence using Oracle Discoverer

Confidential

Database Developer

Responsibilities:

• Multiples tasks doing Oracle DBA support, migrations, upgrades, performance tuning, and Enterprise Manager Grid Control implementation. Involved in Performance Tuning using ADDM (Automatic DB Diagnostic Monitor) which makes the diagnostic data readily available
• Shell scripting and programming in PL/SQL, CRON jobs for database operation, and database security

Confidential

Database Consultant/Migration Specialist

Responsibilities:

• Part of the migration team where I worked as Database Developer Data Migration and Data Conversion Specialist, created database objects, ETL process and programs for a data migration and data conversion between AS400 and Oracle
• Worked with Oracle Forms, Oracle Reports and Oracle Discoverer to create interfaces in AR and subscription modules. Use of Oracle OC4J to display forms and reports
• Database administration support, 8.x, 9.x, 10g
• Installed and maintained production, development and test databases using Oracle (9x-10g)
• Performed ongoing tuning of database instances and SQL statements
• Used Oracle Workflows tools for Back-end Insurance Underwriting System process and validations.
• Installed and implemented Oracle Collaboration Suite (SSL, email, workspace, etc.)
• Implemented and configured Oracle Portal to display business intelligence using Discoverer and portal dashboard tools
• Created and implemented data warehouse using Oracle Warehouse Builder
• Implemented ETL process with extensive PL/SQL and SQL coding - Dynamic PL/SQL, Oracle built-in packages
• Involved in creating Database Design (Physical and logical) as per the requirement given by business
• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views

Confidential

Independent Database Consultant/Migration Specialist

Responsibilities:

• Supported in the creation of database objects for Single billing system between PRTC and Confidential companies. Worked in the extraction of data using PL/SQL and shell scripts (UNIX) to load data from Oracle (AMDOCS) to the Mainframe billing system
• Administration of Discovery working areas
• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• Data Migration and Data Transformation Specialist for multiple extraction projects from Legacy System to Oracle DB
• Involved in extensive PL/SQL and SQL coding - Dynamic PL/SQL, Oracle built-in packages.
• Developed and upgraded data warehouse data load scripts for PRTC Facilities and trouble tickets system using PL/SQL and Discoverer 4

Confidential

Database Developer and Database Administrator

Responsibilities:

• Responsible for Oracle Database Administration tasks at Confidential Information System Division
• Duties included the monitoring of Oracle activities on over fifty database instances, along with a team of 8 other DBA’s. These databases resided on 10 UNIX servers and 4 NT servers
• Responsible for automating various processes with UNIX Shell scripts, configuring and automating databases for disaster recovery, and resolving database problems in a timely manner
• Additionally responsible for extensive documentation of all Oracle related activities, maintaining robust security, planning and implementing disaster recovery, ensuring optimal database performance, and effective communication with end-users
• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• Data Migration and Data Conversion Specialist for different extraction projects from Legacy System to Oracle DB
• Responsible for the creation of Procedures, Functions, Dynamic PL/SQL, Oracle built-in packages (DBMS SQL)
• Performed several Oracle Upgrades from 7.1 through 8.1.7
• Worked on OLTP optimization and facilitated the processing of large numbers of concurrent updates to a database
• Monitored database activity and file usage, and ensured necessary resources were present so that databases (DML) functioned properly, by removing or deleting old or obsolete files
• Coded complex views and queries for reporting and warehouse databases
• Set-up and managed database security by creating new users, roles, profiles, and provided required user privileges in development, test, training and production environments
• Performed ongoing tuning of the database instances and SQL statements
• Managed space utilization (tablespaces, datafiles, extents) by reducing fragmentation and compressing extents
• Developed PL/SQL code to support administrative functions (schema creation, security, migration, etc.)
• Offered business and technical solutions to client, in Oracle (7.x, 8.x, 8i) environments, as well as other client/server and WEB solutions
• Involved in creating Database Design (Physical and logical) as per the requirement given by business
• Responsible for the development and replication of data in various projects and database systems
• Involved in multiple Oracle installations using UNIX (AIX, Solaris), NT and Novell

Database Developer/Migration Specialist

Confidential

Responsibilities:

• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• Worked with Procedures, Functions, Dynamic PL/SQL, Oracle built-in packages
• Implemented bank security for different databases
• Migrated Oracle database for the Siebel CRM System from Tampa Bay to Puerto Rico
• Implemented backup and recovery procedures

Database Developer/Migration Specialist

Confidential

Responsibilities:

• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• Migration and Conversion of the main Database from Gupta to Oracle
• Worked with Procedures, Functions, Dynamic PL/SQL, Oracle built-in packages (DBMS SQL)
• Developed backup strategies and migration for new systems
• Oracle PL/SQL development and coding of complex queries for reporting
• Support developer’s team with queries, schema design, security implementation and database design

Database Developer

Confidential

Responsibilities:

• Created and modified Oracle database objects such as Tables, Packages, Procedures, Functions, Sequences, Indexes and Views
• Worked with Procedures, Functions, Dynamic PL/SQL, Oracle built-in packages (DBMS SQL)
• Implemented backup and recovery procedures
• Responsible for database tuning and performance
• Database support for LIMS system