Pranab P.

Pranab P.

SQL/MSBI Developer

New Delhi , India

Experience: 10 Years

Pranab

New Delhi , India

SQL/MSBI Developer

USD / Year

  • Start Date / Notice Period end date:

10 Years

Now you can Instantly Chat with Pranab!

About Me

Programming Experience

  • Good knowledge of ADO and ADO.NET,CLASSIC ASP,ASP.NET,VISUAL BASIC,VB.NET,C#,WEB API
  • Knowledge of linq, jQuery, Angular4, mvc pro...
  • Knowledge of linq, jQuery, Angular4, mvc project architecture.
  • Good knowledge of scripting languages like VBscript and javascript.
  • Experience of working with com component and apply VB component in component service.
  • Good knowledge of binary, project and No compatibility of ActiveX DLL and ActiveX EXE.
  • Good Knowledge of component instancing like SingleUse, MultiUse and Global Multiuse.
  • Good experience of HTTP calls from Visual Basic components and handle the response.
  • Good knowledge of working with XML using VB 6.0 and using SQL Server.
  • Experience of scheduling ActiveX Exe in SQL Job for daily process.
  • Good knowledge of DSN, Registry and File read and write using Visual Basic.
  • Good Knowledge of MS Access Database, from design and macros.
  • Experience of deployment of website on IIS.
  • Excellent Working experience of Data Table, Dataset, Data Reader and Data View.
  • Knowledge of power shell.

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