Summary
Overview
Work History
Education
Skills
Timeline
Generic
Kishore Kumar Kolipaka

Kishore Kumar Kolipaka

Northlake,TX

Summary

Data Engineer with over 10 years of experience in Data Modeling, Designing and implementing solutions for complex business challenges. Proficient in leveraging AWS technologies to architect and manage data pipelines, transforming raw data into actionable insights. Seeking to contribute my expertise in data engineering at a dynamic organization to drive innovation, optimize data models, and deliver high-impact solutions for business growth.

Overview

10
10
years of professional experience

Work History

Sr Data Engineer

Amazon.Inc
04.2022 - Current
  • Subject Matter Expert (SME) for AWS AI services: Amazon Bedrock, Amazon Fraud Detector, Amazon Monitron, Amazon Kendra, Amazon Comprehend, Amazon Omics.
  • Built Data lake for AWS AI usage and billing data using S3, AWS Glue, Spark, Typescript, DynamoDB, Labmda, Cloudformation, Lakeformation, CDK, Python, Redshift etc.
  • Built ETL and reporting pipelines for Daily and Weekly Business reports using Python, CDK, AWS Glue, Redshift and DynamoDB, enabling AWS AI leadership to make data-driven decisions.
  • Created a framework called "AWS AI true customer adoption ratio" which focuses on proportional rate of customer adoption for a service in comparison to the growth of potential customers for the respective service in the market.
  • Created Dashboards in Quicksight for DBS BI Services, providing crucial metrics like T4WK Revenue, Net Revenue, Gross Revenue, CWGR, WoW%, Usage, Attached Rate, Annualized Run Rate.
  • Created a CDK package using Python, DynamoDB and Typescript which handles source data onboarding, creation of AWS Glue ETL jobs, executions of ETL jobs and reporting jobs.

Data Engineer II

Amazon.Inc
10.2018 - 04.2022
  • Designed Relational Data Model for Alexa Comms Recommendations pipeline based on clickstream data related to Alexa Mobile, Alexa devices etc.
  • Implemented BI metrics for various Alexa Comms launches (e.g., UK Vodafone integration, Skype calling, Photo sharing, Kid-Kid Comms, Recommendations cards).
  • Integrated data from three significant data warehouses (Alexa Comms BI, Alexa BI, Alexa Mobilytics) to generate Comms datasets for ML teams and Service teams which is used for A/B testing. feature analysis and providing Alexa Comms feature recommendations to customers.
  • Led migration of Alexa Comms BI Data warehouse from one AWS account to another, ensuring GDPR compliance, HIPPA compliance and data deletion using Python package and DynamoDB.

Data Engineer

Amazon.Inc
02.2015 - 05.2018
  • Designed and implemented Amazon's Unified Sub Ledger BI Data Model using EMR, EDX, Redshift, Hive, and OBIEE.
  • Successfully built a reconciliation platform which reconciles shipment data with sub-ledger data, reducing manual effort for accounting teams by 12-16 hours
  • Migrated OBIEE reporting from Oracle to Redshift, improving performance and scalability which involves migration of Oracle SQL / PLSQL code to Redshift ETLs.
  • Led the migration of USLBI Data Warehouse from Oracle to Redshift, including data extraction, transformation, and loading using Hive on EMR in a Python package.

ETL Developer

GGK TECH
07.2013 - 02.2015
  • Designed and developed an ETL pipeline using clickstream data to assess customer interest across diverse travel campaigns. The pipeline identifies the top five campaigns with a high probability of engaging customers. The platform team leverages this data to send personalized recommendations to customers for the corresponding travel campaigns.
  • Created new ETL pipelines using Informatica ETL tool, performance tuning of existing Informatica workflows, Oracle SQLs, production support for BI pipelines etc.

Education

Bachelor of Technology - Computer Science and Engineering

Indian Institute of Technology
India
04.2013

Skills

  • Programming and scripting Languages: Python, Shell scripting
  • ETL and Reporting Tools: Informatica, OBIEE, Tableau
  • Libraries and Tools: My SQL Workbench/J, SQL Developer, WinSCP, PUTTY, TOAD
  • Big Data and AWS Technologies: EMR, Hive, Spark, S3, EC2, Redshift, Athena, Spectrum
  • Operating Systems: Windows, Linux, Android
  • Databases: SQL Server, Oracle, Redshift, DynamoDB
  • AWS Technologies: Lambda, Lake formation, Sage maker, S3, EC2, EMR, Redshift, Athena

Timeline

Sr Data Engineer

Amazon.Inc
04.2022 - Current

Data Engineer II

Amazon.Inc
10.2018 - 04.2022

Data Engineer

Amazon.Inc
02.2015 - 05.2018

ETL Developer

GGK TECH
07.2013 - 02.2015

Bachelor of Technology - Computer Science and Engineering

Indian Institute of Technology

Similar Profiles

CREATE PROFILE
Kishore Kumar Kolipaka