Professional Summary:

• Over 7 years of IT experience in designing, developing, implementing of Oracle Applications R12/11i/11.5.10.2 using ORACLE 11g/10g/9i/8i, SQL, PL/SQL, Forms 10g/6i, Reports 10g/6i, Discoverer 9i/4i, XML Publisher/BI Publisher and OAF.
• Proficient in Implementation, Integration, Upgrade and Support projects for Financials, SCM, Manufacturing modules of Oracle E-Business Suite.
• Solid expertise of:
• Oracle Financials modules GL,AR,AP,FA
• Oracle Manufacturing modules WIP, BOM
• SCM (Supply Chain Management): PO,INV,OM
• ASCP(Advanced Supply Chain Planning)
• CRM(Customer Relation Management)
• OPM(Oracle Process Manufacturing)
• Expertise in designing, developing product development, test methodologies, and production support and test.
• Good Experience in implementing Order-to-Cash and Procure-to-Pay Business Process flows.
• Experience in implementing Technical design documents (AIM).
• Extensive experience in Oracle EBS(E-Business Suite),Oracle Forms, Oracle Reports,PL/SQL,SQL*Plus UNIX, SHELL Scripting, TOAD, Oracle Discoverer, Optio, XML Publisher/BI Publisher and Oracle Workflow.
• Well Proficient in understanding client's requirements, designing and developing customizations according to the requirements and specifications.
• Involved in customization, personalization of apps forms using Custom.pll, Form personalization feature in APPS.
• Extensive experience in TCA architecture.
• Extensive experience in TCA customer setups in Oracle EBS.
• Experienced in designing, developing and customizing OAF(Oracle Applications Framework) using Oracle JDeveloper.
• Experience in performance and tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints.
• Experience in creating Concurrent Programs, Request Sets, Flex fields, lookups, Profiles, Value Sets, Triggers, Packages, Procedures, Functions and Cursors.
• Performing AOL Tasks (Creating responsibilities, users, request groups, attaching responsibilities to users etc).
• Extensively used System Administrator,AOL and Application Developer responsibilities, for registering Concurrent Programs, application user set up, defining responsibilities, value sets, Flex Fields, registering reports, forms, creating menus, functions, lookups etc.
• Extensive technical experience in RICEW (Reports, Forms, Interfaces, Conversions and Workflows) Components.
• Hands-on experience in data conversion, data migration and preparing documents like CV10, CV40, CV60,MD50 and MD70 based on functional requirements in various Manufacturing,Supply chain management and Financials modules.
• Worked and managed successfully many Full Life Cycle of Software & Business Projects involving Requirement Analysis, User interviews, Architecting, High level Design, Low level Design, Presentation Layer, Prototyping, Designing, Developing, Code Reviews, Testing, Implementing, Deploying, Documenting, Maintaining and client/user interaction.
• Excellent inter-personal and problem solving skills.
• Strong communication skills.

CERTIFICATION:

• Oracle Certified Professional for Oracle Application Frame work (OAF).

Professional Work Experience:

Client :Confidential, Torrance, CA, USA
Duration : Dec'08 - Present
Role:Oracle Technical Analyst
Description:
Confidential, is a premier nutrition and weight-management company. We offer life-changing products and an unparalleled business opportunity. Herbalife has become a world-class company with over 1.9 million Distributors.

Responsibilities:

• Reviewed Functional Design documents.Designed and implemented Technical Design documents using AIM methodology for Oracle SCM (PO, OM, INV), AR,AP and GL.
• Designed and customized numerous PL/SQL packages as per client requirement.
• Developed the reports using Optio 7.8 Design tool.
• Developed Several XML Reports in all modules like PO, OM, INV, AP, AR and GL.
• Uploaded all the concurrent program, Value sets and Responsibilities details into another instance by using FNDLOAD commands.
• Participated in the Unit and Integration Testing along with the end-users.
• Created various Unit Test Case and Installation Documents as per the requirements.
• Creation of concurrent executables and Concurrent Programs for interface programs and Customized Reports.
• The oracle out of box feature for TCA called Business Event Subscriptions (BES) was utilized to capture all updates to the TCA registry (party and account information).
• Using TCA to fetch customer level information for the reports.
• Responsible for documenting the mapping and requirements for the interfaces and conversions between the source and oracle Applications.
• Involved in Performance Tuning.
• Defined Processes, Notifications,Roles and Messages in Oracle Workflow as per client requirements.
• Customized Workflows as per the client requirements.
• Performing AOL Tasks(Creating responsibilities, users, request groups, attaching responsibilities to users etc).
• Extensively used SRW packages in Oracle Reports.
• Imported the Standard Invoices, for Oracle Receivables, from Legacy System into Oracle Applications. Developed a control file using SQL*Loader to import the data from flat files into Staging tables. Created PL/SQL Package/Procedures to validate the data and entered into the Interface Tables and finally imported the data into the Base tables using Auto Invoice Import program.
• Defined setups in Order Management, and worked on various issues with Functional and Business Analysts.

Environment: Oracle Apps Implementation Release (12.0.3)
Modules: SCM (PO, INV, OM), Financials (AP, AR, GL, FA); SQL, PL-SQL, Forms 10g, Reports 10g, Putty, Winscp 3, FTP, Optio 7.8, Windows XP and UNIX.

Client :Confidential, Waukesha, WI, USA
Duration : Aug'08 - Dec'08
Role:Sr Oracle Consultant
Description:
Confidential, market and service the critical equipment that forms the backbone of the world\'s energy infrastructure. Around the world, Dresser stands for excellence in energy equipment and services. Dresser\'s Compression and Power Systems Segment is a leader in the design, manufacture and marketing of natural gas-fueled engines, used primarily for natural gas compression and distributed power generation. These engines are sold under the Waukesha.
Waukesha Engine manufactures engines in the United States (Waukesha, Wisconsin, USA) and in Europe (Appingedam, The Netherlands). Both of Waukesha\'smanufacturing facilities are certified by the world\'s leading registrar, Lloyd\'s Register Quality Assurance (LRQA), to the ISO 9001:2000 Quality Management System Standard. Waukesha Engine manufactures large, spark-ignited, gaseous fueled reciprocating engines. Waukesha also packages Enginator engine-driven generator sets. The products are widely used in field gas compression, power generation and other mechanical drive applications. In addition, Dresser is the only ASTM-listed manufacturer of the Cooperative Fuel Research (CFR) engine, used to test and qualify the octane and cetane value of gasoline and diesel fuel.

• A solid reputation for providing products and technologies that drive performance, efficiency, growth and safety
• 12,000-plus customers, including the premier names in oil and gas, coal, refinery and petrochemical processing; electrical power generation; food, pharmaceutical, textile, pulp and paper, and other industrial processors; and natural gas, water and waste-water utilities
• Sales presence in 100 countries
• Manufacturing and customer service facilities strategically located in 20 countries, enabling us to meet customer needs throughout the world
• An array of aftermarket services such as OEM parts, diagnostics, service and repair
• 6,000 employees around the world

Responsibilities:

• Interaction with the users to getting all the business requirements.
• Analysis of Conceptual design document and understanding Business Requirements & Functional design documents for the migration/interface components.
• Prepared MD50 documents as per the client requirements.
• Developed Vendor Interface program to load data from legacy system in to temporary table to validate the data and run the Interface Program to load the data into base tables.
• Build an Oracle Workflow so that as soon as the Sales Order is booked a notification should be sent to all the users.
• Setup AR and HZ profile options ,Tax Location Flexfield ,flexible addresses,Flexible Address Validation, Customer Profile Classes (optional) ,customer lookups Enter parties and customer accounts Enter Customer Account Information by using TCA Architecture for Oracle EBS.
• As a part of this project, 6 different Service history reports were created to help track the history or trend in Service Requests based on Customer, Location, Market Place, and SR Status etc. The customer information was fetched based on TCA.
• Post-production troubleshooting and analysis of business process issues within: TCA/Customer Master. Gather requirements, write functional (MD050) and technical (MD070) specifications, provide recommendations for user challenges, and implement process and system modifications.
• Implementation Method (AIM) approach, and documented the process using AIM guidelines.)
• Created and customized various reports using XML Publisher.
• Designed and developed reports in OM,FA,PO,INV,AR, and AP using XML Publisher.Defined Data Definitions and Templates in Oracle Applications.
• Extensive Experience in OM API's.
• Designed and defined inventory key flex field structure, inventory structure, organization setup, organization calendar and exceptions, items, serial and lot controls.
• Defining set-ups for OM and Inventory.
• Defined purchasing, financial and receiving options. Defined ATP rules, document types, approved suppliers, buyers, approval limits and groups in PO application.
• Defined Payment Options, Payment terms, Distribution Set, Payment format, Matching options, Adjustment of Prepayments in AP.
• Interacted with users to design and develop the interface from legacy and third party system to Oracle Applications.
• Developed an Interface Program for loading Sales orders from flat files to Oracle Order Management. Used SQL*Loader to load the data from Legacy systems into Oracle Apps.
• Developed Custom Reports of different types as per user requirements.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Developed AFA Warranty and AFA Warranty ClaimInterfaces in CRM Module.
• Developed Item Conversion.
• Imported Bills and Routings through BOM Interfaces.
• Created Shell script program to call the SQL loader program that transfers data in data file to staging table and runs the custom concurrent program to transfer data from staging table to interface tables.
• Registering custom reports and PL/SQL Procedures, Triggers and Packages and creating executables using Application Object Library (AOL) in the development environment.

Environment: Oracle Apps Implementation Release (11.5.10.2)
Modules: Manufacturing(WIP,BOM),SCM(PO,OM,INV),Financials(GL,AP,AR,FA),CRM; SQL,PL-SQL, Forms10g, Reports10g, Putty, Winscp 3, FTP,TOAD Windows XP and UNIX.

Client :Confidential, Boston, MA
Duration : May'08 - Aug'08
Role:Oracle Apps Developer
Description:
Confidential, is a research-based pharmaceutical company dedicated to treating and preventing human diseases by discovering, developing, and commercializing innovative pharmaceutical products that are directed towards serving unmet medical needs.

Responsibilities:

• Interacted with the functional team to understand the business and user requirements.
• Prepared the MD50, MD70 and UTC (Unit Test Case) Documents.
• Prepared SQL scripts for creating the concurrent programs, executables and parameters in Oracleapplications.
• Created Discoverer Reports for GL,AP,AR,PO,ASCP,OPM and OM modules using Discoverer Administrator and Desktop Edition. Created EUL's, Custom Folders, Business Areas, and Workbooks. Assigned Privileges and registered the reports in Oracle Applications. Customized the Workbooks by adding additional functionality (conditions, calculations, parameters, sorting, etc.) and scheduling them for the users.
• Uploaded all the concurrent program details into another instance by using FNDLOAD commands.
• Involved in Custom.pll and form personalization.
• Developed the interfaces as per the requirements.
• Creation of Value sets in various Modules of the application.
• Defining Concurrent Programs, Executables and Parameters.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.

Environment: Oracle Apps Implementation Release (11.5.10.2)
Modules: OPM, ASCP, SCM (PO, INV, And OM),Financials(AP,AR,GL,FA), Conversions; SQL, PL-SQL, Discoverer 4i, Forms 6i, Reports 6i, Putty, TOAD, Winscp 3, FTP, Windows XP and UNIX.

Client :Confidential, Atlanta,USA
Duration: Jun'07 - May'08
Role:Sr Oracle Apps Consultant
Description:
Confidential, headquartered in Atlanta, Georgia having offices across the United States of America is a service provider for specialty products and engineer services. Tensar specializes in cost-effective solutions for common site development problems. These solutions are used in development of residential, commercial, industrial, municipal and transportation infrastructure. The Company has two manufacturing plants located in Morrow, Georgia and Evansville, Indiana. Tensar Earth Technologies and Tensar Polytechnologies orders are processed from the plant located in Morrow, Georgia and North America Green orders are processed from its plant in Evansville, Indiana.

Responsibilities:

• Getting the functional inputs from the users and worked on the technical enhancements.
• Analyzed business requirements, designed, implemented business solution design and development.
• Created and customized reports using XML Publisher in OM, AR, AP and INV. Defined Data Definitions and Templates.
• Prepared the Technical Design documents, Installation documents and Unit Test Case documents.
• Worked on the Data Conversions using SQL*Loader to import legacy Suppliers into the PO Module.
• To send notifications to users by using oracle work flow builder.
• Customized Workflows as per the client requirements.
• Experience includes application system administration activities such as user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs, providing support to apps users for any technical and functional issues.
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracleapplications.
• Uploaded all the concurrent program, Value sets and Responsibilities details into another instance by using FNDLOAD commands.
• Involved in document review, code review and testing.
• Involved in Custom.pll and form personalization.
• Creation of Value sets in various Modules of the application.
• Defining Concurrent Programs, Executables and Parameters.
• Validated test scenarios and test cases to ensure that the delivered unit is valid after incorporating the changes.
• Evaluated tests using Explain Plan and tkprof utilities.
• Developed the reports and Forms as per the current requirement by using reports6i and Forms 6i.

Environment: Oracle Apps Implementation Release (11.5.10.2)
Modules: SCM(OM,PO,INV), Manufacturing(WIP,BOM); SQL, PL-SQL, Forms 6i, Reports6i, JDeveloper, Putty,FTP, Winscp 3, Windows XP and UNIX.

Client : Confidential
Duration: May'06 to May'07
Role:Oracle Apps Developer
Description: Confidential, is a Global player in various businesses including Aerospace, Automotive Replacement Glass, Insurance & Services, Architectural Coatings and Derivatives, Optical Products, Automotive Coatings, Fiber Glass, Packaging Coatings, Automotive OEM Glass, Fine Chemicals, Performance Glazing, Automotive Refinish, Industrial Coating and Silica's. The project is to re-engineer their business processes spread across the World by the name "Business Breakthrough Re-engineering". This project involved reengineering and upgrade of 11i Custom objects from Release 11.0.3 to Release 11.5.10.2 in all modules.

Responsibilities:

• Analyzed business requirements.
• Worked on Customer conversion to import data from Legacy System into Oracle Account Receivables by using Customer Interface. Created SQL*Loader control programs and validation procedures to execute along with Customer Interface (AR).
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Designed, developed and implemented business solution.
• Developed an interface for monthly import of journal entries from payroll running on a legacy system by using the journal import interface provided by Oracle General Ledger.
• Prepared the Technical design documents, Installation documents and Unit Test Case documents.
• Extracted data from AP tables and sending a flat file (checks cut in a period) using UTL_FILE package at periodic intervals.
• Involved in Custom.pll and form personalization.
• Developed new custom forms as per the client requirement.
• Used AOL, System Administrator and Application Developer responsibilities to register new reports, functions, menus and created validation sets, request sets and concurrent programs.

Environment: Oracle Apps Implementation Release (11.5.10.2)
Modules: SCM (OM,PO,INV), Financials (AP,FA,GL,AR); SQL, PL-SQL,Forms 6i,Reports 6i,Putty,Winscp 3,Windows XP and UNIX.

Client : Confidential
Duration: Dec'04 to May'06
Role:Apps Developer
Description:
Confidential, implemented a new business structure for its global operations. Dynea's businesses - panel board, industrial resins, wood and specialty adhesives, and paper overlays - restructured into four regional structures: Europe, North America, Asia Pacific and South America through the implementation of Oracle Apps ERP.

Responsibilities:

• Involved in document review, code review and testing.
• Prepared the Technical design documents, Installation documents and Unit Test Case documents.
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications.
• Developed reports like Packing slip report, PO Requisition Report, Sales Order Cross Reference Report etc…
• Developed Interfaces in OPM.
• Involved in Custom.pll and form personalization.
• Uploaded all the concurrent program, Value sets and Responsibilities details into another instance by using FNDLOAD commands.
• Tuned the reports to improve performance.
• Creation of Value sets in various Modules of the application.
• Defined Concurrent Programs, Executables and Parameters.
• Developed the reports as per the current requirement by using reports6i.
• Loaded Legacy Journals data into GL interface table using SQL*Loader and run Journal Import Program and integrated into Oracle Applications.
• Customized the following Oracle Payables, Purchasing and Receivables reports according to business requirements.

Environment: Oracle Apps Implementation Release (11.5.9)
Modules: SCM (OM, PO, INV), Financials (AP, FA GL, AR), Oracle process Manufacturing(OPM); SQL, PL-SQL, Forms 6i, Reports 6i,Putty,Winscp 3,XP & UNIX.

Client : Confidential
Duration: Oct'03 to Dec'04
Role:Oracle Apps Reports Developer
Description:
Confidential offers superior sound equipment for aircraft, audio, broadcast, communications, multimedia and wireless applications.

• Customization and enhancement for existing reports and interfaces in the modules of Inventory, Oracle receivables and Order management.
• Prepared the SQL scripts for creating the concurrent programs, executable and parameters in Oracle applications.
• Customized several reports are: Customized Invoice Print Select Invoices Report - Telex Customized Move Order Pick slips Report - Telex. Customized Dispatch list Report- Telex. Customized Print consolidated Report - Telex
• Creation of Value sets in various Modules of the application.
• Defining Concurrent Programs, Executables and Parameters.
• Imported the customers into Oracle Receivables using the Customer Import Program with in Oracle applications. Used SQL*Loader to load the data from flat file into staging tables, finally into Customer Interface Tables, and then into Base Tables.

Environment: Oracle Apps Implementation Release 11i (11.0.3)
Modules: SCM (OM,PO,INV),Financials(AP,FA,GL,AR); SQL, PL-SQL, Forms 4.5, Reports 2.5, Putty, Winscp 3, XP & UNIX.

Client : Confidential
Duration: Mar'03 to Oct'03
Role:Oracle PL/SQL Developer
Description:
Confidential, high-performance network infrastructure helps businesses create a responsive and trusted environment for accelerating the deployment of services and applications over a single network. Juniper\'s high-performance network infrastructure encompasses:

• Best-in-class IP routing, security and WAN application acceleration solutions to power and protect the network, as well as the applications and services that run on it.
• Performance-enabling customer services designed around a time-to-value model that accelerates, extends and optimizes the value of high-performance networking, and fuels competitive advantage.
  

• Developing new Reports, Forms as per client Requirements.
• Created tables, indexes, views, synonyms and sequences.
• Developed PL/SQL programs for validations.

Environment: SQL, PL-SQL, Forms 4.5, Reports 2.5, Winscp3, Windows and UNIX.

Educational Qualification:

• Master in Computer Applications (MCA)
• Bachelor in Science (BS)