Business Analyst/implementation Consultant Resume
Naperville, IL
SUMMARY
- 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.
- Extensive Scrum and Agile experience, user Stories including 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 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 Jaspersoft iReports to facilitate management decision making processes.
- 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.
- Extensive experience with Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools.
- 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
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, Jaspersoft iReports
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
PROFESSIONAL EXPERIENCE
Business Analyst/Implementation Consultant
Confidential - Naperville, IL
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 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
Environment: MS Word, MS Excel, J2EE, MS Visio, BPMN, IBM Mainframe, and Informatica, Microsoft SharePoint, HP Quality Center, Oracle, AGILE methodology
Confidential
Business Analyst/Implementation Consultant
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.
- 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
Confidential, Columbus, MS
Business Analyst
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.
- 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.
- Worked majorly on agile methodology for updating the trading systems and generating prototypes as per the client’s convenience.
- 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 Jaspersoft ireports 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.
Environment: Rational RequisitePro, .NET, Rational Rose, Rational ClearCase, Rational ClearQuest, Java, OOAD, RUP, VISIO, HTML, BPMN, UML, XML, HPQC, Agile, SQL
Confidential - TX
Business Analyst
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 activities and 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.
Environment: UML, HTML, XML, DHTML, JavaScript, CSS, BPMN, Agile, RUP, OOAD, Rational Requisite Pro, Rational Rose, VISIO
Confidential
Business analyst
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.
Environment: SharePoint, MS Word, MS Excel, MS Power Point, MS Project, HP Quality Center, Windows XP, MS Visio, SQL Server, BPMN, Oracle, PL/SQL, Trading Systems, Rational Suite, Requisite Pro, Agile, Rational Rose, JavaScript
Confidential
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.
Environment: Agile, Waterfall, OOAD, RUP, SQL, HPQC, NSE, BSE OOAD, Rational RequisitePro, Rational Rose, Rational ClearCase, Rational ClearQuest, Java, BPMN, VISIO, HTML, UML
Confidential
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