Looking for a job

Kim Khan

@kimkhan

Message

Senior VBA, SQL and Python developer specializing in modernizing legacy automation and reporting.

United States

Message

What I'm looking for

I seek roles modernizing legacy automation into scalable Python/SQL solutions, collaborating with stakeholders, and delivering tested, production-ready reporting. Create and maintain ETL pipelines to ensure data is in a usable format for end users.

I am a senior-level developer specializing in VBA, SQL and Python, with deep experience troubleshooting, maintaining and modernizing legacy Office-based automation into efficient, production-ready scripts. I analyze, design and reverse-engineer complex MS Access and Excel applications to deliver reliable automation and reporting.

My work focuses on converting VBA to Python and SQL, optimizing data pipelines, and ensuring data integrity through rigorous testing and validation. I have delivered production deployments using pandas, xlwings, numpy and SQLAlchemy alongside Teradata, SQL Server and MySQL.

I have led full SDLC efforts—gathering requirements from stakeholders, developing solutions, automating workflows, and documenting technical and training materials. Key achievements include automating KPI and revenue reports, streamlining data cleansing on large datasets, and reducing manual runtimes via scheduled automation.

I collaborate closely with business users, quantitative teams and operations to ensure tools meet business needs, and I use Agile practices, Jira and version control to deliver timely, maintainable solutions that improve efficiency and reporting accuracy.

Experience

Work history, roles, and key accomplishments

Business Analytics Developer

iTech Solutions, Inc.

Nov 2024 - Jun 2025 (7 months)

Converted legacy VBA scripts to Python and SQL, designed, tested and deployed production automation scripts using pandas, xlwings and numpy, and optimized processes to ensure data integrity and performance.

VBA Python SQL Pandas Xlwings Teradata Automation)ETL

Full Stack Engineer

Mastech Digital

Jan 2024 - Nov 2024 (10 months)

Reverse engineered and enhanced legacy Excel risk tools with dynamic SQL, custom functions, API calls and integrated Python and Excel automation to support portfolio managers and quantitative analysts.

SQL Python APIs Access Debugging

VBA Developer

RSC Consulting

Feb 2023 - Oct 2023 (8 months)

Automated ranking and reporting systems in Excel using VBA, improved add-ins and developed Python scripts to streamline data cleansing and ensure accurate deliverables.

VBA Python Add Ins Development Automation)Agile)Jira

Senior Analyst

CVS Health

Nov 2022 - Feb 2023 (3 months)

Automated weekly and monthly KPI reports using VBA and PowerPoint, generated data sets via SAS SQL from Salesforce, and developed Tableau reports to support management decision-making.

VBA Tableau MS Access Reporting Automation)Data Integration

Automation Developer

Amtex System Inc.

Apr 2022 - Oct 2022 (6 months)

Automated KPI reporting using VBA for Excel and PowerPoint, improved Access and Excel databases, and produced Tableau reports while supporting migration to Microsoft 365 Power Apps.

VBA MS Access Tableau Reporting Automation)

VBA Developer

A Amelia H LLC

Jun 2021 - Mar 2022 (9 months)

Implemented VBA enhancements for legacy Access and Excel applications, managed requirements and UAT via Jira, and performed database maintenance and feature additions to Excel add-ins.

VBA MS Access Jira UAT

MS Access/Excel VBA Developer

Patel Consultants Corporation

Oct 2020 - May 2021 (7 months)

Designed and developed VBA solutions for Access, Excel and PowerPoint to automate workflows, including a tool that significantly reduced weekly timesheet processing time.

MS Access VBA PowerPoint Workflow Automation Reporting Process Improvement

Application Engineer

Insight Global

Apr 2020 - Oct 2020 (6 months)

Supported IBOR transition by creating Access/Excel applications to process loans with alternative benchmark rates, automating loan sales workflows and standardizing reporting.

MS Access SQL SDLC Automation)Reporting Loan Processing

MS Excel/VBA Developer

Rose International, Inc.

Nov 2018 - Mar 2020 (1 year 4 months)

Enhanced a large legacy Access application and developed Excel VBA functionality to produce compliance risk assessment reports, run T-SQL scripts and support testing and validation processes.

VBA MS Access SQL Server T SQL Compliance Reporting UAT Debugging

VBA Developer

Malikco, LLC

Jun 2018 - Sep 2018 (3 months)

Developed Excel VBA automation for journal entry workflows, integrated with RPA processes, and managed an overseas developer to deliver project requirements.

VBA Automation)Team Management Workflow Design

VBA Developer

Synthesis Systems Inc.

Sep 2017 - Jun 2018 (9 months)

Built Excel enhancements to accelerate workflows, created ETL tools to import/export data via Zuora API and developed custom functions and statistical calculations in VBA.

VBA ETL APIs Zuora Salesforce Custom Functionality

Senior Software Engineer

WebMD

Sep 2014 - Sep 2017 (3 years)

Maintained and enhanced a VBA reporting application generating over $12M annually, reverse engineered legacy code base and automated reporting processes to deliver 120+ quarterly outcomes reports.