Arpit Chauhan
Business Analyst
Lucknow
Summary
Dynamic Business Analyst with 8 years of experience specializing in transforming business requirements into actionable insights and enhancing operational efficiencies. Proficient in leveraging tools such as Power BI and SQL to develop interactive dashboards that drive data-driven decision-making. Expertise in bridging communication between technical teams and stakeholders, ensuring seamless project execution and user acceptance testing. Committed to continuous improvement, with a strong foundation in documenting functional and technical requirements. Proven ability to automate processes and enhance user experiences across diverse industries.
Overview
10
10
years of professional experience
4
4
Certifications
Work History
Business Analyst/Power BI developer
Tata Consultancy Services
07.2024 - Current
- Working as a business analyst for NASSCOM,(National Association of Software and Service Companies) which is an Indian non-governmental trade association and advocacy group that primarily serves the Indian technology industry. NASSCOM operates as a nonprofit organization and serves as a key entity within the Indian technology sector.
- Helped in building Power BI dashboard to track business metrics of NASSCOM’s e-learning platform 'Future Skills Prime'.
- Gathered data from multiple sources and create interactive dashboards for business analysis.
- Captured business requirement and effectively communicated the same to technical team.
- Collaborated with business users, gathered requirement, and created new dashboards for management to track the platform's traction.
- Comprehend business requirement in a BI context and developed data models to convert raw data into actionable insights.
- Involved in end to end stakeholder management from gathering requirement to conducting UAT and delivery.
- Assisted the end user with post-deployment issue resolution and resolving the issues within SLA to enhance customer experience.
Business Analyst
Tata Consultancy Services
08.2022 - 07.2024
- Working as a business analyst in True Value account, which is a US based hardware wholesaler with a trusted, iconic and globally-recognized brand.
- Draft User Stories, Acceptance Criteria and track issues sprint wise in JIRA tool.
- Conduct/Participate in Agile ceremonies like Sprint Planning, Stand-ups, Sprint Retrospective providing support in sprint plans, working closely with Product Owner and Scrum master.
- Modify the existing application of True Value Company to enhance user experience and improve business of the organization.
- Create wireframes and functional requirement document.
- Manage end to end delivery of the implementation and prepared efforts estimate for approach, testing the deliverable, facilitate UAT testing and releasing it to production.
- Capturing business requirements and effectively communicating the same to the technical team.
- Engaged stakeholders in functional and Non-Functional requirements and translated requirements into actionable plans.
- Actively involved in documenting functional requirement documents (FRD), technical requirement documents (TRD), unit test cases (UTC) and integrated test cases (ITC).
- Assisted the business by creating Admin tool to administer the feature of CTB products on the E-commerce website.
Business Analyst
Tata Consultancy Services
08.2015 - 08.2020
- Automated the ordering process for Walgreens which is the largest drug retailing chain in United States. The Company operated 8000+ stores in all 50 states.
- Involved in extract transform and load processes using Ab - initio as an ETL tool.
- Actively involved in documenting functional requirement documents (FRD), technical requirement documents (TRD), unit test cases (UTC) and integrated test cases (ITC).
- Creating Traceability matrix for tracing the technical requirements to functional requirements and simultaneously tracing functional requirements to business requirements.
- Conducted User acceptance testing (UAT).
- Performing Root Cause Analysis on application specific faults and work upon to devise a permanent fix.
- Maintaining Standard Operating procedures (SOPs) for repetitive failures.
- Created process flow diagrams and documents using MS Visio for business team.
- Acted as a bridge between the offshore and onshore team and facilitated the smooth functioning of the project.
Education
MBA - I.T
APJ Abdul Kalam Technical University Lucknow
07-2022
B.Tech - ME
APJ Abdul Kalam Technical University Lucknow
01.2015
Skills
- Ab - initio(ETL Tool)
- Microsoft Excel PowerPoint
- SQL
- Power BI
Certification
Awarded ON THE SPOT award for exceptional performance and dedication during pandemic.
Timeline
Business Analyst/Power BI developer
Tata Consultancy Services
07.2024 - Current
Business Analyst
Tata Consultancy Services
08.2022 - 07.2024
Business Analyst
Tata Consultancy Services
08.2015 - 08.2020
MBA - I.T
APJ Abdul Kalam Technical University Lucknow
B.Tech - ME
APJ Abdul Kalam Technical University Lucknow
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
Ritika AgarwalRitika Agarwal
Power BI Developer at Tata Consultancy ServicesPower BI Developer at Tata Consultancy Services