Gunjan Kumar Email & Phone Number

Gurugram, Haryana, India

• Updating all the details related to HR system like attendance, leave, Comp Off, etc. with backend when HR is not able to update the details from GUI.• Interacted with Crew member’s for getting their flight details and sales details, which they updated in the CabTab to update the missing details in the database.• Analysts and prepare the weekly/monthly report from the database and update the details to the business.• Built complex queries using SQL to get the complete Crew and… Show more • Updating all the details related to HR system like attendance, leave, Comp Off, etc. with backend when HR is not able to update the details from GUI.• Interacted with Crew member’s for getting their flight details and sales details, which they updated in the CabTab to update the missing details in the database.• Analysts and prepare the weekly/monthly report from the database and update the details to the business.• Built complex queries using SQL to get the complete Crew and their sales details that they filled in the CabTab.• Working experience as L2 Production support in rotational shifts.• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.• Responsible for developing technical specifications documents for business requirements.• Writing SQL queries to generate various ad-hoc reports as per client requirements Show less

Gurugram, Haryana, India

• Updating all the details related to HR system like attendance, leave, Comp Off, etc. with backend when HR is not able to update the details from GUI.• Interacted with Crew member’s for getting their flight details and sales details, which they updated in the CabTab to update the missing details in the database.• Analysts and prepare the weekly/monthly report from the database and update the details to the business.• Built complex queries using SQL to get the complete Crew and… Show more • Updating all the details related to HR system like attendance, leave, Comp Off, etc. with backend when HR is not able to update the details from GUI.• Interacted with Crew member’s for getting their flight details and sales details, which they updated in the CabTab to update the missing details in the database.• Analysts and prepare the weekly/monthly report from the database and update the details to the business.• Built complex queries using SQL to get the complete Crew and their sales details that they filled in the CabTab.• Working experience as L2 Production support in rotational shifts.• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.• Monitoring the Database performance and take necessary action to optimize the database performance.• Responsible for developing technical specifications documents for business requirements.• Writing SQL queries to generate various ad-hoc reports as per client requirements Show less

Noida Area, India

• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.• Built complex queries using SQL and wrote commands using PL/SQL.• Performing Root Cause analysis and submitted Known errors (KB Process). • Working experience as L2 Production support in rotational shifts.• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.• Monitoring the Database performance and take necessary… Show more • Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.• Built complex queries using SQL and wrote commands using PL/SQL.• Performing Root Cause analysis and submitted Known errors (KB Process). • Working experience as L2 Production support in rotational shifts.• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.• Monitoring the Database performance and take necessary action to optimize the database performance• Responsible for developing technical specifications from business requirements.• Writing SQL queries to generate various ad-hoc reports as per client requirements• Troubleshoot application issues using appropriate SQL queries and identify the problem related to the database tables.• Assist in the development of best practices and guidelines to ensure complete and accurate solutions. Show less

Gurgaon, India

• Updating all the details related to customers like voucher, store credit, registration, refund etc. with backend.• Interacted with Customer’s for having issues regarding login, registration, refund or in getting store credit and voucher.• Analyze and prepare the weekly/monthly/quarterly report related to order, payment , refund, store credit, voucher, Gross Booking, Net Booking, Product wise sale, Category wise sale from the database and update the details to the business.• Built… Show more • Updating all the details related to customers like voucher, store credit, registration, refund etc. with backend.• Interacted with Customer’s for having issues regarding login, registration, refund or in getting store credit and voucher.• Analyze and prepare the weekly/monthly/quarterly report related to order, payment , refund, store credit, voucher, Gross Booking, Net Booking, Product wise sale, Category wise sale from the database and update the details to the business.• Built complex queries using SQL to get the complete Customer and their order details that they filled information on website and purchase the product.• Working experience as L2 Production support in rotational shifts.• Monitoring the Database performance and take necessary action to optimize the database performance.• Responsible for developing technical specifications documents for business requirements.• Writing SQL queries to generate various ad-hoc reports as per client requirements Show less

Gurgaon, India

• Updating all the details related to customers like voucher, store credit, registration, refund etc. with backend.• Interacted with Customer’s for having issues regarding login, registration, refund or in getting store credit and voucher.• Analyze and prepare the weekly/monthly/quarterly report related to order, payment , refund, store credit, voucher, Gross Booking, Net Booking, Product wise sale, Category wise sale from the database and update the details to the business.• Built… Show more • Updating all the details related to customers like voucher, store credit, registration, refund etc. with backend.• Interacted with Customer’s for having issues regarding login, registration, refund or in getting store credit and voucher.• Analyze and prepare the weekly/monthly/quarterly report related to order, payment , refund, store credit, voucher, Gross Booking, Net Booking, Product wise sale, Category wise sale from the database and update the details to the business.• Built complex queries using SQL to get the complete Customer and their order details that they filled information on website and purchase the product.• Working experience as L2 Production support in rotational shifts.• Monitoring the Database performance and take necessary action to optimize the database performance.• Responsible for developing technical specifications documents for business requirements.• Writing SQL queries to generate various ad-hoc reports as per client requirements Show less