GOPALA KRISHNA G
(ORACLE SOFTWARE ENGINEER)
Career Summary
Experienced PLSQL developer in Apex and OBIEE environment. B-Tech in Instrumentation with demonstrated history of working in Service based company, handling multiple projects, both initial development and production issues.
Educational Background
Degree
School/College
Board/University
Year
CGPA/%
Bachelor of Engineering
Sir C.R. Reddy college of Engineering
Andhra University
2014
7.43
Diploma
A.A.N.M & V.V.R.S.R Polytechnic
State Board of Secondary Education
2011
79.9
Project Details
Project Title : PAC CCC Integration
Environment : Apex 5.0 and UNIX.
Role : Oracle Apex Developer.
Duration : June-2014 - Feb-2017.
Organization : Rempar Solutions Private Limited
Description : We get Quote and PO request from customers which we accept and process the request using Java code and send the response back. On Apex we developed application which displays Quote and PO transactions happened. As per user requirement we have provided different options like modal page, hyperlinks on text, image, download option for PO transactions which downloads the open PO’s and updates a column in backend using dynamic action and Ajax call, Custom Tabs to navigate easily between different transaction reports, Style Cards on home page to display count of transactions current day and many more.
Project Title : Power Design Incorporated PDI
Environment : Oracle Apex, OBIEE
Role : Oracle APEX/OBIEE Developer
Duration : June-2014 - Feb-2017
Organization : Rempar Solutions Private Limited
Description : Worked on developing payment process Apex application which involves lot of validations, computations, Ajax Calls, Interactive reports, Forms etc and worked on upgrading all Apex applications from 4.2 UI versions to 5.0 UI. Worked on creating OBIEE analysis Reports, Data model, Bursting reports, Dash board prompt, BI Publisher reports as per client requirements.
Project Title : Service IQ
Environment : Oracle Apex
Role : Team lead/Oracle APEX Developer
Duration : Feb-2017 - Feb-2019
Organization : NITS Solutions India Private Limited
Description : IQ Analytical Portal to Display reports based on different KPI’s for each Dealer. Reports include gauge charts, fusion charts, forms etc. As a Technical lead I am handling the initial Apex part and Production issues
Project Title : DIA
Environment : Oracle Apex
Role : Team lead/Oracle APEX Developer
Duration : Feb-2017- Feb-2019
Organization : NITS Solutions India Private Limited
Description : Developing reports and Dashboards to show accessories installed at dealer level so that dealer can assess their performance compare to accessories installed at port level. Reports include bar charts, multiple navigation, gauge charts.
Project Title : JOSS
Environment : Oracle Apex
Role : I.T Analyst
Duration : Feb-2019 - Till Date
Organization : Jade Global Software Pvt Ltd
Description : Maintaining Time Sheets and Performance analysis of employees in jade Global .
Technical Skills
RDBMS : Oracle 11g
Environment : APEX 5.0, 5.1, ORDS2.0.10, glassfish 4.1 on OEL, OBIEE 11.1.1.7.
Languages : SQL, PL/SQL, HTML, CSS,REST API,EBS,Workflow
Tools : Toad, SQL developer, Data modeler, BI Publisher Desktop Tool.
Apex Role:
•Experience in developing applications using Oracle Application Express 5.0 & 5.1.
•Pages, regions, items, lists, tabs, lov’s, dynamic actions, shared components and other applications items.
•Experience in building reports - classic reports, interactive reports, ability to generate reports using dynamic PL/SQL queries and also anonymous PL/SQL block to match application level templates.
•Having good knowledge on upgrading the apex applications UI from 4.2 to 5.0.
•Experience in Forms, Tabular Forms, and Editable classic and Interactive reports.
•Experience in creating templates, implementing authentication and authorizations as per the security rules defined.
•Creative in designing UI.
•Worked on Refresh Programs and Creation of Jobs (DBMS Schedulers) for Apex.
•Having Knowledge on migrate the code from one instance to another.
OBIEE Role:
•Good Experience on OBIEE (BI Answers, BI Publisher, BI Scheduler)
•Strong Experience in Creating OBIEE Analysis Reports using RPD and Direct Data Base Request.
•Experience in creating Data Model, Reports using BI Publisher which integrated with OBIEE.
•Strong Experience on Bursting and Agents.
•Experienced in Designing customized, interactive dashboards in OBIEE using actionable navigation, Dashboard Prompts, filters, Narrative view, and Variables.
•Experience in Creating RTF and Excel Template using BI Desktop plug-in