Business Analyst Resume Profile
Naperville, IL
Business Analyst
- Around 8 years of extensive experience as a Business Analyst in business and functional requirements gathering, analyzing requirements, data mapping, business process re-engineering, object-oriented analysis and designing OOAD , unified modeling language UML , SDLC methodology RUP, Agile, SCRUM, XP and project management in finance and investment banking domain, very good team player with excellent communication and presentation skills.
- Experienced in conducting joint application development JAD and Rapid application development RAD sessions.
- Well-versed in translating business requirements and user expectations into detailed functional specifications employing Unified Modeling Language UML .
- Wide-ranging experience in Finance and Investment Banking industries.
- Worked on reconciling Accounts Payable, Accounts Receivables and General Ledgers.
- Extensive Scrum and Agile experience, user Storiesincluding blending Agile practices with existing processes as well as gaining executive and organizational support for transitions to Agile practices
- In charge of corporate bank financing for Capital or Business acquisitions.
- Extensive experience in web technology, infrastructure, content management systems CMS , business process automation BPA , Business process re-engineering BPR and data warehousing environment
- In-depth knowledge of the practices of private equity, financial tools and theories.
- Worked with the General Ledger to ensure that all transactional data conformed with GAAP standards
- Extensive use of Excel Macros and Excel Pivot tables for data manipulation.
- Provided support to Portfolio Managers on daily trades made using Bloomberg and our own business systems.
- Worked extensively with Java, Javascript developer for creating applications
- Worked extensively on trade settlement, clearance and portfolio update information for potential vendors.
- Generated portfolio analysis and P L reports by performing reconciliation, risk analysis and risk management Credit Risk, Market Risk, Reinvestment Risk, and Inflation Risk based on the client investment objectives.
- Involved in the formulation and implementation of a structured credit policy and related processes to manage and monitor credit risk.
- Maintained daily correspondence with Portfolio Managers and Management to ensure the proper trajectory of Fixed Income and Cash allocations
- Sound experience in Manual Testing using Testing Tools like HPQC or Rational Tools.
- Worked on Agile methodology in almost all the projects.
- Guide consumers with financial decisions as a mortgage Business consultant
- Conduct mortgage financial and investment research and analysis to support our continued business development.
- Worked intensively in Capital and Derivative future, options, forwards, swap market, Arbitrage, currency and commodity markets.
- Experienced in constructing valuation models to undertake Cost/Benefit analysis.
- Expert in Financial Planning, Forecasting, Budgeting and utilization of variance analysis to manage project to completion on time and within budget.
- Highly proficient in developing and managing MS access and SQL server database for data entry, storage and generation of JaspersoftiReports to facilitate management decision making processes.
- Design, Develop, and Implement QA processes while documenting Test Plans, Test Cases, Test Procedures and Test Scripts for manual and automated requirements in the QA life cycle.
- Accomplished at UAT user acceptance testing , Functionality Testing, Unit testing, System Testing, Integration Testing and Regression Testing.
- Ability to implore various negotiating strategies to gather resources for project implementation.
- Self-motivated, diligent, ability to adapt to new environments and situations quickly, good grasping ability, capable of forming and maintaining positive and productive working relationships.
- Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills with strong analytical skills
Technical Skills:
| Requirements Gathering Tools | Rational Requisite Pro |
| Modeling Designing Tools | MS Visio |
| Technical | SQL, HTML, XML, JAVA, JAVA Script |
| SDLC Methods | Agile, RUP, Waterfall, Scrum |
| Databases | SQL Server 2008 |
| Business Tools | Microsoft Visio, MS Office Suite, Adobe Photoshop |
| Operating Systems | Microsoft Windows 2000, XP, Vista 7 |
| Other Tools | Microsoft Project, TOAD, MS Office, MS FrontPage, Photoshop CS, SQL Server Management Studio, MS Sharepoint , BPMN, JaspersoftiReports |
| Finance | Hedging Techniques, Equity Analysis Research, Portfolio Management, Capital Derivatives F O , trade flows |
| Testing Tools | Load Runner, UAT, Automated Testing QTP , Manual Testing, Black Box, White box |
Confidential
Role: Business Analyst/Implementation Consultant
Confidential
Project focuses on reconciling policies from STG, PMS and Confidential input sources to their EPIQ account, which contains all Insurance policies, Capital and Derivative investments, Accounts Payable, Accounts Receivables and General ledger.
Responsibilities:
- Worked on financial rate calculation and developing strategies for newly introduced plans.
- Conducted JAD sessions to allow different stakeholders to communicate their perspective with each other, resolve any issues and come to an agreement quickly.
- Worked majorly on agile methodology for updating the trading systems and generating prototypes as per the client's convenience.
- Worked with Java developers for building application.
- Worked with reporting team to create Reports and Dashboards for client use.
- Worked on rate swaps using industrial formulas and calculated ROI for different claims.
- Worked on Use case documents and System Design Documents and communicated them with IT teams.
- Gathered requirements from Business Managers, Supervisors, stakeholders, Surveillance Team and the subject matter experts through meetings to understand needs of the system
- Involved with project management team in developing project plan
- Created Use case diagrams using MS Visio.
- Gathered all the required information related the incoming data and data sources for the Tracking Application.
- Created a thorough Data Analysis document in order to gather the accurate data for the rewrite of the application and also to demolish the bad data.
- Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirement.
- Developed Test Scenarios and Test Cases for User Acceptance Testing and verified the Test Scenarios and Test Cases written by System Integration Testing Team
- Conducted weekly status calls with Third Party Vendors and Project Leads to keep track of events and progress on a weekly basis
- Evaluate test scenarios and test cases based on established system specifications and user requirements, Execute test cases analyze results and report verdicts and issues to Test Lead and Manager, Conducted Unit, Component Integration, System, Regression, Web, System and UAT Testing.
- Reported defects via the HP Quality Center tool to the developer. Supported business during UAT testing to research issues with the new functionality and log defects.
Confidential
Project focuses on reconciling data from different sources Trail balance, Accounts payable, Accounts receivable, to company's General Ledger GL account. Balancing Debits and Credits, validating input files, developing reports and dashboards.
Responsibilities:
- Facilitated interview sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
- Responsible for creating reconciliation environment for credit and debit out of balances.
- Created targeted Questionnaires for SMEs to gather requirements and analyze the business process model.
- Understood and articulated business requirements from user interviews and then converted requirements into functional specifications.
- Conducted JAD sessions with Product, Operations and different team leads to analyze business requirements and functional system design.
- Design Business Plans for project completion with MS Project.
- Worked extensively on reporting requirements and build reports and dashboards.
- Created Business Requirement Document, Use Case Document, and Detailed Requirement document, Process Flows, Test Scenarios and Requirement Traceability Matrix.
- Implement Agile project management principles and methodologies by leading requirements gathering sessions, sprint planning, product backlog grooming, level of effort and estimation sessions.
- Extensively used MS Visio for creating Business and System workflows.
- Generated tickets using JIRA for Product Development Group PDG to create patches or updated system for future needs.
- Worked with Java platform developers for enhancing websites.
- Developed and executed SQL queries for data extraction, manipulation and to view the data in the tables.
- Developed Functional and Non Functional Requirements, which included screen design and mock ups.
- Gathered requirements for Reporting, which were developed to provide statistical analysis for the subscribed Providers.
- Conducted Requirement Inspection meetings with stakeholders and different team leads to verify and validate Requirement Documents obtain a Sign- Off.
- Acted as a liaison between Business and Development teams to verify if, the requirements were accurately met by constant interaction and daily scrum meetings.
- Developed Test Scenarios and Test Cases for User Acceptance Testing and verified the Test Scenarios and Test Cases written by System Integration Testing Team
- Assisted QA team in creating Test plans, Test Scenario and Test Cases for smoke, Functional, system integration and regression testing
- Performed end to end test manually, participated in defect review meetings, Status meetings and GO/NO-GO meetings
- Worked on User Interface testing, Web services testing using, Interface testing for Inbound and Outbound Interface Request.
Confidential
Business Analyst
The Project focuses on enhancing the Trading system which acts as an interface between the investors and brokers and helps them in the trading of shares and bonds. The system is a web based application which is fully connected to both the trading engine and the bank authorities to facilitate successful and secure transaction. The application provides the investor with current updates of the stock market and facilitates the user investor in managing his/her portfolio. The application shows the data and market scenarios in the form of pie chats and bar charts for better understanding and readability.
Responsibilities:
- Worked on multiple stages of a project life cycle from formulating and defining system scope analyzing existing system logic and operation feasibility study, gap analysis, and developing recommendations for procedures to solve end user problems.
- Acted as a liaison between several groups within the business and technology to meet project deadlines and objectives with success.
- Reconciled different accounts like AP, AR Trail balance, GL etc.
- Understanding the need of customers and work on KYC Know your Customer
- Identified and developed portfolio solutions including capital and derivative investment management and stock option grants to advisory services for top level business executives.
- Directed the project using Agile methodologies and acted as an Agile consultant for the whole project life cycle.
- Involved in finding bugs, testing and then log them and track the progress in HPQC.
- Contribute investment recommendations based on analysis and constraints
- Successfully improved the derivative trade process of clients managed by reducing the processing time of trade booking and increasing its accuracy which, improved controls and was instrumental in attracting more clients.
- Used BPMN for business process flow
- Good understanding of MS sharepoint as an internal project tool.
- Updated websites with proper information about settlement, clearance and trade information.
- Responsible for gathering, analyzing, and documenting business requirements writing use cases UML , functional and non-functional specifications based on information gathering sessions with business unit stakeholders and technical team members.
- Analyzed industry conditions, issuer strategies, historical and prospective measures of financial strength, earnings quality, Fixed Income, refunding risk, legal and regulatory contingencies, contractual relationships, and risk appetites.
- Intensive knowledge of Jaspersoftireports for reporting investments.
- Involved in GUI design, application architecture, components and reports design identified internal/external application dependencies available reusable interfaces.
- Defined the business logic in capturing and presenting holder's information in the portal application.
- Performed system and integration testing to ensure conformance to project standards, performance criteria and functional specifications.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Played a key role in the planning, User Accepted Testing, and implementation of system enhancements and conversions.
- Lead the testing team and creating test plans, cases, scenarios, testing reports
- Established a business Analysis methodology around the Rational Unified Process.
- Researched the various steps in the lifecycle and then constructed the system in such a way that the riskier claims could be easily identified and monitored.
- Streamlined clerical work processes and mapped to the automated system.
- Developed project plans and managed scope.
- Build Business Process Model using Rational Rose and Visio.
- Performed extensive Requirement analysis and developed use cases and workflows.
- Involved in finding bugs, testing and then log them and track the progress in HPQC.
- Worked as Lead the testing team and creating test plans, cases, scenarios, testing reports
Confidential
Business Analyst
The scope of the project is to maintain a Force Account system which is a web based system that facilitates opening new bank accounts, request for credit cards, check status of applications, establish recurring billing, and generation of reports in a decentralized fashion. The Force Account system is specifically designed to use only by military partners, Air Force Services and Army Community and Family Support Center. The service can be availed at any time and from any part of the world.
Responsibilities:
- Acquired comprehensive knowledge of Banking activities and operating processes.
- Collected and documented business processes as well as business rules.
- Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
- Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
- Collaborated with development architect and the business to develop both high-level and detailed application architecture to meet the business needs.
- Highly involved in building equity trading application in Capital and Derivative F O Market.
- Monitor fundamental economic, mortgage industry and developments by analyzing information from financial publications and services, banking firms and other mortgage companies.
- Performed gap analysis.
- Worked extensively on BPMN, UML designs for business users and developers.
- Work on trading platforms used by major banks for research and financial investments
- Managed development team using agile methodologies SCRUM to interact with team of management peers within business analysts, architecture, project management, test, and system engineering.
- Directed all corporate financial practices and supervised accounting team in AP and GL reconciliation
- Undertook Basel1 regulations for all bank transaction and liquidity issues.
- Created pricing models to assist in determining the quality of the Mortgage loans being sold.
- Maintained the entire portfolio database of all mortgage purchased loans.
- Produced weekly summary reports on the status of the acquired mortgage loans.
- Documented and delivered Functional Specification Document to the project team.
- Conducted User Acceptance Testing UAT .
- Responsible for complete oversight and portfolio analysis of 18 Billion on behalf of clients with assets across global taxable fixed income, municipal, international quant/fundamental equity, hedge fund
- Developed test scenarios and implemented test plan. Providing key input in working with users in defining project and system requirements.
- Conducted project related presentations.
- Used HPQC for the Defect Management.
- Developed strategic partnerships with the business units to develop a solid knowledge base of the business line including the business plan, products, and process and revenue streams.
- Documented and delivered Functional Specification Document to the project team.
- Conducted testing and defect correction activitiesand prepared test reports and metrics for each testing phase
- Conducted JAD sessions for communicating with Stakeholders and Project directors.
- Developed business requirement specification documents as well as high-level project plan.
- Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
- Conducted benchmarking activities to identify best practices.
- Create Traceability Matrix to ensure comprehensive test coverage of requirements identifies all test conditions and test data needs.
- Attended meetings to discuss on status of defects and projects.
- Interacted with developers regarding priority of bugs and update the status of bugs once they are fixed.
- Created and executed test cases before and after bug fixes for each build for User acceptance testing.
The scope of the project was to revamp the web applications, which enable potential customers to perform searches for mutual fund performance, Equity, stock ratings, bond and market performance and providing information regarding recent events related to the investments. It provides a clear and complete picture of the client's asset allocation, current investment portfolio and full brokerage capability.
Responsibilities:
- Organized and facilitated meetings with the management and the development team, conducting requirements gathering sessions with the purpose of defining the functional business and system requirements.
- Performed extensive requirements analysis and requirement gathering including data analysis and GAP analysis.
- Worked extensively on Capital and Derivative instruments for investments.
- Responsible for producing net asset valuations NAV for more than 1,000 OTC and cleared derivative trades, equities, swaps, options on a daily basis through trade processing and data mining for multiple funds valued over 1 billion
- Promoted the Agile process within the company, to include responsibility for expanding the understanding and practice of agile principles throughout the entire organization, including technology and operations teams, and the business
- Represented the teams in daily Scrum of scrums and appropriately escalated and tracked issues and blockers in order to bring right attention to the impediments faced by teams
- Conducted user interviews, Document Analysis and JAD sessions to reduce the Scope Creep and document analysis in requirements elicitation.
- Helped the organization in learning the agile process and implementing agile within their corporate environment
- Worked on all phases of life cycle using Rational unified process RUP methodology.
- Created Business Requirements Documents BRD and Functional Requirements Specifications FRS documents.
- Management of corporate investments to include financial analysis and regulatory compliance with corporate partners.
- Creating and managing Project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
- Designed Use cases, Use case diagrams to present a better view of the system as a whole to the technical team for them to identify the key processes.
- Used MS Visio for flow charting, process model and architectural design of the application. Used MS Project for status reporting and project planning.
- Interacted with the QA developers on resolving the reported bugs.
- Conducted Walkthroughs and User Acceptance Tests UAT and worked closely with the UAT personnel to both ensure that their needs are met.
- Assisted QA team in creating Test plans, Test Scenario and Test Cases for smoke, Functional, system integration and regression testing.
- Interacted with the QA developers on resolving the reported bugs.
Business Analyst
Responsibilities:
- Assessing the stock market index, price fluctuations, exercise prices, processes and tool functionalities closely while working on data processing and recommending Process Enhancements.
- Maintaining and updating Price and Non-price database for Fixed Income Securities in particular with Bonds and Warrants.
- Performing extensive research on new stocks issued new issues of fixed income securities, providing customized technology solutions and adding value to the customers' Capital and Derivative Investment decisions.
- Maintaining and providing Qualitative Data to our Customers - Quality at 100 .
- Performing timely Quality Audits on relevant products to discern content quality from a client perspective.
- Conducting quality checks on time series static bond warrant data for the markets handled.
- Data Acquisition Team to explore the avenues.
- Counterparts through conference calls and business meetings related to fixed income markets, the major topics being major developments in the markets and knowledge sharing.
- Effectively managed various projects involving information gathering, testing on the product database, analyzing the information gathered and preparing documentation for the same.
- Effectively handled an assignment on analysis of client queries with the necessary findings for various European Markets.
- Participated in User Acceptance testing UAT and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
- Performed defect analysis to identify root cause of problems and interact with appropriate team and resolved outstanding problems. Discussed blocking defects with team.
Business Analyst
Responsibilities:
- Conducted trade initiative on NSE Terminals: Neat Capital Market and F O market.
- Conducted trade initiative on BSE Terminal and Currency Terminal.
- Assisted clients in making informed decisions.
- Reviewed accounts on a regular basis to ensure compliance with internal and external policies, guidelines, rules, and regulations.
- Created, implemented, and continually reviewed plans that include strategies designed to help clients to pursue their long-term investment goals
- Provided strategic quantitative models to high-net worth clients to reduce fees, beta and unsystematic risk while adding alpha.
- Formulated asset allocation strategies and developed proprietary investment models for client portfolios
- Maintained database of the financial documents, reports and quotations of every client in a prescribed format.
- Devised and executed business development strategies to attract and acquire new clients
Environment:HP Quality Center, SQL Reports, Microsoft office, RationalClearCase/ClearQuest, , PL/SQL, Java Script, Microsoft Office, MS Project, MS Visio, Load Runner, Rational Clear Quest, BPMN
