00

Portfolio Chandigarh, India

VIKAS SHARMA

MIS Executive  ·  Data Automation Specialist  ·  Performance Marketer

Available for New Opportunities

Vikas Sharma

Transforming complex datasets into actionable business insights through advanced automation, AI-powered analytics, and intelligent dashboard solutions that drive organizational excellence and strategic decision-making.

0+Years Experience
0+Projects Delivered
0+Tools Mastered
Get In Touch
View LinkedIn
Download CV
GitHub
Vikas Sharma - MIS Executive Data Automation Specialist Chandigarh

Vikas Sharma

MIS Executive & Data Specialist

Data Analytics Automation Power BI Meta Ads
About Me

Professional Expertise

Delivering comprehensive data-driven solutions that empower organizations to make smarter, faster business decisions through automation, advanced analytics, and performance marketing

Advanced Data Analysis

Expert in transforming raw data into meaningful insights using Power BI, Excel, and AI-driven analytics tools. Specializing in comprehensive business intelligence solutions that drive strategic decision-making and improve operational efficiency by up to 40%.

Process Automation

Building intelligent workflows with Google Apps Script, n8n, and ERP systems to eliminate manual tasks, reduce errors by 85%, and boost operational efficiency. Proven track record of reducing reporting time from hours to minutes through smart automation.

Dashboard Development

Creating interactive, real-time dashboards and comprehensive reporting systems that provide actionable insights. Enabling data-driven decision-making across teams with visually compelling and intuitive analytics solutions that reduce analysis time by 60%.

Technical Skills

Core Competencies

Comprehensive expertise across modern data management, automation technologies, business intelligence platforms, and performance marketing

📊Data, MIS & Automation
Advanced Excel (Pivot Tables, Macros, VBA, Data Modeling)
Power BI (Basic Dashboards & Reporting)
Google Sheets & Apps Script Automation
AI-Driven Data Analysis & Reporting (Gemini API)
ERP Systems (Marg, Busy, E-Base 12)
Workflow Automation (n8n, Webhooks, APIs)
AI-Powered Automation (Apps Script & AI Integration)
Graphic Design & Business Presentation
📣Performance Marketing & Meta Ads
Meta Ads (Facebook & Instagram Ads)
Lead Generation Campaign Management
Performance Marketing & Campaign Optimization
Campaign Analytics & Reporting (CPL, CTR, ROAS)
Audience Targeting & Optimization
Data-Driven Marketing (MIS + Ads Integration)
Key Projects

Featured Work

Highlighting impactful automation, analytics, and performance marketing solutions that delivered measurable business results

⭐ Flagship

Godown Dispatch Portal

Cloud Warehouse Ops · Ultrapolis Lifescience

Cloud-based warehouse portal that fully automates the daily dispatch workflow — from picking to dispatch — with real-time Google Sheets sync, eliminating all paperwork.

Picker→ Auditor→ Packing→ TSS→ Dispatch
  • PIN-based role login per stage
  • Live TV Mode floor dashboard
  • SLA breach auto-alerts
  • Rework & accuracy logging
  • KPI CSV export by date range
  • ScriptLock concurrency control
Apps Script V8Sheets API ScriptLockPIN Auth TV ModeSLA Tracking

Call Recording QA System

AI-Powered Quality Assurance

AI-powered call QA system using Gemini API. Auto-fetches recordings from Drive, generates structured feedback reports — reducing QA review time by 70%.

Apps ScriptGemini APIGoogle DriveAutomation
🏢 Enterprise

Recruitment Flow System

11-Step HR Pipeline · Google Workspace

Real-time enterprise HR tracking app — automates 11 hiring steps from JD creation to onboarding. Full audit trail, zero email chaos, role-based access for Admin & HR.

JD→ Approval→ Screen→ Interview→ Offer→ Join
  • Admin vs HR role-based PIN auth
  • Planned vs Actual delay auto-calc
  • Auto-polling refresh every 6 sec
  • 52-col schema, 4 cols per step
  • LockService concurrent write-guard
  • Dept-wise KPI live dashboard
Apps Script V8LockService PropertiesServiceAuto-Poll Role Auth52-Col DB

Meta Ads Lead Generation

Performance Marketing Campaigns

End-to-end Meta Ads campaigns with audience segmentation, A/B testing, and MIS-integrated performance tracking — significantly reducing CPL with automated WhatsApp follow-up.

Meta AdsExcelSheetsWhatsApp API

Lead Qualification Workflow

Healthcare Sales Automation

n8n-based WhatsApp automation for healthcare prospect screening. Multi-criteria lead scoring with automated follow-up — boosted conversions by 45%.

n8nWhatsApp APISheetsWebhooks

Task Management System

Team Coordination Platform

Multi-sheet task tracker with conditional formatting, auto row-hiding on completion, and real-time user access tracking across the team.

Google SheetsApps ScriptAutomation

Flow Management Tracker

Performance Monitoring System

Real-time accuracy and productivity tracker — monitors correct vs incorrect work completion with time-based analysis to ensure quality delivery.

Google SheetsApps ScriptAnalytics
Career Journey

Professional Experience

Progressive growth in data management, automation, performance marketing, and business intelligence with proven results

May 2025 – Present

Ultrapolis Lifescience Pvt. Ltd.

MIS Executive

Leading comprehensive data operations and business intelligence for a growing pharmaceutical company — from automated reporting and AI-powered dashboards to performance marketing and lead generation campaigns.

Key Responsibilities

  • Manage and analyze business data (sales, purchase, stock, and leads) to generate structured MIS reports for strategic decision-making
  • Develop automated reporting systems using Microsoft Excel and Google Sheets, improving efficiency and data accuracy
  • Design and implement AI-enabled automation workflows using Google Apps Script to streamline reporting, date validation, financial year tracking, and operational processes
  • Build interactive KPI dashboards in Power BI and Looker Studio for performance monitoring and trend analysis
  • Plan and execute lead generation campaigns through Meta Ads Manager, optimizing based on CPL, CTR, and conversion performance
  • Create automated lead tracking and WhatsApp follow-up systems integrating ad data with Sheets for faster response and improved conversion rates
  • Maintain pharmaceutical product master data including pricing models, GST calculations, margin analysis, and inventory performance tracking
Jul 2024 – Apr 2025

Himalayan Solar Ltd.

MIS Executive

Designed and implemented automated reporting and data management systems for a solar energy company, driving data visibility and operational efficiency.

Key Responsibilities

  • Data Analysis & Reporting: Utilized Advanced Excel, Google Sheets, and AI tools to analyze and visualize data for decision-making
  • Automation & Optimization: Implemented AI-driven data automation techniques to enhance operational efficiency
  • Dashboard Management: Developed and maintained interactive dashboards for real-time performance tracking
  • Data Accuracy & Maintenance: Ensured proper data validation, cleansing, and structuring for reporting
Jun 2023 – Jun 2024

Tiranga Express Govt-Tender

MIS Executive

Managed government tender data operations, leveraging AI-powered tools and automation to ensure data accuracy and efficient billing processes.

Key Responsibilities

  • Data Handling: Managed large datasets in Excel and Google Forms with high accuracy
  • AI-Assisted Reporting: Used AI-powered tools to generate comprehensive reports and insights
  • Billing & Documentation: Created automated billing documents to streamline government tender processes
May 2020 – Jun 2023

Macleods Pharma C&F

Computer Operator

Managed ERP operations and data management for pharmaceutical distribution, handling billing, inventory, and transport coordination.

Key Responsibilities

  • ERP & Software Management: Worked on Marg ERP, Busy ERP, and E-Base 12 ERP systems
  • Billing & Data Entry: Managed billing, credit/debit notes, and expiry data with high accuracy
  • Logistics & Transportation: Coordinated transportation schedules using 1Order.com
Impact

Achievements & Impact

Quantifiable results delivering measurable business value across organizations

0

Time Saved Through Automation

0

Efficiency Improvement

0

Data Accuracy Rate

0

Projects Completed

Resume

My Resume

Download my resume to know more about my experience, skills, and projects

Vikas Sharma — Resume

MIS Executive & Data Automation Specialist

6+ Years Experience 13+ Skills 6 Key Projects
Download PDF View Online
Let's Connect

Get In Touch

Ready to discuss how I can help optimize your data processes and drive business growth through automation, analytics, and performance marketing

Contact Information

Full Name

Vikas Sharma

Location

Chandigarh, India

Core Strengths

  • Expert in MIS reporting and dashboard creation
  • Advanced data analysis and visualization skills
  • Process automation and workflow optimization
  • Meta Ads campaign management & lead generation
  • Performance marketing with data-driven optimization
  • Proficient in multiple ERP systems
  • AI-powered analytics implementation
  • Strong analytical and problem-solving abilities
  • Excellent communication and presentation skills
  • Proven track record of delivering measurable results

Send a Message

Koi bhi query ho — project, collaboration, ya job opportunity — seedha message karo. Response milega! 🚀

Ready to Optimize Your Data Operations?

Let's discuss how automation, analytics, and performance marketing can transform your business

Start a Conversation