SUMMARY:

• 8+ years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i/9i/10g & 11g in Production, Staging, Development environment
• Developed various SQL, PL/SQL blocks to optimize the query performance using SQL* Plus
• Strong experience with developing Perl, Oracle and Unix based applications
• Good experience with web application using JavaScript and HTML
• Strong development, support and administration knowledge on Oracle, SQL, and PL/SQL
• Expertise in Oracle SQL, PL/SQL. Skilled in Application development using Oracle Forms and Reports with knowledge in master - detail blocks , forms triggers , system variables
• Good experience with scripting and programming in different languages, including Unix shell and Perl
• Strong Experience in front-end and back-end development using Forms 10g/9i/6i, Reports 10g/9i/6i
• Experience in Data Migration and Data modeling tools like ER Modeling, Entity relationship, MS Visio, Toad, Erwin
• Solid experience in CGI programming and database connections using Python and Perl
• Good experience in Data warehouse Concepts & ETL tools like Informatica
• Experience in developing various systems using PL/SQL stored procedures in Oracle
• Strong experience in Perl programming with variable types subroutines file operations regular expressions text processing strings and sorting process
• Substantial knowledge in development of triggers, stored procedures and functions using Oracle SQL and PL/SQL
• Good experience with supporting and developing financial application
• Strong problem solving and analytical capabilities
• Developed several reports for IT analysts to analyze data for inconsistencies and integrity issues using Oracle PL/SQL queries
• Ability to understand customer needs and manage expectations
• Excellent communication and interpersonal skills, excellent team organizing skills.

TECHNICAL SKILLS:

Languages: Perl, C, KSH, JavaScript, HTML, SQL, PL/SQL

Operating System: Windows, Solaris, Linux, Unix

Databases: Oracle, MS Access

Web Servers: Weblogic, Apache Tomcat

Tools: Cron Tab, DBI/DBD, Sql Plus, Sql Loader

PROFESSIONAL EXPERIENCE:

Confidential -East Brunswick, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Performed requirement collection, analysis and design documentation for the project
• Designed and developed Unix scripts to fetch data automatically for trade processing
• Designed, developed, and deployed customizations to Oracle Applications modules using Oracle SQL*Plus and PL/SQL
• Developed several Perl modules to handle data from other applications for market analysis
• Worked in the front-end interface to authenticate the user access to application using HTML/JavaScript
• Upgrade, maintain and troubleshoot Oracle Forms and Reports
• Enhanced the performance of the Oracle environment by providing advanced Performance Tuning and coding standards
• Performed database testing by passing SQL Queries to retrieve data in Oracle 12c
• Integrated korn shell, SQL*Loader and Oracle Streams for optimum loading
• Developed Oracle queries and PL/SQL code to verify databases for reconciliation module
• Developed Perl scripts to monitor the process schedulers
• Develop a best practice or standards document for Oracle 6i/10g/11gForms/Reports application development.
• Developed Unix scripts to maximize productivity and resolve issues
• Utilized Oracle PL/SQL to perform trouble shooting while assisting client services
• Performed Korn shell scripting to automate aspects of the Unix environment
• Provided support, training and troubleshooting services in customer support team
• Wrote packages using PL/SQL to access data from the database and write into and extract from flat files using SQL* Loader utility
• Assist in the migration and resolution of issues of the following Oracle 11g Forms and Reports applications to the Oracle Exalogic Servers.
• Uploaded data into Oracle 12c using SQL*Loader
• Worked on data extraction, Transportation and loading from various sources like Oracle SQL and flat files
• Worked on performance tuning of SQL, PL/SQL and analyzed tables
• Extended and maintained existing web application using Perl
• Worked on solving the behavioral difference issues between 10g and 11g forms debugging the errors.
• Maintained complete documentation of trading module, system maintenance requirements
• Conducted unit testing, UAT on the applications using functional and automated testing methods
• Worked on bug fixing and supporting the production

Environment: Oracle 12c/11g, PL/SQL, SQL, DBI/DBD, Perl, Unix, KornShell, SQL *Loader, SQL *Plus, Crontab

Confidential, New York, NY

Oracle Developer

Responsibilities:

• Involved in gathering software requirements and specifications from clients
• Developed the reporting system module using Perl
• Maintained and enhanced the administration module, queried them and tuned their performance
• Experience in performance tuning of SQL queries by implementing Table Partioning, Indexes and Oracle Hints
• Designed and developed Oracle Forms Reports using Forms11g/10g/6i and Reports11g/10g/ 6i Including Forms based on stored procedures
• Wrote Unix scripts to Schedule data loads using Unix CRON
• Developed web interface to automate the execution of command line tools in Perl
• Developed scripts to create the tables in Oracle
• Wrote source code in SQL*Plus and PL/SQL to handle multiple tables
• Wrote Stored Procedures for effective data inserts and updates into the tables in administration module
• Created SQL*Loader scripts to load data from external system to Oracle
• Wrote a suite of Perl scripts to convert and test the pages and then reviewed them on a web server
• Created new module using Forms and Reports for number portability module.
• Involved in extensive coding using PL/SQL. Wrote PL/SQL
• Wrote Unix shell scripts as per requirement. Schedule Cron tab as per requirement
• Created batch processes to function independently behind the scenes for data transfers, and database updates
• Used SQL, SQL*Plus and PL/SQL to check for data truncation problem
• Managed and supported the outages during urgency
• Worked with operations team in load testing and deploying the code in staging a production environment
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers extensively used Cursors, REF cursors, User-defined object types, Records, forms and reports in PL/SQL programming
• Used SQL Loader to automate the load of data from text files to Oracle tables using load data module
• Worked on performance tuning of Oracle packages, procedures, functions, and triggers
• Provide daily production support status meetings via conference calls and report the issue to the customer support
• Coded and deployed application in test and production environments
• Took part in user meetings and quality testing
• Extensively involved in the process of trouble-shooting and application enhancements for performance

Environment: Oracle 11g, PL/SQL, SQL, Perl, Unix, KornShell, SQL *Loader, SQL *Plus, Crontab, DBI/DBD

Confidential

Oracle Developer

Responsibilities:

• Developed triggers and PL/SQL procedures for automation of jobs scheduling
• Used Perl and the Unix find command to make search-and-replace-style changes
• Worked on SQL*Loader loads data from external files into tables of an Oracle database
• Build and maintain large-scale JavaScript applications
• Code-reviewed in Oracle PL/SQL procedures, functions and triggers
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, stored Outlines
• Involved in performance tuning for SQL and PL/SQL code of the application
• Created Perl/CGI to parse and validate submitted form data
• Modified required Unix scripts and other SQL validation scripts and writing scripts in SQL to validate the outputs for the report module
• DBMS developments include building data migration scripts using Oracle SQL*Loader and UTL packages
• Wrote Perl scripts to automate generation of HTML pages by gathering information
• Developed PL/SQL routines to extract data from another database and load it into the Oracle database
• Maintained code, files, and scripts using Unix platform to validate the data available in the inventory module
• Helped design custom data models that integrated with Oracle applications
• Used SQL*Plus to execute PL/SQL programs, procedures and packages
• Involved in the Maintenance releases to support the production environment
• Wrote and provided support for interfaces to and from in-house and third-party systems

Environment: Oracle 10g, PL/SQL, SQL, Perl, Unix, SQL *Loader, SQL *Plus, Crontab, DBI/DBD, KornShell

Confidential

Database Developer

Responsibilities:

• Responsible for gathering and documentation of new business rules for the project
• Maintained, troubleshooted and enhanced the existing Oracle PL/SQL code library
• Responsible for maintaining all existing HTML and Perl DBI/DBD code
• Created Unix shell scripts to perform transfer data to multiple systems and clients
• Created weekly issue dashboard reporting, resulting in integrated view across multiple resolution work streams
• Used advanced Oracle PL/SQL techniques for data retrieval in the import/export module
• Developed Unix KSH scripts allowed users to perform database tasks
• Developed Perl Scripts to automated backup status reports
• Conducted unit testing, UAT on the applications using functional and automated testing methods
• Developed Cron job and Unix shell scripts for monitoring web application and database services
• Developed Oracle PL/SQL triggers to work with Workflow design
• Wrote Perl CGI scripts for and text processing by assigning tasks for project entry module
• Responsible for 24x7, on-call support for all issues affecting Production

Environment: Oracle 10g, PL/SQL, SQL, Perl, Unix, SQL *Loader, SQL *Plus, DBI/DBD, Korn Shell, Crontab