Dhawal Panchal

Application Devlopment Analyst

accenture•  July 2019 - July 2022

Application Development Analyst Project: EDF Energies • Transformed 20+ complex business requirements into detailed, actionable specifications, utilizing my proficiency in Excel to build data models and automate repetitive tasks. This resulted in a 25% improvement in operational efficiency. • Collaborated with senior consultants and stakeholders to create Project Plans, and define system Scope, Specifications, and Technical Designs, leading to a 20% improvement in project timeline adherence and effective tracking through Azure DevOps. • Proactively suggested and implemented 15 IT system improvements, enhancing user experience and increased system security. • Created automated workflows using TOSCA for Dev, QA & UAT environments smoke testing, regression testing, and compliance testing, resulting in 26% less bi-weekly labor time. • Identified and resolved 100+ software errors, reducing system downtime by 25% and improving user productivity by 12%. • Provided ongoing ad hoc reporting, questions, queries, and problem support, maintaining a customer satisfaction rating of 90%. Project: Axis Capital • Spearheaded complete testing cycles (unit, integration, user acceptance), including test planning, test designs, test conditions, and output review through TOSCA, leading to a reduced risk of system vulnerabilities by 15%. • Developed detailed functional design specifications for CRM and ERP system customizations and integrations, including API connections and custom workflows, thus enabling seamless cross-functional collaboration. • Actively participated in SCRUM Calls with cross-functional teams of Developers, Business Analysts, and Clients, tracking objectives and outcomes, leading to 20% improved collaborative insights and decision-making. • Developed and delivered 5+ comprehensive user training manuals, SOPs, and FRD reducing onboarding time for new employees by 15%, and 30% reducing project review time, and improving cross-team collaboration. • Designed 5 interactive Power BI dashboards and 20 dynamic reports, effectively communicating complex data insights to diverse stakeholders, vendors, and cross-functional teams, promoting a data-driven culture, and driving positive business outcomes.

University of Texas at Dallas, Richardson

Information Technology, MS•  August 2022 - Present

ACADEMIC PROJECTS: • Utilized Tableau to compare cryptocurrency performance with traditional markets. Developed interactive dashboards that identified a strong correlation between Bitcoin price and gold market volatility, providing insights for investment strategies. • Leveraged advanced SQL techniques (joins, window functions, filtering) to conduct a comprehensive analysis of the world's oldest businesses (>2000 years), which uncovered historical patterns in business longevity, revealing key drivers of adaptability. • Leveraged Power BI and Bayesian statistics to analyze death records spanning 20 years. Discovered a 32% positive association between left-handedness and lifespan, suggesting left-handed individuals may live longer on average. • Analyzed user engagement on Spotify by 10% by identifying key trends in user behavior using Pandas, NumPy, and Seaborn. Insights led to a 10% increase in quality content recommendations and personalized ad campaigns.