We provide IT Staff Augmentation Services!

Excel Vba And Python Developer Resume

North Brunswick, NJ

PERFORMANCE SUMMARY:

An IT professional who specializes in taming operation chaos by developing custom mission - critical solutions using Excel VBA, Access VBA, Visual Basic 2017, Rest API, Python, XML, and JSON. These custom solutions often reduce processing times by over 90 percent. Ability to quickly build a rapport with the user community. Ability to bring together disparate data sources to create a single coherent business intelligence solution. Many of the custom-built applications have passed Confidential internal corporate audits

SPECIFIC SKILLS IN:

Excel VBA

Access VBA

Accounting

SQL

Visual Basic 2017

Visual Studio Code

Python

Microsoft Power BI

JSON

XML

Xlwings Python Library

Excel Power Query

PROFESSIONAL EXPERIENCE:

Confidential, North Brunswick, NJ

Excel VBA and Python Developer

Responsibilities:

  • Scrape Financial web sites using Python 3.7 and Beautifulsoup
  • Scrape Financial web sites using Excel 365 and Power Query
  • Excel Reporting with Python Xlwings Python Library
  • Supervise Python developer

Confidential, Jersey City, NJ

Excel VBA and VB.Net Developer

Responsibilities:

  • Created and maintained Confidential Excel Stress reports
  • The report has 7,000 columns and about 2,000 rows. Rows are generated dynamically.
  • 90 Day Single Period Report, Period over Period Report, CCY Peak Report, 365 Day Report
  • Dynamically created row groupings based on report line hierarchy
  • Created multi-threaded VB.NET desktop utility to generate monthly stress variance reports
  • Each run generates over 120 monthly variance reports with a single user kickoff
  • Automated report generation allows for quicker report review and refinement iterations and enables delivery by deadlines
  • Uses multithreading to call REST web services to retrieve and parse XML and JSON responses
  • VB.NET utility produces variance reports 90% more efficiently than the previous Excel tool
  • Created VB.NET utility to parse 3 to 6 million 5G XML rows to populate an Excel workbook
  • Improved XML parsing efficiency by 90%
  • Tool used to review 5G XML that is sent to the Federal Reserve
  • Excel reports makes REST web service calls to get data for the report.
  • Excel formats JSON response
  • Created and maintained Resolution Liquidity Execution Need (RLEN) Excel reports
  • Created and maintained 5G, US NSFR, US LCR, EBA LCR Excel Reports

Confidential, Jersey City, NJ

Excel VBA and Access VBA Developer

Responsibilities:

  • Market Risk Officer Scenario Stress Analysis Tool
  • A Microsoft Excel front-end tool with a Microsoft Access backend database
  • Enables Market Risk Officers to "slice and dice" hierarchical stress information

Confidential, Jersey City, NJ

Excel VBA Developer

Responsibilities:

  • Created a sophisticated client-server Excel workbook application that allows users to enter trade data to be sent to the margin calculator on the server.
  • Excel workbook uses XML to send trade data to margin calculators; margin results are then sent back to the workbook using XML

Confidential, New York, NY

MS Access VBA and MS Excel VBA Application Developer

Responsibilities:

  • Designed custom multi-user Microsoft Access applications for Hedge Fund Middle Office Group, including:
  • Custom NAV monitoring system for 20 users for daily NAV trigger monitoring.
  • Custom Access reports and custom Excel reports utilizing Access as the data source.
  • Hedge Fund applications passed Confidential internal audit review
  • Designed custom multi-user Microsoft Access Collateral monitoring system for Collateral Group
  • Created custom Access reports to notify clients of margin calls
  • Collateral applications passed Confidential internal audit review

Hire Now