Tushar Jain
Data Scientist
*********@*****.*** • 515-***-****
Data-driven professional with commendable expertise in enhancing dashboard functionality, integrating advanced analytics into user experiences, and developing machine learning models.
Known for deploying Power BI dashboard, streamlining data quality tracking, and managing various projects. Skilled in driving insightful analytics and informed decision-making from complex datasets through employing machine learning techniques. Capable of leading and collaborating with cross-functional teams to ensure process improvement and deliver impactful results. Excel at fostering solid stakeholder relationships and offering data science solutions to solve challenging business problems. Possess strong background in data visualization, SQL, Power BI, Python, and machine learning with understanding of cloud services, such as Azure.
Technical Skills
Cloud Platform:
Microsoft Azure, Microsoft Azure data factory, Azure Synapse, Azure Cosmo DB, Azure SQL Database, Azure Data lakes, Azure Data Explorer, Microsoft Data Fabric
Programming:
Python, Pandas, Numpy, Scikit Learn, Tensorflow, Keras, Selenium, API integration,
Database:
SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
Data Processing & Analytics tools:
Apache PySpark, Databricks, Microsoft Data Fabric, Azure Data Factory
Data Visualization Tools:
Power BI, Tableau, Plotly, DAX
Machine Learning & Deep Learning:
Statistical Analysis, PCA, K-means, SMOTE Analysis, Sampling, Decision Trees, LightGBM, XGBoost, Logistic Regression, LSTM Autoencoders
Professional Experience
Berkshire Hathaway Energy, Iowa
Data Science Intern
May 2023 — May 2024
Constructed Power BI dashboards to accurately track data quality by collecting and analyzing stakeholder requirements. Delivered findings on alarm codes and turbine data to engineers and department directors, influencing data-driven decisions. Created and implemented machine learning model to detect anomalies in wind turbine data.
●Drove 1200% improvement in dashboard by utilizing Apache Pyspark to reduce refresh times as well as elevated user experience by overseeing dashboard enhancements.
●Created a Power BI dashboard using SQL and Direct Query, increasing the data quality and data integrity by 100%.
●Developed a Power BI dashboard using DAX and SQL with Direct Query to monitor data quality and integrity for engineers, achieving a 100% improvement in both metrics..
●Performed exploratory data analysis (EDA) to understand the wind turbine behavior during and before alarm codes, resulting in greater understanding of data.
●Utilized Azure DevOps to keep track of user stories and communicate project update with stakeholders
iCreate, India
Business Analyst
Jun 2019 — Jun 2022
Determined business model efficacy, market viability, and growth potential by assessing startup ventures. Conducted comprehensive market research to identify strategic investment opportunities in key sectors. Facilitated data-driven decisions and project evaluation by advising clients on business strategy and product development through reviewing
market trends and competitive landscape.
●Designed market surveys for startups using survey monkey to gain understanding of market demographic and price points for the product.
●Performed market competition research for clients to help them define their USP
●Achieved 99% on-time response rate for client queries across 700+ accounts by launching Google Studio dashboard.
●Developed and managed a MySQL database to monitor key performance indicators (KPIs) for cohort analysis.
●Addressed ad-hoc queries by executing SQL commands to retrieve and analyze data.
●Designed Power BI dashboard to monitor 200+ projects, providing crucial insights on project valuation and funding and other KPIs.
●Boosted operational efficiency and consistency across projects by streamlining business processes and establishing standard operating procedures.
Key Projects
●Performed restaurant business analysis across five states in the United States.
●Defined the project scope and managed the timeline of the project ensuring before time delivery
●Led implementation of Microsoft Data Fabric, facilitating data-driven decision-making through in-depth analysis.
●Designed ETL pipeline to clean and transform the data to make it usable for analysis.
●Utilized T-SQL to efficiently query data
●Ensured efficient data storage as well as strengthened data integrity and accessibility by formulating robust Azure SQL database.
●Improved data visualization and optimized reporting processes by developing advanced Power BI dashboard, enabling cross-functional teams to access real-time insights and guide data-driven strategies.
Education
Master of Science in Management of Information Systems Iowa State University, Iowa (2024) - GPA: 3.96/4.0
Bachelor of Science in Electronics and Communication Shiv Nadar University, India (2019)