Lavanya Bandharu

I am an Data Analyst in Hinduja group company working on MS Excel preparing weekly reports, Dashboard, PowerPoint, Pivot Tables also on Excel formulas.

Beside that working on Power Automation, Power BI preparing dashboards.Any other work associated by Management is done by me.

In detail what I do in Hinduja( Hinduja Rooftop Private Limited)

• Monitoring Network Operation Centre for Rooftop Plants. (Report on Summary Plant also raising flags on site).
• Updating of Operation Asset. (Details of Inverter & Data Logger In detail).
• DGR Automation. (Through Power apps).
• Repository Management. (Maintain a document Repository of project-related reports on SharePoint).
• Monitoring Noc for Ground Mount Plants. (Compile by the daily report of Ground Mount SCADA 2 times a day).
• Process Automation. (Create four process automation flows using Macro & Power Automate apps).
• Prepare Pivot Reports and charts & create dashboards as per management requirements. 
 

I am well pleased to learn more about Data Analyst & Management.

I completed my Graduation in BCA from SNDT University in 2015.

My skills are Singing,Cooking.

Project Learnings:

Analyzed Ecommerce Sales Data created an Interactive Dashboard by using Power Bi.

• Created interactive dashboard to track and analyze online sales data.
• Used complex parameters to drill down in worksheet and customization using filters and slicers.
• Created connections, join new tables, calculations to manipulate data and enable user driven parameters for visualizations.
• Used different types of customized visualization (bar chart, Pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map slicers, etc)

Project Key Points:

Data Collection, Data Cleaning & wrangling, Data modeling, Data Visualization, Dashboard design, Sharing Insights.

Data Analysis project using PYTHON.

• Performed data cleaning and manipulation.
• Performed exploratory data analysis (EDA) using pandas, matplotlib and seaborn libraries.
• Improved customer experience by identifying potential customers across different states, occupation, gender and age groups.
• Improved sales by identifying most selling product categories and products, which can help to plan inventory and hence meet the demands.

Company Name: Hinduja Rooftop Pvt Ltd. (Hinduja Renewables Group Company)
Role/Designation: Data Analyst
Duration: 24th May 22 to till date.
SOFTWARE SKILLS:
• Power Apps, Power BI, Tableau.
• Certification of Completion in Data Visualization with Power BI & Data Science Foundations.

Company Name: Samsung C & T Pvt Ltd - Worli
Role/Designation: IT Support (Executive)
Duration: 15th March 2016 till 7th June 2019
SOFTWARE SKILLS:
• Vlookup, Hlookup, Pivot Table or Chart, Data Validation, IF Formula, Subtotal, Advance Excel etc.
 

Company Name: Aqua Related Business - Chembur
Client Name: Ion’s Exchange
Role/Designation: Administrator Executive 
Duration: 8th May 2015 – 12th March2016
Responsibilities:
• Carry out daily administrative tasks.
• Coordinate with clients and follow up on payments and settlement of bills
• Handle petty cash, floats and expenses.
• Knowledge of any relevant Payroll, HR and staffing issues.

Company Name: GlaxoSmithKline Pharmaceuticals Ltd – Worli,
Role/Designation: Vocational Apprentice   (Part-time) 
Duration: 1st Aug 2012 – 31st July 2013

KEY SKILLS:
• Dedicated and loyal towards work and organization, with ample experience in administrative work.
• Ability to work on multiple tasks efficiently & able to work independently.

2015 BCA SNDT University 68.75%
2012 Class XII Hemu Kalani Junior College, Maharashtra State Board 74.33%
2010 Class X Shree Sanatan Dharam Vidyalaya, Maharashtra State Board 54.55%
2017 Certification Microsoft Dot Net Certification (Course) from St. Angelo’s Institute
66.66%