Siva Kumar

+1-347-***-****

adkbp2@r.postjobfree.com

Synopsis: Senior Business Analyst with 11 years of experience supporting business solution software and analyzing business operations in various domains like Finance, e-Commerce, Education, Telecom, Publication, Tax, Analytics and Healthcare. Improved efficiency via customization, development, and implementation of software applications.

EXPERIENCE SUMMARY

Have 11 years of experience in process redesign/reengineering, agile methodology, requirement gathering, documentation, team management & Unit, functional and UAT testing, providing support to users, planning releases, communicating the releases/downtime to users & stakeholders and facilitating agile ceremonies. Managing the team, by breaking the modules in to tasks and allocating it based on their skillset, tracking and monitoring the progress. Continuously work on improving the efficiency by identifying the scopes and enhancing it.

Around 11 years of professional experience as Business/System/Data Analyst

Worked in different domains Finance, e-Commerce, Education, Telecom, Publication, Tax, Analytics and HealthCare.

Experience working in Agile, SDLC & Waterfall methodologies.

Experience working in Budgeting, Analysis, Design, Development & Testing phases.

Facilitated and participated in Scrum Calls, Defect Review & Backlog Grooming for the team.

Responsible for Grooming the backlog (Feature and User stories) and prepare product release plan

Facilitated and participated in High level Planning Session and Requirement Gathering Session with Stakeholders and SME’s.

Facilitated and participated in JAR & JAD sessions.

Authored BRDs (Business Requirement Document), FSDs (Functional Specification Document), SRSs (System Requirement Specification), Use cases and Data Mapping documents.

Experience in supporting and maintenance of Workday HCM

Documented RTM (Requirement Traceability Matrix), test plans and test Scripts.

Developed Flow Diagrams, Process Diagrams & Workflow Diagrams using MS Visio.

Worked on Use Case, Sequence, Class and database diagrams.

Designed Business Process, Activity diagram, Swim lanes, Context diagram using Real time UML

Worked on Project Management activities involving budgeting, designing schedules and work breakdown structures, prepare weekly status reports, and conflict resolutions.

Expertise in writing User Stories, Creating Sub task for the user stories and Maintaining Product Backlog document.

Experience in creating UI designs and UI Mockups for the usability of the end users.

Experience in working on HTML / JavaScript for creating working UI Pages.

Extensively involved design discussions and user experience sessions to provide inputs on the layout and UX

Experience in performing Gap Analysis and Impact Analysis.

Worked on SharePoint portals; manages access, creates custom lists, document libraries.

Facilitated and participated in Functional Walkthroughs session.

Facilitated and participated in User Acceptance Testing (UAT).

Involved in GUI testing, Functionality Testing of Client/Server & Web based applications and creating test cases, analyzing bugs, interacting with QA/DEV teams.

Experience working on SoapUI for XML and Web Service testing.

Proficient in using Microsoft Office Tools (Outlook, PowerPoint, Word, Excel & Access).

Experienced working with databases like DB2, My SQL, Oracle, MS SQL and MS-Access.

Expertise in writing well-tuned SQL Queries for handling large volumes of data.

Expertise in creating reports using Clear Analytics.

Expertise in performing Data Analysis on massive and high complex data.

Expertise on working on AWS environment.

Experienced in writing SQL queries, which are used to check data quality for reporting purpose.

Expertise in working on Data Profiling & Data Cleansing.

Expertise in working on Data Mapping documents for Data Migration.

Experience in defining impacts of conversion, Business rules and configuration.

Experience in health information and health care services regulatory environment including HIPAA, Medicaid/Medicare, EDI and XML.

Good understanding of Healthcare Claim Processing, Health Care plans.

Strong healthcare business configuration experience with focused primarily on claims adjudication, pricing, provider, member enrollment, and prior authorization.

Possess strong knowledge of healthcare terminology and extensive experience working on healthcare projects. Good understanding of insurance policies like HMO and PPO and proven experience with HIPAA 5010 EDI transaction codes such as 837(Health Care Claim), 999 (Acknowledgment), 834 (Enrollment), 270/271(Benefits Eligibility Request/Response) and 276/277 (Claim Status Request/Response).

Expertise in working at the HIPAA gateway to validate all the EDI X12 transactions according to the HIPAA implementation guide.

Extensive knowledge of various EDI standards including American National Standard Institutes (ANSI), Accredited Standard Committee (ASC) X12 structures and formats.

Highly result oriented and pro-active, proven abilities to learn New Technologies quickly and implementing them successfully in production.

QUALIFICATION

Degree

Institute

Bachelor’s Information & Technology

Osmania University, Hyderabad India

Master’s Computer Systems

University of East London

PROJECT EXPERIENCE

Working as a Senior Data Analyst for CareFirst - Federal Employee Program Operation Center (FEPOC) in a US HealthCare domain involved in modernization project which was to move from mainframes to DB2 and BigData.

Worked as a Senior Business Analyst for Ernst & Young in a US Tax domain involved in all phases of development Budget, planning, Analysis, Design, Development and testing.

Worked as a Project lead for Clarivate Analytics, in a content management domain, as a lead business analyst, led a team of Eight solution analysts, owning the product backlog, facilitating the agile ceremonies, providing solutions to improve efficiency and performing all the roles of a solution analyst

Worked as a Sr. Business Analyst in a project called U.S Patent and Trademark for end to end from requirement gathering to providing solution designs, client-based development, testing, team management

Worked as a Programmer Analyst in a project for Comcast to develop Retail application by providing solution design and developing application.

Client: CareFirst – Federal Employee Program Operation Center (FEPOC)

Role: Senior Data Analyst

Location: Reston, VA (Remote work)

Duration: August 2020 to till date

Configurable Claim Adjudication Engine (CCAE) is modernization and multiyear project. Moving from mainframes to DB2 and Big Data. Project goal is to streamline the claim adjudication process. Canonical Model will used across different modules. This model will accommodate both claim and charge level details from different data sources – CMR, DBR, DBIR, FCR, TWR & OPR.

Roles & Responsibilities

Involved in gathering, analyzing systems to provide requirements for CCAE project

Worked on analyzing raw 837data files to resolve any claim processing issues.

Provided analysis for creating a canonical model

Analyzed TWR, FCR, DBR and 837 data sources, mainframe modules & copybooks to build a new canonical model

Analyzed all the COBOL and mainframe modules and identified all the transformation rules and documented

Performed gap analysis between all the data sources - TWR, FCR, DBR, DBIR and 837 data sources

Documented the data mapping between all the data sources - TWR, FCR, DBR and 837 data sources

Analyzed the Out bound and Inbound file for the canonical model

Involved in monitoring the 837 claim files processing through HIPAA gateway and load them in the database for adjudication process.

Supported the implementation of a Data Integration/Data Warehouse for the Informatics Teams

Performed Data Cleaning – identify erroneous data and determine appropriate resolution

Performed data analysis and data modeling to create source to target mappings.

Perform gap analysis of data requirements versus current data sources.

Work closely with business analysts and source data experts to develop data requirements.

Working within a growing knowledge of X12 5010 HIPAA Transaction Processing 837 I, P, D

Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.

Acquired data from internal or external data sources and maintain mapping documents of the files, databases/data systems.

Involved in JAD sessions to resolve conflict arising from ambiguous requirements.

Creating user stories, Project Requirement Document (PRD), Functional Specification Document (FSD), Mapping documents and Use cases.

Created Functional and Non-Functional Requirements by Analyzing Legacy Code and holding meetings with various SME’s and Technical Architects.

Involved in assisting Functionality testing, Integration testing, Regression testing and User Acceptance testing (UAT).

Provided analysis and insight to QA Team in defects and bugs tracking.

Client: Ernst & Young

Role: Senior Business Analyst - lead

Location: Alpharetta, GA (Remote work with travel onsite as needed)

Duration: June 2019 to August 2020

Electronic Tax Form Validator (eTFV) and Automated Tax Form Validator(aTFV) are tax form validation tools that will be used to support EY’s form validation services by means of electronic submission of IRS Forms W-8, W-9, and CRS self-certifications. Tool is accessible to the external clients which will allow clients of our tax form validation service to be included in the process and allow clients to pull results themselves instead of having to request them.

Roles & Responsibilities

Involved in all phase development life cycle Budget, planning, Analysis, Design, Development and testing.

Work with the various business stakeholders in the support and maintenance of Workday HCM

Document Business Impact Analysis (BIA) and Privacy & Confidentially Impact Assessment (PIA) for the eTFV project.

Documented Non-Functional Requirement (NFR)

Understand Business requirement by conducting workshops and interviews with the business team

Responsible for the Product backlog grooming both on feature and user story

Prepared product release plan based on the feature grooming session

Identified, designed and documented high level process flow, data flows and use cases.

Analyze Business Requirements and segregate the information into high level and low-level Use Cases, Swim Lanes, Activity Diagrams / State Chart Diagrams using MS Visio according to UML methodology, thus defining the Data Process Models.

Created Mockup for the requirements.

Worked with the UX team for creating invision demo for the project

Created Epics, User stories using Azure DevOps and Microsoft TFS

Worked with the product owner in assigning user stories to the sprint

Provided data analysis for requirement with DB changes

Identified all the data elements for the requirement and documented

Documented all the DB changes needed for the requirement.

Provide data mapping document for the Books & Records and DB

Analyzed XML’s and created data mapping

Provided SQL queries for data quality using TOAD.

Worked with the business team on the validation logic sheet

Worked with Dev team in identifying the configuration changes for the validation logic

Facilitated requirement walk through session for the DEV and QA team

Interacted with QA team to support testing

Reviewed test case and test scenarios written by QA team

Experienced in HP ALM/QC to ensure req coverage by Test Cases and defect traceability to Test Cases.

Facilitated Sprint Demo for the business

Assist Development and QA teams to resolve problems and explore opportunities for enhancements and improvements.

Facilitated User Acceptance Testing (UAT) for the business users

Assisted different team (UAT, InfoSec & Performance) for testing the application

Logged all the UAT, InfoSec and Performance testing issues in Azure DevOps

Client: Clarivate Analytics

Role: Senior Business Analyst - lead & Project Owner

Location: Philadelphia, PA (Remote work with travel onsite couple times a week)

Duration: May 2018 to June 2019

Clarivate Analytics is a company that owns and operates a collection of subscription-based services focused largely on analytics, including scientific and academic research, patent analytics, regulatory standards, trademark protection, pharmaceutical and biotechnology intelligence, domain brand protection and intellectual property management. The services include Web of Science, Cortellis, Derwent Innovation, Derwent World Patents Index, CompuMark, MarkMonitor, Techstreet, Publons, EndNote and Kopernio.

Clarivate Analytics was formerly the Intellectual Property and Science business of Thomson Reuters.

Roles & Responsibilities

Responsible for managing projects through the development lifecycle including requirements gathering, functional specifications, testing, implementation, training, transition and maintenance.

Led the team of 12 Solution Analyst working in multiple Business Process.

Proposed and implemented Scrum model for Project

Facilitated Scrum call and participated in Scrum Of Scrum for the project level updates

Worked on the Project Timelines and aligning all Project Delivery

Acted as a Project Owner and responsible for grooming the backlog.

Assisted PMO with the release plan based on the feature grooming sessions.

Facilitated all the Scrum meeting for the Project including Scrum calls, Sprint Kickoff, Sprint Planning, Sprint Retrospective

Responsible for the deliveries of all the Business Processes (JEDI Books & Conference, JEDI Onboarding, Publisher Integration, MJL, Analytical Integrity and Publisher Portal)

Good domain knowledge on all the Business Processes.

Lead the team in the scrum meetings, including backlog grooming, sprint planning and demos with the business.

Worked closely with Business Stakeholders, Users, Development & QA

Provided potential solution by assessing both technical and business suitability.

Documented Business Requirement Document (BRD), Functional Specification Document (FSD) and Data Mapping Document.

Responsible for building and maintaining a relationship with Data Provider e.g. Exchanges, Contributors.

Review deliverables and provides input for other analysts.

Leads discussions and documents meetings. Provide analysis to direct manager and to senior leadership when required.

Performed Gap analysis legacy and Current system which is OCS & JEDI

Provided analysis for the data migration from Oracle to AWS

Worked Use cases, workflows, Swim Lane, Process models using Lucid Chart & Visio.

Designed Flow charts and Sequence diagram using UML

Managed and maintain SharePoint site housing Specification, Requirement documents and other documents

Actively involved in providing technical solution for AWS services

Involved in technical architecture for all the business process

Provided analysis for lift and shift of an existing application to AWS

Wrote SQL queries to check data validation and also perform data comparison between the database.

Model data using MS Excel, Access, SQL analytical tools

Provide data analysis for the Data changes

Provided data analysis and documented data mapping for Data Migration.

Worked on reconciliation scripts to test completeness and accuracy of data load between the Source to Staging and Staging to the Data Warehouse tables.

Reviewed the Test cases with the QA team

Actively involved in Testing and UAT

Ensured the execution of UAT Test Cases and documentation of test results

Provide Weekly & Monthly status reports to Higher management

Actively assisted in mentoring and training the SA team

Client: U.S Patent & Trademark

Role: Senior Business Analyst

Location: Alexandria, VA

Duration: March 2017 to April 2018

Canary is revolutionary product offering control and visibility into the software delivery life cycle to help you build amazing, resilient software. How high velocity Agile teams get software done!

Enable real-time feedback loops. Automate and streamline your build-test-release cycle for reliable delivery of product releases to teams for inspection.

Roles & Responsibilities

Worked on critical component of the application which is “Delivery Pipelines”.

Worked on the project road map & scope definition.

Facilitated Scrum call and other meeting for team.

Worked with the stakeholder’s in understanding the business needs.

Documented business needs and worked on eliciting the requirements.

Authored user stories based on the business needs and added to the Canary.

Analyzed and documented AS IS and TO BE for all the epic user stories

Designed Process flow, Swim Lane.

Worked on the UI/UX design and mock-ups for the user stories.

Facilitated one on one session or team meeting with the skate holders, Dev and QA team to define the requirements.

Facilitated Sprint Kick off, Sprint Demos, Backlog grooming, Estimation session for the team.

Responsible for grooming the product feature

Created power point presentations for Sprint kick off and UAT meetings.

Managed overall SharePoint Operations and Maintenance and documentations.

Worked with stakeholder in prioritizing the user stories for the sprint.

Analyzed the issues and bugs and forwarded it to DEV team for fixing it.

Rich knowledge in uploading Business Risks in HP ALM/Quality center and mapping the Test cases.

Performed defect root cause analysis, interacted with Dev/QA team, and tracked defects in HP Quality Center

Documented Action steps & Acceptance Criteria for all user stories.

Involved in testing the user stories and marking the user stories for UAT readiness.

Facilitated and participated in the UAT meeting for the USPTO.

Assisted the USPTO testing team in testing the release on their DEV environment.

Worked on building and deploying the application using Jenkins.

Worked on migrating Jenkins job to different environments.

Supported the Production releases.

Supported Canary user in terms of usability of the application.

Worked on several prototype concepts and presented to the Stakeholder’s for approval for the implementation.

Use MS Access to automate report creation and distribution.

Client: College Board

Role: Senior Information Analyst

Location: Reston, VA

Duration: May 2016 to February 2017

College Board is a mission-driven not-for-profit organization that connects students to college success and opportunity.

Each year, the College Board helps more than seven million students prepare for a successful transition to college through programs and services in college readiness and college success — including the SAT and the Advanced Placement Program. The organization also serves the education community through research and advocacy on behalf of students, educators and schools.

Roles & Responsibilities

Provide analytical expertise during requirements, design, testing phases and data flows development.

Actively participated in planning session and defect review session.

Worked on Logical Data Models and supporting documents containing essential business elements, detailed definitions, and descriptions of relationship between data elements and documented business data requirements.

Participated in Joint Work Stream meeting (JWS).

Facilitated and Participated in Scrum calls, Backlog grooming, Sprint kickoff and Sprint demos.

Worked with the business user to create business rules and conduct Data analysis for the multiple data mart and the data warehouse.

Provided analysis for Data Migration from Source to target.

Worked with the DBA’s for creating fields, dataset and rules.

Analyzed through SQL queries and documented the data mapping requirements for several Assessments (e.g., SAT, Legacy PSAT)

Worked on Source to Target mapping document, which was used by the ETL team for the Data Migration.

Closely worked with ETL team data mapping between source data and data warehouse

Worked on the scripts to load data from the staging tables to the data warehouse

Interacted with Data warehousing SME’s to gather inputs data mapping requirements.

Performed data warehousing and determined the business rules analyzing the store procedure using Toad and SQL developer

Provided consistent and high-quality queries for data quality check for the project stabilization.

Set up data extracts from MS Access to Excel 2007 to create PivotTables, vlookups and other analysis tools

Worked on optimizing exist Data quality queries based of the data validations.

Analyzed and documented requirements and the corresponding impact on the business process.

Performed GAP analysis of AS IS and TO BE systems.

Performed data analysis and coordinated with DBA team to create data models for new changes.

Performed requirement walkthrough with the DEV and QA teams with the aim to develop testing strategies and test plans.

Supported QA team in creating test cases and testing the functionality.

Participated and facilitated UAT

Create and improve existing reports with MS Excel., convert them to MS Access or SQL Server to automate.

Client: Comcast/Xavient

Role: Programmer Analyst

Location: Reston, VA/ Philadelphia PA

Duration: November 2012 to May 2016

Retail UI is Point of Sale application used by Comcast agents and affiliates to present and sale various cable services offered by Comcast. Retail UI provides complete Buy Flow service for order placement where agents can show all the best offers and services available in their area to customer and build customized offer based on customer choice. When customer place order using Retail UI, the order is submitted to the biller for further order fulfillment.

Retail UI also equipped with Admin Tool that is used for agent administration and reporting purposes.

Roles & Responsibilities

Worked with different teams as the application was a cross functional team development.

Responsible for coordinating with Project Owners, Business Sponsors to identify all the in scope & out of Scope items and finally documented them in the Scope Document.

Performed GAP analysis of AS IS and TO BE systems and modeled them to understand the impact of the different versions and patches of the software across all the sites.

Conducted requirements analysis and facilitated Joint Application Development (JAD) sessions.

Assisted with detailed project planning by contributing and creating business requirements documents (BRD), and functional requirements documents (FSD).

Created Flow Diagrams, Swim Lanes, Process Diagrams & Work flow Diagrams.

Worked on SQL queries and Stored procedures which were used to retrieve data for the application.

Worked on SQL and Oracle databases for analysis and reporting purposes.

Created Requirements Traceability Matrix (RTM) for use cases and test specifications.

Updated task statuses to the business team in the Scrum.

Attended the Planning & Estimate, Recurring Defect Review and Product Backlog Elaboration session for every Sprint.

Created Mock designs for the UI/UX.

Developed UI web pages using HTML and JavaScript.

Used Soap concept for the web service design and implementation.

Used Rest web service for the interaction of UI and controller with the help of Ajax call.

Used SoapUI for XML and web service testing.

Created daily and weekly BA/QA team status reports for management team and Project Management office (PMO).

Worked on the SQL queries, which were used to generate the reports the application like Number of orders place, number of orders placed by the agent, Kind of orders etc.

Facilitate user training for applications and created user manuals for new and enhanced applications.

Actively assisted in mentoring and training the junior team members.

Logged defects and updated user stories with business requirements in JIRA & Rally.

Adept in reviewing Test Procedures, defining Test cases, reviewing and maintaining Test scripts, analyzing bugs, interacting with team members in fixing errors and extensive experience in all forms of testing including User Acceptance Testing (UAT).

Client: State of Michigan/ State of New Mexico

Role: Analyst/Programmer

Location: Santa Fe, NM/ Lansing MI

Duration: January 2012 to November 2012

ASPEN is a welfare project for State of New Mexico. ASPEN is being implemented on the guidelines of BRIDGES project of State of Michigan with the State of New Mexico requirement by Deloitte. This provides different types of programs like Medicaid (MA), Food Assist Program (FAP), CASH, etc. The project aim is to check the eligibility of the people who are eligible for the above benefits with the help of third-party agencies. Applications are filled at the third-party agencies and directly send them to the bridges to check for the eligibility.

Roles & Responsibilities

Participated in the Project Estimation and Scope Definition and ensure that functionality meets Project Objectives.

Translated Business/Customer Requirements into Development Requirements (both Functional & Non-Functional Requirements).

Analyzed and created Use Case model, process flow diagrams, activity diagrams, class diagrams and sequence diagrams using Rational tools and MS Visio.

Developed sequence diagrams, activity diagrams, class diagrams and swim-lane diagrams.

Documented for conversion, redesign, and conducted functional walkthroughs and supervised development of user manuals.

Identified and managed data requirements scope, risks and issues, documented change control and traced data requirements from origination to implementation using analysis SQL queries and mapping techniques.

Developed and managed project plans and schedules. Managed resolution of project issues and conflicts of both External and Internal Audits, including audit interviews, reports, data gathering, etc.

Performed analysis of the technical specifications of AS IS and TO BE process.

Involved in Alignment Management, Process Improvement, Change Management, Issues & Risk Management, Configuration Management and Contingencies Planning.

Client: HDFC Bank

Role: Analyst/Programmer

Location: Hyderabad, India

Duration: September 2008 to April 2011

HDFC Bank, India is a major Indian financial services company that is India’s largest housing Finance Company.

Roles & Responsibilities

Worked on the Business Requirement Document (BRD)

Conducted Joint Application Design (JAD) sessions to allow different stakeholders to communicate with each other, resolve problems at early stage.

Analyzed existing Functional Requirements Documents (FRD) to get a better understanding of the system on both Technical and Business perspectives.

Analyzed and documented information system requirements and the corresponding impact on business processes.

Interacted with Business Users and Stakeholders to identify business system needs, evaluated solutions for business problems.

Designed and developed Use Case Diagrams, Activity Diagrams, and Data Flow Diagrams (DFD’s) to define the Business Process.

Gathered business analysis, requirements capture, and support and testing towards development of a large scale, distributed pricing and risk management framework for Equity Structured Products.

Worked with Subject Matter Experts (SME’s) of different groups to gain detailed knowledge of the different systems and also to understand the cross impacts of the system by conducting meetings.

Understood Mutual Funds Performance and Pricing reporting and reporting system and also understood Invest Smart Reporting Systems.

Worked on Data Mapping and prepared Functional Requirements Document (FRD).

Assist in selection process for vendors and products within the Mortgage Division

Worked on Security Master and Reference data for Equity and fixed income instruments.

Areas of Experience

Processes

Tax & Analytics

Telecom, Ecommerce

Education, Finance, Health Care

Project Management

Expertise

Requirement Gathering, Documentation,

Implementation and Testing,

Preparing Wireframes,

UI/UX, Designing process flows,

Conducting Agile Ceremonies,

Communication with Stakeholders

Technology

AWS

C++, JAVA, J2EE, XML, JSON, HTML

COBOL, Mainframes

Testing Mgmt./Defect Tracking Tools

Jira, Rally, Version One, DevOps, HP ALM/QC

UI/UX Tools

MS Visio

Lucid chart

Report Interface

Clear Analytics

Database Tools

Toad, SQL Developer, RocketShuttle, Microsoft Access

Contact this candidate