SUMMARY:

• Having 11+ years of experience in IT Services industry.
• Having vast experience in design, development, and maintenance of Oracle E - Business Suite 11i and R12 with expertise in General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Assets (FA), Purchasing (PO), Sub Ledger Accounting (SLA), iProcurement, iExpenses and AOL objects.
• Having good knowledge on SCM Modules (OM, INV)
• Excellent Functional knowledge of P2P flow.
• Expertise in Oracle Apps R12 Technical (RICEW) with Oracle PL/SQL.
• Expertise in SQL, PL/SQL, and advanced PL/SQL.
• Expertise in developing Interfaces, Conversions, and BI Publisher reports.
• Expertise in Workflow development & customization, Reports Customizations and Form Personalization.
• Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools- Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Worked on 2 Cloud PPM Implementations and 2 assessments including multiple POC.
• Worked on 2 largest implementations with heavy PPM. Implemented PPM for 45 countries (BU’s).
• Involved in 10 Full Life Cycle Implementations/Upgrades, 5 production Support projects, 5 assessments and 3 Process re-engineering in Oracle eBusiness Suite (EBS) and Cloud PPM
• Very good experience in CI/CD Tools such as Jenkins, Release management tools Confidential APPDB, Kintana and Version Control tools SVN, PVCS, GITHUB, Project Management tool Rally
• Good knowledge on calling web services to integrating with ERP.
• Good knowledge on Oracle cloud Implementation.
• Analyze user requirements and create design documents from user requirements.
• Having experience in interacting with Stakeholders to gather the requirements.
• Have good experience in On-Site Off-Shore model.
• Have an ability and willingness to continuously acquire new competencies and accept new challenges.

TECHNICAL SKILLS:

ERP Packages: Oracle Apps R11i, R12, SAP- Ariba.

Database: Oracle 10g, 12c, 19c

Programming Languages: SQL, PL/SQL, Unix Shell Script, Perl Script.

ETL Tools: Informatica PowerCenter.

Scheduling Tools: Tidal Enterprise Scheduler, CTRL - M

Web Technologies: HTML, JavaScript.

Tools: & Utilities: Toad, Report Builder, Form Builder, Workflow Builder, SQL*PLUS, SQL*LOADER, SVN, PVCS, GITHUB, APPDB, Kintana & QC.

Platforms: Windows (XP-SP2, 7, 10), LINUX, UNIX.

Domain Knowledge: Finance and SCM

PROFESSIONAL EXPERIENCE:

Confidential, San Jose

Technologies: Oracle Apps R12 (AR), Unix, Oracle PL/SQL.

Tools: TOAD, Putty and CTRL -M

Responsibilities:

• To evolve Biz Model for HW Consumption Models or Hardware as A Service (HaaS) by providing better user experiences for the customer.
• To enable flexible consumption, simplified sales motion and As A Service Offering for the customer
• Allow users to consume Confidential Owned Full Stack with variable units of capacity Contribution.
• Configured the PPM Setups for POC1, POC2, SIT1, SIT2, SIT3, UAT and in GOLD (Production)
• Designed and developed a completely new Business functionality for Athena Products, which allows business users to assess the Credit Capacity of the customers.
• Developed new PL/SQL Code components, Interfaces, Packages, Complex Reports to enhance the Credit Management Functionality.
• Enhanced Interfaces to send data between EBS Database to eCredit System using PL/SQL Scripts and generating data files.
• Supported GL, AP, AR, FA and iExpenses modules. Worked on vertex tax engine
• Enhanced various XML Publisher Reports according to the client requirements.
• Interacting with clients to interpret and evaluate business requirements and propose technology solutions.
• Understand business models and translate them into either service configuration or specification for new implementation.
• Interacting with IT and Business groups during entire software life cycle development phase.
• Identifying opportunities for technology-related improvements.
• Translate business/user requirement into technical requirement
• Write solution/technical specifications for Technical team.

Confidential, San Jose

Technologies: PL/SQL, Informatica, Oracle 19c, Java, Hadoop, Kafka, Perl Web Services

Tools: TOAD, Putty and CTRL -M

Responsibilities:

• Allows a distributor to submit Bookings, POS, INV and claims.
• Define business rules for distributor’s located world-wide.
• Process the data submitted by distributors in different currencies.
• Automate all the validations required to process data. Interface it to cross functional systems like Customer Registry in order to get the cleansed and registered data
• Provide the data to downstream reporting application that facilitates the management with quality reports. Sales credit application that benefits the field engineer by crediting the sales on his name
• Gathering business requirements from Business Analyst.
• Designed and developed a BE process for a new User Interface from which DISTI’s can modify the address related errors.
• Developed a PL/SQL Interface for Internal POS to get the data from O2C and enrich according to WIPS requirement and transform the data to be used by downstream systems.
• Designed and developed POS templates, Formulated data governance rules and master data profiling requirements.
• Developed various reports according to the client requirements.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer, and scheduling of the workflow.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle.
• Analyzing business process workflows and development of ETL procedures for moving data from source to target systems.
• Interacting with clients to interpret and evaluate business requirements and propose technology solutions.
• Understand business models and translate them into either service configuration or specification for new implementation.
• Interacting with IT and Business groups during entire software life cycle development phase.
• Identifying opportunities for technology-related improvements.
• Translate business/user requirement into technical requirement
• Write solution/technical specifications for Technical team.

Confidential, San Jose

Technologies: Oracle Apps R12, SAP Field glass, PL/SQL, Oracle 12c

Tools: TOAD, Putty and CTRL -M

Responsibilities:

• Attending the Client meetings to understand the Business requirement.
• Analyzing the source system and how the data is presented in there.
• Prepare Technical documents to map the data with the destination tool at column level details.
• Fetching the source data and cleansing and converting into agreed format.
• Encrypting the data and transfer to the target system.
• Analysis of connectivity and adaptors details as part of long-term technical plan.
• Coordinating with the offshore team.

Confidential

Technologies: Oracle Apps R12, SAP-ARIBA, PL/SQL, Oracle 12c

Modules: AP, GL, PO, IBY, FA, iExp, iProc

Tools: TOAD, Putty and CTRL -M, Toad, WINSCP, Putty, SSH, Workflow Builder, XML Publisher, Oracle Reports, Kintana.

Responsibilities:

• Worked on 12.2.8 Upgradation of Oracle EBS from 12.1.3.
• Successfully completed RPC5 (Required Patch Collection), FND, CPU Oct-2017 CPU-2015, PSU patch bundles application in Production environment.
• Completed Oracle 12C Database upgrade, R12.2.5 Application upgrade POC.
• Coordinating with DBA team before and after implementing the Infra Maintenance plan.
• Performing the patch Analysis for RPC, CPU, all major and minor patches applied.
• Identifying the objects changed into invalid status because of the maintenance activity, and make sure the status changed to valid status.
• Restored customizations, which are overridden by patches. Modified Invoice Approval Workflow.
• Analyzing rdf, SQL, and all code files for any changes and if there are any modifications found, if required, we need to make changes to them so that our business functionality to work smoothly.
• Testing the end-to-end Functionality across the modules. Finding the deviations, if any, and then working for the fixes.
• Raising SR’s and working with Oracle team if any of the fixes not found.
• Working with performance team and taking steps to improve the performance of the Application.
• Coordinating with multiple teams across the projects to make sure the Application is working in an optimum level.

Confidential

Technologies: Oracle Apps R12, PL/SQL, Oracle 12c

Modules: GL

Tools: TOAD, Putty, APPDB.

Responsibilities:

• Analyzing the existing system and gathering exact business requirements to flow the data into down streams.
• Design, Development and coding the interface using PL/SQL.
• Developed BI reports and implemented XML Bursting Logic to send Emails with Error Records Attachment.
• Extensively tested entire functionality as it deals with critical General Ledger Accounts.
• Responsible for overseeing the Quality procedures related to the project.
• Migration process using APPDB.

Confidential

Technologies: Oracle Apps R12, PL/SQL, Oracle 12c

Modules: AP, GL, iExpenses, iProcurement.

Tools: Toad, WINSCP, Putty, SSH, Workflow BuilderXML Publisher, Oracle Reports, Kintana.

Responsibilities:

• Analysis of the specifications provided by the clients, Design and Development.
• Extensively worked on a very complex Report - Confidential Account Analysis Summery/Detail Report.
• Developed BI reports and implemented XML Bursting Logic to send Emails with Attachment.
• Extensively worked on rdf reports.
• Worked on Confidential ERS Invoice Load Program Performance tuning.
• Responsible for developing Data fix scripts.
• Developed the programs that can be re used while reducing the Re work effort.
• Completed APPDB POC while successful testing of the object migration.
• Testing - unit testing & integration testing.
• Responsible for overseeing the Quality procedures related to the project.
• Migration of developed objects using APPDB, Kintana.

Confidential

Technologies: Oracle Apps R12, PL/SQL, Oracle 12c

Modules: AP, GL, PO, IBY, FA, iExpenses, iProcurement.

Tools: Toad, WINSCP, Putty, SSH, Workflow BuilderXML Publisher, Oracle Reports, Kintana.

Responsibilities:

• Verifying ACL Connections
• Verifying the Application connections with DC1 and DC2 (Data Center).
• Communicating with all other external teams like ECB, iSupplier, Payroll, Sabrix etc., which are connecting with the CFN network and make sure the connection established in a right manner while testing all the scenarios.
• Rigorously tested End-to-End Application which includes the crucial customizations like C-Worker, Punch-outs, CXML, EDI, Amex and all other important customizations and functional flows in order to make sure the Application is working in a correct way.
• Covered End to End testing in I2R, P2P, and P2O Modules.
• RPC 3 Patch analysis performed as part of Confidential ’s plans to apply the patch in CFN.