Vijaya Hegde

Senior Technical Lead

Bengaluru, India 18+ yrs exp 95 · Outstanding

About

Senior Technical Lead with 20+ years of IT experience in Microsoft technologies, SQL Server, Oracle, and enterprise application development. Extensive experience designing, developing, supporting, and enhancing business-critical applications for global clients including HP Inc. Strong expertise in SQL, Power BI, Advanced Excel, Reporting, Dashboard Development, Data Analysis, and MIS Reporting — transforming raw business data into actionable insights using Power BI dashboards, Excel dashboards, Pivot Tables, Pivot Charts, XLOOKUP, VLOOKUP, INDEX-MATCH, Power Query, Conditional Formatting, SUMIFS, COUNTIFS, and SQL.

Skills & Expertise (38)

Advanced Excel Expert

9.0/10

Years Exp

SQL Expert

9.0/10

Years Exp

SQL Server Expert

9.0/10

Years Exp

Power BI Advanced

8.5/10

Years Exp

.NET Framework Advanced

8.0/10

Years Exp

C# Advanced

8.0/10

Years Exp

VB.NET Advanced

7.5/10

Years Exp

Crystal Reports Advanced

7.0/10

Years Exp

Oracle Advanced

7.0/10

Years Exp

JavaScript Intermediate

6.0/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

Basic Python Intermediate

5.5/10

Years Exp

Ajax Reporting Charts & Graphs Excel Dashboards COUNTIF SUMIF Ifs If Data Validation Pivot Charts Pivot Tables SQL Reporting Dashboard Development Data Analysis Index-match XML HTML jquery MIS Reporting XLOOKUP ASP.NET VLOOKUP Countifs SUMIFS Conditional Formatting Power Query

Work Experience

Senior Technical Lead

Hewlett-Packard (HP Inc.)

May 2023 - Apr 2025

Managed contingent development team. Designed and developed enhancements for Order, Assignment and Registration modules. Conducted code reviews and test case reviews. Developed complex SQL queries and stored procedures. Built interactive Power BI dashboards for monitoring Care Pack orders, registrations and assignments. Created executive MIS reports using Advanced Excel. Used Pivot Tables for monthly, quarterly and yearly reporting. Used XLOOKUP and INDEX-MATCH to reconcile Care Pack orders between multiple systems. Used VLOOKUP for validating reseller and customer information. Created Excel dashboards using Pivot Charts and slicers. Used SUMIFS, COUNTIFS, and IF formulas for KPI reporting.

Senior Software Engineer

TEKSystems — Client: HP Inc.

Jul 2016 - Apr 2023

Developed enhancements for HP Care Pack applications. Designed SQL Server database objects and stored procedures. Developed business reports using SQL. Created Advanced Excel reports using XLOOKUP, VLOOKUP, INDEX-MATCH, Pivot Tables, Pivot Charts, SUMIFS, COUNTIFS. Prepared monthly operational reports. Created reconciliation reports comparing order and registration data. Participated in code reviews, testing and production support. Worked directly with business users to understand reporting requirements.

Senior Software Engineer

Capgemini India Pvt Ltd — Client: HP Inc.

Mar 2013 - Jan 2015

Designed and developed Inquiry Module. Migrated ASP application to .NET. Developed SQL stored procedures. Conducted code reviews. Performed smoke testing and post-release validations.

Senior Software Engineer

SM Netserv Pvt Ltd — Client: CareerBuilder

Jun 2012 - Nov 2012

Developed Job Seeker module. Developed SQL stored procedures. Performed testing and bug fixing.

Senior Software Engineer

3i Infotech Ltd. — Client: BBK Healthcare (USA)

Aug 2007 - Jul 2008

Developed TrialCENTRALNet clinical enrollment system. Developed SQL procedures, views and triggers. Prepared unit test cases. Performed integration testing.