Resume
Experience
Jan 2017 - Present
ANALYST
Reliance Jio Infocom
Payroll - Brijesh Himmatramka &
Associates
Kolkata, West Bengal
-
Generate & Analyze reports of all finance verticals [Business Finance, Operations & Maintenance, and Project] for Eastern Region from different portals [i.e. SAP, IEM].
-
Conduct in-depth analysis of provisioning, Cost variance, and forecasting.
-
Work on cost-reduction opportunities.
-
Capital budgeting of new projects.
-
OPEX hygiene maintenance.
-
Site wise revenue, contribution & ROI analysis
-
Analyze reports on Identifying trends, Market insights, Network KPI’s Etc.
-
Prepare and publish dashboards on OPEX, material, Network, RMS, CMS Etc.
-
Use statistical methods like Regression, K-Means clustering, ARIMA, Geospatial Analysis, and others to get meaningful insight & forecast.
Nov 2015 - Oct 2016
DATA ANALYST
Zinfi Software System (P) Ltd.
Kolkata, West Bengal
-
Manage data and upload it into the in-house marketing tools.
-
Search and extract raw data and company information from online sources to support direct and interactive marketing campaigns.
-
Conduct in-house social media analysis.
-
Manage marketing database for direct and interactive marketing activities.
-
Campaign data management and analysis for prospective and existing customer databases.
-
Support the marketing team with list segmentation and campaign analysis.
-
Create reports and documents that measure the success of direct and interactive marketing campaigns.
-
Designing and performing analyses using spreadsheets and Summarizing findings and presenting results in an easy-to-understand manner.
-
Monitoring and assessing data quality on an ongoing basis.
-
Combining analytical skills with business domain knowledge to execute a project and guide junior team members.
Dec 2012 - Jun 2015
EXECUTIVE CONTRACTS
Rahee Infratech Limited
Kolkata, West Bengal
Worked for Kolkata East-West Metro Project – Design, Procurement, Construction & Installation of Rails.
-
Budgeting capital expenses and procurement of assets [Start to end].
-
Monitor project activity cost and performance of the contract.
-
Raise timely bill to ‘KMRCL’ for payment and thereafter following with them for collection.
-
Human Resource activities – Recruitment, Policies, Appraisals, Grievance handling, Payroll for contract staff.
-
Make sure that all activities are carried according to the contract – Procurement, Design, Billing, Testing.
-
Manage entire database of the project – Correspondences, Designs, Policies, Agreements, Documents.
Education
2012
St. Xavier’s College, Kolkata,
Bachelor of Commerce
2008
St. Xavier’s Collegiate School,
I.S.C. Commerce
Present
Preparing for CFA [Chartered Financial Analyst Level I & II
Certifications
2020
EICT, Indian Institute of Technology Roorkee,
Machine Learning Specialization
2016
INSAnalytics,
Data Mining
2015
Indian Institute of Export Management Bangalore,
Export Import Management
2017-21
Python, R, MySQL, Power BI
Core skillset
Data Mining & Modeling
Machine Learning
Dashboards & Visualization
Stattistical Modeling
Financial Analysis & Modeling
Marketing Analysis & Modeling
Professional skillset
Excel
Access
PPT
MySQL
Python
R Stats.
