BANALA MAHESH

Data Analyst

https://www.opentalent.in/banala-mahesh

Data Analyst with less than a year in SQL & Power BI

Key Strengths

Strong foundational knowledge in SQL, including advanced querying, optimization, and database design (3NF).
Proficiency in Power BI for dashboard development, DAX measures, Power Query, and KPI reporting.
Experience with ETL pipeline development and data transformation.
Demonstrated ability in exploratory data analysis (EDA) and data storytelling.
Relevant certifications from Cisco, Microsoft, and other industry organizations.
Project experience directly aligns with Data Analyst responsibilities.

Cultural & Operational Fit

Cultural Fit Analysis

The candidate's project diversity, covering both BI dashboard development and relational database design, shows a broad interest in data analytics domains. The numerous certifications from various organizations (Cisco, Microsoft, JPMorgan Chase, TCS) indicate a proactive learning attitude and a desire to continuously improve, which aligns well with a culture of continuous development. The focus on problem-solving and stakeholder communication in project descriptions suggests a team-oriented and business-value-driven mindset.

Soft Skills & Operational Fit

The candidate highlights soft skills such as Analytical Thinking, Problem-Solving, Adaptability, Quick Learning, Attention to Detail, Data Storytelling, Stakeholder Communication, and Team Collaboration. These are crucial for a Data Analyst role, indicating a good operational fit for roles requiring both technical execution and cross-functional interaction. The project descriptions demonstrate practical application of these skills, particularly in stakeholder reporting and data storytelling.

AI is analyzing your overall score…

Identifying your key strengths…

Evaluating your skill match against the job requirements…

Assessing your cultural and operational fit

About

Results-driven Data Analyst with hands-on expertise in SQL, Python (Pandas, NumPy), and Power BI (DAX, Power Query), delivering end-to-end analytics solutions from ETL pipeline development and relational database design to interactive business intelligence dashboards and KPI reporting. Skilled in exploratory data analysis (EDA), data modeling, data storytelling, and stakeholder reporting to drive business optimization and strategic decision-making. Strong communicator who translates complex data into actionable insights. Certified by Cisco, Microsoft, and industry-leading organizations with a CGPA of 8.7 in Bachelor of Commerce (Computer Applications).

Education

SVPCET, Puttur

Master of Computer Applications

August 1, 2025 – June 30, 2027

SVU, Tirupati

Bachelor of Commerce · Computer Applications

August 1, 2022 – June 30, 2025

Vedavyasa Vidya Nikethan, Puttur

Secondary Education

June 1, 2019 – May 31, 2020

Projects

E-Commerce Database Design - SQL

August 1, 2025 – December 1, 2025

• Designed and implemented a fully normalized relational database (3NF) with 18 tables supporting users, orders, payments, inventory, coupons, and product reviews — architected to handle 10,000+ daily transactions with high reliability. • Improved SQL query performance by 30% through strategic indexing, query optimization techniques, and database normalization, reducing latency across complex multi-join queries. • Built and maintained an ETL pipeline for automated data ingestion and transformation, ensuring data integrity, consistency, and governance across all database modules. • Wrote advanced SQL queries using CTEs, window functions, and stored procedures to support business reporting, inventory management, and transactional analytics.

Sales Analytics Dashboard - Power BI

January 1, 2024 – March 1, 2024

• Built an interactive Power BI business intelligence dashboard analyzing 50,000+ sales records, delivering insights on revenue trends, profit margins, and year-over-year (YoY) growth. • Automated stakeholder reporting using DAX measures and Power Query transformations, reducing manual reporting effort by 75% and enabling real-time KPI monitoring for business leadership. • Designed data models and performed exploratory data analysis (EDA) to uncover actionable insights, resulting in data storytelling reports adopted by 3+ business stakeholders for strategic decision-making. • Implemented dynamic slicers, drill-through pages, and custom visuals to improve usability and accelerate data-driven decisions across departments.

Certifications

Data Analyst

Cisco

January 1, 2024 – Present

Microsoft Data Analyst 101

Simplilearn

January 1, 2024 – Present

Investment Banking Simulation

JPMorgan Chase & Co. (Forage)

January 1, 2024 – Present

Database Fundamentals

Albero Systems Pvt. Ltd.

January 1, 2023 – Present

Python Web Development with SQL

Karthikeya Software Solutions Pvt. Ltd.

January 1, 2023 – Present

IT Primer

Tata Consultancy Services (TCS)

January 1, 2023 – Present

Key Strengths

Strong foundational knowledge in SQL, including advanced querying, optimization, and database design (3NF).
Proficiency in Power BI for dashboard development, DAX measures, Power Query, and KPI reporting.
Experience with ETL pipeline development and data transformation.
Demonstrated ability in exploratory data analysis (EDA) and data storytelling.
Relevant certifications from Cisco, Microsoft, and other industry organizations.
Project experience directly aligns with Data Analyst responsibilities.

Cultural & Operational Fit

Cultural Fit Analysis

Soft Skills & Operational Fit