Pranab P.

Pranab P.

Technical Manager

New Delhi , India

Experience: 10 Years

Pranab

New Delhi , India

Technical Manager

USD / Year

  • Start Date / Notice Period end date:

10 Years

Now you can Instantly Chat with Pranab!

About Me

Experienced IT professional with 13 years+ experience in Business Intelligence and software development. Extensive hands-on experience of Microsoft Business Intelligence (MSBI) suite - SSIS & SSRS, SQL Server & C#. In depth working knowledge of RDBMS...

Show More

Portfolio Projects

Description

The MVP 24 release is related to aircraft maintenance project. The Engine maintenance, vendor and maintenance parts are stored in database and tracked. Power BI is used for reporting purposes. Daily nightly jobs load data from different source like Oracle, Guard and SharePoint.

Show More Show Less

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 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 Academy: a) Normal Plan (Learning Course due date is not configured module due date will be applied) b) Special Plan (Learning Course due date is configured like 5 or 30 etc.) c) GPL Plan (courses under this plan needs to be complete by all bank employee and the due date is populated from HRD feed. d) In case of following events new learning courses is assigned to the bank employee Example: Cost Center change, Promotion, New Joiner, Internal movement, LTA movement etc. e) There are various pre and post course complete notification/warning/escalation mails send to chase the employees regarding the assigned learning courses f) The Spot fire reporting is used in this project. Learned and used Spot fire by using my SSRS experience

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