
Senior Data Analysis with 1+ years in BI, ETL, and Data Analytics
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
MIS Executive & Data Analyst - Skilled in building BI dashboards, automating ETL pipelines with SSIS, and delivering daily data reports to branches and head office. Currently leading the company's migration from Looker Studio to Power BI at Marwadi Shares and Finance Ltd. Certified by IBM, Microsoft, and Cisco. Strong hands-on experience with SQL, Python, Power BI, Looker Studio, SSIS, and multi-database environments.
Manipal University, Jaipur
M.B.A in Business Analysis · Business Analysis
July 1, 2025 – Present
Atmiya University, Rajkot
B.Tech · Computer Engineering
N/A – January 1, 2025
Tapan Science School, Rajkot
H.S.C · Science
N/A – May 31, 2021
Tapovan School, Rajkot
S.S.C
N/A – May 31, 2019
Marwadi Shares and Finance Ltd.
MIS Executive
June 1, 2025 – Present
Rajkot, Gujarat, India
Marwadi Shares and Finance Ltd.
Data Analyst Intern
February 1, 2025 – May 1, 2025
Rajkot, Gujarat, India
Intern Career
Data Analysis Intern
February 1, 2024 – March 1, 2024
India
Client Onboarding & Deboarding Journey Dashboard
January 1, 2026 – Present
Independently designed and built an advanced Power BI dashboard tracking the complete client account lifecycle — opening, active status, and closure — across all branches and channels, connected live to the production SQL database. Engineered an SSIS package for full ETL automation — extraction, cleansing, type normalization, and loading — then scheduled it via Windows Task Scheduler for zero-intervention daily execution. Surfaced key KPIs (Open Accounts, Closed Accounts, Total Active Clients) with drilldown by Channel ID, Channel Type, Cluster Head, and Account Category; included Open/Close Ratio donut charts and a Month-Wise line chart for trend analysis. Included an Age-Wise Accounts Breakup table (Under 18 → 60+) and Top 10 Channels by Open Accounts bar chart, providing branch managers with actionable segmentation insights across FY 2025-26.
Monthly Brokerage Analysis FY Dashboard
September 1, 2025 – Present
Built a comprehensive FY-wise monthly brokerage dashboard consolidating turnover, brokerage earnings, and channel-wise performance with modules covering Month-Wise Brokerage, Segment-Wise Turnover, and Channel-Wise Earning %. Integrated dynamic filters (Channel ID, Channel Name, Month, Date Range) enabling management to isolate performance across two fiscal years (FY 25-26 and FY 26-27) for YoY seasonality analysis. Connected live multi-table SQL databases as data sources, ensuring report values stay synchronized with the operational data warehouse without manual refreshes.
Daily Brokerage Analysis Dashboard (FY-Wise)
June 1, 2025 – Present
Designed and deployed a FY-wise B2B brokerage analysis dashboard in Looker Studio tracking three core KPIs — Total Turnover, Total Brokerage, and Brokerage Yield — updated daily with live data for senior management. Built interactive Month-Wise Brokerage Breakup bar chart and Segment-Wise Earning donut chart (Cash, FO, Commodity, SLB) for period-over-period and granular profitability analysis. Configured automated daily report sharing with 100+ branch managers, APs, and head office stakeholders with multi-level filters (Segment, Channel ID, Month, Date Range) for self-serve drill-downs.
Data Analysis with Python
IBM
June 1, 2026 – Present
Data Analytics Essentials
Cisco
June 1, 2026 – Present
Data Analysis & Visualization with Power BI
Microsoft
June 1, 2026 – Present
SQL for Data Science
Great Learning Academy
June 1, 2026 – Present
Tableau Workshop
Jobaaj Learnings
June 1, 2026 – Present
Cultural Fit Analysis
The candidate's project diversity, ranging from brokerage analysis to client lifecycle tracking and global terrorism data visualization, shows a broad interest in applying data analysis skills across different domains. The current role as an MIS Executive and the target role of Senior Data Analysis align well, indicating a clear career progression path. The certifications in various data analysis tools and techniques further demonstrate a commitment to continuous learning and skill development, which is a positive cultural indicator. However, the experience is heavily concentrated in one company, which might suggest less exposure to diverse organizational cultures.
Soft Skills & Operational Fit
The candidate's experience in coordinating with cross-functional teams (IT, operations, compliance) to resolve data discrepancies and deliver reporting requirements indicates good collaboration and operational fit. Leading a migration project from Looker Studio to Power BI also suggests strong project ownership and adaptability. The detailed project descriptions highlight a proactive approach to problem-solving and a focus on delivering actionable insights to management.