SUMMARY

• A Technology driven IT professional wif over 6+ years of experience in designing and developing Complex applications, developing Reports for Internet/Intranet based applications.
• Expertise in writing SQL Queries, PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Materialized Views, SQL Trace on Oracle 10g/11g databases.
• Experience in Table Partitioning, creation of indexes for faster database access and better query performance.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Designed and developed OracleReports and Forms for Oracle Applications using Oracle 10g.
• Expertise in development of OracleForms/Reports, New Screen designs, Modifications
• Worked on different level triggers like form level, block level and item level.
• Extensive experience on developing different types of Canvases.
• Developed Master Detail, Detail reports using tabular and Group above reports
• 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
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• 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.
• Expertise in writing Pipeline functions.
• Extensive experience in using Compound triggers.
• Expertise in utilizing oracle Utility tools SQL *Loader, Import and Export.
• Experience wif Oracle SQL and PL/SQL programming and used Database utility tools like SQL Navigator, SQL Plus, TOAD, SQL Developer.
• Expertise in working wif Oracle built - in packages such as DBMS SCHEDULER, UTL FILE, UTL MAIL, DBMS SQL,DBMS JOBS.
• Excellent Analytical, Programming and Reporting skills.
• Experience in Understanding complex performance issues and worked wif DBA’s to suggest valuable ways to fix teh problem.
• Coordinated wif 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, Oracle Forms and Reports.

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

PROFESSIONAL EXPERIENCE

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 wif 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.
• Designed different ORACLE FORMS and REPORTS in ORACLE DEVELOPER SUITE 10g.
• Developed different front end GUI screens using ORACLE FORMS Builder
• Worked on different level triggers (Form level, Block level, Item level) in ORACLE FORMS.
• Developed Master Detail, Detail reports using tabular and Group above reports
• 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.
• Extensive use of Global Temporary Tables (GTT) in staging areas.
• 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, Forms 10g, Reports10g,UNIX, Toad 9.6/9.7

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

• Collaborated wif 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 development of OracleForms/Reports, New Screen designs, Modifications.
• Created, Modified, maintained and debuggedForms andReports using OracleForms and Reports 10g.
• 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.
• Developed Master Detail, Detail reports using tabular and Group above reports
• Involved in creation of Conceptual Modeling covering all teh business requirements.
• Loaded teh data into database tables using SQL*loaderfrom text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Extensively used Ref cursors. worked wif 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).
• 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.
• Worked on admin and user editions of discoverer 10g and used AIM (application implementation methodology) in documenting teh development tasks.
• 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 wif 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.
• Generated various analytical reports using MicrosoftAccess.
• Worked wif 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/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, Oracle Forms 10g,Reports10g,UNIX, Windows XP/2000.owb 10g.

Confidential, Boston, MA

Oracle 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 wif 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, Foster city, CA

Responsibilities:

• Studied user requirements and functional specifications. Converted User Requirements into formal Functional specification and Interfacing wif client.
• Participated in teh design and development of teh project.
• Used Oracle designer to produce teh ER diagrams, Dataflow, function Hierarchy.
• Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures. Developed Database Triggers to enforce security also used ref cursors
• Created and modified SQL*Loader scripts for migrating flat file data into target.
• Used advanced SQL features like Inline views, advanced Joins, Decodes, Indexing, Bulk Inserts, Bulk collects and other analytical functions in 10g.
• Wrote teh extract program to generate theXML file wif consumer details by order, which teh dealers target for their business, using PL/SQL and automate teh process using UNIX shell scripts.
• Designed and developed complex procedures to handle errors and exceptions level using PL/SQL and SHELL scripts.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Written shell scripts and executed them as Cron jobs on UNIX.
• Designed and developed OracleForms & Reports using Forms10g and Reports 10g. Including Forms based on stored procedures
• Supplied packages were used to extend teh functionality of pl/sql programs such as DBMS JOB for scheduling, UTL FILE to read and write from database, DBMS SQL to write Dynamic SQL etc.
• Planned version control of production source code using Concurrent Version System (CVS).
• Using CAB for any production changes and attending teh meeting to get an approval.
• Providing Post production support for XPO, OMS systems.
• Using remedy for ticket tracking.
• Developed database triggers to enforce security. Also implemented materialized views for remote instances.
• Responsible for application testing and support, version control, production staging and implementation planning, overseeing development efforts, support and training.

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