Excellent Knowledge on Oracle9i ,UNIX, perl scripting
IT - MCA - 3-5
Posted on: Mon, 17 Nov 2008, 03:07 AM
Job category: IT
Field: database - software
Role: developer/programmer
Education: MCA
Experience: 3-5 years
Preferred job location: Anywhere in India
Name: - Pravas Panda
Mail ID: –pravas.ora@gmail.com
Cell Number: - +91-9704092602
PRELUDE:
A degree in Master in Computer Application having IT experience of over 3 years and 6 Months in the field of development on Client/Server Technology. As a quick Learner and a strong understanding capability, is Capable of switching to any domain or functional area and skill set easily within a limited time frame. Basically a Person with very Positive attitude and can give its best Commitment towards its Employer and adheres to all the quality processes and techniques required to deliver optimum quality results for an organization.
PERSONAL EXPERIENCE:
Experienced in Client/Server and Web based Applications.
Excellent Knowledge on Oracle9i (SQL, PL/SQL), UNIX, Shell Scripting and Perl Scripting.
Extensive Experience in Development, Production Support and Maintenance.
Automating the Jobs using Shell Scripting and Perl on Unix Platform
Knowledge in Telecom and Banking Domain
Excellent interpersonal skills, confidence and poised in interaction with individuals at all levels.
WORK EXPERIENCE:
Presently working as a developer at XIUS-BCGI. (A DIVISION OF MEGASOFT Ltd.)
Hyderabad, since Jan. 2008- Till Date
Worked as a Technical Consultant at Perot Systems (TSI) India Ltd., Bangalore since Dec. 2006 –Jan 2008.
Worked as a Consultant at DSL Softwares Ltd. from Apr. 2005 – Nov. 2006.
TECHNICAL SKILLS:
Domain : Telecom, Investment Banking, Finance & Capital Market
Database Server : Oracle 9i (SQL, PL/SQL)
Operating System : Windows, Sun Solaris UNIX 5.8
Scripting : Shell Scripting , Perl Scripting
Other Tools Used : TOAD, Putty, SSH Client
EDUCATIONAL DETAILS:
Master in Computer Application (MCA).
Percentage secured: 72%.
Year of passing: 2003.
PROJECT EXPERIENCE:
1.Project Name: WNFC
Start Date
Jan. 2008 End Date
Till day
Client : TNZI(Telecom Newzealand international)
Technologies : RDBMS Oracle 9.2.02
S/w : Oracle, PL/SQL
Environment : Toad
Role and responsibilities:
• Developing different packages, procedures and functions.
• Gathering requirement, Involved in coordination and planning with different teams for releases.
• Developing API procedures for the client.
• Developing different triggers, for a particular task.
• Developing Reports according to the requirement.
• Creating script for the others, and developing rollback statements for modification.
• Writing codes according to the functionality of the front-end.
• Receive payment files (batches) and other auxiliary information from customers.
• Provide exceptions, error codes for easy access of the customers.
Project Summary:
This application caters functionality WNFC (Welcome notification). Whole application is bifurcated into 2 modules. There is - Roamer Management, User Management.
Report generation: Reports to be generated as per requirement.
• Operator wise analysis of roamer details for inbound / outbound roamers
• The details of registrations/deregistration/number of each SMS messages sent (successful/failed) during a specific period
• Current list of roamers at any time with their previous logged network details, arrival date and time and the number of messages already sent etc. List of Outbound roamers
• All front-end screens are developed using JAVA .Back-end procedures are developed in oracle.
Functionality:
Welcome Notification (WN) serves (currently) the GSM Network (Mobile) Operators to help reaching out their inbound and outbound roaming subscribers by sending targeted and personalized SMS
WN promotes new services directly to the mobile roaming subscribers and these include targeted messages to specific market segments as well as to specific locations in the network (inbound and outbound), based on the location-based concept.
WN is mainly focused on roaming subscribers of GSM to:
• Send a welcome SMS (welcome note) to all the in-roamers in a network
• Send a short message when the home subscriber logs on to other roaming networks
2.Project Name: TSI
Start Date
Dec. 2006 End Date
Jan. 2008
Client : UBS(Perot Systems, Bangalore)
Technologies : RDBMS Oracle 9.2.02
S/w : Oracle, PL/SQL, UNIX, Shell Scripting and Perl Scripting
Environment : Sun Solaris UNIX 5.8.0 (Batch job scheduler Korn Shell)
Role and responsibilities:
• Involving in developing day to day trades flow from the up streams system (front offices) to downstream system.
• Involved in coordination and planning with different teams for production releases.
• Responsible for improving the system by analyzing the process improvement to achieve system stability and also taking necessary preventive actions for avoiding repetitive issues.
• Automating the Trade Flow that flows from the Payment Dispatcher to the downstream systems.
• Receive payment files (batches) and other auxiliary information from customers.
• Provide easy access to transaction status for customer support.
Project Summary:
This application caters functionality TSI (Trade executions & settlement inquiry). Whole application is bifurcated into 3 modules. There are data loading processes :(tsi_fail_trades,tsi_good_trades,tsi_global_daily_trades,tsi_eod_open_trades)trade details to be captured from eSpear.
Report generation: Reports to be generated as per requirement.
Administration: (Access right manager, set transaction columns).
All front-end screens are developed using JSP/JAVA .Back-end procedures like batch processes using shell scripts, which in turn calls the sql-loader using respective loader scripts shell scripts would be scheduled through UNIX cron.
Functionality:
Provides users to get the report of global daily trades. Users can also avail the reports of good trades, cancel trades and fail trades and so also special reports on UBS Australia and Switzerland.
3.Project Name: Heliograph
Start Date
Jan. 2006 End Date
Nov. 2006
Client : DB Asset Management, German
Organization : DSL Softwares Ltd., Bangalore
Technologies : RDBMS Oracle 9.2.02
S/w : Oracle, PL/SQL and Perl Scripting
Environment : Windows XP
Role and responsibilities:
Handling User Queries through various media like Chat, Phone or Ticket Tracking Tool
Providing Production Support to the client on 24*7 basis
Involved in Code Migration and Change deployment
Automating various jobs to reduce manual effort
Project Summary:
This product is specially designed for asset management companies like DeAM. Asset-backed securities may be appropriate for customers, who have access to larger subsidy volumes with similar individual subsidies. This is basically divided into 3 modules i.e. Portia, Oasys and Helio Match.
Portia: - Database of Business (Fund Managers).
Oasys: - Network for Brokers
Helio Match: - Core of Heliograph product which takes input as ETC and sends to ETS and Custodians as output. All front-end screens are developed using Visual Studio. Back-end procedures like batch processes use oracle.
Functionality:
Provides facility to users in the settlement of money market trades, FX trades by giving both broker & client side trade matching.
4.Project Name: DB-Custody Start Date
Apr. 2005 End Date
Dec. 2005
Client : Deutsche Bank AG
Organisation : DSL Softwares Ltd., Bangalore
Technologies : RDBMS Oracle 9.2.02
S/w : Oracle, PL/SQL, UNIX, Shell Scripting and Perl Scripting
Environment : Sun Solaris UNIX 5.8.0
Role and responsibilities:
• As a team member, my responsibilities are to analyze the change requests and new enhancements that come in as part of DB-Custody Offshore development work.
• Prepare technical specifications and do the impact analysis.
Project Summary:
DB-Custody is an on line trade settlement system. The primary function of DB-Custody is to confirm and settle securities. It is a multi-currency, integrated, international clearing and settlement system used by Deutsche Bank AG. Involved in SWIFT Net and number of RFS (Change Requests) for Deutsche Bank AG.
Personal Profile:
Date of Birth : 24th june 1975
Nationality : Indian
Sex : Male
Languages Known : English, Hindi, and Oriya
Pravas panda
Landline number: +91-141-301 5652
Mobile number: +91-97040 92602
Syndicated from: 
|
|
|
