GANDHI B
Software Developer
Chennai
Summary
- Experienced in SQL and PL/SQL development, maintaining various databases such as Oracle, PostgreSQL, SQL Server, Azure Synapse, Azure Databricks, and Snowflake.
- Actively participated in the entire Software Development Life Cycle (SDLC), including design, development, testing, implementation, documentation, and support of software applications.
- Expertise in utilizing indexes, analytical functions, views, constraints, and subqueries for application development.
- Skilled in working with Oracle Pseudo columns, joins, group functions, sequences, and global temporary tables.
- Extensive experience creating stored procedures and functions, triggers, packages, cursors, collections, and materialized views.
- Proficient in handling errors using exception handling techniques for effective debugging and displaying error messages.
- Expertise in loading data from flat files into database tables using SQL*Loader and performance tuning for Oracle RDBMS using Explain Plan.
- Strong understanding of creating dimensions and facts in DWH modeling and experience with Azure Synapse.
- Developed Synapse pipelines to load data from different sources to dedicated SQL databases.
- Developed and maintained complex reports, loaded data from PostgreSQL and Oracle tables to MS Excel using JasperSoft Studio 6.4+.
- Designed Jasper Reports, Dashboards, Ad Hoc Views for BI reporting in Jasper Server.
- Designed rich-looking financial and billing reports using Oracle SQL and analytic functions deployed onto Jasper Server.
- Adept at creating new input controls and managing the server's repository on the Jasper Server.
- Designed sub-reports, hyperlinks, charts reports using JasperSoft Studio and deployed them in the Jasper Server.
- Implemented advanced ETL methodologies using SQL to import data into Power BI resulting in a significant boost in data reliability.
- Utilized advanced DAX queries in Power BI desktop to provide detailed insights and achieve 20% better performance.
Overview
11
11
years of professional experience
Work History
Manager
Capgemini Technology Services India Limited
10.2024 - Current
Senior Consultant
Capgemini Technology Services India Limited
04.2022 - 09.2024
Senior Software Engineer
Infinite Computer Solution
04.2021 - 04.2022
Software Engineer
BCITS Private Limited
10.2018 - 04.2021
Assistant Professor
RVS Padhamavathy College of Engineering and Technology
08.2014 - 07.2018
Education
Master of Engineering -
Loyola Institute of Technology
ChennaiBachelor of Engineering -
Sri Muthu Kumaran Institute of Technology
Skills
- SQL
- PLSQL
- Oracle RDBMS
- Postgre SQL
- SQL Server
- SQL PLUS
- Jaspersoft Studio 64
- Jasper Reports
- Power BI
- Azure Synapse
- Azure Databricks
Declaration
I hereby declare that the information furnished above is true to the best of my knowledge.
Timeline
Manager
Capgemini Technology Services India Limited
10.2024 - Current
Senior Consultant
Capgemini Technology Services India Limited
04.2022 - 09.2024
Senior Software Engineer
Infinite Computer Solution
04.2021 - 04.2022
Software Engineer
BCITS Private Limited
10.2018 - 04.2021
Assistant Professor
RVS Padhamavathy College of Engineering and Technology
08.2014 - 07.2018
Master of Engineering -
Loyola Institute of Technology
Bachelor of Engineering -
Sri Muthu Kumaran Institute of Technology
Similar Profiles
Vasu Sagar AbishettiVasu Sagar Abishetti
Finance Controller at Capgemini Technology Services India LimitedFinance Controller at Capgemini Technology Services India Limited
Debjit MukherjeeDebjit Mukherjee
Senior Service Lead – Managed Services at Capgemini Technology Services India LimitedSenior Service Lead – Managed Services at Capgemini Technology Services India Limited
BHAGAVATULA R V S S SAISREEBHAGAVATULA R V S S SAISREE
Senior Analyst/Software Engineer at CAPGEMINI TECHNOLOGY SERVICES INDIA LIMITEDSenior Analyst/Software Engineer at CAPGEMINI TECHNOLOGY SERVICES INDIA LIMITED