Sarabjot singh

Analyst

eClerx•  February 2023 - August 2023•  Chandigarh

• Extracted and transformed raw data from client's portal and databases executing complex SQL queries, resulting in a 40% reduction in data processing time and providing accurate insights for strategic decision-making. • Developed dynamic excel charts, graphs, and dashboards through various excel formulas, pivot tables, switch control components, PowerBI/Tableau increasing data-driven decision making and improved overall data comprehension. • Automated projects by applying Excel Macros using VBA programming` and SQL trigger functions and saved the employees time on the project by 30%.