Ravinder Shahrawat
AVP
Gurugram
Summary
Technical professional with proven track record in guiding development teams through complex projects. Known for driving impactful results and fostering collaborative team environment. Reliable and adaptable, ensuring project goals are met while leveraging technical expertise and strategic thinking.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Associate Vice President
NatWest Bank
Gurugram
05.2024 - Current
- Implemented data-driven decision-making practices to inform business strategy and optimize performance metrics across all departments using cloud Technology in AWS.
- Implementation of Agile Methodologies in project.
- Collaborated with cross-functional teams to drive process improvements and innovation.
- Working as solution Architect in developing end to end process using SPARK framework on AWS platform.
- Building migration solution from on-premise(SAS Based system) to cloud platform.
- Mentored junior team members, providing guidance on best practices and strategies to overcome challenges while simultaneously strengthening their professional skillsets.
Associate Manager
Accenture Services Pvt Ltd
Gurugram
01.2021 - 04.2024
- Leading Commercial Credit Card and Mortgage Reporting team
- Exposure to creating and maintaining Datamart for downstream users like IFRS9, Basel, Exposures, Defaults
- Experience in Model Monitoring and validation
- Managing AWS cloud Migration Project for UK Bank
- Leading Cloud Migration Activity for around 20+ Teams like IFRS9, Provisional, Retail, Capital for their Mortgage accounts
- Pyspark migration of Datamart process from Legacy SAS EG
- Pyspark migration of SQL Server report to AWS environment
- Worked with departmental heads, managers, and other stakeholders to understand and implement the new environment/process flow
- Write Project Report/Progress as necessary
- Performing UAT Testing for projects/platform and getting client/vendor signoff
SAS Consultant
EXL Services Pvt. Ltd.
Gurugram
08.2018 - 01.2021
- Data analysis, coding and validation for scoring logic and adverse action codes of machine learning and logistic models
- Operating in sync with Business strategy and Model Development team for understanding requirements of model
- Thereafter delivering the model which can be run on production environment in real time
- Preparation of model validation reports, waterfall reports and summarizing observations to the clients for business decision purposes by data extraction and analysis from Enterprise Data Warehouse using tools such as Teradata
- Leading CCAR/CECL Model Validation and Monitoring team
- Leading the CECL and CCAR Reporting work on branded cards for consumer and business
- Provides production support for ECM and CECL/CCAR Models
- Code migration from UAT to production environment
Senior Software Engineer
UHG Pvt. Ltd.
Gurugram
07.2014 - 08.2018
- Extracting, Transferring, and Loading the target population to database
- Handling the File Management Work
- Reviewing, Validating and Loading the Client/Vendor files/Data to data warehouse
- Preparing SQL Queries for extracting data from warehouse
- Writes SAS programs for any ad-hoc or permanent report required by the client
- Requirement Analysis for New Client/Vendor Implementation
- Direct Interaction with Client/Vendors
Batch Technical Analyst
Aon Hewitt
Gurugram
08.2010 - 07.2014
- Write codes in JCL to run batch jobs which process daily transaction and update record keeping system
- Also use SAS Programming language and write SQL queries to generate reports from the database
- Imported data from MS-excel to SAS data set & performed Data validation, Data Cleaning & Data Manipulation by SAS Functions and other tools
- Developed new SAS codes and SQL queries and updated any existing SAS codes and SQL queries
- Worked as Requirement Analyst and Senior Developer
Education
B.Tech - Information Technology
GGSIPU University
C.B.S.E - 12th - undefined
Army Public School
C.B.S.E - 10th - undefined
Army Public School
Skills
Cloud : AWS (S3, Athena, EMR, AWS Glue , Cloudshell, Cloudwatch)
SAS Tools : SAS EG , SAS DI , SAS Management console, SAS Viya
Platform : Unix, Mainframe, Window
Scheduler : Autosys, Apache Airflow
Language : SAS , SQL ,PYTHON, Unix Scripting , Toad(Oracle)
DevOps Tools : SAFe Agile , JIRA, GIT, Gitlab
Profile Summary
- Around 14 years of work experience in diverse domains including BFSI, US Healthcare , Human Resource sectors.
- Leading Data strategy and cloud transformation journey from on-premise to AWS Infrastructure.
- Deep expertise in Credit Risk Analytics , mastering both on-premises and cloud hosted application.
- Collaborated with department heads, managers, and other stakeholders to comprehend and implement the new environment and process flow.
- Act as a champion of Agile methodologies (Scrum, Kanban, SAFe, etc.), ensuring the team adheres to Agile principles and practices. SAFe Agile Certified .
- Deep understanding on AWS cloud services like S3, Athena, CloudShell , EMR, Cloud Watch AWS Glue.
- Deep understanding on the Implementation of ETL process on Glue studio using SPARK framework using Python and SQL.
- Expertise in implementing end to end process using Analytical tool SAS on Mainframe, Unix and Window platform.
- Exposure to CCR and CECL (regulatory frameworks in the financial industry) Model Validation and monitoring.
- Exposure on Devops tools like Gitlab CI/CD, GIT, Teamcity, Bitbucket, Microsoft Team, Airflow, Autosys, JIRA etc.
- Understanding of Unix command and scripts.
Certification
SAFe Agile
Timeline
SAFe Agile
11-2024
Associate Vice President
NatWest Bank
05.2024 - Current
Associate Manager
Accenture Services Pvt Ltd
01.2021 - 04.2024
SAS Consultant
EXL Services Pvt. Ltd.
08.2018 - 01.2021
Senior Software Engineer
UHG Pvt. Ltd.
07.2014 - 08.2018
Batch Technical Analyst
Aon Hewitt
08.2010 - 07.2014
C.B.S.E - 12th - undefined
Army Public School
C.B.S.E - 10th - undefined
Army Public School
B.Tech - Information Technology
GGSIPU University
Similar Profiles
DEEPAK JHADEEPAK JHA
Senior Business Analyst at NatWest BankSenior Business Analyst at NatWest Bank
Abhishek DanduAbhishek Dandu
Senior Analyst at NatWest BankSenior Analyst at NatWest Bank
Charles MACBYCharles MACBY
AGILE PROJECT MANAGER-SCRUM MASTER at NATWEST BANKAGILE PROJECT MANAGER-SCRUM MASTER at NATWEST BANK