Senior Oracle Plsql Resume

Summary

Joseph Harmon has 15 plus years of application development and support experience. He has 12 plus years of oracle pl/sql development experience as a lead and as a team participant. He is proficient at tuning sql statements and has performed pl/sql development for the following: ETL purposes, batch processing, web based applications created using APEX, modification of off-the shelf software, and enterprise wide VB6 applications. He has peformed pl/sql development on financial systems, workorder management systems, customer loyalty systems, asset management systems, home loan systems, insurance systems, permit systems, meter reading systems, and retail systems. He is analytical, a creative problem solver, and communicates very well.

Education

Bachelor’s Degree in Business Administration and Total Quality Management, College of Confidential

Master of Science in Organizational Leadership (MSOL), College of Mount St Joseph, 2005

Skills:

Languages/Development Tools/Configuration Mgt Tools:

OraclePL/SQL,SQL,APEX,PL/SQLDeveloper,Report2Web,SharePoint,Jira,Toad,ORACLE DEVELOPER/2000(Forms and Reports 6i),Bugzilla, SQR, Informatica, COGNOS, COBOL, Unix Shell Script, FOCUS, WEB FOCUS, HTML, XML, Javascript, VBScript, Visual Basic, Access, People Tools, TSO, Fileaid, Expeditor, JCL, CVS, Subversion, Test Track

Infrastructure:

APPWORX/UC4,Ecometry,Windows7,Windows Vista/XP/98/2000/2003, Unix, DOS

Databases:

Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, Oracle 7, DB2, Teradata, Access, FOCUS, WEB FOCUS, VSAM

Project Management and Design:

Agile Software Development, Visio

Positions Held:

ConfidentialJanuary 2011 to Present

Senior Oracle PL/SQL Developer

• Serve as technical lead of an offshore team for the design and development of new enterprise web based applications as well as new versions of existing ones written in APEX(Application Express) and Oracle PL/SQL.
• Facilitate requirements gathering and design sessions of APEX web applications with customers.
• Provide technical and functional direction to our customers in matters of implementing technology within their business processes
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Use Dynamic SQL and Execute_Immediate functionality to perform DDL in PL/SQL blocks and procedures
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
• Create PL/SQL packages, stand alone procedures, and stand alone functions.
• Write complex SQL queries with sub-queries, analytical functions, and inline views
• Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.
• Use Collections like variable arrays, nested tables
• Design and create entity relationship diagrams (ERD) for Oracle based applications and interfaces.
• Provide on call and daily production support of APEX applications and Oracle PL/SQL ETL processes.
• Manage User Acceptance Testing of new applications and new versions of existing applications.
• Manage the packaging and release of applications to the training, UAT and production environments.

Accomplishments:

• Technical lead, designer, QA manager, configuration manager, and one of the developers of an APEX frontend PL/SQL backend web application called Work Queue Management (WQM) to help the Cornerstone Brands Call Center to manage the daily, weekly, and monthly distribution of its work. The application will save the Call Center managers and supervisors three hours a day of scheduling work.
• Designed and developed an interface for a project called West Coast DC to manage the shipping of inventory to multiple distribution centers for customer’s orders. The interface will save Cornerstone Brands several millions of dollars each year.
• Designed and developed an APEX module and batch process for identifying COM vendors as a part of an ACE 3.1 application release.
• Technical lead, one of the developers, QA manager, and configuration manager for the development and release of versions 3.2 and 3.2.1 of an ACE APEX enterprise web application.
• Designed and developed a PL/SQL batch process to allow products to be shared across different companies and divisions within the companies.
• Designed, developed and added a tax module written in APEX and PL/SQL to an existing batch scheduling application to load a file so that taxes, postage and handling or both can be turned on and off for individual states.

Senior Consultant :

• Design, and develop, Oracle PL/SQL ETL processes for loading data from internal systems using SQL Loader and External tables.
• Use Collections like variable arrays, nested tables.
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Create PL/SQL packages, stand alone procedures, and stand alone functions.
• Write complex SQL queries with sub-queries, analytical functions and inline views
• Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.

Accomplishments

• Designed and developed ETL package to load Travel Insurance data from external tables into a data warehouse for American Modern Insurance Group.
• Designed and developed ETL package to process key contact, error omissions, and managing group data.
• Designed and developed an insert/update trigger to left pad state and county numbers.

ConfidentialJune 2010 to September 2010

Senior Consultant:

• Design and develop ETL processes in PL/SQL to pull data from multiple sources into a single database source for end user reporting purposes at Fannie Mae Corporation.
• Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Create PL/SQL packages, stand alone procedures, and stand alone functions.
• Write complex SQL queries with sub-queries, analytical functions, and inline views
• Performance tune and optimize SQLs using explain tables, TKPROF utility, by setting database parameters, by using optimizer hints and using Analyze to compute statistics on tables.

Accomplishments:

• Designed an ETL process to pull data from a Bond Credit Enhancement (BCE) system into a FRCO system for user reporting purposes.
• Designed an ETL process to pull data from multiple loan maturity systems into a FRCO system for user reporting purposes.
• Designed an ETL process to pull data from a Strategy system into a FRCO system for user reporting purposes.
• Designed an ETL process to pull data from a MCODES system into a FRCO system for user reporting purposes.

ConfidentialJune 2007 to February 2010

Senior Consultant

• Design, develop, and maintain PL/SQL stand alone procedures, stand alone functions, packages, triggers, standard views, materialized views, unique indexes, non unique indexes, reference cursors, tables, and other PL/SQL creations.
• Use Collections like variable arrays, nested tables.
• Use oracle utl_smtp utility to email SQL reports
• Use DBMS_JOB and DBMS_SCHEDULER create and schedule the execution of packages, stand alone procedures and emailing of reports from the database.
• Design and create logical and physical data models for Oracle based applications and interfaces.
• Facilitate requirements gathering and data mapping meetings with clients.
• Lead or participate in the design, develop, and implementation of applications, interfaces, and other creations written in PL/SQL and Unix.
• Served as configuration manager for tasks such as code changes, code backups, and code implementations.
• Served as career counselor and performance evaluator for junior level consultants.

Accomplishments

• Design and development of an Orders Interface between an Oracle and SAP database for Proctor and Gamble
• Design and development of Unix shell scripts for ftping flat files, calling SQL Loader, executing SQL reports, and executing interfaces
• Development of custom database security written in PL/SQL for GE’s Export Control Energy Database Hardening Project.
• Export and archiving of data for several of Proctor and Gambles multiple terabyte databases
• Design of the Product and Customer Interfaces between an Oracle and SAP database for Proctor and Gamble
• Designed and developed custom database security in PL/SQL for Oracle versions 7, 8i, 9i, and 10g for General Electric’s Energy Division
• IT Project Manager for the successful implementation of Cognos performance scorecards and a Cognos cube project called Fleet Data Management (FDM) Data Quality Phase II for General Electric’s Aviation Division

Confidential
Customer Support Manager

• Manage the HelpDesk and overall coordination of IT applications development projects.
• Hiring, scheduling work assignments, counseling, and conducting performance evalutions of helpdesk technicians, business analysts, quality assurance testers, and software developers.
• Implement and enforce development of software process improvement, establish and oversee the implementation of processes, procedures, and standards

Accomplishments:

• Managed the Launch of Marquis Homes web application
• Saved Drees Homes $750,000 per year on computer support
• Created and implemented Customer Service SLAs
• Co-Created and implemented a less expensive and quicker way of reimaging computers.

Solution Environment-HP UNIX, Java/JSP, Oracle 10G, Tools-IPMS, Oracle Forms/Reports Developer, PLSQL Developer, Toad, XML Spy, Clear tool,and MS-VSS

Customer- Confidential Dec 2005 - Apr 2006
Project-SECL ERP
Role-Developer

Description-SECL ERP is the customized ERP solution for South Eastern Coal Fields Limited. This ERP contains following Business Process Chains [BPC] - Purchase, Inventory, Payables Management, Fixed Asset Management, Enterprise Asset Management, General Accounting, and Management Accounting.

User interface is developed using Ramco virtual works which generates JSP code. The user interface calls an oracle procedure which handles the business functionalities.

ConfidentialApril 2005 to September 2005

Systems Analyst

• Design, development, and maintenance of modules for an enterprise wide asset management application written in Visual Basic 6 and PL/SQL operating on an Oracle database.

Accomplishments:

• Designed and created a module using VB6 and PL/SQL to track the receipt of and resale of used computers.

ConfidentialOctober 2002 to April 2005

Application Analyst:

• Technical Lead for the application support team and a member of soft
• Scheduled new application version releases and performed implementation verifications.
• Analysis, design and development of PL/SQL ETL processes for new incoming clients.
• Design, development, and maintenance of applications written in PL/SQL, Oracle 6i forms, Oracle 6i reports and Unix.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader.
• Use Dynamic SQL and Execute_Immediate functionality to perform DDL in PL/SQL blocks and procedures
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, and other database objects.
• Create PL/SQL packages, stand alone procedures, and stand alone functions.

Accomplishments:

• Design and development of an software module for American Express’s Favorite Places program written in Oracle PL/SQL, Oracle Forms 6i, and Oracle Reports 6i.
• Design, development, and implementation of over hundreds of custom bonus PL/SQL packages for Best Buy’s Reward Zone program
• Created and implemented Customer Service SLAs

ConfidentialMarch 1997 to October 2002

Senior Computer Programmer:

• Design and development of applications and ETL processes written in PL/SQL, Focus, Web Focus, SQR, and UNIX.
• Design, development, and maintenance of online and batch COBOL programs used for City of Cincinnati accounting and procurement departments.

Accomplishments

• Created ETL processes for building accounting lines and address information for work orders management system
• Co-Created a release of VB6 App for linking a GIS and work order management system
• Created a FOCUS application for generating accounts payable, accounts receivable, budget cost accounting, general ledger, and procurement reports.
• Created an ACCESS database for tracking requirements and task completions
• Created an active server page to allow accounting lines to be maintained on demand
• for a work order management system.
• Successful conversion of FOCUS code and reports to WEB FOCUS.