Agrima Agarwal Email & Phone Number

• Closely engaged with the consumer to gather functional requirements and convert them into technical requirements for implementation.
• Leading and managing a team of Five, strategically assigning tasks to optimize their learning curve and productivity.
• Implemented tailored task allocations based on individual strengths and development needs, ensuring each team member contributed effectively to overall goals.
• Conducted regular check-ins and guided to foster a productive learning environment
• Ingesting streaming and batch data to HDFS in Avro and Hbase file formats from multiple sources and loaded intoparquet files as per the consumer requirements using Spark Scala SQL and loaded to JP Morgan’s.
• Provided mentorship to the new joiners in the team, making them understand the end-to-end flow of the projectand aligning them with the overall company vision.

Bengaluru, Karnataka, India

• Ingesting streaming and batch data to HDFS in Avro and Hbase file formats from multiple sources and formats.
• After data is ingested into raw tables, data is loaded into parquet files as per the consumer requirements usingSpark Scala SQL and loaded to JP Morgan’s internal cloud/Enterprise Data platform/Cassandra.
• Created a purge script that runs weekly and cleans up raw and conformed Avro and Parquet files.
• Working in the agile methodology with 15-day sprints.

Bengaluru, Karnataka, India

• Created a flow for ingesting streaming and batch data to HDFS in ORC format and from multiple sources/formats data such as JSON, csv, Kafka.
• Performed data quality checks like date format, null check, integer check, casting date and numeric fields while ingesting data in Hadoop.
• Develop Spark code in Scala for creating star and snowflake schema using dataframes and Spark SQL.
• Perform end-to-end testing by using Hive queries and spark-shell.
• Created UDFs in Scala which has reduced development time to 20% and used across 20+ models.
• Implemented a partitioning strategy for performance improvement during data retrieval and load from HDFS.

Bangalore

Hyderabad, Telangana, India

Developed e-commerce based Chatbot using Rasa framework using MySQL and MongoDb databases with Python.

Pune, Maharashtra, India

Worked as ETL developer in Banking domain.Performing ETL on the data using Informatica tool to calculate Risk Weighted Assets and Credit Risk Assets.Worked on impact analysis, technical design, code development, unit testing, code review and migration.

Advance Management Programme In Business Analytics(Cba), 3.2

Machine learning, statistical modelling, Tableau, Big Data(hadoop, Spark), Python Language, Forcasting Analytics, Data Mining(Supervised.

Bachelor Of Engineering (B.E.), Information Technology, 76%(Honours)

Activities and Societies: Oraganized events, Attended Aakash tablet launch conference, IBM DB2 certified

Education record

Activities and Societies: Badminton (zone level, district level), Basket Ball(school level), participated in dance events