Oracle PL/SQL Developer

HARRY J. WATTS JR.

*** **** ***** **.

Frackville, PA 17931

CELL: 717-***-****

************@*****.***

WORK EXPERIENCE

Manpower Staffing, Ringtown PA: September 2017 - Present

Double Hung Window Frame Cleaner

●Inspect weld, nail fin, measurements of window frame

●Remove any access vinyl from corners of frame

●Check various parts within the frame to be sure the measure within spec and are free of debris

●Calk specified areas with proper color

●Build double and triple window frame by installing parts within the window frame.

Workforce Staffing, Pottsville PA: August 2017 - September 2017

Order Selector

●Check equipment is charged and operational

●Pull items for a specific order

●Box items according to company standards

●Clean assigned warehouse isles to company standards

Giant Foods, Harrisburg PA, Hazelton PA: May 2017 - August 2017

Porter

●Solution based selling to discover what merchandise will best fit the customer’s needs.

Home Depot, Harrisburg PA: February 2017 - May 2017

Sales Associate

●Solution based selling to discover what merchandise will best fit the customer’s needs.

●Responsible for building and maintaining presentations that make merchandise compelling for the customer to purchase.

●Providing superior customer service from the time the customer enters the store all the way through until the customer leaves the store including loading and unloading of customer purchases.

●Providing solutions for escalated customer issues

●Building and maintaining presentations that make merchandise compelling for the customer to purchase.

●Providing superior customer service at checkout from the time the customer enters the store all the way to loading of customer purchases if needed.

●Providing solutions for escalated customer issues.

Jiffy Lube, Hummelstown, PA: January – February 2017

Top end Lube Tech

●Providing superior customer service from the time the customer enters the store all the way through until the customer leaves the establishment

●Check/Fill all automotive fluids to proper levels, inflate tires to proper/desired air pressure and notify Service Writer of any potential mechanical issues

●Clean all exterior windows and vacuum front and rear floor

●Reset oil change lights and verify mileage sticker for next oil change

Information Gateways, Mechanicsburg PA: June 2014 - January 2016

Developer

●Break/fix Oracle PL/SQL programming based on user submitted requests following requirements documentation

●Debug Forte Application via Oracle PL/SQL programming

●Document all unit testing for Business Analyst evaluation

●Share new found methods of performing task with team members

BAE Systems, York PA: August 2011 – June 2014

Developer/Programmer/Analyst

●Over two years’ Oracle E-Business Suite Application (11i and R12) experience in creating and/or modifying tables, packages, procedures and functions following best practices and Oracle guidelines including but not limited to reusable coding

●Debug Oracle Application, third party applications, Oracle Concurrent Requests, Oracle Reports on the database side through Oracle documentation and customer querying creation.

●Break/fix for Oracle E-Business Suite programming based on user submitted errors tickets and end user input for requirements, MyOracle (MetaLink) service request resolution.

●Full documentation of all service requests, customer issues, data/system errors from start to resolution for complete customer satisfaction.

●Purchasing,Inventory, and Order Management modules troubleshooting (database side) to resolution up to and including update/delete specific records

●Learned UNIX scripting to create, rename, or delete files.

●Inventory barcode ticket editing with company software (tied to third party custom coding)

●Output in various formats which include CSV, XML, tab delimited among other formats

●Ad-hoc data extracts that users may request via custom query

●Manipulate data from an outside source file to allow a data import into different applications such as an Oracle Table, MS Excel, MS Access, or a text editor such as notepad or TextPad

●Create Oracle Concurrent Request from research to development for a manually, user driven process or scheduled request to run at various times.

●Used data manipulation tool (Monarch) to extract data from an HTML/text document

●Work with team members to gain knowledge gathering and system specifics to better understand process flow and to develop and update a Data Model

●Share new found methods of performing task with team members.

●Add/edit company’s information documents with known Oracle script fixes to Oracle’s seeded code, know error fixed, user created errors and fixes, better methods of performing specific tasks, queries for analysis

●Create how-to documents for users as well as other team members

●SDLC and Agile Development methodologies followed for development.

●ITIL Certified

●Use STAT for SDLC, version control and migration tool

●Use TOAD, JDeveloper PL/SQL utility

●Tools learn include JDeveloper PL/SQL utility (similar to TOAD Utility), Quest STAT, Monarch, Oracle EBS Application, MS OneNote (for shared team notes), Third party barcoding software, reporting software Maximo (IBM) and Remedy

SAIC, Chambersburg, PA: November 2007 – August 2011

Developer

●Over three years’ of Oracle 9i/10g/11i Oracle PL/SQL development in a logistic environment

●Over three years’ of creating and using tables, stored packages, procedures, functions, sequences and triggers for record processing in a production environment.

●Over three years’ experience writing scripts (Tables, Insert, Update, Alter, Delete)

●Over three years’ in uploading data to production through data manipulation in order to upload into Oracle tables.

●Over three years’ manipulated data source input to conform to production table definitions which includes but not limited to the following: create packages, procedures, functions, create anonymous ad-hoc block code to change specific records

●Over three years’ conforming and validating data source (mainly XML documents) to be used for PDF creation, MS Access use, MS Excel use, or webpage processing or viewing.

●Over three years’ experience working with in CSV, XML, tab delimited files which include: exporting, importing, editing/fixing broking files and data uploaded errors.

●Developed and modified order processing screens with full query visibility in Oracle 9i/10g/11i

●Created and developed processing applications using HTML, JavaScript, and Oracle 9i/10g/11i

●Debugged multiple processing applications in JavaScript/HMTL/Oracle9i/10g

●Over three years’ experience in HTML, JavaScript Programming, TOAD Oracle Utility, writing and code documentation, team environment programming

●Full documentation of all service requests, customer issue, data/system errors from start to resolution for complete customer satisfaction.

●XML 10g Introduction Training for XML & PL/SQL

●Over two year using Adobe PDF creator

●XML/XSL file creation for PDF output

●4 years’ experience with SDLC, specifically CMMI Maturity Level III Trained

●Security Clearance

EDUCATION

DeVry University Online, Headquarters Oakbrook Terrace, IL: March 2004 – April 2006

Bachelor’s Degree in Computer Information Systems

●GPA 3.1

●Oracle 9i Database Programming (PL/SQL)

●Web Page Design in HTML/XHTML

●Visual C#.NET, Java, Java Applets, JDBC.ODBC Connections

●Dreamweaver and Fireworks (with CCS)

●MS Project Management

●Rational Rose, MS Visio

●System Analyst and Design with UML

●IIS Web Administrator (live environment)

●Networking and Web Connectivity (live environment)

Thompson Institute, Harrisburg, PA: Graduation - July 2000

Associate Degree Specializing in Computer Programming Applications

●GPA 3.34

●RPG/400, COBOL/400, DB2 AS/400

●AS/400 Operations (SQL), Systems Analyst (60 Clock Hours)

●Microsoft Office Suite, Windows 98, Peachtree Accounting

●Visual Basic 6.0, Adobe PageMaker 6.5

Contact this candidate