Resume – MosamKhan

My Resume

ASKARI BANK LIMITED | 03/2025 – Present

Extract, analyze, and manage data from various sources including Oracle Flexcube, OBI, and other internal databases to support internal audit functions.
Develop and optimize complex SQL and PL/SQL scripts to collect and automate data queries across multiple schemas and systems.
Automate audit reports using a combination of SQL, Power Query, Power BI, and Power Automate, significantly improving efficiency and reducing manual workload.
Design and maintain interactive dashboards and reports in Power BI to visualize key risk and control indicators for audit teams.
Implement automated workflows using Power Automate to schedule data extraction, refresh Power Query, and distribute reports to team via Excel and email.
Collaborate closely with auditors to understand data requirements and deliver timely, accurate, and actionable insights.

24-7 CONSULTANCY (SMC-PVT) LTD | Nov/2024 – Mar/2025

Collaborate with billing teams and extract data from various billing software platforms, including Office Ally, eClinicalWorks (ECW), and NextGen.
Process, clean, and structure data to support meaningful analysis and dashboard development.
Develop customized, in-depth reports tailored to the specific needs of individual medical practices.
Automate recurring reporting processes using Power BI, Excel, and Power Query to enhance operational efficiency and reduce manual workload.
Provide training and ongoing support to billing staff, ensuring effective use of reporting tools and clear interpretation of data insights.

AIA Global Resources PVT LTD | 03/2024 – 09/2024

Collected and consolidated data from multiple sources daily.
Analyzed and reported on Daily & monthly sales performance for employees and departments.
Tracked order profitability and assessed financial outcomes.
Analyzed refund orders to identify root causes and developed solutions to prevent future issues
Identified top-rated products and analyzed specific regions for targeted promotions to boost sales.
Reviewed listing data to ensure all uploaded listings met quality and accuracy standards.
Developed interactive Power BI dashboards to monitor department, group, and individual performance.
Performed Monthly & quarterly sales analysis and presented findings to the CEO.

Millennium Medical Billing, INC | 01/2023 – 01/2024

Oversee data updates in all departments to ensure accuracy and timeliness.
Diligently review and validate weekly, monthly, and yearly reports from all departments.
Collect data from various billing departments, such as claim posting, payment posting, and appeals etc.
Conduct thorough data preprocessing, encompassing cleansing, validation, and standardization.
Leverage advanced Excel techniques to perform in-depth data analysis related to medical billing, reimbursement rates, and claims processing.
Utilize statistical methodologies to uncover trends and insights.
Conduct comprehensive exploratory data analysis (EDA) to identify patterns and anomalies.
Develop interactive dashboards and concise reports to convey critical financial and billing metrics.
Customize visualizations to align with specific client and department reporting requirements.
Generate comprehensive reports summarizing data analysis outcomes for each client.
Communicate insights and recommendations clearly to our manager.
Document data analysis processes, methodologies, and assumptions for future reference and auditing.

SoftMining – Peshawar | 08/2021 – 12/2022

Getting the data and understanding what is required through metadata.
Asking some important questions related to SMART technique.
Cleaning the data from errors, null values, inconsistency, duplicated values and outliers to be valid for analysis.
Analyzing the data using Excel.
Designing an interactive dashboard based on design thinking.