Subhra Sen
Bangalore
Summary
Professional IT Analyst with a proven track record at Tata Consultancy Services, excelling in data visualization and stakeholder engagement. Spearheaded critical projects, enhancing data capture accuracy and driving adoption of innovative solutions. Adept in SQL, PBI and SAS, I thrive on delivering impactful insights that inform strategic decision-making.
Overview
17
17
years of professional experience
1
1
Certification
Work History
IT Analyst
Tata Consultancy Services
11.2023 - Current
- Lead critical projects for leading CPG company on Monitoring and Evaluation assessment, Regenerative Agriculture, Emissions etc on implementation to completion
- Facilitate UAT sessions and training workshops with end users newly developed assessment modules and mobile applications, improving adoption and data capture accuracy.
- Managed project timelines and deliverables to ensure timely completion of tasks
- Performed root cause analysis to determine underlying issues in complex problems
- Created functional document on Carbon Emissions, Extrapolation, Regenerative Agriculture for leading CPG client.
- Documented test cases for validating system functionality against user requirements.
- Mentoring new joiners and handling team on daily activities and assignments for smooth delivery.
Senior Business Analyst
Tata Consultancy Services
07.2015 - 11.2023
- Partner with Business Stake Holders to understand and gather requirements on procurement, sustainability, traceability for leading CPG client.
- Designed wireframes, mock-ups, and storyboards to capture business logic, report flow, and dashboard visualizations before handover to development teams.
- Worked closely with developers, data engineers, and BI specialists to design and deliver dashboards in Power BI for meaning insights
- Acted as a liaison between the business team and IT developers, ensuring clear communication, technical feasibility, and timely delivery of analytics solutions.
- Analyzed business requirements to identify gaps and recommend solutions
- Collaborated with stakeholders to gather and document project specifications
- Developed detailed reports to support decision-making and strategic planning
- Utilized Power BI as data visualization tool to present findings and insights effectively
- Extracting data using mainly SQL and SAS and analyzing using Excel.
- Understanding economic, socio demographic and geographic dynamics of market.
- Providing meaningful insights to different market variables as per client requirement.
- Working hand in hand with clients in a regular basis in understanding their need.
- Successfully implementing new customized setups according to client requests.
- Stratifying and allocating sample with accurate dispersion using SAS and excel.
- Engaged in calculation of projection factors, standard error calculation, designing master sample and questionnaires and sample maintenance using SAS, SQL and Excel
- Conducted regular coverage studies of client data to ensure our trends are accurate.
- Maintained Sample Quality Dashboard by checking the Sample Compliance.
- Prepare sample Key Performance Indicators (KPIs) and dashboard using Excel & PowerPoint.
- Handling team activities. Monitoring regular tasks of team members. Attending daily calls with all stakeholders and providing key inputs.
- Mentoring new joiners and making them process ready for operation.
- Work as a Single Point of Contact for Business Continuity Plans during business emergencies by coordinating with teams.
Business Analyst
Tata Consultancy Services
08.2011 - 07.2015
- Performing inspection on data trend on various leading FMCG/CPG Brands on sales for leading market research company.
- Supported ad-hoc analysis for client queries, including tracking shipment-to-sales variances, outlier detection on sales anomalies and providing insights.
- Working hand in hand with clients in a regular basis in understanding their need.
- Successfully implementing new customized setups according to client requests.
- Stratifying and allocating sample with accurate dispersion using SAS and excel.
- Engaged in calculation of projection factors, standard error calculation, designing master sample and questionnaires and sample maintenance using SAS, SQL and Excel
- Prepare sample Key Performance Indicators (KPIs) and dashboard using Excel & PowerPoint.
Research Associate
Barasat Government College
03.2009 - 09.2010
- Provided important suggestions in editing and framing the main questionnaire.
- Conducted the pilot survey.
- Meeting DM, BDO etc. to collect official data from their database.
- Analyzed the relevance of the data in the context of the project of other team members. Checked the consistency of the collected data.
- Worked as the team leader in the main survey team by mentoring and monitoring the performance of the other team members.
- Helped the team members in understanding the questionnaire.
Education
M.Sc. - Economics
University of Calcutta
Kolkata01.2008
Bachelor of Science - Economics
Uttarpara R.P.M. College
Uttarpara01.2006
Higher Secondary (10+2) - Science
Hoogly Branch School
Hooghly01.2002
Madhyamik (Secondary Examination) -
St. Johns High School
Bandel01.2000
Skills
- MS OFFICE
- Requirement gathering
- Data visualization
- Data analysis
- Stakeholder engagement
- Effective communication
- Basic SQL
- Joining multiple tables and Nested queries in SQL
- Conditional functions
- BASE SAS
- Producing LIST reports
- PROC procedures
- Reading raw data files
- SAS datasets
- Combining SAS datasets
- Concatenation
- Merging
- Importing Oracle database
- Exporting to csv
- Investigating data
- Summarizing data
- REPORT procedure
- TABULATE procedure
- Data manipulation
- Data transformation
- SAS functions
- Train users
Accomplishments
- Successfully leading complicated projects on the implementation of agri assessments
- Successfully implemented various dashboards and reports, such as regenerative agriculture, extrapolation, traceability, etc.
- Attended training for SAS Base and Advanced Module Learning comprised writing SAS codes for different business requirements
- Got promoted from Business Analyst to Senior Business Analyst
- Received the Spot Award for performance
- Successfully deployed a new setup for customized data structures
- Received the Star Performer award for the month of July 2018
- Two-time winner of the 'Guru' award for being one of the best mentors in the company
Certification
Obtained Azure AZ-900 certificate from Microsoft.
Projects
Completed a project on agricultural productivity and rural poverty, University of Calcutta, took part in the collection of secondary data from different official handbooks of institutes such as CU, CSSS, etc., analyzed the data using the Analysis of Variance (ANOVA) tool, worked with the team in writing the project report, presented the main project outcome
Affiliations
- Team building activities and curriculum such as Sapling, social cause activities
- Multiple-time winner of 'Market Minds,' a gamified business simulation for analysts to think like FMCG clients, involving endorsements, the creation of mock website wireframes, quizzes, etc
- Winner of school and locality one-act drama completion
Personal Information
Date of birth: 24th July, 1983
Present Address: R/AA 27, Raghunathpur East
P.O- Raghunathpur
Kolkata- 700059
Permanent Address: Pyne Bagan,
PO-Sahaganj, District-Hoogly,
Pincode-712104,
WEST BENGAL, INDIA
Languages
Bengali
First Language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2
Hobbies and Interests
- Cooking
- Watching Sports
- Travelling
References
Will be provided on request
Disclaimer
I do hereby declare that the information furnished above is true to the best of my knowledge and belief
Timeline
IT Analyst
Tata Consultancy Services
11.2023 - Current
Senior Business Analyst
Tata Consultancy Services
07.2015 - 11.2023
Business Analyst
Tata Consultancy Services
08.2011 - 07.2015
Research Associate
Barasat Government College
03.2009 - 09.2010
M.Sc. - Economics
University of Calcutta
Bachelor of Science - Economics
Uttarpara R.P.M. College
Higher Secondary (10+2) - Science
Hoogly Branch School
Madhyamik (Secondary Examination) -
St. Johns High 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
Sourav GhoshSourav Ghosh
Research Analyst-IT at Globsyn I.T Services (p) LtdResearch Analyst-IT at Globsyn I.T Services (p) Ltd