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
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Anton Leander AAnton Leander A
.NET Full Stack Developer at Infosys Pvt. Ltd..NET Full Stack Developer at Infosys Pvt. Ltd.