PROFILE

CONTACT

CERTIFICATIONS WORK EXPERIENCE

OTHERS

HARSH KOTHARI

Data Analyst / Engineer

*** ******* ***, ****** ****,

New Jersey, 07307

201-***-****

adx71e@r.postjobfree.com

harsh-kothari21

Medium Upwork

Experienced Data Analyst adept at collecting, and interpreting large datasets, working efficiently in close collaboration with analytic, engineering, and other stakeholders, Designing/Implementing data solutions, and proven capabilities in GCP & Azure cloud.

Possessing extensive analytical skills, strong attention to detail, and a significant ability to work in team environments. I am seeking a long-term career opportunity where I can utilize my Experience and skills to make a measurable contribution. Azure Data Scientist Associate

Professional Certification

Design and Implement Data

Science Solution in Microsoft

Azure

Build and Manage Pipelines

Deploying Models

Microsoft Certified Power Platform

Professional Certification

Automate business process

through Power Automate

Build Power Apps

PowerBI Capabilities

Power Virtual Agents

Lead Data Analyst SEP 2022-PRESENT

Tata Consultancy Services - McKesson

Tech Lead for Snowflake EDW & EDL team. Responsible to support Data ingestions from various sources (SAP, BW, HANA, Oracle, etc.) to the data lake and dealing with data issues in production to ensure data quality and data integrity. Received Top innovation award for "Health Check Monitoring Dashboard" which provides more visibility over ongoing data issues/delays to stakeholders/Data scientists/analysts and other consumers.

Lead data engineer for bug fixes and enhancements to data pipelines or data integration strategies.

understanding of the Data modeling (Dimensional & Relational) concepts like Star- Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Designed conceptual and logical data models of databases and tables. Improved service now ticketing process and support model by collaborating with Product Management, Dev Leads, and Leadership team which resulted in more than 50% reduced resolution time and 50% fewer tickets/incidents. Led small team (approx. 8 members) and helped them with technical challenges, running daily scrum calls, and keeping everyone organized. Developed SOP, Data lineage, and high-level architecture diagrams. Technical support lead for Enterprise Reporting & Analytics Platform. Dealing with issues and enhancements in Looker embedded reports, admin configurations, and leading the production support team.

Google Cloud Data Engineer

Professional Certification

ETL Processing and Data

Transformation pipelines

BigQuery Warehousing

Cloud composer Airflow

Google Cloud Architect

Professional Certification

Google Kubernetes Engine

Terraform

Microservices

Networking Storage

SLA SLO SLI

Machine Learning - Coursera

By Andrew Ng

Stanford University- online

Data Tata Consultancy Engineer / Data Services Analyst - Cardinal Health SEP 2021-SEP 2022 Opportunity Analysis - Worked closely with stakeholders across departments and conducted the analysis to identify opportunities to mitigate the impact of supply disruption. Analyzed & monitored the business impact of Machine Learning models i.e impacted revenue, gross margin, and service level. Won best predictive analytics model award where over the first six months, the model contributed over 42 million dollars in incremental sales and 1 million dollars in incremental margin.

Data Engineering - Identified and implemented data ingestion patterns, scheduled data pipelines using Airflow on GCP, and performed ETL using Alteryx and Google BigQuery.

Extensively used advanced features of SQL like partitioning, clustering, materialized views, and store procs.

MLOps - Data Acquisition, validation, productionalize machine learning model. Understanding existing business processes and Interacting with the super user to finalize the requirement.

SKILLS

Hard Skills

Automation

Business Analysis

Dashboard/Report

Data mining

Problem Solving

Modeling

Machine Learning

NLP

ETL

Alteryx

IBM Infosphere

Power-BI

CRM(Dynamics365)

MS Office

Tableau

Looker

Additional Activities

Blogs on various concepts of Data Analysis, Machine Learning, Data Visualization, Deep Learning, and Cloud

Publication Writer on The Startup and Analytics Vidhya Publication @Medium Python, SQL, HTML/CSS

Leadership

Teamwork

Time Management

Soft Skills

Programming Languages

Tool Skills

EDUCATION

Bachelor's

Computer Engineering

Gujarat Technological University

Python Developer SEPT 2019-FEB 2020

SIH

Creation of web portal for Book sharing system.

Authentication system.

Pagination to decrease site loading time.

Feedback system in the portal.

Maintenance-free platform.

Developed an intuitive book-sharing platform for the university. Major features of the solution include:

Extract Tweets Based on $CASHTAG from Tweeter API and applied time-based filters on tweets.

Performed Sentiment Analysis on the extracted tweets to look out for market sentiments on stocks.

Data InDeep Scientist Labs MAR 2020-APR 2020

Data Vertex Scientist Tech. LLC SEP 2020-MAR 2021

Developed Campus Dashboard on the University management portal using PowerBI containing deep analysis of academic records and bio records. Developed a machine learning model to predict student graduation status. Developed PowerBI Dashboard to keep track of the client projects, total revenue, project status, project costs, etc.

Developed application structures using UML, documented User journey using miro, established system requirements, and matched the "right" API to the Use-case by running test cases.

Tested API by creating reports on the API results. Used Azure-DevOps Board to manage the sprints, user stories, and tasks. Leverage Azure Service - Power automate solutions to create automated flows to load applicant's data.

Built connectors to drive the data from different sources into Azure dataverse. Developed PowerBI reports to keep track of candidates through the application process, jobs, etc.

Mentored and coached Interns to accomplish project deliverables within the allocated time.

Data Computing Analyst For All MAR 2021-SEP 2021

Researched and Analyzed similar products in the market in order to come up with strategic ways to improve the product features.

Contact this candidate