Hemant Kamal

• Responsible for the development of EAD/PD modelling data and maintenance as per the IRB guidelines used in the bank's risk frameworks. it involved collaboration with internal modelling teams to understand their requirement and implementation of it after liaising with multiple stakeholders to collate the required data in SAS that can be further used for modelling purposes.
• Providing actionable analysis and insights on all aspects of modelling data in the form of MI reports and dashboards.
• Developing data quality reports basis regulatory and governance framework. Supporting regulatory engagement and internal governance in relation to risk models and model frameworks.
• Successfully managed change within the organization, ensuring smooth transitions during periods of restructuring or process improvements with respect to migration of SAS codes to python/pyspark on Amazon sagemaker studio.

 Execution of key strategic and regulatory projects primarily financial difficulty, EBA –PRA reporting
along with regular regulatory reporting to stakeholders.
 Transform high,level requests into focused and specific analysis, Synthesize analysis results to inform
business issues, Extend, modify analysis based on observations, knowledge of data and limitations
and implications of results.
 Presented final results and conclusions to top management at appropriate forums.
 Generated insights from data whenever required, assessed the commercial and financial impact and
recommended action accordingly through the lens of risk management.
 Actively involved in understanding portfolio requirements and contribute to enhanced risk analysis
through independent interaction and collaboration with the stakeholders.
 Implemented key internal Projects to support portfolio and overall RIS requirements and Carried out
investigations, reconciliations and analysis to explain trends, outliers, peaks and through
demonstrating impact of Business strategy on risk metrics.
 Worked within the standard BCBS control framework in order to ensure the accuracy of data and
reports and adhere to completeness, accuracy and timeliness principles of Risk Data Aggregation and
Reporting.
 Maintaining existing Business Banking Portfolio reports and amended them whenever required and
helped in migration of these reports to SAS DI.
 Ensuring Ad-hoc delivery to the client as per the requirement

 Development of new Marketing reports through extensive use of SAS-Base and Advanced, Macros.
 Maintaining existing SAS deployed codes and scheduling the ETL Marts and Reports through SAS
and Unix scripting.
 Ensuring Ad-hoc delivery to the partners as per the requirement
 Designing and deploying marketing campaigns through SAS CIand assisting Marketing managers in
Learning SAS-CI tool to create campaigns on their own.
 Preparation and Maintenance of ETL updates.
 Preparation of data and its validation for the Modelling team.
 Making the Current data warehouse more effective and efficient.

 Data Migration of Current data from SQL Database into SAS and Configuration of Marketing
Campaign through SAS-CI
 Preparation of Marketing reports through Web Report Studio.
 Building Information maps and cubes that can be further used for Reporting and Campaign.
 Making the Current data warehouse more effective and efficient.
 Providing training and mentoring to the functional users so that they can make reports and design
campaign on their own thus eliminating dependency on IT
 Finding Patterns in Customer Data.
 Driving insights and helping marketing team to build strategies

Project Details:
Project : SAS Analytics, Consulting & SAS Algorithm for an US Insurance companies.

Client : US insurance companies like Swiss-re, wilton-re etc.
Responsibilities :
 Working in a team of Analysts engaged on De-Duplication Analytics (Customer Matching)
 Review the current customer matching process to Assess and quantify qualitative and quantitative
impact of poor matching and Improve matching efficiency of the current matching process.
 To provide business acumen in understanding the problem and structure.
 Manipulated and analyzed data using SAS Functions and data-step programming including
conditional processing.
 Creating pooled, standardized and analysis datasets as per client specifications.
 Managing the data using Base SAS and Macros extensively to ease the process of coding and
to standardize programs.

Processing Health Insurance related Claims which include
 Initial set up of claims
 Status Updating
 Processing claims as per the guidelines provided by the Health Insurance Company
 Payment issue
 Closing claims
 Allocation of claims to team members
 Work on the projects sent by client