Abhishek Kumar Katiyar
Kanpur
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Software Engineer
MAQ Software
01.2023 - 03.2024
- Collaborated Azure Synapse and Azure DevOps to drive project success, optimizing SQL and Python scripts, resulting in 50% reduction in database query runtime and 30% decrease in server response time.
- Spearheaded creation of Power BI reports for MAQ software director, revolutionizing data analysis processes and leading to 25% improvement in client service quality and 30% boost in revenue generation.
- Engineered and implemented comprehensive data analytics framework with Analytics and BI teams that standardized key performance indicators globally, resulting in 40% reduction in data processing time and 25% increase in operational efficiency.
- Demonstrated adept management of frontend (Power BI) and backend services (Azure Synapse, SSMS), ensuring smooth data visualization and processing with an impressive track record of uptime and reliability.
- Implemented DevOps tools such as Microsoft Azure DevOps (ADO) and Docker resulting in a substantial reduction in ETL pipeline deployment time and an enhanced time-to-market by 20%.
- Leveraged advanced AI utilities including Chat GPT, Copilot, and others to optimize data analysis workflows, refining complex queries improving overall decision-making processes by 50%.
Education
B.Tech - Computer Science And Engineering
GL Bajaj Institute of Technology
Greater Noida07.2023
Intermediate - PCM + CS
Heritage International School
Kanpur03.2018
Skills
- SQL
- Python
- Power BI
- Azure Synapse Analytics
- Microsoft Excel
- ETL development
- Tableau
- Data Pipeline Design
- Data Visualization and Presentations
- Data Analysis
Projects
Global Partnership Platform (07/2023 – 03/2024)
- Pioneered a pivotal project for a client by leading the Azure Synapse cloud migration effort, with a primary focus on enhancing data warehouse structures and refining ETL procedures, resulting in a 50% increase in data retrieval efficiency and a 30% reduction in processing latency.
- Employed a proactive approach to identify and resolve obstacles promptly, fostering a collaborative environment and Leveraged expertise in Azure Synapse, SQL, Python and ETL methodologies to drive seamless transitions and maximize project outcomes.
Digital Sales Bridge (01/2023 - 06/2023)
- Leveraged advanced Excel functionalities to preprocess and transform raw data, optimizing it for analysis within Power BI, ensuring accuracy and consistency in reporting metrics and trends.
- Utilized SQL queries to extract and integrate data from multiple sources into Power BI, enabling comprehensive and real-time visualization of key performance indicators to client stakeholders with actionable insights, fostering a culture of data-driven decision-making and organizational agility and competitiveness.
Certification
Microsoft Azure AI Fundamentals:
- Validates basic AI knowledge, Azure AI services, machine learning concepts. Essential for entry-level AI professionals
Data Analyst Skillpath:
- Excelled in a comprehensive course mastering data analysis tools: Excel, Python, and SQL, enhancing proficiency and practical application expertise.
Languages
- English
- Hindi
Timeline
Software Engineer
MAQ Software
01.2023 - 03.2024
B.Tech - Computer Science And Engineering
GL Bajaj Institute of Technology
Intermediate - PCM + CS
Heritage International School
Similar Profiles
Gourav KumarGourav Kumar
Software Engineer I at MAQ SoftwareSoftware Engineer I at MAQ Software
Chetan PatilChetan Patil
Technical Project Manager at MAQ SoftwareTechnical Project Manager at MAQ Software
Rishikesh PashteRishikesh Pashte
Software Engineer 2 at MAQ SoftwareSoftware Engineer 2 at MAQ Software