Pl/Sql Developer Resume Cranford, NJ - Hire IT People

SKILL:

Operating Systems: Windows 2010, Exadata

DBMS: Oracle 12c, 11g, 10g 9i

Languages: Oracle PL/SQL, SQL, Java

Applications: SQL Developer, SQLPLUS, OBIEE, Qlikview, MyEclipes,Word, Excel, PowerPoint, Microsoft Outlook, Microsoft Visio

WORK EXPERIENCE:

Confidential, Pl/Sql Developer

Assumed role as oracle developer, Office Leader supporting over 360 employees
Responsible for payroll, benefits, T&E
Maintained General Ledger using Oracle Financials, produced management reporting, reconciled General Ledger issues and made adjustments where needed.
Automated management reporting using OBIEE and Tableau
Worked extensively with Oracle Analytical SQL functions.
Independently learned SQL and Oracle and implemented best practices for administrative tasks.
In HR Salary Raise Project, I programmed stored procedures, user defined functions, database triggers and packages and all the database objects needed in Oracle environment to implement reach requirement.
In the inventory project,I coded a stored procedure and a function.that assigned a value to a column based on rule tables. So in the rule table, if the row met the criteria of the rule table, I built dynamic sql in the stored proc to update the column in that row. It was cursor processing so for each row read I would go check the rule tables to see if how that rows fair value column should be set or defaulted.then issue the update to the row using dynamic sql. I would build the sql statement then issue execute immediate to apply the update. The function too care of strings, commas, ticks, parenthesis when building the update stmt.

Confidential, Oracle Developer

Participated in a marketing capacity, generating leads, and produced advertising. developing the Code as per the requirements, experience in Core Java, JDBC,JSP,JavaScript. involved in the management system project by using Java/J2EE.
Compiled reservation information for management and clients by region and timeframe.
Worked extensively with Oracle SQL and PL/SQL in producing reports for upper management to exhibit high end and repeat clients.
Generated policy to utilize SQL result sets in establishing an operational workflow that increased sales by 340% and increased customer satisfaction by 140%
Provide customer information and profile using an Oracle view to the cruise line
Coded process in PL/SQL to collect customer expenses and input to General Ledger, then produce income statements and balance sheets for the company.

Confidential, Junior Engineer

Worked in engineering departments and assisted the Technician Department & General Manage
Involved in office functions, project scheduling, meeting minutes and project status