Karan Mahajan
New Delhi
Summary
Results-driven Associate with 4 years of experience in analytical roles, excelling in data-driven decision-making and problem-solving. Highly self-motivated with a proven ability to adapt quickly, learn new skills, and manage time effectively in fast-paced environments.
Overview
4
4
years of professional experience
Work History
Service and Operations Associate |
Ameriprise Financial Services
Gurugram
03.2021 - Current
- Two years of work experience as an analyst with analysis, visualization, and transformation in Tableau, Power BI, Alteryx, SAS, Python, and SQL Server.
- Familiar with writing DAX queries in Power BI, creating calculated measures, computed columns, and tables using DAX.
- Design simple and complex dashboards in Tableau and Power BI with various non-standard charts, like funnel, butterfly, waterfall, donut chart, etc.
- Created DML queries in SQL Server, including WHERE, GROUP BY, HAVING, and ORDER BY functions, as well as INNER, FULL, RIGHT, LEFT, CROSS, and SELF joins.
- Created workflows using Alteryx with advanced transformations like cross tab, multi-row, dynamic renaming, transpose, etc.
- Working with a team of developers, we designed, developed, and implemented a BI solution for product and customer KPIs.
Education
PGDM - Business Analytics And Finance
BULMIM
Delhi01-2021
Bachelor of Commerce -
SOL DU
Delhi01-2018
Skills
- Tableau
- Power BI
- Alteryx
- SQL Server Management Studio
- Advanced Excel
- IBM's Host On-Demand
Project 1
Demand Analysis- Cluster Model
Client: Retail | Role: Data Modeler and Visualization
- For a US based client, identifying the location for new service office to be opened on the basis of the demand data available with Latitude and Longitude.
- Targeted to meet 80% demand in 2 transit day.
- Data Transformation was done in Excel and Alteryx.
- Generated demand centric clusters using K- Mean cluster in Python and weighted algorithms.
Environment: Alteryx ,Advanced Excel & Python.
PROJECT 2
Man Power and Resources (MRP) Analytics
- Design a dashboard using Tableau from the HR data processed Via SQL and Python.
- Ensuring that the data preparation process in SQL takes input from different files and output in a single .CSV file for
uploading in Tableau. - Design an Attrition model and incorporate the outcome in Tableau.
- Maintain the historical data and design incremental load strategy.
Environment: Tableau, SQL Server and Python.
Timeline
Service and Operations Associate |
Ameriprise Financial Services
03.2021 - Current
PGDM - Business Analytics And Finance
BULMIM
Bachelor of Commerce -
SOL DU