Oracle Plsql 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 SKILLS:

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

Confidential, USA
Oracle PL/Sql Developer
July 2010 – July 2011

Client: Confidential

Project: Global Labor Scheduling

• 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.

Confidential, Seattle, USA
Oracle PL/Sql Developer
Aug 2009 – Mar 2010

Client: Confidential

Project: Implement Restricted Parking Zone (RPZ) Permits into Hansen 7

• 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.

Confidential, USA
Oracle Developer
May 2006 – Sep 2008

Project: Global PT, Jan 2008 – Sep 2008

• 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

• 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

• 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

Confidential
Oracle PL/Sql Developer�
June 2005 – Apr 2006

Client: Confidential

Project: GL Subsidiary, Oct 2005 – Apr 2005

• 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

• 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