Loading Portfolio…
HARISH AMEER · MIS ANALYST
📊 MIS Analyst @ Credgenics⚡ Excel VBA Expert 📈 Power BI Specialist☁ AWS Cloud Practitioner 🗄 SQL Certified · HackerRank🤖 AI Tools Enthusiast 📊 MIS Analyst @ Credgenics⚡ Excel VBA Expert 📈 Power BI Specialist☁ AWS Cloud Practitioner 🗄 SQL Certified · HackerRank🤖 AI Tools Enthusiast
Delhi, INDIA --:--:--
MIS Analyst · Data Specialist · Excel Automation Expert
HARISH
AMEER
Turning raw data into decisions that matter

Excel wizard. Dashboard architect. Process automator. I transform messy spreadsheets into powerful, real-time intelligence systems — reducing reporting time by up to 50%.

Harish Ameer
MIS ANALYST · Delhi
0
Years Experience
0
Companies Worked
50%
Reporting Time Saved
0
Tools Mastered
0
Certifications
01 / ABOUT
WHO I AM

I'm Harish Ameer, a data-driven professional with expertise in MIS operations, client servicing, and advanced Excel automation. Based in Delhi, I specialize in building systems that make organizations smarter and faster.

Currently at Credgenics as MIS Analyst since January 2025 — architecting the company's reporting backbone and delivering automated dashboards that give leadership a real-time pulse on every KPI that matters.

My background spans HR payroll processing, client data management, Power BI visualization, and Google Workspace automation. I bring a rare mix of analytical precision and people skills.

Name
Harish Ameer
Role
MIS Analyst @ Credgenics
Location
Delhi, Delhi, India
Languages
Hindi, English
Status
● Employed @ Credgenics
02 / SKILLS
WHAT I KNOW
Data & Analytics
Microsoft Excel / VBA95%
Google Sheets / Apps Script90%
Power BI80%
SQL (Intermediate)75%
Data Visualization88%
MIS & Operations
Dashboard Creation92%
Report Generation95%
Payroll / HR Operations85%
Data Management90%
Process Automation87%
Tools & Technologies
Microsoft ExcelVBA Macros Google SheetsApps Script Power BISQL Pivot TablesPower Query Dashboard DesignReport Automation ChatGPT / AI ToolsAWS Cloud CTC StructuringPayroll Processing MIS ReportingData Modeling
03 / EXPERIENCE
WHERE I'VE WORKED
JAN 2025
PRESENT
Current
Credgenics
MIS Analyst
  • Driving end-to-end MIS operations — collecting, structuring, and analysing business data to support strategic decision-making across all teams.
  • Building and maintaining live analytical dashboards giving leadership a real-time pulse on KPIs, sales metrics, and operational performance.
  • Designing automated data pipelines that replace repetitive manual reporting — saving hours of effort every week.
  • Applying advanced Excel — dynamic arrays, Power Query, conditional macros — to transform raw exports into clean, actionable reports.
  • Championing a data-first culture by standardising reporting templates and training team members on best practices.
🚀 Building Credgenics' data backbone from the ground up
JUL 2024
JAN 2025
DKC Exports
MIS Executive
  • Expert in Advanced Excel: dashboards, pivot tables, macros, and full automation using VBA.
  • Automated workflows in Google Sheets using Apps Script, reducing manual tasks significantly.
  • Created real-time dashboards and scheduled reports with automated email triggers.
  • Migrated Excel processes to Google Sheets for better cross-team collaboration.
⚡ Reduced reporting time by 50% through efficient automation
JAN 2024
JUN 2024
Easy Source HR Pvt. Solutions
Executive — Client Servicing
  • Handled complete CTC structuring, gross salary computation, payroll cycles, and TDS certificates.
  • Managed attendance sheets, overtime & leave records, mediclaim, and full & final settlements.
  • Established data collection protocols for high-profile clients; updated all Master data records.
04 / EDUCATION
MY ACADEMIA
🏫
2020 — 2023
BSc (PMCs)
MGS University · Bachelor's in Science
📚
2019 — 2020
Science (XII)
Sun Bright School · Higher Secondary
🏫
2017 — 2018
Intermediate (X)
Sun Bright School · Secondary Education
05 / CERTIFICATES
PROOF OF SKILLS
🏆
SQL — Intermediate
HackerRank · Verified Certification
AWS Cloud Practitioner (CCP)
Udemy · Cloud Fundamentals
📊
Data Analyst Certification
Udemy · Full Data Analysis Course
📈
Advanced Excel Certification
IICS · Macros, Pivot, VBA, Dashboards
06 / PROJECTS
WHAT I'VE BUILT
PROJECT 01
Credgenics
Analytics Hub
Current ●
Architecting a centralised MIS reporting system at Credgenics — connecting sales, ops, and finance into a single source of truth with automated daily/weekly reports to leadership.
ExcelPower QueryAutomationKPI Tracking
PROJECT 02
Real-Time Export
MIS Dashboard
Excel + VBA
Automated MIS dashboard for DKC Exports tracking shipments, orders, and inventory in real-time with scheduled email reports and embedded charts triggered automatically.
ExcelVBAPivot TablesCharts
PROJECT 03
HR Payroll
Automation System
Google Sheets
Complete payroll system with auto-calculated salary slips, TDS computation, attendance tracking, and automated email distribution to employees via Apps Script.
Google SheetsApps ScriptGmail API
PROJECT 04
Client Data
Analytics Portal
Power BI
Interactive Power BI dashboards for client performance metrics, enabling data-driven hiring and cost optimization decisions in real time.
Power BIDAXSQLData Modeling
07 / BEYOND THE DATA
THE HUMAN BEHIND
🔥
WHAT DRIVES ME
Obsessed with turning messy, unstructured data into clean systems. There's something deeply satisfying about watching a 3-hour manual process collapse into a 3-second automated click.
🌙
OUTSIDE WORK
When not building dashboards, you'll find me exploring new AI tools, watching tech breakdowns on YouTube, or deep-diving into productivity systems. Every tool mastered is a superpower added.
💡
MY PHILOSOPHY
Data without context is just noise. Every number tells a story — you just need to ask the right questions. My job isn't just to report what happened, but to explain why and what to do next.
harish@portfolio:~$ cat fun_facts.txt
Started learning Excel to solve one boring task — now it's a superpower driving company-wide decisions.
Holds a HackerRank SQL badge — because data in tables is just a spreadsheet that went to university.
Bridged BSc Science to Data Analytics — curiosity is the best career counsellor anyone can have.
Earned AWS Cloud Practitioner cert — future-proofing skills because the cloud isn't going anywhere.
From HR payroll to export MIS to SaaS analytics — thrives in fast-changing, high-stakes environments.
Believes the best dashboard is one your CEO reads in 10 seconds flat — clarity beats complexity.
08 / CONTACT
LET'S WORK
TOGETHER

Whether you need a data analyst, MIS executive, or Excel automation expert — I'm ready to contribute. Let's build something great.

SEND A MESSAGE
Designed & coded with ❤  ·  Harish Ameer © 2025  ·  haris1731.github.io