Data Analyst Financial Services
Resume:
excel/google sheets.
Ankita Singh
EXPERIENCE
DATA ANALYST 09/2022 - Current
CarDekho – GirnarCapital Pvt Ltd – Gurgaon
ROLES AND RESPONSIBILITIES
• Regulated Bureau data Submission on monthly basis to all CIC's (CIBIL, CRIF, Experian, Equifax).
• Handling all row data that came from collections, sales and development.
• Worked on a waterfall model and created customer portfolio for the risk analytics project
• Bureau reporting of retail and whole sales data (Consumer -used car and two- wheeler, Commercial -Inventory funding) to credit information companies.
• Have taken responsibilities of fetching data for the reporting from different servers, Fields such as “Amount overdue”, “Principal Outstanding”, “Total outstanding”, Number of days past dues and bucketing of EMI’s taken care via reporting.
• Worked on gathering Business Reporting Requirements and prepared various MIS and Technical Design Documents for Reporting needs.
• Developed dashboard and MIS’s as per the business needs using Google Sheet, Power BI, Tableau.
• Performed SQL data analysis.
• Developed business procedure, reports and documentation using Google sheets and SQL.
• Advanced analytical and Excel skills required to understand, manage and access the large data sets including the ability to interpret the results.
• Optimizing data collection and making daily, Weekly & Monthly Reports.
• Automated risk reporting processes using Python and SQL, reducing report generation time and improving data visualization techniques for communicating risk insights to stakeholders.
SR. CLINICAL ASSOCIATE 05/2015 - 02/2022
Healthwatch Telediagnosis Pvt Ltd - New Delhi
• Prepared ECG reports.
• Holter and Event monitoring.
• Month on month reports of data validation.
• Data presentation by Summary Dashboard & Chart Dashboard in
• Manage the planning and development of design and procedures for matrix reports.
• Develop new reports and delegate tasks to team members.
• Optimized data collection procedures and generated reports weekly, monthly, and quarterly reports.
• Used advanced Microsoft Excel to create pivot tables and pivot reporting.
• Presented data and conclusions to the team to improve strategies and operations.
Gurgaon, Haryana
**************@*****.***
SUMMARY
A professional with 2.7 years of
experience in NBFC, Financial
Services as Data Analyst with
proven history in regular bureau
reporting to credit information
companies, analyzing company
inventory data, sales and
developing reports to illustrate
findings.
SKILLS
Structured query language (SQL)
Python
Django
Power BI
Excel & Google Sheets
Automation
Data Quality
Requirements Analysis and
Documentation
Operation Analysis
and Data mapping
EDUCATION
AND TRAINING
Training YA Institute Gurgaon –
Data Analyst Intern 03/2022 to
08/2022
Experience in creating data models,
dashboards and reports using tool
SQL server, Power BI, Python,
Advance Excel
Jiwaji University - Gwalior, M.P.
Post Graduated (Biotechnology,
Regular) 01/2015
Jiwaji University -Gwalior, M.P.
Graduated (Biology, Regular)
01/2012
PROJECTS
RISK ANALYTICS (WATERFALL MODEL)
• The loan providing companies find it hard to give loans to the customers due to their insufficient or non- existent credit history. Some consumers use it as their advantage by becoming a defaulter.
• Worked for automobile finance company which specializes in lending various types of loans to urban customers.
• Used EDA to analyses the patterns present in the data. This will ensure that the applicant share capable of repaying the loan are not rejected.
CLUSTER MODEL (DEALER SEGMENTATION)
• Developed a clustering model to classified dealer location into different cohorts based on latitude and longitude from office location so that suitable marketing strategies can be used for individual cohort.
• Performed initial investigations on data with the help of summary statistics and graphical representations. Identified optimal number of clusters through dendrogram
method/shoulder method and modelling was performed using Hierarchical/K-means clustering method
Skill Used : Django, Python, SQL
CERTIFICATIONS
• Training YA Institute Gurgaon – Data Analyst Intern From - 03/2022 to 08/2022
• SQL Masterclass certification
Contact this candidate