Summary
Work History
Education
Skills
Software
Kajal Choudhary

Kajal Choudhary

Data Analyst
New Delhi

Summary

  • Strategic and analytical professional with 5 years of success in financial analysis and reporting.
  • Talented in delivering advanced Excel and SQL reporting to plan, design, execute and evaluate report results.
  • Highly adept in analyzing business needs using technical skills to provide data and information analysis to achieve continuous improvement.
  • Proficient in advanced MS Excel formulas and functions to produce data-driven reports.
  • Expert in creating reports using tableau/Power BI, writing SQL/SAS queries and analyzing SQL data.

Work History

ARD And Reporting Analyst

Barclays Global Service Pvt Ltd
Noida
09.2022 - Current

• Executed overall data integration, cleansing, manipulation, aggregation, process improvement for reporting and visualization within credit risk analytics in SQL, SAS.

• Streamlines excel base reporting to advanced data visualization applications like Tableau and Power BI within more insightful and storytelling KPI dashboards. Overall business impact 30%-man hours reduced Strategy Building and Reporting.

• Develop KPI metrics for ad-hoc support and insightful reporting on application funnel in Excel and Tableau Visualization

• Create collection strategy for delinquent account before they go into Charge OFF and try to track the performance by risk segment.

• Migrating the SAS dataset to Hue as part of platform rewiring. Done adhoc analysis for the CROs

• Conducted credit risk analysis by analysing risk parameters such as the probability of default, value-at-risk, risk weighted, activity ratios.


Data Analytics Consultant

New Found Infotech PVT LTD
07.2017 - 08.2022

• Develop data engineering and streamlining data integration process from multi source files mapping into an analytical DataMart and design business insights to regular reporting process using DBMS programming and automation in SQL, SAS

• Derive actionable insights from retail data coming from all online and offline sources. Have a 360 view of the entire brand and its operations across stores and geo. Presenting analysis to a regular practice by providing inputs in Excel Reporting and PPT Presentations.

• Develop insights for strategy making in seamlessly integrates with Inventory to deliver unified analytics.

• Forecast demand and sales, enhance customer segmentation and profiling, identify market gaps, and discover new opportunities.

• Make stores more profitable and enhance in-store customer engagement with advanced analytics.

• Enhance in-store merchandising and optimize the shelf space and product placement by heat mapping and analysing SKU sales and inventory data.

• Optimize pricing and minimize losses by analysing competitors, demand, and other metrics

• Utilize location analytics to visualize all locations and their data in a single dashboard. Understand location specific consumer behaviour, sales data, and more to make location-specific data-driven decisions.

• Get a complete picture of customer behaviour and business with advanced analytics. Blend customer data from all channels to understand omnichannel consumer buying patterns and preferences. Generate intelligence from a single source of truth by combining data coming from all.

Education

BTech - Computer Science

Manav Rachna International University, Faridabad
08.2012 - 08.2016

12th -

K.S.K Academy , New Delhi
03.2011 - 04.2012

10th -

K.S.K Academy, New Delhi
03.2009 - 03.2010

Skills

DBMS Programming- SQL, VBAundefined

Software

SAS

SQL

Tableau

Power BI

Hadoop

Kajal ChoudharyData Analyst