Accomplished Software Development Engineer with extensive expertise at F5 Networks, specializing in SQL Server optimization and data integration. Demonstrated success in enhancing system performance and streamlining data processes. Proficient in Azure Data Factory and committed to collaborative teamwork, consistently driving project success through innovative solutions and detailed testing.
Developed complex queries to import data efficiently.
Created saved import functionalities to enable seamless data transfer between databases.
Facilitated completion of assigned responsibilities among developers.
Implemented unit testing procedures.
Crafted SQL database solutions through table creation, view formulation, and function development.
Ensured seamless coordination among development and UI staff.
Supported team members with current projects as needed.
Confirmed functionality through testing.
Developed user-defined tables, joins, and stored procedures.
Executed query optimization steps for stored procedures.
Managed backup operations and maintained database integrity.
Created personalized annual and quarterly reports as per client demands.
Sales Compensation Re-Architecture, F5, Varicent 10, SQL Server 2016, SDE III, as part of upgrading the current system with a few enhancements added to the new system with a different database structure, design and create tables, views, stored procedures, developing the queries in SQL Server used to import data, consolidate the upstream data using stored procedures, maintain these in different tables, and send them to Varicent through SFTP, performing unit testing along with tuning and optimizing the complex stored procedures Travel & Expenses, F5, SQL, SQL Server 2016, SDE III, Internal Employees travel and expenses application support, Design and Create Tables, Views, SP’s, developing the queries in SQL Server used to import data, Back end support for these two applications like enhancements, Change request, Production Issues., Performing unit testing. Cigna Insurance Commission Automation, Cigna, IBM ICM varicent 9.0, SQL Server 2014, Sr Software Engineer, Cigna Indonesia, Sales Commission Process Automation project is to automate the commission’s calculations and processes, along with the Individual management reports and workflows in the Cigna Insurance Company in Indonesia., Design and Create Tables, Views, developing the queries in SQL Server used to import data, Coordinating with the other developers and create saved imports to migrate data from Client database to ICM Model database, Assist other developers in handling ongoing tasks as required., Performing unit testing. Bupa Arabia Sales Commission Process Automation, Bupa Arabia, IBM ICM varicent 9.0, SQL Server 2014, Sr Software Engineer, Bupa Arabia, KSA, Sales Commission Process Automation project is to automate the commissions calculations and processes, along with the Individual management reports and workflows in the Bupa Arabia Insurance company., Design and Create Tables, Views, developing the queries in SQL Server used to import data, Building calculations, Reports, Workflows, Coordinating with the other developers and create saved imports to migrate data from Client database to ICM Model database, Assist other developers in handling ongoing tasks as required., Performing unit testing. HH Global Print Management, HH Global Print Management, .NET 4.5, C#.NET, MVC 4.0, Entity Framework Code First Approach, SQL Server 2008 R2, SQL Developer, The HHUB is a print management system which acts as an interface/broker between the customers (who specify orders for printing) and suppliers (who take orders and execute them) globally., Create Tables, Views, Functions, developing the SQL stored procedures., Coordinating with the other developers and UI developers., Assist other developers in handling ongoing tasks as required., Performing unit testing. C3PM (Credit Card Core Platform Modernization), Bank Of America, DB2 IBM, SQL Developer, Bank of America has initiated a strategic, corporate initiative championed by Credit Card core platform to replace the current, aging, 30 years old system by outsourcing it to Tsys., Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues., Analyses the Performance of queries and reported to respective section. SANJAY TECHNICALS PVT LTD., SAP Business One 8.81 and Vb.Net 4.0, SQL Server 2008, Crystal Reports 2008, SQL Developer and Reporting, One of the leading Electrical Panel Builders and 'A' Grade Electrical Contractors based in Hyderabad, India., Writing T-Sql queries, creating user defined tables, stored procedures, views etc., Generate reports according to the client requirement using crystal reports and sql server. STYPACK PVT LTD, SAP Business One 8.81 and Vb.Net 4.0, SQL Server 2008, Crystal Reports 2008, SQL Developer and Reporting, Leading manufacturer and Supplier of Thermocol Products such as Thermocol Sheets and Thermocol Packing Material., Understanding requirements and provide backend functionality and support, Writing T-Sql queries, creating user defined tables, stored procedures, views etc., Backup and Restoring Database, Generate Sales, Purchase, Financial reports according to the client requirement using crystal reports and sql server. SRI BIOTECH LABORATORIES INDIA LTD, SAP Business One 8.8 and Vb.Net 4.0, SQL Server 2008, Crystal Reports 2008, SQL Developer and Reporting, The company is engaged in Research in the areas of Crop Improvement, Crop nutrition and Crop Protection., Understanding requirements and provide backend functionality and support, Writing T-Sql queries, creating user defined tables, stored procedures, views etc., Backup and Restoring Database, Generate Sales, Purchase, Financial reports according to the client requirement using crystal reports and sql server. JYOTHI DAIRY PVT LTD., SAP Business One 8.81 and Vb.Net 4.0, SQL Server 2005, Crystal Reports, SQL Developer and Reporting, Procure quality milk from the farmers and produce milk and milk products., Writing T-Sql queries, creating user defined tables, joins, stored procedures, views, cursors, Pivot queries etc., Created clustered/non clustered Indexes for performance tuning of queries along with execution plan., Backup, Restoring and Maintaining Database, Generate Sales, Purchase, Financial reports like yearly and quarterly reports and sub reports according to the client requirement using crystal reports and sql server. INVENTORY MANAGEMENT, VB.net 2.0, MS-Access and Sql Server 2005, Crystal Reports, Developer, This product is developed for maintaining general business process of a trading company., Responsible for analyzing the client specifications., Responsible for Designing, Coding, Debugging., Data Base Designing and Report Designing. EVENT MANAGEMENT SYSTEM, VB.net 2.0, MS-Access and Sql Server 2005, Crystal Reports, Developer, This product is basically for the people who conduct 3 to 7 days event., Responsible for Designing, Coding, Debugging., Data Base Designing and Report Designing. PATIENT INFORMATION SYSTEM, VB.net 2.0, Ms-Access and SQL Server 2005, Crystal Reports, Developer, Patient Information System is a customized software package developed for use in hospitals., Responsible for Designing, Coding, Debugging., Data Base Designing and Report Designing.
I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars., Hyderabad, G. MADHU GANGA RAJU