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 knowledge of key Oracle performance - related features, such asQuery Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning, V$-views.
• Strong knowledge in Oracle cursor management and exception handling.
• Proficient in data loading/extraction using SQL*Loader 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 certified environment.
• Experienced in, Documentation and Implementation in a business environment.
• Strong experience on working wif Procedures for improving teh load performance in various schemas across databases using appropriate HINTS.
• Hard hand in interacting wif business analysts and developers to analyze teh user requirements, functional specifications and system specifications.
• 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#
• Java
• Shell Scripting
• Visual Basic 6.0
• MS Office Suite
• MS Visio
• MS Project 2003
• PVCS
• MS VSS
• CVS
• SVN
• Windows 9x/NT/2000/XP
• UNIX Confidential AIX 5.2.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Oracle Developer/Analyst

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 wif 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.
• Modified XSD to validate incoming XML’s which improved efficiency and overall system Performance.
• 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 wif teh development team.
• Worked wif multiple vendors to facilitate integration of systems.
• Effectively documented and archived historical data for future auditing purposes.
• Responsible for production support and troubleshooting production issues.

Confidential, Merck, NJ

Oracle Developer/DBA

Responsibilities:

• Understanding teh Business process/requirement by interacting wif 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 teh business processes for claims adjudication.
• Gatheird 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 wif large tables and created partitions for managing teh large tables.
• Created audit table to record teh Updates and Inserts on teh tables by creating database triggers.
• 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 wif project manager and development team.
• Interacting wif teh Front End Team to in corporate teh required functionality for their screens and processes.

Confidential, Chicago, IL

Oracle Developer/Support Analyst

Responsibilities:

• Understanding and Analysis of teh requirement specifications of teh 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 teh 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 effective usage of teh software package.
• Managing Knowledge transfer sessions for deployment and support resources.
• Supporting and enhancement of teh application based on teh feedback provided by teh Users.
• Identify and respond to faults and performance degradations, monitor application for security breaches, identify and resolve security-related events and follow escalation procedures.

Tools: and Technology:UNIX, Windows XP, Oracle 10g, PL/SQL, Toad 9.0, HP Quality Centre, Autosys Job Scheduler

Confidential, GA

Oracle Developer/Analyst

Responsibilities:

• Analyze enhancement requests and develop detailed specifications.
• Worked on requirement gathering, analysis, use case designing and testing.
• Use SQL*Loader utility to upload data files into tables, Export and Import Oracle Utilities to move tables between Schemas.
• 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 for acquiring information to be used in calculations written in stored procedures.
• Worked wif teh team members in developing teh Test Plan and Test cases for Unit testing for validation.
• Change Identification for Bank Specific Products and Parameters for teh general banking.
• Understand and articulate business requirements from user interviews and then convert requirements into technical specifications.
• Identified new processes, found out gaps in existing process, and arranged for new process development and implementation.
• Developed user manuals, presentations and manuals as per project specifications and timelines.
• Conducted technical/non-technical presentations to teh management and workshops for teh clients.
• Implementation and production support for B@ncs24 Software related issues.
• Created UML diagrams including context diagrams, use case diagrams and sequence diagrams to define business process model.

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 teh form of JAD sessions wif teh business sponsors, users, stake holders, system architects, developers, database developers, quality testers during teh entire project to assure that teh critical as well as teh minute details of teh 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 teh 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 manuals as per project specifications and timelines.
• Worked on Very Large Database Environment in terabytes. And tuned queries for performance
• Worked in partnership wif project team, functional team leads and functional end-users to identify and document business process improvement opportunities and complete teh definition of requirements for system design, implementation &
• Conducted technical/non-technical presentations to teh management and workshops for teh clients.

Confidential, Vidyanagar, IN

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 wif user to identify teh user requirement from various groups/level of user and defined Entity relations ship diagram.
• Used various kinds of control structures including case, decode, if-then-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 teh PL/SQL code, tuning queries, optimization for teh Oracle database