Power Bi Project Management
Resume:
RAJENDRA PULIVARTHY
Senior Lead Engineer
******************@*****.***
P R O F E S S IO N A L S U M M A RY
More than 13+ years of experience in the IT industry, with a focus on project management and IT development, maintenance, and support with 7+ years of experience in Leading project.
Coordinated with cross-functional teams, including development, QA, and design, to ensure seamless project execution.
Facilitated project kick-off meetings, requirement gathering sessions, and sprint planning meetings to align project teams and stakeholders.
Conducted weekly project status meetings and utilized Dev-Ops boards for issue tracking and task management.
Managed scope changes and client expectations through effective communication and change control processes.
Collaborated with stakeholders, including executives, clients, and vendors, to ensure alignment with project objectives and expectations.
Developed and delivered regular project status reports, presentations, and executive summaries to keep stakeholders informed and engaged.
Conducted post-project evaluations to identify lessons learned and areas for improvement, leading to enhanced project performance and client satisfaction.
Develop and execute a project communication plan.
Ensure effective communication within the project team and with stakeholders.
Technically competent and resourceful BI Developer (Power BI, SSAS, Snowflake Cloud Data Warehouse, SSRS, Tableau, ), Arc Plan reporting tool, Crystal reports, SQL, T- SQL, and ELT, ELT technologies like Azure data factory(ADF), SSIS, Where scape (3D, Red with Overall 13+ years of IT experience in analysing data.
Skilled in utilizing OLAP tools such as Microsoft Analysis Services to extract, transform, and analyse complex datasets.
Proficient in designing, implementing, and optimizing OLAP solutions to drive actionable insights and support strategic decision-making.
Extensive experience with Power Platform tools like POWER-BI, Power Automate, Power Apps.
Proficient in Microsoft Fabric for integrating data engineering, data warehousing, and real-time analytics into a unified platform, enabling end-to-end analytics solutions.
Experienced in implementing data pipelines using Microsoft Fabric, automating data flows from diverse sources and optimizing performance for complex data models.
Strong expertise in developing analytical solutions with Microsoft Fabric by leveraging tools such as Power BI, Synapse, and Data Lake integration.
Experience in connecting to a REST API / other web services from Power BI to fetch external data—like CRM, ERP, finance, social media platforms, custom apps, etc.
Experienced Senior Tableau Developer with 5 years of expertise in designing and deploying advanced dashboards and visualizations.
Experience with Azure cloud platforms like (IaaS, SaaS, PaaS), Cloud resources and resource groups.
Experience in designing and implementing data models in Snowflake, including schema design, table structures, and optimization for performance and scalability.
Strong command of SQL for data manipulation, querying, and performance tuning within the Snowflake environment. This includes expertise in writing complex SQL queries, stored procedures, and user-defined functions.
Experience with Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) processes in Snowflake, using tools like Snowflake's native features, or third-party ETL/ELT tools like WhereScape(3D, Red), Azure Data Factory, Matillion and ADF.
Created and maintained comprehensive data models, including star schemas and snowflake schemas, to support business intelligence and reporting needs.
Implemented error handling and logging mechanisms to ensure data integrity and traceability.
Optimized SSIS packages for performance, reducing ETL processing time.
Developed and maintained documentation for ETL processes, ensuring clarity and reproducibility.
Collaborated with data architects and analysts to understand data requirements and deliver accurate solutions.
Conducted unit testing and system integration testing to validate ETL processes and data accuracy.
Ability to integrate data from various sources into Snowflake, including structured and semi-structured data formats, such as JSON, XML, CSV, Parquet, etc.
Demonstrated ability to stay updated with the latest Snowflake features, enhancements, and best practices, and adapt quickly to evolving technologies and business requirements.
Experience with Power platform like – Power Bi reporting, Power Bi Services, Power BI report builder, Power Automate, Power apps.
Experience of Tableau, Cogonos to the Power Bi Dashboards and reports Migration.
Knowledge on the Azure fabric and the Pipelines end to end flow.
Good experience with end to end Tableau, SSRS and Power Bi, development projects.
Experience with Ad hoc reporting, Parameterized, Custom Reporting using different reporting tools for daily reports.
Experience with Snowflake Cloud Data Warehouse, deep understanding of Snowflake architecture and processing.
Good Experience in filtering the Unwanted Data in Power Query.
Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, Un Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns.
Extensively worked on Enhancing the Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions.
Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information.
Good hands on experience with Power Automate to automate multiple services and data driven and ad-hoc refreshing in power BI.
Experience in working with SSAS in creating cubes.
Gathered and documented business requirements for SSRS reports through stakeholder interviews and workshops.
Defined technical specifications for report development, ensuring alignment with business needs.
Validated and tested SSRS reports to ensure they met user requirements and performance standards.
Trained business users on accessing and utilizing SSRS reports effectively.
Acted as a liaison between business stakeholders and technical teams, facilitating clear communication.
Conducted regular reviews and updates of reporting requirements based on changing business needs.
Supported continuous improvement initiatives for reporting processes and tools.
Extensively worked in Power View for Presenting the Data in Graphical Format using Different Visualizations in Power BI.
Hands on Experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report.
Good Experience in Creating Hierarchies and Drilldown Reports.
Good Experience in sorting the Data in Visualizations, Grouping and Binning the Data in Power BI.
Experience in publishing the Reports to Power BI Service and setting up the necessary connections.
Worked on On-Premises Data Gateway to Refresh and Schedule Refresh the Data in the Dataset.
Implemented ROW LEVEL SECURITY (RLS) as part of security in Power BI.
Experience in sharing the Reports and Dashboards with End Users.
Proficient in designing and developing visually appealing and interactive dashboards using Tableau Desktop. Skilled in choosing the right chart types, colour schemes, and interactivity features to effectively communicate data insights.
Extensive experience in creating dynamic and intuitive dashboards that provide stakeholders with real-time access to key metrics and KPIs. Capable of integrating multiple data sources and designing workflows for seamless navigation.
Strong analytical skills combined with deep understanding of data structures and relationships. Able to conduct thorough data analysis to identify trends, patterns, and outliers, and translate findings into actionable recommendations.
Proficient in writing SQL queries to extract, transform, and manipulate data from various sources for use in Tableau. Experienced in data blending and data preparation techniques to ensure data accuracy and reliability.
Skilled in optimizing Tableau dashboards and reports for performance and scalability. Proficient in techniques such as data aggregation, calculated fields optimization, and extract optimization to enhance dashboard responsiveness.
Good Hand on experience using management tools like Jira, confluence Azure Devops to Pull tasks into the sprint backlog according to team velocity. Move tickets through Jira workflow and attach files like screenshots, sample data, or SQL scripts to the jira tickets.
Hands on experience to use confluence to document business requirements, KPIs, and report expectations. Capture meeting notes from stakeholder discussions or requirement gathering sessions. Include mockups, wireframes, or dashboard sketches for reference.
Skills:
Databases
SQL Server, My SQL, Snowflake, Oracle, Azure Synapse.
ETL Tools
SSIS, ADF, Microsoft Fabric, Wherescape, Informatica, Data Stage
Cubes
SSAS Multi-dimensional, Tabular cubes.
Cloud Tools
Azure Data factory, Azure data Storage, Azure Data bricks, Azure Fabric
Reporting Tools
SSRS, Power Bi, Power Bi Report builder, Arc Plan, Tableau, Pbrs.
Querying Tools
SSMS, Dax Studio, Visual Studio.
Scripting Tools
Pyspark, Pyhton.
Project management Tools
Azure Devops, Jira, Confluence, Word, Excel, One Note, Teams, Planner
Domain Experience:
Possessing expertise in several fields such as sales, payroll, human resources, and finance.
Proficiency in incident handling reporting
Proficiency in scrutinizing sales representative data and determining incentive distribution.
Proficiency in monitoring and tracking payroll-related tasks.
Proficiency in executing management information system (MIS) reporting for monthly and annual sales reports.
Experience in healthcare domain to insight the business trails tacking and sales.
Proficiency with both PX analytics and the HR E2E process.
Proficiency in supply chain management reporting to monitor every aspect of every stage of the process.
Proficiency in disclosing modifications and enhancements in payroll and budget monitoring.
Employment history
SVS IT Systems Inc Persistent (Client -Mizuho Bank USA) Senior BI Engineer/Data Engineer
Jul 2023 - Present
Design and develop interactive reports, dashboards, and data models using Power BI.
Connect and integrate data from various sources, such as databases, Excel files, cloud services, etc.
Implement data transformations, data cleaning, and data modelling to create a reliable data model.
Optimize performance and efficiency of Power BI reports and dashboards.
Creating Dax expressions for measures and column calculations.
Using Power Query to work on transformations.
Setting up options in Power Query to use Mcode for incremental load scheduling.
Reports are published to services, and the deployment pipeline is established within the services to transfer developed reports to production.
Created different parameterized reports using Power Bi report builder(Paginated reports/SSRS).
Creating datasets for paginated reports by writing Dax queries.
Utilizing Dax Studio to create Dax Queries and the data checks found in the Power BI schematic models.
Scheduling Paginated reports(Pbrs) using Tidal jobs.
Creating views in reporting schema for the dataset creation.
Python code to use for fetching data from different source and tuning it as per requirement needs.
Implemented data pipelines for extracting, transforming, and loading (ETL) data into Snowflake, ensuring data accuracy and consistency.
Optimized Snowflake performance through efficient query tuning, resource utilization, and workload management.
Implemented clustering, partitioning, and indexing strategies to improve query performance and reduce processing time.
Implemented role-based access controls (RBAC) and data encryption to ensure data security and compliance with regulatory requirements.
Developed data governance policies and procedures to maintain data integrity and enforce data quality standards.
Designed end-to-end data integration pipelines using Azure Data Factory and Where scape(3D, Red) to ingest, transform, and load (ETL) data from various sources into target data repositories.
Building Enterprise data models to create common dimensions and facts using WhereScape.
Developed reusable data transformation activities and custom activities using Azure Functions to implement complex data processing logic.
Implemented monitoring and logging solutions to track pipeline execution, data lineage, and performance metrics.
Conducted performance tuning and optimization of Azure Data Factory pipelines to improve throughput, reduce latency, and optimize resource utilization.
Connecting to a REST API from Power BI to fetch external data from Salesforce CRM and transform it to business useful needs.
Volvo cars Senior insight Engineer (Data / BI Engineer) Bengaluru, IND
Jul 2021 - Jun 2023
Worked on Data Ingestion, Data profiling, Transformation using Snowflake.
Implemented DBRA(Driver based revenue allocation) methodology to calculate revenue per customer in snowflake using Snowflake stored procedure and views.
Implementing ELT process for accessing and loading data from multiple source systems by using WhereScape(3D, RED) and Azure Data factory.
Implemented ELT process for loading dimensions and facts using whereScape 3D.
Worked on loading CSV data from s3 External stage to Snowflake using Snowpipe, Stream and Task.
Experience in ELT process in Snowflake, Involved in E2E process.
Worked on Integrating and scheduling the whole flow of ingestion, profiling and transformation using snowflake tasks and streams.
Created daily, weekly and quarterly monitoring reports using SSRS.
Creating Dax datasets using Dax studio for SSRS reports using Power Bi datasets as source.
Creating multiple dashboard’s using Power Bi desktop.
Employed WhereScape 3D to design and model data warehouse structures, facilitating accurate and efficient data storage solutions.
Conducted data profiling and analysis to understand data sources, ensuring accurate data mapping and transformation rules.
Created and maintained comprehensive data models, including star schemas and snowflake schemas, to support business intelligence and reporting needs.
Capgemini Senior Consultant (Senior Consultant) Bengaluru, IND
Client – Eco labs, HPI, HPE
Nov 2018 - Jul 2021
Contribute to project planning, design, and development activities.
Execute tasks and deliverables according to the project plan.
Collaborate with other team members to achieve project goals.
Provide expertise in their respective areas, such as development, design, testing, etc.
Gather and document project requirements, ensuring they align with business needs.
Working on different OLAP and OLTP databases for storing current and historical data using different dimensional modelling techniques.
Developing Multi-dimensional and Tabular cubes using OLAP Databases.
Created multiple Dashboards and reports using Tableau and power Bi Desktop and Power Bi report builder.
Involuted in creating Monitoring reports using SSRS and Power Bi reports.
Techno Soft Team Lead Bengaluru, IND
Jun 2018 - Nov 2018
Configured, Installed and Administered Reporting Services 2012.
Converted 50+ reports from Business Objects and SSRS reports to Power BI.
Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Drill through, and Drill down Reports.
Designed Large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters
Transformed reporting processes by integrating advanced filtering techniques, setting new standards in data analysis.
Spearheaded a seamless transition of over 50 reports to Power BI, boosting data analysis efficiency.
Loading data to the OLAP systems using ETL tools like SSIS and wherescape.
Used multiple tasks and Transformations for transforming data and loading into the destination EDWH
Created ad-hoc reporting based on the client requirements using SSRS and Power BI.
Created revenue reports and the HR reports for the monthly and yearly analysis using SSRS.
Scheduling reports using Tidal Jobs for Weekly and Quarterly reporting needs.
DXC Technologies Data Engineer II Bengaluru, IND
Client – Seadrill, HPI
Jul 2016 - Jun 2018
Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
Worked with multiple type of dimensionality (Conformed, Degenerate, Role playing etc), Design with Multiple Fact Tables, Star and Snowflake Schema design and data model (Relational and Multi-dimensional), Transactional\Operational Data Store (ODS), MDM, and other Data Warehouse concepts.
Led design of scalable Star and Snowflake schemas, enhancing data retrieval efficiency.
Streamlined Data Warehouse operations, significantly reducing data processing time.
Introduced advanced multi-dimensional modeling techniques to improve data analysis.
Managed meticulous implementation of ODS, ensuring accurate real-time data availability.
Pioneered integration of MDM into existing architectures to centralize data management.
Optimized ETL processes, reducing load times by 30% at DXC Technologies.
NuSecond Technologies Team Lead Bengaluru, IND
Client – Seadrill, DXC Technologies
Jul 2016 - Jun 2018
Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
Worked with multiple type of dimensionality (Conformed, Degenerate, Role playing etc), Design with Multiple Fact Tables, Star and Snowflake Schema design and data model (Relational and Multi-dimensional), Transactional\Operational Data Store (ODS), MDM, and other Data Warehouse concepts.
Led design of scalable Star and Snowflake schemas, enhancing data retrieval efficiency.
Streamlined Data Warehouse operations, significantly reducing data processing time.
Introduced advanced multi-dimensional modeling techniques to improve data analysis.
Managed meticulous implementation of ODS, ensuring accurate real-time data availability.
Pioneered integration of MDM into existing architectures to centralize data management.
Optimized ETL processes, reducing load times by 30% at DXC Technologies.
Tek Systems Sr, Software Engineer Bengaluru
Client – Robert Bosch
Jul 2015 - Jul 2016
Involved in Installation, Configuration, Upgrades, Administration of SQL Server 2008/ 2008 R2 across different environments like Test, Dev, UAT, and PROD.
Successfully Migrated/Upgraded SQL Servers (In place and Side by Side) from 200*-****-**** on Development, Testing Production Environments for various mission critical applications.
Handling multiple instances failover SQL cluster for SQL 2008 on Windows Server 2008/ 2008 R2.
Upgraded SQL Server systems, enhancing performance and reliability across multiple environments.
Managed SQL Server 2008 installations and configurations, optimizing system efficiency.
Oversaw failover clustering for SQL Server 2008, ensuring robust data integrity and uptime.
Pioneered SQL Server migrations, boosting system capabilities and supporting critical applications.
Administered multiple SQL Server environments, providing stable and secure database solutions.
Streamlined SQL Server 2008 updates, boosting system efficiency and reliability.
IDS Next Software Engineer Bengaluru
Oct 2013 - Jul 2015
Gathered business requirements from users and translated them as technical specs and design docs for development.
Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
Transferred data from various data sources/business systems including MSExcel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
Engineered data models and enhanced data flow between systems, boosting efficiency.
Optimized data integration using SSIS, significantly reducing data processing time.
Refined data extraction processes, ensuring high accuracy and reliability in data handling.
Pioneered advanced data management strategies, setting a new standard for data utilization.
Facilitated team understanding of technical requirements, enhancing project collaboration.
Streamlined data extraction to SQL Server, enhancing system integration and reliability.
AMZ Web Solutions Software Engineer Bengaluru
Client – Midland Courier
Feb 2011 - Oct 2013
Define data modelling standards and guidelines to ensure consistency and scalability.
Optimize data storage and retrieval for improved performance.
Collaborate with data engineers and developers to design data integration processes.
Engineered robust data models, enhancing system scalability and consistency.
Boosted database performance, ensuring faster data access and processing.
Fostered teamwork in Power BI projects, aligning data goals across departments.
Pioneered data integration strategies, setting a benchmark for future projects.
Managed detailed reporting protocols to meet diverse team requirements.
Streamlined data workflows, enhancing operational efficiency and output quality.
Education
PG - IIBM institute of Business Management MBA (Project Management/Human Resource) 2014.
Grad - VTU, Bangalore B.E (Electrical and Electronics) 2010.
Contact this candidate