SUMMARY

• Over 7 years of experience in Analysis, Design, Development, Testing, Implementation and Support of IT systems.
• Expertise in Oracle 8i/9i/10g and in developing packages, functions, procedures, triggers, clusters, views, native dynamic SQL using SQL and PL/SQL.
• Experience inPerformance AnalysisandSQL query tuning, reducing response time, while designing scalable applications from scratch and maintaining existing ones, usingAWR, Explain Plan and OEM. Good noledge of key Oracle performance - related features, such asQuery Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning, V$-views.
• Strong noledge in Oracle cursor management and exception handling.
• Proficient in data loading/extraction using SQL*Loader, external tables and Oracle utilities.
• Knowledge in performing logical database backup and recovery using Oracle’s EXPORT/IMPORT.
• Worked on in design and deployment of Unix Shell Scripts.
• Experience inBusiness Analysis, gathering of business requirements, functional and technicalspecification writing.
• Skilled in gathering user requirements by performing gap analysis and translating them into functional specifications.
• Performed various types of testing, such as functional, system, regression and user acceptance testing.
• Experience in implementing software development standards, business and IT processes.
• Worked in CMMi Level 5 and ISO 9001-2000 certified environment.
• Experienced in Training, Documentation and Implementation in a business environment.
• Strong experience on working with Procedures for improving the load performance in various schemas across databases using appropriate HINTS.
• Hard hand in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Experience with ETL process and job scheduling using PLSQL.
• Proficient experience in working on conceptual, physical and logical data models using various Data Modeling tools like Erwin 3.5,4.0,4.1,7.1,7.2, Designer 2000, MS Visio.
• Experienced in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS) and Report Development.
• Excellent analytical and interpersonal skills, oral and written Communication Skills.

TECHNICAL SKILLS

• Oracle 11g/10g/9i/8i
• MS Access
• Forms 9i
• Oracle Reports 9i
• TOAD
• SQL Developer
• Erwin 4.1.4
• SQL
• PL/SQL
• C
• C++ c#
• ASP
• Java
• Shell Scripting
• Visual Basic 6.0
• MS Office Suite
• MS Visio
• MS visual studio
• TFS
• PVCS
• MS VSS
• CVS
• SVN
• Windows 9x/NT/2000/XP
• UNIX IBM AIX 5.2.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Oracle PL/SQL Developer

Responsibilities:

• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
• Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Use of PL/SQL bulk collection and DML (insert/update/delete) methods.
• Encapsulated error handling and use of autonomous transaction for logging.
• Used UTL FILE for exporting data and UTL MAIL to generate E-mails.
• Extensively used PL/SQL features like collections, nested table, Varray and Bulk collect for high performance of stored procedures
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade.
• Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms, etc.
• Extensively worked on writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries).
• Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
• Suggested and implemented improvements to legacy systems.
• Developed multiple reports for IT needs to identify and improve performance.
• Responsible for SQL tuning using explain plan, tkprof utility, optimizer hints.
• Involved in RDBMS design and developed ER-diagrams using Erwin.
• Participated in code walkthroughs and review sessions with the development team.
• Worked with multiple vendors to facilitate integration of systems.
• TEMPEffectively documented and archived historical data for future auditing purposes.

Confidential, NJ

Oracle Developer/DBA

Responsibilities:

• Confidential in addition to providing pharmaceutical supplies to domestic and international pharmacies also provides patient assistance program. dis private and confidential program provides patients with huge discounts or in most cases free medications who has difficulty affording them. According to dis program, the patient provides his income details, personal details dat are stored into PA database which goes through rounds of programming checks to make sure dat the patient is eligible for the program. In addition, it also goes through higher management review for final approval. Once the final approval is done, patient is provided for free medication for maximum one year. All the invoices for medication, their shipment are being handled through PL/SQL procedures, functions, cursors and packages dat are tan sent to the shipping department dat handles the packaging and shipping of the medication. Project also involves writing database triggers for security and logging of events. Involved in design, development of end user screens and reports using Oracle Forms and Reports.
• Understanding the Business process/requirement by interacting with business users for successful deployment.
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
• Developed SQL Queries to fetch data from different tables using complex joins.
• Created PL/SQL Packages, Procedures and Functions for implementing the business processes for claims adjudication.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Tuned performance of existing SQL statements and PL/SQL code by using different methods of performance tuning techniques like Explain Plan and Hints.
• Developed Static & Dynamic (REF) Cursors, Records & Exception handlers.
• Worked with large tables and created partitions for managing the large tables.
• Created audit table to record the Updates and Inserts on the tables by creating database triggers.
• Involved in design, development of end user screens and reports using Oracle Forms and Reports.
• Involved in loading data using Oracle SQL*Loader.
• Writing small UNIX shell scripts for automating jobs.
• Involved in creating data models and object models.
• Participation in weekly design reviews and walkthroughs with project manager and development team.
• Interacting with the Front End Team to in corporate the required functionality for their screens and processes.

Confidential, Chicago, IL

Oracle Developer/Support Analyst

Responsibilities:

• Understanding and Analysis of the requirement specifications of the client.
• Designed and developed PL/SQL functions, stored procedures, cursors, packages, triggers.
• Involved in writing complex queries to generate processes as per client request.
• Created Sequences to generate unique numeric values.
• Tuned complex SQL statements, complex joins co-related sub-queries which were taking too much time to run by using Explain Plan and Hints.
• Rebuild Indexes for better performance during query execution.
• Wrote extensive Exception handling procedures to handle exceptions.
• Involved in creating different kinds of partitions for managing large tables.
• Used TOAD for creating PL/SQL and SQL Scripts to debug and test the code
• Enforcing data Integrity using integrity constraints and database triggers as per data model.
• Utilizing Built in Oracle Packages like UTL FILE, DBMS OUTPUT for better debugging.
• Generated UNIX shell scripts to automate batch jobs and loading process.
• Responsible for user acceptance test, post production support and train end users for TEMPeffective usage of the software package.
• Managing Knowledge transfer sessions for deployment and support resources.
• Supporting and enhancement of the application based on the feedback provided by the Users.
• Identify and respond to faults and performance degradations, monitor application for security breaches, identify and resolve security-related events and follow escalation procedures.

Confidential, GA

Oracle PL/SQL Developer/Analyst

Responsibilities:

• Analyze enhancement requests and develop detailed specifications.
• Developed Stored Procedures for creating financial reports like size and style report, asset class report, account valuation reports, etc.
• Use SQL*Loader utility to load data files into tables, Export and Import Oracle Utilities to move tables between Schemas for logical backup.
• Developed UNIX shell scripts and generate scripts using SQL*Plus.
• Performance optimization, procedure definition, queries tuning, database design.
• Wrote packages, procedures & triggers using PL/SQL to enforce business functionality.
• Extensively Used PL/SQL to write cursors and ref cursors for acquiring information to be used in calculations written in stored procedures.
• Used PL/SQL bulk collection, cursor for loop, bulk insert using forall and DML (insert/update/delete) methods.
• Wrote code to handle exception during bulk operation and used dynamic SQL.
• Change Identification for Bank Specific Products and Parameters for the general banking.
• Understand and articulate business requirements from user interviews and tan convert requirements into technical specifications.
• Identified new processes, found out gaps in existing process, and arranged training for new process development and implementation.

Confidential, Baltimore, MD

Oracle Developer/Analyst

Responsibilities:

• Extensively worked on requirement gathering, analysis, use case designing and testing related to general packaging industry.
• Held regular meetings in the form of JAD sessions with the business sponsors, users, stake holders, system architects, developers, database developers, quality testers during the entire project to assure dat the critical as well as the minute details of the project were discussed and issues were resolved beforehand.
• Performance optimization, procedure definition, queries tuning, database design.
• Complex database programming for triggers, procedure and created integrity constraints and triggers needed to guarantee data Integrity.
• Designed, created data entry screens to facilitate the business requirements.
• Involved in creating UNIX shell scripting.
• Created and executed detailed test plans and scripts to verify software functionality and adherence to business requirements.
• Developed user manuals, presentations and training manuals as per project specifications and timelines.
• Worked on Very Large Database Environment in terabytes. And tuned queries for performance
• Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation.
• Worked in partnership with project team, functional team leads and functional end-users to identify and document business process improvement opportunities and complete the definition of requirements for system design, implementation & training.
• Conducted technical/non-technical presentations to the management and training workshops for the clients.

Confidential

PL/SQL Developer/Database Designer

Responsibilities:

• Used Dynamic SQL for DDL commands in PL/SQL.
• Creating and managing schema objects like tables, indexes, views, synonyms and clusters.
• Actively involved in detail design, development and testing phases of SDLC.
• Interacted with user to identify the user requirement from various groups/level of user and defined Entity relations ship diagram.
• Used various kinds of control structures including case, decode, if-tan-else, for loops, while loops while developing procedures.
• Wrote Cursors for acquiring information to be used in calculations written in stored procedures.
• Writing Unit Test Cases and Test Scripts for Manual Testing.
• Debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database