*Interacted with the existing database developers and DBA to understand the existing schema.
*Fine-tuned existing SQL Queries for maximum efficiency and performance.
*Created database objects like tables, views, procedures, triggers, and functions using T-SQL to provide
definition, structure and to maintain data efficiently.
*Worked with team of developers to design, develop, and implement a BI solution for Sales, Product and
Customer KPIs.
*Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of
analysis.
*Generated Dashboards with Quick filters, context filters, data source filters (for huge volume of data),
parameters and sets to handle views more efficiently.
*Accessed and transformed massive datasets through filtering, grouping, aggregation, and statistical calculation