Nagesh Babu Vallamdas +919*********
DBA, Data Modeler, Oracle Developer u7lzsd@r.postjobfree.com
Professional Profile
30 months of total experience in Wipro Technologies on DBA, Data Modeling and Oracle Development.
Currently handling DMG project in a Project Engineer role.
Strong experience in Banking and Financial Services, Securities Domain.
Learn with intense desire and to convert thoughts to reality and keep consistency.
Very good communication and interpersonal skills.
Directly dealt with the clients regarding the requirements and provided solutions along with awareness sessions to the client.
Involved in development and maintenance of projects.
Worked at Onsite(London) for 3 months as DBA, Data Modeler, Oracle Developer.
Employment Details:
Current Employer – Wipro Technologies
Designation – Project Engineer
From: March 2008 To: Till Date
VISA Details:
VISA type – Work Permit
Country – UK
Validity: 29/03/2010 to11/04/2013
Certifications/Trainings
Outstanding rating and Certificate of Excellence(Feather in My Cap) from Vice President, Wipro InfoTech for possessing multi skills.
Technical Skills
Query Languages: SQL, PL-SQL
Languages: C, Core JAVA
Databases: DBMS, ORACLE 10g DBA
Web Technologies: HTML, XML, Java Script
Tools: TOAD, Sybase Power Designer, SQL Loader
Project Experience
Project Engineer – Banking and Financial Services
Project : RKYC (Client Master and COT)
Client : Investment Bank in Europe
Role : DBA, Data Modeler, Oracle Developer
Duration : Jul’ 08 – Aug’ 09
Environment : Windows, Unix
Description:
A “Golden Source” of client data, Client Master, needs to be in place to consolidate client data across existing applications and enable a master of client data for the investment bank.
Currently, client data are scattered across various systems such as Account Workflow (AW), Master files (MF) and Client On boarding Tool (COT). This causes inefficiencies in the business processes for On boarding, Client Review, Prime Services Transition Management, Compliance and other logistic functions.
The single “Golden Source” will remove business process inefficiencies, consolidate business processes, allow a single view of the client, provide transparency across different functions and centralize reporting.
In 2009, Client Master is envisaged to achieve this and it will:
• Provide a single view of client data in a centralized repository
• Provide transparency of client data across different functions
• Consolidate client data across existing client systems
• Source external data on client/entity data
• Integrate with the current client data workflow tool, COT to streamline business processes
• Integrate with MF to ensure client data is referenced correctly for the account and downstream systems
• Integrate with AW to provide KYC entitlement information for account requests (out of scope for Client Master 1.0)
• Decommission part of the functionalities in other client data systems to enable better control of client data (e.g. KYC data in AW, CE maintenance in MF)
• Provide reporting functionalities for management reporting and support business processes (e.g. client review)
Contribution:
Designing the Data Model for the application.
Designing and developing the Database based on the Data model.
Schema Creation, Refreshing the Databases.
Securing the data by developing VPDs.
Database Performance Tuning.
Maintaining and setup of Databases.
Taking backup of Databases.
Involved in developing application by developing PL/SQL scripts (Procedures, Triggers, Packages, Indexes, Cursors, etc,).
Project Engineer – Banking and Financial Services
Project : RKYC (Entity Master)
Client : Investment Bank in Europe
Role : DBA, Data Modeler, Oracle Developer
Duration : Aug’ 09 – Till date
Environment : Windows, UNIX
Description:
Entity Master is the enhanced version for Client Master. As explained in the above Project No.3, Client Master is the Repository of Client data. This existing Client Master is enhanced to Entity Master to store Issuer data (which is used to be stored in IPARTY) along with Client data.
Therefore, Entity Master has become the Central Repository for Client Data and Issuer Data.
Contribution:
Designing the Data Model for the application.
Designing and developing the Database based on the Data model.
Schema Creation, Refreshing the Databases.
Securing the data by developing VPDs.
Database Performance Tuning.
Maintaining and setup of Databases.
Taking backup of Databases.
Involved in developing application by developing PL/SQL scripts (Procedures, Triggers, Packages, Indexes, Cursors, etc,).
Onsite Experience
Worked at Onsite for the above mentioned Project Entity Master for 3 months.
Contribution:
Designing the Data Model for the application.
Designing and developing the Database based on the Data model.
Schema Creation, Refreshing the Databases.
Securing the data by developing VPDs.
Database Performance Tuning.
Maintaining and setup of Databases.
Taking backup of Databases.
Involved in developing application by developing PL/SQL scripts (Procedures, Triggers, Packages, Indexes, Cursors, etc,).