Senior Business Analyst
First Sentier Investors
Total years of experience :12 years, 8 Months
• Project coordinating and implementing solutions for multiple teams such as VRS, Eagle, Website and Data teams.
• Documentation for legacy migration processes and documenting the As Is / To Be process, current and future state architecture, data sources, data sets, files specifications, filtering, and transformation logic.
• Coordinating with business stakeholders from Heads of Departments, Risk and Compli-ance, Product, Distribution and Marketing teams to elicit, document and prioritize business requirements.
• Coordinating with 3rd party data providers to set up data feeds, reference data feeds for re-porting.
• Creating UAT/PIV test cases and participating in BA Testing, planning and effort estima-tion, UAT and Post Implementation Testing, coordinating releases with DevOps.
• Creating business requirement documents and user stories for the 3rd party software re-quired for the remediation project.
• Working with relevant stakeholders to gather business requirements.
• Setting up workshops with relevant stakeholders.
• Data analysis, data visualization and creation of technical BRDs
• Working with 3rd party vendors and software providers.
• Writing user requirements and creating using stories around requirements.
• Tracking project progress using JIRA, Kanban boards.
• Working with the project manager and business to capture requirements.
• Analyzing and documenting functionality of legacy applications used by Traders / IT / Front Office teams.
• Analysis and mitigating of risks associated with older/legacy applications.
• Analyzing and advising on migration of multiple legacy Excel VBA and MS Access applica-tions from older versions of Office to Office 365.
• Analyzing existing server infrastructure for migration to new server infrastructure.
• Analyzing existing solutions, creating as is / to be documentation.
· Collaborating with project manager to analyze data sources, defining query logic that effec-tively captures business information requirements for both current and future business pro-cesses.
· Setting up of user profiles, software configuration and data governance.
· Assisting Project Manager to develop strategies for continuous improvement of business data processes.
· Creating the user interfaces using HTML5, CSS, JavaScript & jQuery
· Creating Business Requirement documents and Technical Specification documents.
· Assisting Business/Technical team to verify the data integrity of reports and data.
· Enhancing product, reports and product functionality customized to client requirements.
· Creating test cases and coordinating UAT Testing.
· Senior Business Analyst for the WIB Derivatives Authorization team part of the WIB Risk Data Management Team.
· Collaborating with the business team to analyze data sources to define query logic to cap-ture business information requirements.
· Collaborating with the business team to verify the data integrity of reports and data.
· Control processes/MIS - absence of accuracy concerns; no significant issues identified in audit reports; stakeholder/ business partner management.
· Creating detailed project management plans, project scope, and project timelines.
· Project coordinating for upgrading for all systems in IPC and upgrading Genesys an exist-ing telephone call management application.
· Interviewing stakeholders, eliciting requirements, creating as-is/to-be workflows and docu-menting project requirements.
· Creating as is / to be business workflows.
· Collaborating with the Project Manager for data analysis and reporting.
· Creating the UI using Excel with MS Access database for reporting purposes.
· Visualization of Data and reporting using a range of charts and tables in Excel and Power-Point and Visio.
· Documenting table structures and creating ER diagrams and schemas.
· Designing and Creating user Interfaces, creating screen mockups and application proto-types.
· Enhancing and developing MS Access Projects built with MS Access Front End and SQL Server 2008 database.
· Advising on methods to optimize existing systems and creating business requirement doc-uments. Providing weekly updates to the clients to track project status.
· Creating test cases, Unit testing, Integration testing and facilitating UAT.
· Conducting Training Sessions with Business users.
Achievements:
· Successfully created a tool called Korea Short Sell tool using C#, VBA Excel and WPF with SQL Server and Sybase databases in a short period of time to meet Korea regulators requirements.
Responsibilities:
· Product documentation, project planning and requirement analysis.
· Creating and maintaining Excel VBA and Dot. Net Front Office tools using SWIFT proto-cols.
· Creating Middle Office/Front Office applications such as trade blotters, termsheet genera-tors, trade confirmation mailers and analytical tools for financial products such as F&O, Equities, Derivatives, Warrants and Bonds across Hong Kong, Tokyo, London and Mumbai regions.