Oracle Pl/sql Developer Resume


Summary


  • 8 years of working experience in Oracle 8i,9i,10G,11G, SQL and PL/SQL procedures, functions, packages, triggers, cursors, view etc.
  • Good experience in PL/SQL and ETL scripting and query optimization.
  • I used Informatica Tool for ETL Process.
  • Good experience in data warehouse systems.
  • Good experience in UNIX shells scripting.
  • Over 2+ years of experience in Oracle Forms and Reports.
  • Over 2+ years of experience in SQL Server 2005/2008.
  • Over 3+ years experience developing and supporting Crystal Reports XI and Crystal Reports 8.
  • 3+ years of experience in Performance tuning of Oracle database.
  • Basic knowledge of DOTNET(C#,VB.NET),Visual Studio 2008,Java.
  • Extensive experience in MS Excel.
  • Extensive experience in writing stored procedures, functions and views.
  • Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
  • Involved in all phases of a migration project from Oracle 9i to10G.
  • Done the data conversion from SQL Server and Oracle.
  • Done the data conversion from FoxPro
  • Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
  • Load the data from MS Excel to Oracle Table and Oracle table to MS Excel.
  • Loaded the data using the SQL loader, Imports & UTL files based on file formats.
  • Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query etc.
  • Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
  • Used partitioning and sub partitioning of tables to improve performance.
  • Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
  • Good Experience in Unit Testing, Integration Testing and Performance Testing.
  • Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.
  • Expertise preparing report specifications and database designs to support reporting requirements
  • Developed complex reports – multi-functioned, leveled and grouped, summary functionality in main reports providing detailed drilldown through On Demand Sub-reports, dynamic link labeling, complex functions, cross-tabs, charts, shared variables, imported parameters and record sets from stored procedures, conditionally suppressed sections, error handling/messaging, clean and attractive designs, user friendly with instructional ToolTips.
  • Worked with team on customizing the abilities of Crystal Enterprise such as exporting, previewing, printing and emailing reports.
  • Created Crystal Reports sourced from the Oracle database and flat files.
  • Created ad-hoc reports as well as canned/recurring reports (such as daily, monthly, and annual) from simple drilldowns to complex summaries with charts/graphs, cross-tabs, running totals, multiple sections, etc.


  • Technical Skill Summary


    Reporting Tools: Business Objects, Crystal Reports
    Designing Tool: Erwin Data Modeler
    Database: Oracle11g/10g/9i/8i, SQL Server 2005, MS Access
    Languages: SQL, PL SQL, Oracle Developer 2000,Unix Shells Scripting, C,C++,HTML,Java
    Operating Systems: Windows95/98/2000/NT, MS DOS, UNIX
    Other Tools: TOAD, SQL Loader, SQL Plus, Query Analyzer, MS-Word, MS-Excel, MS-VISIO, Visual Source Safe (VSS), CVS, Crystal Reports 8.0/XI, Forms 5.0,Forms 6i, Reports 6i, Forms 9i,Reports 9i,Oracle Reports 10G,Oracle Forms 10G, Oracle Apex, SQL Server Management Studio, Visual Studio 2008.

    Professional Experience:


    Client: Confidential, USA
    Role: Oracle PL/Sql Developer
    Project: Global Labor Scheduling
    Duration: July 2010 – July 2011

    Responsibilities


  • Created lots of Triggers for validation.
  • Created lots of procedure, package, and functions.
  • Worked on performance tuning of the SQL queries to improve data conversion process.
  • Created the index for increasing the performance of data conversion process
  • Performed Unit Testing, Integration Testing and Performance Testing.
  • Load the data from Excel file to oracle database.
  • Done Configuration Management using VSS.
  • Tuned SQL queries and performed code debugging using TOAD.
  • Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
  • Prepared and updated design specifications.
  • Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
  • Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.
  • Created lots of SQL script for ETL Process.
  • Used Analytic functions, Decode, case statement while writing complex SQL queries.
  • Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
  • Exported the database and imported the same into development and test environment whenever required.
  • Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
  • Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
  • Created Oracle Materialized Views.
  • Used the inner join, outer join, cross join while writing the complex SQL Queries.
  • Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
  • Created lots of UNIX shell script to automate the process.
  • Experience in writing shell scripting for various ETL needs
  • Design and development of UNIX Shell Scripts to handle pre and post session processes.


  • Environment: Oracle 11g, MS Access 2003, MS Excel, TOAD, Microsoft Office, VSS, XP, Linux, Putty.
    Client: Confidential, Seattle, USA
    Role: Oracle PL/Sql Developer
    Duration: Aug 2009 – Mar 2010
    Project: Implement Restricted Parking Zone (RPZ) Permits into Hansen 7

    Responsibilities


  • Created lots of Triggers for frontend validation.
  • Done the data conversion to move data from FoxPro system to Hansen 7.
  • Created lots of procedure, package, and functions.
  • Worked on performance tuning of the SQL queries to improve data conversion process.
  • Created the index for increasing the performance of data conversion process
  • Performed Unit Testing, Integration Testing and Performance Testing.
  • Load the data from Excel file to oracle database.
  • I used Informatica Tool for ETL Process.
  • Done Configuration Management using VSS.
  • Tuned SQL queries and performed code debugging using TOAD.
  • Conducted Oracle database and SQL code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
  • Prepared and updated design specifications.
  • Developed a variety of Management reports for users, using Crystal Reports 2008.
  • Created parameterized reports and customized existing reports. Developed various sub-reports, running totals per period.
  • Run the Reports from Business Object Info View.
  • Created Master Detail and Cross Tab reports to view the data in an analyzed way; formatted the reports as per the user requirements.
  • Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
  • Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.
  • Created lots of SQL script.
  • Used Analytic functions, Decode, case statement while writing complex SQL queries.
  • Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.
  • Exported the database and imported the same into development and test environment whenever required.
  • Created Oracle Database Users, Roles and managing Security. Implement effective database security practices and procedures.
  • Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
  • Created Oracle Materialized Views.
  • Used the inner join, outer join, cross join while writing the complex SQL Queries.
  • Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
  • Created lots of UNIX shell script to automate the process.
  • Experience in writing shell scripting for various ETL needs
  • Design and development of UNIX Shell Scripts to handle pre and post session processes.

  • Environment: Oracle 9i/10g, Crystal Reports 2008, Data Integrator, MS Access 2003, MS Excel, TOAD, Microsoft Office, VSS,XP, Business Object Info View, CMC, Linux.
    client: Confidential, USA
    Role: Oracle Developer
    Duration: May 2006 – Sep 2008
    Project: Global PT, Jan 2008 – Sep 2008

    Responsibilities:


  • Involved in a large migration project moving from Oracle 9i to 10g and prepared the Impact Analysis Document prior to project launch.
  • Worked on performance tuning including procedures, functions and SQL statements.
  • Ran the ADDM (Automatic Database Diagnostic Monitor) Report for performance tuning.
  • Conducted performance tuning of the database for optimal performance.
  • Used partitioning and sub partitioning of tables to improve performance.
  • Involved in the database design and prepared the detail design document (DDD).
  • Created procedures, triggers, functions and packages using PL/SQL
  • Load the data from Excel file to oracle database.
  • Conducted database and code tuning to improve performance of the application, used Bulk binds, in-line queries, Dynamic SQL, Analytics and Sub-query factoring etc.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
  • Analyzed and computed statistics to improve response time for queries.
  • Performed Unit Testing, Integration Testing and Performance Testing.
  • Developed a variety of activity reports for users, using Crystal Reports.
  • Scheduled regular backups of data, universes, and reports.
  • Developed complex reports using multiple data providers and report level variables.
  • Developed materialized views and other database objects to optimize reports.
  • Implemented different level hierarchies for drill down reports.
  • Worked with developers for performance tuning of the queries to improve user experience.
  • Created data dictionaries.
  • Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
  • Worked on Fact and dimension table of data warehouse.
  • Created UNIX shell scripts.
  • Worked on data extraction, data cleaning, data transformation and data loading process.
  • Created the bitmap index in data warehousing environment.
  • Created lots of UNIX shell script to automate the process.
  • Created materialized view to increase the performance in data warehousing environment.
  • Used rollup and cubes for summary data.

  • Environment: Oracle 9i/10g, Crystal Reports XI, Data Integrator, MS Access 2003, MS Excel, TOAD, WebLogic, UNIX, and Microsoft Office
    Client: Confidential
    Project: TTPRO (Issue Tracking Application), Feb 2007 to Dec 2007

    Responsibilities:


  • Wrote queries/procedures to retrieve and store data in the Oracle database.
  • Coded and maintained PL/SQL Packages, Stored Procedures and Database Triggers.
  • Tuned SQL queries and performed code debugging using TOAD.
  • Developed complex queries including Sub queries, Unions, Intersect and Aliases.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
  • Load the data from Excel file to oracle database and Oracle table to Excel file.
  • Created parameterized reports and customized existing reports. Developed various sub-reports, running totals per period.
  • Successfully involved in inclusion of linked as well as unlinked sub-reports along with the primary reports
  • Prepared estimates for Change requests raised by the client.
  • Conducted Configuration Management using VSS.
  • Coded for Oracle Apex
  • Involved in unit testing and writing test cases.
  • Coordinated team activities
  • Conducted enhancement and bug fixing.
  • Involved in the code review.

  • Environment: Oracle Apex, Oracle 10g, Crystal Reports XI, Data Integrator, Visio, MS Excel, TOAD, Microsoft Windows XP Professional
    Client: Confidential
    Project: Catlogic Design Office, May 2006 – Jan 2007

    Responsibilities:


  • Wrote queries/procedures to retrieve and store data in the Oracle database.
  • Created Tables, Views, Constrains, Synonyms, Sequences.
  • Analyzed and computed statistics to improve response time for queries.
  • Maintained version control in VSS.
  • Load the data from Excel file to oracle database.
  • Generated linked reports with complex cross-tab reports with multiple queries, conditions, global filters and multiple data providers.
  • Developed Crystal Reports and RFC (Cybage internal XML based tool)
  • Prepared test cases and conducted Unit Testing for this module.
  • Prepared estimates for Change Requests raised by the client.
  • Provided new reports development and enhancements to existing reports.
  • Worked on enhancements and bug fixes.
  • Developed custom reports that were formatted according to the user requirements using Business Objects functionalities like @Functions and Formulas, etc.

  • Environment: Groovy, GAD/GAP (Internal tool of client),Crystal Reports XI, Data Integrator, MS Access 2003, MS Excel ,Oracle 10g, Visio, TOAD, Weblogic, Microsoft Windows XP Professional, Microsoft Office
    client: Confidential
    Role: Oracle PL/Sql Developer
    Duration: June 2005 – Apr 2006
    Project: GL Subsidiary, Oct 2005 – Apr 2005

    Responsibilities:


  • Contributed to the database design and prepared detail level design document
  • Developed/Coded in Oracle Forms/Reports
  • Prepared test cases and performed unit testing.
  • Provided estimates for Change Requests raised by the client.
  • Performed Configuration Management using VSS.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
  • Load the data from Excel file to oracle database
  • Used Bulk Collect feature to improve performance.
  • Prepared and updated design specifications.
  • Reports responsible for included the following: General Ledger, Currency Conversion Rate, Payment sheet etc.
  • Wrote queries/procedures/function/package to retrieve and store data in the Oracle database.

  • Environment: Oracle Forms 10G, Oracle Reports 10G, Oracle 9i/10g, MS Access 2003, MS Excel, TOAD, UNIX, Microsoft Office, VSS
    Client: Confidential
    Project: Financial Accounting System, Jun 2005 – Sep 2005

    Responsibilities:


  • Involved in the database design and prepared detail level design document
  • Developed/coded in Oracle Forms/Reports
  • Prepared test cases and performed unit testing.
  • Proposed Innovative ideas/architectural designs/changes those were approved and appreciated.
  • Prepared and updated design specifications.
  • Wrote queries/procedures to retrieve and store data in the Oracle database.
  • Scheduled regular backups of data, universes, and reports.
  • Tuned SQL queries and performed code debugging using TOAD
  • Used Bulk Collect feature to improve performance.
  • Developed complex queries including Sub queries, Unions, Intersects and Aliases.
  • Maintained version control in VSS


  • Environment: Oracle Forms 6i, Oracle Reports 6i, Oracle 9i/10g, MS Access 2003, MS Excel, TOAD, UNIX, Microsoft Office, VSS

    Education


  • Master of Computer Application (M.C.A), Confidential University
  • Bachelor Degree (BSc) Confidential University

  • Professional Certification


  • Oracle Certified Professional (OCP) Aug 2007

  • Testimonials
    best oracle training center in chennai "I did my oracle training in greens technology, Chennai. Now I got placed in Virtusa. I really thank Dinesh for his involvement in my training. His way of teaching is really awesome. I never saw such quality teaching and placements were so fast. Thanks a lot Greens Technologys for your support. I wish dinesh sir all the best for his new IT development venture."

    oracle training classes in chennai "I thought I knew oracle until I took this course. My company sent me here against my will. It was definitely worth and I found out how many things I was doing wrong. Dinesh is awesome. but i got a lot inspired by you. I will keep in touch and will always try to learn from you as much as I can. Thanks once again Dinesh for the Best Oracle training !"


    Oracle Placement Training in Chennai


    Greens Technologys Overall Reviews


    Greens Technologys Overall Reviews 5 out of 5 based on 17,981 ratings. 17,981 user reviews.
    oracle training chennai """I think this is the best Oracle training course in chennai I have taken so far..Well I am still in the process of learning new things but for me this learning process has become so easy only after I joined this course in greens technologies..as Dinesh is very organized and up to the point.. he knows what he is teaching and makes his point very clear by explaining numerous times. I would definitely recommend anyone who has any passion for Oracle.." ""



    Oracle Developer Roles and Responsibility





    SQL and PLSQL Practice



    Oracle Production Support Resume
    Oracle plsql Developer Resume
    Oracle plsql Developer Resume 1
    Oracle plsql Developer Resume 2
    Oracle plsql Developer Resume 3
    Oracle plsql Developer Resume 4
    Oracle plsql Developer Resume 5
    Oracle plsql Developer Resume 6
    Oracle plsql Developer Resume 7
    Oracle plsql Developer Resume 8
    Oracle plsql Developer Resume 9
    Oracle ETL plsql resume
    Oracle Plsql Developer Resume Profile
    plsql ETL Resume
    Senior Oracle plsql Resume
    Sr.Oracle plsql Developer Resume
    Sr.Oracle plsql Resume
    Sr.Plsql Developer Resume
    Oracle plsql Developer Resume
    Oracle plsql Developer Resume