SUMMARY

• 6 years of diverse experience as a Business Analyst, BSA of Client/Server, multi device and Web based applications under multi browser environment.
• Understanding of Capital markets, Insurance, Mortgage and E - Commerce domains with strong functional experience, excellent in all phases of banking domains
• Acquired solid knowledge in all areas of the banking domain (full life cycle), as I had a chance to interact with almost all levels of stakeholders and lead requirement workshops
• Excellent in producing various documentation for the application, documents like functional specifications, test cases, BRD, Business Process Documents, user manuals, user interface specs
• Proficient analytical skills to understand the business process and Functionality, Requirements and to translate them to System Requirement Specifications.
• Developing Functional specifications for business process refinement and automation, data modeling, system Architecture, conducting Feasibility studies and Scope.
• Experience in business process design, research, & implementation methodologies, diagramming data & process mapping, applying Unified Modeling Language (UML), and the implementation of performance measures.
• Extensive experience in analyzing and creating Use Cases, Use Case Diagrams, Data Flow Diagrams, Business Flow Diagrams, and Navigational Flow diagrams, Wireframes and Sequence Diagrams.
• Involved in Data Modeling (both physical and Logical Design) of client application, process models/swim lane diagrams using MS Visio/MS Sql server
• Excellent in performing requirement analysis through techniques like functional decomposition (WBS) and GAP analysis
• Conducted Requirement Gathering Sessions (RGS) and Joint Application Development (JAD) sessions and interviewed
• Subject Matter Experts (SMEs), asking detailed functionality aspects of business process and carefully updating the information to the requirements in an easily understandable format.
• Worked under Agile methodology, familiar with all agile ceremonies
• Hands on experience in preparation of Test Plans, Test Cases, Test Reports and Defect Lifecycle.
• Accomplished Sanity, Functional, GUI, Regression, Integration, System, Database, Exploratory, Black Box, Browser Compatibility, and User Acceptance Testing (UAT).
• Complete the mapping of Requirement Traceability Matrix and managed defect lifecycle using tools like Quality Centre, Red mine, JIRA.
• Used IBM Rational Quality manager to Plan, construct and execute Test cases.
• Was a part of process improvement team, after understanding the as-is business process helped the stakeholders with solutions by facilitating various JAD sessions with development team
• Extensively worked on tools like MS Office, MS Visio, MS Excel and used pivot tables and macros
• Highly proficient with RDBMS such as MS SQL Server, Hadoop and reading and writing complex queries across heterogenous platforms
• Hands on experience on of Hadoop ecosystem components viz HDFS, YARN, Pig, Hive, HBase, Flume, Sqoop, Oozie, Spark, and Zookeeper .
• Experience with Microsoft Power BI and Tableau

PROFESSIONAL EXPERIENCE

Senior Business System Analyst

Confidential

Responsibilities:

• Gathered requirements through interviews, storyboarding, wireframes and user stories techniques.
• Performed GAP Analysis to analyze the difference between the current systems and the to-be system.
• Have good understanding and followed market risk regulations - FRTB, CCAR etc.
• Interacted with end users (Risk managers and Traders) for requirements and supported the application when performing live as a part of end user training
• Strong working knowledge on Bloomberg implementation, interacted with various internal and external stakeholders for the requirements
• In-depth Bloomberg TOMS knowledge
• Converted the business needs into epics and document these epics into user stories
• Was effective in translating the business requirements into use cases, pseudo code, process models and data modelling diagrams so that the technical team can easily understand and develop a quality software
• Used SAS and SAS Enterprise Guide, and Hive for detailed analysis
• Proficient in SQL and experienced in using statements to pull data
• Was successful in performing incident investigation through data collection and data analysis
• Worked collaboratively with the User Experience Analysts and System Analysts to help document custom and system modifications.
• Used Microsoft Dynamics NAV for resource planning.
• Developed Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.
• Worked on technical content deliverable, containing instructions about how to effectively use and integrate with an API
• Experience with multivariate analysis, business intelligence, data management, andpredictive analytics using SAS.
• Developed system Use Cases, process models in MS Visio using UML standards which enabled internal and external stakeholders to understand the business process.
• Used MS Office for documentation and MS Visio for Diagrams and modelling purposes (Process models, Data modelling) working with Anti-Money Laundering projects (AML)
• Raised, managed and reported defects through HP Quality Centre, Jira, Confluence and HP ALM

Environment: MS Office Suite 2007, MS Visio Professional 2007 JIRA, HDFS, Oozie, Spark, Confluence, UNIX, C#, SAS, JAVA, MS Project, MS SharePoint, MS SQL, Dynamics NAV 2017/2018, MS Excel (Macros, Pivot tables),Talend data studio,Microsoft Power BI and Tableau

Business Analyst

Confidential

Responsibilities:

• Worked with Investment SME’s, Financial Analysts as well as other business teams on requirements gathering to write the Business Requirements Documents.
• Met and interviewed internal & external stakeholders to gather requirements for the application and to understand challenges in the as-is business process
• Processes and created use case and process flow diagrams.
• Involved in all phases of software development life cycle.
• Contributed in defining the scope of the project and defined functional specifications.
• Analyzed and documented the system specifications, Business requirements, documenting, tracking and analyzing the requirements.
• Used requirements to create test cases, business rules and design items to maintain traceability.
• Actively participated in scrum meetings, sprint planning meeting, retrospective meeting, reviews and developed test scenarios.
• Participated in creating detailed test plan and detailed test cases for each unit’s merger.
• Responsible for interacting with business analyst, developers and support team to define and develop the test scenarios/cases.
• Hands-on experience with large data models and relational databases
• Created and executes test cases for mobile applications for platforms iOS/Android/Blackberry.
• Executed SQL queries to retrieve data from the database to create test data.
• Knowledge of data mining using SQL, ETL and data warehouse tools
• Responsible for knowledge transfer to new testers in QA team.
• Involve in smoke, integration, system, data redundancy, security, performance, end to end, and ETL workflows testing
• Created inputs for daily status reports and scheduled defect resolution meetings daily during testing phase with development team.
• Professional experience (reporting, data analysis, data manipulation techniques, preferably in SQL, SAS and KNIME)

Environment: MS Excel, MS PowerPoint, MS SharePoint, Rational ClearCase, Jira, MS Office Suite 2010, Microsoft Visio Professional 2007, MS Project, JAVA, KNIME software, Adobe Products (FrameMaker, PhotoShop, Illustrator, Acrobat, PageMaker), Talend Open Studio.

Business Analyst / Tester

Confidential

Responsibilities:

• Used UML to produce Use-Cases, use case diagrams and Activity diagrams to explain process flows and functional specifications.
• Used the tool Systems Architect and MS-Visio to create use case diagrams and process flows.
• Involved in identification of business rules, business and system process flows, user administration, requirements and assumptions.
• Good understanding on all the insurance procedures, supported end users at all phases of the insurance life cycle
• Regularly interacted with onshore and offshore teams to communicate requirements and review test cases and test plans.
• Performed manual testing for the validity of data migration from a legacy system to the latest version.
• Prepared test data for positive and negative testing.
• Was author of Data Dictionary
• Executed SQL Queries to test the validity of the data migration process.
• Supported the data analysts in monitoring the performance and quality of the data
• Used SQL select statements to test migrated data
• Responsible for identifying and reporting defects to application developers by using HP QC
• Developed QA test plans and test cases to ensure adherence to agreed upon business requirements and performed user acceptance testing (UAT) according to QA test plans
• Documented Test cases for Functional testing, Integration testing and End to End testing.
• Executed Test cases for the verification of form generation.
• Worked in on-site/off-shore model, by successfully delivering the requirements to the dev team off-shore (India) meeting the deliverables on time
• Assists in the preparation of operating impacts of capital through Capital Request submissions Scotiaglobe, International Banking platform (IBP), Fast Credit, Quick App, FDR and QAT test environments.

Environment: SAP, MS Office Suite 2003, .Net, Microsoft Visio Professional 2003, Excel, Word, PowerPoint MS Share point, MS Project, MS SQL, Jira, MS Access, HP Quality Center,ALM, JIRA, MS Excel.