Resume

Sign in

Oracle Pl/sql,APEX developer

Location:
Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia
Posted:
January 18, 2019

Contact this candidate

Resume:

Venkatesan Rajarajan

+60-14-369****

ac78ih@r.postjobfree.com

SUMMARY

14+ Years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (Sql, PL/SQL).

Expertise in Client-Server application development using Oracle 12c/11g/10g/9i, PL/SQL, SQL *PLUS, SQL Developer, SQL*LOADER, APEX 4.0/4.2/5.0, Forms 6i and Reports 6i.

Solid experience in translating business requirements into creation of Database Objects.

Proficient in writing Complex SQL Queries, Normalization, Database Design, creating Indexes, Triggers, Sub Queries, Joins, Procedures, Cursors, Functions, Packages, Experience in Oracle supplied packages such as DBMS_SQL, DBMS_JOB/DBMS_SCHEDULER, UTL_FILE., Dynamic SQL, Records and PL/SQL Tables, Exceptions. Worked extensively on Ref Cursor, External Tables and Collections. Experience in advanced PL/SQL concepts like Bulk collect and for all.

Loaded Data into Oracle Tables using SQL Loader.

Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, Hints and Indexes.

Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as BIRT.

Created Shell Scripts for invoking SQL.

Experience with APEX Administration, APEX Development and Web services Experience with JavaScript Validation used for APEX Design.

Experience with JQuery used for APEX Functionality. Experience with HTML, CSS used for APEX.

Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.

Involved in Oracle DBA Activities like Export, Import Dump Files, Table space Creation, User creation, Data pump, Assigning Roles, Oracle installation, Monitor Server Performance and Tuning.

Significant experience working with clients, technical teams for executing concurrent multi-technology projects.

Possess excellent oral / written communication and interpersonal skills.

Good ability to quickly grasp and master new concepts and technologies.

Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.

Significant experience in 24/7 Production Environment Support.

TECHNICAL SKILLS

Operating System : Windows, UNIX, Linux.

Databases Environments : Oracle 9i, 10g, 11g, 12c, MySQL 5.1, Informix 11x.

Reporting Tools : Actuate BIRT, Birtihub.

Front End : APEX 4.0/4.2/5.x.

Other tools : Forms 6i, Reports 6i, JavaScript, JQuery, Ajax,

Knowledge in Joomla.

EDUCATIONAL QUALIFICATION

Master in Computer Application.

PROFESSIONAL SUMMARY:

Inoapps sdn bhd from Nov 14 2016 to till date.

DHL IT Services Cyberjaya from Jan 6 2015 October 2016.

Star Solutions (M) Sdn bhd from Feb 16 2011 to Dec 2014.

Orient Information Technology from July 15 2007 to Aug 2010.

Intellisys Technologies Chennai from March 2004 to March 2007

Inoapps sdn bhd from Nov 14 2016 to till date.

Oracle pl/sql developer

Description:

Responsibilities:

Creating Web services using pl/sql and APEX 5.x.

Involved in the maintenance and enhancement of the application.

Creating table spaces, tables, views, scripts for automatic operations of the database activities.

Coded various stored procedures, packages and triggers to incorporate business logic into

the application.

Used the technical document to design the database tables.

Gather Database and User Level Statistics and Analyze Overall System Performance.

Designed/developed tables, views, various SQL queries, stored procedures, functions.

Monitor database and system backups, developed Oracle Stored procedures, functions,

packages, and triggers that pull data for reports.

Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.

Used DBMS_JOB/DBMS_SCHEDULER to automate the PL/SQL procedures and packages.

Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

Involved in Unit Testing Stored Procedures and Functions.

Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Tuned complex Stored Procedures for faster execution and Developed database structures, per the requirements.

Created various SQL and PL/SQL scripts for verification of the required functionalities.

Developed complex SQL queries for data retrieval from various database objects including tables and views.

Worked on various backend Procedures and Functions using PL/SQL.

Contributed with database designs and assisted in increasing response time for APEX

reports.

Environment: APEX 5.x, Oracle SQL, PL/SQL, SQL*Loader, SQL Developer, Oracle Fusion, Web services

DHL IT Service, Cyberjaya, Malaysia, from Jan 6 2015 to October 2016

Senior System Analyst (Oracle PL/SQL)

Description: OCNT (Operations Containerization) is a Containerization application for Logistics. Containerization has been designed to give accurate status on the whereabouts of the shipment.

Responsibilities:

Responsible for purging and archiving the production databases.

Responsible in developing UNIX shell scripts to administer the system.

Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.

Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

Involved in Unit Testing Stored Procedures and Functions.

Developed complex SQL queries for data retrieval from various database objects including tables and views.

Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.

Supported QA activities, test plans and performance enhancement techniques.

Environment: Oracle SQL, PL/SQL, SQL*Loader, SQL Developer, web logic.

Star Solutions (M) Sdn Bhd, Bangsar South, Malaysia Feb 2011 – December 2014

Senior Oracle PL/SQL Developer

Description: STARDriver a CRM Application Consists of the modules Data Import, Data Loading, Validation and Deduplication, Targeting Filters, Campaign Planning Campaign Approval Engine, SMS Activity Execution,E-mail Activity Execution,USSD Activity Execution, Telemarketing Activity Execution, Direct Mail Activity Execution, Event Activity Execution, Upload Responses, Campaign Dashboard, Admin Console.

Responsibilities:

Installation, Creation and support of Oracle 10g/11g database environments.

Involved in the maintenance and enhancement of the application.

Maintaining Logical and Physical structure of the database.

Creating table spaces, tables, views, scripts for automatic operations of the database activities.

Coded various stored procedures, packages and triggers to incorporate business logic into the application.

Used the technical document to design the database tables.

Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping

Created control files for SQL*Loader.

Gather Database and User Level Statistics and Analyze Overall System Performance.

Designed/developed tables, views, various SQL queries, stored procedures, functions.

Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.

Develop UNIX shell scripts to administer the system.

Extensively worked with Dynamic SQL, Composite data types & Global Temporary Tables.

Responsible for purging and archiving the production databases.

Used DBMS_JOB/DBMS_SCHEDULER to automate the PL/SQL procedures and packages.

Involved in Interacting with users, error fixing by enhancing PL/SQL packages, stored procedures & functions.

Data conversion from flat file to intermediate tables using SQL*Loader and also created control files for SQL*Loader.

Communicate issues and progress to project manager.

Performed logical backup using export and import utilities.

Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

Involved in Unit Testing Stored Procedures and Functions.

Created SQL*Loader scripts to load data into the temporary staging tables.

Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.

Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.

Created various SQL and PL/SQL scripts for verification of the required functionalities.

Developed complex SQL queries for data retrieval from various database objects including tables and views.

Worked on various backend Procedures and Functions using PL/SQL.

Formulated SQL queries, functions and processes as per customization requirement for APEX.

Supported APEX applications and conducted performance tuning for PLSQL.

Contributed with database designs and assisted in increasing response time for APEX reports.

Designed application framework and developed Oracle APEX Application.

Provided APEX guidance and support to technical staff on application maintenance and SDLC process.

Used Oracle APEX 4.0/4.2/5 for designing application structure.

Formulated oracle process, data retrieval methods and SQL code blocks.

Designed and evaluated applications, and provided architectural input apps.

Coded, tested and troubleshot software applications.

Conducted unit testing and maintained data extractions and object models.

Supported QA activities, test plans and performance enhancement techniques.

Environment: Oracle SQL, PL/SQL, APEX 4.2/5, SQL*Loader, SQL Developer, BIRT Report.

Orient information, Dubai, UAE July 2007 August 2010

System Analyst (Oracle PL/SQL)

Description:

Load data from Bancs, Postilion Database to Oracle database, Cleansing, Transformation and loading into various applications (Oracle CRM, Oracle Applications etc.).

Responsibilities:

Developed stored procedures to extract the data from different sources and load it into Oracle Database.

Created data mapping files for the data coming from different web services.

Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.

Developed procedures using Dynamic SQL.

Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

Worked with Development team and architect to build data model for staging area.

Importing and exporting the data into multiple environments.

Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.

Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.

Involved in handling the changes in compiling scripts according to the database changes.

Developed reports using complex queries as per client request as a part of production support.

Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.

Created SQL*Loader scripts to load data into temporary staging tables.

Utilized SQL*Loader to load flat files into database tables.

Environment: Oracle SQL, PL/SQL, SQL*Loader, SQL Developer.

Intellisys technologies, Chennai, India March 2004 July 2006

Senior System Analyst (Oracle PL/SQL)

Description: Flexcube is one of the leading banking software in the world, involved in

Loan Deposit, Loan syndication, Currency Conversion, Holiday Currency, Letter of credit and

General ledger Modules.

Responsibilities:

Expertise in developing forms using Oracle Forms 6i/9i.

Expertise in developing forms using Oracle Reports 6i/9i

Expertise in deploying reports on Reports Server and troubleshooting Reports Server.

Experience in Report Security issues.

Experience in Leading a Team for development of reports and Backend Development.

Proven skills in SQL tuning and enhancing application performances.

Proficient in server side programming like Procedures, Functions, Database Triggers, Packages using PL/SQL and SQL.

Worked extensively with SQL Loader using control files for data ware housing and data loading into oracle database tables.

Environment: Oracle SQL, PL/SQL, Forms 6i/9i, Reports 6i/9i, SQL*Loader, SQL Developer.



Contact this candidate