Sr Business Analyst Resume
PA
SUMMARY
- 14+ years of experience including Business Analysis & Operations in Accounts/Finance, specialising in Hedge Fund Accounting.
- Led major accounting process transitions from US & UK and worked in Payroll processing, debtors/creditors reconciliation, GAAP Analysis & netting.
- Extensive experience in 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 & Documents.
- Have Led & coordinated onsite & offshore teams in Banking, Insurance & Capital Market Domain.
- Creating & Buddy reviewing of Use cases, UML Diagrams, Activity Diagrams, State Diagrams using Visio.
- Strong experience in holdingJoint Application Development(JAD)sessions, JAD session agenda.
- Working experience in writing Test Cases in MQC (HP Quality Center), following up on defects as noted by the Testers with respective teams. Reporting in MQC.
- Experience in using Data mining to extract the data from Oracle Server using SQL queries.
- Good experience in usingMS-Visiofor modeldiagrams, MS-Word for documentation.
- Working experience in extensive usage of Pivot Table, V-Lookup & H-Lookup for Data mining in MS Excel.
- Worked on currencies SGD, HKD, AUD apart from GBP, USD & Euro in Hedge fund environments.
- Extensive experience in managingChange Requestsafter conducting ImpactAssessmentsto capture the expected consequence of such changes
- Worked with various instruments (Equity, FX trades etc) and their treatment in the Trading and Accounting System “Aexeo”.
- Working experience in preparation and finalization of Toll Gates & SOW & signoff on SOP & SIPOC for the process.
- Business Process Analysis & Reengineering
- Gap Analysis, Impact Analysis, As - Is & To - Be Process Analysis
- Requirements Elicitation Techniques
- Conducting Interviews, meetings, observations and Workshop, Joint Application Development (JAD) Sessions and brain storming sessions.
- Modelling and Analysis
- UML Diagrams-Use Case, Activity diagrams
- Business and System Documentations
- Business Case, Vision Document, Business Requirements Document (BRD), Requirements Managements
TECHNICAL SKILLS
Methodologies: Waterfall, Agile, Scrum, structured SDLC methodology
Office Skills: MS Office Suite - MS Excel (Spreadsheet), MS Word & MS PowerPoint (DBMS & Other Applications)
BusinessModelling & 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 AccessOperating 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 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 to the End Users apart from the Preparation of 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.
Confidential, San Jose, CA
Reconciliation Specialist
Responsibilities:
- General Ledger Reconciliation & GAP Analysis for various Corps of GES (Global Electronics Solutions). To ensure, General Ledger and Sub Ledger tie out and show the true & fair picture.
- Preparation and finalization of Toll Gates & SOW & signoff on SOP & SIPOC for the process.
- Base lining & Defining Operational Definitions and CTQ's for the process.
- Pilot Testing & subsequently ensuring that Reconciliation meets TAT & CTQ's.
- General ledger and cash disbursement systems
- Cash Allocations, MIS for Accounts Receivables & keeping a check on suspense accounts for GE TLS (GE Trailer Leasing Services - Manchester UK).
- Helped Project Manager with his GB Project & was the SME for the process.
- Interacting with the customer (Manchester Team) for issue resolutions on a daily basis.
- Helping out team with the process updates & improvements.
- Daily settlements of big clients like Banana, Gap, Fred Meyer etc & reconciling the daily total funding figure with GECorp’s cash outflow to check for any variances.
- Rejects, Suspense & Chargeback clearing and processing of month end accruals in Oracle11i.
- Part of Project 'Accountants Calling'. of non-accounting persons in accounting process.
- General ledger and cash disbursement systems