Summary:

• 9 years of experience on Oracle Applications E-Business Suite as a technical developer.
• Extensive experience in HealthCare domain.
• Expertise in Analyzing, Implementation, Development, Customizations, Testing and Supporting Oracle Applications 11i and R12.
• Expertise in Accounts Receivables AR , Order Management OM , Application Object Library AOL and System Administration.
• Worked on Order to Cash and Procure to pay business flows and integrating custom workflows.
• Expertise in Multi Org Environments.
• Experience in upgrading Oracle Applications from 11i to R12.
• Expertise in doing Gap Analysis, MD 050, MD 070 documents and TE040 Test Scripts.
• Expertise on Data Conversion and Data Integration from Legacy Systems or External Systems into Oracle Applications using Oracle open Interfaces and Oracle Public API's.
• Good knowledge in Reports, Interfaces, Conversions, Extensions and Forms RICEF.
• Extensively worked with Oracle 9i/8i and PL/SQL. Expertise in writing SQL, PL/SQL Stored Procedures, Packages, Triggers, Functions and Cursors.
• Extensive knowledge and expertise in UNIX, Shell Scripting and VB Scripting.
• Experienced in Performance Tuning and analyzing using SQL Trace and Explain Plan.
• Strong skill set in Oracle 8i/9i/10g, Developer Suite Forms 6i/10g and Reports 6i/10g , SQL Loader, UTL FILE, SQL Developer and TOAD.
• Extensive knowledge and experience on Version Management Tool: Serena PVCS Version Management.
• Well versed with complete Software Development Life Cycle process SDLC .
• Strongly self-motivated, highly committed to responsibilities and takes pleasure in learning new technologies.
• Fine Troubleshooting skills ability to go to the core of the problem.
• Expertise in managing System Administrator responsibility with excellent Production Support.
• Excellent in Researching and working with Oracle Support for Resolving Oracle Issues.
• Expertise in client interaction, understanding business applications, data flow relations.
• Ability to manage user expectations and Ensures the customer satisfaction.

Technical Skills:

Professional Experience:

Confidential

Oracle Applications Technical Lead

Responsibilities:

• Extracted Setup and Configurations from the existing legacy environment for all the modules.
• Developed Conversion programs using BULK COLLECT and FORALL.
• Developed stored procedure that extracts data from OM and AR modules, according to business requirement.
• Designed and Developed PL/SQL scripts that extracts the data in form of flat files.
• Developed PL/SQL packages using UTL FILE to load data to temp tables and hence to staging tables.
• Loaded data into oracle tables using SQL Loader and dbms utility package.
• Involved in writing SQL Loader scripts and PL/SQL programs for loading ,data mapping, data conversions,
• Validating the data into the staging/target tables from the Legacy source.
• Designed and created Reports to estimate the data transfer.
• Developed a PL/SQL program that is scheduled to submit concurrent programs in a desired sequence as per the functional document.
• Developed conversion and interface programs and registered them as concurrent programs and which ran from SRS form.
• Involved in performance tuning of the conversion programs.
• Created indexes, hints with different tuning techniques.
• Involved in Database Tuning and Improved Application performance using Explain Plan, TKPROF and SQL trace.
• Was involved in building System Integration Test strategy and End to End testing.
• Developed and Designed Shell Scripts and VB Scripts used in triggering the Conversion Programs.
• Documented and coded Technical artifacts and developed test plans.
• Plan, assign, review, track development work through the entire conversion process.
• Code migration of the Conversion Components to different database instances using the hp Project and Portfolio Management Centre hp-PPM .
• Ensured smooth functioning of all conversion programs and resolve the problems as soon as possible.
• Providing cost effective ideas to business to make conversion process more automated.
• Technical Support for the functional team as needed.
• Leading development team at onsite and offshore successfully to meet the technical milestones as per development plan ensuring quality and schedules
• Establishing quality processes and ensuring processes are followed as per defined standards and guidelines.
• Day to day status tracking with offshore development team and updating the status to onsite project manager.

Environment: Oracle Applications 11.0.3, TOAD, SQL Developer, Kintana, Subversion, Reports Developer 10g.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Responsible for managing the overall technical deliverables including helpdesk tickets/change requests related to Oracle Production instance including bug fix enhancements.
• Leading technical onsite offshore project team, task allocation, status monitoring and ensuring quality timely delivery of the deliverables which are in form of issues resolution, bug fix migration, user's assistance, escalation handling, new development effort, testing and migration.
• Responsible for interacting with Business for requirements and managing the offshore team.
• Interacting with users to understand the support issues and resolving the same on time.
• Responsible for custom program maintenance during the production support.
• Developed various Unix scripts such as Archiving of the files, moving them to different servers etc.,
• Creation of alerts to monitor the daily processes, improve the automation thus reducing the manual intervention.
• Preparing the SLA Report detailing the Tickets, Enhancements, Data Fixes etc., and sharing with customer.
• Modified their Vendor Site DFF to add an attribute to store data per design.
• Developed Custom forms and added the zoom functionality in the e-business form.
• Worked on Customizations using Oracle Apps standard API Packages.
• Developed various Custom reports, Customized existing reports according to the functional specifications using Reports Builder.
• Developed stored procedure that extracts data from AR, AP and GL modules according to business requirement.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Wrote test scripts for Unit testing.
• Supported UAT Testing.
• Performance tuning of system processes to remove the bottlenecks for the system.
• Conducting the weekly meetings with customer to discuss the on-going issues and status updates.

Environment: Linux x86, Oracle Applications 11i 11.5.10.2 ,GL, AR, AP, Purchasing and iProcurement, PA Oracle 10g, Reports 6i, Discoverer 4i, Oracle Workflow 2.6, PL/SQL, SQL Loader, SQL Plus, TOAD

Confidential

Oracle Applications Technical Developer

Responsibilities:

• Enhanced the customer order entry form, thus ensuring correct order management and Invoicing.
• Performed forms personalization in customer forms.
• Was responsible for enhancements depending on the client's functionality.
• Worked extensively on SQL, Sub queries, Joins, Index, Constraints, Foreign keys and Sequences.
• Responsible for coding, testing and documentation.
• Developed Stored Procedures, Functions, Packages, and Triggers. Appropriately handled exceptions.
• Used cursors to fetch rows. Assigned roles and privileges to control user access.
• Developed and customized oracle reports and register them as concurrent Programs.
• Customization in Oracle Workflow.
• Creating Workflow process definitions by using Oracle Workflow builder like Item types, lookup types, messages, Activities, Attributes and roles.
• Created value sets for report parameters and registered in applications.
• Packaging the application into various components, so that it can be deployed on various servers and executed from different environments.
• Migrating code to different testing environments.
• Provided support during QA and Business user acceptance testing.
• Preparing and reviewing the contingency and implementation plans.
• Installing the application in the production environment to be available to end user.
• Stabilized the nightly batch run thus minimizing the issues.
• Was responsible for all the project technical deliverables.
• Providing post-production warranty support.

Environment: Oracle Applications 11.0.3, TOAD, SQL Developer, Kintana, Subversion, Reports Developer 10g, Oracle Workflows, Winscp, Putty, IBM Rational ClearCase,IBM Rational Clear Quest,Zeke Batch Scheduler,HP PPM.

Confidential

Oracle Applications Technical Developer

Responsibilities:

• Analyzing all the reports and forms to upgrade them to the latest version that is compatible to R12.
• Upgraded Oracle Reports Forms from 6i to 10g.
• Customized custom.pll as per business needs.
• Completed design for recreating all the responsibilities in R12 for all the operating units.
• Designed and Developed Script for loading Flex Values from 1105 / Spread sheet to R12 for a given Value Set.
• Defined Standard API s for PL/SQL procedures.
• Developed control files for SQL Loader and PL/SQL programs for loading and validating the data into the AR interface tables.
• Worked on AR Interfaces like Customer Interface, Auto Invoice and Auto Lockbox.
• Worked on technical delta changes in R12 processes with reference to the existing processes in 11i.
• Worked on Customizations and Personalization made upon the Standard components including Forms and Reports in 11i to be migrated to those in R12.
• Fixed Transactions and Receipts that were unaccounted after the upgrade to R12.
• Has Worked on Multi-Org Access Control feature MOAC .
• Responsible for Sys Admin activities like custom responsibilities, menus, profiles etc.
• Actively involved post-production support of Oracle Applications R12
• Worked with QA team to design test plan and test cases for User Acceptance Testing UAT
• Helped QA analysts and technical team with troubleshooting and fault resolution
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met

Environment: Oracle Applications 11.5.10 and R12 Oracle 9i/10g, Reports 6i/10g, PL/SQL, SQL Developer.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Concurrent Programs: Developed new PL/SQL concurrent programs
• Value Sets: Created new value sets which are used in Parameters for various concurrent programs
• Developed Model BOMs using Oracle Configurator Developer tool.
• Worked on the Design, Build and Unit Test of EDI inbound component which collects the data from inbound directory of Oracle database and performs the validations according to the functional design and update the ORACLE tables with the validated data.
• Configuration management for different modules such as Inventory, Service Contracts and Advanced Pricing to maintain the stability of the different instances in Oracle Applications.

Environment: Oracle Applications 11i Applications Version 11.5.9 , Developer2000, HP-Unix, SQL PLUS Database Version 9.2.0.6.0 , TOAD

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created database objects like Tables, Indexes, Sequences and Views.
• Modified the existing database objects to meet the expanding business requirements.
• Involved in design, development and modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Loading of the data from flat files into staging tables using SQL Loader.
• Involved in Database Tuning and Improved Application performance using Explain Plan, TKPROF and SQL trace.
• Used MySQL dump to get the data from My SQL.
• Developed Java script for adding validations and added styles to the WebPages using Cascading style sheets.
• Involved in Development, Testing and Maintenance of the System.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, SQL Loader, My SQL, Java script, CSS, C

Confidential

Oracle Developer

Responsibilities:

• Developed PL/SQL packages using UTL FILE to load data to temp tables and hence to staging tables.
• Involved in writing SQL Loader script and PL/SQL programs for loading, data Mapping, data conversions and validating the data into the staging/target tables from the Legacy source.
• Developed PL/SQL programs to load order data from external system to staging tables. Validate data based on business logic and load into actual tables.
• Analyzed and enhanced many existing packages and triggers, to meet new requirements.
• Prepared many DDL, DML scripts as part of migration activities.
• Developed many SQL PLUS reports which were fed to a publishing tool, to generate legal documents.

Environment: Oracle 9i, SQL PLUS, PL/SQL Developer, TOAD

Confidential

Software Developer

Responsibilities:

• Developed interfaces for the integration of Oracle EBS and OTM Oracle Transportation Management .
• Customized the OTM screen as per user requirements.
• Developed a custom order management web portal for DHL integrated it with OTM.
• Produced data extracts and ad hoc reports using SQL.
• Developed interfaces for the integration between OTM and B2B server.
• Developed modified several reports using Oracle reports developer and XML publisher.