•Architect and develop native applications DASHBOARD using HANA 2.0 Web IDE, Cloud Foundry, SAP HaaS, Git Repository, Multi-Tenant Application, Containers, Synonyms, TF & SP, CDS Views•Architect and develop real time replication solution SCDREP using HANA 2.0 Web IDE, virtual table, remote source, hdbtable/hdbcds, hdbtrigger and replication task and flowgraph•Configure & manage SAP HANA 2.0 cockpit to monitor & admin multiple SAP HANA landscapes such as DEV, QA and PROD in centralized portal•Install SAP HANA 2.0 XSA runtime and different XSA components and design the XSA development best practice & deployment life cycle•SAP HANA Rules Framework 1.0 SP 11 on XSA to manage and automate business decisions and rules•Migrate SAP HANA server from SAP HANA1.0 SPS12 into SAP HANA 2.0 SPS3 •Develop Azure DevOps pipeline for SAP HANA XSA agile development and deployment•Develop data modeling for comprehensive asset classes with Compliance and Finance teams to implement FundApps, a financial regulatory compliance monitoring tool for equities, bonds, futures, options, swaps, and indexes etc.,

•Worked on MR project which is a sub stream of the largest SAP S/4HANA project SWIFT. It is responsible for the replacement of the company's reporting capabilities. This project aligns with Global, US and UK and Consulting recommendations and has a multi-phase delivery. SAP HANA Enterprise Global & Local sidecar•Finance HANA reporting – SAP Analysis for Microsoft Office Excel•Enterprise reporting – IBM Cognos•Self-service reporting – Tableau•SAP HALM, SAP HANA SDI

•SAP BI implementation using SAP HANA SP12, SAP SLT, SAP BOBJ, SAP BODS•Reviewed functional requirements and developed technical documents for BI projects•Developed SAP BI reporting solution in SAP FI, SAP CO, SAP SD, SAP MM, SAP PS•Coordinated teams between Aecon and offshore resources•Architected and developed the HANA native model, BOBJ universe and Webi reports

•Led SAP HANA analytics solution development on SAP ECC on SAP HANA•Developed SAP HANA XS App and analytical models in SAP FICO, MM, SD, COPA etc.,•Implemented HANA security architecture for reporting and developers to comply with CGT security controls•Designed the SAP XS job to accumulate the stock level snapshot and provide trend analysis •Developed SAP HANA BOM explosion to create BOM linkage and product-on-demand modeling view

•Led SAP HANA development and recommended architecture solution to client•Gathered business requirements, developed and reviewed SAP HANA native models in insurance, mortgage, banking, RBroker, RClass, VMA etc.,•Developed complex SAP HANA models using attribute views, analytic views and calculations views, stored procedures, tables, etc. to meet functional requirements •Trained and mentored development team•Created, enforced, and adhered to SAP HANA best practice and development standards•Developed SAP BODS framework to integrate source data into RDL and IDE layers •Performance tuned and troubleshooted•Created ad hoc dashboards, reports using SAP Analysis for Microsoft Excel and SAP Lumira•SAP HANA 1.0 SPS 9/10, SAP BODS 4.2 and SAP Lumira

•Participated in HANA DMO project and implemented SAP Business Suite on HANA on HEC•Lead HANA operational reporting solution development and replaced SAP BW using HANA Live & BI toolset •Designed and developed HANA virtual data modeling views in the modules of SAP FI/CO, SAP SD, PS, COPA, CATS, PCA, BI connectivity & security model and reports and Dashboards using SAP Analysis Office & Design Studio •Prototyped SAP HANA Text Analysis and PAL POC•Integrated and federated multiple data sources by SAP HANA SDA and SAP BODS•Supported SAP HANA production, optomization and troubleshooting•SAP ABAP on HANA by using CDS to push down the data process logic into HANA•Supported HANA upgrade from SP8 to SP9 & SP10

•Developed the real-time agile data mart CommViews using SAP HANA SPS08/09•Implemented the replication solution to capture, transfer and integrate the financial transaction data from Oracle into HANA by using SAP SRS•Developed the ETL solution for financial risk data by using SAP BODS 4.0/4.1•Federated external securities data on MS SQL by using SAP HANA SDA•Developed financial risk reporting solution using SAP BO webi reports

•Architected and Developed Employee Gift Giving solution by using C#, SQL Server 2008R2, SSIS, SharePoint and PerformancePoint etc.•Developed Data Quality Management Platform by using DB2, SSIS, SSAS, PerformancePoint, KPI, Analytic Report,etc.•Developed Naviplan Audit Report solution by using C#, DB2, SQL Server 2008 and SSIS/SSRS.•Developed Anti-Money Laundering enterprise data warehouse and reporting solutions to provide the analysis on transaction monitoring, high risk account unit and name matching,etc.

Architected and Developed ETL solutions, VoltariConnect operational system and AnalyticsBackbone data warehouse platform.The AnalyticsBackbone is a core component of mobile predictive analytics platform (V-Connect) that provides on-the-fly optimization of campaigns by factoring real-time behavioral transactional data for higher engagement. It combines customer profiling, reporting, predictive modeling, scoring, mapping, targeting and suppression into an automated end-to-end process.

•Architected and developed the data warehouse/BI solution for non-standard automobile insurance and other niche and specialty insurance products.•Developed RTM Booking database and automated booking feeds loading.•Developed the processes for Insurance Bureau of Canada submission and related statistical reports

•Architected and led the development of data management web solution (DMT) to provide business users the ability to manage the trade data in an efficient, secure solution, •Architected and led the development of Dynamic RDLC Reporting solution (ASP.NET/C#, report viewer,Dynamic RDLC) to deliver the financial risk reports•Design and implement the ETL and BI solution for various Capital Market Risk, Credit Risk and Liquidity Reserve processes•Automated the ETL loading daily trade data (Summit, Calypso, Murex, WSS, etc...) into production data mart and also release monthly calculations of various risk factors, Profit & Loss (PL), Attribution, Domestic Fixed Income and Money Market Adjustments processes.•Designed and implemented the RVR Central Processing and Reporting database which contain configuration and settings for ETL components, also report definition.

•Architected and developed data warehouse for HomeDepot, ScotiaBank, etc•Designed and implemented database solutions for HomeDepot, RIM and ScotiaBank, HSBC, etc• Developed enterprise solutions for RIM, ScotiaBank, HSBC Canada, Nortel, Lexus, GM and Acura.