DHANANJAY GURAV
SQL-ETL Developer
Mumbai
Summary
I am a BSc IT graduate with a strong passion for SQL programming and data Management. SQL Developer with 4 years of progressive experience in Ms-SQL Server,Oracle and Sybase databases and application programming. . Proficient at data architecture design, emerging data warehouse concepts and new SQL development techniques. Takes responsibility for data integrity from acquisition through processing and into final validation. Collaborate closely with cross-functional teams to understand business requirements and deliver solutions that align with organizational goals. Talented Informatica Developer with good requirements gathering, mapping and logic design skills. Detail-oriented and thorough with good grasp of business processes and needs developed over 1 years 8 month in Finance(banking and Insurance) field.
Overview
4
4
years of professional experience
6
6
years of post-secondary education
Work History
Associate
KGiSL
02.2024 - Current
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Maintained high-quality code standards through rigorous testing and peer code reviews, minimizing potential bugs and security vulnerabilities.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Provided technical support for end-users by addressing SQL-related issues, enhancing overall user satisfaction with application.
- Developed custom database objects, stored procedures and delivered application support.
- Managed customer relations through communication and helpful interactions
SQL DEVLOPER
INFOCUS TECHNOLOGIES
5 2022 - 12.2023
- We Developed IRDA Finical Report from SYBASE AND ORACLE Database with help of INFORMATICA Tool that automated by our developer Team.
- That Report are submitted to IRDA department.
- Developed data models and database designs to plan projects
- Takes responsibility for data integrity from acquisition through processing and into final validation.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Provided technical support for end-users by addressing SQL-related issues, enhancing overall user satisfaction with application.
- Developed custom database objects, stored procedures and delivered application support.
- Dynamic ETL Developer practiced in helping companies with diverse transitioning, including sensitive Sybase data and massive, big data installations.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Tested database performance and functionality, implementing modifications to correct issues
- I collaborate closely with cross-functional teams to understand business requirements and deliver solutions that align with organizational goals
- Promotes extensive simulation and testing to provide smooth ETL execution
- Effective tools to automate and optimize database management tasks.
- Enhanced data integration by designing and developing efficient ETL processes using Informatica PowerCenter.
- Streamlined data extraction, transformation, and loading for improved overall system performance.
- Developed standard mappings, workflows, and sessions to meet project objectives and deadlines.
APPLICATION SUPPORT
PROIND BUSINESS SOLUTION
03.2020 - 04.2022
- Work for compliance application in client location LIC OF INDIA
- Updated compliance data sheet in compliance Application by using MS-SQL SERVER Management studio 2014
- Get daily back up of application in SQL SERVER Management studio 2014
- We uploaded Excel sheet in our application for compliance through Sql-database
- We maintain data, create table and column as per user Requirement
- Provide technical support to databases, including system management, backup/recovery account management, configuration management
- Performed deployment on testing and production
- Server.
BACK-OFFICE EXECUTIVE
POWERWEAVE
- We are entered incoming purchase orders into AS400 screen and convert in invoice
- We are maintaining that data into Excel sheet
- This is US base clients the client's name is hitrpomo
- This totally back-office data entry work in night shift as per client time zone.
CUSTOMER SERVICE ASSOCIATE
FIRSTSOURCE SOLUTION LIMITED
- It's a full-time inbound voice process
- Our product is Airtel telecom service(postpaid)
- We received a called from south zone of India
- We solved a customer query related bill, plan and others
- It's a domestic call center so speak in regional language like Hindi and English with customer.
Education
B.sc (IT) -
Mumbai University
Mumbai 06.2012 - 07.2016
Bachelor of Science - HSC
Maharashtra Board
Mumbai 02.2008 - 03.2010
SSC -
Maharashtra Board
MumbaiSkills
SQL development
Advanced SQL Queries
Stored Procedures
ETL development
Data Validation
Real-time Data Processing
Indexing Strategies
Workflow Design
Data Mapping
ETL processes
Microsoft Office
MS Office
Timeline
Associate
KGiSL
02.2024 - Current
APPLICATION SUPPORT
PROIND BUSINESS SOLUTION
03.2020 - 04.2022
B.sc (IT) -
Mumbai University
06.2012 - 07.2016
Bachelor of Science - HSC
Maharashtra Board
02.2008 - 03.2010
SQL DEVLOPER
INFOCUS TECHNOLOGIES
5 2022 - 12.2023
BACK-OFFICE EXECUTIVE
POWERWEAVE
CUSTOMER SERVICE ASSOCIATE
FIRSTSOURCE SOLUTION LIMITED
SSC -
Maharashtra Board
Similar Profiles
Gaurav KenyGaurav Keny
Manager - Talent Acquisition at KGISLManager - Talent Acquisition at KGISL
Siranjevi KrishnanSiranjevi Krishnan
UI/UX Designer at KGISLUI/UX Designer at KGISL
Rajat SharmaRajat Sharma
Associate Consultant at KGiSLAssociate Consultant at KGiSL