To pursue a challenging position in an organization which gives room for management growth, personal fulfillment with welcome attitude for new ideas and concepts to enhance the self-growth with overall growth of the organization.
Hi, I’m
Gaurav Kathuria
Gurgaon,Haryana
Summary
Overview
9
years of professional experience
Work History
AVIZVA Solution PVT LTDGurgaon, India
Senior development Engg-Database Technologies
11.2021 - Current
Job overview
- Design and develop database structures, tables, views, and stored procedure according to project requirement.
- Write efficient SQL queries for data retrieval, modification, and reporting
- ETL (Extract, Transform, Load)
- Optimize database queries and stored procedures for improved performance.
- Create and maintain data models(logical & physical ERD) that align with application and business requirements
- Implement data security measures at the database level, including encryption and masking of data.
- Collaborate with application developers, data analysts, and other stakeholders to ensure database solutions meet business needs.
- Document database development processes, coding standards, and best practices.
- Provide guidance and mentorship to junior database developers
- Lead database-related projects and initiatives.
- Database management like ensure the availability, reliability, and performance of databases.
- Monitor database systems to identify and resolve performance issues
- Manage user access and permissions, including creating and maintaining user accounts.
Nthrive Global Solution Pvt LtdGurgaon
Software Engineer
12.2019 - 11.2021
Job overview
- Gurgaon office
- Job Profile: ∙ Troubleshoots issues, validates the root cause and performs the necessary fix as appropriate
- This may include retrieving a new data file from the client due to a data issue, rewriting code using C#, collaborating with other teams for resolution, or other troubleshooting activities
- Independently create technical solutions for complex or urgent reported issues ∙ Gather and document design requirements ∙ Provide code review and QA as needed
- Build custom features and integrations to help delight our clients
- Manages, communicates, and documents case status to clients and colleagues in a professional and timely manner ∙ Takes the initiative to enhance and document existing processes ∙ Ability to establish priorities and manage multiple critical paths ∙ Ability to evaluate multiple solutions regarding effort, risk and customer satisfaction ∙ Performs special projects and other tasks as assigned by management
TOLUNA Pvt LtdGurgaon
Database developer
12.2016 - 07.2019
Job overview
- Is in the field of Marketing Research, on demand take survey for any Business Company to research market requirements, help them to take decision accordingly
- TolunaPvt Ltd functioning across 19 countries different region (Asia, MENA, Europe, North America) in the world and head quarter in Levallois-Perret (France, ∙ Responsible for SSIS package development for all applications of Toluna
- Work on database development which included creating database object such as Tables, Views Writing Store Procedure, functions and Triggers ∙ Handling all query, data request, application relate issue of internal Toluna's User globally
- Providing the Email and Remote support to internal user in APAC/GMT/EST (Capable in anyShift time)
- Analysis the user requirements and provide them with database Solutions
- Provide training to new member who join with us
- Role play of team lead when team leader is not available
- Application's Data Analysis from front end and back end (using SQL)
- INFOMAN Group ∙ The `INFOMAN Group of Companies' is in the field of IT mainly provide software to Automobile Industry and other industries
ACS INFOTECH Pvt. LtdNew Delhi
Software Support Executive
Job overview
- Product Handled ∙ e-DMS (Dealer Management System)
- Product Description
- It is a web base billing application developed for Automobile dealership for automate operation across multiple location
- This application provides business intelligence to dealer's transactional and various reporting needs, which will highly useful for dealer's Management for monitor their daily transaction across all locations
- It has several module New Car, Pre Own, Accessories and Account
- Job Description: ∙ Create SSIS packages for e-DMS application ∙ Database development for e-DMS which included procedures, functions, tables and views ∙ Handling all major and corporate customers
- Analysis the customer requirements and provide the best Solution
- Work with business team about Customer‘s requirements implementation on production
- Test new feature and existing fixed bugs in application before go to production or live
- Prepare a Documents for customer as well as support team future references
- Collect feedback from Customers over company domain blog
- Data Analysis from front end and back end
- Projects and Details
- Data Implementation and Collections
- Client: US HealthCare Multilple Clients
- Database: SQL Server 2015, SSIS, MS Excel
Education
Indira Gandhi National Open UniversityDelhi, DL
Master of Computer Application (MCA) from Computer
2023
University Overview
- [Degree] Graduate
Maharshi Dayanand UniversityRohtak, HR
Bachelor of Comupter from Computer Application
2015
University Overview
- [Degree] Graduate
JivenJyoti Sr. Sec Public School, H.B.S.E. BoardGurgaon, HR
Higher Secondary from Non- Med
2012
University Overview
GPA: 79
JiwanJyoti Sr. Sec Public School, H.B.S.E. Board
Matric
University Overview
GPA: 81
NIIT
Professional Diploma from Software Engineering
University Overview
NIIT
Certification in C# from Microsoft
∙ Participate Certification in Developing App for Touch and Mobile Device
University Overview
Gurgaon and Duration - 7 days
University Overview
Participate Certification in Critical thinking and Creative Problem Solving
University Overview
NIIT, Gurgaon and Duration - 7 days
University Overview
Inter District College
Participate Certification in
University Overview
DSD College
Science Exhibition
University Overview
3 days.
Skills
- Having 9 years of professional in multiple Database Technologies experience in the areas of Microsoft SQL, Postgres SQL,Redshift,Elastic-Search(No Sql) & Microsoft Business Intelligence (MSBI) tool SSIS using Microsoft SQL
- Mentoring members in their technical skill and ensuring delivery of DB code in their project by guiding & reviewing the code
- Requirement understanding of project/product and develop database level implementation of Logical ERD, Physical ERD
- Hands on experience in Extract, Transform & Load (ETL) development using SQL
- Server Integration Services (SSIS) and automate it through SQL Server Job Agent
- Hands on experience in Migration activity from one database application to other database application
- Handle business requirement at database architect level and provide them healthy solution
- Good knowledge on T-SQL, Subqueries, Joins, set operations and stored procedures & Function
- Experience in technical interview & training events in database technologies
- Accepts responsibilities and job duties eagerly with minimal supervision required
- Implementing and maintaining existing systems
- Fixing some of legacy bugs which are client specific (CR's)
- Actively participating in enhancement of project at client end
- Database: MS SQL Server, Postgres SQL, Elastic Search
- ETL Tool: MSBI Tool (SSIS)
- Language: C# (some extend)
- Bitbucket
- Gitlab
- Jira
- Oracle Data Modular Jenkin Piplines (to some extend) Drawio
- MS-Office buddle AWS (Could Watch, AWS pipeline (to some extend),crontab)
TECHNICAL SKILL
Additional Information
Additional Information
- Got "Pro Marvel Award" 2 times in Avizva for handle Client's database enhancement.
- Rewards and Recognitions ∙ Got ‘nThrive Tip Top Award' award 1 time for quickly understanding the Project Requirement within few months of joining the Project. ∙ Got ‘nThrive Spot award' award 1 time for doing some enhancements in the existing project and making them generalized to be used in other projects as well.
Timeline
Senior development Engg-Database Technologies
AVIZVA Solution PVT LTD
11.2021 - Current
Software Engineer
Nthrive Global Solution Pvt Ltd
12.2019 - 11.2021
Database developer
TOLUNA Pvt Ltd
12.2016 - 07.2019
Software Support Executive
ACS INFOTECH Pvt. Ltd
Indira Gandhi National Open University
Master of Computer Application (MCA) from Computer
Maharshi Dayanand University
Bachelor of Comupter from Computer Application
JivenJyoti Sr. Sec Public School, H.B.S.E. Board
Higher Secondary from Non- Med
JiwanJyoti Sr. Sec Public School, H.B.S.E. Board
Matric
NIIT
Professional Diploma from Software Engineering
NIIT
Certification in C# from Microsoft
∙ Participate Certification in Developing App for Touch and Mobile Device
Gurgaon and Duration - 7 days
Participate Certification in Critical thinking and Creative Problem Solving
NIIT, Gurgaon and Duration - 7 days
Inter District College
Participate Certification in
DSD College
Science Exhibition