Oracle Support

Janarthanan Pandurangan

*********@*****.***

Phone – 972-***-****

H1B Visa with Approved I-140, TCS Fulltime ( Client : Michaels Stores Inc, Irving, Texas )

Current Petition Expiry: 31-JAN-2023

Professional Summary:

Oracle Cloud/E Business Suite Techno Functional consultant/Business Analyst/EBS Developer having 12+ years of experience in Production Support, Development/Enhancements, Implementation and Testing of Oracle Applications across R11i, R12. Working in the area of Financial Modules (General Ledger, Accounts Payables (Invoices & Payments), Fixed Assets, Cash Management and IExpense) and worked on Supply chain Management Modules (Modules involved in Order to Cash and Procure to Pay Cycle). Extensive experience in RDBMS, SQL, PLSQL, UNIX, Pro-C and building custom application. Worked on Oracle Forms/Report/Workflows/Oracle APEX/Oracle OAF. Ability to learn any Tool/Functionality/Process without guidance based on Business Requirement or Project Need.

Oracle Financials & SCM Production Support - 5 Years

Oracle Application Development/Enhancements - 7+ Years.

Have Experience in Technical Lead role for the End-To-End Implementation of Purchasing, IProcurement, Isupplier, Project Costing.

Current Work - Business Analyst/Technical Lead in Onsite-Offshore Model for Oracle Finance Enhancements. Excellent Functional Knowledge in Oracle Fusion Cloud Procurement and Financials Modules and EBS Underlying Architecture.

Key Certifications gained are below:

Oracle E-Business Suite 12 Financial Management Certified Implementation Specialist: Oracle Payables

Oracle Financials Cloud: Payables 2019 Certified Implementation Specialist

Oracle Financials Cloud: General Ledger 2019 Certified Implementation Specialist

Oracle Procurement Cloud 2018 Certified Implementation Specialist

Oracle Financials Cloud: Receivables 2019 Certified Implementation Specialist

Oracle Revenue Management Cloud Service 2019 Certified Implementation Specialist

Certified on “ITIL V3 Foundation”

Education Summary:

-B.Tech. (Engineering) from Coimbatore Institute of Technology, Coimbatore, India.

Core Competencies\Experience Summary:

oWorked as a Techno- Functional Consultant/Business Analyst in Implementations, Upgrade and Production Support of Oracle EBS in various industries like Telecom and Retail.

oWorked in R12 Implementations with Financials and Procurement Modules.

oWorked in PCARD and Travel & Expense Card Implementation.

oWorked in Oracle Retail Sales Audit Implementation.

oPurging and Archival of Financials & Procurement Modules.

oWorked on Several Integrations with Bank for Payments, Invoice Interfaces, and Accounting Etc.

oMultiple project life cycles experience with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirements Gathering including facilitate Workshops, Scope Verification & Validation, Alternatives Identification and Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live and Post-Implementation Support.

oKnowledge of SDLC and Agile Methodology.

oStrong Exposure in preparation of Functional & Technical design documents (BR100, MD50 & MD70) for Custom application development, Conversions, Interfaces & Reports.

oPrepared generic Test cases for various Financials End to End modules. Testing includes Unit testing, System Integration Testing, Performance Testing, User Acceptance Testing, Regression Testing etc.

oGood troubleshooting & problem solving skills (triage, diagnostics, resolution) using tools like PLSQL Developer, TOAD.

oAbility to deliver end-to-end solution for Production Support problems and development tasks including identifying the Issue, Configuration, Development and Testing.

oStrong understanding of business flows, underlying technical architecture, basic accounting and table structure of E-Business Finance modules and SCM Modules.

oSolid understanding of integration of Oracle Applications modules, Multi Org,Chart of Accounts, Trial Balance, Budgets and Flex fields.

oGood understanding of Fusion Middleware.

oAbility to work effectively with Oracle Support to resolve Service Request (SR) issues.

oTechnically proficient in RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows)

oExtensively experienced in Oracle PL/SQL development i.e. Stored Procedures, Packages, and Functions & Triggers.

oExperience with Oracle SQL loader to load data and validate/Import into Oracle Base Tables.

oExperience developing and optimizing Concurrent Programs in Oracle Apps. Strong knowledge and understanding of Oracle APIs.

oCustomized and developed Oracle Forms and Oracle Reports using oracle Forms 10g and Reports 10g. Developed UNIX shell Scripts with SFTP/Encryption.

oExperience in defining new architectures and ability to drive an independent project from an architectural standpoint.

oExperience leading customer workshop sessions to educate customers on the latest technology trends and best practices.

oAbility to handle multiple priorities and experience in on-call support Process.

oTrained the client’s super users and users on the application and conducting Pilot testing, integrated testing, design validations and setups of the Distributed ERP applications.

oExcellent communication skills and leadership qualities with analytical problem solving abilities including playing vital role in coordinating multiple business meetings and following up on open item.

Areas/Applications

Oracle Fusion Cloud – Procurement

Oracle Fusion Cloud – Financials

Oracle EBS - Oracle Finance Modules

oGeneral Ledger

oAccount Payable

oFixed Assets

oE-Business Tax

oIExpense

oFinancial Accounting Hub (FAH)

Oracle EBS – IProcurement & ISupplier

Oracle EBS – Project Costing

Oracle EBS - Order To Cash & Procurement to Pay (Supply Chain Management)

oOrder Management

oPurchasing

oAccounts Receivable

oInventory

Data Bases

Oracle 9i/10G/11g/12c with emphasis on PL/SQL

Tools & Packages

TOAD & PL/SQL Developer

Oracle Discoverer 10g

JDeveloper

Oracle APEX

EDI Gentran

XML/BI Publisher

Oracle Application Framework

Oracle Form Builder

Oracle Report Builder

Oracle Workflow

Remedy Management Tool – Incident/Problem/Change Management Process

Proficient in using Microsoft Office products (Word, Excel, PowerPoint and Visio).

Control-M Scheduler, Data Loader

Oracle Integrator Cloud (OIC)

Languages

SQL, PL/SQL

Unix

Pro - C

JAVA

XML

Business Areas

Oracle Fusion Cloud - Procurement

Oracle Fusion Cloud - Financials

Oracle EBS - Financial Management

Oracle EBS - Supply Chain Management

Certification:

Oracle Financials Cloud: Payables 2019 Certified Implementation Specialist

Oracle Financials Cloud: General Ledger 2019 Certified Implementation Specialist

Oracle Procurement Cloud 2018 Certified Implementation Specialist

Oracle Financials Cloud: Receivables 2019 Certified Implementation Specialist

Oracle Revenue Management Cloud Service 2019 Certified Implementation Specialist

Oracle E-Business Suite 12 Financial Management Certified Implementation Specialist: Oracle Payables

ITIL

Oracle PL/SQL

Professional Experience:

Since June, 2013 to Till Date - Tata Consultancy Services

Client Name : The Michaels Companies.

Project : Michaels – Oracle Finance Enhancements

Implement Procurement, supplier Portal & Project Costing.

Position : Oracle Application Techo Functional Consultant.

Location : Irving, Texas - USA.

Environment : Oracle IProcurement, Isupplier, Project Costing, Purchasing, General Ledger, Account Payables, Fixed Asset, Cash Management, E-Business Tax & IExpense

Responsibilities :

Objective of our project is to work on Several Enhancement of Oracle Finance project based on Business IT work request.

Full Cycle Implementation of Procurement and Project Costing.

Gathering new Enhancement requests from the customers and documenting them in the form of Development Requirements Documents. Attend Client Discussions, suggest and propose solutions that add value to the company.

Experience leading projects through decomposing high level functional requirements into system requirements, leading meetings, presenting ideas and developing project plans.

Maintain Coordination with various functional teams, Business Users and Offshore Team to fix the issues and to keep the application stable.

Providing weekly status to the clients on the Enhancement Requests.

Worked on Several Integrations with Bank for Payments.

Prepared Functional and Technical Design Documents for Enhancement Work Request.

Testing the custom processes and programs as per the requirement and design.

In user edition, developed various crucial financial analysis reports for Business Users using Oracle Discoverer 10g.

Create SQL queries, PL/SQL packages to incorporate the business functionalities.

Enhancements to Internet Expenses functionality.

Designed and developed various custom PL\SQL APIs (Business Logic Routines) for various Financials Interfaces from Third party vendor.

Developed custom reports in oracle General Ledger that gives a listing of all accounts balances according to the financial calendar.

Performing Pre Go-Live checks and Post Go-Live checks. Prepare Unit test plan and unit test cases

Develop the code and deliver it at the right time along with unit testing results .Also Involved in UAT, code deployment & Oracle Finance support phase.

Integration testing between Oracle EBS and external systems like Banks and other client specific corporate systems.

Knowledge of Agile Methodology.

Worked on Chart of Account Creation, concurrent program, value set, lookups, and profiles setups.

Ensure documentation of defects during testing and document it as lesson learned to avoid in future enhancements.

Ensure Monitoring the Enhancements project as post production support and provide proper guide line to support the interface.

Conducting trial runs of programs and testing of software applications to be sure they will produce the desired information and that the instructions are correct.

Evaluating user requests for new or modified programs and compatibility with correct systems and computer capabilities. Recreating the steps taken by users to locate source of and correct problems.

Created Knowledge Article and Knowledge Transition Document for Support teams.

Project Description :

Michaels Stores has awarded TCS to manage their IT operations and Services that includes Application Development, Maintenance and Support. This Project is to provide support and Enhancements to the Oracle Financial system and Retail Sales Audit system. All the issues arise within the system are resolved with appropriate root-cause analysis, impact analysis, occurrence frequency analysis and temporary fix/permanent fix. The Project also involves works for the service requests from the business users.

Since December, 2008 to May, 2013 - Tata Consultancy Services

Client Name : Motorola Solutions.

Project : Networks Order To cash ERP for Motorola Solutions.

Position : Oracle Application Techo Functional Consultant.

Location : Chennai, India.

Environment : Oracle EBS 11i - OTC & P2P Modules (OM, PO, INV, AP, AR, PA)

Responsibilities :

Carried out the following activities

Provide Application Support for OTC and P2P modules primarily on (Oracle Purchasing, Order Management, Inventory) and moderately supported Accounts Receivable, Project Accounting, WIP...Etc.

Coordinating with Onsite Team in analyzing the incidents and provide fix for the reported issues.

Identify and fixing various Business Critical Issues and finding the Permanent solution. Requirement Analysis for Enhancements/Changes.

Provide Month-end, Quarter end and year end support for business inventory/financial close.

Conducted detailed and comprehensive Business Analysis by working with end users and other stake holders to identify the system, operational requirements, and proposed enhancements.

Resolving issues raised by customers using Remedy Request. Also coordinate with Oracle Support through Service Request (SR) for issues in Standard Functionality.

Created Business Requirement Documents and the Functional Documents.

Working on the Downtime activities.

Providing weekly status to the clients on the application related issues.

Data’s are loaded into interface table using Data Loader tool.

Performing Data fix and code fix to repair bug in the application.

Disaster Recovery in case of Power outrage.

Worked with the client team to understand the current Business Process.

Developed various custom PL\SQL programs for several business functions like Buy Sell Order cancellations, Promise Date calculation.

Conducted the Gap Analysis in order to understand the 'as-is' and the 'to-be' scenarios.

SQL/PLSQL Query Optimization for reporting & Dashboard.

Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements in Supply Chain Management Modules.

Project Description :

This project involves Development, Maintenance and Enhancement activities on order to cash cycle for GTSS sector in Motorola Solution – OASES ERP. The Oracle ERP system takes in orders from the various Motorola customers and processes the sales orders coming in with the oracle functionalities and then fulfills /ships the sales order to the customer and then invoices the customer for the fulfilled customer. The specific activities involved are Production Support, Project Planning, Project Management, Requirement analysis, Detail design and Implementation of development and enhancement requests, scheduling jobs in Productions, Applications Set-Ups, performance tuning, development of new interfaces.

Users will raise tickets using REMEDY and will get routed to the appropriate teams that support the relevant part of the application.

Personal Details

Date of Birth : 04-04-1985

Gender : Male

Nationality : Indian

Visa : H1B ( Until 31-JAN-2023 )

Designation : Assistant Consultant

Location : Irving- Dallas, Texas

DECLARATION

I hereby declare that the above information is true to the best of my knowledge.

Place: Dallas Signature

Date: (Janarthanan Pandurangan)

Contact this candidate