Data Analyst Information Technology

PRAVIN ADEP

Dallas, TX

+1-945-***-**** ******.*******@*****.*** www.linkedin.com/in/pravinadep EDUCATION _

Master of Science in Information Technology & Management May 2024 The University of Texas at Dallas, Dallas, Texas GPA: 3.9 Bachelor of Science in Computer Science November 2020 Savitribai Phule Pune University, Pune, India GPA: 3.5 PROFESSIONAL EXPERIENCE _

Junior Data Analyst MIST IT Services, Mumbai, India May 2020 – June 2022 o Cleaned and pre-processed large datasets using Python and Excel, ensuring data accuracy and enabling actionable insights o Executed SQL queries to generate detailed reports and perform advanced data analysis for business decision-making o Conducted data profiling and quality checks to uncover insights, improving efficiency of cross-functional decision-making o Designed and implemented dynamic Power BI dashboards to effectively communicate analytical findings to stakeholders o Applied Power Query for seamless data transformation, streamlining workflows and improving dataset usability o Automated ETL workflows using Python and SQL, achieving a 25% reduction in processing time, improving data accuracy o Built and deployed predictive models using machine learning algorithms to forecast trends and support strategic planning o Collaborated with cross-functional teams to align data strategies with business priorities, improving client satisfaction by 10% IT Intern, Web Development MIST IT Services, Mumbai, India September 2019 - April 2020 o Monitored the company website for issues, resolving 30% of identified bugs using HTML, JavaScript debugging techniques o Optimized ETL data flows and resolved migration issues, streamlining database management and improving efficiency o Increased session duration by 40% through the redesign of the webpage, focusing on user engagement and experience o Integrated third-party APIs and optimized scripts to improve website functionality and performance, enhancing user experience o Designed and executed A/B tests for various website features, resulting in a 20% improvement in conversion rates o Reduced IT issues by 25% through efficient troubleshooting strategies, enhancing overall system performance and user satisfaction

ORGANIZATIONAL EXPERIENCE _

Teaching Assistant The University of Texas at Dallas August 2023 – May 2024 o Mentored students in Marketing and Strategic Management, enhancing their understanding and academic performance o Managed student data securely, ensuring compliance with data protection standards during grading and reporting o Ensured data integrity and reliability in maintaining student records, contributing to an efficient academic evaluation process o Assisted the professor in developing course materials and grading, applying data organization and analysis for accurate evaluations

PROJECTS

Ecommerce Customer Segmentation using R programming o Conducted exploratory data analysis in Excel and R to uncover key trends, resulting in a 30% improvement in decisions o Applied clustering techniques like K-Means and KNN to segment customers and optimize targeted marketing strategies o Visualized trends and insights in R using bar charts, line plots, and scatterplots to support data-driven decision-making o Crafted and deployed strategic marketing plans, resulting in significant improvements in customer engagement metrics Forecasting Targeted Advertisements Based on Unique Physical Attributes of individual Customers o Authored and published a research paper focusing on Digital Instore Merchandising Research Paper o Developed a hybrid model combining machine learning and deep learning techniques, achieving 85% precision in predictions o Implemented CNN for precise image processing, optimizing the efficiency & accuracy of visual data analysis o Used a Raspberry Pi and camera module to capture high-resolution images for real-time data acquisition COVID-19 Mortality Analysis: Demographics, Underlying Conditions, and Public Health Systems using Tableau o Designed Tableau dashboards analyzing COVID-19 mortality trends by underlying health conditions and public responses o Employed Tableau Prep to clean and transform datasets, enabling precise analysis of multiple hypotheses o Presented key insights through interactive visualizations, supporting data-driven public health strategies SKILLS

Programming Languages and Databases - Python, C, C++, SQL, MySQL, JavaScript Cloud and Web Technologies - Azure, AWS, HTML, CSS Machine Learning and Data Science - Keras, PyTorch, Scikit-learn, Seaborn, TensorFlow, NumPy, Pandas Data Analysis and Visualization - Tableau, Power BI, DAX, SQL, Excel, R, Data Cleaning, Data Visualization, Statistical Analysis Software - PyCharm, Android Studio, R Studio, Excel, SQL Server, Visual Studio Operating Systems - Windows, Linux

Others - Jira, SDLC, Agile, Waterfall

CERTIFICATIONS

Google Data Analytics, Coursera August 2023

Contact this candidate