Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic
DeepaK J

DeepaK J

DATA PROCESSING ANALYST
Chennai

Summary

A highly professional MBA graduate with a bachelor’s degree in Engineering currently working as a Data analyst. Determined to excel as an analyst by leveraging comprehensive knowledge and deep understanding of business requirements to drive organizational success.

Overview

3
3
years of professional experience
6
6
Certifications

Work History

Data Processing Analyst

NielsenIQ
1 2023 - Current
  • Analyzing big data involves leveraging Excel and Advanced Excel for initial data structuring and automation
  • Python for in-depth exploration and insights, and SQL for thorough data validation to meet business standards
  • Collaborating with US clients to collect enormous amount of big data and execute Extract, Transform, Load (ETL) procedures, ensuring alignment with business needs and maintaining effective collaboration throughout the process
  • ETL process involves validating data using Excel, including advanced features like Macros and VBA
  • Insights and data cleaning are handled in Python using libraries such as Pandas, NumPy and PySpark leveraging automation
  • AI/ML techniques are employed to speed up the process by generating VBA and Python scripts efficiently
  • Post managing the complexity of the data it is loaded and inspected with Oracle using SQL commands to ensure alignment with business requirements and standards
  • The data insights are then presented through Power BI dashboards, focusing on revenue, product sales and improving creditworthiness through trend analysis to enhance their creditworthiness using the data
  • Created SOP and BRD for an automated software solution to streamline processes which enhance efficiency and reduce resource usage
  • Conducted manual testing and collaborated with developers to ensure software accuracy
  • Initiated documentation and encouraged sharing knowledge to ensure that everyone implements and maintains processes consistently and transparently.

Intern

Indian Overseas Bank
07.2021 - 08.2021
  • Analyzed documentation for credit approval, verified customer KYC details, evaluated assets for credit assessment, managed customer cash transactions, handled loan documentation, engaged with customers to understand their requirements, ensured customer satisfaction, calculated credit scores, conducted business interactions with customers and maintained comprehensive customer data
  • Implemented a survey project for IOB to enhance the sales of their credit products using Google Sheets, Google Analytics tools, and Power BI dashboards, and presented the comprehensive report detailing the project findings.

Education

B.Tech-Electronics and Communication Engineering -

Sri Manakula Vinayagar Engineering College

MBA-Banking Technology - undefined

Pondicherry University

Skills

    Advanced Excel

    Python Programming

    SQL Database

    Large dataset management

    Data Governance

    SRS,BRD,FRD

    Statistical Analysis

    Documentation

    Reporting

    Problem solving

    Decision-making

    Attention to Detail

Certification

SQL for Data Analysis

Projects

 Educating the customers for various credits

Objective: Understand and educate customers about IOB Credit products.

Scope: Gather customer data on product awareness and provide real-time data visualization.

Goals: Evaluate customer awareness, increase promotion of credit products, and improve customer engagement.

Activities: Conduct surveys, analyze data, create visualizations, and engage extensively with customers.

Deliverables: Survey results, interactive data dashboard, customer requirements summary, actionable recommendations.


Additional features in payment application to avoid payment error

Aim: Enhance customer confidence in mobile payment methods and ensure seamless user experiences.

Objective: Facilitate effective payment processing without errors to attract a significant customer base and drive business growth.

Used tools and skills like Figma, SRS, BRD and FRD for designing ,creating flowcharts and documenting respectively for developing a payment application model.

Timeline

Intern

Indian Overseas Bank
07.2021 - 08.2021

Data Processing Analyst

NielsenIQ
1 2023 - Current

B.Tech-Electronics and Communication Engineering -

Sri Manakula Vinayagar Engineering College

MBA-Banking Technology - undefined

Pondicherry University
SQL for Data Analysis
Python Data Analysis
Macros & VBA
POWER BI: Dashboards
Excel: Data Analysis
Agile Foundation
DeepaK JDATA PROCESSING ANALYST