MANSI PANCHAL
Pune
Summary
Experienced professional with 3 years in corporate financial analytics and reporting, seeking to leverage diverse skills and expertise into data analytics roles.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Analyst
CRIF High Mark Credit Information Services
03.2024 - Current
- Created and Optimized SQL queries to generate insights and reports for Business Stakeholders.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Managed large-scale databases to ensure timely access to critical information for key stakeholders.
- Identified patterns and trends in large data sets and provided actionable insights.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Performing UAT testing on multiple projects.
- Full Development software Lifecycle from Fetching data from database to testing.
Data Analyst
BNY Mellon
05.2021 - 11.2022
- Designed, created and maintained automated template visualizations using Power Bi for internal and client facing reporting deliverables
- Processed and verified a high volume of electronic payments, ensuring accuracy and adherence to established protocols
- Investigated data discrepancies, resolved them and articulated them to support team's ability to do effective data analysis
- Built and maintained SQL scripts, stored procedures and complex queries for Data Analysis and Data Extraction
- Performed Data Quality and Validation check process in order to maintain data accuracy and reliability
- Extracted data from SQL Server database tables into flat data files and Excel sheets using table export for easy data migration
- Exposure in generating Data Visualizations using Python libraries
- Provided data reporting functions to support Business and analyzed data to perform root cause analysis.
Data Analyst
BNY Mellon
11.2019 - 05.2021
- Monitored and analyzed payment trends, providing insights using Power BI tool to management that contributed to strategic decision-making
- Independently mine data using SQL/Big Query to translate Business data needs into creative visualizations
- Transformed Business processes by working across teams to generate insights using data visualizations tools Power BI and Tableau
- Designed BI solutions based on Guided analytical approach by Clients
- Expertise in providing quality and occasionally complex client service and support to onshore clients
- Preparing Financial Regulatory Reports
- Planning for restructures and re-organization of asset in case of default, corporate action by pulling and analyzing market data from different verticals
- Dealing with reconciliation of loans and non-loan products for CDO and CLOs in asset administration function
- Primarily handling, asset setup, research, trade settlement, trade processing including interest payments, principal payment, borrowing, creating, and updating amortization schedule Ratings of loans through rating sites, i.e., Moody's, S&P and Fitch Planning for restructures and re-organization of asset in case of default, corporate action
- Handling escalations from onshore clients on a day-to-day basis as first point of contact for any escalations.
Education
Insitute of Chartered Accountant Of India
11.2018
Bachelor of Commerce -
Savitribai Phule University Of Pune
07.2016
Skills
- Data Visualization: Power BI
- Tableau
- Microsoft Office Suite: Excel
- PowerPoint
- Word
- Database Management: SQL
- Programming Languages: Python
- R
- Statistical Analysis: Hypothesis Testing
- Tools: Jupyter Notebook
- Git
- Data Manipulation: Pandas
- Scala
- Hive
- Spark
Certification
- Google Data Analytics Certificate by Coursera
- SQL Certificate by Growth School
- Visualize Data with Power BI by Growth School
- Completion of Python by Udemy
Accomplishments
- Bravo Award - From Client Services Team
- Take a Bow Award - For Exceptional issue handling
Languages
English
Hindi
Timeline
Data Analyst
CRIF High Mark Credit Information Services
03.2024 - Current
Data Analyst
BNY Mellon
05.2021 - 11.2022
Data Analyst
BNY Mellon
11.2019 - 05.2021
Insitute of Chartered Accountant Of India
Bachelor of Commerce -
Savitribai Phule University Of Pune
- Google Data Analytics Certificate by Coursera
- SQL Certificate by Growth School
- Visualize Data with Power BI by Growth School
- Completion of Python by Udemy
Similar Profiles
Alok RainaAlok Raina
Pre Sales Lead at CRIF High Mark Credit Information Services Pvt. LtPre Sales Lead at CRIF High Mark Credit Information Services Pvt. Lt
Archana RajputArchana Rajput
Assistant Manager at Ruloans Financial Services Private LimitedAssistant Manager at Ruloans Financial Services Private Limited
Amul TambadeAmul Tambade
Assistant Vice President – Finance at CRIF High Mark Credit Information CompanyAssistant Vice President – Finance at CRIF High Mark Credit Information Company