Aamar Nawaz

Results-driven business intelligence and data analyst with over 5 years of experience designing etl pipelines, building interactive dashboards, and delivering actionable insights for business operations. Proficient in python, SQL, and data visualization tools with hands-on expertise in power BI, DAX, data modelling, google sheets API, and stream lit. Adept at integrating APIs, automating workflows, and creating lightweight internal applications to improve efficiency and decision-making.

Strong background in data wrangling, testing, and dashboarding across PostgreSQL/MySQL databases and salesforce CRM systems. Proven track record of partnering with stakeholders to translate complex data into clear, impactful business solutions.

BUSINESS INTELLIGENCE ANALYST - Excel Marquee Hire

(2021-04)

• Designed and maintained ETL pipelines extracting data from Salesforce CRM, PostgreSQL/MySQL databases, and REST APIs to streamline reporting and analytics.
• Performed advanced data wrangling and cleaning using Python (Pandas, NumPy) and SQL, improving data accuracy and reducing manual processing time.
• Developed and deployed interactive dashboards and visualizations using Power BI, Google Sheets API, and Stream lit to track KPIs and operational performance.
• Built lightweight internal web applications with Python/Flask, Stream lit, HTML/CSS, and basic JavaScript to automate business workflows.
• Integrated APIs such as OpenWeatherMap (event forecasts), Stripe (payment analytics), and Google Sheets for real-time data synchronization.
• Conducted exploratory data analysis (EDA) to uncover trends and insights supporting customer acquisition, retention, and operational efficiency initiatives.
• Used Git for version control and collaborative development across cross-functional teams.
• Automated reporting processes using Python scripting and Google Sheets API, reducing report turnaround time significantly.
• Ensured data integrity by conducting regular testing, validation, and auditing of dashboards and ETL processes.
• Produced clear data documentation and presented insights to senior stakeholders, enabling data-driven decision making.

DATA ANALYST - CHOICE CARS

(2020-04 - 2021-03)

• Wrote SQL queries across large transactional datasets to deliver daily reporting and ad-hoc analysis, improving decision-making speed by 30% for operations and finance teams.
• Migrated legacy Excel processes into automated Python scripts (Pandas, NumPy), reducing manual reporting time from several hours to under 30 minutes per cycle.
• Designed and deployed Power BI dashboards to track KPIs such as driver performance, ride volume, and revenue trends, enabling department heads to make data-driven operational adjustments.
• Integrated multiple data sources (dispatch system, payment gateway, and customer feedback) to create a unified view of business performance.
• Conducted data quality checks and implemented validation rules, reducing reporting errors by 20%.
• Collaborated with stakeholders to identify key metrics and improve reporting structure, leading to more accurate forecasting and resource allocation.

AA Teleworker

(2016-02 - 2020-03)

• Handled inbound and outbound calls from customers needing urgent assistance, including in difficult or stressful circumstances.
• Maintained professionalism and empathy while assessing breakdown scenarios and dispatching support.
• Logged case details accurately in CRM system while managing multiple tasks and systems.
• Provided reassurance to stranded motorists and ensured high levels of customer satisfaction.
• Worked to KPIs including call response time, case resolution, and customer feedback.
• Experienced with home-working tools (e.g., Microsoft Teams, Zoom, VPN access).

Bachelor of Science Honours - Computer science - University of Wolverhampton (2011-09 - 2014-07)

I.T Software Development - Computer Systems, Event driven programming, Website production and management - Halesowen College, United Kingdom (2009-09 - 2011-07)

A Level - Law (2009-09 - 2011-07)