Piyanshu Patel Email & Phone Number

United Kingdom

Greater London, England, United Kingdom

Greater London, England, United Kingdom

• Spearheaded data extraction from CRM and Dynamics 365, ensuring precise and punctual retrieval using SQL queries.• Utilized Excel for data preprocessing, executing data mapping activities, pulling data, analyzing, and summarizing key findings into comprehensive reports.• Recognized for significant contributions to the project and expertise in developing a data model and utilising web-based tools for establishing database connections to achieve desired results for data visualization.• Spearheaded the development of Power BI dashboards, highlighting key performance indicators (KPIs) to enable decision-making within the finance department, leading to a productivity increase of 15%.• Staged and shaped data from multiple sources into cohesive reporting and maintained analytics solutions, performing comprehensive data analysis.• Assisted in producing daily, weekly, and monthly reports for various stakeholders and collaborated with teams to identify data problems and contribute 25% less time to data-driven solutions.• Provided Ad-hoc analysis to support various business initiatives and collaborated with teams to investigate issues and develop reports that supported business questions.• Identified, troubleshooted, and resolved data-related issues to ensure seamless data operations.

• Performed ETL processes to gather data from diverse sources, performed filtering, and rectified errors to consolidate data for analysis and visualization in Excel and BI tools, resulting in a 12% increase in productivity time.• Generated routine reports and in-depth analysis of extensive datasets using SQL, ensuring 100% accuracy in tracking KPIs, and delivering actionable insights to stakeholders.• Designed and implemented a Revenue Assurance dashboard on Salesforce for the entire organization which reduced DSO (Days Sales Outstanding) by 19,23% (From 26 Days down to 21 Days).• Created automated data pipelines utilizing Python scripts to pull data from databases and APIs, optimized for multithreading to save 75% of runtime.• Implemented various DAX functions for efficient data extraction in Power BI, enhancing analytical capabilities.• Conducted hypothesis testing and statistical analysis using t-tests to validate findings and support decision-making.• Integrated Power BI with Microsoft products like Excel, SharePoint, and Teams to facilitate seamless data collaboration.• Promoted automation across the organization and supported business development.

• Utilized Excel and Power BI to create visually appealing interactive reports, dashboards, and presentations, ensuring 100% data accuracy for effective communication of complex data insights to stakeholders.• Achieved project goals by transforming extensive data into actionable business insights through data visualization.• Led a KFC campaign for mobile marketing, extracting, and analyzing data using SQL queries to inform strategic decision-making, increasing delivery rate from 66% to 87%.• Devised automation, backup, and recovery protocols to ensure data integrity and confidentiality.

Postgraduate Degree, Data Science

Bachelor Of Engineering - Be, Computer Science

Diploma Of Education, Computer Engineering