Prasanth Venkatesulu
Summary
Highly skilled and results-driven Technical Solution Analyst with 5 years of experience in providing L2 Application/Production support across a range of platforms. Exceptional troubleshooting abilities and a proven track record of resolving complex application issues, ensuring smooth operations in fast-paced, high-pressure environments. Proficient in analyzing, diagnosing, and rectifying application errors, collaborating with cross-functional teams, and improving application performance. Strong knowledge of SQL, system integrations, and various monitoring tools. Excellent communication and interpersonal skills, consistently delivering high-quality user support and improving customer satisfaction. Passionate about leveraging technology to streamline business processes and enhance operational efficiency.
Overview
5
5
years of professional experience
Work History
Technical Solution Analyst II
Oracle Cerner
05.2023 - Current
- Analyzing and troubleshoot the issues raised by the clients related to the product (Millennium) and customize the product as per the client's requirements
- Writing SQL queries and rules using CCL (Cerner Command Language)
- Working on ticketing tools (Supportal, Remedy) for managing incidents and service requests
- Capturing log files, querying tables and updating database fields
- Generating various audit report using discern visual developer based on client's requirement
- Identifying the root cause and fixing the issues on both front-end and back-end applications within the SLA
- Monitoring the OPS jobs, servers and services to ensure the stability
- Perform root cause failure analysis using log files and reports
- Utilizing troubleshooting tools, shadowing end users and testing the workflow to resolve the issue effectively
- Develop and maintain detailed technical documentation for issue resolution and system configurations
Programmer Analyst
Cognizant
11.2019 - 04.2023
- Troubleshooting the issue related to CMS (Claim Management System)
- Investigating and fixing the production related issue with SLA
- Working on ticketing tool ASM (Alemba Service Manager) for managing incidents and service requests
- Perform random checks on incidents and services request to ensure that quality is maintained
- Ensuring tickets are escalated as per the guidelines provided by the client
- Running and checking the SQL queries will be the key component of ongoing production support
- Wrote database scripts & SQL stored procedure and functions
- Generating various reports using SQL queries
- Debugging ASP.NET codes on visual studio for technical issue
- Monitoring progress on change plan
- Handling technical and resource escalations, working on the quality parameters which include proper documentation and implementation plan
- Proving live support to PROD environment to the client
- Follow up on incident records that do not meet quality standards to prevent recurrence
- Work on weekly and monthly email report for multiple accounts
- Will be part of sprint release to perform various pre & post deployment activities
- Generating various claims and policy related reports as per the client request
Education
Bachelor's degree - BCA
Vijayam Science & Arts Degree College
04-2019
Intermediate - MPC
Narayana Junior College
04-2016
Higher Secondary - SSLC
Holy Cross Metric School
03-2014
Skills
- SQL
- Cerner Command Language (CCL)
- Microsoft SQL Server
- MySQL
- ITIL Framework
- SDLC
- Agile & Scrum Methodology
- Incident Handling
- Root Cause Analysis
- Customer Interaction
- Issue Documentation & Reporting
- SLA Management
Timeline
Technical Solution Analyst II
Oracle Cerner
05.2023 - Current
Programmer Analyst
Cognizant
11.2019 - 04.2023
Bachelor's degree - BCA
Vijayam Science & Arts Degree College
Intermediate - MPC
Narayana Junior College
Higher Secondary - SSLC
Holy Cross Metric School
Similar Profiles
Sudhakara Shankara ShettaraSudhakara Shankara Shettara
Senior Scrum Master/Agile Coach/RTE (SAFe) at Cerner Corporation (Oracle-Cerner)Senior Scrum Master/Agile Coach/RTE (SAFe) at Cerner Corporation (Oracle-Cerner)
Vivek KulkarniVivek Kulkarni
Partnership Analyst I at Oracle Cerner(Previously known as Cerner Healthcare Solutions)Partnership Analyst I at Oracle Cerner(Previously known as Cerner Healthcare Solutions)
Praveen ThadigiriPraveen Thadigiri
Manager, Client Support – IRC Event & Incident Management at Oracle Cerner Healthcare India Pvt. Ltd.Manager, Client Support – IRC Event & Incident Management at Oracle Cerner Healthcare India Pvt. Ltd.
Nishit RanjanNishit Ranjan
Software Engineer - III at Oracle Cerner Healthcare Solutions Private LimitedSoftware Engineer - III at Oracle Cerner Healthcare Solutions Private Limited
NAMISHA NAMISHA null
Technical Solution Analyst II at Oracle CernerTechnical Solution Analyst II at Oracle Cerner