At DTE Energy, the collaboration with experts across departments has honed our approach to data analytics, particularly in AI-enhanced analysis and visualization. Leading a team in energy sector projects, we've elevated Power BI reporting with custom visualizations and interactive features, harnessing R and Python for strategic insights.The integration of a comprehensive Data Warehouse underlines our commitment to a data-centric culture. Through Agile methodologies, we've ensured that our analytics initiatives align with organizational goals, facilitating data-driven decision-making and fostering a collaborative environment that propels the energy sector forward.
Dte Energy
View- Website:
- dteenergy.com
- Employees:
- 9333
-
Bi Developer And Data AnalystDte EnergyHouston, Tx, Us -
Bi Developer / Data AnalystDte Energy Dec 2022 - PresentMetro Detroit, Michigan, United StatesContributed to energy sector analytics by providing key insights to optimize energy production, distribution, and customer service.Assisted in developing a centralized Data Warehouse, integrating data from Salesforce and SAP to improve decision-making and streamline reporting processes.Played a key role in implementing Snowflake as the primary data storage solution, enabling real-time analytics and driving operational improvements.Enhanced Power BI reports with custom visualizations, interactive features, and advanced DAX functions to support energy consumption and performance analysis.Applied Python-based machine learning to analyze complex energy datasets, delivering actionable insights for strategic business initiatives.Executed ETL processes using SAP HANA and Teradata, ensuring seamless data integration and reliable data flow for energy operations.Developed data transformation pipelines using SQL and Azure Data Factory, facilitating efficient data processing.Supported the establishment of a SharePoint platform for Lean Six Sigma projects, contributing to continuous improvement and audit processes. -
Senior Data Analyst / Power Bi DeveloperDxc Technology Nov 2020 - Oct 2022Topeka, Kansas, United StatesExtracted data from SQL Server, Azure SQL Database, and Salesforce using complex SQL queries and stored procedures, enabling comprehensive reporting.Developed advanced visualizations in Tableau (scatter plots, heatmaps, donut charts) to effectively present business insights.Utilized DAX in Power BI to create measures and calculated fields, enhancing the depth of data analysis and reporting.Implemented the migration of key reports and dashboards from Tableau to Power BI, optimizing performance and improving data visualization capabilities.Built and maintained interactive dashboards in Power BI and Tableau, ensuring data-driven decision-making with real-time insights.Developed SSIS packages to streamline ETL processes, optimizing data integration workflows and ensuring data accuracy.Designed and implemented snowflake schema models in SQL Server Data Warehouse, improving scalability and flexibility for analytics. -
Business Intelligence Developer / Power Bi DeveloperWells Fargo Dec 2018 - Oct 2020Charlotte, NcCollaborated with clients, data managers, and analytics teams to deliver data solutions aligned with banking goals and regulatory requirements.Developed data warehouses and data marts to improve data analysis and reporting for the banking sector.Created SQL scripts and Tableau dashboards connected to Azure SQL for efficient reporting processes.Managed user access and security for Power BI dashboards, ensuring proper data sharing and compliance.Built and optimized Power BI and Tableau reports, using DAX and SQL to extract insights from banking data.Designed and implemented stored procedures, triggers, and views for data processing and cleansing to improve data quality.Developed SSIS packages for data transformations and used Python for data loading into BigQuery.Contributed to banking application migrations and web development on Azure, improving data access and operations.Created SSAS tabular cubes for reporting, enhancing data analysis and insights. -
Data AnalystInspire Innovations Jan 2017 - Feb 2018IndiaExtracted and analyzed data from various databases, including SQL Server and Oracle, using SQL queries for reporting and insights.Utilized SQL Server Management Studio (SSMS) and SSIS for data querying and ETL processes to streamline data integration.Performed data cleansing and manipulation with T-SQL and Excel to ensure accurate reporting and analysis.Developed and maintained Power BI reports, incorporating data from SQL Server to provide actionable insights for stakeholders.Prepared project presentations and reports using MS PowerPoint and Excel, incorporating insights from SQL Server data.Managed data integrity and tracked missing files using SQL Server and Excel, ensuring accurate data availability.Participated in Agile and Scrum meetings, providing updates on SQL Server-related tasks and ensuring smooth project execution. -
Data AnalystBig Biz Solutions Jun 2014 - Dec 2016IndiaTranslated business objectives into analytical tasks and developed databases to support performance improvement initiatives.Collaborated with teams from accounting, marketing, sales, and operations to ensure data accuracy and maintain database integrity.Executed data extraction and reporting tasks using SQL and Excel, including pivot tables and VLOOKUP for data analysis.Used Tableau to create visualizations, identifying trends and patterns for business insights.Conducted research and analysis of sales data, transforming it into actionable insights to support decision-making.Assisted in budget forecasting and generated ad-hoc reports for management review.Applied business intelligence techniques like Regression analysis and forecasting, contributing to improved sales performance.
Rakesh R. Education Details
-
Bachelor Of Technology In Computer Science Engineering
Frequently Asked Questions about Rakesh R.
What company does Rakesh R. work for?
Rakesh R. works for Dte Energy
What is Rakesh R.'s role at the current company?
Rakesh R.'s current role is BI Developer and Data Analyst.
What schools did Rakesh R. attend?
Rakesh R. attended Osmania University.
Who are Rakesh R.'s colleagues?
Rakesh R.'s colleagues are Khalil Rahal, David Palsrok, Maria Lawson, David Wiecha, Chris Lethbridge Jj, Project Creator, Sally Smith.
Not the Rakesh R. you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial