Rahul N

PROJECT SUMMARY :

Power BI Developer

Project Client : Northern Trust

September 2022 - Present

Environments : Power BI Desktop, Power BI Service, Oracle SQL

Northern Trust is a Financial services company and a Banking Institution based in US.

Roles & Responsibilities :

• Extracting the data from Oracle SQL and SQL SERVER Tabular Model, performing basic ETL Processes using Power Query and placed into Power View.
• Integrated real time data using Power BI's streaming dataset capabilities and Establish Relationships and perform Data modelling from multiple sources.
• Applied Complex DAX calculations and measures for time series analysis and various such metrics.
• Utilized Power BI's Custom Visuals and Slicers to provide Dynamic Filtering and detailed insights into performance metrics and develop Interactive Dashboards.
• Developed visualizations such as scatter plots, bubble charts, heat maps and advanced chart types according to project specifications.
• Scheduled report Refreshes and data updates using Power BI Services and Enterprise Gateway and Implemented Row-Level Security (RLS) to ensure Data Security and accessibility only for authorized users.
• Enhanced Dashboards by implementing advanced features like Bookmarks, Hierarchies and Drill-through capabilities and conducted various Performance Optimization techniques.
• Optimized dashboards by integrating complex SQL functions and stored procedures to efficiently preprocess data, streamline ETL processes, and improve overall query performance in Power BI, ensuring accurate and timely insights for business decision-making.
• Implement version control practices to monitor changes and manage different versions of Power BI reports.

Data Analyst

Project Client : Womeyn

April 2021 – September 2022

Environments : Power BI Desktop, Oracle SQL

Womeyn is a social enterprise E-Commerce Platform aiming to empower women of our community to help them achieve Self-Reliance.

Roles & Responsibilities :

• Created Power BI reports that provide clear visualizations of key industry-specific performance metrics.
• Designed dashboards with filters, parameters, and action filters, and developed Drill-through reports within the dashboards.
• Expert in designing and deploying rich graphical visualizations with Drill-down and Dropdown menu options, and Parameterization within Power BI.
• Developed visualizations such as side-by-side bars, scatter plots, stacked bars, heat maps, Filled maps, and ArcGIS maps according to project specifications.
• Combined data from multiple sources and custom objects using Data blending techniques and crafted Customised and Interactive Dashboards.
• Conducted year-over-year, quarter-over-quarter, YTD, QTD, and MTD Analysis within Power BI workbooks.
• Built Complex Reports incorporating Forecasting, Trend lines, and Reference lines for advanced data analysis.
• Developed reports tailored to meet client requirements.

Associate Analyst

Project Client : Piramal Swasthya

January 2020 – April 2021

Environments : Power BI, Microsoft Excel, SQL,JIRA

Piramal Swasthya is a division of Piramal Group specializing in Mobile Medical Services.

Roles & Responsibilities :

• Experience in developing and implementing BI solutions for tracking Sales, Product, and Customer KPI.
• Developed and reviewed SQL queries utilizing joins in Power BI Desktop to validate both static and dynamic data for ensuring data accuracy.
• Cleaned and Integrated multiple data sources to enable various views of application data within a single dashboard.
• Created, customized, and published Interactive Reports and Dashboards, and managed report Scheduling using Power BI Server.
• Documented the dashboard requirements, key success factors of the business, relevant KPIs, measures in the dataset, and design specifications.
• Played a role in creating interactive dashboards and applied actions such as Highlighting and URL links to enhance user interaction based on business needs.
• Generated Dual-axis, Blended-axis, Bar, Pie, and Donut charts with multiple measures, and handled Data blending for merging different data sources.