Data Analytics North Carolina

Aadit Gurvinder Bagga

Charlotte, NC **********@*****.*** LinkedIn +1-980-***-****

EDUCATION

The University of North Carolina at Charlotte, Charlotte, NC Aug 2022 - May 2024 Master of Science in Computer Science

Coursework: Big Data Analytics, Visual Analytics, Information Visualization, Machine Learning, Database Systems, Intelligent Systems Pune University, Pune, Maharashtra Jul 2018 - May 2022 Bachelor of Engineering in Computer Science

Coursework: Advanced Data Structures, Discrete Mathematics, Object Oriented Programming, Web Technology, Data Analytics, High Performance Computing, Data Mining & Warehousing, Artificial Intelligence & Robotics, Business Intelligence, Human Computer Interface WORK EXPERIENCE

Software Developer Intern (Remote) – Antra LLC Virginia, USA Jul 2024 - Present

Developed a blog app using React.js, Redux, React Router, and RESTful APIs to manage application state and seamless navigation, resulting in a 30% improvement in user engagement. Integrated Axios for efficient data fetching from a MongoDB backend, optimizing data retrieval and reducing load times by 20%.

Implemented responsive design with CSS3 and SCSS, ensuring compatibility across mobile, tablet, and desktop, which led to a 40% increase in mobile users. Utilized Babel for JavaScript transpilation and ESLint for maintaining code quality.

Conducted thorough testing with Jest and Cypress, achieving 95% code coverage, while using GitHub for version control, enhancing collaboration, and reducing 25% code errors through continuous code reviews and best practices. Data Analyst (Project) – Carolina Hurricanes & University of North Carolina at Charlotte, USA Feb 2024 - Apr 2024

Conducted in-depth analysis of season ticket sales data using SQL and Excel, uncovering trends that informed pricing adjustments and optimized ticket mix strategies, resulting in a 15% projected increase in overall sales revenue.

Designed and deployed interactive dashboards in Tableau and Streamlit to visualize customer engagement patterns and seating preferences, enhancing data-driven decision-making, and increasing pre-season ticket sales by 20%.

Collaborated with a team to develop a 3-year ticket sales strategy, incorporating insights from Python-based models and to improve fan diversity, introduce premium seating experiences for the renovated stadium, and ensure a balanced distribution between single-game and season ticket sales. Business Analyst – Maharashtra Electronics Corporation Pune, India Mar 2021 - Apr 2022

Designed and developed interactive dashboards in Tableau, visualizing key metrics like monthly sales trends, product demand, and warehouse utilization, leading to a 20% increase in operational efficiency.

Utilized SQL to extract and query sales and inventory data from databases, providing actionable insights that boosted revenue by 10% through targeted promotions on high-demand products.

Monitored website traffic and user behavior through Google Analytics, correlating online and offline sales data to optimize marketing strategies, resulting in a 12% growth in sales from digital channels.

Streamlined sales and inventory analysis by utilizing Power Query for data cleaning and transformation, and advanced formulas like INDEX- MATCH, IFERROR, and SUMIFS, reducing manual effort by 30% and enhancing decision-making with accurate, real-time insights. Database Management Intern (Remote) – Expert’s Global Noida, India Jun 2020 - Aug 2020

Managed the company’s website using WordPress, posting GMAT questions and optimizing content with SEO techniques, resulting in a 40% increase in webpage visibility and top search engine rankings for key terms.

Utilized Microsoft Excel tools like pivot tables, VLOOKUP, and HLOOKUP to analyze and organize college data, and created interactive Tableau dashboards for student and college profiles, improving data accessibility and decision-making by 20%. Business Development Manager – AIESEC in India Pune, India Jan 2020 - Feb 2021

Organized 5 major events, including Youth Talks, Youth Speak Forum, Balakalakaar, Global Village, and MUN, engaging over 1,000 attendees, while achieving a 30% increase in attendance through targeted digital marketing strategies using LinkedIn and Instagram.

Led a team of 5, enhancing their expertise in sales, sponsorship acquisition, and event management, while maintaining strong relationships with partners, resulting in a 20% increase in recurring sponsorship agreements.

Leveraged tools like Google Workspace, Slack, ZoomInfo, and Canva for event tracking, collaboration, and promotional material creation, while employing deal-closing techniques, persuasive communication, and budgeting strategies to drive 80% of annual event revenue. Secured sponsorships during the COVID-19 pandemic, becoming the only member in AIESEC Pune to raise funds, covering operational costs, office rent, and fees, ensuring the organization's continuity.

Utilized Microsoft Excel to manage sales data, create interactive dashboards showcasing attendee engagement for sponsors, and perform data analysis using advanced features like VLOOKUP, HLOOKUP, pivot tables, and advanced formulas, resulting in a 20% increase in sponsor retention and satisfaction through enhanced transparency and insights. ACADEMIC PROJECTS

Ecommerce Application using MERN

Developed a full-featured role-based access control (Admin/User) e-commerce platform using the MERN stack with auth using JWT.

Implemented key e-commerce functionalities, including add-to-cart, filters to show relevant products, admin controls, similar product recommendations, and integrated a payment gateway for seamless transactions.

Built modular backend architecture with separate controllers for efficient management of product filtering, pagination, and user data. Personal Budget Application using React

Created and deployed a single-page website on DigitalOcean for personal budget tracking. Utilized React, Node.js, and MongoDB showcasing advanced programming skills and creativity in website design.

Executed a comprehensive backend solution utilizing MongoDB as a robust NoSQL database to securely manage user data, leading to an improvement in data accessibility and integrity.

SKILLS

Languages: Python, SQL, HTML5, JavaScript, Typescript, CSS3, Java, C/C++

Libraries and Frameworks: React, NodeJS, Redux, Express.js, Flask, NumPy, TensorFlow, PyTorch and Pandas, Matplotlib, Keras, Streamlit

Databases: MongoDB, MySQL, PostgreSQL, NoSQL, S3

Tools and Platforms: Microsoft Excel, Snowflake, Tableau, GitHub, Android Studio, Docker, GitHub, Visual Studio, AWS, Digital Ocean

Contact this candidate