Data Analyst Information Technology

Aishwarya Nandraj Patil

945-***-**** *****************@*****.*** https://github.com/Aishwarya-Patil27 https://www.linkedin.com/in/aishwaryapatil27/ EDUCATION

The University of Texas at Dallas Jan 2023-Dec 2024 Master of Science, Information Technology and Management GPA: 3.6 Dallas,Texas Relevant Coursework: Advanced Statistics for Data Science, Business Data Warehousing, Database foundations, Data Visualization, Big Data, Foundation of Digital Product Management, OOP with Python, Spreadsheet Modeling Savitribai Phule Pune University, Pune, India Sept 2020 Bachelor of Engineering, Computer Engineering GPA: 3.8 Pune, India PROFESSIONAL EXPERIENCE

Data Analyst ZENSAR TECHNOLOGIES, INDIA Feb 2022 - Dec 2022

• Executed ad-hoc analysis using SQL on datasets over 1TB in ZenAccurate (internal tool), identifying KPI shifts that led to a 25% annual growth in key product sales

• Performed descriptive, predictive, and prescriptive analysis on large datasets for organizations with high-risk cybersecurity constraints.

• Prepared and analyzed sales reports by tracking KPIs using Tableau, leading to a 30% increase in product sales

• Championed new data collection processes, improving communication between client needs and 5 product development teams, exceeding KPI goals by 67%

• Extracted data from internal tool using SQL, implemented ETL pipelines with Python (Pandas, NumPy) to transform and merge data, boosting pre-processing efficiency by 45%

Junior Data Analyst ZENSAR TECHNOLOGIES, INDIA Nov 2020 - Feb 2022

• Identified 33% data discrepancies using VLOOKUP and HLOOKUP, ensuring 99.9% accurate pricing data analysis

• Developed KPI dashboards in Power BI for request management, improving operational insights and reporting efficiency

• Automated end-to-end cycle time reporting using Advanced DAX in Power BI, enhancing workflow efficiency

• Standardized reporting protocols across 50+ data streams using Visio and Excel, delivering comprehensive pricing reports

• Implemented Agile methodologies in JIRA, reducing defects by 40% and ensuring on-time project delivery PROJECTS

RFM Analysis: Customer Behavior Analysis and Segmentation

• Performed RFM (Recency, Frequency, Monetary) Analysis using Python, increasing targeted marketing effectiveness by 13% through processing transaction data and computing RFM metrics

• Improved targeted marketing strategies by 25% through collaborative analysis of RFM results Bank Loan Analytics & Reporting System: Financial Analytics and Reporting

• Spearheaded the creation of a unified “Details Dashboard”, increasing data accessibility by 40% and driving data-driven lending decisions

• Crafted visualizations of loan trends, regional performance, and borrower characteristics, enhancing strategic decision-making Sentiment Analysis of Amazon Reviews: Consumer Insights

• Built a sentiment analysis model to classify Amazon product reviews, improving insights for over 10,000 reviews each month

• Conducted Exploratory Data Analysis (EDA) on 50,000+ reviews using Python, identifying key sentiment drivers and visualizing data trends Heart Disease Prediction Modelling Predictive Health Analytics

• Examined heart disease data of 1.3M patients with high probability of experiencing heart attacks in future using SQL and Spark

• Predicted patients at highest risk by developing machine learning models(Random Forest, SVM) ) in Python with 92% accuracy; visualized insights using Tableau

A/B Testing for Enhanced Website Engagement: Data-Driven Decision-Making

• Designed and executed A/B tests to evaluate the effectiveness of different website layouts, leading to a 15% increase in user engagement by analyzing data from over 10,000 user interactions using Python (SciPy)

• Visualized findings and provided actionable recommendations to improve website engagement CERTIFICATION AND SKILLS

Certifications: AWS Certified Cloud Solutions Architect,Tableau for Data Scientists, Data Visualization for Data Analysis and Analytics Programming Languages: Python (NumPy, Pandas, Keras, Matplotlib, SciPy), R, SQL, Java, HTML, JavaScript and CSS Databases: MySQL, PostgreSQL, AWS, Amazon Redshift, Microsoft SQL server ETL: Data Transformation, ETL Pipelines, Data Cleansing, Data Warehousing Analysis & Visualization Tools: Power BI, Tableau, Microsoft Excel, Looker, Visio, Alteryx, Hadoop, Spark,Google Analytics Database Management Systems: Microsoft SQL Server, MySQL, Oracle, PostgreSQL, NoSQL, SSRS, SSIS, MongoDB LEADERSHIP EXPERIENCE & ORGANIZATIONS

• Volunteer, 2024 National Cricket League (NCL) Dallas Assisted key players and event coordination, demonstrating strong organizational and interpersonal skills.

• Marketing Manager, The Product Base Club

Managed outreach and engagement for mentorship programs, driving participation from 20+ members and successfully positioning them for internships and job placements.

ELIGIBILITY: Eligible to work in the US for internships and full time for up 36 months.

Contact this candidate