Apr 2021 – Oct 2022 · 1 yr 6 mos

Mar 2020 – Apr 2021 · 1 yr 1 mo

Oct 2018 – Feb 2020 · 1 yr 4 mos · Pune, Maharashtra, India

• Part of Phoenix project which is an asset management system that provides a detailed database of hardware and software inventory that can help identify usage and potential efficiency improvements.
• Hadoop Frameworks: Hadoop 2.7.2
• Hadoop Processing Technologies: Hive v1.2.1, Spark v2.3, Kafka , Elastic Search, Hbase v1.2
• Hadoop Integration Processes: Sqoop v1.4.6
• Databases: Oracle 11g
• Versioning Tool: Git
• Languages: Java 8, SQL, Unix Shell Scripting
• 1. Part of backend-end development team of DELL Phoenix Project
• 2. Developed SPARK Java component to read data from Kafka topics and ingest data into Hive Tables
• 3. Developed SPARK Java component to read data from Kafka topic and ingest data into Elastic Search
• Index
• 4. Created hive transactional tables and used hive’s ACID properties to maintain latest asset information
• 5. Created unix shell scripts for Kafka topic creation
• 6. Developed hive migration component to migrate hive data
• 7. Developed sqoop component to migrate hive data into oracle tables
• 8. Created automated Junit test cases for Unit testing of the SPARK components
• 9. Coordinated with Client Support teams for resolution of issues
• 10. Worked in conjunction with Product Owners, BAs and QAs in defining deliverables and managing
• timelines
• 11. Mentored new hires in the team and conducted knowledge transfer sessions

Mar 2017 – Oct 2018 · 1 yr 7 mos · Pune Area, India

• Part of Capital-IT project which involved calculation of Risk Weighted Assets for the bank to be shared with the regulators. The goal was to prevent banks from losing large amounts of capital when a particular asset class declines supply in value.
• Hadoop Frameworks: Hadoop 2.2.4
• Hadoop Processing Technologies: Hive v0.14, Spark v1.6.2, Platfora
• Versioning Tool: Git
• Languages: Java 8, Unix Shell Scripting , Python Basics
• 1. Developed SPARK Java component to read data and apply SQL transformations
• 2. Developed UNIX shell scripts for data filtration and data transformation
• 3. Daily, Weekly, Fortnightly and monthly data analysis of transactional data
• 4. Involved in developing Hive queries and JAVA-Hive UDFs
• 5. Involved in creating batch flows using CONTROL-M
• 6. Involved in data reporting using Platfora
• 7. Developed Python programs for data cleaning and preprocessing

Sep 2016 – Feb 2017 · 5 mos · Pune Area, India

• Part of analysis team that analyzed the customer-spending pattern for defining class of customer for customer retention, preparing and for guiding the bank in their marketing strategies
• 1. Data analysis in Hadoop using HiveQL.
• 2. Weekly, Fortnightly and monthly data analysis of customer behavior pattern like spending trends, most viewed products and browsing pattern with MapReduce using Java, Hive
• 3. Involved in developing Hive queries and JAVA-Hive UDFs
• 4. Importing and exporting data into HDFS and Hive using Sqoop
• 5. Load and transform large sets of structured, semi structured and unstructured data
• Tools/Technology: Hive v0.14, Sqoop, Unix Shell Script, Java

Jun 2014 – Jul 2016 · 2 yrs 1 mo

• Worked as part of Interface team for DFS bank.
• 1. Responsible for creating batch jobs and APIs using PLSQL and Finacle scripting.
• 2. Was part of the Performance Tuning team.
• 3. Responsible for unit testing the items built.
• Tools/Technology: Java, SQL, PL/SQL, Unix, Finacle

Feb 2014 – May 2014 · 3 mos

• 1. Had Undergone Java training program
• 2. Developed an Online Banking application project
• 3. Had Undergone Finacle Training program
• Tools/Technology: Java, RDBMS, Finacle