Work History
Education
Skills
Summary
Work Preference
Accomplishments
Timeline
Generic
Manjunath G.B

Manjunath G.B

Data/BI Engineer
Leeds,Yorkshire

Work History

Expert BI Engineer

Aeries Technology Group
Bengaluru
2023.May - 2023.Sep
  • Data Modeling: I assumed a Senior Data Modeler role in the implementation of Data Models for ODS transactional data system, which played a pivotal role in elevating Alegeus Technologies production data decision making by up to 50%. This achievement not only led to considerable cost reductions but also contributed to a marked enhancement in overall operational efficiency.
  • Analyze the data available in ODS System, Develop Erwin data models using Erwin Data Modeler 12.2, Generate Materialized SQL views, Dimensions, Fact tables SQL scripts and share this with pipeline team to create pipelines in Azure data bricks
  • Architect Data-warehouse solution by interacting with OLTP business team, designing models as per reporting requirement in Power BI, Design and implement slowly changing dimension type 2
  • Successfully handling of tickets in Azure DevOps, managing various versions in Git, and Implementation of CI/CD tasks.
  • Spearheaded Offshore Data Modeling Team in delivering NextGen Data Platform solutions.
  • Data Engineering & Data Management: Proficient in creating tailored Data Engineering Pipelines across Azure, and Snowflake, optimizing storage and compute layers, establishing Data Lakes and Lake Houses for Data Integration and Machine Learning, and enhancing data governance with MDM through data mesh and fabric architectures.
  • Self-motivated, with a strong sense of personal responsibility.
  • Managed time efficiently in order to complete all tasks within deadlines.
  • Proven ability to learn quickly and adapt to new situations.
  • Worked well in a team setting, providing support and guidance.

Senior Technical Specialist

Datavail Infotech India Pvt. Ltd, Microsoft
Bengaluru
06.2020 - 01.2023
  • Mountain West Azure Data Platform with Synapse Analytics: Implemented Azure architecture at a prominent Mountain West Insurance company significantly improved operational efficiency and Claims resolution in a leading North American Insurance institution by enhancing scalability, real-time data access, and Insurance system integration. Azure bolstered data security and compliance while centralizing Insurance data, ensuring secure storage, real-time insights, and cost savings, with Azure Synapse being widely utilized for advanced analytics and data sharing
  • Data Integration: Analyze the data available in Guidewire system and migrate data to Azure Data Lake through pipelines in Azure Synapse Analytics CreationofCDAJob to stage data from amazon S3 to Azure Data Lake
  • Development of Azure database in built in SQL Pool and Dedicated SQL Pool to load parquet files from guide wire system
  • Development of integration pipelines to generate general ledger output files and others for finance team.
  • Monitor pipelines execution through daily schedule, fix in case of any failures/errors.
  • Designing Tableau Dashboards/Reports for a retail customer based on data available in different source systems, Developed Purchase Order Dashboard, Finance Monthly Dashboard, and Others.
  • Migration of Legacy CRM data to Microsoft CRM system using Azure Data Factory. Created pipelines to perform copy data activities.
  • Designing Power BI reports to validate data from source system versus data loaded to Microsoft CRM.
  • Researched and adopted new technologies to add value to existing offerings.
  • Investigated system issues and implemented resolutions to reduce downtime.

Technical Architect

Maxim Integrated, Inc
BENGALURU/SAN JOSE
01.2016 - 05.2020
  • Enterprise Data Warehouse(EDW): Developed database modeling architecture for a leading semiconductor company that represents a robust and scalable framework tailored to the unique needs of data analytics. This architecture seamlessly integrates structured and unstructured semiconductor parts data, ensuring efficient storage, retrieval, and analysis while maintaining data integrity and compliance with american regulations. By employing advanced database modeling techniques, this system empowers the company with real-time insights, demand planning, sales opportunities and improved operational efficiency, ultimately enhancing the overall quality of manufacturing capability services in semiconductor fab.
  • Involved in designing SQL database, ETL Packages using Microsoft SSIS and Data warehouse using Microsoft SSAS multidimensional cubes.
  • Entrusted with the responsibilities of designing: Sales opportunities dashboard by connecting to SSAS Cube in Tableau 20.2, Vendor spend query tool using VBA by connecting to vendor spend data mart SSAS cube.
  • Aligning architecture to business strategy in order to deliver structured, Client, sustainable and adaptable IT solutions in line with the business need
  • Analyze the data available in SAP ERP system and migrate data to Microsoft SQL Data warehouse through SSIS and then designed vendor spend cube using SSAS by creating dimensions and fact tables in SQL.
  • Collaborated with clients to determine project specifications and scope.
  • Improved business productivity for clients by 60% by re-engineering and designing infrastructures.
  • Database Performance Tuning: At Maxim Integrated, I played a pivotal role in optimizing database performance across various database servers, including SQL Server, SAP HANA and Oracle. This involved fine-tuning database configurations, query optimization, and proactive monitoring to ensure efficient and responsive data management systems.
  • Participated in system development life cycle from requirements analysis through system implementation.

Technical Lead

Genpact
Bengaluru
01.2014 - 01.2016
  • Lead end-to-end projects right from requirement analysis, client interaction, documentation, requirements translation to developers, QA and UAT testing, responsibilities assignment, Scrum calls to go-live assistance
  • Deliver business requirements documents, functional specifications and technology solutions Coordinate in business analysis sessions to understand client process and conduct trend analysis to understand user needs and translate them into technical solutions that save time, eliminate redundancies and improve quality Assess different systems, conduct gap, feasibility & risk analysis and propose various profitable options & new systems for the business to senior management
  • Data Solutions and Stakeholder Management: Teamed up with the McKesson Global Data Centers department to innovate health care solutions for their customers, ultimately boosting satisfaction levels and trimming costs. I proficiently communicated the introduction of new features to healthcare operations teams, oversaw application performance, led user acceptance testing, and delivered training to enhance efficiency, resulting in significant cost savings.
  • Database Performance Tuning: At Genpact, I played a pivotal role in optimizing database performance across various database servers, including SQL Server, and Oracle. This involved fine-tuning database configurations, query optimization, and proactive monitoring to ensure efficient and responsive data management systems.
  • Provide clear & concise analysis/recommendations by analyzing key business requirements and develop, support & enhance business solution software
  • Analyzing, executing & overseeing implementation of corporate & business-oriented software / applications
  • Ensuring delivery of quality services to client
  • Data Analysis and Reporting: Analyze the data sent by the client and design the database per the client requirement and upload the raw data into the database using SSIS and then design cube using SSAS by creating dimensions and fact tables, Developed Analytical solutions to worlds second largest brewery i.e., South African Breweries. . Once the adhocs report data is good in Marketing Insights Application and
    got approval from client. I have designed the several custom reports using SSRS.

System Analyst

Fidelity Business Services India Private Limited
Bengaluru
11.2011 - 12.2013
  • Meeting with technology managers and the design team to discuss the goals and needs of the company examining and defining current architecture systems.
  • Collaborating with cross-functional development team members to analyze potential system solutions based on evolving client requirements
  • Development of ETL packages using SSIS, Creation of SQL Database, Objects such as Stored Procedures, Functions, Views, and Indexes.
  • Involved in optimizing performance of SQL queries, and Stored Procedures.
  • Development of SSRS reports based on custom report requirement
  • Enhanced interfaces to promote better functionality for users.
  • Performed system analysis, documentation, testing, implementation, and user support for platform transitions.

Software Engineer

Theorem India Pvt. Ltd
Bengaluru
11.2007 - 11.2011
  • Data Analysis and Reporting: Involved in SQL database creation and Data-warehouse designing, Data Models, and SSAS Multidimensional cubes to promote various clients business needs through Theorem Analytics Software
  • Developed robust self service reporting platform for Hilton, Double Tree Hotel suites using SSRS
  • Data driven subscription to deliver the reports directly to customer Inbox
  • SSRS reports using MDW queries and use Lookup function to combine data from to 2 different data source system
  • Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
  • Development of ETL Packages using Microsoft SSIS
  • Involved in optimizing slowly running SQL queries, writing complex T-SQL procedures
  • Tested and deployed scalable and highly available software products.

Education

Bachelors in Engineering - Electrical And Electronics

Dr Ambedkar Institute of Technology
Bengaluru
06.2001 - 06.2005

Skills

  • Big Data Ecosystems

Microsoft Azure HDInsights, Apache Spark, Snowflake, Tableau

  • On-Prem Data Warehouses & Virtual Data Warehouses

Microsoft SQL Server, SAP HANA, Snowflake, Azure Synapse Analytics,Databricks Delta Lake

  • Data Lakes

Azure Data Lake Storage

  • ETL & ELT

Microsoft SSIS, Azure Data Factory, Snowflake

  • Machine Learning

Python, Jupyter Notebooks, Azure Synapse, Snowflake, Azure Databricks

  • Artificial Intelligence

Azure Machine Learning, Azure Databricks

  • MLOps & AIOps

Azure Machine Learning, Databricks, Azure DevOps,

Data Engineering

SQL, SnowSQL, Python, Scala, ETL/ELT processes, Data pipelines, Data transformation, Data integration;ETL/ELT (Apache Spark), Stream processing (Apache Kafka)

  • Data Management

Data cataloguing, Business Glossaries, Master data management, Data lineage, Data quality management ; Azure Data Catalog

Data Governance & Compliance

Data governance frameworks, Data Governance councils, Data stewards, Data custodians, Data owners, business glossaries, Data catalogues, Data quality, Data lineage,master data management;GDPR, CCPA, FCRA, HIPAA

  • Data Visualisation

Tableau, PowerBI,

  • Workflow Orchestration

Apache Airflow, Azure Data Factory

  • Data Modeling, Version Control, & Project Management

Erwin ; Git, SVN; Agile, Scrum, Waterfall methodology

Summary

High-energy Technocrat with over 15 years of extensive experience in Data Analysis and Reporting, Technical Architecture and Software Development & Supports using Microsoft Cloud Technologies.

An accomplished Microsoft BI Engineer/ Data Engineer with 15+ years of hands-on experience in crafting dynamic data ecosystems on top-tier cloud platforms (Azure,Snowflake) and my expertise lies in delivering cloud data architecture, solution architecture, advanced analytics, consultancy services, strategy implementation in major technology transformation programs. Specialized in cloud data platforms, data migrations, integrations.

Committed to precise data and solution architecture and adept in developing solutions using a mix of proprietary, custom, open-source, and off-the-shelf tools. Successfully managed projects with 50+ team members spanning the UK, US, and India, covering 5+ countries across EMEA, APAC, and AMER regions.

My achievements encompass:

  • As a Multi-Cloud Data Engineer, I've enhanced data reliability and performance through advanced techniques, aligning data strategies with business objectives and fostering data governance across various industries in on-premise and cloud environments.
  • As a Data Engineer, I excel in crafting intricate solutions for big data, data warehousing, and advanced analytics, with a commitment to well-structured data and solution architecture, shaping technical architectures, specifying exact requirements, crafting detailed designs, and establishing robust security controls, including identity access management. Throughout my career, I've crafted intricate solutions for data warehousing, data lakes, delta lakes, lake houses, deep learning and advanced analytics, predominantly for multinational clients. I'm devoted to structured data and solution architecture, skilled with diverse toolsets, and my track record underscores my unwavering commitment to advancing data excellence and fostering innovation in a rapidly evolving tech landscape.

AREAS OF SPECIALIZATION

INDUSTRY / DOMAIN

  • FS – Investment/Insurance
  • FS - Consumer Finance
  • FS – Cards & Payments
  • FS - Digital & Mobile Banking
  • HS - Health Information System
  • CPG - Retail
  • Semiconductor
  • Internet Marketing

TECHNICAL CONSULTING

  • Enterprise architecture
  • Data Engineering & Data Management
  • Data architecture & MDM
  • Data Governance & Security
  • Advanced Analytics
  • Digital Transformation

MANAGEMENT

  • Pre-sales Consulting
  • Stakeholder management
  • Budget & Contract management
  • Program & project management
  • Estimation and cost management
  • Agile methodologies & DataOps, and DevOps
  • Design Assurance
  • Release and configuration

To check my right to work in the United Kingdom,

https://www.gov.uk/view-right-to-work

share code: WES XDG 3EF , and date of birth is 11-12-1983.

You can find more about my professional background and achievements on my LinkedIn profile:

https://uk.linkedin.com/in/gbmanjunath/

I can be reached via email at manjunathbasavanth@gmail.com or by phone at +44 07733 657567. Currently, I am based in Leeds, United Kingdom.

Work Preference

Work Type

Full TimePart TimeContract Work

Work Location

RemoteHybrid

Important To Me

Work-life balanceCareer advancement

Accomplishments

  • Established the NextGen Data Plat Form Data Modeling team at Alegeus Technologies, Led Important role in establishing company to transform from legacy reporting to self service reporting platform.
  • Created effective Data Models which led to creation of highly robust and scalable datawarehouse and resulted in saving $10 million annually
  • Implemented Cloud-based Process Optimization, resulting in a 0.5% to 1.2% increase in MW production per process claim and improved cost efficiencies.

Timeline

Expert BI Engineer

Aeries Technology Group
2023.May - 2023.Sep

Senior Technical Specialist

Datavail Infotech India Pvt. Ltd, Microsoft
06.2020 - 01.2023

Technical Architect

Maxim Integrated, Inc
01.2016 - 05.2020

Technical Lead

Genpact
01.2014 - 01.2016

System Analyst

Fidelity Business Services India Private Limited
11.2011 - 12.2013

Software Engineer

Theorem India Pvt. Ltd
11.2007 - 11.2011

Bachelors in Engineering - Electrical And Electronics

Dr Ambedkar Institute of Technology
06.2001 - 06.2005

Similar Profiles

CREATE PROFILE
Manjunath G.BData/BI Engineer