Business Analyst Resume
NY
SUMMARY:
- Around 9 years of experience as a Sr. Business Analyst in Finance/Investment banking/Compliance/Capital Market/Accounting domain.
- Working Knowledge on Dodd - Frank Act, Confidential .
- Working Knowledge of stocks, bonds, and depository receipts, futures, forwards, options, swaps, Fixed Income products Mortgage Backed Securities (MBS), Collateralized Mortgage Obligations (CMOs).
- Risk Management experience using VaR, Monet Carlo Simulation, Variance-Covariance and Historical Simulation. Calculation of Risk factors such as variance, standard deviation, Alpha, Beta, Capital Asset Pricing Model
- Experienced in preparation of Financial Statements - Balance Sheet and Profit & Loss Accounts, cash flow statements, revenue recognition, fixed assets, depreciation Schedules, Impairment of fixed assets, reconciliations, etc.
- Securities lending and borrowing, borrowing order requests, lending order requests, borrowing and lending message codes
- Measuring risk using metrics such as Duration and Convexity
- Analyze risks such as Total risk (common market and industry/asset specific), Active risk, allocation/ selection risk, etc, associated with instruments in various markets
- Collaborated with front office and made detailed business analysis for a new single integrated Market risk and Credit risk management processes- defining market risk, goals of market risk management, credit risk, goals of credit risk management and sources of credit risk.
- An innovative Business Analyst with a Master’s Degree in Business Administration, and over 7 years of experience in business process analysis/modeling, business requirements, database design and development of Web Based, and Client/Server applications.
- Actively used XML, XSD and XSLT formats from source systems, Mapping data items to target systems and building templates for Customized Dashboards.
- Experience in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
- Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP) and Agile.
- Involved in client reporting. Worked on manual reporting using Excel.
- Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.
- Extensive experience in conducting Joint Application Development (JAD) sessions.
- Expertise in broad range of technologies, including business process tools such as Microsoft Project, Microsoft Excel, MS Access, MS Visio, technical assessment tools.
- Responsible for supporting and managing database activity during the development cycle.
- Proactive database monitoring and maintenance to locate and prevent future problems
- Worked extensively in SQL Queries using Joins, Alias, Sub-query, nested query, different operators etc in SQL & Oracle database.
- Experience in SOA architecture wherein we had to in corporate web service calls (using SOAP XML) for the compliance module.
- Performed backend testing using SQL queries to check the data accuracy and integrity.
- Exposure to Version Controlling Tool like SVN and CVS.
- Worked closely with Project manager, business and IT team to build test plan, test cases, perform unit testing, system testing and integration testing during multiple releases and helping to migrate into production.
TECHNICAL SKILLS:
Modeling Languages: UML
Database Languages: SQL
Databases: SQL Server, Oracle, MS Access
Microsoft Tools: MS Office, MS Outlook, MS Visio
Visual Modeling Tools: Rational Rose, MS Visio
Operating Systems: Windows 95/98/2000/XP, UNIX, Linux
PROFESSIONAL EXPERIENCE:
Confidential, NY
Business Analyst
Responsibilities:
- Collaborate with Users, Project Management and Technology team.
- Captured detailed business requirements required to move from the legacy Confidential to a more advanced system Pulse.
- Prepare User stories in JIRA for development. Analyzed processes and dataflow of legacy system to create the requirements for the new system.
- Work with Business to get various approvals and sing offs.
- Conducted meetings and JAD sessions with Subject Matter Experts, Technology teams and other stakeholders in order to understand the end user requirements to best design the functionality for the application.
- Prepared UAT test cases.
- Assisted testing team in identifying test scenarios and defects.
- Review test cases created by testing team.
- Conducting training for QA teams, RTB team, GIS team and other developers in the team.
- Conducted demo with user to show and review modification made to existing usage of functionality.
- Created mock up and prototype using online tool Justinmind and MS paint for better user experience.
- Use Agile methodology for sprint planning.
- Reviewed and assisted the QA testers with the development of project test plans. Used QC to build test cases and document the test results.
- Used SQL and JAVA codes of existing application for requirement analysis.
- Lead & Interact with dev team and QA team on daily basis to clear gaps if any.
- Coordinated to work with teams in different region Asia, Europe and America.
- Coordinated with users and QA team to test the application in production on release and get sign off.
Environnent : SQL Server, MS Access, Agile, XML, Windows, Java
Confidential, NY
Senior Business Analyst
Responsibilities:
- Collaborate with Legal, Compliance, Change Management, Product Control and Technology team.
- Captured detailed business requirements required to setup VOLT Fund Assessment, Survey Review, Reference data and report generation module in Business Objects.
- Prepared documents such as BRD. Analyzed processes and dataflow specific to question logic, Primary & Secondary category.
- Worked with Business to get various approvals and sing offs.
- Conducted meetings and JAD sessions with Subject Matter Experts, Legal, compliance and other stakeholders in order to understand the end user requirements to best design the functionality of the application.
- Collaborated with PM in developing Project Plans, doing business analysis, preparing Business Requirements Document, Functional Specification Document and Testing during SDLC.
- Prepared UAT test cases.
- Assisted testing team in identifying test scenarios and defects.
- Conducting user training by helping design training manuals and providing in person training sessions to end users, to facilitate the use of application.
- Involved in UAT testing with Legal and Compliance Users and get sign off.
- Used MS Visio to design and develop Use Cases Scenarios, Use Cases Models, and Sequence Diagrams and Process Flow diagrams.
- Successfully used agile methodology in which the project was divided in phases called Sprints. Used Jira to write User stories.
- Involved in performance testing, functional testing, Smoke testing, regression testing, integration testing and performance testing.
- Reviewed and assisted the QA testers with the development of project test plans. Used QC to build test cases and document the test results.
- Assisted Development team in setting up different roles and permissions in the system.
- Used SQL throughout the project to check user information, access and status of the assessments.
- Used SQL to identify the user issues and help RTB team to resolve the issues.
Environnent : SQL Server, MS Access, Agile, XML, Linux, UNIX, C#
Confidential, NY
Senior Business Analyst
Responsibilities:
- Collaborate with traders, Financial Engineers, Risk Management, Product Control and Technology team.
- Captured detailed business requirements required to setup risk summary, asset view, portfolio browser and report generation module in total risk navigation window.
- Prepared documents such as BRD and FRD. Analyzed processes and dataflow specific to risk calculations.
- Gathered and managed requirements by using Requisite pro and MS Office.
- Conducted meetings and JAD sessions with Subject Matter Experts, Portfolio managers, Risk Analysts (under Risk Managers) and other stakeholders in order to understand the end user requirements to best design the functionality of the application.
- Collaborated with PM in developing Project Plans, doing business analysis, preparing Business Requirements Document, Functional Specification Document and Testing during SDLC.
- Created project-initiation diagrams including business use cases, activity diagrams, sequence diagrams, class charts and entity-relationship.
- Used SQL throughout the project for queries and validating data flow.
- Used MS Excel to create client report and give status update during monthly meetings.
- Used XML message formats to retrieve reference data from third party
- Assisted testing team in identifying test scenarios and defects. Also conducted functional flow testing, integration and performance testing.
- Assisted in Gap Analysis.
- Assisted in conducting user training by helping design training manuals and in providing in person training sessions to end users, so as to facilitate the use of application.
- Used MS Visio to design and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams and Sequence Diagrams.
- Successfully employed Agile Scrum methodology in which the project was divided in phases called Sprints.
- Involved in performance testing, functional testing, Regression testing and integration testing. Reviewed and assisted the QA testers with the development of project test plans
Environment: Java, J2EE, SQL Server, MS Access, Agile, XML, Web Services, CVS, Unix
Confidential
Jr. Business Analyst
Responsibilities:
- Worked on Financial Statement Analysis and Financial Reporting.
- Analyze the Financial Statements and Financial Reports to derive at the DSCR.
- Worked closely with the business users for identifying different type of functionality we should be capturing and reporting as part of the application
- Provided desk support for the any update on the application
- Involved in design and discussions of various system functionalities.
- Worked with research team on identifying the various sources of retrieving data.
- Worked with users on generating the DSCR (Debt Service Coverage Ratio) reports.
- Involved in pre and post financial analysis.
Environment: .NET, MS Excel, SQL, QC, VSS, Unix, Windows XP,
Confidential
Jr. Accountant Analyst
Responsibilities:
- Dealing with various Confidential.
- Reconciliation of various accounts and rectifying the entries to balance the accounts.
- Liaison with counter parts in US to resolve the issue and Queries of the customers.
- Sending Notification to the banking centers Vice President to reconcile the official items.
- Preparing EZREC Month end Corporate Financial control report.
- Responsible for day to day Transaction Processing with quality and control and reporting the operations in assigned team.
- Handling and managing the training schedules for new joiners’. .
- Identify the growth plan for the members within the team and assigning mandatory trainings.
- Worked closely with the business users for identifying different type of functionality we should be capturing and reporting as part of the application
- Provided desk support for the any update on the application
- Involved in design and discussions of various system functionalities.
- Worked with research team on identifying the various sources of retrieving data.
Environment: MS Office, Oracle