We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

4.00/5 (Submit Your Rating)

New York, NY

SUMMARY

  • IT professional wif over 7+ years experience in technology driven project development, SDLC planning/managing and Business Analysis in teh IT sector.
  • Strong experience in Perl, Oracle, Unix programming
  • Strong experience in writing Unix shell scripts to schedule data loads using Cron Tab
  • Solid experience in building large complex / scalable distributed applications in Unix environment
  • Experience in creating more accessible user interfaces using HTML and JavaScript
  • Experience in Perl development wif Unix shell programming
  • Proficient in writing SQL, PL/SQL stored procedures, packages and triggers
  • Ability to develop/maintain applications and write complex Oracle PL/SQL queries
  • Good knowledge in providing technical solutions for Unix environment
  • Good understanding of financial industry and terms
  • Specific experience in managing all aspects of production support
  • Excellent communication, presentation and interpersonal skills

TECHNICAL SKILLS

LANGUAGES: Perl, C, C++, Unix Shell, JavaScript, Java, PHP DBI/DBD, HTML, SQL, PLSQL

OPERATING SYSTEM: Windows, Sun Solaris, Linux, HP Unix

RDBMS: Oracle, Sybase, MS Access, MS SQL Server

WEB/APP SERVERS: Apache, Weblogic, Websphere

TOOLS: VB, DBI/DBD, ERWin, Aquadata Cron, Autosys, SQL * Loader, SQL*Plus

Version Control Tools: GIT, Jenkins

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

PL/SQL Developer

Responsibilities:

  • Involved in User requirement gathering, analysis, coding, testing of application
  • Created Unix shell scripts and generated SQL reports for halp testing teh back - end
  • Developed automated batch schedule to execute all necessary procedures using Unix shell scripting to execute all stored procedures
  • Developed Oracle tables and PL/SQL packages procedures and function
  • Created many batch scripts using Unix scripting and scheduled in Cron Tab
  • Wrote Perl script to manipulate text file as per user requirements
  • Developed SQL programs to automatically load data in to database
  • Wrote many Java programs to do teh data validation
  • Designed and programmed applications and utilities using Perl, and shell scripting for Linux operating systems
  • Developed and tested Unix Shell Scripts (Korn & Perl) to automate file manipulation, transfers and archives
  • Built SQL queries and stored procedures for computation and inquiry module
  • Developed Oracle alert PL/SQL code to work wif work flow design
  • Created many Unix shell scripts for data file extraction and loading
  • Wrote numerous Shell and Perl scripts to automate various tasks
  • Worked wif Unix commands to check and match teh output manually
  • Worked wif HTML and JS pages in order to create web pages and fix bugs for website
  • Created Cron jobs in UNIX for scheduling file processing
  • Analyzed Java programs and enhanced teh existing data extractor Core Java programs
  • Wrote Unix / Linux shell scripts and Perl scripts to automate manual processes
  • Developed Oracle PL/SQL scripts for data import/ export
  • Developed and maintained extensive scripting environment using Unix Shell scripting
  • Maintained existing web page using Perl
  • Developed Unix shell scripts to check code for standard violations
  • Use SQL *Loader to automate load of data from file to db tables created and maintained extensive library of Unix shell scripts
  • Involved in production support and resolving production issues
  • Involved wif software engineering team for SDLC
  • Provide day to day support for production database and programming issue

Environment: Perl, DBI/DBD, HTML, JavaScript, Cron Tab, Unix, Oracle, PL/SQL, SQL

Confidential, New York, NY

PL/SQL Developer

Responsibilities:

  • Implemented SDLC which include req gathering, design, analysis and testing
  • Managed batch jobs using Unix shell scripts and Perl scripts to process Oracle database activities
  • Wrote UNIX shell scripts to provide additional monitoring on production server
  • Designed HTML interface for a JavaScript and Perl driven price for report and inquiry module
  • Implemented procedures to install and deploy large numbers of Linux / Unix servers
  • Wrote customized Unix shell scripts used to provide additional monitoring of production servers
  • Designed, implemented, and maintained Perl application wif Oracle database
  • Developed many Unix shell scripting for batch scheduling for report generation
  • Wrote SQL queries to automate load data in to database
  • Designed and developed Java enterprise applications/services to access Oracle via entity beans and session beans
  • Wrote Unix shell scripts to automate teh start up and shut down of applications
  • Use DBI/DBD for Oracle connection in Perl
  • Used Cron Tab for teh batch scheduling in Unix
  • Contributed to prevention of problems/ issues as they are related to production support
  • Created many batch scripts using Unix scripting and scheduled in Cron Tab
  • Worked on call support in production environment on web based application
  • Developed Scripts to run Unix shell tabs to update teh database in specific intervals
  • Used Oracle to manage and store teh transactional and config. data
  • Worked on stream processing to run SQL queries
  • Batch processing for data handling

Environment: Perl, DBI/DBD, JavaScript, HTML, Oracle, SQL, PL/SQL, Cron Tab, UNIX

Confidential

PL/SQL Developer

Responsibilities:

  • Involved in User requirement, Functional specification, Data models
  • Wrote a Korn shell script to simplify addition and deletion of Unix logins
  • Design document to ensure quality of SDLC deliverables and test quality
  • Wrote Perl scripts wif debugging features and syntax highlighting
  • Developed and tested Unix shell scripts (Perl) which automate, file manipulation, transfers and archives
  • Involved in recursive Oracle queries to built wif recursive common table expression
  • Build custom commercial and system applications, and servers for Linux
  • Worked wif Unix commands to check and match teh output manually
  • Developed reusable components and rule based engines for production improvement using Oracle PL/SQL
  • Wrote Unix shell scripts for data backups, and web site systems monitoring
  • Wrote Perl and shell to automate task in invoice generation
  • Designed and developed Unix scripts for creating, dropping tables for job scheduling
  • Use Cron tab to automate reports generation
  • Wrote a shell script to simplify addition and deletion of Unix logins
  • Wrote Perl scripts to extract info from premiere files
  • Wrote Unix shell scripts to automate teh start up and shut down of applications
  • Wrote complex Oracle PL/SQL procedures and function to improve efficiency for summarizing data
  • Developed many Unix scripts for data file movement and scheduling
  • Involved wif front end team in designing interactive UI
  • Responsible for production support engineer also monitor ticket queue and resolve technical issues
  • Creates SP for Admin modules
  • Provide production support and maintain data

Environment: PL/SQL, SQL, Perl, DBI/DBD, JavaScript, HTML, Oracle, Cron Tab, UNIX

Confidential

PL/SQL Developer

Responsibilities:

  • Created many migration and maintenance scripts in Perl
  • Provided performance monitoring and tuning on Unix systems
  • Involved in User requirement, Functional specification, Data models
  • Design document to ensure quality of SDLC deliverables and test quality
  • Used Cron Tab for teh batch scheduling in Unix
  • Wrote SQL scripts and SP for customer information and order entry modules
  • Use per scripting to automate creation of global address book setting and importing
  • Created Unix shell scripts to perform transfer data to multiple systems and clients
  • Wrote Perl and shell to automate task in invoice generation
  • Implemented complex SQL queries on database along wif SP, Triggers and PL/SQL blocks for report module and computation module
  • Created batch jobs using Unix shell scripts (Cron Tab) and Perl scripts to process database activities
  • Used Oracle to manage and store, transactional and config data
  • Created Unix scripts for data format/validation checking
  • Developed Triggers, packages, procedures and function using PL/SQL for report generation module
  • Wrote Unix shell scripts to assist in code development environment, file transfer and text searches
  • Wrote complex Oracle procedures and function to improve efficiency for summarizing data
  • Use Cron tab to automate reports generation
  • Modified Unix shell scripts that created SQL scripts to give extra fields wifin reports
  • Developed department intranet sie using Perl, html and JS
  • Developed framework for extensible automated production support in Oracle
  • Developed and implemented Unix shell script to smoothly execute executables while producing log file and archieve for production support
  • Involved wif front end team in designing interactive UI
  • Responsible for participating in out of hours support duties
  • Creates SP for Payment module
  • Responsible for production support monitor and investigate issues wif production applications

Environment: Perl, JavaScript, HTML, DBI/DBD, Oracle, SQL, PL/SQL, Cron Tab, UNIX

We'd love your feedback!