JYOTHI KIRAN G R
Plsql Consultant
Surrey,British columbia
Summary
As an experienced Software Developer with over 5 years of expertise in designing, unit testing, and maintaining software systems, I bring a diverse and promising skill set to the table. I have proven proficiency across various platforms and languages and have collaborated effectively as part of productive teams. My skills are particularly strong in Oracle SQL/PLSQL, Unix, Amdocs Order Management System (OMS), Enterprise Product Catalog (EPC), CRM, and Amdocs Billing. My hands-on experience and deep understanding of these technologies enable me to deliver high-quality software solutions that meet business requirements effectively.
Overview
6
6
years of professional experience
Work History
ORACLE PLSQL DEVELOPER
Capgemini
12.2022 - Current
SOFTWARE SUPPORT ENGINEER
Amdocs Pune
11.2018 - 12.2022
Intern
ITC Infotech
01.2018 - 07.2018
Education
Bachelors (BE) - Computer Science
Bapuji Institute of Engineering & Technology
Class XII - undefined
STJ PU College
Skills
Oracle SQLundefined
Accomplishments
- Recognition award for actively working and delivering resolutions as per Business.
- Client appreciations with rewards for proactively delivering resolutions.
- Proactively taken part in organizing team events
- Beyond the call of Duty: For supporting additional hours during the release.
- Cleared basic and Advanced OMS, UNIX and SQL certifications.
- Creating Mapplets and using in multiple mappings as per the business requirement.
Projects
UCB, Pharmacy, 12/2022 - Present, Part of Quearo360 platform which is an aggregation and analytics platform for Life sciences clients mainly involved in re-usable solution for Drug Launch performance and Sales Analytics for Specialty pharmaceuticals drugs, Involved in end to end development of UCB Rare Disease Drug Data Aggregation from different SP's and hubs and 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., Developed both inbound and outbound interfaces to load data into targeted operational Databases and extract data from database to flat files., 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 handling UCB reports like File Delivery Report, Score Card Report., Debugged various defects related to implementation of business logic., 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., Performed Quality checks as per provided DIA document., Involved in loading data from ODS tables to DWE tables., Involved in enhancements and modifications of API views and packages as per business logic. US CELLULAR, Telecommunication, 11/2018 - 12/2022, Responsible for handling various tickets which were opened by CSR's within the parameters of contractual service Level Agreements (SLAs). These tickets were related to orders getting stuck and providing resolution for the same. Ordering happens through Order Management System (OMS) wherein every request generated by the customer creates an order which flows through OMS., Responsible for creating sql quants for running MASS ORDER EXCEUTION as per client's requirements., Responsible for analyzing production issues from business and application code., Responsible for troubleshooting and identifying the production issue and it's root cause by doing data and log analysis., Involved in creating and troubleshooting of promo and sales reports from QlikView., Involved in handling complex incidents and client's escalations., 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 ETL Tool and also responsible for trouble shooting of production issues., 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., Good knowledge on ticketing tools like UTS Remedy tool and BMC Remedy. Customer Experience 360, Airline, 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., Responsible for creation of basic quantifications as per business needs., Responsible for creating powerpoint presentation as per requirement., Creation of one to one Mappings and workflows to fix the data quality issues.
Timeline
ORACLE PLSQL DEVELOPER
Capgemini
12.2022 - Current
SOFTWARE SUPPORT ENGINEER
Amdocs Pune
11.2018 - 12.2022
Intern
ITC Infotech
01.2018 - 07.2018
Bachelors (BE) - Computer Science
Bapuji Institute of Engineering & Technology
Class XII - undefined
STJ PU College
Similar Profiles
Mohammed Rabic RiyazudeenMohammed Rabic Riyazudeen
Senior Applications Consultant at CapgeminiSenior Applications Consultant at Capgemini
V S S R K RAJU KATARIV S S R K RAJU KATARI
Senior Analyst at CapgeminiSenior Analyst at Capgemini
Thierry MaurelThierry Maurel
Engagement Manager at CAPGEMINIEngagement Manager at CAPGEMINI
Priyanka SutarPriyanka Sutar
SAP Analyst at CapgeminiSAP Analyst at Capgemini
James ShawJames Shaw
TMC Agent at Ministry of Transportation and TransitTMC Agent at Ministry of Transportation and Transit