Venkatesh Ramakrishnan

Architect for ADL Framework - Using DataBricks, Tableau and Python

Successfully rolled out a tested and easy to use architecture for all PODs to adopt

Introduced Medallion Architecture to transform the data

Setup guidelines for data storage and transformation in each layer of MedallionArchitecture

Part of technical governance group and responsible for signing off design before the PBIs are taken up for development

Implemented unity catalog as cataloging tool - UC acted as data dictionary - Automated catalog update e.g Field Definition, Tagging, PII etc

Designed Metadata capturing and Audit framework

Responsible for establishing Alert framework as a function for all PODs to utilize

Implemented DQ framework as part of CI/CD pipeline and integrated unit test cases to ETL using Nutter framework

Held a creator license and responsible for converting Hyper extract (In-Memory) based datasets to Live connection datasets - saved significant time and cost as part of this initiative

Responsible for consolidating Master data

Architect for ADL Framework - Using DataBricks, Tableau and Python

Successfully rolled out a tested and easy to use architecture for all PODs to adopt

Introduced Medallion Architecture to transform the data

Setup guidelines for data storage and transformation in each layer of MedallionArchitecture

Part of technical governance group and responsible for signing off design before the PBIs are taken up for development

Implemented unity catalog as cataloging tool - UC acted as data dictionary - Automated catalog update e.g Field Definition, Tagging, PII etc

Designed Metadata capturing and Audit framework

Responsible for establishing Alert framework as a function for all PODs to utilize

Implemented DQ framework as part of CI/CD pipeline and integrated unit test cases to ETL using Nutter framework

Held a creator license and responsible for converting Hyper extract (In-Memory) based datasets to Live connection datasets - saved significant time and cost as part of this initiative

Responsible for consolidating Master data

Telefnica UK Limited is a telecommunications, Internet and financial services provider in the United Kingdom owned by Telefnica. It is the second-largest mobile telecommunications provider in the UK at present

Cognizant was engaged to transform their BI platform which was executed using AbInitio, Teradata and MicroStrategy.

Played BI Architect role

Engaged with customers to better understand needs and deliver excellent service.

Customized customer experiences to build brand loyalty.

Responsible for setting up a semantic layer on top of CLDM architecture

Created reports and dashboards with optimal performance to handle high volume of data like CDRs

Involved in conceptualization, Requirement Gathering, Impact Analysis and Data Modeling

As a MicroStrategy Architect, involved in Auditing other Projects executed in MicroStrategy environment and provided valuable feedback to improvise

Trained and mentored employees to maximize team performance.

Supported MicroStrategy version upgrades and acted as liaison for MicroStrategy Inc.Support team

Successfully implemented best practices and design techniques to improve reports and

Dashboard performance

O2 is a telecommunications, Internet and financial services provider in the United Kingdom owned by Telefnica, It is the second-largest mobile telecommunications provider in the UK at present

HP was engaged to migrate the legacy DW application from Ab-Initio/ Oracle based solution to high performance Ab-Initio/Teradata solution and implemented 'Nucleus' (Transformed BI Platform) based on CLDM model using Ab-Initio as ETL tool, Teradata as database and MicroStrategy as Enterprise BI tool.

Was part of the Nucleus engagement for a long time and performed various roles such as Teradata Senior Developer, MicroStrategy Analyst, Data Quality Lead and Operations lead

Primarily focused on Presentation layer development as a Senior Teradata Developer

Responsible for tuning the applications for optimal performance

First point of contact for data issues and data quality issues

Volunteered to learn MicroStrategy to assist report analysis and got certified as a MicroStrategy Architect

Implemented DQ dashboard to highlight data issues before users identify and automated reconciliation of Source and data warehouse KPIs

Worked on Reports and Dashboard enhancements

Tesco plc is a British multinational groceries and general merchandise retailer headquartered in Welwyn Garden City, England

In 2011, it was the third-largest retailer in the world measured by gross revenues and the ninth-largest in the world measured by revenues

Infosys handled implementation of CRST (Commercial Ranging Support tool) and SRS

(Group MIS)

CRST - Tool to handle the exceptions occurring in stores with respect to the product allotments by business analyst and also to predict the product requirement in store and to decide when a particular product can be launched and when a product should be reduced/removed from display GMIS-GMIS is a suite of jobs to monitor the sales, waste and store attributes to report the data warehouse.

Responsible for preparing design and impact analysis document

Created BTEQ script to transform data

Created FLOAD/ MLOAD/ FastExport script to load and unload data

Successfully prepared schedule for 1000+ jobs for a major migration activity

Spearheaded UAT phase of the CRST project from customer location

The Munich-based Versicherungskammer Bayern (VKB) Group is the largest public insurer of personal and property insurance in Germany

Versicherungskammer Bayern Versicherungsanstalt des ffentlichen Rechts' as a parent company performs the function of holding company for the Group

In addition, as a primary insurer it conducts insurance business with local authorities and other public institutions in Bavaria and Palatinate

The VKB Group is integrated into the Sparkassen-Finanzgruppe and is therefore part of the largest association of financial service providers in Germany

It belongs to the group of public insurers, that together rank second in the German primary insurance market.

Worked a COBOL developer to develop and maintain the BEKO application

Worked on creating one off scripts to perform data fixes

Developer code in Xcobol, software which assists in creating object oriented program and in turn converts the same to COBOL equivalent