Summary
Overview
Work History
Education
Skills
Certification
Primary Skills
Timeline
Generic

RAKESH RANJAN

DELHI

Summary

Versatile Data Professional with expertise in Power BI development, T-SQL programming, and data analysis. Skilled in designing and implementing data solutions for both engineering and analytical purposes. Proven ability to leverage technical acumen to drive business insights and optimize data infrastructure.

Overview

6
6
years of professional experience
1
1
Certification

Work History

POWER BI APPLICATION DEVELOPER

ACCENTURE
10.2021 - Current
  • Design and develop Power BI reports and dashboards in finance domain, employing various data visualization techniques and complex data modeling which ultimately help business users to get complete insight of business and help them to take important decisions
  • Create data models supporting business requirements using Power Query and advanced DAX functions.
  • Utilize Power Apps and Power Automate for data integration and process automation.
  • Collaborate closely with stakeholders to understand requirements and provide training and support.
  • Optimize report performance and troubleshoot issues.
  • Manage user access, permissions, workspaces, and data sources.
  • Monitor Power BI service and manage licensing for users.

SQL Developer

Corecard Software Development
05.2020 - 10.2021
  • Developed and maintained complex T-SQL queries, views, and stored procedures required for maintaining and developing reports related to credit card , payment card
  • Optimized application performance through root cause analysis and query optimization.
  • Created SSRS reports from SQL database stored procedures.
  • Analyzed and enhanced existing SSRS reports.
  • Designed and implemented T-SQL queries for reporting and solution development.

BI Developer

Kelly IT Resources US
09.2019 - 05.2020
  • Closely worked on retail data generated from all stores of company, develop power bi report visuals on important KPI like total sales , year on year growth , revenue , cost and all these gives overall health of business and helped business users to take important decisions
  • Designed and implemented TSQL queries, stored procedure, scalar function, multi line table value function for reporting and complex solution development
  • Analyzed existing SQL queries to identify opportunities for improvements.

SQL Developer

Magicrete Building Solutions Private Limited
03.2018 - 12.2018
  • Designed and implemented TSQL queries for reporting and importing tables in Power BI, do data modeling, write DAX queries, and make attractive visualization
  • Analyzed existing SQL queries and make raw data into meaningful data which is used for further analysis for making business decisions.

Education

Bachelor Of Engineering - Electronics And Telecommunication

BapuraoDeshmukh College Of Engineering
Nagpur, India
06.2013 -

Intermediate (12th Board Exam) - Science Education

Delhi Public School
05.2008 - undefined

10th Board Exam - undefined

Woodbine Modern Public School
05.2006 - undefined

Skills

Primary skill : T-SQL , Power BI, Data Modelling , Advance Dax ,Paginated Report

undefined

Certification

cleared PL- 300 exam(Microsoft certified data analyst)

Primary Skills

  • Power BI
  • T-SQL

Timeline

POWER BI APPLICATION DEVELOPER

ACCENTURE
10.2021 - Current

SQL Developer

Corecard Software Development
05.2020 - 10.2021

BI Developer

Kelly IT Resources US
09.2019 - 05.2020

SQL Developer

Magicrete Building Solutions Private Limited
03.2018 - 12.2018

Bachelor Of Engineering - Electronics And Telecommunication

BapuraoDeshmukh College Of Engineering
06.2013 -

Intermediate (12th Board Exam) - Science Education

Delhi Public School
05.2008 - undefined

10th Board Exam - undefined

Woodbine Modern Public School
05.2006 - undefined

Similar Profiles

CREATE PROFILE
RAKESH RANJAN