Prachi Patel Email and Phone Number

● Designed and implemented SSRS reports and Power BI dashboards to provide critical insights, reducing report generation time by 60% and improving data access by 12%.● Developed an ETL pipeline using Amazon Redshift to consolidate workforce data, leading to a 32% decrease in turnover costs through improved insights.● Performed hypotheses tests like chi-squared test of independence to investigate and analyze relationships between factors like gender and job satisfaction.● Created complex SQL queries and stored procedures for data analysis, enabling efficient and accurate reporting.● Collaborated with business units to define data requirements for analysis, driving a 10% increase in employee satisfaction through data-driven insights.● Utilized Jira to manage cross-functional projects and ensure the seamless implementation of business intelligence solutions.

● Utilized SQL to query and analyze large datasets from Health Kart's database of over 10 million records, reducing data processing time by 25%, and developed automated dashboards in Tableau for real-time sales and inventory access.● Implemented A/B testing for customer engagement strategies using Python, resulting in a 15% increase in website conversion rates, and conducted market trend analysis leading to a 20% growth in product offerings.● Managed a data migration project transferring 500 GB of data to a cloud-based warehouse with AWS Redshift and ETL tools, while optimizing supply chain analytics with R to reduce inventory discrepancies by 10%.● Analyzed sales and product performance data across 10+ verticals, generating actionable insights that led to a 12% increase in quarterly revenue through optimized pricing strategies and marketing efforts.

● Analyzed 100,000+ data points from aircraft sensors, delivering insights that improved operational decisions by 30% and reduced maintenance costs by 15%.● Built predictive models using regression and decision trees, improving maintenance schedules by 25%, resulting in $1.5M in annual savings.● Automated data cleaning and extraction processes, reducing manual work by 40% and enhancing data quality by 50%.● Developed dashboards with Tableau that streamlined decision-making processes across 5 departments, reducing time-to-insight by 20%.● Collaborated with engineering teams to integrate 12 new features into predictive models, enhancing model precision.● Conducted A/B testing across 7 KPIs, ensuring model validation and alignment with industry standards, improving operational effectiveness by 15%.

Developed data mining models, including Multilinear and Logistic Regression, using Python (scikit-learn, stats models), boosting student engagement by 40%.• Conducted data preprocessing, feature engineering, and model tuning to optimize model performance, improving accuracy and the reliability of insights.• Created and maintained interactive Tableau dashboards, increasing parent engagement by 15% through effective data storytelling.• Improved the student management system by designing data models using UML and EER diagrams, streamlining operations and reducing database redundancy.• Realized an 18% improvement in student management by using RDBMS optimizing database organization and facilitating effective administrative functions.