SUMMARY

• Almost 7+ years’ experience as a Business System Analyst with extensive hands - on experience in business consulting and application development with excellent skills in client interfacing, requirement gathering, user support, quality assurance, problem solving, and documentation in Telecommunication & Healthcare Industries.
• Skilled in determining system requirements and specifications for complex application development projects. Past experiences of leading and interacting with business teams, programmers and technical staff Confidential all levels.
• Data Warehousing Concepts, Modeling (including activity, state, sequence diagrams).
• Facilitated and led team projects that improved the relationship between voice brokering team and electronic brokering team - teams that didn’t historically work well together.
• Strong customer service orientation.
• Experience working with API and defining endpoints.
• Strong ability to elicit, document, validate and transform business requirements Confidential different stages of software development life cycle.
• Experienced in gathering requirements for HIPAA (Health Insurance Portability and Accountability Act) EDI (Electronic Data Interchange) Transactions 820, 834, 835, 837 (I, P and D), 270, 271, 276, 277, 278, 997 and 999 in various phases of implementation.
• Experience in web-services or APIs integration with third party product - Inbound Outbound and Getter services.
• Familiar with Automated Testing using tools such as JIRA, HP ALM/Quality center.
• 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.
• Extensive experience in documenting Business Requirements for CRM and Loan application process.
• Highly analytical in developing the methods and measures to meet requirements and solve any issues that arise during the project
• Participate in the IT Governance activities and SDLC projects
• Experience in creating and maintaining the Requirements definition documents that included Business requirements and Functional requirements
• Skilled in developing Use Case diagrams, Sequence diagrams, State Chart diagrams, and Class diagrams
• Exposure in creating and analyzing Data flow diagrams, and Entity Relationship diagrams
• Skilled in track environment build release level Confidential various point in the software building process
• Strong knowledge of Project management skills such as time estimation, task identification, risk analysis and scope management and resource management
• Defining Test Cases, analyzing bugs, interaction with team members in fixing errors, Unit testing and User Acceptance Testing (UAT) among requirements, use cases, change requests, and configure changes
• Conducted requirement analysis techniques such as Business Process Automation, Business Process Improvement, and Business Process Re-engineering
• Involved in maintaining Test Matrix, Traceability Matrix and performing GAP analysis
• Motivated self-starter, good team member with exceptional team building, leadership, and interpersonal skills to resolve issues
• Ability to act as a liaison with different stakeholders of the project

TECHNICAL SKILLS

Platforms: Windows 7/8/10, UNIX

Methodologies: Agile, Scrum and Waterfall

Requirement Management/ Defect Tracking: JIRA, HP ALM, Quality Center

Business Modeling Tools: Microsoft Visio

Database Designing Tools: MS SQL Server, Oracle

Reporting Tools: Tableau

Web Technologies: HTML, XML

Business Applications: MS Visio, MS Word MS Excel, MS PowerPoint, MS Project, MS SharePoint

PROFESSIONAL EXPERIENCE

Confidential, TX

Business Analyst

Responsibilities:

• Collaboratively worked with business analysts, developers, leads and customer SME’s.
• Interacted with client for requirements gathering, analyzing requirements, and creating detailed specifications.
• Analyzed “AS IS” and “TO BE” scenarios, designed new process flows and documented the business process and various business scenarios.
• Implementing Agile Methodologies to break the project into sprints, develop and deploy components on time.
• Analyzed business rules, functional requirements and specifications to create test plans and test cases.
• Prepared the business requirement document (BRD) and system requirement document (SRD).
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements.
• Collaborated with IT Data Modeling team to ensure data model design is consistent and accurate with the business requirements.
• Validated and tested the mappings using Informatica Debugger, Session Logs and Workflow Logs.
• Designed and developed Use Cases, Use Case Diagram, Activity Diagrams, and Sequence Diagrams.
• Performed Root Cause Analysis and Re-engineeredbusinessprocesses, and implemented performance measures, presented project presentations to executive management.
• Created Custom hierarchies to meet the Business requirement in Tableau.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the database.
• Created and maintained SQL Scripts and UNIX Shell scripts to perform back-end testing on the oracle database.
• Responsible for coordinating JAD sessions withbusinessusers to analyses the tracking system, application life-cycle, gather and define the key performance indicators, document and present the requirements specifications.
• Performeddatamapping which specifies whatdatawill be extracted from an internaldatawarehouse, transformed and sent to an external entity.
• Create detail Data elements list to align with requirements and create Data mapping document to show the flow of data from Enterprise data warehouse (EDW).
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements.
• Developed Business requirements, Functional requirement, Technical requirements, Business Process, Workflow etc.
• Connected to SQL Plus in UNIX and created and executed complex SQL queries.
• Performed Data visualization with the help of Tableau.
• Prepared interactive dashboards & visualization in reports with the help of Tableau.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views Confidential once.
• Validated and tested the mappings using Informatica Debugger, Session Logs and Workflow Logs.
• Performed back-end testing by extensively using SQL commands to verify the database integrity.
• Worked with Database team, involved in writing SQL queries, extracting data, creating modifying tables, functions procedures. Performed data validation and Web Services testing.
• Provide analytic support in resolving issues arising from our web user interface and mobile app.
• Wrote use cases and relevant UML diagrams such as Use Cases, Activity and Sequence diagrams.

Environment: Agile/Scrum, HP ALM/Quality Center, Informatica, UAT, Data Mapping, MS SQL Server, ETL, XML, SOAP, REST API, MS Visio, Tableau, MS Office Suite, Windows.

Confidential, Philadelphia, PA

Business System Analyst

Responsibilities:

• Followed Agile/Scrum methodologies for the entire SDLC process.
• Involved in gathering business and functional requirements through different type session like interview, brainstorm, JAD sessions and discussions with the shareholders, End Users, R&D and SME team members to develop an enhancement experience for the mobile application.
• Acting as a liaison between Business Analyst and Developers to analyze current system functionality and elicit business/system requirements.
• Analyze client’s existing business systems, procedure, and data and propose changes that would result in overall system enhancements.
• Created user stories, improvements as per business requirements under each epic of project.
• Involved in analyzing different source systems and assist the BA and technical team to understand the systems and data.
• Worked withBusinessProcess Modeling (BPM) - BPMN methodologies
• Managed JIRA Story boards for issues and workload using JIRA for Agile SDLC.
• Involved in Extracting, Analyzing, Merging and Summarizing Data conversion and Data migration aspects from the existing Financial Systems.
• Conducted multiple JAD sessions to synchronize different stakeholders on their objectives and gathered requirements.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Performed GAP Analysis to analyze the difference between the current systems and the old system. Worked with internal users to help define system requirements.
• Involved in Business Process Management (BPM) activities like Process Design, Process Monitoring and Process Execution.
• Wrote User stories which included the business logic, expected behavior and user acceptance criteria.
• Involved in defect tracking management and used JIRA for requirements documentation.
• Analyzing the sources, transforming the data mapping and data masking the columns and loading the data into targets.
• Created Power BI Dashboards from multiple data sources using complex SQL Queries
• Created Model reports including Data Dictionary, Business reports.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Analysis of the existing document processing system and preparing the understanding document of the current system.
• Develop analytical databases from complex financial source data, create dynamic reports and dashboards using advanced excel.
• Performed data analysis task using SQL queries on Enterprise Data Warehouse (EDW) and various source systems.
• Worked with developers to create requirements and ran SQL queries to extractdatafrom specific tables from database
• Create UML diagrams like Use Cases, Activity and data flow diagram using MS-Visio and consistently translate business requirements into IT solutions.
• Working closely on reporting tools such as SQL for underlying database tables to resolve data issues.
• Created and maintained a Requirement Traceability Matrix (RTM) to see if all the requirements are being captured and are being worked on.
• Performed backend testing using SQL queries to validate data.
• ValidatedXMLschema for system data documentation including the data requirement document.
• Performed Database integrity testing by executing SQL statements.
• Prepared project status reports and represented BA team in PMO meetings
• Create Test Plan and Test Cases for the desired functionality described in the Business documents.

Environment: Agile, Scrum, JIRA, SQL, BPMN, MS Visio, XML, UI/UX, SOAP, API’s, HTML, MS SQL Server, MS SharePoint.

Confidential - Atlanta, GA

Business Analyst

Responsibilities:

• Worked through Software Development Life Cycle (SDLC) from Requirements, Analysis, Design, and Implementation through Testing.
• Created learning environment for team members by brainstorming ideas through guilds, agile events and learn fast iterations.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand the repository objects that supported the business requirements and processes.
• Documented FunctionalSpecifications for Enrollment (834), Customer Service Interface, Claim (837) including Encounter Claim and Capitation Payment (820) and Authorized Representative for Medicaid Members.
• Performed as-is analysis, to-be analysis, data Analysis, Gap analysis, competitive analysis, comparative analysis, process flows and business flows.
• Experience in Integrated Eligibility in order to determine eligibility and deliver Health and Human services through programs such as TANF, Food stamps (SNAP), Development disability, Child care, Adult and protective services, and Employment First Programs
• Developed a detail project plan and helped manage the data conversion migration from the legacy mainframe system to the targetSQLServer database.
• Requirement gathering from Inception and creating RTM, Functional Specification Documents and Data Mapping Analysis for System Integrations.
• Prepared Business Requirement Document (BRD) and drafted Systems Requirement Specification (SRS). Analyzed, modified and validated these documents.
• Responsible for gap analysis in changing old MMIS and Involved in testing new MMIS.
• Provide guidance to the team in terms of Data quality, adopting newly created templates and following delivery methodology.
• Worked closely with business team, and identified, analyzed the core requirements and key features of the ongoing project. Extracted, discussed, and refined business requirements and developed comprehensive business requirement document (BRD)
• Create Functional Specification Documents and Data Mapping Analysis for System Integrations.
• Created a team specific agile work flow in JIRA to move tasks from one activity to another.
• Worked on Pivot table and V-lookups in MS Excel.
• Extensively used complex SQL to retrieve and manipulate data in the database for data validation within the UAT phase
• Actively worked with the Business Users in the UAT phase by helping them build test scenarios, test cases and resolving any anomalies in the results of the reporting elements.

Environment: Agile Scrum, JIRA/Confluence, ETL, MS SQL Server, Data Warehouse, Tableau, MS Visio, MS Project, MS SharePoint, SQL, MS Office, Excel (Pivot Table, V-Lookups), XML, HTML, UAT, Windows.