Rahul Nair

Experience

• 

  Compass Group

  Aug 2017 - May 2018

  Graduate Student - Analyst

  Interacted with stakeholders daily to gather and capture the food-order requirements efficiently and accuratelyMaintained regular reporting of the inventory and tracked the food stock levels efficiently in MS ExcelIdentified factors that influenced the client’s order placement and forecasted demand patterns based on historical data to make recommendations to stock level changes

• 

  Data Axle

  Sept 2018 - Feb 2019

  Business Analyst

  Collaborated with key stakeholders in brainstorming sessions, requirement workshops to gather and translate user requirements into usable functional specifications for the ETL development team Developed high-level architecture diagram, ETL mapping and data dictionary documents for the project team to capture the data flow between on-premises and AWS cloud environmentAssisted the development team in performing data profiling and data quality assessments and wrote custom SQL queries to build reports for the project team Show less

• 

  NextEra Energy Resources

  Jun 2019 - Dec 2020

  Business Intelligence Analyst

  Developed, deployed and automated SSIS ETL packages to extract data from disparate data sources and loaded the transformed data into dimension and fact tables housed in SQL Server DbCreated SQL views, stored procedures combining and merging large datasets and improved the underlying query performance reducing the report rendering time Developed T-SQL scripts, CTE queries and leveraged Power Bi power query capabilities to transform and format the raw source data into clean, consistent actionable datasetsCreated custom measures, business critical KPIs, calculated columns and visual charts using DAX to compute complex business logic and visualize the insights effectivelyDesigned highly interactive advanced Power Bi report views using decomposition visual charts, bookmarks, buttons and drill-through functionalities for effective communication and visual storytellingBuilt interactive Power Bi reports on COVID-19 dataset for executives to analyze the active cases, hospitalizations, deaths, fatality rate and the possible impact on NEE facilities Designed interactive actionable reports for tropical storm season and hurricane events to deal with customer outages and significantly reduced the time taken to restore the customers by more than 20% Developed custom paginated reports for the emergency preparedness team to deal with customer outages during tropical storm across FPL substationsDeveloped data dictionary and data mapping documents to capture the flow from source system to the target SQL server destination tablesCreated SIPOC, data flow and UML Diagrams in Confluence to visualize the ETL load process from SFTP source to dimension and Fact tablesExecuted the windows PowerShell scripts to simulate 200 concurrent users accessing the report and analyzed the load testing results using SQL Server Profiler Show less

• 

  Episcopal Communities & Services

  Feb 2021 - Dec 2021

  Power BI Developer

  • Collaborated with the Director of IT and VP to design and implement a comprehensive COVID-19 Analytics dashboard in Power BI• Engineered a range of key powerful metrics to track and monitor covid positive seniors in Power BI and built forecasting models to predict future transmissions, enhancing strategic planning• Assumed administrative responsibilities like managing workspaces, controlling access and sharing permissions, assigning Power BI licenses, and configuring dataset gateway and refresh schedule• Achieved a significant reduction in transmission rates by over 40% through active, near-real-time data reporting Show less

• 

  Sentara Health

  Apr 2021 - Jun 2021

  Business Intelligence Consultant

  Developed multiple ETL packages and processes in a multi-server environment. Performed complex transformations and cleaning required to clean the data for the Tableau team and end-usersSuccessfully developed and deployed complex ETL packages into testing and PROD environment.Developed Complex SQL scripts, Views and Stored procedures to encapsulate the logic

• 

  Verstand AI

  Jun 2021 - Aug 2023

  Business Intelligence Engineer

  • Facilitated high-level meetings with senior executives and upper management to capture intricate business requirements for data modeling and financial reporting• Devised complex SQL sub-queries and CTEs to build large-scale datasets and transform data for accurate and efficient reporting • Applied dimensional modeling techniques to design and implement star schema and snowflake schema models, enabling seamless data exploration and improving report performance.• Developed multiple highly intuitive Power BI reports with sophisticated visualizations using buttons, bookmarks, and drill-through features, thereby visualizing key departmental and business unit performance to stakeholders• Designed advanced incremental refresh on multiple fact tables significantly improving report rendering and dataset refresh times • Enhanced the efficiency of Power BI reports by optimizing slow-performing queries, resulting in a performance improvement of over 65%• Developed dynamic SSIS ETL packages for transformations and data warehousing operations• Implemented advanced LookML expressions to create tailored dimensions and measures in view files, equipping business users with the ability to delve deeper into intricate financial data • Developed dynamic user-defined and LookML interactive dashboards leveraging liquid variables and adding drill-down and drill-through features to effectively visualize and monitor E-commerce KPIs • Optimized Looker dashboards by implementing PDTs and defining Datagroups with dynamic caching policies resulting in significant performance improvement of over 65% • Wrote complex LookML scripts and logic to build data models in Looker to analyze drug-dispensing datasets• Integrated HTML & CSS components to build highly interactive and advanced LookML dashboards, enhancing user navigation experience with crosslinking and multi-page filtering features Show less

• 

  NextEra Energy Resources

  Sept 2023 - now

  Business Intelligence Engineer at Nextera Energy Inc.