Kim Khan

Results-oriented Data Analyst with experience delivering analytics, ETL automation, reconciliation, and reporting solutions across healthcare, financial services, and real estate.

Strong

Python, SQL, Excel VBA, and Power BI skills with a track record of improving reporting efficiency, automating workflows, and uncovering business insights. Adept at translating complex data into actionable recommendations.

Business Analyst - A. Amelia H LLC

(2025-07)

• Analyzed rental revenue, occupancy, pricing, and receivables to support revenue growth and property performance.
• Automated financial tracking and reporting using Python and Excel, improving data accuracy and reducing manual effort.
• Managed lease, payment, and vendor data to support accurate rent calculations, financial reporting, and tax preparation.
• Evaluated comparable rental properties to identify pricing trends and revenue optimization opportunities.
• Improved financial reporting by organizing operational datasets and automating Excel-based tracking for receivables, expenses, and vendor payments.
• Streamlined reporting workflows through Python and Excel automation, enabling faster financial analysis and more informed pricing decisions.

Business Analyst - iTech Solutions / Cigna

(2024-11 - 2025-06)

• Converted legacy VBA workflows to Python and SQL, reducing manual processing time by approximately 30%.
• Reconciled 100K+ CMS member records using Teradata SQL to identify data discrepancies and improve data quality.
• Cleaned, transformed, and analyzed healthcare datasets using Python (Pandas, NumPy, xlwings) to support operational reporting and business decisions.
• Built analysis-ready datasets through SQL data transformations, reconciliations, and ETL workflows for reporting initiatives.
• Monitored and validated 20+ scheduled Python and VBA production jobs to ensure accurate and timely ETL processing.

Full Stack Developer - Mastech Digital / Fidelity Investment

(2024-01 - 2024-11)

• Supported investment operations, reporting, and analytics by enhancing legacy Excel tools using Python, SQL, Excel VBA, and Bloomberg API integrations.
• Improved reporting efficiency by modernizing risk analysis, reconciliation, and operational reporting solutions used by investment teams.
• Developed and maintained SQL- and VBA-based reporting processes to automate data extraction, reconciliation, and business reporting.
• Automated and monitored Python, Oracle SQL, and Excel batch workflows to ensure accurate, timely delivery of daily reporting and analytics.

Excel VBA Developer - RSC Consulting / Fitch Ratings

(2023-02 - 2023-10)

• Automated financial and operational reporting using Python and Excel VBA, improving reporting consistency and reducing manual effort.
• Built Python data cleansing and validation workflows to prepare large financial rating datasets for analysis and reporting.
• Maintained and enhanced Excel VBA applications and Add-ins, troubleshooting production issues to improve reporting reliability.

Automation Developer - Amtex Systems / CVS Health

(2022-04 - 2023-02)

• Automated healthcare KPI reporting using Excel VBA and SAS SQL, reducing manual report preparation by approximately 20%.
• Improved reporting accuracy by enhancing Excel and Access applications with automation, data validation, and business rule updates.
• Developed Power Automate workflows to streamline SharePoint business processes and improve operational efficiency.
• Supported operational reporting, reconciliation, and business analytics by maintaining Excel- and Access-based reporting systems.

MS Access/Excel VBA Developer - A. Amelia H LLC / Huntington National Bank

(2021-06 - 2022-03)

• Modernized legacy Microsoft Access and Excel applications using VBA, improving application performance and maintainability.
• Automated reporting and business processes with Excel VBA, reducing manual effort and improving workflow efficiency.
• Performed database maintenance, archival, and data management activities to optimize database performance and support operational reporting.
• Supported Jira-managed development projects by implementing application enhancements, troubleshooting issues, and maintaining legacy reporting solutions.

MS Access/Excel VBA Developer - Patel Consultants

(2020-10 - 2021-05)

• Designed and developed business solutions by leveraging VBA for MS Access, MS Excel & MS Powerpoint to automate and improve various workflows.
• Developed a tool that significantly reduced the time to complete a weekly timesheet processing routine.