Prateek Arora

About Prateek Arora

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

1. Associate Analyst

   United Airlines

   Dec 2022 — Present · Gurugram, IN

   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.

Education

• Birla Institute of Technology, Mesra

  Bachelor of Computer Applications

  2019 — 2022

• St Edmund's School

  Senior Secondary School

  2017 — 2018