Open to opportunities

Mohit Rajpal 2476

@mohitrajpal2476

Message

Data-driven analyst with expertise in risk management and automation.

India

Message

What I'm looking for

I am looking for a role that challenges my analytical skills and offers opportunities for growth in data-driven decision-making.

I am a data-driven professional with over 4.5 years of experience in data analysis and risk management. Currently, I work as a Data Analyst at Blackstone, where I design and maintain advanced dashboards that visualize key performance indicators across multi-billion-dollar real estate portfolios. My role involves conducting quarterly reporting and valuation analytics for Private Equity real estate funds, which supports critical investor communications and internal audits. I have successfully automated end-to-end data extraction and transformation workflows using SQL and Python, significantly reducing manual effort and improving reporting turnaround time.

Previously, I served as a Risk Data Analyst at American Express, where I conducted in-depth analyses on high-volume financial transactions to identify anomalies and inform fraud mitigation strategies. I led initiatives that enhanced fraud prevention frameworks and collaborated with cross-functional teams to implement scalable reporting pipelines aligned with global risk policies. My expertise in building dynamic dashboards and performing exploratory data analysis has enabled real-time decision-making for risk teams, ultimately improving risk mitigation strategies.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst (Analysis and Automation)

Current

Blackstone (Wipro)

Sep 2024 - Present (9 months)

Designed, built, and maintained advanced Sigma dashboards to visualize key performance indicators across multi-billion-dollar real estate portfolios, enabling leadership to make data-informed decisions. Automated end-to-end data extraction and transformation workflows using SQL and Python, reducing manual effort by 30% and improving reporting turnaround time. Spearheaded the integration of Snowfla

Sigma SQL Python Snowflake Data Visualization ETL Data Warehousing Reporting

Risk Data Analyst

American Express

Oct 2022 - Apr 2024 (1 year 6 months)

Conducted in-depth analysis on high-volume financial transactions to identify anomalies, reduce risk exposure, and inform fraud mitigation strategies across global payment systems. Led the Reconciliation of Charges (ROC) initiative with Travel Management Companies (TMCs), leveraging advanced Excel logic and SQL queries to validate financial data and detect discrepancies. Built dynamic Sigma dashbo

Fraud Detection Risk Analysis SQL Advanced Excel Sigma Travel Data Reconciliation Data Extraction

Management Information System Executive (Senior MIS Analyst)

Meritto (NoPaperForms)

Oct 2021 - Oct 2022 (1 year)

Analyzed and interpreted large datasets to identify trends, patterns, and actionable insights that support strategic business decisions. Utilized advanced Excel functionalities, including LOOKUP formulas, INDEX MATCH, SUMIF/SUMIFS, Pivot Tables, and IF functions, for detailed financial and operational analysis. Executed full-scale ETL processes to ensure data integrity, cleanliness, and readiness

Data Analysis Advanced Excel ETL Data Modeling Dashboard Development Database Management Business Intelligence Data Integrity Reporting

Business Analyst

RBL Bank

Sep 2020 - Sep 2021 (1 year)

Collaborated with Customer Service Operations Managers to design and deliver actionable reports that enabled informed decision-making on performance, staffing, and customer experience improvements. Maintained daily, weekly, monthly, and quarterly MIS reports, ensuring timely and accurate data compilation. Prepared proactive checklists for databases and important work to avoid future downtime.

Information Compilation Custom Reports Advanced Excel MS Office Root Cause Analysis Data Validation Communication Skills Customer Service Operations performance reporting

Education

Degrees, certifications, and relevant coursework

Amity University Online

MBA in Business Analytics, Business Analytics

Currently pursuing an MBA in Business Analytics, focusing on advanced data analysis techniques. The curriculum emphasizes the use of Sigma, Excel, and SQL for business intelligence and strategic decision-making.