Hello World. नमस्ते

I'm Varun Shiralkar.

Data Analyst Business Analyst


More About Me

About

Let me introduce myself.

Profile Picture

Originally from Nagpur, India, I am a recent graduate with a Master of Science in Business Analytics and have accrued nearly two years of experience in data migration, analytics, and management. I also possess a solid understanding of fundamental IT concepts and security principles. I am dedicated to delivering impactful solutions through my knowledge.

Skills

Work Experience

Analyst

Sept 2022 - May 2023

Working as a Data Engineer on a data migration project transitioning from Hadoop to AWS Cloud for an insurance company, I worked on various tasks, including collaborating in the development of architectural diagrams for migrating historical client data and playing a key role in the successful migration of 719 tables to Redshift external tables. I conducted in-depth data analysis and comparison of these tables between on-premises data sources and AWS environments, ensuring accuracy and preventing data discrepancies. I also crafted SQL queries to facilitate data insertion and table updates, while configuring AWS Glue job settings to optimize worker nodes and types, resulting in a 7% increase in processing efficiency and reducing job runtime by 2.8 minutes. Additionally, I provided technical support for debugging and testing Glue job code, reducing errors by 8% and improving overall job reliability.

Intern Analyst

Sept 2021 - Sept 2022

As a Data Engineer on a data migration project from DB2 to AWS Cloud for a financial services client, I engaged in a variety of activities. I analyzed various DB2 mining documents and collaborated on creating architectural diagrams for data migration to the AWS cloud. During this time, I developed CloudFormation templates for various AWS services and constructed 10 SQL queries for Aurora DB, which established the groundwork for enhanced data management and integration. Additionally, I provided technical support for data migration scripts and played a key role in data loading from DB2 to S3 in Qlik, which improved operational efficiency by 10%. I also utilized the Splunk tool for visualizing data from AWS logs.

Education

MSc Business Analytics

Sept 2023 - Sept 2024

Grade: 1.1 (First Class Honours)

My MSc in Business Analytics at University College Cork taught me advanced analytics, focusing on predictive and prescriptive techniques, data visualization, and cloud computing. The program emphasized practical application through group projects and independent research, sharpening my project management skills. The group capstone project involved developing a machine learning model and database using Python and SQL to predict loan defaults and assess credit risk. We further integrated Power BI dashboards to enhance financial management and provide detailed business insights.

BE Computer Technology

Juy 2017 - July 2021

CGPA: 7.11 (First Class)

My Bachelor of Engineering in Computer Technology from Yeshwantrao Chavan College of Engineering focused on key skills like software development, network infrastructure, and database management. The program stressed practical learning through projects that combined theory with real-world applications, equipping me with a solid foundation in the essential technical and practical aspects of computer technology. The group capstone project involved creating a machine learning application in Python designed to identify writers from their handwriting.

Check Out Some of My Works.

Contact

I'd Love To Hear From You.

Your message was sent, thank you!
Address

Dublin 15
Dublin, Ireland

Email Me At

vrshiralkar@gmail.com

Call Me At

India: +91 9373418047
Ireland: +353 0892138640