Pushpinder Kaur

Accomplished Senior Software Developer with 7.2 years of experience leading projects by acting as developer and programmer analyst. Proficient in supporting project deliverables and maintaining releases. Strong leader in guiding support teams and solving complex issues. Steadfast in planning and implementing effective development strategies based on industry best practices.

Reference: Reference available upon request.

Driving License : Full UK driving license.

Relocation: Ready to relocate.

Visa Status : Authorized to work in the UK. Valid until Feb 26 (will be extendable).

Microsoft Data Analyst

Project 1: Data Management and Reporting Enhancement

Role : SQL Developer / Analyst

Responsibilities and Achievements : 

• Conducted seamless software installations and upgrades, ensuring minimal disruption to ongoing operations.
• Utilized advanced SQL skills to develop and optimize complex queries, stored procedures, functions, and triggers to efficiently extract, transform, and load (ETL) data from diverse sources.
• Collaborated with cross-functional teams to gather and analyze customer data requirements, ensuring accurate and comprehensive data representation.
• Generated custom reports and documents using SQL queries and MS Excel, providing actionable insights to stakeholders.
• Ensured data integrity and security through rigorous testing and validation procedures.
• Enhanced reporting efficiency by 30% through the optimization of SQL queries and implementation of performance tuning techniques.
• Successfully reduced data retrieval time by 40% by implementing indexing strategies and query optimization techniques.
• Received commendations from clients for delivering customized reports that significantly improved decision-making processes.
• Streamlined data migration processes, resulting in a 25% reduction in project timelines and associated costs.
• Proactively identified and resolved data inconsistencies, contributing to a 20% increase in overall data accuracy and reliability.

Project 2  : Sales Performance Dashboard

Role : Data Analyst

Responsibilities and Achievements : 

• Developed interactive dashboards and reports in Power BI to visualize key performance indicators (KPIs) and trends, facilitating data-driven decision-making for senior management.
• Conducted complex SQL queries to extract, clean, and analyze data from various databases, identifying insights and trends to optimize business processes.
• Utilized advanced Excel functions and macros to automate data processing tasks, reducing manual effort by 30%.
• Integrated data from multiple sources, including CRM and ERP systems, to provide a comprehensive view of sales activities.
• Implemented dynamic filters and drill-down capabilities for interactive analysis by sales managers and executives.
• Presented findings and recommendations to stakeholders through clear and concise reports and presentations.

Project 3  : Data Warehouse Migration

Role : ETL Developer

Responsibilities and Achievements : 

• Led the migration of a legacy data warehouse to a modern cloud-based platform using SSIS, SSRS, and Azure services.
• Designed and implemented ETL packages to extract data from on-premises sources, transform it using Azure Data Factory, and load it into Azure SQL Data Warehouse.
• Developed custom monitoring and alerting solutions using C# and Azure Functions to ensure data integrity and reliability during the migration process.