Ombir Rathee Email & Phone Number

Gurugram, Haryana, India

• Responsibilities:
• Develop and maintain interactive Tableau dashboards to visualize key business metrics and trends for Cisco sales leaders and improving data-driven decision-making
• Write complex SQL queries to extract, transform and load large datasets from multiple sources for reporting and analysis
• Perform data modeling and create backend datasets, ensuring high performance and scalability in data analysis workflows.
• Optimized heavy Hana Sql views and queries by reducing memory usage down to 80%
• Develop automated ETL workflows using Python, SQL and Tableau Prep ensuring seamless data integration and minimizing manual intervention.

Gurugram, Haryana, India

Gurgaon, India

Worked for Cisco as a Client

Gurgaon, India

• Responsibilities:
• Designed and developed end to end interactive Tableau dashboards that enabled decision makers to take action.
• Migrated existing Cognos reports to Tableau Dashboards with actionable and insightful data analytics.
• Optimized Tableau extracts and data sources to improve dashboard performance, reducing load times and ensuring timely data refreshes
• Connected Dashboards with disparate data sources such as SQL Server, Hadoop and Excel.
• Developed and maintained custom VBA applications and macros to automate repetitive tasks which led to the reduction in 80% of resource time.

Noida Area, India

Role: Reporting Analyst/VBA Developer1. Developed VBA/VFP code to Schedule candidates for various exams to their convenient location and as per client requirement using Google API Distance Matrix.2. Developed Tableau Dashboards for Educational Boards.3. Performed various analysis on data such as Trend analysis, ranking analysis, Comparison.