![]() Experience and knowledge of Apex 3.0, HTML, CSS, and JavaScript.Expertise in Oracle 10g/9i/8i database server, forms 6i/9i and reports 6i/9i, and tools like SQL Plus, SQL Developer, TOAD, Data Loader, SQL * Loader, and RapidSQL.Conceptual understanding of Data marts, OLAP, OLTP, STAR Schema, and Snowflake schema.Knowledge and experience of Data Analysis, Data Warehousing, and ETL Techniques.Generated Excel Reports using oracle supplied package UTL FILE for data analysis purpose.Experience utilizing dynamic SQL (dbms sql, Execute Immediate) functionality.Experience in writing Shell (Korn, Bash, C) and AWK scripts and has utilized crontab functionality.Developed Interactive User Interfaces using Forms 6i/9i and generated reports using Reports 6i.Experience and knowledge of FTP transfer from UNIX to Windows and vice versa.Experience in utilizing oracle analytical and decoding functions and dealing with multi-terabytes database. ![]() Experience in tuning complex SQL statements using Explain plan and SQL trace.Experience in maintaining and developing database objects like tables, views, indexes, sequences, synonyms etc.Experience in quality testing of data-warehouse objects, using a customized scripts based on in-house methodology.Utilized oracle advance features like Bulk Bind (Bulk collect, For all), Ref Cursor, and Index - By Tables. ![]()
0 Comments
Leave a Reply. |