Pradeep

Senior Analyst JUNE 2019 – PRESENT Novartis - Hyderabad

• Gathering the project requirements from different stakeholders across the globe.

• Built a global transparency dashboard using Qliksense from scratch depicting finance figures, the dashboard currently has a large user base.

• Involved in data extraction from different data sources i.e., oracle, SAP, Stores procedures and flat files and used incremental load methodology.

• Developed linked tables, Concatenation and solved the loops issues.

• Involved in overall scripting and designing of the project.

• Implemented section access to restrict dashboard access.

• Designed dashboards using different objects like Bar,Line, Combo,Gauge,Scatter,Straight/Pivot table.

• Designed and developed Adhoc reports as per users request

. • Generated dynamic reports using nprinting

• Heavily involved with the functional consultants so as to understand the business logics.

BI Consultant FEB 2017 – MAY 2019 IRT Digital Analytics Solution Pvt Ltd - Delhi

• Worked for multiple clients - Bajaj auto, Max healthcare and Pernod Ricard.

• Worked in automobile, healthcare and liquor sector.

• Worked predominantly in Qlikview 11.2 and 12

• Created various Qliksense dashboards POCs to the users as per client requirements.

• Performed unit testing for the developed QVW and QVF applications

• Worked with different types of triggers,Groups/Cycles and possess in-depth knowledge on Incremental loads.

• Hands on experience in removing of synthetic keys and circular loops.

• Ensuring best practices while implementation of any BI application.