Neerja Virmani Wadhwa
Auckland,AUK
Summary
Overall, 9.5 years' experience, interacting with Tech and Reporting Team for Requirement analysis and implementing different technical solutions. My core competencies include Data Quality and Reporting, Data cleaning and Validation, Credit Risk knowledge, SQL, SAS, Excel, Campaign Fulfillment Management.
Overview
10
10
years of professional experience
Work History
Database Administrator
Oceana Homes And Developments Limited
Auckland, AUK
12.2023 - Current
- Managing Database access and permissions.
- Work with business teams to provide reporting services to both internal and external stakeholders.
- Enhanced reporting capabilities by designing efficient ETL processes that improved data accuracy and completeness.
Senior Consultant
Ernst & Young
India
12.2021 - 12.2023
- Worked on writing the SAS/SQL codes to fetch the required data from the Database as per the requirements.
- Enhanced data accuracy by implementing SAS techniques for data cleaning and validation.
- Compiled, cleaned and manipulated data for proper handling.
- Worked on setting up the End-to-End Data Quality Process to define rules and Thresholds, executing DQ checks, identifying and raising the Data quality issues and perform the root cause Analysis.
- Developed comprehensive documentation for data quality processes, enabling easy replication of methods and practices.
- Leveraged data profiling and statistical analysis techniques to identify trends, patterns, and anomalies within datasets, guiding the development of targeted improvement strategies.
- Worked on Identification of the key BDE used in regulatory reporting and ensuring these are classified, defined, documented in the Data dictionary, and periodically accessed.
- Worked on Creation of Data Lineage at a BDE level for Key BDEs used in regulatory reporting to evident at least one hops up traceability to a trusted Data source.
- Worked with the IT team to get the IT systems mapping of the identified BDEs to ensure Completeness and Accuracy.
- Proactively monitor, analyze, execute, track and report data issues and solving them.
- Enhanced team performance by implementing training programs and fostering a collaborative work environment.
- Built strong relationships with clients through consistent communication and proactive problem-solving efforts.
- Created and developed detailed work plans to meet business priorities and deadlines.
- Prepared presentations to explain revisions, enhancements and process improvements of organization's programs.
Consultant
Exl services
India
05.2021 - 12.2021
- Extracting data, conducting data analysis, and addressing common data issues.
- Reviewed credit reports to comprehensively view borrowers' credit history and identify potential red flags.
- Collaborated with other teams to identify and mitigate risks impacting organization.
- Managed client relationships through regular check-ins and updates on project progress.
Senior Risk Analyst
NatWest (Formerly RBS)
India
09.2019 - 05.2021
- To handle the BAU reporting for retail products (cards, mortgage, personal loans and current accounts).
- To handle SAS projects (starting from analysis to implementation and debugging the ongoing SAS code errors).
- Analyzing the trends of the Risk data reports and solving Stakeholder's queries.
- Automate different processes using scripts to reduce manual efforts.
- Forecasting the losses by analyzing the customer behaviour such as delinquency, payment rate, roll rate etc.
- Experience to work on data extraction, transformation, and loading into the database.
- Handles Athena to Walker reconciliation project which covers the assets of personal Banking & Business Banking UK, Primary focus is to identify the material differences in Balance which could lead to provisioning impacts.
- Enhanced risk management processes by conducting thorough analyses and providing actionable recommendations.
- Improved decision-making by providing senior management with timely and accurate risk reporting.
- Produced reports to inform senior management of current activities and progress with investigations.
Analyst
HSBC
India
06.2018 - 09.2019
- Understanding the client requirements and formulating detailed execution plan for the business partners.
- Designing of several campaigns with the help of technologies like SAS, MS Excel and SQL where each campaign results in an average ROI of $2.5bn.
- Managed multiple campaigns simultaneously, ensuring timely execution and delivery of results.
- Managed a high volume of customer issues and determined root cause of problems to resolve Complaints.
- Interacting with the US based branch managers regularly for efficient resolution of project related queries.
Programmer Analyst Advance
Aon
India
06.2014 - 06.2018
- Prepared new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Formats, and Functions
- Developed and improved the efficiency of programs through the use of SAS macros.
- Optimized code quality through regular peer reviews, resulting in fewer defects and easier maintenance.
- Mentored junior developers on best practices, helping them grow their skill sets while enhancing overall team capabilities.
- Documented program development and revisions to maintain records.
Education
Bachelors in Computer Science -
Maharishi Markandeshwar University
06.2014
Diploma in Computer Science -
Maharishi Markandeshwar University
05.2011
Skills
- Data Analysis
- Data Quality Methodologies
- Data Cleaning and Validation
- Data Lineage
- SAS Programming
- SQL
- Microsoft Excel
- Credit Risk Knowledge
- Credit Reporting
- Project Management
- Campaign Management
- Client relationship management
Languages
English
Hindi
References
Vipul Elawadhi, Ernst & Young, contact.vipulelawadhi@gmail.com, +91-9871848242
Extracurricular Activities
- Team Star Award for Share the experience.
- Week day Champ Award for excellent Client Deliverables.
Hobbies and Interests
- Reading
- Travel
- Dance
- Listening to music
- Volunteering
Timeline
Database Administrator
Oceana Homes And Developments Limited
12.2023 - Current
Senior Consultant
Ernst & Young
12.2021 - 12.2023
Consultant
Exl services
05.2021 - 12.2021
Senior Risk Analyst
NatWest (Formerly RBS)
09.2019 - 05.2021
Analyst
HSBC
06.2018 - 09.2019
Programmer Analyst Advance
Aon
06.2014 - 06.2018
Bachelors in Computer Science -
Maharishi Markandeshwar University
Diploma in Computer Science -
Maharishi Markandeshwar University