PROFESSIONAL SUMMARY:

• Over 6 years of experience in analysis, design, development, testing and deployment of software applications using Oracle8i/9i/10/11g.
• Extensive experience in building Client Server Applications using Oracle, PL/SQL, Stored Procedures, Packages and Database Triggers and working with partitions
• Proficient in oracle tools and utilities such as SQL Loader, SQL developer and TOAD.
• Experience in query optimization, Performance Tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, Hints, SQL Profiling, Bulk Collect, Creation of global temporary tables and table partitioning.
• Involved in Unit Testing, Integration testing and Performance Testing.
• Experienced in interacting with Business users, Business Analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Proven ability to plan, coordinate and implement SDLC and Agile software development and maintenance projects.
• Strong experience in SQL, SQL*PLUS, PL/SQL, back end programming using Packages, Functions, Stored Procedures, Exception handlers, Database triggers, Views, Ref Cursors, Record Types, UTL FILE and other built in packages.
• Expertise in UNIX shell scripting and job scheduling.
• Able to work within an aggressive and demanding project schedule and environment.
• Highly motivated & conceptually strong individual with outstanding oral and excellent communication, analytical and interpersonal skills.

SKILL:

RDBMS: Oracle 11i, 10g and 9i, SQL Server

Database Programming: SQL, PL/SQL, T: SQL

Operating Systems: Windows XP/2008/2010, HP: Unix

Programming: Shell Scripting, C, C++ and PL/SQL

Scheduling: Appworx, DBMS

Version Control: CVS, SVN (Subversion)

Web: HTML, DHTML, Java Script

Reports: Tableau, Crystal Reports (BO)

Other Products/Tools: Toad, SQL*Loader, Cute ftp, Putty, PL/SQL Developer, Golden 32

MS Office Tools: MS Word, MS Excel, MS: Power Point, MS - Visio

WORK EXPERIENCE:

Confidential, MI

Oracle Database Developer

Responsibilities:

• Created design documents to be reviewed by architect.
• Wrote loader scripts using SQL Loader/External tables to load large tables.
• Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL.
• Optimized queries by obtaining Explain Plan, analyzing tables, providing hints, and adding Indexes on tables where required
• Performed maintenance work on the schedules jobs.
• Actively involved in troubleshooting database issues.
• Provided SQL and PL/SQL code tuning to improve database response time and performance for several applications
• Developed Oracle Stored Procedures, Functions and Packages to effectively in corporate Business rules
• Worked extensively with Composite data types, Cursors and Dynamic SQL
• Worked with Dynamic SQL, Global Temporary Tables
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DBMS SQL, and PL/SQL Collections and used BULK Binding
• Created materialized views, Inline Views & normal views where business requirements needed
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Running the daily/weekly/monthly Appworx scheduled jobs after making the necessary changes to the queries.
• Answering the customer queries by writing the Adhoc SQL and PL/SQL queries.
• Developing Dashboard Reports using Tableau and Excel.
• Worked with development of packages and procedures using PL/SQL and functions using PL/SQL.
• Involved in analysis, development, testing, and production support.
• Participating in the Status calls and Reporting to Manager,

Environment: UNIX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Microsoft Excel, TOAD, Tableau, Cold Fusion, SQL, PL/SQL Developer, SQL*Loader, Toad, SVN, Java, ASP, HP-UX UNIX.

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Wrote loader scripts using SQL Loader/External tables to load large tables.
• Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL.
• Worked with Dynamic SQL, Global Temporary Tables
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DBMS SQL, and PL/SQL Collections and used BULK Binding
• Created materialized views, Inline Views & normal views where business requirements needed
• Developed stored procedures and packages. Extensive work in PL/SQL.

Environment: UNIX, Oracle 11g, PL/SQL, SQL*Plus, SQL*Loader, Microsoft Excel, TOAD, SQL, PL/SQL Developer, Toad, SVN, HP-UX UNIX.

Confidential, DE

Responsibilities:

• Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL.
• Worked with Dynamic SQL, Global Temporary Tables
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DBMS SQL, and PL/SQL Collections and used BULK Binding
• Created materialized views, Inline Views & normal views where business requirements needed
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Support the testing activities and fix the issues on-time to meet the delivery timelines.

Environment: UNIX, Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Microsoft Excel, TOAD, SQL, PL/SQL Developer, ASP, CVS, Toad, HP-UX UNIX.

Confidential

Responsibilities:

• Responsible for developing and modifying several PL/SQL packages procedures, functions, views and triggers using PL/SQL.
• Developed stored procedures and packages. Extensive work in PL/SQL.
• Support the testing activities and fix the issues on-time to meet the delivery timelines.
• Worked extensively with Composite data types, Cursors and Dynamic SQL
• Worked with Dynamic SQL, Global Temporary Tables, materialized views, Inline Views & normal views

Environment: UNIX, Oracle 10g, PL/SQL, SQL*Plus, SQL*Loader, Microsoft Excel, TOAD, SQL, PL/SQL Developer, Coldfusion, Java, ASP, CVS, Toad, HP-UX UNIX.