| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSuvarna Ravuri Phone: PHONE NUMBER AVAILABLESr Business Analyst/Team lead E-mail:EMAIL AVAILABLEJob Related Summary:I am a resource with more than 8 years experience in the health Insurance domain within the Software and Technology services industry. Through my tenure, I wore multiple hats that of a business analyst, subject matter expert and product owner. I have been primarily associated with development and implementation for products and building data warehousing and reporting for policy, claim. I have understood and worked on billing, client, and interfaces between multiple systems. I have a good understanding of relational database structure and extract transform and load process (ETL process) as well.I have worked on all phases of the SDLC in both the waterfall and agile methodology projects and have rich experience in the software implementation area. My experience has equipped me with knowledge on business processes, business analysis, planning and requirement analysis, business Intelligence,planning and documentation of user stories and product backlog, agile methodology best practices andquality initiatives.My communication and presentation skills make me a strong candidate for roles that need people management abilities.My professional goal is to pursue a career that gives me the opportunity to grow, learn and evolve as asuccessful professional in the IT services and insurance industries as well as add value to my organization at large.Technical Skills:Data WarehousingAb 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 SystemsWindows (XP, 7), Linux (Red Hat, Fedora), UNIX (Sun Solaris, AIX, HP-UX)Data ModelingPhysical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake Schema, Fact Table, Dimension Table), ERWIN 4.0/3.5DatabasesOracle11g/10g, SQL Server 2000/2005/2008, IBM DB2 8.1, OLTP, Teradata 13, SnowflakeProgrammingSQL, PL/SQL, SQL*Loader, UNIX,Query ToolsSQL Developer, TOAD, SQL*Plus, Teradata SQL AssistantReporting ToolsTableau, Business Objects XIBusiness ToolsMS Office (Word, Excel), Test director, AutoSys, MS VisioEducation:Bachelor of engineering (BE) focus on Electronics and Communications.Certified in Tableau from CollabraProfessional Experience:Project : State of North Carolina, Accenture.Project Duration : Feb 2024- PresentAssigned Role : Deployment LeadNorth Carolina's Medicaid transformation, also known as NC Medicaid Managed Care, is a change to how most people receive Medicaid services. The program began on July 1, 2021, and involves changes.Transition from fee-for-service to managed care: The state transitioned from the fee-for-service model, where the state reimbursed providers based on the number of services provided, to a managed care model, where the state contracts with insurance companies to provide care. Two types of health plansThere are two types of health plans: Standard Plans and Tailored Plans. Standard Plans include most Medicaid enrollees, including those with mild to moderate behavioral health needs. Tailored Plans include behavioral health, intellectual/developmental disabilities, and traumatic brain injuries.Role and Responsibilities:Working as deployment lead in the Medicaid transformation team.Planning the roll-out process and the sequence of new systems and platforms.Communicate with business stakeholders and individual contributors to understand when all the plans planned for release and communicate with vendors/ downstream users regarding the data and responsible for engaging right team in time.Created Jira reports for GDIT vendors every week for requirements traceability and communicate with business units on every week report with utilization of Python script.With utilization of service now creating NCTRACKS reports for all open issues and get in touch with business unit to bring issues to their attentionResponsible for plans and providers to plan their releases before any process sunsets.Conduct sessions with each business unit to finalize approach and review the contractual things and prepare documentation for the departmentConduct Strategic technical operations meeting as when any program lunches or upgrades to any existing models/methods including reviewing new contract by board members.Create end user documentation for all process that we do on day-to-day basis to help team members and review methods in place.Create reports to determine the day-to-day work from JIRA for all Standard and tailored plans and populate results in the dashboard for leadership exposure.Experience in developing a crosswalk or matrix of data classification documents to meet state and security Rules.Experience creating, reviewing, and/or refining system data dictionaries with stakeholders.Experience with data asset classification of federally regulated stated and NC state-owned and controlled data, to include retention schedules.Experience developing and implementing standard operating procedures (SOPs) about information privacy and security.Experience manually creating data dictionaries in Excel to record data owner, data table names, system business names, retention schedules, aligned privacy policies and notices, etc.Project : Blue Cross Blue Shield of North Carolina, Accenture.Project Duration : Apr, 2017 - Jan 2018 and May 2018 -Feb 2024.Assigned Role : Senior Business Analyst and Team Lead.BCBSNC Major US Health Care provider has claims data source 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.Project 1: The Affordable Care Act (ACA) is the name for the comprehensive health care reform law (passed in 2010) and its amendments. The law addresses health insurance coverage, health care costs, and preventive care.Project 2: Senior Market Migration/ UDABlue Cross and Blue Shield of North Carolina (Blue Cross NC) will begin transitioning BlueCard Medicare Advantage claims processing from the Power MHS/Amisys system to the Facets system.Two years of historical claims will be migrated from Power MHS/Amisys to Facets system to process any incoming adjustments Claims will begin issuing a revised formatted Explanation of Payments (EOP) from the Facets system. Providers will not be asked to do anything for this migration.Role and Responsibilities:I am working as the senior business analyst and team lead in the Information/Data Delivery (ID/DDE) team in Blue Cross Blue Shield of North Carolina (BCBSNC). The ID/DDE team is responsible for Delivering Information technology solutions to support the healthcare business needs and business transformation plans of BCBSNC.As part of this team, I support the ETL processes that bring data into the enterprise data warehouse and data store as well as support reporting and analytics. I am currently involved in multiple healthcare data migration projects that are actively being pursued by the organization.My primary responsibilities are to plan, analyze and scope the work related to the team in the discovery and solution scoping phases of the project. I also support the solution design and delivery phases as a team lead and project coordination/management POC for offshore resources, business stakeholders and enterprise project management office.Work on requirements gathering, requirements analysis for healthcare data migration projects.Communicate with business stakeholders to understand business requirements and translate them into functional requirements.Work on NC HealthConnex portal for Patient records and managed audit upon need basis.Interact with solution architecture, PMO, business SMEs and other stakeholders to consolidate requirements and scope of project.Document the requirements and scope as part of initial assessment and functional requirement specification documents.Analyze and map data based on functional documentation and database understanding.Communicate, coordinate and mange expectations of project stakeholders, business and offshore development and testing teams.Support the planning, scoping, and estimation of deliverables.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, define scope and objectives, and formulates systems to parallel overall business strategies.Involved in developing workflows and Data flows diagrams.Developing clear technical user stories/documents that accurately depict data process flows and interfaces.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.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 tunes 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 Ab Initio XFRs to derive new fields and solves rigorous business requirements.High level Design DW/BI Development, Support and Operations methodology.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.Responsible for system migration from Teradata to SnowflakeProject : CIGNA, Raleigh, NC. Wipro/Sage ITProject Duration : Jan 2018 May 2018.Assigned Role : Production support lead.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 SMEs and Salespeople and created requirements documents.Prepared BUC (Business Use Cases) for proper building up documentation for the different sub systemsCreated 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.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.Project : Pfizer, NJProject Duration : Sep 2014 Dec2016Assigned Role : Informatica ETL DeveloperPfizer is the global pharmaceutical company. Financial 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:Involved in collecting requirements, analyzing data, design, and development of Data warehouse.Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.Designed Informatica mappings by translating the business requirements.Involved in creation of technical specification document (Source to Target) for the project by conducting technical meetings.Extensively worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer to Extract Sources, Transform Data and Load into Target.Created and Modified Autosys jobs to automate the ETL process along with Pre ETL and Post ETL routines.Involved in analyzing and writing complex procedures and queries to extract data from SQL Server.Worked on Transformations like Connected and Un-Connected Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure and Sequence Generator, Sorter, Normalizer.Tuned performance of Informatica sessions for large Data Files by increasing block size, data cache size, sequence buffer length and target-based commit interval.Performed Exception Handling in Informatica and loaded Invalid data to Error log tables with proper error message details.Improving the session performance by making enhancements to the existing Mappings /Sessions / Database tables.Wrote UNIX shell scripts to validate source files for expected Record counts and expected Business Dates.Created and monitored sessions using Informatica Server and Workflow monitor.Used debuggers to detect bugs in mappings with development data.Involved in unit testing of the mapping and mapplets.Provide production support as needed.Environment: Informatica Power Center 9.5, Oracle 11g, SQL Server 2008, Windows 7, SQL Developer, SQL, PL/SQL, Erwin 4.0, Autosys.Project : Credit Suisse, NJProject Duration: Jan 2013 Aug 2014Assigned Role : Informatica ETL DeveloperThe objective of this project was to create a Consolidate Reporting Project. Build a data mart for the Retail Customer Service department. The data is from the call center coming from different Cisco modules like ICM, IVR and IEX etc. These tools populate data in the database, which is pulled to design the data mart.Responsibilities:Involved in all phases of SDLC from requirement, design, development, testing, production, and support for production environment.Extensively Designed, Developed, tested complex Informatica mappings, mapplets and Reusable Transformations to load data from various sources.Extensively Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.Involved in Requirement gathering and documenting the ETL process for Mapping documents.Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings etc.Created workflow design document, mapping design document, Integration test plan document, Unit test plan document etc.Extensively experience in loading the data from multiple sources like flat files, other RDBMS databases.Worked with Autosys job scheduling to schedule Informatica Workflows.Experience in working with Autosys job states like ON_ICE, ON_HOLD/OFF_HOLD and force start the box in DEV environment for Integration testing.Involved in running the loads to the data warehouse and data mart involving different environments.Used the update strategy to effectively migrate data from source to target.Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.Created, Configured and Scheduled the Sessions and Batches for different mappings using workflow Manager and UNIX Scripts.Integrated various sources into the Staging area in Data warehouse.Created the Source and Target Definitions in Informatica Power Center Designer.Developed shell scripts to automate the data loading process and to cleanse the flat file inputs.Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.Provided production support as needed and resolved Production issues.Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL, SQL, TOAD, ERWIN 3.5, UNIX Shell Scripting, Autosys, Business Objects XI. |
