Nitin Balasaheb Shrikant
Pune
Summary
Dynamic Technical Lead with extensive experience at Tech Mahindra Ltd, excelling in SQL and PL/SQL for performance tuning and complex query optimization. Proven ability to enhance data solutions while demonstrating strong analytical skills. Adept at collaborating with cross-functional teams to deliver innovative IT solutions that drive business success.
Overview
9
9
years of professional experience
Work History
Technical Lead
Tech Mahindra Ltd
Pune
01.2023 - Current
- Company Overview: Tech Mahindra Ltd is a leading provider of IT services and solutions, specializing in telecommunications and technology
- Analysis and understanding requirement specification
- Writing SQL queries for report generation as per the requirement
- Created views as per the business requirements
- Created materialized views as per the requirements
- Have knowledge of triggers
- Worked for performance tuning to faster the query
- Worked for complex queries as per the requirements
- Provided optimum solution to requirement by enhancing PLSQL scripts
- Root cause analysis to the issue with the help of Debugging
- Tech Mahindra Ltd is a leading provider of IT services and solutions, specializing in telecommunications and technology
Software Developer
Saama Technologies (India) Pvt Ltd
09.2021 - 11.2022
- Company Overview: Saama Technologies provides data analytics and AI solutions to various industries, focusing on healthcare and life sciences
- Analysis and understanding requirement specification
- Writing SQL queries for report generation as per the requirement
- Created views as per the business requirements
- Worked for performance tuning to faster the query
- Worked for complex queries as per the requirements
- Provided optimum solution to requirement by enhancing SQL scripts
- Root cause analysis to the issue with the help of Debugging
- Saama Technologies provides data analytics and AI solutions to various industries, focusing on healthcare and life sciences
Software Developer
Clover Infotech Pvt Ltd
10.2019 - 09.2021
- Company Overview: Clover Infotech is a leading IT services provider specializing in software development and IT consulting
- Analysis and understanding requirement specification
- Writing SQL queries for report generation as per the requirement
- Created Packages, Procedures, Functions, Indexes and views
- Worked for performance tuning to faster the query
- Have fair knowledge of bulk collect to extract the data in huge amounts
- Have knowledge of triggers
- Worked for complex queries as per the requirements
- Created materialized views as per the requirements
- Provided optimum solution to requirement by enhancing PLSQL scripts
- Root cause analysis to the issue with the help of Debugging
- Clover Infotech is a leading IT services provider specializing in software development and IT consulting
Software Developer
Exxat Systems Pvt Ltd
10.2018 - 07.2019
- Company Overview: Exxat Systems provides software solutions for healthcare education, focusing on clinical education management
- Have fair knowledge of database objects-tables, views, synonyms, function, procedures
- Analysis and understanding requirement specification
- Writing SQL queries for report generation as per the requirement
- Root cause analysis to the issue with the help of Debugging
- Exxat Systems provides software solutions for healthcare education, focusing on clinical education management
Software Developer
RevGurus Info India Private Limited
01.2018 - 07.2018
- Company Overview: RevGurus provides IT solutions and consulting services, focusing on software development and data management
- Have fair knowledge of database objects-tables, views, synonyms, function, procedures
- Analysis and understanding requirement specification
- Writing SQL queries for report generation as per the requirement
- Root cause analysis to the issue with the help of Debugging
- Provided optimum solution to requirement by enhancing PLSQL Scripts
- RevGurus provides IT solutions and consulting services, focusing on software development and data management
Trainee Software Engineer
BricTech Software Pvt Ltd
09.2016 - 12.2017
- Company Overview: BricTech Software specializes in software development and IT services, particularly in the e-commerce sector
- Analysis and understanding requirement specification
- Writing SQL as per the client requirements to generate reports
- Migrate database objects (Procedure & Functions) from MS SQL to MYSQL database
- Export & Import in Database
- Have fair knowledge of database objects-tables, views, synonyms, function, procedures
- Was involved in database monitoring activities
- Writing SQL queries for report generation as per the requirement
- Created SSIS packages to load data from MSSQL to MYSQL
- Root cause analysis to the issue with the help of Debugging
- Provided optimum solution to requirement by enhancing PLSQL Scripts
- BricTech Software specializes in software development and IT services, particularly in the e-commerce sector
Education
M.C.A. - Management
Savitribai Phule Pune University
01.2016
B.S.C - C S
B.A.M.U.A University
01.2014
H.S.C. - Science
Maharashtra State Board
01.2011
S.S.C. - English
Maharashtra State Board
01.2009
Skills
- Oracle PL/SQL Developer
- PostgreSQL
- MySQL, MS SQL
- SQL, T-SQL, ETL
- Windows 10
- Toad
- SQL Developer
- Snowflake
- JIRA
- MS-Office
- Excel
- Edit plus
- Notepad
Key Skills
● Total Experience of 7.8 + Years in Software development.
● Expertise in requirement analysis, designing, developing, implementing and executing a project
● Expertise in creating tables and constraint definitions, views, sequence and synonyms.
● Proficiency in PL/SQL programming with experience of Collections, Stored Procedures, Packages, Functions, Views, Indexing, Cursors, Exception handling, Bulk collect and Database Triggers.
● Experience in Dynamic SQL, Collections and Exception handling.
● Experience in SQL performance tuning.
● Experience of working with oracle inbuilt Functions, Packages, Exceptions, Explain plan and inbuilt features.
● Enthusiastic with good analytical skills and flair to learn new skills and technologies.
● Able to communicate effectively with both technical and non-technical project stakeholders.
● Experience in creating unit test cases, technical analysis, demo file and impact document as per the project requirement.
● Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
● Experience of SOAP user interface.
● Having basics of java script.
● Having basics of UNIX shell scripting.
Languages
- English
- Hindi
- Marathi
Hobbies and Interests
- Trekking
- Watching seasons
Disclaimer
I hereby declare that the above-mentioned information is correct and true to the best of my knowledge.
Personal Information
- Date of Birth: 11/02/92
- Marital Status: Married
Timeline
Technical Lead
Tech Mahindra Ltd
01.2023 - Current
Software Developer
Saama Technologies (India) Pvt Ltd
09.2021 - 11.2022
Software Developer
Clover Infotech Pvt Ltd
10.2019 - 09.2021
Software Developer
Exxat Systems Pvt Ltd
10.2018 - 07.2019
Software Developer
RevGurus Info India Private Limited
01.2018 - 07.2018
Trainee Software Engineer
BricTech Software Pvt Ltd
09.2016 - 12.2017
M.C.A. - Management
Savitribai Phule Pune University
B.S.C - C S
B.A.M.U.A University
H.S.C. - Science
Maharashtra State Board
S.S.C. - English
Maharashtra State Board
Similar Profiles
Sangeetha GajamSangeetha Gajam
Sr DevOps Engineer at Tech Mahindra LtdSr DevOps Engineer at Tech Mahindra Ltd
Achint KumarAchint Kumar
Associate Tech Lead at Tech Mahindra LtdAssociate Tech Lead at Tech Mahindra Ltd
Gowthami VemulapalliGowthami Vemulapalli
Senior Associate Analyst (Supply Chain Application Support) at Tech Mahindra LtdSenior Associate Analyst (Supply Chain Application Support) at Tech Mahindra Ltd