We provide IT Staff Augmentation Services!

Senior Business Analyst Resume

NY

PROFESSIONAL SUMMARY:

  • Over 7+ years of experience as a Senior Business Analyst in Finance/Investment banking/Insurance/Tax & Accounting domains with knowledge of Capital Markets, Equities and Derivatives products including Futures, Options (OTC and Exchange traded), Swaps (Equity, CDS, Commodity and Fx), Risk Management, Fixed Income, and Revenue Analysis.
  • Working Knowledge of stocks, bonds, futures, forwards, options, swaps, Collateralized Mortgage Obligations (CMOs) and Taxes.
  • Securities lending and borrowing, borrowing order requests, lending order requests, borrowing and lending message codes
  • Hands on experience with Equity Trading Systems, configuring and supporting Trading systems - Trade Blotter, Manager Work Bench, Compliance & Data feed ( Bloomberg)
  • Risk Management experience using VaR, Monte Carlo Simulation, Variance-Covariance and Historical Simulation. Calculation of Risk factors such as variance, standard deviation, Alpha, Beta, Capital Asset Pricing Model
  • 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 market.
  • Garnered vast experience & domain knowledge in US Taxation which includes entire tax administration process for Property tax, Real estate Tax and Corporate tax
  • Extensive hands-on experience in Insurance Point of Sale (POS) and Policy administration systems, Rating, underwriting and policy procedures. Involved in a large multi-state POS product roll out initiative
  • Worked on initiatives for sales force effectiveness and interacted with various user groups while being part of the Sales & Market and eBiz business teams at AAA( Confidential )
  • An innovative Business Analyst with a Master’s Degree in Business Administration, and over 7 years of experience in gathering requirements and creating Business Requirements Document (BRD) and Functional Requirement Specification (FRS) documents, writing Use cases, facilitating Joint Application Development (JAD) sessions, and developing use cases and test scenarios.
  • Experience in translating business requirements and user expectations into detailed specifications employing various Business analysis tools & techniques.
  • Proficient in UML - Use case Diagrams, Activity Diagrams, Data Flow diagrams & Sequence Diagrams using MS Visio.
  • Experienced in working with technical, DBA, QA and business teams (business users &sales teams).
  • Excellent interpersonal skills and effective at interviewing business users, stakeholders and subject matter experts (SME's) and eliciting needs and translating those needs into concise functional and non-functional requirements.
  • Extensive experience in Software Development Life Cycle (SDLC), Project management life cycle (PLC) and various SDLC methodologies such as waterfall, RUP, iterative, and Agile/Scrum.
  • Hands on experience of writing SQL Queries against MS SQL Server, Oracle and MS Access databases. Extensive knowledge on basic and complex SQL queries using Joins, Alias, Sub-query, nested query, different operators etc.
  • Have worked with database management teams to create/update data models to cater to new requirements and enhancements.
  • Performed backend testing using SQL queries to check the data accuracy and integrity.
  • Proven expertise in Application Testing activities such conducting user acceptance tests (UAT) which includes maintaining/updating test plans, defect tracking on Quality Center, issue management and resolution and hands-on creation and execution of high level test cases/scenarios and detailed test scripts. Also created Requirement Traceability Matrix (RTM) and conducted high level manual testing.
  • Actively used XML, XSD and XSLT formats from source systems, Mapping data items to target systems and building templates for Customized Dashboards.
  • Experience in SOA architecture wherein we had to in corporate web service calls (using SOAP XML) for the compliance module.
  • Exposure to Version Controlling Tool like SVN and CVS.
  • Expertise in broad range of technologies, including business process tools such as Microsoft Project, Microsoft Excel, MS Access, MS Visio, technical assessment tools.
  • 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.
  • Hands-on experience in developing Reports & Charts in Excel, Access and PowerPoint using, VLookup, Advanced Nested Formulas and Pivot Tables.

TECHNICAL PROFICIENCY:

Modeling Languages: UML

Database Languages: SQL

Databases: SQL Server, Oracle, MS Access

Tools: MS Office, MS Outlook, MS Visio, Rally

Visual Modeling Tools: Rational Rose, MS Visio

Operating Systems: Windows 95/98/2000/XP, Unix, Linux

PROFESSIONAL EXPERIENCE:

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 use cases, activity diagrams, sequence diagrams, class charts & entity-relationship.
  • Used SQL throughout the project for queries and validating data flow.
  • While doing the data analysis using SQL queries, worked extensively on Joins, Alias, Sub-query, nested query, different operators etc in SQL & Oracle database.
  • Used XML message formats to retrieve 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 by helping design manuals and in providing in person 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 and integration testing. Reviewed and assisted the QA testers with the development of project test plans

Confidential, NY

Business Analyst

Responsibilities:

  • Conducted JAD sessions in gathering business requirements from traders, portfolio and investment managers
  • Assisted in developing a business analysis model describing the fine points of business processes such as business workers and entities to carry out business process as well as the relationships between them
  • Made a detailed fit-gap analysis on the IMS trading platform for equity
  • Prepared various requirement documents such as BRD, FRD
  • Well versed with Waterfall SDLC Methodology which was used in this project
  • Used MS Visio to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams using UML
  • Used MS Project to track the development and progress of the project
  • Assisted database designers by continuous involvement in transition from business data to database design
  • Developed SQL queries to generate reports for clients - 1.Portfolio Holdings Report 2.Compliance Reports 3. Daily Trade Export 4. Block Trade Report 5. Broker Report 6. Intraday Cash Balance Report
  • Held intermediate brainstorming sessions to understand the obstacles in the system development lifecycle
  • Used SQL for Data Analysis and MS Excel to generate reports and create data-entry templates
  • Experience in SOA architecture wherein we had to in corporate web service calls (using SOAP XML) for the compliance module.
  • Involved with integration testing, performance testing, GUI & navigation testing
  • Involved in User Acceptance Testing (UAT) and Black Box Testing
  • Reviewed and assisted the QA testers with the development of project test plans

Confidential, NY

Business Analyst

Responsibilities:

  • Conduct meetings with Business users and sponsors on the features/requirements. Translate those into Features/Epics and subsequent user stories on Rally
  • Worked as a liaison between the business users and DBA to automate the market feed for tax rates for specified counties and for different states.
  • Involved in functional requirement gathering and high level impact analysis for multiple changes in the application (e.g. field level changes and validation, verbiage changes etc.) for multiple releases in a year.
  • Developed use case diagrams for every conceivable scenario - such as use case for Asset Management on One Source, use case for Appealing, Use case for Assessment Review etc.
  • Gained good domain knowledge while understanding various tax administration processes such as Filing Returns, Appealing Assessment Review and Tax bills Review.
  • Supervised the development of the application by simultaneously interacting with the clients and the technical team
  • Involved in UAT process before rolling out to production
  • Used SQL on SQL server database to perform data analysis, and generating reports for management discussion
  • Perform complex queries against large datasets in various formats and perform data integrity/ validation, reconciliation and UAT.
  • Worked in liaison with DBA teams to create/update data models/maps for new market feeds.
  • Participated in all phases of application development and application integration including feasibility evaluation, project estimation, requirements analysis, functional specification, integration, test planning and test execution, implementation planning and release to production.
  • Managing any issue that affects the project; keeping an issue log that organizes issues by type and priority.
  • Maintain and prepare various reports to apprise the senior management about project updates and issues
  • Guide the team during analysis and manage the task allocation for ensuring a quality deliverable
  • Act as a liaison between the offshore team and onsite team.
  • Client interaction on a day-to-day basis for resolving various issues.
  • Work on initiatives to improve the team effectiveness and understand their pain points
  • Trained and Mentored new recruits in the project.

Confidential, CA

Business Analyst

Responsibilities:

  • Gather Business and Functional Requirements from Subject Matter Experts (SME’s) comprising the Insurance services teams, field offices and underwriting.
  • Analyze, understand and draft the Software Requirement Specification documents.
  • Conduct requirements walkthrough sessions with the IT/QA teams.
  • Extensive analysis on various aspects of the SalesX application which include rating, policy process and procedures and existing workarounds. Coordinating between Sales & Service, Business, and Development teams in resolving issues.
  • Constant interaction with Insurance Product management, Actuaries, Underwriting and Sales & Service groups for streamlining some of the existing process flows and suggesting improvements.
  • Review and sign-off the test scenarios, test plan and strategy prepared by the QA teams.
  • Involved in high level functional testing, GUI and navigation testing from Business analyst stand point
  • Led the initiative to automate the Application support department of SalesX application by developing tools for table update testing. The turnaround time of testing reduced by 75% by using these tools.
  • Work on initiatives to improve the sales force effectiveness and understand their pain points.
  • Interaction with Sales Agents, Cashiers, and office managers helped in understanding the business in real world.
  • While drafting requirements for Quote and Choicepoint data retrieval modules, got exposure to SOA architecture wherein we had to in corporate web service calls (using SOAP XML).
  • Defect tracking, maintenance and issue resolution of requirements defects.

Hire Now