Summary
Overview
Work History
Education
Skills
Websites
Acknowledgments
Certification
Timeline
Generic

Nikita Kansal

New Delhi

Summary

Business Analyst with 9 years of experience in data-driven solutions and process optimization within banking and IT consulting. Proficient in SQL, Power BI, and AI analytics to deliver actionable insights and automate workflows. Demonstrated success in leading cross-functional teams and aligning stakeholder requirements to enhance project delivery.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Lead Business Analyst

Tata Consultancy Services
New Delhi
10.2023 - Current
  • Directed team of 9 associates, including junior BAs and testers, to achieve operational targets and meet client-defined SLAs.
  • Utilized large data sets to generate actionable insights, creating dashboards in Excel, SQL, and Power BI, reducing decision-making time by 30%.
  • Drafted user stories and automated documentation using ChatGPT and Copilot, expediting turnaround time.
  • Converted manual processes to digital platforms, achieving a 40% reduction in processing time.
  • Evaluated impacts of future developments on systems and procedures, highlighting interdependencies within organization.

Business Analyst

Tata Consultancy Services
New Delhi
07.2022 - 09.2023
  • Conducted gap analysis to evaluate current and future state requirements, reducing project rework by 25%.
  • Facilitated workshops to elicit requirements and align project goals.
  • Collaborated with over 30 development team members to define functional and non-functional product requirements.
  • Managed JIRA and Confluence for data analysis, developing more than 15 custom dashboards.
  • Utilized Power BI to deliver actionable insights, decreasing analysis time by 30%.

Business Analyst

ICICI Bank LTD
New Delhi
01.2015 - 06.2022
  • Developed CRM dashboard to analyze transactions and identify trends, increasing customer satisfaction by 15%.
  • Integrated investment platforms with core banking services for seamless cross-selling of products.
  • Prepared process flows, use cases, and wireframes to enhance project clarity and reduce rework by 25%.
  • Delivered timely support by tracking issues and communicating resolutions to end users.
  • Managed requirements traceability information and tracked requirements status throughout the project.

Education

B.Tech - IT

Lovely Professional University
01.2014

Skills

  • Agile methodology (Scrum and Kanban)
  • Use case development
  • Power BI
  • Documentation (BRD, FSD, SRS, SOP)
  • Business process modeling (UML)
  • Prototyping and wireframing
  • SQL database management
  • Gap analysis
  • Jira project management
  • Generative AI (ChatGPT, Copilot)
  • Data analysis
  • User story creation
  • Requirements gathering

Acknowledgments

  • Best Team Award- Our team of 5 won the 'Best Team' award for meeting delivery timelines and receiving formal client appreciation.
  • On the Spot Award- Received the 'On the Spot' Award for completing a critical task on time, unlocking new business opportunities and additional revenue streams.

Certification

  • Certified Business Analysis Professional (CBAP) — Pursuing

Timeline

Lead Business Analyst

Tata Consultancy Services
10.2023 - Current

Business Analyst

Tata Consultancy Services
07.2022 - 09.2023

Business Analyst

ICICI Bank LTD
01.2015 - 06.2022

B.Tech - IT

Lovely Professional University
Nikita Kansal