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.

• Design and write complex PL/SQL packages, stored procedures, functions, triggers and views
• 15 years
• Optimize existing PL/SQL packages
• 9 years
• SQL Loader and External table creation
• 14 years
• Document technical specifications
• 12 years
• Progressive software development experience
• 15 years
• Oracle PL/SQL
• 15 years
• SQL tuning of large database environments
• 10 years
• Programming PL/SQL batch environment utilizing large tables
• C .NET application development
• SQL Server Database Administration
• 14 years
• 3 years
• 4 years

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 ETL programs in PL/SQL to load and extract data in dimensional model Data Warehouses.
• Created dimension and fact tables

BOURNE Shell, Korn Shell and Bash Shell:

• Created programs that extracted and loaded Oracle data from one database into another.
• Created programs to manipulate data from the Oracle DBMS. Created scripts to create or manipulate flat files.
• 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 queries to display data or extract data from a database table to be loaded into another table
• Created queries within shell scripts, perl and Pro-C programs that extract data from one database to be loaded to another.
• Created queries for date to be displayed on web pages.
• Created large-scale queries that use all types of joins.

Perl

• Created and edited programs that extracted and loaded Oracle data from one database into another.
• Created and edited programs to manipulate data from the Oracle DBMS. Created scripts to create or manipulate flat files.
• 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

XML

• 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

Pro-C

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

Amerisure Insurance

Confidential

Amerisure 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.

• Currently, I am a senior PL/SQL Warehouse developer.
• I develop ETL processes using PL/SQL
• I create dimensional model tables
• dimension tables
• fact tables
• bitmap and b-tree indexes
• foreign keys
• Responsible for DBA activities like creating Tables, Views, sequences, indexes and constraints
• I gave technical guidance, advice and support to other members of the data warehousing 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 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.

Xerox

Confidential

Senior Oracle Developer

Xerox 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.

Constellation Energy Nuclear Group

Confidential

Software Engineer - IT Lead/Project Manager

• 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
• Report development using Crystal Reports and iReports
• Created ORACLE views and stored procedures
• Visual Survey software for Radiation Protection to create surveys and maps of containment
• File share setup Active Directory permission driven sharing
• Application packaging for automatic installation
• SQL Server database creation and customization
• IIS Web server creation and Administration
• Legacy data transfers using TIBCO
• SQL Server database creation and maintenance
• Created modules using groovy code
• Created a C .NET web application to import and sanitize data.
• Java tomcat server setup
• Cyber Security assessment software and architecture
• SharePoint Administration
• SQL Server database Administration
• Trouble shoot all issues
• QA and Unit test all modules
• Optimize queries and mapping tables
• Created and modified a C .Net Application development with iText PDF integration
• 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
• I was the IT Lead for implementing major nuclear applications including
• I was the Project Manager of the Nuclear Communications site
• The Nuclear industry is an extremely fast-paced, highly active industry. I had three main functions for development and support:
• 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.

Confidential

Software Engineer

US Airways 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
• Tested and debugged PL/SQL code using the PLSQL Developer tool
• Responsible for data mining and reporting to aid the Business Analyst
• I gave technical guidance, advice and support
• Created complex ad-hoc queries in SQL PLUS
• Loaded extensive data files into ORACLE using SQL LOADER
• Created ORACLE EXTERNAL tables for search and processing
• Unit tested all modules I created
• Created and maintained technical documentation for projects and code modules
• Created code standards and standardized processes
• Created and edited back end, batch programs using UNIX Korn Shell scripting
• Created custom Discoverer reports for specific business needs

Paramount Computing Associates

Confidential

Software Engineer

• Designed PL SQL packages, stored procedures, functions and triggers using Collections, Cursors, Ref Cursors, Bulk Collection and user-defined data types
• Created Views and Materialized Views
• Responsible for DBA activities like creating Tables, Views, sequences, indexes and constraints
• Optimized existing packages, stored procedures, functions and SQL queries using ANALYZE and EXPLAIN PLAN
• Tested and debugged PL/SQL code using the PLSQL Developer tool
• Created complex ad-hoc queries in SQL PLUS
• 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
• Created and edited back end, batch programs using UNIX Korn Shell scripting and Perl
• Supplied third tier support to major applications

Confidential

API Support Engineer

• Researched problems in large-scale workflow software and custom code using the Oracle, SQL Server 2000 and DB2 Database Management systems.
• Created and maintained ORACLE and SQL Server databases
• Created indexes for optimized queries
• Created SQL Server TSQL procedures
• Created and resolved issues on custom forms and workflow API's using stored procedures, Visual Basic, .NET, HTML and JavaScript.

Confidential

Programmer / Developer, Web Developer

• Designed PL SQL packages, stored procedures, functions and triggers using Cursors, Ref Cursors and user-defined data types
• Optimized existing packages, stored procedures, functions and SQL queries
• Created complex ad-hoc queries in SQL PLUS
• Used EXPORT and IMPORT utilities to copy data between different schemas in Databases
• Loaded extensive data files into ORACLE using SQL LOADER
• Integrated communication of PL SQL stored procedures and functions with XML
• Unit tested all modules I created
• Created and maintained technical documentation for projects and code modules
• Performed code reviews
• Created Database reports using Crystal Reports
• Created and edited back end, batch programs using UNIX Korn, C and Bourne Shell scripting
• Created WEB pages using HTML, cgi scripts, VB script and JavaScript
• Supported all the applications created by Structured Technologies

Xerox

• December, 1997 June, 2000
• Programmer / Developer / Software Support
• Webster, New York
• Designed and edited PL SQL packages
• Created and edited back-end programs using UNIX Bourne and C Shell scripting,
• Resolved user issues using legacy system interfaces and legacy software.

Confidential

Network Administrator Consultant / Web Designer

• Set up networks using the Microsoft Network and Windows constructed and repaired computers.
• Designed and created web pages using JavaScript and HTML.

Created programs for specific business needs using Visual Basic and Microsoft Access

Confidential

Computer Technician / Support Technician

• Repaired computer hardware problems researched software problems using UNIX.
• Answered hardware and software computer-related questions and solved computer-related problems for stores nationwide.