MADHAN MOHAN
Business Data Analyst
CHENNAI
Summary
Results-driven Business Data Analyst with extensive experience in the Banking domain across Corporate, Private, and Retail segments, delivering data-driven insights for lending, liabilities, payments, and wealth products. Proficient in SQL, Excel, Python, and Power BI, with strong expertise in data modelling, exploratory and descriptive analysis, and building interactive dashboards to support business, risk, and regulatory reporting. Collaborates closely with data engineering and data governance teams to design scalable data models, improve data quality, and ensure adherence to banking compliance and control standards across large-scale enterprise environments. Trusted partner to product, operations, and risk stakeholders in translating complex banking data into actionable recommendations that optimize customer experience, portfolio performance, and process efficiency.
Overview
17
17
years of professional experience
4
4
Certificates
Work History
Business Data Analyst
Standard Chartered Global Business Services
07.2019 - Current
- Reduced report generation time significantly by optimizing SQL queries and restructuring existing databases.
- Created comprehensive documentation of analytical methodologies, ensuring consistency and reproducibility in future analyses.
- Collaborated with cross-functional teams to identify key metrics and develop relevant dashboards for tracking business performance.
- Increased data accuracy by implementing thorough data validation and cleansing processes.
- Designed and developed data pipelines to acquire, clean and process data.
- Presented findings from complex analyses to executive leadership in an easily digestible format, driving strategic decision making based on data-driven insights.
- Identified data discrepancies and inconsistencies through rigorous data audits, ensuring the highest level of data integrity for business-critical decisions.
- Facilitated seamless integration of acquired company''s data systems by mapping critical fields between databases and performing extensive reconciliation efforts.
- Created data models to support decision-making processes.
- Developed and maintained data warehouses and data marts to support business operations.
Business Analyst
Standard Chartered Global Business Services
07.2016 - 06.2019
- Actively participated in team meetings to share knowledge, exchange ideas, address challenges, and collaborate on potential solutions.
- Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
- Streamlined project management with effective communication and collaboration across cross-functional teams.
- Performed gap analysis between existing systems or processes and desired state, identifying areas for improvement or enhancement.
- Developed fraud detection models leveraging machine learning and AI, reducing false positives, and improving fraud detection accuracy.
- Implemented Bancassurance Digital Transformation, replacing Oracle Insurance Policy Administration (OIPA) with an in-house Global Banc Platform, significantly reducing operational costs, and enhancing data control, saving $3M annually.
- Enhanced risk detection methodologies by integrating real-time anomaly detection using advanced analytics, reducing fraud-related financial losses.
- Defined testing strategies and automation frameworks, improving product stability, reducing defects, and increasing test efficiency.
Quality Assurance Lead
Standard Chartered Global Business Services
09.2010 - 06.2016
- Created requirements for milestones and monitored completion of tasks for QA team.
- Mentored junior team members in quality assurance best practices, fostering a culture of continuous improvement.
- Managed test case creation and execution to ensure comprehensive coverage of all feature sets.
- Created detailed defect reports for clear communication between development teams about identified bugs.
- Led quality assurance efforts for core banking systems, ensuring compliance, reducing operational risks, and improving the end-user experience.
- Automated CASA testing using Visual Basic in QTP reduces turnaround time, improves data integrity, and minimizes human errors.
- Developed fraud monitoring test automation frameworks, enhancing security, reducing manual audit workload, and increasing compliance efficiency.
Implementation Analyst
Onward EServices
03.2009 - 08.2010
- Consistently met or exceeded implementation objectives by maintaining a high level of organization and attention to detail.
- Leveraged strong analytical skills to assess the impact of implemented solutions on overall business performance over time.
- Identified areas for improvement and implemented necessary changes, resulting in successful project completion.
- Developed comprehensive training materials to ensure smooth transition and adoption of new systems for endusers.
- Evaluated the effectiveness of implemented solutions through regular performance assessments, using insights gained to drive future improvements in both process and technology.
- Monitored progress throughout the implementation lifecycle, making real-time adjustments to maintain alignment with project objectives.
Education
PG Diploma in Data Analytics - Data Engineering And Data Analysis
NIELIT
New Delhi, India 04.2001 -
MBA - Business Administration And Management
Anna University
Chennai, India 04.2001 -
B.Tech - Information And Communication Technology
KCG College of Technology
Chennai, India 04.2001 -
Diploma - Electrical, Electronics And Communications Engineering
Elumalai Polytechnic College
Villupuram, India 04.2001 -
Skills
Business Analysis – Requirement Gathering, Stakeholder Engagement, Data Analytics, Business Solutioning, Business Intelligence, Data Models
Banking & Financial Services – Core Banking, ESG, Risk Management, Fraud Prevention, Corporate and Institutional Banking, Private Banking
Technology & Tools – Excel, Python, Hadoop, HiveQL, PostgreSQL, SQL, Unix, Dremio, MSTR, Control M
Data Governance - Metadata Management, Data Quality Management, Data Lineage
Agile Project & Delivery Management – Agile, SAFe, Digital Transformation
Cloud & DevOps – Azure DevOps, AWS Business Professional
Leadership & Stakeholder Management – Cross functional Team Leadership, Vendor Collaboration, Executive Reporting
Certification
CBAP - Certified Business Analysis Professional (Simplilearn)
Timeline
Business Data Analyst
Standard Chartered Global Business Services
07.2019 - Current
Business Analyst
Standard Chartered Global Business Services
07.2016 - 06.2019
Quality Assurance Lead
Standard Chartered Global Business Services
09.2010 - 06.2016
Implementation Analyst
Onward EServices
03.2009 - 08.2010
PG Diploma in Data Analytics - Data Engineering And Data Analysis
NIELIT
04.2001 -
MBA - Business Administration And Management
Anna University
04.2001 -
B.Tech - Information And Communication Technology
KCG College of Technology
04.2001 -
Diploma - Electrical, Electronics And Communications Engineering
Elumalai Polytechnic College
04.2001 -
Accomplishments
- Best Performer Award, 2023, Migrated and delivered 87+
repositories from Bitbucket to Azure DevOps., - Best Performer Award, 2022, Consolidated infrastructure
capacity, improving performance and saving $1M annually., - Best Performer Award, 2020, Recognized for leading BigData migration projects.