Vikas Pillai Email & Phone Number

Guelph, Ontario, Canada

Toronto, Ontario, Canada

Toronto, Canada Area

• Responsible for understanding requirements, conducting impact assessments, designing the databases, ETL process & front-end application layers, coding, unit testing and providing technical solutions • Perform integration of customer-related data from different sources like CSV files, PostGreSQL database, AWS cloud database and load the transformed data into Data Marts/Data warehouse• Load the transformed financial data (Accruals, Actuals, and Purchase orders) as batches into the… Show more • Responsible for understanding requirements, conducting impact assessments, designing the databases, ETL process & front-end application layers, coding, unit testing and providing technical solutions • Perform integration of customer-related data from different sources like CSV files, PostGreSQL database, AWS cloud database and load the transformed data into Data Marts/Data warehouse• Load the transformed financial data (Accruals, Actuals, and Purchase orders) as batches into the financial ERP system• Conduct system testing and deployment activities for ETL packages and database scripts• Develop financial reports including Trip Profitability, data validation reports, month-end reports, cost and revenue differences using Looker, Power BI, Excel, office 365• Actively participate in Daily Scrum, Sprint Planning, Review & Retrospective sessions (Agile) and provide insight into progress and difficulties faced in a particular user story/ task• Design and develop databases for new SSAS cubes, SSIS packages for data warehousing and reports using SSRS• Develop interactive dashboards reports and data visualizations to interactive with end-user using Power BI with Power View, Power Pivot, Power Query• Perform the database migration including migrated existing BI solution to cloud (Azure) and automation using Python• Manage the DBA activities on PostgreSQL and SQL Server including regular backups, performance tuning, change implantation and DR (disaster recovery) activities• Perform BI production development, test, deployment on Dev, UAT, Production environment and provide 24 * 7 hours Level 2 and 3 application support for all the upstream and downstream applicationsEnvironment: AWS, Postgres 9,10,11, SQL Server 2012, 2008, GitHub, PowerShell, PowerBI, Clickup, Trello, Python, Trello, Click up, Query Analyzer, Enterprise Manager, SQL Profiler, Index Tuning Wizard, BI Stack (SSIS, SSAS, SSRS), Microsoft Business Intelligence Studio, ETL, C#, MS Excel) Show less

London, England, United Kingdom

Client: GlaxoSmithKline – London, UK (Pharmaceutical & Life Sciences)RPA & BI Consultant• Performed end to end RPA Development including feasibility analysis, requirement gathering, prepared function design document, technical design document• Developed SSIS packages, SSRS reports, SSAS cubes, crystal reports, and performed SQL Server Database performance tuning & maintenance• Developed ad hoc reports and performed data analysis using Tableau, Power BI, Azure Databricks on the… Show more Client: GlaxoSmithKline – London, UK (Pharmaceutical & Life Sciences)RPA & BI Consultant• Performed end to end RPA Development including feasibility analysis, requirement gathering, prepared function design document, technical design document• Developed SSIS packages, SSRS reports, SSAS cubes, crystal reports, and performed SQL Server Database performance tuning & maintenance• Developed ad hoc reports and performed data analysis using Tableau, Power BI, Azure Databricks on the cloud platform.Client: Barclays Bank PLC – London, UK (Banking/Financial Services)RPA/BI Consultant• Created POC with RPA tool BLUE Prism to automate all excel and backend manual tasks• Worked on end to end development of Credit Risk Data Warehouse/Wealth Management data and built Datamart for credit risk data for analyzing investors’ funds for risk exposure, financial returns, liquidity and leverage using Power BI, Excel, BI stack (SSIS, SSRS and SSAS)• Performed the development and maintenance of internal portal build on .Net framework (ASP.net, C#)Client BUPA Insurance – Brighton, UKMS Azure/BI Developer• Performed the data migration from enterprise Datawarehouse (on-premise database, CSV files, media files, etc.) to MS Azure (Cloud)• Developed a Data warehouse on Azure loud using SSIS, Azure data factory, PowershellClient: British Petroleum – London, UK (Oil & Gas)Programmer Analyst• Developed MVaR calculation and forecasting using Matlab and .Net and loaded the calculated values into the database using SSIS and C# for NAGP trading portfolio• Developed and maintained a front-end GUI for the business users to upload the raw files, to trigger the calculation of Value at Risk (VaR) and loaded the calculated VAR (Value at Risk) into database and cubes• Developed SSRS reports using Dundas chart with in-depth data analysis to provide portfolio analysis on supplementary risk measurements such as stress test, back test, liquidity VaR Show less

Mumbai Area, India