Data Analyst with 3+ years in Business Intelligence & ETL
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Results-driven Data Analyst & MIS Specialist with 3+ years of end-to-end experience in dashboard development, MIS automation, ETL pipeline design, and business intelligence reporting within a high-stakes real estate finance environment. Proficient in Power BI, Advanced Excel (VBA, Power Query), Python (Pandas, NumPy), PostgreSQL/SQL, and DAX. Proven track record of reducing reporting cycle time by 40%, eliminating audit discrepancies, and delivering executive-ready financial insights. Strong domain expertise in KPI tracking, revenue forecasting, GST/TDS compliance automation, and data quality assurance. Seeking to bring analytical rigor and technical depth to a world-class data team.
Tilka Manjhi Bhagalpur University, Bhagalpur, Bihar
Bachelor of Commerce (B.Com) · Accounting & Finance
N/A – June 30, 2019
Vastu Vihar Real Estate Company
Data Analyst & MIS Specialist
March 1, 2023 – Present
Buddh Gaya, Bihar, India
Multi-Project Financial MIS Dashboard
March 1, 2023 – June 1, 2026
Consolidated P&L, cash flow, and cost data from 5+ real estate projects into a single interactive Power BI dashboard with drill-downs, slicers, and time-series visualizations. Replaced manual monthly reporting entirely - adopted as the primary decision-making tool for senior management, reviewed weekly. Reduced data aggregation time from 2 days to under 2 hours through automated ETL refresh pipelines.
KPI Sales Pipeline Tracker
March 1, 2023 – June 1, 2026
Built a stage-wise lead and sales tracker with automated follow-up alerts, conversion-rate formulas, and monthly KPI charts using Power Query and dynamic Excel arrays. Reduced missed follow-up incidents significantly; enabled sales management to monitor real-time pipeline health without manual intervention.
GST & TDS Compliance Automation
March 1, 2023 – June 1, 2026
Automated cross-verification of transaction data against GST and TDS compliance rules (Section 194-IA) using VBA Macros and nested cross-check formulas. Delivered zero tax documentation errors across all filing periods and saved 5+ hours per month in manual reconciliation effort.
Revenue & Receivables BI Report
March 1, 2023 – June 1, 2026
Developed an interactive BI dashboard with drill-down capabilities by project, buyer, and time period — used directly for revenue forecasting and collections management. Integrated PostgreSQL-sourced financial data through ETL transformations, ensuring clean, queryable datasets feeding real-time Power BI visuals.
Advanced Excel & Power BI
Self-directed professional learning
June 1, 2026 – Present
Python for Data Analysis (Pandas, NumPy, Data Cleaning)
Self-directed
June 1, 2026 – Present
PostgreSQL & SQL Querying
Self-directed professional learning
June 1, 2026 – Present
Tata GenAI-Powered Data Analytics Job Simulation
Forage (Tata Group)
January 1, 2024 – Present
Cultural Fit Analysis
The candidate's project diversity, focusing on financial MIS, sales tracking, and compliance automation, aligns well with a data-driven organizational culture. Their proactive approach to self-directed learning in Python, PostgreSQL, and advanced Excel/Power BI indicates a strong desire for continuous improvement and adaptability, which are positive cultural indicators. The experience in a real estate finance environment suggests a practical, results-oriented mindset.
Soft Skills & Operational Fit
The candidate demonstrates strong soft skills in stakeholder communication, executive reporting, cross-functional collaboration, and analytical problem-solving, which are crucial for a senior Data Analyst role. Their experience in partnering with finance, sales, and operations teams indicates good operational fit and ability to translate technical insights into business value. The candidate's remote-ready and quick technology adoption traits suggest adaptability.