Sr. Consultant Resume
2.00/5 (Submit Your Rating)
SUMMARY
- 20+ Years experience in USA & India with development and implementation trading applications using
- Sybase. C, C++, SQL, SUN OS, Shell scripting (including Perl, SybPerl), Oracle. Implementation of Charles River Trading System, Development. Comfortable interacting with users, gathering and translating requirements, implementing the Solutions. Developed and managed various project implementations on various platforms.
- Demonstrated success in leading full project life cycle resulting in increased productivity, efficiency, saving time and money for the stake holders.
- Has extensive understanding of technology and practical utility of the same and able to suggest enterprise solutions that address current day changing and challenging requirements of fast paced business set ups. Ability to deliver the planned tasks on time and within budget constraints Able to lead and motivate to achieve optimum levels of performance from the team keeping in mind the objectives and constraints of the team members and technical professionals both internal and external. Have worked in Agile Environment
- Sybase, Database design/development and implementation for real time and high volume systems, C, Perl (Sybperl), Python, (Limited exposure to R) Good knowledge of Oracle. DRM (Oracle Hyperion), Experienced in fast paced and high pressure environment.
TECHNICAL EXPERIENCE
- Business Analysis
- Sybase
- PL/SQL
- Oracle
- Databases
- ETL
- Equities
- Fixed Income
- Trading Systems
- User Acceptance Testing
- Requirements Analysis
- Perl,Python
- Charles River
- Investment Management System
- Portia
PROFESSIONAL EXPERIENCE
Confidential
Sr. Consultant
Responsibilities:
- Design and create. Custom feeds for Charles River Trading System for instruments like Equities and Forex for day to day trading.
- The objective was to refresh data in CRTS on an intraday basis for different clients. Created a generic base API for import of various real time data (prices, ratings, x - rates for fx pairs) from standard data vendors into CRTS.
- Administration of Master Data using DRM (Oracle Hyperion) to manage chart of accounts like Data governance, Manage Versions, Hierarchies, Compares, Exports, Automators and Validations etc.
- Develop algorithms based on custom indexes for Share Khan group for their quant group ( e.g Moving averages cross over for slow trend reversals, etc the strategies were defined by their analysts and experts).
- The objective was to develop a black box environment for back testing for analysis of possible quant strategies.
Confidential
Sr. Consultant - (Contd.)
Responsibilities:
- Identify Infrastructural Needs.
- Feasibility Study and Cost Benefit Analysis.
- Data Conversion and ETL from Odion.
- Developing perl scripts, shell scripts.
- Interacting with vendors, prospective Clients.
- Business Development and Leading a team of 4 Business & data Analyst’s.
Confidential
Sr. Consultant (DTCC)
Responsibilities:
- Designed and developed a generic workflow engine for use with DTCC implementation. DTCC (Depository Trust and Clearing Corporation) is a central warehouse for trade settlements.
- Involved in gathering requirements and generating specifications for messaging and implementation of various legs of settlement (T-1, T, T+1, T+2 etc). Was the coordinator and SME for the senior organizing group (SOG) for DTCC implementation.
- Responsibilities included Technical Leadership and collection of specifications, understanding the various requirements of other corporations on testing/implementation phases and practices of the DTCC system across the various corporations.
- Platforms: Sybase, Perl (SybPerl), Java and JCash.
Confidential
Sr. Consultant - Charles River
Responsibilities:
- Involved in business analysis, scoping and configuration of Workflow for Charles River for business users of their Active Equity and Private Wealth Management implementation on Charles River.
- The current implementation uses XIP (McGregor) for Active Equity and Longview for PWM business ith a specialized order routing routine into different trader blotters divided by Order Size, Sector, Product, Capital Market and Program trade blotters based on percentage Median Daily Value computed over a specified period (generally 21 days).
- Platform: Charles River IMS, Oracle PL-SQL (UI Toad), Perl.
Confidential
Sr. Consultant - Stock Loan System
Responsibilities:
- Account Master Load. Streamline and optimize account master data load.
- The job was to get account information from various source (Mainframe) and load it in various Sybase tables.
- The job which used to take 7 hours and regularly failed disrupting business (especially Japan and Europe) was streamlined and redesigned so that there will be zero user down time. Currently the job is highly modular, re-runable and optimized. Repo accrual calculations.
- Calculates borrow rates and interest accruals for repo and gives users the data for risk analysis. Positions, Market values are extracted from diffferent systems and based on asset class buckets, the accrual calculations are applied to the repos enabling the users see risk exposure at an asset class level.
- Average Borrow Rate Calculations. Calculation of average borrow rate at security level so users can arrive at Profit and loss numbers at a profit center level based on rebalancing, the average borrow rate and the actual market value in fee or rebates terms.
Confidential, New York, NY
Consultant - Trading Systems
Responsibilities:
- OrderGen (Order Management System) Role: Interact with users and get their requirement, Design, Development and Implementation, Document Database Models, Business Logic and Meta-Data (Compliance) and Feeds (MDISS/Bloomberg), Portia.
- Multi-user/multithreaded Open Server Application.
- Transparent isql access to data (for administrators in passthrough mode)
- Automatic checking of orders (Compliance/ Oversells etc.) before they get to trading desk.
- Equity, Mutual funds and Fixed income orders.
- Send Equity trades/mutual funds/Fixed Income to their respective trading systems.
- Allow Front end development based on any Standard GUI.
- Interfaces with various proprietary trading systems like Predator (McGregor) (Object Store DBMS),
- Charles River (Sybase) and others (ADP) for Mutual Funds.
- Allows Rebalancing of portfolios. Generation of Block Trades.
- Event driven, three tier system that handles all protocols standard to Sybase.Daily Security Level Performance attribution for clients using Sybase, Stored procedure, Perl scripts,FactSet Portfolio Analysis.
- Daily security-level attribution for client portfolios (long-only) against relevant benchmark indices.
- Completely automated process for extracting holdings and transactions data from an accounting system and delivering that data to FactSet's Portfolio Analysis system.
- Trade (Mode) Interface (Charles River Compliance Check) Integrates with OMS system, Checking for compliance violations and alerts OMS users, enabling Users to review and override violations if required. Multiple modes of checking (Start of Day, Proposed and Send modes) Extensive auditing. Equities, FI and FX trades.
- Data Extract and Import into Charles River.
- Executions import into Portia for performance and porfolio accounting.
- Role: Design & develop stored procedures, Perl scripts needed to extract, scrub and import data into Charles River from other vendor OMS (eg Portia).
-