Pranav Ranjan

Pranav Ranjan Email:-Contact: - Linkedin:www.linkedin.com/in/pranav-ranjan-23964a122 Career Objec ve Ac vely working and enhancing my skills and exper se as a Data Analy c in BI and ETL tools. Profile Summary ✔ More than 3.10 years of experience as an IT professional. ✔ 3 years of rich experience in crea ng compelling reports and dashboard using advanced DAX. ✔ Strong coding experience in SQL (wri ng complex queries, stored procedures, func ons, views). ✔ Extensive knowledge of data query languages and repor ng so ware. ✔ Experience on using SSIS. ✔ Extensive knowledge on Power BI, SQL, Data Warehousing technologies including star schemas and snowflakes concept. ✔ Experience in crea ng all kind of reports such as Yearly, Quarterly, Monthly, and Daily. ✔ Experience in using Azure services for analy cs purpose. ✔ Excellent communica on skills and ability to translate the complex to simple and easier terms for business leaders and users of data. ✔ Experience of working in an Agile environment and following the project life cycle. ✔ Good experience in client handling and customer interac on for requirement gathering and clarifica ons. Employment Details 12th June 2017 – Till Date with Wipro Limited. Joined as Project Engineer and rose to the posi on of Senior So ware Engineer. Work Experience 1. Senior So ware Engineer: Wipro Limited, Bengaluru Working for D&B CSMSS to enhance the Power BI reports and Dashboards to provide solu ons to the client. Skills: MS Power BI, DAX, SAS, Jira Responsibili es: ▪ Published Power BI Reports in the required organisa ons and made Power BI Dashboards available in Web clients and mobile applica ons. ▪ Involved in crea ng new stored procedures and op mizing exis ng queries and stored procedures. ▪ Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports ▪ Explored data in variety of ways and across mul ple visualiza ons using Power BI. ▪ Published reports and dashboards using Power BI. ▪ Used Power BI gateways to keep the dashboards and reports up to date. ▪ Scheduled automa c refresh and scheduling refresh in Power BI service. ▪ U lized Power Query in Power BI to pivot and un-pivot the data model for data cleansing and data massaging. ▪ Integrated custom visuals based on business requirement using power BI desktop. ▪ Converted all opera onal excel report into Power BI Reports. 2. Project Engineer: Wipro Limited, Hyderabad Working for Na onal Grid, US to support and enhance the reports to provide solu on to the client. Skills: Power BI, DAX, SQL, SSRS Responsibili es: ▪ Published reports and dashboards using Power BI. ▪ Used Power BI gateways to keep the dashboards and reports up to date. ▪ Scheduled automa c refresh and scheduling refresh in Power BI service. ▪ Developed analysis reports and visualiza on using DAX func ons like table func on, aggrega on func on and itera on func ons. ▪ Created reports using me intelligence calcula ons and func ons. ▪ Involved in crea ng new stored procedures and op mizing exis ng queries and stored procedures. ▪ Imported data from SQL Server DB, Azure Server DB to Power BI to generate reports. ▪ Executed dashboard setups and data manipula on using DAX. ▪ U lized Power Query in Power BI to pivot and un-pivot the data model for data cleansing and data massaging. ▪ Created Row level security with Power BI and integra on with Power Bi service portal. ▪ Contributed to the documenta on for knowledge transfer. Technical Skills ● ● ● ● ● ● ● ● ● ● ● ● Power BI SSIS SQL Server SQL Data Structure Microso Powershell JIRA Cherwell Ticke ng HP Quality Centre SAP BO SAP BODS Amazon Redshi ● SSAS ● Azure Analysis Services Educa on Details Na onal Ins tute of Science and Technology, Berhampur B.Tech in Electrical and Electronics Engineering (2016) 6.65 CGPA Army Public School, Ramgarh Can Army Public School, Ramgarh Can H.S.C (12th Grade) (2012) S.S.C(10th Grade) (2010) 76.6% 8.2 CGPA Personal Details Date of Birth : 3rd May, 1994 Languages Known: English, Hindi I hear by declare that all the above informa on provided by me is true to the best of my knowledge. Pranav Ranjan