A

Avantika Modi

Product Engineer

India8 mos experience

Key Highlights

  • Strong background in software engineering and data analytics.
  • Proven ability to develop dashboards and automate reporting.
  • Experience with compliance and regulatory projects in fintech.
Stackforce AI infers this person is a Data Analyst with strong software engineering skills in Fintech and SaaS industries.

Contact

Skills

Core Skills

Data AnalysisSqlSoftware EngineeringPythonJavaDatabase Management System (dbms)Go

Other Skills

SnowflakeAirflowAzure DatabricksMicrosoft OfficeMicrosoft Power BIPython (Programming Language)Large Language Models (LLM)Django REST FrameworkTestingLoggingPlxFlumePiperRulezDashboarding

About

Avantika is a quick learner with a strong mix of software engineering and data analytics experience.

Experience

8 mos
Total Experience
8 mos
Average Tenure
--
Current Experience

Swiggy

Analytics Engineering Intern

Nov 2023May 2024 · 6 mos · Bengaluru, Karnataka, India · Hybrid

SnowflakeSQLAirflowAzure DatabricksMicrosoft OfficeMicrosoft Power BI+2

Belzabar software design india private limited

Software Engineer Intern

Sep 2023Nov 2023 · 2 mos · Delhi, India

Large Language Models (LLM)Django REST FrameworkPython (Programming Language)TestingLoggingSoftware Engineering+1

Google

2 roles

Software Engineer Intern

May 2023Jul 2023 · 2 mos · Hyderabad, Telangana, India · On-site

  • Worked as a part of FOPs Cards - Global Cards IN (Google Payments) team.
  • 1. Implemented Cleanup Out of Compliance Cards Backfill, a critical component of the card storage code yellow project, ensuring compliance with RBI regulations.
  • 2. Implemented a comprehensive dashboard and alerting system, providing timely detection of issues related to regulated cards and triggering alerts to the team when predefined thresholds were breached.
  • 3. Authored comprehensive and detailed documentation for the project, facilitating launch, ease of maintenance and future enhancements.
PlxFlumeDatabase Management System (DBMS)PiperRulezJava+1

Software STEP Intern

May 2022Jul 2022 · 2 mos · Bangalore, India

  • Worked as a part of the Collection and Ingestion of Data Team of Chronicle - Google Cloud Security
  • 1. Parser Release Cadence: Designed ways to automate parser releases to customers in a fixed schedule.
  • 2. Tests: Implemented tests to ensure that only directories that require fixed schedule updates are affected.
  • 3. Tests: Implemented tests to ensure that an emergency update can be released without being bound by fixed cadence.
  • 4. Freeze Dates Configuration: Built configuration to ensure that all the other non-release days are frozen.
Go (Programming Language)RegexGeneral Configuration Language (GCL)Protocol BuffersNested Configuration Language (NCL)Software Engineering+1

Urban company

Marketing Analytics Intern

Jul 2022Mar 2023 · 8 mos · Gurgaon, India

  • Worked as a part of the UC Marketing Analytics Team.
  • 1. Developed end-to-end funnel from scratch for a newly launched painting category, identifying key drop-off points to drive user engagement and increase conversion rates.
  • 2. Designed queries for dashboard to track user behavior in the install-to-signup-to-first-order funnel for the Middle East Market, including the no. of days between each event, resulting in improved insights into user acquisition and retention.
  • 3. Automated daily performance KPIs such as installs, spends, traffic funnel, user state at the category, device and country levels for the Middle East and Singapore, resulting in streamlined data processing and improved insights.
  • 4. Streamlined data tracking processes by developing Python scripts for automatic updates, resulting in saved manual effort.
  • 5. Developed Jarvis dashboards with KPIs at test/control group cut to monitor the impact of pricing experiments in real-time, resulting in improvement in category performance (Salon, EPC, AC).
  • 6. Extracted and analyzed unique user-traffic and conversion data source-wise to identify priority categories to display on Home Screen, resulting in improvement in user-engagement and revenue.
  • 7. Extracted SKU-level data to identify and segregate single and multiple SKU bookings, resulting in improved insights into customer behavior and product popularity.
  • 8. Created and optimized queries to find society-level loyalists.
  • 9. Successfully closed over 100 requests for data and dashboards and collaborated with 40 individuals including stakeholders, category leaders and team members, ensuring timely delivery of critical information and analysis.
  • 10. Created a data dictionary of the tables within the database and documenting the most important queries used for analysis, validation, and reporting.
  • 11. Designed queries to extract data for churn prediction model and recommendation model.
  • 12. Worked 40+ hours per week while being a full-time student.
DashboardingApache SupersetJarvisPython (Programming Language)SQLSnowflake+2

Squadstack

Business Intelligence Analyst Intern

Sep 2021Feb 2022 · 5 mos · Noida, Uttar Pradesh, India

  • Worked as a part of the FinTech Pod.
  • 1. Performance Monitoring: Built performance monitoring dashboards for newly launched product features (Whatsapp integration, On-call SMS Trigger), their adoption rate, and effects using SQL and Metabase. Built operations dashboard to monitor CSAT and NPS.
  • 2. Lead Prioritization Model: Created text analysis python script to funnelise customers for specialized customer support resulting in an increase in conversion.
  • 3. Optimisation: Extracted actionable insights using data to optimize the lead conversion percentage in the SquadIQ team.
  • Optimized already existing SQLs and dashboards to reduce their loading time by 50%.
  • 4. Fraud-Detection: Worked extensively on fraud-detection of users on SquadIQ application which includes creating alerts to find duplicate users, automatic banning/unbanning of fraudulents, and so on.
  • 5. Knowledge Training: Gave KT Sessions to Supply Analysts, Business Operation Analysts on basic SQL and dashboarding to reduce dependency and increase their efficiency.
  • 6. Root Cause Analysis: Performed root cause analysis on SQLs not producing expected outputs and underlying database issues.
  • Worked 40+ hrs a week while being a full-time student.
Data AnalysisDashboardingRegexPython (Programming Language)MetaBaseSQL

Talentsprint

Google WE Cohort - 3 Scholar

Apr 2021Dec 2021 · 8 mos

Equinox, iiit lucknow

Volunteer

Jan 2021Jan 2022 · 1 yr

Education

Indian Institute of Information Technology Lucknow

Bachelor of Technology - BTech — Computer Science and Artificial Intelligence

Dec 2020Jun 2024

Abhinav Bharati High School

Standard XII — CBSE

St. Helen's School

Standard X — ICSE

Stackforce found 100+ more professionals with Data Analysis & Sql

Explore similar profiles based on matching skills and experience