Priya Som

Email : acyxn1@r.postjobfree.com, 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).

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

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.

Prepared several Read me documents for users so that they don’t face issue especially during month end.

Groomed 3 other team members on Oracle Apps Technical skills and mentored them to help them achieve their technical objectives.

Led a few technical initiatives at offshore location (e.g. CCBT – Customer Centric Business Transformation and Knowledge Sharing Session Initiative).

End-to-End ERP Implementation

Project

JCI BE OA Implementation Offshore, Kolkata

Customer

Johnson Controls Inc.

Period

April 2011 to March 2012

Description

Offshore Oracle Apps Technical Leadership and Techno-functional Support

Led the technical development activities and provided extensive Offshore Technical support for the Oracle Apps modules, besides co-ordination with the Onsite Team.

Role

Technical Lead

Techno-functional Consultant for Purchasing Module

Solution Environment

Oracle Applications E-Business Suite R12

Oracle Reports(Purchasing)

Oracle XML Reports

SQL & PL/SQL

Oracle Discoverer Reports

Responsibilities

Techno-Functional Consultant for Oracle Apps Purchasing Module and Technical Consultant for HR/Purchasing modules.

Setup activities, Preparation of To-be Document, Gap Fit documents, BR100, FDDs and so on for purchasing module.

Setup and Maintenance of Collection Plans in Quality module.

Implementation of various customisations and developments including Oracle Reports, XML Reports, Oracle Alerts, Form Personalization for Oracle Purchasing, Oracle Finance and Oracle HR modules.

Data migration by implementation of data conversion and migration scripts for Purchasing module.

Extensively worked on P2P cycle both technically and functionally.

Onsite-offshore management and co-ordination with the onsite team to help resolve technical problems and meet project deadlines.

Development of a shell script for bulk movement of AOL objects across instances easily, without the need to write the commands for all objects.

Development of PL/SQL Procedures & packages, Interface programs.

Development of Complex Reports like Dunning Letters, Self Billing of Invoices and PO PDF Reports.

Testing and debugging custom components as well as seeded processes, Code and TDD review and documentation.

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

Responsible for Data Mapping from Legacy and Oracle environment.

End-to-End ERP Implementation and Support

Project

MAXAM Oracle development, Kolkata

Customer

MAXAM

Period

Nov-2010 to Mar-2011

Description

Offshore Oracle Apps Technical support

Provided extensive Offshore Technical support for the Oracle Apps modules and certain custom modules to the Client Organization which comprised various companies having different Instances each of Oracle Apps.

Role

Techno-functional Consultant

Solution Environment

Oracle Applications E-Business Suite (ERP)

Oracle Reports (Purchasing/Custom Modules)

Oracle XML Reports

SQL & PL/SQL

Oracle Discoverer Reports

Responsibilities

Techno-Functional Consultant for Oracle Apps Purchasing Module.

Implementation of various customisations and developments including XML Reports for Oracle Purchasing, Customer Relationship Management.

Data migration by implementation of data migration scripts for various custom modules in the purchasing apart from the seeded Oracle Modules.

Development of PL/SQL Procedures & packages, Interface programs.

Testing and debugging components, Code review and documentation.

Development and Management of a custom Module for Legal Tracking in the Client Organization.

MOF NTIS Offshore Implementation

Project

CITI Project Offshore Implementation

Customer

CITI Bank

Period

Aug-2010 to Oct-2010

Description

Offshore Oracle Apps Technical support to Ministry Of Finance (KSA).

Provided extensive Offshore Technical Implementation support to the onsite team for achieving the deadline for the planned GO-Live Date.

Role

Technical Consultant

Solution Environment

Oracle Applications E-Business Suite (ERP)

Oracle Reports (AP/AR/Public Sector Budgeting)

Oracle XML Reports

SQL & PL/SQL

Responsibilities

Implementation of extensive customisations and developments for Accounts Receivables, Public Sector Budgeting, General Ledger modules.

Successfully teamed up for the extensive development of more than 80 XML reports for different modules.

Appreciation received from onsite team for excellent offshore support.

Key Competencies and Skills

Skill

Proficiency (E0 to E4)

Oracle e-Business Suite (Functional): Oracle Finance Modules

E3

Oracle e-Business Suite (Functional): Oracle HR

E1

Oracle e-Business Suite (Technical): Oracle Reports 10g, XML Reports

E3

Oracle e-Business Suite (Technical): Form Personalization

E2

Oracle e-Business Suite (Technical): Discoverer Reports

E1

Oracle e-Business Suite (Technical): PLSQL

E3

OA Framework

E1

SQL

E3

Unix

E1

Career Profile

Dates

Organization

Role

10th March 2010 till date

TATA Consultancy Services

Oracle Technical Consultant

Training/Continuing Education Summary

Program or Course

Coverage

Dates

Project Training

Oracle Forms

Oracle Reports

Oracle E-Business Suite Overview

Form Personalization

Jun-2010

To

Aug-2010

ILP in TCS

Exhaustive training provided by TCS

Mar-2010 to May-2010

Personal Details

Date of Birth : 27-May-1986

Nationality : Indian

Passport Details

Name as on passport

Passport Number

Date of Issue

Expiry Date

Place of Issue

PRIYA SOM

J0093184

03-NOV-/2010

03-OCT-2020

KOLKATA

Contact this candidate