Abhishek Manglam
Data Analyst/Solution Architect
Mumbai
Summary
12+ years of experience in various roles as a data analyst, solution architect, and programmer in the Banking and Finance sector into Market Risk, Credit Risk, Treasury, Finance Reconstruction, Credit Cards, etc. Highly skilled and motivated Data Scientist/Analyst with a solid background in extracting actionable insights from complex datasets. Proficient in utilizing statistical techniques and data visualization tools to drive data-driven decision-making. Demonstrated expertise in conducting exploratory data analysis, and creating meaningful reports for business. Strong problem-solving abilities and a passion for transforming raw data into valuable insights. Excellent communication and collaboration skills to effectively translate technical findings to non-technical stakeholders. Seeking to leverage skills and experience to contribute to a dynamic data-driven organization.
Overview
13
13
years of professional experience
1
1
Certificate
4
4
years of post-secondary education
Work History
AVP, App Support Sr Analyst
Citi Bank, Citi
Pune
01.2020 - Current
- Working as Citi lead in GFT global production assurance supporting several analytics applications for more than three years.
- Performed analysis and drawn insight from data and worked with different stakeholders like Business users, development team, DBA, System Admin, Cloud Team, etc. for any issues.
- Clarified roles, responsibilities and expectations of staff.
- Managing vendor's team to understand outstanding issues/concerns and getting them addressed. Reviewing weekly deck with them for major issues/highlights to be presented to senior management.
- Identified opportunities to improve business process flows and productivity.
Chief Manager, Solution Architect
Indusind Bank
Mumbai
03.2017 - 01.2020
- Worked as Solution Architect within Risk - Solution Delivery Group to support Market Risk, Credit Risk, Asset Liability management, Treasury, Finance restructuring and reconstruction functions.
- Responsible for carrying out necessary configuration in system basis new regulatory guidelines or management requirements in consultation with system users (Risk Management, Treasury, and CFO).
- As part of digitization drive of bank, worked on several automation projects.
- Developed system for Non-performing assets (NPA), statement of account (SOA) , VAR and Expected shortfall, etc. reports.
- Coordination with IT team for timely completion of processing and generation of reports.
Consultant, Data Analyst/Manager
Axis Risk Consultancy
Mumbai
04.2016 - 03.2017
- Have worked in internal audit department of Morgan Stanley as data analyst to find anomalies and exceptions for wealth management department.
- Performed data analysis and found anomalies, exceptions, and patterns using SAS, Python, and SQL queries.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Utilized data visualization tools to effectively communicate business insights.
Consultant
Capgemini
Mumbai
03.2014 - 03.2016
- Liaised with business users to better understand requirement and implementing solution.
- Collaborated with teams to define, strategize, and implement solution.
- Worked on cleaning, and analysis of data using existing and new COBOL and SAS programs as per business requirements
- Resolved production errors and ensured processing of job was error-free. Implemented several fixes to avoid repetitive issues.
- Worked on analysis of error in reports, did root cause analysis and provided resolution for same which involved in-depth analysis of codes and fixed bug.
Analyst Programmer
Syntel Ltd
Mumbai
07.2010 - 02.2014
- Worked on analysis of error in reports, did root cause analysis and provided resolution for same which involved in-depth analysis of codes and fixed bug.
- Resolved production errors and ensured processing of job was error-free. Implemented several fixes to avoid repetitive issues.
- Resolved queries of users which required analysis of applications (programs and jobs) and proactively communicated results with them.
Education
B.E - Electronics and Communication
Anna University, Paavai Engineering College
Salem, Tamil Nadu 07.2004 - 06.2008
Skills
Python, SAS, SQL, Stats & Probaility, Exploratory Data Analysis, Tableau, Excel, Machine Learning
undefinedAccomplishments
- Star of the Quarter award for NOSTRO funding automation project which saved 1 FTE.
- INSTA achiever award for providing a quick solution for the Intraday Liquidity report project.
- Nomination for Star of the Quarter award for resolving file format issues.
Additional Information
Link for data analytics projects : https://github.com/abhishekmanglam/Project
Kaggle community competition on Drug recovery challenge participation: https://www.kaggle.com/competitions/community-event-drug-recovery/overview
Certification
SAS Advanced Programmer
Timeline
AVP, App Support Sr Analyst
Citi Bank, Citi
01.2020 - Current
Chief Manager, Solution Architect
Indusind Bank
03.2017 - 01.2020
SAS Advanced Programmer
12-2016
Consultant, Data Analyst/Manager
Axis Risk Consultancy
04.2016 - 03.2017
Consultant
Capgemini
03.2014 - 03.2016
Analyst Programmer
Syntel Ltd
07.2010 - 02.2014
B.E - Electronics and Communication
Anna University, Paavai Engineering College
07.2004 - 06.2008
Similar Profiles
Punit MundraPunit Mundra
Manager (C11)- Financial Planning & Analysis at Citi Bank (Citi Corp Services India Pvt. Ltd.)Manager (C11)- Financial Planning & Analysis at Citi Bank (Citi Corp Services India Pvt. Ltd.)
Laxmi KadamLaxmi Kadam
Officer at Citi Bank, CitiOfficer at Citi Bank, Citi
Nizar Elie DahdouhNizar Elie Dahdouh
SVP, Senior Relationship Manager at Hanmi Bank - San DiegoSVP, Senior Relationship Manager at Hanmi Bank - San Diego