Pothuri Mani

About Pothuri Mani

Extensive experience in Tableau, PowerBI, Business Intelligence and Qlikview as a BI Consultant and Analyst within the finance, sales and marketing, healthcare, and Manufacturing industries. • Worked on different Tableau versions (Tableau 2019.1.7/2018.1.3/10.5/10.2/10.1/9.1), Tableau server, Tableau online, Tableau public and Tableau reader.• Experienced in Data Governance, Data Profiling, Analysis, Development, Design and Maintenance of Business Intelligence applications.• Expertise in conducting Workshop sessions for Power Users and Ad-hoc reporting based on their user stories• Proficient in Tableau visual analytics design and development of various dashboards, reports utilizing advanced Tableau Visualizations like Waterfall Charts, Funnel Charts, Pareto Charts, Dual Axis, Blended Axes, Scatter Plots, Box Plot, Bullet Chart, Gantt Chart, Heat Map, KPI Charts using Oracle, SQL Server, ODBC and MS Excel as Data source.• Excellent knowledge on Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report.• Provided governance and technical expertise for the use and operation of clinical dashboards. • Expertise in working with ETL Tools like Informatica and Talend.• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL(Informatica), Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.• Experience in Data Analysis, Dimensional Data Modeling, Data Extraction Transformation & Loading (ETL), Creating Meta layer, Data Mining, End User Reporting• Build from the ground up reliable Architecture setup distributed cluster environment for Tableau server versions (2019.1.7/2018.1.3/10.5/10.2/10.1/9.1) and used Tabjolt for load testing and load analysis.• Expertise in Performance tuning for the Tableau Visualizations and Tableau server for more than 500 concurrent users.• Experience in creating reports by connecting to Hive as a Backend Data base and performance tuning on Hive.• Extensive Experience in Tableau Server administration includes Automatic Backup, restore and migration.

Experience

1. Sr Data Analyst Bi Consultant

   Optum

   Mar 2018 — Present · Richmond, VA, US

   Providing technical and analytical support Ad-hoc reporting in responding to specialized report requests requiring higher-level data analysis and data management services• Design Traceability Document for Load Process and Report Requirements to Test Design • Involved in Go-Live and Operations and Maintenance Post Go-Live support for OPA• Created customized complex interactive Tableau reports like Medicare/ Medicaid Enrolment Analysis, Over Lap claim Analysis for DMAS (Virginia Department of Medical Assistance Services) in Tableau (10.5/2019.1.6) and refresh scheduling using Tableau server 2019.1.6• Created action filters,parameters advanced table calculations and sets for preparing dashboards and worksheets in Tableau using Teradata as a Data Source.• Used level of Detailed Functions, Trend Lines, Statistics and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI\'s.• Developed Tableau reports effectively used data blending and multiple data sources joins in Tableau 2019.1.6 published to Tableau server and Embedded in Liferay pages.• Understand source systems Data, Interacted with Business Analysts and Data Modelers and created ETL source to Target Mapping documents• Experienced Working on Informatica Designer, Workflow Manager and Workflow Monitor for loading BI tables.• Validation of data transformations and perform End-to-End data validation for BI layer Tables.• Developed and executed plan for data profiling, Unit Testing, Performance testing, SIT, UAT for BI Tables and Tableau OPA (Optum Performance Analytics) reports.• Gathered ETL test cases from QA team and automated in tableau• Implemented Load order, Partitioning on Tables, Unique Primary and non-unique primary indexing on Teradata Database performance tuning to meet performance SLA time for Tableau Reports• Provide on-going daily support to business users to quickly triage and resolve any issues faced once solution is in production

Education

• California State University, Fullerton

  Master of Science - MS, Computer Science

  2011