Dinesh Adda

Dallas 214-***-**** ad4g4e@r.postjobfree.com LinkedIn

SUMMARY

As a highly skilled data science and analytics professional, my expertise encompasses extensive proficiency in Python, SQL, and a diverse range of programming languages and tools including Hadoop, Spark, and Scala. My robust experience in databases is evident through my work with SQL, MySQL, MongoDB, and SAP HANA. I am adept at utilizing a variety of data analytics tools such as Tableau, Power BI, and AWS QuickSight, enhanced by my proficiency in machine learning techniques like Random Forest and Neural Networks. My certifications in Machine Learning and AWS Cloud Computing, combined with a solid foundation in project management methodologies like Agile and Scrum, make me a versatile asset capable of delivering impactful data-driven insights and solutions. SKILLS & CERTIFICATION

Programming: C, Proficient in Python and SQL, with experience in R, Hadoop, Scala, Spark, Airflow, Snowflake Databases: SQL, MySQL, MongoDB, SAP HANA

Tools: Tableau, Power BI, AWS QuickSight, Tableau, Alteryx Core Designer, Microsoft Excel (VBA & Macros), MATLAB, Azure, MS Access, Jira, SAP Lumira, SAP BI

Data Science& Analytics: Data Mining, Data Modeling, Database Querying, Data Pipelines, Hypothesis Test, A/B or Split Test, ANOVA Sentiment Analysis, Big Data, Linux, Hive, Sqoop, AngularJS, Cloudera, Casual Inference, Correlation, Conjoint Analysis, Stata, SAS

Machine Learning: Random Forest, XGBoost, Decision Trees, Neural Networks, Clustering, Segmentation, Deep Learning, Supervised & Unsupervised Learning, Linear & Logistic Regression Cloud Services: SAP Cloud Analytics, Google Data Analytics, AWS Cloud, Cloud Economics & Billing Project Management: Atlassian Jira, Agile, Scrum & Waterfall Methodology, Lean, Six Sigma, Kanban, SAP MM Certifications: Machine Learning, Google Analytics for beginners, AWS Cloud Computing Practitioner PROFESSIONALEXPERIENCE

Data Analyst, Tavas Systems, Reading, PA Jan 2023 – Dec 2023

• Led the development and maintenance of complex data pipelines using Python, Airflow, and Snowflake, significantly improving data processing efficiency.

• Conducted extensive data analysis using SQL, MongoDB, and SAP HANA, providing insightful business solutions, and driving data-driven decision-making.

• Developed the CICD process for the team to ensure the builds are thoroughly monitored and migrated scalable databases capable of ETL processes using SQL and Spark.

• Developed and implemented advanced machine learning models (Random Forest, XGBoost, Neural Networks) to analyze large datasets, resulting in a 20% improvement in predictive accuracy.

• Migrated 600 Automic jobs to Airflow while ensuring data quality and sanity.

• Removed duplicate records from datasets using Snowflake

• Utilized Tableau and Power BI for data visualization, enabling stakeholders to understand complex data insights easily.

• Spearheaded a big data project using Hadoop, Scala, and Spark, processing over 2 TB of data and enhancing data accessibility.

• Managed cloud services, including AWS Cloud and SAP Cloud Analytics, optimizing cloud resources, and reducing costs by 15%.

• Applied project management methodologies (Agile, Scrum) to ensure timely delivery of data projects, leading a team of 20 data analysts.

• Automated various data processes using Python scripts and Excel VBA, reducing manual effort by 30%.

• Collaborated with cross-functional teams to implement A/B testing and hypothesis testing, leading to a 10% increase in user engagement.

Teaching Assistant, University of Texas at Dallas Aug2022 – Dec 2022

• Developed multiple grading scripts in python to programmatically grade assignments, thereby reducing manual grading effort by 70%.

• Researched teaching methods and styles to develop new learning strategies that increased a student's Statistics score by47%.

• Managed tutoring sessions for statistics in business analytics and arithmetic courses. Business Data Analyst, BYJUS, Hyderabad July 2019 – Jan 2022

• Designed and executed data models and database querying techniques in SQL, MySQL, and MongoDB for optimized data storage and retrieval.

• Implemented machine learning techniques for customer segmentation and predictive analytics, improving customer targeting strategies.

• Enhanced data reporting and analytics capabilities using SAP BI and SAP Lumira, providing comprehensive business intelligence solutions.

• Managed and scaled big data technologies (Cloudera, Hive, Sqoop) for efficient data handling and processing.

• Led the migration of data analytics to Google Data Analytics and AWS Cloud services, ensuring scalable and cost- effective data solutions.

• Conducted sentiment analysis and casual inference studies to understand customer behavior, contributing to a 15% increase in customer satisfaction.

• Employed Six Sigma and Lean methodologies in project management, achieving a 20% reduction in project lead times.

• Oversaw the integration of Atlassian Jira for project tracking and management, enhancing team collaboration and productivity.

• Certified in Machine Learning and AWS Cloud Computing, consistently applying best practices and cutting-edge technologies in data science projects.

ACADEMIC PROJECTS EXPERIENCE

Visualize the overview of group airlines key performance (Data Visualization-Tableau) Utilized Tableau to craft diverse data visualizations and dashboards, offering a visual overview of BTS Airlines' key performance indicators and highlighting HA Airlines as the top performer in on-time performance. Unlocking Future Growth Potential for Conagra leveraging BCG/Growth Matrix Framework (SAS, Tableau, PowerBI) Examined 5 years of sales data and consumption trends to create a data-driven product roadmap for table spreads. This involved forecasting future challenges and validating recommendations through hypothesis testing and regression analysis. Credit Risk Modelling based on G-XGBoost and graph-based deep neural network (Machine Learning, Python-Jupyter) Deployed XGBoost and Neural network models to predict credit applicant default probabilities, linearizing and transforming features into a high- dimensional data matrix and identifying key feature relationships. AWS Architecture in Food Manufacturing Industries (AWS, Cloud Computing) Developed a cost-effective and scalable inventory management solution on AWS, leveraging Amazon S3, RDS, Lambda, API Gateway, and Step Functions, yielding substantial cost reductions. Sentiment analysis of IMDB rating (NLP)

Extracted relevant features using multiple feature engineering techniques, Trained the model using a customized training class, improved it by adding functionality learning rate schedulers and added template model for sequential stack of layers. EDUCATION

The University of Texasat Dallas Jan2022 - Dec 2023 Master of Science, Business Analytics (Data Science) GPA: 3.68/4.0 Courses: Big Data, Database Foundation, Machine Learning, Applied Natural Language Processing, Advance Statistics and Data Analysis, Cloud Computing, Programming for Data science (Python), Predictive Analytics using SAS Sathyabama Institute of Science and Technology, Chennai, India April 2019 Bachelor of Engineering, Mechanical GPA: 8.5/10.0