Mohsin Rao

Experienced Senior Data Warehouse Consultant with over 11 years of expertise in data integration, ETL development, and Business Intelligence (BI) solutions. Proven ability to design, optimize, and implement scalable data warehousing solutions, ensuring data accuracy, integrity, and efficiency. Adept at leveraging ETL tools, SQL, Python, and BI platforms to transform raw data into actionable insights.

Passionate about streamlining business operations through advanced analytics, reporting, and visualization.

ETL Developer at Meraki Global Consulting (2024-03 – Present)

• Designed and managed ETL workflows for Oracle Utilities Analytics (OUA), ensuring data consistency and quality.
• Extracted, transformed, and loaded Oracle Customer to Meter (C2M) data into enterprise data warehouses.
• Developed BI Publisher reports, including billing and reconciliation reports, to enhance financial accuracy and business transparency.
• Partnered with crossfunctional teams to align BI solutions with business objectives.

ETL and SQL Developer at GCS Pvt. Ltd. (2020-01 – 2024-02)

• Led data warehouse architecture and ETL pipeline development for Bus Rapid Transit System (BRTS) in Karachi.
• Specialized in Pentaho CTools, including Community Dashboard Editor (CDE), CDF, CDA, and CCC for BI solutions.
• Built realtime dashboards using XMLHttpRequest for revenue tracking, ticket analysis, and route performance.
• Implemented data extraction, transformation, and loading (ETL) processes, ensuring high data integrity and scalability.
• Developed optimized SQL queries for improved data aggregation and performance tuning.
• Automated data pipelines, reducing manual intervention and improving operational efficiency.

Business Intelligence Specialist at Infotech Group Ltd. (2016-02 – 2019-12)

• Designed and deployed BI Publisher reports for Oracle Utility Products (Customer Care and Billing System).
• Conducted requirement analysis and developed reporting solutions for ADNOC Abu Dhabi.
• Reverseengineered QlikView applications, restructured database schemas, and developed star schema models.
• Developed interactive reports using RStudio, R Markdown, and Shiny.
• Built custom web scraping tools in .Net C and JSP/Servlets for dynamic content generation.

Senior Business Intelligence Consultant at AbbuSys Ltd. (2010-11 – 2016-01)

• Implemented Oracle OBIEE BI Apps for SiebelCRM and EBS (HR & Financial modules).
• Designed and developed complex BI Publisher reports, integrating scheduling and bursting functionalities.
• Developed ETL solutions using Informatica and Oracle Data Integrator (ODI).
• Designed and optimized SQL queries to improve ETL efficiency and reporting performance.
• Led training sessions on BI tools including Informatica, ODI, and SQL, mentoring junior team members.

Bachelor of Engineering (BE) in Computer Engineering – Quaid-e-Awam University of Engineering, Sciences, and Technology Nawabshah (2005-01 – 2009-05)