SUMMARY

• A skilled software professional with 8+ years of experience in Information Technology.
• Specialist in Oracle database and Oracle PL/SQLdevelopment.
• Technical Lead with extensive experience in Data modeling, Database design, Database Migration as well as performance optimization skills.
• Extensive experience in creating conceptual, logical and physical data models for OLTP systems, reporting frameworks and batch processing.
• Expert in creating and modifying stored procedures, cursors, functions, tables, indexes, views and triggers.
• Experience in normalization and building referential integrity constraints.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, and Stored Procedures.
• Excellent quantitative and analytical skills combined with pragmatic interpersonal and communication skills.
• Having strong Experience in writingSQLqueries, PL/SQLqueries and Exception Handling, understanding requirements and developing plans.
• Experienced in Partitioning Administration. Creating and Managing Partitioned Tables and Indexes.
• Experienced in Normalized Database Design and Modeling (Logical and Physical design of database).
• Strong knowledge in developing PL/SQLobjects such as procedures, functions, packages, views, materialized views, DB links & triggers.
• Solid knowledge about the Oracle 9i/10g/11g architecture.
• Extensive hands on experience in performance tuning ofSQLqueries & PL/SQLprograms.
• Expertise in development using Oracle Forms and Reports (Developer2000) and in using tools like TOAD,SQL*Plus.
• Experience on Meta data definition, implementation and maintenance, new business rules identification and implementation to data rules.
• Good knowledge onSQLserver.
• Experienced in the development and deployment of Reports for Retail, Healthcare, Financial, Manufacturing, and Software companies. Defined, designed & developed the use of Reports by blending the financial knowledge of the client with the available technical knowledge. Possesses excellent analytical skills.
• Have working knowledge of C, C++, Java, HTML and MS - Office suite.
• Experience using TOAD andPL/SQLDeveloperfor query building and analysis and manipulations of databasefor checking compatibility and integrity of RDBMS.
• Experience in supporting the various production issues addressed by the users from the client side and providing them with required solutions.
• Well versed with Software Development Life Cycle activities such as Requirements Analysis by coordinating with business analysts; Preparation of High-level and Detailed design documents; Build; Unit Test Plan Preparation, Test data requirement identification and preparation, and Unit Test case execution.
• Experience in handling multiple applications at the same time and played Tech Lead roles in many projects.
• Involved in the analysis of the existing database.
• Strong interpersonal & communication skills, Competitive analytical, logical, and problem solving skills, Strong management, administrative and leadership skills to work in team.
• Ability to work well in a team and open to Team related tasks, team meetings, team interaction and also conference calls.
• Translated and provided to end users.
• Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit.
• Help team to resolve conflicts constructively and ability to communicate when help is needed. A Self starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

TECHNICAL SKILLS

Programming Languages: OracleSQL& PL/SQL, SQLServer, C, C++, Core Java, UNIX & Shell scripting.

Databases: Oracle, SQL Server, My SQL, MS Access

Tools: TOAD, PL/SQLdeveloper,SQLDeveloper

Testing: Manual Testing, Automated Testing

ETL Tools: Informatica

Reporting Tools: Cognos, Oracle Reports

Operating Systems: Windows 7/ XP, UNIX, LINUX

Application Packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Confidential, Champaign, Illinois

Sr PL/SQL Developer

Responsibilities:

• Responsible forProductionSupportof all the applications Billing, Enabler, CSM, AR & Collections.
• Monitored daily activities to ensure that batch production runs smoothly and service level agreements are met, including Usage processing, Billing issues and rejects and all End of Day failures and issues.
• Created various UNIX shell scripts to invoke PL/SQL anonymous blocks, stored procedures, functions and packages using SQL plus sessions in silent mode.
• Extensively used Cursors inPL/SQL Programming.
• Performance Tuning of SQL queries by analyzing the queries explain plan and statistics.
• Optimized critical queries to eliminate Full Table Scans and reduce Disk I/O.
• Fine Tuned SQL statements for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan and Trace sessions.
• Extensively used analytical functions like DENSE RANK, RANK and ROW NUMBER.
• Used SQL loader to perform bulk data loads into database tables from external data files.
• Involved in improving query response time by creating partitioning on tables.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created UNIX Shell scripts for automating the backend jobs.
• Involved in writing new enhancement programs and fixing the old program bug fixes using Oracle PL/SQL and UNIX Shell scripting.
• Resolved Priority Production Support Issues and defect fixes in PL/SQLcode which were mainly because of changes in requirements.
• Acted as a single point of contact for the Reporting team for coordinating the development across the platform. Responsible for onsite-offshore co-ordination.
• Working on ProductionMaintenance and change controls (CCs) and tracking all the problems/requests with productionprocesses through Unified Ticketing System (Remedy) tool.
• Involved in writing complex queries to generate reports as per client requests as part of production support.
• Worked in production support environment which involves operations such as monitoring jobs, performing root cause analysis, troubleshooting the issues, monitoring top activity and long running queries, performance tuning with the help of DBA.
• Appreciated by the Project Manager and the onsite team for being able to handle the module with minimal issues during and after applying the release.

Environment: Oracle 11g, SQL Plus, Toad, Windows XP, UNIX, Putty, UNIX Shell scripts.

Confidential, Oaks, PA

PL/SQL Developer

Responsibilities:

• Analysis of requirements, coordinating with business analysts and developing technical design documents.
• Created several tables, sequences, views, indexes, constraints, complexPL/SQLProcedures, Functions, Packages, Cursors and Triggers to enforce business rules.
• Extensively used advancedPL/SQLconcepts such as collections and bulk processing to achieve best performance. These were used in large data conversion scripts, to process records within a procedure or package before updating them to the database.
• Used TOAD andSQL*Plus for writingPL/SQLcode and executing the queries.
• Resolved Priority Production Support Issues and defect fixes in PL/SQLcode which were mainly because of changes in requirements.
• Extensively usage of Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Extensively used XML Publisher to design the layout of the report for different output formats like PDF, HTML and EXCEL.
• Performing extracting of data and loading viasqlloader or toad.
• Developed migration and implementation plans.
• Extensively worked with table partitioning and tablespace creation etc.
• Created reusable components of code and used Microsoft's Visual Source Safe to store all the files and documents related to the project.
• Handling Access related issues for the Team.
• Acted as a single point-of-contact for OAF implementation queries not only for the developed module but externally as well.
• Appreciated by the Project Manager and the onsite team for being able to handle the module with minimal issues during and after applying the release.

Environment: Oracle 11g, UNIX, Oracle 10g, Microsoft Visio, TOAD for Oracle,PL/SQL, SQL*Plus, Putty, XML Publisher.

Confidential, Dayton, Ohio

PL/SQL Developer

Responsibilities:

• Analyzed requirements document and designed the technical specifications document for the database-related functionality.
• Developed ER diagrams, physical and logical Data Models using Microsoft Visio.
• Used Oracle Forms 6i to design and develop the interface for the system which facilitated creation of custom forms related to customer and supplier maintenance, bill, receipt, invoice, debit and credit notes.
• Solely responsible for analysis, design, development, and testing ofthe database http://www.indeed.com/r/Ashwini-Chadrapu/d2fbe33ae773422einvolved in the application.
• Created front-end procedures and functions with Forms 6i to perform calculations related to bills and invoices.
• Developed tables, sequences and indexes necessary for implementing the business rules.
• Good understanding with application code like Java and JavaScript.
• Created new database objects such asPL/SQLProcedures, Functions, Triggers, Cursors and Packages as part of database development using TOAD and Oracle 11g.
• Manage privileges on tables and other objects for outside schema users.
• Understand the future requirements and model database concepts accordingly.
• Control and maximize the data resources and processes within the organization.
• Review of code changes, test procedure, test plans and other deliverables.
• Developed Materialized Views with fast and incremental Refresh Rates using TOAD.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Extensive use ofPL/SQLCollections and Records, and Partition methods for oracle tables and indexes.
• DevelopedPLSQLstored procedures to read input from, and send output to, in the form of XML.
• Used Reports 6i to create reports related to revenue earnings and expenses.
• Developed new triggers and modified existing triggers as per the requirements.
• Performed effective Unit Testing and also offered support during the production releases.
• Created several reusable code components and communicated them to the team for future use. Used Microsoft VSS for checking in the scripts on a daily basis.
• Held meetings for junior oracledevelopersto introduce the system and environment of the company.

Environment: Oracle 11g, TOAD for Oracle,PL/SQL,Developer2000 (Forms 6i, Reports 6i),SQL*Plus, Microsoft Visual Source Safe 6.0, Microsoft Visio.

Confidential, Springfield, MA

Jr. PL/SQL Developer

Responsibilities:

• Created estimated schedule for the project after the requirements gathering meeting.
• Analyzed and designed the technical proposal solution to effectively allocate budgets and merit increases.
• Worked on setting up the plan types and Fast Formulas using Oracle E-Business Suite R12.
• Solely responsible for customizing the OAF pages involved in the module for error handling purposes.
• Customized forms using Forms 6i for UI, which dealt with details about employees, budget allocations, notifications for approval or rejection, and merit increases.
• Extracted data from Excel sheets into tables by means ofSQL*Loader and TOAD.
• UsedSQL*LOADER to store data in the Oracle database from different types of flat files.
• Involved in preparing technical documentation.
• Worked closely with the testing team helping them in testing the codes.
• DevelopedPL/SQLProcedures and database triggers for the validation of input data and to implement business rules.
• Involved in customizing the workflows for sending, receiving, accepting and rejecting the notifications.
• CreatedPL/SQLProcedures, Functions, Triggers, Cursors and Packages as part of OAF customizations.
• Worked extensively onPL/SQLException Handling, Control Structures and Cursors.
• Developed reports using Reports 6i to show the budget allocations, merit increase percentages and Short Term Incentive targets.
• Performed Oracle Performance tuning usingSQLTrace and EXPLAIN PLAN.
• Participated in Unit and Integration Testing and also supported production DBA in daily or emergency procedures to resolve issues.
• Synchronized with other team members for a better overall performance.

Environment: Oracle Applications R12, Forms 6i, Reports 6i, Oracle 11g, TOAD for Oracle,PL/SQL, Oracle Workflow Builder,SQL*Loader, Microsoft Visual Source Safe 6.0, JDeveloper, Putty, LINUX.

Confidential

PL/SQL Developer

Responsibilities:

• Interaction with Business Analysts, Data architect and client representatives for requirements gathering, Investigate, troubleshoot, diagnose, and provide resolution for Oracle database related issues. Research and solve client specific data issues.
• Coordinated with Clients in Requirements gathering, Analysis, Estimation and Capacity Planning.
• Creating different schemas and maintaining schema objects.
• WritingPL/SQLStored Procedures, Functions and Packages to enforce business rules.
• SQLPerformance and Tuning.
• Extensive usage of EXTERNAL TABLES for data conversion in staging area before loading the data.
• Extensively usage of Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Implementing complex Interface business rules using Oracle Database Triggers constructs.
• Utilized partitions to fine-tuneSQLdata load.
• Involved in preparing technical documentation for process flow.
• Using Toad as an advancedSQL-PL/SQLeditor. Built and tested scripts,PL/SQLpackages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
• Regularly monitoring Help Desk Ticketing System Queue to work on regular support Issues.
• Handling Access related issues for the Team.
• Review and implement software change requests for fixes and enhancements.
• Create and maintain scripts for automation of routine tasks.

Environment: Oracle 9i,SQL, PLSQL, TOAD, Windows XP, UNIX shell scripting, Microsoft Visual Source Safe, Oracle Data Integrator (ODI).