Sr. Business System Analyst/product Test Engineer Resume
SUMMARY
- 8+ years of industry experience in multiple roles as Senior business system analyst and business analyst with good domain knowledge in finance, Investment Banking, Banking and Compliances
- Prior knowledge in financial and investment banking concepts such as Financial Securities - Bonds, Stock, ETF. Trade Lifecycle - Front Office, Middle Office & Back Office Activities, SIP (Systematic Investment Plans), Risk Management, Capital Market- ECM & DCM and RIA, IAR, IRA, ETFs & Mutual funds.
- Exposure to regulations & compliance such as FINRA, Dodd-Frank, ERISA, IRS, FATCA, GAAP, FINMA,, Investment Company Act, Securities Exchange Act, SOX, BSA regulation, US patriot Act, Basel II & KYC rules.
- Worked in environments such as waterfall methodologies, Waterfall-Scrum hybrid and Agile-scrum
- Expertise in Business requirement elicitations, Requirement Gathering, Business Process Flow, Business Process Modelling, Change Management, Release Management, workflow description and prototypes.
- Experienced in performing SWOT analysis, Risk analysis, Cost benefit analysis, Feasibility study, Impact assessment, Cause and effect analysis (root cause analysis), Effort estimation and mitigation plan.
- Expertise in "As is" process and "To be" process as parts of gap analysis for new functionality requirements, as well as prioritizing them based on actual business needs so as to align them with the project roadmap.
- Expert in translating stakeholder requirements into over deliverables such as user stories, workflow diagrams, data flows, use cases, functional specifications, Wireframes and Business Process Model.
- Created User stories (INVEST criteria) and acceptance criteria for an iterative and incremental development of an application with the help of Scrum Master & Product Owners.
- Experienced in using various prioritization techniques like MoSCoW, KANO, DOT-voting, 100point method, silent writing and estimation techniques like Planning poker, T shirt sizing, bucket system and Relative estimation.
- Prepared Use Case specification document comprising actions, pre-conditions, post-conditions, triggers, actual/happy, alternate/unhappy paths, assumptions, constraints and business rules for different scenarios.
- Competent in Creating Unified Modelling Language (UML) diagrams (Sequence Diagrams, and Activity Diagrams) and Use case diagrams using Mock-up Screen, Draw.io, Lucid charts and Ms Visio.
- Created Conceptual, Logical and experienced in Entity-Relationship diagrams.
- Experience in SQL queries for Data Analysis, retrieval, validation, cleaning and modification.
- Sound knowledge of Relational Database Management System (RDBMS) & Business Intelligence tools such as Power BI, Tableau, SSRS & QlikView for reporting needs.
- Good understanding of Big Data concepts such as Spark, Hive, Pig, Sqoop and Hadoop Ecosystem consisting of HDFS, Name Nodes, Data Nodes, Hbase, Job Tracker, Task Tracker, MapReduce, Clusters and Nodes.
- Proficient in Data warehouse, Data marts, OLAP operations (Slicing & Dicing), and OLTP related concepts of Entity relationships. Competent Dimensional Modelling, Data modelling, Data migration, Data profiling, Data governance, Master data management (MDM), Schemas, Data mart and Operational Data store.
- Experienced working with data governance teams to create and maintain documentation related to Metadata of different kinds of data. Proficient creating Data Dictionary and Data Mapping Specification document.
- Strong knowledge on Service Oriented Architecture, N-tier Architecture, SOAP & RESTful web services
- Performed ETL process for transformation of data sources into one integrated system (Transformation performed include Sorter, Filter, Source Analyzer, Aggregator, Joiner, Lookup, Stored Procedures, Expression and Router).
- Experienced in API documentation using Swagger and API testing using Postman to check if the API's are returning the data in JSON, XML format as defined in the API documentation and required by the workflow.
- Involved in Bugs Validation, Conflict Resolution & Report Generation using various Defect Tracking Tools.
- Proficient in developing and executing Test Plans, SQL queries, performing functional, usability testing and ensuring that the software meets the system requirements.
- Collaborated in various types of testing like Functional testing, End to End Testing, Regression Testing, and User Acceptance Testing (UAT), smoke testing, functionality testing, Sandbox testing. Accompanied with expertise in developing Test cases, Test plans and Test case scenarios in manual and automated test environments.
- Engaged actively in creating reports such as feature progress reports, performance reports and ad-hoc reports.
TECHNICAL SKILLS
Business system analysis/business analysis: Requirements analysis, Requirements management and communication, Backlog grooming, user stories with appropriate acceptance criteria, wireframes, test cases, feature files, change request design flow, UI and UML.
Methodologies &frameworks: Experience in Traditional Waterfall, custom agile water scrum fall, Agile-Kanban, Scrum and Knowledgeable in Scaled Agile Framework (SAFe) Extreme Programming and Spiral methodologies.
Technologies: HDFS, Informatica Cloud, Informatica PowerCenter, Ms Dynamics CRM, AWS.
Reporting tools: MS Excel, Power BI and Tableau
Testing tools: HP Application Lifecycle Management (ALM)/ Quality Center (QC), HP LoadRunner 12.60.
Languages: XML, JQL and SQL.
Other tools: MS Word, PowerPoint, MS Visio and Balsamiq
PROFESSIONAL EXPERIENCE
Confidential
Sr. Business System Analyst/Product test engineer
Responsibilities:
- Provided expert level of expertise. Built effective relationships with the project’s business lead ensuring a collaborative environment is established. Lead facilitation of the team collaboration sessions leveraging BDD (behaviour driven design).
- Applied elicitations techniques, utilizing various modelling techniques such as process modelling, data modelling, system modelling, example mapping, to gather information at the right level of detail and scope to represent all of the stakeholder’s needs, and the ability to ask questions that lead to a succinct understanding of the business.
- Lead analysis, design and preparation of application/system specifications for information systems solutions which address business needs and methods for testing and installing them. Organized, optimised and sustained ATTD and project artifacts that define Product baseline.
- Authored the project’s test strategy, as warranted, during the project’s planning phase or Sprint 0 and lead the design and implementation of a detailed systems test plan to ensure an accurate and effective product. Applied risk assessment methods to identify risk, probability, impact and mitigate approaches.
- Provided IT business needs of applications for mainframe, client/Server-web, and PC based software or middleware. Leading requirements gathering sessions and story decompositions, as well as mapping work, the flow of internal clients.
- Involved in planning activities to ensure system specifications are met, and to identify the risks and interface issues that may result from approval or rejection of changes.
- Worked with cross functional teams on several complex issues, providing business data, and requirement analysis to ensure reporting solutions meet the highest data quality standards using agile scrum.
- Prepared feature files and various business scenarios to ensure that the applications meet the requirements.
- Prepared regression test gold copy for UI pages and performed manual tests on the pages.
- Created user stories and acceptance criteria for an iterative and incremental development of an application with scrum master and product owner.
- Applied significant leadership and collaboration with the team to develop and execute manual End-to-end test cases, and exploratory tests following the test case standards.
- Provided expert support and oversight to creation and maintenance of a set of automated test (using JUnit, Selenium, Cucumber, Jasmine, Protractor, Appium etc.). Provided thought leadership and significant technical contribution to enterprise automation infrastructure, code repositories, and community forums.
- Adhered to best practice for automation and orchestrates code review for test automation code, actively participate in code reviews. Provided realistic estimates. Researches, shares and recommends new technologies in trends. Significant leadership and active participation in initiatives to deepen shift left maturity across their division.
- Ensured the test approach, for every functional requirement/story is captured in the feature files. Challenges the team to automate testing at the lowest possible level (unit, integration or End-to-End).
- Leveraged current tools and techniques used to automate acceptance tests and linked them to requirements key controls (E.g.- Cucumber ). Supported developers and automation engineers scripting the automated tests at all levels of the “test pyramid”. Participates in the automated test code reviews.
- Performed API testing using postman to check if the API’s are returning the data in JSON, XML format as defined in the API documentation and required by the workflow. Participates in special projects and performs other duties as assigned.
- Removed team level impediments and escalated complex organizational impediments which blocked the team’s progress and focused on early resolution of conflicts to keep the team’s velocity and progress on track
- Sustained an ongoing investment in business acumen and product domain knowledge to ensure business needs are met for the project. Conducts research on emerging technologies, tools & techniques to efficiently certify software systems. Optimized Gold regression test suite, Identified opportunities and defined a strategy to automate existing manual test cases, works with other teams to optimize testing across products.
Environment: Agile Scrum, SpringSource tool Suite 3.7.0, Visual Studio Code, Postman, Swagger Editor, MS Office tools, Trello, JIRA, confluence 6.13.9.
Confidential - Johnston, RI
Sr. Business System Analyst
Responsibilities:
- Worked in Agile- Scrum Framework environment facilitating requirement elaboration and elicitation, stakeholder analysis and other business processes (AS-IS vs TO-BE) related optimization activities.
- Conducted Gap analysis and Cost benefit analysis to determine the effects & performance of new features.
- Conducted JAD session, Questionnaire, one-on-one interviews to collect requirements with Product Owner about data types required to be displayed on UI and Persona creation (novices, experts or somewhere in middle).
- Defined the business rules by working with subject matter experts using 'if' and 'then' statements.
- Determined traceability and dependencies between the requirements using Blueprint software.
- Created Wireframes, Mock-ups and high-fidelity Prototypes after closely collaborating with the business users.
- Used JIRA for drafting user stories, defects and tickets for maintenance and deployment of system being developed.
- Involved and assisted scrum master in time-boxed Scrum ceremonies such as Sprint Planning Meeting, Daily Standups, Sprint Review Meeting, Sprint Retrospective Meeting and Grooming Sessions.
- Provided justifiable estimates for stories (story sizing) and tasks that are consistently applied across multiple stories/tasks and from sprint to sprint.
- Involved and assisted the scrum team in loading and transforming large sets of external data (structured, semi structured and unstructured data) from multiple source system such as investment firm researches, articles, stock/bond stories and reviews generated by the investors to Hadoop Data Lake.
- Created mapping diagrams to integrate multiple external data sources to HDFS, mapped the tags of both modules.
- Created an activity diagram to explain the automated workflows and security rules to the team. created use case diagrams and a conceptual data model with the help of SME.
- Performed SQL Queries to extract data from different sources, verify, validate & modify using various commands.
- Worked with the Product Owner during the Sprint Review Meeting for the Potential Shippable Product Increment (PSPI) and help decide which features are DONE and satisfied using the acceptance criteria.
- Assisted in creating Hive tables, loading data and writing Hive queries as per business requirements.
- Assisted the data scientists in creating the customized Machine learning algorithm and validated it.
- Assisted the Hadoop developers in creating HBase tables to store the final aggregated data from HDFS.
- Implemented Spark jobs using Scala and Spark SQL to speedup Hive batch jobs.
- Assisted in creating detailed test plans and test case scenarios. Drafted test cases for integration, regression, end-to-end, smoke, sanity, functional, performance and stub testing.
- Facilitated meetings and conducted Regression Tests, UAT testing across Asset management support functions including business users & Portfolio Managers as admin role, wholesalers, sales and marketing & institutional clients.
- Assisted the QA team to create the readiness document to move the system from testing environment to Pre-production environment and tested the product post deployment in E1, E2 and E3 environments.
- Used Web methods of GET, POST, DELETE & PUT for testing API endpoints and validated the response, response time & error code by executing HTTP requests in postman to ensure that API aligns with expectations.
- Documented best practice implementation plans and continuously measured project outcomes for desired results.
Environment: Agile Scrum, Hadoop Cloudera distribution (CDH) 5.14.0, Hue 4.0, Hive 2.3.1, HDFS, Hbase, Flume, Spark, MS Visio, JIRA 7.2, Tableau 9.1, confluence.
