Chaitanya Kumar — Business Analyst

I am a Data Analyst & Marketing Analytics Specialist with over 6 years of experience transforming complex data into actionable insights that drive growth, efficiency, and smarter decision-making. My journey into analytics began with a B.Tech in Mechanical Engineering from the Indian Institute of Technology (IIT) Patna (2014–2018), where I built a strong foundation in problem-solving, structured thinking, and quantitative analysis. After graduating, I started my career as an LPG Marketing Officer at HPCL (Hindustan Petroleum Corporation Limited), where I managed sales strategies, distributor networks, and performance reporting. During this time, I learned how business decisions impact customers and revenue on a large scale. While I enjoyed sales and operations, I realized my passion was in leveraging data and analytics to optimize performance. That realization shaped my career path. Currently, I work as a Marketing Data Analyst Specialist at Marine Hardware Syndicate, where I own end-to-end analytics across inventory, sales, and marketing. Some of my key achievements include: ✅ Designing and deploying interactive dashboards (Power BI, Tableau) that improved campaign ROI by 20% and reduced reporting effort by 25%. ✅ Automating MIS workflows using SQL and Excel VBA, cutting reporting turnaround time by 50%. ✅ Conducting inventory analysis that reduced holding costs by 15%, improved storage utilization by 25%, and reduced delivery time from 7 to 3 days. ✅ Performing customer churn analysis using SQL and Python, enabling targeted campaigns that reduced churn by 12% YoY. Beyond professional work, I’ve delivered multiple data projects, including inventory optimisation, customer acquisition, and analytics case studies with Trainity, applying SQL, Python, Power BI, and Tableau to real-world datasets. My core skill set includes SQL, Python (Pandas, Matplotlib, Seaborn), Power BI, Tableau, Excel (VBA, Macros, Power Query), DAX, A/B Testing, Cohort & Funnel Analysis, Google Ads, SEO, and Campaign Optimization. I bring a unique combination of data-driven decision-making and digital marketing expertise, making me effective in bridging technical insights with business strategy. 🌱 To stay ahead, I am broadening my knowledge of cloud data platforms (Google BigQuery, Snowflake) and advanced statistical modelling, as these are shaping the future of analytics. 📬 Always open to connecting with professionals in data analytics, business intelligence, digital marketing, and strategy. Let’s connect and explore how we can create impact through data!

Stackforce AI infers this person is a Data Analyst specializing in Marketing Analytics and Business Intelligence.

Location: Patna, Bihar, India

Experience: 8 yrs 11 mos

Skills

Data Analysis
Data Visualization
Operations Management
Sales Management
Project Management

Career Highlights

Improved campaign ROI by 20% through data-driven insights.
Reduced reporting turnaround time by 50% with automation.
Achieved 50% conversion increase through targeted PPC campaigns.

Work Experience

Trainity

Data Analyst Training (1 mo)

Marine Hardware Syndicate

Data Analyst and Marketing Specialist (4 yrs 3 mos)

Hindustan Petroleum Corporation Limited

Operation officer Mundra Terminal (9 mos)

LPG Sales Officer Siwan SA (2 yrs 8 mos)

Steel Authority of India Limited

Summer Intern Bhilai Steel Plant (2 mos)

Student council of mechanical engineering

Technical Head SCME (8 mos)

RTDC Club

Technical Coordinator (10 mos)

Adhyayan (RTDC Club, IIT Patna)

Teaching (11 mos)

CELESTA, IIT Patna

Event Organizer (0 mo)

Education

Bachelor of Technology (B.Tech.) at Indian Institute of Technology, Patna

Selected in JEE-Advance at Vision classes, Kankarbagh Patna

High school at Adharsh Vikash Vidhalya, Patna

High School at Paramount Academy muzaffarpur , Bihar

Chaitanya Kumar

Business Analyst

Patna, Bihar, India8 yrs 11 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Improved campaign ROI by 20% through data-driven insights.
Reduced reporting turnaround time by 50% with automation.
Achieved 50% conversion increase through targeted PPC campaigns.

Stackforce AI infers this person is a Data Analyst specializing in Marketing Analytics and Business Intelligence.

Contact

chaitanya.kmr12@gmail.com LinkedIn

Skills

Core Skills

Data AnalysisData VisualizationOperations ManagementSales ManagementProject Management

Other Skills

VBA ExcelForecastingEnglishSQLDecision-MakingData ScienceAnalytical SupportWritten CommunicationPython (Programming Language)VLOOKUPPresentationsData EntryDashboard BuildingDatabasesReporting

About

Experience

8 yrs 11 mos

Total Experience

2 yrs 4 mos

Average Tenure

4 yrs 3 mos

Current Experience

Trainity

Data Analyst Training

Nov 2023 – Dec 2023 · 1 mo · Remote

> As a portfolio project, I examined hotel booking data across different franchises, identifying reasons for cancellations and providing insights to mitigate cancellations and enhance customer retention, resulting in a proper plan to reduce at least 15% of cancellations and increase customer retention by implementing personalized offers.
> Worked on a total of 8 live projects during the 8 weeks of training and completed all projects within the given time, which resulted in the proper utilization of findings.
> Project Link: https://drive.google.com/file/d/18XSDEt8wNcI-pk5j5bmENTC7KOniayZJ/view?usp=sharing

VBA ExcelForecastingEnglishDecision-MakingData ScienceAnalytical Support+26

Marine hardware syndicate

Data Analyst and Marketing Specialist

Feb 2022 – Present · 4 yrs 3 mos · Gandhidham, Gujarat, India · On-site

> Analyzed 5 years of sales data using Excel VLOOKUP and advanced features like Power Pivot to explore existing and past customers. trends.
> Applied data cleaning techniques from Pandas to ensure data integrity and accuracy for analysis purposes, increasing process efficiency by 50%.
> Utilized the data visualization techniques of Matplotlib and Seaborn to present findings and insights in a visually appealing and easily understandable manner, reducing process time by 50%.
> Used data analysis techniques to analyze the last 5 years sales data and identify the trends for each category of items, resulting in saving 15% of inventory space.
> Inventory management analysis and movement of hero product analysis resulted in saving 20% of capital and reduced average delivery time from 7 days to 3 days.
> Utilized the Python programming language to analyze Hero product sales data, identifying patterns and insights to enhance customer experience and drive sales growth by 5% to 7%.
> I managed social media content, engaged target audiences, and boosted reach with strategic ad placements for almost 500 products.
> Planned digital marketing strategies by creating and implementing plans to reach and engage target audiences within a time limit of 1 week.
> Optimized the product website to improve engine ranking, user experiences, and conversion rates, and worked with more than 500 products.
> Achieved a 50% conversion increase by creating pay-per-click campaigns for the product website.
> Did a comprehensive analysis of consumer behaviour and shopping habits, leading to the identification of key customer segments and a 15% improvement in targeted marketing campaigns.

VBA ExcelForecastingEnglishSQLDecision-MakingData Science+31

Hindustan petroleum corporation limited

2 roles

Operation officer Mundra Terminal

Apr 2021 – Jan 2022 · 9 mos · On-site

Develop effective solutions for challenging situations. Increased operation efficiency by 2%.
Within one month of joining, adapted to new situations.
Gained extensive knowledge in data entry, analysis and reporting within 6 months.

VBA ExcelEnglishContent Management Systems (CMS)Decision-MakingAnalytical SupportWritten Communication+21

LPG Sales Officer Siwan SA

Jul 2018 – Mar 2021 · 2 yrs 8 mos · On-site

Enhanced sales by 25% through the development of new sales strategies, lead generation, and direct client interaction.
Identified and qualified new distributors to increase market share in key territories by 2.5%.
Developed sales strategy based on research of consumer buying trends for FY 2018-2019 and market conditions and prepared 12-month sales reports with informative graphs and charts to outline key data.
Received the top performance award for 5 kg domestic sales in the fiscal year 2018-2019.

VBA ExcelCommunicationEnglishContent Management Systems (CMS)Decision-MakingAnalytical Support+27

Steel authority of india limited

Summer Intern Bhilai Steel Plant

May 2017 – Jul 2017 · 2 mos · Bhilai Area, India · On-site

Summer Internship at Bhilai Steel Plant (SAIL),
Project Mentor: K.K. Thakur (AGM, Foundry Shop).
Failure and remedial analysis of the roof of the Electric Arc Furnace at the Foundry Shop.
Fixed misalignment of electrodes w.r.t electrode holes by changing the design size.
Replacement of refractory bricks of the roof by castables for a higher lifetime.
Introduced AutoCAD and SolidWorks software, optimizing design workflows and accelerating project timelines by an impressive 20%, resulting in significant time and cost savings.
Promoted teamwork and achieved project milestones within 2.5 months ahead of schedule by working with cross-functional teams.

Microsoft ExcelTeamworkProblem SolvingSolidWorksPowerPointExcel Automation+1

Student council of mechanical engineering

Technical Head SCME

Aug 2016 – Apr 2017 · 8 mos · IIT Patna

SCME is a community run, managed and fostered by a group of Mechanical Engineering enthusiasts of IIT Patna.It look after all the technical events of IITP.

Microsoft ExcelTeamworkProblem SolvingSolidWorks

Rtdc club

Technical Coordinator

Jun 2016 – Apr 2017 · 10 mos · IIT Patna

Technical coordinator of mechanical engineering department of Indian Institute of Technology Patna

Microsoft Excel

Adhyayan (rtdc club, iit patna)

Teaching

Jan 2016 – Dec 2016 · 11 mos · Patna Area, India

Adhyayan is a social initiative started by one of my friend from Rural Technology Development Club (RTDC) IIT Patna . In this we are also going in primary school and teaching students.