Roles and Responsibilities:• Delivered ad-hoc data support to users, ensuring prompt access to essential information.• Contributed to the development of DataMarts for Power BI, enabling advanced analytics and comprehensive reporting capabilities.• Streamlined existing data extraction processes by automating them with Python, significantly reducing manual effort and enhancing operational efficiency.• Designed and scheduled ETL pipelines using Python, optimizing data workflows for better performance.• Monitored and maintained current ETL pipelines to ensure their reliability and efficiency.• Collaborated with the development team to deploy ad-hoc data on the reporting portal, improving user accessibility and overall experience.• Enhanced SQL query performance through optimization, resulting in faster data retrieval and processing times.• Developed SQL scripts to identify inaccuracies in customer demographics based on defined criteria.Achievements:• Successfully automated the entire month-end reporting process using Python, resulting in significant time savings and increased accuracy in reporting.• Spearheaded the migration of reports from Business Objects SAP to a local reporting portal built in Python, improving the efficiency of our reporting framework.

Key Responsibilities- Data Processing: Conducting monthly data processing for a diverse portfolio of Consumer banks and institutions across Pakistan. This involves utilizing Oracle PL/SQL to efficiently manage and analyze large datasets, ensuring accuracy and timeliness in reporting.- Data Visualization and Analysis: Developed and maintain interactive dashboards in Power BI, enabling stakeholders to visualize and analyze data trends effectively. This helps in deriving actionable insights that drive strategic decision-making.- SQL Query Management: Utilizing SQL for ad-hoc querying, investigating and resolving data-related issues promptly. This capability is crucial for maintaining the integrity of our data processes.- KPI Reporting: Generated comprehensive Key Performance Indicator (KPI) reports that provide strategic insights into our operations, facilitating better performance tracking and management.- Data Governance and Compliance: Worked on governance standards and ensure compliance with security protocols, safeguarding sensitive information while adhering to industry regulations.

• Worked with various types of datasets over a period of 1+ years, refining my skills in extracting valuable insights.• Worked on data cleaning techniques using Python (Pandas) and Power BI• Leveraged SQL for efficient data retrieval, manipulation, and analysis, enabling seamless exploration and extraction of valuable insights from large datasets.• Utilized Python (Matplotlib, Seaborn) and Power BI for data visualization• Implemented machine learning algorithms for prediction and statistical analysis with diverse datasets