JYOTHI KIRAN G R

SQL/PLSQL Consultant with 5 plus years of work experience, who have a diverse skill set that includes proficiency in writing complex SQL queries, specialized in writing efficient and scalable code to meet business requirements. With a strong background in database management and skilled in developing robust complex queries, views, triggers, stored procedures and packages by troubleshooting database issues to ensure smooth and reliable database operations. Dedicated to deliver high-quality solutions that align with organizational goals and drive business success.

• Recognition award for actively working and delivering resolutions as per Business.
• Client appreciations with rewards for proactively delivering resolutions.
• Cleared basic and Advanced Amdocs OMS, UNIX and SQL certifications.

Client: UCB
Domain: Pharmacy
Date:12/2022 - 04/2024

• Involved in end to end development of UCB Rare Disease Drug insights including Data Aggregation from different SP's and hubs ,Data cleansing, Quality Checks and moving it to Operational Databases and sending back the outbound files to clients.
• Responsible for handling both developmental and operational activities as per business.
• Application development with all stages of SDLC:Design, Analysis, coding and unit Testing.
• Created new procedures, sequences, triggers,views and modified existing codes, tables, views as per business requirements.
• Performed functional and regression testing to ensure updates or code changes were moved to production without causing any new defects in
  existing functionality.
• Involved in Dynamic Data Load (DDL) Process to move the data from a source table/view to target Table using the Pl/Sql Process using the configuration tables.
• Good knowledge on merge statements and Tables which are created as part of the Data Movement Process between the Layers.
• Involved in performing standardization to cleanse data as per business by using various Database objects.
• Good knowledge of using tools like Sql Developer, WinScp, Putty, Jira and spreadsheets.
• Involved in enhancements and modifications of API views and packages as per business logic.

Client:US CELLULAR
Domain: Telecommunication
Date: 11/2018 - 12/2022

• Responsible for creating sql queries for running MASS ORDER EXCEUTION as per client's requirements.
• Responsible for analyzing,troubleshooting and identifying the production issue and it's root cause by doing data and log analysis.
• Good Knowledge on PLSQL concepts like Stored procedures, functions, cursors, triggers and exception handling and also involved troubleshooting of automation scripts.
• Basic knowledge on RPA Robotic Process automation to process file in bulk.
• Basic Knowledge on TALEND and Informatica ETL Tool
• Good knowledge on Various Amdocs Applications like CRM for customer related information details, SRM for number allocation based on particular location, Amdocs Process Manager (APM) for handling orders in bulk Amdocs Billing for handling customer's billing.
• Responsible for resolving highly escalated tickets over bridge and providing immediate resolutions.

Client:Customer Experience 360
Domain:Airline
Date:01/2018 - 07/2018

• Responsible for creation of DDL's as per Client's requirement.
• Responsible for creating SQL Joins,sub queries and nested queries as per business requirements.
• Creation of one to one Mappings and workflows to fix the data quality issues.