Nov 2024 – Aug 2025 · 9 mos

Jun 2022 – Dec 2024 · 2 yrs 6 mos

May 2021 – Jun 2022 · 1 yr 1 mo

Jul 2020 – May 2021 · 10 mos

Sep 2018 – Jul 2020 · 1 yr 10 mos

Jul 2017 – Feb 2018 · 7 mos

• RRA(Rated Risk Analytics)
• This project covers the risks involved in the analysis for the bank.
• Analyzing on the Business requirements to understand the business specifications.
• Preparing the design documents for the requirements.
• Collecting the user requirements and develop the Mappings and the sessions based on solution specification that provided by users.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using power centre of Informatica/Power Exchange.
• Involved in the developing of developed various mappings, mapplets, Sessions and workflows.
• Migration of the code in to higher environments using the ALM/udeploy tool.
• Providing the demo to users on the requirements how those are developed and working.
• Developed CA7 scheduler jobs using mainframes and accessing those jobs in linux and WinSCP.

Apr 2017 – Sep 2018 · 1 yr 5 mos

• Downstream Analytics Program
• One of the renowned banks in USA wanted to utilize data obtained from its customer to identify patterns in buying patterns and identify new cross sell opportunities. Client was looking for market analysis/predictive analytics based on existing users and their buying patterns and wanted to develop a POC on small scale data.
• MySQL DB connectors and flat files are used as input.
• Understanding business needs, analyzing functional specifications and map those to develop HQL’s and Pig Latin Scripts.
• Project is executing in Oracle Environment and we are slowly changing to Hadoop system.
• Created the hive tables with the similar structure of tables and Sqoop import the tables to hive.
• Performing data migration from Legacy Databases RDBMS to HDFS using SQOOP.
• Writing Pig scripts for data analysis and end result will be processed to HDFS.
• Implemented Hive tables and HQL Queries for the reports. Written and used complex data type in Hive.Storing and retrieving data using HQL in Hive. Developed Hive queries to analyzed reducer output data.
• Developed PIG Latin scripts to extract data from source system.

Jul 2016 – Aug 2017 · 1 yr 1 mo

• Telecom Self Care Portal
• A fully equipped telecom portal that serves the purpose of any telecom company and includes most of the functionalities .The website developed was fully responsive.
• Understand requirements and create high level design.
• Impact Analysis, Detailed Design, Code Development and Review.
• In the initial phase developed the website using Servlets and JSP and implementing MVC architecture.
• In the final phase migrated the whole website was into a fully responsive web app using Angular JS and Bootstrap and Spring MVC and generated the war file using Ant for code deployment.
• Implemented pagination and bar charts describing the subscriber's individual status from each client.
• Unit testing after developing of one module and sanity check to produce bug free application.

Jul 2015 – Sep 2018 · 3 yrs 2 mos

• Domain-Banking and Financial Services.
• Collecting the user requirements and develop the Mappings and the sessions based on solution specification that provided by users.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using power centre of Informatica/Power Exchange.
• Involved in the developing of developed various mappings, mapplets, Sessions and workflows.
• Writing Unit and System Test Plan / Test Cases as per the requirements from the client.
• Migration of the code in to higher environments using the Artifactory/udeploy tool.
• Providing the demo to users on the requirements how those are developed and working.
• Coordinating with testing team on the defects/Tasks.
• Developed CA7 scheduler jobs using mainframes and accessing those jobs in linux and WinSCP.

Jun 2014 – Jul 2014 · 1 mo · Greater Lucknow Area

• A File Management System that keeps a track record of the files being rotated within the directorate.This was developed as a website that required the officials to fill in the data entries and keep a record of each file.The project was developed using .NET.