We provide IT Staff Augmentation Services!

Lead Business Analyst / Qa Analyst Resume

0/5 (Submit Your Rating)

Framingham, MA

SUMMARY

  • A diligent and progressive Business Analyst with over 8 years of experience majorly in financial institutions in the domains such as AML, Trading, Accounting, Portfolios management etc.
  • Combined experience in Software Development Life Cycle and Business / System Analysis: experienced in gathering user requirements, documenting requirements, technical writing, business analysis, system analysis, testing, and implementation of projects.
  • Experience in AML tools such as Actimize and Jacota systems and related topics knowledge and understanding of fixed - income trading, asset management and portfolio management applications and how they are impacted by the Bank Secrecy Act, USA PATRIOT Act, Dodd Frank Act, Anti-Money Laundering, OFAC and Customer Identification Program (KYC/CIP), Basel II compliance using industry standards and regulatory guidance, etc.
  • Extensive experience in Finance industry, Credit Card, Investment Banking (GL, Personal Accounts, Check payment, ATM, Fraud - AML) and Mortgage industries.
  • Experience in Private Equity, Securities and Derivatives trading, Hedge Funds and Fixed income instruments such as Bonds.
  • Understanding of Portfolio analysis report and P&L reports by performing the risk analysis (Credit Risk, Market Risk, Reinvestment Risk, and Inflation Risk) based on the client investment objective.
  • Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
  • Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
  • Proficient in using UML in behavioral, structural and architectural modeling - in creating Use Case, Activity, Class and Sequence diagrams.
  • Excellent understanding of Database management system, Data warehousing concepts, Business Intelligence technologies and Data mining.
  • Experienced in Implementing Normalization/Denormalization techniques for optimum performance in OLTP/OLAP database environments for Business Intelligence’s function.
  • Wrote SQL queries and assisted in extracting data for creating Data mapping document.
  • Highly skilled in creating, writing, and executing Test Cases, Test Scripts from Business User Requirement documents and Functional Design Documents.
  • Experienced in performing functional tests at various stages of SDLC using manual testing.
  • Ability to handle pressure and meet deadlines coordinating multiple tasks in project environment.

TECHNICAL SKILLS

  • Rational Requisite Pro
  • Rational Rose
  • Rational Clear Quest
  • MS Visio
  • MS Project
  • Erwin
  • UML 2.0
  • Rational Clear Case
  • Test Director
  • SharePoint
  • Mercury Win Runner
  • Load Runner
  • Quick Test Pro
  • Black Box
  • System
  • Regression and Performance testing
  • SQL
  • PL/SQL
  • Visual Basic
  • HTML
  • MS Access
  • Excel
  • MS SQL Server 2000
  • Oracle9i
  • Sybase
  • MS-DOS
  • Windows 95/ 98/ 00/XP
  • ISO9001
  • Six Sigma
  • TQM
  • SSAS
  • SSRS
  • Quality center

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

Business Analyst/Test Data Analyst

Responsibilities:

  • Acted as the Liaison between Line of Businesses (LOBs), Technology Partners (Source Applications) and implementation team.
  • Participated in BRD review meetings to provide knowledge and Expertise on Anti Money Laundering Initiatives and AML deliverables.
  • Consistently met up with SMEs to update knowledge on ever-changing regulatory requirements.
  • Gathered and Coordinated Business requirements and converted them into appropriate functional requirements.
  • Coordinated Day to day meetings to discuss the outcome of implementation processes, testing efforts, time lines etc. Provided Guidance and Leadership as needed.
  • Lead the Prepaid Team in IST Testing, Defect Remediation and Solution Delivery.
  • Acted as the Subject Matter Expert (SME) on all prepaid related Matters including the Interface Specification. Operated as prepaid interface product owner and gatekeeper.
  • Created reporting metrics for Daily team meetings and executive meetings on behalf of the Transaction Monitoring and Investigations (TMI) unit.
  • Maintained and created Enterprise wide test cases for Subject Matter Expert Testing, Oracle Mantas testing and Integrated Systems Testing (IST).
  • Lead both on shore and Offshore teams to deliver Business solutions in a timely and efficient Manner.

Tools: & Technologies: Microsoft Office suites (Word, PowerPoint, Access, Excel Pivot, Rational requisite pro, Outlook, LYNC, Project, Visio), SharePoint 10.1, Application Lifecycle Management (ALM) 11.00, Oracle SQL developer, Oracle Toad 10.6, Oracle Mantas, NICE Actimize ERCM

Confidential - Framingham, MA

Lead Business Analyst / QA Analyst

Responsibilities:

  • Understood the AML compliance requirements by interacting with compliance department, and SME experts in the laws/act of compliances
  • Lead the team in requirement gathering and managing using IBM Rational DOORS, which included interviews, brainstorms and meetings with stakeholders, BU, and compliance department and SMEs.
  • Studied the existing KYP/CIP system and prepared the test data for the CDD and EDD based on the inputs.
  • Studied the data mapping from the transactional data to the Jacota Analytics system
  • Prepared the reporting formats for the regulatory filings and internal use and helped the Jocata team to produce the reports.
  • Prepared the report publishing frequencies and the media in which it shall be published (SharePoint), also prepared the document for filing frequency and filing format of the SARs, CTRs to the regulatory agencies and internal systems
  • Understood the business logic, User requirements and test-objectives to develop test plans, test cases, and test case execution using Test Director.
  • Tested the application manually by executing Test Cases in Quality Centre prior to Automation and Involved in automated testing and Performance testing using QTP and Load Runner.
  • Participated in Bug-Review meetings with software developers, QA engineers, managers and suggested enhancements to the existed application from business perspectives, provided solutions to existing bugs.
  • Conducted UAT to make sure that all the user requirements are catered by the application.

Tools: & Technologies: Agile, SDLC, Erwin, Microsoft Office 2007 (Word, PowerPoint, Access, Excel Pivot and VLookup, Outlook, Project, Visio), Rational DOORS, Rational Clear Quest, QTP, Mercury Quality Centre, Jocata

Confidential - Somerset, New Jersey

Business Analyst / Data Analyst

Responsibilities:

  • Understood the Bank Secrecy Act, US Patriot Act, Basel II agreement with help of SMEs.
  • Analyzed the existing customer data and understood the necessary information that needs to be captured for each existing customer and prepared missing values, anomalies for the completion of the CDD.
  • Conducted JAD (Joint Application Development) sessions and Gather Business Requirements, analyze and prioritize requirements by using Rational Requisite Pro.
  • Developed scope document, financial projections, budgeting and analysis for the project using IBM Cognos 10.
  • Identify the technical needs of the organization and accordingly develop Cognos based applications and software.
  • Propose solutions or alterations to remove inefficiencies and close gaps in existing process via process redesigning
  • Develop UML diagrams like Use Cases Diagram, Activity Diagram, Sequence Diagram, Class Diagram and Coloration Diagram using MS VISIO 2010.
  • Prepared Business Process Models that includes modeling of all the activities of business from conceptual to procedural level.
  • Writing the SQL queries in Oracle SQL Developer and managing the database and assisted in making Data warehouse and doing Data profiling.
  • Prepared a Gap analysis of the existing data to fully comply with CIP as per AML regulations using actimize.
  • Determined the threshold parameters such as geography, source of income the customer etc., and fed to actimize along with the historical transactional data to categorize the customers for monitoring purposes.
  • Defined and created the Test strategies and associated scripts for the verification and validation of all defined business requirements and associated functionality.
  • Reviewed and analyzed the Use cases and came up with System design and Test plan Templates and developed test plans, test cases and test strategy.
  • Designed the test plans and test scripts based on the user requirement specification and conducted UAT- Integration testing, Unit testing.
  • Provided training and assistance to business users.

Tools: & Technologies: Rational Rose, Rational Requisite Pro,SQL Developer, Nice Actimize RCM, Actimize visual Modeler 4.7 Software Development Life Cycle (RUP), SOA, UML, MS Project 2010, MS-Visio 2010 (UI Mockups), MS-Office 2010, Excel Macros, Erwin 7.1, MS SharePoint

Confidential, Jersey City, NJ

Business Analyst

Responsibilities:

  • Conducted brainstorming sessions to extrapolate the requirements that are not stated.
  • Worked with business sponsors to elicit business/functional requirements and generated use cases in accordance with RUP Best Practices.
  • Extensively used DOORS to document, review and analyze the requirements.
  • Used UML and RUP methodology to capture, analyze and translate business requirements.
  • Developed business Use Case scenarios, sequence diagrams and class diagrams.
  • Prepared Rational Suite (Clear Quest and Requisite Pro) training materials for user and administrators and trained nearly thirty of them in the branch office.
  • Understand and assess the types of Risks involved for the Mortgage processing department.
  • Structured flexible test plans, test cases and test scripts to test entire application based on business requirements, technical specifications, product knowledge and use case scenarios.
  • Using SQL Developer for retrieving the databases and manipulating the database.
  • Revised existing documentation comprehensively to enhance the ability of the stakeholders to proceed with the next major phase of developing the application.
  • Performed User Acceptance Testing on behalf of end-user to ensure that the user requirements are satisfied and properly tested.

Tools: & Technologies: DOORS, Rational Clear Quest, Rational Clear Case, Oracle BI, SQL Developer, Oracle Database, UML, Test Director, VB, .NET, Windows 2000, Microsoft Office suite 2007, MS Visio, SQL server 2000, Aladdin Enterprise Investment System.

Confidential, New York, NY

Business Analyst

Responsibilities:

  • Explained the users and senior management thecurrent design challengesin supportingEquitiesfor USA.UsedPowerPointfor creatingpresentations.
  • Documented the'current state'and'future state'of the data extraction and enrichment process and performedgap analysis.
  • Developed the system to capture any possible incidents of dealing ahead of a price sensitive announcement.
  • Discussed and reviewed the enhancements required to supportListed Derivativesfor Americas and EMEA.
  • Proposed bothstrategicandtacticalsolutions towards fillings the gap for supporting Listed Derivatives.
  • Discussed the Shares Equivalent concept with users and created sample report templates depicting the same.
  • Formulatedcalculationsthat depict the client's / traderstradingpattern by looking at the net executions in last 3 days and comparing them over with their prior history.
  • Assisted the development team in figuring out some of the data points used by the reports such as the EOD closing price and the delta adjustment factor of the option contracts.
  • Interacted with portfolio analysts and asset managers to finalize the Business Requirements for the application.
  • Conducted JAD (Joint Application development) for the requirement gathering and used Rational Requisite pro to analyze and prioritized the requirements.
  • Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
  • Extensive work on IBM File Net process engine for data collection and data management
  • Used RUP methodology to define user’s requirements and to design the final system.
  • Produced the visual models for the application using Rational Rose to create use cases, state charts, sequence diagrams, deployment diagrams and activity diagrams.
  • Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
  • Involved in mapping and improving the current business process.
  • Analyzed system requirements, developed detailed Test plan, Test cases, Test scripts for testing the functionality, GUI and security testing.
  • Performed operationalRISKgap analysis involving front/middle/back office to identify and rectify regulatory compliance (DoddFrank) and internal fraud weaknesses.
  • Assisted the stakeholder meet its overall strategy to implement a more efficient way to meet regulatory and compliance reporting requirements by studying and researching the DoddFrank.
  • Performed risk analysis of the requirements to identify the key business risk areas for the project and prioritized the application development and testing.
  • Facilitated the weekly meetings with the review teams to continuously improve the QA process for the application development.
  • Writing Test cases and uploading to Quality Center for testing in QA as well as Production and uploading test approval proofs in QC for passing the test.
  • Used power point presentations for conduction walkthroughs with the stakeholders.
  • Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.

Tools: & Technologies: Microsoft Office suites (Word, PowerPoint, Access, Excel Pivot, Rational requisite pro, Outlook, Project, Visio), Windows, Microsoft SQL Server (2000 & 2005), Visual Basic, HTML, Oracle (8i and 9i), UML, Object Oriented Analysis and Design, SQL, IBM FileNet, SQL developer, Quality Center (v8.2 & v9.2), SunGard Intrader.

Confidential

Jr.Business analyst/Internal Relationship Officer

Responsibilities:

  • Interview business area experts asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people
  • Interact with SME's to elicit business goals and define goal-level requirements
  • Collaborate with mortgage bankers, personal bankers, investment analysts and accountants to collect and understand business requirements
  • Analyze Risks, documented Risk Logs and created Requirement Traceability Matrix (RTM) as a roadmap for the 'TO BE' system
  • Evaluate technical requirements Created System Requirement Specifications (SRS), Systems Design Specifications (SDS)
  • System Information sheets to provide concrete inputs for the data mapping processes for Account Analysis, Pay Plus & PAM systems, Signature Snippets Data Conversion
  • Conducting JAD Sessions to resolve open issues, change requests so that the application meets the business requirements and dead lines
  • Used Six Sigma Methodologies in solving the errors and issues while the development of the project.
  • Helped the Business Users while performing the UAT testing and helping them resolve the defects in the environment.
  • Worked in mainframe environment and used SQL to query various reporting databases.
  • Interact and negotiate with Vendors to complete the tasks related to data conversion
  • Was involved in the Test Plan document preparation.
  • Developed and designed the test cases for different modules of finance referring to the test plan document and analyzing the test rules.
  • Kept a track of all UAT bugs/defects and helped the testers to resolve the issues and made a report of all the defects which were resolved and which were not using MS EXCEL.
  • Identified, prioritized and designed various test scenarios.
  • Used Quality Center/Test Director for requirement management, test planning, scheduling, executing test cases, managing and tracking defects.
  • Reported the bugs, Email notifications to the developers using Test Director.

Confidential

Business Relationship officer

Responsibilities:

  • Created new portfolios and coordinated existing portfolios in commercial banking
  • Cultivated top tier customer base to boost business by 15%
  • Coordinated short term lending and intraday overdraft facilities
  • Postdated check management
  • Performed daily account monitoring and forecasting of portfolio growth
  • Trained new and existing staff in sales and customer service “best practices”

We'd love your feedback!