Project Oracle
Resume:
Aanchal Dhingra
Oracle E- Business Suites – Techno Functional Consultant
Phone +91-956******* Email – *******.********@*****.***
Professional Summary :
Aanchal is having 3 years of experience in Oracle R12 as an Technical consultant
Expertise on RICEFW (Reports, Interfaces, Conversions, API’s, Concurrent Program API’s. )
Extensive exposure on oracle applications modules like Account Payables, General Ledger and
Working knowledge on Project Accounting and Account Receivables.
Good Leadership skills, excellent communication and interpersonal skills
Versatile team player with ability to help team along with excellent problem solving skills, to provide
quality deliverables within deadlines.
Proven ability to work efficiently in both independent and team work environments
Work Profile:
Team member in Implementation rollout of Oracle Applications Financials suite of products.
Hands-on expertise in tools like SQL*Plus, PL/SQL, XML Reports, Interfaces, SQL * Loader.
Well versed with Multi Org concept of Oracle Application.
Good Experience in writing AIM documents MD-200, BR-110 etc
Expert in designing Data Conversion Programs from Legacy Systems to Oracle Applications.
Worked extensively on Oracle 10g, SQL, PL/SQL, 6i/4.5, Reports 6i, SQL*Loader.
Certifications:
• Six Sigma – Green Belt Certified. (Apr 2012)
• Oracle 11g – Oracle Certified Associate Level 1Certified. (Mar 2012)
• Oracle EBS R12: E-Business Essentials. (Jul 2012)
• Oracle EBS 12:Oracle General Ledger.(Jun 2013)
• Oracle EBS 12:Oracle Payables.(Jun 2013)
Technical Skill Profile:
• Developmen PL/SQL Developer, Oracle, SQL*Loader 8, Report Builder HP Service
Desk, Quality Centre 10.0, Appworx
t Tools
Oracle 10g, Oracle Apps 11i [11.5.10 Ver.],Oracle Alerts, Oracle
• Database
Workflows
• Oracle EBS
Account Payables, Project Accounting, General Ledger
Modules
Education:
B. Tech (Bachelor of Technology) - KURUKSHETRA UNIVERSITY (Haryana) Year
2010
AISSCE (Class XII) CBSE board with 81.8% Year2006
<Aanchal Dhingra > Page 1
Work Experience:
System Engineer from Dec-2010 to Till Date
Project Experience:
System Engineer from Mar-2010 to Till Date
Project 1: AMEX OASIS Oct-13 to Till Date
Client: American Express, USA
Role: Functional Finance Test Analyst
Major Modules: Account Payables
Responsibilities include:
Representing team on client location.
o
Responsible to test Custom Interfaces and Reports.
o
Responsible to create Test scenarios.
o
Preparing Test Strategy.
o
Resolving CR’s related to Finance AP area. Preparing CF250’s for the CR’s resolved.
o
Responsible to log defects in QC.
o
Project 2: GE Transportation Oracle ERP Support Jan-12 to Sep-
13
Client: GE Infra, USA
Achievements in project: - BEST Team Award
Role: Finance Support Analyst
Major Modules: Account Payables, General Ledger and Account Receivables
Responsibilities include:
Responsible to provide support and Enhancement/up gradation for GE transportation USA
o
Resolved Issues on custom Interfaces and Reports.
o
Direct Interaction with client on problem tickets.
o
Resolving GMR’s related to Finance area. Preparing CF250’s for the GMR’s resolved.
o
Monitoring the Appworx - OLTP & ASCP run. Nightly process support.
o
Raising SR with vendor Oracle for production issues.
o
Provide application support as per application specific SLA for Responsiveness, Resolution
o
Handling enhancement requests raised by users in Finance module- Custom Interfaces and
o
functionalities.
Worked on development of Alerts for GL Interface Errors.
o
Reports Worked on;
o
o AP Trial Balance Report
o Invoice Aging Report
o RXi: Asset Details Extract
Worked on issues related to below interfaces:-
o
o Journal Import
o PRC: Interface Revenue to General Ledger
<Aanchal Dhingra > Page 2
Project 3: GEPS Enhancements ND V May-11 to Dec-11
Client: GE Infra, USA
GE Energy is one of the world's leading suppliers of power generation and energy delivery
technologies in all areas of the energy industry including coal, oil, natural gas and nuclear energy as well
with renewable sources such as water, wind, solar and alternative fuels.
Role: Developer
Major Modules: Project Accounting and General Ledger
Responsibilities include:
o Key person in team, involved in development of new RICE objects and also giving
production support for the existing modules.
o Interface Designed and Developed
o Payroll Interface Development to load Payrolls to Oracle GL.
o PIT Interface to send the requested data elements (time card and location) to PIT
CoE system.
o Reports
o Developed XML reports in Financials like Reconciliation Report, Preview
Report and Custom DFF Report.
o Involved in analyzing business requirements as per the functional documents
CF250 and translating functional document into technical document MD200.
o Registration of Executables, Concurrent programs, Value Sets.
o Involved in analyzing business requirements as per the functional documents CF250 and
translating functional document into technical document MD200.
o Registration of Executables, Concurrent programs, Value Sets.
o Involved in post implementation support and user training.
o Closely worked with users and resolved day-to-day requests and problems.
o Involved in unit testing, system testing, reviewing and defect tracking of interfaces and
reports.
o Documented all the work done for future reference. Also created various reference
documents for support team.
o Responsible for Performance Tuning, Optimizing SQL and PL/SQL scripts.
o Designed, developed, and tested Oracle PL/SQL packages, stored procedures,
o Functions, triggers and design/development of new tables and reports.
o Developed Integration Development Framework module to send notifications to users in
case of any errors using UTIL File utility.
o Wrote Sql Loader Control files to transfer the data from flat files staging tables.
o Created ldt files to move Concurrent Programs from one instance to another
Project 4: Sabrix Implementation Support Project Mar-11 to Apr-11
Client: Taxaccord, LA
The project was about Sabrix which a tax engine used by GE to calculate tax/VAT for the
transactions carried out by the company. It required implementation of Sabrix in various businesses as
and when specified by GE and then after take care of the production issues.
Role: Analyst
Major Modules: Account Payables and Account Receivables
Responsibilities include:
<Aanchal Dhingra > Page 3
Resolving Production Issues rose in Support Central and HPSD.
o
Initial Learning Program (ILP)
Dec 2010-Mar2011
Completed training in Oracle Apps together with Software Engineering in TCS Haldia.
Contact Details:
Cell Phone: +91-956**-*****
Email: *******.********@*****.***
<Aanchal Dhingra > Page 4
Contact this candidate