Ranganath S Email & Phone Number

Bengaluru, Karnataka, India

--> Run/Maintain end-to-end Production Infrastructure(Azure,PowerBI) and application architecture. --> Troubleshoot and RCA Prod issues.--> Requirement analysis and translating them to Technical work items--> Setup and maintain > Azure DevOps Build Agent. > Self-Hosted Integration Run time. > Azure Automation Hybrid worker > Power BI Deployment Pipelines--> Fix Bugs and Enhance ADF data ingestion framework (Metadata… Show more --> Run/Maintain end-to-end Production Infrastructure(Azure,PowerBI) and application architecture. --> Troubleshoot and RCA Prod issues.--> Requirement analysis and translating them to Technical work items--> Setup and maintain > Azure DevOps Build Agent. > Self-Hosted Integration Run time. > Azure Automation Hybrid worker > Power BI Deployment Pipelines--> Fix Bugs and Enhance ADF data ingestion framework (Metadata, Pipelines, Dataflows)--> Automate PowerBI dataset refresh using Azure Automation and XMLA endpoint.--> Automate extracting Hyper datasource from Tableau cloud using Python Script.--> Enhance data factory pipeline to extract invoice details from SAP Ariba APIs--> Build YAML based CI/CD pipelines for Azure SQL, Azure Data Factory using Azure DevOps--> Maintain Azure Repos--> Build data ingestion logic using ADF for > SAP Ariba Data source using REST API > SAP CDS views using SAP CDC connector Show less

Bengaluru, Karnataka, India

DXC Insights> Experience in building Automated Azure Infra Deployments using Biceps in Azure DevOps.> Build ETL Pipelines in Azure Data Factory using Paul Andrew's framework.> Design and Implement Adhoc Tabular model table refreshes using PowerApps and Power Automate Flows.> Implement solutions to source data from APIs for Sales data.> Perform Root Cause Analysis on production issues and implement permanent fixes to reduce operational issues.> Design… Show more DXC Insights> Experience in building Automated Azure Infra Deployments using Biceps in Azure DevOps.> Build ETL Pipelines in Azure Data Factory using Paul Andrew's framework.> Design and Implement Adhoc Tabular model table refreshes using PowerApps and Power Automate Flows.> Implement solutions to source data from APIs for Sales data.> Perform Root Cause Analysis on production issues and implement permanent fixes to reduce operational issues.> Design and Implement Automated Move to ITG and Move to Production using Microsoft Forms, Logic Apps and Azure DevOps Pipelines.> Desing and Implement Custom Tabular Model data refresh using LogicApps, Azure Automation and Azure Analysis Services API.> Design and Implement CI/CD pipelines for SQL Server Database Projects, SSIS Packages and Tabular model to Azure Analysis Services and PowerBI Premium Datasets, PowerApps, for both onprem and Azure Infrastructure.> Manage and Enhance Andrew Leonard's SSIS Framework to suite Project needs. Show less

Bengaluru, Karnataka, India

Roles(In descending order)>Lead .Net Developer (GFIT - nSights)* Enhanced the build and deploy automation to Continuous Integration using Microsoft Team Foundation Server 2015’s build and release tools. This enhancement fully automates the Build and Deploymentprocess using environment owner approval Workflow controlling the deployment of build files to thecorresponding environments. We also archive the build artifacts in Github as well as NEXUS repositories.* Upgraded the… Show more Roles(In descending order)>Lead .Net Developer (GFIT - nSights)* Enhanced the build and deploy automation to Continuous Integration using Microsoft Team Foundation Server 2015’s build and release tools. This enhancement fully automates the Build and Deploymentprocess using environment owner approval Workflow controlling the deployment of build files to thecorresponding environments. We also archive the build artifacts in Github as well as NEXUS repositories.* Upgraded the Continuous Integration implemented using MS TFS 2015 to Microsoft Azure DevOps 2019 on Premise Infrastructure.* Create a generic Health Check Script using C# to check the status of Windows Web Servers andDatabase Connections. It checks the status of Application Pools, WebSite, Virtual folders, WindowsServices, Shared Folders and sends an email report of the same to Application Support team to helpthem manage the application in Production.* Refactor web services to improve performance of Web portal* Setup and upgrade the clone instances of the application to support HP Separation.* Volunteered in DevOps Internal Training and Automated the Training Setup Preparation steps using Vagrant and Shell Scripts that helped reducing the training duration from 3 weeks to 1 week.>Individual Contributor, Data Modeler, Subject Matter Expert (Progress® OpenEdge® DB, SAP, Vertica, Hadoop Hive) - RADAR* Created Mapping Document relating Source DB fields to Integrated Core fields ensuring they satisfy DB constraints.* Research and Implementation on how to replicate and connect to a PROGRESS® OpenEdge® Database system which was used in one of the source systems that needs to be onboarded to RADAR system.* Write ABAP Scripts to export SAP internal Tables to be ingested by Hadoop Hive Tables.* Write a C# script to decode multi-language data present in the same Table with proper Character Encoding.* Trained Team and Scrum Master on How to Use JIRA for Backlog and Bugs Tracking. Show less

Bengaluru Area, India

Roles(In descending order)> Lead .Net Developer (GFIT nSights)* Designed and Built Data Discovery module to enable business users to discover the kind and quality ofdata available at our refined data layer. Data Discovery allows business users to expore attributesavailable at domain levels and extract data for the selected attributes by applying custom filter criteriasusing an intuitive User Interface. Users can then export the data into excel/csv files for further… Show more Roles(In descending order)> Lead .Net Developer (GFIT nSights)* Designed and Built Data Discovery module to enable business users to discover the kind and quality ofdata available at our refined data layer. Data Discovery allows business users to expore attributesavailable at domain levels and extract data for the selected attributes by applying custom filter criteriasusing an intuitive User Interface. Users can then export the data into excel/csv files for further analysis.* Enhanced Data Discovery module to enable business users to save custom queries built during dataexploration and run them at scheduled time/intervals making it as a flexible reporting tool.* Integrated Enterprise Standard UID as authentication layer into nSights which was earlier using LDAPauthentication.* Integrated Enterprise Standard User Access Governence (UAG) as Authorization layer into nSights.* Solved a technical challenge to transfer files from Windows servers to HDFS locations using webHDFSAPI using Kerberos Authentication. Shared .Net webHDFS client API source code over the GITHUBEnterprise to help other teams to solve similar problems.* Designed and Build a generic Trigger Batch Job REST service to trigger windows batch jobs from Linuxenvironment. This exposes a batch script/executables on a windows machine as a REST service. Anynumber of batch scripts can be exposed by just adding an entry in configuration file. Show less

Bengaluru, Karnataka, India

Roles(In descending order)> Lead .NET Developer (GFIT - nSights)* Implement bulk/fileupload feature to update Hadoop Hive Tables from Excel/CSV/PlainText Documents.* Automate build and deploy activities using a .Net Console application which would do code checkoutsource code from SCM, build the source code and copy build artifacts to DEV/ITG/PRO web serversusing a single command execution.>Individual Contributor (MSSQL SSIS, Vertica) - Global Functions IT*… Show more Roles(In descending order)> Lead .NET Developer (GFIT - nSights)* Implement bulk/fileupload feature to update Hadoop Hive Tables from Excel/CSV/PlainText Documents.* Automate build and deploy activities using a .Net Console application which would do code checkoutsource code from SCM, build the source code and copy build artifacts to DEV/ITG/PRO web serversusing a single command execution.>Individual Contributor (MSSQL SSIS, Vertica) - Global Functions IT* Implemented SSIS packages to consolidated revenue details from different data sources and apply Secure Position calculation for reports>.Net Developer - Media Asset Manager[Content Management]* Setup an windows instance of OpenLDAP Server and integrated it with the application as Authorization solution.* Wrote a WCF service to expose methods to administer the LDAP users.* Setup and configure Windows webservers to host the web clients for the Autonomy's RIA client.* Create and modify Liquid Office (Autonomy Process Automation) workflows.* Upgrade Autonomy's Mediabin to new version 8.> .Net Developer - US Store [HP's B2B portal]* migrated few modules written in Classic ASP to .net C# code.* Implement Security fixes to the Portal which was written in Classic ASP. 1.Fixing the issue with mixed content http and https 2.Fixed the back door login issue for PD Store 3.Implementing session framework in classic asp for removing the all parameters from query string and storing in DB 4.Removed plain password from Hidden fields* Lead a team of 4 to apply these fixes to entire portal. > .Net Developer - ISCS [Integrate Simple Commerce Site] Project* Involved in performance analysis and Bug fixes.* Setup and configure Biztalk Server for workflow management.* Upgradation of DTS packages into SSIS packages. Show less

Bengaluru, Karnataka, India

Roles(In descending order)> .NET developer in GADSC India Development Center * Currently Working as .Net 3.5 resource for development of HP's Managed Print Services tool, a WPF based client-server application. * Involved in upgrading EDS Legal IT Web applications and Integrating them with HP Legal domain as a part of HP-EDS Integration Activities * Involved in Migration of EDS Matter Management System to TeamConnect a 3rd Party suite as go forward HP's Matter Management… Show more Roles(In descending order)> .NET developer in GADSC India Development Center * Currently Working as .Net 3.5 resource for development of HP's Managed Print Services tool, a WPF based client-server application. * Involved in upgrading EDS Legal IT Web applications and Integrating them with HP Legal domain as a part of HP-EDS Integration Activities * Involved in Migration of EDS Matter Management System to TeamConnect a 3rd Party suite as go forward HP's Matter Management System. * Involved in development of a major add-on to an existing Legal-Finance System in Rapid Application Development Model to deliver in record time. * Development resource for a Legal Records Management System in Legal IT. Involved in Enhancements, Bug fixing and Performance Improvement activities. * Migration HP's Consumer Product Management Application called Newton from MPE to ASP.Net, involved developing Web User Interface with Business logic equivalent to the legacy MPE screens. > as L1/L2 Support Engineer for IPG IT EMEA Support Operations(GADSC Support). * Managed & Provided Application Support to 12 HP's Intranet/Extranet Web Applications specific to EMEA region. * Provided L1/L2 Support to the HP's Product Life Cycle Management(PLCM) Application. * Upgraded Web Applications to meet HP's new DCC guidelines and Migrated them from various European Data Centers to HP's new Central Data Centers in Austin. Show less

Bachelors, Instrumentation & Electronics

Activities and Societies: Member of Editorial Team of Departmental News Letter "TATVA" Volunteered in organizing various events at college

Undergraduate, Physics,Chemistry,Mathematics,Biology

Activities and Societies: Won 3rd prize in Rural IT Quiz competition organized by TCS as a part of Bangalore IT.com, an IT expo event

High School

Activities and Societies: Cultural Team, Class Representative

Education record

Nursery, Lower And Upper Kindergarten