Ankit Anchan Email & Phone Number

Mumbai, Mh, In

Pune, Maharashtra, India

• Worked on building an application to predict Drug Shortage 90 days in advance using Tracelink's network data.• Built Data Pipeline to ingest, process and store supply chain events in an efficient queryable way for Data scientists to perform exploratory analysis.• Used Apache Airflow to orchestrate daily data pipelines to generate drug shortage prediction reports for the end-clients using ML Model.• Developed custom AWS Glue (Apache Spark) ETL scripts to normalize data, perform compaction and store in S3 to be efficiently queried from AWS Athena.• Created High Level Design Documents to outline architecture of data pipelines for ETL of events in the Pharma supply chain.• Built and managed AWS resources using terraform, lambda and Jenkins to create CI/CD pipelines.• Built a microservice using RxJava to ingest large volumes of messages (ranging from few Kbs to 300Mb+ in size) and store in AWS S3.• Performed AWS cost analysis to ensure AWS resources are efficiently used and cut AWS costs by ~40%.• Built a configuration driven general purpose framework to schedule and execute Jupyter notebooks using Airflow and Sagemaker processing jobs for data scientists to peform experiments.https://www.tracelink.com/products/orchestration-intelligence/product-availability-intelligence

Pune, Maharashtra, India

Worked on building an application providing end to end visibility to customers to view all the serialization processes that a product undergoes.• Worked on designing and developing data pipelines to ingest structured and unstructured data from various upstream applications into AWS S3 Data Lake, loading approx 100M events per day.• Developed custom AWS Glue Jobs to use AWS Glue ETL service to extract data from the source, transform the data to match the target schema, and load it into the target that could handle 7+ million events/day. • Worked on migration of data processing from batch (Datalake + AWS glue) to stream processing by building Datamesh Pipelines (kafka + Elasticsearch) and provide near real-time reports to users.• Worked on migration of Athena queries (from S3) to Elasticsearch to query audit log data to gain significant improvement in performance.• Created a micro-service that uses the transformed data in S3 to create reports using AWS Athena, AWS Redshift, PostgreSQL & Elasticsearch that can be used by the end-clients.• Worked on implementing Policy Based Authorization using Rego scripts and OPA (Open Policy Agent) to provide very granular control over resource access.https://www.tracelink.com/products/orchestration-intelligence/product-availability-intelligence/serialized-product-intelligence

Pune, Maharashtra, India

Mumbai, India

OHH Daily provides wide variety of Healthy, Homely Meal Subscription options. Ohh Daily stands out to be the best a foodie can get for daily meal requirements.To provide smooth experience with Ohh Daily, we focus on building a high performance, scalable and secure software architecture for supporting mobile application, Web application, Dashboards for vendors while focusing on UI/UX for delivering better experience to OHH Daily Users.

Mumbai, India

I was part of the team responsible to build an in-house performance testing suite with open source tools (Jmeter) and cut costs by eliminating need of expensive proprietary tool licenses.

Bachelor Of Engineering (B.E.), Information Technology

Diploma, Computer Technology