Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Awards
Generic
RAKESH RAUSHAN

RAKESH RAUSHAN

Dubai

Summary

Results-driven Data Analyst and BI Developer with over 9 years of expertise in Power BI, SAP BO, SQL, ETL workflows, and data modeling. Proven success in banking, governance analytics, procurement, and construction sectors through the delivery of impactful dashboards, data integration solutions, and performance optimization strategies. Proficient in migrating legacy reporting systems to Power BI, establishing enterprise-grade reporting frameworks, and empowering stakeholders through self-service analytics training. Recognized for reducing report delivery times by up to 50%, maintaining 99.9% system uptime, and fostering data-informed decision-making across various industries.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Analyst

DICETEK LLC
05.2022 - Current
  • Client: ADCB (Abu Dhabi Commercial Bank) | Domain: Banking
  • Technologies: SAP BO 4.2, Power BI Desktop, Report Builder, Oracle 19c, SQL Server
  • Developed and automated over 60+ interactive dashboards and reports using Power BI, SAP BO WebI, and Crystal Reports, improving report delivery efficiency by 30%.
  • Designed complex SQL and PL/SQL queries across Oracle 19c and SQL Server databases, optimizing data retrieval time by 25% and ensuring seamless integration with reporting tools.
  • Migrated 40%+ of legacy Crystal Reports to Power BI, enhancing visualization quality and enabling centralized access via Power BI Service and Report Builder.
  • Revamped report deployment through scripting and centralized scheduling, leading to analysts saving 16 hours weekly; freed up resources for better data deep dives and improved client insights.
  • Influenced 24/7 production support and resolved report-related issues, achieving 99.9% uptime and ensuring consistent client satisfaction within the banking domain (ADCB, Dubai).

Associate

INSTITUTIONAL SHAREHOLDER SERVICES INDIA PVT. LTD.
03.2020 - 04.2022
  • Domain: Governance Analytics
  • Technologies: SAP BO 4.0, Oracle 11g, SQL Server, Unix
  • Spearheaded the development and maintenance of 70+ complex reports and dashboards using SAP BO (WebI, Crystal Reports) and Oracle PL/SQL, reducing reporting errors by 40% through optimized logic and query tuning.
  • Pioneered high-frequency report generation and distribution (60,000+ daily publications during peak), ensuring 99.5% on-time delivery and minimizing manual effort across projects.
  • Enhanced system performance by reducing report runtime by 50% for a critical dashboard consisting of 10 sub-reports, leveraging Oracle hints and query optimization techniques.
  • Delivered real-time production support and defect resolution, earning client appreciation and internal recognition for minimizing production downtime and ensuring 100% SLA compliance.
  • Migrated and scheduled reports across environments using SAP BO Central Management Console, while implementing event-based scheduling, improving scheduling accuracy by 35%.

System Engineer

TATA CONSULTANCY SERVICES (TCS)
07.2016 - 03.2020
  • Client: Tata Capital Ltd.
  • Domain: Banking & Finance
  • Technologies: SAP BO 4.0, SAP BODS 4.2, Oracle 11g, Unix
  • Developed and deployed 50+ end-to-end ETL jobs using SAP BODS 4.2 and complex WebI/Crystal reports in SAP BO 4.0, enhancing reporting efficiency and contributing to a 90% reduction in job execution time for critical processes.
  • Engineered and simplified daily batch processing for data ingestion from core systems (TCS BaNCS, SAP, LOS, Finnone), improving data accuracy and enabling real-time business reporting across the EDW.
  • Optimized performance of production jobs and batch processes by eliminating database-level bottlenecks through advanced BODS techniques, reducing failures by 40% and ensuring 99.9% uptime.
  • Delivered multilingual Crystal Reports and dashboards for Tata Capital’s financial operations, supporting stakeholder decision-making across 5+ business units.
  • Received 2 “On the Spot” Awards and “Star of the Month” recognition for defect-free report delivery and immediate resolution of high-impact production issues, ensuring 100% SLA adherence.

Education

Bachelor of Technology (B.Tech) - Electrical, Electronics & Communication Engineering

Techno India College of Technology

Skills

  • Power BI data visualization expertise
  • Experience with SAP Business Objects reporting tools
  • SAP BODS expertise
  • Oracle SQL development
  • SQL Server reporting
  • ETL Design & Data Integration
  • Data modeling expertise
  • Query performance tuning
  • Report Automation & Scheduling (CMC)
  • Dynamic reporting and visualization
  • Production support expertise
  • Event-based & Job Scheduling
  • Unix Shell Scripting for Automation
  • Governance and finance proficiency

Accomplishments

On the Spot Award

Team Lead | December 2018 | Tata Consultancy Services Ltd.

Achievement: Recognized for achieving a 90% performance improvement in a key SAP BODS job, enhancing ETL processing efficiency and reducing overall data load time.

Star of the Month

Team Lead | November 2017 | Tata Consultancy Services Ltd.

Achievement: Awarded for delivering 53 complex WebI reports within 15 days with zero defects, demonstrating exceptional report development skills and precision under tight deadlines.

On the Spot Award

Team Member | March 2017 | Tata Consultancy Services Ltd.

Achievement: Honored for optimizing a critical PL/SQL procedure by 80%, improving database performance and meeting a high-priority business requirement.

Certification

  • Generative AI Mastermind – Outskill | LinkedIn
  • Completed a comprehensive program on Generative AI applications and strategies under the mentorship of Vaibhav Sisinity, Founder of GrowthSchool.

Timeline

Analyst

DICETEK LLC
05.2022 - Current

Associate

INSTITUTIONAL SHAREHOLDER SERVICES INDIA PVT. LTD.
03.2020 - 04.2022

System Engineer

TATA CONSULTANCY SERVICES (TCS)
07.2016 - 03.2020

Bachelor of Technology (B.Tech) - Electrical, Electronics & Communication Engineering

Techno India College of Technology

Awards

On the Spot Award, Team Lead | December 2018 | Tata Consultancy Services Ltd., Achievement: Recognized for achieving a 90% performance improvement in a key SAP BODS job, enhancing ETL processing efficiency and reducing overall data load time., Star of the Month, Team Lead | November 2017 | Tata Consultancy Services Ltd., Achievement: Awarded for delivering 53 complex WebI reports within 15 days with zero defects, demonstrating exceptional report development skills and precision under tight deadlines., On the Spot Award, Team Member | March 2017 | Tata Consultancy Services Ltd., Achievement: Honored for optimizing a critical PL/SQL procedure by 80%, improving database performance and meeting a high-priority business requirement.
RAKESH RAUSHAN