Summary
Overview
Work History
Education
Timeline
Prem SB

Prem SB

BI Developer
Coimbatore

Summary

  • Qualified IT Developer with overall experience of 6+ years and 3 years’ experience in BI (Qliksense) development.
  • Experience working in Banking and Finance Domain
  • Involved in Full Life Cycle Implementations and Support of Qliksense with hands on working experience in Analysis & Design , Development, Defect fixing and Maintenance of Qliksense Report
  • Having relevant working experience in Qliksense/Qlikview data modelling
  • Data base experience in SQL Server and MYSQL
  • Real time experience in Big Data related technology experience in Storage, Querying, Processing and analysis of data.
  • Knowledge in installing and configuring jobs using Hadoop ecosystem components like HDFS, Hive, Sqoop, and Spark.
  • Able to assess business rules and perform source-to-target data mapping, design and review.
  • High Organizational and project management skills
  • Excellent ability to translate client requirements into effective solutions
  • Strong ability to interact with end users and craft clear technical requirements from business language
  • Used Agile methodology to work with IT and business team to progress efficient system development.
  • Good communication skills and Interpersonal skills with abilities in resolving complex issues
  • Having self-confidence of take initiative of any work and capable of it handling it independently

Overview

6
6
years of professional experience
6
6
years of post-secondary education

Work History

BI Developer

IndusInd Bank Ltd
Coimbatore
02.2019 - 08.2023

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

Associate Developer

Bajaj Finance Ltd
Chennai
07.2017 - 01.2019

Project Name: CustomerEye August 2017 January 2019

Role: Hadoop Developer

CustomerEye is a Bajaj Finance internal application. It's a customer centric application used by internal finance team to analyse customer needs and market requirements and make business strategies on the data provided

Responsibilities:

  • Performed Import and Export of data into HDFS and Hive using Sqoop and managed data within the environment.
  • Processed web URL data using scala and converted it to data frames for further transformations.
  • Loaded and transformed large sets of semi structured data likes XML,JSON,Avro,Parquet.
  • Was responsible for Optimizing Hive queries that helped in saving Cost to the project.
  • Managed Hive Tables and created child tables based on partitions.
  • Development of Code & peer review of assigned task and Bug fixing.

Education

Bachelor of Engineering - Computer Science

Jansons Institute of Technology, Coimbatore
06.2011 - 05.2014

Diploma - Information Technology

KSR Polytechnic College, Tiruchengode
06.2008 - 04.2011

Timeline

BI Developer - IndusInd Bank Ltd
02.2019 - 08.2023
Associate Developer - Bajaj Finance Ltd
07.2017 - 01.2019
Jansons Institute of Technology - Bachelor of Engineering, Computer Science
06.2011 - 05.2014
KSR Polytechnic College - Diploma, Information Technology
06.2008 - 04.2011
Prem SBBI Developer