Oracle Plsql Developer Resume

OBJECTIVE

My objective is to utilize my technical gifting within a fast-paced and challenging position.

PROFESSIONAL STRONG POINTS

• Focus driven work ethic
• Integrity
• Ability to learn and utilize new programming languages quickly
• Excellent communication skills
• Accomplish projects and tasks on or before deadline
• Motivated, efficient and driven to satisfy customer needs
• Work well alone and in a team setting

REVELENT ORACLE EXPERIENCE

Most of my experience is extensive programming in Oracle PL/SQL on a UNIX back-end. I have a strong talent and desire for data mining, creating complex PL/SQL packages, stored procedures, function, triggers and views and SQL queries.

TECHNICAL EXPERTISE

ORACLE PLSQL

• Created Packages, stored procedures, triggers and functions that query and manipulate data for data transfer.
• Created ETL programs in PL/SQL for Data Warehouses.
• Created PLSQL programs to update or insert data into another table, extracted and manipulate data, put into temp files or tables for later retrieval, display or loading into another database.
• Created support applications to monitor and email
• Created Packages, stored procedures, triggers and functions as hooks into external applications like ORACLE iLearning.
• Created Packages, stored procedures and functions as a back-end for web interfaces communicating with XML

ETL and Data Warehouse

• Created programs to manipulate data from the Oracle DBMS. Created scripts to create or manipulate flat files.
• Created programs that extracted and loaded Oracle data from one database into another.

Confidential

• Created dimension and fact tables
• Created ETL programs in PL/SQL to load and extract data in dimensional model Data Warehouses.
• Created cgi scripts for web applications to display data queried from the Oracle DBMS or other data manipulation.

SQL / SQL Plus

• Create ad-hoc queries from the command line to research problems, reporting or the creation of flat files.
• Created and edited programs to manipulate data from the Oracle DBMS. Created scripts to create or manipulate flat files.
• Created and edited programs that extracted and loaded Oracle data from one database into another.
• Created large-scale queries that use all types of joins.
• Created queries for date to be displayed on web pages.
• Created queries within shell scripts, perl and Pro-C programs that extract data from one database to be loaded to another.
• Created queries to display data or extract data from a database table to be loaded into another table
• Created cgi scripts for web applications to display data queried from the Oracle DBMS or other data manipulation.
• Used the C language to manipulate flat files

C .NET

• Created internal business applications that connect to external databases SQL Server and Oracle .
• All applications were created using the Visual Studio 2008/2010 Framework.

VB.NET

• Created internal business applications that connect to external databases SQL Server and Microsoft Access .
• All applications were created using the Visual Studio Framework.

Oracle Discoverer

• Created custom Discoverer reports for specific customer needs.

iReports

• Created custom crystal reports for specific customer needs.

Crystal Reports

• Created custom crystal reports for specific customer needs.

UNIX

• Created complex UNIX shell scripts using the vi editor

T-SQL

• Created stored procedures using Transact SQL for test systems and specific business needs.

HTML and JavaScript

• Created web pages for Xerox.com and Xerox internal use
• Used the Oracle features available for XML creation and output
• Used the Oracle features available to consume, parse and navigate through XML inputs as well as from external files
• Used the Oracle features available for pro-C insert command, update command, and sql features

ORACLE Database Administration

• Created schemas and users
• Created and dropped tables, external tables and views
• Modified columns in tables and views
• Created and manipulated tnsnames file
• Add and modify grants and permissions for users to tables and views and performance tuning

SQL Server Database Administration

• Created and dropped Databases
• Created and dropped tables and views
• Modified columns in tables and views
• Add and modify grants and permissions for users to tables and views and performance tuning

EXPERIENCE

Confidential

PL/SQL Data WarehouseDeveloper

Confidential is a major commercial insurance company headquartered in the Metro Detroit area. All the data from all of their applications are stored in one large data warehouse. Some of the main objectives of this position were to create ETL load packages using PL/SQL, extracting data from the data warehouse for external applications and creating queries for the BI systems.

• Designed and wrote complex PL/SQL packages, stored procedures, functions and triggers using Collections, Cursors, Ref Cursors, Bulk Collection and user-defined data types
• I gave technical guidance, advice and support to other members of the data warehousing team
• Responsible for DBA activities like creating Tables, Views, sequences, indexes and constraints
• foreign keys
• bitmap and b-tree indexes
• fact tables
• dimension tables
• I create dimensional model tables
• I develop ETL processes using PL/SQL
• Currently, I am a senior PL/SQL Warehouse developer.
• Optimized existing packages, stored procedures, functions and SQL queries
• Optimized queries by creating indexes and creative data gathering
• Involved in trouble shooting technical and data issues
• Tested and debugged PL/SQL code using the PLSQL Developer tool
• Created complex ad-hoc queries and reports
• Responsible for maintaining the code versions using source control systems like TCS.
• QA and Unit tested all modules
• Created and maintained technical documentation for projects and code modules
• Created and edited back-end batch scripts

Environment: Oracle 10g, SQL, PL/SQL, ETL, Batch command scripts, PL/SQL Developer, Tidal Services.

Senior Oracle Developer

Confidential receives packets of data containing meter reads, toner levels, error codes and other device data to aid the business, trouble shoot issues, send out equipment and bill the customer properly. The main objective of this position was to create a process that will take world-wide device connectivity data coming from Oracle, SQL Server, flat files and XML and then load, manipulate and normalize the data into a single Oracle data source.

• I was the Lead developer for the Machine Connectivity team hired to develop the major processing and reporting applications for worldwide connectivity data.
• Worked closely with cross functional teams, Business users to gather the functional specifications and preparing technical specifications, and involved in conceptual, Logical, Physical designs of the Database, review and validate software design documents.
• Responsible for DBA activities like creating Tables, Views, sequences, indexes and constraints
• Responsible for data mining and reporting for the business
• I gave technical guidance, advice and support to the Connectivity team
• Designed and wrote complex PL/SQL packages, stored procedures, functions and triggers using Collections, Cursors, Ref Cursors, Bulk Collection and user-defined data types
• Optimized existing packages, stored procedures, functions and SQL queries
• Optimized queries using Bulk Collect, Hints, Object types and Collection types
• Involved in trouble shooting technical and data issues
• Tested and debugged PL/SQL code using the PLSQL Developer tool
• Created complex ad-hoc queries and reports
• Created ORACLE External tables for large file parsing and manipulation
• Responsible for maintaining the code versions using source control systems like Subversion.
• Simplified SQL Loader processes by using External tables and then using procedures and functions to process and manipulate data.
• QA and Unit tested all modules
• Created and maintained technical documentation for projects and code modules
• Created and edited complex back-end, batch programs using UNIX Bash Shell scripting
• Developed Web applications and pages using HTML, CSS, XML, JavaScript, cgi Bash scripting , SQL and PL SQL
• Worked with web services to obtain data in SOAP

Environment: Oracle 10g, 11g, SQL, PL/SQL, UNIX Scripts, PL/SQL Developer, XML, SOAP Web Services, PuTTY, SFTP, Linux, Windows XP, SOX compliance, TTM, Apache Tomcat.

Confidential support:

• 3. Implement and manipulate the programs and processes for the Radiation Protection maps to keep the employees safe from radiation Dose.
• 2. Develop and support some of the Cyber Security assessment process
• 1. Develop a process to compile large amounts of data for the daily activities of the five nuclear reactors
• I was the Project Manager of the Nuclear Communications site http://www.cengllc.com
• I was the IT Lead for implementing major nuclear applications including
• Nuclear Plan of Day software that took documents from a SharePoint site, merged them together and automatically printed the documents to specified printers as well as emailed a DL
• Created and modified a C .Net Application development with iText PDF integration
• Optimize queries and mapping tables
• QA and Unit test all modules
• Trouble shoot all issues
• SQL Server database Administration
• SharePoint Administration
• Cyber Security assessment software and architecture
• Java tomcat server setup
• Created a C .NET web application to import and sanitize data.
• Created modules using groovy code
• SQL Server database creation and maintenance
• Legacy data transfers using TIBCO
• IIS Web server creation and Administration
• SQL Server database creation and customization
• Application packaging for automatic installation
• File share setup Active Directory permission driven sharing
• Visual Survey software for Radiation Protection to create surveys and maps of containment
• Created ORACLE views and stored procedures
• Report development using Crystal Reports and iReports
• IT Software and Server support

Environment: Oracle 10g, 11g, SQL, PL/SQL, C .NET, XML, SOAP Web Services, PuTTY, Jasper iReport, Windows XP, Apache Tomcat, Groovy.

US Airways

Confidential uses Oracle iLearning for all on-going education and training. All employees are required a certain amount of training and continuing education. My main function was to be the lead developer and bring the US Airways East and West together as well as Legacy data into one data source. I was also responsible to optimize processes that did not have an acceptable response time.

• Created custom modules for the Oracle iLearning tool
• Responsible for DBA activities like creating Tables, Views, sequences, indexes and constraints
• Designed PL SQL packages, stored procedures, functions and triggers using Collections, Cursors, Ref Cursors, Bulk Collection and user-defined data types
• Created Tables, Views and Materialized Views
• Optimized existing packages, stored procedures, functions and SQL queries
• Created complex ad-hoc queries in SQL PLUS
• Tested and debugged PL/SQL code using the PLSQL Developer tool
• Optimized existing packages, stored procedures, functions and SQL queries using ANALYZE and EXPLAIN PLAN
• Responsible for DBA activities like creating Tables, Views, sequences, indexes and constraints
• Created Views and Materialized Views
• Confidential Bulk Collection and user-defined data types
• Created custom Discoverer reports for specific business needs
• Created and edited back end, batch programs using UNIX Korn Shell scripting
• Created code standards and standardized processes
• Created and maintained technical documentation for projects and code modules
• Unit tested all modules I created
• Created ORACLE EXTERNAL tables for search and processing
• Loaded extensive data files into ORACLE using SQL LOADER
• Created complex ad-hoc queries in SQL PLUS
• I gave technical guidance, advice and support
• Responsible for data mining and reporting to aid the Business Analyst
• Tested and debugged PL/SQL code using the PLSQL Developer tool
• Loaded extensive data files into ORACLE using SQL LOADER
• Created ORACLE EXTERNAL tables for search and processing
• Provided technical aid to junior developers
• Integrated communication of PL SQL stored procedures and functions with XML
• Unit tested all modules created
• Created and maintained technical documentation for projects and code modules
• Helped to created code standards and standardized processes
• Performed code reviews
• Confidential Designed and edited PL SQL packages
• Supported all the applications created by Structured Technologies
• Created WEB pages using HTML, cgi scripts, VB script and JavaScript
• Created and edited back end, batch programs using UNIX Korn, C and Bourne Shell scripting
• Created Database reports using Crystal Reports
• Performed code reviews
• Created and maintained technical documentation for projects and code modules
• Unit tested all modules I created
• Integrated communication of PL SQL stored procedures and functions with XML
• Loaded extensive data files into ORACLE using SQL LOADER
• Used EXPORT and IMPORT utilities to copy data between different schemas in Databases
• Created complex ad-hoc queries in SQL PLUS
• Optimized existing packages, stored procedures, functions and SQL queries
• Confidential Designed PL SQL packages, stored procedures, functions and triggers using Cursors, Ref Cursors and user-defined data types
• Created and resolved issues on custom forms and workflow API's using stored procedures, Visual Basic, .NET, HTML and JavaScript.
• Created SQL Server TSQL procedures
• Created indexes for optimized queries
• Confidential Created and maintained ORACLE and SQL Server databases
• Supplied third tier support to major applications
• Created and edited back end, batch programs using UNIX Korn Shell scripting and Perl
• Created and edited back-end programs using UNIX Bourne and C Shell scripting,
• Resolved user issues using legacy system interfaces and legacy software.