Sr. Business Analyst Resume
El Segundo, CA
SUMMARY
- Result oriented Business Analyst with 7+ years of experiencein various sectors ofFinance Industryincluding Banking Software, Cash Management, Payments, Correspondent Banking,Wire Transfers, ACH Processing, Standing Orders, Direct Debits, Mandate Management, Check Electronic Clearing, Remittance,Security Trading,Derivatives,Fixed Assets,Risk Management,and Portfolio Accounting.
- Broad experience in investment banking, capital markets and technology, specialized professional experience in global reference data, securities lending, prime brokerage and fund accounting.
- Extensive experience with Fixed Income, Equities, Trade Cycle and Derivatives (Options and Futures), Basel II Accord.
- Excellent skillsin Data Analysis, Requirement Analysis,BusinessModeling, and use case developmentusingUMLmethodology.
- Expert in variousSoftware Development Life Cycle (SDLC) Methodologies including Agile, Waterfall and RUP.
- Strong documentation skills in developing Business Requirement Document, Functional and Non Functional Specifications.
- Proficient in usingUMLforBusinessProcess Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe prototypes and documenting them usingMicrosoft Visio.
- Expert inTest driven development & testing methodologiesfor performing UAT, System Integration Testing (SIT),BusinessAcceptance Testing (BAT) and documenting test results.
- Participated with QA team in different phases of testing such asSystem testing, Functional testing, Regression testing and Integration testingfor Quality Analysis.
- Strong experience in database modeling and development ofEntity Relationship Diagrams (ERD), SQL, Data migration,Data mapping,ETL, and reportingprocess.
- Excellentinterpersonal skillsin listening, mentoring, coaching, negotiation, mediation, influencing, conflict resolution and strong communication, written and presentation skills.
TECHNICAL SKILLS
- RUP
- Six Sigma
- Waterfall
- Agile
- UML
- Rational RequisitePro
- Rational Clear Case
- Clear Quest
- Agile
- Rally
- Visual Source Safe
- MS Project
- JAD
- RAD
- C
- C++
- SQL
- PL/SQL
- .Net
- JAVA
- Oracle 8i/9i
- MS Access
- SQL Server 2008
- UNIX shell script
- Awk
- Sed
- Perl
- MS Windows XP/NT/2000/98/95
- Sun Solaris
- GNU/Linux
- Unix
- MS Office Suite Word
- Excel
- Project
- Visio
- PowerPoint
- Adobe Acrobat Suite
- Erwin
PROFESSIONAL EXPERIENCE
Confidential, El Segundo, CA
Sr. Business Analyst
Responsibilities:
- Collaborated with project manager to define projectscope,risksand determined appropriate methodologies to apply based onScope/Vision documents, and developed project time lines for on time delivery based on SDLC methodology
- Facilitated discussions involving key stakeholders from bothbusinessside and IT side to elicithigh level requirementsand estimate projectfeasibility, designed and conductedsurveyamong differentend users including institutional users, brokers to collect detailed requirements, and documentedbusiness requirementsaccording to interviews and user surveys.
- Mediated users and stakeholders conflicts on requirementsthroughJADsessions.
- Examined Order Management System (OMS)to ensure compliances with upgrade requirements, and generated documents for the workflow of existing system and desired system that involvesCashAnalysis, Portfolio Analysis, Order Initiation, Order Execution, Trade Clearing, and Booking,andperformedgap analysis.
- Identified and documented business needs and created detailedUse CasesusingUML, and collaborated with production team to identify and map detailed existing processes, identify system gaps and developed functional requirements documentation (FRD)that supported overall strategy, goals and objectives.
- Derived functional specifications using UML models includinguser case diagram,activity diagram, andsequence diagram, and collaborated with software architects and developers to ensure that the applications conform to the requirements and helped to understand thebusinessflow and account relationships in accordance to the specific databases and tables involved in development
- Wrote SQL Queries extensively against different databases, generated different reports and analyzed them as per the company requirement.
- Maintained Traceability Matrixfor the currentbusinessprocesses and proposed changes.
- Assisted Project Managerin maintaining and monitoring project progress and status usingMS Project,providing high level estimates of efforts for analysis, implementation and support of application, estimating delivery schedule and resource allocation.
- Establishedtraceability matrixusingRational Requisite Proto trace completeness of requirements in different SDLC stages, and managed changes requests; controlled, tracked and monitoredchange requestsusing Rational Clear Quest to enable successful interactive development
- Developed test planswith QA team and helped to developtest scenariosforsystem testing,integration testingandperformance testing
- Conducted UAT,documented and reported user feedbacks to management team, and developedtraining materialsfor different end users and assisted inUser Trainingfor the new system.
Environment: RUP, UML, Rational Requisite Pro, Rational Rose, Rational Clear Case, Rational Clear Quest, Windows 7, Java, SQL, HTML, MS Excel, MS Word, MS Project, Excalibur
Confidential, Jersey City, NJ
Sr. Business Analyst
Responsibilities:
- Gathered, analyzed and documented the user stories for the need for new module or re - usability of an existing module by performing GAP analysis.
- Constantly partnered with project leads to ensure the team is producing solutions that meet established standards, procedures and practices, address issues, risks and mitigation plans.
- As Scrum Master involved with making appropriate commitments through story selection, sizing and tasking.
- Worked with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow to create market risk and credit risk module
- Performed data analytics with emphasis on credit scoring, credit risk, behavioral models, loan loss and general purposerisk/profitability models
- Proactively identified and removed blockers, facilitated frequent retrospectives, sharing metrics to identify and implement improvements.
- As Scrum Master involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria.
- As Scrum Master created and prioritized the Back Log in Rally, coordinated Planning Sessions and maintained User Stories and Acceptance Criteria.
- Employed various statistical analysis methodologies including regression analysis, Kolmogorov-Smirnov (KS) and Divergence
- Developed prototypes for multi-currency Portfolio market value reconciliations - LMV and BMV calculations
- Designed Trade-Break, Aggregate report formats and evaluating COGNOS as an strategic reporting tool.
- Documented Test Plan, Test cases and performed functional and regression testing.
- Facilitated UAT and recorded the user feedback for future changes
Environment: Agile Scrum, Rally, MS Project, MS Word, MS Excel, MS Visio, Cognos, XAML, HTML, J2EE, SQL, HP Quality center
Confidential, Cincinnati, OH
Sr Business Analyst
Responsibilities:
- Gatheredand analyzedbusiness requirement and delivered artifactsincluded:businessrequirement documents,functional specification documents,usecases,testplans,andrequirementtraceabilitymatrices.
- Identified and documentedbusinessneeds and created detailedUse CasesusingUML, and collaborated with production team to identify and map detailed existing processes, identify system gaps and developedfunctional requirements documentation (FRD)that supported overall strategy, goals and objectives.
- Reviewed finance formulations and analyzed market trade (Bond Pricing, Coupon Rate, Current Yield, YTM, NPV, VAR, PD)
- Developedfunctional specificationsbased on high level requirements provided by the end users.
- Interacted withbusinesspartners, management and design teams for identification ofbusinessand system requirements.
- ConductedBusinessGapAnalysis, feasibility study andimpact analysisof the current functionality with respect to proposed enhancements and new requirements.
- ConductedFeasibility analysisthrough mapping of As-IsBusinessprocesses versus To-BeBusinessprocesses.
- Created Business specifications,data flow, activity diagramsandstate transition diagramsusingMS Visio.
- MaintainedTraceability Matrixfor the currentbusinessprocesses and proposedchanges.
- Assisted Project Managerin maintaining and monitoring project progress and status usingMS Project,providing high level estimates of efforts for analysis, implementation and support of application, estimating delivery schedule and resource allocation.
- Interacted with various cross-functional teams to buildbusinessuse cases and understand banking regulations and Cash-Management functionality
- Interfacedbetweenbusinessusers and offshore development / QA team to ensure thebusinessspecifications are met and solicitbusinesssign-offs.
- DraftedUser Training Manualsoutlining the features of the application and step-by-step process for using the functionality provided by the application.
- Conducted data analysis and data validation by writing complex SQL queries using TOAD for ORACLE database.
Environment: MS Office Suite (Word, Excel, PowerPoint, Access, Visio), Quality Center, UML, .Net, Microsoft TOAD for ORACLE, MS Project.
Confidential, Columbus, OH
Business Analyst
Responsibilities:
- Understood the dynamics of the bond life cycle and understood the reporting needs of the policy makers/managers
- Prepared the work of the existing (AS-IS) process for the reporting and proposed the (To-BE) process
- Conducted Gap analysis to understand new business model and additional functionalities to be incorporated into the new application.
- Conducted JAD sessions for better understanding and refining of requirements in coordination with multiple teams.
- Clarified and prioritized requirements by conducting brainstorming sessions with the stakeholders and SMEs.
- Documented various documents including the Business Requirements Document and the Use Case Specification Documents.
- Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.
- Carried out detailed and comprehensive business analysis with the RUP methodology.
- Prepared Business Process Models, which included modeling of all activities of the business from conceptual to procedural level.
- Participated in Change control meetings recommending appropriate action after analysis of changing requirements.
- Conducted multiple interviews to clarify requirements in order to identify use cases and document UC Specifications.
- Assisted QA team by Reviewing test cases and clarifying requirements to ensure complete coverage of requirements.
- Provided training to users, and involved in conducting UAT sessions to gain user confidence and approval.
- Provided project manager with regular status updates assisting the overall project management initiative.
Environment: MS Word (2003), MS Excel (2003), MS Visio (2003), MS Project (2003), Extranet, J2EE, Web 2.0, Erwin (7.1), Oracle (10g2), .Net, Oracle BPA, Team Foundational Server
Confidential, Waltham, MA
Business Analyst
Responsibilities:
- Interacted with portfolio analysts and asset managers’ heads to finalize the Business Requirements for the application.
- Conducted JAD (Joint Application development) for the requirement gathering and used Rational Requisite Pro to analyze and prioritized the requirements.
- Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
- Extensively used RAD (Rapid Application Development) to define user’s requirements and to design the final system.
- Produced the visual models for the application using Rational Rose to create use cases, state charts, sequence diagrams, deployment diagrams and activity diagrams and initiate and implement Agile (Scrum) as software development methodology.
- Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
- Experienced in FX, Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user’s sentiments.
- Created overview document for data conversion, data mapping documents, detailed instructions, and specification documents.
- Involved in analysis of various types of risks (Credit Risk, Market Risk), which impacts portfolio management.
- Analyzed system requirements, developed detailed Test plan, Test cases, Test scripts for testing the functionality, GUI and security testing.
- Performed risk analysis of the requirements to identify the key business risk areas for the project and prioritized the application development and testing.
- Facilitated the weekly meetings with the review teams to continuously improve the QA process for the application development.
- Used power point presentations for conduction walkthroughs with the stakeholders.
- Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.
- Monitored and analyzed the development of cascading style sheets in HTML at front end.
Environment: Microsoft Office suites (Word, PowerPoint, Access, Excel, Rational requisite pro, Outlook, Project, Visio), Windows, Microsoft SQL Server (2000 & 2005), Oracle (8i, 9i & 10g), UML
Confidential, New York, NY
Business Analyst
Responsibilities:
- Dealt extensively with Fixed Income, Equities, Trade Cycle and Derivatives (Options and Futures).
- Assessed the scope and impact of business needs through analysis and completion of all enhancement specifications.
- Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and also conducted project related presentations.
- Conducted interviews with Subject Matter Experts (SMEs) in understanding and documenting their requirements.
- Co-authored business requirements documents with project teams. Also, extracted, discussed and refined business requirements from business users and team members and segregated them into Use Cases and Sequence diagrams according to UML methodology thus defining the data process models.
- Conducted comprehensive business analysis by working with the Client, IT staff, project managers, SMEs, and other stakeholders to identify the system, operational requirements and improvements.
- Modeled trading activities and designed comprehensive Test plan and Test case accordingly. Coordinated Unit Testing, Integration Testing, and User Acceptance Testing (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
- Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
Environment: MS Office, MS Project, MS Visio, MS Outlook, Adobe Professional, Quality center, MS Access, SQL, HTML.