SUMMARY:

Business or developer role in financial services (I can do data operations, model support and programming)

TECHNICAL SKILLS:

• Agile (Scrum) methodology; Confidential ; VersionOne, Python; C#; VB.NET; VBA; financial model support; VBScript; Perl; SQL; Toad;
• SQL Server; Oracle; QTP; VSTO; Geneva; VALUE; Risque; Visual Studio; Microsoft Office; Visio; product design; XSLT; XML;
• Bloomberg; middle and back office support; language translation; teaching; business modeling; business and creative writing;
• PHP; MySQL; HTML; JavaScript; CSS; AJAX; jQuery; SEO; Apache; COM AddIn; fund accounting.

PROFESSIONAL EXPERIENCE:

Consultant

Python/VBA Developer

Responsibilities:

• Backtesting system development (financial trading) in Python: Database setup and operations Web scraping Usage of vendor API' Confidential for consuming data feeds and data wrangling Integration of disparate scripts for forming a self - contained system Signal and order generations as well as SOR Performance assessment and associated optimization (from metrics some of which undergo VBA processing)
• Formulate data strategies in the context of financial modeling.
• Give VBA programming lectures in classroom and distance learning (rework in progress) formats.

Confidential

VBA Developer

Responsibilities:

• Applied data abstraction as a linchpin of the new platform, a core goal was precise preservation of model data points.
• The abstraction was kept on the model level and consumed by other backend processes (other teams).
• Wrote a large set of VBA procedures to derive and stringently validate subtle model attributes.
• Formally managed the project via VersionOne (negotiation, allocation and execution of Stories and Tasks).
• There were no impediments reported by other teams stemming from my work in each Sprint meeting.
• I completed my deliverables within allocated times which contributed to the project’ Confidential momentum.

Confidential

Responsibilities:

• Integrated the CryptoAPI to obfuscate client defined data points available to general users while allowing authorized analysts to decrypt and re-encrypt the same data points for research at full depth, the implementation was in VBA.
• Wrote program profilers for assessing heuristic use of solution approaches in preparation for further optimization.
• User Interface (UserForms, ActiveX controls and Ribbon) development through quick iterations and pivots for optimal UX and RAD.
• Designed and implemented a frontend to a reporting engine, the logic was a mix of VBA, ADO and SQL code.
• Toad review of Oracle views, stored procedures and intermediate objects for implementing parameterized queries.
• Team collaboration leveraging Confidential for parallel task division and project deliverable acceleration.
• Performed heavy code integration (e.g. decoupling) to validate data, improve robustness and retrofit UI controls.
• Made exhaustive optimizations due to VBA limitations in parallel to developing Python alternatives.
• Fully satisfied a compliance concern by instituting an encryption alternative not acceptable in other ways.
• Rapid delivery of reports through the dovetailing of my frontend code with the backend code and after performing QA.
• The framework was made ambitious particularly by allowing multiple analysts to switch between test rounds (data sets), it was ambitious because each test round had a unique test objective as well as a large and divergent data set.
• Developed a model hierarchy structuring utility in VBA for model planning.
• Model support (data integrity, access security and version control) prior to release to the model oversight committee.
• Received official recognition for a deliverable (award received by the team’ Confidential manager).

Confidential

VBA Developer/Instructor/Entrepreneur

Responsibilities:

• Created an OMS prototype for the Americas region to meet an audit mandate on trade monitoring.
• Resolved auto-message communication problems between brokers and clearing firms and set up workflows.
• Developed back office solutions to integrate into the company’ Confidential software modules (data transformations).

Confidential

VBA Developer/Instructor

Responsibilities:

• Business projects in collaboration with a lead developer.
• Designed and taught a formal programming course, wrote a formal manual to standardize lecture pace.

Confidential

VBA Developer

Responsibilities:

• Development work for loading Outlook elements into Siebel and for detecting activities for emergency reporting.
• Administered a CRM portal for new clients and generated metrics for senior executives on project performance.
• Conducted root cause analyses to fix long-standing problems and help institute better CRM protocols.

Confidential

Business Systems Specialist - VBA Developer

Responsibilities:

• Geneva production and UAT support as well as trouble-shooting of trade and P&L discrepancies in the application.
• Developed conversion templates for hedge funds’ trade feeds and performed fund liquidations and migrations.
• Added subroutines to an in-house reconciliation program to accommodate new brokers.

Confidential

Data Analyst

Responsibilities:

• Data feed management and asset allocations in support of trading, risk management and securitization operations.