Key Contributor in many including:- Data Architecture and Governance Department setup- Developed Data Models for hundreds of Datasets for Abu Dhabi Government Entities, Semi government and private entities- Auto Data Modeling - Automation of Data Models development - Automated multi-layer Data Modeling key project tasks with zero technology cost saved Time, Effort and Resource to great extent.- Data Governance – Metadata Management, Data Quality, Data Privacy… Show more Key Contributor in many including:- Data Architecture and Governance Department setup- Developed Data Models for hundreds of Datasets for Abu Dhabi Government Entities, Semi government and private entities- Auto Data Modeling - Automation of Data Models development - Automated multi-layer Data Modeling key project tasks with zero technology cost saved Time, Effort and Resource to great extent.- Data Governance – Metadata Management, Data Quality, Data Privacy, Data Security, Reference Data Management, Data Masking, Data pseudonymization- Erwin suite implementation across Departments – Erwin Data Modeling, Erwin Mart, Erwin Portal setup, training, rollout organization wide- Informatica EDC (Enterprise Data Catalog) and Data Profiling / Data analyst tools setup, training and rollout across departments- Innovatively implemented Unified Data Model for processing many and different datasets like Aggregate, Statistical Values, KOIs KPIs, Surveys, etc. in single unified integrated model- Policies and Procedures for Data Architecture and Governance Department responsibilities and deliverables. Including Unify Naming Standards, Principles, Best Practices, Checklists, Authority Matrix, etc.- Modernization of Data Warehouse by Technology transformation, Process transformation, Data transformation. NSSD and ADRC national and international data standardization- Contribution to Registers, Surveys, Opinion Polls, etc. – by developing Design Blueprint, Design principles, High-level and Low-level designs, Data Architecture, Data Modeling, Data flow, etc.- Exploring new technologies and trends, performing fitment assessment, POC development and technology implementation for - IBM Data Fabric, Data Virtualization, Data Synthesis, Non SQL Databases, Azure Devops Show less

Contributing and managing Data Warehouse which includes MIS, Analytics, Advanced Data Visualization, Banking Regulatory reports, Performance Tuning, Automation, RPA / BOT, Data Modeling, Loyalty program implementation, Microsoft Dynamics, Vendor Management, Tens of upstream and downstream systems, Data Quality, Reports Optimization, Real Time Reports, big size Database and critical Data Extracts

Migration from On-premise to Cloud. 25+ TB size Data Migration and 5000+ Database objects Migration From IBM Netezza to Microsoft AZURE SQL Data Warehouse (MPP).Saved cost of Migration Tools and Data Integration Tools.• 25 TB of Data• 30+ Databases• 4000+ Tables• 1000+ Stored procedures• 1000+ Views• Developed Automation Script for STORED PROCEDURES and VIEWS Migration from Netezza to Azure SQL DWH• Developed Automation Script for generating Azure Polybase… Show more Migration from On-premise to Cloud. 25+ TB size Data Migration and 5000+ Database objects Migration From IBM Netezza to Microsoft AZURE SQL Data Warehouse (MPP).Saved cost of Migration Tools and Data Integration Tools.• 25 TB of Data• 30+ Databases• 4000+ Tables• 1000+ Stored procedures• 1000+ Views• Developed Automation Script for STORED PROCEDURES and VIEWS Migration from Netezza to Azure SQL DWH• Developed Automation Script for generating Azure Polybase Script each Table for DATA MIGRATION from Netezza database to Azure Blob Storage to SQL DWH Tables• Developed Automation Script for Tables Structure Migration, Data movement and DATA VALIDATION post migration to Azure. Show less

As a Senior Consultant - helped India, Middle East and other region clients in the areas like Big Data Architecture, Data Governance, Analytics, Business Intelligence Reports, Data Integration, Data Migration, Data Modeling, EDW, DWH, ETL, BI, RFPs, Performance Tuning, Requirement gathering, Solutioning, Architecture Review, Design Review, Data Model Review, Code Review, Estimation, Solution Plan, Project Plan, Resource Plan, SME Review. MY ARTICLES in LinkedIn - 21+… Show more As a Senior Consultant - helped India, Middle East and other region clients in the areas like Big Data Architecture, Data Governance, Analytics, Business Intelligence Reports, Data Integration, Data Migration, Data Modeling, EDW, DWH, ETL, BI, RFPs, Performance Tuning, Requirement gathering, Solutioning, Architecture Review, Design Review, Data Model Review, Code Review, Estimation, Solution Plan, Project Plan, Resource Plan, SME Review. MY ARTICLES in LinkedIn - 21+ Articles:How to Improve your Business Intelligence?https://www.linkedin.com/pulse/how-improve-your-business-intelligence-raghavendra-narayana/Still Not Automated Your Data Quality Checks – waiting for 2200? | Automation of Data Quality Checkshttps://www.linkedin.com/pulse/still-automated-your-data-quality-checks-waiting-2200-narayana/“Current+Recent+History” = Data Analysishttps://www.linkedin.com/pulse/current-recent-history-data-analysis-raghavendra-narayana/Few of the assignments at high level is below:RETAIL CLIENT - Data Architect, Big Data Architect, Data Modeler, Microsoft Azure Suite, develop platform and productTools: Using MICROSOFT AZURE Suite for Big Data like Azure Data Lake, Azure SQL DWH, Azure Data Lake Analytics, Azure Logic Apps, Azure Data Factory, NoSQL / U-SQL, structured unstructured dataCustomer Engagement PLATFORM - Customer Analytics and Single Customer View. Data Management PLATFORM - Data Store, NoSQLData Intelligence PLATFORM - Analytics and Artificial Intelligence BANKING CLIENT – Evaluate the existing Data Warehouse and Datamarts to understand the need and benefits of creating Enterprise Data warehouse MANUFACTURING CLIENT - Understand the Analytics and BI Reports requirement, help client to decide on Tools to be used by identifying the Parameters that should be considered.BANKING CLIENT - Understanding, Estimation and Solution plan for Data Model migration from Legacy design to Data Lake design to support data loads to current and future systems. Show less

Business Analyst - IT Directorate, Qatar Foundation, Doha, Qatar. Through HCL Infosystems MEA.Prepare Business Requirements based on the IT needs of different Directorates of Qatar FoundationMeet Business Users and IT Managers from different Directorates, understand software requirements, plan end to end steps from requirements gathering to solution implementation.Product evaluation and Vendor evaluation. Solution fitment by evaluating available products from Vendors for… Show more Business Analyst - IT Directorate, Qatar Foundation, Doha, Qatar. Through HCL Infosystems MEA.Prepare Business Requirements based on the IT needs of different Directorates of Qatar FoundationMeet Business Users and IT Managers from different Directorates, understand software requirements, plan end to end steps from requirements gathering to solution implementation.Product evaluation and Vendor evaluation. Solution fitment by evaluating available products from Vendors for procurement Show less

BI Architect - Business Intelligence Transformation Program. Vodafone Qatar, Doha, Qatar. Through HCL Infosystems MEA.Written Proposal / RFP (Request For Proposal) for BI Transformation program. End to end cycle of RFP from Pre-RFP to Vendors Response assessment & rating.Assessed the existing Business Intelligence landscape for transforming the system to achieve better Data Insight and to align with industry standards.Performed Gap Analysis and defined BI Roadmap for… Show more BI Architect - Business Intelligence Transformation Program. Vodafone Qatar, Doha, Qatar. Through HCL Infosystems MEA.Written Proposal / RFP (Request For Proposal) for BI Transformation program. End to end cycle of RFP from Pre-RFP to Vendors Response assessment & rating.Assessed the existing Business Intelligence landscape for transforming the system to achieve better Data Insight and to align with industry standards.Performed Gap Analysis and defined BI Roadmap for Data Management, Data Integration, Information Delivery, Analytics, Hardware & Architecture, Internal Governance and BI Strategy Areas.Provided different options for solution along with pros and cons to handle Budget, Schedule, Business priorities and constraints.Defined Internal Governance for initial phase of BICC (BI Competency Center) implementation. Show less

Building competency in Big Data, NoSQL, Splunk, MongoDB, HiveBuilding competency in Advanced Data Visualization Tableau, Qlivview, SpotfireDefine BI strategy for Client, provide BI RoadmapUnderstand Client’s DWH and BI requirements and challenge areas, define Client specific roadmaps, be partner with Client in executing the defined strategyContribute to the Growth of DWBI Technical Expertise Talent pool and Process maturity

BI Consultant, DWH Consultant, ETL Consultant, Database Consultant, BI Solution Architect, Data Architect, Data Modeling, Dimensional Modeling, Datawarehouse and Datamart developmentSubject Matter Expert Review, Defining Technology Roadmap, Defining BI Roadmap, Defining Processes and Best practices.Training, Planning, Training content development, Technical Proficiency Growth, Technology Growth, Explore new technologies, Demos, Proof of Concept, Planning of Technology… Show more BI Consultant, DWH Consultant, ETL Consultant, Database Consultant, BI Solution Architect, Data Architect, Data Modeling, Dimensional Modeling, Datawarehouse and Datamart developmentSubject Matter Expert Review, Defining Technology Roadmap, Defining BI Roadmap, Defining Processes and Best practices.Training, Planning, Training content development, Technical Proficiency Growth, Technology Growth, Explore new technologies, Demos, Proof of Concept, Planning of Technology growth, reusable assetsHighlights:Data Architect for Pharma client - Played Data Architect Role for a Pharma client at Onshore (USA). Client interaction to understand the requirement and providing Datawarehouse and Datamart solution for SQL Users. Involved Master Data Management.BI SME for Telecom client – Daily Data load of ETL was taking more than 24 hours. Assessment and reducing the cycle time to 7 hours by tuning Architecture and SQL code.Open Source Database Evaluation – Interacted with Product Architects from Open Source Databases like MySQL, Ingres, Postgres, Infobright. Provided Gartner kind of evaluation assessment. Contributed to the start of Open Source Capability in AccentureLarge Steel Manufacturer – It is an Oracle BI Applications out of the box implementation with large customization. Client was implementing Financials, SCM and HR modules. BI Development activities for 3 Releases are happening in Parallel. Managed complexities in client expectations, timelines, standards, staffing, onshore / offshore co-ordination.Large Retail Client - Contributed to the Planning and Analysis of Oracle BI Apps modules. Handled complexities in understanding the requirements from Users working on legacy applications having less or no knowledge in BI kind of ReportsBuilding SME Team – 30+ resources BI SMEs who can work on high-end technical tasks Show less

Technologies:MS SQL Server, .NETRoles / Responsibilities:Data Architect, Data Modeler, Database LeadHighlights:TSYS Product – Architected and developed a product for TSYS on Bank Credit Card workflow process. Architected and Modeled the Database portion. Designed and contributed in Coding. Managed a team of Designers and Developers.

Technologies:Oracle, OWB, PL/SQL, OLAP + OLTP, Java, Rules EngineRoles / Responsibilities:Data Architect, Data Modeler, Technical Leader, Team LeaderPerformed ETL Architect, Data Architect, Data Modeling, Metadata Modeling, PL/SQL Coding activities Highlights:iMintPoints is a loyalty product developed in collaboration with US company. It is a rewarding program for the activities of Loyalty card holders based on the various campaigns running on HISTORICAL/… Show more Technologies:Oracle, OWB, PL/SQL, OLAP + OLTP, Java, Rules EngineRoles / Responsibilities:Data Architect, Data Modeler, Technical Leader, Team LeaderPerformed ETL Architect, Data Architect, Data Modeling, Metadata Modeling, PL/SQL Coding activities Highlights:iMintPoints is a loyalty product developed in collaboration with US company. It is a rewarding program for the activities of Loyalty card holders based on the various campaigns running on HISTORICAL/ FUTURISTIC/ RECURSIVE DATA. As a first member in the project, involved from initial meeting with client till the release of Product The project required combination of OLAP and OLTP concepts in the Architecture. A Flexible and Extendable Datamodel / Meta Datamodel developed to avoid any changes in code. Rules engine developed in Java required to be run during ETL Data load still demanding the lesser time windowTo crosstrain ETL Tool developers to PL/SQL Code Developers was challenging task, handled a team 10+ members by owning the complete delivery of Design and coding as well Show less

Technologies:Oracle, MS SQL Server, Sybase, Microsoft Studio 6.0, .NET, Java, IBM MQ Series, PL/SQL, Crystal ReportsRoles / Responsibilities:Coding, Module Lead, Data Modeler, Testing, Release Management.Highlights:Picked up multiple technologies in quick turnaround, handled development and delivery in variety of Databases and ApplicationsInvestment Banking projects involved complex data validation and data transformations logics in PL/SQL code while… Show more Technologies:Oracle, MS SQL Server, Sybase, Microsoft Studio 6.0, .NET, Java, IBM MQ Series, PL/SQL, Crystal ReportsRoles / Responsibilities:Coding, Module Lead, Data Modeler, Testing, Release Management.Highlights:Picked up multiple technologies in quick turnaround, handled development and delivery in variety of Databases and ApplicationsInvestment Banking projects involved complex data validation and data transformations logics in PL/SQL code while consuming data from different data providers, required flexibility in adding additional data providers. Written Articles, won Microsoft Community Star Award, PlanetSourceCode Award, Book published. Show less