SUMMARY

• Over 7 years of experience in the field of software development
• Experience in Perl, Oracle and Unix
• Expertise in financial industries based applications including trading systems
• Excellent database knowledge on RDBMS like Oracle, SQL, PL/SQL
• Solid experience in Perl programming using with JavaScript and Html
• Experience in Oracle SQL queries and PL/SQL scripts, procedures, functions, triggers and packages and query optimization
• Experience in Service Oriented Architecture (SOA) with Web Services and Messaging Services.
• Good experience with job scheduling using Cron Tab in Unix
• Strong in Oracle query optimization and tuning
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment
• Extensive experience in Oracle back - end in PL/SQL development
• Excellent logical and analytical skills to solve complex problems

TECHNICAL SKILLS

Languages: Perl, C, C++, Unix Shell, JavaScript, HTML, TSQL

Databases: SQL, PL SQL, Oracle, Sybase, MS SQL Server, MySQL

Tools: CronTab, CVS, ISQL, ERWin, Toad, Visual Studio 2008

Web Server: Apache Web server, Netscape Enterprise Server (Web)

Operating Systems: Solaris, Microsoft Windows, Linux, Microsoft Access2003, MS 2007

PROFESSIONAL EXPERIENCE

Confidential, Bridgeport, CT

Sr. Oracle Developer

Responsibilities:

• Collecting the software specification and client requirements.
• Created user interface using HTML.
• Designed and Developed Oracle database Objects like Materialized View, Views, Tables and associated objects like Indexes and Trigger using PL/SQL
• Gathered requirements from the client for front end design and developed software requirements specification.
• Created new web services for message types using Service oriented architecture(SOA)
• Created and modified SQL*Plus scripts to capture data
• Include advanced performance tuning, database design, capacity planning and establishing standards for Oracle installations, maintenance, tuning, and coding standards
• Used UNIX to schedule different jobs using the crontab scheduler.
• Responsible for scripting data manipulation using SQL and PL/SQL
• Used Perl scripts for data migration.
• Responsible for performance testing and functional decomposition of web-based (SOA) and legacy systems architecture
• Created complex functions, stored procedures and packages by using PL/SQL.
• Created different Oracle database objects like tables, indexes etc.
• Used SQL Loader to convert the data.
• Worked on SQL tuning after analyzing the tables, users and Functionality.
• Developed Oracle PL/SQL functions and cursors for changing existing content to new format
• Created UNIX scripts for sequential execution of Perl scripts including file archiving, transformation and backup.
• Created directory object in Oracle
• Provided support when the users faced issues along with production support people.
• Wrote source code in SQL*Plus and PL/SQL to handle multiple tables
• Wrote database triggers, stored procedures, packages and functions using PL/SQL and SQL in Oracle databases
• Created Perl DBI/DBD for database access from web pages.
• Created UNIX shell scripts for uninterrupted execution during creation of log files and archives.
• Involved in data load using PL/SQL and SQL*Loader
• Worked on performance tuning and monitoring of database
• Developed many tables, stored procedures and triggers on Oracle database for implementing complex business logic
• Wrote PERL scripts to establish a connection with the Oracle database using DBI/DBD for the processing module while giving the permissions to do so in the administration module
• Worked with other team members to move the code to production.
• Participated in testing and customer meetings.
• Participated in daily production support status meetings.

Environment: Oracle, Perl, DBI/DBD, HTML, SQL, PL/SQL, SQL Loader, Unix, Linux, CronTab

Confidential, Newark, NJ

Oracle Developer

Responsibilities:

• Identified database objects, created and delivered them to the development team.
• Designed and Developed stored procedures to convert and load data into the Oracle databases
• Created Perl scripts for data migration.
• Monitored the changes in requirement and constantly kept the database model in sync with the changing requirement.
• Worked extensively on PL/SQL batch programming to process the previously collected jobs in a single batch of the processes running in the processing module
• Developed SOA (Service Oriented Architecture) Web and Middleware applications
• Responsible for primary database creation writing indexing and triggers on Oracle database
• Handled back end processes written using UNIX.
• Developed Perl DBI/DBD and JavaScript for database access from html web pages.
• Worked on optimizing PL/SQL packages that are existing within the system
• Involved in Performance Tuning of SQL statements
• Developed complex Oracle SQL scripts to generate data content records for automatic content generation
• Developed Shell scripts and SQL control files to load data through SQL*Loader
• Builded on a custom framework using SOA Web Services
• Created many Indexes for performance improvement.
• Modified required UNIX scripts and other SQL validation scripts.
• Developed database triggers and procedures using the Oracle PL/SQL cursors and tables for the modules needing user feedback or interaction
• Wrote and enhanced stored procedures and triggers for better performance of queries.
• Used Perl, DBI/DBD for Oracle connection.
• Created documentation for performance testing.
• Used CronTab for batch scheduling.
• Wrote Oracle PL/SQL procedures for data migration and validation
• Validated the record layout and filed format using regular expression matching.
• Responsible for capacity planning, space management, problem resolution, database monitoring and performance tuning of Production Databases
• Developed and implemented Oracle backup and recovery procedures
• Developed UNIX scripts for data file movement and scheduling.
• Created ad-hoc reports using shell scripts.
• Used SQL, SQL*Plus and PL/SQL to check for data truncation problem
• Fixed the performance bottlenecks identified by the QA team.
• Provided application support during post production.
• Participated in testing and customer meetings.

Environment: Oracle, PL/SQL, Perl, Html, JavaScript, Unix, Solaris, Apache, DBI/DBD, Windows

Confidential

Oracle Developer

Responsibilities:

• Involved in front-end design, analysis, testing and development.
• Worked with Oracle databases and designed procedures for the modules that required database assistance and backup support
• Developed, tested and optimized Oracle queries and PL/SQL code for the migration of large datasets
• Designed and analyzed scheduling system including relation ER diagrams.
• Fixed the errors in the data by using the PL/SQL scripting
• Maintained code files and scripts using UNIX platform.
• Involved in creating new databases, performance tuning and partitioning tables on multiple versions of Oracle
• Implemented image creation and manipulation using Perl scripts.
• Worked in PL/SQL batches for data handling in the backend.
• Developed and implemented UNIX shell scripts which automate, file manipulation and transfers.
• Wrote Perl programming to error check the data and import it into the Oracle database.
• Involved in data load using PL/SQL and SQL*Loader and cron jobs calling Unix scripts to download and manipulate files
• Utilized SQL*Plus as the main interface with Oracle.
• Created many batch scripts Using Perl and KSH.
• Utilized linked files in UNIX shell scripting.
• Involved in Oracle PL/SQL code review and modification for the development of new requirements
• Worked in performance tuning of the PL/SQL batches and stored procedures
• Provided support for the application.
• Performed database testing by passing SQL queries to retrieve data in Oracle.
• Worked with users for new module enhancements and testing.

Environment: Oracle, HTML, JavaScript, Unix, Perl, CGI, SQL, PL/SQL, Linux, Cron Tab

Confidential 

Oracle Developer

Responsibilities:

• Performed code reviews in Oracle PL/SQL procedures, functions and triggers.
• Wrote Perl scripts to automate the process of scheduled bill payments.
• Managed performance tuning of SQL queries and fixed the slow running queries with utilities like Explain, Trace, stored outlines.
• Wrote UNIX scripts to schedule data loads using CRONTAB.
• Developed triggers and PL/SQL procedures for automation of jobs scheduling.
• Wrote SQL scripts to validate the output.
• Used Oracle PL/SQL to filter and load data from other production databases
• Used Perl and UNIX find command to make search and replace style changes.
• Wrote control files and loaded the data into the Oracle database with SQL Loader
• Worked on Performance tuning of SQL using Joins and data distribution
• Programmed stored Oracle PL/SQL procedures for processing and analyzing raw data
• Provided resolutions to the issues reported by customers in past 24 hours.
• Developed and maintained web forms in Oracle for analysis and user interaction and information collection in the registration and reports module
• Wrote UNIX and Perl scripts to automate the generation of reports for account transactions.
• Designed and built an integration solution that merged Oracle tables from two separate Oracle databases using PL/SQL
• Wrote log files to record all the changes made in user accounts.
• Provided support for interfaces to and from in-house and third-party systems.

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