SUMMARY:

• Over 8 years of experience in the areas of analyzing, application programming, system design, development and testing of business applications.
• Strong experience in design and development of applications involving Oracle, Perl and Unix/Linux Shell scripting.
• Good experience creating web application using HTML and JavaScript.
• Experience in Oracle SQL queries, PL/SQL scripts, procedures, functions, triggers, packages and query optimization.
• Strong experience in designing and development many Perl programs and modules.
• Expertise in Oracle PL/SQL and Database Performance Tuning by implementing Parallel Execution, Table Partition, Materialized Views with query.
• Experience in working and implementation of Agile software development process.
• Strong hands on experience in Unix/Linux Shell Scripts for automated testing.
• Experience in Oracle relational database modeling (RDBMS), SQL and PL/SQL.
• Experience in design, development and production support for applications using web and client/server technologies.
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review process.
• Excellent analytical, communication skills and good team spirit.

SKILLS AND EXPERTISE:

Languages: Perl, Java, HTML, SQL, PL/SQL

Operating System: Unix, Windows, Linux, Mac

Databases: Oracle 11g/12c, MySql, MS SQl Server

Web Servers: Weblogic, Apache Web Server, WebSphere

Tools: Cron Tab, DBI/DBD, APEX, ERWin, SQL*Plus, SQL*Loader

PROFESSIONAL EXPERIENCE:

Confidential, Highlands Ranch, CO

Responsibilities:

• Analyzed, developed, documented and validated products for the application, against the use case and business requirements documents as part of the SDLC activity.
• Designed Unix and Perl script to feed the transactions from flat files to falcon database for load testing of CIS/AIS/PIS..
• Parsed the fixed length file format in Perl and used Hashes to do conversion into different data formats.
• Developed the system in Perl to track the changes from file transfer by NDM, received the batch files, processed, and SFTP to the different scoring servers.
• Designed and documented the technical doc for the Non - Monetary (NMON) change application.
• Developed the application in Unix Shell and Perl Script to track NMON changes for the data records associated with each hashed (key-value) field.
• Created different data feeds by fetching the records from the Oracle 11g/12c transactional and historical database feeding to the Falcon system and processing it using Perl scripts for scoring purposes.
• Designed and developed Oracle PL/SQL, SQL scripts, RDBMS and Stored Procedures for data Import/Export and to manipulate or query data to work with back-end database development.
• Developed Oracle database objects like materialized views, tables and associated objects like Indexes and triggers.
• Developed, tested and optimized Oracle queries and Pl/SQL code for large data sets.
• Wrote the Unix Shell and Perl script to restart the transactional servers with different Users on each node.
• Wrote Unix shell scripts to assist in code development environment, file transfer and text searches.
• Captured the running logs using PL/SQL (stored procedure and triggers) and decipher the codes using Perl script for debugging and alert the QA and team as UI or email notification with the error messages.
• Developed the UI application using JavaScript/HTML for the QA team to track the changes and debug the code.
• Used CronTab to schedule the local jobs and MVS tracker to schedule the main job scripts.
• Developed the daemon process in Perl and Unix shell to run in the background tracking and capturing any changes and FORK multiple parallel processes to process the changes utilizing the maximum CPU.
• Wrote Unix Shell scripts to extract the raw data and parse it in a format so to load into the transactional database.
• Configured the Falcon application and installed it on the Red Hat Linux environment.
• Wrote SQL queries to fetch the data using DBI/DBD modules and attach it as a message to the Cases associated with a PAN for scoring purposed and for the support team.
• Maintain multiple levels of support and provided support during production application deployment.

Environment: - Oracle 11g/12c, PL/SQL, SQL, Perl, Unix/Linux, CronTab, SQL*Plus, SQL*Loader, Java, JavaScript, DBI/DBD

Confidential, New York, NY

Responsibilities:

• Involved in user requirements gathering, analysis, design, coding, testing, implementation and review.
• Wrote SQL and Shell scripts for performance tuning and monitoring, database backup and recovery on Oracle.
• Wrote application in Per DBI for data parsing and loading.
• Involved in HTML, best coding practices and clean UI implementation using CSS.
• Developed PL/SQL routines to extract data from other database and load it into the Oracle 11g database.
• Used JavaScript and Perl for dynamic data filtering, uploading and downloading.
• Provided design and implementation of Oracle database schemas and stored procedures with PL/SQL.
• Developed drag and drop slide show editing and viewing application with JavaScript and HTML.
• Involved in software development life cycle (SDLC) using Agile development methodology.
• Created web based UI using Oracle 11g Apex for Oracle database and developing queries and reports to the database.
• Used SQL*Loader utility to load data from flat files into an Oracle database.
• Developed and worked on performance tuning Oracle PL/SQL, packages, functions and triggers.
• Designed and developed Oracle PL/SQL client/server environment and created Unix shell scripts for ad - hoc work.
• Debugged and wrote error trap routines in Unix Shell and developed programs and scripts to maximize productivity and resolve issues.
• Followed Agile methodology to track, optimize and tailor features to customer needs.
• Created flat files with SQL*Plus from Oracle 11g tables.
• Maintain multiple levels of support for batch processing and provided 24x7 support during application deployment.

Environment: - Oracle 11g, PL/SQL, SQL*Loader, SQL*Plus, Perl, DBI/DBD, HTML, JavaScript, CronTab, Unix/Linux

Confidential, New York, NY

Responsibilities:

• Analyzed and designed the requirement document by coordinating with the business analysts.
• Wrote PL/SQL procedures for data migration and validation.
• Wrote Perl scripts for forms character encoding tests scripts and text processing.
• Responsible for capacity planning, database monitoring and performance tuning of production database.
• Used Oracle APEX to develop fast, scalable and secure web based application.
• Developed, tested and optimized Oracle queries and PL/SQL codes for the migration of large datasets.
• Created interfaces using HTML and JavaScript for web page presentation of data.
• Developed and tested Oracle PL/SQL procedures, functions and triggers.
• Developed Shell scripts and SQL control files to load data through SQL*Loader.
• Created many batch scripts using Unix scripting and scheduled jobs using CronTab.
• Developed Oracle PL/SQL functions and cursors for changing existing content to new format.
• Created tables and performed data driven test to retrieve items from the database using SQL.
• Worked on Oracle APEX raid development tool for Web application on the Oracle database.
• Wrote source code in SQL*Plus and Oracle PL/SQL to handle multiple tables.
• Provided Oracle PL/SQL script support for production database upgrade/change.
• Developed web application using Perl and Unix shell and modified Perl scripts due to database changes using DBI.
• Developed server side Oracle Pl/SQL (Stored Procedures, Functions and Packages) for implementing business logic.

Environment: - Oracle, Unix, Perl, DBI/DBD, Apex, CronTab, HTML, JavaScript, PL/SQL, SQL, SQL*Loader, SQL*Plus

Confidential, Edison, NJ

Responsibilities:

• Involved in the back - end design, analysis, development and testing.
• Developed Perl scripts to transform data and drive execution of PL/SQL packages and procedures.
• Involved in Oracle PL/SQL debugging and support.
• Designed, implemented and supported internal and external web based application using HTML and JavaScript.
• Designed and assisted in development of backend systems using Oracle PL/SQL technologies.
• Programmed stored Oracle PL/SQL procedures for processing and analyzing raw data.
• Wrote Perl scripts to handle and manage data in the work sheets.
• Developed PL/SQL routines to extract data from other database and load it into the Oracle database.
• Developed Unix Shell scripts to run job streams.
• Worked on performance tuning of SQL, PL/SQL and analyzed tables.
• Created Unix shell scripts to automate the monitoring of database, saving of log files and other tasks.
• Used Oracle to manage and store transactional and configuration data.
• Developed and implemented Perl scripts to monitor backups for process and failure.
• Responsible for production support and various internal technical support.
• Developed Oracle PL/SQL processes for data extraction and loading

Environment: - Oracle, PL/SQL, SQL, HTML, JavaScript, Perl, DBI/DBD, CronTab, Unix