Ankit Shah
Data Warehouse Engineer 4 at TrueCar, Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Hindi Full professional proficiency
-
Gujarati Native or bilingual proficiency
Topline Score
Bio
LinkedIn User
Ankit is a motivated, skilled engineer who has continued to take advantage of every opportunity to grow. He has an upbeat mentality in working with his team while promoting technical evolution. He deeply cares about what he works on, and that brings a passion for delivery. He would be an asset to any team looking for someone to jump in and contribute to the team's path forward.
Anton Fritsch
Having worked with Ankit for only a brief time, I knew immediately that his potential was sky high. Ankit is a quick learner, intellectually curious about both business and technical aspects of work, and conscientious in his undertaking of such. He was a key driving force on the modernization and automation efforts on his team, and later was able to quickly transition to a new product and tech stack to become a key contributor in a more advanced environment. As a teammate, Ankit is always willing and able to support or guide his colleagues in need, and his strong sense of ownership reinforces an authenticity that makes Ankit a pleasure to work with. Additionally, Ankit’s generally energetic and upbeat manner transforms the nature of team collaboration, I strongly believe that he would be a valued addition to any data team he happened upon.
LinkedIn User
Ankit is a motivated, skilled engineer who has continued to take advantage of every opportunity to grow. He has an upbeat mentality in working with his team while promoting technical evolution. He deeply cares about what he works on, and that brings a passion for delivery. He would be an asset to any team looking for someone to jump in and contribute to the team's path forward.
Anton Fritsch
Having worked with Ankit for only a brief time, I knew immediately that his potential was sky high. Ankit is a quick learner, intellectually curious about both business and technical aspects of work, and conscientious in his undertaking of such. He was a key driving force on the modernization and automation efforts on his team, and later was able to quickly transition to a new product and tech stack to become a key contributor in a more advanced environment. As a teammate, Ankit is always willing and able to support or guide his colleagues in need, and his strong sense of ownership reinforces an authenticity that makes Ankit a pleasure to work with. Additionally, Ankit’s generally energetic and upbeat manner transforms the nature of team collaboration, I strongly believe that he would be a valued addition to any data team he happened upon.
LinkedIn User
Ankit is a motivated, skilled engineer who has continued to take advantage of every opportunity to grow. He has an upbeat mentality in working with his team while promoting technical evolution. He deeply cares about what he works on, and that brings a passion for delivery. He would be an asset to any team looking for someone to jump in and contribute to the team's path forward.
Anton Fritsch
Having worked with Ankit for only a brief time, I knew immediately that his potential was sky high. Ankit is a quick learner, intellectually curious about both business and technical aspects of work, and conscientious in his undertaking of such. He was a key driving force on the modernization and automation efforts on his team, and later was able to quickly transition to a new product and tech stack to become a key contributor in a more advanced environment. As a teammate, Ankit is always willing and able to support or guide his colleagues in need, and his strong sense of ownership reinforces an authenticity that makes Ankit a pleasure to work with. Additionally, Ankit’s generally energetic and upbeat manner transforms the nature of team collaboration, I strongly believe that he would be a valued addition to any data team he happened upon.
LinkedIn User
Ankit is a motivated, skilled engineer who has continued to take advantage of every opportunity to grow. He has an upbeat mentality in working with his team while promoting technical evolution. He deeply cares about what he works on, and that brings a passion for delivery. He would be an asset to any team looking for someone to jump in and contribute to the team's path forward.
Anton Fritsch
Having worked with Ankit for only a brief time, I knew immediately that his potential was sky high. Ankit is a quick learner, intellectually curious about both business and technical aspects of work, and conscientious in his undertaking of such. He was a key driving force on the modernization and automation efforts on his team, and later was able to quickly transition to a new product and tech stack to become a key contributor in a more advanced environment. As a teammate, Ankit is always willing and able to support or guide his colleagues in need, and his strong sense of ownership reinforces an authenticity that makes Ankit a pleasure to work with. Additionally, Ankit’s generally energetic and upbeat manner transforms the nature of team collaboration, I strongly believe that he would be a valued addition to any data team he happened upon.
Credentials
-
Tableau for DataScience
UdemyMay, 2017- Nov, 2024 -
Manual Testing
SEED Infotech LtdMay, 2011- Nov, 2024 -
AWS Certified Solutions Architect – Associate
Amazon Web Services (AWS)Dec, 2020- Nov, 2024
Experience
-
TrueCar, Inc.
-
United States
-
Technology, Information and Internet
-
300 - 400 Employee
-
Data Warehouse Engineer 4
-
Nov 2022 - Present
-
-
-
Signify Health
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Software Engineer II
-
Jan 2018 - Oct 2022
• Setup a project based on data engineering best practices to harmonize distributed services like airflow, terraform, localstack, Docker, AWS micro services, and different distributed database services like redshift and snowflake. • Implemented code testing framework based on test driven development (TDD) strategies to improve code quality by running unit test and end to end test suite with the use of CI/CD approach. • Established cloud infra structure using CloudFormation templates and terraform as part of an infrastructure as code (IAC) concepts. • Performed proof of concept (POC) for various tools and technologies like AWS Services for ETL/ELT processing, Redshift – Snowflake for data warehousing, Tableau– Pentaho BI Suite for data visualization and reporting etc., with proper documentation comparing performance, usability, limitations, advance features, security, scalability user and server management. • Lead data lake project initiative for building data pipeline to bring multiple data points into cloud storage and make it available for analysis through quarriable data layer. This pipeline includes extraction of different data types, transform and store in highly compressed columnar storage type parquet with partitions. • Achieved 40x performance optimization using python distributed processing concepts in order to deal with millions of files per batch. Additionally, redesign ETL data flow for parallel data processing, and easy onboarding of a new payers with least code change. • Lead team at hack-a-thon challenge and reduced cost to ~$38,000/ month by identifying and terminating 8-10 additional RDS instances with migrating data and making pipeline changes. Show less
-
-
-
Remedy Partners
-
United States
-
Hospitals and Health Care
-
1 - 100 Employee
-
ETL/BI developer
-
Apr 2016 - Dec 2017
• Interacted with multiple source systems from flat file, MySQL, MongoDB, REST APIs and AWS micro-services like (SNS, SQS, S3) using data pipelines with application of business logic on top of the extracted data, with end goal as to create and refresh target enterprise data warehouse for reporting and analytics. • Designed, developed and accomplished data warehouse migration project from MySQL (traditional warehouse) to columnar database Redshift and scale the application to process 4x more data with optimization. • Additional logical layer created by designing Mondrian cube with dimension, measures, calculated measures, hierarchy and levels to support ad-hoc report creation. Moreover, created Virtual cubes by combining two or more logical cubes for single source of truth for dashboard designing, row level and column level security bundled within the cube. Developed interactive dashboards using C-Tools with JavaScript, HTML, CSS, bootstrap, MDX, SQL and jQuery over. • Transformed legacy ETLs designed on bash scripts to more organized and orchestrated manner using Pentaho for easy, efficient, more secure platform and better observability with 95% accuracy of data. Show less
-
-
-
Credit Suisse
-
Switzerland
-
Banking
-
700 & Above Employee
-
Test Analyst
-
Jun 2014 - Dec 2015
Credit Suisse has adopted the most advanced approaches, which align with the way that risk is internally managed and provide the greatest risk sensitivity. Basel III focuses on credit risk, market risk, operational risk, securitization risk and equity and interest rate risk in the banking book. As Test analyst I have provided testing services to ensure the data quality and integrity for BASEL regulatory reporting for Investment Banking by Data warehouse and Business intelligence testing techniques. As part of BASEL there were several internal application like STAR,COMET,US and UK Regulatory Reporting, ACE /ARTS and Basel Measurement reporting( IB and PB data harmonization) were tested on different environment like End to End, SIT,PT ,FT. I was responsible for environment setup , preparing Test plan, Code Merge strategy , Functional Test Cases, running ETL Batch process to prepare Data warehouse and Data mart, Walk through Meetings, Weekly Delivery Meeting with Business users, PM, IT BA and Delivery Team. Show less
-
-
-
(Inactive profile) Endurance Group is Newfold Digital
-
United States
-
Technology, Information and Internet
-
300 - 400 Employee
-
Programmer Analyst
-
Nov 2013 - Mar 2014
Endurance International Group (EIG) Data Migration Project provides technical support to manage their servers to Web Hosting Clients like Hostgator, Vdeck, Homestead, Cpanel etc., Moreover EIG handles their clients tons of data in their data warehouse ,provide marketing strategies as well as development environment .As a Programmer analyst I was responsible to migrate the data, scripts and procedures from MySQL to Ms SQL server 2008 R2 with keeping data quality and integrity intact. Worked to make necessary connection and variable changes to existing ETL transformation Suits with on going Data Migration . Show less
-
-
Education
-
2016 - 2018
Goldey-Beacom College
Master of Business Administration (MBA), Information Technology -
2011 - 2013
New York Institute of Technology
Master of Science - MS, Computer Science -
2006 - 2010
BITS Edu Campus: BABARIA INSTITUTE
Bachelor's degree, Computer Science
Community
