MIS

Anirudhya Krishna Ghosh Moulik

C/O P CHAKRABORTY FLAT D 1ST FLOOR

Deep Apartment 44A/2 K N SEN ROAD KASBA KOL-42

M: 759-***-****, E: *********.*@*****.***

PERSONAL SUMMARY

An adaptable, resourceful and enthusiastic MIS analyst, who has extensive in monitoring and reconciling a company’s Data and knowledge of KPI reporting and assisting in the production of monthly management reports.

KEY SKILLS AND COMPETENCIES

Strong Data Analysing skills, Ability to make MIS report formats

Extensive knowledge in Excel Formulas, Strong Analytical skills.

Tenacious work ethic, Ability to meet deadlines, Self-Motivated, Hard Working

Ms Excel & advance Excel, V-lookup, H-lookup, Pivot, Sum-ifs, IF, Sum-product, PPT.

WORK EXPERIENCE:

Overall 10+ years of experience in MIS / Analyst profile.

Emami Ltd

MIS Executive Aug 2018-till date

Duties & Responsibilities:

Gross and Net Sales analysis i.e. brand wise, region wise, country wise monthly, quarterly and yearly.

Sku-wise and country wise analysis of YTD data w.r.t quantity, avg sales per qty, sales value, per pc avdg COGS, total COGS and COGS % to sales

Tracking of Cost per pc w.r.t actual and budget and also brand wise and product wise.

Sales COGS Variance analysis of sales i.e. actual vs budgeted monthly, quarterly and yearly.

ABC analysis w.r.t sales and COGS i.e actual vs budgeted.

Cost increase or decrease analysis w.r.t CY vs LY

Develop various types of MIS reports as required by seniors.

Coordinating with cost dept for any discrepancies in cost and resolving the errors.

Magma HDI General Insurance Company (A Unit of Magma Fincorp Ltd.)

Senior Executive Oct 2016-Aug 2018

Duties & Responsibilities:

Responsible for MIS reporting and analysing of data to assist in preparing presentation for Review meeting / Board Meeting.

Capturing the data from ERP (Qlikview) and comparing it with manual captured data.

Perform data analysis for generating reports on periodic basis.

Provide strong reporting and analytical information support to management team.

Calculating the Incentive for the Marketing dept., Agents, Brokers, Special schemes.

Reconciling MIS data with marketing & sales dept. identifying the discrepancy.

Assisting MIS Team in Regulatory IRDA report making.

Ess Dee Aluminium Ltd (India Foils Ltd) - Daman

Assistant manager MIS July 2013–July 2016

Duties & Responsibilities:

Responsible for MIS reporting and analyzing of data to assist in increasing the efficiency and improvement of the factory.

Work closely with Factory Head, HOD’s, Management Committee& Accounts and Audit dept. by providing necessary information about activities relating to cost & production.

Understanding and generation of the entire analytics requirement as per Management which includes Sales and Revenue Analysis, and Target vs. Achievement Analysis.

Managing various reports (Store Items Report, Inventory Data Reports, Balanced Items & Current Value of Inventory Report, Sales Report, MTD Report, Variance Reports, Conversion Reports, etc.)

Ess Dee Aluminium Ltd (India Foils Ltd) - Daman

Senior Executive - MIS Jan 2011 – June 2013

Daily recording of data from all machines [Input & Output weights.] Actual vs. Targeted Production Analysis, Sales Analysis

Cross checking the Dispatch report, Production report, Stock report on daily basis.

Informing the Factory Head & Production head if any wrong or false record is recorded in the register

MIS Reports on Production, Stocks, Dispatch, and Raw material consumption.

Preparing Job Card (issue & closing of job card), maintaining proper tracking of job card.

Ess Dee Aluminium Ltd (India Foils Ltd) - Daman

Trainee- MIS July 2011 – Dec 2011

Daily recording of data from all machines [Input & Output weights.]

Cross checking the Dispatch report, Production report, Stock report on daily basis.

Informing the Factory Head & Production head if any wrong or false record is recorded in the register.

Amit Motor Cycles (P) Ltd (Now Hitech Hero) - Kolkata

Accounts Executive Dec 2010 – May 2011

Payment & Accruals record, Entries in Tally & Excel (MIS reports).Preparing reconciliation Statements for Petty Cash balances.

Meticulously managed diverse accounting functions including preparation of vouchers and, maintenance of Books of accounts like Bank, cash, petty cash, purchase & sales register on daily basis.

ACADEMIC QUALIFICATIONS

MBA Finance 2008-2010

West Bengal University of Technology 7.34 CGPA

Financial Management, Financial Analysis

B. Com (Hons.) Accountancy 2004-2007

St Xavier’s college, Kolkata (C.U.) 58.75%

Accounts, Costing, Financial statement analysis

Higher Secondary (WBHSCE) 2002-2004

St Xavier’s Higher Secondary, Haldia 62.80%

Accounts, Commerce, Business Economics,

Secondary (WBBSE) 2002

St Xavier’s High School, Haldia 57.88%

SUMMER INTERN PROJECT (MBA) DETAILS

“A STUDY OF THE CREDIT APPRAISAL PROCESS IN AXIS BANK WITH REFERENCE TO AUTO LOAN”

PROJECT OBJECTIVE

Studying the Credit Appraisal Process at Axis Bank.

Understand and examining the credit rating process for the loan of applicants.

Finding out the category of Credit Scores where a high probability of defaulters is possible.

To understand prerequisite for application of loan, documents needed for different types of clients.

To understand types of loan, amount of loan & tenure for repayment sanctioned for the clients.

Market analysis of Axis Bank (Durgapur) & customer feedback.

PROFESSIONAL SKILLS

Certificate in Financial Accounting.. Having exposure in Tally ERP accountancy module. Qlikview, SAP (data download only)SALARY

Current CTC Rs. 3,99,000 p.a.

Expected CTC As per industry Standard

Notice Period 30 Days

ADDRESS

For Communication Permanent Address

C/O P CHAKRABORTY FLAT D 1ST FLOOR C/o Nisith Krishna Ghosh Moulik

Deep Apartment Vill+PO Panchthupi, Moulikpara

44A/2 K N SEN ROAD KASBA KOL-42 Dist Murshidabad West Bengal Pin 742161

PERSONAL DETAILS

Name Anirudhya Krishna Ghosh Moulik

Father’s Name Nisith Krishna Ghosh Moulik

Mother’s Name Late Ratna Ghosh Moulik

Marital Status Single

D.O.B. 20-10-1984

Languages Known Bengali, English, Hindi

DECLARATION:

I hereby declare that the information furnished above is true as the best of my knowledge.

Date: 02/12/2020

Place: Kolkata Anirudhya Krishna Ghosh Moulik

Contact this candidate