PROFESSIONAL SUMMARY:

• Oracle PL/SQL Developer with over 6 Plus years of extensive experience in SQL PLUS, Oracle SQL, PL/SQL Development Oracle 10g/9i , Application Development, Implementation of ERP Oracle Apps Application, Performance Analysis, Production Support, Software development life cycle, leading and executing deliveries and supporting global clients customers
• Implementation, Development, Enhancement and support of Oracle Modules Account Payables/ Order Management/ General Ledger/ Purchasing/ Cash Management/ Inventory/ Manufacturing
• Experience in Client / Server database application development and Migration using Oracle 9i/10g/11g AS, Oracle Designer and Oracle Developer 9i/10g/11g AS on Windows, AIX and UNIX environment.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN
• Experts in PL/ SQL programming, SQL, Application Tuning and SQL loader, Pro C scripts.
• Expert in writing efficient SQL and PL/SQL code Stored Procedure, Functions, Triggers, Autonomous Transactions and Packages on TOAD to analyze very large data sets
• Expertise with ERP implementation and Data Conversions
• Experience in Oracle E-Business Suite 11i and R12 and Oracle Developer Suite
• Expertise in system integration testing, preparing design documents
• Excellent Analytical skills to understand the business process and functionality, requirements and to translate them to system requirement specifications
• Experience in various phases of SDLC like Exploring requirements, Analysis/Design, Development, Testing and deployment, Go-live and Post go-live support
• Experience in preparing Test plans, Test Data and execution of Test cases to ensure application functionality meet the user's requirements
• Well versed with Unix Scripts and Unix Shell Scripting
• Experience in handling Production cases and escalations
• Ensured Project compliance to Quality and Standard implementation methodology Drive QA processes for the project in the program, Participate in CMMI Level 5, Identify, communicate and implement opportunities for process/solution improvement Establish CMMI process to control defects and improved customer satisfaction
• Have good experience in On site-offshore model execution of projects
• Excellent documentation and presentation skills, great verbal and written communication skills
• Customized and modified Forms/Reports in Oracle Financial modules.

TECHENICAL SKILLS

EXPERIENCE

Confidential

Program Analyst.

Responsibilities:

• Designed and Developed the SCS application from document level. Building template form, standard libraries and Package's, which support the daily business and synch with current level of application.
• Designed the various Oracle logical and physical databases for data integration and database developments as application demands for better maintainability.
• Setting up Environment in Oracle 10g application RDBMS, Forms, and Reports for new application.
• Writing SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily transaction.
• Responsible for tracking the Load the data into the DPS application, which comes in flat files and process them for correctness.
• Developed Complex Forms Using dB packages / reports Web Reports Excel format and PDF format using DEVELOPER 2000 Forms 9i/10g, Reports 9i/10g 10g R2 using custom template form for user screens.
• Building the Dash Board for SCS Applications so that will show only accessible applications/ forms are available for the logged user as per the assigned permissions.
• Responsible for Application integration and supporting the user/business critical issues in 24 x7.
• Maintaining and scheduling the different interfaces, which feed the data from SCS, ORACLE APPLICATIONS and sending forecast data into PASI Custom Application . Also actively participated in monitoring the interfaces and making sure that the process flow completed successfully.
• Ability to work with functional teams in an AGILE environment Established excellent meeting, facilitation, and presentation skills
• Worked with version control system GIT.
• Involved in RDBMS developments include building data migration scripts using Oracle SQL LOADER, and UTL packages.
• Worked with the Sr DBA's and Oracle Support Team for TAR/Service Requests for some critical issues on the Application and User Issues.
• Conducting analysis and design for implementing the project development phases.
• Worked on Performance tuning of Custom PL/SQL Code, Forms and Reports.
• Worked with team of four in the application.
• Development of Functional Design Documents FDD for given task for Business approval and convert then to Technical Design Document TDD before going to development phase.
• Demonstrated ability to monitor and track performance, anticipates risks, resolve and debug Issues within Oracle applications and escalate if needed.
• Responsible for the Data Mart reporting Project using the Oracle RDBMS Technology 10g AS for higher management.
• Keep track of user activities in SCS Application to make sure no user is locked by others.
• Migrating the New /Modified Forms/Reports to Oracle Application Portal.
• Testing of application with different sample test data in different SCHEMAS like DEV, TEST for accuracy of application before moving to QA and UAT and update in the VSS.

Environment: Oracle 9i/10g SQL PLUS, SQL, PL/SQL , DEVELOPER 2000 FORMS 9i/10g, REPORTS 9i/10g , TOAD, SQL Navigator, Oracle WEB server, Oracle Applications 11. Java Scripting, HTML, Erwin Data Model, Apache Web Server, VSS. Oracle Discover 10g.

Confidential

Program/Application Analyst.

Responsibilities:

• Responsible to Supporting and maintain the CMiC Enterprise Application.
• Creating scripts to generate the data for reports developed in Oracle reports/Discoverer as per user requirements.
• Creating Oracle Database objects based on the new requirement Tables, Indexes, views, partitions, constraints, triggers etc.,
• Writing SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily/incremental loads.
• This is the Java front end application with Oracle Database as a backend, Building/maintaining the Oracle dB for supporting the Java application as a front end.
• Responsible for preparing the migration and deployments scripts for CONV, UAT as well as PRODUCTION environments.
• Coordinating with CMiC Application support and application team for issues and concerns.
• Experience in Database Design, Database programming, SQL and Database Tuning and Performance Tuning, Trouble shooting, maintenance.
• Create the jobs and schedules them to run on the specific times and will not affect the system performance, Email notification setup for failure notifications.
• Worked with the Sr DBA's and CMic Application Support Team for Service Requests for some critical issues on the Application and User Issues.
• Conducting analysis and design for implementing the project development phases.
• Participation in project discussion, trouble shooting and problem solving interactions and user support.
• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Created and maintained project tasks and schedules.
• Developed Complex forms/ reports using DEVELOPER 2000 Forms 11g, Reports 11g for the Application.
• Extensively used SQL joins, Oracle analytic and grouping functions for data analysis.
• Created complex views for the purpose of extracting the Data and to avoid duplicating the Dictionary tables on data stage/DW.
• Dealing with performance tuning SQL related issues and resolving the Issues with Oracle 10/11g Advanced Functions as to cope up with con-current processes and to make it faster.
• Requirements gathering from Specs, Users/PM's and documentation, data cleansing and extraction, report design and implementation, and testing.
• Making sure all the batch jobs are working with no issues as data and performance wise and available by morning for the business.

Environment: SQL, PL/SQL, Oracle 11g, Developer 2000 Reports 11g, Forms 11g , SQL Loader, Toad 10.5, SQL Navigator V5.5,Oracle SQL developer V3.0, Oracle Discover 11g, CMiC Enterprise Application V10, Erwin.

Confidential

Oracle PL SQL Developer

Responsibilities

• Developing the custom RDF reports on the AP, GL, OM modules and testing the same
• Worked extensively on PL SQL packages, stored procedures and cursors and functions
• Designed and developed the custom tables using Oracle 10g based on existing for the inbound and outbound interfaces
• Migrating the custom tables, PL SQL packages to other environments and testing the custom code
• Worked extensively on registering reports and creating and migrating concurrent programs to other environments
• Worked extensively on UTL FILE functions, UNIX shell scripting
• Co-ordination with the on site team
• User requirement gathering, design development of Inbound and Outbound interfaces in Financial and Manufacturing modules
• Developing Unit test plan
• Performing Unit testing, Integration testing
• Coordinating with functional team leads for functional testing
• Updating the test documents
• Providing support for the post go-live activities

Environment: Oracle 11i, Oracle Reports, Oracle Interfaces, UTL FILE, PL/SQL, SQL, Oracle 9i database, TOAD.

Confidential

Oracle PL SQL Developer

Responsibilities

• Worked extensively on PL SQL packages, stored procedures, functions, cursors and arrays
• Have extensive knowledge in creating global temp tables
• Worked on UNIX shell scripting which sends email to users with text output as an attachment
• Worked on PL SQL code to submit the concurrent programs programmatically and test the process
• Involved in end to end testing of the custom components
• Co-ordination with On site team for the deliverable s
• Understand Client Business process and prepare the design documents and test plans
• Involved in integration testing

Environment: Oracle R12, Oracle Extensions, PL/SQL, SQL, Oracle 10g database, TOAD