Chandra Shekhar Jha

Email: azvweq@r.postjobfree.com, Phone: +971-(50)-3548434

Experience Summary

More than 7 Years of Professional IT Experience in Project Management,Leadership, Requirement gathering and mapping it to System Design, Development, Product Customization and Implementation, Training, Testing, Debugging and Maintenance of Oracle e-Business Suite applications. I have worked for clients in 4 different regions including USA, South Africa and UAE (Currently).

Have vast experience of following Domain areas:

• Telecom – Modules like Sales & Marketing Online, Teleservices, Contact Centre Solutions and Customer Lifecycle Management for clients like Vodafone, VSNL, Neotel(South Africa).

• Media and Entertainment – Order Management module with Supply Chain life cycle management for Warner Bros studios.

• Banking – Oracle eBusiness Suite implementation and integration with Core banking and other Bank interface systems for EmiratesNBD. Modules like Oracle GL and Account Payables.

• Property Management – Oracle Property Manager Implementation along with integration with GL and Account payable modules for emirates NBD and Emirates Islamic Bank.

Employment History

Company Name Date Location

Esquire Sytems 09-May-2010 Till date Dubai, UAE

Futech Software Solutions (Al-Futtaim Group) 20-Apr-2008 to 18-Apr-2010 Dubai, UAE

Tata Consultancy Services Ltd. 01-Jul-2004 to 17-Apr-2008 Mumbai(India), Los Angeles (USA), Cape Town(South Africa)

Key Competencies & Skills

My Competency Profile includes the following

Skill Set Proficiency (Scale Of 1-5 with 5 being highest)

Oracle eBusiness Suite - Product Customization (Technical) 5

Oracle Forms and Reports 10g 5

Oracle Discoverer 10g 5

Oracle BI Publisher(Formerly XML Publisher) 4

OA Frameworks (Oracle JDeveloper) 4

Oracle CRM Module (Functional And Technical) 5

Oracle General Ledger Module (Functional And Technical) 4

Oracle Account Payable Module (Functional And Technical) 4

Oracle Sales and Marketing Modules (Functional And Technical) 4

IBM Rational Functional And Performance Tester Version 8.1 4

PL/SQL 5

Oracle Workflows 4

MS Project 2007 4

JSP 3

Unix Shell Scripting 4

Solution Environment And Tools Used

Solution Environments Tools

• Oracle E-Business Suite(12.0.4)

• Oracle E-Business Suite(11.5.10.2)

• Oracle 10g Release 2(10.2.0.4)

• Oracle 9i Release 2(9.2.0.7)

• Oracle 10g Developer Suite

• Sun Fire M9000 Server

• Sun Microsystems OS 5.10 • Oracle Forms and Reports 10g,6i

• Oracle JDeveloper 10g

• Oracle BI Publisher (Formerly XML Publisher)

• Oracle Discoverer 10g

• IBM Rational Functional And Performance Tester 8.1

• SQL*Plus

• MS Access 2007

• TOAD 9.0.0.160 (Tools For Oracle Application Developers)

• PL/SQL Developer

• MS Visual Source Safe

• Unix Shell Scripts

• Oracle Workflow Builder 2.6

• MS Project 2007

Qualification

Degree and Date Institute Major and Specialization

Bachelor Of Engineering, June 2004 Birla Institute Of Technology, Mesra, Ranchi Electrical & Electronics Engineering (Ist Class)

Assignments

The details of the various assignments that I have handled are listed here, in chronological order.

Project Logical Security Online Workflow System (Identity Management Solution)

Customer Emirates NBD

Period 01-Sep-2011 to till date

Location Dubai, UAE

Role Project Manager

Project Description Emirates NBD Bank required a workflow system to cater to their daily activities of the Logical security unit. Objective of the proposed initiative was to implement an integrated software solution managing all User ID Creation/Deletion, Password resets, Enable/Disable User IDs in all the bank systems. The online workflow System will integrate with maximum possible bank systems allowing automated actions.

Implementation of this software reduced administrative overheads and manual processes, thereby reducing costs, ensure fast and error-free transaction processing and provide accurate and timely MIS information. This was developed in an eBusiness Suite Platform using OA Framework, Oracle workflow, AME, BI Publisher and Discoverer reports capabilities.

Responsibilities 1. Business Requirement gathering and prepared functional specifications (MD-50) along with prototype screen designs.

2. Created Project Plan and prepared the work breakdown structure of the team.

3. Weekly tracking of the project status and notifying the project stakeholders about the same.

4. Technical design of the application along with the ER diagram and process flow diagrams for the screens.

5. Development of Workflow and AME.

6. Development of interface with Core Banking (Finacle), Loan Management (FinOne), Active Directory etc. systems.

7. Development of reports in BI Publisher and Oracle discoverer.

8. Developed more than 20 reports using Oracle BI publisher (formerly XML publisher).

9. Development of Alerts.

10. Preparation of UAT scripts and co-ordinate the UAT.

11. Performed Functional and Stress testing of all the modules using IBM Rational functional and Performance tester tool.

12. User Training during both pre go-live and post go-live.

Project Oracle Property Management Solution

Customer Emirates Islamic Bank, Emirates NBD Bank

Period 01-May-2010 to till date

Location Dubai, UAE

Role Technical Lead

Project Description Emirates Islamic bank and Emirates NBD Bank required a property management solution for managing the properties owned by them/their customers/funded properties. The system required modules for Leasing, Booking, Handle Tenant/Occupant complaints, Facilities and Property maintenance management. The system needed to be integrated with Oracle GL module for automated accounting entries and Account Payables module for payments to tenants and vendors.

Responsibilities 13. Business Requirement gathering and prepared functional specifications (MD-50 along with prototype screen designs.

14. Developed more than 25 Forms from scratch including Property master, Customer Master, legal case tracker, Leasing and Booking Modules, Payment Management, Worklist, Contracts management, Receipts management screens using Oracle Forms 10g in APPS environment.

15. Integrated the Leasing and facilities management module with Oracle General Ledger and core banking systems for automated payment management and clearing along with accounting entries.

16. Integrated with AP module for automatic invoice creation and vendor payments including settlement payments to Tenants.

17. Developed more than 50 reports using Oracle Discoverer.

18. Developed more than 20 reports using Oracle BI publisher (formerly XML publisher).

19. Developed more than 50 oracle alerts using Alert Manager.

20. Performed Functional and Stress testing of all the modules using IBM Rational functional and Performance tester tool.

21. Used standard oracle data migration utilities like FNDLOAD.

22. Co-ordination of UAT and closing all issues as per the SLA.

23. User Training during both pre go-live and post go-live.

Highlights Project was selected as Project of the Year in 2010 by Emirates NBD group IT for exceptional delivery quality and customer satisfaction. Got Client Appreciation for end to end implementation.

Project Emirates NBD eBusiness Suite R12 Upgrade

Customer Emirates NBD

Period 01-Dec-2009 to 30-Apr-2010

Location Dubai, UAE

Role Project Lead

Project Description The Oracle eBusiness Suite Implementation at EmiratesNBD was of version 11.5.10.2 with Teleservice, CRM Foundation, Installed Base, Oracle Interaction Inbound and Outbound Modules installed. This project was aimed at upgrading the existing operational system to 12.0.4 version of Oracle APPS for the ease of future implementations and getting additional features.

Responsibilities 1. Conducting a gap study between existing Oracle 11i and R12 system and preparing a gap document.

2. Prepare plan for pre and post upgrade process.

3. Getting rid of customizations/upgrade the current customizations to work with Oracle R12.

4. Upgrade the Database as required per the R12 compatibility matrix.

5. Carry out the upgrade process of APPS environment using standard Oracle patch for R12 upgrade.

6. Modify existing TCA procedures and functions for customer upload as per the upgraded TCA APIs.

7. Upgrade existing customized Forms and PLLs from 6i to 10g to work with the new environment.

8. Create new customized forms in 10g version.

9. Retrofitting and all the customizations and Integration layers with other interface systems. Prepare and manage project plan and Task list of the team.

10. Manage and review all the technical and functional activities of the project.

11. Managing a development and testing team size of 13.

12. Performed Functional and Stress testing of all the modules using IBM Rational functional and Performance tester tool

13. Handle UAT.

14. Publish the gap analysis document w.r.t the new and old system mentioning GUI changes.

Highlights Got Client Appreciation for seamless upgradation.

Project EmiratesNBD CRM Rollout

Customer EmiratesNBD

Period 20-Apr-2008 to 30-Nov-2009

Location Dubai, UAE

Role Project Leader

Project Description The eBS Implementation at EmiratesNBD was aimed at standardizing the Customer Service Processes across the bank post NBD and Emirates Bank‘s merger. The architecture of the application involved CRM servicing integrated with the Core Banking System (Finacle), ATM and Cards System (Base24 and Vision Plus) and Loans System (FinOne). The project involves product customization and implementation of Oracle 11i (E-Business Suite 11.5.10). It involved implementing the Customer Life cycle, Oracle Workflow and Advanced Inbound. It also involved development and implementation of a Generic Oracle Service Request Workflow that could address the various Customer Service scenarios across the bank’s departments and a robust integration with the Banking Systems. The project also involved implementation of TCA architecture for uploading data for all the customers and their details from Finacle, Vision Plus and FinOne to the CRM and also development of the logic for the daily refresh.

Responsibilities 1. Liaison with the core banking and interfaces team and gather requirements and conduct feasibility study.

2. Implementing TCA module for customer data migration from various interfaces.

3. Development of Generic Service Request Workflow to handle all the possible combination of Customer Service scenarios as defined in the Workflow Meta Data.

4. Functional Configuration of CRM and e-Business Centre for a 360 degree customer view.

5. Designed Oracle Forms, Reports, and Libraries using Oracle Forms 6i. Developed Custom Service Request Creation and Enquiry form and integrated it with eBusiness Centre in Oracle eBusiness suite. Also developed Service Request Mass update, Task Mass update and File Upload forms etc.

6. Developed reports in PDF, Doc and Excel formats using XML publisher.

7. Design and Development of PL/SQL Packages, Procedures and Data base triggers to process the Workflows.

8. Integration of the Generic Workflow with EAI to interact with interface systems.

9. All CRM configurations for Flex fields, Valuesets, Dashboard, Concurrent programs and request sets, Responsibilities, groups, user, Menu, etc.

10. Performed Functional and Stress testing of all the modules using IBM Rational functional and Performance tester tool

11. Performance Tuning of the system. Development of Purging programs for maintain seeded and custom tables.

12. Apply Oracle patches using ADPATCH and ADCTRL and do SYSADMIN jobs like forms and library compilation, Schema compilation using ADADMIN utilities.

13. Working actively with Oracle through their TAR in Metalink

Highlights Got Star of the month 3 times during the tenure of the project. Got Customer Appreciation for end to end implementation.

Project Implementation of Operational Support System for Neotel Enterprise Business Unit

Customer Neotel Corporation, South Africa.

Period 07-Nov-2007 to 17-Apr-2008

Location Mumbai, Maharashtra, India.

Role Module Leader

Project Description Neotel is South Africa's first converged communications network operator. Neotel is licensed as South Africa's first alternative infrastructure-based telecoms provider, capable of delivering a broad range of wireline and wireless data telecoms services on a national and international level. Neotel provides a portfolio of services to the wholesale, enterprise and consumer markets.

The scope of the project to capture user information from the order (lead) generation till putting the order in service. This project has interfaces with modules like Sales (Oracle Sales Online Tool), MetaSolv (Order Management System), Billing (Geneva Tool) and Remedy (ViZNet).

Responsibilities 1. Gathering the requirements and understanding the process flow from the client, Suggesting and implementing suitable designs and getting one approved by the client.

2. Create custom screens and interfaces into Oracle Sales Online system according to the user requirement and interfacing various other applications like POS (Point of sales), Order management system, Billing System etc.

3. Implementing Workflow for sending notifications to various users at the appropriate stage of Order Life cycle.

4. Design and Development of PL/SQL Packages, Procedures and Data base triggers to process the Workflows and then Integration of the Generic Workflow with the Oracle sales online using Oracle Advanced Queuing.

5. Customizing existing seeded forms and develop custom forms in Forms 6i.

6. Develop Oracle reports and scheduling it with Oracle APPS concurrent programs.

7. Configuring various concurrent requests, users, responsibilities, menus, role, customer dashboard etc. in E-Business suite implementation.

8. Performance tuning of the implemented system.

Highlights Got Customer Appreciation for Performance tuning of the system.

Project Warner Bros. Video Distribution Order Entry System

Customer Warner Bros. Studios

Period 07-Aug-2006 to 04-Nov-2007

Location Burbank, Los Angeles County, California, USA.

Role Module Leader

Project Description Warner Brothers is a fully integrated, broad-based entertainment company, is a global leader in the creation, production, distribution, licensing, marketing of all forms of entertainment and their related businesses.

Worked in an order management system which manages the validation, pricing, logistics and invoicing of all customer shipments. Order entry system managed the complete order lifecycle including inventory management and invoices generation to the respective customers against it. It also managed the returned items lifecycle.

Most of the transactions were EDI transactions through GXS like Purchase Orders, Invoices, Orders, Returns.

Design and development done Onsite (worked from Burbank, LA County, California for 14 months).

Responsibilities 1. Gathering the requirements and understanding the process flow from the client, Suggesting and implementing suitable designs and getting one approved by the client.

2. Developed Sales order and Invoice forms using Oracle Forms6i.

3. Development and Maintenance of Generic Router system to handle EDI file transactions across multiple systems globally through Australia, Hong Kong, UK, Brazil, Mexico and US.

4. Functional Configuration of EDI transactions to handle the Order flow through Supply chain cycle.

5. Design, Development and maintenance of Interfaces with Warehouses for Order Dispatch and Confirmations.

6. Design and development of Shell scripts, PL/SQL procedures and packages and various Database Objects to support Order Flow and processing, Invoicing and Interfaces with external systems.

7. Handling issues related to Order Flow/Processing and Invoices.

8. Monitoring Router system for file transfers to and fro from Warehouse and other external systems across the globe.

9. Performance Tuning of long running jobs and reports.

10. Handling Change Requests.

Highlights Got Customer Appreciation for Exemplary performance in January 2007.

Project Vodafone National CRM Rollout

Customer Vodafone

Period 01-Jul-2004 to 04-Aug-2006

Location Mumbai, Maharashtra, India.

Role Team Member (Developer)

Project Description The eBS Implementation at Vodafone was aimed at standardizing the Customer Service Processes across all Vodafone Locations. The architecture of the application involved 3 instances of eBS servicing multiple Vodafone circles and integrating with the Billing Systems at all these Circles. The project involves product customization and implementation of Oracle 11i (E-Business Suite). It involves implementing the CRM foundation, Oracle Workflow, E-mail Centre, and Advanced Inbound. It also involves development and implementation of a Generic Oracle Service Request Workflow that could address the various Customer Service scenarios across Vodafone Circles and a robust integration with the Billing Systems at these circles. The project also involves implementation of TCA architecture for uploading data for all the customers and their details from the BSCS system to the eBS and also development of the logic for the hourly refresh.

Responsibilities 1. Closely co-ordinate with the Vodafone CRM Core team and attract newer developments and enhancements

2. Liaison with the core team and gather requirements and conduct feasibility study.

3. Perform Quality review for project deliverables.

4. Handling UAT for the various circles and working on the UAT issues prior to go-live.

5. Development and Maintenance of Generic Service Request Workflow to handle all the possible combination of Customer Service scenarios as defined in the Workflow Meta Data.

6. Functional Configuration of Workflow Metadata and BSCS Rule Builder

7. Development of Custom Service Request form and integrating it with Contact Centre. Other forms developed were Token Management form, Work bucket form etc.

8. Design and Development of PL/SQL Packages, Procedures and Data base triggers to process the Workflows.

9. Integration of the Generic Workflow with the Vodafone Billing System (Business Support & Control System – BSCS) using Oracle Advanced Queuing

10. Integration of Workflows with the Fulfilment Module of the E-Business Suite

11. Creations of Users, Responsibilities and Menus.

12. Creation of Concurrent Managers and Concurrent Programs.

13. Creating Custom Profiles, Descriptive Flex fields and Value sets.

14. Configuring Calendars, Shifts and Exceptions.

15. Migration of Workflow data between the Development, Staging and Production Instances

16. Design and Implementation of Purging/Archival Strategy custom and Oracle Apps Base Tables.

17. Creating Configuration Scripts on need basis to provide dumps and reports

18. Monitoring Database and Application Servers for performance issues.

Highlights Got Customer Appreciation for Exemplary performance in March 2005.

Training / Continuing Education Summary

Program or Course Training Partner Dates

R12.X Extend Oracle Applications: Building OA Framework Applications Oracle University 16th-20th Oct, 2011

R12 Extend Oracle Applications: Customizing OA Framework Applications Oracle University 23rd-27th Oct, 2011

Oracle E-Business Suite Implementation Champion Certificate - E-Business Suite Essentials Oracle University 31st May, 2009

Oracle 10g Discoverer Administrator and Desktop Oracle University 01-Feb-2010

Developing Reports Through Oracle BI Publisher Oracle University 31-Jul-2009

Project Management PMI 30th May 2009.

1Z0-200 Oracle 11i E-Business Essentials Oracle University 29th May, 2009

Oracle Workflows Oracle University 3-4th Feb,2006

11i Extend Oracle Applications: Building OA Framework Applications Oracle University 17-21st May,2005

UNIX programming TCS 20-21 Jan,2005

Oracle 9i,10g Database and E-Business Suite Performance Tuning TCS Feb,2005

Oracle PL/SQL TCS 6-9th Sep,2004

J2EE TCS 5-9th Oct,2005

Professional Memberships / Certifications

Professional Society / Certification Member Since / Date Certified

PMI (Project Management Institute) Chapter, Middle East June 2009

OA Frameworks for Oracle R12 by Oracle Corporation. Oct 2011

IEEE July 2004

Personal Details

Date of Birth 03-Jul-1983

Nationality Indian

Contact this candidate