SUMMARY

• Qualified professional with over 4+ years of extensive experience in the field of Business Analysis in Finance and Investment Banking Environments, working with the technical staff to implement management and staff's business requirements into the software application in banking and retail banking environments.
• Expert in business process engineering and software development life cycle methodologies i.e. Waterfall, RUP, Agile, XP, and Prototype, including analysis, design, development, gap analysis testing and implementation of software applications.
• Extensive experience in Gathering Requirements, Scoping Requirement and creating Business Requirement Documents, User Requirement Specifications, Functional Requirement Specifications, System Requirement Specification, Test Plan, analyzing and Creating Use Cases, Use Case Diagrams, Activity diagrams, System Workflow Diagrams, Data Flow Diagrams, Business Flow Diagrams.
• Expert in documenting project plan, Business Requirements Document (BRD), Test Plans, Use Case Specifications, Functional Specifications (FSD) and Systems Requirements Specification (SRS).
• Excellent communication skills, Interpersonal skills, interacting with team members, leadership qualities, mentoring, ability to work independently.
• Exceptional knowledge of Microsoft Office Suite including Project, Word, Excel, Power Point, Visio and Access.
• Interface with clients starting from Operations, Marketing, Sales, Technologies to Outside Vendors and acted as their customer interface point.
• Strong business insight, strategic thinking, communication, interpersonal and presentation skills and editing.
• Coordinating extensive communication networks, presentation skills Group and individual based problem solving, excellent leadership.
• Experience in business process reengineering for improving business performance and implementation of new applications, strategic and business planning.
• Communicating business concepts to technical audiences, communicating technical concepts to business audiences, business outcome thinking, problem solving, decision making, team management, leadership and facilitation.
• Experience in relational database fundamentals, software development life cycle, and software quality methodology.
• Ability to drive and communicate Business Intelligence solutions to build shared vision for implementation across business groups and all levels of the business.
• Working knowledge of relational databases and SQL tuning; strong data mining, database, analysis, and problem - solving skills.
• An excellent communicator between technical and business units who can translate complex data into easily understood terms. Strong Business analysis skills accompanied with Data warehousing and testing skills.
• Prepared for GAP Analysis; identified and documented improved areas to meet requirement regulations and Compliance.

TECHNICAL SKILLS

Operating Systems: Windows, Mac, UNIX

Software: MS Office suite (inclusive Front Page, Project, Visio), Rational ClearQuest, HP/Mercury Quality Centre, Remedy, XML Spy

Languages: UML, HTML, XML, SQL, Web Services (REST, WSDL and SOAP)

Database: Oracle, MySQL, Microsoft SQL server, DB2

SDLC Methodology: Rational Unified Process (RUP), Waterfall, Agile Methodology and Scrum.

Management Tools: MS Project, Microsoft Outlook, Lotus Notes, MS Visio, MS Office, Excel Pivot Tables

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

BUSINESS SYSTEMS ANALYST

Responsibilities:

• Experience in Agile and Scrum Methodologies and related terminology such as Daily Scrum, Product Backlog, Release Burn down, Scrum Master, Sprint Planning Meeting, Task board, To-do and Work in Process Charts.
• Worked with development team on Agile methodology (Rapid Application Development) of Software Development Lifecycle.
• Performed database validation in the Mainframe to ensure the data entered through the front end reached the database.
• Creating and dealing with logical data modelling, workflow modelling, Use Case analysis, and business process modelling.
• Worked with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL
• Involved in the design of system so that it would fully integrate the client’s portfolio management, trading, operations and reporting functions to facilitate Straight through Processing of client’s investment operations.
• Send daily status updates regarding the test in progress to Business technology manager, Compliance manager, Project manager, DBA’s, Developers, QA manager & QA analysts and attach test execution matrices report for better understanding
• Prepared Business workflow models that cover "How" business processes are accomplished.
• Involved in the design of Data Flow Diagram for the visualization of data processing and in the Conceptual and Logical Design of the Database Management System. Assisted in Data Migration by developing Data Mapping Diagram.
• Recorded retention stored in Knowledge Link. Ad Hoc reporting, Admin for MS Project 2003, Excel dbase and pivot tables, Clarity and MS Project Server Admin duties.
• Used Pivot Tables, Lookups, and filters in Excel for analyzing Data.
• Used SQL on Oracle database to perform data analysis and generating reports for management discussion.
• Involved with Data Analyst in analyzing existing reports & Prepared Dashboards to make Business understand the Process. Used SQL for querying and analysis purposes on various source tables and conditions applied.
• Extracted the data from SQL Server, Oracle, Files, and Access into Data warehouse.
• Organized various UAT sessions and made presentations to the users on the project and the changes implemented.
• Reviewed several test plans and test scenarios with the QC team for each project worked on.
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Conducted JAD sessions to resolve critical issues

Confidential, Cleveland, OH

Business Systems Analyst

Responsibilities:

• Helped the PM in documenting the scope of the project.
• Scrum master for the Consulting engagement tied to the initial establishment of Agile Iterative development methodologies associated with the start-up of the bank-wide Data Quality Initiative.
• Worked with EDI to provide a timely reporting of ACH remittance
• Experience in Agile and Scrum Methodologies and related terminology such as Daily Scrum, Product Backlog, Release Burn down, Scrum Master, Sprint Planning Meeting, Task board, To-do and Work in Process Charts.
• Identified risk and project impact and performed risk assessment and mitigation
• Defined the enterprise change management approval procedures to control the scope of the order management requirements. Actively engaged various partners from the client team to monitor and control the risk associated with changing scope.
• Interviewed Business Users to gather functional, business and technical requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Created various types of UML Diagrams like Use Case Diagram, Activity Diagram, Class Diagram and Sequence Diagram to model the business use cases, business activities, business entities and business workflow and the interaction between them.
• Understanding of SQL, XML, and XSD (schemas)
• Widely used SQL queries to fetch information in production.
• Performed Business Process Modeling using MS Visio to model all activities of the business from the conceptual to procedural level
• Used UML during requirements gathering and created Use Case Models and Use Case Diagrams for the purpose of stakeholders in the project to help them understand the workflow of the system associated with the requirements
• On execution of each cycle, validated the test results using the SQL queries and looked at the generated actuate reports
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Documented all the requirements in a structured BRD format that included multi-level functional views broken down by functionalities.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from system users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing documentation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Confidential, Stanford, CT

Business Systems Analyst

Responsibilities:

• Leverage strong business knowledge of the investment banking sector to help design viable solutions.
• Analyzed process flows from various work-streams (i.e., Traded Products Group (TPG), Securitizations, Equities, and Retail Mobile Banking) into Revalues, to calculate capital
• Documented Scorecards process flows to analyze mathematical and statistical risk calculation models for Retail Mobile Banking work-streams
• Produced company rating from third party intelligence companies so that the risk management can be performed for the direct client.
• Worked with development team on agile methodology (Rapid Application Development) of Software Development Lifecycle.
• Collaborate with financial analysts, investment analysts and accountants to collect and understand business requirements
• Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
• Created various types of UML diagrams like Use Case diagram, Activity diagram and State diagram and business workflow and the interaction between them.
• Participated in writing data mapping documents and performing gap analysis to verify the compatibility of existing system with new business requirements
• Developed reports in Microsoft Access to show store performance and compliance.
• Worked heavily on SQL Server database to extract data and build Business reports.
• Extracted the data from SQL Server, Oracle, Files, and Access into Data warehouse.
• Organized various UAT sessions and made presentations to the users on the project and the changes implemented.
• Reviewed several test plans and test scenarios with the QC team for each project worked on.
• Successfully conducted Root Cause Analysis to identify the underlying issues and design solutions accordingly.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.
• Designed and developed Use Cases and UML models using Microsoft Visio.
• Responsible for creating and reviewing business requirement documentation (BRD), functional specifications (FSD), project schedules and test plans
• Assisted the Project Manager in setting realistic project expectations, in evaluating the impact of changes on the organization and conducted project related presentations.