Pankaj Pandey

Software Engineer

MAQ Software•  March 2022 - Present•  Hyderabad

Experience: • Developed a course recommendation system using Apriori Algorithm in Python for LDP (Learning and Development Portal). • Designed and developed Big Data Solution for PepsiCo, tracking orders Near Real Time using Structured Streaming. • Designed reliable data pipelines in Azure Data Factory to fetch data from API, trigger notebooks and perform ETL Operations. • Successfully performed transformations using Python and PySpark in Azure Databricks. • Created dynamic and visually appealing Power BI visuals, dashboards, and Paginated reports to represent Daily Sales data. • Performed KPI validations using SQL queries in Azure Synapse and developed Power BI reports on top of it. • Consolidated multiple datasets into a single dataset to provide a holistic view of business operations. • Migrated BOBJ reports to Power BI reports, converting Bex to DAX queries, optimized model for faster processing (reducing visual load time from 90 to 10 seconds). • Actively participated in code and UI/UX reviews, provided estimates for work items, and technical guidance to junior team members.

AWS Intern

Genese Cloud Academy•  September 2020 - December 2020

Learnt about cloud services offered by AWS with practical hands-on experience on it(in field of Machine Learning). Learnt about the machine learning concepts and worked on basics of prediction scenarios like car price prediction, house price prediction and so on.