SUMMARY

• About 7 years of experience as Oracle PL/SQL Developer including 3 years as Unix - Shell Script Developer.
• Hands on experience with end to end SDLC implementation- System Analysis, Design, Development, Maintenance and Support of Oracle Database 9i/10g/11g.
• Proficient in creating PL/SQL Packages, Procedures, Functions, Exceptions Handling, Views, Triggers, Bulk Binding, Collections, Records, Dynamic SQL, Analytic Functions, Merge.
• Experience in query level Performance Tuning using Explain Plan.
• Improving the overall performance of application by Analyzing query conditions, Creation of index, Constraints, Hints, and Partitions.
• Experience of data tools like Toad, SQL*PLUS and PL/SQL Developer.
• Experience in data loading from text files into Oracle Database using SQL*Loader.
• Hands on experience with REF cursors, Dynamic SQL and Bulk Collect.
• Experience in Data Migration between different environments.
• Assisted DBA Team to upgrade database from Oracle 9i to 10g.
• Experience in Unix Shell Scripting and commands like sed, find, grep, awk.
• Experience in releasing enhancements and code fixes into various environments through the process of release deployment.
• Solved Production issues via Information Technology Infrastructure Library (ITIL).
• Worked with UNIX team and DBA Team for resolving the Production Issues.
• Worked with Operational Team, Business Analysts and Clients to define requirements and provide optimal functionality.
• Possess excellent communication, interpersonal and presentation skills.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i, DB2, MySQL, SQLiteLanguagesUNIX, Shell Scripting, XML, HTML, AJAX, JAVA

Programming Skills: Software Development, Testing, Preventive maintenance and Troubleshooting

Tools: and Apps: Toad, PL/SQL developer, $Universe, Tetra call, Wiki, JIRA, Service Now, SVN, FileZilla, SQL Loader, VSS

PROFESSIONAL EXPERIENCE

Confidential, New York

Developer/Support & Enhancement

Responsibilities:

• Developed and maintained various reports for matched and unmatched data, discrepancies, summaries, user actions (justified, unjustified, validated, reviewed), product specific and special reports for each reconciliation using Socrates.
• Requirement study, analysis, development and testing of new Reconciliations. Direct interaction with Business analysts and Users to gather and analyze requirements and define estimates and timelines.
• Built deals and Cashflow reconciliations for various financial instruments such as Swaps and Derivatives, Loan and Deposits, Associated Cashflows.
• Enhanced and restructured existing application, code fix, bug fix and maintenance.
• Technical support and Production support for Reconciliation application, batches and servers.
• Incident, Problem and Release Management.
• Developed and Implemented batch monitoring utilities and information system.
• Provided Functional support to Application Users.
• Monitored all production batches, applications, automatic calls and mail alerts for production incidents and application issues. Analyzed and resolved them to provide Reconciliation reports to users on time.
• Coordinated and communicated with various upstream teams, middleware, DBA, Unix administration, IT team and other teams in case of system issues/outages and complex issues.
• Contact person for end Users across the globe to resolve their functional/technical requests and issues related to reconciliations/reconciled data. Escalated the complex issues/requests to IT/BA team and coordinated to resolve requests/issues.
• Managed all the production incidents, user requests and problem tickets through Service Now tool and provided daily updates and reports.
• Maintained Knowledge Database with updated resolution of issues.
• Database performance tuning for database production issues.
• Assistance and suggestions in order to improve the performance and quality of application.
• Automation of production monitoring, checkouts, data and various report extraction for the users.

Environment: Oracle 11g/10g/9i, TOAD, PL/SQL, SQL, SQL*LOADER, UNIX, $Universe, Tetra call, Wiki JIRA, Service Now.

Confidential

Developer/Support & Enhancement

Responsibilities:

• Developed scripts to migrate the entire user data from ISARS (old Access Management Tool for Europe Users) to ARM Application.
• Actively worked on migration from SIAMS (old Access Management Tool for New York Users) to ARM Application.
• Developed and maintained various reports for manager’s accesses.
• Maintained and monitored ARM and SIAM servers.
• Deployed various projects on SIAM and ARM Server.
• Developed functionality to update, delete and add data of users in ARM Application.
• Developed scripts to purge data from ISARS Application.
• Developed, maintained and fixed production issues, application issues, system outages and user issues for granting accesses.
• Requirement study, analysis, development and testing of any new functionality in ARM. Analyzed the requirements and decided the original estimate and timelines.
• Monitored all production batches, applications, automatic calls and mail alerts for production incidents and application issues.
• Technical assistance to other teams and application users.
• Database optimization and performance tuning.
• Assistance and suggestions in order to improve the performance and quality of application.

Environment: Oracle 10g/9i, TOAD, PL/SQL, SQL, UNIX, $Universe, Tetra call, Wiki, JIRA, Service Now.

Confidential

Developer/Support & Enhancement

Responsibilities:

• Developed scripts to purge old service requests, notes & interactions from CRM
• Developed an Alternate Ticketing System (ATS) for tracking issues in CRM.
• Developed scripts to generate automatic alerts and mails if in case of failures.
• Data loading using SQL Loader and implementation of various processes.
• Developed application to view status of tasks in MetaSolv Application.
• Prepared Change Request fixes and ticket solving.
• Designed & developed a PL/SQL interface for automating the flow of service requests from Oracle Tele Service to Remedy.
• Developed Forms for CRM Application.
• Developed some AJAX forms to meet client requirements.
• Modified Custom.PLL to integrate customizations with other seeded screens.
• Provided high-level technical support to customers after the production rollout.
• Provided functional training to clients.
• Server monitoring, bouncing and maintenance.
• Application Maintenance, Performance improvement, Production Roll out and deployment.
• Provided Level 2 and Level 3 Technical Production support to application.
• Requirement study, analysis, development and testing of any new functionality in OSO and OTS Application. Analyzed the requirements and decided the Original Estimate and timelines.

Environment: Oracle 9i, TOAD, PL/SQL, SQL, SQL*LOADER, CRM, XML, HTML, AJAX, JAVA, SVN, FileZilla, SQL Loader, VSS

Confidential

Developer/Support & Enhancement

Responsibilities:

• Requirement study, analysis, development and testing of bug fix in this Application.
• Analyzed the requirements and decided the Original Estimate and timelines.
• Production problem analysis, resolution, Root Cause Analysis and permanent fixes.
• Developed scripts to generate automatic alerts and mails if in case of failures.
• Preventative Maintenance & Integrated Change Management activities.
• BCP/Disaster Recovery.
• Handling problem tickets with different severities well within the SLA.
• Interacting with clients to elicit requirements and provided On Call Support to JAPA Application.
• Prepared Application Specific Reports.
• Organize and conduct Weekly/Monthly Status Report calls with the Client.

Environment: Oracle 9i, UNIX, TOAD, PL/SQL, SVN, FileZilla, VSS, Edit Plus