SUMMARY

• About 8 years of experience as Oracle PL/SQL Developer - 9i/10g/11g 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 and Optimization 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.
• Strong SQL and Analysis skills with experience in writing Complex SQL queries.
• 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, SQLite, SQL PLUS

Languages: UNIX, Shell Scripting, XML, HTML, AJAX, JAVA

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

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

PROFESSIONAL EXPERIENCE

Confidential, New York

Developer/Support & Enhancement

Technologies: Oracle 11g/10g/9i, PL/SQL Developer, UNIX Shell Scripting

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.
• Developed Scripts in KSH for various batches.
• Developed UNIX Scripts to reconcile data for the application.
• 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 PLUS, SQL*LOADER, UNIX, $Universe, Tetra call, Wiki JIRA, Service Now.

Confidential

Developer/Support & Enhancement

Technologies:Oracle 9i/10g, PL/SQL Developer, UNIX Shell Scripting

Responsibilities:

• Developed scripts to migrate the entire user data from ISARS (old Access Management Tool for Europe Users) to ARM Application.
• Developed Scripts in KSH for various batches.
• Developed UNIX Scripts to maintain proper flow of data to different levels.
• 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, SQL PLUS, UNIX, $Universe, Tetra call, Wiki, JIRA, Service Now.

Confidential

Developer/Support & Enhancement

Technologies:Oracle 9i, PL/SQL Developer, JAVA

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

Technologies:Oracle 9i, PL/SQL Developer,UNIX

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, TOAD, PL/SQL, SVN, FileZilla, VSS, Edit Plus

Confidential

Developer

Technologies: Oracle 9i, PL/SQL Developer

Responsibilities:

• Designed Schema of database using Object relational database model.
• The database stores various statistics of countries for the years .
• Object type used to store GDP per capita, CO2 emissions and number of internet users.
• Created separate objects for each category and populated data into object tables using VARRAY.
• Used the insert statement to populate data into VARRAY’s for each country. Object types gdp type, co2 type, net type are VARRAYS, and tables gdp tab, co2 tab, net tab have country code and respective VARRAYS as attributes.
• Used inheritance feature of object relational database to inherit the population and expectancy fields from respective parent object.
• Declared object types person pop type and person exp type which has inheritable field ptype that stores gender of person.
• Object Reference used to create reference from country to region and continents.
• To populate data related to countries, which include country name, country code, geographical region and continent, references were created from country to regions and continents to disallow multiple entries of the later.

Environment: Oracle 9i, PL/SQL