Power Bi Project Management
Resume:
Power BI SQL DAX Data Analytics Business Intelligence Data Warehousing Cloud Integration Scrum Master Project Management Agile Delivery Business Analysis Reporting & Data Modeling Experienced and highly skilled IT professional with over 15 years of comprehensive expertise in data warehouse tools, business analytics, and Agile project management. Customer-oriented multitasker with exceptional analytical and problem-solving abilities, possessing over 9 years of experience as a Certified Power BI Developer specializing in Business Intelligence, data analytics and reporting solutions. Proficient in Power BI, SQL, and Agile methodologies, with a strong track record of delivering successful projects by driving innovation and fostering cross-functional collaboration. Demonstrated expertise in data visualization, data modeling, ETL/ELT architecture and Oracle SQL/PLSQL, ensuring seamless data integration and timely project deliverables. Adept at managing complex stakeholder relationships, aligning technical execution with business goals, and leveraging cloud platforms such as Snowflake for scalable solutions. Certified Scrum Master with deep knowledge of Agile methodologies, Waterfall/Agile frameworks, Scrum, and Kanban, driving process improvements and delivering complex products efficiently. Extensive experience utilizing project management tools like JIRA, Trello, and GitHub for efficient project tracking and experience in AWS and Azure DevOps for integrating cloud solutions into workflows. P R O F E S S I O N A L S UMMARY
• Proficient in Power BI, skilled at importing data from diverse sources and applying advanced analytics using DAX functions for complex data modeling.
• Experienced in designing interactive dashboards featuring RLS, custom visuals, bookmarks, and formatting for enhanced user experience.
• Collaborated with cross-functional teams to develop robust data models and analytics, aligning technical execution with business goals.
• Expertise in data modeling techniques, including creating relationships, measures, calculated columns, and optimizing data models.
• Proficient in designing data visualizations using Power BI (Line charts, Bar charts, KPIs, Tree maps, Pie charts, and custom visuals) and enhancing user interactivity with Slicers, Filters and Buttons.
• Extensive knowledge of data warehousing methodologies such as star/snowflake schemas, ETL processes, and dimensional modeling. Skilled in managing Power BI Service workspaces and app spaces to ensure security and proper access controls.
• Experience in ETL processes using Power Query and the M language for data transformation, as well as SSIS packages for data integration.
• Developed custom reports and dashboards using Power BI Desktop and SSRS, including Tabular, Matrix, Drilldown, and Parameterized reports.
• Strong SQL expertise, including Joins, Subqueries, Views, Procedures, and query optimization for performance improvements.
• Hands-on experience with data ingestion to Snowflake from diverse formats (CSV, JSON) and leveraging cloud services (AWS, Azure) for scalable data solutions.
• Developed Power Apps forms integrated with Power BI datasets to capture and visualize customer data. Proficient in SSRS, SSMS, SSIS, Visual Studio, and Power BI, with a strong background in data warehouse development, complex data mining and business intelligence.
• Proficient in all SDLC phases (requirement gathering, development, testing, deployment, production support) following both Agile and Waterfall methodologies.
• Organized and facilitated Scrum ceremonies (Sprint Planning, Daily Stand-ups, Sprint Reviews, Madhava R
*******.*******@*****.***
2
Retrospectives) and managed Agile metrics using JIRA and Confluence.
• Collaborated with product owners to manage backlogs, write user stories, and prioritize tasks for maximizing business value.
• Strong understanding of cloud platforms, particularly Azure, and experience hosting Power BI Report Server on Azure VMs. Committed to improving quality by implementing effective processes and supporting best quality practices to reduce defects. A R E A S O F E X P E R T ISE
• Database Management Tools: SQL Server Management Studio, Microsoft SQL Server, Oracle & MySQL
• Analytics/Reporting Tools - Power BI, Data Visualization (Dashboard Design, KPI Metrics, Interactive Reports), DAX, SSRS, Data Modelling, SQL, OLAP, SSIS and Tableau
• BI Tools - Power BI Desktop, Microsoft Fabric Implementation, Power BI Gateway, Power Query, Power BI App, SSIS, SSRS, SSMS and SSAS
• Languages – PL/SQL, DAX, M CODE and T-SQL
• Agile development and Best Practices & Agile Frameworks – Scrum and Kanban
• Project Management Tools: Atlassian Jira and Confluence, Rally, Microsoft Project & Trello
• Tools & Platforms: Visual Studio, MS Office Suite (Word, Excel & PowerPoint) & Power Pivot in Excel
• Business Intelligence technologies
• Project management
• Capable of thinking out of box
• Identify areas of improvement
• Stakeholder Management
• Willingness to learn new technologies
• Analytical and problem-solving skills
• Customer service and Risk identification
• Team player and Application Oriented approach
• Training material development & Quick Learner
• Excellent interpersonal skills and ability to work with diverse teams and Analyze test results
• Strategic planning & execution, process optimization, change management and release management
C E R T I F I C A T I ONS
• Professional Scrum Master (PSM-1)
• PL-300 (DA-100) Microsoft Power BI Data Analyst Certification P R O F E S S I ONAL E X P E R I E N C E
BCT Consulting Inc. (Bahwan CyberTek Group) Feb-2024 to Till Date Role : Power BI Developer
Client : Alnylam Pharmaceuticals, USA
Responsibilities:
• Collaborated with management and other teams to define project objectives, translating business requirements into innovative Power BI solutions.
• Developed and maintained interactive Power BI dashboards and reports to visualize key business metrics and support data-driven decision-making within the pharmaceutical domain.
• Collaborated with cross-functional teams to gather requirements, understand business needs, and design efficient data models that align with organizational goals.
• Utilized DAX to create complex calculated measures, aggregations, and custom calculations, enabling stakeholders to extract deeper insights from the data.
• Created and optimized SQL queries to extract, manipulate, and transform large datasets from various data sources, ensuring high-quality data for reporting. Implemented dynamic visualizations such as bar charts, line graphs, KPIs, and slicers to enhance user experience and facilitate data exploration. 3
• Ensured data integrity and accuracy through rigorous validation techniques, automating report refreshes and improving report accessibility across departments.
• Provided technical support and training to end-users, ensuring proper understanding and use of Power BI tools for self-service analytics.
• Utilized advanced DAX functions, including time intelligence, mathematical, and logical operations, to create measures and calculated columns for in-depth data analysis. Vilas Business Solutions Pvt.Ltd., Lead Consultant May-2019 to Jan-2024 Role : Power BI Developer
Client : Con Forms, USA
Responsibilities:
• Collaborated with management and analyst teams to define project objectives, translating business requirements into innovative Power BI solutions.
• Created and optimized efficient, scalable data models in Power BI, supporting interactive visualizations and analytical reporting.
• Applied Power Query to transform data from multiple sources, performing data cleansing, merging, and shaping to improve data quality.
• Designed and implemented new and standard reports using SSRS and Power BI, ensuring clear and concise data presentation.
• Utilized advanced DAX functions, including time intelligence, mathematical, and logical operations, to create measures and calculated columns for in-depth data analysis.
• Applied optimization techniques to enhance Power BI report performance, including data model and query optimization, resulting in faster response times and a better user experience.
• Developed custom reports and dashboards using Power BI Desktop, ensuring robust data visualizations tailored to stakeholder needs.
• Published reports to Power BI service, managing access through role-based security measures and ensuring data integrity.
• Communicated project updates and data insights to stakeholders, providing actionable business recommendations and fostering informed decision-making.
• Analyzed complex datasets to identify trends and patterns, translating insights into actionable business strategies. Implemented dynamic features such as bookmarks, drill down, drill through, and button actions to enhance interactivity in reports.
• Collaborated with stakeholders to gather reporting requirements and deliver tailored, effective data visualizations.
• Managed stakeholder expectations by providing regular updates and aligning deliverables with business objectives.
Vilas Business Solutions Pvt.Ltd., Sr. Consultant Feb 2015 – April 2019 Role : Power BI Developer
Client : GHSP, USA
Responsibilities:
• Created dynamic and interactive dashboards using Power BI, facilitating better visibility into key performance metrics.
• Used SSIS for ETL processes to extract, transform, and load data from multiple sources into the data warehouse. Gathered data from various external sources (Oracle) into a data warehousing system
(Enterprise Cube) through the ETL process.
• Implemented DAX (Data Analysis Expressions) functions for SSAS tabular models and Excel pivot tables to create advanced calculations.
4
• Designed data visualizations using various objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Managed table relationships in Power BI using the star schema and created data hierarchies for enhanced analysis.
• Designed and managed databases in SSMS, ensuring data accuracy and integrity across multiple projects. Integrated Power BI reports with SSRS for enhanced reporting capabilities.
• Developed and optimized Power BI reports and dashboards using data from on-premises and cloud sources.
• Performed data cleansing and transformation using Power Query in Power BI, including Pivot/Un-pivot operations for data massaging.
• Designed SSRS reports with sub-reports, dynamic sorting, and defined data sources and subtotals for reporting needs.
• Analyzed data from SQL databases and Excel files to identify trends and patterns, supporting data- driven decision-making.
• Optimized Power BI reports and dashboards for performance and established best practices for data modeling and visualization.
Vilas Business Solutions Pvt.Ltd., Consultant Feb 2012 – Jan 2015 Role : Scrum Master
Client : Freddie Mac, USA
Responsibilities:
• Facilitated scrum ceremonies such as Sprint planning, Daily stand ups, Sprint review, Retrospective, Sprint demos and Backlog refinement, ensuring continuous team engagement and alignment.
• Prepared team capacity sheets ahead of Sprint Planning based on upcoming sprint availability and discussed them during Daily Standups.
• Utilized Scrum and Kanban boards to monitor project progress, limit work-in-progress, and maximize team efficiency while improving stakeholder visibility. Developed dashboards that provided a clear view of workloads and roadmaps, aiding teams in quarterly planning.
• Coordinated with development teams to monitor release schedules and checkpoints to meet production timelines. Worked closely with delivery management and product owners to align team efforts with project goals and quarterly roadmaps.
• Facilitated backlog grooming sessions and estimated user stories using techniques like Planning Poker to ensure accurate prioritization.
• Monitored team velocity and progress using Burndown/Burnup charts and Velocity reports, ensuring data-driven decision-making.
• Actively worked with team members to resolve blockers and improve productivity.
• Managed relationships with technology vendors, overseeing hardware and software support agreements to meet project and business needs.
BOFO Solutions Pvt.Ltd., Consultant May 2009 – Jan 2012 Composite Design Support Limited, Birtley, U.K., Software Engineer March 2007 – April 2009 E D U C A T I ON / A C ADEMIC C R E D E N T I A L S Master in science – Engineering Design and its Management Nov 2006 From University of Huddersfield, London, U.K.
Bachelor of Engineering April 2003
From Madras University, Chennai, India.
Contact this candidate