Prateek Arora

Associate Consultant

Gurugram, Haryana, India3 yrs 5 mos experience

Highly Stable

Key Highlights

Proven expertise in SQL Server and Python.
Reduced manual reporting effort by 80% through automation.
Achieved 30% performance increase in Power BI products.

Stackforce AI infers this person is a Data Analyst with expertise in SaaS and Business Intelligence.

Contact

Skills

Core Skills

Data AnalysisBusiness IntelligenceStatistical Data Analysis

Other Skills

Microsoft SQL ServerPython (Programming Language)Power BIData ModelingDashboard DevelopmentPerformance TuningPythonAutomationMicrosoft ExcelWordPressWordPress DesignHTMLCSSAmazon RedshiftJira

About

Hi, I am a Data Analyst with 3 years of experience leveraging data to drive business insights and support decision-making. Proven expertise in SQL Server, Amazon Redshift, Python, Statistical Data Analysis, Microsoft Excel, and Power BI. Adept at transforming complex datasets into actionable insights and collaborating cross-functionally to implement data-driven strategies. Strong problem-solving skills with a track record of improving operational efficiency and enhancing reporting accuracy.

Experience

3 yrs 5 mos

Total Experience

3 yrs 5 mos

Average Tenure

3 yrs 5 mos

Current Experience

United airlines

2 roles

Analyst

Jan 2026 – Present · 4 mos · Gurugram, Haryana, India

Associate Analyst

Dec 2022 – Present · 3 yrs 5 mos · Gurugram, Haryana, India

Collaborate with cross-functional teams to ensure alignment with business objectives, identify datasets/ data sources, and streamline the backend process, resulting in a 25% reduction in development time and analysis.
Optimized Power BI product(s), and data modeling, leading to a 30% increase in performance.
Mentored junior developers in developing dashboards/reports and ensured proper BI standards, policies, and procedures were followed in requirements gathering, analysis, design, development, documentation, and testing phases and setting up version control using GitHub and SharePoint.
Developed impactful data transformation methodologies and ETL processes (Databricks).
Improved dashboard usability by troubleshooting and performance tuning resulting in a 20% increase in user adoption/engagement.
Developed Python scripts to automate the generation of weekly/monthly reports, reducing manual effort by 80%.
Developed complex SQL queries to extract, manipulate, and analyze large datasets, supporting business intelligence and reporting needs.
Created and maintained stored procedures, functions, and triggers to automate business processes and enforce data integrity.

Microsoft SQL ServerPython (Programming Language)Data AnalysisBusiness Intelligence

Technocolabs softwares

Data Analyst

Aug 2022 – Oct 2022 · 2 mos · Indore, Madhya Pradesh, India

My role is to work on a given task and give relevant solutions to the problems. Also, I used SQL, Excel, and Python(numpy, pandas, seaborn,
and matplotlib).
Maintained large databases and used various techniques to analyze and interpret data.
Collected, cleansed, and provided modeling and analyses of structured and unstructured data used for major business initiatives.
Conduct detailed weekly reports and actively participated in team meetings with managers.

Microsoft ExcelData ModelingData AnalysisStatistical Data Analysis

Pibyx

Web Developer

Apr 2021 – Oct 2021 · 6 mos · Jaipur, Rajasthan, India

Developed Learning Management System (LMS) website using HTML, CSS, and WordPress.
Establish an interactive and dynamic website that guarantees high traffic, page views, and maximum user experience.
Collaborate with senior developers to update the website and create new features using WooCommerce and Elementor.
Proactively liaised with the design team and project manager to ensure efficient and timely delivery of significant projects.

WordPressWordPress Design