Sales Financial

Kapil Bareja

New Delhi

@*******@*****.***

Contact No: +91-999*******

Career Objective:

To become a successful Professional in the field of Finance and Accounts and to work in an innovative and competitive

environment where my knowledge and analytical skills are to be put in for the successful completion of any given project or

assigned task and work sincerely to keep up reputation of the organization.

Strengths:

Keen to experiment and learn new things.

Excellent analytical and problem Solving skills.

Good Grasping Power.

Strive to excel and exceed expectations in challenging Tasks.

Self motivated and have the ability to create new ideas.

Summary:

Qualitative & Quantitative Experience of more than 4.5 Yrs. in the field of Finance.

Worked with Morningstar India Pvt. Ltd. from August, 2008 to July, 2012.

Working for PepsiCo India Holdings Pvt. Ltd. from September, 2012

Organizational Experience Details:

Company : PepsiCo India Holdings Pvt. Ltd. (on the Payroll of Team Lease)

Segment : Snacks (Frito-Lay)

Designation : Finance Associate

Duration : September, 2012 till Present date

Department : Financial Planning

About PepsiCo-

PepsiCo is a global food and beverage leader with net revenues of more than $65 billion and a product portfolio that includes

22 brands that generate more than $1 billion each in annual retail sales. Our main businesses – Quaker, Tropicana, Gatorade,

Frito-Lay and Pepsi-Cola – make hundreds of enjoyable foods and beverages that are loved throughout the world.

Job Description:

As a Finance Associate, responsible for supporting the financial planning team in following tasks:

Financial Planning: includes following responsibilities:

Preparation of the Income Statement, Balance Sheet and OCF for Annual Operating Plan and

Forecast, considering the KPIs decided by Higher Management.

Preparation of the Department wise G&A Expenses for AOP and Forecast.

To Prepare the Mix COC for Plan and Actual figures.

Monthly Analytical Reports: includes following responsibilities:

Analyzing the Actual Volume Report to find the dark and bright Spots.

Preparing Growth Reports VS YAGO and AOP on Brand and Pack basis.

MOM Variance Analysis of G&A Report.

MIS Reporting: includes following responsibilities:

Preparing Sales Volume report on basis of region and Brand for every month.

Preparing MIS for GCTS (Gross Cost to Stockiest) and report to Management.

Preparing Brand Wise Net Revenue Report and MBR deck MOM.

Other Supporting Tasks: includes following responsibilities:

Segregating Actual Report of G&A MOM on the basis of Departments.

Preparing MOM OCF through Balance Sheet provided by Control team.

Preparing other Ad hoc Reports as according to team requirement.

Organizational Experience Details:

Company : Morningstar India Pvt. Ltd.

Designation : Sr. Research Associate (Feb 2012 to July 2012)

Research Associate (July 2010 to Feb 2012)

Jr. Research Associate (Aug, 2008 to June 2010)

Duration : August, 2008 to July, 2012

Research Type : Secondary Research through Financial results of the companies

About Morningstar-

Morningstar, Inc. is a leading provider of independent investment research in North America, Europe, Australia, and Asia.

The company offers an extensive line of Internet, software, and print-based products and services for individuals, financial

advisors, and institutions. Morningstar provides data on approximately 450,000 investment offerings, including stocks,

mutual funds, and similar vehicles, along with real-time global market data on more than 4 million equities, indexes, futures,

options, commodities, and precious metals, in addition to foreign exchange and Treasury markets

Key Responsibilities:

Financial Spreading/Reporting: Responsibilities while collecting the information for creation of financial

database are as follows:

Financial Spreading/Reporting (Profit & Loss A/C, Balance Sheet, Cash Flow and Equity Share holder

fund) into the web applications to generate the standardize reports and charts which are used by the

investment community to take investment decision all over the globe as per the rules under IFRS & UK-

GAAP standards.

Conduct research on the companies and removing the effects of certain extraordinary items (non-recurring

in nature) from income statement to arrive at normalized earnings.

Tracking dividend related information through the Financial Reports (Annual & Quarter Reports).

Calculation of EBIT, EBITDA, EPS, Adjusted EPS, Market Capitalization and Normalized Earning on the

Excel sheet and provide that information to client for making investment decision.

Good Understanding of General Accounting Concepts.

Financial Statement Analysis: Analytical Part of Financial Statement Includes following responsibilities:

Growth and Compound growth of Revenue, Operating Profit and Net Income of the Company for last 5

Year and represent it through Charts.

Calculation of Balance sheet ratio (Current Ratio, Cash ratio, Turnover ratio), Income Statement Ratio

(Profitability ratio, Market Ratio) and Cash Flow Ratio (Free Cash Flow Ratio, and Operating Cash Flow

ratio) of the Companies as according to Client’s Requirement.

Product database knowledge i.e. Deep understanding of the System itself and various calculation based on

formulas/ratios required as per equity market. (Dividend Yield Ratio, EV, PE, EBIT, EBITDA, Etc)

Non Financial Database: Non Financial database creation includes:

To Collect the Operational information of the Business.

To collect the information of corporate governance.

Financial Database Migration: Financial database Migration is process of transferring the data from one

Application to another. It is categorized as:

Third Party Data Migration

Client Files Migration for Application compatibility.

Task Allocation and Resource Planning: As a senior member of the team responsible for:

Creates and maintain process/content/training documentation.

Process related training to new comers.

Practical knowledge of US-GAAP, IFRS and UK-GAAP as according to process.

Monitoring overall functioning of process, identifying improvement areas and implementing it.

Academic Credentials:

MBA (Finance) from PDM College under MD University, Rohtak in 2007 with 1st division.

B. Com (Pass) from A.R.S.D. College under Delhi University in 2004 with 2nd division.

10+2 from Triveni Memorial Sr. Secondary School under CBSE Board in 2001 with 1st division.

10th from Holy Child High School under HBSE Board in 1999 with 1st division.

Computer Skills:

Good in MS Office and internet.

Proficient in MS-Excel and HFM (Hyperion Financial Management) financial upload and Retrieval.

Personal Details

Father’s Name : Mr. Dharampal Bareja

29th June, 1984

Date of Birth :

Marital status : Single

Languages Known : Hindi and English

Present Address : A-42, Mansaram Park, Uttam Nagar, New Delhi.

Permanent Address : 26/109, Quilla Enclave, Bahadurgarh-124507.

Declaration:

I hereby certify that all the information provided above is true to the best of my knowledge and belief.

Date: (Kapil Bareja)

Contact this candidate