Learn Data Skills
Beta
Aun Peerzada

Aun Peerzada

Certified

Data Analyst

Cognizant Technology

Technologies

My Portfolio Highlights

My New Certification

Data Analyst Associate

My New Certification

Data Analyst Associate

Data Analyst with 3 years in SQL, Power BI, Excel & Python. Expertise in data analysis, reporting, and workflow automation. Generated insights, boosted efficiency, and drove business success with data-driven solutions.

My Work

Take a look at my latest work.

DataLab

Project: Analyze International Debt Statistics

1Upvotes
DataLab

Project: Analyzing Unicorn Companies

1Upvotes
DataLab

Project: Analyzing Students' Mental Health

DataLab

Supermarket Transaction Analysis in SQL

1Upvotes
DataLab

Project: Analyze International Debt Statistics

1Upvotes

My Certifications

These are the industry credentials that I’ve earned.

Data Analyst Associate

Data Analyst Associate

SQL Associate

SQL Associate

Other Certificates

Microsft Microsoft Power BI Data Analyst Associate

Microsoft Azure Data Fundamentals

Google Google Data Analytics

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Cognizant | Mar 2022 - Present

Technical Lead

N/A

Cognizant | Mar 2022 - Present

Technical Lead - Data Analyst

Project - TriZetto Healtcare As a Data Analyst at Cognizant, I have developed strong expertise in data analysis, reporting, and process optimization. My role involved using SQL, Power BI, Excel, and Python to manage and analyze data, automate processes, and provide actionable insights to internal and external stakeholders. Below are some key aspects of my work: Data Analysis & Reporting: Performed extensive data analysis on claims, membership, billing, and payments using SQL queries to extract, clean, and manipulate data, and used Excel for data modeling, pivot tables, and reporting. Created monthly, weekly, and ad-hoc reports on key performance indicators (KPIs) related to batch job performance, system errors, and SLA compliance, helping internal teams and clients track progress against defined goals. Automated the report generation process by building Excel templates with advanced functions, reducing report preparation time by 40%. Data Queries & Troubleshooting: Wrote complex SQL queries to troubleshoot data-related issues, such as batch job failures and discrepancies in claims and membership data. Worked closely with cross-functional teams (DBA, Middleware, Claims, and Membership) to resolve data quality issues, improve data accuracy, and ensure data integrity across systems. Developed customized SQL reports for business stakeholders to assist in decision-making and track performance metrics, improving operational efficiency by 20%. Data Visualization & Dashboards: Designed interactive dashboards and visualizations using Power BI to provide real-time tracking of operational metrics such as batch job performance, claim adjudication rates, and SLA adherence. Delivered insights via visually engaging reports that helped management make data-driven decisions, reducing turnaround time for decision-making by 15%. Root Cause Analysis & Data-Driven Solutions: Led data-driven root cause analysis for production issues related to batch jobs and claims processing, leveraging SQL and Excel to analyze large data sets, identify bottlenecks, and implement solutions. Collaborated with technical teams to streamline processes based on findings, resulting in a 25% reduction in job failures and improved system uptime. Client-Specific Projects & Support: Supported the onboarding of new clients by performing detailed application checks, data migration reviews, and reporting, ensuring smooth integration and operational success. Worked closely with clients to understand their data-related challenges, provided actionable insights, and recommended process improvements, improving client satisfaction and reducing operational errors by 20%. Process Automation & Optimization: Automated key data validation tasks and reporting using Python scripts and SQL, significantly reducing manual effort and improving accuracy in data processing. Led a project to automate the monitoring of batch jobs and their SLA performance, creating SQL scripts and Power BI dashboards that provided real-time data on job status and compliance, reducing manual effort by 50%. Key Technologies Used: SQL: Complex data queries, data manipulation, reporting, troubleshooting. Power BI: Data visualization, dashboards, KPI tracking, reporting. Excel: Data analysis, pivot tables, automation, report generation. Python: Scripting for process automation, data cleaning, and analysis. This role has sharpened my ability to transform raw data into actionable insights and leverage data analytics tools to solve complex business problems. I am now looking to apply my analytical skills and knowledge to more focused data analytics roles, where I can continue contributing to data-driven decision-making.
Show More

My Education

Take a look at my formal education

Bachelor of Engineering in Mechanical Sandip Institute of Engineering and Management | 2021

About Me

Aun Peerzada

Aun hasn't filled in a bio text

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free