Pankaj Shende

Experience

• 

  Cybage Software

  Sept 2009 - Aug 2012

  Software Engineer

  Worked with Cybage Private Limited as a Software Engineer with experience of implementation, Customizations development, Support and Maintenance of Microsoft learning BI projects.

• 

  Courion IT Pvt Ltd

  Aug 2012 - Feb 2013

  Software Engineer
• 

  Infosys

  Feb 2013 - Oct 2015

  Technology Analyst

  - Requirement gathering, business analysis- ETL designing and development using SSIS- Data modelling - Providing reporting solution using SSRS- Designing Dashboards - Performance tuning of SQL, SSIS packages, SSRS reports- Writing the MDX/DAX queries

• 

  Cognizant

  Oct 2015 - now

  • Worked on client side in UK for 2.5 Yrs • Analyzing and architecting data retrieval from different sources of the Extraction, viz. SQL Server Cube, Cosmos data source, Flat files, excel files.• ETL design and development using Azure data factory and Azure databricks for the large scale data processing and transformation • Saved the server upgradation cost and ETL development efforts of the client by providing them solution to load the hive data directly in SSAS tabular cubes instead of loading in SQL.• Developed SSAS cube on the large volume of Hive data approx. 300 GB and improved the cube processing time from 15 Hrs. to 5Hrs. • Architect and developed interactive dashboards using Power BI and delivered across global Sponsors in multiple countries, provided the personalized dashboard by adding the Multilanguage and multi time zone feature so that user can see the report as per their Country time zone and language.• Developed and delivered the Power BI dashboards for multiple clients, business users for various domains including Telecom, Insurance, Retail, Pharma.• SSIS (2008/2012/2014) package development, configuration, deployment, using Checkpoint, transactions, logging.• Creating jobs to execute the ETL process at scheduled time periods. • Data Warehouse Design and implementation• Designed & developed the SSRS reports for the representation of health and trends of the business in the form of charts and trees.• Development of SSRS reports 2012 from Sources like SSAS cubes and SQL server, SSRS reports developed include Parametrized, Linked Report, Tablix, Matrix, Drill Down ,Drill Through, Subreports, automating reports. Show less

  • Senior Associate

    Oct 2015 - now

  • BI - Sr. Associate

    Oct 2015 - now
• 

  LTIMindtree

  Aug 2022 - now

  Senior Specialist - Data Engineering