Apr 2021 – Nov 2023 · 2 yrs 7 mos · Gurugram, Haryana, India

• > Generating Regulatory Reports for client Natwest Bank, reporting RWAs for Personal Loans, Home Loans, Credit Cards, Current accounts for the UK retail market.
• > Generating IFRS9 reports & disclosures, reporting ECL (Expected Credit Loss) by various sectors (wholesale, retail) and splits (agriculture, real estate, power utilities).
• > Mentoring a team of 5 people, and taking end-to-end ownership of projects to deliver before deadlines.
• > Using SAS coding techniques (macros, loops, rank ordering etc) to generate multiple metrics for various regulatory reports.
• > Develop complex SQL queries for ETL processes to modify, fetch and manipulate data from server for client needs and project requirements.
• > Provide full cloud, AWS, S3, Athena and Unix script support for design and architecture changes to ATLAS platform during their on-going AWS migration.
• > Working in Agile methodology to create user stories, sprints, and implementation of SDLC lifecycle process which includes requirement gathering, development, testing and post implementation support.

Jan 2021 – Mar 2021 · 2 mos

• Worked on projects with in-depth knowledge of the pricing and analysis tools used in the
• Market Pricing team, e.g. Radar, Emblem, SAS Enterprise Guide, SAS Viya, SQL etc.
• Developed different campaigns to efficiently manage client data using SAS Macros. Oversee the automation of 40+ monthly billing and operational reports using Python. Maintained and developed best practice pricing models and price optimization techniques.

Jul 2019 – Dec 2020 · 1 yr 5 mos

• Analysis performing on Insurance domain data for the US client and creating dashboards in Power Bi.
• Developing different campaigns to strategize on the data provided by the client and improve existing methods using SAS macros.
• Owning 40+ Billing & Operational reports and automate them to be executed on daily frequency.
• Extracted data from various data sources and build a bridge between SAS and Hadoop in order to use the output datasets for visualization.
• Extensive use of SQL queries to modify, fetch and manipulate data from the server.
• Working in Agile methodology and supporting onshore team in any way possible.
• Working on Migration project for SAS towards cloud based platform using Pyspark.

Sep 2015 – Jun 2019 · 3 yrs 9 mos · Gurgaon, India

• Responsible for Implementing different Client Requirements along with
• Requirement Analysis and generating Business Report for the same.
• Provided a secure environment while allowing one to build, test, maintain, and
• deploy business applications in an automated manner using in-house application
• provided by UNISYS.
• Owning the complete responsibility of implementing New Client Requirement in
• assigned portfolios by various SAS Functions and Procedures.
• Writing SQL Queries to fetch required data from Teradata tables as per
• requirements.
• Imported data from MS-excel to SAS data set & performed Data validation & Data
• Manipulation by SAS Functions and other tools.
• Used SAS/SQL for combining, creating & eliminating the duplicate data of different
• files.
• Worked on dev requests, data requests, system incident request, defects,
• incidents etc. on ServiceNow to ensure smooth testing and delivery of several
• projects.
• Produced customized reports for Performance Optimization by using various
• procedures.
• Adapted Agile methodology, KANBAN & SDLC model and delivered projects on
• several sprints with adequate use of JIRA tool.
• Implemented various models in a fully automated system (SAS & SQL) for
• validation (standard statistical, logical and accuracy tests) working on total assets
• of 500 billion GBP and 20 million customers thereby, resulting in ~70%
• reduction in turnaround time.
• Significant client exposure while engaging with multiple functional platforms.

May 2014 – Jul 2014 · 2 mos

• Study of various equipments of GIS Substation used in Power Transmission Operation, Maintenance and Testing activities.

Jun 2013 – Jul 2013 · 1 mo

• I worked as a trainee engineer on a Power Plant Management gaining a hands-on experience in the field of power systems.
• The project covered the various processes that take place in the generation of thermal power on a practical scale as well as how the distribution of electricity is done.
• Examined the working of various substation equipments and protection systems.