Master of Science - Project Management
University of Northampton
Northampton, United Kingdom 06.2022 - 11.2023
Pushpinder Kaur
Senior Software Developer
Leicester,United Kingdom
Summary
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.
Education
Bachelor of Engineering - Computer Science
Mumbai University
Mumbai 05.2009 - 05.2013
Skills
SQL programming language(MS SQL, MySQL, Oracle)
Visualization Tool (Power BI, Tableau)
Programming Language (C#, ASPNET, Python, PHP)
BI Tools (SSIS, SSAS,SSRS)
Oracle Apex
SQL Server Adminisitration
Front end languages (HTML, CSS, Javascript)
GitHub and TeamCity
Communication
Mathematical and statistical knowledge
Database security best practices
Performance tuning and database optimization
Content Developer (Wordpress)
Timeline
Microsoft Data Analyst
06-2024
Project Management
03-2024
Master of Science - Project Management
University of Northampton
06.2022 - 11.2023
Microsoft Azure Foundation
11-2019
Senior Software Developer
Accenture
04.2019 - 05.2022
Software Developer
Infosys Ltd.
01.2018 - 10.2018
Oracle PL/SQL
09-2015
Microsoft C#
07-2015
Software Developer
Atos Global IT Solutions
06.2015 - 12.2017
Associate Software Developer
Varian Software Teachnology Ltd
10.2013 - 11.2014
Bachelor of Engineering - Computer Science
Mumbai University
05.2009 - 05.2013
Work History
Senior Software Developer
Accenture
Gurugram, India
04.2019 - 05.2022
- Administered SQL Server installations, configurations, and migrations, ensuring optimal performance and security.
- Developed and maintained complex T-SQL, PL/SQL, and stored procedures for various applications.
- Conducted performance tuning and database optimization, significantly improving query response times.
- Implemented and managed SSRS, SSAS, and SSIS solutions for comprehensive data management.
- Collaborated with cross-functional teams to deliver robust .NET applications using C#, ASP.NET.
- Utilized Python for scripting and automation, enhancing system efficiency.
- Created and deployed interactive dashboards and reports using Tableau and Power BI.
- Led customer-facing meetings to gather data requirements and ensure successful project delivery.
- Utilized GitHub and Team City for version control and CI/CD pipelines, streamlining development process.
- Provided expertise in Microsoft Access and VBA programming for custom solutions.
- Conducted training sessions on best practices for database security and optimization.
- Successfully migrated SQL databases to Azure SQL Database with zero downtime.
- Reduced query execution times by 60% through performance tuning and optimization.
- Reduced system downtime by conducting rigorous testing and addressing critical bugs promptly
- Contributed to architecture design of complex software systems, ensuring scalability and maintainability
- Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
Software Developer
Infosys Ltd.
Pune, India
01.2018 - 10.2018
- Oversaw SQL Server installations, configurations, and migrations, ensuring peak performance and security.
- Developed and maintained complex T-SQL, PL/SQL, and stored procedures.
- Conducted performance tuning and database optimization, enhancing query response times significantly.
- Managed database technologies including SQL Server, MySQL, and Oracle.
- Designed and implemented front-end solutions using HTML, CSS, JavaScript, and React.
- Ensured code quality and consistency using version control systems like Git.
- Developed multidimensional and tabular models with SSAS, improving data analysis capabilities.
- Enhanced ETL processes with SSIS for accurate and efficient data flow.
- Improved team productivity by 30% through introduction of Agile and Scrum methodologies.
Software Developer
Atos Global IT Solutions
Pune, India
06.2015 - 12.2017
- Designed and maintained SQL databases, ensuring data integrity, security, and performance.
- Developed complex ETL processes using SQL Server Integration Services (SSIS) for efficient data extraction, transformation, and loading.
- Implemented data models and cubes using SQL Server Analysis Services (SSAS) to facilitate multidimensional analysis and reporting.
- Created interactive reports and dashboards using SQL Server Reporting Services (SSRS) to provide actionable insights to stakeholders.
- Optimized database performance through indexing strategies, query tuning, and partitioning techniques.
- Collaborated with cross-functional teams to integrate C# components into SQL-based solutions for enhanced functionality.
- Conducted code reviews, performance analysis, and troubleshooting to ensure reliability and scalability of database systems.
- Provided technical guidance and mentorship to junior developers on SQL best practices and development methodologies.
- Reduced ETL processing time by 30% through optimization and parallel processing techniques.
- Implemented comprehensive SSRS reporting solution, resulting in 20% increase in data accessibility and decision-making efficiency.
Associate Software Developer
Varian Software Teachnology Ltd
Pune, India
10.2013 - 11.2014
- Developed and maintained SQL queries, stored procedures, and triggers to support business applications.
- Implemented SSIS packages for data extraction, transformation, and loading from heterogeneous data sources.
- Participated in database design discussions, contributing to schema design, normalization, and indexing strategies.
- Utilized C# for developing custom applications and utilities to automate data-related tasks.
- Generated ad-hoc reports and data extracts based on user requirements using SSRS.
- Conducted performance tuning and optimization of SQL queries and stored procedures to improve application responsiveness.
- Collaborated with QA teams to ensure data accuracy and integrity throughout development lifecycle.
- Streamlined data migration processes, reducing project timelines by 20%.
- Implemented database monitoring solutions, reducing downtime by proactively identifying and resolving performance issues.
Additional Information
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).
Certification
Microsoft Data Analyst
Projects
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.
Overview
9
9
years of professional experience
5
5
years of post-secondary education
5
5
Certificates
1
1
Language