Pranauv Kumar. R

*, ********** ****** *. *************, India

adhsiq@r.postjobfree.com

+91-790*******

CAREER OBJECTIVE

To make a sound position in corporate world and work enthusiastically in a team to achieve the goal of the organization with devotion and hard work.

EDUCATIONAL QUALIFICATIONS

Course

Name of the Institution / School

University/Board

Year of Passing

Percentage B.E. (CSE)

P. A. College of Engineering and Technology, Pollachi.

Anna University, Chennai

2018

6.7%

H.S.C

J.K.K.N.Matriculation Higher Secondary

Komarapalayam

State Board

2014

70.40%

S.S.L.C

Shri Ganga Higher Secondary

School Perndurai

State Board

2012

77.60%

AREA OF INTEREST

JAVA (Basics)

SQL

Technical Skills

RDBMS

ORACLE, SQL SERVER,SAP HANA

Languages/ Reporting Tools

SQL and Excel, Advanced Excel,, SAP BO Reporting,POWERBI

Platform

Windows Family

Technical Summary:

Good Knowledge in creating Views, Functions to retrieve data from database.

Good knowledge Excel based reporting using Lookups and Pivots.

Good knowledge in RDBMS and Data Warehousing Concepts.

Strong Knowledge in Normalization and Denormalization concepts.

Having Strong Knowledge in OLTP, OLAP and Data modelling concepts.

Good knowledge in Report Development using SAP BO.

Good knowledge in Excel Reports automation using SQL query.

Good Knowledge writing complex SQL using Functions, Joins, Views and Set operators.

Good Knowledge in Report development using SQL/Excel.

Very good analytical and team work skills. And Excellent communication and interpersonal skills

Power BI:

Good Knowledge and Real time exposure in Power Bi reports & dashboards with SQL Server, SAP Hana, Oracle databases

Good Knowledge and Real time Exposure in Power Pivot, Power Query and Loading and Transforming data

Good knowledge and Real time Exposure in Relationships and Cardinality and Joins

Good knowledge and Real time Exposure in Appending,Merging Queries and Splitting Columns and Indexing

Good knowledge and Real time Exposure in Calculated columns and working with date functions

Uploading reports in server App.power bi.com

Good Knowledge in DAX Queries

Good knowledge in Data Modeling

Good knowledge in downloading different format of reports in server

EXCEL:

Good Knowledge in Pivot, Vlook up and HLook up

Good knowledge in conditional formatting

Good knowledge in power Query

SAP Business Object Reporting:

Good Knowledge in Creating charts, Tables and Images in Web Intelligence Rich client

Good knowledge in designing reports in different formats like crosstabs, tables etc.

Good knowledge in designing charts for reports

Good knowledge knowledge in joins Using Information design tool

Resolving loops in IDT

Good knowledge in star and Snowflake schemas.

Good knowledge in Report Development using SAP BO.

PROJECTS

Project: Online library management system

Duration: 3 months

Front End: Microsoft Visual Basic

Back End: MySQL

Description: Aim of this project to Develop Software Which Would automate the functioning of a library over a network, either Internet or Intranet. It allows Admin and Student to search for Desired Book .Library management system helps students in better learning to provide Quick

Access to the Library system .User can add members, search books, Update information Edit information, Borrow and return Books in Quick time

Project: Real Time Vehicle Tracking and monitoring using Arduino and application

Front End: Embedded C

Back End: Java

Description: Aim of this this project to Track the vehicle from Source to destination and displayed in Android application. This design and implementation of a real time GPS tracker system using Arduino. Meanwhile a user installs the mobile application and the GPS-GSM shield to Arduino, The user receives the location coordinates with data’s and Stored in Think to speak cloud and displayed in Android Application

CERTIFICATIONS

Attended a workshop on Ruby on Rails in P. A. College of Engineering And Technology, held on 25 -Feburary-2017

Completed Microsoft Power BI Course In William McGuffey Academy in Udemy

Completed Course in Network Technology and devices (CCNA-Routing and Switching) In Tech –Work solutions.Pvt Limited.

Attended a workshop on Hardware and Networking in P. A. College of Engineering And Technology.

Attended the Inplant Training on Android from 09-December-2015 to 12-December-2015 in Code Bind Technologies .Coimbatore.

Attended a National Level Workshop on Internet of things conducted by Intelogy Techno- Solution Private Limited

Undergone Industrial Visit in UST Global, Cochin during the academic year 2014-2015.

DECLARATION

I hereby declare that the above mentioned information is true to my knowledge and I bear responsibility for the correctness of the above mentioned particulars

Place: Signature

Date: (Pranauv Kumar R)

Contact this candidate