Sr. Business Analyst Resume
PA
SUMMARY
- With more than 14 years of experience including Business Analysis & operations in Accounts/Finance, specialising in Hedge Fund Accounting.
- Led major accounting process transitions from US & UK.
- Worked in Payroll processing, debtors/creditors reconciliation, GAAP Analysis & netting. As a Sr. /Lead BA, good experience of Requirements Gathering, artefacts namely As - Is & To - Be Process, FRD, Use Cases, Change Management, Defining Interfaces, prepared Wire frames & Prototypes, System Testing & UAT, prepared Release Notes & Training Documents.
- Have Led & coordinated onsite & offshore teams in Banking, Insurance & Capital Market Domain.
TECHNICAL SKILLS
Methodologies: Waterfall, Agile, Scrum, structured SDLC methodology
Office Skills: MS Office Suite - MS Excel (Spreadsheet), MS Word & MS PowerPoint (DBMS & Other Applications)
Business Modelling & Designing Tools: Rational Requisite Pro, MS Visio, Axure RP, Enterprise Architect, SharePoint
Testing Tools: MQC (Mercury Quality Centre) - Test Cases, Test Planner
Platforms: Mainframe, SharePoint 2010
Financial Tools: Scala, Oracle 11i (end user only), SAP (FICO), Advent Geneva
Database: SQL Queries, Oracle Server, MS Access
Operating Systems: Windows 97, XP, 2000, 2007
PROFESSIONAL EXPERIENCE
Confidential, PA
Sr. Business Analyst
Responsibilities:
- Review of Functional requirement document (BRD) through inputs from project BA's
- Occasionally participated with the Project BA's in their routine calls.
- Creating & Buddy reviewing of Use cases.
- Creating & Buddy review of UML Diagrams, Activity Diagrams, State Diagrams using Visio.
- Used Enterprise Architect for Traceability Matrix between Use Cases vis-a-vi requirements.
- Involved with Training for the Project BA's.
Environment: Agile methodologies, Scrum, Oracle Server, SQL queries, Metadata, Advanced MS Office (MS Excel, MS Word, Pivot table, LOOKUP Tables, Transpose, MS Project), Report Generator, General Ledger Templates, MS Visio, Data Mining, Java, structured SDLC methodology, wireframes & prototypes in Axure, system flows, interfaces, use cases, and business rules, SQL
Confidential, Warren, NJ
Sr. Business Analyst
Responsibilities:
- Business requirement gathering using interviews, Observation, meetings, business process analysis, use case scenarios, Wire Frames & Prototypes in Axure for artifacts like FRD (Functional Requirement Document), Use Case
- Prepared & analyzed As - Is & To - Be Process for the Legacy & the new system.
- HoldJoint Application Development(JAD)sessions, JAD session agenda.
- Acted as a liaison between the customer and IT & also between the Onsite & Offshore team for developing the new system.
- Prepared Prototypes after adding Annotations in the wireframes and making it work in Axure.
- Organized regular meetings with Off-shore development team, Capture Meetings / documentation & sharing of MOM (Minutes of Meeting) with the team.
- Had regular morning Scrum meetings for analyzing the current health / status of the project.
- Using SQL Query for data retrieving from Data warehouse by syntax like “where”, “select”, ”and”, “or”, “as” etc, cleaning of un required huge chunks of Metadata, after every UAT signoffs.
- Worked on SharePoint2007 for managing artifacts, version changes, Capture Meeting minutes, sharing of Wireframes, Flowcharts, Activity Diagrams, Use Case Diagrams
- Used Data mining to extract the data from Oracle Server using SQL queries.
- Advanced Excel with VLOOKUP, HLOOKUP, Pivot Tables, Hyperlink in FRD, Transpose etc.
- The Application was build using Java Application Development.
- Releases were made on 4 week iterations (2nd Wednesday of every month).
- Helped Testers understand the requirements through calls, impromptu meetings, and emails.
- Writing Test Cases in MQC (HP Quality Center), following up on defects as noted by the Testers with respective teams. Reporting in MQC.
- ConductedDefect ValidationusingHP Quality Centerfor defects raised by the QA teams.
- As a Business Analyst, have worked in projects where systems were developed in Java, J2EE, XML environment and the build was successfully tested by me on the generic Functional Requirements before handing over to the QA team for actual Testing.
- Provided Training to the End Users apart from the Preparation of Training documents.
Environment: Agile methodologies, Scrum, Oracle Server, SQL queries, Metadata, Advanced MS Office (MS Excel, MS Word, Pivot table, LOOKUP Tables, Transpose, MS Project), Report Generator, HP Quality Center, Templates, MS Visio, SharePoint 2007, Business Process Mapping (BPM), Axure, JAD Session, Sprint Backlog, SQL, Data Mining, Java, MQC, structured SDLC methodology, wireframes, Prototypes, mock-ups, system flows, interfaces, use cases, & business rules.
Confidential, New York, NY
Sr. Business / Test Analyst
Responsibilities:
- Serve as a liaison between user groups and technical team
- Document & elicit Business Requirements incorporating AIG Standards. Prepared Use Cases, Process Flow Diagram (GUI) for Business Requirement Document using MS Visio (Amendment to the initial Use Cases)s
- Identify upstream & downstream dependencies.
- Creation of Business, System, Security & Non Functional requirements.
- Document full requirements traceability in its approved repository using Enterprise Architect.
- UsedMS-Visiofor modeldiagrams, MS-Word for documentation.
- Worked on Dashboard reporting using Tableau
- Extensive usage of Pivot Table, V-Lookup & H-Lookup for Data mining in MS Excel.
- Testing irregularities between Mainframe, Genesis & Cognos & identifying any variances
- Assisted in reviewing test cases based on requirements anddefect tracking. using Jira
Environment: Agile methodologies, Scrum Methodologies, Sprint Backlog, Advanced MS Office (MS Excel, MS Word, Pivot Table, LOOKUP Tables, Transpose), Templates, MS Visio, Mainframe, Genesis, IBM Cognos, Data Mining, Windows 2007, Enterprise Architect, AxureRP, JIRA, Tableau, structured SDLC methodology, wireframes, system flows, interfaces, use cases, and business rules, SQL
Confidential, Manhattan - NY
Sr. Fund Accountant
Responsibilities:
- Daily & monthly reconciliations for cash, trades, positions against Custodial & Prime Broker
- Daily & monthly cash balancing for Subscription & Redemptions.
- Worked on currencies SGD, HKD, AUD apart from GBP, USD & Euro in Hedge fund environments.
- Accurately booking of Journal Entries for Incentive Fees, Admin & Management Fees,
- Worked on Government Bond portfolio of $350mm, responsible for their Interest Rate Calculation, Reconciliation & Booking & Break Resolution after reconciliation with Prime broker’s statements.
- Ageing analysis & reporting of Breaks and other projects from time to time as asked by manager.
Environment: MS Office (MS Excel, MS Word, Pivot table, LOOKUP Tables, Transpose, MS Project) Reconciliation.
Confidential
Lead Business Analyst
Responsibilities:
- Documenting Functional Requirement & Solution Documents as per client requirement.
- Documented Business Rules and DevelopedAs-IsandTo-BeProcess Flow Diagrams
- Documented use cases, UML & activity diagramsusingMS Visiofor a clear understanding of the requirements by the development team
- Acted as a liaison between the customer and IT & also between the Onsite & Offshore team for developing the new system
- ManagedChange Requestsafter conducting ImpactAssessmentsto capture the expected consequence of such changes
- First point of contact for any escalation issues from the production as well as Client side.
Environment: Requirement Gathering, Waterfall methodologies, Test Director, Oracle, MS Excel, MS Word, Pivot Table, MS Project, MS Visio, Axure RP, Windows 2007, Enterprise Architect, structured SDLC methodology, wireframes, system flows, interfaces, use cases, and business rules, SQL
Confidential, Somerset, NJ
Sr. Hedge Fund Accountant
Responsibilities:
- Daily & monthly reconciliation along with Month End Accruals for Pequot Fund. Daily and month end reconciliation of trades, positions, cash, collateral and P&L for 11 funds with their prime brokers and resolve and report any un reconciled items on a daily basis
- Preparation & Review of Month End P&L Accruals & entering in to the system.
- Ageing analysis of open items & reporting to the senior Managers.
- Review and analysis of international and domestic corporate action postings.
Environment: MS Excel, MS Word, Pivot Table, Reconciliation, Windows 97.
Confidential, Midtown, NY
Hedge Fund Accountant
Responsibilities:
- Daily Fund Reconciliation for Cash & P&L of Marathon Global Fund
- Responsible for the accurate and timely completion of 6 Daily Cash Reconciliations
- Booked monthly journal entries, reconciliations for Dividend, Interest, and Inc/Exp Accruals.
- GL Posting in FASTracker (Derivative Accounting Software)
- Calculated month end NAV for funds with over 400mil in AUM (Assets under Management).
- Worked with various instruments (Equity, FX trades etc) and their treatment in the Trading and Accounting System “Aexeo”.
Environment: MS Excel, MS Word, Pivot Table, Reconciliation software, Aexeo, Windows 97.
Confidential
Hedge Fund Consultant
Responsibilities:
- Conversion project i.e. moving of Bisys Funds from legacy system (Advisorware) to “Star Eagle”.
- Assisted with the financial accounting system conversion.
- Manual Trade & Corporate Action Processing.
- Cash, Income & Position Reconciliation & clearing of breaks.
- NAV computation on new system under testing server, trial run of 16 weeks & comparing with the actual NAV from Advisorware. Looking for differences & informing the Business analysts.
Environment: MS Excel, MS Word, Reconciliation, Aexeo, Windows 97.
