Sr. Sales Operations Business Analyst (consultant) Resume
PROFESSIONAL SUMMARY:
- 6 plus years’ experience in all phases of Software Development Life Cycle (SDLC) as Project Manager, 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 interpersonal skills wif ability to interact wif 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 wif business users and separately wif 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 wif 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 reengineering, UI design, and process flow modeling.
- Involved wif Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP) in agile environment.
- Facilitated Agile Ceremonies as follows: Backlog Grooming, Sprint planning meeting, Daily Scrum, Sprint review meeting, and Sprint retrospective meeting.
- Proficient in Web Services implementation wif SOAP, WSDL and REST.
- Hands on experience in using SQL Queries, Stored Procedures, Triggers, Views, Indexes in SQL Server wif a strong understanding of data & analytics.
- Worked efficiently on multiple projects spanning over different releases at teh same time.
- Experienced in performing Business Process Reengineering/Gap Analysis to check teh compatibility of teh existing system infrastructure wif teh 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 noledge in teh 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 noledge 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.
Bachelor Degree: Media Management wif Minor in Project Management.
PROFESSIONAL EXPERIENCES:
Confidential
Sr. Sales Operations Business Analyst (Consultant)
Responsibilities:
- Supported sales organization use of Salesforce
- Analyzed business & processed requirements
- Facilitated testing, documentation, communication and training
- Supported Data Quality in SFDC
- Drew conclusions regarding complex data & information
- Managed Projects & was primary liaison between IT and Sales Operation team.
- Supported CRM Manager in development of strategy & communications
- Worked wif IT to clarify business requirements
- Performed data uploads, created report and worked closely on dashboards
- Monthly uploaded data for mapping & worked on cleaning of data in SFDC.
- Conducted UAT - defined, coordinated and executed UAT against business requirements. Documented test results and developed remediation plans.
- Worked wif Tableau team to create reports desired by upper management
- Developed training plans, materials, presentation & documentation
- Posted announcements for end users.
- Contributed to teh analysis & design of Salesforce.com enhancements
Environment: Jira, Confluence Tableau, Salesforce, MS Visio 2007, MS Office 2007, MS Project, Outlook, Rally, Service Now, Crystal Reports, Data Modeling
Confidential
Project Manager and Business Analyst (Full-time Employee)
Responsibilities:
- Worked wif 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 teh Agile methodology & participated in stand up meetings when necessary.
- Conducted meetings wif 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 teh Actor(s) and system.
- Conducted Gap Analysis.
- Created Epics, User stories wif 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 teh testing team.
- Conducted Requirement Gathering and JAD sessions.
- Performed User Acceptance Testing (UAT). Developed Test Scenarios and documented Test Plans dat contains test scripts, test cases, test data and expected results. Used Toad to run SQL queries to get teh useful information from database.
- Facilitated Agile Ceremonies as follows: Backlog Grooming, Sprint planning meeting, Daily Scrum, Sprint review meeting, and Sprint retrospective meeting.
- 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 teh start of teh project until teh end as required.
- Worked wif IT team for data extraction, Transformation and Loading from source systems to destination systems.
- Worked wif teh Asset Management financial advisors to deliver a full range of financial services and products to prosperous client.
- Used MS SharePoint to Upload and share various documents, deliverables wif other teams and departments.
- Worked closely wif Platform Subject Matter Expert's in understanding teh 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
Project Manager/Sr. Business Analyst (Consultant)
Responsibilities:
- Gatheird requirements and conducted interviews wif business users and Project Manager to understand teh needs of teh 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 teh primary liaison between teh Business line, operations, and teh technical areas throughout teh Project Cycle.
- Worked on various applications and Conducted Gap Analysis between “As is” and “To be” process for teh applications. Participated in teh Logical and Physical Design sessions and developed Design Documents.
- Used Web Service dat checks teh background of a vendor.
- Identified and analyzed business problems and defined teh scope of activities required to address teh 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 wif teh developer to create applications supporting these roles.
- Lead Scrum meetings.
- Responsible for business process modeling, process mapping.
- Created DCR (Document collection repository) diagrams in MS Visio to understand teh inbound and outbound files, uploading of documents in teh applications. Also created diagrams to depict teh 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 dat their needs/business requirements are being met
- Gatheird data requirements for systems and overseen ETL processes using Informatica
- Coordinated data profiling/data mapping wif 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 teh ETL team to load data into teh target database and insisted them wif source to target mappings and wif teh 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 teh scope of activities required to address teh 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 wif 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 . Headquarters NYC, NY
QA Analyst/Mobil Tester (Consultant)
Responsibilities:
- Used Quality Center to prepare Test cases, procedures, Requirements Traceability Matrix and managing teh Defects.
- Conducted GUI/Usability Testing according to specifications and design document.
- Responsible for testing teh e-commerce solution of shopping cart software at front end and back end.
- Perform teh 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 teh authorization and autantication wif 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
QA Analyst (Consultant)
Responsibilities:
- Analyzed teh Test plan, which detailed teh testing scope, strategy, test requirements and necessary resources.
- Responsible for maintaining test cases and test scripts for teh 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 teh defects.
- Utilized agile test methodology and performed manual functional testing.
- Participated in all phases of teh Software Life Cycle.
- Developed test plan and modified teh 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 teh applications.
- Participated as a key member wif teh QA Team for Regression testing where day-to-day bugs were monitored
- Worked wif developers and teh testers for resolution of teh 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 (Consultant)
Responsibilities:
- Created and executed functional, integration and regression test cases based on teh software functional requirements.
- Reported teh defects to team lead/development team on periodic basis and retesting teh defects as they are fixed.
- Reporting teh status to teh upper management (Team Lead and SME) on test progress.
- Tracking teh execution till teh final delivery and followed by teh project closure.
- TEMPEffectively performed bug tracking using Quality Center and JIRA.
- Participated as a member of teh project team to ensure requirements, technical specifications and designs are understood; attend project meetings as requested by teh 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 wif SMEs for understanding teh data requirements and teh business processes.
- Checked for teh Database Integrity using teh SQL queries.
- Manually verified teh Database changes which occurred due to teh 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 teh new functionality worked as per specifications.
- Performed Integration testing to check if teh flow of applications was smooth.
- Performed End To End Testing of teh Application.
Environment: Windows, Quality Center10.0, JIRA, SQL, Microsoft Office, All Browsers