Oracle Consultant

SAHANA SRINIVAS

860-***-**** *********.******@*****.***

Summary:

Oracle techno - functional consultant with over 8 years of experience in implementation and support.

Knowledgeable in aspects of E-Business, IT strategies, Project Management, CRM, E-Marketing and Supply Chain

In-depth understanding of new and emerging technologies like Oracle Fusion Middleware and their applications to business.

Project development and coding using PLSQL, Advanced PLSQL, Java, Javascript and

UNIX programming.

Subject Matter Expert (SME) for the dissemination of information from Client to the offshore team and vice versa.

Troubleshooting areas of poor performance and identifying effective solutions to resolve issues both in the immediate future and for the longer term.

Excellent experience and understanding of system development life cycle (SDLC) such as analysis, design, development, testing, implementation and support with exposure in database.

Completed 10+ full cycle implementations so far using Oracle Applications R11i, R12 with complete usage of Oracle Unified Methodologies.

Expertise in using Oracle 9i/10g/11g/12c database.

Experienced in performance tuning using explain plan, TkProf, Trace analysis.

Prepared DS140 (Technical writing for the codes developed), MD150 (Functional Setups required) and T20 (Test Documents).

Design and coding Web Pages using OAF and ADF tools. Designed and implemented dynamic Web content and Web-server application using OAF, ADF, MS-SQL, HTML, XML, AJAX, Web services and Simple Object Access Protocol (SOAP).

Worked with ADI and Web ADI tools to put Oracle detail into spreadsheets.

Automatized various customization processes by creation of custom concurrent programs with usage of standard base tables and APIs.

Worked with standard APIs and involved in debug for the same during upgrade projects.

Creation of reports using Report Builder, XML Publisher and XSL Style sheets.

Creation of new forms and customization of standard forms using Oracle Form Builder.

Active Participation to the Code and design review, meetings, effort tracking.

Worked with clients on Requirement gathering.

Fully responsible for overall end-to-end delivery and integration of the projects.

Establishing best practices for project development.

Mentored and trained freshers on the Oracle products and tools.

Expertise and implementation experience in Oracle ERP – Inventory (INV), Bills of Material (BOM), Work in Process (WIP), Advance supply chain planning (ASCP), Manufacturing Scheduling /MRP, Warehouse Management (WMS), Mobile Supply Chain Applications (MSCA), Engineering (ENG), Cost management (CST), Quality (QA), E-Records and E-Signatures (ERES), Approvals Management (AME), Order Management (OM), Purchasing (PO), Depot Repair (CSD).

Extensive functional knowledge on the Oracle Modules like Service Contracts, Install Base and Order Management including P2P and O2C cycles.

Creation of reusable interfaces and extensions for modules like Inventory, Sales Orders, Purchase Order, Banking, Asset management, Account Receivables, Account Payables and Customer modules.

Participated in technical discussions on Oracle Fusion with 3 years of implementation experience in CRM and Finance modules(AP, AR, FAH, SLA,GL ).

Worked at client location to understand the requirements and met the needs of culture bonding.

Excellent troubleshooting, de-bugging and problem-solving skills.

A committed team player with extensive organizational and interpersonal skills.

Skills:

Functional Skills

Technical Skills

Languages known

Oracle Service Contracts

BI Publishers

SQL/PLSQL(Advanced)

Oracle Financials - Account Payables and Account Receivables

Oracle Forms - Form Builder

C/C++

Oracle Install Base

Oracle Reports - Report Builder

JAVA

Oracle Banking

Oracle Workflow - Workflow Builder

UNIX/PERL

Oracle Supply Chain Management

OAF, ADF - JDeveloper

XSL Stylesheets

Oracle HRMS

Discoverer

VB Scripting

Oracle Asset Management

Scripting Tools - SQL

Developer, TOAD, SQL Plus,

Apache TOMCAT, Eclipse IDE, Tortoise SVN

Oracle Project Accounting

WinScp, Putty, Mercury Release Manager, Clear Quest Share Point

Oracle Product Management

Web Services and Web Server Applications - MS-SQL, HTML, XML, AJAX, SOAP, JAVASCRIPT

Oracle Process Management

QTP Automation Tool

Professional Experience:

Prism IT Corp, Florida, USA. 2017-Till Date

Responsibilities :

Designed and implemented dynamic Web content and Web-server application using ADF, MS-SQL, HTML, XML, AJAX, Web services and Simple Object Access Protocol (SOAP).

Created and maintained 5 SQL databases at remote locations, data was shared by these databases to run Shipping, Inventory, and an Install Base Web site.

Managed Backups, Queries, Stored Procedures, and Disaster Recovery for SQL databases.

Developed real-time credit card processing gift and card processing, USPS/UPS/FedEx shipping rates using OAF.

Integrated VB Script, AJAX, Java Script, and ADF to run custom Point of Sale (POS) module for application (touch screen, bar code scanner, credit card swipe, receipt printer and cash draw).

Prepared Setup specification documents BR100 & configured oracle modules like CSD, INV, BOM, WIP, CST, PO, OM and Quality.

Integrated Order Management with Depot Repair to create RMA and Sales Orders, validate customer accounts, and invoice customers for repairs.

Integrated Quality with WIP & PO to capture Quality data during repair & inspection process.

Defined various repair types like Repair and Return, Loaner, Exchange, Advance Exchange, Replacement etc to support different business processes.

Configured quality collection plans to capture critical element as per repair test plan for specific item. Displayed alert massage for specifications and errors.

Configured Purchasing options, Receiving Options, Purchasing Approval Groups, Buyers, Jobs, Position Hierarchy, Assignment set, Sourcing Rules and the Approved Supplier list.

Form Personalization to trigger custom label.

Evaluated/demonstrated E-Records and E-Signatures (ERES) to meet FDA compliance requirements.

Data Migration & Validation strategy. Performed Data conversion through Data Loader.

Designed customized reports & Bar code labels. Bar Code printer deployment.

Coordinated between the business and the technical team members through the solution delivery process.

Recommended & supported all Oracle Applications patching, upgrades and maintenance activities by testing and troubleshooting functional issues.

Oracle Corporation, Bangalore, India 2011 - 2016

Alcoa, Fullerton, CA

Techno Functional Consultant

Alcoa is among the leading suppliers of Alumina and Aluminum. Alcoa is one of the oldest clients for Oracle and has now been an integral client and major support to Oracle.

Responsibilities:

Worked thru Implementation phase of Oracle Process Management module for R11i and upgrade from Oracle 11i to Oracle R12.

Functional Setups related to Inventory, Account Receivables, Account Payables and OPM modules.

Technical understanding on standard tables and APIs like ar_invoice_api_pub.Create_single_invoive in AR module.

Involved in technical structure and analysis during R12 Upgrade for AP modules.

Technical understanding on replacement of key tables like PO_VENDORS.

Migration of PLSQL packages, PLSQL procedures, PLSQL objects, Forms, Reports and XML Reports from R11i to R12 instance. Totally migrated over 200 objects individually.

Debugging on standard AP module APIs like ap_vendor_pub_pkg.

Worked on complete life cycle of AR to AP including reconciliation and print functionality for creation of data and test purposes.

Worked on creation of logo for a customized report using XML Publishers.

Design and implement a contract first SOAP WebService to automate and regulate the OPM custom services.

Extensively worked thru P2P cycles for creation of data and test purposes.

Customized forms like Quick Receipts form and Purchase Order receiving form in OPM module.

Created a custom form called Lot Form which actually was able to achieve the functionality similar to R12 as Alcoa wanted to retain R11i for OPM module for a considerable amount due to some audit reason.

Worked on Advanced Pricing functionality, which involved complete customization like price modifiers and pricing methods.

Technical writing using Oracle Unified Method template specification.

Extended the functionality achieved during R12 upgrade in other regions like EMEA and APAC.

Worked closely with Oracle Metalink team to resolve standard Oracle Upgrade issues.

Improved the performance of the standard concurrent program – Auto Invoice Import with the help of Oracle Metalink team which was a one off issue during R12 upgrade.

Attended Alcoa client friendly hours organized by Oracle which enabled a bonding with the clients.

Post Implementation and Maintenance support.

Worked with complete implementation on moving the services to cloud for Oracle Fusion CRM – Service Contracts and Install Bases.

Awarded as the best project.

Client: National Trust, UK

National Trust is a charitable organization in the UK and rely for income on membership fees, donations and legacies, and revenue raised from their commercial operations. There are over 3.7 million members and 61,000 volunteers. More than 17 million people visit their pay for entry properties, while an estimated 50 million visit our open air properties. Oracle provided end to end implementation and is now working on Upgrade, post implementation support and maintenance.

Responsibilities:

Moved in during the post implementation and support phase for the project.

Worked with complete implementation on moving the services to cloud for Oracle Fusion CRM – Service Contracts and Install Base and Finance modules.

Functional and Technical understanding on the complete customization involved in CRM, Supply Chain and Financial modules.

Worked as tester.

Solely involved in upgrade and migration of 150+ forms, OAF pages, XML reports and Workflows.

Worked on Customizations like Creation of Memberships. Their Payment Terms and Methods, Types of Gift Membership and Orders.

Worked on BARCODE functionality for 25+ complex XML reports.

Worked extensively on OAF personalization for the CRM customized home page.

Technical understanding on the Configurator tool.

Worked on SVN branching for version control.

Worked on Clear Quest Share point tool.

Performance tuning using HINTS, which specifically reduced a concurrent program taking hours to complete to finish in less than a minute.

Worked on O2C and AR cycles

Worked on Install Base OAF pages and their customization

Worked on designing and developing web service for Install Base using JPA2 and OAF.

Client: Volta River Authority, Ghana

Volta River Authority is a governance project for Ghana country. Accra, a small territory with the river Volta harnessed the resources of the Volta River to provide electrical energy for industrial, commercial and domestic use in Ghana, as well as transportation, fishing and recreation. Oracle provided end to end implementation along with post implementation support and maintenance.

Responsibilities:

End to End implementation on all the above specified modules.

Solely involved in complete Functional Setups including AOL registry.

Solely worked on Interfaces and Conversions for Inventory and their org assignments, PO, OM, CRM,

AR, AP, GL, Banking and OAM modules using standard APIs.

Interfaces and Conversions included customized data validations per client requirement.

Worked on the scripts, so they could be reused for a similar requirement.

Special feature to create an XML report triggered thru PLSQL packs to enable the user to verify the data.

Worked as a tester.

Created OAF page personalization for Suppliers page, Invoice entry detail page and PO requisition page.

Worked on the logo for Volta River Authority and customized all reports created using Report Builder and XML publisher to use the newly created logo.

Technical writing using Oracle Unified Method template specification.

Best project award.

Client: UNISA, University of South Africa

UNISA is an educational institution with lot of study opportunities for students from across. Oracle provided end to end implementation to UNISA with key modules like Inventory and Order Management.

Responsibilities:

Solely worked on a complex automation which involved creation of items and assigning it to master orgs and all the child orgs.

Involved complex customization to differentiate between items created using complex validations.

Further involved automated creation of orders and their shipping based on the type of item.

The standard APIs were used along with submission of standard concurrent programs thru the package.

Finally, an XML report was triggered to display all the details the automation process performed to enable the visibility of the process to the users.

As a JAVA developer, maintained J2EE Applications using SOAP.

Prepared Installation Scripts and release packs with a release note for all the deliverable.

Was the only point of contact and worked as a developer, functional and tester for the complex object.

Performed Functional setup required for the automation

Technical writing using Oracle Unified Method template specification.

Was awarded the best employee for successful creation of this complex automation.

Client: New Zealand Housing, New Zealand

New Zealand Housing is a housing company and is well known for redevelopment of dwelling and modern homes across New Zealand. Oracle offered complete implementation on the Purchase Order and Requisition Management module.

Responsibilities:

Worked thru the second phase of the project.

Developed a complex custom workflow from scratch which created a requisition and a purchase order without any manual intervention which used standard workflow processes – REQAPPRV and POXWFPOA.

Created notifications to users using business events and WFMAILER.

Created a custom current program to automate the time entry for internal New Zealand Housing employees, which included usage of standard PA base tables and APIs like

PA_PROJ_TEMPLATE_SETUP_PUB and PA_PROJECT_PUB.create_project.

Maintained legacy web applications implemented with AJX, HTML and OAF.

Maintenance and post implementation support.

Created installation scripts (.SH) using shell programming.

Technical writing using Oracle Unified Method template specification

Client: Lintec, Japan

Lintec is a product based company and a known industry for adhesive manufactures. Oracle served the company with complete implementation, maintenance and support for the Oracle Management module.

Responsibilities:

Worked thru the entire phase of the project until successful release.

Functional setup related to Order Management.

Created 25+ custom Oracle forms using Oracle Form Builder, which included Japanese translations.

The custom forms included display and database update for custom column information for created orders. Mainly worked on Lot Numbers concept.

Created Custom views, inline views, global temp tables, triggers and database packages.

Technical understanding on standard OM tables and APIs, mainly on OE_ORDER_PUB.

Data creation using SQL loaders to fetch data from .CSV file format.

Creation of custom concurrent programs for data validation.

Created custom sequences and indexes as a part of technical coding.

Extensively used O2C cycle for creation of data.

Created installation scripts (.SH) using shell programming.

Technical writing using Oracle Unified Method template specification.

Client: Panasonic, Japan

Panasonic is a product based company and a known industry for Electronic goods and their manufacture. They came up with a model for Direct Store Model. Oracle served them with an upgrade from R11i to R12 and a successful implementation for the Oracle Modules Management, Oracle Warehouse Management, Linux/Unix.

Responsibilities:

Moved in during the release phase of the project and worked in Japanese Translations.

Functional setup related to Supply chain management and Warehouse management modules.

Sole person to prepare 200 release pack deliveries which included a .TAR file and complete Technical writing using Oracle Unified Method template specification.

NTT Data Corporation, Bangalore, India 2007-2011

Senior Software Engineer

Client: CSX Transportation, Florida

CSX Transportation is an American holding company focused on real estate and railways in North America. NTT Data supported end to end implementation. Worked during the final phase of the project.

Responsibilities:

Created UNIX automation to schedule spawned tasks.

Created 20 XML reports related to Order Management module.

Customization of reports to include logo using Report Builder.

Technical Writing using AIM methodology

Client: Staples, Boston

Staples is a well-known product based company. NTT Data provided testing support to Staples.

Responsibilities:

Worked as a tester.

Tested various integrated components to check the correctness.

Created data by running P2P cycle, O2C cycle and AR to AP cycles.

Functional setup for GL periods.

Created test documents per AIM methodology.

Created installation scripts.

Client: Unisys, Philadelphia

Unisys is a well-known product based company. NTT Data provided end to end implementation, post implementation support and maintenance to Unisys.

Responsibilities:

Worked on Service Contracts and Install Base module functionally and technically.

Extensive knowledge on standard OKS OKC and IB tables and APIs.

Created automation script called "Mass Item Creation" which involved bulk creation of instances items and contracts - service and warranty.

Worked with Oracle Metalink support to resolve various standard oracle bugs during upgrade from 11i to R12.

Created functional setup and documentations to record the same.

Created reports with company logos using XML publisher.

Customization of standard oracle forms and oracle reports.

Solely handled the month end data corrections during GL periods.

Created data scripts to cleanse/correct the data in the database tables.

Awarded as the BEST Employee twice.

Education:

B.E Computer Science

Certified Oracle Apps and JAVA Developer

Contact this candidate