Summary
Overview
Work History
Education
Skills
Certification
References
Accomplishments
Timeline
Generic
SONAM CHANDA

SONAM CHANDA

Bangalore

Summary

Experienced Data Analyst, worked in domain of healthcare, IT, merchant services. Specialist in data visualization by extracting unprocessed data, using Power BI and Tableau, and building dashboards and Data reporting, as per requirements. Collaborating across different teams optimizing reporting processes by min 40% to meet the KPI. Performed Power BI story-telling with stakeholders leading in min 25% increase in campaign performance. Executed MS Excel formulas and SQL reporting to plan, design, execute and evaluate report results. Good working knowledge on python libraries like Numpy, Pandas and Matplotlib to assist in analyzing large data set.

Overview

5
5
years of professional experience
2
2
Certification

Work History

Data Analyst

NJ Technologies Pvt
11.2022 - Current
  • Usage of DAX and M-exp in Power BI and connecting with databases to generate dynamic pricing model
  • Streamlined geospatial workflows for increased efficiency by developing custom Python scripts.
  • Implemented row-level security measures that enhanced data protection, and ensuring compliance with privacy regulations
  • Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel
  • Designed and developed a data architecture that supported the integration of new data sources, resulting in a 20% increase in data availability and improved data accuracy.
  • Utilized Joins and Sub-Queries to simplify complex queries involving multiple tables while optimizing procedures and triggers to be used in production
  • Performed database performance tuning, indexing and query optimization — enhancing report performance by 20%
  • Increased productivity by automating repetitive tasks using Python scripting.
  • Having working experience in Normalization techniques for OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes
  • Leveraged advanced features such as LOD expressions, table calculations, parameters, sets and blending in designing Tableau dashboards to meet complex data analysis requirements.
  • Developed and maintained Tableau calculations and parameters, resulting in a 20% improvement in data accuracy and a 15% reduction in manual data entry errors.

Account Manager

Amazon
02.2022 - 07.2022
  • Lead and managed Power BI projects from conception to delivery, ensuring to meet deadlines, budgets, and quality standards.
  • Built and published 20+ customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server
  • Instrumental in deployment of advanced analytics solutions using Data Visualization tools,supporting IT service management, leading 30% improvement in incident response times
  • Developed and maintained Tableau security roles and permissions, ensuring compliance with industry regulations and improving data security by 25%.
  • Have developed stored procedures, triggers, and functions as per business requirements to automate tasks and enhance system efficiency.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Helped maintain database documentation and data standards to ensure consistency and quality across data models. achieving a high satisfaction rate.

Inside Sales Associate

Mfine
10.2021 - 01.2022
  • Led cross-functional team in large-scale migration project to Tableau Server, enhancing data visualization capabilities for health care users in IT enterprise environment
  • Cleaned and transformed data using Power BI Query Editor to prepare ETL processes to optimize reporting datasets
  • Collaborated with stakeholders to develop and implement a data governance process that ensured compliance with data privacy regulations and improved data security.
  • Troubleshoot and debugged errors in formulas and functions using Excel, resulting in 20% reduction in errors and 10% increase in accuracy.
  • Improved system performance by 25% through advanced query optimization techniques to improve response times and reduce resource consumption on servers.
  • Proficient in advanced SQL queries, creating stored procedures, and designing relational database schemas.

Senior Sales Consultant

Lifeline Solutions
03.2019 - 07.2021
  • Created predictive analysis that improved scheduling accuracy by 20%
  • Used advanced chart visualizations in Tableau—such as dual axis, box plots, bullet graphs, tree maps, bubble charts, and waterfall charts—to solve complex problems and to create interactive dashboards and visualizations
  • Designed and implemented macros and VBA scripts to automate processes, resulting in 27% reduction in manual labor and 20% increase in data accuracy
  • Developed interactive dashboards using Power BI and SQL tools to provide on-demand reporting, powerful visualizations, and insights to business users
  • Developed pivot tables and custom reports in Excel.

Education

MBA - Finance

Birla Institute of Management Technology
Delhi, India
02.2025

Executive Program - Fintech

IIM
Kozhikode
10.2024

PGDCA - Computer And Information Sciences

Astel Technologies
Assam
10.2018

Bachelor of Science - Biotechnology

Gauhati University
Guwahati, India
07.2016

Skills

  • Tableau Server
  • Pandas Library
  • Python Scripting
  • MySQL database management
  • Microsoft SQL Server Management
  • SQL Querying
  • Power BI Reporting
  • NumPy Library
  • Oracle PL and SQL Programming

Certification

  • Microsoft Certified: Power BI Data Analyst Associate (Sep 2023)
    Issued by Microsoft (ID: BC62C1A9C767AB96)



  • Tableau Certified Data Analyst (Sep 2023)
    Issued by Tableau Software LLC (ID:459295672)





References

REFERENCES (Available on request)

Accomplishments

  • Automated Data Cleaning:Utilized Python scripting, Pandas, and NumPy to automate data analysis for large-scale research projects.
  • NJ Technologies and Amazon:Developed Power BI dashboard that showcased website traffic patterns and user behavior, guiding website redesign efforts that resulted in a 20% increase in user collaboration.
  • NJ Technologies and Amazon:Utilized Tableau desktop features to create a dynamic narrative dashboard highlighting impact of marketing campaigns on revenue, contributing to a 12% increase in campaign effectiveness.
  • SQl Querying: Designed and executed Extract, Load, Transform (ETL) procedures to migrate data from production databases to data warehouse, improving database performance and loading speed by 70%
  • Lifeline Solution and Mfine: Created a database for a local business using SQL, designed to track inventory and sales data.
  • Amazon and NJ Technologies: Created a database for a local business using SQL, designed to track inventory and sales data. Developed and maintained data models and data dictionaries, facilitating efficient data organization and enhancing data understanding for stakeholders.
  • NJ Technologies: Managed a Tableau project for a healthcare client, analyzing patient data to identify areas for improvement and reduce hospital readmission rates by 10%.

Timeline

Data Analyst

NJ Technologies Pvt
11.2022 - Current

Account Manager

Amazon
02.2022 - 07.2022

Inside Sales Associate

Mfine
10.2021 - 01.2022

Senior Sales Consultant

Lifeline Solutions
03.2019 - 07.2021

MBA - Finance

Birla Institute of Management Technology

Executive Program - Fintech

IIM

PGDCA - Computer And Information Sciences

Astel Technologies

Bachelor of Science - Biotechnology

Gauhati University

Similar Profiles

CREATE PROFILE
SONAM CHANDA