Gangadhar Pathi

Project: Enterprise Data Hub (Pension Insurance Corporation, London)

PIC specializes in securing the liabilities of Defined Benefit pension schemes to pensions. Azure team is responsible for designing and implementing secure data integrations between within and outside PIC.

Responsibilities:

• Delivered £5 million projects by meeting project timeline
• Lead effort to develop technical standards to support and operate technologies within Microsoft Azure eco-system
• Create prototypes, if necessary, to validate proposed solutions and seek feedback from stakeholders
• Responsible for analyzing user requirements, understanding existing OLTP systems (Murex, Oracle) to design and develop robust solutions using Microsoft Azure Stack (Storage Account, Azure SQL Database, Azure Synapse Analytics, Data Factory, Function App, API Management Service, App Service Environment, Key Vault, Active Directory & V-Net) and power platform (Power BI, Power Apps & Power Automate)
• Create Web applications using C# hosted on Azure Service Environment
• Proactively benchmark application code to mitigate performance and scalability issues
• Assist application support team (Support and Troubleshooting) with any environment issues during application deployment and post live across
• Create Architectural, Functional Specification, Technical Design and Unit Testing documents

Project: Business Intelligence and Data Analytic Solutions

Polaris Industries is a leader in Off Road automobile industry. It manufactures ATV, Snowmobiles, Electric Vehicles and Motor Cycles. BI team is responsible for creating business insights for decision-making to compete with other manufactures and providing quality & safety products to consumers.

Responsibilities:

• Interacted with Stakeholders from different units like Manufacturing Plants, Supply Chain Units, Core Engineering, Vendors and Leadership team to understand business needs
• Co-coordinated with IT vendors to run projects smoothly
• Responsible for analyzing the user requirements, understanding the existing OLTP systems (IBM i-Series, Dynamics AX, Dynamics CRM, SharePoint) to design and develop robust solutions using Microsoft BI Stack (SQL Server 2012, SSIS, SSAS & SSRS) and Power BI
• Developed Data Engineering solutions using Apache Spark, Scala and Microsoft Azure.
• Created Wiki Pages, Functional Specification, Technical Design and Unit Testing documents

Project: Global Enterprise Technology Services (Dell International Services)

GETS was a Data Warehouse service which empowers decision makers at every level within the organization by providing an intuitive interface to access, analyze, and share information. Configuration Services
implement customer solutions into Dell systems as they are being built.
Services include "Imaging, Hardware Configuration, Software Configuration, Asset Tagging, and Rack Integration"

Responsibilities:

• Developed and delivered business information solutions
• Improved data gathering, analysis and visualization procedures with strategic optimizations
• Worked on End-to-End Microsoft BI stack (SQL Server 2012, SSIS, SSAS and SSRS)

Project: Inflight Dashboard (CGI Information Systems)

Inflight Dashboard was an In-House project for CGI which focuses on the project delivery process. The main focus was on project management, cost minimization, resource utilization.

Responsibilities:

• Participated in architecture, design and implementation of Data Warehouse, ETL packages and Multi-Dimensional cubes using SQL, SSIS, SSAS and C#
• Created dashboards using SSRS and Fusion Charts