Pranab P.

Pranab P.

Senior MSBI/SQL Developer

New Delhi , India

Experience: 10 Years

Pranab

New Delhi , India

Senior MSBI/SQL Developer

USD / Year

  • Start Date / Notice Period end date:

10 Years

Now you can Instantly Chat with Pranab!

About Me

Working with NIIT Technology Greater Noida as a Technical Analyst. I am dependable, positive, flexible and effective and can work well under pressure. Over 8 Years of Database development and total 10 year of industry experience. Experience of databa...

Show More

Portfolio Projects

Description

The Learning module of ECD Application is the ability to assign employees the mandatory trainings to acquire skills and efficiency. Which will Increase the productivity of bank employee and they become an asset for the organization. This is the own product of RBS and whose data source is currently migrating from people soft to workday environment.

The following events create observation jobs and analyzing with different criteria learning course is assigned to a bank employee. There are the different modules of ECD application Academy, P2P, JD, Surveillance

Show More Show Less

Description

The FMV module of Managed Account Application is the ability to allow users input the security details (Equity, Mutual Fund and bond) and display the on screen calculated Fair Market Value based on the DOD. The application also allows have Excel report generation and download functionality. The OUF (Operation Utility Framework) is used for Authorization and the Transaction Loader tool is used to update the taxlot information into the SWP oracle database.

Show More Show Less

Description

Trust Office Integration and Operation Application is the centralized application for all Middle Office Operations. This application is used mostly as an information repository having data of accounts, accountants, administrators, branches, Trades, Incoming Cash Receipts etc. To creating this reports, Trust Office Data Warehouse need to load data from various data sources like Main Frame, SQL Server, Flat files, XML files, Excel files, etc. The Integration framework provides generic ETL tool to transfer data from different data sources to Trust Office data warehouse with very minimal code modification.

Show More Show Less

Description

The main purpose of NxAS application is asset management, investment processing, and investment operations solutions for institutional and personal wealth management. These applications help private banks, investment advisors, investment managers, institutional investors and affluent individuals and create and manage their wealth. This application uses third party tool for address verification, PA compliance and also uses Blaze rules for applying business logic.

Show More Show Less

Description

Trust Office Integration and Operation Application is the centralized application for all Middle Office Operations. This application is used mostly as an information repository having data of accounts, accountants, administrators, branches, Trades, Incoming Cash Receipts etc. To creating this reports, Trust Office Data Warehouse need to load data from various data sources like Main Frame, SQL Server, Flat files, XML files, Excel files, etc. The Integration framework provides generic ETL tool to transfer data from different data sources to Trust Office data warehouse with very minimal code modification.

Show More Show Less

Description

The Image Station suite of applications is used in the daily operations of the SEI Middle Office Service and Processing Team. Image Station captures documents electronically and routes the images through a predetermined workflow. Both during and after work has been completed the electronic images, as well as the notations and history of the image, are available for searching and viewing by Image Station users. Applications in the Image Station suite fall under one of two categories: User Application or Robot Application. User Applications are applications that the SEI Trust Company user interfaces with directly. The Robot Applications are applications that run without user intervention and perform the same task repeatedly throughout the day.

Show More Show Less

Description

This application is to allow Branches Deposit scheme (CDPPIPP) through Agents. Branch Head Request Loan, Claim, Repurchase Customer Request to Head Office. This Software Differentiate Allotted, Non Allotted and Register Cases and Calculate Interest and Deduction Accordingly and Process the request After proper Validation the branch cases are Sanctioned at Ho Level and Secured Text and Access File Generated and Mailed to Branches .This Application Provide Option free look period of one Month to the Customer (Only to CDPP Cases and face value greater than 20000) to review the plan if the Customer does not find plan suitable the plan documents must be returned to the company within 30 days from the date of receipt. If any customer does not choose to continue plan than plan will be foreclosed as per the plan terms and conditions after expiry of one year from the date of unpaid installment and called defaulter. No deduction within two years of plan registered. Greater Than Two Year and payment less than 80% of face value 6.5% deduction for Non Allotted Case and 20% deduction of face value for Allotted Cases In case of sanction before expiry date. Payment of 80% of face value and sanction after expiry date no deduction. After 50% payment of face value Land Allotted To Customer. This Application Provide Special Sanction in emergency cases. Provides various claim options and sanction amount vary depends upon the type of claim. This Application Provide Module wise security and User Wise Security and having user admin level and user level. Generation of various reports mainly Loan Report, Claim Report, sanction report, Status report, Allotted and Non Allotted Reports.

Show More Show Less

Description

The central part of the application is to allow BranchesDepartments to Order the Products of their desire through this Software. The information pertaining to the products are stored in database at the server side .The server processes the BranchesDepartments request and the product are shipped to the address submitted by them. This project is having Multilanguage facility according to our requirement. This project is designed to provide all the solutions regarding Store Management processes like Requisition, Indent, Purchase, Receipt, Rejection, Issue, challan and Quality Control and provide a great architecture for Pearls Group. Each module provides a base set of industry-standard capabilities, plus the flexibility to be configured to your Specific needs. This Project Have Report Generation Section where Stock Ledger, Indent Register, Material Receipt Register, Quality Check Register Generated where requisition and issue register report generated department and branch wise. Store Management Software (SMS) is ideal for implementing across multiple sites.

Show More Show Less

Description

This software is very friendly, and very efficient to operate. It has been designed to facilitate both everyday accounts and administrative tasks (including client and job records, time and expense tracking, billing, accounts receivable, and work scheduling), and monitoring and decision-making by managers. During everyday use, client and job histories are automatically accumulated for later reference and searching as necessary. The software has comprehensive management reporting facilities that allow the everyday data to be re-used for strategic purposes. Its modular construction allows you to purchase the most important functionality initially, and add further capabilities at a later date once your staff is using the basics well.

Show More Show Less