Power Bi Data Analyst
Resume:
RUTUJA U
BI DEVELOPER
*.*********@*****.***
PROFESSSIONAL SUMMARY
Over 5 years of experience in creating interactive dashboards and data visualizations with Power BI and Tableau.
Skilled in using DAX for complex calculations, Power Query for data transformation, and Power BI Service for publishing and sharing reports.
Expert in building interactive dashboards with drill-through functionality, dynamic filters, and custom visuals in Power BI and Tableau.
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.
Experienced in relational and dimensional data modelling, ensuring optimal data structure for reporting and analysis.
Skilled in integrating data from various sources like APIs, Salesforce, SAP, ensuring data accuracy and consistency.
Expert in Implementing end-to-end automation in Tableau Server, Online, Cloud and Power BI, improving operational efficiency and workflow optimization.
Experience in Leding the development of project plans, functional specifications, and data mapping documents, aligning with business and technical requirements.
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.
Mastery in Utilizing advanced geographic mapping and spatial visualizations in Tableau, including custom images and geocoding.
Know-how in Leveraging Tableau REST API for embedding interactive dashboards into mobile applications for real-time data access.
Experienced in Agile and Waterfall methodologies, ensuring timely project delivery.
Proficient in creating detailed, print-friendly reports with Power BI Paginated Reports and optimizing performance with Incremental Refresh.
Exposure to Automated data preparation with Tableau Prep CLI, reducing manual effort and enhancing efficiency.
Competence in Appling advanced analytics techniques like regression analysis, clustering, and forecasting using Alteryx to drive insights and optimize operations.
Accomplishment in Developing a personal project using Python for predictive analysis and recommendation systems, enhancing technical skills in data analysis and machine learning.
Experience in Applying Alteryx’s advanced analytics tools, including regression analysis, clustering, and time series forecasting, to extract insights and enhance business operations. Cleaning and transforming data from Excel, XML, and JSON files to create reliable datasets for analysis, optimizing workflow efficiency.
Proficient in Utilizing K-Means Clustering to segment customers based on order behavior, enabling personalized marketing strategies. Developing Tableau dashboards and reports to visualize order trends and customer insights, facilitating improved decision-making and streamlined processes.
Dedicated to excellence, self-motivated, quick learner, and collaborative team player. Possesses strong diplomatic skills in dealing with people, along with exceptional problem-solving and communication abilities.
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
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: Nutanix Oct 2021 – Jan 2023
Role: BI Developer
Project 1:
Contributed to a finance pipeline project aimed at optimizing sales processes and increasing revenue generation by designing and implementing business intelligence solutions. Played a key role in data modeling, analysis, and visualization while collaborating with cross-functional teams to deliver actionable insights and achieve project objectives.
Responsibilities:
Designed simple yet effective Tableau reports for weekly, monthly, and quarterly analysis, focusing on clarity and usability for business users.
Managed and configured user permissions and roles in Tableau Online and Tableau Cloud to ensure secure access control.
Integrated Tableau online dashboards seamlessly into Salesforce to provide embedded analytics, enabling sales and marketing teams to access insights directly within their workflow.
Set up subscription-based reporting in Tableau, automating the delivery of periodic reports to stakeholders based on their preferences.
Coordinate project timelines, deliverables, and updates with clients to ensure satisfaction and project success.
Implemented custom filters and dynamic notifications within Tableau to ensure users received relevant updates tailored to their roles and responsibilities.
Collaborated with cross-functional teams to streamline reporting processes and ensure alignment with business objectives.
Designed Tableau Server reports to track diverse KPIs such as sales growth, customer acquisition cost, churn rate, and revenue by segment, addressing the complexity of combining data from multiple sources and ensuring accurate calculations, dynamic filtering, and real-time updates for actionable insights.
Upgrade tableau server and managed tableau admin role.
Implemented advanced analytical modelling and algorithmic forecasting within the finance sales pipeline using Tableau and SQL.
Applied cohort analysis to track customer behaviour over time, visualized average conversion rates by cohort, and utilized waterfall charts to assess the impact of various factors on sales performance, enabling data-driven decisions to optimize sales strategies and improve financial outcomes.
Employed algorithms like ARIMA for time-series forecasting and Linear Regression to analyse and predict sales trends, helping to refine financial strategies and enhance forecasting accuracy.
Developed data pipelines and transformations using Snowflake, ensuring efficient data warehousing and real-time data availability for reporting and analytics.
Utilized Tableau Prep to streamline data preparation tasks, including data cleaning, transformation, and blending from multiple sources.
Utilized Azure Data Factory to automate ETL processes, integrating data from various sources into Snowflake for consolidated reporting.
Optimized Snowflake queries to improve performance and reduce data retrieval times, enhancing the overall user experience of Tableau dashboards.
Collaborated with Azure DevOps teams to manage deployments and monitor the health of BI solutions, ensuring high availability and minimal downtime.
Created interactive dashboards with Tableau and Snowflake to provide deeper insights into Nutanix's operational and financial data, leveraging Azure cloud resources for scalability and performance.
Oversee the deployment of Tableau dashboards and updates in production environments, ensuring smooth transitions.
Environment: Tableau, Tableau Server, SQL Server, Snowflake, Excel, Windows.
Project 2:
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.
Managed Tableau Online/Cloud instances, including user access, data connections, and server performance monitoring.
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.
Environment: Power BI, Snowflake, Azure, Windows,
Client: Marico, 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.
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. Sent weekly and quarterly reports to the CEO, providing critical business updates.
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:
I spearheaded a pivotal initiative within Marico Consumer Foods' Health, Beauty, and Wellness division, dedicated to refining commercial operations, optimizing product performance, and ensuring strategic alignment with the ever-evolving market landscape. This endeavor harnessed advanced analytics, seamless data integration, and innovative methodologies to elevate business performance, enhance customer engagement, and foster sustainable growth. The outcome was a marked improvement in overall customer satisfaction and a strengthened sense of brand loyalty, contributing to the continued success of the organization.
Responsibilities:
Utilized Snowflake's capabilities to manage and analyse health-related data, integrating dietary and nutritional information from diverse sources. This initiative provided actionable insights into consumer behaviour and health outcomes, thereby contributing to strategic decision-making for product development.
Leveraged the integration of tableau and Snowflake to perform detailed market segmentation analysis, identifying consumer segments with unique preferences and needs. The insights derived from this analysis guided product development and marketing strategies, resulting in a 15% increase in targeted sales. Additionally, customized Power BI visuals were utilized to enhance data interpretation and decision-making.
Utilized advanced forecasting models within tableau to predict quarterly sales targets and demand trends. This empowered the marketing and sales teams to set data-driven goals, while also advising the expenditure team on optimal budget allocation. Further, provided strategic guidance to the supply chain team to ensure timely product availability and mitigate the risk of stockouts.
Designed and implemented an automated inventory management system by integrating Power BI with Snowflake. This system optimized stock levels and effectively minimized excess inventory costs, contributing to overall operational efficiency.
Conducted in-depth cost analysis on production, distribution, and marketing expenses using Power BI and Snowflake, identifying key areas for cost reduction and process optimization.
Worked closely with cross-functional teams, including marketing, sales, and production, to ensure the successful deployment of data-driven strategies utilizing Power BI and Snowflake. This collaboration facilitated the seamless execution of initiatives and the achievement of business objectives.
Environment: Tableau Desktop, Tableau Server, SQL, Excel, Snowflake, Windows.
Client: Team Computers, India Sep 2019 – Aug 2020
Role: BI Developer
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:
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.
Expertly designed, developed, validated, and troubleshooted ETL workflows in Alteryx, ensuring the seamless extraction, transformation, and loading of data for analysis and reporting purposes, optimizing data processing efficiency.
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 deeper understanding among non-technical stakeholders and ensuring project success.
Continuously monitored and improved BI solutions, ensuring high standards in data governance, security, and compliance with business requirements.
Created reusable data preparation workflows to streamline data pipeline processes for Tableau visualizations.
Drove automation initiatives, implementing tools to streamline data workflows and reduce manual intervention, contributing to improved operational efficiency and reduced turnaround times.
Environment: Power BI, Tableau, Alteryx, Python, SQL, Alteryx, DAX (Power BI), Windows.
PROJECT 1:
As part of this project, we were responsible for developing Power BI reports and dashboards using healthcare data to provide in-depth insights, enabling the client to make informed and confidential decisions.
Responsibilities:
Conducted comprehensive requirements analysis and meticulously created technical design documents, ensuring alignment with business objectives and technical specifications.
Integrated and consumed data from the Power Platform (Data verse), ensuring seamless data flow for reporting and analytics.
Executed data preparation and data cleansing processes using Power Query and M Language, transforming raw data into valuable, actionable insights.
Developed dynamic, interactive dashboards and reports based on client requirements, incorporating advanced features such as Drill-Through and Sync Slicers to enhance user experience and data exploration.
Leveraged DAX functions to create complex calculated columns and measures, providing customized calculations and metrics tailored to client needs.
Published Power BI reports on the Power BI Service, ensuring accessibility and collaboration across stakeholders while maintaining data security and governance.
Ensured the availability of Power BI dashboards for clients, enabling real-time access to critical business insights and empowering confident decision-making.
Collaborated with cross-functional teams to iterate on and refine reports, addressing client feedback and optimizing dashboard performance for enhanced usability and data accuracy.
Maintained an unwavering focus on data integrity, governance, and visualization best practices, ensuring the delivery of high-quality BI solutions.
Environment: Power BI, DAX, Power Query, Excel, Oracle, Windows.
Client: TCS, India Jul 2018 – Sep 2019
Role: System Engineer
Collaborated closely with the sales team to design and develop dynamic dashboards using an earlier version of Tableau. Focused on transforming raw sales data through SQL and integrating with ServiceNow to create customized visualizations for monitoring key performance metrics. Engaged in requirement gathering, data modelling, and the development of interactive features such as data blending, parameters, and custom filters to align with business objectives.
Responsibilities:
Led the design and execution of sophisticated sales dashboards in Tableau, enhancing data visibility and decision-making processes across the organization.
Actively engaged in eliciting requirements from end users, translating business needs into technical and functional specifications for seamless integration and user satisfaction.
Leveraged SQL and data integration techniques to convert raw sales data into structured, actionable formats, ensuring accuracy and efficiency in reporting.
Partnered with diverse teams to develop bespoke visualizations that monitor key performance indicators, aligning with strategic objectives and operational goals.
Conducted thorough analysis of reporting requirements, creating proofs of concept and prototypes using Tableau Desktop to demonstrate potential solutions and refine user requirements.
Engineered robust data models and architectures to meet complex reporting needs, supporting scalability and long-term data integrity.
Utilized blending, relationships, parameters, and customized calculations to craft interactive reports and dashboards, incorporating filters, prompts, groups, and sets for enhanced analytical insights.
Extracted and integrated ServiceNow data to generate comprehensive reports in Tableau Desktop, providing a unified view of operational metrics.
Environment: Tableau Server, Tableau Desktop, SQL, Oracle, Excel, ServiceNow, Windows Server, Linux, Python, Power BI, JIRA, Confluence, Git, Shell Scripting, Data Warehousing, ETL Processes, Agile/Scrum Methodologies.
Client: Reliance Retail Ltd., India Apr 2017 – Jun 2018
Role: System Engineer
Worked on a project for Reliance Retail Ltd., focusing on integrating sales data from multiple sources and creating dynamic visualizations to support decision-making processes. This involved data transformation, automation, and reporting using Alteryx and Tableau.
Responsibilities:
Utilized Alteryx to automate data extraction, transformation, and loading (ETL) processes, ensuring seamless data flow from diverse sources into the central database.
Developed interactive dashboards in Tableau to visualize sales data, enabling stakeholders to track key metrics and trends efficiently.
Wrote and optimized SQL queries for data extraction and reporting, enhancing the performance of database interactions.
Collaborated with business analysts at Reliance Retail Ltd. to gather and document requirements, translating them into technical solutions that meet user needs.
Worked closely with cross-functional teams, including data engineers and business analysts, to ensure the accuracy and relevance of data presented in dashboards.
Conducted data quality checks and validations to ensure the integrity and reliability of the data used in reporting.
Provided support for data-related issues and performed troubleshooting to resolve discrepancies in the reports and dashboards.
Environment: Alteryx, Tableau Server, Tableau Desktop, SQL, Oracle, Excel, Windows.
Contact this candidate