We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

GA

Summary:

  • Over 6 years of experience as a Business Analyst in all phases of Software Development Life Cycle (SDLC), including Requirement gathering and Documentation, Use Casing, Functional specification, Business Case analysis, Quality Assurance and Testing.
  • Extensive experience in Finance, Mortgage, Health Care, Insurance and Banking domain.
  • Extensive knowledge of Object Oriented Analysis and Design using Unified Modeling Language (UML), Rational Unified Process (RUP), Agile, Waterfall cycle, Rational Rose, Requisite Pro, Rational Clear Case and MS Visio.
  • Excellent knowledge of Capital Markets, Fixed Income Securities, Equities, FX, Derivatives, Mutual Funds, Over The Counter (OTC) Trading, Mortgage products, Collateralized Assets (MBS, ABS & CMO),Trading floor applications and Portfolio Management.
  • Expertise in Financial Planning, Forecasting, Budgeting and utilization of variance analysis to manage project to completion on time and within budget.
  • Extensive understanding of Business Intelligence reporting tools for Risk Management, Revenue Management, Social Media, Sales, Marketing and Planning etc.
  • Excellent experience in developing project scope statement, Work Breakdown structure (WBS), project management plan, communication management plan, cost management plan and project resource management.
  • Extensive experience in business analysis, gap analysis, cost/benefit analysis, risk analysis, testing, development of functional specifications and project planning.
  • Experience in facilitating Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
  • Expertise in Data Modeling, Data Analysis, Requirement Analysis, Business Modeling, Data Migration, Data Profiling, Data mapping, and ETL testing.
  • Extensive experience in conducting Joint application development (JAD) session, Rapid application development (RAD) and requirements work-sessions.
  • Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions, and confident, accurate, decision-making coupled with excellent communication and interpersonal skills. Excellent track record for meeting deadlines and submitting deliverables on time.
  • Effective in working with business stakeholders, VP’s, MD’s, Support Managers off-site and on-site, Senior Project Managers, Project Managers, Solution Architects.

Educational Qualification:

MBA in Finance

Technical Skills:

Business Modeling Tools: Rational Enterprise Suite, Requisite Pro, Rational Rose, Clear Case, Visio, UML, Share Point, Microsoft Office Project Management Tools: MS Outlook, MS Visio 2007, MS Word, MS Excel, MS Access,MS PowerPoint, MS SharePoint Financial Systems: Reuters 3000 Xtra, Bloomberg , Capital IQ Financial Databases: Hoover’s, Factiva, Business Source Premier, Mergent Online, Standard & Poor’s Net advantage Project Methodologies: Rational Unified Process (RUP), SDLC, Agile, Waterfall Operating System: Windows 95/2000/XP Databases: SQL Server, MS Access, MySql Reporting Tools: Business Objects, Crystal Reports Test Tools: Test Director, Win Runner, Load Runner

Professional Experience:

Confidential, Atlanta, GA May 2011 – Present Sr. Business Systems Analyst ING Group N.V. (ING) is a global financial institution offering banking, investments, life insurance and retirement services to meet the needs of the customers. It operates in six business segments: Retail Banking, ING Direct, Commercial banking, Insurance Europe, Insurance Americas and Insurance Asia/Pacific. In preparation for the separation of ING US companies from ING Group for an IPO, project is based on readiness of Financial Risk Applications required to manage capital and risk. This project was to implement Moody’s RiskFrontier (a credit risk portfolio management modeling tool) -- instead of replacing ING Group’s credit risk data warehouse with a new credit risk data warehouse for Insurance US’ Enterprise Risk Management function.

Responsibilities:

  • Working closely with Business users in defining the scope, analyzing business requirements and segregating them into high level and low level requirements for Financial Risk Applications.
  • Assisting the project manager in other financial risk projects such as Adaptive Counterparty Risk (ACR), Economic Capital (ECAPS) and Global Market Database (GMDB).
  • Working with Data warehouse team and source systems in preparing Data mapping documents and data models to procure the required data feeds into the Moody’s RiskFrontier Application.
  • Conducting JAD sessions with users to identify the requirements and outline business rules.
  • Enhancing and reengineering Business Processes and creating Business Process Flows using UML/ MS Visio.
  • Assisting project manager to research on Business Intelligence reporting tools required to reduce costs, manage risks and proactively respond to the changes and needs for other financial risk projects.
  • Developing User Requirements Specifications (URS, Functional Requirements Specifications (FRS), Role Based Access Control (RBAC) and Business Owned Application Manual (BOA).
  • Working with Application Architect and Network Administrators to help design and administer the architecture around the needs of the RiskFrontier Application.
  • Assisting in preparing Business Operational Procedures document which included Environment migration plan, Disaster recovery plan, and Technical specification document for the Risk Application.
  • Conducting functional walkthroughs, User Acceptance Testing (UAT) sessions, and assisted the development of User Manuals.
  • Working with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project.
  • Developing requirements document for Data Extraction, Data Analysis and Loading process.
  • Actively involved in walkthroughs and meetings with Project Team to discuss related business and project issues.
  • Working with the QA team for requirements clarification and to analyze the test results of the application.
  • Creating functional and technical presentations for management and training workshop for end users.
  • Working with ING Investment Management (IIM), Corporate Insurance Risk Management (CIRM) and Black Rock for business process governance, counterparty risk policies and procedures, credit risk exposures in investment portfolios, reinsurance portfolios and in the financial derivative portfolios.

Environment:Microsoft Visio, Microsoft Access, Microsoft Excel, Microsoft PowerPoint, SQL Server 2008, Requisite Pro, Black Rock , Bloomberg, and Eagle/Pace data warehouse.

Confidential, Vienna, VA Mar 2010– Apr 2011 Sr. 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 equity, fixed income and derivative 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 risks.

Responsibilities:

  • Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis and created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the business from the conceptual to procedural level.
  • Gathered business requirements from traders, portfolio managers, hedge fund managers, and risk management group to identify and map detailed current processes and develop functional requirements that supported overall strategy, goals and objectives, and develop and document the BRD and FSD.
  • Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams (Activity diagrams, Sequence diagrams, Collaboration diagrams) in MS Visio.
  • Conducted analysis on Trading Lifecycle in front-office to back office systems and documented with diagrams.
  • Worked with developers to develop and document technical specifications of system document.
  • Worked with Financial Analysts on Fixed Income Analysis (Pricing, Risk, Yield, Duration, and Recommended Strategy) with Excel to support trading, and reviewed with portfolio manager and traders.
  • Assisted Risk Management Group in financial and Risk analysis on calculation of PV, and other key trade metrics (e.g. Breakeven Rate).
  • Worked with end users to define business requirements and needs, performed data validation, drafted procedures for steering committee approval, overseeing the implementation of approved projects and ensured that the project goals are achieved.
  • Acted as liaison between management and development team for Requirements and QA testing during the User Acceptance Testing (UAT) phase and involved in user interfaces, requirements and data modeling sessions.
  • Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
  • Created user manuals and provided training to business users as part of the change management process.

Environment: Microsoft Visio, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Mercury Quality Center, Requisite Pro, RUP, Bloomberg, and HTML.

Confidential, Budd Lake, NJ Dec 2008 – Feb 2010 Business Analyst American Federal Mortgage is a licensed mortgage banker. Since their incorporation in 1986, they have dedicated themselves exclusively to mortgage lending. Loan Origination System automates the entire lending process from origination through funding. It goes far beyond rate quotes and loan applications by automating the most complex, inefficient and labor-intensive aspects of lending; including automated underwriting, document preparation management, and customer relationship management. It Interfaces with other products and legacy systems including Lending exchange with ability to electronically order/track document services such as appraisal, credit reports, etc.

Responsibilities:

  • Worked with the stakeholders to get a better understanding of client business processes and gather business requirements.
  • Conducted JAD sessions and meetings with developers, QA team, and users for communicating primary requirements, discussed different versions of requirements, queries, and clarified the issues.
  • Used Rational Rose to create use case models and activity diagrams, depicting whole business workflows in these diagrams.
  • Provided regular verbal and written status reports to IT management and business community, published meeting minutes and maintained project plans.
  • Linked business processes to organizational objectives, performed critical path analysis, and identified opportunities for business process improvement.
  • Assisted in the project and component scope definition and adherence, measuring impact to plan where necessary.
  • Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
  • Created test plan and test cases for user acceptance testing.
  • Assisted the Project manager in preparing Risk Management and Minimization plans from the issues and data gaps identified.
  • Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
  • Used the Unified Change Management to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.
  • Performed Feasibility Analysis and Risk Analysis on vendor/third party tools.
  • Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.
  • Facilitated User Acceptance Testing (UAT) with the business users and communicated the change requests resulting from the UAT.

Environment: HTML, Agile, UML, SQL, VB.Net, MS-Office, Test Director, Rational tools.

Confidential, Columbia, MO Aug 2007 –Nov 2008 Business Analyst Shelter Insurance provides its insurances in more than 10 states and has more than 1000 agents. The goal of the project was to develop an Internet application that allows potential customers to file claims online for claims related to Storm Damage, Auto, Glass related, and Property Damage in addition to Emergency Road Services. This application helps the customers find local agents contact information for assistance.

Responsibilities:

  • Facilitated meetings with Subject Matter Experts for Requirements Gathering and transforming them to functional specification.
  • Acted as a primary liaison between business lines, operations, and technical areas throughout the project cycle.
  • Conducted JAD sessions and meetings with developers, QA team, and users for communicating primary requirements, discussed different versions of requirements, queries, and clarified the issues.
  • Participated in writing data mapping documents and performing gap analysis to verify the compatibility of existing system with new business requirements.
  • Created Requirements Traceability Matrix.
  • Created requirements document for Data Extraction, Data Analysis and Loading process.
  • Reviewed Business Requirements Documents and the Technical Specification.
  • Design UML diagrams like Use Case Diagram, Class Diagram, Sequence Diagram, and State - Diagram for project documentation using MS Visio.
  • Coordinated UAT and executed environment build plans.
  • Wrote SQL Queries to perform Data Validation.
  • Organized and Performed GUI Testing, Functional Testing, Regression, and support for User Acceptance Testing (UAT).
  • Involved in defect tracking and bug management using Rational Clear Quest.
  • Planned, scheduled, and controlled projects based on plans and requirements outlined by the business.
  • Interacted with developers to report data related bugs and re-tested the fixed issues.
  • Provided inputs for Modification and Enhancement Requests.
  • Involved in meetings, walkthroughs and creating minutes of the meeting.
  • Created and submitted weekly status report to the project manager.

Environment: RUP, J2EE, Java Script, HTML, Oracle, MS Visio, Rational Requisite Pro and MS Office.

Confidential, Duluth MN Jan 2006 – Jun 2007 Business Analyst The project was to design a system which allows medical practitioner or physicians to enter orders directly in to the electronic record, eliminating handwriting orders under his or her care. These orders are communicated over computer network to the medical staff or to the departments (pharmacy, laboratory or radiology) responsible for fulfilling the order.

Responsibilities:

  • Enhanced, reengineered and documented Business Processes created and updated User Requirements Specifications (URS) and Functional Requirements Specifications (FRS).
  • Organized sessions for the stake holders, with the purpose of defining the functional business requirements, and documented these requirements and composed detailed design specifications.
  • Aided documentation of computer system validation lifecycle per FDA regulations. Assisted in process modeling; conducted and participated in walk-through sessions with system users, helped with design walkthroughs with stakeholders for base lining architecture.
  • Managed the approved changes when and as they occur by regulating the flow of requested changes.
  • Involved in detailing project mission, data process flow diagrams, and timelines.
  • Worked with SQL queries for data manipulations.
  • Wrote test plan and executed various levels of Unit, Assembly and Product testing using test cases to prove that the application conformed to specifications of business and quality requirements.
  • Worked with the testing team to analyze the test results of the application.
  • Worked with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project.
  • Provided regular verbal and written status reports to IT management and business community, published meeting minutes and maintained project plans.
  • Prepared screen shots and user interface guidelines to facilitate the end-user and the developer.
  • Developed recommendations and designed solutions for process improvements.
  • Created Test Plan, Test Cases and performed Testing for all the user scenarios.
  • Generated mock data, maintained enhancements/defects, created Dashboards and Test Summary Reports.
  • Provided guidance and recommendations on process improvements and “best practices”.
  • Performed Extraction, Transformation, Loading (ETL) and created Data marts and Business Intelligence Reports using MS SQL SSSI and MS SQL reporting service.

Environment: RUP, XML, ASP.Net, MS Visio, Requisite Pro, Clear Quest, SharePoint, Windows XP, Win Runner, MS SQL Server 2005.

Hire Now