PROFESSIONAL SUMMARY:

• 5 plus years’ experience in all phases of Software Development Life Cycle (SDLC) as Business Analyst & QA Engineer.
• Experienced working in different SDLC Methodologies including Agile and Waterfall.
• Thorough hands on experience in designing use cases, flowcharts, wireframes & writing business requirements, plus verifying and validating Web based E - commerce applications by using testing techniques.
• Proven track record in requirement gathering, analysis, data collection, evaluation of Information Systems, resolving issues, problem solving, decision-making, communication and inter­personal skills with ability to interact with individuals at all levels.
• As Business Analyst, experienced in E-commerce and Banking domain.
• Skilled in Business Process Modeling, Use Case modeling, Data Modeling, Project Management and Change Management.
• Involved in conducting various JAD sessions with business users and separately with development & QA teams.
• Experienced in performing demos for Software Training, QA testing, System Testing, troubleshooting of client server and Web-based applications.
• Hands on Experience of CRM Salesforce with creation of multiple objects including Campaign, Leads, Opportunities, Account, Clients, Contact, etc.
• Transformed business requirements into functional specifications, focusing on workflow analysis and design, business process re­engineering, UI design, and process flow modeling.
• Involved with Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP) in agile environment.
• Proficient in Web Services implementation with SOAP, WSDL and REST.
• Hands on experience in using SQL Queries, Stored Procedures, Triggers, Views, Indexes in SQL Server with a strong understanding of data & analytics.
• Worked efficiently on multiple projects spanning over different releases at the same time.
• Experienced in performing Business Process Reengineering/Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Hands on experience of modifying Data warehouse and Business Intelligence ETL tools using Informatica, Ab Initio, Business Objects and Cognos.
• In-depth knowledge in the Investment Banking Industry, Project Finance, Credit Card Industry, Mortgage Loan Origination, Loan Servicing, Treasury Services, Brokerage Services, Commercial Banking, Retail Banking, Asset Wealth Management, Cash Management, Capital Market and Credit Risk Fundamentals.
• Handled production support from business team for critical & high priority production tickets.
• Extensive knowledge of Design Patterns, Structured and Object-oriented Analysis and Design.
• Expert in MS Office Products such as Word, Excel, Project, Power Point, Access, & Visio.

TECHNICAL SKILLS:

Tools: Microsoft Office Suite (Word, Excel, Power Point, Project, Access), Outlook, Microsoft SharePoint, MS Exchange, IBM Lotus Notes, Lync, & Service Now.

Analysis Tools, Techniques: RUP, UML, Object Oriented Analysis, Rational Rose, Visio, Rational Requisite Pro, Data Analysis, Data Modeling, ETL Analysis, Dashboard Design, BRM, and Blueprint.

Testing Tools: Quality Center (ALM), JIRA, Test director.

Reporting Tools: Cognos, Crystal Reports, and Business Objects.

Business Intelligence: Data warehousing, ETL process to transform and load data in Data warehouse

CRM: Salesforce

Database: SQL Server, Oracle, Teradata, and MS Access.

Data Access Technologies: PL/SQL, Toad, MQ Series, and Stored Procedures.

Operating Systems: Windows XP, Advanced Server, Windows 2x, Windows NT, and UNIX.

PROFESSIONAL EXPERIENCES:

Confidential

Business Analyst II

Responsibilities:

• Worked with Business team during analysis phase to define features
• Created FR and NFR for newly built platform called Supplier Connections and Servicing UI for JPMC internal role.
• Actively worked in the Agile methodology & participated in stand up meetings when necessary.
• Conducted meetings with Business and Technical Area Experts, asking detailed questions to understand project needs from business & technical standpoint.
• Liaison between Business and Technology teams.
• Created Use case scenarios, representing the Actor(s) and system.
• Conducted Gap Analysis.
• Created Epics, User stories with clear Acceptance Criteria, & also used Gherkin format when required.
• Created Virtual Card diagrams & process flows using Microsoft Visio.
• Created Wireframes and UI mockups.
• Created data tables for the testing team.
• Conducted Requirement Gathering and JAD sessions.
• Performed User Acceptance Testing (UAT). Developed Test Scenarios and documented Test Plans that contains test scripts, test cases, test data and expected results. Used Toad to run SQL queries to get the useful information from database.
• Lead scrum meetings.
• Created numerous objects in CRM Salesforce to work in conjunction on multiple functionalities of Single Use Accounts.
• Conducted story grooming sessions & sprint planning sessions.
• Presented demos during showcase stage.
• Provided clarification to technical teams from the start of the project until the end as required.
• Worked with IT team for data extraction, Transformation and Loading from source systems to destination systems.
• Used MS SharePoint to Upload and share various documents, deliverables with other teams and departments.
• Worked closely with Platform Subject Matter Expert's in understanding the upcoming and existing API's on different mobile platforms & tested API changes.
• Conducted ADA (American Disability Act) Compliance Testing using JAWS and NVDA.

Environment: MS Visio 2007, MS Office 2007, XML, DAT, MS Project, Oracle, Toad, UML, Windows XP, Quality Center, Doors, Agile, Rally, Jira, ALM, Excel, Soap UI, Blueprint, Salesforce.com, JAWS and NVDA

Confidential, Glenview, IL

Sr. Business Analyst

Responsibilities:

• Gathered requirements and conducted interviews with business users and Project Manager to understand the needs of the application.
• Designed data flow, mapping design documents and ETL process to extract data from sources and store them to staging tables and also designed ETL process to transform and load data into Data warehouse.
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• Worked on various applications and Conducted Gap Analysis between “As is” and “To be” process for the applications. Participated in the Logical and Physical Design sessions and developed Design Documents.
• Used Web Service that checks the background of a vendor.
• Identified and analyzed business problems and defined the scope of activities required to address the issues, including requirement definition, process review, impact assessment and operational streamlining where appropriate
• Used SOAP and WSDL for web services.
• Created role based matrix for these applications and worked with the developer to create applications supporting these roles.
• Responsible for business process modeling, process mapping.
• Created DCR (Document collection repository) diagrams in MS Visio to understand the inbound and outbound files, uploading of documents in the applications. Also created diagrams to depict the process flows and use case diagrams for applications related to each other.
• Acted as primary communication channel between business areas and Data warehouse group. Provided support to Data warehouse users to ensure that their needs/business requirements are being met
• Gathered data requirements for systems and overseen ETL processes using Informatica
• Coordinated data profiling/data mapping with business subject matter experts, data stewards, data architects, ETL developers, and data modelers. Identified opportunities for business process improvement and initiated efforts to make improvements.
• Analyzed data requirements, data accuracy and created specifications for the ETL team to load data into the target database and insisted them with source to target mappings and with the tables, columns and other database objects.
• Created documentation for Analysis reporting, architectural presentations, infrastructure specifications, strategy planning, risk analysis, contingency plans for company executives.
• Identified and analyzed business problems and defined the scope of activities required to address the issues, including requirement definition, process review, impact assessment and operational streamlining
• Proficient in creating user stories, epics, maintaining product backlogs and test cases in Agile methodology.
• Documented and tracked all product defects with use of SQL (reporting).
• Documented how to add/delete/modify existing users in an application and how to create access request through an internal approval based system & created BRD’s.

Environment: Microsoft SharePoint, .Net, MS Visio, MS Office, Data warehouse, ETL, Informatics, Erwin, Web Service, MS Exchange, Microsoft Project, PL/SQL, UML and Data Stage, Iterative Process Methodology.

Confidential, NY

QA Analyst/Mobil Tester

Responsibilities:

• Used Quality Center to prepare Test cases, procedures, Requirements Traceability Matrix and managing the Defects.
• Conducted GUI/Usability Testing according to specifications and design document.
• Responsible for testing the e-commerce solution of shopping cart software at front end and back end.
• Perform the tasks of testing in inventory management.
• Created test data sets for available promotions, validate Coupons/Vouchers and product details by conducting positive and negative test for online shop.
• Involved in testing Web based e-commerce Application and performed Security Testing to ensure the authorization and authentication with Credit card tokenization.
• Conducting testing of shipment services, comparing results to FedEx results.
• Responsible for validating shipment cost on online shop is accurate.
• Responsible for performing functional and integration testing of software application.
• Involved in planning test scenarios and writing test cases and test results for application.
• Performed end-to-end testing, Integration Testing, and UAT Testing.

Environment: Agile, E-commerce Web application, Hybris, CQ, DB2, Quality center ALM, Soap UI, Postman, JIRA, SQL, Windows, IE, FF, Safari etc.

Confidential, IA

QA Analyst

Responsibilities:

• Analyzed the Test plan, which detailed the testing scope, strategy, test requirements and necessary resources.
• Responsible for maintaining test cases and test scripts for the application using MTM.
• Developed test related documents including Test Plans, Test Procedures, Test Cases and Test Scripts.
• Involved in Manual testing using TFS to develop and logging the defects.
• Utilized agile test methodology and performed manual functional testing.
• Participated in all phases of the Software Life Cycle.
• Developed test plan and modified the test plan when required in later stages of testing.
• Performed (UAT) acceptance Testing, verification/validation and Regression Testing
• Written SQL Queries to extract data from various database tables for testing purpose.
• Performed feasibility studies and evaluated system requirements.
• Tracked Bugs and Reported using Defect Tracking and Maintenance Team Foundation Server Tool.
• Created Test Data to test different scenarios after a thorough analysis of the applications.
• Participated as a key member with the QA Team for Regression testing where day-to-day bugs were monitored
• Worked with developers and the testers for resolution of the problems reported.
• Attended daily stand ups and defects review meetings.

Environment: Agile sprint, TFS (Team Foundation Server), MTM (Micros0ft Test Manager), SQL, IE, FF, Chrome, Word, Excel, etc.

Confidential, AL

QA Tester

Responsibilities:

• Created and executed functional, integration and regression test cases based on the software functional requirements.
• Reported the defects to team lead/development team on periodic basis and retesting the defects as they are fixed.
• Reporting the status to the upper management (Team Lead and SME) on test progress.
• Tracking the execution till the final delivery and followed by the project closure.
• Effectively performed bug tracking using Quality Center and JIRA.
• Participated as a member of the project team to ensure requirements, technical specifications and designs are understood; attend project meetings as requested by the Functional Test Lead.
• Used Quality Center to report all defects, defect status and closure information; ensured data is correctly reported in it when defect is resolved or closed.
• Closely worked with SMEs for understanding the data requirements and the business processes.
• Checked for the Database Integrity using the SQL queries.
• Manually verified the Database changes which occurred due to the new data in tables and new fields which were added in various tables.
• Involved in identifying data for testing purposes.
• Performed Functional testing to check if all the new functionality worked as per specifications.
• Performed Integration testing to check if the flow of applications was smooth.
• Performed End To End Testing of the Application.

Environment: Windows, Quality Center10.0, JIRA, SQL, Microsoft Office, All Browsers