SUMMARY

• Over 8 years of experience in Analysis, Design, Development, Testing, Implementation and Support of IT systems.
• Expertise in Oracle 11g/10g/9i/8i 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 11g/10g.
• Expert in developing Tabular reports, Form - like, Matrix, Matrix with Group, Group left, Group above reports using Oracle 10g/9i/6i.
• 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.
• 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
• Developer 2000
• SQL developer
• Oracle 11g 10g 9i 8i 8 7.3
• INFORMATICA
• Toad
• SQL Navigator
• SQL*Loader
• Oracle Reports 6i/9i/10g
• Oracle EBS(11i/R12)
• XML Publisher

PROFESSIONAL EXPERIENCE

Confidential, MD

Oracle Developer

Responsibilities:

• Develop and implement ETL process from scratch for end to end process to integrate data for the new Database coming from legacy system.
• Provide enhancement to the existing ETL process based on the desire functionality.
• Gathered requirements and converting those business requirements intoETLspecifications.
• Write DDL scripts to create new Database Objects like Tables, Views, Sequences, Synonyms and indexes.
• Create new Packages, Procedure and triggers to fulfill business requirements.
• Performance tuning changes to the existing SQL and PL/SQL code.
• Write ComplexPL/SQLscript, Analytical Function using Cursors, Collections, and DynamicSQL.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
• Migrate data from Flat File toOracleDatabase Table usingSQL*LOADER.
• Write cursors and REF Cursors for transaction processing.
• Use exception-handling methods along with RAISE APPLICATION ERROR in order to associate our own created exception names.
• Developed a new environment for the exiting database for testing purpose.
• Support CDC (Change data capture process) as a part of US ON call team and to give support WFIS team.
• Provide production support for the nightly Batch and end of the month Pooling.
• Work on the Defects and Problem ticket which incurred during the nightly Production batch.
• Dealt with various datafix on daily basis.
• Interact with business users on daily basis for the necessity of deliverables.
• Write various small shell scripts to be called from the Main CDC script.
• Developed Packages for Auditing Purpose for the user which would generate reports on daily basis after the Batch Completes.
• Suggested and implemented changes to the existing system.
• Implement new scheduler jobs for reporting purpose.
• Worked on changing the process of SYNC CDC to ASYNC CDC.
• Tested ASYNC CDC with various DBA Capture parameters like SPILL THRESHOLD LIMITS and Degree of Parallelism.
• Worked on Improving the various stream Process for the ASYNC CDC and carried out bench mark test for the same.
• Implemented various changes to the DDL and PL/SQL for various releases.
• Involved in various bench mark test for the CDC process improvements.

Confidential, IL

Oracle Developer

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.
• 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 Cronjobs.
• 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, Florham park, 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, 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).
• Suggested and implemented improvements to legacy systems.
• Created 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.
• Effectively documented and archived historical data for future auditing purposes.
• Responsible for production support and troubleshooting production issues.

Confidential, Itasca, IL

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.
• 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.
• Created UML diagrams including context diagrams, use case diagrams and sequence diagrams to define business process model.

Confidential, Sandy Springs, GA

Oracle Developer/Analyst

Responsibilities:

• Extensively worked on requirement gathering, analysis, use case designing and testing.
• 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 Shipment specific and Parameters for the general billing.
• Developed user manuals, presentations and training manuals as per project specifications and timelines.
• Developing Control files using SQL*Loader to perform bulk data loads into database tables from external data files.
• Maintaining the Data Base changes according to the client’s requirements.
• 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.
• Up and Design of Backup and Recovery Strategy for various databases.

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 and STLC.
• 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