Jitendra Jp Pandey

About Jitendra Jp Pandey

A technology professional with the following characteristics:• Technology Thought Leader• Process Driven• Automation Oriented• Outside-the-box Thinker• Minimalist

Experience

1. Solutions Architect

   Electrolux Group

   Aug 2023 — Present · Charlotte, NC, US

   Led the migration of North American data and reporting infrastructure from on-premise Microsoft SQL Server/Power BI Report Server to Fabric Capacity/Azure Databricks environment and guided Data and Analytics Team throughout the migration.• Designed and implemented the architecture data pipelines to ingest, load and transform the data from disparate sources, including APIs, relational databases, Analysis Service, SAP CRM and cloud storage (Azure Blob and Amazon S3) into Medallion Architecture.• Assessed existing reporting portfolio to make keep-on-premise or migrate-to-cloud decision by carefully considering costs (capex and opex,) features, performance and limitations.• Led the data and reporting infrastructure strategy for the installation, upgrade, administration, security and governance of on-premise solutions including Microsoft SQL Server, Power BI Report Server, QlikView Server and Publisher, SAS Analytics Platform and SAS DDPO.• Designed scalable on-premise/hybrid-cloud infrastructure for data and BI applications with periodic evaluations and performance optimizations to support growing data volumes and user demand.• Managed CI/CD life cycle for BI developers ensuring compliance with enterprise change management protocols.• Provisioned utilities to measure the performance of Microsoft SQL Server based enterprise data warehouse and proposed architectural improvements to optimize performance (deployment type, hardware refresh, licensing) and optimize cost (capex and opex).• Monitored and audited license usage of Power BI Pro licenses across IT and North American business users using self-serve reporting.

Education

• Indian Institute of Technology (Banaras Hindu University), Varanasi

  B. Tech., Chemical Engineering

  1999 — 2003

Skills

• Business Intelligence
• Etl
• Sql
• Sas
• Data Warehousing
• Agile Methodologies
• Analytics
• Unix
• Solution Architecture
• Software Project Management
• Requirements Analysis
• Sas/Base
• Sas/Graph
• Sas Web Report Studio
• Html
• Db2
• Sas Data Integration Studio
• Sas Information Delivery Portal
• Sas Information Map Studio
• Sas Spds
• Sas Management Console
• Linux
• Oracle
• Sas Programming
• Sas Platform Administration
• Sas Visual Analytics
• Sas Ddpo