Gowthami Annapareddy

Business Intelligence and Data Analytics Professional having 11+ years of Team Lead / Specialist, Senior Consultant and Senior Developer experience in designing and implementing Business Intelligence & Data Warehousing Projects using Tableau, MicroStrategy, Sisense, Google Looker Studio, Power BI, SQL Server, Snowflake, PostgreSQL, MYSQL, GCP Big Query, Oracle, Talend, Informatica & IBM Watson Explorer. Designed, developed, and maintained sophisticated Business Intelligence, Reporting and Dashboard solutions for enterprise clients in Technology, Communications, Financial Services, Lifesciences & Healthcare. Worked as Data Engineering & Analytics Team lead in Business Intelligence projects of marquee clients such as Google and Salesforce. Designed & developed more than 600 Dashboards using Tableau, MicroStrategy & Looker Studio for Sales, Operations, Supply Chain, Manufacturing, Healthcare, Finance and other areas and proficient in Performance Tuning of Tableau. Transformed 50% of existing Databases and ETL processes to create the entire Back end of Tableau. Constructed system architecture in such a manner that 80% core business logic remains in the database for future portability to any other data visualization tools. Instituted a Data Strategy to ingest and transformed data to support large volume (billion rows) of data and future portability to any other data visualization tool. Rationalized BI Tools and automated dashboards for clients & saved on man hours and license costs annually. Conducted end-user trainings for faster adoption of data visualization tools in client orgs. Experience with multiple data management tools and techniques producing insights to business teams. Strong experience in data management& analysis, validation, reporting, new data delivery feeds, post-production support and communications to end users of data. Extensive experience in data analysis and profiling using complex SQL on various data source systems. Experience is data storing, cleansing, exploring, analyzing and presenting data. Experience working with various types of data connections with multiple on-prem and cloud databases. Deliver medium to large complexity dashboards either individually or as part of a project team. Planning, identifying, and designing data integration strategies and building intuitive interfaces, and visualizations (graphs, charts, heatmaps, KPI scorecards, etc.) dashboards and reports. Experience working with multiple ETL tools to automate the process of moving data from various sources, transforming it, and loading it into a destination system. Experience in creating join indexes, partitioned indexes, and adding collect statistics for query performance. Build row level security and integration for role-based security controls on dashboards & reports. Built tabular & multi-dimensional data models, facts/dimensions data sets, data aggregation & calculations on data sets to build high level views and drilldowns to lower-level data elements. Created Mobile Layouts along with Tableau Dashboards. Experience in Business Analysis, Business Requirements Gathering, Data Blending, Data Mining and Data Governance including management, analysis, validation, reporting, new data delivery feeds, post-production support, and communications to end-users of data. Performed data analysis and data profiling using complex SQL on various sources systems including Oracle, Big Query, Snowflake and MySQL. Participate in agile ceremonies like grooming, planning, standup, retrospective, demos in agile teams. Experience working on multiple projects simultaneously in Agile environment and effectively interacting with Project Managers/Scrum Masters, Business Analysts and Business Users to drive desired project outcomes. Extensively used Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) in SQL to process large data requests. Good Understanding of Entity relationship models and Proficient in creating and maintaining Metadata. Work with QA, UAT users to work on defects, data accuracy, meeting requirements and fix any issues. Partner with cross-functional leadership to define the firm's data-related requirements. Creating and managing the strategy and ensures data deliverables and processes drive business results.