Technical Support Oracle

Location:

Charlotte, NC

Posted:

February 21, 2017

Contact this candidate

Resume:

Priya Som

Email : ********.*******@*******.***, Phone : 412-***-****

Experience Summary

I am associated with Prabhav Services Inc. and had total work experience of 7 years. Previously I was associated with Tata Consultancy Services Ltd for the last 6.5 years. My technological forte is Oracle Applications E-Business Suite. I have worked as a Technical Lead as well as Techno-Functional consultant in Oracle Applications in Payables, Receivables, Purchasing, Costing and HR modules. My functional core competency lies in Finance modules i.e. Oracle Payables, Costing, Receivables and Purchasing Modules; whereas my technical core competency is on PL/SQL in addition to Oracle reports, XML Reports, Discoverer Reports, APIs and Open Interfaces for all major Oracle Apps modules.

Task Performed

Over 6.5 years of extensive experience as Oracle Application Technical Developer in implementation, upgrade and customization of Oracle e-Business Suite Applications (R12 and 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.

Extensively Worked on Oracle apps 11i and R12.

Extensive experience in Implementation, Migration, Customization, Production and support of various modules in Oracle Applications with major focus in HR Modules Accounts Payables(AP), Accounts Receivable(AR), Costing and Purchasing(PO).

Have hands on Conversions, Interfaces (Finance and Supply Chain Management), Reports (D2K 10G), XML Publisher (v5.6.2), Discoverer (10g), UNIX Shell Script, Technical Specifications.

Technically proficient in RICE Components (Reports, interfaces, Conversions and Extensions).

Experience in Procure to Pay (P2P) life cycle.

Proficient in development of Interfaces and Conversion Programs to integrate Oracle applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL* Loader.

Experience in importing data from Legacy System to Oracle Applications using Oracle Interfaces, SQL Loader, UTL_FILE, Oracle APIs and Open Import Programs etc.

Strong Knowledge of Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).

Expertise on designing and implementing Oracle Alerts and Lookup.

Experienced in Customizing Oracle Forms with Form Personalization.

Extensively used TCA (Trading Community Architecture) to create customers in AR.

Well versed with client server environment and tools like SQL*Plus, PL/SQL, QL*Loader, TOAD, Oracle*Reports and modified the formats using XML Publisher for customizations as per client specifications.

Registered Concurrent Program and Request Groups for Reports.

Expertise in Requirement gathering, Requirement Analysis, System Design, Data Flow Designs, Support, Development, Testing, Documentation and Design Reviews.

Expert in developing Technical Design Documents (MD70), Technical Test Documents (TE120), Conversion (CV50) and Migration Documents (MD120).

Strong in Performance Tuning using Tools like EXPLAIN PLAN, SQL TRACE, TLPROF, HINTS.

Worked on India Localization Reports and Tax Calculation Reports.

Troubleshoot issues including creation/follow-up of Oracle Service Requests (SR).

Have hands on experience of user defined errors by developing Error-Handling package using PL/SQL.

Interacted with Users, fixed the bugs, developed Test Plans and provided daily Production Support using tools like HP Quality Centre and BMC Remedy Tool.

Excellent in Team Collaboration, Quick adaption and problem solving ability with Good Communication Skills

Technology

Certifications:

Oracle Certified Associate (OCA) in Developers Track

Hardware:

HP Server with OS as UNIX and windows server

Software Products:

Oracle Apps e-Business Suite, C, C++, Java(Core), Developer/2000 Forms & Reports, Oracle Developer Suite 10g, SQL & PL/SQL, HTML, Microsoft Visual Studio IDE

Tools:

Oracle Report Builder- Oracle Developer Suite 10g, Oracle Discoverer: Administrator and Desktop, PL/SQL Developer, SQL Developer, Win CVS, HP Kintana, Dimension Express, HP Quality Centre, BMC Remedy Tool, Jdeveloper, Jmeter

Training:

Project Training (Oracle Forms, Reports, E-business Suite), Initial Learning Phase(TCS)

Qualifications

Bachelor of Technology [Biotechnology], Haldia Institute of Technology, West Bengal, India.

(August 2005 – June 2009)

Assignments

End-to-End ERP Implementation

Project

SMART Transformation (Implementation and Onsite Support)

Customer

Ingersoll Rand

Period

Jan 2016 till Nov 2016

Location

Charlotte, USA

Description

Onsite Oracle Apps Technical Implementation and Support (Finance Tower)

Performed the technical development activities and provided extensive Onsite Technical support for Finance and Purchasing modules (Payables, Receivables, Costing, General Ledger and Purchasing Modules).

Role

Technical Consultant for Finance modules

Solution Environment

Oracle Applications E-Business Suite R12

Oracle Reports (Payables/ Receivables/ Costing, General Ledger)

Oracle XML Publisher Reports

SQL & PL/SQL

Form Personalization

Performance Tuning

Responsibilities

Technical Consultant for Finance modules (Oracle Apps Payables/ Receivables/ Costing/ General Ledger).

Preparation and Maintenance of Technical Design Documents (MD070, TE020, Check scripts), as well as code review for various RICE components.

Implementation of various customisations and developments including XML Reports, Form Personalization, Interfaces (Internal as well as with partner systems) for Finance modules.

Supported various existing custom workflows, billing extensions, inbound as well as outbound third party interfaces.

Worked on Language Translations (Xliff files), bursting, form personalisation.

Developed Custom Reports using complex Queries as per client request as a part of Production Support.

Worked on various India Localization Reports and Tax Calculation Reports.

Worked extensively on Conversion Programs and Conversion Tool.

Developed Conversion programs to load AP Invoice, AR Invoices and Items data from legacy System to Oracle Applications using APIs.

Also, wrote validation Procedures to validate the data before migration.

Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.

Coded PL/SQL Packages and Procedures to perform Data Loading, Error Handling and Logging.

Performed SQL Tuning using Explain Plan, Tkprof, Hints and Indexes.

Analyse SQL statements, Reorganize Database Objects and Design Indexes to Improve Response of Queries.

Developed Oracle Alerts to show whether the period is open or closed during month end process to minimise P2 Tickets.

Developed various custom programs to extract Payment related data during month end to fasten the process of Reconciliation and validation.

Responsible for delivery of objects on time and sometimes ahead of schedule.

Interacted with Users, fixed the bugs, developed Test Plans and provided daily Production Support.

As Technical Developer worked through all Software Development Lifecycle (SDLC) process.

End-to-End ERP Implementation

Project

SMART Transformation (Implementation and Offshore Support)

Customer

Ingersoll Rand

Period

April 2012 till Dec 2015

Description

Offshore Oracle Apps Technical Implementation and Support (Finance Tower)

Performed the technical development activities and provided extensive Offshore Technical support for Finance and Purchasing modules (Payables, Receivables, Costing, General Ledger and Purchasing Modules).