SUMMARY

• A functional Business/Data Analyst wif over 7 years of experience in Gathering Requirement, Business Process Design, Data Analysis/Validation and Documenting Workflows.
• Comprehensive noledge of software development methodologies Waterfall, Agile SCRUM/Kanban.
• Extensive noledge in Designing reports dashboard and KPIs trends analysis for stakeholder and leadership review.
• Created Product Backlog, sprint backlog and managed and updated Issues (Epics, Stories, and Tasks) onto Azure DevOps. Participated in Sprint Planning, Daily Scrum Stand up and Sprint Retrospective meetings.
• Experience in query database, validating teh data, failure analysis, and Root Cause Analysis using
• MS SQL and My SQL.
• Played a key role in teh planning, testing, and implementation of system enhancements and conversions in and Scrum and Agile environment.
• Expertise in Joint Application Development JAD sessions, interviews, workshops and requirement gathering sessions wif business users, stakeholders and development team.
• Proficient in creating various artifacts such as BRD, FRD, use cases, RTM, Process flow, Change Request, Test Plan/Case, defect Report.
• Experience in conducting Gap Analysis and SWOT Analysis to gain a clear understanding of teh AS - IS process of teh system and additionally derive new user scenarios to understand teh potential TO-BE process to be implemented in teh project.
• Good Knowledge of Test Plan, Test Scripts and Test Cases for Functional, System, Integration and UAT.
• Experience in Data Analysis techniques such as Data Dictionary, Data Control, and Data Mapping.
• Experience working on MS Visio, Excel, PowerPoint, Word, Access, Outlook.
• Experience in analyzing and creating Use Cases, Use Case Diagrams, User Stories, Data Flow Diagrams, Business Flow Diagrams, Swim Lane Diagrams, Activity Diagrams, Sequence Diagrams, and other related UML diagrams.
• Fast Learner, excellent analytical & problem-solving skills and a team player and able to lead teh teams and consistently demonstrated ability to achieve tight deadline.

TECHNICAL SKILLS

Database: SQL Server, MS Access, MySQL

Tools: MS Visio, Lucid Chart, Rational Rose, Rational Clear Case, Rational Requisite Pro

Project Management and Tracking Tools: Jira, Azure DevOps, HP Quality Center, Rational Clear Quest, Rally, Confluence, SharePoint

Reporting tools: Tableau, Power BI, Ms. Excel

Methodologies: SDLC, Agile, Waterfall, Scrum, Kanban, RUP

PROFESSIONAL EXPERIENCE

Confidential, Columbia, SC

Lead Business Analyst

Responsibilities:

• Gathering requirements from testing perspective.
• Prepared numerous documentations based on teh integration points between different software and services which are connected and might affect by upgrade regime.
• Served as a liaison between teh business teams and teh technology teams located onshore and offshore.
• Performed Meeting Minutes for managerial and technical meetings.
• Performed testing in various environments: DEV, UAT, Pre-Prod.
• Thoroughly and actively involved in testing during numerous deployments.
• Performed Gap Analysis to check teh compatibility of teh existing system infrastructure, features and functionality wif teh new business design using teh "As Is" and "To Be" methodology.
• Actively carried out creating project artifacts such as BRD, FRD.
• Performed in Software Development Lifecycle, SCRUM Framework using Agile Methodology and Iterative Software Development Life Cycle Process.
• Actively engaged in Agile environment and act as lead to document and implement teh process into project.
• Interacted wif SMEs and Stakeholders to get a better understanding of teh client's business processes and requirements.
• Worked wif developers to track various issues during teh testing process.
• Gatheird information needed for documenting estimation hours needed to perform testing for each environment which is important to stakeholders for meeting project deadlines.
• Worked collaboratively and actively wif tech team to analyze teh root cause for Data Defects and Failures.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Preformed business acceptance testing (BAT, UAT) such as business source data consistency, critical data elements validation, and sample data validation, as well as count and column check.
• Set prioritization for module testing.
• Oversaw teh teamwork of a team of BAs, assigned, and evaluated different testing tasks.
• Worked wif on and off-site testers team to coordinate and facilitate testing.
• Created and executed Test Plans and Test Cases to verify software functionality and adherence to business requirements.
• Planned teh UAT testing, test plans, test cases and worked wif teh business users for UAT Test execution and developing test plan documents.

Confidential, Atlanta, GA

Business Data Analyst

Responsibilities:

• Conducted Gap Analysis for as-is and to-be of teh process to identify and validate requirements.
• Performed Interviews and Surveys, Document Analysis wif Business Users, SME’s and multiple teams for requirement gathering and refinement.
• Actively worked in teh Teradata platform and write SQL queries to retrieve teh data from databases to perform data validation, UI Analysis, Backend analysis, data Remediation, and UAT testing.
• Translated teh business requirements specification into teh functional specification and GUI specifications based on business Rules and company listing/delisting rules and procedures.
• Worked closely wif teh product owner and project manager to identified dependencies and risks of teh project.
• An integral part of breaking down teh EPICS into User Stories dat teh development team could estimate teh work using T-Shirt Sizing.
• Generate reports meaningful information for shareholders for decision-making based on teh business need using business intelligence tools (Tableau, JIRA report function).
• Maintained teh Task Board dat was referred to during teh daily standups dat helped teh team track teh stories To Do, In Progress, Done, and Accepted.
• Assisted Data analyst to help develop Data Architecture for teh migration of historical records from existing Listing and Compliance application to teh newly developed web-based application.
• Ran Excel-based Macros to run teh daily compliance reports using Lookups and Pivot Tables.
• Streamlined teh requirements/enhancements for Post-Production release based on business priority to technological severity analyses and mappings.
• Understanding and analyzing test requirements
• Contribution to Test Plan documentation
• Monitored various module tasks from initiation through transition and organize interdepartmental or cross-functional team activities ensuring completion of project tasks and schedule.
• Maintain up-to-date monthly report of accounting documentation.

Confidential, Houston, TX

Business /Data Analyst

Responsibilities:

• Gatheird Business & Technical Requirements, Source System Analysis, Gap Analysis, Data Profiling, Requirements Documentation for ETL development and report development.
• Worked in UML Modeling like Activity Diagrams, Sequence Diagrams, Use Case Diagrams, Process Workflow Diagrams, Interaction Overview Diagrams, and Timing Diagrams.
• Involved wif creating project artifacts such as BRD, Use Case Documentation, FRD, Data Mapping Document, and Systems Requirements Specification.
• Performed in Software Development Lifecycle, SCRUM Framework using Agile Methodology and Iterative Software Development Life Cycle Process.
• Prepared various statistical data analysis reports for corporate clients, provided ad-hoc updates and modified reporting and tracking templates as required.
• Worked in Agile Sprint activities such as daily stand up/Scrum meeting, User Storied, Sprint planning and release planning and other agile meetings.
• Prepared, gatheird and analyzed business requirements, user requirements, design, and technical specification document.
• Managed implementation of Document Management System meeting requirements deadlines.
• Worked collaboratively wif internal partners to do root cause analysis.
• Assist QA Leads in planning/developing a test plan which includes regression testing
• Carried out SQL Scripting, Transactional Data Analysis and Reporting on MS SQL database.
• Analyzed relational data wif SQL to quickly understand existing data stores and to validate source/target mappings and transformation logic.
• Created and executed Test Plans and Scripts to verify software functionality and adherence to business requirements.
• Carried out queries from teh customer database using SQL. Manually performed Back End Testing by extensively using SQL queries to verify teh integrity of teh database.
• Responsible to refresh and revising a monthly report for stakeholders based on teh desktop procedure.
• Involved in other projects as a support team in UAT process.

Confidential, Pleasanton, CA

Business Analyst

Responsibilities:

• Identified high-level requirements for developing and documenting detailed business requirements.
• Converted Business Requirements into Functional Requirements.
• Involved in teh meetings wif Business Process Owners, Subject Matter Experts, and Marketing Team for Requirements Gathering during teh Definition Stage.
• Gatheird requirements and followed teh methodology for teh entire Product Development Life Cycle.
• Gatheird Business Requirements, wrote Business and User Requirement Documents.
• Documented requirements and Use Cases for Refill Prescription and Transfer Prescription.
• Refined teh requirements (Use Cases) and Business Process Models to a detailed level appropriate for technical analysis and system design.
• Analyzed teh reporting process and suggested modifications in teh process to avoid errors.
• Followed established formats and procedures, created new formats as well as researched, created, edited technical and business data documents.
• Created Collaboration Diagrams, Activity Diagrams, ER Diagrams and Project Flow Diagrams in MS Visio.
• Developed Process Models, detailed Business Policies and modified teh Business Requirement Document.
• Prepared teh Business Workflow using MS Visio.
• Analyzed team performance wif teh task manager and implemented teh changes concerning raising teh efficiency of teh entire team.
• Involved in weekly walkthroughs and inspection meetings to verify teh status of teh team and teh project as a whole.
• Encouraged team members to step up and share their noledge on teh project wif teh team.
• Transitioned from teh Waterfall method to teh agile development cycle to improve productivity and continuous improvement of teh release cycle and work prioritization.

Confidential, Buffalo, NY

Business Analyst

Responsibilities:

• Assisted Project Manager (PM) as project coordinator in creating Work Breakdown Structure (WBS) and Project Charter using MS Project.
• Assisted teh team wif User Acceptance Testing (UAT) maintaining Quality Procedures; also, assisted QA
• Identified and Modified Defects, Issues and Priorities using JIRA and captured them into tracking log.
• Identified bugs and assisted via User Acceptance Testing (UAT) to verify if teh system meets user requirements and get UAT Sign Off from teh stakeholders.
• Created UML Diagrams like Use Cases, Activity and Sequence Diagrams using MS Visio for clear understanding of teh vision document.
• Generated ad hoc reports by writing Structured Query Language (SQL) using special functions like Joins, Inner joins, Outer joins, implementing database connections to fetch data from teh Serve