Shadab Nawab

C

Chase corporation

Jun 2024 - Sep 2024 (4 months)

• Used Hubspot Ticketing tool. • Handled team of 7 employees. • Take Daily standup for team meeting to get updates on salesforce tickets • Prepare a knowledge article on Notion to help the team to resolve the issues that are new. • Create standard operating procedures to handle tickets and troubleshooting steps. • Fetch excel report for status of tickets In progress, Hold, Resolved and Closed. • Provide excel report about status of tickets and team performance to senior manager

H

Hydra Facial (ERP:Netsuite2)

• Write a process support document. • Used salesforce ticketing tool to work on application issues. • Perform replication of data from client Netsuite ERP to organization aws database. Replication takes around 1 day to complete • Install spreadsheet server as ribbon on excel for client machine. • Troubleshoot application issues by using application and configuration logs, Unix commands, Kibana and SQL server management studio to optimize SQL queries. • Create a custom profile that has sql queries to fetch account balance month and year wise. • Check account balance as per Month, Life to date, Year to Date.

O

Oracle Cloud

• Add public key from Oracle cloud into AWS environment • Start replication that transfers Client ERP database into organization AWS environment, Once replication is complete create a custom profile with segment account number, department, location. Update drilldown and transaction query. • Validate data to fetch account balance month and year wise. • Trouble application using sql queries, kibana and unix commands. • Use joins, triggers, stored procedure, index, common table expressions to generate financial reports. • Used Hubspot ticketing tool to work on issues. Work on issues as per the priority and severity.

D

Database Admin (SQL)

E

Events moderator (Java)

• Monitor application executing queries using sql server management studio sql profiler • Write and optimize queries using triggers, stored procedure, index, joins and functions • Check estimated and actual execution time of queries, if required optimize the queries for actual execution time. • Use stored procedures to load table data. • Use functions such as aggregate, scalar, conversion, ranking and general functions to optimize sql queries. • Use SQL server agent to schedule the jobs. • Used SQL Server integration Services to create control flow and Flow. • Check SQL logs using management tab of SQL Server management studio • Make the database highly available and take backup and restore of the database regularly.

P

PropCrowd (Python)

• Load table data using stored procedure. • Use SQL Profiler to check application executing queries and optimize queries to improve execution time by updating clauses such as were, having and group by . • Create replication of the primary database into a secondary database. • Use joins, triggers, stored procedure, index, functions and common table expressions to write and optimize SQL queries and reduce actual query execution time. • To integrate file data into database use sequence container, data flow task, for each loop, execute SQL task, flat file source, flat file destination and ADO.Net connection of SQL Server Integration Services. • Take backup of database regularly and make database highly available

About

Detail

Timeline

Résumé