SUMMARY

• Over 7+ years of professional experience in the field of IT
• Strong experience in Unix shell and commands (FIND, AWK, SED, GREP, DIFF, SCP, Reg Ex) and programming using Vi Editor
• Strong experience in writing Unix shell scripts to Schedule data loads using Unix Cron Tab
• Strong & expert experience in Perl, Oracle, Unix Shell programming
• Strong experience in writing Unix shell scripts to schedule data loads using Cron Tab
• Broad experience in SQL, PL/SQL programming, including effective use of Oracle packages, stored procedures, database triggers and tools like SQL*Plus
• Strong hands on experienced with Unix Shell Scripts for the automated testing
• Good experience in developing web pages and other applications using Perl scripting
• Possessing strong hands - on background in supporting production environments and meeting customers’ needs
• Hard working individual, team player with excellent oral and written skills and good communication skills

TECHNICAL SKILLS

Language: Perl, C, PL/SQL, SQL, JavaScript, HTML, FPGA, VHDL

Tools: TOAD, Cron Tab, Erwin, DBI/DBD, Model-sim, Xilinx, Altium, Cadence

Databases: Oracle, Sybase, SQL Server

Operating Systems: Unix, Windows, Linux, Solaris

Web Server: Apache, Weblogic

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

Responsibilities:

• Developed many Unix shell scripts for batch scheduling
• Developed Oracle queries and PL/SQL code for large data migration
• Wrote Unix command to list all the links from directory using GREP/AWK command
• Implemented complex business logic on server side using Oracle Pl/SQL
• Created Unix scripts along with enhancing the existing ones
• Worked in data handling using Unix scripts using KSH
• Used Send mail in Perl script for sending application based emails
• Designed and programmed applications and utilities using Perl, and shell scripting for Linux operating systems
• Used Unix Shell scripting in CSH for automating startup/shutdown of databases
• Used SQL*loader to automate the load of data from file to db tables
• Wrote Unix shell scripts to discover and document dependencies between tables in the database, establishing a table hierarchy
• Developed Perl modules for data handling
• Created many Unix Shell Scripts (KSH) for data file extraction and loading
• Wrote Unix shell scripts for report generating and printing
• Wrote complex Oracle SQL using joins, sub queries and correlated sub-queries for Performance tuning
• Designed Unix scripts for file extraction and loading
• Wrote Unix / Linux shell scripts and Perl scripts to automate manual processes
• Developed scripts for web application and database services using Unix shell scripts and Cron jobs
• Developed Unix Shell and Perl utilities for proactive monitoring, alternate boot drive backup and management of SSH user accounts and keys
• Created interfaces using html and java script for web page presentation on front end
• Used TOAD for add/edit/update information
• Provided support for testing which included regression, unit, and system testing
• Maintained multiple levels of support for all systems batch processing

Technology: Perl, DBI/DBD, Unix, Oracle, PL/SQL, SQL, HTML, JavaScript, Crontab

Confidential, NYC, NY

Responsibilities:

• Worked with Unix commands to check and match output manually
• Used Oracle Pl/SQL tables to process huge volumes of data
• Wrote customized Unix shell Scripts used to provide additional monitoring of production servers
• Created batch jobs using Unix shell scripts and Perl scripts to process database activities
• Used dynamic procedures of Oracle SQL in package creation
• Implemented procedures to install and deploy large numbers of Linux / Unix servers
• Created Perl scripts for data validation/checking
• Created Unix Scripts for sequential execution of Perl scripts including file archiving, transformation and backup
• Involved in design, analysis and testing of the application
• Created batch scripts using Unix, KSH scripting and scheduled in Cron Tab
• Created interfaces using html and JavaScript for web page presentation on front end
• Extracted data using data transformation services and loaded into Oracle server
• Wrote Unix shell scripts with SQL to unload and load data and change state information for databases
• Used Unix shell scripting using hash tables and array index listing for fast retrieval
• Modifies 52 weeks report using PL/SQL queries
• Designed Perl scripts for finding top and bottom performers
• Wrote stored procedure for price reports
• Created Unix shell scripts for ad-hoc work
• Build custom commercial and system applications, and servers for Linux
• Participated in Production support and helped in trouble shooting
• Created Perl scripts with send mail for report distribution
• Maintained multiple levels of Production support

Technology: Perl, DBI/DBD, Unix, Oracle, PL/SQL, SQL, HTML, JavaScript, Crontab

Confidential

Responsibilities:

• Designed and developed Unix scripts for creating, dropping tables which are used for scheduling the jobs
• Configured Unix systems for in applications to ensure proper functionality
• Enhanced Perl script using Xml for Volume reports
• Developed and tested Unix shell scripts (Perl) which automate, file manipulation, transfers and archives
• Created Stored procedures in Oracle for customizing the reports
• Developed Unix shell scripts to generate reports, automate development and simplify testing
• Created Perl scripts to manipulate text files as per the customer requirement
• Used crontab to schedule jobs for checking invoices and account existing calls
• Managed batch jobs using Unix shell scripts and Perl scripts to process Oracle database activities
• Developed load processes and data warehouse integration using ETL procedures
• Wrote Unix shell scripts to automate start up and shut down of applications
• Developed scripting automation testing for checking job and server status
• Created batch jobs using Unix scripts and Perl scripts to process database activities
• Performed require collection analysis and design documentation
• Created multiple Unix shell scripts to import data into Oracle database
• Responsible for the production implementation and support
• Used TOAD to write database queries for checking insert/update/delete data of tables
• Provided 24/7 production support

Technology: Perl, DBI/DBD, Unix, Oracle, PL/SQL, SQL, HTML, JavaScript, Crontab

Confidential

Responsibilities:

• Coded Unix shell scripts to call SQL scripts and to manipulate returned data
• Wrote stored procedures from generating reports on vehicle availability and depreciation of vehicles
• Created Perl scripts for work orders on rebuild and repairs
• Developed and implemented Unix shell scripts to smoothly execute executables while producing log files and archives for troubleshooting purposes
• Code-reviewed in Oracle PL/SQL procedures, functions and triggers
• Maintained code, files, and scripts using Unix platform
• Created and scheduled Unix Shell Scripts for maintenance using Cron Tab
• Created XML output using Perl scripts for generating report on revenue
• Wrote shell scripts to keep track of inventory of the system
• Involved in Oracle PL/SQL debugging and support
• Created Unix shell scripts to make a reservation from client side
• Created shell script to transfer data to multiple systems and clients
• Provided hands-on support as a backup for the production technicians
• Involved in creating DBI/DBID program to connect Oracle database
• Developed in Unix shell scripts to perform data transfers and archives periodically
• Automated SQL tasks through Perl DBI
• Provided support and monitoring for enterprises infrastructure

Technology: Perl, DBI/DBD, Unix, Oracle, PL/SQL, SQL, HTML, JavaScript, Crontab