SUMMARY

• Having around 9 years of working experience as Sr Oracle PL/SQL Developer and Database Modelling and Database design, development, maintenance and production support phases in renowned IT Organizations.
• Hands - on expertise in tools like SQL*Plus, PL/SQL, TSQL, Oracle Reports, Crystal Reports, Discover, XML Reports, Oracle Reports, Oracle Forms, UTIL file utility, SQL * Loader, Data Conversion and Data Migration using API’s.
• Extensive working experience on manual ETL (PL/SQL Driven) and manual Data Migration (PL/SQL Driven) projects.
• Extensively worked on range of database technologies like Oracle, MySQL, SQL Server.
• Hands on expertise on performance tuning of SQL queries, Dynamic SQL,Stored Procedures Packages, Collections, Explain Plans, Partitioning Tables and various PL/SQL intensive applications and Java Programming.
• Created business adhoc reports by joining multiple tables from multiples database usingcomplex SQL queries, with high volume transactions systems.
• Well experienced in Query Optimization and Tuning using SQL Trace and Tkprof and AWR Reports.
• Responsible for debugging, troubleshooting, and tuning PL/SQL storedprocedures and functions and Complex SQL.
• Scheduling Jobs using Oracle Scheduler.
• Having exposure of new features available in 10g / 11g / 12c Database.
• Maintaining the database code versions using the Internal ARU Tool.
• Branching of versions maintain dual check in files in different branch lines.
• Extensive experience in writing PL/SQL Packages, Collections, Functions, Procedures, Types, Views, Indexes &Triggers to implement business logic.
• Worked on Financial and Health care Domains.
• Knowledge and exposure to VPD(Virtual Private Database),Unix and Shell Scripting
• Experience on Designing Web Pages using Java Scripting
• Working Knowledge in Regular Expressions in 10g
• Guided and lead team members in various stages of the project
• Good team player and ability to work independently.
• Knowledge on Webutl and WebLogic.
• Excellent logical and analytical skills, enthusiastic, excellent interpersonal & communication skills.
• Commitment to excellence proven by an outstanding career track.

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g/11g/12c, SQL SERVER 2008, MySQL 5

ETL Tools: Oracle Data Integrator (ODI)

Reporting Tools: OBI, Crystal Reports,Jasper Reports,OracleReportBuilder,XML/BI Publisher Reports

Database Tools/Utilities: SQL*PLUS, SQL-Loader, TOAD, SQL Developer.SQL Navigator, OEM

Data Modeller Tools: SQL Developer Data Modeller

Operating Systems: HP-UNIX, Windows NT/XP

Languages: C, Java, HTML, Java Scripting, Per Scripting, PL/SQL, UNIX (shell scripting)

PROFESSIONAL EXPERIENCE

Confidential, RedWood City, CA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Development of Packages, Procedures, Functions, Indexes, Triggers and Packages.
• Involved in preparation of the unit test plans.
• Handled many performance bugs. Dealt with SQL Trace, Tkprof, Hints, Histograms and Statistics.
• Developed all the reports to use Data Templates (BI Publisher).
• Worked on Optimization and Performance Tuning of SQLs
• Worked on Oracle Forms and Oracle Reports Builders.
• Processing the Interface Data using SQL Loader by loading the data using Flat Files.
• Developing and debugging Java Scripting, PERL Scripting and Unix Shell Programming.
• Working on Adhoc Reports by writing Complex SQL’s using TOAD and SQL Developer.

Confidential

PL/SQL Developer

Responsibilities:

• Development of Procedures, Functions, Indexes, Triggers and Packages.
• Whole and sole responsibility of Bug Screening for the entire product.
• Making decisions on any functional/technical changes of the product related to AP, AR and CST.
• Involved in preparation of the unit test plans.
• Developing and debugging Unix Shell Programming
• Handled many performance bugs. Dealt with SQL Trace, Tkprof, Hints, Histograms and Statistics.
• Maintained the internal forums for techno-functional questions.
• Processing the Interface Data using SQL Loader by loading the data using Flat Files.
• Responsible for moving data migration from various external systems to Oracle database.
• Involved in gathering the requirement phase, interacting with various users to address their technical issues with the product.

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

• Responsible for writing business logic by using PL/SQL Stored procedure, database objects and complex queries.
• Responsible for generating the SQL * Loader control files to load the raw data to staging tables.
• Extensively used cursors, collections and advanced PL/SQL in the business logic wrapper.
• Responsible for implementing the complex queries to support the various reports development.
• Involved in data discovery phase to find the source definition of each and every dimension involved in reporting domain.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Responsible for writing business logic by using PL/SQL Stored procedure, database objects and complex queries.
• Developed Crystal Reports and Jasper Reports to generate the Customer Billing Cycle Reports.
• Responsible for generating the SQL * Loader control files to load the raw data to staging tables.
• Extensively used cursors, collections and advanced PL/SQL in the business logic wrapper.
• Responsible for implementing the complex queries to support the various reports development.
• Involved in data discovery phase to find the source definition of each and every dimension involved in reporting domain.