Consultant Resume
New York, NY
SUMMARY:
- Over 15 years of providing solid software solutions to both large and small companies in various languages on multiple platforms
- Experienced in providing global financial companies with solid, reliable, well - tested software deployed in mission-critical environments
- Provided software support and solutions for Wall Street traders, front office, and middle office personnel
- Extensive experience in the development life cycle of technology projects including systems analysis, design, development, integration, testing, and deployment
TECHNICAL EXPERTISE:
Languages: Python, Excel VBA, Visual C++, Perl, Java, C#, VB.net, ASP, C# WPF, MS Access,.NET 4.0, Transact SQL, XML, Objective C,Pig, Hive, Hadoop, IBM SPSS Data Modeler, R
Methodologies: OOA/OOD (UML, Design Patterns)
Software: MySQL, SQL Server 2016, Oracle 11g, Sybase, Apache Spark, Matlab, MS Visio, Visual Studio 2016, HTML,
Systems: Windows 10, Linux, Mac OS 10
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Consultant
Responsibilities:
- Built custom applications to detect signals used in trading and portfolio allocation. s include
- Automation of data from Bloomberg using the Bpipe api
- Scraped public data using python and beautiful soup library
- Automated download of data from yahoo finance and other sites using selenium
Confidential, New York, NY
Consultant
Responsibilities:
- Built custom application to analyze global oil and natural gas deposits and all residual commodities resulting in oil exploration.
- Created tool to calculate the financial viability to predict the capital expenditures, operating expenditures, and abandonment fees based on the historical production and peak production using a modified ‘Arps’ equation. s include
- Automation of data import utilizing Python using production data, asset information, equity partnerships and reserve data
- Created model which connects with MS Excel sheets which contained the tax information for each fiscal regime
- Created ETL tools in Python used to augment the data clients used to analyze oil and natural gas assets
- Wrote MS SQL queries using Python to extract data from remote sites housing historical data
Confidential, New York, NY
Consultant
Responsibilities:
- Automation of data reporting using Python and Excel
- Creation of stored procedures and functions for large Oracle tables. Wrote and edited complex SQL queries.
- Provided analysis of web traffic and effectiveness of marketing campaigns for customer acquisition and retention
Confidential, New York, NY
Consultant
Responsibilities:
- Project included changes to ASP pages written in VB.net and C#.net
- Changes to web services code written in C++ and C#.net
Confidential, New York, NY
Consultant
Responsibilities:
- Excel VBA system for Algorithmic trading company to identify front running in order execution
- Risk Software enhancements in cloud based architecture
- Creating software-based al products that teach high school science, chemistry, and mathematics. Software tools include Java and Objective C
Confidential, New York, NY
Consultant
Responsibilities:
- Architected fixed income data warehouse for all products traded at the firm after switch to ICI Impact (self-clear) from JP Morgan MORCOM system
- Designed accounting solution for the calculation and aggregation of PnL for each asset class which was then used to post to firm wide trial balance and other downstream systems
- Designed and developed reports for Repo desk
- Gathered system requirements from middle office and trading desk and wrote detailed specs
- Wrote product control T+1 trade analysis reports reconciling trades on Bloomberg against prime broker records
- Wrote middle office reports to perform cost of carry, cusip netting, and inventory control in Excel VBA
- Wrote end of trade day interest rate curve construction risk analysis report reconciling curve pricing differences between Bloomberg, Ion and Calypso
- Wrote programs to reconcile files from Bloomberg, JP Morgan, and ICI Impact in Excel VBA
- Wrote and automated Perl scripts which interfaced with MS Excel data to create middle office management reports that were then attached to lotus notes e-mails.
- Wrote over 50 scripts in python and perl to transfer daily trade and accounting data from files on windows and linux servers to populate the Sybase tables.
- Created system documentation for all systems created in MS Sharepoint
- Created source code repository using SVN
- Conversion of MS Access data from derivatives trading system to enterprise wide Sybase database
- Wrote complex SQL queries to gather trade data from multiple databases and tables
Confidential, New York, NY
Vice President
Responsibilities:
- Wrote programs to perform both manager and portfolio analysis using C++, Excel VBA, C# and Matlab and MS Access
- Wrote programs to perform portfolio attribution used in client presentations to prove that the firm excelled at asset allocation
- Saved redemptions by creating a Java application whereby the client could blend different weights of portfolio products and chart their proforma returns
- Supervised risk intern. Interviewed and helped select risk intern from hundreds of applicants.
- Used Monte Carlo simulation in calculating Value at Risk reports
Confidential, New York, NY
COO/CTO
Responsibilities:
- Organized and lead meetings to gather requirements
- Wrote detailed and functional specs for web programmers for website design
- Wrote all front end data entry systems to manage the creation of all online exercises in Visual C# front end and MS Access database
- Created all SQL scripts and XML used to populated all MySQL tables used on website
- Directed the research and development of literacy and math software targeting the K - 6 market
- Managed all web programmers, testers, animators, and illustrators
- Supervised the production on all audio components of website and CD ROM including hiring of voice talent, directing sessions, and post audio production
- Supervised the writing and production of 36 children’s books which were both printed and put in pdf format for website
Confidential, New York, NY
Senior Systems Analyst
Responsibilities:
- Wrote remote data entry program and all programs and procedures to transfer the information back to the central office
- Wrote Client Server applications utilizing MS SQL server on the back end
Confidential, New York, NY
Developer
Responsibilities:
- Developed cross platform, PC and Macintosh, system to create purchase orders, sales orders and invoices
- Responsible for building and maintaining network
- Built custom CAD machines built using PRIMAVISION boards and WACOM tablets
Confidential, New York, NY
Developer
Responsibilities:
- Wrote compliance monitoring system used to track all NASD licensed representatives and their state affiliations reconciled against monthly trade data. s included:
- Integrated licensing data with clearing broker data to flag trade exceptions
- Developed application framework upon which other applications could be built