VINIITH

VINIITH

Data analyst
Canada

About Me

Logical [Data analyst] collects, processes, and executes statistical analysis of data. Key team member who is responsible for possessing exceptional problem-solving skills combined with strong cross-functional understand…

Experience

Data Analyst

EMBARK INTERACTIVE Pvt. Ltd.
Jan 2021 - Present · 5 years 9 months

• Responsible for designing the SQL queries, procedures, functions, and triggers.
• Automated over 10 manual tasks with Python scripts, cutting down data analysis time by 75%. In addition, Utilized Python and SQL for data extraction, transformation, and loading (ETL) processes, ensuring data accuracy and reliability.
• Developed dynamic Power BI dashboards that allowed stakeholders to clearly visualize key performance indicators, aiding in data-driven decision-making and for real-time profitability tracking.
• Used SQL for data extraction from 12 interconnected tables within Mega Mart's customer sales databases, employing JOIN and VIEW operations.
• Leveraged aggregation and filtering functions to refine and streamline the data, enhancing the reporting process.
• Utilized SQL and power BI for data loading and visualization, uncovering crucial business insights to boost the sales performance of our client, HERITAGE FOODS LIMITED.
• Collaborated as a team member to remove duplicate records from the business database, achieving a 92% accuracy rate. Furthermore, assisted front-line teams in making 25% more data-driven decisions by providing up-to-date, pertinent insights across various projects.
• Built a data warehouse employing SQL Server and Excel to manage, structure, and scrutinize extensive data sets, achieving this milestone within three weeks of commencing the client's project (GT Holidays Private Limited).
• Boosted the value of analytical reports by improving data mining and segmentation methods for a client across various social media platforms.
• Followed agile methodologies and participated in weekly sprint progress and sprint delivery.
• Delivered consistent maintenance and bi-monthly development of bug fixes for both existing and new Power BI reports for clients over a period of two years.
• Analyzed 50GB of data to devise an optimal pricing strategy for 15 new products for our client, Prithvi Enterprises, uncovering opportunities that boosted annual revenue by $1.5 million.

Garden Center Associate (Part-time)

Walmart-SPAR
May 2023 - Jul 2023 · 2 months

<p>Engaged in customer interaction, plant maintenance, inventory organization, and product display.<br>
Followed checklists and handled materials effectively.<br>
Completed the assigned daily tasks and reported promptly to the supervisor.</p>

Data analyst Intern

EMBARK INTERACTIVE Pvt. Ltd. (Location: K K Nagar, Madurai.)
Apr 2021 - Dec 2022 · 1 year 8 months

<p>Responsible for designing the SQL queries, procedures, functions, and triggers.<br>
Conducted research and tested relevant data to support project decision-making for locations and Vendors.<br>
Delivered immediate insights across seven critical performance metrics, resulting in a 33% increase in revenue during the first month on the job.<br>
Employed SQL, Power BI, and Excel for the analysis and processing of 20 terabytes of data, aiding in more than 100 plus business decisions.<br>
Employed data mining, OLAP, and statistical analysis tools to identify 35 market trends.<br>
Conducted statistical modeling, hypothesis testing, and A/B testing, providing robust data-driven recommendations that improved project outcomes.<br>
Learned in utilizing, testing, supporting, and migrating databases across Microsoft SQL Server, Oracle, and MS Access platforms.</p>

Data analyst

EMBARK INTERACTIVE Pvt. Ltd. (Location: K K Nagar, Madurai.)
Apr 2021 - Dec 2022 · 1 year 8 months

<p>Automated over 10 manual tasks with Python scripts, cutting down data analysis time by 75%.<br>
Utilized Python and SQL for data extraction, transformation, and loading (ETL) processes, ensuring data accuracy and reliability.<br>
Developed dynamic Power BI dashboards that allowed stakeholders to clearly visualize key performance indicators, aiding in data-driven decision-making and for real-time profitability tracking.<br>
Used SQL for data extraction from 12 interconnected tables within Mega Mart's customer sales databases, employing JOIN and VIEW operations.<br>
Leveraged aggregation and filtering functions to refine and streamline the data, enhancing the reporting process.<br>
Utilized SQL and power BI for data loading and visualization, uncovering crucial business insights to boost the sales performance of our client, HERITAGE FOODS LIMITED.<br>
Collaborated as a team member to remove duplicate records from the business database, achieving a 92% accuracy rate.<br>
Assisted front-line teams in making 25% more data-driven decisions by providing up-to-date, pertinent insights across various projects.<br>
Built a data warehouse employing SQL Server and Excel to manage, structure, and scrutinize extensive data sets, achieving this milestone within three weeks of commencing the client's project (GT Holidays Private Limited).<br>
Boosted the value of analytical reports by improving data mining and segmentation methods for a client across various social media platforms.<br>
Followed agile methodologies and participated in weekly sprint progress and sprint delivery.<br>
Delivered consistent maintenance and bi-monthly development of bug fixes for both existing and new Power BI reports for clients over a period of two years.<br>
Analyzed 50GB of data to devise an optimal pricing strategy for 15 new products for our client, Prithvi Enterprises, uncovering opportunities that boosted annual revenue by $1.5 million.</p>

Skills

Analytics Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) R Programming Language (R) Tableau SQL Power BI MySQL Excel Microsoft Office Suite Macros VLOOKUP HLOOKUP Python Pandas matplotlib C++ C# RapidMiner Agile JIRA Microsoft SQL Server Oracle MS Access Data Visualization Statistical Analysis Statistical Modeling Hypothesis Testing A/B Testing OLAP ETL Data Warehousing Data Extraction Data Transformation Data Loading Dashboard Development Report Generation Project Management Foundations Business Acumen
Report this Profile?