PRASANNA PANDIAN
Madurai
Summary
Accomplished System Engineer at Tata Consultancy Services, adept in leveraging Power BI and Oracle SQL o enhance data visualization and reporting.
Overview
3
3
years of professional experience
Work History
System Engineer
Tata Consultancy Services
02.2022 - Current
- Developed power bi visualization and dashboard using power bi desktop
- Using power bi as a front end and oracle sql server as a back end database, designed and developed a workbook and dashboard
- Developed reports, dashboard using power bi for quick reviews to be presented to business and IT users
- Published workbook by creating user filter so that only appropriate team can view it
- Created and published 50+ reports using stack bar, bar graph, scatter plots, geographical maps, gantt cards and other visualization
- Build and published 50+ reports along with data refresh scheduling using power bi
- A good knowledge in data modeling, report and dashboard design, DAX function, Date visualization
- Experience in various command like DDL, DML, TCL
- Had experience in case manipulation function like upper, lower and initcap
- Worked on various joins like inner join, outer join, right outer join and left outer join
- Worked on various analytics function such as rank, dense rank, lead, lag
- Worked on various character manipulation function like length, reverse, concat, pad, trim etc
- Has experienced in aggregate function
- Created views
- Worked in set operators
- Database - Oracle
Education
Electrical And Electronic Engineering
Velalar College Of Engineering And Technology
Erode, TamilNadu05.2021
Skills
- Power BI
- Microsoft Excel
- Tableau
- Basic in Python
- Oracle SQL
Timeline
System Engineer
Tata Consultancy Services
02.2022 - Current
Electrical And Electronic Engineering
Velalar College Of Engineering And Technology