We provide IT Staff Augmentation Services!

Business Analyst Resume

Peoria, IL

SUMMARY

  • More all 8 years of professional experience as a Business / System Analyst in Finance/Banking Domain.
  • Hands on experience in creating SQL Queries, Stored Procedures, Data modeling, Triggers, Views, Indexes in SQL Server with a strong understanding of data analytics.
  • Design and review of various documents including the Software Requirement Specifications SRS, User stories, Business requirements document BRD, Use Case Specifications, Functional Specifications FSD, Systems Design Specification SDS, High Level Design Document HLD, Requirement Traceability Matrix RTM and testing documents.
  • Worked efficiently on multiple projects spanning over different releases at the same time
  • Good Understanding of different phase of Trade Lifecycle such as Account Set - up, Trade Order Generation, and Trade Order Execution, Order Settlement etc..
  • Strong domain knowledge in Banking and Finance. Good understanding of basic principles of financial markets and instruments Equity Derivatives, Cash Equities Domestic and International, Fixed Income, FX, Derivatives FX Options, OTC Options, Swaps, Forwards, Futures, Market Link Investments, Deposits, Repos, CDS, Mutual funds, NAV, fund accounting
  • Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
  • Strong subject matter expertise in Investment/Retail banking, financial statements, cash flow, financing structures, Foreign Exchange FX Risk Management, Capital Management, Asset Data, Fixed Income, Portfolio Analysis, Stock Valuation, Capital Structures and Budgeting, Value Based management. Worked extensively with Microsoft Excel Macros, VLOOKUPS, and Pivot Tables. Proficient Microsoft Word, Power Point, Access and Lotus Notes. Extensive experience on Mobile/E-Banking solution.
  • Excellent in Developing and evaluating business process Models.
  • Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
  • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
  • Strong experience in RUP Business Modeling process.
  • Used Query Analyzer, Execution Plan to optimize SQL Queries.
  • Extensive experience in conducting Market Research, Feasibility Studies, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management. Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
  • Strong experience in conducting User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
  • Proven success as a business analyst through the years, providing a well-balanced understanding of business relationships, business requirements, and technical solutions.
  • Professional experience in business analysis, operations management and development, design, documentation and testing.
  • Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.
  • Demonstrated ability to identify root causes of problems, consider both the long and short-term impact of proposed solutions and develop workable solutions. Ability to manage Multiple project tasks with changing priorities and tight deadlines. Ability to work well in a team. Open to Team related tasks, team meetings, team interaction and conference calls.
  • Demonstrated ability to work well with a wide variety of people at various levels, foster cooperation and collaboration among individuals in the work unit, help team resolve conflicts constructively and ability and willingness to communicate when help is needed. A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.

PROFESSIONAL EXPERIENCE

Confidential - Peoria, IL

Business Analyst

Responsibilities:

  • Identified, researched, realized, investigated, analyzed, defined and documented business processes and Use Case Scenarios
  • Designed and developed all Use Cases and UML models using Rational and Visio
  • Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
  • Prepared detailed design documents to translate business process effectively for developers and product managers using MS Visio.
  • Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
  • Executed Regression and IST sceneries in the Quality Center
  • Assisted in system and User Acceptance Testing, performed client presentations.
  • Assured that all Artifacts are in Compliance with corporate AGILE Policies and guidelines.
  • Experience from Front to back office, worked with fund managers, financial advisors and technical team members.
  • Designed asset management portfolio for its customers as per business requirements.
  • Interacted with Fixed Income business heads to finalize the Business Requirements for the application.
  • Wrote SQL statements to extract data from the Tables
  • Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
  • Assisted with project team in the whole project lifecycle phases including scope analyzing, requirements gatherings, developments and quality assurance.
  • Created various reports, Data sets and then used those for building Dash Boards and enabled flash mode as per user's request.
  • Created Security roles, Security Filters and assigned them to groups and users to meet the corporate requirements.
  • Used MS Visio for Process modeling and Business Process flow diagrams.
  • Conducted interviews with various business users to collect requirement and business process information using MS Visio, Requisite pro.
  • Conduct extensive analysis on security trading cycles provide consulting on financial disclosure, regulatory and Compliance issues
  • Performed Data mapping, data mining, data analysis, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
  • Used SQL for data extraction and data analysis, Qlik view dashboards has been made to increase the data visualization.
  • Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, and Transaction capture Execution and reporting requirements for the user interface.
  • Conducted project due diligence and created testing document to meet Sarbanes-Oxley and other Compliance requirements
  • Worked with Fixed Income, Bonds and Bond Trading Cycle, Bond Pricing, Equities, Trade Cycle, Derivatives Options and Futures, Portfolio Management, Sales and Marketing.
  • Involved with the trading activities of Credit Derivatives, Credit default swaps, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives and Futures including Commodity Futures Contracts and Financial Futures
  • Designed and developed project document templates based on SDLC methodology
  • Gained understanding of the Asset management requirements for risk analytics and developed the equity reference data mappings and equity reference data dictionaries considering the source system and target system equity reference data.

Confidential, New York, NY

Business Analyst

Responsibilities:

  • Identified Use Cases from the requirements and wrote Use Case Specifications document.
  • Linked business processes to organizational objectives, identifying opportunities for business process improvement and involved in the performance of cost/benefit analysis.
  • Worked extensively on data mapping and metadata requirements. Wrote SQL queries to test the source to target data.
  • Reported status to project management and project owners on a weekly and monthly basis.
  • Actively involved in developing, executing and coordinating functional and user acceptance testing UAT .
  • Maintained strong working relationship with various business groups such as project technical/development team and external clients throughout the development process of the credit card processing system.
  • Interacted with business area experts, IT experts asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical teams across organizational lines
  • Provided continuous support to the development team in order to make sure that business requirements are being converted into a desired software product
  • Worked with SME and Tech leads to gather the data regarding the Capital Markets and Asset Management.
  • Prepared, analyzed AS IS and TO BE of existing architecture and performed GAP Analysis, created workflow scenarios, designed new process flows and documented the Business Process and various Business Process and various Business Scenarios and activities of the business from the conceptual to procedural level.
  • Conducted JAD sessions and involved in all phases of software development life cycle in RUP framework.
  • Followed UML based methodology using Rational Rose for creating Business Cases and Use Case Models after assessing the status and scope of the project and implementing technology based solutions that will meet their strategic business processes needs.
  • Interacted with the Subject Matter Experts SMEs and stakeholders to get a better understanding of client's business processes.
  • Monitored client expectations and skillfully negotiated with clients through client involvement and all types of communication with the client's team throughout the lifecycle of the project.
  • Actively involved in designing of the system with the system architecture and the development team, supporting the technical team in the product development and delivery process and translated the business requirements into Functional Specification Document FSD .
  • Elicited meetings on credit card application process and payments.
  • Conducted Agile stand up meetings and created user stories
  • Involved in the periodically held JAD sessions for the purpose of project updates as well as involved in the weekly meetings to discuss the current project status.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica mappings.

Confidential, New York, NY

Business Analyst

Responsibilities:

  • Created requirements analysis and design phase artifacts using Requisite Pro, activity diagrams and Sequential diagrams.
  • Implemented Front End to a Fixed Income Derivatives Trading System, including trade blotter and interfaces to risk management, accounting, and middle and back office.
  • Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
  • Supported User Acceptance testing UAT and collaborated with the QA team to develop test plans, test scenarios, test cases and test data to be used in testing, based on business requirements, technical specifications and/or product knowledge. Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML Unified Modeling Language methodologies.
  • Interacting with the developers to report and correct bugs.
  • Worked with the business users and with different levels of management to identify requirements, use cases and to develop functional specifications.
  • The basic understanding of Reconciliation was to have independent check points and data verifications automated for internal compliance purpose.
  • Review Commercial loan documentation to ensure enhancements are meeting the proper audit standards.
  • Developed a new Credit Card application which was all automated and replacing existing system
  • Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized. Responsible for defining and designing commercial lending loan approval process which resulted in data collection and analysis compliance
  • Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using Rational Rose. Facilitated Joint Requirement Planning JRP sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
  • Interacted with the Subject Matter Experts SME's and stakeholders to get a better understanding of client business processes and gathered business requirements for Reconciliation and Reporting functionalities
  • Integrated Requisite Pro with Rational Rose to provide all teams visibility and maintain traceability among requirements, use cases and change requests.
  • Led client facilitation meetings to gather Interface and Business Process Requirements from Subject Matter Experts in Trading shares, Equities and Fixed Incomes like Bonds, and converted them into functional requirements by implementing the RUP methodology, authored the same in Business Requirement Document (BRD).
  • Created Business Process Diagrams (BPD) and Business Flow Diagrams using MS Visio.
  • Prepared graphical depictions of Textual Use Cases, creating Use Case Diagrams, and Activity Diagrams.
  • Performed Fixed Income Analysis (Pricing, Risk, Yield, Duration, and Recommended Strategy) in Excel to support trading, and reviewed with portfolio manager and traders.
  • Assisted Risk Management Group in Financial analysis and Risk analysis on calculation of PV, FV, and other key trade metrics (e.g. Breakeven Rate) to test new Risk Analytic Tool.
  • Performed Data Analysis and used SQL queries for Data Mining and Data Validation.
  • Run SQL queries from multiple databases (data warehouse) for research, data integrity, and validation provide Adhoc reports to investment, accounting, and risk and compliance groups.
  • Managed all the requirements effectively and made them available to all team members.
  • Authored Data Flow diagrams, Sequence diagrams and Business models
  • Prepared detailed reports of the Bugs, Pass-Fail report, Comparison Chart

Confidential

Business System Analyst

Responsibilities:

  • Wrote database interface specifications and documented in Data Manager data dictionary
  • Utilized detailed knowledge of application features; functions assess scope and impact of business needs throughout analysis.
  • Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft Share Point.
  • Acted as a resource in understanding how IS carry out business functions and assists in ensuring the timely and effective implementation
  • Developed timelines for project delivery, and managed projects and resources to successful completion
  • Liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships
  • Assisted in development of training materials for new technology and process improvements
  • Worked as a business analyst to build Strategy Web application for financial statements and inspections
  • Identified, researched, investigated, analyzed, defined and documented business processes.
  • Successfully managed a large scale project from requirements gathering through implementation to automate the assembly and mailing prep for Homeowners, Automobile and Umbrella policies to Insureds, Agents and Lien holders.
  • Very strong knowledge of Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
  • Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
  • Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs
  • Provide customer service and support for Property Casualty risk management needs.
  • Designed and developed, Use Cases, Activity Diagrams, Sequence Diagrams, Visio and Business Process Modeling
  • Designed and developed Project document templates based on SDLC methodology.
  • Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
  • Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
  • Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Origination, MBS, CMBS, and Secondary Mortgage Market
  • Escrow and Reserve Administration, Escrow processing, Escrow Analysis, Non-Escrow Loans Collateral Inspection and Monitoring, Property Inspection, Income and Expense Statement Review, Inspection Report
  • Analyzing the existing reports, reporting system
  • Maintained on-going technical assistance and provided help desk support to customer's mainframe systems software that included problem determination and resolution. Executed volume/load/acceptance/performance testing.

Hire Now