Home

Rakesh - BI Developer / BI Consultant / Tableau Developer / Power BI Developer / Data Analyst / Data Consultant

[email protected]

Location: Houston, Texas, USA

Relocation: Yes

Visa: GC

Rakesh Senior Data Analyst | Tableau Developer |BI Developer | BI Consultant | Power BI Developer | Data Analyst | Data Consultant Summary: Over 9+ years of diversified experience in the IT industry, specializing in data analysis and business intelligence development with a focus on Power BI over the last 7+ years. Proficient in T-SQL for developing, optimizing, and maintaining complex stored procedures, triggers, user-defined functions, and tables, ensuring high standards of data integrity and eHiciency. Advanced skills in Performance Tuning and Query Optimization; proficient in using SQL Server Performance Tools such as SQL Profiler, Database Engine Tuning Advisor, and Index Tuning Wizards to enhance database performance. Extensive experience with MS SQL Server (2005 to 2019), utilizing SSRS, SSAS, and SSIS to build robust, scalable data solutions and perform data analytics & processing with increased eHiciency. Demonstrated ability to engineer complex SQL queries and architect database objects, including stored procedures, views, indexes, and triggers. Expert in managing queries involving multiple joins, subqueries, and aggregate functions to retrieve complex data. Expertise in SQL Server High Availability and Disaster Recovery (HADR) solutions, implementing SQL Server Replication, Log Shipping, and SQL Server Always On solutions to ensure data availability and business continuity. Developed comprehensive ETL workflows using SSIS, integrating control flow, data flow tasks that automate data loading and transformation processes tailored for specific business requirements. Robust experience in logging, error handling, and performance tuning in SSIS packages using best practices and Event Handlers to maintain data reliability and operational stability. Proficient in automating and scheduling SSIS packages using SQL Server Agent, creating jobs, alerts, and SQL Mail for automated task management and system notifications. Advanced reporting skills using SQL Server Reporting Services (SSRS); proficient in creating dynamic, interactive reports utilizing features such as data-driven subscriptions, parameters, expressions, and custom code, enhancing data analysis and decision-making processes. In-depth experience with SSRS for report authoring, management, delivery, and security; skilled in developing complex reports including Tabular, Matrix, Ad Hoc, and distributed reports to support diverse business needs. Expert in multidimensional and tabular data modeling using SQL Server Analysis Services (SSAS); proficient in MDX and DAX to craft insightful, performance-optimized analytical models. Skilled in leveraging Apache Hive and Power BI for big data analytics, integrate Hive with Power BI to perform advanced data querying and generate real-time business intelligence from Hadoop ecosystems. Experienced in integrating BigQuery with visualization tools like Google Data Studio and Tableau for advanced data reporting. Comprehensive experience in defining and managing referenced relationships in SSAS for building intricate data models that support complex, scalable analytics platforms. Highly skilled in full lifecycle application development: from requirement analysis and design to development, testing, and maintenance, ensuring the delivery of high-quality software solutions. Expertise in modern BI and data visualization tools such as Google Looker Studio and Power BI, designing intuitive and interactive dashboards that streamline insights and facilitate strategic decision-making across business units. Well-versed in the latest programming languages and technologies, including Python for data science, javascript for web development, continuous integration/continuous deployment (CI/CD) practices using Jenkins and Docker, enhancing productivity and ensuring the delivery of optimal solutions. Proven project management abilities in high-pressure environments,adept at steering cross- functional teams, delivering projects that meet rigorous performance standards & tight deadlines. Education: Bachelor of Technology in Computer Science Engineering, Osmania University, 2014 Technical Skills: Languages & Frameworks: SQL, Python, javascript, .NET, Java, Scala, powershell, Bash, R, C#, PHP, T-SQL, PL/SQL, HTML5, CSS3, React, Angular, Bootstrap, Node.js, Vue.js, JSP, vbscript, Visual Basic 6, ASP.NET, XML, UNIX shell scripting, Apache Hive, Hadoop. Databases & Management Tools: Relational Databases: Microsoft SQL Server (2005-2019), Oracle (9i to 19c), mysql, postgresql, nosql & Big Data: mongodb, Cosmos DB, Apache Cassandra, Redis, Tools & ides: MS Access, TOAD, SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio Code, SQL Profiler, Performance Monitor, DTS, Database Tuning Advisor BI & Visualization Tools: Power BI, IBM Cognos, SSRS, SSAS, SSIS, Google Looker Studio, SAP Business Objects, Qlik Sense, Qlikview, Visualization & Reporting: Tableau (Desktop & Server), Grafana, Crystal Reports, D3.js, Einstein Analytics, Excel Power View, MS Excel, Other Tools: Workday, Reader, Online, Adobe Analytics Cloud Platforms & Services: Microsoft Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP), Oracle Cloud, IBM Cloud, Salesforce Cloud, AWS Lambda, Azure Functions, Google App Engine, Kubernetes, Docker, Terraform Devops & Software Engineering Tools: Continuous Integration/Continuous Deployment: Jenkins, gitlab CI, circleci, Configuration Management: Ansible, Chef, Puppet, Version Control & Collaboration: Git, Mercurial, SVN, Azure devops, Bitbucket Project Management & Methodologies: JIRA, Agile Methodologies, Scrum, Waterfall, SDLC, Kanban, MS Project, TFS, Lean Six Sigma Machine Learning & AI Technologies: tensorflow, pytorch, Scikit-Learn, Keras, mxnet, Theano, Azure Machine Learning, AWS sagemaker, Google AI Platform Data Processing & Workflow Automation: Apache nifi, Apache Airflow, Luigi Additional Skills: OWASP, Secure Coding Practices, Ethical Hacking Basics, Networking & Protocols: TCP/IP, UDP, FTP, HTTP/S, SMTP, DNS Operating Systems: Linux (Red Hat, Ubuntu, centos), UNIX, Windows Server (2012/2008/2003) Professional Experience: Sr. Data Analyst BI Consultant | DTE Energy, Detroit, MI | Dec 2022 - Present Collaborated with Subject Matter Experts and Product Owners to define data requirements and establish source-to-target mapping for advanced analytics initiatives within the energy sector, focusing on optimizing operational eHiciency and enhancing customer service. Headed a diverse team in executing energy sector data analytics projects, fostering collaboration, and meeting organizational goals. Developed and integrated a comprehensive Data Warehouse, consolidating data from various systems including Salesforce and SAP, to facilitate holistic data analysis and decision-making. Enhanced Power BI reports with interactive features such as bookmarks, selection panes, and drill- through filters, alongside creating custom visualizations using the R programming language. Proficiently configured Hive ODBC drivers to establish seamless data connections between Apache Hive and Power BI, ensuring robust and eHicient data transfer mechanisms. Utilizing Cognos BI, with real-time insights, predictive analytics, and self-service reporting, rostering data-driven decisions that directly enhance student outcomes and educational excellence. Skilled in designing real-time dashboards and reports in Looker Studio, integrated eHectively with BigQuery to optimize data visualization and decision-making. Experienced in using SQL for advanced query development and data management in BigQuery, enhanced by creating insightful reports and dashboards in Looker Studio. Utilized Python-based machine learning algorithms to analyze diverse datasets, including multilingual text data, to extract valuable insights supporting strategic decision-making. Created analytical dashboards using Power BI, enabling quick insights for stakeholders to make data-driven decisions related to energy production, distribution, and customer service. Published and maintained workspaces in Power BI Service, ensuring timely data refresh schedules and eHicient management of applications and workbooks. Led the migration of legacy BI tools to Google Looker Studio, streamlining data analysis workflows and reducing report generation time by 40%. Utilized DAX functions and Power Queries to analyze and transform data for logical visualization, providing insights into energy consumption patterns and operational performance. Converted Excel-based data tables into Power BI, enhancing data visualization capabilities for improved understanding and decision-making within the organization. Analyzed plant data from various regions worldwide to assess energy production eHiciency and identify opportunities for cost reduction and process optimization. Conducted COPQ and DPPM analysis in Power BI, assisting quality leaders in making data-driven decisions to enhance operational eHiciency. Translated complex data requirements into comprehensive data maps and canonicals, ensuring streamlined data management processes. Identified supply chain problem areas and opportunities for service improvement through detailed data analysis and visualization techniques. Conducted Extract, Transform, Load (ETL) processes on multiple platforms including SAP HANA and Teradata, ensuring seamless integration of data into the Data Warehouse. Created and maintained applications and reports in Salesforce for customer issue resolution and CRM processes, utilizing SQL queries for interactive dashboards and data analysis. Established and managed a sharepoint page for Lean Six Sigma initiatives, employing Power Queries for data analysis and conducting project audits. Utilized BOXI (Business Objects) for generating reports for legacy systems, ensuring data accessibility and integrity across diverse platforms. Mapped data across diHerent systems and documented processes, facilitating eHective data management and resolution of operational issues. Conducted queries, maintenance, and data extraction from Teradata to support energy production and distribution operations. Environment: Power BI Desktop, Power BI Service Pro, Teradata, Salesforce, Einstein Analytics Studio, Business Objects, sharepoint, SAP HANA, Apache Hive, Hadoop, SAP Logon, qlikview, IBM Lotus Notes, SQL, SQL Server, MS Access, Microsoft OHice Suite (Word, powerpoint, Excel), Python, R, DAX, Apache Kafka, Azure Data Factory, tensorflow, pyspark, Google bigquery, Azure Synapse Analytics, Docker, Kubernetes. Power BI Developer | DXC Technology, Topeka, KS | Nov 2020 - Oct 2022 Actively participated in daily scrum meetings with the project team to discuss challenges and project development progress, ensuring alignment with project goals and timelines. Facilitated requirement gathering sessions with business users and IT teams to comprehensively understand and articulate business processes and logic for eHective project execution. Extracted data from various sources including SQL Server, SQL Server Analysis Services, Azure SQL Database, Azure SQL Data Warehouse, and Salesforce for reporting purposes, employing complex SQL statements and stored procedures. Developed visualizations and views in Tableau, including scatter plots, box plots, heatmaps, tree maps, and donut charts, to present data insights eHectively. Generated complex reports in Tableau utilizing features such as context filters, hierarchies, parameters, LOD Expressions, and time intelligence, enhancing data visualization and analysis capabilities. Built interactive and storytelling dashboards in Tableau workbooks using dashboard actions, ensuring seamless navigation and enhanced user engagement. Published Tableau workbooks on Tableau Server and managed report refresh schedules to ensure up-to-date data availability for stakeholders. Utilized Data Analysis Expressions (DAX) to create measures and calculated fields for data analysis in Tableau and Power BI, enhancing analytical capabilities. Developed & maintained Power BI reports with various visualizations, including line charts, doughnut charts, tables, matrix, kpis, scatter plots, and box plots, to provide quick insights to business users. Implemented storytelling features such as bookmarks, selection panes, and drill-through filters in Power BI reports to enhance interactivity and user engagement. Created and administered workspaces for each project on Power BI Service, publishing reports from Power BI Desktop to Power BI Services workspace for stakeholder access. Installed Data Gateway and configured schedule plans for Data Refresh of Power BI reports,ensuring data accuracy and timeliness. Developed SSIS packages for ETL processes, optimizing data integration workflows and maintaining performance for slowly running packages. Expert in writing optimized SQL queries in BigQuery, managing large datasets, and developing eHicient data schemas to support scalable analytics. Generated accurate financial reports on a daily, weekly, and monthly basis to support decision- making processes and ensure compliance with financial regulations. Evaluated returns and risks for various types of investments, including stocks, fixed-income assets, hedge funds, real estate, and commodities, while assessing risk tolerance for customers. Created ad-hoc reports such as YTD, YOY, MTD, MOM analysis for income statement and cash flow, addressing specific requests from business units. Implemented report integration among Power BI, Tableau, SSRS, and Python reports, ensuring seamless data sharing and accessibility across platforms. Environment: Power BI Desktop, Power BI Service, Project Online, SQL Server 2016/2017, SSRS, SSIS, SSAS, DAX, Tableau, Microsoft Azure, Python, sharepoint, Visual Studio, Scrum/Agile, BI Development Studio (BIDS), MDX, XML, SQL Profiler, TFS, MS OHice, Windows 10/7, Looker studio, Data Analyzer, Apache Kafka, tensorflow, Docker, Kubernetes, pyspark, Google bigquery, Azure Synapse Analytics. BI Developer | Wells Fargo, Charlotte, NC | Dec 2018 Oct 2020 Collaborated with cross-functional teams including client representatives, analytics professionals, data managers, QA specialists, and visualization experts to ensure seamless project execution and delivery, utilizing Agile methodologies throughout the project lifecycle. Led the development of data warehouses and data marts, aligning data structures with reporting needs to enhance data analysis capabilities using SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS). Created advanced SQL scripts and Tableau dashboards for dynamic reporting and analytics, connected to Azure SQL databases to streamline client reporting processes. Managed user access and permissions for Power BI dashboards, optimizing data sharing and security configurations to improve stakeholder engagement. Designed and executed complex DAX queries in Power BI to derive insights from large datasets, significantly enhancing data visualization and reporting accuracy. Provided comprehensive backend support for Power BI and Tableau reports, focusing on performance optimization and data integrity. Developed and maintained SSIS packages for eHicient data movement and transformation, incorporating Python scripting for loading data into Google bigquery via ELT processes. Executed proof of concept (POC) for advanced data movement solutions using Apache nifi (Hortonworks) and C# scripting within SSIS packages for API data integrations. Contributed to application migration projects in Azure, utilizing Azure Data Factory, Logic Apps, and Azure Functions to enhance application scalability and maintainability. Implemented, maintained, and refined PL/SQL scripts and database triggers for Oracle 11g databases, optimizing data processes and logic implementation. Established comprehensive databases and data warehousing solutions leveraging Azure SQL Data Warehouse, enhancing data accessibility and analytics capabilities. Environment: Power BI, SQL Server 2012/2016, Azure, Google Big Query, Tableau, Excel, MS SQL Server 2016/2014/2012, SSIS, SSRS, SSAS, SSMS, Oracle 11g. Data Analyst | Inspire Innovations LTD, Hyderabad, India | Jan 2017- Feb 2018 Developed and optimized SSIS packages, overseeing deployment in development and QA environments to ensure robust data integration. Translated business requirements into technical specifications for ETL processes, enhancing system performance and data processing capabilities in Azure. Utilized advanced T-SQL features to design and optimize interfaces for Azure and other applications, ensuring eHicient data processing and integration. Designed and executed ETL packages to manage data across various sources, including SQL Server and flat files, using SQL Server Integration Services (SSIS). Collaborated closely with business units to onboard and integrate bulk claims data, assessing and retrofitting legacy systems to new technologies. Enhanced data architecture using Azure Data Lake, Azure Data Factory, and SQL Data Warehouse, significantly improving data handling and storage solutions. Created and managed OLAP and OLTP structures on MS Analysis Server (SSAS) in Tabular Model, utilizing MDX and DAX queries for deep data analysis. Developed comprehensive Power BI reports and dashboards from multiple data sources, embedding reports eHiciently on sharepoint portals. Environment: Microsoft Visual Studio 2016, SQL Server, Azure, Power BI, Power Pivot, SAS EG, Teradata,SQL assistant. Data Analyst | Big Buz Solutions | Hyderabad, India | June 2014 - Dec 2016 Translated business objectives into analytical frameworks, developing databases to support performance improvement projects across multiple departments. Executed complex data queries and used SQL and Excel (pivot tables, VLOOKUP) for data compilation and transformation, enhancing data-driven decision-making processes. Utilized Tableau to create insightful visualizations for trend analysis, pattern identification, and competitor analysis, improving market strategy development. Conducted detailed budget forecasts and analyses, generating ad-hoc reports to aid management in strategic planning and decision-making. Applied regression analysis and forecasting techniques in Tableau to predict sales trends, achieving a 20% increase in sales through enhanced market intelligence. Environment: SQL Server 2014, MySQL, Microsoft Excel, Tableau Desktop, Analytics, SQL, Python,Data Visualization, Regression Analysis, Forecasting, Pivot Tables, VLOOKUP Keywords: csharp continuous integration continuous deployment quality analyst artificial intelligence javascript business intelligence database active directory rlang information technology microsoft procedural language Kansas Michigan North Carolina