Freelancers
freelancer
Email Verified Revanth K
0.0/5 (0 Feedback)
Member since May 10, 2021

o Software professional with more than 8 years of Technical/Techno-Functional and PL/SQL Developer e...

o Software professional with more than 8 years of Technical/Techno-Functional and PL/SQL Developer experience involving systems analysis, design, development, implementation and testing of large to medium scale business applications / modules using Oracle /UNIX technologies in Client-Server and Internet environments for INHOUSE Projects and Oracle E-Business Suites . o Extensive experience with all phases of the Software Development Life Cycle (SDLC) including analysis, Resource Planning, code development, testing, implementing and maintenance. o Expertise in writing Packages, Stored Procedures, Functions, Triggers using PL/SQL in Oracle to enhance the functionality of the product. o Extensive experience in using PL/SQL, Developer 2000/6i, SQL Loader, Oracle 10g/9i/8i, Unix, Linux, Shell scripts, and developing applications using Oracle Forms, Reports and Pro*C. o Responsible for working with the Functional Team to assist with development or modifying reports, legacy data Conversions, Personalization (Forms/Reports)(RICE objects) in an ORACLE EBS environment. o Experience in converting standard Oracle Reports to more fancier reports using XML Publisher. o Involved in writing PL/SQL libraries for Custom Forms and Reports for INHOUSE projects. o Enforced data integrity using integrity constraint and database triggers. o Extensively used UNIX Shell scripting to interact with Database, executed database scripts and used FTP scripts to deliver the extracted files to target servers etc. o Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, and SQL*Loader. o Proficient in advance features of Oracle 10g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, and Dynamic SQL. o Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace and Explain Plan. o Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques. o Have been an active participant in Quality Circles and Suggestion Schemes and have contributed significantly to improve the quality and time of the deliverables. o Good Knowledge in MS SQL Server suite of products like SSRS, SSIS, and SSAS. o Proficient knowledge in HTML5/CSS3/JavaScript/XML. ERP: Oracle E-Business Suite v 11i ERP Modules: Oracle Financials (AR/AP/GL/Purchasing) Operating Systems: Windows, HP-UNIX, Linux. RDBMS: Oracle7.x/8.x/9i/10g/11g, SQL Server 2012. Interface Tools: Forms 6i/Developer 2000, Apex 3.2, TOAD, and SQL* Loader. Languages: SQL, PL/SQL, Pro*C, Pro*COBOL. Reporting Tools: Reports 6i/Oracle BI Publisher (XML Publisher)

0

Ongoing projects

0

Completed projects

0

Cancelled projects

0

Ongoing services

0

Completed services

0

Cancelled services

$0.00

Total earnings

* Click the button to send an offer

Send offer