Mathangi Chandrasekar
Phone No: +91 9789994313 Email:
Experience Summary:
· Over 6.5 years of extensive working experience as an Oracle Application Consultant with good command over TECHNO-FUNCTIONAL aspects including implementation, Customization, Conversion Interface and Production Support works in Oracle Applications11i.
· Worked extensively on AOL, Financial Modules like Oracle Financial- General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Core HRMS,SCM modules (Order Management and Purchase Order) in Multi Org, Multi Currency environment.
· Experience in the area of analysis, design, development, testing, implementation and Production Support of complex Servers with applications using Oracle Applications (Financials and Manufacturing) 11i.
· Extensive Experience in the Analysis, development and maintenance of business applications using Oracle AIM and RICE methodology.
· Expertise in Developing and Supporting both Production and Development Systems.
· Excellent interpersonal skills, ability to interact with people at all levels good communication and presentation skills.
· Great learning skills to adapt the rapid changing technologies and implementing the same at work.
Domain expertise: Retail, Banking and Finance.
Technical Expertise:
Technology / ToolsPackages / Oracle Application 11i and R12
Databases / Oracle 8i, Oracle 9i, Oracle 10g
Development/Productivity Tools / PL/SQL Developer, SQL*Plus, TOAD
GUI / Oracle Forms 6i, Oracle Reports 6i, Oracle BI Publisher
ERP Tools / Accounts Receivables(AR), General Ledger(GL), Accounts Payables(AP), Order Management (OM), Oracle Purchasing(PO), Oracle Projects (PO), Oracle procurement (iProc)
Functional Areas / Retail, Banking and finance
Programming Languages / SQL,PL/SQL, Java
Verticals / Retail, Banking and Finance, Travel
Project Details:
1. British Airways plc
Description / British Airways plc (BA) is the flag carrier airline of the United Kingdom and it is the largest airline in the UKRole / Techno- functional Consultant
Operating System(s) / Linux
Tools / SQL developer, SQL * Plus, HRMS, Putty, Wincvs, Forms 6i, Reports 6i,workflow
Environment / Oracle Application 11.5.10
Contribution / 1. Analyzing and Preparing complete High Level and Detail Level Design documents for the Custom components.
2. Involved in Coding and Unit testing of the Custom components like PL\SQL packages, D2K forms and Reports,
3. Preparing Test cases, test plans documents and executing the test cases.
4. Preparing Installation and Migration Scripts for the migration of the custom components to other instance as well as Production environment.
5. Executing a Root Cause analysis of Issues reported by the End users and necessary measures to correct the same.
6. Version controlling using the version control tool called as Wincvs.
7. Mentoring and reviewing their Deliverables done by team members of 4 on all the above-mentioned activities.
8. Customizing workflows based on clients needs
Start Date / 21/05/2010
End Date / Till Date
Period / 10 Months
Team Size / 4
2. Master Card – Fin Apps
Description / Master card is a well-known leading Banker’s net. Master card Worldwide operates out of various countries thought the Globe.Role / Technical Consultant
Operating System(s) / Sun Solaris
Tools / TOAD, SQL * Plus, XML Publisher, Purchasing, Payables, MS – Word, PVCS, Forms 6i, Reports 6i
Environment / Oracle Application 11.5.10
Contribution / 1. Analyzing and Preparing complete High Level and Detail Level Design documents for the Custom components.
2. Involved in Coding and Unit testing of the Custom components like PL\SQL packages, D2K forms and Reports, XML Reports, Interfaces etc.
3. Preparing Test cases, test plans documents and executing the test cases.
4. Preparing Installation and Migration Scripts for the migration of the custom components to other instance as well as Production environment.
5. Executing a Root Cause analysis of Issues reported by the End users and necessary measures to correct the same.
6. Version controlling using the version control tool called as PVCS.
7. Mentoring and reviewing their Deliverables done by team members of 4 on all the above-mentioned activities.
Start Date / 15/08/2009
End Date / 15/05/2010
Period / 10 Months
Team Size / 8
3. Morrison’s – Fin P2
Description / Wm Morrison Supermarkets plc is the fourth largest chain of supermarkets in the United Kingdom. The company is usually referred to and is branded as Morrison’s, and it is part of the FTSE 100 Index of companiesRole / Technical Consultant
Operating System(s) / Unix
Skills / SQL Developer, SQL * Plus, XML Publisher, Purchasing, Payables
Environment / Oracle Application R 12.0.4
Contribution / 1. Involved in Writing Technical Design Documents for Custom Reports Based on the Requirements that are captured in the Functional Design Documents.
2. Developed Complex Reports using BI Publisher in R12
3. Personalizing few pages as per the requirement of the Clients.
4. Defining alerts.
5. Preparing completes Deliverable for the Developed components so as to facilitate the movement to other environments.
Start Date / 08/03/2009
End Date / 07/08/2009
Period / 5 Months
Team Size / 10
Other Information / Have developed a complex Audit Details report, which is used for supplier auditing. This Report is based on the Audit trail functionality.
4. Oracle Application AP Project (J.C. Penney)
Description / J. C. Penney Corporation, Inc., the wholly owned operating subsidiary of J. C. Penney Company, Inc., is one of America’s largest department store, catalogue, and e-commerce retailers, employing approximately 151,000 associates. In J. C. Penney Corporation, Inc. operated 1,037 JCPenney department stores throughout the United States and Puerto Rico. JCPenney is the nation’s largest catalogue merchant of general merchandise, and jcp.com is one of the largest apparel and home furnishings sites on the Internet. JCPenney refers to the Internet/catalogue business As Direct. JCPenney intends to replace its Oracle Apps and Mainframe based Demand and Forecasting system with MANUGISTICS – a New supply Chain management application with advance demand and forecasting features which are not available in existing system. It is required for JCPenney to Migrate data from existing legacy system to the new Manugistics application to generate forecasts. The generated forecast data needs to be supplied to the legacy system, which would be used for their reorder of items.Role / Technical Consultant
Operating System(s) / Unix
Tools / Oracle 9i, MS Office, Oracle Forms 6i, Oracle Reports 6i, PL/SQL Developer, SQL*Plus, TOAD
Environment / Oracle Application 11.5.10
Contribution / 1. Modified many Packages in order to add new functionality and to change the existing functionality.
2. Has developed a complex Oracle form with tab pages. Has developed a SQL report for the above-mentioned form and implemented the functionality of tracking the users and the data modified. Has developed a concurrent program, which loads data from the data file into the base table based on certain validations. Worked on many interface programs, which loads data into the main tables. Created many Procedures in order to meet the requirements in an efficient manner. Worked in data tracking when there is some crash in the system and successfully retrieved those missing receipt records and other records, which were having issues. Have done many enhancements for upgrading from Oracle Apps 11.5.9 to 11.5.10
Start Date / 20/08/2007
End Date / 04/12/2008
Period / 21 Months
Team Size / 12
Other Information / Got many appreciations from the Client
5. Getty Images Upgrade
Description / Getty images a leading online imagery seller based in Seattle. Involved in Upgrade of Oracle Applications from 11.5. 7 to 11.5.10Role / Techno- Functional Consultant
Operating System(s) / Sun Solaris
Skills / Oracle 9i,Oracle Forms 6i,Oracle Reports 6i,PL/SQL
Environment / Oracle Applications 11.5.10
Contribution / 1. Involved in Preparing Test Cases documents for various modules like AP, AR, iprocurement, INV.
2. Clients had various custom reports, which were not working properly after upgrading to 11.5.10 was involved in modifying the reports and making them suitable to work in the upgraded instance.
3. Involved in preparing documents called “Train the Trainer” which were used to highlight the new features of 11.5.10
Start Date / 12/10/2006
End Date / 13/01/2007
Period / 3 Months
Team Size / 10
Other Information / Was working in production support and upgrade simultaneously.
6.Getty Images Production Support
Description / Getty images a leading online imagery seller based in Seattle.Role / Techno- Functional Consultant
Operating System(s) / Sun Solaris
Skills / Oracle 9i,Oracle Forms 6i,Oracle Reports 6i,PL/SQL
Environment / Oracle Applications 11.5.10 and 11.5.7
Contribution / 1. Supporting the Customers who are facing issues in various modules viz., AP, AR, GL, PO, OM/Shipping, CM, FA, INV.
2. Solving the tickets that have been created by the Customers. 3. Performing the monitoring activity there by fix the issues on the Interfaces (Invoice Interface, Item interface, payment interface)
3. Preparing solution document and guiding the Customer to follow in order to fix the issue.
4. Communicating with the end user through e-mail for various issues to get more clarity and give clear picture of the issue.
5. Have taken various initiatives to provide value additions to the Clients to reduce the number of tickets logged in a month. These initiatives includes documenting the solutions for most often repeated issues and uploading them in a shared location that is accessible to all the users, This document served as a guide for the users in various occasions and have greatly reduced the amount of tickets.
6. Created various process documents on direct debit and Auto Lock boxes that served as a ready reference for the end users on while running the same.
7. Developed as Form that could help in updating a custom table that served as a basis for various Multi lingual reports
Start Date / 27/01/2005
End Date / 19/8/2007
Period / 31 Months
Team Size / 6
Other Information / Have handled support for APEX, UK and Australia single handed. Have received various appreciations from the clients on effective support.
Educational Qualification
Degree/Qualification / Year / Institution NameM.S. Software Engineering / 2004 – 2008 / Birla Institute of Technology and Science, Rajasthan
B. Sc. Computer Science / 2001 – 2004 / Prince Venkateswara, Madras University
Employment History
Company Name / Designation / Start date – End dateWipro Technologies / Student Computer Application / Sep 2004 to Nov 2008
Wipro Technologies / Sr. Project Engineer / Dec 2008 to May 2010
Tata Consultancy Services / IT Analyst / May2010 to till date
Personal Details
Father’s Name: Mr P. Chandrasekar
Marital Status: Married
Date of Birth: 10th Sep 1984
Passport No: G1792310
Languages Known: English, Tamil, and Hindi
Permanent Address: No.1, Ramalinga Adigal st, Periyar Nagar,
Pallikaranai, Chennai – 600100.
Date : Yours Sincerely,
Place :
(C.Mathangi)