SUPRIYA ARORAMobile: +91-8510913300

Email: supriyaarora2386@gmail.com

OBJECTIVETo pursue a long term career in design, development, testing and support of ERP applications. To succeed in an environment of growth and excellence where my skills, aptitude and proficiency will allow me the opportunity for contributing in the growth and development of the organization.

PROFESSIONAL SUMMARY

• 6 years 10 months of experience as Oracle Applications Technical Developer in development, implementation, upgrade and support of Oracle e-Business Suite Applications (11i, R12).

• Experience in Order to cash (O2C), Procure to Pay (P2P) life cycles and Supply Chain business flows.

• Experience working on AOL (Application Object Library) components. • Developed value sets, lookups and concurrent programs and attaching them to the

responsibilities.• Experience in developing technical design document.• Good understanding of application design, technical documentation, development, upgradation,

support and unit testing of modules in Oracle Applications Supply Chain Management domain like Order Management (OM), Inventory (INV).

• Up gradation of RICEFW components like Interfaces and Forms from 11i to R12.• Worked on Forms and XML Publisher reports.• Excellent analytical, communication and client relationship management skills.• Strong team player and ability to learn new technologies.

EMPLOYMENT HISTORY

• Working as an Oracle Applications Technical Consultant with IBM India Pvt. Ltd., Noida since June 2012.

• Worked as an Oracle Applications Developer with Accenture Services Pvt. Ltd., Bangalore for 3 years from August 2009 till June 2012 in areas of development, unit testing, implementation, upgradation and support of applications.

• Worked as a Lecturer with Lovely Professional University, Punjab for 7 months from January 2009 till August 2009.

TECHNICAL SKILL SET

Database: Oracle 9i/10gDatabase Languages: SQL,PL/SQLERP: Oracle SCM : Inventory (INV) and Order Management (OM)Operating System: WindowsTools: TOAD, PL/SQL Developer, SQL * PLUS, Clear Case, Kintana, PVCS, Star

Team

PROFESSIONAL EXPEREINCE

Project #1Project Name Oracle LeapClient APPLIED MATERIALSRole Oracle Applications DeveloperDuration May 2014-PresentEnvironment Oracle Applications 11iLocation Noida

Project Details:Applied Materials, Inc is the global leader in nano manufacturing technology solutions with a broad portfolio of innovative service and software product for the fabrication of semiconductor chips, flat panel displays, flexible electronics and energy efficient glass.

IBM supports Applied Materials by providing the technical/functional consulting in different areas in terms of technology. In Applied Materials project, IBM is providing support on ERP(Oracle Apps related modules SCM, manufacturing and finance technical/functional support with RICE component, sql/plsql). The purpose of this project is to provide 24*7 production support.

Responsibilities:1) Working as an Oracle Application developer responsible for resolving various production issues

of users.2) Involved in the analysis of the assigned support tickets including replicating the issue in lower

instances, analyzing the issue and updating the ticket with the appropriate information.3) Updating the Service Now (SNOW) tool with ticket updates.4) Participated in the weekly meetings to discuss the long pending tickets and any other

issues/concerns.5) Perform Unit Testing and assisting the user in testing and closing the tickets.6) Closely worked with users to understand business needs and objectives.7) Creating ACR for datafix.8) Resolved Opportunity Sales Management related issues being part of the OSM team.

Project #2Project Name ERP AnalyticsClient BHARTI AIRTELRole Oracle PL/SQL DeveloperDuration Aug 2012- Sep 2013Location Client location, Gurgaon

Project Details:

Bharti Airtel Limited is a leading global telecommunications company with operations in 20 countries across Asia and Africa. PPSC is Partner Performance Score Card. Several KPI’s have been designed to measure the performance of the partners of Bharti Airtel.

Responsibilities:• Modifying the Oracle queries according to the business requirement and extracted the

corresponding output.

Project#3Project Name Fuji XeroxClient FUJI XEROXRole Developer - Oracle ApplicationsDuration Mar 2012-Jun 2012Environment Oracle Applications 11i, Oracle Applications R12Location Bangalore

Project Details:Fuji Xerox is a part of Cross Industry entity in OSF (Oracle Solution Factory).Fuji Xerox is an up gradation project and involves up gradation of RICEFW components from 11i to R12.

Responsibilities:• Up gradation of RICEFW components like Interfaces and Forms from 11i to R12.• Preparing the technical document which describes the technical changes made to the

components, the execution steps and the concurrent program details for objects.• Doing the testing and preparing the Unit Test Document (UTD) detailing the unit test cases, the

test results including the log file and the output file and UTD checklist.• Following the project specific templates and checklists.• Learnt and used the tool: Clear Case which acts as a code repository and supports the version

control for all DB objects.• Mentoring the newly joined ASE’s in the project.

Project#4Project Name Oracle RenewClient PEPSICORole Developer - Oracle ApplicationsEnvironment Oracle Applications 11i, Oracle Applications R12Duration Aug 2011-Feb 2012Location Bangalore

Project Details:PepsiCo is a part of CGS (Consumer Goods and Services) entity.Oracle Renew is an up gradation project and involves up gradation of RICEFW components from 11i to R12.

Responsibilities:• Up gradation of RICEFW components like Interfaces, Forms and Reports from 11i to R12.• Preparing the data sheet which describes the technical changes made to the components, the

database and AOL objects used, the concurrent program details, the test results including the log file and the output file.

• Preparing the database object’s scripts and executing them in R12.• Doing the sanity testing of the components migrated from 11i to R12 and fixing any issues

encountered.• Support of the custom components upgraded to R12.• Involved in Design Reviews, Code Reviews, Coding, and Testing.• Generating the ldt’s for the concurrent programs.• Learnt and used the tool: Star Team which acts as a code repository and supports the version

control for all DB objects. Tagging the components to RICEF and AT (Assembly Testing) label for its migration to the AT environment.

• Fixing any AT migration issues and defects on priority and updating the status in Star Team.• Fixing the defects and working on Build Fixes and testing it.

Project#5Project Name Cisco – Consumer ITClient CISCORole Developer - Oracle ApplicationsModules Handled SCM : Order Management

FINANCE : Account ReceivablesEnvironment Oracle Applications 11iDuration Jan 2011-July 2011Location Offshore, Bangalore

Project Details:Cisco is a part of CHT (Communication and Hi-Tech) entity.Cisco – Consumer IT is an enhancement project and uses Oracle EBS 11i.

Responsibilities:• Development of the Revenue Recognition project in the FINANCE domain.• Doing the build for revenue recognition project which involved incorporating the RDL i.e

Revenue Decision Logic, POS (Point Of Sale), processing standard margin data.• Preparing the test data and Unit Test Plan and executing it.• Gathering the requirements from the business user and interacting with the client.• Analysis of the specifications provided by the client and documenting the requirements.• Preparing the technical design document (TDD).• Worked on basic XML Publisher reports.• Coordinating with the team in meetings for the status and deadlines of the deliverables.• Unit testing of the components developed.• Giving KT to new joiners in the project.

• Support and enhancement for Oracle E-Business Suite and custom components build around the E-Business Suite.

• Reporting the status to the team lead and onsite manager in weekly status call and also discussing any issues/concerns.

Project#6Project Name Motorola – Mobile Devices Business

TransformationClient MOTOROLARole Developer – Oracle ApplicationsModules Handled SCM: InventoryEnvironment Oracle Applications R12Duration Dec 2009 – Dec 2010Location Offshore, Bangalore

Project Details:Motorola is a part of the CHT (Communication and Hi-Tech) entity.Motorola successfully completed full life cycle implementation using Oracle EBS R12.

Responsibilities:• Understanding requirements from the client and analysis of the specifications/requirements

provided by the client.• Understanding the process flows, analyzing the issues and providing the solution within time

commitments.• Developed an interface component on RMA (Return Material Authorization) Receipts and Direct

Shipment.• Designed and executed unit test cases, test scripts and unit test plans.• Prepared test data and tested the component in different environments: DEV, TEST, PROD and

UAT. Successfully completed Unit testing.• Had direct interaction with client while code review and incorporated client review comments in

my code.• Conducted User Acceptance Testing, go-live and post production support.• Prepared all the build phase deliverables: Installation Guide, Unit Test Plan, Relational

Traceability Matrix(RTM), Updated the Technical Design Document so that the TD and code were in sync with each other and ensured that all the deliverables were completed on time.

• Involved in defect fixing team and fixed the defects in my component as well as other components also.

• Used Clear Case tool for version control and helped my team members in understanding the use of the tool.

• Learnt and used Kintana tool to check in codes and for migration of all the scripts, packages and associated deliverables to other instances.

• Entered all the issues faced in the build issue log template.• Communicated status of deliverables to Team Lead on a regular basis and had status calls with

onsite people as well.• Gave KT to support team (TCS team) of components for providing maintenance support.

• Conducted peer review to check the coding standards.• Worked on the Change Requests.• Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System

Administration.

AWARDS RECEIVED

Received Accenture’s Celebrates Excellence (ACE) Team award for successful implementation of the project.

Received Star of the Month award.

EDUCATIONAL QUALIFICATION

B.Tech in Electronics and Communication Engineering from Rayat Institute Of Engineering and Information Technology affiliated to Punjab Technical University in July 2008 with 75%.

12th from HMV College from Punjab School Education board with 77%. 10th from St. Joseph’s Convent School from ICSE board with 82.5%.

Personal Details

Name Supriya AroraFather’s Name Sh. Bhushan AroraDate of Birth 23-March-1986Nationality IndianPassport Available Yes