Pushpinder Kaur

Expert software development professional with proven skills in project management, coding and testing. Brings 7.9 years of experience in building robust, well-performing applications matching specifications and exceeding expectations. Seeks out opportunities to expand skills and improve designs.

• Microsoft Data Analyst, 06/2024
• Microsoft Azure Foundation, 11/2019
• Microsoft C#, 07/2015
• Oracle PL/SQL, 09/2015

Project 1: E-Commerce Web Application

Role: Full stack developer

Responsibilities and Achievements:

• Designed the database schema, implemented backend APIs, and created a responsive frontend interface.

• Developed and maintained web applications using C#, MySQL, and JavaScript frameworks (React.JS).

• Participated in code reviews and provided constructive feedback to peers.

• Implemented unit tests using NUnit and Moq to ensure code quality and reliability.

• Worked on optimizing SQL queries for better performance.

Project 2: Sales Performance Dashboard

Role: Data Analyst

Responsibilities and Achievements:

· Created interactive dashboards and reports in Power BI to visualize KPIs and trends.

· Enabled data-driven decision-making for senior management through clear visualizations.

· Utilized Python/R for data manipulation and statistical analysis.

· Conducted complex SQL queries to extract data from multiple databases by cleaning and analyzing data to ensure accuracy and relevance.

· Utilized advanced Excel functions and macros to automate data processing tasks, reducing manual effort by 30%.

· Implemented dynamic filters and drill-down capabilities for interactive analysis by sales managers and executives.

Project 3: Banking Data Analysis and Optimization

Role: SQL Developer

Responsibilities and Achievements:

· Designed and optimized SQL queries to extract, transform, and load (ETL) banking transaction data from diverse sources.

· Created stored procedures and triggers to automate routine data management tasks, ensuring data integrity and reliability.

· Conducted performance tuning of SQL queries to improve database responsiveness and query execution times.

· Implemented data validation checks and error handling procedures to maintain data quality and compliance with regulatory standards.

Project 4: Financial Reporting Dashboard

Role: MSBI/BI Developer

Responsibilities and Achievements:

· Integrated financial data from disparate sources into Snowflake using SSIS, ensuring data accuracy and completeness.

· Designed and implemented robust ETL processes in SSIS to extract, transform, and load financial data for reporting purposes.

· Developed SSAS cubes to create multidimensional models for in-depth financial analysis and reporting.

· Created interactive and dynamic financial reports using SSRS, providing stakeholders with actionable insights into key financial metrics.

· Automated daily, weekly, and monthly financial reporting processes using MSBI tools, reducing manual effort and improving efficiency by 40%.

· Optimized SQL queries and SSAS cube processing to enhance performance and ensure timely delivery of financial reports and analysis.

Project 5: Ecommerce Website Redesign

Role: Web Designer

Responsibilities and Achievements:

· Created intuitive and visually appealing interfaces using HTML, CSS, JavaScript, and Figma, ensuring seamless navigation and enhanced user engagement.

· Customized and implemented WordPress themes and plugins to optimize site performance and functionality.

· Implemented SEO best practices to improve search engine visibility and drive organic traffic to the website.

· Developed a responsive design strategy to ensure optimal performance across various devices and screen sizes.

· Managed and updated product listings, images, and content to maintain relevance and accuracy.

Optimized website performance through code refactoring, image compression, and caching techniques, resulting in a 30% improvement in page load times.

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).