Sign in

Developer Oracle

Fremont, CA
March 11, 2019

Contact this candidate


Pallavi Manikandan Mobile: 510-***-****


4+ years of IT experience as an Oracle PL/SQL developer in analysis, design, development, testing and implementing a quality real time business application using oracle database with oracle forms and reports at UNIX and Windows environments

1+ years of experience in ETL projects using Informatica PowerCenter

Good Knowledge in Software Development Life Cycle with timely delivery

Substantial development experience in cursors, views, constraints, stored procedures, functions, packages, triggers, exception handlings, DBMS_SQL, UTL_FILE, DBMS_SCHEDULER, DBMS_RANDOM packages, Ref cursor, collections, analytical functions and BULK processings.

Knowledge in materialized views, parallel processing and partitioning tables

Experience in data migration using sql * loader

Experience in performance tuning using EXPLAIN_PLAN and AUTOTRACE

Good working knowledge in SQL developer, toad tools and UNIX shell scripting

Implemented UNIX shell scripts for file handling, archiving operations with oracle database and ETL workflows operations

Experience in creating Reusable Transformations, mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources to targets

Knowledge in UC4 automation tool and .Net, crystal, oracle reports, HTML language and IBM archiving tool

Good knowledge in healthcare, shipping and telecommunication domains

Worked on AGILE, a good team player and capable of working individually with less supervision


Languages PL/SQL, UNIX shell scripts

Database Environment Oracle 9i/10g/11g, SQL Server 2005/2008 Database Tools PL/SQL Developer, SQL*Plus, Toad, SQL Developer Design Tools .Net, Oracle Form Builder 9i/10g/11g, UC4 automation Reporting Tools Oracle Report Builder 10g/11g, Crystal Reports, SSRS ETL Tool Informatica PowerCenter 9.1, 9.6

Operating Systems Microsoft Windows 2000/2003/7/10, UNIX EDUCATION



NTrust Infotech Inc., CA, USA Sep 2017 – Current Date Client – AT&T Role: Programmer


Archiving process mainly deals with the database objects of tables, views and synonyms. The archiving process has different processing levels and it handles the data from different databases (Oracle/SQL Server/Teradata/DB2/Flat Files). The IBM Optim tool generates the archived files and reports and eventually the archived data will be moved to oracle databases server.

● Created and modified the PL SQL script, Unix shell scripts, UC4 and optim scripts

● Involved in data migration processes (Oracle data migration and ETL)

● Worked on BULK collect, collections and query performances

● Maintained tables spaces at oracle DB and archived files at unix environment

● Created mapping documents to outline data flow from sources to targets.

● Extracted the data from the flat files and other RDBMS databases into staging area and populated onto data warehouse.

● Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

● Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

● Created mapplets to use them in different mappings. Environment: Oracle, Informatica 9.6, Unix Shell Scripts, Optim, UC4 tool, toad PIL India Pvt Ltd,Chennai, India Oct 2011 – Oct 2012 Role: Jr Application Specialist

Projects : (PIL and ACL - Advance Container Lines) VOS - Vessel Operation Systems

One of main module that contains vessel maintenance, voyage maintenance, external voyages maintenance, and bayplan details, providing information based on service, vessel, voyages and ports. Enables the efficient execution of all vessel, voyages, service, ports planning, vessel scheduling and container managements VCS - Vessel Charting Systems

The CRM project deals with the payment from the customers (who lease the vessels). The payment will be paid as an installment by the customers. Our system is to maintain the monthly transaction and circulate the payment advice to the Finance and Charter department they will verify & approve the payment advice. Once the bill is approved the payment details will be circulate to the customer via email. ISB - Inter Service Billing

This module interacts only with the finance department for their accounts maintenance and bill submissions. The main process is to maintain and verify the payment process and transactions which sent by the agents. It rapidly reduce administrative burden on report submission and increase the delivery speed of complete ISB accounts statements

● Created several tables, procedures, functions, packages, cursors, sequences, view to meet the business requirements

● Worked on Migration from 9i, 10g oracle DB, forms and reports to 11g

● Created the procedure and packages to validate the EDI file data and uploaded the verified EDI file data into tables and reported the status to the client via email using unix script

● Wrote unix shell scripts to send mails and file processings

● Designed and generated the oracle reports based on vessel, voyages, ports and services, approval notice, payment advice, audit process, bill process etc.,

● Enhanced the performance by created indexes on the tables for faster retrieval of data and did SQL, PL/SQL tunings

● Maintained the source at WinCVS (CVS—Concurrent Versions System)

● Involved in Unit testing and integration testing

● Prepared the monthly minutes and documentation

● Supported the issues on approval, payment and audit forms and related reports

● Acquired finance domain knowledge like billing and exchange rate transactions

● Oracle analytical functions are used on financial module for billings

● Worked as a level 2 supporter and trained the trainees

● Participated the team meeting to discuss the issues, ideas, solutions and discussed new technologies

● Arranged the meeting with finance department and presented the project to the users

Environment: Oracle database, Forms and Reports 11g, PL/SQL Developer, UNIX, winCVS Broadline Computer Systems,Chennai, India Feb 2010 – Oct 2011 Client - Tamilnadu Medical Services Corporation Ltd Role: Application Developer Projects:


ERP software of TNMSC handles, Tender Finalization, Drug Order and Distribution, Stock Maintenance, Drug Transfer, Supplier Invoice and Payment Process. Finally, Reporting services to the various department of TNMSC. Depending upon various rules the system will determine which participant is eligible to which benefits QUALITY CONTROL SYSTEM

This project is to computerize and organize the quality control department activities like QC Samples, Lab Sending Process and finalization.


The entire product consists of various modules pertaining to the different section of the Hospital. The integrated software provides monthly departmental reports and yearly financial reports. So there is a high degree of dependency among all modules to achieve the end objective. The entire workings of the pay ward from the initial entry up to the final settlement of the accounts and reporting to the TNMSC and Pay ward Management Section is covered in the scope of this project. This system is generating the incentive report based on the incentive policy, which is produced on tender by the management. Various calculations are involved in the incentive report generation.

● Worked as a full stack developer

● Created a PL/SQL Scripts for auto distribution of drugs

● Oracle Supplied Packages like DBMS_Scheduler is used to maintain stock updates

● Created the function and procedures that used for back end transactions

● Computerized and automated many of the QC process and migrated the applications from manual and FoxPro system to

● Procedure developed for random selection of batches using DBMS_RANDOM package

● Various crystal reports are generated based on requirement like QC stages, company, block listed company and sample wise

● Maintained the PL/SQL scripts, .net application sources and documentation

● Created SQL queries, analytical functions and constraints for complex incentive calculation

● Involved in debugging, cold backup and SQL performance tuning

● Performed unit and integration testing and submitted the supporting documents

● Presented weekly demo to the business team to show the progress on the development

● Performed code review, supported the team and provided the business logic clarifications

● Acquired finance domain knowledge like billing, invoice, balance sheet and bank transactions

Environment: VB.Net, Crystal report, Oracle Database 10g, PL/SQL Developer

Contact this candidate