Pl/sql Developer Resume
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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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 DeveloperResponsibilities:
- 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