EXPERIENCE SUMMARY:

• 8years of experience in IT industry in all phases of SDLC including requirement gathering,
• Analysis, designing, developing, testing, implementation and maintenance.
• Experience in relational databases like Oracle 11g, 10g
• Knowledge on Sales, Health Care and financial Domain.
• SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes.
• Extensive experience in trouble shooting, Query Optimization and performance tuning.
• Knowledge in Oracle Cursors, Exception Handling, REF Cursors.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Working Knowledge on UNIX shell scripting.
• Experience in Configuration Management, Release management activities.
• Experience in production support model including Batch support, Data fix, Analyzing issues and generating
• Ad - hoc reports to customer.
• Good interpersonal communication and problem solving skills.

TECHNICAL SKILLS

DevelopmentSkills: Creation of Packages, Procedures, Functions, Triggers, Indexes, Partitioning, Performance tuning, Unit test cases.

Creation of ETL mappings through Informatica.: Creation of reports using Business Objects and QlikView.

Languages: SQL - PL/SQL, Unix-Shell

Products: Cúram(IBM product for Health Care)

Tools and Utilities: Quality Center, Toad, SQL Developer Putty, Business Objects XI R2, Informatica 9.1, QlikView 11, PVCS, SVN, Dollar U,BMC Remedy

PROFESSIONAL EXPERIENCE

Confidential New Jersey

OracleDeveloper

Role & Responsibilities

• Worked along wif CúramBusiness analysts and Confidential New Jersey for acquiring business requirements.
• Design and development of PL/SQL objects such as Packages, functions, procedures,
• Triggers etc. to process complex business requirements on Oracle 11g DB
• Modified the existing packages and procedures based on the business requirement.
• Performed performance tuning and Optimization of SQL statements using Oracle Hints, explain plan, TK Prof and table partitioning.
• Involved in creation of UNIX shell scripts.
• Co-ordination wif various teams during deployment activities.
• Smoke testing, IT validation and tracking of migration activities.
• Working alongside wif DBA’s for DB related performance issues.

Confidential

Oracle/Informatica Developer

Responsibilities:

• Worked along wif Business analysts and end users for acquiring business requirements.
• Design and development of PL/SQL objects such as Packages, functions, procedures, triggers etc to process complex business requirements on Oracle DB.
• Created indexes on the tables for faster retrieval of data to enhance database performance.Performed SQL and PL/SQL tuning using Hints, Indexes and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Helping UI developers in creating functions, procedures according to the requirement.
• Creation of mapping through Informatica tool to extract data from different upstream and placing it on server so as to be available to other environments through Gloden Gate replication.
• Using CTRL-M for scheduling of jobs
• Developed complex mapping logic, mapplets, sessions & workflows.
• Created flows by implementing the required business logics and populated various dimension and fact tables by extensively using all the transformations including complex lookups, update strategy, complex expressions, and other transformations in Informatica.

Confidential

Technical Analyst

Role & Responsibilities

• Participated in the weekly meetings wif client and business to understand functional requirements.
• Creating and Maintaining of High Level and Detailed Level Design documents.
• Design and development of PL/SQL objects such as Packages, functions, procedures, triggers etc to process complex business requirements.
• Involved in Performance Tuning for Business critical process by re-coding functions, procedures and packages and creating/adding indexes.
• PerformedSQLandPL/SQLtuning using Hints, Indexes various tools like EXPLAIN PLAN,SQL*TRACE, TKPROF and AUTOTRACE.
• Used hints to direct the optimizer to choose an optimum query execution plan.
• Extensively used bulk collection inPL/SQLobjects for improving the performing.
• Client Interactions for escalations regarding production issues, data corrections, performance improvements and enhancements.
• Providing production support to the application.
• Created Dollar U jobs which would run on daily basis in order to extract records from various upstreams.
• Created Perl Scripts to call the backend packages.
• Migration of the code to different environments through Kintana tool.
• Coordination wif various teams during deployment activities.
• Used Quality Center for checking and updating on the defects assigned to the team.

Confidential

As an Intern

Role & Responsibilities

• Was involved in Migration and enhancements from current platforms to Oracle
• Development of PL/SQL objects such as Packages, functions, procedures, triggers etc to process complex business requirements.
• Involved in Performance Tuning for Business critical process by re-coding functions, procedures and packages and creating/adding indexes.
• PerformedSQLandPL/SQLtuning using Hints, Indexes various tools like EXPLAIN PLAN,SQL*TRACE, TKPROF and AUTOTRACE.
• Used hints to direct the optimizer to choose an optimum query execution plan.
• Extensively used bulk collection inPL/SQLobjects for improving the performing.