HARIPRAKASH S.
Chennai,TN
Summary
Results-driven Senior Software Engineer with extensive experience at GI Technology Private Limited, specializing in SQL development and database optimization. Achieved significant performance improvements through automation of report generation and optimization of complex queries. Strong critical thinking and problem-solving abilities enhance cross-functional collaboration, improving operational workflows and streamlining processes for greater efficiency. Committed to delivering innovative solutions that drive organizational success and elevate technical performance.
Overview
11
11
years of professional experience
Work History
Senior Software Engineer
GI Technology Private Limited
Chennai, India
04.2019 - Current
- Involved in development of interface programs to import parts information to inventory base tables.
- Interacted with Business Analysts and participated in user requirement sessions to analyses and gather business requirements.
- Write high performing SQL (DML, DDL), triggers, and stored procedures.
- Developed program code and methods for automating report generation. Automation of report creation reduced time spent each day creating and disseminating reports to end-users.
- Worked with database administrators and identified Slow Performing Queries, User Defined Functions, and Stored Procedures in the Production Environment and optimized their performance by adding/modifying Indexes, and rewriting them.
- Worked with testers and developers to review and validate test results.
- Developed more than 500 Stored Procedures with complex business logics.
- Worked on SQL Profiler and Estimated Query plan to optimize the performance of SQL queries and stored procedures.
- Assist application development teams with planning and implementing database changes as well as query/job optimization.
- Worked on parsing huge XML's data using stored procedures.
- Resolved locking and blocking issues.
- Tuned Production server gets performance improvement.
- Used Sub queries, joins, CTE's and Analytical functions for data retrieval.
- Working with other senior database developers & management.
- Provides technical advice and assists in solving programming problems.
- Work closely with the development team to provide support for database objects (stored procedures/triggers/views) and performing code review.
- Developed ETL processes using SSIS for data integration projects.
- Created documentation such as technical specifications for each task involved in ETL process.
- Involved in developing reports using SQL Server Reporting Services based on the requirements gathered from stakeholders.
- Implemented data security measures, including access controls and encryption, to protect sensitive information.
- Provided technical support and training to end-users on database querying and reporting tools.
Technical Support Engineer
GI Technology Private Limited
Chennai, India
11.2014 - 03.2019
- Managed daily operations to ensure efficiency and productivity in technology solutions.
- Coordinated cross-functional teams for project execution and operational alignment.
- Analyzed operational workflows to identify areas for improvement and optimization.
- Facilitated communication between departments to streamline processes and resolve issues.
- Created and updated operational documents and database records.
Education
Bachelor of Engineering - Electronics & Communication
Adhiparasakthi College of Engineering
01.2012
Skills
- SQL programming proficiency
- Automated data processing
- Efficient stored procedure implementation
- Improving query execution speed
- Collaborative teamwork across functions
- Data table partitioning
- Techniques for data integration
- Database performance enhancement
- Index performance enhancement strategies
- Creating efficient SSIS packages
- ETL process design
- Data migration management
- Data analysis and visualization
- Power BI analytics development
Languages
SQL, T-SQL
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge. Place: Date: (HARIPRAKASH S)
Personal profile
- Father’s Name: Subramaniyan.
- Date of Birth: 1990-12-09
- Sex: Male
Timeline
Senior Software Engineer
GI Technology Private Limited
04.2019 - Current
Technical Support Engineer
GI Technology Private Limited
11.2014 - 03.2019
Bachelor of Engineering - Electronics & Communication
Adhiparasakthi College of Engineering