BI dashboards
Power BI and QlikView views for sales, profitability, regional growth and management reviews, built with DAX and clean data models.
- Power BI
- DAX
- QlikView
Open to connect, collaborate and grow IST
Operations, measured. Reporting, automated.
Data analyst, automation builder, freelancer and mentor. Power BI dashboards, Excel VBA tools, web apps, chatbots and workflow automation for real teams.
Power BIPythonSQL
CurrentlySr. Executive Data Analyst
SL Fasteners, Sonipat · Feb 2026 to now
SL Fasteners, Sonipat · Feb 2026 to now
Profile
I turn scattered operations data into the dashboards leadership reads and the automations that replace manual reporting. Five years across manufacturing, exports, automotive retail and e-commerce. Outside work I build websites, inventory systems and chatbots for freelance clients, create content on YouTube, and mentor young people toward their first jobs.
5+Years in industry
4Companies
12Certifications
6Featured projects
What I build
Systems that make the numbers trustworthy and the work faster.
Excel, VBA and flow automation
Macros, Power Automate and SharePoint flows, Google Apps Script. Weekly and monthly reports that build themselves.
- VBA
- Power Automate
- Apps Script
Python and SQL pipelines
Cleaning, joins, stored procedures and forecasting with pandas and NumPy. One version of the truth for every report.
- Python
- SQL
- Pandas
AI-assisted workflows
Prompt engineering and Gemini for Workspace applied to reporting, documentation and routine operations work.
- Generative AI
- Prompting
- Gemini
HR and payroll systems
HRMIS databases, attendance, payroll sheets, ESIC and PF compliance, onboarding and audit-ready reporting.
- HRMIS
- Payroll
- Compliance
Marketing, e-commerce and warehouse analytics
CPA, ROAS and attribution tracking. Stock turns, reorder logic and shift reporting for factories and warehouses.
- ROAS
- Inventory
- MIS
Builder · Freelancer · Creator · Mentor
More than a job: I build, ship and mentor.
Alongside my analyst role I take on freelance projects, create content and guide young people toward their first jobs.
I build
Websites and portfolios, inventory management systems in Excel and as web apps, report automation and tools that remove manual work.
- Websites
- Portfolios
- Inventory systems
- Web app reports
I freelance
Chatbots, workflow automation, digital marketing, lead generation and paid ad campaigns for small businesses and teams.
- Chatbots
- Workflow automation
- Lead generation
- Running ads
I create
I make tutorials and project walkthroughs as Rulerbyte and Aakash Analyst on YouTube and Instagram, and share what I learn in public.
- YouTube
- Tutorials
I guide
I have guided many young people on careers, helped them get jobs and become self-dependent. If you are starting out, let's talk.
- Career guidance
- Job preparation
- Mentoring
Experience
Four roles, one thread: data that operations can act on.
Feb 2026 to present · SonipatCurrent
Sr. Executive Data Analyst
SL Fasteners Pvt Ltd (State Enterprises)
- Resolve data issues with cross-functional teams and improve workflow.
- Roll out Excel 365, Power Automate and SharePoint solutions across departments.
- Design reports for Management Review Meetings.
Jan 2025 to Jan 2026 · Sonipat
MIS Analyst
Manohar Filaments Pvt. Ltd.
- Built advanced Excel formats that automated recurring reports.
- Produced weekly and monthly reports for senior management.
- Handled data modeling and visualization in Power BI.
- Represented MIS in process reviews and audits; supported sustainability tracking.
Aug 2022 to Dec 2024 · Sonipat
Senior Executive, HR and Systems
Padia Exports Pvt. Ltd.
- Ran the HRMIS site and secure employee databases.
- Managed payroll, attendance, ESIC and PF compliance.
- Handled onboarding, exits, training and audit reports in Google Sheets.
Jan 2020 to Aug 2022 · Bahalgarh
Electronic Data Processing Head
PP Automotive Mahindra
- Managed bookings and invoices in Salesforce; tracked inventory in DMS.
- Built QlikView dashboards for sales analysis.
- Maintained ETBR (enquiry, test drive, booking, retail) MIS reports.
Selected work
Dashboards, apps and videos.
Voice AI · Desktop HUD
BYTE Cognitive HUD
Voice-driven assistant dashboard with a holographic globe, 3D solar-system orbits, live system telemetry and Gemini / ChatGPT query consoles.
Website · Logistics
A Group Logistics Solution
Business website for a packing and moving company: services, about, pricing highlights and a contact form.
Power BI
E-commerce Sales Dashboard
Sales by state, quantity by category and payment mode, profit by month and sub-category, with quarter slicers.
Power BI · HR analytics
HR Analytics Dashboard
Attrition by department, salary slab, gender and experience, plus job-satisfaction matrix and age-group distribution.
Excel dashboard
Amazon Sales Dashboard 2024
Sales, units and city coverage KPIs, city-wise trend, state-wise map and product-wise units funnel.
Power BI · Risk
Credit Card Customer Report
Revenue, interest and income by gender, age, state, salary, education and card tier, with quarter filters.
Excel dashboard
DMart Sales Dashboard 2024
Category, region, ship-mode, segment and sub-category sales with timeline and state slicers.
Web app
Compound Interest Calculator
SIP and wealth-growth simulator with sliders for amount, rate and duration, live KPIs and a growth chart.
Excel VBA automation
VBA Automation Suite
Excel report to PDF export. Shipment tracking form that saves each entry into master data. BOM filling form.
Web development
Zomato Frontend Clone
Responsive food-ordering interface with flexbox layouts, overlay cards and validation scripts.
Watch the walkthrough on YouTube ↗
Web development
Book-Selling Site and HTML Quiz
An e-commerce book-selling website and an interactive HTML quiz.
YouTube
Rulerbyte
Tutorials on spreadsheet macros, Python data scripts, database cleanups and automated reporting.
Visit the channel ↗
YouTube
Aakash Analyst
Data analytics, Power BI and MIS content from real project work.
Visit the channel ↗Showreel
Meet the person behind the numbers.
10 sec · AI-generated intro made with Gemini · tap to play with sound
How I work
From messy sheets to a working system.
- 01
Discover
Map the manual steps, owners and the decisions the numbers must support.
- 02
Model
Clean and structure data in SQL, Excel or Python so there is one source of truth.
- 03
Automate
Build the dashboards, macros and scheduled flows that replace repeat work.
- 04
Hand over
Document the system and train the team to run it.
Credentials
Twelve certifications, Oracle to Duke.
Beyond the day job
I teach what I build on YouTube and Instagram.
Spreadsheet macros, Python data scripts, Power BI dashboards and automated reporting, explained step by step.
Contact
Let's connect and grow together.
+91 90509 96163 · Sonipat, Haryana 131001