Systems Programmer Resume Profile
4.00/5 (Submit Your Rating)
Summary:
- Extensive experience in analysis and documentation of business processes and procedures, recommend improvements to enhance efficiency, improve workflow and/or solve problems.
- Developed the business, functional, and technical requirements needed to ensure that the technology solutions delivered that meet the needs of the organization and end users..
- Worked with Front-office users and brokers to obtain Business and functional requirements for Equity Derivative products.
- Implemented Dodd-Frank rules on SEF Equity derivative platform for tpSEF including DTCC SDR reporting and NFA compliance.
- Have Superior Financial Product knowledge of, FX, FX options, IRD US, Mexican , Fixed Income and Energy Products.
- Reviewed, analyzed, and evaluated user requests and administrative activities to determine the scope of operational and informational needs.
- Fully involved in reference data management including mapping reference data between systems.
- Conducted system level testing and assisted the end-users with UAT.
- Highly problem solving skills with effective solution.
- Familiar with FINRA, SEC regulation requirements.
- Designed and developed end to End functionality for equities to satisfy Dodd-frank regulations.
- Have More than 20 years of experience at various levels in Business analysis, Project Management, databases and system Administration, Maintenance and development.
- Worked on database maintenance, programming and System Administration.
- Knowledge in Oracle, Informix and SQL Server administration.
- Proficient in SQL Queries.
- Used various tools such as SQL Plus, Toad, PL/SQL, and SQL Loader for oracle and ISQL, ESQL, Informix 4gl for Informix.
- Highly proficient in relational databases and FPML
- Experienced in UNIX, Linux and Windows operating systems.
- Good knowledge of Shell Scripting.
- Managed projects effectively using software like Microsoft Project, Visio, Word, Excel, JIRA, Service Now and SharePoint.
WORK EXPERIENCE:
Confidential
Role: Business Technology Manager-Equities
- The tpEquityTrade platform was built to comply with Derivatives Reform Program: Dodd-Frank Act Title VII for Equity Derivative products. The platform supports both in-scope and out-of-scope products of Dodd Frank Regulations that includes OTC Options, Variance Swap, Total Return Swap and dividend Swap.
- Elicited Business and Functional requirements from Business Users and Subject Matter Experts for Equity Derivative product development and Dodd Frank Requirements.
- Defined Documented, Analyzed and Prioritized requirements and modeled the requirements/specifications.
- Designed the trade screens and workflows diagrams for better understanding for developers and QA teams
- Liaised with various integration teams to develop connectivity to internal/external systems to achieve straight through processing
- Created a gap analysis/Mapping document for trade flow between systems.
- Interviewed Middle Office users and Operations to understand their current business processes, identified and assessed functional requirements.
- Managed Issues and enhancements with JIRA and Service now.
- Formulated and Implemented strategies for resolving data integrity issues assisting in operational rollout and support.
- Worked in conjunction with Business, Operations, Tech teams to ensure timely delivery of new enhancements per stakeholder request.
- Effectively communicated the progress of the project to all the Stake holders and Executive Committee Members.
- Attended Weekly SEF Steering Committee meetings and involved in the discussion of Dodd Frank Regulation.
- Assisted the support teams in resolving the reference data issues.
- Worked with external teams like DTCC, MarkitWire and NFA in the integration process and resolved the issues during the integration.
- Implemented Customer Hierarchy SD, MSP, ECP and other in the reference data to determine reporting party.
- Involved in enhancing the OMS and DMS to support Multi-Broker functionality in order to comply with Dodd Frank SEF regulation of Introducing Broker Model.
Project: Exchange For Physical Electronic Trading
- Confidential is enhanced to add new functionality of EFP product in order to achieve straight through processing without any manual intervention during the trade process. Upon future execution the system can determine the futures and Stock prices. The system has integrated with ACT and CME for clearing S P's Stock and Future trades.
- Elicited Business and Functional requirements from Business Users.
- Defined Documented, Analyzed and Prioritized requirements and modeled the requirements/specifications.
- Worked with Vendor in implementing the Requirements.
- Liaised with various integration teams to integrate with ACT and CME.
- Managed Issues and enhancements with JIRA and Service now.
- Worked in conjunction with Business, Operations, Tech teams to ensure timely delivery of new enhancements per stakeholder request.
- Effectively communicated the progress of the project to all the Stake holders and Executive Committee Members.
Project: MIXIT OMS Implementation
- This project is initiated in order to receive and notify executions of the Equity orders electronically to the customer.
- Evaluated several OMS's available in the market and selected MIXIT OMS for receiving orders electronically for Listed Equities.
- Worked with REDI Plus and MIXIT teams to stage orders to Redi Plus for Executions and clearing the trades at Goldman.
- Coordinated the building of several fixed inbound/outbound connections between Tullett's OMS, Floor Brokers and customers OMS for receiving/sending orders electronically for execution. This includes working with Fix and OMS Vendors.
- Managed implementation and upgrade of several order executions systems OES like WEX wolverine execution system , Liquid Point Blaze, Real Tick and ISE.
Project: ABN Clearing
- The Confidential is initiated for the customers who clear their Equity trades through ABN. This project initiated in order to reduce trading cost to ABN clearing customers.
- Reviewed and Evaluated FIX 4.2 and 4.0 message specifications provided by ABN AMRO
- Gathered the requirements and written both business and Functional Requirements.
- Worked with development teams to generate fix messages and trade data mapping from Equity trades.
- Coordinated the building of fix connection using VPN tunneling with internal and external network teams.
- Involved in testing of connectivity and trade fix messages with ABN.
- Managed implementation and user training in sending trades to ABN for clearing.
Role: Business Analyst
- The Magic Marker was a price distribution system in which the bid/offer prices distributed to the customers via ENI, BWC and Bloomberg green pages. The application is built on Java technologies..
- Elicited Business and Functional requirements from EMIRD Business Users and Middle office users.
- Defined Documented, Analyzed and Prioritized requirements and modeled the requirements/specifications.
- Designed workflows diagrams for better understanding for developers and QA teams
- Liaised with integration team and Bloomberg to publish prices to Bloomberg green pages.
- Worked major Investment banks in building and testing of the BWC connectivity.
- Interviewed Middle Office users and Operations to understand their current business processes, identified and assessed functional requirements.
- Managed Issues and enhancements with JIRA and Service now.
- Trained the EMIRD Brokers entering prices using pecker pads.
- Worked in conjunction with Business, Operations, Tech teams to ensure timely delivery of the system as per stakeholder request.
- Effectively communicated the progress of the project to all the Stake holders
- Involved in End to-End process of design, development, Testing and implementation.
Project: DMS:EMIRD Options Interest Rate Derivatives
- The DMS for EMIRD options is created to handle trade processing , confirmation and Integration with MarkitWire.
- Gathered Business and Functional requirements from EMIRD Business Users and Middle office users.
- Defined Documented, Analyzed and Prioritized requirements and modeled the requirements/specifications.
- Designed workflows diagrams for better understanding for developers and QA teams
- Liaised with integration team to integrate with MarkitWire.
- Interviewed Middle Office users and Operations to understand their current business processes, identified and assessed functional requirements.
- Managed Issues and enhancements with JIRA and Service now.
- Trained the Middle office users with the new trade entry screens.
- Worked in conjunction with Business, Operations, Tech teams to ensure timely delivery of the system as per stakeholder request.
- Effectively communicated the progress of the project to all the Stake holders
- Involved in End to-End process of design, development, Testing and implementation.
Role: Production systems Manager
- After Prebon merged with Tullett, Managed successful migration of applications to Tullett systems. Written gap analysis of equities, EM options, FX, FX option products.
- Defined Documented, Analyzed and Prioritized requirements and modeled the requirements/specifications.
- Managed the requirement of each product to make sure the implementations done properly.
- Worked with the development to implement the gaps in Tullett systems.
- Involved in UAT and user training.
- Created the scripts for Reference data download.
- Trade history migration.
- Validated the Monthly invoices with existing system.
Confidential
Role: Production systems Manager/Sr. Database Administrator
As DBA and production systems manager, successfully managed team of six people including system analysts, developers and QA.
Project: Global Broking system GBS
- The GBS includes the functionality of trading, Deal management and Straight through processing.
- Involved in building various environments like QA, UAT and Production.
- Managed Oracle Databases, Web Logic EJB Servers and XML files. Supported test team with the issues during testing process.
- Involved in jumpstarting servers with the new releases and migrating data from old schema to new schema for Developers.
- Supported the test team and developers with trade posting issues like data mapping from front office system to Back-office system.
Role: Database Administrator
- Worked as DBA for Oracle, Informix, and SQL server in various projects.
- Involved in Application Support, OS and Database upgrades and Maintenance,
- Backup and recovery.
- Used various SQL tools like Toad and SQLPLUS to generate reports for users..
- Developed various interfaces using shell scripts and Informix 4gl to communicate between systems to consolidate data.
- Designed and Developed interface to PGTRAX index to provide power and gas price at the end of day.
- Designed and developed interfaces to clearing houses for clearing the trades.
- Installed and managed oracle HA cluster for Yamane Connect project. Involved in load, performance and fail over testing. Managed development, test, demo, and production databases.
- Migrated entire back-office systems to new infrastructure and converted the MBS application from standalone to client server architecture.
- Configured and managed tools like PVCS Tracker, Version Control.
- Installed and configured Rational Rose, Rational requisite pro
Confidential
Systems programmer/Analyst
- Managed and supported the order processing system which includes Fabrication, Inventory, Depot inventory, Label tracking and customer service.
- Developed Barcode for the item parts produced in production for easy tracking.
- Informix- tools like 4GL and ISQL used for the development and changes to the application.
- Managed Accounting system which includes payroll, time tracking and employee information.
- Administered and supported Informix database and UNIX.
- Managed the Backup and recovery for the Database and application.
- Supported all technical needs including printer setup, Phone setup, making of RJ-45 Cable.
Confidential
Programmer/Analyst
- As a programmer Analyst, Responsible for day to day issues in the fixed deposits system also known as FDS. Simultaneously, implement new enhancement based on the new requirements.
- Involved in development and the improvements of the Fixed Asset Management system that keeps track of fixed assets of the organization.
- Involved in the maintenance of the Fixed Deposit System that include improvements of the application.
- Developed shell scripts to automate cron jobs to generate interest income certificates based on the maturity of the fixed deposits. The FDS development was done in COBOL.
- Involved in the enhancements of purchase order system that used for entering the purchase orders and Maintenance of Vendors and their payment information..
- Administered and Supported the UNIX platform with day to day issues.
- Managed the Backups and restore.
- Tape Rotation.
Confidential
Systems Support Executive
- As a system support executive, responsible for support students with day to day with projects and programming questions and keep the system live during the business hours. Also, worked as Faculty for teaching students in UNIX, C and Oracle.
- Supported the training institute with maintenance of UNIX Administration on UNISYS 6000.
- Trained students in UNIX, C, and Oracle
- Assisted students with their projects towards the end of training.
- Backups and system restore
- Tape management.
