📅 Project Duration: 1-3 months (2015)🏢 Company: Aris Rayaneh Arak Company🎯 Role: Database Performance Optimization Specialist Project Overview In 2015, I was entrusted with optimizing the SQL Server database for the Asset and Warehouse Management System at Aris Rayaneh Arak Company. The system faced serious performance bottlenecks, impacting query execution speed, data retrieval efficiency, and overall user experience. My objective was to analyze, refine, and enhance the database architecture, achieving an impressive 90% improvement in database efficiency without modifying the application code. The project required in-depth performance tuning on a complex database structure, consisting of:✔ 80+ tables – Reviewing and restructuring

 Project Duration: April 2015 – August 2015 Client: Bakhtar Regional Electricity Company (Website) Associated with: Aris Rayaneh Project Overview In 2015, Bakhtar Regional Electricity Company engaged me to analyze, optimize, and enhance the performance of their comprehensive electricity management system’s database. The system relied on a SQL Server database of approximately 1TB, which had significant performance issues due to lack of stored procedures and direct script execution within the application. These inefficiencies resulted in slow query execution, redundant data structures, and system bottlenecks, affecting the company’s ability to process large volumes of data efficiently. To resolve these challenges, I conducted an in-depth performance analysis and implemented a series of strategic improvements to increase efficiency, optimize query response

📅 Project Duration: October 2014 – May 2015🏢 Company: Aris Rayaneh Arak🎯 Role: Project Manager & Lead Developer Project Overview As the Project Manager, I led the implementation of an Accrual Accounting System, designed to enhance financial transparency, automate accounting workflows, and improve financial reporting. This system enabled organizations to accurately track revenues and expenses, ensuring compliance with accounting standards. The project involved a team of three professionals, where I was responsible for managing development, overseeing system architecture, and ensuring on-time delivery. The solution was built using C#.Net for backend processing, SQL Server for database management, and web technologies (HTML, CSS3,

 Project Duration: September 2013 – November 2013 Company: Aris Rayaneh Arak Role: Lead Developer & System Integrator Project Overview The Sena and Sanama Plan aimed to digitize financial data exchange in cost accounting and capital asset acquisition systems. This project focused on integrating an electronic data receipt protocol, ensuring seamless and automated financial transactions between external financial platforms and the organization’s accounting system. As the Lead Developer, I was responsible for designing and implementing the protocol, ensuring secure, accurate, and real-time data synchronization between external financial sources and the SQL Server-based accounting system. Key Features & Functionalities  Automated Data Collection – Enabled seamless electronic receipt of financial data, reducing manual input errors. Secure & Standardized Data Exchange – Implemented data validation and encryption protocols to protect sensitive financial information. Integration

 Project Duration: February 2015 Company: Aris Rayaneh Arak Role: Database Optimization Specialist Project Overview This project focused on enhancing the performance of the database powering the Inventory and Asset Management System of Aris Rayaneh Company. Due to inefficient queries, redundant indexes, and unoptimized database structures, the system was experiencing slow performance and resource bottlenecks. Through an extensive database performance tuning process, I successfully optimized query execution, indexing, and data structure efficiency, achieving up to a 90% increase in overall system performance. Key Improvements & Optimizations  Query Optimization & Performance Tuning – Rewrote inefficient stored procedures and queries to minimize execution time. Indexing Enhancements – Removed redundant indexes and implemented new indexing strategies for faster data retrieval. Execution Plan Optimization – Analyzed and optimized query execution plans to

 Project Duration: December 2014 Company: Aris Rayaneh Arak Role: Lead Developer & System Integrator Project Overview This project aimed to modernize and streamline the warehouse and asset management system by integrating barcode and RFID technology with handheld devices (Handheld Terminals – HHTs). The goal was to automate inventory tracking, improve accuracy, and enhance efficiency in warehouse operations. As the Lead Developer, I was responsible for designing and implementing the subsystem, ensuring seamless data synchronization between handheld scanners and the central SQL Server database. This solution significantly reduced manual data entry errors, optimized stock management, and accelerated inventory audits. Key Features & Functionalities  Real-Time Inventory Tracking – Enabled instant scanning and updating of warehouse stock using barcode readers and RFID. Handheld Device Integration –

 Project Duration: June 2014 – November 2014 Company: Aris Rayaneh Arak Role: Project Manager & Lead Developer Project Overview This project involved the development and deployment of a web-based vehicle tracking system integrated with car alarm hardware produced by Aris Rayaneh Company. The system provided real-time vehicle location tracking, enabling users to monitor, manage, and secure their vehicles remotely. As the Project Manager and Lead Developer, I was responsible for overseeing the development team, designing the system architecture, and ensuring seamless integration between hardware and software. The platform allowed end-users to track their vehicles via a user-friendly web interface, enhancing security and fleet management capabilities. Key Features & Functionalities  Real-Time GPS Tracking – Enabled live vehicle tracking with high-accuracy

 Project Duration: 3-6 months (2014) Company: Aris Rayaneh Arak Company Role: Team Leader & Lead Developer Project Overview In 2014, I led and developed a real-time vehicle location tracking system for Aris Rayaneh Arak Company, aimed at businesses requiring accurate and real-time fleet monitoring. This project, titled “Implementation of a Vehicle Location Website,” was designed to assist logistics companies, transportation services, postal services, school transportation providers, and car rental businesses in effectively tracking their vehicles. The system integrated seamlessly with vehicle tracking hardware manufactured by the company, ensuring precise real-time monitoring, enhanced operational efficiency, and improved customer service. The web-based solution allowed users to view live vehicle locations, monitor fleet performance, and receive real-time updates, significantly improving fleet management and logistics coordination.