Business Analyst Resume
Vienna, VA
Summary
- 7+ years of experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Process-flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis
- Imported, managed and tagged requirement documents, and designed project deliverables (Attribute Matrix, andRequirements Traceability Matrix) usingvarious tools.
- Strong understanding of Capital Markets, Fixed Income, Equities, Risk management (credit risk, Over The Counter (OTC) Trading, Mortgage products, Collateralized Assets (MBS, ABS & CMO), Trading floor applications, Loan Processing Applications and Portfolio Management.
- Extensive experience in working with different domains including finance, healthcare, property and casualty, auto insurance etc.
- Proficient in Software Development Life Cycle (SDLC) process, which includes RUP, Agile and Waterfall methodologies.
- Extensive experience in gathering, managing and documenting business and functional requirements and communicating effectively with stakeholders, developers and QA testers.
- Experience in creating and transforming business requirements into software requirement specification (SRS)
- Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and joint application development (JAD) sessions.
- Proficient in creatingBusinessRequirement Documents (BRD), Functional Specifications Document (FSD), Wireframes and Prototypes, and UML Diagrams using various tools including MS Visio, and Rational Rose
- Proficient in creating Use Case diagrams, Sequence Diagrams, Activity Diagrams and Class Diagrams
- Expert in Business Process Modeling, Data Flow Modeling, Work Flow Analysis, Use Case Analysis, ER Diagrams, GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis and ROI analysis.
- Expertise in Client Server, Web-based, Multi-Tier applications. Proven expertise in business process modeling, Flow diagramming and data modeling using Erwin, MS Visio & Rational Rose.
- Expertise in designing & developing business intelligence reporting solutions in Insurance & Banking industries with Data Warehousing using Business Objects – Crystal Reports, Cognos and ETL.
- Experienced in working with Cognos 8 BI (Framework Manager, Report Studio, Query Studio, event studio and Analysis Studio).
- Extensive knowledge with Data modeling, Star Schema/snowflakes schema, OLTP/OLAP, E-R modeling, Fact and Dimension tables, Worked with Erwin for developing Logical and Physical design
- Expertise in developing test documents likes Test Plans, Decomposition of requirements, Test Procedures Creating Test Cases, defect tracking using tool such as test director.
Business Skills
Gap Analysis, SWOT Analysis, Business Process Modeling, and Business Process Re-engineering
Technical Skills
- Requirements Management Tools: Rational Requisite Pro, HP Quality Center
- Business Modeling Tools: Rational Rose, MS-Visio
- Change Management and Version Control Tools: Rational Clear Quest, Rational Clear Case.
- Environments: Assembly, Basic, Java, JSP, HTML, XML
- Data Bases: Microsoft Access, Oracle, Mainframe, My SQL, SQL Server, Oracle Database Server, DB2,Business objects (Business Intelligence Software)
- Software Utilized: Microsoft Office Suite 2007 (Word, Excel, PowerPoint and Outlook), Microsoft Project, IBM Lotus Notes, Erwin
- Query Tools: TOAD, My SQL
- Other Tools Utilized: UNIX vi editor, JDBC/ODBC,J2SE/J2EE, Websphere, MS office,Active directory, Java APIs , C++ library, Norton Antivirus, Zdelete, Undelete, Norton Antivirus, MS Internet Connection Firewall, MS Baseline Security Analyzer, Zone Alarm, SSH
Education
Master of Business Administration
- Majors in Corporate Finance, and Minors in International Marketing
Bachelor of Commerce
- Majors in Financial Accounting, and Minors in Applied Statistics
Professional Experience
Confidential,Vienna, VA Jan 2010 – Present
Business Analyst
Peracon Corporation provides full real estate life cycle, integrated solution to investors, asset managers and brokers worldwide. The project was to implement a comprehensive trading system for asset management business. The system handles the trading of Financial markets, Fixed income, and derivative (FX derivatives and options) for listed and OTC market. It enables its users to simultaneously trade a comprehensive set of securities, track live P&L values and examine exposure to shifting market prices, interest rates, volatility, yield-curve assumptions and other risk.
- Elicited, analyzed, documented and communicated requirements for implemention of the trading system in the Agile Environment
- Performed Feasibility Study, Project Planning, Requirements Analysis, and Prototype Development
- Studied established Trading System to understand the processes and challenges in STP, which helped define project scope
- Studied OTC Derivatives Trade Lifecycle to analyze trading processes and post-trade processing challenges, and recommended system settings to materialize the STP Environment
- Applied Iterative/Agile model in each SDLC phases, involved in daily Scrum Calls/Meetings, and incorporated change requests throughout the project lifecycle
- Gathered Business Requirements, analyzed data/workflows. Defined the scope, financial projections and Cost/benefit analysis. Progressed from Problem Statement to well-documented Designs.
- Wrote business requirements documents (BRD’s), which involved market risk analysis and risk management like continuous time finance & asset pricing and documentation
- Conducted Business Process Reengineering to build a new version of the existing system.
- Created Use-Cases for appropriate decomposition to use-case model; designed navigation flows, narrations, and user interfaces
- Conducted Use-Case reviews and identified gaps, leading to improvements/enhancements in the same and ensured Use-Cases were consistent and covered all aspects of the Requirements document.
- Designed Wireframes for the development of the user friendly User Interface Design.
- Designed and developed scenarios based on business requirements.
- Worked directly with software engineers to ensure clear communications on requirements and defect reports.
- Worked with developers to develop and documenttechnical specificationsof system document
- Used SQL statements for Back-end testing.
- Worked with Scrum Master in implementing Agile SDLC processes, including ticketing system, burn down charts, scrum sessions, and sprint and product backlogs
- Created Wireframes/Prototypes for the system.
- Validated the scripts to make sure they have been executed correctly and meets the scenario description.
- Worked with Financial Analysts onFixed Income Analysis (Pricing, Risk,Yield, Duration, and Recommended Strategy) with Excelto support trading,and reviewed with portfolio manager and traders
- Assisted Risk Management Group infinancial and Risk analysison calculation ofPV, and other key trade metrics (e.g. Breakeven Rate)
- Deployment of business process management and process frameworks at enterprise level. Highly involved in process modeling. Worked on business rules of various banking processes like mutual funds, future, swaps, derivatives etc
- Created Test Plans, Test Requirements, Test Hierarchy, Test Cases and Test Scripts with QA team and was involved with test execution, participated in System Testing and UAT process.
- Created user manuals and provided training to business users as part of the change management process
Environment: JAVA, Microsoft Visio, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Mercury Quality Center and IBM Rational Suite.
Confidential,NYC, NY Sep 2008 – Dec 2009
Senior Business Analyst
QBE Insurance Group Ltd. is Australian based Insurance company. QBE Insurance group Ltd. includes the business that provides life insurance, health insurance, dental, property and casualty insurance (P&C), banking and investment products like Equities through distribution channels. This project aims at assisting the Executive Team to analyze/track the performance of various product lines based on Key Performance Metrics. The product lines include life, health, annuity, dental, long-term disability, etc for both individual and groups. Claim-Processing module was re-engineered for the faster claim process. The Second application was of Reinsurance of the insured applicant/ community by Area/ Location/ Agent/ Community to narrow down the risk associated with it.
Responsibilities:
- Involved in requirement gathering by conducting personal interviews, developing questionnaire, brainstorming, or role playing to get a better understanding of client business processes and creating requirements traceability matrix for tracking the requirements using RUP methodology
- Responsible for Project Planning, Feasibility Study, Requirements Analysis (through JAD sessions and Storyboards), Wireframes, and Prototype Development
- Used power point presentations for conduction walkthroughs with the stakeholders.
- Analyzed and documented Business requirements and detail design of the software for full understanding of the business.
- Prototyped Property and Casualty forms in Microsoft word.
- Designed and developed the Property & Casualty Insurance forms
- Studied the existing ODS with a view to Map the data from ODS to Data Warehouse.
- Created the ETL specification for loading the Data Warehouse using EXCEL.
- Mapped the source and target databases by studying the specifications and analyzing the required transforms.
- Developed Use Case diagrams, User stories, Business flow diagrams, Activity/State diagrams and Sequence diagrams using Rational rose so that developers and other stakeholders can understand the business process
- Responsible for creating wireframes and prototypes for the system
- Performed feasibility, adaptability study and risk analysis to identify the business critical areas from USER perspective.
- Worked with designers and software developers to understand application functionality and navigational flow and keep them updated about Clients sentiments.
- Conducted Design Walkthroughs with end users, developers, managers and analysts to gather the modification requests and to upgrade or change the business specifications for the product.
- 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.
- Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
- Used Test Director to report bugs to Developers and Project Managers to resolve defect related issues
- Jointly responsible for monitoring the progress of the development and QA teams
- Analyzed defects reported in test director and assigned them to the technical team to fix the same
Environment: MS SQL Server 2008, UML, Windows Server 2008, SSIS (ETL), HTML and ERWIN, Test Director, Win Runner, Load Runner
Confidential,NY Aug 2007- Aug 2008
Senior Business Analyst
Alliance Bernstein is a leading global investment management firm that offers high-quality research and diversified investment services to institutional clients, individuals and private clients in major markets around the world. Functional redesign was taken up to improve the Quotes and Research, developed in the SOA framework. The investment site enables potential customers to perform research on Stocks Rates, and Bonds providing complete news and stories about the recent events related to Investment (such as Stock, Bond and Market).
Responsibilities:
- Facilitated JAD sessions for defining business requirements and follow-up for Project Plan updates.
- Reviewed the existing waterfall methodology and worked towards implementingRUP iterative process.
- Worked as a liaison between technology and the business clients to improve business processes and support critical business strategies.
- Designed use-cases, use case stories and use-case models to further refine the requirements and understand the business processes.
- Worked extensively in Rational Requisite Pro to organize and catalog requirements.
- Gained consensus for business requirements being fully met and attainable technical development expectations.
- Performed research on incoming user requirements/modifications and suggested improvements for the second release of the application.
- Proactivelyidentified opportunities and made recommendations to improve the system’s effectiveness viadatamining and analysis to understand user interactions with system and to scope out opportunities to increase user engagement and satisfaction.
- Dataextraction,DataMigration andDataconversion using ETL tools from application front-end with Oracle databases anddatawarehouse.
- Addressed software validation and compliance issues with particular attention todatamigration.
- Responsible for verifying ofdataintegration/migration from various distributors systems into theDataWarehouse environment and maintaining the Informatica Repository.
- Worked closely with the QATeam to review and enhance the TestPlan and Test Cases.
- Reviewed development plans, quality assurance test plans, and user documentation to ensure correct interpretation of original specifications.
- AnalyzedSQLqueries thatto be usedby thetestingteam to validate thedatain the back-end Oracle Database.
- Worked with the test team in Identifying and creating TestDatafor Smoke, Functional, and end-to-endtesting.
- Worked Closely with UAT Team to understand their needs and issues.
- Helped in designing and implementingdeploymentprocess, and thus maintaining the application in postdeploymentprocess
Environment: Oracle, MS Visio, MS Office Suite Windows, Informatica, Hyperion and Requisite Pro
Confidential,Scottsdale, AZ Aug 2006 – Jul 2007
Business Analyst
Fidelity Investments is a group of privately held companies in the Financial services industry. Fidelity Investments includes a large family ofmutual funds, their distributors and investment advisors, and a retail brokerage, as well as unrelated business. The project was to design and develop a Portfolio Management System. The system provides enhancedBusiness Process Management (BPM), newPortfolio Reporting Systemfor High Net worth Clients
Responsibilities:
- Participated in requirement gathering and business modeling along with the SMEs, business team, development team and testing teams
- Established aBusiness Analysis methodologyaround the Rational Unified Process
- Conducted interviews with various business users (Financial Advisors, Risk Management Group) to collect high level requirements and business process information usingMS VisioandWord
- Gathered and documented requirements to support highly diversified portfolio of applications including retail trading, risk management, scheduling and accounting.
- Utilized Data Flow Diagrams (DFDs) in MS Visio and Power Point to graphically define and document data processes, data flow and data exchanges
- Developed theBusiness Process Flowsto support the products and services selected
- Solid knowledge in Portfolio Management,Risk Management, Fixed Income Securities(Treasury Securities)
- Experienced onMarket Data and Reference Data, and performeddata extraction, and data manipulationwithSQL
- Developed current and futureBusiness Process Flows,and createdBRDandFSDwithVisioandWord
- Helped developUse Cases, project plans and manage scope
- Coordinated in developingTest Plan, Test Caseand participated inQAtesting
Environment: Rational Rose, Rational RequisitePro, Rational Clear Quest, JAD, Rational Manager, Rational Administrator, HTML, and SQL
Confidential,NY Jul 2005 – Aug 2006
Business Analyst
The project involved the development of system aimed at improving the analytical approaches forpricing and trading. The system guided dealers on relative index business.The system offered scenario analysis that permitted traders andtrading managementto observe the effect of theoreticaltrades/yield curveshifts on their portfolios.
Responsibilities:
- Followed theRUP methodologyfor the entireSDLC
- Involved inbusiness analysisand project management, coordinating between the team members, addressing budget issues and creatingtest plansaccording to the business requirements
- Worked with the project manager for planning and organizing theproject activities, and in communicating with other business center mangers and stakeholders of the project
- Met with various groups, including business owners,SMEs(subject matter experts) and marketing team, for requirements gathering indefinition Stage
- Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed
- Involved in project planning, coordination and implementedQA methodology
- Initiated, proposed and implemented critical analytical and technical turnkey solutions extensively increasing the quantitative and qualitative value of the application
- Provided overall project management to multiple projects successfully completing them on-schedule and on-budget
- Prepared the Business Workflow usingMS-Visiowith input, output, Pre and Post conditions
- Utilized technicalflow charts, Network Diagramsand Gantt Chartsto effectively map and manage critical paths and bottlenecks in conjunction with Project Tracking Reports and Project Data Sheets for Senior Management
- Enhancedtest cases and scriptsby adding the requiredfunctionalityas per the newbusiness requirements
Environment: MS Visio, MS Access, XML File, SQL, Rational Requisite Pro, Windows ME, UML, MS Office 2003, and Rational Clear Quest 2002.
Confidential,India Aug 2004 – June 2005
Junior Business Analyst
TheRisk Management System- The project is to develop an automated web based risk management system for the process of recording and maintaining reports from the credit card companies. The system generates Credit reports of individuals based on the data provided by the various agencies. The system also maintains a record of any information obtained to an individual’s report and updates the database. Responsibilities:
- Facilitated meetings and arranged JAD sessions with business users for requirements gathering
- Primarily involved in gathering requirements for the GUI (Graphical User Interface) screens and designing the same
- Analyzed and created workflow diagrams and presented to developers
- Created use cases, user stories and designed use case diagram, class diagrams and sequence diagrams using Rational Rose
- Responsible for preparing Software Requirements Specification (SRS) taking functional requirements specification as a base
- Responsible for the Timeline estimation
- Analyzed and documented non-functional requirements
- Interacted with various cross-functional teams on building business scenarios, and understanding expenses and revenue stream
- Prepared detailed reports of the defects and Comparison Chart
- Interaction with the developers to report and correct defects
Environment:Rational Rose, Requisite Pro, MS-Office, Microsoft FrontPage, MS Excel, MS Access, MS SQL Server 2008, UML, Windows Server 2008, SSIS (ETL), HT
