Business Systems Analyst Resume
SUMMARY:
- Over 10 years of progressive Information Technology (IT) experience in Finance Domain with a focus on Project and Business Analysis on web based and client server applications.
- Seeking a Business Systems Analyst/Business Development Consultant position which will allow me to utilize my experiences holistically and leverage my knowledge in finance domain.
- Finance & Business Management professional currently spearheading as Business Systems Analyst and Business Development Consultant ( Confidential Domain) at Confidential Ltd.
- Possess an inquisitive & analytical mind, creative thinking, excellent organizational skills, flexible & detail oriented attitude combined with strong analytical & information analysis skills and a proven ability to interact with a diverse range of people in a professional manner.
- Visionary leadership in assessing client needs, and strategically positioning programs aligned with customer and market needs/ projections. Solutions oriented approach with excellent relationship management skills. Ability to manage relationships from executive level people at the customer to technical contributors of the organization.
- Excellent communication skills with the ability to clearly formulate issues and recommendations and delivering effective presentations. Ability to articulate the value proposition of key industry messages and technologies.
- Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications FRS, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document(SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams
TECHNICAL SKILLS:
Technical: Wealth Management Advisor Onboarding, Reporting, Advisor Maintenance Fixed Income Attribution, reconciliation, corporate actions, pricing Equities Reconciliations, corporate actions, trading, pricing. Collateral Management Derivatives (OTC, Exchange Traded) Futures and Forwards Reconciliations (cash and trade) Corporate Actions and Class Actions MIS and Client Reporting Loan Management (Securitization, Syndication, Lease) Securities Processing Data analysis and cleansing Data mapping, data mining Data Dictionaries Analysis, testing through usage of SQL queries and commands Data definitions and use cases Analysis of stored procedures Unix MS Visio MS Office suite Agile and lean software development process Business and systems analysis and documentation System integration, regression and user acceptance testing Working closely with the QA/QC Team on defect analysis and remediation Working closely with the Data Governance Team Working closely with the Oracle Business Intelligence Enterprise Edition (OBIEE) Team to develop necessary reports based on business requirements Advised on process improvement and data quality issues Creation of and documentation of Change Requests Entering, updating, and closing defects/change requests in HP Quality Center
PROFESSIONAL EXPERIENCE:
Confidential
Business Systems Analyst
Responsibilities:
- Development of a web application (mobile browser compatible)
- Improved User Interface
- Automated workflow
- Additional/Enhanced validations and notifications
- PC, tablet and mobile compatibility introduced
- Data analysis, aggregation and cleansing. Automated data flow into downstream applications
- Extensive data mining, data cleansing and analysis
- Source to target mapping
- Consistency of rules
- Data staging and transfer to live tables
- Automated notifications to HOS teams during various stages
- Defining hierarchy based access
- Introduction of TIBCO services to automate the data flow into downstream applications from the Web Form UI
- Enabling Advisor Facing Technology and providing Advisors and Home Office with completely automated workflow solution to process Advisor Registration activities.
- Keeping pace with the industry standards while optimizing the way advisors register to sell securities, state registrations, and insurance appointments
- Defining IAR, RIA, Admin hierarchies within the workflows.
- Automated notifications, emails and validations
- Integration and implementation of automated internal and external feeds (FINRA, NIPR)
- Eliminate the double and - at times - triple entry of advisor data into multiple systems
- Ease of current and future compliance with regulations that are affecting the advisor wealth management space
Skillsets: Requirement Elicitation, Scoping, Data Analysis, Requirements Analysis, Documentation, Testing
Confidential
Business Systems Analyst
Responsibilities:
- Development of new functionalities to cater to the Dodd Frank and EMIR regulations.
- Enabling exchange traded derivatives to comply with regulations. Performing impact analysis, regulatory analysis and implementation of the functionalities across various applications within the landscape.
- Enabling additional reporting requirements for cleared and non-cleared derivatives
- Reporting to DTCC and other regulatory authorities
- Setup of Legal Entity Identifiers in the data system
- Accounting functionalities to add new CCP exchanges for derivatives.
- Enhancements to all systems in scope to cater to various kinds of derivatives instruments that are traded through exchanges
- Functionalities to monitor the collateral requirements for initial margin and variation margin on derivative trading post Dodd Frank and EMIR
- Data mapping and Creation of Unique Trade Identifiers and files (position, collateral and valuation) that contain all records that pertain to accounts with all eligible EMIR records. This is as per the new EMIR regulations. Ensure accurate reporting to all stakeholders and regulatory authorities.
- Development of new functionalities to accurately account for margin movements for Futures and CCP products. To reduce the frequency of cash wire settlement between FCM (Futures Commission Merchant) and custodian bank and allow for systematic record keeping of balances at the FCM. Automated workflow to analyse the balances’ excess or deficit status in relation to a limit balance and process ad hoc cash wires as needed.
- Enhancements to various accounting functionalities in the collateral management space. Enhancements to the directives sent to banks and brokers within the collateral space.
- Analysis and documentation of platform and system conversions
- Analysis and documentation of report cycles, database conversions and enhancements, systems and table decommissions
- Client on-boarding - Analysis of the new system landscape. Functional testing of all the possible scenarios during the client on-boarding process.
- Enabling CNY as a deliverable currency for stocks/bonds and FX trades
- Wealth Management experience relating to investment management and related sub function groups (asset management, fund accounting, reconciliations, corporate actions etc.),maintenance and setup of HNI accounts, enhancing systems and data to enhance client reporting based on the requirements laid down under various regulations such as Dodd frank, EMIR. Ensuring enhanced client reporting transparency, cutting down operational costs through IT system enhancement projects, open source reporting, elimination of data redundancy and data duplication across the WM system landscape.
- RFP/RFI/RFQ responses across Industry verticals and geographies
- Maintain liaison with the Sales team by proactive research of potential areas of business acquisition, gathering future client expectations and requirements as per continuous economic, financial and regulatory changes
- Preparing Case studies for all the Engagements, Methodologies and Processes and maintain a Global Reusable Repository; Working on developing an online global repository
- Ensuring Domain Expertise as a competitive differentiator for the Company. Formation of virtual Domain Practice Teams. The Scope of Domain Practice Activities include:
- Preparation of white papers, research reports, sales pitch presentations
- Functional Assistance in creation of POC’s
- Tracking Business Trends
- Talent Development
- Determination of Cost/Time Estimations
- Preparation and presentation of Domain Capability Stories
- Project Fitment of Domain skills
Confidential
Business Systems Analyst
Responsibilities:
- Requirement gathering and analysis of the overall functioning of the Front office, Mid Office and Back Office operations at a leading wealth management and brokerage firm. Primary intention of complete systems integration and implementation of a PWM solution to gear up for the future increase in operations at all levels.
- Enterprise Analysis
- Existing business operations analysis/understanding
- Project Scoping
- Requirements gathering and elicitation
- Preparation of the Business requirements, Technical solutions and interaction with the Oracle sales team to determine the exact solution in sync with the budget constraints and future opportunities
- Presenting Oracle solution proposition to the client
- Stable Value Fund Accounting and Invoicing System (Fixed Income): Enhancing the current accounting application that dealt primarily with back-office and mid-office operations for the management of Fixed Income and Pooled Fund Instruments for one of the leading investment managers in the USA.
- Functionality upgrade to cater to accounting of the Stable Value Funds and enable systematic accounting process for traditional and synthetic contracts and its processing within the system.
- Enable fair value accounting concept
- Development of reports adhering to the Fair Value accounting and reporting rules as laid down by FASB, client and Back Office Reporting. Enhancement of existing reports to accurately reflect the fair value accounting concept
- Account and Contract detailed report, Holdings report, Trade Settlement Report, Pending/Open Trades Report
- Interest Accrual Report, Expense Accrual Report
- Fair Value Report, Fair Value Change Report
- NAV Report etc.
- Development of new invoice templates that reflected the monthly, quarterly billing for each Client - Account - Portfolio.
- RFP/RFI/RFQ responses across Industry verticals and geographies
- Proactive research of potential areas of business acquisition, gathering future client expectations and requirements as per continuous economic, financial and regulatory changes
- Creation of case studies for all the Engagements, Methodologies and Processes
- Managing entire life cycle of a Corporate Action event on securities held in respective IM portfolio. Validation of event with market sources, setting up of event in system, Informing IMs on the upcoming event, Coordinating for Responses on Voluntary events, processing entitlements in the accounting books. Ensuring that all dividend income is booked accurately and timely in the system.
- Management of “upstream” issues with respect to integrity of booking process in risk management systems, liaison with stakeholders and other support groups e.g. IT with respect to on-going issues.
- Analysis of various class action proceedings and tracking them via various vendors and sources.
- Filing Proof of claims for various class actions involving Morgan Stanley or its clients.
- Filing relevant transactions and holdings within the class period before the last date of filing as per court and following up to ensure that claim is received.
- Comparison of Total Portfolio reflected by MSIM and the Fund Accountant which entailed detailed asset level check and reporting of Variances
- Developed an understanding of Transaction Processing Risk and ensuring compliance with all TPRA/Audit/Regulatory requirements
Confidential
Financial Services - Capital Markets
Responsibilities:
- Data Analyst in the CDO (Collateral Debt Obligations) and Account Maintenance Business
- Setting up of the deal structure as per deal trading executed and maintenance of the SPV structure so set up.
- Set up of the investor information on various systems and ensuring timely coupon payouts and entitlements.
- Maintenance of accounts pertaining to the Issuer and Bondholder.
- Setting up of Issuers in the system and resolving their queries that relate to lost cheques, delayed interest payments, lost s, duplicate s, coupons etc.