Power Bi Data Analyst
Resume:
RUTUJA ANANDRAO UTTARWAR
BI Developer
**.********@*****.***
PROFESSSIONAL SUMMARY
Tableau Desktop Certified Professional and Alteryx Micro Foundation Certified Reporting Analyst with over 8 years of experience in designing and delivering interactive dashboards and data visualizations using Tableau and Power BI. Skilled in SQL and Python for advanced data manipulation, with expertise in working with data warehouses such as Snowflake for integrating, transforming, and modeling multi-source datasets to enable accurate, actionable business insights.
Designed, developed, and maintained interactive Tableau dashboards for banking, sales, marketing, finance, collections, and supply chain analytics, enabling data-driven decision-making across departments.
Skilled in using DAX for complex calculations, Power Query for data transformation, and Power BI Service for publishing and sharing reports.
Utilized Microsoft Fabric integration to unify data sources and streamline governance across Power BI reports.
Proficient in creating detailed, print-friendly reports with Power BI Paginated Reports and optimizing performance with Incremental Refresh.
Skilled in SQL Server development, including coding, stored procedures, and scheduling jobs for automated workflows.
Designed and developed SSRS reports, ensuring data accuracy and user satisfaction.
Hands-on experience with Alteryx for data preparation, cleansing, and automating workflows, enhancing efficiency and accuracy.
Proficient in Python for automating data workflows, API data extraction, and integration with BI tools for advanced analytics.
Automated ETL workflows and scheduled data refreshes integrated with Tableau Server (versions 2018 to 2023) and Tableau Cloud, ensuring seamless data availability.
Know-how in Leveraging Tableau REST API for embedding interactive dashboards into mobile applications for real-time data access.
Proficient in Tableau Pulse for setting up real-time alerts and automated monitoring, enabling proactive insight delivery and timely business decision-making.
Skilled in Tableau Prep (Flow) for data cleaning, transformation, and merging across multiple sources, ensuring reliable and streamlined data pipelines for analysis
Proficient in VBA macros for automating data manipulation tasks, improving productivity.
Specialization in Collaborating with cross-functional teams to streamline ETL processes for seamless data flow into BI tools.
Experienced in Agile and Waterfall methodologies, ensuring timely project delivery.
Demonstrated strong organizational skills and a disciplined approach to managing reporting assets and stakeholder requests, with a solid understanding of data quality, governance, and accuracy—particularly within fast-paced environments like the fintech industry.
Accomplishment in Developing a personal project using Python for predictive analysis and recommendation systems, enhancing technical skills in data analysis and machine learning.
Facilitated end-to-end coordination and lifecycle tracking of reporting assets through SDLC stages, ensuring timely updates, stakeholder communication, and seamless program integration across enterprise platforms.
Acted as a bridge between business users and development teams by gathering, analyzing, and documenting business requirements into clear FDDs and BRDs, enabling accurate and efficient solution delivery without direct coding involvement.
TECHNICAL SKILLS
ETL Tools
Alteryx, SSIS, Tableau Prep, SAS, Snowflake, Salesforce
BI Tools
Tableau Desktop, Tableau Online, tableau cloud Tableau Server, Power BI
Scripting Languages
JavScript, Groovy, Python
Operating System
Windows, UNIX, MAC
PROFESSIONAL EXPERIENCE
Client: Fsteck (Remote)- Rockefeller Capital Management sept 2023 - Present
Role: BI Developer/ Data Analyst
Led the development and implementation of a comprehensive Capital Project Governance & Tracking Platform for a leading capital management firm. The platform streamlined the monitoring and management of capital project requests, budgets, vendor relationships, and contract approvals. By leveraging Microsoft Power BI, SSRS, Alteryx, and Azure technologies, the solution automated workflows, enhanced data visibility, ensured regulatory compliance, and empowered leadership with real-time analytics for informed decision-making. The project improved operational efficiency, reduced manual effort, and strengthened governance across multiple business units.
Responsibilities:
Developed and deployed a centralized reporting solution using Power BI to monitor capital project requests, budget approvals, and vendor evaluations, enhancing governance and reducing manual tracking across departments.
Automated business workflows with Power Automate, facilitating real-time approvals, contract routing, and financial milestone tracking, leading to increased compliance and process efficiency.
Automated SSRS report subscriptions and scheduling, ensuring timely delivery of daily/weekly/quarterly performance metrics to business stakeholders via email.
Designed Power BI dashboards delivering insights on capital allocation, project burn rates, vendor performance, and financial forecasting, supporting senior leadership in strategic investment decisions.
Configured Power BI data gateways for secure, automated refreshes of on-premises and cloud data, ensuring dashboards reflect up-to-date information without manual effort.
Implemented row-level security (RLS) in Power BI reports to restrict data visibility based on user roles, safeguarding sensitive financial data and meeting compliance requirements.
Optimized Power BI data models by establishing efficient relationships and creating DAX measures and calculated columns, improving performance for large capital datasets.
Scheduled and managed incremental data refreshes in Power BI Service, significantly reducing processing times for extensive datasets.
Developed custom visuals and interactive filters in Power BI to enhance usability and enable detailed, dynamic data exploration for finance and operations teams.
Set up Power BI workspaces, user groups, and permissions to control access and promote collaboration among business users, analysts, and executives.
Integrated Power BI dashboards with Microsoft Teams and SharePoint for seamless report sharing and real-time collaboration.
Collaborated with finance, operations, and compliance teams to gather requirements, translate them into functional designs, and ensure platform alignment with capital management controls.
Supported vendor relationship and contract lifecycle management, enhancing audit readiness and financial accountability across capital projects.
Collaborated in Agile development environments to deliver BI solutions through iterative sprints, integrating dashboards and data pipelines into CI/CD workflows for efficient and reliable deployments.
Documented Power BI architecture, configuration, and maintenance processes, ensuring knowledge transfer and streamlined onboarding for new team members.
Environment: Power BI, SQl,CRM
Client: Nutanix (Bangalore, India) Oct 2021 – Jan 2023
Role: Power BI Developer/Data Analyst
Project 1:
Delivered high-impact analytics solutions across Finance and Sales by developing executive-level dashboards in Tableau and Power BI, driving strategic insights recognized by C-suite leaders. Expert in stakeholder collaboration, SQL-based data automation, and secure, performance-optimized reporting for global business needs.
Responsibilities:
Worked in cross-departmental projects, played a key role in analytics and dashboarding for Finance (FP&A) & Sales.
Acted as the SME on the Nutanix project, delivering critical financial insights and supporting decision-making for senior stakeholders and colleagues within the FP&A & Sales team.
Built powerful Tableau/Power BI dashboards telling story behind the data in an easy-to-understand format that are viewed daily by CFO. Key KPI dashboards had very high visibility and received CEO Acclaim.
Expert in generating on-demand, ad-hoc, and scheduled reports for business analysis and management decision-making using Tableau, Power BI, and Salesforce. Reports are delivered on a daily, weekly, monthly, and quarterly basis.
Sales Rep Productivity Analysis – Analyzes the distribution of rep attainment and dollar contribution cohorts to identify the factors that drive field rep productivity. Worldwide Bookings Metrics – A comprehensive report that helps executive staff track key sales KPIs. The report is fully automated and delivered as a PDF to recipients, tailored to their specific region via subscription.
Skilled in creating various chart types, blending multiple data sources, and building interactive dashboards. Proficient in implementing rowlevel security by creating user filters to ensure that data is only accessible to the appropriate teams.
Worked closely with data architects to improve data/report performance by reducing number of calculated fields. Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau desktop/server reports.
Lead the engagement with multiple stakeholders across the business to map project requirements, understand strategic initiatives and business drivers, identifying all data assets to be leveraged, key KPIs to be measured.
Strong technical proficiency writing complex SQL queries to manage, manipulate and automate complex data feeds to be leveraged for analytics based products. Manage multiple projects with high degree of accuracy and attention to detail in deadline - oriented environment.Upgrade
Environment: Tableau Desktop, Tableau Server, SQL Server,Excel, Azure, Windows.
Project 2: HR Management
Developed and maintained the Accelerator dashboard to empower HR teams with a comprehensive understanding of critical headcount metrics. Leveraged advanced data analysis and interpretation of HR datasets to generate insightful reports. Integrated Salesforce to enhance data accuracy and accessibility, providing real-time, actionable insights for strategic decision-making.
Responsibilities:
Designed and developed interactive dashboards and reports in Power BI, providing HR analytics and insights into employee performance, attrition, and departmental changes.
Utilized Power BI to create self-service BI solutions, enabling HR teams to access, analyze, and visualize data without requiring extensive technical expertise.
Connected Power BI to Snowflake for seamless data retrieval and real-time updates, enhancing the accuracy and timeliness of HR reports.
Implemented DAX (Data Analysis Expressions) in Power BI to perform advanced data calculations and create custom measures for HR reporting.
Designed Power BI reports to track employee lifecycle events, such as onboarding, promotions, and terminations, offering a comprehensive view of workforce dynamics.
Collaborated with stakeholders to gather requirements and develop Power BI dashboards that reflect key HR metrics and support data-driven decision-making.
Automated data refresh schedules in Power BI, ensuring that HR reports are always up-to-date with the latest information from Snowflake.
Create detailed technical documentation for dashboards, data models, and workflows in Tableau.
Integrated Power BI with Azure Active Directory for secure access and user management, maintaining data privacy and compliance standards.
Conducted workshops and training sessions to educate HR staff on using Power BI dashboards, empowering them to generate insights independently.
Monitored Power BI performance and usage analytics to optimize dashboard performance and user experience.
Created and delivered insightful PowerPoint presentations to effectively communicate data findings and business recommendations to stakeholders
Environment: Power BI, Snowflake, Windows,
Client: Marico (Mumbai, India) Aug 2020 – Oct 2021
Role: BI Developer
Project 1:
At Marico, a prominent food and product-based company, I worked across multiple departments to develop and deliver key reporting solutions. This included creating detailed reports for various projects and departments such as Commercial Prime, Exceptional Analysis, Net Revenue Management, Advertising, and HR. The reports provided valuable insights and contributed to informed decision-making, supporting the company's business objectives and strategic initiatives.
Responsibilities:
Worked in developing strategy and technical specifications for implementing a reporting portal/semantic layer in conjunction with the data layer, aligning with business objectives.
Acted as a change agent by transforming traditional Excel-based reporting workflows into automated, streamlined processes, significantly improving efficiency and accelerating the delivery of actionable business insights across multiple departments.
Designed and developed multiple analytical reports by blending data from various sources into a single worksheet in Tableau Desktop. Also published some external sheets on tableau server/online.
Developed interactive storytelling dashboards in Tableau Desktop and published them to Tableau Server/Tableau online, enhancing end-user experience with quick filters for on-demand insights. Demonstrated strong organizational skills and a keen appreciation for regulatory deadlines by efficiently managing multiple reporting responsibilities simultaneously, ensuring timely and accurate delivery of business-critical insights across departments.
Analysed daily trends and KPIs across various departments, focusing on traffic patterns and performance indicators. Monitored daily activities, including extract refresh, custom subscription setups, and automated email chains.
Built advanced dashboards from scratch, providing complex analytical solutions for various business needs.
Regularly updated Tableau Server and made necessary adjustments to existing dashboards to enhance performance and user experience.
Managed BI development tasks using Jira, tracking progress through sprints, user stories, and issue resolution to ensure timely delivery of reports and dashboards.
Ensured security best practices are followed in managing data access and storage on Tableau Online/Cloud.
Created custom KPIs, color palettes, and rich text formatting to improve dashboard clarity and visual appeal.
Automated manual report-building processes, reducing effort and time by 50%, improving efficiency in report generation.
Provided Tableau training to business users and new employees, enhancing their understanding of the tool and promoting self-sufficiency in data analysis.
Environment: Tableau Desktop, Tableau Server, SQL, Excel, Data Blending, Data Warehousing, Data Analysis, KPIs, Dashboards, Reporting, Automation.
Project 2:
Led an enterprise-wide reporting initiative for Marico Consumer Foods' Health, Beauty, and Wellness division, aimed at enhancing visibility into commercial operations and product performance. Implemented robust SSRS reporting solutions integrated with SSIS ETL pipelines, SQL-based data transformations, and SSAS OLAP cubes to consolidate data from multiple sources and deliver accurate, timely insights. Worked closely with stakeholders to translate complex business requirements into actionable analytics, enabling informed decision-making, improving operational efficiency, and supporting strategic growth. The initiative contributed to better resource allocation, increased process transparency, and strengthened brand performance across key markets.
Responsibilities:
Spearheaded a critical initiative to refine commercial operations, optimize product performance, and align business strategy with evolving market trends using SSRS reporting solutions.
Designed and deployed interactive and parameterized SSRS reports to provide insights into sales performance, product metrics, and customer engagement, enabling data-driven decision-making.
Integrated multiple data sources into SSRS (SQL Server, ERP, and CRM systems), ensuring accurate, consolidated reporting for cross-functional teams.
Automated report generation and distribution via subscriptions, delivering timely insights to senior management and regional teams for daily, weekly, and monthly monitoring.
Leveraged drill-down, drill-through, and matrix reports to allow detailed exploration of sales, product performance, and customer behaviour.
Collaborated with business stakeholders to define key KPIs, metrics, and reporting requirements, translating them into actionable SSRS dashboards and reports.
Achieved measurable improvements in customer satisfaction, product performance tracking, and operational efficiency, contributing to stronger brand loyalty and strategic growth
Collaborated with cross-functional teams to gather reporting requirements and deliver actionable insights.
Conducted performance tuning of reports, achieving a 30% reduction in load times.
Provided training and support to end-users on report generation and data interpretation.
Environment: Tableau Desktop, Tableau Server, SQL, Excel, Snowflake, Windows.
Client: Team Computers (Mumbai, India) Sep 2019 – Aug 2020
Role: BI Analyst
Led a team in the analytics field, gaining extensive experience in the successful implementation of Business Analytics projects. This role involved utilizing a range of Business Intelligence tools, including Tableau, Tableau Server, and Power BI, along with ETL tools like Alteryx and Python, databases, and automation solutions. I played a key role in contributing innovative methodologies and creative solutions to BI projects, database systems, and server administration, ensuring efficiency and goal-oriented outcomes. Demonstrated the ability to work both independently and collaboratively within a team, consistently meeting challenging deadlines and achieving project
Responsibilities:
Developed and communicated architectural proposals and technical solutions through customized proofs of concept(POC), effectively demonstrating how BI tools resolve complex data challenges and drive improved business outcomes.
Conducted live comparison sessions for business stakeholders, highlighting limitations of Excel (manual refresh, scalability issues, security gaps) versus advantages of Power BI and Tableau (real-time updates, row-level security, centralized governance)
Evangelized BI adoption by addressing scepticism and building trust through iterative demos, rapid prototyping, and performance benchmarks against existing Excel workflows
Automated repetitive Excel-based reporting using Python scripts, Power Query in Power BI, and Alteryx workflows—eliminating manual intervention and reducing errors
Leveraged Python to automate data reconciliation, implementing quality checks that improved data accuracy for regulatory submissions.
Deployed Power BI Gateways and configured scheduled refresh to maintain up-to-date insights without user action, boosting confidence in automated reporting systems
Transitioned legacy Excel trackers into Power BI dashboards with version control, audit logs, and user role-based access—improving transparency and reliability
Led interactive Power BI and Tableau Server training sessions for analysts, department heads, and business users, focused on building trust through hands-on learning and real-time use cases
Created user-specific training decks, sandbox datasets, and guided walkthroughs to simplify adoption across different teams and roles
Rolled out self-service BI portals with curated datasets and user-friendly reporting templates to empower non-technical users and minimize IT dependency
Established dashboard governance protocols—naming conventions, versioning guidelines, and refresh schedules—to ensure consistency and long-term usability
Collaborated with operations and finance teams to automate KPI alerts, email subscriptions, and monthly performance summaries via Power BI Service
Introduced metadata tagging and data lineage documentation in Power BI and Alteryx for improved traceability and audit readiness
Spearheaded the provision of tailored analytical solutions to clients, conceptualizing and visualizing bespoke strategies aligned with their core objectives. Demonstrated success factors using clients’ own data (Proof of Concept).
Led the application of advanced analytics to design and deliver interactive dashboards tailored to address specific use cases across diverse departments, driving business intelligence initiatives.
Created and optimized analytic views, attribute views, and calculated views, as well as materialized views, integrating multiple databases for robust reporting, ensuring superior query performance and data accuracy.
Produced comprehensive technical documentation for data models, facilitating a clear understanding of dashboard functionalities for users and ensuring proper data interpretation.
Implemented Alteryx workflows for data blending and advanced analytics, resulting in a 40% reduction in data processing time while ensuring high-quality data outputs for reporting and analysis.
Harnessed advanced analytical features in Tableau and Power BI, such as statistical functions, trend lines, and forecasting models, to develop insightful reports that support data-driven decision-making.
Collaborated closely with stakeholders, process specialists, business teams, and end users to capture and document business requirements, ensuring alignment between technical solutions and business goals.
Provided expert guidance in translating complex data concepts into actionable insights, fostering a deep.
Environment: Power BI, Tableau, Alteryx, Python, SQL, Alteryx, DAX (Power BI), Windows.
PROJECT 1: Healthcare Insight BI Project (Aditya Birla Healthcare – Mumbai,India)
Led the end-to-end development of an enterprise-grade clinical performance dashboard for GE Healthcare, enabling real-time insights into patient flow, scan utilization, and equipment efficiency across radiology, cardiology, ICU, and emergency departments. Integrated data from internal and cloud sources using Power BI, SQL Server, and GE Edison APIs, significantly improving operational efficiency, compliance readiness, and clinical decision-making across 5+ partner hospitals.
Responsibilities:
Designed and deployed an enterprise-wide clinical operations dashboard that reduced data retrieval time by 40% and improved decision-making accuracy by 15% across 5+ hospital partners.
Integrated data from GE Edison Platform APIs, SQL Server, and internal cloud data warehouses to analyze patient flow, scan throughput, and equipment utilization in real time.
Created robust DAX measures, KPIs, and calculated tables for tracking metrics like Mean Time to Repair (MTTR), Bed Occupancy Rate, and Scan Volume per Modality, improving patient throughput by 20%.
Led a team of 4 developers to build a unified data model across radiology, cardiology, ICU, and emergency departments, ensuring consistency and reducing data discrepancies by 30%.
Automated recurring reports for patient outcomes and equipment performance using SQL Server Integration Services (SSIS), saving 50+ hours/month of manual effort.
Collaborated with data scientists to incorporate predictive modeling into Power BI dashboards, successfully identifying high-risk patients, which reduced readmission rates by 12%.
Implemented row-level security (RLS) and user role permissions in Power BI Service, enabling department-specific insights while maintaining HIPAA-compliant access control.
Worked with hospital IT and GE’s cloud team to optimize data refresh processes and reduce report load times by 35%, improving user experience for clinical staff.
Developed a compliance dashboard that tracked critical service-level KPIs, regulatory benchmarks, and equipment audit readiness, decreasing regulatory audit prep time by 35%.
Conducted training workshops for 50+ clinical and operations staff on Power BI usage, resulting in a 25% reduction in ad hoc report requests and higher dashboard adoption.
Conducted in-depth analysis of complex financial data to identify trends, patterns, and anomalies, delivering actionable insights to finance, risk, and operations teams; wrote and optimized complex SQL queries, developed stored procedures, triggers, and functions in Oracle to automate data processes, and designed reporting solutions with SQL and scripting languages that enhanced data visualization accuracy and business decision-making.
Implemented data quality checks and validation logic in Power Query and SQL views, ensuring accuracy of real-time reports used by hospital executives.
Coordinated with cross-functional stakeholders (clinical leads, biomedical engineers, IT, compliance officers) to gather requirements and ensure alignment with business goals.
Environment: Power BI, GDPR, HIPAA, DAX, Power Query, Excel, Oracle, Windows.
Client: SBI Cards (TCS) Jul 2018 – Sep 2019
Role: Tableau Developer
Contributed to the development and delivery of end-to-end analytics solutions supporting marketing and collections functions at SBI Cards. Designed and implemented interactive Tableau dashboards to monitor merchant performance, customer spend behavior, discount utilization, transaction rejections, and automated collections workflows for real-time reporting to multiple collection agencies. Enabled data-driven decision-making and facilitated defaulter data transmission to RBI for credit scoring.
Responsibilities:
Led the design and execution of sophisticated sales dashboards in Tableau, enhancing data visibility and decision-making processes across the organization.
Collaborated within a team of 4 developers to gather and analyze detailed business requirements and create functional specifications.
Assisted in designing and optimizing data models in MySQL and SQL Server, incorporating complex joins, aggregations, and cleansing logic to ensure data accuracy and performance. Designed and developed interactive Tableau dashboards to visualize key financial indicators such as net interest margin, capital adequacy, liquidity ratios, and daily transaction summaries.
Automated data workflows and reporting pipelines, reducing manual effort and improving report refresh cycles using Tableau Server scheduling and SQL procedures.
Performed data validation and source-to-target mapping to ensure accuracy across various accounting systems and operational data stores.
Built parameter-driven dashboards and custom filters to support dynamic reporting for different business units, product lines, and geographies.
Implemented error handling and data validation checks within SQL queries and Tableau calculations to maintain high data integrity.
Defined functional specifications and translated business needs into technical requirements.
Reports that detect suspicious or potentially illegal activities, part of Anti-Money Laundering practices.
Built interactive Tableau dashboards to visualize key metrics like average spends, discounts, and merchant performance.Led system testing and UAT efforts, ensuring enhancements met user expectations and functional specifications.
Automated and maintained regulatory reporting (CBUAE, FATCA/CRS, AML transaction monitoring) using SQL and BI tools, ensuring compliance accuracy and reducing manual effort across audits and regulatory cycles.
Environment: Tableau Server, Tableau Desktop, SQL
EDUCATION :
Btech (2014-2018)
Shri Guru Gobind Singhji Institute of Engineering and Technology College in Nanded, India
ACHIEVEMENT
Earned SQL, python badges on Hacker rank, earned tableau badges on e- learning, won C-coding competition in college
CERTIFICATIONS
Tableau Desktop Certified, Alteryx Designer Core, Alteryx Data Preparation
Contact this candidate