JANANI B
Coimbatore
Summary
Dedicated and highly skilled Business Intelligence Analyst with a strong background in data analysis, reporting, and insights generation. Seeking to leverage my analytical expertise to develop and implement business reports that align with demand and business objectives.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
Beroe
Chennai
06.2024 - Current
- Data Processing & Analysis: Managed large datasets, performed data cleaning, transformation, and validation to ensure accuracy and consistency.
- Forecasting & Pricing Models: Developed and maintained cost driver analysis, price deviation checks, and forecasting models using Excel and Python.
- Currency & Unit Conversions: Implemented automated scripts for currency conversion and unit standardization, ensuring data integrity across reports.
- Excel Automation & Formulas: Created complex Excel formulas and macros to extract, compare, and validate forecasted prices against historical trends.
- Data Integration: Matched cost driver IDs and monthly data across multiple sheets and files to generate accurate insights.
- Collaboration & Reporting: Worked closely with teams like procurement and finance to deliver data-driven insights and reports.
- Tools & Technologies: Excel (advanced formulas, pivot tables, Power Query), Python (pandas, NumPy), SQL, and Power BI/Tableau for visualization.
Data Analyst
Healthsy
Coimbatore
08.2023 - 06.2024
- Collaborate with cross-functional teams to collect, analyze, and report data
- Utilize data analysis tools, including Tableau, Power BI, and SQL, to create and maintain reports and key performance indicators (KPIs)
- Conduct in-depth analysis of business data, extracting valuable insights and presenting actionable information to decision-makers
- Identify process improvement opportunities and develop solutions to strengthen processes for the organization
- Creating log files using VBA scripts to automate and record activities
- Also automating the linking and connection of Google Sheets to Excel
- Writing Python code to automate Google Sheets with Excel for analytics
- Creating macros to automate tasks and develop a task manager
- Creating Google Sheets for viewing analytics using charts and pivot tables
- Creating dashboards using Power BI to visualize analytics
Data Analyst
KornFerry
Banglore
12.2022 - 04.2023
- Developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality
- Acquiring data from primary and secondary data sources and maintaining databases
- Identify, analyze, and interpret trends or patterns in complex datasets
- Preparing reports for management, stating trends, patterns, and compelling reports and insights
- Analyzing the data using visualizing tool Power BI and Tableau and giving insights on the data
Research Specialist
Draup
Coimbatore
06.2021 - 12.2022
- Collect, clean, and organize data from various sources and platforms
- Perform statistical analysis and develop reports and visualizations to communicate findings with stakeholders
- Work with cross-functional teams to identify trends and patterns in data
- Preparing final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends
- Validating the data based on the output of machine learning models and providing insights on improving the model
Education
M.Sc. - Data Analytics
PSGR Krishnammal College For Women
Coimbatore05.2021
BCA - Bachelor of Computer Application
PSGR Krishnammal College For Women
Coimbatore05.2019
Skills
- Data Analysis
- Tableau
- Power BI
- Python
- SQL
- Advanced Excel
- EDA
- Macros
- VBA Scripting
- Reporting and visualization
Certification
- Python for Data Science, 02/01/21
- Digital Marketing, 03/01/19
- Hackerank SQL Intermediate Certificate
Timeline
Data Analyst
Beroe
06.2024 - Current
Data Analyst
Healthsy
08.2023 - 06.2024
Data Analyst
KornFerry
12.2022 - 04.2023
Research Specialist
Draup
06.2021 - 12.2022
M.Sc. - Data Analytics
PSGR Krishnammal College For Women
BCA - Bachelor of Computer Application
PSGR Krishnammal College For Women
Similar Profiles
Sruthi RSruthi R
Customer Engagement Associate at BeroeCustomer Engagement Associate at Beroe
Namitha ReghunathNamitha Reghunath
Executive- Sales Operations at Beroe Consulting India Pvt. Ltd.Executive- Sales Operations at Beroe Consulting India Pvt. Ltd.
Sarath NambiarSarath Nambiar
Business Development Manager at Beroe IncBusiness Development Manager at Beroe Inc