Summary
Overview
Work History
Education
Skills
Workshops Seminars Attended
Affiliations
Certification
Project 2
PROJECT 1
In Plant Training
Disclaimer
Timeline
Generic
ARUN KUMAR ASOK

ARUN KUMAR ASOK

Chennai

Summary

Analytical professional with technical knowledge and critical thinking skills to thrive in data-driven environments. Tackles challenges with positivity and drive to overcome. Works great alone or with others and consistently exceeds expectations.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Senior Operations Associate

Capgemini Global IT Services
Chennai
11.2022 - 01.2024
  • Experienced in using Different Modes and in getting data from different data Sources into Power BI.
  • Experienced in Handling Data Transformation Techniques using Power Query Editor.
  • Experienced in Creating and Implementing Data Modelling using Append, Merge and Relationships in Power BI.
  • Experienced in Creating ,Visualization using Different Charts and customs charts in Power BI Skilled in Creating Interactive Reports and Dashboards in Power BI Desktop and Service using Filters, Slicers and Synchronized Slicers.
  • Experienced in Creating Calculated Columns and New Measures using DAX Queries.

HR Recruitment Specialist

Cholamandalam Business Services (CBSL)
01.2022 - 09.2022
  • Responsible for maintaining MIS Related audit controls etc
  • Responsible for fixing of salaries and allowances to employees
  • Responsible for providing offer letters, ID cards and Onboarding of employees on southern Districts like Kerala,Karnataka,Tamilnadu and Andhra Pradesh
  • Supporting and assisting in recruitment process to Senior Recruitment Manager

Junior Data Analyst

RR DONNELLY Global Private Outsourcing Firm
Chennai
11.2017 - 01.2019
  • Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text.
  • Experienced in Implementing Incremental and Full Refresh and Scheduling them in Power BI.
  • Experienced in Implementing Gateways and Knowledge in Workspace Roles in Power BI
  • Coordinated and managed various programs or projects to achieve established objectives.
  • Created Visuals and Reports in Power BI Desktop and published into Power BI Service.
  • Created Calculated columns and measures by using Dax functions like Sum, SumX, Same period last year, Parallel period, Count, All, Distinct, Filters.

Education

MBA - HUMAN RESOURCE MANAGEMENT

SASTRA UNIVERSITY
THANJAVUR
05-2017

Bachelor of Engineering Technology - Electrical, Electronics And Communications Engineering

SARANATHAN COLLEGE OF ENGINEERING
TIRUCHIRAPALLI
11-2013

High School Diploma -

VETRI VIKAAS BOYS HIGHER SECONDARY SCHOOL
NAMAKKAL
06-2009

Skills

  • POWER BI DESKTOP
  • POWER QUERY EDITOR
  • POWER BI SERVICE
  • DATA MODELING
  • DATA VISUALIZATION
  • TABLEAU
  • ADVANCED EXCEL
  • MANAGEMENT SKILLS
  • RECORD RECONCILATION
  • DATA HANDLING
  • Administrative Support
  • Database Management
  • Lean Six Sigma

Workshops Seminars Attended

  • Attended a workshop on wireless communication technologies, and Energy Saving techniques.
  • Attended a workshop on Introduction to embedded systems conducted by frontline electronics
  • Attended workshop on entrepreneurship awareness drive at Sastra University.
  • Attended workshop on Leadership alignment & breakthrough at Sastra University
  • Attended workshop on Re-inventing HR practices –HR CONCLAVE at Sastra university

Affiliations

  • Served as an organizer in inter-college fest & symposium during post graduation .
  • Student Representative of cultural events and seminars during college days of 2009-2013.
  • Won 1 st place as a team in Biz –Laurete , National level Management event in Gnanam school of Business ,Tanjore in 2016.
  • Runner in Firma 16 –National level Management Meet in Bishop Heber institute of Management studies ,Trichy-2016

Certification

  • Certified HR Generalist course & Assessment in Human resource policies and principles completed from Middle earth HR Academy
  • Certified Business Analytics course completed from Upgrade learning institute -Mumbai
  • Certified Management Consultant Course completed from Upgrad Learning Institute –Mumbai.
  • Certified in Microsoft excel tools & VBA from Primax learning Academy –Bangalore

Project 2

DOMAIN : Sales 

PROJECT TITLE : Retail Sales 

CLIENT : Unilever 

ENVIRONMENT : Power BI & SQL Server

ROLES AND RESPONSIBLITIES :

  • Created Filters and applied conditional formatting based on user requirement.
  • Created Slicer and measures and columns in Power BI Desktop.
  • Created different types of reports in Power BI Desktop Pinning reports to the Dashboards as per the requirements
  • . Created scheduling and sharing the reports & Dashboards using Data Gateway.
  • Understand the business requirement and translate it into reporting requirement/ Participated in requirement gathering, design and develop report and analysis project.
  • Managed relationships in the tables and created data models in model view.
  • Created various interactive Reports and dashboards

PROJECT 1

 DOMAIN : Insurance 

 PROJECT TITLE : Life Insurance

 CLIENT : New York Life Insurance

 ENVIRONMENT : Power BI & DAX

ROLES AND RESPONSIBLITIES :

  • Understand the business requirement and translate it into reporting
  • requirement
  • Extracted data from various sources and worked on all types of transformations like Append queries, disable load, Splitting queries and merge queries etc
  • Created various interactive Reports and Dashboard
  • Transformed data using various options in Power Query Editor like Choose column, Remove Column, Group by, merge queries and append queries, Etc.
  • Managed relationships in the tables and created data models in model view.
  • Created Bookmarks and buttons in layouts.
  • Generating reports in Power BI Desktop Pinning reports to the Dashboards as per the requirements
  • Implemented Row level security on data.

In Plant Training

  • Bharat Sanchar Nigam limited- Trichy
  • Hindustan Aeronautics limited-Coimbatore

Disclaimer

I hereby declare that all the above information is true and correct to the best of my knowledge and belief

Timeline

Senior Operations Associate

Capgemini Global IT Services
11.2022 - 01.2024

HR Recruitment Specialist

Cholamandalam Business Services (CBSL)
01.2022 - 09.2022

Junior Data Analyst

RR DONNELLY Global Private Outsourcing Firm
11.2017 - 01.2019

MBA - HUMAN RESOURCE MANAGEMENT

SASTRA UNIVERSITY

Bachelor of Engineering Technology - Electrical, Electronics And Communications Engineering

SARANATHAN COLLEGE OF ENGINEERING

High School Diploma -

VETRI VIKAAS BOYS HIGHER SECONDARY SCHOOL
ARUN KUMAR ASOK