Synopsis
Dedicated professional with total domain experience of more than ten years
and around five years of experience in the areas like IT Consulting (ERP) -
implementing and supporting Oracle Financial E-Business Suite on various
versions from 11.5.9 to R12.1. Handled full-fledged implementation and
support for all financial modules. My competency lies in core domain
knowledge of Oracle Applications and a natural inclination towards emerging
aspects of IT & business consulting. Consider myself as Project Lead /
Functional consultant with full-fledged functional knowledge of GL, AP, AR,
FA, Treasury, CM and i-expense.
Work Career - A Snapshot
V Presently working as External Consultant with I T Convergence, USA
V Project Lead with Satyam Computers Services Ltd., Hyderabad, India
V Assistant System Analyst with Tata Consultancy Services Ltd., Baroda,
India
V Partner, Chartered Accountant firm Raja Kalyani & Company, Nagpur,
India
V Finance & Account Manager, Murli Agro Products Ltd., Nagpur, India
V Asst. Finance & Account Manager, Zim Laboratories Ltd., Nagpur, India
V Article ship with Tushar Trivedi & Co., Chartered Accountants, Nagpur,
India
Professional Qualifications
V Oracle Certified Professional (OCP) on R12- General Ledger & Accounts
Payable
V Chartered Accountant from Institute of Chartered Accountants of India
in 2002 (First Attempt)
V Diploma in Information Systems Audit (DISA) from Institute of
Chartered Accountants of India in 2005
V Master of Commerce from Nagpur University in 2003 (1st Class)
V Bachelor of Commerce from Nagpur University in 2000 (1st Class)
V Certified Oracle Financial Training in 2005
Technical Skills
Operating Systems : Windows 95/98/NT 4.0/XP
Applications : MS Office, Open Office, Lotus Smartsuit and other
Accounting Packages : Tally, Quickbooks, Wings and other
Audit Softwares : IDEA, ACL, SoftCAAT
Utilities, Tools & GUI : Data Loader, PL/SQL Developer, TOAD,
Application
Desktop Integrator (ADI), Discoverer, UPK
Enterprise Resource Planning : Oracle Application (11i & R12)
Professional Experience - ERP
1) I T Convergence, US
Working as External Consultant for Client Mattel Inc. (Oracle Application)
Sep'2009 - Till Date
Mattel is the worldwide leader in the design, manufacture and marketing of
toys and family products. The Mattel family is comprised of such best-
selling brands as Barbie , the most popular fashion doll ever introduced,
Hot Wheels , Matchbox , American Girl , Radica and Tyco R/C, as well as
Fisher-Price brands, including Little People , Power Wheels and a wide
array of entertainment-inspired toy lines. With global headquarters in El
Segundo, Calif., Mattel employs more than 30,000 people in 43 countries and
territories and sells products in more than 150 nations.
i) Project: MGT Asia Wave III-
(Sep-2009 to Till Date)
Project Description:
Mattel Inc. is using Oracle Application since 2001 and it is rolled
out to more than 120 countries. This project includes implementation
of Oracle Application for India, Australia and New Zealand.
Contribution:
V Involved in the project from Kick off meeting, project planning,
business requirement gathering, process flows, solution designing,
testing and currently cutover.
V Provided complex solution on India Localization for India entity
(Mattel Toys India Pvt. Ltd.) of Mattel Inc.
V Looking after implementation for all three following entity under
the current phase of global implementation -
. Mattel Toys India Pvt. Ltd. (India)
. Mattel PTY Ltd. (Australia)
. Mattel (NZ) Limited (New Zealand)
V Implementing all financial modules which include GL, AP, PO, AR, FA,
CM and iExp.
V Implemented integration with 170 markview image solution for
processing and approval of AP Invoices.
2) Satyam Computers Services Limited, India
Working as Project Manager (Oracle Application) Oct'2006 - Aug' 2009
Satyam Computer Services Ltd. is a leading global consulting and IT
services company, offering a wide array of solutions customized for a range
of key verticals and horizontals. From strategy consulting right through to
implementing IT solutions for customers, Satyam straddles the entire IT
space.
Satyam's Oracle Enterprise solutions practice took shape in 1996, with
primary emphasis on implementing and supporting Oracle Financials. Growing
with every project, gaining invaluable experience and in-depth knowledge of
clients' needs, today Satyam is the leading Oracle practice in APAC.
i) Project: Wataniya Airways support -
(May-2009 to Aug-2009)
Project Description:
Wataniya Airways is the major airline in Kuwait. Wataniya went into
implementation of Oracle Applications from 2009. The project included
Support of Oracle Financials modules on R12.
Contribution:
V Leading a team of 4 professionals onsite as a project manager of
Wataniya Aiways support project.
V Resolution of all the major issues in the project as a trouble
shooter.
V Preparation/modification of Designs for Inbound and Outbound
Interfaces to integrate with legacy systems and other third party
applications.
V Controlling Release and Change Management in Production instance,
tracking development status
V Resolved the clients issue in reconciliation between various Sub
ledgers and General Ledger.
ii) Project: Air India Implementation and support -
(Dec-2008 to Apr-2009)
Project Description:
Air India is the major airline in India and worldwide. Air India went
into implementation of Oracle Applications from 2005 for SCM and 2007
for financials and right now operating its business process for all
the station in Oracle ERP. The project included implementation of
Oracle Treasury and iexpense modules along with continues support on
all other financial modules.
Contribution:
V Implemented Oracle Treasury and Business Intelligence for airline
industry based on the requirement for interbank transfer, term loan
management, FX hedging.
V Implemented iexpense to automate the employee payments and benefits
V Brought lot of process improvement with the automation and
restricting manual intervention.
iii) Project: Air India Support -
(Sep-2008 to Nov-2008)
Project Description:
Air India is the major airline in India and worldwide. Air India went
into implementation of Oracle Applications from 2005 for SCM and 2007
for financials and right now operating its business process for all
the station in Oracle ERP. The project included support on Oracle
11.5.10.2 for all the financial and supply chain modules.
Contribution:
V Leading a team of 9 professionals onsite as a project manager of Air
India support project.
V Successfully closed the financial accounts for FY 2007-2008.
V Preparation of Designs for Inbound and Outbound Interfaces to
integrate with legacy systems and other third party applications.
V Monitoring & reporting Project progress on a weekly basis to Air
India's project manager and Satyam's Account Manager for Roll Out
activities and Data Conversion and Transition.
V Involved in the solution design of Air India's business processes on
Oracle applications for new scenario's after Implementation.
V Controlling Release and Change Management in Production instance,
tracking development status
V Incharge for the post implementation support and guided the team in
the support activities like registering the issues and maintaining a
log of resolutions and specifically incharge for Data Conversion
Activities including Month End Closure Activities.
iv) Project: R12.1 Testing for Financial Modules in Oracle -
(Aug-2008 to Sep-2008)
Project Description:
Oracle has called implementation partners from Satyam, Infosys, IBM,
and Accenture for testing Release 12.1. This project is for testing
the delta features in R12.1 and existing features R12.
Contribution:
V Created test flows on the basis of previous implementation and
business experience
V Setup entire organization structure along with setup in all the
financial modules in R12.1
V Setup e-Business Tax with respect to VAT, Sales Tax, Use Tax and
others
V Testing all the transactional and setup flows for e-Business Tax
V Interfacing AP and AR invoices to test the tax effect in the
calculation of EB Tax
v) Project: Fullerton Financial Oracle Implementation -
(Jan-2007 to Jul-2008)
Project Description:
Fullerton Financial Holding (FFH) is a green field Financial Service
entity based out of Dubai. It is promoted by Temasek Group, which is
an Asia investment house headquartered in Singapore. Temasek Holdings
has multinational staff of more than 300 people, and manages a
portfolio of over US$100 billion, focused primarily in Asia. FFH is
starting its operations in Dubai (UAE) and India for which they
implemented Oracle EBS.
FFH is using Oracle Applications extensively to support its customers
and user. The solution integrates Oracle CRM, Oracle Financials
(including Oracle Treasury), Card System and Core Banking Solution.
The project is to implement and integrate various applications with
major reporting from Oracle Applications.
Contribution:
V Lead the finance track including Oracle Treasury and Business
Intelligence Dashboard of the project, managing a team of 4 members
V Business Requirements Gathering which comprised continued
interaction with clients, analysis of requirements, elicitation of
untold needs and documentation of the consolidated requirements
V As-Is Study that included preparation of multiple documents and high-
level diagrams using diagramming tools and presentation of the
business analysis to clients
V Gap-Fit Analysis which included preparation of Process Mapping
document, identification of gaps and addressing gaps
V Designing chart of accounts and integration with various other
systems with GL
V Mapping unique requirement for treasury department in Oracle
Treasury module
V Interacting with Oracle for development of gaps and fixing bugs in
the functionality with respect to Oracle Treasury
vi) Project: Healthcare Instance Setup for a new Vertical Healthcare
Industry-
(Dec-2006 to Dec-2006)
Project Description:
Set up complete instance with predefined requirement for the
healthcare industry. Requirement was to setup complete Instance with
POC (Proof of Concept) for Healthcare Industry.
Contribution:
V Designing Chart of Account, Set of Books and Multi Org Structure.
V Implemented Account Receivables module along with testing various
scenarios.
V General Ledger including GIS, GCS, MRC, Budgets, Rollup Groups and
Revaluation.
V Testing of all setups and transactional flows.
V Understanding the responsibility matrix and creating / assigning
responsibilities to user with custom menus.
vii) Project: EBG (Emirates Bank Group, Dubai) Pre Sales Instance Setups -
(Nov-2006 to Nov-2006)
Project Description:
Set up complete instance with client requirement for the pre sales
activities for Emirates Bank Group. Requirement was to map 70% of the
client requirement, which was completed in a week time.
Contribution:
V Designing Chart of Account, Set of Books and Multi Org Structure.
V Implemented General Ledger including GIS, GCS, MRC, Budgets, Rollup
Groups and Revaluation.
V Implemented Account Payables, Approvers Management, Treasury and
Cash Management for banking company.
V Testing of all setups and transactional flows.
V Consolidation of various set of books with difference currencies
after translation.
V Understanding the responsibility matrix and creating / assigning
responsibilities to user with custom menus.
3) Tata Consultancy Services Limited, India
Working as Assistant Systems Analyst (Oracle Application) Dec-2005 to
Oct-2006
Tata Consultancy Services (TCS) is one of the world's leading information
technology companies. Through its networked delivery model, domain-specific
expertise, a global workforce of over 74,000 professionals, and its
flexible approach to client relationships, TCS relentlessly focuses on
helping 3,000 global organisations address their business challenges
effectively and stay ahead. Pioneer of the flexible global delivery model
for IT services, TCS focuses on delivering technology-led business
solutions to its international customers across varied industries. The
company's vision is to be a Global top 10 IT services company by 2010.
i) Project: Rollouts for e-Urja IT Solution -
(Jun-2006 to Oct-2006)
Project Description:
Rollouts for existing implementation of Oracle Application (e-Urja)
into various non-pilot location spread all over Gujarat. It includes
rollouts for 200 odd locations of six different companies of GEB.
Rollouts involved making/modifying setups for new location and
giving training to end-users.
Involved in rollouts for financial modules, viz. GL, AP, AR, FA, TR
& CM. My role here includes
Contribution:
V Making addition setups and modifying the existing setups wherever
necessary.
V Data migration for masters as well as transactional data.
V Providing training to end users in GL, AP, CM and Treasury modules.
V Providing post production support for the already gone live
locations.
V Assisting users in performing month end closing activities for
various financial modules.
ii) Project: GEB end2end Project -
(Dec-2005 to Jun-2006)
Project Description:
Gujarat Electricity Board (GEB) was established along with the
formation of Gujarat State in the year 1960 under Section 5 of the
Electricity (Supply) Act 1948. Starting with a generation capacity
of 315 MW and a consumer base of 1.40 million consumers, GEB today
is the lifeline for over 7.3 million consumers across the State of
Gujarat.
This is India's biggest Oracle Apps implementation project, which
involves implementing an end-end IT solution for Gujarat Urja Vikas
Nigam Limited (GUVNL - formerly known as Gujarat Electricity Board)
and its six subsidiaries.
Involved in implementation and production support (day-to-day
activities) for financial modules, viz. GL, AP, AR, FA, XTR & CM. My
role here includes
Contribution:
V Conversion of the entire functional process from the client's
legacy system to Oracle Applications suite for Accounts Payables,
Treasury and Cash Management module. The challenges include India
localization.
V Managing mainly four modules viz. General Ledger, Accounts
Payables, Treasury and Cash Management for all four Companies for
DISCOM (Distribution Companies), viz. MGVCL, DGVCL, PGVCL and
UGVCL.
V Done all the setups for General Ledger, Accounts Payables,
Treasury, DBI and Cash Management
V Involved in various phases of implementation from SIT, UAT, End
User Training, Data Migration, setups and roll outs.
V Provided end user training to users of four DISCOM companies users.
V Continues interaction with client from business process mapping
till data migration, golive, production and roll outs.
V Implemented Security Rule and Cross Validation functionality.
V Writing Financial Statement Generator as required by user from time
to time.
V Writing query with PL/SQL developer and TOAD for data required by
users and live support from time to time.
V Giving full fledged support for month close activities including
all Reconciliations.
V Liaison with Oracle for support on various critical issues.
V Providing Functional inputs to Technical Consultants in for
Customizing Reports and Interfaces etc.
Special Assignments- ERP
V Conducted Oracle Treasury training on R12 with Oracle India Pvt.
Ltd in Bangalore for 2 days.
V Conducted hands on Oracle Treasury training on 11i with COLT,
Gurgaon for 4 days.
V Conducted Oracle Financials training on 11i with Satyam Computers
to ELTP batch twice.
V Done many proposals for Satyam Computers for EMEA and APAC region
V Involved in presales presentations and demo with clients
V Conducted many web based training on vShare for Satyam Computers on
all Oracle financial modules
Related Functional Experience
As part of my work experience (at Raja Kalyani & Company & Co,
C.A., Murli Agro Products Ltd., Zim Laboratories Ltd. and
articleship during Chartered Accountancy), I have been involved
with in providing auditing, consulting, finance services. A brief
profile of my experience is given here.
4) Period : One year five months [May-2004 to Sep-
2005]
Firm/Company : Raja Kalyani & Company, Nagpur, India
(One of the big Chartered Accountant firm in
Nagpur)
Designation : Partner
Major Responsibility : Have done many audits of banks, firms,
and companies in India. Have involved in
following:
V Concurrent, Revenue & statutory Audits of Banks.
V Preparing monthly reports for above audits & discuss with
concerning person.
V Handling Direct and Indirect Taxation matters of various Public
Companies, Private Companies, Partnership Firms and
Individuals.
V Prepared Income Tax Returns for Individuals, partnership Firms,
HUF & Corporate Assesses along with advisory services on
routine Income Tax matters.
V Review of Internal Control System & Preparation & Communication
of Internal Audit Report.
V Statutory Audits of various Private companies.
5) Period : One Year One Month (Post qualification as ACA)
[Apr-2003 to Apr-2004]
Firm/Company : Murli Agro Products Limited, Nagpur, India
(One of Central India's largest Soya Refined
Oil Extraction, Paper, Co-generation Co.
having turnover of Rs. 3.90 Billion)
Designation : Finance & Accounts Manager
Major Responsibility: Finance for new projects and existing units
and monitoring day to day accounting along
with finalization of Financial Statements and
MIS Reports.
Achievements :
V Have liaison with banks for the finance of Rs.430 Million for
the new project setup by the company.
V Documentation of export of about Rs.600 Million along with the
follow up of the payments and other formalities.
V Handled the work related to Demat and Transfer of Shares and
legal matters.
V Internal audit with development and monitoring of internal
control system.
V Conversant with development of project reports, evaluation of
financial data, Internal Controls and implementation of various
auditing techniques.
V Prepared and finalized the Balance Sheet, Profit & Loss
Account, Fund flow, Cash flow statements along with schedules.
Also prepared the annual report of the company for the F.Y.
2002-2003.
6) Period : One Year three months (Pre
qualification as ACA)
[Nov-2001 to Jan-2003]
Firm : Zim Laboratories Ltd., Nagpur, India
(One of the largest groups in Central India in
Manufacturing Pharmaceutical products)
Designation : Asst. Finance & Accounts Manager
Major Responsibility: Finance planning for the pharmaceutical
unit and monitoring day-to-day accounting.
Achievements :
V Monitoring of Financial data and evaluation of performance of
various profit centers.
V Computerized / Manual Accounting, Preparation of Monthly Trial
Balance, Profit & Loss Account and finalization of Balance
Sheets as per the latest Accounting Standards.
V Conversant with development of project reports, evaluation of
financial data, Internal Controls and implementation of various
auditing techniques.
V Handled total project finance work of the new project & banking
procedures.
V Preparation of Fund flow and Cash flow statements as per the
latest accounting standards.
7) Articleship with C.A.:
i) Period : One Year Four month [Oct-1998 to Feb-
2000]
Audit Firms : Ravindra Lashkare & Associate.,
Chartered Accountants,
Central Avenue, Nagpur, India.
Roles & responsibilities:
All basic preparation for auditing, by auditors, internal as well
as external and working simultaneously with them for the
preparation of Balance-Sheet, Funds Flow, Cash Flows etc.
ii) Period : One Year Seven Months [Mar-2000 to Oct-2001]
Audit Firms : Tushar Trivedi & Co.,
Chartered Accountants,
Shaheed Chowk,
Itwari, Nagpur, India.
Roles & responsibilities:
V Entrusted with the preparation and finalization of various
financial statements.
V Entrusted with the audit of Public & Private Limited Companies,
which include Statutory & Tax Audit.
V Entrusted with the Statutory, Internal & Revenue Audit of
Banks.
V Handled Company Law Requirements regarding Resolutions,
Minutes, Annual Returns & Other ROC Matters.
V Prepared Income Tax Returns for Individuals, partnership Firms,
HUF & Corporate Assesses along with advisory services on
routine Income Tax matters.
V Review of Internal Control System & Preparation & Communication
of Internal Audit Report.
V All basic preparation for auditing, by auditors, internal as
well as external and working simultaneously with them for the
preparation of Balance-Sheet, Funds Flow, Cash Flows etc.
Personal information
Date of Birth : October 26th, 1979
Marital Status : Married
Professional Membership : Institute of Chartered Accountants of
India
Passport No. : G 8137813 (Valid upto 09-Apr-2018)
Visa : US H1B (Valid upto 12-Aug-2011)
Australia Business Visa (Valid upto 04-Dec-
2010)
Malaysia Business Visa (Valid upto 20-May-
2011)
Reference : Available if desired