Ritu Gulia

As a Data Analyst, I have applied my knowledge and skills in data science and analytics to various projects and domains, such as transport, healthcare, and software development. I have a Master's degree in Data Science and Analytics from Brunel University London, where I learned to use various tools and techniques, such as QGIS, Python, SQL, and Power BI, to collect, clean, manipulate, and visualize data.

My most recent experience was at Transport for London, where I conducted a 100% audit of the bus lane data and designed a data dictionary report using Redshift and Power BI. I also validated the cycle model outputs using the vivacity SPL count line. Previously, I worked at HecoAnalytics Limited, where I developed algorithms and data models to mine and analyze clinical data using Python and sequence analysis.

I also developed a simple user interface and generated reports for the client. I am highly motivated, problem-solving, and solution-oriented, and I seek a challenging and career-advancing position as a data analyst to implement and enhance my data analysis skills and contribute to the data-driven decision-making process.

Mar 2023 – Aug 2023 Data Analyst Transport for London (TFL)

• Conducted a 100% virtual audit of the current Bus Lane Database and subsequently all 4,220km of bus routes to ensure all bus lanes have been captured to the desired specification and captured any bus lane not represented within the BLD. Additionally, the associated metadata was also captured using Google Street View and Traffic Regulation Orders in the London Gazette. (Using QGIS)
• Designed a dictionary structure using tables in Redshift and Developed a Data Dictionary report to share information on the datasets that TFL manage and supports. (Using Power BI) 
• Validated the cycle model outputs using the vivacity SPL Count Line (data from sensors all over London), where the data was imported to RStudio for cleaning, manipulating, and analyzing, and produced a final solution with a model presenting a comparison between the Cycle model output and Vivacity Countline data. Other applications, such as SQL and MapInfo, were also used for data extraction, transformation and loading.

 

Aug 2022 – Feb 2023 Junior Data Analyst Brunel Talent Marketplace (Heco Analytics) 

• Imported/Collected, cleaned, converted, and analysed the big data to uncover insights, patterns, and draw conclusions.
• Manipulated the data to facilitate the application of the apriori (or similar) approach for mining clinical pathways within the provided data, utilizing Python and R.
• Conducted quantitative analysis of patient data and constructed Data Models to derive meaningful insights from clinical data.
• Created an algorithmic solution (code) to implement sequence analysis/apriori algorithm, and organized the results into comprehensive reports for HecoAnalytics.
• Adapted the developed algorithms for usage across different time frames, locations (e.g., healthcare facilities), and specific patient groupings (segments).
• Designed a user-friendly interface allowing users to conveniently select different segments for analysis.
• Produced detailed reports containing the implemented code along with succinct summaries of the key findings.

Sept 21 – Sept 22 MSc Data Science and Analytics (Final grade A-,2.1) Brunel University London

Key modules

• Quantitative Data Analysis (B+)
• Machine Learning (A+)
• High-Performance Computational Infrastructure(B)
• Data Visualization (B)
• Distributed Data Analysis (A)
• Research Project Management (A)
• Dissertation (A+)

Final year dissertation - In-depth piece of research work based on Road Accident Analysis and Prediction using Machine Learning (In the process of being published).

Aug 18 – Aug 21 Bachelor’s in Computer Application (Cloud Computing) (Final grade A+) SGT University, Gurugram,Haryana

Key modules

• Artificial Intelligence (A+)
• Operating System (A*)
• Advanced Relational Database Management (SQL)
• Computer Networks (A+)
• Data Warehouse (A+)
• Database Management System (SQL) (A*)
• Software Engineering (A*)
• IoT Application Development (A+) 
• Advanced Microsoft Excel with IBM (A*)

Final year project – Developed Online Examination Website using Python.

“Achieved academic success at the top rank (1) and received a gold medal at the convocation in May 2022.”