Venkata Deepak B

OPA (Optum Performance Analytics)

OPA is a tool that clients use to check the processed, Valid data in a organized manner within a user interface environment which it contains the patients details, about the their clinical data, Claims data.

• Loading of the raw data into the Production Server that is received from the Client
• Responsible in checking the Data Loaded into the Production Server using DVP Tool, which shows the Data Loaded in a graph, if any issues are found analyze the Data and check which table has data issue note down the analysis and reach out to the client regarding the Data Issues, for further confirmation.
• Identified trends and patterns in large datasets, leading to actionable insights for business growth.
• Responsible in monitoring the Production server when the data is loaded and if any issue occurred in the Loading, Fixing the Issue accordingly with an Immediate Action to process the Load.
• Responsible in Working on the Incidents that are created when any issues are occurred in the Production Server after the data is loaded
• Initiating the Builds for the Data Loaded and Process the Data into the OPA Tool for the Clients to View the Loaded Raw Data as Processed Data
• Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
• Queried databases like Oracle, Athena for information needed for report processing.
• Recommended process improvements to continually identify, analyze and fix constraints and challenges.
• Increased efficiency by streamlining data analysis processes and implementing automation tools for extracting the raw data.

EDA (Enterprise Data Acquisition)

EDA is a process where this part does the work of pulling out the information of a patient like Clinical data, claims data and other information of the patient's visit to the hospital every time in the CDR.

• Responsible in writing the ETL ’s for validating the data,
• Cleansing the Data, correcting the inconsistencies and missing data before it Is moved to the Production Server
• Removing the duplicated and redundant data
• Responsible in writing Joins against the Developers Code and check if any issues are found in the Data and if any found reporting it for correction Validating the FE and BE data against the Legacy, EDA and RAW Data once all the values are matching then the Data Would be sent to the Implementation team for Moving into the Production Servers.
• Responsible in running the validation checks for all the tables Related to the CDRFE and CDRBE and work with the dev team for any mismatch of data found during the checks.
• Enhanced team collaboration by providing clear communication of complex findings through visualizations and reports.
• Identified and resolved problems through root cause analysis and research.
• Queried databases like Oracle, Athena, Mango DB for information needed for report processing

Project includes development to streamline study workflows with their CROs by defining data models, folders and terminology prior to study start, and can receive data for interim analysis until study is completed

• Responsible in providing solution or fixes for existing production bugs Responsible in Enhancing existing code
• Responsible for promoting code to Production environment
• Responsible in writing Procedures, Triggers, views and code blocks for improving stability of product.
• This includes production fixes and enhancements Involved in all phases of SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines
• Performing Unit testing before handing off data to prod server
• Delivered unit-tested systems within customer-prescribed timeframes.
• Responsible in working with team on product development and application support plans.
• Worked with preparing dumps for loading database in test environments and for prod environments.
• Promoted experience with Amazon Web Services, sqldeveolper, Putty.
• Corrected, modified and upgraded software to improve performance.

Worked as executive for Samsung for on call support assistant for all their electronics goods.

• Responsible in providing resolution to customer on call and if it is not resolved assigning technical person to customer place.
• Used SAP tool for raising tickets for customers, and provide them service ticket number.
• Reduced customer complaints with proactive issue identification and resolution strategies.
• Implemented feedback-driven improvements for enhanced overall customer experience.
• Managed high volume of inbound calls, multitasking effectively to address diverse customer needs simultaneously.
• Managing Call flow in time time of early start of day and assigning executives with calls based on flow
• Kept accurate records of all customer interactions and transactions.