ANKIT PAJNI
Noida
Summary
Detail-oriented professional with expertise in SAS programming, advanced Excel, and data visualization tools such as Qlikview and Tableau. Proficient in SQL and Oracle development, with foundational knowledge in Python. Strong analytical skills drive effective data-driven decision-making and innovative solutions. Committed to precision and excellence in data analysis roles.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
Work history
Assistant Vice President
Barclays
Noida
11.2024 - Current
- Cultivated strong relationships with key stakeholders to enhance business development opportunities.
- Implemented process improvements, achieving greater workflow efficiency across all portfolios.
- Calculated Post Model Adjustments (PMAs) to address deficiencies in IFRS9 models caused by data issues or strategic changes.
- Created Impairment Committee Pack, Monthly Impairment Pack, and portfolio-specific impairment schedules following IFRS9 guidelines.
- Managed team to ensure effective execution of BAU activities.
- Executed monthly and quarterly submissions involving data preparation, reconciliation, and sign-off from leads/directors.
- Analysed end-to-end IFRS9 model results, investigating factors driving month-on-month movements in PD, LGD, and EAD.
- Provided insights on month-on-month ECL movements and addressed non-model items such as write-offs and PWOR.
Assistant Manager
Barclays
09.2022 - 10.2024
- Calculated Post Model Adjustments (PMAs) to address deficiencies in IFRS9 model due to data issues or strategic changes.
- Created Impairment Committee Pack, Monthly Impairment Pack, and portfolio-specific impairment schedules following IFRS9 guidelines.
- Executed monthly and quarterly submissions, including data preparation, reconciliations, and obtaining sign-off from senior management.
- Analysed end-to-end IFRS9 model results, focusing on drivers of month-on-month movements in Probability of Default (PD), Loss Given Default (LGD), and Exposure at Default (EAD).
- Provided commentaries on month-on-month Expected Credit Loss (ECL) movements and non-model items such as write-offs and post-write-off recoveries.
- Delivered expert judgments on model ECL based on discussions with senior leadership, aligned with market conditions.
- Managed postings for PMAs and expert judgments affecting model ECL, facilitating transitions to SAP for book closures.
- Handled ad-hoc ECL impact requests involving investigations and analyses of various IFRS9 activities like account switching and dormancy.
Senior Fraud Analyst
Barclays
09.2020 - 09.2022
- Delivered analytical reports within strict daily, monthly, and quarterly deadlines.
- Designed and developed SAS processes to automate data transfers to SAS Grid locations.
- Encrypted personal identifier data across various BAU processes for enhanced security.
- Optimised space for Advances and Investments data, improving storage efficiency.
- Collaborated with stakeholders from business, portfolio teams, and third-party organisations.
- Executed multiple enhancements to align current processes with upstream data changes.
- Reviewed code changes from developers in Fraud Analytics to ensure compliance with production guidelines.
- Utilised tools including SAS Enterprise Guide and Teradata SQL Assistant for efficient reporting.
Data Analytics Intern
Ernst & Young
01.2020 - 04.2020
- Developed dashboard for Department of Excise and Taxation to enhance revenue forecasting and detect tax fraud.
- Identified top taxpayers to optimise state collection and analysed monthly collection trends.
- Implemented Oracle SQL Developer Extensions and Microsoft Excel for data analysis.
- Utilised SAS Enterprise Guide, Oracle, and Microsoft Office to support business operations.
Education
Computer Science
Chitkara University
Rajpura 08.2016 - 08.2020
Skills
- SAS programming proficiency
- Advanced Excel skills
- Python knowledge
- Tableau/QlikView expertise
- Oracle SQL and Teradata proficiency
Timeline
Assistant Vice President
Barclays
11.2024 - Current
Assistant Manager
Barclays
09.2022 - 10.2024
Senior Fraud Analyst
Barclays
09.2020 - 09.2022
Data Analytics Intern
Ernst & Young
01.2020 - 04.2020
Computer Science
Chitkara University
08.2016 - 08.2020
Similar Profiles
THANDO JARVISTHANDO JARVIS
Assistant Vice President, Internal Audit at BarclaysAssistant Vice President, Internal Audit at Barclays
OMKAR R JAGTAPOMKAR R JAGTAP
Sr. Data Engineer at BarclaysSr. Data Engineer at Barclays
Hayley JonesHayley Jones
Operations Manager at BarclaysOperations Manager at Barclays
Wendell WigginsWendell Wiggins
Disputes Specialist at BarclaysDisputes Specialist at Barclays
Pinky AhlawatPinky Ahlawat
HR Administrative Assistant at LINTL Clothing Pvt. Ltd.HR Administrative Assistant at LINTL Clothing Pvt. Ltd.