About Me
Extensive experience in Database Programming with MS Sql server, Azure SQL, Teradata and BI technoligies like MSBI, Power BI
Exposure to MS Azure Data Factory, Azure SQL DB and Azure Board
Skilled at setting up and maintaining process, d...
Skills
Others
Development Tools
Data & Analytics
Database
Web Development
Programming Language
Operating System
Graphic Design
Portfolio Projects
Company
RBC- BFSI - Liquidity Risk Management/ BFSI – US Wealth Management
Description
Liquidity Risk Management (LRM) Group, part of Corporate Treasury Group of RBC provided liquidity management solutions and end-to-end strategic solution for Basel III Compliance Reporting. LRM generated daily/weekly/monthly/quarterly reports which were submitted to Basel III Committee from Corporate Treasury (CT) Group of RBC Bank. It involved obtaining data from 50+ source systems including Canada, US and other international locations.
The SQL upgrade for InfoNet project was an upgrade from the MS SQL 2000 to new MS SQL 2008 for all the InfoNet related database& applications. The application changes included applying schema connection strings changes, calling stored procedures, as well as converting DTS packages to SSIS packages.
Show More Show LessCompany
Alpha ImpactRx (IMS Health Company)
Description
The project provides consultative and analytically-based promotional effectiveness solutions to the Healthcare industry. The physicians capture data with the help of EDC application (IOS app) in IPhone/IPad. The data captured from EDC application will be saved in the form of XML files and later on physician can send it to the upload server. ImpactRx Nightly ETL process loads the data provided by physicians (XML files) into Data Warehouse and Data Marts. End user reports will be generated from Warehouse/Data Marts.
Show More Show LessCompany
Intelligent Processing Solutions Ltd (iPSL) UK - Digital Cheque Processing
Description
Farnaby is the future cheque clearing system. Currently, UK cheque clearing process would take 6 days for the receiver to receive the funds; now this 6 days process will be reduced to 2 days, which means the receiver would receive the funds within 2 days. To achieve this we have a proposed system called as FCM (Future Cheque clearing Module). Image Archive is one among the components in the FCM, which has Web UI, services and Databases. Image Archive is a centralized database in which audit will be maintained throughout the cheque clearing process. Each component interacts with other components using SQL server service broker queue.
Show More Show LessCompany
Leopard Business Solutions (UK) - WH Smith