Suvarna Ravuri Phone: 919-***-****

Lead Business Analyst E-mail: adqsen@r.postjobfree.com

SR

Job Related Summary:

7+ years of experience as a Business Analyst.

6+ years of HealthCare experience.

6+ years of experience in Agile & Change Management activities

Worked with Major Clients: BCBSNC (Currently working), Pfizer and Cigna

Excellent communication and interpersonal skills.

Education:

Bachelor of engineering (BE) focus on Electronics and Communications.

Certified in Tableau from Collabra.

Certified in Azure AZ-900.

Summary:

Over 7 years of diverse experience as Business Analyst in Information Technology with the ability to work independently and manage business expectations with a delivery-focused approach to work, ability to build and experience interfacing with Stakeholders, System Analysts, senior management with excellent communication and interpersonal skills.

Four years of extensive, practical experience as a Business and Systems Analyst in Health Care Industry.

Strong working experience in Claims, Benefits and Insurance Applications (Enterprise Claim System).

Worked in both Agile Scrum and Waterfall methodologies.

Experienced in Document Management Tools like SharePoint and Compass (Open text).

Thorough knowledge of Business analysis and Iterative Software Development Life Cycle (SDLC) using Rational Unified Process (RUP) and RAD. Proficient in applying RUP in all the four phases during software development Inception, Elaboration, Construction and Transition.

Involved in Sprint planning meetings (review product backlog and set scope for sprint) and expert in setting up sprint goals and standup meetings.

In depth understanding of the AS-IS and TO-BE business processes, experience in documenting business requirements, vision, scope documents and maintaining project charters.

Leading Audit meetings and worked with Compliance team to make sure all confidential information meets organization security standard.

Worked on different ETL tools to Extract,Transform and load the data .

Leading JAD sessions to facilitate discussions of requirements scope, priority, and dependencies. Work with application architects, developers, testing teams thereby coordinating efforts.

Expert in performing data analysis and testing with the help of SQL statements.

Conducting feasibility, adaptability study and risk analysis to identify the business-critical high-risk areas and recommending solutions to management.

Expert in writing detail system use cases, developing business test cases and working with QA teams during testing phase thereby facilitating acceptance testing with stakeholders and business users.

Experienced in the documentation of specifications, creating step-by step technical and user manuals with illustrations, screen prototypes and implementing new processes and technology.

Extensively used Tableau and Alteryx for Data Analysis.

Worked on AWS to archive the CMS files.

Technical Skills:

Data Warehousing

Ab Initio, Informatica PowerCenter 9.1/8.6/7.1 (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, and Workflow Monitor),

Operating Systems

Windows (XP, 7), Linux (Red Hat, Fedora), UNIX (Sun Solaris, AIX, HP-UX)

Data Modeling

Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake Schema, Fact Table, Dimension Table), ERWIN 4.0/3.5

Databases

Oracle11g/10g, SQL Server 2000/2005/2008, IBM DB2 8.1, OLTP, Teradata 13

Programming

SQL, PL/SQL, SQL*Loader, UNIX,

Query Tools

SQL Developer, TOAD, SQL*Plus, Teradata SQL Assistant

Reporting Tools

Tableau, Business Objects XI

Business Tools

MS Office (Word, Excel), Test director, AutoSys, MS Visio

Professional Experience:

BCBSNC, NC Mar 2017 - Current

Lead Business Analyst

BCBSNC – Major US Health Care provider has claims datasource of multiple geographic regions. Each region had its own information management system; the project objective is to consolidate all the varied source data to common consistent claims warehouse.

Responsibilities:

Breaking-down business requirements and complex business needs into their simplest elements and user stories to provide clear documentation to IT developers and architects while maintaining end to end traceability.

Capture technical requirements, defines scope and objectives, and formulates systems to parallel overall business strategies

Creating functional and non-functional test strategies and test cases

Involved in developing workflows and Data flows diagrams.

Assisting as liaison between business, technical teams and EQA for test plan builds

Executing test cases as IT product owner in support of user acceptance testing

Developing clear technical user stories/documents that accurately depict data process flows and interfaces

Leading user story grooming with business and technical teams.

Participating in sprint and release planning

Responsible for DSS applications KT planning and schedule.

Release assessment, migration methodology, setting up development Testing and Production environment.

ETL design and strategy development and number of graphs needed and Effort estimation in terms of number of simple, Medium and complex graphs that are required for development and testing timelines.

Setting up job schedule and graphs dependencies.

Tasks assignment to Offshore-onshore teams, allocation, and providing the direction and guidance for the development whenever team is stuck with development issues.

Defined the coding standards and guidelines for the project.

Designed and reviewed the reusable Abinitio components.

Incorporated the best practices and performance tuning measures for the existing graphs

Requirement Gathering and review of the Business Requirement Documents.

Defining Estimations, Delivery and Technical (Ab Initio) Standards.

Developed re-usable design patterns in Abinitio and UNIX.

Parsing high-level design spec to simple ETL coding and mapping standards.

Used different functions in ETL process to filter and parse the data.

Performed reviews of all ETL designs, graphs, job Scheduling and test plans.

Involved in designing and implementing data quality and data auditing processes.

Co-Coordinating with the Subject Matter Experts for inputs and approvals while performing bug fixes and performance enhancement measures for the production jobs.

Develop UNIX wrapper, purge, cleanup scripts and schedule using control-M scheduler.

Designed and developed the graphs using the GDE, with library components and created custom components to be used for the reusability of standard read and write processes.

Performance tune the graphs using various techniques like using parallelism, phasing and checkpointing, avoiding unnecessary sorts, defining proper max core value, using partitioned lookups etc.

Created a design and framework for the generic Ab Initio Code to handle the multiple and ever-expanding list of data files coming from source.

Developed Complex AbInitio XFR’s to derive new fields and solves rigorous business requirements.

High level Design DW/BI Development, Support and Operations methodology.

Developed workflows using Alteryx using XML as input files.

Used different Alteryx tools like Data cleansing, Filter, Select, Join and Union in Alteryx to Blend the data and created Hyper files as Output for BI Tools.

Provide reviews at all phases of the project.

Responsible for project communication, escalation (from and to project team, Customer and supporting groups) and knowledge management.

Responsible for archiving all project related CMS files into Glacier for 10+1 years using AWS

CIGNA, Raleigh, NC. Jan 2016 – Feb 2017.

Business Analyst.

Cigna is a global health service company dedicated to helping people improve their health, well-being and sense of security. Its insurance subsidiaries are major providers of medical, dental, disability, life and accident insurance and related products and services, the majority of which are offered through employers and other groups (e.g. governmental and non-governmental organizations, unions and associations).

Gathered requirements for business process flow and on-screen flow for wizards driven products from products SME's and Salespeople and created requirements documents.

Prepared BUC (Business Use Cases) for proper building up documentation for the different sub systems

Created and documented the Data Flow Diagrams, Context Free diagrams and Use Case Diagrams to model System Requirements using MS Visio.

Created User and System Level Use Cases that include documenting the various sections in a Use Case Document like overview of use case, requirements satisfied, Preconditions, Actors, Main Flow, Sub Flows and User Interfaces.

Coordinated and executed the development of test cases and analysis of results.

Coordinated the development review meetings and training sessions.

Created Business Rules Document and Requirement Traceability Matrix to track the requirements.

Facilitated daily created Test Cases, Test Conditions and Test Scenarios for all TS IDM Wizards as well as Non-Wizards and assisted the testing team in defects identification.

Managed change requests-maintained requirements traceability matrix and published daily status report for management to keep them up to date with project progress.

Maintained the defects on Mercury Quality Center and followed up with developers for open defects before going for Testing to QA. Tested closed defects as they are fixed.

Perform data analysis and testing with the help of SQL statements

Worked on Informatica tool to pull source data from different tables.

Created Mapplets for reusable purpose in informatica workflow.

Created change requests for developers by defining feature and functionality boundaries. Worked closely with technical staff to validate business requirements and expectations. Tested new code implementations to expected results and cross-functionality occurrences. Requesting required Functional IDs access and managing overall harmonization of roles and information access levels across production to all lower environments. Participates with post incident reviews for client impacting incidents

Manage the change requests process on behalf of the Regional Hub to ensure that all system changes have been requested through the proper methods and tracked

Manage the process to ensure that all incident tickets are logged and tracked and followed through to resolution.

Investigate, analyze and make the necessary corrections to solve problems (corrections to the data)

Willingness to investigate the existing code to find the causes and solutions to problems

Participates with post incident reviews for client impacting incidents

Manage the change requests process on behalf of the Regional Hub to ensure that all system changes have been requested through the proper methods and tracked

Manage the process to ensure that all incident tickets are logged and tracked and followed through to resolution

Pfizer, NJ Feb 2014 – Jan 2016

Business Analyst

Pfizer is the global pharmaceutical company. Reporting System (RS) is used to identify spend incurred by

pharmaceutical companies on an individual healthcare professionals and institutions that prescribe, dispense, and/or influence the purchase of pharmaceutical products. RS is used when enhancing the decision making by using potential future monitoring and tracking reports associated with state legislation. The objective is to integrate and automate systems, data and business rules across the enterprise.

Responsibilities:

Capture user requirements by conducting Joint Application Development (JAD) sessions, analyze the existing system and processes.

Actively involved in Story Creation, Backlog and Scrum Events (Sprint Planning, Daily Standup, Retrospective, and Reviews)

Work with Compliance to make sure all confidential information meets Pfizer security standard

Facilitate Process and Story Mapping sessions, developing, and writing user stories that directly support the primary objective of the project and are appropriate size for iterative development

Develop and write user stories that directly support the primary objective of the project and are appropriate size for iterative development

Perform story analysis to determine conditions of satisfaction and to understand the impact to other systems, projects, domains, and operational teams

Compiling data from multiple sources to create integrated views that can be used to drive decision making

Use data to identify problems and solutions that can be presented to management and key business stakeholders

Groom backlog in support of Sprint Planning

Answer questions and Development

Creating FSC (Forward Scheduled Change) and change deployment plan

Creating change records (change management) for each deployment and coordinate deployments for each sprint deliverables.

Perform data analysis and testing with the help of SQL statements

Work on leadership presentations (Demo’s) and release documentation.

Work with TAE’s to identify Test data to handle all Test scenarios and working with QA team to write and execute Test plans and Test Cases, coming up with test scripts, test scenarios and work on UAT (User Acceptance Testing).

Contact this candidate