SANTOSH KUMAR MISHRA
Bangalore,
Summary
Data Analyst and Power BI Developer with over 5 years of experience delivering financial and business operations analytics solutions using Power BI, SQL, Python, and Excel. Expertise in transforming complex datasets into strategic insights, enhancing decision-making, operational efficiency, and financial reporting. Skilled in data modeling, ETL pipeline development, and DAX optimization.
Overview
5
5
years of professional experience
Work History
Data Analyst
Globestar Software Limited
Bangalore
06.2024 - Current
- Developed complex SQL queries for analyzing large datasets, reducing data analysis time by 30% while extracting actionable trends and insights.
- Created Power BI dashboards delivering real-time business intelligence insights, reducing manual reporting effort by 40%.
- Optimized database design and queries to enhance performance of analytics operations.
- Designed and implemented ETL processes for seamless data integration from multiple sources.
- Conducted statistical analyses on customer data to uncover patterns and correlations.
- Applied predictive analysis techniques on historical customer data to identify behavior trends.
- Collaborated with cross-functional teams to improve accuracy of data reporting.
- Provided technical support for existing reports and dashboards, ensuring reliability.
Power BI Developer
DNA GROWTH Pvt.Ltd.
Bangalore
04.2023 - 05.2024
- Developed interactive financial dashboards, including Income Statement, Balance Sheet, and Cash Flow.
- Implemented forecasting models to enhance budgeting and strategic planning.
- Automated data refresh and transformation processes for accurate reporting.
- Optimized DAX calculations and Power Query logic to increase report efficiency.
- Analyzed construction project costs and revenues to ensure budget accuracy.
- Produced executive-ready reports for finance and leadership teams.
Data Analyst
Keeno Technology
Bangalore
12.2020 - 04.2023
- Created sales performance dashboards to track revenue, growth, and KPIs.
- Integrated data from Altiris, SCCM, CMDB, ServiceNow, and Excel for comprehensive analytics.
- Implemented regional, product, and time filters to facilitate self-service analytics.
- Developed automated reporting pipelines, significantly reducing manual effort.
- Ensured high data quality through rigorous validation and cleansing processes.
- Collaborated with sales and management teams to generate insights aligned with business objectives.
Education
Bachelor of Computer Applications (BCA) -
Jamia Hamdard University
New DelhiSkills
- SQL (Complex Queries, CTEs, Window Functions)
- Power BI (DAX, Power Query, Data Modeling)
- Python (ETL, EDA)
- Excel (Advanced formulas, Pivot Tables)
- Data validation and cleaning
- Business and financial analytics
Accomplishments
Implemented a Power BI solution for a manufacturing client, reducing manual reporting time by 40%.
Delivered cross-functional analytics solutions that improved operational efficiency by 50%.
Reduced data processing time by 30% through query and model optimization.
Delivered cross-functional analytics solutions that improved operational efficiency by 50%.
Reduced data processing time by 30% through query and model optimization.
Languages
- Hindi, Native
- English, Proficient
Timeline
Data Analyst
Globestar Software Limited
06.2024 - Current
Power BI Developer
DNA GROWTH Pvt.Ltd.
04.2023 - 05.2024
Data Analyst
Keeno Technology
12.2020 - 04.2023
Bachelor of Computer Applications (BCA) -
Jamia Hamdard University