Data Analyst Power Bi

Sandeep Mallick

Marathahalli, Bangalore -******

Email – *****************@*****.***

Phone - 933-***-****

Summary

Highly motivated and detail-oriented Data Analyst with 2.6 years of experience transforming complex datasets into actionable insights. Proven ability to leverage statistical methods and programming languages to drive data-driven decision-making across various business functions. Skilled in data quality management, reporting, and visualization using industry standard tools. Skills:

Technical Skills: MS Excel, SQL, Power BI, Tableau, Python (NumPy, Pandas, matplotlib)

Programming Language: Python, SQL

Data Analysis: EDA, Data visualization, Data modeling, Analysis. Experience

Data Specialist Kotak Mahindra Bank may2024-Till now Project Overview:

In this role, I focused on transforming and analyzing extensive datasets related to customer profiles, sales performance, and financial transactions to uncover actionable insights for strategic decision-making. Utilizing my expertise in SQL, Advanced Excel, Power BI, and Python, I provided comprehensive data solutions that helped streamline processes and optimize reporting efficiency for key stakeholders. Roles and Responsibilities:

Integrated data from multiple sources, performing thorough cleaning and preprocessing to ensure datasets were complete, accurate, and analysis-ready.

Validated and audited large datasets using SQL to identify inconsistencies and discrepancies, thereby improving data quality and integrity for reliable business insights.

Created advanced SQL queries and stored procedures to support ongoing analyses, such as customer behavior profiling, transaction tracking, and revenue projections, allowing for targeted business interventions.

Leveraged Excel for detailed reporting and automated calculations, employing tools like Advanced Filters, Power Query, and complex formulas to streamline monthly and quarterly reporting.

Developed Power BI dashboards tailored to visualize customer segmentation, transaction volume, and profitability metrics, enabling stakeholders to easily track financial health and operational KPIs.

Collaborated directly with various teams and executives to understand data requirements and communicate key findings, ensuring that insights were actionable and aligned with business goals.

Produced detailed documentation for data pipelines, methodologies, and visualizations, fostering clarity, transparency, and ease of replication for future projects.

Reduced manual reporting efforts by 35% through the automation of recurring tasks in SQL and Excel, and increased data reliability by implementing comprehensive validation checks.

Data Analyst ICICI Bank Jan2023-Apr2024

Roles and Responsibilities:

This project focuses on data management, handling new requests, inquiries, and services, each with specific requirements.

When a user registers, the admin records client details and manages new registrations.

Raw data is received in MS Excel format and undergoes data cleansing.

Data cleansing includes splitting names into first, middle, and last names, and removing unnecessary spaces and characters.

Data is manipulated, cleansed, and processed using MS Excel, SQL Server, and Tableau.

The cleaned data is then used for visualization in Tableau to provide actionable insights.

Utilized advanced excel functions for data cleaning and processing.

Wrote joins, sub-queries, Group By, CTE queries to fetch data of specific date range as per management requests

Certifications:

SQL with Microsoft Server (Infosys Springboard)

Data Visualization with Power BI (Great Learning)

Data Analysis with Python (Cognitive Class)

Education

MBA (MARKETING, FINANCE), Global institute of management,Bhubaneswar,Odisha.

BCom, S.V.M College, Jagatasinghpur, Odisha.

Declaration

I hereby assure that the above-furnished details are true to the best of my knowledge.

Contact this candidate