Avinash Gunturu

WORK HISTORY

EDUCATION

ABOUT AVINASH GUNTURU

Sr. BI developer with Over 6 Years of IT Experience in Business Intelligence with different Applications like SSMS, SSIS, SSAS, Snowflake, Talend, Tableau & Cognos on multiple Environments. • Additionally, I have a strong background in creating various business intelligence dashboards and solutions, gathering customer requirements, performing data modeling, developing test cases, and generating analytical reports. • Outstanding SQL programming abilities and practical understanding of stored procedures, triggers, functions, and packages using SQL and PL/SQL. • I possess a deep understanding of the Entity-Relationship concept, as well as a comprehensive knowledge of facts and dimensions tables, slowly changing dimensions (SCD), and Dimensional Modeling using methodologies such as Kimball and Inmon. Moreover, I am well-versed in designing Star Schema and Snowflake Schema structures. • Worked with Tableau COE team for global level internal reports like employee management & HR Analytics. Also, Assisted in resolving pressing concerns in multiple projects brought forth by employees to Tableau\'s Center of Excellence (COE) in India. • I have actively participated in multiple proof-of-concept (POC) projects within my previous role, where I was responsible for creating new reports. During these projects, I leveraged my skills in SQL for data extraction, manipulation, and analysis. Additionally, I utilized Tableau, a powerful data visualization tool, to design and develop visually appealing and interactive reports that provided valuable insights to stakeholders. • Facilitated knowledge sharing sessions and training programs to empower employees with the necessary skills and tools to overcome challenges independently. • SQL Server, Snowflake and Oracle Database development experience using tables, triggers, views, packages and stored procedures in PL/SQL. Strong RDBMS fundamentals. • Created & formatted Crosstab, Conditional, Drill-down, Top N, Summary, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports. • Expertise in managing Tableau server as Site Admin. Performed activities like User Access Management, License Management, Extract Schedules and Dashboards Publishing. • Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports. • Creating, scheduling and monitoring ETL workflow’s using Talend and SSIS. • Experience of data ingestion from Azure BLOB to Snowflake using Procedures and Tasks. • Experience in Maintaining of Centralized logging procedures.