Project Name: INDIE July 2021– August 2023
Role: Qliksense Developer
INDIE is an IndusInd Bank application. It's a service based application used by customers where Internal banking team make analysis on customer intensity with the data provided
Responsibilities:
- Involved in the requirements gathering (gathering, analysing and documenting business requirements and data specifications).
- Involved in designing the Datamodels , extract and transform the data from the sources like QVD files, Excel, Oracle, SQL Server in creating Qliksense dashboards.
- Developed a Cost Tracker dashboard using different objects like List boxes, charts, Pivot tables, Straight tables, containers etc. to track an order and appointments details for the new customer.
- Extensively worked with Qliksense functions, objects, Set Analysis, Variables to generate different kind of charts. Also generated QVD files by writing scripts in Qliksense applications.
- Trained end users to use the Qliksense applications.
- Performed error handling process, debugging and troubleshooting the applications.
- Have utilized the resident and preceding loading types and have used Concatenation, join and keep operations to derive the optimized data model.
- Prepared and documented Unit Test Result document for each reports
Project Name: Cosmos April 2020 – June 2021
Role: Qlikview Developer and Support
Cosmos is an IndusInd Bank application. It's an Asset based application used by Internal Asset Banking team to explore business opportunity and make analysis on the data provided
Responsibilities:
- Involved in the requirements gathering (gathering, analysing and documenting business requirements and data specifications)
- Developed Qlikview load scripts from multiple data sources (Text and XML files).
- Developed a Qlikview report for analyzing the performance of data and to measure the contractual KPI PIs for users on period basis like year to date, Month to date etc.
- Developed a star schema data modelling.
- Eliminated Synthetic keys and circular loops in the Data Model.
- Have used Applymap, dual, Interval Match (), Time and Date functions in this application.
- Designed and developed extensive Qlikview reports using combination of charts, containers and tables.
- Have used sheet objects in various styles for better view.
- Have given KT to the support people for future support
Project Name: Salestics January 2019 – February 2020
Role: Spark Developer
Salestics is IndusInd Bank sales tracking application used by its own executives to keep track on customer locations and key areas to develop business opportunities based on the geotagging by executives
Responsibilities:
- Created multiple Hive tables, running hive queries in those data, implemented Partitioning, Dynamic Partitioning, and Bucketing in Hive for efficient data access.
- Processed web URL data using scala and converted it to data frames for further transformations.
- Queried data using Spark SQL on top of Spark engine for faster datasets processing.
- As per the business requirement storing the spark processed data in HDFS/S3 with appropriate file formats.
- Involved in working on the Data Analysis, Data Quality and data profiling for handling the business that helped the Business team.
- Have done POCs using Apache Spark SQL