Amitosh Kumar
Delhi
Summary
Proven Business Intelligence Analyst with a track record of enhancing business efficiency by 30% through optimized SQL queries and BI reporting processes at tbo.com. Expert in BI model development and dashboard creation, I excel in translating complex data into actionable insights. Collaborative and results-oriented, I leverage Apache Spark and SQL programming to drive decision-making and business performance.
Overview
6
6
years of professional experience
Work History
Business Intelligence Analyst
tbo.com
Gurugram
08.2021 - Current
- Generated daily, monthly and annual reports to address short- or long-term business intelligence questions.
- Designed and developed a comprehensive 10-page dashboard in Power BI, incorporating SQL-based data queries and visualizations. The dashboard provides detailed monthly, weekly, and daily financial analysis, including key metrics such as net revenue margin, gross margin, and other key performance indicators (KPIs).
- Designed and maintained automated reporting systems that provided real-time insights into business performance across multiple departments.
- Optimized SQL queries and BI reporting processes, resulting in a 30% reduction in report generation time, and improved data processing efficiency.
- Conducted regular review meetings with business units to gather feedback and refine BI reports and dashboards based on evolving business needs.
- Collaborated with data scientists, analysts, and business stakeholders to understand data requirements and ensure efficient ETL design.
- Worked closely with the data architecture team to design and implement scalable data pipeline architectures to handle increasing data volumes.
Data Analyst
Bence energy pvt ltd
Ghaziabad
01.2019 - 07.2021
- Built visualizations that enabled users to quickly interpret results from complex analyses.
- Worked with internal teams to understand business needs and changing strategies.
- Prepared detailed reports by collecting, analyzing, and summarizing information and trends.
- Performed data entry, data cleaning, and data coding for analysis.
- Identified needs of customers promptly and efficiently.
- Translated raw data into meaningful information using statistical techniques.
- Collected, tracked and reviewed data to evaluate business and market trends.
Education
Bachelor of Technology - Electrical And Electronics Engineering
Dev Bhoomi Institute of Technology
Dehradun06-2015
Skills
- BI model development
- SQL programming
- Dashboard creation
- Database management
- Apache Spark
- BI tools expertise
- NoSQL databases
- ETL development
- Business efficiency improvement
Timeline
Business Intelligence Analyst
tbo.com
08.2021 - Current
Data Analyst
Bence energy pvt ltd
01.2019 - 07.2021
Bachelor of Technology - Electrical And Electronics Engineering
Dev Bhoomi Institute of Technology
Similar Profiles
Malay NaithaniMalay Naithani
Head Sales North India at TBO.COMHead Sales North India at TBO.COM
Muhammad EbadMuhammad Ebad
Assistant Sales Manager at TBO.COMAssistant Sales Manager at TBO.COM
Mayank AhujaMayank Ahuja
Associate Director at TBO.COMAssociate Director at TBO.COM