Amirtha Varshini M
Chennai
Summary
Detail-focused BI engineer having over 3 years experience in analytics with knowledge in data warehousing,Data visualization, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Business Intelligence Engineer
OEC
Chennai
09.2022 - Current
- Designed and implemented data pipelines using Azure Data Factory, streamlining data processing and improving efficiency for business intelligence and analytics.
- Developed complex SQL queries and created a multidimensional data warehouse for Fleet Base, enhancing data management and analysis capabilities.
- Built interactive Dashboards and what-if analysis reports in PowerBI for Leasing companies and Part Dealers enabling, real-time data exploration and scenario analysis.
- Implemented RLS,Deployment pipeline ,Gateways in PowerBI ,ensuring secure and reliable data access.
- Created and maintained multilingual features in PBI reports, allowing customers worldwide to access them in their preferred language.
- Developed data prediction models for product category mapping, resulting in increased automatic authorizations of vehicle workorders in one of OEC's large Fleet Product, significantly reducing manual efforts.
- Trained and mentored interns, sharing knowledge and expertise and fostering the growth of the next generation of data professionals.
Data Analyst
Latent View Analytics
Chennai
05.2019 - 08.2020
- Collaborated with the team to develop a Cloud Based Enterprise Data Hub using a design pattern approach for Data Ingestion in Microsoft Azure, contributing to a 60% reduction in execution time and a 30% reduction in overall expenses.
- Provided support in data modeling techniques and data transformation in azure data bricks.
- Developed a PowerBI dashboard to visualize core business Key Performance Indicators, such as Advisors churn ratio and Advisors behavioral insights, providing 97% accurate insights that helped the Sales team focus on quality leads.
- Implemented automated deployment of code across environments using CICD, reducing the time taken in Release management by 50%.
Software Developer Intern
Interlace India
Chennai
12.2018 - 04.2019
- Developed e-Bharat Mobile App for social welfare project using Java(Spring MVC and Hibernate) programming language.
- Also Developed web portal for the same using HTML, CSS and JQuery.Developed and maintained quality assurance procedure documentation.
Data Analyst Inplant Trainee
Subham Computers and Industrial School, Coimbatore
Coimbatore
05.2018 - 08.2018
- Collaborated with mentors to commission and decommission data sets, identifying and resolving data collection and reporting issues.
- Designed, executed, and measured the performance of e-Commerce visualizations using Tableau, optimizing end-to-end strategies for future design improvements
Education
Bachelor of Technology - Information Technology
PSG College of Engineering
Coimbatore05-2019
Skills
- SQL,DAX
- Power BI,Tableau,Excel
- Azure-Data Factory ,Databricks
- PySpark
- Python
Accomplishments
- Received the Guiding Principle Award for being an integral part of the Fleet Reporting project, recognizing dedication, hard work, and commitment to excellence in data analysis and management.
- Created RFP dashboards to offer data to stakeholders for the expansion and development of organization.
- Published case studies and blogs on Data ingestion into cloud and Investment Management.Published Dashboards for content publishing team on rising COVID cases in USA and Impact of COVID in travel industry .
Certification
- SQL, Python ,R ,Tableau Training -30 days
- Edureka Azure Training course certification
- Udemy Microsoft Power BI course
- Sep 2023 -2024 IIT Madras Diploma in Data Science
Timeline
Business Intelligence Engineer
OEC
09.2022 - Current
Data Analyst
Latent View Analytics
05.2019 - 08.2020
Software Developer Intern
Interlace India
12.2018 - 04.2019
Data Analyst Inplant Trainee
Subham Computers and Industrial School, Coimbatore
05.2018 - 08.2018
Bachelor of Technology - Information Technology
PSG College of Engineering
Similar Profiles
Ajithbalaji CAjithbalaji C
QA Automation Engineer at OECQA Automation Engineer at OEC
Josh MessnerJosh Messner
Vice President at OECVice President at OEC
Bradley ScottBradley Scott
District Lineman at OECDistrict Lineman at OEC