Pricing Data Analyst - SQL BI Specialist

HEMA PATEL

Kendall Park, NJ, Email: *********@*******.*** Phone: +1-732-***-****

Green Card Holder – Authorized to Work in the U.S. PROFESSIONAL SUMMARY

Results-driven Data Analyst with hands-on experience in SQL, Power BI, Tableau, and Advanced Excel. Skilled in transforming raw datasets into actionable insights, building automated dashboards, and optimizing reporting workflows. Brings 10+ years of cross- functional professional experience across data analytics, education, and accounting. Currently working on real-time data analytics projects focused on BI development, reporting automation, and data modelling.

TECHNICAL SKILLS

Business Intelligence & Analytics: Power BI, Tableau, DAX, Power Query, Data Modelling, KPI Tracking, Reporting Automation

Databases: SQL (MySQL, SQL Server), Joins, Window Functions Excel & Spreadsheets: Power Pivot, XLOOKUP, INDEX-MATCH, What-If Analysis, Power Query

Data Processes: Data Cleaning, Statistical Analysis, Dashboard Development, Performance Monitoring

Other Tools: MS Office Suite, Tally Prime, Computerized Accounting, Digital Learning Tools

HOSPITALITY ANALYTICS - CURRENT PROJECT EXPERIENCE (Ongoing) Tools: SQL, Power BI, Excel, Tableau

• Extracting and analyzing 100,000+ rows of transactional data using SQL joins, and window functions

• Cleaning and transforming raw data using Power Query; building a star-schema data model

• Developing DAX measures for YoY growth, profit margins, and KPI tracking

• Designing an automated executive dashboard to streamline reporting workflows

• Enhancing data quality checks and optimizing performance for scalable reporting

HIGH CLOUD AIRLINES PERFORMANCE ANALYTICS – COMPLETED

(JULY 2026)

Tools: Excel, SQL, Power BI, Tableau

• Analyzed airline operational performance including delays, cancellations, route efficiency, and passenger trends

• Built interactive dashboards to visualize on-time performance, peak travel periods, and airport-level metrics

• Applied SQL window functions to identify delay patterns and root causes

• Created KPI scorecards for management to monitor performance improvements

• Delivered insights supporting strategic decision-making for airline operations EDUCATION & CERTIFICATIONS

Bachelor of Commerce (Accounting & Auditing)

Certificate of Excellence – Data Analyst Programme (ExcelR)

• Awarded for outstanding performance and successful completion of all mandated requirements

• Date of Completion: 22 June 2026

Data Analyst Certificate

Advanced Excel Certification

International Diploma in Pre-Primary Teacher Training Certifications

Tally & Computerized Accounting

KEY STRENGTHS

• Fast learner with strong adaptability across multiple domains

• Excellent communicator and cross-functional collaborator

• Passionate about continuous improvement and process optimization

• Proven ability to deliver consistent results in fast-paced environments

Contact this candidate