SUMMARY

• Having 7 years of IT experience complemented by analysis, design and developing skills.
• Experience in projects involving object oriented methodologies.
• Working expertise in Relational Database Systems like Oracle.
• Strong Programming experience in PL/SQL and DEVELOPER - 2000.
• Used Dynamic LOV by handling Record Group programmatically.
• Developed Forms Library to use as common object.
• MDI application with multiple windows and canvas interfaces.
• Used all important Form triggers and Built-in packages.
• Used Report triggers.
• Experience in development of Packages, Procedures, Functions and Triggers.
• Performance tuning which included creating indexes and modifying tables using Explain plan utility.
• Created materialized views.
• Created Public Synonyms and Database Links public/private.
• Hands on experienced with Oracle Forms 6i/9i/10g and reports generation with Oracle Reports 6i/9i/10g.
• Proficient in advance features of Oracle 9i for PL/SQL programming like Using cursor variables, Ref. cursors, Varrays, nested tables and Dynamic SQL.
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
• Proficient in Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF, and Auto trace.
• Expertise in handling errors using Exceptions.
• Good experience of direct interaction with client.
• Versatile team player with good analytical and problem solving skills.

TECHNICAL SKILLS

Programming Languages: SQL/PLSQL, JAVA

Databases: Oracle11g/10g/9i

Tools: Oracle D2K, Oracle Developer Suite, Developer/2000 Forms 5.0/6i,10g & Reports 6i,10g, TOAD, SQL Developer, Pl/SQL Developer, JDeveloper, SQL*Loader, SQL*PLUS

BI Tool: Qlik View

Operating Systems: Windows XP/2000, UNIX

Web Technologies: HTML, XML

Office Applications: Word, Outlook, Power point, Excel

PROFESSIONAL EXPERIENCE

Confidential, MD

Sr Oracle Developer

Environment: Oracle 10g, SQL plus, PL/SQL, Java, J2EE, Windows XP, Toad 9.0, Putty Connection Manager, Win SCP, Oracle Forms

Responsibilities:

• Created Oracle PL/SQL procedures and packages to transfer and process customers data.
• Wrote SQL statement for ad-hoc report generation and for data cleansing.
• Responsible for the designing the advanced SQL queries, procedure, cursor, triggers, scripts
• Used Advanced Oracle PL/SQL techniques like cursors and bulk collect for data retrieval.
• Tuned the complex SQL queries for the better performance.
• Used SQL*LOADER for loading the data into the database using control files.
• Prepared SQL scripts to validate the data in the Report.

Confidential

Sr. Oracle Developer

Responsibilities:

• Generated SQL and PL/SQL scripts to install, create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Performed analysis, design, coding, implementation and support
• Developed Stored Procedure, Package and Triggers for back end validations
• Developed procedures using Oracle supplied Packages for Notifications
• Developed additional localizations.
• Involved in migrating oracle from 9i to 10g
• Developed complex SQL queries using joins and correlated sub queries.
• Created indexes for faster access of data.
• Documented business rules, functional and technical design, test cases and user guides. Involved in debugging and error handling.
• Created TABLESPACE, schemas, tables, views and index.
• Created Data Flow Diagrams, Flow Charts, ER-Diagrams and Work Flow Diagrams in Requirement Collection, Analysis and Design for the required application.
• Coded and debugged triggers at various levels and involved in testing of each module
• Developed shell scripts for automating the batch programs.
• Tuned the stored procedures and the database for the better performance.

Environment: Oracle 10g, Oracle Forms & Reports 10g, SQL plus, shell Scripts, SQL, PL/SQL, PL/SQL Developer, SQL*Loader Windows XP, Toad 9.0, Putty Connection Manager, WinSCP

Confidential, NY

Oracle PL/SQL Developer

Environment: Oracle 10g, PL/SQL, SQL Developer, Java, J2EE, JDBC, UNIX, Toad 9.0, Oracle OWB, Clear Case

Responsibilities:

• Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per User requirements to make new enhancements.
• Developed and designed UI using Oracle forms developer tool.
• Designed and developed interfaces b/w Java (frontend) and Oracle (backend) using PL/SQL.
• Designed & developed reports.
• Prepared SQL scripts to validate the data in the Report.
• Participated in regular project status meetings related to testing.
• Performed Report testing by validating layout, data in the report.
• Performed Change Request whenever the customer needs to change their existing Business Rules or they may integrate a new rule.
• Seamless Client / Onsite Co ordination with the Offshore Team to proactively identify and mitigate risks / issues.
• Creating and maintaining project documents for the subsystem. Ensuring appropriate use of methods, tools and techniques within the team.
• Worked on SQL scripts to load data in the tables.
• Learned usage of ETL tool Oracle OWB.
• Developed OWB mappings and defined transformation code rules.
• Performed UAT.
• Source Code Version Controlling.
• Handling Problem Requests of end users.

Confidential

Oracle PL/SQL Developer

Environment: Oracle Forms & Reports Developer 6i, Oracle10g, PL/SQL, Windows XP.

Responsibilities:

• Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per User requirements to make new enhancements.
• Developed User Interfaces.
• Designed, developed and tested various Outstanding/CN/DN/Adjustment reports.
• Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
• Developed PL/SQL packages, procedures, functions.
• Designed and Developed forms & Reports.
• Prepared test cases and performed unit testing.
• Performed UAT.
• Overall Billing & Performance against Target
• Overall Collection against Target
• Combined Published Space
• Combined Realization Break-up Summary
• Party/Client Ledger etc-
• Implemented major MIS reports using Qlik View

Confidential

Environment: Oracle Developer Suite 10g, Oracle10g, PL/SQL, SQL plus, Windows XP, BI Tool Qlik View.

Responsibilities:

• Developed PL/SQL packages, procedures.
• Designed & Developed Procedure based forms.
• Designed & developed reports.
• Prepared SQL scripts to validate the data in the Report
• Performed Report unit testing by validating layout, data in the report.
• Creating and maintaining project documents. Ensuring appropriate use of methods, tools and techniques within the team.