HarshaWardhanReddy
Harsha Wardhan Reddy Duvvrv
EDUCATION
Master�s in Data Analytics , Santa Clara University , CA, US Sep 2018 - Dec 2019
Bachelor of Engineering , Visvesvaraya Technological University , Bangalore, INDIA Sep 2012 - Jun 201 6
TECHNICAL SKILLS
Database & Modelling Tools : MYSQL, SQL Server, T-SQL, PostgreSQL, dimensional Modelling , Navicat, Erwin, Enterprise Data
Warehouse (Star Schema, Snowflake Schema), Pentaho, RDBMS, data mart.
Programming Languages & Tools: Python (NumPy, Pandas, Scikitlearn, SciPy), Linux, R, Keras, TensorFlow, MS Office, Agile, SAP ABAP,
SAP XI, RStudio, Git.
Data Science: Econometrics, Machine Learning, Supervised Learning ( Linear Regression, Logistic, Decision Tree, Random Forest, Na�ve
Bayes, GLM, KNN), Regularization (Lasso, Ridge), A/B testing, AdaBoost, Bagging, Marketing Mix Modelling, Clustering, Semi -
Supervised Learning.
Big Data: MapReduce, Hadoop, HDFS, Hive, PySpark(RDD, DataFrames), SparkSQL.
Visualization : Python (Matplotlib, Seaborn), R( Shiny), Tableau, PowerBI.
Cloud: Azure SQL, Azure ML studio, Event hub, Stream Analytics, HDInsight, Databricks, Azure Storage, AWS Redshift, S3, EC2.
EXPERIENCE
Program Analyst � ExaData Solutions Inc. Jan 2021 � Present
� Working with the program manager and product managers to provide insights regarding the progress of the projects using dashboards.
� Writing SQL queries and maintaining databases.
Data Analyst � Cardus Inc., Santa Clara, US March 2020 � Dec 2020
� Worked on developing a Rapid Analytics as A Service tool for healthcare administration to manage their resources efficiently.
� Developed complex SQL queries based on the Ad -hoc requests that involve d CTE�s, window functions, etc.
� Implemented several features like action filters, parameters, calculated fields, and set s for preparing dashboards and
worksheets in Tableau.
Data Analyst Intern � Nisum Technologies Inc., Fremont, US June 2019 � Sep 2019
� Worked on intelligent and scalable personalized recommendation system using machine learning models .
� Built a data pipeline in Microsoft Azure which involve d cleaning, ingesting, storing, visualizing dataset .
� Extracted data from Azure database using SQL queries and carr y out further analysis in python.
Data Analyst - Eventus Systems � Santa Clara, US Jan 2019 � Dec 2019
� Worked with Eventus Systems to come up with a new approach to identify market manipulation activity by the traders.
� Cleaned and organized the market data, clients trading data into a PostgreSQL database to further perform feature engineering,
visualization, and analysis using unsupervised learning in python.
Data Analyst- Accenture, Bangalore, India July 2016 � June 201 8
� Worked in a team to develop an API to extract account expense data along with the sales data from the database using SQL
queries and generated reports to provide account status and sales information to the client.
� Communicated with client to understand the functional requirement .
� Collaborated on a team of 5 to add custom KPIs for Finance and Procurement functionalities using python.
� Developed custom reports automating DML operations on different database tables.
ACADEMIC PROJECTS
Ticket Booking System Data Warehouse Development - ------------/profile/harsha.wardhan.reddy.duvvrv
� Designed and implemented OLTP, Enterprise Data Warehouse in MySQL, using Pentaho to do ETL development for the movie
ticket booking system. Implemented star schema by creating fact tables, dimension tables, Slowly Changing Dimension.
� Further connected Tableau with the Data Warehouse to provide managerial level insights by generating descriptive and predictive
dashboards.
Buy Online Pick Up In-Store (BOPS)
� Utilized the past 3 year�s data of national jewelry retailers to analyze the impact of BOPS on online channel sales and returns.
Performed data cleaning, aggregation, visualization, and derived managerial insights.
Best Buy 1 Month Sales Examination.
� Identified potential customers having a high propensity to purchase Best Buy�s warranty Plan using econometrics.
� Interpreted results are helpful for customer segment-based advertisement strategy.
Harsha Wardhan Reddy Duvvrv
EDUCATION
Master�s in Data Analytics , Santa Clara University , CA, US Sep 2018 - Dec 2019
Bachelor of Engineering , Visvesvaraya Technological University , Bangalore, INDIA Sep 2012 - Jun 201 6
TECHNICAL SKILLS
Database & Modelling Tools : MYSQL, SQL Server, T-SQL, PostgreSQL, dimensional Modelling , Navicat, Erwin, Enterprise Data
Warehouse (Star Schema, Snowflake Schema), Pentaho, RDBMS, data mart.
Programming Languages & Tools: Python (NumPy, Pandas, Scikitlearn, SciPy), Linux, R, Keras, TensorFlow, MS Office, Agile, SAP ABAP,
SAP XI, RStudio, Git.
Data Science: Econometrics, Machine Learning, Supervised Learning ( Linear Regression, Logistic, Decision Tree, Random Forest, Na�ve
Bayes, GLM, KNN), Regularization (Lasso, Ridge), A/B testing, AdaBoost, Bagging, Marketing Mix Modelling, Clustering, Semi -
Supervised Learning.
Big Data: MapReduce, Hadoop, HDFS, Hive, PySpark(RDD, DataFrames), SparkSQL.
Visualization : Python (Matplotlib, Seaborn), R( Shiny), Tableau, PowerBI.
Cloud: Azure SQL, Azure ML studio, Event hub, Stream Analytics, HDInsight, Databricks, Azure Storage, AWS Redshift, S3, EC2.
EXPERIENCE
Program Analyst � ExaData Solutions Inc. Jan 2021 � Present
� Working with the program manager and product managers to provide insights regarding the progress of the projects using dashboards.
� Writing SQL queries and maintaining databases.
Data Analyst � Cardus Inc., Santa Clara, US March 2020 � Dec 2020
� Worked on developing a Rapid Analytics as A Service tool for healthcare administration to manage their resources efficiently.
� Developed complex SQL queries based on the Ad -hoc requests that involve d CTE�s, window functions, etc.
� Implemented several features like action filters, parameters, calculated fields, and set s for preparing dashboards and
worksheets in Tableau.
Data Analyst Intern � Nisum Technologies Inc., Fremont, US June 2019 � Sep 2019
� Worked on intelligent and scalable personalized recommendation system using machine learning models .
� Built a data pipeline in Microsoft Azure which involve d cleaning, ingesting, storing, visualizing dataset .
� Extracted data from Azure database using SQL queries and carr y out further analysis in python.
Data Analyst - Eventus Systems � Santa Clara, US Jan 2019 � Dec 2019
� Worked with Eventus Systems to come up with a new approach to identify market manipulation activity by the traders.
� Cleaned and organized the market data, clients trading data into a PostgreSQL database to further perform feature engineering,
visualization, and analysis using unsupervised learning in python.
Data Analyst- Accenture, Bangalore, India July 2016 � June 201 8
� Worked in a team to develop an API to extract account expense data along with the sales data from the database using SQL
queries and generated reports to provide account status and sales information to the client.
� Communicated with client to understand the functional requirement .
� Collaborated on a team of 5 to add custom KPIs for Finance and Procurement functionalities using python.
� Developed custom reports automating DML operations on different database tables.
ACADEMIC PROJECTS
Ticket Booking System Data Warehouse Development - ------------/profile/harsha.wardhan.reddy.duvvrv
� Designed and implemented OLTP, Enterprise Data Warehouse in MySQL, using Pentaho to do ETL development for the movie
ticket booking system. Implemented star schema by creating fact tables, dimension tables, Slowly Changing Dimension.
� Further connected Tableau with the Data Warehouse to provide managerial level insights by generating descriptive and predictive
dashboards.
Buy Online Pick Up In-Store (BOPS)
� Utilized the past 3 year�s data of national jewelry retailers to analyze the impact of BOPS on online channel sales and returns.
Performed data cleaning, aggregation, visualization, and derived managerial insights.
Best Buy 1 Month Sales Examination.
� Identified potential customers having a high propensity to purchase Best Buy�s warranty Plan using econometrics.
� Interpreted results are helpful for customer segment-based advertisement strategy.