robert smith oracle plsql developer phone 0123456789 email infoqwikresumecom website qwikresumecom summary oracle plsql developer 7 years experience various phases sdlc project requirement study highlevel design lowlevel design coding testing quality assurance documentation implementation project planning expertise data modeling large data warehouses supporting business intelligence applications olap also online transaction processing systems oltp core competencies oracle ms sql server ibm db2 udb 8070 environment windows xp red hat linux unix sun solaris programming languages plsql sql tsql professional experience oracle plsql developer hp infosystem llc march 2010september 2013 key deliverables responsible gathering requirements users reports development interface program customizations analyzing business process created maintained oracle database objects like tables views materialized views indexes constraints sequence synonyms database link using sql created numerous complex queries involving joins correlated subqueries diverse business requirements partitioned tables determining suitable methodology improve performance manageability planned designed implemented application database code objects stored procedures views indexes worked advanced plsql constructs like oraclesupplied packages nested tables varrays records types dynamic sql analytical functions created temporary tables packages procedures using sql developer oracle plsql developer abc corp 20062013 key deliverables conducted plsql development solve business problem worked various informatica power center transformations like connected amp unconnected lookups router expressions aggregators filters sequence generator joiner etc developed complex business logic developed many workflow sessions monitored workflow runs debugged errors created maintained oracle database objects like tables views materialized views indexes constraints sequence synonyms database link using sql 2259 oak street old forge new york 13420 free resume template copyright qwikresumecom usage guidelines