SUMMARY

• Highly energetic, flexible and multifaceted individual with excellent trouble - shooting skills and have a positive attitude to learn and apply new technologies to real-time scenarios.
• Around 9.5 years of experience in IT Industry on Oracle E-Business Suite RICEW in R12. Performance Engineering & Data Modeling.
• Worked on Oracle 10g/11g/12c databases.
• Proven experience with data conversion and interface development, forms/reports development, forms personalization and PL/SQL with TOAD.
• Experience in database loading using SQL Loader and working with Export/Import utilities.
• Experienced in Performance tuning of the database using autotrace & tkprof.
• Developed Procedures, Functions, Triggers and Packages in PL/SQL.
• Worked on ETL Tools for data loading into oracle tables.(Informatica Power center)
• Extensively Worked on AIM documents like MD050, MD070 and MD120.
• Good understanding of all phases of SDLC by working extensively in each phase.
• Proficient in Developing, Customizations and Implementations in Oracle applications, OS and Environment.
• Experienced in Scripting and working with UNIX .
• Effective communication skills (verbal and written) for both highly technical and non-technical audiences.
• Good Experience in business flows like P2P, O2C and Drop Ship Cycles.

PROFESSIONAL EXPERIENCE

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked with Application Team to provide them with necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from external sources.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Addressed problem tickets for enhancements and fixes of production problems.
• Developed PL/SQL triggers for auditing purposes.
• Created PL/SQL stored procedures, functions and packages to load payment data/Templates and per other business needs.
• Used ERWIN to create new tables for new enhancement in the application.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL tuning using Explain Plan/AWR reports and OEM.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Exception Handling using in built exceptions and custom exceptions.
• Got opportunity to work on Oracle 12C and experienced benefits of Adaptive plans and dynamic statistics while fine tuning the SQL queries.

Tools: Used: Putty, PL/SQL Developer, TOAD, JIRA, GIThub, AppDynamics

Confidential

Oracle Pl/SQL Developer

Responsibilities:

• Interfaced with developers, project managers, and management in the development, execution and reporting of test automation results.
• Data ware house Reports design using PL/SQL Packages and Procedures.
• Pl/SQL code review for tuning with Major focus on Indexes, partitioned tables, explains plans.
• Used LoadRunner, executed multi-user performance tests, used online monitors, real-time output messages and other features of the LoadRunner Controller.
• Execution and monitoring Control M jobs.
• Worked on Oracle Enterprise Management (OEM) to monitor SQLs, Identify different kinds of explain plans used. worked on Informatica power center to track data from file extraction to loading in database.
• Execute different test scenarios and suggest code changes for better performance.

Tools: Used: Control M, OEM, Putty, PL/SQL Developer, Rally, Wily, Dynatrace,Informatica Power Center 9.5,

Confidential

Oracle Techno functional

Responsibilities:

• Worked with business teams to analyze system and process requirements.
• Translating and design of functional requirements into technical designs within the Oracle system. Documented all technical designs and actual development product (code) according to the company's IT documentation standards.
• Development and maintenance of Oracle custom code and interfaces to Oracle Forms-based applications in accordance with business requirement in Procurement-to-Pay model and Order-to-cash models.
• Developed several PL/SQL packages, procedures, and functions, triggered from UI events or database triggers, to implement complex business logic
• Involved in all phases of the SDLC (Software Development life Cycle) from Analysis, Design, Development, Testing, Implementation and maintenance with timely delivery against aggressive timelines.
• Used BULK collect concepts for increased performances in conversions and interfaces.
• Participated in code management process, including use of source-code control utilities and facilitation of migration of code across multiple Oracle instances.
• Design and development of Form personalization’s and customizations.
• Worked with Oracle on multiple SR’s.
• Performance tuning by different methods like auto trace and oracle hints
• Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
• Requirement gathering on re-design of a process in order flow.
• Offshore team functional support.
• Preparation and validation of triages.(Incidents and Problem tickets).
• Data Migration Automation designs.
• End-User interaction and support.
• Guided users in validating the test scenarios as part of this upgrade and received the UAT sign off.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked in Agile methodology as well as waterfall model.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from flat files.
• Developed SQL scripts, cursors, tables, views, and materialized views as per the business requirements.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, Tk-prof and Auto trace.
• Analysis and coding of break fixes as part of maintenance team.
• End-to-End executions of data migration cycle, preparing reports, face the business at the end of migration.
• Preparing data-fixes, Automation of reports.
• Expertise in system admin activities like creation and maintenance of users, creating responsibilities, menu maintenance, creation of requests and request sets, registering applications, forms, reports, concurrent programs.
• Used lot API’s to create custom process for pick release, ship confirm in Shipping module and created lot of custom reports in OM, GL and AP modules.
• Involved in developing AIM documents to support out souring team for Oracle Collection module implementation/development.
• Created packages using BULK concepts and several other pl/sql keywords.
• Worked on Patch analysis to identify the effected objects.
• Worked on SQL tuning by adopting methods like analyzing the cost, using hints, building Indexes.