Simranjeet Singh Email & Phone Number

Banbury, Gb

Ellesmere Port, England, United Kingdom

* Design and develop the Destination Form, collecting data from over 9,000 students, utilising HTML, CSS, JavaScript, and Python, with deployment in Azure.* Create and optimise Power BI dashboards to enhance reporting systems and improve data-driven decision-making.* Efficiently write stored procedures, manage SQL jobs, and optimise query performance to ensure accurate data retrieval for in-depth analysis and reporting.* Collaborate with cross-functional teams to identify data quality issues, implementing data governance strategies to increase data accuracy and reduce reporting discrepancies by 15%.* Automate routine data extraction and reporting processes using Python scripts, reducing manual effort and increasing operational efficiency.* Mentor junior analysts, providing guidance on SQL query optimisation, data visualisation best practices, and career development within the data analytics field.* Effectively created power apps to streamline data, integrate with sql, Enhance visualisations and automate workflows.

Buckinghamshire, England, United Kingdom

• Collaborated closely with cross-functional teams to collect and analyse financial data. As a BI Finance Analyst, I ensured financial strategies were aligned with organisational objectives.• Ingested data from data sources using the Amazon Ads API, Google Analytics API, and Salesforce API, using Python to create a data view to be used in BI Tools.• Designed, developed, and managed 120+ Power BI dashboards for real-time insights, supporting data-driven decision-making. Ensured continuous maintenance and optimisation for enhanced data visualisation and accessibility.• Utilised advanced Excel functions and Power Query to efficiently manipulate and transform large datasets, ensuring data accuracy and integrity for strategic analysis and reporting.*Efficiently extracted data from SQL databases using advanced SQL techniques, optimising query performance and ensuring accurate data retrieval for in-depth analysis and reporting.

Caldicot, Wales, United Kingdom

• Skilled in utilising advanced SQL querying and database manipulation to extract, transform, and analyse data, contributing to strategic business insights.• Communicated findings and insights to both technical and non-technical stakeholders through clear and concise ad-hoc reports• Proficient in leveraging advanced Excel functions, pivot tables, VBA, macros, and data visualization techniques to extract insights and enhance data-driven decision-making.• Developed and implemented data pipelines to improve data quality, resulting in a 30% increase in data accuracy.• Leveraged Power BI and SQL Server Management Studio to delve into customer data, uncovering valuable trends and patterns aimed at enhancing customer satisfaction rates

• Use Power BI to run Dax queries and functions.• Proficiency in reconciling complex financial data within the audit delivery team, ensuring accuracy and compliance with industry standards.• Maintained meticulous documentation of reconciliation procedures and outcomes and produced comprehensive reports for audit reviews and management stakeholders. • Collaborated with data engineers to develop the data pipelines to improve data quality and accessibility.

Cardiff, Wales, United Kingdom

Delhi, India

Master'S Degree, Data Science And Analytics

Foundation of Statistics and Data Science , Data visualisation, Linear and Integer programming for mathematical modelling, Applied Machine.

Bachelor Of Science - Bs, Mathematics (Honours)

Linear Algebra, Linear Programming, Analytical Geometry, Theory of Matrices, Linear Differential Equation, Calculus of Several Variables.