VIVEK KUMAR GUPTA
North Lakes,Australia
Summary
Detail-oriented and dedicated aspiring Data Scientist/Analyst with a proven track record in automating processes, offering technical support, and optimizing data management. Known for excellent communication and interpersonal skills, fostering effective teamwork. Passionate about applying mathematical and statistical concepts through programming expertise to drive data-driven insights and solutions.
Overview
13
13
years of professional experience
Work History
Machine Learning Intern
Queensland Government
02.2024 - 11.2024
- Successfully completed a Machine Learning Capstone Project titled "Probabilistic Gradient Boosting Machine Emulation of Rainfall Runoff Simulations for Great Barrier Reef Catchments" to aid environmental policy and planning.
- Designed and implemented predictive models using machine learning algorithms to simulate rainfall runoff scenarios and support critical decision-making for the Great Barrier Reef catchments.
- Improved model accuracy by leveraging feature engineering techniques and testing advanced algorithms like CATBoost, XGBoost and LightGBM to refine predictive performance.
- Conducted hyperparameter tuning, significantly reducing model training time and enhancing computational efficiency.
- Authored a comprehensive thesis detailing project objectives, methodologies, findings, and implications, which was submitted as part of university requirements.
- Presented project results and insights to stakeholders, effectively communicating complex concepts in an accessible manner.
- Developed a strong understanding of environmental data applications and reinforced skills in problem-solving, data analysis, and collaborative research
Data Science Intern
Flight Centre Travel Group
06.2024 - 07.2024
- Worked on a project titled Product-Channel Optimization, focusing on improving the effectiveness of media and marketing strategies.
- Used Databricks and AzureML (Azure AutoML) to build and analyze models for Media-Market Mix Optimization using synthetic data.
- Created and processed synthetic datasets using AI algorithms to meet project requirements.
- Developed clear and impactful data visualizations to present insights to stakeholders.
- Managed code using Git and GitHub, ensuring collaboration and version control.
- Documented project progress, findings, and methodologies using Confluence for team reference.
- Used Jira to track tasks and manage project schedules.
- Applied Python and PySpark to build, test, and optimize data processing workflows.
Data Analyst
Income Tax Department
04.2017 - 01.2023
- Developed comprehensive Power BI reports and dashboards using SQL Stored Procedures for financial reporting, enhancing data visualization
- Devised revenue-boosting strategies, facilitated TDS growth recovery, and spearheaded arrear demand recovery, offering critical data analysis for CBDT's policy formulation
- Refined data-warehousing and data mining initiatives to counteract tax avoidance and evasion, effectively mitigating tax risks.
Business Analyst
Amdocs
03.2014 - 10.2015
- Automated the Business Process Tables through Shell Scripting and PL/SQL, ensuring efficient operations
- Worked on ordering and billing within the Enterprise Product Catalog for Amdocs, optimizing product management
- Provided technical support for clients, including Vodafone (India), Telekomsel (Indonesia), Singtel (Singapore), Optus (Australia), and Bell (Canada), streamlining integrated relationship reporting and information systems
- Revamped SQL scripting for Bell, Canada, improving data processing
- Organized requirements meetings to comprehend business needs and swiftly troubleshoot errors
- Design, Developed and Implemented automation for Business Process Tables using Shell Scripting and PL/SQL with Cursors and Triggers, enhancing operational efficiency, and minimizing manual interventions
- Served as consultant for clients on training, product evolution, requirement gathering and scoping efforts at various offshore locations while also refining integrated relationship reporting and information systems to promptly identify and resolve business-critical issues
- Utilized a combination of Microsoft Excel, Macros, and SQL to extract actionable insights from data and identify meaningful patterns, facilitating informed decision-making
- Provided mentorship to newly on boarded team members on Business Process Tables (BPT) and Billing and Enterprise Product Catalog (EPC), optimizing product management processes within the telecommunications sector
- Conducted thorough research, delivered presentations to stakeholders, and documented business processes and operational procedures for diverse clientele
Data Analyst
Infosys Limited
09.2011 - 03.2014
- Played a pivotal role in managing migration and monitoring schedules while addressing performance issues
- Worked on developing, implementing, analyzing, and reporting in MS SQL Server leveraging Business Intelligence tools such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
- Generated various types of reports utilizing relational data warehouses and OLAP, with a focus on data visualization and analysis using Power BI and optimizing SSIS packages, SSRS reports, and T-SQL queries using tools like SQL Profiler, Performance Monitor, and Database Engine Tuning Advisor
- Involved in building Power BI Dashboards with Tabular and Multi-Dimensional Models, designing and modelling data sets based on customer requirements and dashboard needs, including data extraction, transformation, and loading using Power Query and SSIS
- Experienced in writing and modifying Stored Procedures in T-SQL, performing DAX and MDX functions for calculation and measure creation in Tabular and Multi-Dimensional Cubes, and utilizing SSIS for ETL package development and unit-testing
- Developing and Optimizing PL/SQL, SQL Scripting using SQL Server and Shell Scripting using Linux
- Collaborated on the AT&T project SBCFRST, conducting in-depth root-cause analysis, refining troubleshooting procedures to improve system support and facilitating clear communication between support teams and end-users
Education
Master of Science - Data Science
The University of Queensland
Saint Lucia, QLD11.2024
Bachelor of Science - Software Engineering
Harcourt Butler Technological Institute
Kanpur, India07.2011
Skills
- Critical thinking, Learning and Adaptability skills
- Teamwork
- Programming in Python and Java
- Deep Learning Models like CNN, ANN and ResNet50
- Feature Engineering
- Exploratory Data Analysis
- Supervised Techniques
- Unsupervised Techniques
- Excel
- Tableau and Power BI
- Keras, Scikit-learn, Seaborn
- PySpark
- Machine Learning Modelling including Random Forest, SVM
- XGBoost, LightGBM, CATBoost
- PL/SQL including Cursors, Triggers and Transact SQL
- VBA Macros
- Shell Scripting
- Econometrics
- Numerical Linear Algebra and Optimisation
References
- Rimon Rony, Data Science Lead, Flight Centre Travel Group, 0433918246, rimon.rony@flightcentre.com
- Dr. Frederick Bennett, Senior Scientist, Science Division, Department of Environment, Science and Innovation, Queensland Government, 0490031204, frederick.bennett@des.qld.gov.au
Leadershipandvolunteerexperience
- Collaborated with 'Save the Children,' a foundation dedicated to fostering a healthier future for children, contributing to the noble cause.
- Engaged with 'CybageAsha' - Charitable Trust, the philanthropic arm of Cybage Softwares Pvt Ltd, whose motto is 'spreading smiles across miles'.
- Contributed to the activities of Ecology Club during schooling years.
- Inspired individuals to contribute to blood donation initiatives through active participation as a committed blood donor in various drives.
- Led the college cricket team to the semi-finals in the inter-college tournament.
- Served as a member of the hospitality committee of INCORD - 2009.
Timeline
Data Science Intern
Flight Centre Travel Group
06.2024 - 07.2024
Machine Learning Intern
Queensland Government
02.2024 - 11.2024
Data Analyst
Income Tax Department
04.2017 - 01.2023
Business Analyst
Amdocs
03.2014 - 10.2015
Data Analyst
Infosys Limited
09.2011 - 03.2014
Master of Science - Data Science
The University of Queensland
Bachelor of Science - Software Engineering
Harcourt Butler Technological Institute
Similar Profiles
Kate ArmstrongKate Armstrong
Quality Control Grants Compliance Officer at Queensland GovernmentQuality Control Grants Compliance Officer at Queensland Government
Tamara SmithTamara Smith
Queensland Rural Fire Service at Queensland GovernmentQueensland Rural Fire Service at Queensland Government
Kylie ArlottKylie Arlott
SWIM Advisor at Queensland GovernmentSWIM Advisor at Queensland Government