Learn Data Skills
Beta
Megha Katiyar

Megha Katiyar

Data Analyst

ClicData

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

Analytical maestro, orchestrating symphonies of insights with precision.

My Work

Take a look at my latest work.

course

Introduction to Tableau

course

Introduction to SQL

course

Intermediate SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

ClicData | Aug 2022 - Aug 2023

Data Analyst

• Conduct exploratory data analysis (EDA) on large datasets to identify trends and patterns. • Develop and implement data cleaning and transformation processes to ensure data accuracy. • Create and maintain automated reports and dashboards for key stakeholders and presented findings and recommendations to stakeholders in a clear and accessible manner. • Collaborate with clients to understand their business requirements and develop dashboards for executive reporting. • Developed and maintained SQL queries for data extraction, transformation, and loading (ETL) processes. • Understanding and working with various APIs to make API Calls. • Led a team of junior analysts in conducting comprehensive data analysis projects, providing actionable insights to senior management. • Implement data governance policies and procedures to ensure data quality and integrity.
Show More

Pulse Industrial | Aug 2021 - Aug 2022

Data Analyst

• Developed a robust failure detection system using Python to improve efficiency and accuracy of product performance. • Reduced manual labor by 80% by implementing automated data analysis and failure detection processes. • Collaborated with cross-functional teams to analyze and interpret data, identifying trends and patterns in system failures. • Identified key performance indicators (KPIs) and developed metrics to measure the effectiveness of data analysis and failure detection processes. • Evaluated and recommended new technologies or tools for data analysis to further improve efficiency and accuracy. • Develop and implement data validation processes to ensure the accuracy and integrity of the data used in the failure detection system. • Develop a dashboard using the QlikSense BI tool to provide enhanced visualization capabilities and automate third party integrations under one platform.

SuprAcademy | Nov 2019 - Aug 2021

Mathematics Tutor

N/A

Facedrive | Jul 2020 - Oct 2020

Data Analyst

• Managed the planning and development of Data Analysis Platform using Tableau, AWS RDS and AWS Red Shift. • Provide recommendations on data-driven business strategies based on analysis and insights derived from geospatial data and analytics. • Collaborate with cross-functional teams to understand business needs and provide data-driven solutions. • Develop and maintain dashboards, and reports that provide insights into key business metrics and trends. • Utilize quantitative analysis, such as regression analysis and hypothesis testing, to identify correlations and make data-driven recommendations for improving business operations and decision-making.

Wolseley Canada Inc. | Jul 2019 - Apr 2020

Machine Learning Intern

• Explored capabilities of various Cloud and Data Analytics service providers based on business use cases. • Developed a recommendation Engine for the existing website(used Bayesian Personalized ranking and Neural Collaborative filtering), which helped enhance the user experience. • Developed a Cloud-based architecture(leveraging AWS and Azure platform) to operationalize the recommendation algorithms and provided POC for the devised end to end architecture.

Mathnasium - The Math Learning Center | Sep 2019 - Dec 2019

Mathematics Tutor

‣Introduced various concepts to elementary school students as per their workbook. ‣Followed various approaches for a concept if the student faced difficulty in understanding the generic method. ‣ Assessed the strengths and weakness of the student and provided more practice in the concepts that were difficult for the student to understand.

Infosys | Jul 2016 - Aug 2018

Software Test Engineer

Automation Test Engineer • Understood Business requirements and checked the feasibility of the requirement. • Developed various DevOps prototypes, CICD(continuous integration- continuous Delivery) pipelines using JAVA. • Developed test scripts using selenium and UFT(Unified functional testing). • Awarded the 'Best Performer' Quarterly award for year 2017-2018.

My Education

Take a look at my formal education

Masters, Electrical and Computer engineeringUniversity of Toronto | 2020
BTech, Electrical and Electronics EngineeringSRM UNIVERSITY, TAMILNADU | 2016

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free