Gummalla Charwak, PSM.

adbqzv@r.postjobfree.com

734-***-****

Professional Summary:

Over 9 years of Professional experience as Business Analyst with solid understanding of Business Requirement gathering, Business Process Flow, Business Process Modelling, and Quality Assurance.

Certified Professional Scrum Master with a strong experience in all phases of Software Development Life Cycle (SDLC) and Agile Methodology.

Strong analytical, problem- solving and communication skills with particular emphasis on clear, detailed Business Requirements and Functional Specifications, as well as reports for management.

Direct responsibilities include experience with requirements gathering, planning, organizing, and Change Management.

Experience in SAP and cloud based ERP software.

Extensive experience in Gathering Requirements, analyzing them, modelling Business Process Flows, Use case Specifications, Data Dictionary, Business Continuity Plan (BCP), Workflows and using UML and RUP methodology.

Extensive knowledge on API testing and web services testing using SOAP UI

Adapt in creating Narrative Use Cases, Use Case diagrams, Sequence Diagrams, Activity Diagrams.

Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.

Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.

Strong Knowledge in Finance and banking Industry, Healthcare Insurance, Core banking CRM and SAP ERP applications.

Good knowledge on scripting languages like JavaScript and VB Script.

Extensive knowledge on MYSQL and SQL Queries and a good hands-on experience on IBM Cognos reporting tool.

Expertise in designing relational database models in Microsoft SQL Server and developed Stored Procedures, Views, Triggers using T-SQL.

Experience in conducting User Acceptance Testing (UAT) and verifying performance, reliability and false tolerance issues

Strong interpersonal, communication and presentation skills developed throughout the experience in teamwork as well working with business users, subject matters experts (SMEs), quality assurance personnel and senior management teams.

Technical Skills:

ERP Systems : SAP R/3 4.6C ECC 5.0 ECC6.0

Project Tools : SOLMAN, Share Point, MS Office Suite, Ms-Project, Ms-Outlook,

Mercury Load runner, HP Quality Centre, Manual Testing Techniques.

Education:

B.Tech in Information Technology from JNT University, India.

MBA in Marketing from University of Wales, Newport. U.K.

Professional Scrum Master (PSM).

Attended 4-day training on PMP (Project Management Professional)

Project Experience:

AAALife. Livonia, Michigan Oct 2018 – Till date

Senior Business Analyst

AAAlife is a sister company of AAA. AAAlife offers life insurance to AAA members and also general public.

It is one of the leading Life insurance provider in USA since 1969.

Project: AAALife Marketing Data Environment.

The core of the project is analysing and providing data to the marketing team so that they can market AAA’s products to targeted members. Member data is consumed from various sources into the Policy administration system and is then analysed and sent to Marketing team.

Responsibilities:

Worked with Business teams and marketing teams to gather requirements for the ET2.0 product.

Worked as a liaison between the business teams and the development teams in clearly translating the requirements.

Created and maintained epics, backlog and story cards in Jira.

Worked on integrating live person chat in AAAlife website and worked with developers to test the live chat API using postman.

Coordinate testing applications to support team whenever possible, testing includes manual, database (ETL), Performance and generating reports.

Created and maintained automated test scripts using Eclipse and Jenkins.

Used SQL databases to query and fetch data required for the testing team.

Worked with the development team on integrating Google Analytics/GTM tags on the website for marketing purposes

Worked with QA team and developers to perform web services testing using SOAP UI and POSTMAN

Played a key role to identify, create and facilitate process design changes by conducting business and systems process analysis and design at a complex level.

Worked closely with Product owners to define scope based on story mapping and process flows.

Partnering with internal and external customers and business stakeholders to ensure systems provided meet the long-term business strategies.

Majorly responsible for providing refined business requirements through good user stories to the scrum team with organized workflows, acceptance criteria and required documentation.

Prepared wireframes and involved in solutions for technical debts and improvements. This process involved pairing with enterprise and solution architects.

Conducted Business UATs and demos using SOAP UIs to get final approvals from all the business stakeholders.

While being a backup to the scrum master, conducted Scrum Daily standup, Product backlog, Sprint Planning, Sprint Review & Sprint Retrospective meetings.

Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Jira, IBM Cognos.

ALLY Financial INC. Troy, Michigan. Jan 2017 - July 2018.

Role: Senior Business Analyst.

Ally Financial Inc. is an automotive financial services company offering a full suite of financing products and services, including new and used vehicle inventory and consumer financing, leasing, inventory insurance, commercial loans and vehicle remarketing services.

Project: ALLY Advantage Program.

ALLY Advantage program is focussed on building a strong application for ALLY Financial’s Commercial and Retail departments. Decommissioning the existing systems and moving to one application for all the business transactions and data management is the primary focus.

Responsibilities:

Extensively used SOAP UI to test the data flow using various business flows.

Extensively used SQL queries for data retrieval in testing phases.

Worked with the business users and Marketing team in creating campaign workflows for the marketing team.

Coordinated with the testing team and created ad-hoc test cases to test the data flow.

Primary point of contact for data mapping and data flow diagrams to depict the flow of data from PAC to Marketing team.

Gathered requirements from the marketing team on the specifics on the type of data required.

Conducted JAD sessions with the marketing team and the developers to brainstorm on the requirements.

Worked with the development team and also marketing team to generate reports from the ALFA CRM.

Responsible for conducting UAT testing for the releases.

Maintained functional requirements, reporting requirements and data requirements in JIRA.

Conducted and participated in agile ceremonies including Retrospective, sprint planning and release planning.

Responsible for creating process flow diagrams for Funding business process for ALLY Commercial department including Manual funding, Comerica funding and GM funding.

Investigated solutions for decommissioning many Access databases used to create reports and informational data for commercial department.

Conducted one on one session with Auto business departments to gather requirements for funding and credit lines.

Maintained functional requirements, reporting requirements and data requirements in Blueprint for funding and Credit lines processes.

Responsible for creating and maintaining Epics and user stories in VersionOne for funding business process.

Conducted meetings with ALFA application technical teams in finding solutions to generate reports using the ALFA reporting functionality.

Participated in Agile ceremonies including Retrospective, sprint planning and release planning.

Worked closely with Test managers and Test leads in test planning, creating and maintaining test cases.

Involved in gathering requirements for ALLY’s retail process for Title Management and Insurance process.

Created and executed test cases in HP ALM for funding and Credit Lines business process.

Extensively used IBM Cognos and PowerBI reporting tool to generate reports for testing team.

Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Blueprint, VersionOne, HP ALM, IBM Cognos. Sharepoint.

Blue Cross Blue Shield of Michigan, Detroit, Michigan. April 2016 – December 2016.

Role: Digital Analyst.

Blue Cross Blue Shield of Michigan is the state's leading health benefits organization, serving more than 5 million members residing in the state or employed by companies headquartered there. The not-for-profit company's insurance offerings include traditional indemnity, PPO, and POS plans, in addition to its Blue Care Network HMO plans. It also provides consumer-directed Flexible Blue plans paired with health savings accounts (HSAs), as well as options for individual buyers and Medicare beneficiaries. The organization is an independent licensee of the Blue Cross and Blue Shield Association.

Project : Provider Portal.

Role: Digital Analyst.

The crux of the project is to revamp the existing provider portal with identifying a better access control and adding additional features for the portal with updated applications.

Project : Public retail.

Role: Digital Analyst.

At BCBSM, public retail is one of the busiest departments where all the changes to the public website are constantly updated with PDFs and plan changes.

Responsibilities:

Created sitemaps for the existing Provider portal using Visio.

Collaborated with technical team to understand the architecture of the provider portal and suggested improvements and changes to the portal.

Identified and documented all the applications and documents in the provider portal as part of the discovery phase of the project.

Facilitated meeting with SMEs and technical team to understand the usage of the features with statistics.

Used Clarity tool to identify and generate reports of the customers using the portal.

Met with the users of the portal at Hospitals to gather the process of access to the portals.

Proposed a set of Quick Hits to improve the provider portal with new applications and features.

Coordinated and facilitated extensive meetings and workshops to gather and analyze requirements from SMEs and document in JIRA.

Acted as a liaison between the SMEs and the development team to understand the requirements for the HMO and PPO Plan pages

Worked with the Ninja Team to manage the quick changes to the website and tasks with immediate priority.

Collaborated with Content management team to create new PDFs and Documents for the BCBSM public website.

Facilitated meeting with UX/UI team and content management team to identify and resolve 508 compliant issues.

Worked with the development team to create microsites for various corporate customers.

Participated in Sprint planning, daily standup meetings, Retrospectives and sprint reviews.

Performed System Integration testing and Regression Testing to ensure all the functional requirements are met and valid.

Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Atlassian JIRA, SharePoint, Cisco Jabber, MS office communicator.

The Doctors Company, Lansing, Michigan. Mar 2015 – April 2016.

Role: Business Analyst.

Project1: TDCIS- NOVA 12.0

NOVA is an in house agency management application used by The Doctors Company. The project emphasizes in adding two new modules DWS and Campaign management to NOVA application. Document work station (DWS) is a Document file cabinet where all the documents from the customers, Policy documents and ACORD forms are saved. Campaign Management is a module where all the TDCIS’s sales activities are channelized.

Role: Business Analyst.

Project2: TAM Conversion.

TAM (The Agency Manager) is an agency management application previously used by TDCIS. The project is about conversion of all the Policy data, Claims data, Customer data and Documents from TAM to NOVA. The documents converted from TAM are stored in DWS in NOVA. This project involves lot of analysis on Data mapping, field mapping, Reports Balancing and conversion testing.

Coordinated and facilitated extensive user interviews and workshops to gather and analyze requirements.

Developed crucial functional requirement specification FRS, creating detailed use cases and process flow diagrams to support functional specifications.

Performed requirement gathering and accepted complete ownership of the DWS Module in NOVA.

Acted as a liaison between technical team and business clients to accomplish application enhancement and production.

Created Conversion Matrix for document conversion and Policy conversion.

Worked closely with Business users and Subject Matter Experts SME to understand the work flow and business process.

Created Use cases for better understanding of the sales process for the Campaign Management Module.

Created Test plans, Test documents for Campaign Management and Document work station Modules.

Extensively used SQL queries for data retrieval in testing phases.

Performed daily Batch Jobs using Cisco Tidal Enterprise scheduler.

Developed the product backlog along with product owners and Project managers.

Participated in Sprint planning, daily standup meetings, Retrospectives and sprint reviews.

Participated in creating user manuals.

Coordinated with the QA team to check the weekly status and report the same to the Project Manager.

Performed System Integration testing and Regression Testing to ensure all the functional requirements are met and valid.

Conducted User Acceptance Testing with users and Stakeholders for the validation and got approvals by conducting UAT sessions.

Environment: MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), SQL Server, Oracle Toad, On time, Cisco Jabber, Cisco Tidal Enterprise Scheduler.

Kores India Ltd., India Mar 2014 – Oct 2014

Role: Business Analyst.

Kores is a leading international brand of school and office products best known for solid glue sticks, colour pencils and office supplies.

Responsibilities:

Elicited Requirements through brain storming sessions including the business users and Business Area Experts

Presented the As Is and To Be scenarios along with BIP (Best Industry Practices)

Support in handling OTC (order to cash) related issue resolution in the areas of Sales, Pricing, Billing, ATP and Shipping.

Worked on implementing new changes to the existing Data Model and Master data architecture.

Designed prototypes of the new business processing application

Prepared the Business Requirement Document, got it signed from business users, and derived functional and non functional requirements.

Interacted with the developers on resolving the reported bugs and various technical issues.

Worked on EDI and IDOC data analysis and Interface design and architecture for transactions 855, 850, 940 and 810

Used MS Share point for sharing documents, calendars and other data between users in different locations.

Developed Use Case Diagrams using UML methodology.

Performed Gap Analysis to check the compatibility of the existing system infrastructure, features and functionality with the new business design using the “As Is” and “To Be” methodology

Extensively used Rational Rose and MS Visio for modelling

Provided Production support for Extractors, Info Providers, and other backend functions.

Helped the testing in preparing Test Plans, writing test cases, and implementing User Acceptability Test

Environment: Quick Test Professional, HP Quality Centre, JIRA, MS Word, MS Excel.

STEER Engineering Ltd, Bangalore, India May 2013 – Feb 2014

Role: Business Systems Analyst.

STEER Engineering is a globally acknowledged force in the polymer processing machine industry and a creator of state-of-the-art products catering to the polymer, pharmaceutical and food processing industries.

Responsibilities:

Actively participated in Kick-Off meetings to get a better understanding of the project scope and project requirements within SAP SD( Sales and Distribution) and MM (Material Management) modules as per ASAP methodology.

Involved ingathering business requirements for various business processes including Oder- to- cash (OTC) and Third party.

Facilitated (JAD) Joint Application Development sessions to identify the business rules and requirements for customer master and material master.

Interviewed functional area users to collect Pricing requirements and business process information and facilitate meeting sessions with the Subject Matter Experts (SMEs) from various business areas.

Created project plans, detailing projects’ mission, process flow, timelines, requirements and any risks

Created the requirements Documents using SAP SOLUTION MANAGER.

Assisted the Development team in designing the GUI of the application

Conducted JADs and created Project Schedule using MS Project, and decided on realistic workload.

Developed and maintained all presentations using PowerPoint. Reported weekly status to management, project team and development team.

Created Use Cases using Microsoft Visio and Created the Data Flow Diagrams and Entity relationship diagram using the RDBMS concepts

Analyzed Business requirement, Use Cases and System specifications to write test plan for the installation, GUI, functional, performance and integration testing.

Verified the functional aspect as per the Business Process and validated the user interfaces

Developed test metrics for weekly evaluation of test status

Met with the Project manager on Weekly status reports.

Conducted applicant interviews.

Environment: ECC 6.0, SAP SOLMAN, Quick Test Professional, HP Quality Centre, JIRA, MS Word, MS Excel.

Maveric Systems Ltd. Chennai, India. July 2012 –April 2013

Role: Business Analyst.

India’s leading independent software testing company with a strong and dedicated focus across Banking, Financial services, Insurance and Healthcare

Responsibilities:

Actively involved in Identifying business needs, Gathering Requirements, Analyzing the requirements and documenting the requirements.

Acted as a liaison between Business Users and Technical Team.

Conducted various brainstorming sessions with banking professionals, customers, other stakeholders including the technical and project teams.

Followed a structured approach to organize requirements into logical groupings and developed Business Requirement Documents (BRD) from essential Business Process, Business Rules, and information needs and ensured that critical requirements are not missed.

Participated in performing detailed non-functional requirements analysis, including usability, reliability, performance and scalability. Transformed business requirements to technical models.

Facilitated (JAD) Joint Application Development sessions to identify the business rules and requirements and then documented the Functional Specification Document (FSD) that can be reviewed and understood by both business people and technical people.

Designed Use Case Diagrams, Activity Diagrams, and Sequence Diagrams, Use Cases, and web Prototypes.

Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery.

Assisted project managers with the development of project schedules and developed requirements and preliminary design for client applications. Also created the Risk Register and documented the possible project related risks well in advance.

Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is completed.

Assisted in developing test cases and testing strategy for conducting UAT (User Acceptance Testing).

Assisted in development of training materials for new technology and process improvements.

Environment: Windows, MS Office(MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Visio),MS Exchange Server 2007, .NET, Oracle, SQL, Crystal reports, UML, SWOT analysis, GAP Analysis, Quality Centre.

Maveric Systems Ltd. Chennai, India. Aug 2010 – June 2012

Role: QA Analyst

India’s leading independent software testing company with a strong and dedicated focus across Banking, Financial services, Insurance and Healthcare

Responsibilities:

Involved development of test plans, test schedules, test cases based on high-level and detailed specifications, requirements and designs.

Developed custom procedures to validate the functionality of the application by using Quick Test Professional.

Developed automated test scripts and enhanced them by introducing checkpoints, using regular expressions, by parameterization and correlation of the test scripts using QTP.

Inserted standard, database, table, text and bitmap checkpoints in test scripts and executed the test scripts and analyzed the results.

Enhanced test scripts to perform Data-driven testing by defining and adding parameters values to the Data Table and modifying the steps affected by parameterization, creating output values and by correlation.

Used SQL queries for testing the backend databases and performed data-validation.

Performed multi-user testing, cross browser testing and ad-hoc testing on the management system.

Performed navigational testing of the hyperlinks provided in the web pages in various browsers as a part of GUI testing and cross browser testing.

Developed and executed the Oracle SQL Queries for reports development.

Involved in System Testing, Regression Testing, data-driven testing and smoke testing.

Mapped Test Scripts/Test Cases to Requirements in the Test Plan module of Test Director, to create a requirement traceability matrix.

Identified, logged and tracked defects using the bug-tracking tool - Test Director.

Participated in project meetings, process improvement meetings, review meetings and training meetings.

Developed and executed the Oracle SQL Queries for reports development.

Involved in HIPAA Medical Claims Analysis, Design, Implementation and Documentation

Environment: Quick Test Professional, HP Quality Centre, JIRA, MS Word, MS Excel.

Contact this candidate