Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
CONTACT
Software
Achievements
Timeline
Generic
Subhankita Mahapatra

Subhankita Mahapatra

Data Analyst
Hyderabad,Telengana

Summary

Experienced data analyst proficient in SQL, data modeling, and PowerBI. Proven ability to turn disorganized data into actionable insights. With over 4 years of experience in data analysis and reporting, I have provided partners with reliable insights for daily operations. Diligent worker with strong communication and task prioritization skills. Capable of understanding customer requirements and translating them into effective project plans.

Overview

5
5
years of professional experience
3
3
years of post-secondary education
3
3
Certifications
3
3
Languages

Work History

Data Analyst

ROBERT WALTERS INDIA PVT. LTD.
Hyderabad, Telengana
10.2023 - Current
  • Developing and maintaining accurate reports and dashboards in Excel and Power BI, ensuring compliance with global design and development standards defined in the organization.
  • Used statistical methods to analyze data and generate useful business reports in the HR domain.
  • Utilized data visualization tools to effectively communicate business insights on National Insurance changes in the UK HR organization.
  • Managing a diverse reporting schedule for multiple clients, consistently delivering timely and insightful reports for data-driven decision-making by the end users based out of the US, UK, and EMEA regions.
  • Providing proactive and requested reports and analysis to support business reviews, governance, audit, and delivery against SLAs, and KPIs.
  • Produced weekly and monthly system reconciliation reports, promoting data integrity, and driving continuous improvement using lean methodology on various BAU reports.
  • Collaborating with end users to generate, maintain, and validate BI products, ensuring adherence to governance processes and procedures as defined by Data governance team within the organization.
  • Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.

SOFTWARE TRAINEE

WIPRO TECHNOLOGIES
11.2020 - 09.2023
  • Extracting and organizing data with help of SQL queries and assisting on creating tables, views and materialized views for multiple data models.
  • Developed visually compelling data visualization dashboards using Power BI to effectively communicate tailored messages to non-technical stakeholders, facilitating easier understanding of business cases/scenarios.
  • Utilized reports and exploratory analysis to identify and correct complex data problems, recommending solutions to eliminate root causes for better data quality.
  • Provided reporting and analytical support as well as maintenance to management team for existing MIS by data management, data cleansing, dataformatting, data migration and transformation.
  • Performed data analysis for generating reports and creating interactive dashboards using MS Excel on a periodic basis to provide recommendations for updating the current MIS that will improve reporting efficiency and consistency.
  • Assisted with the onboarding of new team members, sharing knowledge and expertise to help them become effective contributors quickly.
  • Maintained detailed documentation of all completed tasks for easy reference during maintenance or future updates as needed by other developers down the line.
  • Assisted in the development of client-specific solutions, resulting in increased customer satisfaction levels.
  • Collaborated with cross-functional teams to ensure smooth project execution and timely completion.
  • Attended regular training sessions, continuously improving skillset in line with evolving industry standards.
  • Improved code maintainability by adhering to established coding standards and best practices.

Education

Bachelor of Computer Applications - Computer Applications

REGIONAL COLLEGE OF MANAGEMENT
Bhubaneswar
01.2017 - 01.2020

Skills

Advanced MS Excel

Power BI

MySQL

Python

Dashboarding and Reporting

Data Modelling

undefined

Certification

Learning Path Certification in Data Science from Board Infinity [AdvanceExcel, SQL, Tableau, Python, Basics of ML]

Accomplishments

  • Developed methods to integrate new hire and leavers information to significantly improve workflow efficiency.
  • Helped on saving around 3-4 hours of daily effort by converting the manual reports to automated reports using excel formulas and powerBI.

CONTACT

  • PHONE: 07788050374
  • EMAIL: subhankitamahapatra07@gmail.com
  • CURRENT LOCATION: Hyderabad
  • LinkedIn

Software

PowerBI

SQL

Achievements

  • Awarded employee of the month from Robert-Walters for the month of Feb-2025 for contributions towards meeting tight deadlines and key project deliverables.
  • Received numerous client appreciation for ensuring project transition to newly onboarded team members and delivering on ad-hoc client requests during my time in Wipro technologies.

Timeline

Data Analyst

ROBERT WALTERS INDIA PVT. LTD.
10.2023 - Current

SOFTWARE TRAINEE

WIPRO TECHNOLOGIES
11.2020 - 09.2023

Bachelor of Computer Applications - Computer Applications

REGIONAL COLLEGE OF MANAGEMENT
01.2017 - 01.2020
Subhankita MahapatraData Analyst