Power Bi Business Intelligence

NIRUPA NALABOTULA

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

Cell: +1-210-***-****

Professional Summary:

•Around 14 years of experience in Business Intelligence, Tableau, Power BI, SQL server, Data warehousing concepts, Data modeling 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.

•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.

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

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

•Experience in creating dashboards using Power BI and Qlikview with multiple datasources.

•Assist in integrating data from multiple sources into Power BI, ensuring data consistency and accuracy.

•Experience in Data cleansing using Power Query to transform data and ensure to be ready for analysis.

•Assist in creating basic reports and dashboards using Power BI Desktop. Creating simple data relationships and hierarchies.

•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, AWS ODBC connections by using specific queries to each database. Have applied table joins blending for analytics as needed.

•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.

•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), 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, Netezza, Jira, Salesforce, AWS, Domino.

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

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

Work Experience:

Tata Consultancy Services : April 2014 - Present

Client: Frost Bank, San Antonio, TX

May 2023 – Present

Business Intelligence Lead 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.

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

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

•Assist in selecting appropriate visualizations for data presentation and formatting visuals for clarity and aesthetics.

•Implement advanced features like bookmarks, drill-through actions, custom themes, and custom visuals using Power BI dashboards.

•Collaborate closely with business analysts, stakeholders, and end-users to gather requirements for Power BI reports and dashboards. Act as a bridge between technical and non-technical stakeholders.

•Optimizing the performance of Power BI reports, dashboards, and data models. Identify and address roadblocks, bottlenecks and performance issues.

•Maintain documentation for reports, data sources, and data transformation processes.

•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.

•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.

•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.

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

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

•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

Data Quality Analyst

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.

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

•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.

•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

Business Intelligence 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 Power BI Dashboard.

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

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

•Build navigation between multiple Power BI 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.

•Excellently used best practices in Power BI and 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 Tableau 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

SAP BO 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 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

SAP BO Developer

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

Key Responsibilities:

•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.

Sitacorp Pvt Ltd : Feb 2011 – Mar 2014

Client: HCL, India

Feb 2011 – Mar 2014

SAP BO Developer and Admin

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.

•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