SUMMARY:

• An experienced BI Technical Manager / Sr. Data Architect with more than a decade (14+ years) of experience in managing dev teams, developing and migrating BI, Analytics, data warehouse, data stores along with third party system integration and data migration on Microsoft technology stack (C#, SSIS, Power BI premium service, Azure Analytics).
• Also experienced in Agile Program management, translating user stories for sprints into techno - functional deliverables; technical and functional specifications, stakeholder management, Process re-engineering, change request management and project delivery.
• 14 years of IT experience, with over 10+ years as senior consultant in Data visualization, Analytics, Insights and BI technologies
• Advanced knowledge of need and usage of Azure tools for data insights and visualization including Azure Data lake, Cosmos DB, Azure Data Factory v2, SQL DWH, Power BI, azure stream analytics, function apps, chatbot, logic apps, data bricks, machine learning build and storage of data for big-data applications, creation of Azure Data Lake Analytics (ADLA) applications using Visual Studio, C#, SQL and USQL, Logstash, Kibana, App Insights.
• Managing day-to-day operational aspects of project, developers, architects project scope, minimizing risk, effective delegation, managing project budget, high expertise on stressed data projects with compressed schedules and low or no contingencies
• Application, database and infrastructure architecture design for Digital platforms, security, system integration, offshore project management.
• Liaising as a Technical SME in migrating to Microsoft tech landscape, designing the high level architecture, data modeling, ETL and Reporting
• In depth knowledge of Banking Trade lifecycle, Fixed Income (Bonds, Repos, MTNs), OTC Derivatives, Forwards, Futures, Swaps and Equities
• Deep understanding of Chart of Accounts, Balance sheet, PnL accounting, Retail eCommerce reporting and Contact Centre Reporting

WORK HISTORY:

Confidential

Principal Azure Data Architect

Responsibilities:

• Advising and engaging with multiple CxO level stakeholders, providing strategic direction in Azure implementation with a focus on azure data platforms
• Hands-on implementation in multiple projects, advising senior architects and developers on project rollout and phasing of projects.
• Development of cloud architecture diagrams and building proofs of concepts on proposed architecture
• Hands-on development, interviewing and mentoring of other team members

Confidential

Responsibilities:

• Building and leading the BI & Analytics team from the ground up. Primarily focused on Microsoft Azure features with providing ETL, Azure Power BI service deployment to 1000s of users, API integration with multiple teams, solution for azure chat bots using AI for simple customer questions, azure log analytics of systems, KPIs
• Led team of 12 developers, technical solution guidance to developers, Proof of Concepts
• Led multiple projects with successful saving of 500k-1mil+ cost saving per project
• Hands-on development, interviewing and mentoring of other team members

Senior BI Manager/Consultant

Confidential

Responsibilities:

• Project saving of 200k+ for process re-engineering
• Integrate Forensics and Malware team into Cyber Threat SQL DB and analytics reporting using Power BI
• Integrate iZoolgic and NetCraft JSON API on azure stream analytics
• Extensive use of Power BI, SQL Server Profiler, Azure Data Lake and Data Factory

Confidential

Technical Lead BA

Responsibilities:

• Design and prepare MIFID II reporting data architecture for XP Investimentos for transaction reporting using Microsoft SSIS, SSRS.
• Roadmap for IT change upgrade, transaction Reporting analysis on MIFID II, analysis of the projects and work streams impacted due to MIFID II requirements

Confidential

Responsibilities:

• Led the transaction Reporting analysis on MIFID II, analysis of the project and work streams impacted due to MIFID II requirements, implementation using Azure Data factory using SSIS transforms, SPs in SQL Server using TSQL and some C#
• Prepare high level design document for finance (agresso) and treasury TMS (quantum) trading projects; presenting these to steering committee, architectural and design authority groups

Confidential

Responsibilities:

• Helped to setup the Treasury to respond to MIFID II change program and setup Asset Liability Management & MIFID II reporting for the proposed new bank, using Power BI, SSRS, SSIS, FTP data feeds.
• Analyze requirements, prepare specs (BRD, FSD, mapping), segregate assets not required in the new bank and obtain sign-off from key users
• Liaise with SME and analyses the trade feeds from Calypso and Wall Street and check for defects, update data mapping document if needed, code the required aspects in SSIS and TSQL

Confidential

Responsibilities:

• Manager of the BI, Data Warehouse and Data Visualization implementation project on Dynamics AX 2012 integrating all data warehouse and BI components with Dynamics AX.
• Scoped, designed and built the DW on AX 2012, included finance and project management modules
• Planned and built the SSAS Cube on SQL DW
• Created the SSIS load mechanism including enabling replication and CDC

Confidential

Responsibilities:

• Microsoft Dynamics migration project to migrate Accounts and finance data from Microsoft ERP 2009 to 2012.
• SSIS packages / SSRS reports and Stored Procedures migration from AX 2009 to 2012

Confidential

Responsibilities:

• Led the Data Warehouse and reporting implementation with 6 developers
• Designed the end-to-end data flow specifications in SSIS, SSRS and SPs for data coming from CRM, ERP and Charging Systems from Ericsson, Huawei and Siemens to the reporting applications

Confidential

Responsibilities:

• Key senior member of the DW team at RBS Treasury to integrate Asset and Liability Management for Liquidity and Interest Rate Risk and Hedge positions as required.
• Liaise with different business units like Ulster, NatWest and capture their treasury liquidity requirements from Workshops, MoM and prepare specs for sign-off
• Good understanding of Front to Back office Trading workflow and liaising with Front Office Calypso IT to import Bonds and Swaps trade data
• Migrating legacy data from Sybase Unix environment to SQL Widows, extensive use of both TSQL and ISQL

Confidential

Responsibilities:

• Led the Confidential wide contact center reporting initiative for DW and Data visualizations Modified the Architecture design for the system implementation to include new ETL mechanism and reporting formats
• Support Confidential call center system in creating, estimating and planning for migration to ICRS system and analyzing the knock-on effects for the IP&R team

Confidential

Technical Architect

Responsibilities:

• Prepared BRD and FSD for database solution architecture and ETL components for data warehouse
• Created FSD and mapping for Migration of Standard Settlement Instructions (SSI) for own Nostros and CPTY accounts, Importing Nostros, Swift codes and Messaging types (MT202, MT210, MT950 etc.)