Rakesh Nag

About Rakesh Nag

A professional with 10+ years of work experience in different domains such as Accounts, Supply Chain, Oil & Gas, Banking and Healthcare. Relevant exp of 6 years in Power BI with expertise in below:* Power BI, DAX, Power Query (M Code),* Power BI Report Builder & SSRS,* Power BI Service & Power BI Report Server,* Power BI Rest API,* Power BI Administration with PowerShell,* Power Automate,* Power Apps,* Tableau,* SQL SERVER * Advance Excel,# Expertise in Dashboard Layout Design, Dashboard/KPI/Report Development, SDLC, Data Visualization, Analytics and SCM Metrics.# Interested in learning business concepts, functionality traits. Finding rationale behind existing business logic or beliefs.# Keen interest in different ways to attractively visualize to convey the story inside the data.# Learning curve towards different analytics concepts, techniques and methods.# Passionate about building dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.# Interested in transitioning existing reports to Tableau/Power BI dashboards # Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.

Experience

1. Platform Engineer

   阿迪达斯

   Mar 2023 — Present

   Configured Tenant settings, Capacity workloads, Usage metrics, Capacity Metric App, Audit logs, Power BI premium capacity settings,Handled complex data refresh requirement using Enhanced Refresh API.Devised Safety Belts for avoiding capacity spikes such Query Scale out etc.Avoiding capacity spikes with help of capacity utilization & overages stats.Developed a Data Bricks Monitoring report which helps end users to see Query History stats of their reports.Maintained different levels of Data Security in Power BI such RLS, Dynamic RLS, Multi Column RLS, Data Source Level RLS etc.POC on MS Fabric capability, it can process 600 GB data (AWS S3 parquet files) in PBI reporting using Shortcut Developing Dashboard/Reports/Apps from Scratch such as Governance Dashboard/Blue Box/Prepaid Card etc. using Power BI and Report Builder.Developed Dynamic Native Query in Power BI to handle Direct Query efficiently.Devised a way to avoid multi queries to source from Power BI.Created and Standardized report design by creating theme file and design guide.Created a solution in Power BI to write back to Data bricks using PowerApps,Created a solution to export more than 150K records in Excel from Power BI using Power Automate.

Education

• Delhi University

  Bachelor of Commerce - BCom, Business/Commerce, General

  2009 — 2012

• R.S.B.V. Erasmus Boxing

  12th

• RSBV school

  12, Business/Commerce, General

  2008 — 2009

• GBSS (Galilee Business Support Services)

  10th

• Delhi University

  B. Com. (Honors)