Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Languages
Timeline
Generic

Rakesh Mahale

Pune

Summary

Dynamic and results-oriented Senior Software Developer with 5.8+ years of experience at Paysquare Consultancy Limited and Bit Hub Technology, specializing in MS SQL Server development, database administration, and data management. Recognized for delivering high-performance, scalable database solutions and leading cross-functional teams to success.

Proficient in Stored Procedures, Triggers, Functions, Complex Query Debugging, and Data Migration, with a strong emphasis on query optimization and performance tuning. Hands-on experience with ETL tools, Python scripting, advanced Excel, and Power BI for business reporting and data visualization.

Successfully led a team of 10 members, managing task allocation, mentoring, and ensuring timely project delivery. Adept at collaborating with stakeholders, analyzing business requirements, and transforming them into effective data solutions.

Committed to quality, efficiency, and continuous improvement, with a proven track record of driving operational excellence through database innovation and strategic thinking.

Overview

6
6
years of professional experience
1
1
Certification

Work History

SR SOFTWARE DEVELOPER

Paysquare Consultancy limited
Pune
01.2023 - Current

SQL Developer and Team Lead with over 2.6 years of hands-on experience in developing, administering, and optimizing database applications and information systems. Proven ability to lead and mentor a team of 10 members, ensuring timely delivery of quality solutions, and fostering a collaborative work environment.

Possesses strong technical expertise in:

  • MS SQL Server: Advanced query writing, performance tuning, trigger development, views, index creation, and stored procedures.
  • DBA Activities: Backup and restore operations, database monitoring, user, and permission management.
  • ETL Tools: Experience in data extraction, transformation, and loading processes for effective data integration.
  • Data Visualization: Proficient in Power Bi for creating interactive dashboards and reports to support business decision-making.
  • Advanced Excel: Skilled in using functions, pivot tables, charts, and data analysis tools.
  • Python: Basic scripting for data handling and automation tasks.

Additionally, I am responsible for:

  • Leading and managing the database team: task allocation, performance reviews, technical mentoring, and stakeholder communication.
  • Collaborating with cross-functional teams to understand data requirements, and deliver robust data solutions.
  • Documenting database designs, configurations, procedures, and best practices for future reference and knowledge sharing.
  • Extracted, transformed, and analyzed payroll data using BigQuery, creating optimized datasets for visualization.

PLSQL DEVELOPER

Bit Hub Technology
Pune
10.2019 - 01.2023

PL/SQL Developer with 3.2 years of hands-on experience in stored procedures, trigger writing, debugging complex queries, creating SQL functions, and data migration. And data integrity. Demonstrated expertise in:

  • Advanced SQL Development: Writing and debugging complex queries, stored procedures, triggers, views, and user-defined functions.
  • Data Migration Projects: Hands-on experience in planning and executing data migration between systems, while ensuring data accuracy and minimal downtime.
  • Query Performance Optimization: Identifying bottlenecks, optimizing indexes, and tuning queries for enhanced system efficiency.
  • Collaboration with cross-functional teams: Working closely with application developers, business analysts, and QA teams to gather requirements and deliver data-driven solutions.
  • Database Maintenance & Support: Involved in routine data validations, integrity checks, schema updates, and production support activities.

Played a key role in delivering critical database solutions that supported business operations and analytics, contributing to both project success and long-term maintainability.

Education

Bachelor of Technology - Computer Science

Dr. D.Y. Patil Vidyapeeth
Pune
01.2021

Polytechnic - Mechanical Engineering

K.B.H Polytechnic
Malegaon
01.2018

Skills

Database Development & Administration:

  • MS SQL Server, T-SQL
  • Stored Procedures, Triggers, Views, Functions
  • Query Performance Tuning & Optimization
  • Data Migration & Transformation
  • Indexing & Execution Plan Analysis
  • Backup & Restore Operations
  • User Management & Access Control

ETL & Data Handling:

  • ETL Tools (eg, SSIS or similar)
  • Data Extraction, Transformation & Loading
  • Data Validation & Cleansing

Data Visualization & Reporting:

  • Power BI (Dashboards, Visual Reports)
  • Advanced Excel (pivot tables, VLOOKUP, charts, formulas)

Programming & Scripting:

  • Python (Data handling, Automation scripts)

Tools and collaboration

  • SQL Server Management Studio (SSMS)
  • Visual Studio (if applicable)
  • Jira / Trello (for project tracking)
  • Git (version control, if used)

Soft Skills & Leadership:

  • Team Leadership & Mentoring (10 member team)
  • Requirement Gathering & Business Analysis
  • Cross-functional collaboration
  • Documentation & Knowledge Sharing
  • BugQuery (Bug Tracking and Reporting Tool)
  • SQL Server Management Studio, BugQuery, Git, Postman

Certification

SQL training certification, 01/01/19, 10/31/19

Accomplishments

  • Successfully optimized a critical database query, reducing the risk of data loss
  • Received recognition from management for consistently delivering high-quality solutions within timelines
  • Employee of the Month award

Languages

  • English, Professional Working Proficiency
  • Hindi, Native or Proficiency
  • Marathi, Native or Proficiency

Timeline

SR SOFTWARE DEVELOPER

Paysquare Consultancy limited
01.2023 - Current

PLSQL DEVELOPER

Bit Hub Technology
10.2019 - 01.2023

Bachelor of Technology - Computer Science

Dr. D.Y. Patil Vidyapeeth

Polytechnic - Mechanical Engineering

K.B.H Polytechnic
Rakesh Mahale