Mahindra Reddy M
BI Developer & Tableau Administrator
Mobile +1-508-***-**** ad0lnf@r.postjobfree.com
Professional Summary
I have 10+ years of IT experience in all phases of Analysis, Design, Development, Implementation and support of Business Intelligence applications.
Excellent data-analysis skills and ability to translate specifications into an interactive Dashboard/Reports using Tableau Desktop tool, Tableau Prep tool & Power BI.
Using Tableau and Power BI, I support production project involving Reporting and Dashboard Solutions Development, Data Extraction & Performance Tuning.
Extensive Experience in Enterprise Environment as Tableau, Power BI Report Developer & Server administration.
Experience with complex or large-scale installations and architecture, automation and working with functional teams.
Proficient in Installing, Configuring and Administration of Tableau & Power BI server performance tuning for optimization.
Experience including technical support, troubleshooting, report design and monitoring of system and application usage.
Experience in automating the Server maintenance,Daily & Weekly activities.
Good experience in QA, UAT, of Dashboard visualization, Data quality prepare documentation, writing test case scenarios and executing test cases in HAP ALM & Jira.
Experience in migrating content from Tableau Server On premise to Tableau Online (Cloud) and to Power BI.
Experience in providing production support of reports for any access issues, data issues, connectivity issues, and performance issues from users through ticketing system.
Skills
BI/Reporting Tools: Tableau Server, Tableau Desktop, Power BI Desktop, Power BI Report Server
ETL Tools: Tableau Prep,Altryx
Database Tools: SQL, Postgres,Amazon Athena,Redshift, IBM DB2 etc.,
Defect Management Tools: JIRA, HP ALM Quality Center (QC), Service Now.
Methodologies: Agile
Operating Systems/Environments: Windows Server, AWS Cloud.
Tableau Admin tools: Tab jolt, Logs hark, Data Dog
Upgrades, Disaster Recovery
Access Management
Content management
Work Experience
Accenture Solutions Pvt Ltd – Client:BMW Apr 2021 – Sept 2023
BI Developer & Tableau Adminstrator
Environment: Tableau Desktop, Tableau Server, Tableau Prep,Altryx, Microsoft SQL Server, PostgreSQL,Redshift,Athena
Responsibilities:
Designed, developed and tested various Tableau visualizations for the dashboard and ad-hoc reporting solutions.
Conducted meetings with business stakeholders, clients and director-level members for requirement gatherings and presented various solutions using best practices.
Participate in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
Fetched the data from different sources like SharePoint. Able to load data from flat files and various other databases.
Implemented data blending to blend related data from different data sources.
Generated context filters and data source filters while handling huge volumes of data.
Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI’s.
Used LOD’s(Level Of Detail Expressions) for the creation of calculation fileds.
Extensively used Ask Data lense on Tableau Server
Extensively used Date functions to create year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
Restricted data for users using Row level security and User filters.
Experience applying statistical analyses and modeling to business problems.
Used applied actions (filter, highlight and URL) in creating Interactive dashboards.
Used Actions extensively to link and filter sheets for easier navigation in Dashboards.
UsedTableau server to publish and share the reports with business users.
Implemented Tableau mobile dashboards via Tableau mobile application.
Expertize in administration tasks such as setting permissions, managing ownerships and providing access to users and adding them to specific group.
Experience in performance tuning and troubleshooting.
Tata Consultancy Services - Client:Public Service Enterprise Group Mar 2017 – Apr 2021
Tableau Developer & Tableau Administrator
Environment: Tableau Desktop,Tableau Prep, Tableau Server, Amazon Athena, Amazon Redshit, PostgreSQL
Responsibilities:
Analyze the Hardware configuration required for the instances running Tableau Server and resources required for services.
Prepare the cluster environment for ready to install Tableau Server on instances by enabling all the required ports, Hardware configuration etc
Responsible for Installing & Configuring Tableau server in Development, QA & Production environments in single & multi node server architecture deployments.
Configured Tableau server installation for High Availability which maximizes the availability of tableau server and can be able to achieve failover in a multi node architecture environment.
Created and configured SSL certificate for enabling the encrypted communications on all external HTTP traffic & Configured Tableau Server to use SAML for user authentication.
Defined security architecture for user authentication at levels License type & content permissions.
Perform daily and weekly automatic script running for taking the backup of Server data and server configuration.
Provide governance and enforce best practices by monitoring the tableau server usage dashboard and user permissions.
Perform trouble shooting on Tableau Server/Dashboard performance issues using Platform admin dashboards, TSM commands, logs, Datadog, log shark etc.,
Perform Software upgrades, driver upgrades, Windows server patches.
24/7 Tableau Server Monitoring, Maintenance and Upgrades
Managed the application’s users & groups, integration with identity providers enabling SSL and
automating tableau server usage monitoring & server job processes like data extracts & backups.
Applying security/permissions, workbook refreshes User management.
Created customized dashboards for application users like Application content Analysis Dashboard, Dashboard for running extract refresh schedules, Dashboard for User details & Permissions.
Checking the status of server application process using various TSM commands and troubleshooting and fixing the issue if any application process is down/not running.
Develop rich interactive Tableau data visualizations in using features such as data blending, extracts, LOD calculations, filters, actions, parameters, context filters, sets, groups and aggregate measures.
Designed tableau dashboards with features like dynamic column display, hiding worksheets based on actions and parameters.
Accenture Solutions Pvt Ltd - Client: British Petrolium Nov 2014 – Feb 2017
Power BI Report Developer
Environment: Power BI Desktop, Power BI Report Server, Amazon Athena, Microsoft SQL, PostgreSQL
Responsibilities:
Designed Power BI dashboards with features like dynamic column display, hiding worksheets based on actions and parameter values.
Develop rich interactive Power BI data visualizations in using features such as data blending, schedules,
DAX calculations, filters, actions, parameters, context filters, sets, groups and aggregate measures.
Display reference lines and trend models, showing forecast results, building dashboards and stories involving actions.
Implemented row level security at Dashboard level in multiple projects.
Publishing workbooks and Data Sources to the Tableau Server.
Scheduling Data Source extracts for the workbooks using Extract DB connections.
Performed report validation by backtracking to the backend database and format the data if required.
Unit Testing of the reports and fixing them in case of any issues
Champs Tech Solutions – Cient:Pratt & Whitney July 2012 – Oct 2014
Tableau Report Developer
Environment: Tableau Desktop, Tableau Server, Amazon Athena, Microsoft SQL, PostgreSQL
Responsibilities:
Develop rich interactive Tableau data visualizations in using features such as data blending, extracts, LOD calculations, filters, actions, parameters, context filters, sets, groups and aggregate measures.
Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
Integrated custom visuals based on business requirements using Tableau desktop for better clarity of information.
Created Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality.
Created interactive data visualizations in Tableau, using relational and aggregate data sources.
Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.
Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
Analytic support for the company’s marketing campaigns; by predicting areas of promotion.
Developed interactive views with action/highlight filters to track-manage-correct system entry errors which provided strategic insights to Finance leaders, that helped decrease the faulty inputs into their projects software.
Implement complex formulas, calculations & Level of detail (LOD) within Tableau to meet the needs of complex business logic.
Created advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
Connected Tableau to various databases and performed live data connections, query auto updates on data refresh.
Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
Education
Bachelor Of Technology - 2012
Jawaharlal Nehru Technological University, Anantapur, India