Ajay Mittal

Ajay Mittal

$14/hr
A Data Analytics professional working with one of Top 4 UK bank with their office in India.
Reply rate:
-
Availability:
Part-time (20 hrs/wk)
Age:
37 years old
Location:
Delhi, Delhi, India
Experience:
10 years
AJAY MITTAL Mobile:- E-Mail:-Address: B-63, Pocket-3, Sector-2, Rohini, New Delhi OBJECTIVE: To provide value to the organization for their time and money with consistent improvement in my performance, being genuine in my purpose, straight forward in execution and through my sheer courage, determination and with the right environment become an icon of the organization. PROFESSIONAL SUMMARY: Current Organization : Barclays Shared Services Pvt. Ltd. Designation : Assistant Manager Previous Organizations : ExlService Holdings, Inc. / Inductis India & Mosaic Media Ventures Pvt. Ltd. Key Responsibilities: Barclays Shared Services Pvt. Ltd. (June’16 – Present) 1. CRIS (Credit Risk Information Services) Regulatory Capital Reporting (PRA and EBA) for the BarclayCard cluster which includes inputs gathering from various risk partners for generating key risk metrics and ensure complete and accurate delivery of risk information packs to agreed stakeholders. Collaborate within the consolidation team, finance team and business functions to ensure compliance. Handling monthly and quarterly reporting (IMS attestation) of Basel compliant flash RWAs with subsequent analysis of actual deviations. Preparing various manual returns for explaining the detailed analysis & commentary on the movements within the cluster. Representing BarclayCard in regular meetings organised by group finance for RROC, Variance Analysis, Pillar III, etc… Responsible for management of the quality of RWA data for Leverage, Securitization and Credit Risk; implementing regulatory assurance for Credit Risk. Performing Risk to finance reconciliation and keeping robust control environment by performing checks to ensure accuracy and completeness. Completing Ad- hoc request from senior management, regulators and other teams. COREP (Axiom) Supporting with disclosure input of all regulatory reports i.e. CoRep templates, Pillar III, ICAAP, Quantitative Impact Study (QIS); steering validation & sign-off Preparing & submission of credit risk COREP returns on a quarterly basis. Liaisoning with Tech team to get taxonomy upgrades in AXIOM for COREP returns. Detecting data validation checks for CoRep submissions and coordinated for quantitative risk reporting in cluster return (BOE Submission) ICAAP – Preparation of capital attribution report based on products/ business line for ICAAP purposes. Project Resolving legacy data quality issue of RWA reporting with in Central Government asset class. Analysing the existing data source (via IFF) and basis the counterparty names. Thereafter tagging counterparties based upon Sector Classification Guide and inputs from senior management to reclassify them into Central Government, Regional Government, Corporate and Retail classes. This led to an increase in RWA reporting for the cluster. Going forward, it is still being investigated to implement the solution at root level. 2. CORPORATE BANKING Preparing credit reports of corporate clients in UK for funding up to £25 million. Working as a member of Middle Office, Barclays Bank Corporate Banking Credit team - London. Appraisal is primarily based on company analysis (both financial and qualitative), Industry analysis and the overall transaction/security structure. Highlight risk concerns and evaluating mitigants while doing the appraisal. Facility structures/ Product category includes all major corporate banking products such as overdrafts, term loans, asset finance, sales finance, settlement limits, trading limits like LC’s / BG’s and SFET limits (derivatives) Responsible for mapped portfolio of corporate clients and taking care of all conquest, interim limits request along with annual reviews. Handling complete process of lending operations which includes: Working closely with mapped Relationship Director (RD) & working in partnership with the Post Sanction Case managers, Credit Monitoring team, Coverage team, servicing team and other specialists. Key Responsibilities: Exlservice Holdings, Inc. (October’13 – June’16) Part of credit underwriting team and have worked on various projects for Banking and Corporate clients Underwriting credit research reports comprising in-depth fundamental and credit analysis of issuers (credit opinion, market trends, and industry analysis) Responsibilities mainly include preparing detailed credit underwriting reports in collaboration with client Analysts and credit managers. Commenting on key credit credentials with the help of financial/credit models; emphasizing on credit history, financial ratios, debt structure analysis, liquidity analysis, and income growth prospectus. Assigned portfolio mainly consists of agricultural companies. Detailed financial statement spreading of balance sheet, income statement and cash flow statement for public and private companies in excel format for analysis purpose. Evaluating the counterparty’s financial performance over the past three years and two interims including profitability, leverage and liquidity using company’s filings and other financial databases like Bloomberg, CapitalIQ, Factiva etc. for both public and private companies Assessment of the counterparty’s free cash flows and liquidity position with respect to their debt maturity profile by studying the credit facilities, covenant analysis and movement in key leverage ratios Rating Updates: Providing detailed discussion on the counterparty’s (investment grade or high-yield category) rating changes for Moody’s, S&P and Fitch ratings Sector Overview: Preparation of brief industry overview to provide with recent industry trends and future outlook of the sector in which the counterparty operates On-going Monitoring & Surveillance of assigned portfolio, which mainly includes rating changes, financial/industry development, news events etc. Company Profile: Brief business description of the entity, including business strategy, management overview and recent events using publicly available information. Recommendation: Providing a final recommendation to client based on the entire analysis along with the proposed trade limit. Proficient with databases/tools like Capital IQ, Factiva, Salesforce, OneSource, Moody’s CreditEdge, Moody’s RiskCalc and Reuters for data sourcing, forecasting, and financial/industry development. Managing internal processes for quality checking, and delivering required throughput of high quality credit reviews on time. Key Responsibilities: Mosaic Media Ventures Pvt. Ltd. (May’10 – Oct’13) Financial Statement Analysis: Preparation of detailed trend analysis of segment-wise revenue, gross margin, EBITDA margin and Free Cash Flow for fiscal year and year-to-date financial result. Capital Structure: Preparation of Capital Structure including bifurcation of debt based on their seniority and maturity and discussion of leverage ratio. Borrower Background: Brief business description of the entity, including business strategy, management overview and recent events using publicly available information. Tracking Transactions such as Mergers and Acquisitions, Private Equity, Venture Capital, Angel Analysing the PE/VC deals to arrive at a company’s valuation. Successfully launched Key Development and QIP Page for public and private company. Considered as “Subject Matter Expert” of the process and Quality Auditor of the tasks handled by team. EDUCATIONAL QUALIFICATION: Particulars of Academies University/Board Percentage/CGPA Year Of Completion MBA-Finance Indian Institute of Finance 6.1 (CGPA) 2010 BBA (Banking & Insurance) GGSIPU 64 2008 HSC C.B.S.E 68 2005 SSC C.B.S.E 58 2003 KEY SKILLS & CORE COMPETENCIES: Credit Risk Assessment Sound Analytical Skills and Numerical solving Skills Ability to work under pressure without close supervision Knowledge of tools like Capital IQ, Factiva, Bloomberg etc. Knowledge of SAP, SAS and VBA. Understanding of risk assessment and analytical tools like S&P Credit Pro and Moody’s Risk Calc. Well versed with MS Office (Excel, word and PowerPoint). Team handling and work management. EXTRA-CURRICULAR ACTIVITIES: Winner of Intercollegiate Entrepreneurship competition in 2009 at Jaipuria Institute of Management and Accman Institute of Management and Amity Business School in 2010. Among Top 5 teams of National level Business plan competition in BHU in 2009 and NIT-Trichy in 2010. 2nd runner up of Intercollegiate Entrepreneurship competition in 2010 in IRMA. PERSONAL DETAILS: Date of Birth: 15 March, 1988 Father’s Name: Ram Niwas Mittal Marital Status: Married Nationality: Indian Language Known : English and Hindi I hereby declare that all the information provided by me in this resume is factual and correct to best of my knowledge and belief. Date: AJAY MITTAL
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.