Rajat Porwal

Rajat Porwal CAREER OBJECTIVES EDUCATION To Secure a Software Engineering Position in a well-established organization with a stable environment. Dr. Virendra Swarup Institute of Computer Studies Bachelor in Computer Applications- CONTACT Heliger Borden Education Center Flat 603, Shatabdi Rail Vihar Noida-- STANDARD XII / H.S.C- Heliger Borden Education Center SSC. X- PROFESSSION EXPERIENCE None BI Developer HOBBIES 2016-Present Tata Consultancy Services • Photography Reading Music Writing Technical Skills\Tools Used Development • • • • • • • • Tableau Tibco-Spotfire SAP- Business Objects Sql Server 2012, 2016 Java Script IronPython MS Office Shell Scripting Testing • PERSONAL HP ALM • • • • • • • • Successfully developed front end web base dashboard with trending data, animated pipeline charts, and demographic charts with drill downs functions that displays a breakdown of Regional/States sales, utilizing data aggregation from Spotfire and Tableau. Built ad hoc reports such as an analysis grid with the capability to drill down at a hierarchical level and functions as print and download. Wrote SQL queries to aggregate data such as profit margin, cost per sales and revenue per Sales. Development includes SQL, HTML, CSS, Java Script and Iron Python with Spotfire and R language in Tableau. Created and modified SQL Stored Procedures. Creating Excel macros and VBA code to massage data in Excel as well as link to SPs in SQL. Performed root cause analysis on failures. Resolve performance tuning related issues and queries. Created Dashboards for tracking live data which are highly optimized for faster runtime. Design and Developed Multisource universes using IDT. PERSONAL