OBJECTIVE

• Aim to associate wif organization that provides me an opportunity to show my skills and improve knowledge wif teh latest trends and to be part of teh team that works dynamically towards growth of teh organization.

SUMMARY

• 7+ years of experience in systems Analysis, design and development of complex software systems in Banking, Finance, Health sectors.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
• Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments.
• Experience in Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques.
• Knowledge of ETL process consists of data transformation, sourcing, mapping, conversion and loading.
• Familiar wif ETL tool Informatica having knowledge of transformations and mappings.
• Expertise in writing and executing teh Test Cases, Test Data and Defect management using Defect Trackers.
• Worked as Team lead, and led a team in two assignments and successfully implemented teh project before given deadline.
• Excellent team player and proven track record working in various team sizes performing cross - functional roles.

TECHNICAL SKILLS

Databases: ORACLE 9i/10g/11g, MS SQL Server 2005.

Languages: SQL, Oracle PL/SQL

ETL: Informatica Power center 8.1

Web: HTML, JavaScript, CSS.

Scripting tool: Unix Shell Script, Perl

Scheduling Tools -: Control -M.

Tools: /utilities: SQL*Plus, SQL* Loader, TOAD 9.0, Putty, WinSCP, Cygwin, PL/SQL Developer, Quality Center, LotusNotes, Eclipse.

Operating System: DOS, Windows 9x/NT/2000/XP, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential

Lead PL/SQL Developer

Responsibilities:

• Understanding Business requirements.
• Analyzing them and preparing teh Approved requirements list (ARL).
• Preparing teh tagging document for Insight and SiteCatalyst tags.
• Documenting teh System Prospectus and SDS/TSD documents and business review.
• Design, implementation and testing of PL/ SQL scripts.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate teh functionality for various modules.
• Involved in tuning of queries for better performance.
• Developing daily/weekly/monthly reports and review wif business.
• Scheduling teh jobs using Control-M scheduling tool and documenting teh processes.
• Enforcing Best Development Practices.
• Also mentored junior team members.

Environment: Oracle 10g, PL/SQL, Toad 9.0, Quality Center, Informatica Power center 8.1, Control-M.

Confidential

Senior PL/SQL Developer

Responsibilities:

• Understanding teh Approved requirements list (ARL), SDS/TSD documents.
• Created tables, Views, Packages, developing SQL and writing PL/SQL scripts.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Responsible for development of packages that implement business logic.
• Design, implementation and testing of PL / SQL scripts
• Scheduling teh jobs using Control-M scheduling tool and documenting teh processes.
• Tag testing for Insight and SiteCatalyst tags using HttpWatch Tool.
• Developing daily/weekly/monthly reports.
• Making clicks to generate raw logs to test teh reports and process them.
• Preparation of Unit test cases.
• Responsible for Development and testing of reports.
• QA support for teh testing team.
• Enforcing Best Development Practices.
• Acts as a technical resource for Web analytics projects.

Environment: Oracle 9i/10g, Toad 9.0, Quality Center, Putty, Informatica Power center 8.1, Control-M.

Confidential

Senior PL/SQL Developer

Responsibilities:

• Preparing and Understanding Technical specification SDS/TSD documents.
• Created views joining multiple tables to facilitate easy interface implementation and enforce security on critical customer information.
• Worked on inline and correlated sub queries based on business context.
• Extensive PL/SQL programming including Development of new backend packages, procedures and functions to in corporate advanced modules.
• Design, implementation and testing of PL / SQL scripts
• Used SQL*loader to load data into tables from Flat, CSV and text files.
• Creating OPDOCS for Job scheduling and Used Control-M scheduling tool for scheduling teh jobs.
• Preparation of Test Plans and test cases according to teh business requirements..
• QA support for teh testing team along wif production support for teh onsite team.
• Enforcing Best Development Practices.

Environment: Oracle 9i/10g, Toad 9.0, UNIX shell scripting, Informatica Power center 8.1, Quality Center, Putty, Control-M.

Confidential, NJ

PL/SQL Developer

Responsibilities:

• Analyzed teh business requirements for teh enhancements needed in teh contract Administration application and related policy modules.
• Documented teh detailed requirements and prepared DLD for teh new enhancements.
• Performed several DDL, DML and TCL operations.
• Created database packages wif related functions and procedures.
• Created views by joining multiple cash flow tables to show output as a report to teh user.
• Provided support to QA team.
• Creation and Execution of teh Functional Test Cases
• Defect Logging and Tracking using LotusNotes.
• Providing solutions for teh defects which exist in teh claim data.

Environment: MS SQL Server 2005, PL*SQL, Toad, Lotus Notes.

Confidential, NJ

Quality Assurance

Responsibilities:

• Creation and Execution of teh Functional Test Cases.
• Defect Logging and Tracking using LotusNotes.
• Providing solutions for teh defects which exist in teh claim data.
• Fixing teh errors which are raised by validating teh claim data, as teh defect fixing is teh critical part of dis project.
• Had opportunity of leading teh team.

Environment: Mainframe, MS Excel, Informatica, Lotus Notes.