Prasanna V Mohan Kumar
Senior Data Engineering & Analytics Consultant
Summary
Prasanna has over 20 years’ experience in designing, implementing and managing end-to-end business intelligence, data warehousing and data discovery solutions. His competence is primarily built delivering multiple large-scale global data integration and business intelligence projects involving dimensional data modelling, data cleansing, data transformation, reconciliation, reporting and analytics including service delivery. His domain exposure includes fixed income, core finance, manufacturing and human resources.
His recent experience includes on-premise BI to cloud platform migration, implementing and managing data architecture, data preparation and machine learning solutions to enable advanced analytics working with seasoned data scientists.
Key Skill Areas
Data Management
Business Analysis
Data Visualization
Data Analysis
Data Architecture
Service Delivery
Dev Ops
Scrum
Cloud Analytics
Data Integration
Data Cleansing
Agile
Cloud Infrastructure
Process Improvements
Project Management
Experience
Technology Stack & Tools
Analytics: Qlikview | Qliksense | Tableau | Power BI
Data Integration: Informatica PC & DQ | SSIS
Data Stores: Sybase| Oracle| SQL Server| DB2 | Databricks | KDB | Splunk | PI
Cloud Solutions: Amazon Web Services – Solution Architect, Data Specialty
Scripting: PL/SQL | SQL | UNIX Shell | Python
Others: ERWIN| Autosys | JIRA | GIT | Perforce | Collibra | Terraform
Timeline
September 2023: Divine Stones, UK (Current) | Primary Role: Business Process Analyst
Key Deliverable: Business Process Workflow Automation (Zoho.com)
Responsibilities:
Detailed Business Analysis and Documentation.
Plan and Deliver RFQ to Invoice Automation.
User training and support.
Enhancements.
May 2022: Morgan Stanley, UK (10 Months) | Primary Role: Vice President – Technology (Full-Time)
Key Deliverable: BI Platform Migration (Qlikview to Power BI).
Responsibilities:
Business Analysis and Solutions.
Plan and Deliver Qlikview to Power BI (Azure Cloud) Migration.
Develop Python Based ETL Pipelines
Stakeholder Management
Offshore Team Management.
January 2020: Corning, Global (2 Years) | Primary Role: Senior Data Engineer (Full-Time)
Key Deliverable: Data Engineering Solutions, Advanced Analytics
Responsibilities:
Business requirement analysis
Design solution architecture
Develop analytics frontend
Develop data ingestion pipelines
Data validation and profiling automation
Deliver and support advanced analytics.
June 2019: Deutsche Bank, Ireland (6 Months) | Primary Role: Senior Visualization Engineer (Contractor)
Key Deliverable: Data Science activities including Feature engineering and Data sampling
Responsibilities:
Deliver data quality analytics for chief data office
Implement recommended machine learning models for enabling advanced analytics
Deliver data acquisition, preparation and data lineage presentation solutions
Cross functional team and stakeholder management
Agile project delivery.
February 2019: EmergeIQ, UK (5 Months) | Primary Role: Senior Data Architect (Contractor)
Key Deliverable: RFI Proposals & Data Integration Proof of Concepts
Responsibilities:
Business Analysis, Requirements Specification and Effort Estimation
New product initiatives
Build and deliver Proof of Concepts (Big Data ETL, ML, Cloud)
Stakeholder Management
Pitch for RFIs
March 2017: Morgan Stanley, UK (7 Months) | Primary Role(s): Senior BI Migration Consultant (Contractor)
Key Deliverable: Application Usage Analytics (Qlikview to KDB+/q Migration)
Responsibilities:
Study existing Qlikview deployment
Migrate QV setup to KDB(HDB) platform - Design, Build, Test & Deploy
Dashboards & Reports using Angular JS, Panoptican, Business Objects
Decommission Qlikview platform
Stakeholder management
April 2015: Morgan Stanley, UK (13 Months) | Primary Role(s): Senior BI Consultant (Contractor)
Key Deliverable: Deliver Security Analytics using Splunk and Qlikview/Qliksense
Responsibilities:
Security Analytics Dashboards - Design, Build, Test & Deploy
Threat Monitoring and Reporting
Implement Machine Learning Algorithms
Hadoop Big Data Querying and Data Analysis using Qlikview
Splunk Querying and Data Analysis using Qlikview
September 2014: HSBC, UK (7 Months) | Primary Role(s): Senior BI Architect & Consultant (Contractor)
Key Deliverable: Dashboards for post-trade process and reconciliation performance analysis
Responsibilities:
Qlikview server setup, administration & user management.
Review source (dimensional) data model and provide feedback
Dashboard Prototyping, Data quality assessment, data modeling (Qlikview)
Establish Qlikview development and deployment standards
Reusable/Configurable ETL (Qlikview) - Design, Build, Test & Deploy
Dashboards(Qlikview) - Design, Build, Test & Deploy
Performance tuning and troubleshooting
January 2014: JPMC, UK (7 Months) | Primary Role(s): Senior BI Architect (Contractor)
Key Deliverable: Setup Time Series Database & establish Trade Flow Analytics Platform (Pilot)
Responsibilities:
Source data qualification (reference data)
Timeseries Database Modeling (for RFQs and Quotes), normalization and deployment (OneTick)
Data Quality Assessment & Data Modeling
Infrastructure estimation and sizing
ETL (OneTick Graphs/T-SQL/Qlikview) - Design, Build, Test & Deploy
Reporting/Analytics Dashboards(Qlikview) - Design, Build, Test & Deploy
Performance tuning and troubleshooting, front desk support, user training
March 2010: Morgan Stanley, UK (3 Years 9 Months) | Primary Role(s): Senior BI Consultant (Contractor)
Key Deliverable: IRD & Trade Flow Reporting and Analysis Platform (Multiple Greenfield Projects)
Responsibilities:
Business Analysis, Requirements Specification and Effort Estimation
Source Analysis, Data Modeling and Data Mapping
Source Data Quality Assessment & Infrastructure estimation and sizing
ETL (Informatica/T-SQL/Qlikview) - Design, Build, Test & Deploy
Reporting/Analytics Dashboards(BO, SSAS Cubes, Qlikview) - Design, Build, Test & Deploy
Performance tuning and troubleshooting, front desk support, user training
May 2004: GE, Global (6 Years) |Primary Role(s): Project Lead / Data Quality Architect / BI Architect (Full-Time)
Key Deliverable: Process Stabilization, Service Delivery, Enhancements, Data cleansing, Lineage tracking and Greenfield EDW projects, BI Toolset consolidation and rationalization projects.
Responsibilities:
Manage BI production support involving 3 polar EDWs and 50+ Data marts with a 20 Member cross-functional global team across multiple locations.
Setup BI Delivery roadmap, Establish standards, Publish OpEx to CIO and work with regional business teams to deliver operational reporting.
Manage multiple change requests and enhancements.
Identify and Implement process improvements.
Education
Bharathiar University, India | Master of Applied Sciences – Computer Technology (2003)