Saurabh Agarwal
Senior Business Analyst
Summary
Seasoned Business Analyst offering 7+ years of Mortgage and Telecom industry success. Expert on business and systems requirements, user acceptance testing and end-user training. Accomplished at leveraging past lessons to inform future decision-making.
Overview
7
7
years of professional experience
Work History
Business Analyst (Letter Processing Dashboard)
Ocwen Financial Cooperation
Bengaluru
08.2022 - Current
- Letter Processing Dashboard is built up to track the timeliness of the letters for each stage
- This Dashboard helps the team to save 4 hours on daily manual work
- Dashboard was tested in excel first for around a month and then moved to MicroStrategy development region, and is now under testing on MSTR
- Cultivated interpersonal skills by building positive relationships with others
- Proved successful working within tight deadlines and a fast-paced environment
- Demonstrated respect, friendliness and willingness to help wherever needed
- In parallel keep providing training to interns, new joiners or refreshing session for existing employees for SQL or the existing database in use
Business Analyst (SSC Portal)
Ocwen Financial Corporation
Bengaluru
09.2021 - 07.2022
- This project helped us identify 192 reports for few of our investors which helps them to review their portfolio with the help of few metrics
- This portal will give the investors an access to login to our portal and review their portfolio on the important metrics required
- Each report was taken over by us and re modified or re structured as per the metric or logic requested by the investor
- Post making the final changes to the queries, reviewed and approved by investors it was moved to Microstrategy
- Acted as a team leader in group projects, delegating tasks and providing feedback.
- Assisted with day-to-day operations, working efficiently and productively with all team members.
Business Analyst (State Exam)
Ocwen Financial Corporation
Bengaluru
02.2021 - 08.2021
- Request received from government authorities from US to share the details of the loans as per their requirement
- This request is more of audits from government authorities
- This request involves process of connecting with the requester to understand the exact requirement, getting the report ready as per the request, get it reviewed within the organization, get the approval and then share it with the requester
- This was time sensitive project which I needed to share the within 3-7 Business days depending upon the complexity of the report
- Provided professional services and support in a dynamic work environment.
- Demonstrated strong organizational and time management skills while managing multiple projects.
Business Analyst
Ocwen Financial Corporation
Bangalore
05.2020 - 01.2021
- Review all the existing reports in production and identify the ones affected due to the timeline activity across the company
- Almost 125 monthly automated reports identified as affected
- Make the necessary changes as required to fix the issue
- Get the fixed reports verified by Business Unit and get them updated on to the production
Data Analyst
TechMahindra
Pune
12.2018 - 04.2020
- Data Extraction, Cleansing and Processing
- Experience in writing queries, sub queries in SQL
- Report Automation Using Sql and Stored Procedures
- Worked as a Team Lead: Managing the team of four
- Weekly Dashboard for client presentation and maintaining KPI
- Offer professional expertise in providing Solutions, Root Cause Analysis and Strategic Fix for the operational issues
- Produced monthly reports using advanced Excel spreadsheet functions.
- Collaborated with business-unit leaders to identify and prioritize problems.
Data Analyst
BT RCIO
Pune
09.2017 - 11.2018
- Measured Operational Impact on Customer Experience, Service Blockers and Loss to Business with appropriate documentation and its presentation to stakeholders
- Business oriented data analyst offering professional expertise in providing Solutions, Root Cause Analysis and Strategic Fix for the operational issues
- Ensured KPI reports, dashboards and all other reports are well maintained and are in accordance with required standards
- Weekly data extraction, cleansing , processing and then Investigation to provide RCA for High Level Complaints
- Preparing Weekly Dashboard
Data Analyst
Tech Mahindra
Pune
08.2016 - 09.2017
- Responsible for KPI delivery as per agreed targets
- Manage and update KPI and other dashboards periodically and represent the same to the client on Review call
- Raise incident and liaise with components/other teams for issue and incident resolution
- Understand the End-to-End process and the L2C order flow journey
- Data integrity and analysis
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Education
B.Tech - Electronics And Communications Engineering
APJ Abdul Kalam University
Ghaziabad 08.2012 - 2016.05
Intermediate -
Central Academy
Lucknow 03.2010 - 2011.05
Skills
Data Analysis
undefinedWork Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Business Analyst (Letter Processing Dashboard)
Ocwen Financial Cooperation
08.2022 - Current
Business Analyst (SSC Portal)
Ocwen Financial Corporation
09.2021 - 07.2022
Business Analyst (State Exam)
Ocwen Financial Corporation
02.2021 - 08.2021
Business Analyst
Ocwen Financial Corporation
05.2020 - 01.2021
Data Analyst
TechMahindra
12.2018 - 04.2020
Data Analyst
BT RCIO
09.2017 - 11.2018
Data Analyst
Tech Mahindra
08.2016 - 09.2017
B.Tech - Electronics And Communications Engineering
APJ Abdul Kalam University
08.2012 - 2016.05
Intermediate -
Central Academy
03.2010 - 2011.05
Similar Profiles
Pooja Goyal SPooja Goyal S
Senior Specialist at Ocwen Financial CorporationSenior Specialist at Ocwen Financial Corporation
M Praveen KumarM Praveen Kumar
Financial Analyst at Ocwen Financial Solutions Pvt LtdFinancial Analyst at Ocwen Financial Solutions Pvt Ltd
M PRAVEENM PRAVEEN
Financial Analyst at Ocwen Financial Solutions Pvt LtdFinancial Analyst at Ocwen Financial Solutions Pvt Ltd