Oracle PL/SQL Resume

Professional Summary

5 years of IT experience in Production/Application Support and development in Investment Banking and Retail domain.

Technical Summary

Languages & Technologies:

Unix, Shell Scripting

Databases:

Oracle PL/SQL, Sybase 12.5

Operating System:

Unix, Windows XP, 2000, 2003 server

Tools:

TOAD,Control M Scheduler, Citrix Meta frame Client, Rational Clearcase, JIRA

Skill Summary

In-depth knowledge of end-to-end development of software projects from requirement analysis to system study, designing, coding testing, de-bugging, documentation and implementation.
Excellent organizational skills and ability to prioritize work load.
Excellent communication and interpersonal skills.
Worked with cross function teams for designing tools to automate the work.

Project Summary

Project Name:

Billing System Test – Tools

Client:

Confidential,India

Technologies:

Unix –Solaris, Oracle PL/SQL

Company:

Confidential,

Roles & Responsibilities:

Involved in development of Accelerated Promo Billing (APB) mechanized

Validation tool. The APB Tool compared existing and the new bills and generated various reports which was used by Billing System Testing Group.

Developed Shell scripts for loading and comparing UIM files, Billing Certification process and for Price change validation.
Involved in code debugging and fixed bugs related to report generation.
Developed automation scripts for billing validation team.

Project Name:

Napoli UAT Environment Support

Client:

Confidential,

Technologies:

Unix –Solaris, Shell Scripting,Sybase 12.5

Company:

Confidential,

NAPOLI System a data repository and settlement and clearing system for cash equity products. Components include Trade Processing components which receive equity trades across NA, EMEA and APAC from Middle Office Systems , for generating accounting, instruction messages, for generating Settlement components which receive settlements from the market and settle trades in Napoli Other systems for Accounting, corporate actions.

Roles & Responsibilities:

Interacted with Napoli Build, Plan team and Napoli Test Centre
Involved in Setting up the environment for the Napoli Plan Team
Released code to the UAT environments.
Involved in Application debugging, troubleshooting in case of startup issues
Developed shell scripts for housekeeping jobs on the server, reconciliation

of data.

Project Name:

Next Generation Systems

Client:

Confidential,

Technologies:

Unix , Sybase ASE 12.5,

Company:

Confidential,India

Confidential,is a Retail Software system, which provides sales information for Tesco Stores Ltd and now support is done at stores across United Kingdom, Republic of Ireland and France. NG application is a reporting module which serves data to the Mainframe System which is the single point of control for entire Tesco Retail Network. As well as it generates reports that provides inputs to the internal store management system. RS6000 is Unix Server at Store, where all the NG applications are running. NG receives the transactions from POS. NG is part of RS6000 and it receives information about Promotions, Coupons, Product updates, Check integrity for unauthorized lines, Sales reports, etc.
Roles & Responsibilities:

Part of Level 3 NG support Team.
Resolved the Incident records and responded to the queries raised through mails.
Provided Out Of Office Hours support for the End of Day Activities.
Mentored the team
Completed the scheduled tasks within the stipulated time.

Project Name:

CREST (CENTRAL RETAIL SUPPORT TOOL)

Client:

Confidential,

Technologies:

C#.Net, VB, SQL server 2000

Company:

Confidential,India

Confidential, Retail support tool .System designed to enable a store system support teams to connect to store devices simply and quickly, also enables Users to remotely connect to any store devices in the store. Many application support teams are entirely dependent on the Crest Tool to carry out their activities. CREST is designed to support Tesco stores in a Global fashion with the user selecting the region they wish to work in and then the specific store.
Roles & Responsibilities:

Part of Level 3 Crest support Team.
Resolved the Incident records and responded to the queries raised through mails.
Monitored the load balancing of the Crest Application Servers.
Monitored the House keeping services on the Crest database servers
Provided Crest access to new users and restricted the user access based on device level and store level.
Provided Out Of Office Hours support for the Critical Christmas Period, For Clock Change Period

Project Name:

Fidelity Pricing and Cash Management System (FPCMS)

Client:

Confidential,

Technologies:

Unix –Solaris ,PL/SQL

Company:

Confidential,

Roles & Responsibilities:

Part of level 2 Support.
Handled various AAA (Very Critical) Applications.
Automated the routine manual tasks

Involved in DR assurance project development activity which dealt with Environment Analysis -Comparing Account Files of Production and Disaster Recovery set ups and identifying differences.

Educational : MBA

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship