Rohan Thomas Email & Phone Number

Bengaluru, Ka, In

Melbourne, Victoria, Australia

• Extracted Json documents from GitHub using API and Python.• Performed data wrangling steps on source data and stored in MongoDB and Neo4j databases.• Validated and visualized the database accuracy using SQL test cases in Python.• Modelled and visualized the datasets in Power BI dashboards to share with stakeholders.

Bengaluru, Karnataka, India

• Analysed and re-engineered existing SQL queries to streamline and improve the efficiency of data retrieval by 15%.• As part of feature engineering, developed new data marts using ETL workflows to improve the data granularity.• Through ETL pipelines and SQL, modelled Type-1 and Type-2 Slowly Changing Dimension tables using Informatica and Oracle DB to capture the historical changes in data.• Reverse analyzed the data lineage of ETL workflows and designed the technical specification… Show more • Analysed and re-engineered existing SQL queries to streamline and improve the efficiency of data retrieval by 15%.• As part of feature engineering, developed new data marts using ETL workflows to improve the data granularity.• Through ETL pipelines and SQL, modelled Type-1 and Type-2 Slowly Changing Dimension tables using Informatica and Oracle DB to capture the historical changes in data.• Reverse analyzed the data lineage of ETL workflows and designed the technical specification documents for SMEs and data architects in Paris to streamline the process using Shell Scripting, SQL and Informatica.• Implemented performance tuning steps at ETL and database level, like parallel processing and table partitioning to improve processing times.• Created Power BI dashboards to visualize the KPIs and SLAs of $20.5B trading market data of various regions, like NA, EMIR and APAC.• Mentored newcomers on data processes and best practices, fostering a culture of CI/CD data pipeline management. Show less

Bengaluru, Karnataka, India

• Engaged with stakeholders from USA to discuss project requirements and timelines, design technical and non-technical documentation, and brainstorm alternate methods during technical roadblocks.• Led a 3-member team to develop POC's and streamline ETL workflows, achieving 20% increased throughput, and cutting manual intervention by one-third.• Implemented Star and Snowflake schemas in ETL processes and Power BI data modelling to extract relevant business information.• Extracted… Show more • Engaged with stakeholders from USA to discuss project requirements and timelines, design technical and non-technical documentation, and brainstorm alternate methods during technical roadblocks.• Led a 3-member team to develop POC's and streamline ETL workflows, achieving 20% increased throughput, and cutting manual intervention by one-third.• Implemented Star and Snowflake schemas in ETL processes and Power BI data modelling to extract relevant business information.• Extracted data from various formats, like, txt, csv, and xml files, and various sources like APIs, AWS, Big Data and Informatica servers to create new fact and dimension tables (data marts) for data warehouses.• Streamlined SQL queries using CTE and window functions to improve efficiency by 15%.• Implemented data governance steps like encrypting sensitive information, handling ETL errors through notifications, and providing right user access to Informatica servers to ensure data integrity & security.• Designed several Power BI dashboards to provide insights into customer Ad preferences across various regions in the US, derive viewership trends of 6.5M subscribed customers, and optimize $15B worth of operations. Show less

Master Of Science - Ms, Data Science, 5.9

Bachelor Of Engineering - Be, Computer Science