Mayank Singh

Applied data analysis techniques using SQL and Python (Pandas, NumPy) to transform raw data into meaningful insights, supporting evidence-based decision-making and automated AI-driven reporting. Developed interactive Power BI dashboards for multiple business units (Micro Finance, Housing Loans), using SQL queries and Python scripts for data extraction, cleansing, and transformation. Gathered business requirements and coordinated with cross-functional teams to deliver SQL-, Python-, Power BI-, and Excel-based analytical solutions for marketing and operations data. Prepared quarterly regulatory reports for RBI, MFIN, and Sa-Dhan by consolidating and validating large datasets using SQL and Python (Pandas) to ensure accuracy and compliance. Analyzed business performance, customer behavior, and operational efficiency across branches using SQL queries and Python exploratory data analysis (EDA) to identify key trends and performance gaps. Led initiatives to automate daily and monthly reports using Python and SQL, reducing manual reporting effort by 70% on a daily basis. Utilized SQL for data extraction and Python for data cleaning and aggregation, along with Excel (pivot tables, charts, c

Collaborated with cross-functional teams to identify and solve data related challenges, enhancing overall data quality and accuracy. Clean and preprocess data to remove duplicates handle missing values, and format data appropriately for analysis. Developed interactive dashboards and visualizations using Power BI, improving data-driven decision-making for the team.