SUMMARY:

• 9+ years of experience in System Analysis, Design, Development, Conversion, Customizations, Interfacing and Implementation of business applications using Oracle Applications 11i/R12.
• Worked on all stages of SDLC (Software Development Life Cycle) including requirement analysis, design, development, testing and implementation.
• Extensively worked on Implementation, Support and R12 Upgrade Projects.
• Well versed with Agile Methodology of software development.
• Expertise in RICEW (Reports, Interfaces, Conversions, Extensions and Workflows) and CEMLI (Configuration, Extension, Modification, Localization and Integration) methodologies.
• Technically proficient in Order - to-Cash (O2C) and Procure-to-Pay (P2P).
• Extensive experience in using ORACLE 11g/10g/9i/8i, SQL, PL/SQL, Oracle Forms, Oracle Reports, Oracle Discoverer, XML/BI Publisher, Oracle Workflow, Data Load Professional Tool, SQL*Loader, EDI 810/850/856/855 .
• Worked on modules like OM, GL, AP, AR, INV, PO, WIP, WSH, BOM, HRMS, FA, AOL and System Administrator.
• Knowledge of Oracle Metalink functionality/technical support area to aid in resolving application problems and solutions.
• Good Exposure to OA Framework.
• Well versed with Performance tuning concepts such as Optimizer Hints, Explain Plan, SQL Trace and TK Prof.
• Experience in creating and Maintaining Users and their responsibilities, creating new responsibility, Assigning Customized Forms, Reports and Oracle PL/SQL batch jobs to Responsibilities and Request Groups.
• Experience in developing inbound and outbound Interfaces for Oracle General Ledger, Accounts Receivables, Purchasing, Order Management and Inventory modules.
• Experience in Customizing standard Oracle Reports using Reports 10g/11g in GL, AP, INV, OM, AR and PO modules as per business user requirements.
• Experience in developing custom Oracle Forms using Oracle Forms 10g/11g. Used CUSTOM.pll to customize the standard oracle Forms.
• Experience in converting the standard Oracle reports to a fancier reports using XML publisher.
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Strong knowledge of Unix/Linux and shell scripts, SQL, PL/ SQL, Forms 10g/11g, Reports 10g/11g, Discoverer 10g/4i and XML Publisher.
• Prepared Technical Design Documents for customizations and conversions using AIM documentation methodology. Developing Technical Design documents (MD070), Conversion (CV40s, 60s), Installation (MD120), Testing Document (T20), Conversion Document (CV120) and Estimation document.
• Excellent Team Player with strong analytical, presentation and problem solving skills.
• Broadly involved in release planning, supporting testing activities of deliverables in different stage cycle environments, supporting Production Go-live.
• Lead offshore support team and worked extensively on onsite offshore model and proven customer management skills with business users.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications EBS 11i & R12 (GL, PO, AP, AR, INV, OM, HRMS, BOM)

Tools: TOAD, SQL Developer, SQL *Plus, SQL *Loader, Oracle Workflow Builder, Eclipse

ETL Tools(Data warehousing Tools ): Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Databases: Oracle 10G.

Operating System: Windows XP/7, Linux, Unix

Languages: SQL, PL/SQL, XML, Java, Shell scripts

GUI: Forms 11g &10g, OAF.

Reporting Tools: Reports 11g &10g, BI (XML Publisher), Oracle Discoverer reports.

Utilities: Mozilla, Putty, FTP (FileZilla, WinSCP).

Big Data Ecosystems: Hadoop, MapReduce, HDFS.

PROFESSIONAL EXPERIENCE:

Oracle EBS Technical Lead

Confidential, Irving,TX

Responsibilities:

• Working in a Team Environment including Business Users, Business Analysts, Technical Developers, Oracle Applications DBA, Systems Administrators while working on various New Projects, Enhancement of existing Applications and Production Support.
• Gathered functional and technical requirements from the end-users and analyzed existing legacy system.
• Involved in preparation of the Conversion Program (CV120) design document, Installation document (MD120) and Conversion Mapping Document (CV40) during designing phase.
• Designed and Developed Data Conversion process and Dashboard
• AP Invoice Interface for PO/NON PO
• Item conversion
• SO Line Creation Interface
• Miscellaneous Receipts/Issues Interface
• SO Line Cancel Interface
• Item Reservation/ SO Line Update program
• Item Cost Update Interface program
• Item Relationship/Cross-reference Interface program
• AR Statement Dashboard
• Collector profile class update program.
• Shell script programs.
• Convert Noetix views into Oracle custom views.
• Creating TAR (Technical Assistance Request) on Metalink for Technical/Functional Support with Oracle while finding issues in existing Oracle Applications Standard Applications Functions during Upgrade, Production Support or while customizing existing Oracle Standard Modules for enhanced business requirements.
• Designed and Developed various new Descriptive Flexfields (DFF) for Standard Oracle R12 Applications Modules.
• Working as a Systems Administrator, supporting end-users including Creating, Maintaining Users, Roles, Responsibility, Concurrent Request Manager, migrate Custom Designed Objects across various instances.
• Performed the unit testing for the code and migrated the files through FTP (FileZilla, WinSCP).

Oracle EBS Technical Lead

Confidential

Responsibilities:

• Working in a Team Environment including Business Users, Business Analysts, Technical Developers, Oracle Applications DBA, Systems Administrators while working on various New Projects, Enhancement of existing Applications and Production Support.
• Worked on Confidential Customized objects and migrated all objects from 11i to R12.
• Gathered functional and technical requirements from the end-users and analyzed existing legacy system.
• Developed new programs to process XML data files, to load in Oracle Database tables and to create an XML files from Oracle database tables for 3PL integration (third party warehouse tool).
• Creating TAR (Technical Assistance Request) on Metalink for Technical/Functional Support with Oracle while finding issues in existing Oracle Applications Standard Applications Functions during Upgrade, Production Support or while customizing existing Oracle Standard Modules for enhanced business requirements.
• Working as a Systems Administrator, supporting end-users including Creating, Maintaining Users, Roles, Responsibility, Concurrent Request Manager, migrate Custom Designed Objects across various instances.
• Involved in development of reports based on business requirements and registered them in Oracle applications.
• Defined concurrent programs, request sets, templates for XML report, registering reports and PL/SQL Procedures and Packages .
• Customized EBS using Forms Personalization and OAF personalization .
• Performed the unit testing for the code and migrated the files through FTP (FileZilla, WinSCP).
• Modified Transaction Maps for EDI Transactions 850, 855, 856 and 810 to include additional field as per requirement.
• Prepared Technical Specification ( MD70 ) documents.

Oracle EBS System Analyst

Confidential

Responsibilities:

• Involved in the day to day activities of production support of Oracle applications environment in AP, PO, OM, INV, AR and GL.
• Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
• Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.
• Worked on Confidential Customized objects and migrated all objects from 11i to R12.
• Closely worked with users to understand business needs and objectives.
• Personalized Oracle standard and custom Forms using oracle forms builder as per the Client requirements.
• Imported new, changed and completed sales orders from legacy system to oracle using order import (order management open interface).
• Customized forms using custom.pll to change the functionally of the standard forms.
• Customized OAF pages.
• Experience to Design AR Invoice Report Customization for Customer Invoice Notes with Print facility in Reports 10g and customize the report using XML Publisher.
• Created custom templates with Data Definitions for XML Publisher and Developed reports using reports and registered as XML reports in applications.
• Developed Master Detail forms using TEMPLATE.FMB and registered them in Oracle Application.
• Worked on Form Personalization in Order Management .
• Developed customer conversion program to load the customers from legacy system into Oracle EBS System by using the TCA APIs.
• Developed Alerts in AP/AR/OM/INV Modules .
• Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration.
• Worked in Oracle backend objects like: Database Triggers, Stored Procedures, Functions, Collections, records, views, materialized views and Packages using PL/SQL .
• Extensively participated in developing technical documents ( MD70 ).
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.

Oracle EBS System Analyst

Confidential

Responsibilities:

• Designed, Developed, Implemented and Supported Interface programs and data conversion packages for HRMS modules
• Participated in detailed Payroll requirement information gathering needed for Reports Customization
• Worked on Conversions for Employees, Addresses, Phones, Assignments, and Salary using Oracle seeded Application Programming Interfaces.
• Discussing with end-users functional requirements and providing solutions for the proposed system to implement the new custom designed application.
• Designed Database Tables for custom applications, Designed and developed new forms for custom forms using Oracle Forms 10g, Oracle Application Object Libraries (AOL) using TEMPLATE.fmb and CUSTOM.pll library objects.
• Implementation and expansion of Flexfields with Cross-Referencing extensively to capture additional information in various Standard Oracle R12 Applications Modules.
• Used personalization to customize Oracle Applications standard Attachment Functionality as well as calling multiple forms from single form through Form personalization.
• Created Dependant, Independent, Table Types Values Sets to validate Descriptive Flexfield Input in Custom and Standard Forms, Parameter Values for Reports and Concurrent Programs.
• Developed New Customs Reports, Alerts and Triggers.

Oracle Apps Techno/Functional consultant

Confidential

Responsibilities:

• Gathered functional and technical requirements from the end-users and analyzed existing legacy system.
• Involved in preparation of the Technical (MD70) design document, Installation document (MD120) and Conversion Mapping Document (CV40) during designing phase.
• Designed and Developed Data Conversion process for Oracle R12 (11.5.10.2) AP, GL and AR modules to populate Standard Tables from the Custom Staging tables.
• Wrote Data conversion scripts, data load, data validation scripts for data conversion for Supplier/Sites/Contacts, Customer, AP invoices, AR invoices, Open balances for GL.
• Creating New Forms, Menu Items, and Defining Concurrent executables, Concurrent Request for Customized Oracle Forms Applications, Oracle Reports, Oracle PL/SQL procedures and packages for Oracle 11i Application extensions.
• Creating and Maintaining Users and their responsibilities, creating new responsibility, Assigning Customized Forms, Reports and Oracle PL/SQL batch jobs to Responsibilities and Request Groups.
• Created Dependant, Independent, Table Types Values Sets to validate Descriptive Flexfield Input in Custom and Standard Forms, Parameter Values for Reports and Concurrent Programs.
• Creating TAR (Technical Assistance Request) on Metalink for Technical/Functional Support with Oracle while finding issues in existing Oracle Applications Standard Applications Functions during implementation, or while customizing existing Oracle Standard Modules for enhanced business requirements.
• Wrote reports in various styles like Matrix, Form letter, and Master-Detail. Various formats.
• Providing Customer Supports including System Requirement Study, Customization of Standard Functions, Product Development, and Enhancement based on customer requirements, Supporting Post-Implementation.

Software Engineer

Confidential

Responsibilities:

• Designing of CognosTM1 dimensions, cubes and Processes.
• Working on SQL.
• Gathered functional and technical requirements from the end-users and analyzed existing legacy system.
• Developed Customs Reports, Alerts and Triggers.
• Modify complex Business Logic into TM1 Rules and increase performance by writing feeders.
• Create Drill through Process from TM1 Cube to database for querying transaction level data.
• Design, build and populate TM1 Cubes with latest forecast data from Data Repository and build dimensions and various types of Cubes in TM1.

Technical Support Engineer

Confidential

Responsibilities

• Development of SQL and PL/SQL, reports using Report builder 10g, XML Publisher and Oracle Discoverer, Oracle Alerts, Form personalization.
• Performed the unit testing for the code and migrated the files through FTP (FileZilla, WinSCP).
• Involved in development of reports based on business requirements and registered them in Oracle applications.
• Preparing Technical Documents and Preparing Unit Test Scripts.
• Defined value sets, concurrent programs, request sets, templates for XML report, registering reports and PL/SQL Procedures, and Packages.
• As part of tuning, created Indexes on tables when necessary and made sure the cost of the query executions in low.
• Documented the development process as per AIM standards for each object along with the test cases
• Provide technical leadership to customer support & Tier 2 support teams Resolve complex technical issues via phone, email accurately communicating
• Technical information to varying skill and comprehension levels of customers in a professional and supportive manner that cannot be solved by Tier 1 and 2 levels.