Keerthan Vantakala, Developer in San Diego, CA, United States
Keerthan is available for hire
Hire Keerthan

Keerthan Vantakala

Verified Expert  in Engineering

Bio

Keerthan is an accomplished data professional with over seven years of experience building end-to-end data platforms, leading teams on complex projects, and driving the uplift of analytics capabilities for several clients. Keerthan has been consulting/contracting for the last three years and has built the initial data infrastructure (data pipelines, data warehouse/database design, reports, APIs, and more) for over 20 companies.

Portfolio

Vant Data
SQL, Amazon QuickSight, Amazon Web Services (AWS), Python, AWS Glue, AWS Lambda...
Startup building SaaS for CPG companies
Amazon RDS, AWS Glue, Amazon S3 (AWS S3), AWS Lambda, Data Engineering...
CPG Client
SAP, Python, Python 3, Microsoft Power BI, Data Engineering, Big Data...

Experience

  • Python - 7 years
  • SQL - 7 years
  • Amazon Web Services (AWS) - 7 years
  • Tableau - 7 years
  • Cloud - 7 years
  • Databases - 7 years
  • Analytics - 7 years
  • ETL - 7 years

Availability

Part-time

Preferred Environment

Python, SQL, Amazon Web Services (AWS), ETL, Tableau, Amazon QuickSight, PostgreSQL, PySpark, Data Visualization, Azure

The most amazing...

...thing I've done is start an analytics enterprise SaaS company for chemical manufacturers—from fundraising, sales, and hiring to building the app.

Work Experience

Principal Analytics Consultant

2020 - PRESENT
Vant Data
  • Architected the data infrastructure to help increase a chemical manufacturing client's profits by optimizing pricing strategies.
  • Created the analytics stack and dashboards to measure key metrics, including customer acquisition cost (CAC), lifetime value (LTV), and average revenue per user (ARPU) for a SaaS chatbot startup.
  • Designed and developed custom data integrations in Python for an insurance aggregator.
  • Built the initial infrastructure and the team to drive analytics capabilities at a fintech startup.
  • Worked as a big data engineering contractor at BCG within the retail catalyst team to build and monitor the data pipelines that loaded retail client (CPG) data into PostgreSQL and Google BigQuery.
Technologies: SQL, Amazon QuickSight, Amazon Web Services (AWS), Python, AWS Glue, AWS Lambda, GraphQL, REST APIs, Tableau, Microsoft Power BI, Databricks, Data Engineering, Data Architecture, Data Warehouse Design, SQL Server 2016, SQL Server 2008, Data Visualization, Microsoft Power Apps, ETL Development, ETL Implementation & Design, ETL Testing, ETL Tools, Big Data, Spark, Spark SQL, Amazon EC2, API Gateways, Cloud, Analytics, PostgreSQL, Consulting, Google BigQuery, IT Consulting, Microsoft SQL Server, Data Pipelines, Data Modeling, Leadership, Pandas, APIs, AWS Step Functions, Electronic Health Records (EHR), Electronic Medical Records (EMR), Azure Data Factory (ADF), Private Equity, Investment Funds, Accounting, Risk Management, Modeling, Snowflake, Looker

Database and Data Integration Engineer

2023 - 2023
Startup building SaaS for CPG companies
  • Designed and implemented an SQL database tailored to meet precise business requirements, ensuring efficient data storage and retrieval while maintaining data accuracy and integrity.
  • Developed Python scripts to extract and transform data from diverse APIs, facilitating the populating of the database with up-to-date information.
  • Automated data integration procedures by leveraging Amazon Glue, enabling the scheduling and execution of Python code at hourly intervals for real-time data freshness.
  • Designed and constructed an Amazon QuickSight dashboard to visualize market conditions for cannabis retailers in Florida, enhancing data-driven decision-making and providing valuable insights for informed reporting.
Technologies: Amazon RDS, AWS Glue, Amazon S3 (AWS S3), AWS Lambda, Data Engineering, Cloud Architecture, GitHub, Git, Database Design, Data Pipelines, Data Modeling, Pandas, APIs, Modeling

Senior Data Engineer

2022 - 2023
CPG Client
  • Designed and implemented a customized sales and operations planning program for Beyond Meat Jerky, enhancing production efficiency and sales forecasting accuracy.
  • Developed and deployed multiple predictive models by integrating raw data from various sources, including sales data, manufacturing data, sales assumptions, and marketing events.
  • Collaborated with cross-functional teams to collect, clean, and preprocess data, ensuring the accuracy and reliability of input for the predictive models.
  • Conducted data analysis to identify trends, patterns, and outliers, allowing for data-driven decision-making in production planning and sales strategies.
Technologies: SAP, Python, Python 3, Microsoft Power BI, Data Engineering, Big Data, Databricks, Azure Databricks, Microsoft Excel, Supply Chain Operations, Pandas, APIs, Azure Data Factory (ADF), Risk Management, Modeling

Senior Software Engineer

2021 - 2023
Raccord
  • Designed and implemented the data model, forming the core structure for the company's operations.
  • Developed REST APIs leveraging AWS API Gateway and Lambda functions to enable efficient data interactions.
  • Managed and maintained data pipelines extracting data from diverse sources, including client-provided Excel models, OM's, and third-party vendors.
Technologies: Liquibase, Agile, Python 3, Python, AWS Glue, AWS Lambda, Amazon RDS, Cloud, Data Engineering, Data Modeling, REST APIs, Amazon API Gateway, PostgreSQL, Amazon S3 (AWS S3), Pandas, APIs, Investment Funds

Senior BI Engineer

2021 - 2022
Juvare
  • Spearheaded a critical project to facilitate the efficient distribution of COVID-19 vaccines across Illinois, collaborating closely with diverse stakeholders with unique requirements and business objectives.
  • Translated stakeholder needs into meaningful key performance indicators (KPIs) to drive actionable insights, aligning technical and business requirements.
  • Designed and developed interactive, user-friendly dashboards using AWS QuickSight, providing decision-makers and stakeholders with real-time data-driven insights.
Technologies: Amazon QuickSight, Amazon RDS, SQL, Python 3, Python, Data Visualization, Business Intelligence (BI)

Business Intelligence Engineer

2020 - 2022
Chat Bot Startup
  • Leveraged Amazon Quicksight's capabilities to create user-friendly, interactive, and visually compelling dashboards that catered to specific business needs.
  • Collaborated with cross-functional teams to ensure the alignment of dashboards with the unique requirements of each department, resulting in highly tailored and effective data visualization solutions.
  • Improved and updated dashboards to adapt to evolving business objectives and data sources, ensuring their ongoing relevance and effectiveness.
  • Created data-driven dashboards by harnessing web analytics data, enabling the calculation and visualization of critical app usage metrics. These insights were instrumental in optimizing operational and marketing strategies.
  • Crafted a comprehensive financial dashboard highlighting key SaaS KPIs such as CAC, LTV, MRR, MUV, and more. This financial tool facilitated data-driven decision-making and provided essential support for strategic financial planning.
  • Engineered dynamic sales dashboards that offered real-time visibility into sales metrics and predictive analytics. These dashboards significantly contributed to enhancing lead management and accurately forecasting future revenue streams.
Technologies: Amazon QuickSight, Amazon RDS, Redshift, Python 3, Python, SQL, Amazon S3 (AWS S3), Data Pipelines, Data Modeling, Pandas, APIs

Data Engineering Architect

2020 - 2022
Boutique Consulting Firm
  • Led the design and implementation of a robust data infrastructure to support the processing and analysis of diverse data sources, enabling data-driven pricing recommendations for chemical manufacturers.
  • Spearheaded the development of a database tailored to Master Data Management (MDM) initiatives, ensuring the consistency and accuracy of critical data assets and enhancing the efficiency of strategic planning and growth strategy projects.
  • Collaborated with cross-functional teams to understand the unique data requirements of chemical manufacturers, translating business needs into scalable data solutions that facilitated accurate pricing recommendations and strategic decision-making.
Technologies: Python 3, Python, SQL, Microsoft Excel, SAP, Microsoft SQL Server, Data Architecture, Data Engineering, Data Pipelines, Data Modeling, Pandas, APIs

Founder | CEO

2018 - 2020
6C Solutions
  • Participated in the Iowa Startup Accelerator program and raised $320,000 in pre-seed angel capital.
  • Developed a SaaS platform enabling real-time analytics and machine learning capabilities for chemical plants. Used Django, TimescaleDB, Plotly Dash, and REST APIs on DigitalOcean.
  • Designed and developed data pipelines to gather data from IoT devices. Used Apache NiFi for streaming data from plants to a data lake and leveraged Airflow for analytics pipelines.
  • Drove business development and sales efforts to close deals with pilot customers. Efforts included cold calls, product demos and pitches, client relationship management, and all customer-facing activities.
Technologies: Sales, SQL, Vue, ETL, Python, Microsoft Power BI, REST APIs, GraphQL, Cloud, Amazon Web Services (AWS), Analytics, PostgreSQL, Amazon EC2, Data Pipelines, Data Modeling, Leadership, Pandas, APIs, Accounting

Big Data Engineering

2019 - 2019
BCG
  • Designed and implemented data pipelines for loading retail client (CPG) data into PostgreSQL and Google BigQuery, ensuring data accuracy and timely delivery.
  • Spearheaded the creation of data pipelines that performed complex calculations to generate crucial market share, sales, profitability metrics, and other CPG Key Performance Indicators (KPIs).
  • Collaborated with cross-functional teams to understand business requirements and translated them into efficient data transformation and calculation processes, ensuring alignment with organizational goals.
  • Actively participated in troubleshooting and resolving technical issues related to data pipelines, ensuring minimal disruptions to data flow and analytics.
Technologies: Python 3, Python, Tableau, Analytics, Google BigQuery, BigQuery, Git, GitHub, Jira, Agile, Big Data, Data Engineering, SQL, PostgreSQL, ETL, ETL Development, Data Pipelines, Pandas, APIs

Senior Data Analyst

2016 - 2018
Conversant (Acquired by Epsilon)
  • Implemented and oversaw the Airflow use within the analytics operations team to centralize analytics code scheduling and enable remote management.
  • Conceptualized and pitched an audience creation platform to improve efficiency over prior methods. Gained stakeholder buy-in and led project planning and a four-member development team using Python and Airflow.
  • Built a Python monitoring platform that enables business stakeholders to quickly set up alerts based on real-time data.
Technologies: SQL, Hadoop, Python, Apache Airflow, Cloud, Analytics, PostgreSQL, Amazon EC2, Data Pipelines, Pandas, APIs

Junior Associate

2015 - 2016
Mu Sigma
  • Leveraged client's Hadoop big data platform to extract valuable insights and generated automated reports on customer behavior, sales, and website efficiency using clickstream data.
  • Analyzed employee data and built classification models in R to find the root cause of employee absenteeism.
  • Used predictive analytics techniques to forecast the number of checked bags per flight to distribute weight evenly across the aircraft.
  • Integrated the Mu Sigma founders' track program for high-potential employees, which distinguishes 1% of top consultants, in my 1st year.
Technologies: Linear Regression, SQL, Python, R, Spotfire, Tableau, Sales, Consulting, Hadoop, Cloud, Analytics, PostgreSQL, Data Pipelines, APIs

Experience

Analytics Platform for Chemical Manufacturing

An enterprise SaaS platform providing real-time analytics and machine learning capabilities for chemical plants. I helped develop the platform using Django, TimescaleDB, Plotly Dash, and REST APIs. I was also involved in developing the 2nd version of the app using Vue, GraphQL, PostgreSQL, Apache NiFi, Airflow, and Auth0 on AWS.

Data Infrastructure for a Prop Tech Startup

A project that targeted the design and development of the entire back-end infrastructure for a property technology startup.

The infrastructure was created on AWS leveraging Amazon S3, AWS Lambda functions, Amazon Relational Database Service (RDS), Amazon API Gateway, and Python. It took data from various data sources, such as flat files, third-party APIs, and manual data, then loaded it into a staging area in Amazon S3 before loading it into a normalized database. REST APIs were built on top of the database using AWS API Gateway and AWS Lambda functions.

Audience Builder for Digital Marketing

I created and pitched the concept for an audience creation platform to improve efficiency over prior methods, securing stakeholder support. As project lead with a four-member team, we utilized Python and Airflow for development. The platform's implementation led to a remarkable 20x efficiency boost, earning me the prestigious Conversant Go Big Award—a quarterly recognition among 2,000 employees.

Education

2011 - 2015

Bachelor's Degree in Chemical Engineering

University of Illinois - Champaign, IL, USA

Skills

Libraries/APIs

Pandas, PySpark, REST APIs, Vue, Liquibase

Tools

Tableau, Microsoft Power BI, Apache Airflow, Spotfire, BigQuery, AWS Step Functions, Amazon QuickSight, AWS Glue, Plotly, Microsoft Power Apps, Spark SQL, Git, GitHub, Jira, Microsoft Excel, Looker

Languages

SQL, Python, R, GraphQL, Python 3, Snowflake

Paradigms

ETL, ETL Implementation & Design, Agile, Management, Database Design, Business Intelligence (BI)

Platforms

AWS Lambda, Amazon EC2, Amazon Web Services (AWS), Databricks, Azure

Storage

PostgreSQL, Microsoft SQL Server, Data Pipelines, Databases, SQL Server 2016, SQL Server 2008, Master Data Management (MDM), SQL Server DBA, Redshift, Amazon S3 (AWS S3)

Frameworks

Hadoop, Django, Spark

Industry Expertise

Accounting

Other

Cloud, Sales, Consulting, Data Visualization, Data Engineering, Data Architecture, Data Warehouse Design, Data Modeling, APIs, Modeling, Linear Regression, Leadership, Azure Data Factory (ADF), Analytics, Amazon RDS, API Gateways, ETL Development, ETL Testing, ETL Tools, Big Data, Google BigQuery, IT Consulting, SAP, Big Data Architecture, Cloud Architecture, Amazon API Gateway, Azure Databricks, Supply Chain Operations, Electronic Health Records (EHR), Electronic Medical Records (EMR), Private Equity, Investment Funds, Risk Management

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring