Likitha K N
Data Analyst
Bangalore
Overview
4
4
years of professional experience
Work History
Data Analyst
Tata Consultancy Services
04.2023 - Current
- Designed and deployed a suite of interactive Revenue Performance Dashboards in Power BI, providing senior management with real-time visibility into Monthly Recurring Revenue (MRR) and Gross Revenue figures.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Executed detailed variance analysis by comparing actual vs. forecasted revenue data, using MySQL to drill down into regional and product-level discrepancies and presenting findings to the Finance department.
- Supported the Finance team during the quarterly close by running validated MySQL scripts to reconcile invoiced amounts with recorded revenue, ensuring 99% data integrity.
- Created preliminary visualizations in Power BI to analyze historical revenue trends and seasonal fluctuations.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Documented the data lineage for key revenue metrics, including the specific MySQL tables and columns used, improving transparency for downstream reporting.
Mainframe Developer
Tata Consultancy Services
08.2021 - 03.2023
- Monitored code and overall application to drive seamless performance.
- Developed and executed complex system test plans to support quality.
- Improved application scalability by refactoring existing codebase and optimizing resource utilization.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Ensured data integrity through the implementation of rigorous testing procedures and validation techniques.
Education
B.Tech/B.E. - Electronics/Telecommunication
CMR Institute of Technology
Bangalore01.2021
Skills
Python
Accomplishments
Microsoft Certified: Power BI Data Analyst Associate-Microsoft
Learning Excel 2019 - LinkedIn learning
SQL Server Fundamentals - LinkedIn learning
Timeline
Data Analyst
Tata Consultancy Services
04.2023 - Current
Mainframe Developer
Tata Consultancy Services
08.2021 - 03.2023
B.Tech/B.E. - Electronics/Telecommunication
CMR Institute of Technology