BHARATH BALAJI SRIDHAR
Wellington,WGN
Summary
5+ years of data analyst experience at TCS. Designed and developed high impacted data solutions for senior stakeholders at TCS.Proficient in analysing complex data sets and providing strategic advice. Results-driven professional with expertise in summary generation, team management, and data analysis. Highly motivated to learn and excel in the industry, and eager to contribute to team success.
Overview
9
9
years of professional experience
Work History
Tata Consultancy Services, Airlines Revenue Management
09.2017 - 01.2023
- The team of flight analysts updates the Safety Database with business outcome data, which we then extract using SQL and feed into the relevant datasets
- In the wake of business EOD, we are gathering RDS forms
- The additional forecasting and predictive analysis we use is based on result sets from Python programming
- SQL fare sync, EMSR principles, daily price updates, and AU connections
- We do this with all interconnection result sets
- The outcomes of those analyses are transformed into interactive dashboards for the stakeholders to understand
- Collaborate with network planning team and stakeholders to understand their analytical needs and define clear intention or extracting insights from data
- Collaborate with cross functional teams to understand their data needs, desired outcomes, and specific requirements to create the SQL query and DAX Measures
- Collaborate with flight analyst team to draw the solution for fare sync with the use of SQL queries
- Responsible for presenting interactive dashboards in Power BI to the stakeholders for the futuristic decision and to show the past growth
- Responsible for tax updating using SQL queries for the upcoming days
- Responsible for qualitative and quantitative checking of data which collaborates with flight analyst team
- Responsible for final reports in Power BI that must be submitted to DGCA
- Responsible for data extraction process using SQL queries
- Responsible to analyse large datasets, perform complex queries, and extract relevant information for business needs
- This involves understanding data structures, subqueries, joining tables, Date functions and applying various filtering and group functions to generate meaningful insights
- Responsible to create DAX measures and calculations to perform in-depth past business performance analysis and create interactive visualizations in Power BI
- Develop compelling reports and dashboards that provide meaningful insights to stakeholders
- Leverage DAX measures to slice and dice data dynamically for exploration
- Prepared monthly, shrinkage, and performance reports, and conducted Weekly Business Reviews (WBR) and Monthly Business Reviews (MBR)
- Participate in weekly release meetings with the data architect and database administrator team to stay current on market trends, the development of data analysis tools and processes, and actively looking for chances to improve analytical abilities
- Assist in data migration and integration projects by ensuring that SQL constraints are properly defined and maintained during the process and collaborate with data architect’s team to ensure data quality and integrity during the migration or integration.
Tata Consultancy Services and Banking and Financial Services
12.2013 - 07.2017
- I Started my career as Junior system engineer who was responsible for the collecting the data from services now and organizing data in excel
- Performing complex SQL queries and calculations
- Collaborate with my lead to understand the overarching goals and priorities of the project
- Responsible for write a SQL to Calculate the total interest earned by the bank from all active loans in the loan department
- Interacted with clients, Business analysts and technical architects to understand the requirements and design the solution approach
- Perform root cause analysis for recurring issues and implement preventive measures to avoid future incidents.
Education
Master of Science - Computer Technology
St. Joseph’s College of Engineering, Anna University
Chennai, India2012
Skills
- Statistical Methods: Forecasting Analysis,Predictive Analysis, Basket Analysis, Probability Distribution, Hypothesis
- Database Language SQL, PLSQL
- Data Reporting Tool Microsoft Power BI
- Power BI Data Modeling
- DAX
- Testing and ANOVA
- Python
- Domain Experience : Airlines Revenue Management, Banking and Financial Services
Additional Information
- ACHIEVEMENTS , Four times Star Performer Award holder for timely and innovative deliveries for sprint commitments.
Timeline
Tata Consultancy Services, Airlines Revenue Management
09.2017 - 01.2023
Tata Consultancy Services and Banking and Financial Services
12.2013 - 07.2017
Master of Science - Computer Technology
St. Joseph’s College of Engineering, Anna University
Similar Profiles
Bharath Balaji SridharBharath Balaji Sridhar
Business Intelligence Analyst at Tata Consultancy Services And Airlines Revenue ManagementBusiness Intelligence Analyst at Tata Consultancy Services And Airlines Revenue Management
Yasar Arafath BasheerYasar Arafath Basheer
Application Support Analyst at TATA Consultancy Services / Client: Singapore AirlinesApplication Support Analyst at TATA Consultancy Services / Client: Singapore Airlines
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited