Rakesh R. Email & Phone Number

Houston, Tx, Us

Metro Detroit, Michigan, United States

Contributed 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.

Topeka, Kansas, United States

Extracted 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.

Charlotte, Nc

Collaborated 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.

India

Extracted 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.

India

Translated 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.