SUMMARY

• 8 years of IT experience as an Oracle PL/SQL developer with emphasis on Analysis, Development, Implementation and support of projects.
• Involved in all phases of theSDLC (Software Development Life Cycle)and experience in the Waterfall and Agile scrum project implementation methodology.
• Experience with Data dictionary, Database normalization theory techniques, Performance tuning and Entity Relation design techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *Plus, Toadand SQL*Loader.
• Conducted requirement gathering analysis, documentation with help of Application Implementation Methodology (AIM).
• Experience in creatingStored Procedures, PL/SQL Packages, TriggersandFunctions. Strong knowledge in Oraclecursor management and exception handling.
• Experience in advanced PL/SQL concepts likeBulk CollectandFor All.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views and Database links.
• Enforced data integrity using integrity constraints and database triggers.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and TKProf.
• In-depth knowledge of the Cost-based and Rule-based query optimization techniques.
• Experience in working with OLTP and OLAP systems.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) and System Integration Testing.
• Hands-on experience in creating project plan using Microsoft Project.
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.
• Interaction with theoffshore development teamfor development of reports and changes needed in the requirements.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g

Languages: SQL, PL/SQL, Unix

Tools: SQL Developer, SQL*Loader, SQL*Plus, Toad

Project Management Tools: MS Project, MS Office Suite, Share Point

Service Management Software: Service Manager, Service Now

Testing Tools: HP Quality Center, QTP

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front-end applications team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Performed meeting within Business stakeholders, DBAs, Quality Assurances and End users of Business to understand and analyze the high level requirements.
• Recommended best solutions and methods per requirements and specifications.
• Involved with study of existing system, preparing the BRD100/ Functional (MD50), Technical (MD70) design document and Conversion Data Mapping Document (CV40).
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• DevelopedPL/SQL triggersandmaster tables for the applications and applied integrity constraints to enforce data integrity.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to interface tables.
• Wrote scripts to createnew tables, views, and synonymsfor new enhancements in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements.

Confidential, Bethesda, MD

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed advanced PL/SQL packages, procedures, triggers, functions, indexes and collections to implement the business logic, using Toad.
• Generated server sidePL/SQL scriptsfordata manipulationand validation and materialized views for remote instances.
• Involved inUnit Testing Stored ProceduresandFunctions.
• Involved in troubleshooting performance issues and bugs within packages, forms, and reports using explain plan and TKProf.
• CreatedSQL*Loaderscripts to load data into the temporary staging tables.
• Developed procedures usingDynamic SQL.
• Resolving the issues on priority basis.
• Responsible for Analyzing and Implementing the Change Requests.
• With secondary role, handled tasks like creating, maintaining and updating the project plan and evaluating the impact of changes on the project plans, if any.
• Performed project planning and tracking activities with respect to budgeted cost, demand forecasts, time over-runs to ensure timely execution of projects with best practices.
• Generated the weekly/monthly project status reports.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developedstored procedures to extractthe data from different sources and load it into staging tables.
• Analyzing the data and Mapping the data requirementsdeveloping Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• UtilizedSQL*Loaderto load flat files into database tables.
• CreatedSQL*Loaderscripts to load data into temporary staging tables.
• PerformedSQL tuningusingExplain Plan, TkProf, Hintsandindexes.
• Partitioned tablesandindexesfor better performance of application
• Contacting Application Team and clients to gather the information for migration.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support.
• Provided on call support, solved the user issues and made necessary changes.
• Resolving Production severity Issues in time and meeting the SLA.
• Writing high quality and well-documented code according to standards.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Diligently studied and analyzed the high and low-level business requirements document.
• Participated in estimating and preparing test plans for the Financial Module.
• Created triggers for transaction adjustment, Auto Adjustment, defined Vendors, Invoices, Tracking of payments, Prepayments.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Developed procedures usingDynamic SQL.
• DevelopUNIX shell scriptsto administer the system.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle Confidential .
• Re-worked on the BAD Files that were generated by SQL Loader.
• Administered offshore-onsite status calls.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Development team in the development and enhancement of the PLSQL packages and Oracle forms, making them more flexible toward future changes.
• Created LLD (Technical Design Document) for the forms and packages to be developed.
• Assisted in design of tables, databases, forms, and reports; connected forms with Oracle Applications.
• Responsible for preparing the Knowledge Management documents.

Confidential, Minneapolis, MN

Database Developer

Responsibilities:

• Developed stored procedures to extract data from different sources and load it into data warehouse.
• Wrote scripts to create tables, indexes, views, aliases and synonyms to meet developer requests.
• Wrote extensive PL/SQL procedures, functions and packages.
• Preparation of unit test plan, integration test plans and user test plans.