Vivek Kumar Dutta
Faridabad
Summary
Experienced Business Analyst specializing in Business Intelligence, with expertise in SQL and Advanced Excel for dashboard reporting and process optimization. Proven ability to conduct comprehensive data analysis, identify trends, and translate complex data into actionable insights to support strategic decision-making. Skilled in data visualization, analysis, and modeling, fostering effective cross-functional collaboration and communication. Recognized for strong problem-solving abilities and business acumen, driving strategic initiatives and delivering measurable results. Proficient in client management and adept at handling customer escalations, ensuring a high standard of service and satisfaction.
Overview
9
9
years of professional experience
Work History
Business Analyst
TATA Consultancy services
02.2020 - Current
- Currently serving as a Business Analyst in the Business Intelligence (BI) team, where focus on developing key performance indicators (KPIs) for dashboards by consolidating issues from Jira and gathering detailed requirements through customer interactions
- I am responsible for defining roles and drafting user stories for new business module development, as well as outlining application functionality and logic
- In addition, I support the Data Warehousing (DWH) team by addressing daily operational and dashboard-related challenges, managing client escalations, sharing timely updates, conducting root cause analyses (RCA), and obtaining approvals for logic modifications as needed
- My role demands a high level of precision and collaborative communication to drive project alignment and operational efficiency
Post-Closing Underwriting QC/Underwriting Complete Review
Tata Consultancy Services
02.2020 - 08.2023
- Audit complete underwriting 4c’s (Credit, Collateral, Capital, Capacity) for onshore underwriters Post-Closing/Underwriting Audit Phase for secondary Market
- Post-Closing underwriting for complete package like Asset, Income, Credit and Collateral
- Following Fannie Mae and Freddie Mac guidelines and Underwriting Loan programs of conventional, conforming, nonconforming Loans, Jumbo loans
- Verifying Reverification of Employment and Transcript & Business Transcript Result after Closing
- Following Client Updates and working Accordingly
- Also Preparing Consolidation sheet of Production worksheet on Weekly basis
Senior Associate (Us Mortgage Underwriter)
EXL Services India PVT LTD
10.2018 - 02.2020
- U.S
- Mortgage Underwriting Conventional – Refinance/Purchase
- Review and verify 1003 URLA application all 10 sections, Credit Report, Preliminary Title Report, Appraisal Report, Flood Certification, Flood Insurance, Hazard Insurance
- Run 1003, AUS (DU/LPA) and 1008, review and stated comments to further move files- Assets Statement, Income calculation, DTI and LTV with other source of income like Paystub, W2, 1099, Personal Tax Return 1040, Rental Income if subject property is Investment Property, Divorce Decree, Credit Supplement, Fraud Checklist
- Also Provided Team support and Trained Peoples in US Mortgage Underwriting and sharing Client Updates with Team
Quality Analyst (US Mortgage)
Quatrro mortgages solution
07.2016 - 10.2018
- Review and verify 1003 URLA application all 10 sections, review all disclosure documents and supporting/mandate documents like Flood Certification, Flood Insurance, Hazard Insurance, Credit Report, Divorce Decree, Drive Report/Fraud Report and all relevant documents related mortgage file
- Process All documentation like standard operating procedure, checklist
- Auditing Loans and sharing Feedback to Team and Preparing Quality and Performance Data on Monthly basis
Senior Associate
Marche Retails Pvt. Ltd
07.2015 - 02.2016
- Responsible for delivering exceptional customer service, driving sales, and enhancing the in-store experience
- Lead by example in achieving sales targets, providing product expertise, and ensuring the highest standards of merchandising and store presentation
- Skilled in building lasting customer relationships, resolving inquiries efficiently, and handling complex transactions with accuracy
Education
Higher Secondary 12th - Commerce
G.B.Sr.Sec.School
Senior Secondary -
Vinay Nagar Bengali Sr. Sec.School
Master of Business Administration -
I.G.N.O.University
01.2024
Bachelor of Business Administration -
Guru Govind Singh Indraprastha University
01.2015
Skills
- Comprehensive problem-solving skills and quick learner
- Self-motivated and committed towards achieving the goals
- Always active with full energy and positive thinking
- A Team player with good management, Coaching, Teaching and Communication skills necessary to promote service of concepts
- Pivot tables
- Business process improvement
- Gap analysis
- Business process modeling
- Consulting
- Revenue development
- Cashflow processes
- Data Analysis
- Problem-solving abilities
- Customer Service
- Team Leadership
- Team building
- SQL Programming
- Statistical Analysis
- Business Forecasting
Languages
Hindi
English
Hobbies and Interests
- Football
- Net Surfing
Personal Information
- Father's Name: Pramod Kumar Dutta
- Date of Birth: 10/10/95
- Gender: Male
- Nationality: Indian
- Marital Status: Single
Timeline
Business Analyst
TATA Consultancy services
02.2020 - Current
Post-Closing Underwriting QC/Underwriting Complete Review
Tata Consultancy Services
02.2020 - 08.2023
Senior Associate (Us Mortgage Underwriter)
EXL Services India PVT LTD
10.2018 - 02.2020
Quality Analyst (US Mortgage)
Quatrro mortgages solution
07.2016 - 10.2018
Senior Associate
Marche Retails Pvt. Ltd
07.2015 - 02.2016
Senior Secondary -
Vinay Nagar Bengali Sr. Sec.School
Master of Business Administration -
I.G.N.O.University
Bachelor of Business Administration -
Guru Govind Singh Indraprastha University
Higher Secondary 12th - Commerce
G.B.Sr.Sec.School
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
HARSH BHARDWAJHARSH BHARDWAJ
Relationship Manager at Vipul Motors Pvt. Ltd.Relationship Manager at Vipul Motors Pvt. Ltd.