Summary

Confidential is an Oracle PL/SQL Developer Certified Associate with 7 years of Oracle Development experience including requirement gathering and analysis, modeling, design, administration and maintenance of Oracle Database systems on both UNIX and NT platforms. Her broad experience includes Oracle 9i/10g, PROGRESS 4GL, Unix shell scripting, SQL PLUS, MySQL including database design, development with emphasis on back-end stored procedures, functions, triggers, database performance tuning and scheduling jobs using CRONTAB. Aishwarya has excellent communication and presentation skills from working closely with business and technology teams and has created and presented different documentation of a SDLC project life cycles. She has proficient knowledge of Oracle E-Business Suite and has additional skills including Data Modeling, Data Mapping, Table Normalization, Query Optimization and Performance Tuning, Oracle Hints, Explain plans, Bulk collects, bulk binds, TKPROF, SQL Trace, SQL Profiler and Indexing.

Technical Expertise

RDBMS: PROGRESS 4GL, Oracle 9i/10g, Performance Tuning

Database Applications: Microsoft Access

Oracle Financials: E-Business Suite 11i

Programming Languages: Core Java, JDBC, SQL, PL/SQL, Unix shell scripting, HTML, PERL

Operating System: UNIX, RHEL 5.0, Windows Vista, XP, 2003, NT, 7

Data Modeling Tools: VISIO, Rational Rose

Source Safe: PVCS, VSS, WinSCP, MPP, Putty

Professional Experience

Confidential

Apps System engineer

• Serves as senior level developer working on multiple concurrent projects to enhance an enterprise collections application serving multiple business units.
• Maintain and support existing software application.
• Performance tuning and PL/ SQL tuning
• Strong experience with batch processes and complex packages, bulk binding and partitioning
• Optimization of existing PL/SQL Code
• Identify and resolve complex application issues and bugs.
• Review and/or write code to enhance and/or extend application.
• Provide subject matter expertise in reviewing, researching and resolving business problems presented in requirements specifications.
• Test new installations and/or software prior to release to minimize failures and impact to business and end users.
• Provide subject matter expertise and business analysis in addressing complex projects and issues.
• Serve as a mentor to junior staff. Oracle DBA knowledge, PL/SQL Developer IDE, Java, PowerBuilder, Perl

Environment: Oracle 11g, PL/SQL Developer, UNIX, Windows XP, Java v1.6, Power builder

Confidential

Programmer

• Worked in Oracle E-Business Suite and implemented Oracle iReceivables for Stryker Spine. This was done to ease the credit card payment system.
• Implemented Oracle Modules on Accounts Receivables.
• Created function and technical specification documentation.
• Responsible for configuration of Oracle iReceivables in development and test environment.
• Tested the application, wrote test case scenarios and did bug fixes.
• Worked in other E-Business Suite, such as, Oracle Bills of material, Payroll, HRMS.
• Involved in configuring up approval levels in Oracle applications.
• Used Oracle E-Business Suite applications for accounts payable/accounts receivable AP/AR , general ledger, fixed assets, and cash management, supporting data extraction, filtering and validation
• Worked directly with the end users and resolved production issues.

Environment: Oracle 10g, Forms 10, Reports 10g, SQL Plus, TOAD, SQL Loader, SQL, PL/SQL Developer, UNIX, Linux, Windows XP.

Confidential

• Designed and developed packages for scheduling appointments, inspections and surveys.
• Developed database objects Procedures, Functions, Packages, Collections, Synonyms, Constraints, Indexes and External Tables.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL Plus.
• Performed performance tuning TKProf, SQL Trace, Oracle Hints and Explain Plan .
• Used the collections and bulk binding for processing billions rows and to improve the performance.
• Data transferred/migrated between two Oracle databases using DB Link.
• Involved in day-to-day database maintenance, Partition tables, Unix Job Scheduling.
• Prepared and ran scripts for creating tables, indexes, etc.
• Prepared Technical Design and Installation Documents.

Environment: Oracle 10g/9i, SQL, PL/SQL Developer, SQL Loader, Toad, UNIX.

Confidential

• Worked with Oracle databases to manage data for development, training and production environments.
• Wrote PL/SQL Functions and Stored Procedures to provide APIs to front-end developers to manipulate the database.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL Plus.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Used TOAD to run SQL and PL/SQL code to manipulate the databases in all environments.

Environment: Oracle 9i, SQL, PL/SQL, SQL Loader, Bourne Shell script, TOAD, Oracle Forms 9i, Reports9i.

Confidential

• Worked on the implementation and support for the enhancements being done.
• Communicated directly with the customer and resolved issues when tickets were opened. As a part of this activity, needed to analyze, document, code change, test and deploy.
• Solved both Technical issues and Business issues in implementing the features.
• Coordination between the on-site and offshore team for task tracking, planning and defect tracking enhancements and bug fixes.

Environment: PROGRESS 4GL, UNIX

Confidential

The segregated funds consisted of a pool of investments in securities, such as, bonds, debentures and stocks.

• Responsible responsibilities include enhancements of existing applications built using PROGRESS 4GL.
• Created transactional and batch processing for different clients with different contract types and funds.
• Involved in the coding and testing of all the modules developed for the project.
• Preparations of detailed unit test cases for the enhancements made and also include various possible cases of testing.
• Used HINTS to tune queries for better performance and also extensive usage of Indexes
• Worked on the implementation and application deployment in production.

Environment: PROGRESS 4GL, UNIX

Confidential

• Responsible for analysis and gathering system requirements.
• Used Oracle forms and reports for report generation.
• Created application schema as tables, views and indexes.
• Customized the stored procedures, functions, packages and database triggers in PL/SQL.
• Implemented and tuned the indexes. Handled pre-defined and user-defined exceptions.
• Established JDBC connection using database connection pool.

Environment: Oracle forms and reports, SQL, Unix Shell Scripting, Java.