RAVI TEJA Ganti

Data Analyst

Numbro Consulting•  June 2019 - November 2022

• Engaged in regular communication with stakeholders, business users, and other functional teams to gather, comprehend, and analyse requirements for BI and Data Engineering projects. • Developed complex SQL statements to create joins, procedures, index’s, views, and Implemented performance optimization strategies for SQL statements exhibiting extended execution times. • Designed and implemented pipelines and data flows in Azure Data factory (ADF), utilizing linked services and Datasets. Executed Extract, Transform and Load(ETL) processes seamlessly, integrating data from diverse sources such as Azure SQL, Blob storage and data warehouse. • Developed several time critical reports and visualizations in Tableau and Power BI. Created dashboards to help identify the Key Performance Indicators and outliers • Utilized Tableau to craft multiple rich dashboards, effectively conveying the business's status, strengths, weaknesses, and potential opportunities through compelling visual storytelling. • Developed Tableau data visualizations, emphasizing the silver tier plan as the preferred choice, selected by 65% of enrollees.. • Designed data models providing end to end ETL solution using Azure Data Factory to process a new project data feed and load to Azure SQL Database facts and dimension tables. • Created complex T-SQL queries, stored procedures, indexes, functions and, views to support efficient data storage and manipulation. • Produced diverse reports, including Tabular Reports, Matrix Reports, Drill-Down, Cross-Tab Reports, Ad-hoc reports, and facilitated their distribution in multiple formats. • Formulated dashboards with advanced calculations, LOD calculations, parameters, calculated fields, groups, sets, and hierarchies in Tableau. Engineered filters and parameters to optimize Tableau dashboard efficiency. • Facilitated interview sessions to identify Business rules and Requirements and then documented in a format that can be reviewed and understood by the whole team.