SUMMARY:

• Over 7+ years of IT Experience as an Oracle PL/SQL Developer in Analysis, Design, Development using Oracle Relational Database Management System.
• Involved in all phases of Software Development Life Cycle(SDLC).
• Had great experience with several business domains like Financial, Banking and Education.
• Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Stored Procedures, UDFs and Triggers on Oracle.
• Good understanding of Normalization/De - normalization and database design methodology.
• Good knowledge of UNIX basic commands. Extensively used shell programs for calling pl/sql programs.
• Proficient in advance features of Oracle for PL/SQL programming like using cursors, variables, Ref. cursors, nested tables, associative array, dynamic SQL and nested loops.
• Knowledge on GLOSS (Global Settlement System), it is a transaction processing engine which automates the trade processing lifecycle.
• Exposure to Capital Markets domain and Equities Trade Life Cycle.
• Specialized in the Higher Education environment. Extensive development work with Banner Student, Admissions and Financial Aid modules.
• Familiar working in fast paced AGILE environment & attended daily scrum meeting.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Ability to work in groups and an open attitude towards learning.
• A team player and have the ability to work effectively with senior management in accomplishing objectives and able to deliver results and meet deadlines.
• Experience working with Production 24/7 and Development Environments and providing On-Call support.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, SQL Server 2008

Languages: SQL, PL/SQL

Operating System: Windows XP/2000/7, LINUX, UNIX

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL Server Management Studio

Data Modeling: Erwin r7.3/7x/4.0, MS Office Visio 2003/2007

Version Control: Sub-Version

WORK EXPERIENCE:

Confidential, NY

Sr. Oracle Database Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the procedures and packages.
• Developed programs in PL/SQL, writing Stored Procedures, Packages, and Queries with best execution plan.
• Experience with tuning complex queries.
• Determining the flow of various trades.
• Identifying and testing background servers for various trade flows.
• Compiling C source code and make their binaries.
• Validating connections between APR Gloss and external systems.
• Review and Implement improvements to support process.
• Coordinated and managed Release Cycle.
• Configured Jenkins Jobs for new Linux Servers.
• Successfully supported UAT for the migration.
• Automating the code to be copied from SVN to different environments through Jenkins Jobs.
• For successful implementation of the project we followed these steps,
• The release was done in phases.
• Again, in each phase, we divided tasks and prioritized the tasks. Started the release with less priority.
• These releases were made over couple of days.
• Hence, we had time gap for each release, which helped us resolve the issues.

Environment: Oracle 11g, TOAD, SQL Developer, Putty, Sun Solaris, Unix, SNV, Scrum, Jenkins

Database Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specification.
• Involved in the System study and Semantic Layer Design using views built using SQL.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Preparation of design documents.
• Building semantic views as per business standards and as per reporting needs
• Created custom API’s to Push Data from UI Application to Banner.
• Implemented and maintained backup and maintenance procedures to ensure reliability.
• Provided proactive support to application issues across production and non-production environments.
• Experience in Performance Tuning, Troubleshooting, backup and restore procedures.
• Review and Implement improvements to support process.
• Good knowledge working with latest tools.

Environment: Oracle 10g/11g, PL/SQL Developer,SQL Developer, Putty, Unix, SVN, Secure VPN

Database Developer

Responsibilities:

• Developed packages and procedures for functionalities.
• Involved in Code Review and verification of coding standards.
• Preparation of design documents.
• Developed complex programs in PL/SQL, writing Stored Procedures, Packages, and Queries with best execution plan and experience with testing.
• Experience with tuning complex queries.
• Resolution of critical issues in oracle.
• Maintenance of environment stability.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Installed, upgraded, configured, compiled, support of various Modules for Prod, QA, staging and on development.
• Experience with SQL DDL/DML Triggers, Database Migration and Upgrading.
• Assisted other teams in stress-testing Mobile App, locating bottlenecks, and recommending possible solutions.
• Troubleshoot day-to-day issues associated with SQL.

Environment: Oracle 10g/11g, PL/SQL Developer,SQL Developer, Putty, Unix, SVN, Cisco VPN

Database Developer

Responsibilities:

• Involved in writing functional and technical documents.
• Discussed and analyzed business functionality with the client and the developers.
• Created and maintained PL/SQL scripts for deploying to Prod.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed various Reports for the end users as per their requirements and created many reports to suit pre-printed format of the company.
• Wrote stored procedures, Functions and Database triggers using PL/SQL.
• Identified and implemented programming enhancements.
• Created custom API’s to Push Data from UI Application to Banner.
• Participated in 24Hr Production support for our environments.
• Provided proactive support to application issues across production and non-production environments.

Environment: Oracle 10g/11g, PL/SQL Developer, SVN, Secure VPN