Business Intelligence Power Bi

NIRUPA NALABOTULA

Lead Tableau BI Developer

Email: *******@*****.***

Contact: 210-***-****

Professional Summary:

• Around 14 years of experience in Business Intelligence, Tableau, SQL server, Data warehousing concepts, Data modelling in various industries. Maintain positive and professional attitude always in communications and working relationship.

• Experience in visualization tool like Tableau Desktop in various versions, Tableau Prep Builder and SAP Business Objects 4.0.

• Experience in UI development in Tableau.

• Installed, configured, and maintained Tableau Server across development, test, and production environments on Windows/Linux platforms.

• Excellent hands-on experience in performance tuning of Dashboards having longer rendering time.

• Have always applied Best practices in Tableau for Businesses, to enhance the performance. Like e.g. using Extracts, hiding unused fields, relevant database, parameters and sets Etc.

• Excellent understanding of Tableau architecture, design, development, function and end business user experience.

• Extracted, transformed, and loaded (ETL) data from multiple sources including SQL databases, flat files (CSV, Excel), and cloud services (Salesforce, Google Analytics) into Tableau for real-time reporting.

• Developed Qlik Sense dashboards to automate defect tracking, reducing manual effort.

• Experience in creating dashboards using Power BI, Qlik Sense and Qlikview with multiple

Datasources

• Designed and developed Power BI Paginated Reports using Report Builder for pixel-perfect, print-ready reports.

• Created Business Intelligence reports using Qlik Sense and Alteryx

• Experience in responsibility of Tableau Administration for user / group setup, permissions, security roles, managing licenses, data connections and Scheduling tasks.

• Extensively involved in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, Implementation and documentation.

• Experience in gathering user`s requirements, analyzing and designing software solution based on the requirements using Agile methodologies.

• Experience in analysis, Data modeling, design, and development of Tableau reports and dashboards for analytics and reporting applications.

• Experience in connecting and using multiple databases from multiple server such as Netezza, Salesforce, Jira, SQL database, Oracle, Snowflake by using specific queries to each database. Have applied table joins blending for analytics as needed.

• Created Business Intelligence reports using Tableau and Alteryx.

• Designed and developed ETP dashboards in Tableau, allowing stakeholders to monitor and analyze real-time data from multiple sources in a unified interface

• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

• Expertise in designing and creating various analytical reports like Performance Dashboards, Score cards and Metrics to help users to identify critical KPIs and facilitate strategic planning.

• Extensive experience in creating SAP Lumira dashboards using multiple data sets.

• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.

• Used MongoDB’s aggregation framework to process and aggregate data before importing it into Tableau for analysis.

• Experience in connecting and using multiple databases from multiple server such as Netezza, Salesforce, Jira, SQL database, Oracle, Snowflake, MongoDB, AWS ODBC connections by using specific queries to each database. Have applied table joins blending for analytics as needed.

• Excellent Knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.

• Experienced in developing rich Interactive reports and complex dashboards integrating various reporting components from multiple sources.

• Developed dashboards to provide leadership with real-time insights into sales and portfolio management.

• Created automated QA dashboards for top-level management, reducing manual report generation time.

• Involved in Trouble Shooting, Performance tuning of reports and resolving issues in Tableau desktop report.

• Served as SME point of contact for Tableau and delivery of solutions adhering to BI.

• Improved Data Governance by implementing Metadata Tagging, Rulesets, and Lineage updates in IA/IGC.

• Team player and quick learner with good communication skills and ability to work independently and as a part of the team.

• Has always fulfilled the commitment made in Agile board.

• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management.

• Proven track record of delivering data-driven insights for major clients, including USAA, Frost Bank, and HCL.

Technical Expertise:

Reporting Tools: Tableau (Desktop, Prep Builder, Server), Power BI, Qlik Sense, Qlik View, SAP Business Objects (Webi, Crystal Reports, Xcelsius Dashboards, Live Office, QaaWS), SAP HANA, SAP BOBJ XI, SAP Lumira, BI Widgets.

Data Governance Tools: Information Analyser (IA) and Information Governance Catalog (IGC).

Databases/Environment: SQL Server, IBM DB2, Cognos, Netezza, Jira, MongoDB, Salesforce, Domino.

ETL Tools: Tableau Prep Builder, Information Design Tool, Alteryx, Data Services.

Programming Languages: JavaScript, HTML5, CSS, SAS, Python.

Work Experience:

Client: Frost Bank, San Antonio, TX

May 2023 – Present

Lead Tableau BI Developer

The overall objective of this project is to convert all the existing monthly/weekly defect reports from manual excel reports to automated dashboards. Creating the existing reports as Tableau dashboards which can be viewed by higher management for easy decision making and periodic scheduling according to the project requirement.

Key Responsibilities:

•Work closely with clients and internal stakeholders to gather requirements and plan milestones in the research, development and implementation phases of the project lifecycle.

•Distribute the work among team members and collect daily updates, discussing the challenges during daily standup meetings and resolving them.

•Diagnosed and resolved Tableau dashboard performance issues by optimizing data extracts, filters, and complex calculations.

•Troubleshot access and permission issues on Tableau Server/Cloud, ensuring correct user roles and group memberships were in place.

•Experience in gathering requirement definitions, drafting validation plans, test plans, test scripts, and test summary reports.

•Managed multiple Tableau Server sites, including user provisioning, role assignments, and project folder structure setup.

•Good experience in using new built-in features in Tableau such as Buttons, adding images, etc. to the reports making them dynamic and more interactive.

•Built end-to-end dashboards using Tableau and Power BI to support executive decision-making across sales and operations.

•Designed and deployed Power BI dashboards connected to Microsoft Fabric Lakehouse, enabling near real-time insights from large-scale data.

•Designed and developed Power BI Paginated Reports using Report Builder for pixel-perfect, print-ready reports.

•Created parameterized paginated reports for dynamic filtering and user-customized data views.

•Experience in creating dashboards using Power BI, Qlik Sense and Qlikview with multiple Datasources.

•Expertise in building interactive and dynamic reports with Actionable filters,

•Parameters, Calculations, Sets, Bins, and Navigation links to meet deliverable specifications.

•Very well versed in creating dashboards showing Trend lines, Reference lines, and with different kinds of filters – Context filters, traditional filters.

•Expertise in using Level of Detail (LOD) calculations in dashboards to display data in different levels of granularity.

•Designed and deployed Qlik Sense dashboards integrated with AWS data sources.

•Proficient in data quality analysis of Qlik Sense dashboards. Expertise includes all levels of Quality Assurance, Testing from the development stage, software requirements and documentation to UAT.

•Extensively worked on creating visualizations by setting up custom hierarchies, and custom grouping.

•Proficient in data quality analysis of Tableau dashboards. Expertise includes all levels of Quality Assurance, Testing from the development stage, software requirements and documentation to UAT.

•Developed complex custom SQL queries to bring data to Tableau and published it in the Tableau Server as a Tableau data source.

•Created centralized data models in Power BI and exposed them to Tableau via live connections to SSAS/Power BI datasets.

•Manage Data Migration and data Modeling using Alteryx and create data visualizations using Tableau to create high quality dashboards.

•Convert complex data from multiple sources into meaningful and easy datasets using Alteryx and create dashboards as per the project requirement.

•Identified and resolved data inconsistencies and errors during the ETL process, ensuring high-quality data was used for reporting.

•Implement ETL process in Alteryx to extract data from SQL and few static Excel/CSV reports and schedule workflows.

•Designed and developed interactive dashboards in IBM Cognos Analytics to support business reporting needs.

•Developed and optimized dashboards connected to relational databases via Cognos Data Modules and Framework Manager.

•Set up and maintained automated data refresh schedules in Tableau Server to ensure consistent and timely updates to ETP dashboards.

•Built interactive dashboards using Tableau, integrating data from diverse sources, including SQL databases, Excel, and cloud data platforms, to visualize key business metrics and KPIs.

•Developed comprehensive ETP dashboards that track and monitor data pipeline performance, data quality, and extraction statuses, ensuring optimal data flow from source to Tableau

•My responsibilities also include monitoring extract refresh loads on a regular basis to ensure the availability of the updated data in the reports.

•Developed interactive Tableau dashboards for defect metrics, data masking, and executive testing summaries, automating manual reporting processes and improving efficiency.

•Successfully integrated MongoDB with Tableau to extract and visualize large datasets.

•Used MongoDB’s native connector or intermediate tools like ODBC drivers to connect MongoDB with Tableau.

•Created and published data sources using Tableau Prep Builder, integrated Jira and Salesforce data sets.

•Delivered actionable insights from consolidated reports, reducing manual effort and enhancing decision-making for business stakeholders.

•Developed interactive and visually compelling dashboards in Tableau using data sourced from MongoDB.

•Creating reports and dashboards in Tableau for cross-functional teams using MongoDB as a data source, enabling better decision-making across business units.

•Meet with Business daily and gather the day-to-day feedback and share it to required teams for updates.

•Gather the business requirement from the business team for Tableau and develop Tableau Dashboards using Jira, Salesforce datasets.

Client: USAA, TX

Apr 2022 – Apr 2023

Sr. Tableau Developer

The main goal of this project is to improve data quality and simplify data management. To provide Data Governance for managing and securing Enterprise Data. Also creating certain rulesets for organizing the data, maitaining the consistency and control the data access.

Key Responsibilities:

•Worked on data governance and data quality management by creating rulesets and tagging metadata terms using IA and IGC.

•Managing the quality of data by creating, implementing, and managing data quality rules and standards.

•Developed Python scripts to automate data cleaning, transformation, and analysis, significantly reducing manual intervention

•Performed data profiling using Python scripts in the Domino environment to ensure data accuracy and consistency.

•Expert in writing DAX formulas for calculated columns, measures, and custom KPIs in Power BI.

•Created Python-based scripts to automate data pipelines for seamless integration into Tableau, enhancing the efficiency of dashboard updates and data refresh cycles

•Updated lineage documentation in IGC and managed critical data elements (CDEs) for improved governance.

•Performing data cleaning, data profiling, and data analysis to ensure data consistency and accuracy.

•Continuous evaluation and monitoring of data quality metrics to ensure ongoing improvement.

•Performed data cleaning technique to identify and correct errors and inconsistencies in datasets, removed duplicates or inaccurate records.

•Developed interactive and visually compelling dashboards in Tableau using data sourced from MongoDB.

•Creating reports and dashboards in Tableau for cross-functional teams using MongoDB as a data source, enabling better decision-making across business units.

•Ensuring the accuracy, completeness, and consistency of data across teams.

•Work closely with different departments to ensure that data is clean, organized, and reliable so that it can be used for strategic decision-making purposes.

•Conducting data quality checks and ensuring that data conforms to predefined data standards.

•Reviewing data accuracy, completeness, consistency, and ensuring that data is compliant with regulations.

Client: USAA, TX

Apr 2018 – Mar 2022

Sr. Tableau Developer

The whole idea of starting this project is to migrate the BO Xcelsuis dashbards to Tableau dashboards. Collecting the data sources information from the BO dashboards, reports and established those data cource connections in Tableau and stating building dashboards using the data. Reviewd them with the teams to confirm on matching the data with previous dashboards.

Key Responsibilities:

•Created Tableau workflow process design, build it and set it up, for smooth development and release in Dev and UAT environments for efficient handling of day-to-day Tableau request.

•Follow the business requirement and develop or update the Tableau Dashboard.

•Interacted with Users, Stakeholder from multiple Business Unit in gathering or clarifying the requirements.

•Expert in writing DAX formulas for calculated columns, measures, and custom KPIs in Power BI.

•Follow the business requirement and develop or update the Power BI Dashboard.

•Analyze the requirement and create a Proof of Concepts with available data and get feedback.

•Build navigation between multiple Qlik Sense dashboards as required.

•Build Tableau calculation, logic, parameters, data prep, data blending, joins required from multiple data sources for Dashboard development. Setup secured access and trigger action functionality.

•Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

•Monitored Tableau Server performance using Admin Views, Tabadmin, and Tableau Services Manager (TSM); identified and resolved system bottlenecks.

•Provided onboarding and support to new users, resolving access issues and educating users on Tableau Server best practices.

•Automated routine admin tasks using Tableau Server REST API and Python scripts for user management, content migration, and extract refresh monitoring.

•Created custom admin dashboards for usage tracking, license consumption, and server health reporting.

•Excellently used best practices in Tableau for Businesses, to enhance the performance. Like e.g. using Extracts, logic, calculation, hiding unused fields, relevant database, parameters and sets etc.

•Expertly used all the functionality of Tableau. E.g. Data connection, logic calculation, blend, join, filter, parameters, UI etc. during development.

•Translate the finalized POC into Tableau Solution for production deployment after validation. Deploy to Tableau Production server.

•Train and support Users in Qlik Sense related issues.

•Involve in multiple Tableau versions migration.

•Designed and developed the ESG-IT Dashboard using Netezza and Excel as datasources incorporating advanced Tableau features such as custom SQL queries, parameters, and dual-axis mixed charts.

•Improved dashboard performance by re-engineering legacy Business Objects (BO) reports and enhancing visualization.

•Was positive and team player all times.

Client: USAA, TX

Jul 2014 – Mar 2018

Tableau / Reports Developer

This project involved dashboards development and support using various data sources and some reports also. Created Monthly and weekly reports using Web Intelligence tool and scheduled them as per the project requirement.

Key Responsibilities:

•Developed Tableau dashboards for PXMS and TPM applications, providing business stakeholders with real-time data for sales and portfolio management.

•Utilized Salesforce data as a source for creating actionable insights.

•Designed QA dashboards to display key performance metrics, automating data reporting for top-level management and saving significant manual effort.

•Worked on O&M dashboards and reports for client-specific changes.

•Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

•Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

•Scheduled extract refresh for weekly and monthly reports and worked on workbook Permissions, Ownerships and User filters and provided production support as per business requirements.

•Involved in sprint planning sessions and sizing the user stories in AGILE environment.

Client: Bank of America, India

Apr 2014 – Jun 2014

Tableau / Dashboard Developer

This project needs performance tuning of the existing Data models and dashboards to reduce the run time.

Key Responsibilities:

•Create and maintain Tableau workbooks and extracts.

•Data Analysis and Interpretation:

•Conduct data analysis using Tableau to identify trends, patterns, and insights.

•Interpret data findings and communicate them effectively to stakeholders.

•Technical Skills and Knowledge:

•Proficiency in SQL and MDX queries for data manipulation.

•Knowledge of data modeling techniques.

•Understanding Tableau platform architecture and best practices.

•Redesigned the data model using Universe Design Tool which acts as data source for the Xcelsuis dashboard.

•Scheduling meeting with the stakeholders for gathering project requirements.

•Focusing on performance tuning of existing dashboards and dynamic functionality for the client demo.

•Replaced the GDCE dashboard datasource for performance check and data validation.

Client: HCL, India

Feb 2011 – Mar 2014

Tableau Developer

Initially started this project to provide demo dashboards to the client and once after demo versions got approved, started developing the dashboards, reports using live data and scheduled, published the files to DEV, UAT and PROD environments.

Key Responsibilities:

•Involved in planning sessions with VP and Managers to analyze requirements and outline the functional reporting solution.

•Performed BO upgrades/migrations and BEX Reports to WebI.

•Performed extensively Unit Tests, System and Integration, UAT, Performance and Regression Testing.

•Developed Reports using WEBI, SAP Universe & OLAP connection and non-SAP data sources.

•Developed and maintained dashboards for HCL, HCPL, NEO using SAP BW, ECC, and Bex queries.

•Created Widgets for HCL, NEO using Map component and tickers that scroll according to the timer in the header/footer section.

•Dashboard and Report Development: Design and build interactive Tableau dashboards and reports that meet business requirements.

•Develop visualizations, including charts, graphs, and maps, to effectively communicate data insights.

•Create and maintain Tableau workbooks and extracts.

•Data Analysis and Interpretation:

•Conduct data analysis using Tableau to identify trends, patterns, and insights.

•Interpret data findings and communicate them effectively to stakeholders.

•Technical Skills and Knowledge:

•Proficiency in SQL and MDX queries for data manipulation.

•Knowledge of data modeling techniques.

•Understanding Tableau platform architecture and best practices.

•Created detailed reports and dashboards to facilitate real-time business decisions, including cumulative, monthly, and daily reports.

•Scheduled Publications and Reports for Daily, Weekly, Hourly, Bi-Monthly and Custom Calendars.

•Created Events, Folders, Connections, Custom Calendars, Users and Groups in CMC.

•Performing troubleshooting and issue resolution and assisting other developers and Business Users.

•Live and Support for handling Incidents, Access requests, Maintenance & Enhancement Tickets.

•Designed the Universe using Business Objects Designer. Defined Classes and Objects appropriately in the Universe.

•Created Joins, Aliases and Contexts for solving the chasm traps and fan trap problems in the universe.

•Created Hierarchies, predefined filter conditions and prompts in the universe.

•Organized data in the reports by using Variables, Filters, Sorting, and Ranking in the canned reports.

•Written documentation to describe program development, logic, coding, testing, changes and corrections.

•Created Test cases for the mappings developed and then created integration Testing Document.

Education:

•Bachelor of Technology (B.Tech) in Electronics & Communication Telangana, India,2008

Contact this candidate