Oracle and Database Developer

NAVEED SHEIKH - U.S. Citizen – Public Trust Security Clearance

Dallas-Fortworth, Texas, Ph: 443-***-****, ******.*********@*****.***

LinkedIn: https://www.linkedin.com/in/naveed-sheikh-8b1807131

Oracle SQL, PLSQL, Forms, EBS, APEX, ETL, OCI, Snowflake

Oracle Database PL/SQL Developer Pro - OCP click to verify

Oracle APEX Cloud Developer Pro click to verify

CSSLP Certified - ISC2 Cyber Security click to verify

AWS Certified Data Engineer - Pro click to verify

AWS Certified Solutions Architect - Pro click to verify

Salesforce Certified Tableau Data Analys click to verify

Snowflake Snowpro Core Certified click to verify

Microsoft Power BI Data Analyst click to verify

PROFESSIONAL SUMMARY

●15+ yrs experience with Oracle versions 9i, 10g, 11g and 12c, 19c in Windows and UNIX environment on-premise and in Cloud. Create, Modify, Maintain Control-M Jobs

●Oracle Certified Associate (OCA on 9i). Used advanced SQL / PL/SQL, working in AGILE methodology

●Created and Performance tune stored procedures, triggers, functions, snapshots, PL/SQL code

●Using snapshots and materialized views for better performance

●PL/SQL error handling and writing custom error codes using Named Exceptions

●Worked in very large databases (VLDB) of 20+ Terabytes - handling large datasets with Billions of rows

●ETL using SQL*Loader, Oracle Data Integrator (ELT) and AWS Glue

●Designed Star / Snowflake schema using dimensional modeling to extract data from various sources

●Migration of data into Oracle DataWarehouse from SQL, MySQL and Access databases.

●SQL*Loader import/export data and migration from flat files

●Proven skills to design and develop ETL interfaces, packages, scenarios, load plans, user functions, variables and sequences in ODI 12c to support batch and data integrations

●Analyzed business requirements and wrote high / detailed level technical designs with development estimates. SQL Reports and ETL on Manufacturing module of EBS (Oracle E-Business Suite 12.1)

●PL/SQL performance tuning using TKPROF, DBMS_PROFILER and EXPLAIN PLAN, PARTITIONING

●Created charts using Visio for PL/SQL objects like Functions, Triggers and Stored Procedures and their relationship with other database objects.

●Used data models for Normalization and de-normalization strategies.

●Created PL/SQL based API’s to support integration of Oracle Field Service

●Developed and Supported ASP, ASP .Net, PhP and XML interfaces with Oracle database in AWS cloud

●Scheduling batch jobs (batch processing) and other PL/SQL scripts using DBMS_SCHEDULAR

●Extensive experience with Unit Testing to UAT and various other test efforts in a data warehouse environment like data validation, data integrity, functional testing, integration testing and system testing. Providing L3 support on Production Oracle database

●Involved in Performance tuning of SQL queries using Hints, Indexing and Partitioning of tables.

●Extensive experience with use of Cursors and high-volume data using Bulk Collect, Bulk Load, TABLE Functions, Function Results Cache. Created Packaged procedures to send/receive emails.

●Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes

●Experience writing Procedures and Functions using Transact-SQL for MS SQL Server

●Experience with MS SQL Server 2008 - 2019, including SQL Server Management Studio

●Designed and Developed In-house Data Warehouse ELT process using ODI tool

●Designed and Developed Data Warehouse ETL using Informatica PowerCenter

●Development using PostgreSQL and PL/pgSQL in Postgres DB version 10.23 to 15.9

●Used pgAdmin to manage/develop in Postgres DB

•12+ years of Oracle APEX 5.0 till 22.2 and JavaScript development & implementation

•Having extensive expertise with DBA’s to implement RESTful API in APEX environments

EXPERIENCE

UnitedHealth Group - Minnetonka, MN / Remote Nov 2021 – Current

Oracle LEAD SQL, PL/SQL Developer, Oracle 12c, 19c EXADATA, Oracle Integration Cloud

●Wrote advanced SQL queries and PL/SQL on large Oracle 19c DB on RAC (Real Application Clusters) and EXADATA platforms.

●Work with highly complex backend systems with minimum documents and support.

●Worked with Table partitioning and Indexing strategies.

●Create, manage, and develop Oracle Advanced Queues.

●Fixed and automated Control-M Job with faulty Table triggers and scattered SQL/PLSQL scripts

●High transaction volume OLTP database with highway Toll Collection system

●Used GIT-Lab to manage versions of scripts, and JIRA and Confluence for tickets and knowledge base respectively.

●Used CI/CD tools and managing automated deployments and builds for databases.

●Used Docker Containers with Oracle PDB tools to develop code locally

●Wrote complex SQL queries and PL/SQL procedures and functions to extract data from various source tables and feeds.

●Used Explain and Execution plan for SQL tuning. Used AWR Reports analysis for application tuning

●Undertook Code Optimization and Performance Tuning of the new and existing application using Explain Plan, Hints, Indexing and Partitioning of tables. Moved code from UNIX Shell into Oracle Procedures and Packages

●Developed extensive PL/SQL packages involving Normal and Global Temp Tables.

●Used Bulk operations (FORALL, Bulk collect, Bulk Insert, Bulk Exception etc.) to load large data sets.

●Worked in Agile environment using JIRA and Bi-weekly sprints. Attending daily stand-up meetings

●Updated logic for Claims processing within a very large and complex Oracle Package to meet SLA

●Worked on UNIX Korn Shell scripts to optimize code and file management.

●Analyzed data quality and report the anomalies to business users using TOAD and SQL Developer

●Performed the uploading and downloading flat files from UNIX server using FTP

●Performing ETL, data validations, and writing PLSQL code to transform the data cleansing and then loading into the oracle database tables using ODI modules and interfaces

●Involved in extracting data from multiple heterogenous sources using ELT tools, map, validate, analyzed, and loaded it into ODI staging tables. All of this supported in PaaS and SaaS services based Oracle Application

●Migrated Oracle Warehouse Builder (OWB 10gR2) projects using ODI 12c. Create new ODI jobs using old OWB Metadata

●Developed ETL for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and various shell scripts

●Involved in designing ETL processes (Batch Jobs) involving large flat files containing 100 million records+ each

●Worked closely with release management to develop and execute Implementation Plan (I-Plan) for ETL jobs

●Debugging and Optimizing ANSI SQL code used in Oracle VBCS based Application

●Converting from ANSI SQL to Oracle SQL syntax. Creating reports using OTBI and BI Publisher in Oracle Integration Cloud

●Played a key role in the successful deployment and ongoing maintenance of Oracle Fusion Cloud HCM modules including Payroll, Benefits, OTL, Compensation, and Talent

●Created/customized BI Publisher reports, OTBI dashboards, and HCM extracts to support HR/Payroll reporting and analytics

●Utilized HCM Data Loader (HDL) and Fast Formulas for bulk data migration, payroll calculations, and benefit rules automation

●Built and maintained real-time and batch integrations using Oracle Integration Cloud (OIC) and SOAP/REST web services, ensuring seamless data flow across systems

●Customized Oracle Cloud applications using Page/Application Composer, and VBCS to align with business process needs

●Performed quarterly Oracle release impact assessment, regression testing, and authored technical documentation to ensure smooth upgrades and compliance

●Supported Legacy DataStage Jobs. Also Develop/Support DataStage 11.7 oracle jobs

●Used Control-M 8.0 to create and monitor UNIX shell script jobs

●Supported MS SQL Server 2012 backend and performed Schema and Query optimization for .Net front

●Used SQL Server Management Studio 2019 for Schema Object creation and monitor Database sessions/queries

●Used Eclipse IDE to Edit, Debug and Refactor JAVA front-end code

●Used Eclipse IDE to edit calls from JAVA code to Oracle API by modifying parameters and/or dynamic SQL query being sent to backend. Implemented PARAMETER sanitation in JAVA code by using Regular Expressions

●Worked on Healthcare Plans modification APIs within Oracle DB and assisted JAVA front-end Team in loading correct data

●Modified logic in Oracle packages for PBM (Pharmacy Benefit Management) module with CLAIMS Adjudication processing that was handled by JAVA mid-tier. Switched over from legacy Dataset RETURN using REF_CURSOR to NESTED TABLES

●Injected logic to improve eligible/ineligible criteria for CLAIMS Adjudication module by modifying all underlying structures, VIEWS, Tables, Procedures, etc.

●As a Certified Salesforce Tableau Data Analyst, identified, analyzed, and interpreted trends and patterns in complex datasets. Performed data cleansing and transformation to ensure data accuracy and integrity in Tableau workbooks

●Using Tableau Prep Builder, designed, developed, and maintained interactive dashboards and reports that visualize key business metrics providing clear insights, while connecting and extracting from multiple Data Sources

●Published data and content on in-house Tableau Server. Some for internal and some for external public users

●Collaborating with the data governance team to ensure data security and privacy policies are met for Tableau Reporting

●Loading Files into Oracle Database using PYTHON

oLoad CSV files into Oracle database using PowerShell scripts and SQL Loader

oProcess and transform data using Python scripts with Pandas, SQL Alchemy, and Oracle cx libraries

oLoad transformed data into Oracle database tables

●Loading Data from MS SQL Server to Oracle Database

oExtract data from MS SQL Server database using pyodbc library and transformed it using business logic

oLoad transformed data into Oracle database tables using SQL Alchemy and cx_Oracle libraries

●Claims Eligibility Determination

oLoad CSV files containing claims data into Oracle db and apply business logic to determine claims eligibility

oGenerate CSV reports based on eligibility determination using Python scripts

oUse Oracle database to store and manage claims data

oPharmacy Inventory System, involving third party Cardinal system to capture the automated sent

●Apex development: Theme creation, System security, Role management, third party usage of list values, etc.

●Used file processing of CLOB (datatype) file into oracle tables in APEX Forms

●Pharmacy module upgraded from Oracle Apex 5.1 to 22.2 involving Forms with multiple Regions/ Dynamic Action and Interactive Reports with Grouping and aggregation within each Dataset

●Helped transition to OCI to benefit from Autonomous Database simplified database management

●Used Oracle Analytics Cloud features within OCI for future forecasting reports with large Healthcare related Data sets and later integrate them with APEX interface

●Configured File and Block storage within OCI for the migrated instance and evaluate Application functionality/performance

●Create custom reports on Oracle HCM module using APEX for Employee Benefits Management

●On-Prem to Cloud Connection: Used Oracle Database Adapter feature in Oracle Integration Cloud (OIC) to connect Cloud based Oracle DB with On-Prem Oracle DB. It involved install/config of on-premises connectivity agent

●Configured Oracle Wallet SSL Certificate, ensuring secure connection/authentication between the OIC (On-Prem to Cloud)

●Oracle EBS upgrade process to 12.2.15 and modified Forms for additional functionality. Oracle APEX integration with EBS and built APEX Interactive Reports/Grids for PBM (Pharmaceutical Benefits Management) functionality

●Setup AWS Architecture for High Transactions Load Balancing

●Worked on Snowflake Procedures and Snowpipe ETL ingestion from SFTP and ORDS sources into Snowflake

●Configured Snowpipe Auto Ingest using Event Notification on Amazon AWS SQS on S3 storage

●Managed Virtual Warehouses for Snowflake and optimized queries for OLAP Reports

●Ingested structured and semi-structured data (JSON, Parquet, Avro) into Snowflake using COPY INTO and Snowpipe for automated continuous loading

●Integrated Snowflake with ETL/ELT tools such as dbt, Informatica, or Azure Data Factory for end-to-end data workflows

●Built easy-to-use dashboards and reports in Oracle Analytics Cloud (OAC) that helped business teams understand data

●Organized/cleansed raw data in Oracle Analytics Cloud so it was accurate, consistent, and ready for reporting

●Led end-to-end data modeling and semantic layer design in Oracle Analytics Cloud (OAC)

●Architected and optimized data preparation workflows using OAC Data Flows

●Designed and delivered executive-level dashboards and interactive visualizations in OAC, translating complex business requirements into intuitive reports

●Established best practices and standards for OAC dashboard development/data modeling while mentoring junior analysts

U.S. Department of Health and Human Services (GDIT) – Falls, Church, VA / Remote Jan 2020 – Nov 2021

Oracle LEAD SQL, PL/SQL Developer, Snowflake Developer (Public Trust Security Clearance)

●Worked on Healthcare database of U.S. Department of Health and Human Services project CMS Chronic Conditions Data Warehouse (CCW) https://www2.ccwdata.org/ through General Dynamics IT (GDIT)

●Help with migration of Data Warehouse from Oracle 12c to Snowflake cloud environment

●Design, develop and package for deployment data pipelines using PL/SQL in ETL capacity

●Built processes supporting data transformation, data structures, metadata, dependency, and workload management

●Serve as technical resource responsible for Oracle SQL development, writing complex queries using advanced PLSQL concepts and, review table structures, apply indexes where needed, performance tune SQL Queries

●Develop software components to support data enrichment and transformation in a high traffic transactional data and data warehouse environment

●Provide development estimates outlining business and technical risks.

●Develop and deploy software in an incremental process that is potentially shippable with each iteration

●Provide technical and business explanation and justification for architectural, design, and coding practices

●Execute comprehensive unit and integration test cases for developed solutions

●Regularly update technical and business teams as to plans, progress, and issues

●Plan, design, enforce, and audit policies and procedures that safeguard the integrity of and access to enterprise systems, files, and data elements. Development/maintenance and defect resolution of code

●Worked under Agile methodology and attended daily scrum to discuss accomplishments, plans and blockers

●Adherence to agile process and defined development standards including technical design specifications (TDS), code reviews, unit and integration testing

●Reverse Engineer COBOL code to Oracle PL/SQL procedures

●Created python scripts that ran nightly batch to extract data from oracle into Postgres DB

●Wrote API (Procedures/Functions) and Table Triggers in PL/pgSQL to facilitate front-end Web Developers

●Returned data to front-end from Postgres DB using refcursors

●Created Matillion transformation and orchestration jobs to ingest/transform data from Oracle/other sources into Snowflake

●Created and Monitored Matillion Jobs and troubleshoot the serialization/concurrency issues

Towel Specialties, Inc, (Manufacturing) - Rosedale, MD May 2014 – Dec 2019

Oracle EBS, SQL, PL/SQL, APEX Developer / Modeler, Oracle 10g, 11g, 12c

●Created/Enhanced application interface for order processing and customer approval in Classic ASP and integrated with TWILIO SMS notification system.

●Worked in Agile environment using JIRA and Bi-weekly sprints. Attending daily stand-up meetings

●Converted reports from Crystal Reports 9.0 to web-based format.

●Created XML SOAP module API’s to support implementation of http://promostandards.org B2B integration with distributors

●Created PL/SQL based API’s to support integration of Oracle Field Service to support inventory information for field Sales Reps and Shipping data for delivery personnel

●Data output to Mongo DB and NoSQL Database to support 3rd party app developer

●Switched Oracle SQL Loader CSV import to External Tables for enhanced performance

●Procedures for refining and inserting imported data into production tables.

●Created and managed shipping confirmation system via email using Oracle PL/SQL and DBMS_SCHEDULER, UTL_HTTP, UTL_MAIL package

●Performance tuning at backend PL/SQL objects and front-end application level.

●Designed data warehouse for storage of Orders, Customer, Shipping and Invoice information.

●Responsible for working closely with DBA for partitioning and parallelism.

●Created materialized views in Data Warehouse and scheduled them for batch refreshes.

●Created ASP 3.0 and ASP .Net web pages to interface with Oracle and AWS S3 bucket using AWS Cloud EC2

●Used Power BI Cloud based solution to connect with Oracle over ODBC and create Dashboard Reports

●Developed visually engaging Power BI dashboards for data visualization

●Infused interactivity into Power BI dashboards, enabling dynamic data exploration

●Create and manage data visualizations, dashboards, and reports on Power BI for monitoring key performance indicators (KPIs) like sales, inventory levels, and customer behavior

●Creating interactive and insightful dashboards and reports using Power BI Desktop to visualize key business metrics and trends, often leveraging DAX calculations for advanced analysis

●Created Materialized Views in Oracle to Performance Tune Power BI reports

●Wrote PL/SQL procedures to output to PERL and CURL scripts and vice versa consuming inputs from PERL and CURL scripts

●Created “Production Schedule” VIEWS based on tables in Manufacturing module of EBS (Oracle E-Business Suite 12.1)

●Wrote complex SQL Reports based on data in EBS Manufacturing module and worked with Crystal Reports Team

●ETL process to move data from Oracle E-Business Suite into relevant Data Marts

●Integrated EBS and Oracle Production Scheduling modules. Imported Prod. Data and modified Stored Procedures

●MS SQL SSIS, 2016 for ETL between SQL DB in shipping dept. and Oracle DB Warehouse

●Wrote procedures to EXPORT data from MS SQL server as CSV data, which was then consumed by Oracle DB

●Provide production support for APEX applications. Improve performance and response times of APEX pages and reports

●Create Apex pages, Master Detail Forms, Tabular forms, Apex Collections, Interactive reports, Grids, Dropdown, Charts etc

●Experience with APEX themes, templates, data upload tools, page application items and processes, forms, reports

●Write SQL queries and create PLSQL objects that are optimized for APEX

●Developed an Interface in Oracle Install base/Service Contract Modules to show the Warranty Information to the end users when the Serial Number is Returned for Repair or Replacement

●Developed Custom Interfaces for validating order lines received from Oracle Management Legacy system for the Install Base creation & Service contract request and processing the entitlement request for the order lines and creating service requests using Standard CSI, SRM & OKC Public API’s

●Integrated MES systems into existing Manufacturing ERP with Industry 4.0 standards for Embroidered products

●Oracle EBS Financials 12.2.7

oModified forms to accommodate for Custom Business fields

oBuilt custom reports within Oracle Reports and advanced level in Power BI

oBuilt and maintain connections between EBS Financials and other legacy accounting system (Peach Tree)

oCreated, configured and extended Oracle Workflow to automate internal Requisitions Approval processes

ICS-NETT (Bureau of Census), Suitland, MD (Secret Clearance) Apr 2012 – Mar 2014

PL/SQL Developer / Data Architecture

●Created/modified pl/sql procedures to fix user errors in production environments.

●Design ETL synch process for data mart.

●Designed and Developed In-house Data Warehouse ETL informatica applications and Data Warehouse Databases using Informatica Power Center 8.6

●Created knowledge transfer documentation to summarize the lessons learned.

●Work with testing team to execute test plans provided by other developers and provide test data. Provided L3 Oracle Database Support. Code Optimization and Performance Tuning of existing scheduled jobs.

●Validate nightly baseline pl/sql scripts prior to deployment in production environment.

●Parse and archive advanced ques into database tables and tagged it with relevant business attributes for reporting team to build data mining queries.

●Developed, modified, and reverse engineered Oracle Forms 11g to introduce new business Logic and modify some existing ones. Also updated relevant Oracle Reports accordingly

●Using Tableau Prep Builder, designed, developed, and maintained interactive dashboards and reports that visualize key business metrics providing clear insights, while connecting and extracting from multiple Data Sources

●Published data and content on in-house Tableau Server. Some for internal and some for external public users

Northrop Grumman, Falls Church, VA (Secret Clearance) July 2009 – Apr 2012

Informatica ETL and PL/SQL Developer / Optimizer for PLM+ AESIP Army Logistics Program

●Created procedures to interface with SAP XI/PI system from oracle-based data staging utility.

●Created partitioning for large tables to optimize performance.

●Used external tables to parse-in legacy data from proprietary Federal systems related to ARMY logistics support.

●Created mapping documents for data attributes.

●Reverse engineer legacy code into PL/SQL in the form of packaged procedures and functions.

●Create test plans to compare the output of Oracle based system vs. legacy system and debug for any logic mis-match.

●Created knowledge transfer documentation to explain logic behind major procedures.

●Run SQL Loader jobs to parse in files that come in monthly basis and debug any parsing issues.

●Work with SAP team to implement authenticated web service STOP / START procedures from within Oracle using DBMS_HTTP.

●Develop ETL workflows and mappings from Source Oracle DB to Target Oracle Warehouse using Informatica PowerCenter

●Created Technical design documents for ETL that were later used by Test Teams

●Tune and optimize ETL batch jobs ETL and troubleshooting in PROD

●Followed mapping standards set by the original Architects and documented them

●Created MTD, YTD and other comparative financial reports using BI Publisher on PeopleSoft Oracle DB Schema

●Integrated PeopleSoft with Oracle APEX Forms for supplemental functionality

Fannie Mae, Reston, VA Nov 2008 – July 2009

Sr. Code Analyst / PL/SQL Optimizer

●Issued Hotfix to the lower environments for urgent code optimization in Oracle Database 10g Release 2

●Tuned SQL and application and added Indexes as required for performance and involved in testing through test scripts and test plans. Modified/Rebuild views to utilize existing indexes.

●Converted long SQL statements into smaller procedures / SQL queries

●Undertook Code Optimization and Performance Tuning of the new and existing application using Explain Plan, Hints, Indexing and Partitioning of tables.

●Tested results of the SQL code from functional and performance point of view

●Logged performance issues into IBM ClearQuest and worked with original developers to understand code

●Validating code results for compliance with business rules

●Working with DBA to implement performance tuning code/objects

●Helped create a plan for migration into 10g database and its impact on current procedures and functions.

●Create and enforce Primary, Foreign, Surrogate keys onto existing data model.

●Evaluate existing tables for normalization and their impact on front end.

●Wrote procedures and anonymous blocks to rename indexes and move them to separate tablespace for performance tuning.

●Created MTD, YTD and other comparative financial reports using BI Publisher on People Soft Oracle DB Schema

●Integrated People Soft with Oracle APEX Forms for supplemental functionality

Health and Human Services (HHS), Washington, D.C Sep 2007 – Nov 2008

Sr. Oracle Developer

●Interacting with business users, gathering and analyzing requirements.

●Writing complex SQL queries and PL/SQL procedures to extract data from various source tables.

●Developed ETL’s for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and various shell scripts.

●Migrated the files and the Oracle data into the present system using SQL Loader.

●Designed Star and Snowflake schema using dimensional modeling to extract data from various source tables.

●Created PL/SQL packages, procedures, cursors and exception handling.

●Loading data from flat files into the database tables using SQL*Loader.

●Tuned SQL and application and added Indexes as required for performance and involved in testing through test scripts and test plans. Used Explain Plain, indexing and hints for performance tuning.

●Oracle capacity planning and data analysis for warehouse setup of the schema.

●Extracted data from excel sheets and other resources to convert data into the SQL tables.

●Performed database estimation to estimate the size for the building of data marts for various reporting needs.

●Worked with DBA’s to trace the bottlenecked queries on the Production server and did performance tuning.

●Create procedures and functions to parse and validate XML using DBMS_XMLSTORE package

●Back end data modeling to support new business logic for security clearance data that came in through XML files.

●Created new reports using Oracle Reports 10g for the new information coming in.

●Modified/consolidated existing reports to display the new information and provide one reports menu for all search criteria.

●Built appropriate indexes and modified queries to performance tune intensive reports.

Barclays Bank – Wilmington, DE Mar 2006 – Sep 2007

Oracle PLSQL / ETL Developer

●Created technical designs after analyzing database and business requirement documents

●Involved in designing ETL processes (Batch Jobs).

●Document program specs, system design, system test plan, unit design, unit test plans and test cases.

●Developed new features in PL/SQL packages based on tech design docs (Oracle 10g) using SQL Navigator as main development tool in EXADATA environment.

●Fixed issues in SQL or PL/SQL code, based on the information provided in Mercury Quality Center (ticket system)

●Analyzed and modified ETL procedures in DataStage 7.5 and monitored them for any failures

●Used WinCVS 2.0 for code management and version control

●Used Control-M 6.2 to create and monitor UNIX shell script jobs

●Worked closely with release management to develop and execute Implementation Plan (I-Plan) for ETL jobs

●Flowchart logic for file loading, staging, sourcing and final insertion into Data Mart Fact tables using dimension table lookups

●Created and modified PL/SQL packages, procedures and functions to incorporate new ETL logic for credit card transactions in my teams Data Mart.

●Replaced ETL jobs/procedures in DataStage with PL/SQL packages and UNIX shell script jobs (Control-M job manager program)

●Used ERWIN to create STAR Schema with FACT and Dimension tables and creating data dictionary spreadsheets

●Created and modified PL/SQL packages, procedures and functions to incorporate new ETL logic for Financial transactions in my teams Data Mart

Social Security Administration (SSA), Baltimore, MD Oct 2005 – Mar 2006

Oracle Database Developer

●Recommend code improvements in PL/SQL code objects for future system upgrade

●Converted old cursor/loops and SQL calls in PL/SQL procedures to use VARRAYS and NESTED TABLES

●Performance tune existing procedures / functions

●Create new packages to return result sets back to Java interface using Toad as main development tool and returned dataset as SYS_REFCURSOR. Later defined CURSORS and converted from weak to strong CURSORS

●Worked closely with Java developer to create PL/SQL wrappers around Java Classes for file I/O

●Modified table structures and code to store documents as CLOB objects

●Wrote search functions to query the CLOB documents

●Developed encryption and decryption package using DBMS_CRYPTO.

●Rewrote old encryption packages that used DBMS_OBFUSCATION_TOOLKIT to DBMS_CRYPTO

U.S. Dept. of Justice, Washington D.C May 2004 – Aug 2005

Oracle PL/SQL and Oracle 6i Forms and Reports Developer – CDCS project

●Recreated/enhanced design for complex legacy forms after migration.

●Followed PL/SQL syntax standards for coding and used SQL Developer as main development tool.

●Used PLL libraries and object sub-classing for formatting standards.

●Wrote Functions, Procedures, Packages and Triggers at Oracle Forms level.

●Exception handling within oracle forms and trapping errors occurring at back-end level.

●Debugged existing forms 4.5 and modified them to incorporate new business requirements in forms 6i.

●Integrated WEBUTIL in forms for file uploading and processing of flat files and BLOB objects.

●Modified EJB for oracle forms time-out function and integrated with the AppServer

●Wrote PL/SQL cursors to improve performance for warehouse search functions in forms.

●Created reports with advanced grouping and layout formatting in Oracle Reports 10g.

●Created snapshots / analytical reports on Data Warehouse.

●Performed unit testing of front-end forms and reports with other team members to ensure smooth transition of changes into production. Also created Reports using Crystal Reports XI R2 11.5 in .rpts format

●Performance tune SQL code in procedures

EDUCATION

Oracle Certified

Contact this candidate