SUMMARY

• Over 7 years of experience in Analysis, Design, Development, Testing, Implementation and Support of IT systems.
• Expertise in Oracle 8i/9i/10g/11g and in developing packages, functions, procedures, triggers, clusters, views using SQL and PL/SQL.
• Extensive programming experience in Oracle 10g/11g Developer suite (Oracle Forms and Reports).
• Hands on experience developing Master Detail Forms, Query Find Forms, Multiple canvases using forms 10g/11g.
• Expert in developing Tabular reports, Form - like, Matrix, Matrix with Group, Group left, Group above reports using Oracle 6i/9i/10g.
• Developed various complex reports. The reports involved complex queries in Data Model, Complex Layouts, used the functionality of Additional default layout, Parameters, Program Units and the use of report triggers.
• Oracle Certified Associate.
• 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.
• Strong knowledge in Oracle cursor management and exception handling.
• Hands on experience in design, development of end user screens and reports using Oracle Forms and Reports.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Worked on in design and deployment of Unix Shell Scripts.
• Have good Technical and Functional knowledge on Oracle E-Business suite 11i/R12.
• 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.
• Experienced in Training, Documentation and Implementation in a business environment.
• Knowledge in performing logical database backup and recovery using Oracle’s EXPORT/IMPORT.
• Improved performance of PL/SQL program units by using Bulk binding with Collections.
• Hard hand in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Moved columns of data into and out of database tables using PL/SQL program units by passing collections as parameters.
• Excellent analytical and interpersonal skills, oral and written Communication Skills.

TECHNICAL SKILLS

• HP-UX
• SUN Solaris
• Windows NT/XP/2000
• Linux
• SQL
• SQL*Plus
• PL/SQL
• Pro*C
• C
• UNIX Shell Scripting
• Oracle Forms 6i/9i/10g/11g
• Oracle Reports 6i/9i/10g
• Developer 2000
• SQL developer
• Oracle 7.3 8 8i 9i 10g 11g
• INFORMATICA
• COGNOS
• Toad
• SQL Navigator
• SQL*Loader
• Oracle EBS(11i/R12)
• AOL concepts
• XML Publisher

PROFESSIONAL EXPERIENCE

Confidential, Secaucus, NJ

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.
• Used UTL FILE for exporting data and UTL MAIL to generate E-mails.
• Extensively used PL/SQL features like collections, nested table, V array 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).
• Suggested and implemented improvements to legacy systems.
• Developed customer form with multiple canvases to be displayed based on the pressing of buttons to view required data.
• Developed a new supplier form(Master Detail's) Form.
• Developed new reports and modified existed reports based on user requirement.
• Developed various complex reports. The reports involved complex reports and the use of report triggers.
• Developed multiple reports for IT needs to identify and improve performance.
• Responsible for SQL tuning using explain plan, TkProf utility, optimizer hints.
• Participated in code walkthroughs and review sessions with the development team.
• Worked with multiple vendors to facilitate integration of systems during merger.
• Effectively documented and archived historical data for future auditing purposes.
• Responsible for production support and troubleshooting production issues.

Confidential, Greensboro, NC

Oracle Developer/DBA

Responsibilities:

• 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 loading data using Oracle SQL*Loader.
• Writing small UNIX shell scripts for automating jobs.
• Involved in creating data models and object models.
• Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation of the code.
• 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 effective 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, Woodbridge, NJ

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 with the team members in developing the Test Plan and Test cases for Unit testing for validation.
• Change Identification for Bank Specific Products and Parameters for the 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 training for new process development and implementation.
• Developed user manuals, presentations and training manuals as per project specifications and timelines.
• Conducted technical/non-technical presentations to the management and training workshops for the 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, Colorado Springs, CO

Oracle Developer/Analyst

Responsibilities:

• Extensively worked on requirement gathering, analysis, use case designing and testing related to General Banking.
• 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 that 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.
• Change Identification for Bank Specific Products and Parameters for the general banking.
• Developed user manuals, presentations and training manuals as per project specifications and timelines.
• 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.
• Implementation and production support for B@ncs24 Software related issues.

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-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 the PL/SQL code, tuning queries, optimization for the Oracle database