MUDIT KOTHIWAL
Data Analyst Consultant
Dubai
Summary
Dynamic and results-oriented data analytics professional with over 7+ years of experience in the banking industry. Expert in developing innovative Power BI solutions to transform complex data into actionable insights, driving strategic decision-making. Proven track record in creating impactful dashboards and management information system (MIS) reports that enhance operational efficiency and exceed business expectations. Skilled in writing and optimizing complex SQL scripts for seamless data extraction and transformation, ensuring accurate and timely reporting. Adept at translating complex banking requirements into interactive visualizations, leveraging Power Query, DAX measures, and calculated columns. Committed to delivering high-quality analytical solutions that support business growth and improve risk management.
Overview
7
7
years of professional experience
5
5
years of post-secondary education
Work History
Data Analyst Consultant
Datamatics Global Services Ltd.
Dubai
9 2020 - Current
- Developed and maintained over 50+ dynamic Power BI dashboards, providing the business with real-time financial insights, risk management data, and compliance reports to support strategic decision-making
- Developed interactive dashboards and reports using Power BI, providing senior management with actionable insights on corporate lending, credit exposure, and financial performance
- Regulatory & Compliance Reporting: Compiled and analyzed data for regulatory submissions and audits (e.g., AML/CFT , Market Conduct, FATCA/CRS, CPR) ensuring accurate, timely, and compliant reporting to regulatory authorities
- Integrated Power BI dashboards with third-party banking applications using APIs, streamlining data retrieval processes and improving financial reporting accuracy by 80%
- Designed custom SQL scripts, views, and stored procedures to ensure data accuracy and integrity, reducing data discrepancies by 50% across key banking databases like SQL Server, Oracle, and IBM IIAS DB2 (DW)
- Collaborated with cross-functional banking teams to gather requirements, ensuring all dashboards and reports aligned with Central Bank regulations and financial compliance needs
- Analyzed the performance of retail banking products (e.g., savings accounts, loans, credit cards) and identified underperforming segments, resulting in product adjustments that improved profitability by 30%
- Reduced manual reporting time by 70% through automation and streamlined data workflows for strategic analysis
- Used Agile methodology and Jira for project management, tracking progress, and maintaining flexibility to adapt to evolving business needs
- Proficient in writing DAX measures, calculated columns, and MDX scripts to develop advanced analytical solutions, delivering insights that exceeded business requirements
- Designed and developed 200+ complex SSRS reports that provided key insights into retail banking operations, including customer transactions, loan performance, and credit card usage
- Created customized financial reports using SSRS for senior management, allowing them to track daily cash flows, account balances, and loan portfolios across multiple branches.
Junior Data Analyst
Shivalik mercantile co-op bank ltd
Noida
05.2017 - 09.2020
- Gathered, cleaned, and organized datasets from various sources (e.g., Excel, SQL databases) to ensure accurate and usable data for analysis
- Created regular reports and visualizations using tools like Excel, Power BI, and Tableau to help stakeholders track key metrics such as sales, customer behavior, and operational efficiency
- Performed data validation and cleaning to ensure consistency and accuracy of data before analysis, reducing errors by 90% in final reports
- Used basic SQL queries to extract relevant data from relational databases, improving the efficiency of data retrieval and report generation by 50%
- Documented data processes, reports, and methodologies to ensure transparency and reproducibility of analysis for future reference.
Education
Bachelor of Technology - Information Technology
ABES Engineering College
Ghaziabad, Uttar Pradesh 08.2013 - 05.2017
Senior Secondary - undefined
KCM School
Moradabad, Uttar Pradesh 04.2012 - 05.2013
Skills
Data Analysis & Statistical Tools: Excel, SQL
Data Visualization: Power BI, Tableau, Excel Charts & Graphs
Database Management: SQL Server, Oracle DB, IIAS DB2
Reporting Tools: SSRS, Crystal Reports, Webi Reports
Big Data Tools: Hive
Cloud Platforms: Azure SQL Database
Project Management Tools: Jira, BMC Helix, HPSM, Confluence
Domain Expertise: Banking
Languages
English Proficient
Hindi Native
Timeline
Junior Data Analyst
Shivalik mercantile co-op bank ltd
05.2017 - 09.2020
Bachelor of Technology - Information Technology
ABES Engineering College
08.2013 - 05.2017
Senior Secondary - undefined
KCM School
04.2012 - 05.2013
Data Analyst Consultant
Datamatics Global Services Ltd.
9 2020 - Current