Saurav Kumar

Development of Dashboard Cascading across all levels,IOCL,Delhi

• Identifed more than 3000 actionable KPIs across-Refinery,Marketing,Pipelines,Finance,Planning and Business Development and Support Functions
• Designed user friendly user interfaces which narrate the business metrics in a story format
• Integrated business from disparate sources across the organizations to enable one version of truth using Tibco Jaspersoft and Talend for ETL on to Single Store DB.
• Designed and developed interactive dashboard and reports using Qlik Sense to provide insights and solutions for various business problems and scenarios.
• Applied best practices for data modelling in Qlik Sense to optimize data processing and analysis , such as creating as star or snowflake scheme or Galaxy Schema.
• Developed interactive dashboard susing Qlik Sense , Qlk Nprinting , QlikGeoAnalytics ,Qlik Alerting
• Used various open source Qlik Sense extensions from GitHub to deliver customer dashboards.
• Created tasks in QMC for Data Scheduler activities and used Task logs in QMC to debug the Job
  failures.
• Knowledge of Installation of Qlik Components.
• Proficient in troubleshooting and fixing the Qlik Sense dashboard issues.

Enterprise Data Warehouse and Business Intelligence
Key responsibilities:

• Developed Qlik Sense reports for different Products like Housing Loan/TW Loan/Infra Loan/Farm Loan/Personal Loan/Micro loan Based on User Requirements.
• Using Qlik Nprinting to Schedule, Generate and Deliver custom reports via Email.
• Also Involved in analysing the Data and defining Key Performance Indicators (KPI) and also participated in
  business requirement document preparation.

Tata Consultancy Services iON Manufacturing Solution, Mumbai

• Developed Qlik Sense dashboards by extracting data from different sources like SQL Server,Rest API, MySQL, JSON, Excel files, XML Files.
• Using Qlik Nprinting to Schedule, Generate and Deliver custom reports via Email
• Migration of Reports from QlikView to Qlik Sense
  Proficient in troubleshooting and fixing the Qlik Sense dashboard issues.
• Managed Team to deal with Critical Deliverables and also worked as Individual Contributor.
• Involved in data cleaning activities like handled nulls, created calculated fields and buckets, handled
  date formatting and currency formatting in Data load editor.