Excel VBA and Python Developer Resume North Brunswick, NJ - Hire IT People

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

We provide IT Staff Augmentation Services!

Excel Vba And Python Developer Resume

North Brunswick, NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship