Gayathri Tumarada

adym3q@r.postjobfree.com

443-***-****

Certification: ECBA (Entrance Certification of Business Analyst) from IIBA. Professional Summary:

• Expertise in writing Business Requirement Document (BRD), Functional Requirement Document (FRD), Data Mapping, Project Charter, Stakeholder Analysis Document, User Stories, Current /proposed process, streamline system data flows using UML, organization structure, process mapping using MS-Visio.

• Experience working with tools such as MS Visio, SQL Server, MS SharePoint, MS Excel, MS Word, MS PowerPoint, and MS Access), JIRA, MS Outlook.

• Produced Graphs, Pivot Tables, and Excel Reports, culminating in a PowerPoint presentation comprised of slides, for executive reporting of key performance indicators of compliance metrics.

• Extensive prior experience analyzing data utilizing Excel and Access for data analysis.

• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.

• Knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

• Understanding and Strong experience in entire software development lifecycle (SDLC).

• Build well-managed data solutions, tools, and capabilities to enable self-service frameworks for data consumers.

• Design, develop and maintenance of existing/new data ecosystem to enable faster insight generation across our analytical platforms.

• Work collaboratively with appropriate Tech teams to build, develop and maintain data solutions.

• Build and execute tools to monitor and report on data quality.

• Experience in creating and updating Test Plans, Test Cases, and Design steps, as well as defect tracking, bug tracking using Test Management Tool HP QC/ALM, Bugzilla, and JIRA.

• Participated in writing High Level Test Plan, Test Scenarios, Test cases based on the requirement and analyzed the results. Skill Set:

Database Systems: SQL Server, Oracle, Teradata, DB2 Tools: MS Office Suit (Word, Excel, Power Point), MS Project, JIRA Reporting: Tableau, Power BI

Testing Tools: UFT, HP Quick Test Pro (QTP), Quality Centre/ALM, Load Runner, SOAPUI TestNG, Jenkins

Professional Experience:

Thermo Fisher Scientific - Frederick, MD Jan 2021 – Present Business Analyst

Responsibilities:

• Converted the Business Requirements Document (BRD) and System Requirement Specification (SRS) into the Functional Requirement Specifications.

• Implemented underlying application following Agile Scrum methodology guidelines to build artifacts in different sprints and phases of the application development process.

• Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point and UNIX.

• Worked on development of business modeling including the use of BPMN, Process Flow Diagram, Use Case Diagram, Activity Diagram, and Sequence Diagram by using UML methodology.

• Facilitated Scrum meetings, including the daily stand-up, Iteration Planning, Team Demo, and Iteration Retrospective.

• Verified the applications according to the requirements. Modified automation scripts as test case changes.

• Involved with Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

• Wrote and executed SQL queries to verify that data has been moved from transactional system to Data warehouse, data mart reporting system in accordance with requirements.

• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

• Automated the reporting elements in multiple systems and prepared the data for analysis using Microsoft Excel.

• Wrote complex SQL queries with sub-queries, analytical functions, pivot functions and inline views.

• Created test plans and test cases in HP ALM as per the requirement document covering all the functionalities.

• Involved with Risk team to fraud check testing and performed End to End testing and UAT testing.

• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems.

• Involve in Defining and Analyzing the Test Requirements based on the Application Functionality and develop Test Plans, Test Cases and Test Script in HP ALM/Quality Center. Under Armour - Baltimore, MD June 2019– Dec 2020

Business Analyst

Responsibilities:

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, and Object-oriented Design (OOD) using MS Visio according to the UML methodology.

• Present solutions in written or oral reports and prepare and deliver presentations using Power Point.

• Gathered Business Requirements Document (BRD), created Functional Requirements Document (FRD) and analyzed data/workflows, defined the scope, financial projections and cost/benefit analysis; progressed from Problem Statement to well-documented designs.

• Analyzed the data using advanced MS Excel functions like Pivot tables, VLook-up, visualizations to get the descriptive analysis of the data.

• Agile legacy system analysis and integration modeling all data sources along with mapping.

• Designed and developed UML Use Cases, Activity Diagrams, Sequence Diagrams, using UML.

• Designed architecture of reporting solutions/Tableau visualizations on Oracle DW/ heterogeneous sources.

• Created Product Roadmap, Product Backlog, Requirement Specification Documents, Sprint Planning, Retrospective, Sprint Review meetings, Backlog Refinement meeting and Story writing workshops.

• Created Business Requirements Document (BRD), Software Requirements Specification (SRS) to incorporate functional, non-functional, GUI Requirements, Data Requirements, Use Case Model, Conceptual Models, RTM.

• Resolved the data related issues such as assessing data quality, data consolidation, and evaluated existing data sources.

• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.

• Developed data analytical databases from complex financial source data. Performing daily system checks. Data entry, data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality.

• Performed Back-End Database Testing by writing and executing SQL Queries on Relational Databases in SQL Toad in order to ensure the Data Consistency on Front-End.

Education:

Bachelors from Andhra University

Contact this candidate