Kumar Prashant Viraj
Kumar Prashant Viraj
Digital Transformation Analyst · Digital Marketer

Kumar Prashant Viraj

I turn manual reporting, billing and HR work into automated systems, and I run SEO, Meta Ads and analytics that bring in measurable leads. One year of freelance marketing, plus a full-time analyst role at Indigo Catering and Services.

EmailPrashantviraj002@gmail.com
LinkedInlinkedin.com/in/kumar-prashant-viraj-518371265/
GitHubgithub.com/VIRAJPRASHANT001
LocationRanchi , India
Experience

Two roles, one thread: better numbers, less manual work

Digital Transformation Analyst

Indigo Catering and Services · May 2024 to June 2026

Business process automation, reporting and HR systems

  • Digitised the KRA and KPI calculation and collection process, replacing manual sheets with a structured, automated flow.
  • Built dashboards for accounting and sales reporting so managers read one source instead of chasing files.
  • Automated billing, and set up HRMS workflows covering employee records, files and onboarding.

Freelance Digital Marketer

May 2023 to August 2024 · 1+ year

Independent, for small and mid-size businesses

  • Delivered SEO, Meta Ads and other paid campaigns, social media management, website work and analytics setup.
  • Tracked results through GA4 and Google Tag Manager so each rupee of ad spend could be tied to leads or sales.
Selected work · Indigo Catering and Services

Digital transformation case studies

Reporting

KRA and KPI tracking system

Problem
KRA and KPI figures were collected and calculated by hand, so reports arrived late and numbers were hard to verify.
Approach
Defined each KPI and its formula, built one collection flow for inputs, and automated the scoring and roll-ups.
Tools
Google Workspace, Google Apps Script, Power automate , Power Apps , Sharepoint , Lists
Result
- Report time cut from 7 days to 1 hours
- Reporting got smoother & managements gets the realtime report
Dashboards

Accounting and sales reporting dashboards

Problem
Accounting and sales data lived in separate files, which made month-end reviews slow.
Approach
Consolidated the data into one model and built dashboards for revenue, collections and sales performance.
Tools
Power BI, Excel, Tally Prime API , Sharepoint edit to match what you used
Result
- consolidated Reports in one place at least 10 number of reports replaced,
- review time saved
Automation

Billing automation

Problem
Invoices were prepared manually, which cost time and allowed errors.
Approach
Automated invoice generation from source data with checks before an invoice goes out.
Tools
Sharepoint list, Power Automate, Approvals ,teams.
Result
- 50+ invoices generated per month, errors reduced by 80%
HRMS

HRMS automation and employee onboarding

Problem
Employee records and onboarding documents were scattered across folders and handled step by step by hand.
Approach
Created a central employee record system with an onboarding workflow that collects, stores and files documents automatically.
Tools
Google Apps Script, Python, SharePoint, Power Platform
Result
- Onboarding time per employee reduced by 60%
- Improved data accuracy and compliance
Freelance · 1 year

Digital marketing services

SEO

Keyword research, on-page fixes, technical checks and content planning for local and service businesses.

Meta Ads

Facebook and Instagram campaigns built around lead and sales goals, with creative and audience testing.

Paid campaigns

Search and display campaign setup, budgeting and weekly optimisation.

Social media

Content calendars, posting and community management across brand channels.

Analytics

GA4 and Google Tag Manager setup, conversion tracking and clear monthly reports.

Websites

Fast, mobile-friendly sites and landing pages built to turn visits into enquiries.

Freelance projects

INDIGO CATERING AND SERVICES PVT. LTD.

Managed SEO and social media campaigns for a PAN India catering business, resulting in a 40% increase in online visibility and a 25% boost in bookings.

BN SINGH ASSOCIATES

Managed Meta Ads campaigns for a local real estate & Debt Recovery agency, resulting in a 30% increase in lead generation and a 20% reduction in cost per acquisition.

Eylex Cinemas

Managed social media and digital advertising campaigns for a regional cinema chain, resulting in a 25% increase in ticket sales and a 30% boost in online engagement.

Skills

Tools and methods

Marketing

SEO, Meta Ads, paid campaigns, social media, GA4, Google Tag Manager

Automation

Google Apps Script, Microsoft Power Platform, workflow automation, Excel automation

Data and BI

Power BI, SQL, Python, KPI design, dashboards

Business systems

ERP, HRMS, Tally Prime, SharePoint, Google Workspace

Development

JavaScript, HTML, CSS, Node.js, React, Bootstrap, Firebase, Git and GitHub

Learning now

Machine learning, advanced Python, cloud architecture, DevOps, Email marketing , Google Ads , UTM Parameters and Analytics