Summary
Overview
Work History
Education
Skills
Certification
Timeline
Projects
Generic

Ravneet Kaur

Houston,TX

Summary

Data Analyst with 7+ years of experience delivering actionable insights through SQL and Power BI across real estate and finance domains. Strong background in data modeling, reporting, dashboard development, and trend analysis, with a proven ability to communicate insights to stakeholders, and support strategic decision-making.

Overview

9
9
years of professional experience
2
2
Certifications

Work History

Data Analyst (BI & Analytics) (Remote)

Tanget45LLC
Chicago, IL
07.2023 - Current
  • Designed and maintained Power BI dashboards and reports, supporting operational and executive decision-making across real estate domains.
  • Collaborated with business stakeholders and data teams to gather reporting
    requirements and translate them into clear, actionable visualizations.
  • Built robust unit availability and occupancy dashboards, integrating property details, area sizes, move-ins, move-outs, and vacancy status to improve tracking and forecasting.
  • Designed trend analysis visualizations to identify market behavior patterns and
    enable data-backed business decisions.
  • Created custom calculated columns and measures using DAX to enhance reporting flexibility and enable dynamic, user-driven analysis in Power BI.
  • Utilized SQL Server (SSMS) and T-SQL to write complex queries and stored procedures for extracting, cleaning, and transforming data from multiple source systems.
  • Engineered advanced T-SQL solutions using CTEs, window functions, temp tables, and dynamic SQL to aggregate and prepare high-volume real estate and financial data for reporting.
  • Supported project tracking and performance metrics through standardized Power BI dashboards and automated reporting workflows.
  • Automated recurring reporting processes, reducing manual effort by approximately 30% and improving overall team efficiency.
  • Leveraged SSRS to deliver scheduled and ad-hoc reports for both technical and nontechnical stakeholders.
  • Performed data validation,reconciliation, and QA checks to ensure accuracy, consistency, and reliability of BI reports and dashboards.
  • Supported troubleshooting and resolution of data quality and performance issues by investigating source data and reporting logic.
  • Assisted in migrating legacy Excel-based reports into centralized Power BI
    dashboards, improving accessibility, consistency, and version control.
  • Worked closely with data engineering teams to optimize data models and queries, reducing dashboard load times by over 40%.

Data Analyst (BI & Reporting)

Emerson Information Technology Solutions
07.2017 - 11.2022
  • Over 5 years of programming experience as an Oracle Business Intelligence Developer in Analysis, Design and Implementation of Business Applications using the Oracle EBS.
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Created monthly, quarterly, and annual GL,AP,AR,FA reports using SQL for management review.
  • Leveraged analytics tools such as Tableau , Power BI, Noetix to prepare user friendly reports , dashboards.
  • Utilized Microsoft Excel and Power Query to perform data cleansing, transformation, and reconciliation across multiple data sources, supporting accurate reporting, adhoc analysis, and business decision-making.
  • Participation in requirement gathering and translating business needs to technical specifications.
  • Developed and maintained comprehensive SQL reports for management review.
  • Involvement in creating functional and technical requirement specification documents with the help of business users and maintaining them.
  • Develop and execute reports, fix bugs in any existing solutions, optimize and enhance the code, document processes, and generate required metadata.
  • Develop database objects like Stored procedures, functions, and packages in Oracle 11g and 12c in SQL and PLSQL using tools like TOAD, SQL Developer, SQL server, SSMS and then use them for creating BI reports /dashboards using edge applications such as POWERBI.
  • Designed, built, and optimized end-to-end data pipelines using T-SQL, Power BI, and SSIS to extract, transform, and load (ETL) data into centralized reporting environments.
  • To regularly monitor BI reports, check their performance, and tune them when performance degrades by analyzing trace files as a part of the system health check process.
  • To troubleshoot the data issues in BI solutions, such as Noetix , POWER/BI reports, and conduct unit testing while creating new solutions.
  • Coordinate with different teams to provide an efficient solution (existing or new) to business users, as per their requirements.
  • Contributes throughout project life cycles, from planning to production implementation, including the creation of functional designs, technical designs, and test plans for repository models and hierarchies.
  • Work closely with the team lead and manager to analyze the problem and propose its related solution in a timely manner in an agile environment. Attending Daily scrum meetings to discuss the issues and progress made on current projects/assignments and update the DEVOPS accordingly.
  • Created documents for user manuals, installation instructions, and troubleshooting procedures.
  • Led knowledge transfer sessions for new team members on BI tools and best practices
  • Involvement in creating functional and technical requirement specification documents with the help of business users and maintaining them.

Education

MBA - INTERNATIONAL BUSINESS AND MARKETING

Punjab University
Chandigarh
05-2021

Bachelor of Science - Computer Science And Programming

Punjabi University
Patiala
05-2017

Skills

  • Data & Querying: SQL, T-SQL, PL/SQL
  • BI & Visualization: Power BI, DAX, Tableau, SSRS, Noetix (Magnitude Angles)
  • Databases & Tools: SQL Server (SSMS), Oracle
  • Other Tools: ServiceNow, DevOps, Serena Business Manager

Certification

Microsoft Certified POWER BI data analyst associate(PL300)

Timeline

Data Analyst (BI & Analytics) (Remote)

Tanget45LLC
07.2023 - Current

Data Analyst (BI & Reporting)

Emerson Information Technology Solutions
07.2017 - 11.2022

Bachelor of Science - Computer Science And Programming

Punjabi University

MBA - INTERNATIONAL BUSINESS AND MARKETING

Punjab University

Projects

Real Estate Data Modernization & Power BI Migration :-

  • Migrated legacy Excel-based reports to interactive Power BI dashboards for a real estate client, improving data accessibility and reporting efficiency by 50%.
  • Built optimized data models and implemented DAX measures for occupancy, lease expirations, and rental trends.
  • Integrated Row level security to ensure user-specific data access across regions.

Creation of reports, POWER BI dashboards for newly set up Business Units:-

  • Understanding requirements from business and developed views using SQL which were further used for data extraction purposes
  • Created Finance reports such as Trial Balance reports, FA reports, Account analysis reports and other GL reports and dashboards using reporting tools as Noetix, POWER BI for business .
  • Worked with Business Units to understand their requirements for reporting and guiding them with best available solutions in BI applications which would suit them.
  • Developed interactive dashboards tracking subscriptions created by users, usage of internal reporting tools, and ServiceNow ticket trends for management visibility.

R12 upgrade:-

  • Upgrading BI Applications such as Noetix to R12
  • Making all the views, reports compatible to R12 by modifying underlying code. • Worked on fixing invalid objects present in database by either deleting them or fixing them as per R12 standards.
  • Created project plan, upgraded Noetix views and other objects , performed sanity checks on edge Applications after upgrade, worked on project issues logged after upgrade such as performance issues

Improve Performance of BI reports and dashboards:-

  • Identifying all the programs , dashboards and reports which are long running and tuning them either by modifying the code or by applying hints or through optimizer

Agile methodology:-

  • Attending agile training , acquiring SAF-e agilist certifications , attending/leading Scrum meetings,attending PI planning events.