Akshat Agrawal

About Akshat Agrawal

Data professional with 7+ years of experience in Data Engineering, Predictive Modeling, Data Analysis, and Database Management. Proven expertise in framing, analyzing, finding insights, and recommending data-driven strategies to solve business problems. Flexible to learn and work on various tools/technologies to cut cost, increase revenue, and improve efficiency.Skills:• Programming Languages: Python, R, SAS, SQL, C, C++.NET, C#, HTML, JavaScript, Git• Packages: TensorFlow, Keras, PyTorch, OpenCV, Matplotlib, NumPy, Pandas, SciPy, NLTK, Scikit-learn• Big data technologies: Hadoop, Hive, Pig, Spark• Databases: MSSQL, PostgreSQL, MySQL, Oracle 12c, NoSQL• Cloud Computing: GCP, MS Azure, AWS, IBM Watson• Business Intelligence: Tableau, PowerBI, SPSS, MS Excel• Others: Git, Linux, Docker, Kubernetes, CUDA, GPUAn avid follower of TED talks and a firm believer in the power of ideas which can transform the society for a better good.

Experience

1. Senior Data Ai Engineer

   IBM

   Jan 2024 — Present · Chicago, IL, US

   Industries:Telecommunications, Public• Built an Enterprise Data Warehouse (EDW) using Snowflake and Data Vault to streamline data ingestion and storage using Striim, ADF, and ADLS across raw, conformed, and mart zones; performed unit testing and used git for version control• Developed a secure PGP decryption solution using Python in Azure Functions by leveraging Azure Key Vault and Blob Storage• Designed and deployed a robust data quality framework in Azure Data Factory and Snowflake, automating governance rule checks and reducing manual validation effort by 80%• Automated tracking of deleted records in 1500+ tables using Snowflake’s time travel feature, enhancing auditing accuracy• Led data team to design a gamified solution by extracting job-related performance data from multiple sources to drive behavioral changes in field technicians• Optimized the existing pipeline to reduce the JSON file size by 80% to incorporate the full set of ~20k technicians• Designed optimized data structures, performed data modeling, and built 8 ETL pipelines & 74 scripts in Palantir using PySpark and SQL• Provided ideas in client-facing design thinking and sprint planning workshops regarding scoping and data-related tasks• Built a Rolling Badge pipeline by implementing incremental update logic and built PowerBI reports• Reduced the process time by 95% by automating the process of adding new XP levels and notifications• Supporting senior leadership on POV and RFP to sign a contract for an integrated forecasting & planning project

Education

• Delhi Public School - Gandhinagar

  High School, Mathematics and Computer Science

  2004 — 2012

• University of Illinois Chicago

  Master of Science - MS, Management Information Systems, General

  2018 — 2020

• National Institute of Technology Surat

  Bachelor of Technology - BTech, Electronics and Communications Engineering

  2012 — 2016

Skills

• Python
• Oracle Database
• Microsoft Sql Server
• Plc Programming
• Oracle Database Administration
• Powerpoint
• Microsoft Excel
• Microsoft Word
• Electronics
• Microsoft Office
• C
• Programming
• C++
• Embedded Systems