We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst / Scrum Master Resume

Chicago, IL

SUMMARY:

  • Success driven business analyst holding experience in industries like - Banking, E-Commerce and Retail, proficient in providing analytical support for diverse business projects, maintaining a record of improving productivity, expert in business cycle management, business data clarification and eliciting project requirements. Driven by low supervision, strong leadership, and high competence, written & verbal communication skills shared with ability to work under pressure to keep up with the deadlines.
  • Over 8+ years of demonstrated experience as Sr. Business Analyst and Scrum Master implementing advanced analytical methods to resolve the business problems with solid understanding in Business and Functional Requirement gathering, Business Process Flow its modeling and Reporting activities.
  • Experience in working with business users and documenting and reviewing business documents such as Software Requirement Specifications (SRS), Business Requirements Document (BRD), Functional Specifications Document (FSD), Use Case Specifications, and Requirement Traceability Matrix (RTM), Product Backlogs.
  • Extensive knowledge and hands on experience on Software Development Life Cycle methodologies like Waterfall, Agile (SCRUM, RUP, XP) and Hybrid (Waterfall-Agile) to extract the best possible output.
  • Knowledge and experience in various Elicitation Techniques such as Personal interviews, Requirements Workshops, JAD Sessions, Prototyping, Document Analysis, Focus Groups, Surveys and Brainstorming.
  • Participated in Business and Technical design sessions with multi-functional teams consisting of SMEs, Developers, and QA analysts and have experience in facilitating Joint Application Development (JAD) for it.
  • Consistently performed GAP Analysis, SWOT Analysis, Risk Analysis, Impact Analysis and Cost/Benefit Analysis.
  • Proficient in drafting Use Cases, Sequence Diagrams, Class Diagrams, and Activity Diagrams using MS-VISIO.
  • Experience in breaking down the EPICS into Features, Features into User Stories and User Stories into User Tasks and very well versed in writing User Stories and proficient in estimation and prioritization techniques such as Kano Model, MoSCoW, Planning Poker, T-Shirt Sizing and Relative Mass validation techniques.
  • Hands on experience in using the tools such as HP Agile Manager, Atlassian JIRA, Rally and Version One for requirement documentation, User Story tracking and generating various SCRUM Artifacts.
  • Involved in facilitation and drafting Test Cases, Test Plans, Test Scenarios and involved in various types of testing such as Manual and automated testing, Smoke Testing, System Integration Testing, Regression Testing, User Acceptance Testing, and Beta Testing (Open Beta testing and Closed Beta Testing), Performance Testing.
  • Experienced with HP Application Lifecycle Management (HPALM) and HP Quality Center (HPQC) to manage the requirement, track the defects perform Root Cause Analysis and bridge between project team and business.
  • Possess comprehensive understanding of CRM business process like Lead management, customer management, initiating OPPORTUNITY TEAM and enhancing the Quoting & Pricing capabilities.
  • Have knowledge in implementing various advanced fields like Pick lists, Custom Formula Fields, Many to Many Relationships, Lookups, Master-Details, Field Dependencies, Validation Rules, Work Flows, Approval Processes for automated alerts, field updates & Email generation per application requirements.
  • Proficient in creating Profiles, Roles, Users, Tasks and actions, Dashboards, Reports, and Validation rules.
  • Expert in successfully demonstrating the user requirements to the team working on the project by employing Unified Modeling Language (UML) and ER-Diagram using MS-Visio & Enterprise Architect.
  • Involved in designing, developing and verifying Server Side Validation and Client Side Validation.
  • Experience in Data Analysis, Data Mapping, Data Modeling, E-R Diagrams, Normalization. Have strong understanding of Legacy DBMS, Relational DBMS, Object Oriented DBMS, Multi-Dimensional DBMS.
  • Actively involved during Dimensional Modeling Data Design and assisted the team in designing the On-Line Transaction Processing (OLTP) and Operational Data Store (ODS) to enhance the speed of the transaction.
  • Experience in drafting the Data Mapping Document and was involved in concatenating and parsing the text field, executing the related conditional logics, performing look-ups. Assisted the ETL Team in preparing the planning document and have extensive knowledge in SQL and various ETL Tools such as Informatica.
  • Experience in using Salesforce.com Creating Roles, Profiles, Email Services, Page Layouts, Workflow Alerts, Actions and Approval Process.
  • Served as SFDC Subject Matter Expert (SME) for Salesforce Service Cloud Implementation.
  • Have good knowledge of using the SQL Queries to verify the data integrity and data consistency after the completion of ETL process on the data which would be in readable format as per user requirements.
  • Knowledge in designing the Web Services to support the application development that involved XML, XML Schemas and implement the associated Data Logic which makes it reusable and interoperable-loosely coupled.
  • Extensive knowledge of Data Warehousing, Databases, Master Data Management, Data Marts, Dimensional modeling (Star schema, Snowflake Schema) and OLAP operations such as Roll-up, Drill-down, Slicing and Dicing
  • Excellent Team oriented work experience in developing, implementing and deploying the projects.
  • Excellent written, verbal, interpersonal and conflict resolution and time-management skills.

TECHNICAL SKILLS:

Operating Systems: Windows XP/Vista/7/8/10, Linux, Unix

SDLC Methodologies: Water fall, Agile - SCRUM, RUP, Waterfall-Scrum Hybrid

Project Management: JIRA; MS Project; SharePoint 2007, 2010, 2013; MS Office Suite

Testing Tools: HP QC, HP ALM, Load Runner, Selenium IDE

Modeling Tools: Erwin, Enterprise Architect, Mockup Screens, MS Visio, Power BI

ETL and Reporting Tools: Informatica, Tableau, IBM COGNOS

Databases: SQL Server, MySQL, Oracle RDBMS, SSIS

Languages: JQuery, Javascript, java, HTML5, CSS3, XML, JSON, PL/SQL, Python & R Programming.

Customer Relationship Management Product: Salesforce.com

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Business Systems Analyst / Scrum Master

Responsibilities:

  • Maintained artifacts such as BRD, FRD, and SRS; and got approval of it before moving to development phase.
  • Helped Project Manager in preparing Cost benefit analysis, and conducted GAP Analysis
  • Interacted with business owners to identify business system needs, evaluated solutions for business problems and proposed methods to increase efficiency and provide feasible solution to the project
  • Supported project managers with scheduling, reporting, and other project control activities
  • Extensively used ALTOVA MAP-FORCE for data mapping between the existing systems and the new Salesforce Sales Cloud system and drafted the Data Mapping Document.
  • Involved in parsing and concatenating the text fields, performing date and numeric calculations, executing conditional logics and performing look ups to avoid data duplications.
  • Assisted the team in using the cross-reference primary key value to automate and streamline the process of updating the data fields.
  • As a Scrum Master, I was involved in facilitating the ceremonies, breaking the Critical Business Scenarios into User Stories, prioritization of the backlog, estimation of the development efforts.
  • Made sure CRUD Operations are performed on multiple data objects of the new systems even though the respective single record of the existing system is being processed simultaneously worked on Visual Process Manager which is responsible for process like call scripting, customer issue resolution.
  • Involved in developing the business logic and business flow which was built on Java J2EE and hosted on JBOSS using the Hyperion Planning and documenting the various business requirement in the Functional Specification.
  • Responsible to connect the workflow engine of the organization to the social intelligence platform to capture the various potential leads through the bi-directional sync using the Data Aggregator Call.
  • Extensively used Case Feeds and Case Hierarchy to assign the opportunity team to the potential opportunity as per the business value they add to the organization and assisted the upper system, ETL team to plan the process and filter the control tables using Informatica tool.
  • Responsible to facilitate page layout customization, sales process customization, pick list segmentation and setting the validation rules by developing and maintaining the quality procedures and ensured that the priority scenarios are executed as per the business value by assisting the Test-Driven Development.
  • Identified and resolved the team impediments so that the team focuses on the final Potential Shippable Product Increment and delivers it in the given respective sprint.
  • Used Google Analytics for identify the core areas for website and mobile development to attract the new leads and make the platform a better place and user friendly to existing the customers.
  • Involved in analyzing and reporting the Bounce Rate, Click Through rate, number of downloads of the features and drafting the scorecards and charts for the comparison between expected and actual sales

Environment: Java, Java2EE, JavaScript, JBOSS,JIRA, Tableau, HOOTSUITE, SPRING, APITITE,XML, DTD, WSDL, XML Spy, Informatica, SOAP UI, HTML 5, CSS3, Informatica MDM, MS Office Suite 2010 (Excel, Word, PowerPoint, Outlook, Project, Visio), Scrum.

Confidential, WI

Senior Business Systems Analyst/ Scrum Master

Responsibilities:

  • Conducted JAD sessions with AF Direct Team and e-Commerce solution experts to ensure that the application provided a holistic view of the customer, enabling them to support all buying, ordering and service requests across all major channels
  • Gathered functional and business requirements by conducting JAD sessions and participatory Design Sessions involving major executive leaders.
  • Translated Business Requirements Documents (BRD) to Functional Requirements Documents (FRD).
  • Extracted the business requirements from the stakeholders keeping in mind their need for the application for e-Commerce and documented them using Rational ReqPro.
  • Conducted the FRS and URS reviews and walkthroughs with designers, developers and stakeholders. Also conducted feasibility and adaptability study
  • Analyzed the QA project plan, Identifying Bottlenecks and provided scheduling guidelines to the project manager
  • Utilized Quality Center for the designing, storing and executing Test Case
  • Executed test cases and updated defect status in Quality Center
  • Developed the business anomalies workarounds and described them in documentation and presented the matter to the upper management for review
  • Acted as a Scrum Master, consistently worked to improve the processed and quality of team’s work by leveraging agile principles and practices.
  • Effective communication made possible between the developers and the end-clients to guarantee that development efforts were within the scope of the project and the development was as expected having focus of e-commerce business.
  • Held regular JAD meetings with the system architects, developers, database developers, quality testers during the entire project to assure that the critical as well as the minute details of the project were discussed and issues were resolved beforehand
  • Facilitated smooth transition of the project from the project environment to the live environment
  • Worked with QA team and design Test plan and test cases for UAT
  • Executed test cases manually. Compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution
  • Performed User Acceptance Testing of systems
  • Developed and maintained quality procedures, and ensuring that appropriate documentation is in place
  • Developed non-functional requirements and documented them as Business Rules, Quality attributes and constraints document

Environment: Agile/Scrum, Data Mapping, Jira, UI -Html, CSS, oracle.10, ATG/BCC, JAVA, SharePoint, MS Office, Rational Requisite Pro, Rational Rose, UML

Confidential, Hudson, OH

Senior Business Analyst

Responsibilities:

  • Performed JAD sessions, interviewing and surveys with Business users, SME& app developer teams for gathering requirements for Application development. Interacted with the legacy system to understand the requirements for to be system.
  • Analyzed the gathered requirement and reviewed Business Requirement Document (BRD) and Functional Specification Document (FSD) for developing better understanding of system requirement to assist development team’s operations.
  • Considered the customers interest while the customers ordered the products so that the customer had choice to view the orders and make necessary changes while the order is still placed in the Shopping cart.
  • Made sure the products list was updated with the Cost, Image and short description regarding the product and the Warehouse had transparent inventory which eventually increased the Traffic acquisition for the existing site further managing the Traffic for the site.
  • Documented the current state of the system and enhanced the future requests and tried to bridge the gap between those.
  • Performed data retrieval using the SQL queries from database to extract the data that was required to analyze the insights of system.
  • Analyzed the gathered requirement and reviewed Business Requirement Document (BRD) and Functional Specification Document (FSD) for developing better understanding of system requirement to assist development team’s operations.
  • Coordinated and controlled Change Request for the clients by conducting impact and cost analysis, prioritizing and mitigating changes. Prepared change request form to provide details of change request and the further process was carried by Change Manager.
  • Prepared project deliverables through business workflow analysis, process analysis, user requirement documents (Use Cases & Activity diagrams) and managed the requirements and made sure they were well understood by the development team members.
  • Used SQL queries for analyzing data and identifying required data with pain points and solving them with effective solutions.
  • Designed and developed Use Case diagrams and involved with design team in creation of Activity Diagrams and Sequence Diagrams to depict process flows of the entire system.
  • Used Data analytics for analyzing the data for type of products sold and types of maximum buying customers which helps in targeting them for developing the business strategies and implement cash rewards based on purchases made by the customers.
  • Developed a simple database and ETL process to load the existing data to store the data for the business process.
  • Worked with QA team for designing Test Plan and Test Cases for the User Acceptance Testing (UAT) and Regression and Load Testing.
  • Involved in Test Plan Preparation and Requirements Streamlining.
  • Created and maintained the Requirements definition documents that included Business requirements and Functional requirements.
  • Involvement in Preparation of Test Procedures, Test Scenarios, Test cases and Test Data.
  • Developed Keyword Driven and Data Driven frameworks to retrieve test actions, test data from Excel files and SQL Databases.
  • Involved in Test Execution, Results Analyzing and Defect Reporting.
  • Used Tableau for data visualization to communicate information clearly and efficiently via the statistical graphics, plots and charts.

Environment: MS Visio, MS Word, MS Excel, Oracle9i, MS Access, MS SharePoint, Waterfall, Java /Eclipse IDE, Spring framework, Balsamic, REST Web service, GitHub, HP Quality Center 10.0, SOA, HTML.

Confidential

Business Analyst

Responsibilities:

  • Accumulated customer requirements from various end through surveys, interviews, brainstorming and JAD sessions and translated them into system requirements.
  • Developed prototype of information processing application and facilitated collection of functional requirements from system users and preparation of business requirement documents.
  • Created use cases, swim lane diagrams, sequence diagrams, activity diagrams or other visual aids to explicitly capture the requirements and lead the development of business process reengineering processes, procedures, and reports.
  • Involved in Training, Quality Analysis, and Production Support for some of the users. Also assisted in developing dashboards for end users using MicroStrategy reporting tool. Reports were generated taking into consideration various key metrics.
  • Created Wire Frames and Screen Mock ups and layouts using MS Visio.
  • Studied the business and technical needs and modeled the “as-is” and “to-be” scenario for the MS Excel files database files.
  • Designed process model, data models and data sets for new account activity and defined SLA Matrices with business users to measure the performance of the new as well as existing functionality.
  • Designed and documented REST/HTTP API's, including JSON data formats and API versioning strategy
  • Increased database performance by utilizing MySQL configuration changes, multiple instances and by upgrading hardware.
  • Lead user acceptance testing (UAT), interface testing and prepared training related activities.

Environment: Waterfall, SSIS, MS Office, MS Visio, HP QC, HP ALM, MS Visio, MS Office, MS Excel, MS Power Point, SOAP, REST, XML, HTML, Java Script, CSS, MicroStrategy.

Confidential

Business Analyst

Responsibilities:

  • Lead Joint Application Design (JAD) sessions to gather business requirements and to identify data stewards.
  • Served as a liaison between business team and the project team by assisting the business in identifying, understanding, and documenting their business needs.
  • Worked with business users and analysts to understand the requirements for mastering the data obtained from various sources and loading the golden records to the target MDM database.
  • Utilized previous experience and helped team in creation of Schema design in Erwin and implement in database and preparing the technical design document.
  • Translated the business needs into system requirements, communicating with the business on a non-technical level, and with the System Analyst on a more technical level.
  • Instrumental in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems along with data architects.
  • Assisted in performing Data mapping testing in Informatica Data quality at each step of ETL mapping to ensure correct data in flow and outflow.
  • Collaborated with team members and management to identify and solve data quality issues
  • Documented and delivered Functional Specification Document to the project team.
  • Assisted the PM in setting realistic project expectations and in evaluating the impact of changes accordingly.
  • Gathered requirements for Client-Side Validation, and Server-Side Validation. Responsible technical writing for API development. Documented REST API request and response flow in XML format.
  • Conducted UAT to verify whether all the requirements were catered by new data warehouse.
  • Provided technical assistance in identifying, evaluating, and developing systems and procedures that are cost effective and meet business requirements.

Environment: MS Project, MS Visio, Informatica MDM, Informatica Data Quality, Crystal Reports, SQL, Oracle 10g, MS Office, MS Visio

Hire Now