SUMMARY

• A Technology driven IT professional with over 7 years of experience in designing and developing Complex applications, developing Reports for Internet/Intranet based applications using Oracle..
• Experience using SQL in a large - scale relational database environment.
• Expertise in writing SQL Queries, PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Materialized Views, SQL Trace on Oracle 10g/11g databases.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Extensive experience in database programming using SQL and PL/SQL.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL coding.
• Managed many database tables using Views and Sequences.
• Scheduled complex cron jobs on UNIX platform using crontab format.
• Involved in handling large volumes of data.
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Experience in Table Partitioning, creation of indexes for faster database access and better query performance.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and different file formats utilizing oracle Utility tools SQL *Loader, Import and Export.
• Worked on Performance Tuning and SQL optimization.
• Expertise in using Excel spreadsheets.
• Expertise in writing Pipeline functions.
• Extensive experience in using Compound triggers.
• Planned, Designed and Implemented Table Partitioning for improving performance.
• Expertise in utilizing oracle Utility tools SQL *Loader, Import and Export.
• Experience with Oracle SQL and PL/SQL programming and used Database utility tools like SQL Navigator, SQL Plus, TOAD, SQL Developer.
• Expertise in working with Oracle built-in packages such as DBMS SCHEDULER, UTL FILE, UTL MAIL, DBMS SQL,DBMS JOBS.
• Experience of building and maintaining Microsoft Excel Spreadsheets, Pivot tables and Macros.
• Excellent Analytical, Programming and Reporting skills.
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix teh problem.
• Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure teh timely release of project.
• Good communication skills, inter personal skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

Scripting: PL/SQL, SQL, C, C++, UNIX

Web Technologies: HTML, HTML5, XML

Database: Oracle 9i/10g/11g, SQL Server, Ms Access 2000.

Operating Systems: Windows 95/98/NT/XP/Vista, Windows 2007, UNIX, Linux

Tools: /Utilities/IDE SQL Developer, Putty, SQL Navigator, SQL*Plus, SQL*Loader, TOADAQT (Advanced Query Tool), Oracle forms and reports 9i.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Oracle SQL Developer

Responsibilities:

• Collaborated with teh Business analysts and teh DBA for requirements gathering, business analysis, testing and project coordination
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing CRONTAB to schedule teh information of cronentries.
• Involved in creation of Conceptual Modeling covering all teh business requirements.
• Loaded teh data into database tables using SQL*loaderfrom text and excel files.
• Worked with teh Data mart team and involved in teh development process.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Extensively used Ref cursors.
• Used external hints during teh SQL optimization to fast up teh SQL process. worked with bulk collect to Implement teh performance of multi row queries
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Remediate Oracle application Custom object components like Forms, report and Concurrent Program (PLSQL code)
• Involved in development of Oracle Forms/Reports, New Screen designs, Modifications.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Implemented SQL and PL/SQL stored procedures.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert teh valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying teh errors.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Developed UNIX Shell scriptsto automate table creation, execute procedures.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g,Reports10g,UNIX, Windows XP/2000.owb 10g.

Confidential, Jersey City, NJ

Oracle PL/SQL developer

Responsibilities:

• Analyzed teh business requirements for teh enhancements needed in teh contract Administration application and related policy modules.
• Performed several DDLand DML operations.
• Created database packages with related functions and procedures.
• Developed views by joining multiple cash flow tables to show output as a report to teh user.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in corporate advanced modules.
• Worked on BULK COLLECT for bulk loading teh data into various transaction tables.
• Implemented various UNIX scripts to generate teh data in delimited format.
• Used UTL FILE to load teh data into oracle tables from FLAT, CSV and Text files.
• Added database triggers to some history tables of teh database for keeping track of updates to values in a history table.
• Worked on Performance tuning using Explain plan, TK PROF.
• Performed SQL Query Optimization for better performance.
• Developed various forms and reports using Oracle Forms and Reports builder 10g.
• Extensive use of Global Temporary Tables (GTT).
• Refreshed teh development and test databases using export/import utilities.
• Used external hints during teh SQL optimization to fast up teh SQL process.
• Worked on Ref cursors.
• Used pipelined functions for better performance.
• Implemented various automated UNIX shell scripts to invoke PL/SQL anonymous blocks, stored procedures, functions and packages.
• Worked on inline and correlated Sub queries based on business context.
• Implemented various customized Oracle reports using different techniques in Oracle SQL/PLSQL like SQL*Plus reports.
• Extensive and in depth analysis of teh problem tickets to dig out teh root cause for teh problems.
• Involved in Impact analysis of teh defects to teh associated functionalities and modules in teh Production environment.
• Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Environment: Oracle 11g/10g, PL*SQL, SQL Developer, SQL*Plus, Export & Import Data, UNIX, Toad 9.6/9.7

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Hands on experience for performance tuning on existing SQL to improve application performance.
• Involved in all phases of SDLC as active participant.
• Has a very good exposure on technical documentation.
• Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
• Expertise in creating functional/technical specifications, testing scenarios, preparing test cases.
• Strong drive and determination to meet targets and deadlines.
• Works quite well under pressure, has a can do attitude.
• Involved in project plan and Risk plan.
• Created Materialized views for summary reports and extracts for better query performance.
• Used various Indexing and partition techniques to improve teh query performance.
• Strong experience to analyze teh existing and proposed systems.
• Based on requirements estimations provided for new development and enhancements.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Implemented SQL and PL/SQL stored procedures.
• Exposed on UNIX scripts and environment.
• Hands on experience to create views, stored procedure, Packages.
• Interacted with business analyst and software developers for bug reviews and participated in QA meetings.
• Used Explain Plan and AWR reports to tune teh complex queries and debug teh queries to provide exact solution.
• Conducted brainstorm meetings and suggested performance improvement techniques and proposed designs.
• Review teh test cases and code developed by team members.

Environment: Oracle 10g, UNIX, PL/SQL, Shell Script, Windows XP, Clear Case, Clear Quest, Unix Shell scripts, SQL navigator, SQL * Loader, Microsoft Visual web developer 2009

Confidential

Jr.Oracle developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing CRONTAB to schedule teh information of cronentries.
• Involved in creation of Conceptual Modeling covering all teh business requirements.
• Loaded teh data into database tables using SQL*loaderfrom text and excel files.
• Worked with teh Data mart team and involved in teh development process.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Extensively used Ref cursors. worked with bulk collect to Implement teh performance of multi row queries
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Remediate Oracle application Custom object components like Forms, report and Concurrent Program (PLSQL code).
• Involved in development of OracleForms/Reports, New Screen designs, Modifications.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Implemented SQL and PL/SQL stored procedures.
• Upgraded to Forms 10g, Reports 10g, maintained and troubleshoot OracleForms and Reports.

Environment: Oracle 11g/10g, Forms 10g, Reports10g, Designer 10g, SQL*Plus, XML, SQL Developer, PL/SQL, HP-UX, Windows NT/2000