SUMMARY

• Over 8+ years of experience in the field of software development
• Proficient working experience in SQL complex queries, Oracle PL/SQL packages, functions, stored procedures, triggers, views, objects etc
• Excellent database experience in RDBMS like Oracle, SQL, PL/SQL
• Expertise in financial industries based applications including trading systems and private banking
• Experience in Oracle, Perl, Unix Shell scripting
• Ability to develop/maintain applications and write complex Oracle PL/SQL queries
• Extensive experience in Oracle back - end in PL/SQL development
• Solid experience in CGI programming using Perl, JavaScript and Html
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment
• Excellent logical and analytical skills to solve complex problems

TECHNICAL SKILLS

Languages: Perl, Unix Shell (KSH), JavaScript, HTML, TSQL

Operating Systems: Solaris, Windows, Linux

Databases: Oracle, MS SQL Server, MySQL

Tools: CronTab, CVS, ISQL, ERWin, Toad

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

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

RESPONSIBILITIES:

• Involved in gathering software requirements and specifications from clients.
• Developed Oracle queries and PL/SQL code to verify databases for reconciliation module
• Developed user interface for Administrator profile using HTML, CSS and JavaScript, it allows admin to change privileges to users and manage their accounts.
• Developed several reports for IT analysts to analyze data for inconsistencies and integrity issues using Oracle PL/SQL queries
• Developed several Perl modules to handle data from other applications for market analysis
• Implemented the Agile Scrum process to manage project
• Designed and developed UNIX scripts to fetch data automatically for trade processing
• Developed comprehensive recovery plan for the Control-M system
• Designed and developed back-end procedures with Oracle PL/SQL
• Develop many Perl scripts that filled in the gaps between technologies of report modules in systems.
• Implement features for Continuous Integration/Continuous Development (CI/CD) pipeline test framework
• Collaborated on the development of a high-level transition plan to re-platform OFF in a UNIX/Linux environment
• Created PL/SQL, SQL*Loader and shell scripts as a part of data load process to load external data into Oracle database tables
• Assisted and worked in creating test cases aligned with requirements using UNIX shell scripts
• Worked on Performance tuning of SQL, Oracle PL/SQL and analyzed Tables
• Created cross browsers-independent HTML and JavaScript interfaces displaying dynamic views for the Administrators and Users Modules.
• Involved in creating DBI/DBD program to connect the Oracle database
• Developed complex PL/SQL stored procedures and triggers to implement the Import/Export
• Worked on Agile SCRUM environment
• Wrote Unix / Linux shell scripts and Perl scripts to automate manual processes
• Developed Perl scripts to let users have email subscriptions to various reports
• Developed several stored procedures and complex packages using PL/SQL
• Wrote multiple SQL's for data checking using SQL*PLUS, DDL activities, and testing
• Creating automated hosting platforms and CI/CD pipelines for clients of various sizes
• Generated custom Perl scripts report to parse from Control-M scheduler
• Used DBI/DBD to connect to the Oracle database and save the data in the tables of the Import/Export, Rules and Reporting Module
• Used SQL*Loader techniques to copy a mass storage of data
• Wrote source code in SQL*Plus and PL/SQL to handle multiple tables
• Wrote UNIX shell scripts to automate verification of information inserted in database
• Responsible for setup Oracle replication of data from production to reporting databases
• Involved in Performance Tuning of SQL statements
• Provided support, training and troubleshooting services in customer support team.

ENVIRONMENT: Oracle, PL/SQL, SQL*Plus, SQL*Loader, CGI, DBI/DBD, Crontab, Unix Solaris, Apache HTTP Server, Linux

Confidential, New York, NY

RESPONSIBILITIES:

• Performed requirements analysis by gathering functional and non-functional requirements for the project.
• Responsible for collection and documentation of new business rules
• Worked intensively on Oracle for creating tables, stored procedures and triggers
• Wrote UNIX shell scripts that automate database operations through SQL calls
• Maintained and improved Perl code for parsing multiple files and for generating reports
• Involved in PL/SQL code review and modification for the development of new requirements
• Custom Perl scripts parse the reports generated from Control-M scheduler
• Mentored clients on Agile and Scrum methodologies
• Implemented procedures to install and deploy large numbers of Linux / Unix servers
• Created DBI/DBD scripts for database connectivity and interaction
• Developed various SQL, PL/SQL blocks to optimize the query performance using SQL* Plus
• Led and executed multiple Oracle upgrades, along with upgrading Perl and DBI to be incompliant with the most recent builds
• Worked on optimizing existing PL/SQL packages
• Developed UNIX shell scripts to smoothly execute executables while producing log files and archives for troubleshooting purposes
• Integrated SQL*Loader and Oracle streams for optimum loading
• Developed Oracle queries and PL/SQL code to verify databases for reconciliation module
• Enhanced the existing batch Perl jobs to handle the exceptions and log the errors
• Created SQL script to create/drop database objects like tables, views, indexes, constraints, sequences and synonyms
• Coded conditions on Control-M scheduling criterion
• Code-reviewed in Oracle PL/SQL procedures, functions and triggers
• Participated in the backup and recovery of Oracle database
• Designed, implemented and maintained UNIX based custom statistics collection package
• Build custom commercial and system applications, and servers for Linux
• Maintained complete documentation of rules and portfolio administration
• Created different Oracle database objects like tables, indexes etc.
• Managed performance tuning of PL/SQL queries and optimized database performance
• Used CRONTAB to let users schedule log reports to run on a regular basis
• Provided technical support to internal developers and external clients

ENVIRONMENT: ORACLE, SQL, PL/SQL, DBI/DBD, UNIX, PERL, HTML, JavaScript, KSH, Crontab, Windows, Linux

Confidential

RESPONSIBILITIES:

• Developed Perl modules and queried the database to test the Claim module.
• Responsible for the development of web screens using HTML and JavaScript for Admin Module
• Prepared many Oracle PL/SQL scripts for data manipulation
• Assisted in debugging SQL queries code and fixing bugs
• Assisted in the data modeling, design and Performance tuning of reports
• Used Perl and UNIX shell scripts to setup web pages dynamically In Report module
• Created cursors and retrieved multiple rows dynamically using Oracle PL/SQL
• Worked in product support and enter the bugs to bug tracking system in Agent Module.
• Developed Oracle PL/SQL procedure for reporting attributes
• Used SQL*Loader loads data from external files into tables of an Oracle database
• Coordinated fixing the bugs and promoting reports to the production
• Used SQL*Plus to execute PL/SQL programs, procedures and packages
• Designed and developed back-end store procedures with Oracle PL/SQL
• Created and maintained web pages using HTML with JavaScript validation in Admin module
• Created Perl infrastructure to synchronize databases
• Responsible for Performance tuning activities in Oracle
• Maintained complete documentation of trading module, system maintenance requirements
• Designed and developed UNIX shell scripts and Oracle scripts to fetch data for reports, display reports in Report module
• Performed systems analysis and UNIX scripting
• Used Oracle PL/SQL tables, ref cursors to process huge volumes of data
• Responsible for Production Support monitor and investigate issues with production applications.

ENVIRONMENT: ORACLE, SQL, PL/SQL, DBI/DBD, UNIX, PERL, HTML, JavaScript, Crontab, Windows

Confidential

RESPONSIBILITIES:

• Responsible for collection and documentation of new business rules
• Worked intensively on Oracle for creating tables, stored procedures and triggers
• Maintained and improved Perl code for parsing multiple files and for generating reports
• Involved in PL/SQL code review and modification for the development of new requirements
• Used Perl and Unix commands to make search-and-replace style changes
• Created DBI/DBD scripts for database connectivity and interaction
• Carried out Performance tuning of the store procedures.
• Involved in Oracle PL/SQL code review and modification for the development of new requirements
• Designed, implemented and maintained UNIX based custom statistics collection package in Contract Module.
• Used SQL, SQL*Plus and PL/SQL to check for data truncation problem
• Load data into system using SQL loader and Bulk utility
• Developed triggers and PL/SQL procedures for automation of jobs scheduling
• Worked in Oracle SQL query analysis and performance tuning
• Created user accounts, roles and granting access permissions to the Oracle database
• Developed web pages and templates utilizing HTML, PERL CGI and JavaScript for Administration Module
• Developed Oracle PL/SQL functions and cursors for changing existing content to new format
• Wrote UNIX shell scripts that automate database operations through SQL calls
• Created PL/SQL Tables, Stored procedures, Triggers and Views
• Responsible for direct customer interaction and support
• Used Oracle business model as aid in improving system development process
• Responsible for production support status meetings to report issues with resolutions

ENVIRONMENT: ORACLE, SQL, PL/SQLHTML, JavaScript, Crontab, Windows, DBI/DBD, UNIX, PERL