Rohit Vakhariya

Projects

• ENABLE INDIA

  Role: Software Architect

  Domain: Social Tech

  Architecture & Technologies: : Apex, SOQL, Lightning Components,Flow, Workflow

  Responsibilities:

  • Deployed Apex triggers that automatically updated Salesforce records with data from external systems, reducing manual data entry time by 90%.
  • Developed a custom application using Apex, SOQL, Triggers, and Lightning Web Components (LWC), driving efficiency and enhancing system functionality.
  • Integrated Microsoft Excel with Salesforce, reducing data entry time by 85%, streamlining the process, and improving accuracy.
  • Built custom user interfaces using VisualForce pages in Lightning, enhancing the user experience by 85% and optimizing workflow processes.

• HUD Connect

  Role: Lead Developer

  Domain: Business Domain

  Architecture & Technologies: : Salesforce, Apex, SOQL, REST

  Responsibilities:

  • Led RESTful API integration between two Salesforce orgs, enabling real-time data synchronization and improving cross-system collaboration by 60%.
  • Developed secure and scalable REST services for seamless data exchange between Salesforce environments, ensuring high availability and performance.
  • Implemented OAuth 2.0 for authentication, ensuring secure and authorized data transfer between the integrated Salesforce orgs.
  • Optimized API callouts using bulkified REST operations, reducing API call consumption by 40% and increasing efficiency of data transfer.
  • Created custom Apex REST endpoints for data exchange, facilitating efficient communication between multiple Salesforce instances and external applications.
  • Automated data synchronization between Salesforce orgs using Apex and scheduled batch jobs, minimizing manual intervention and reducing data discrepancies by 70%.
  • Enhanced data security and compliance by implementing encryption and adhering to Salesforce security best practices during integration.

• ETCB- ETL System

  Role: Software Architect

  Domain: Finance

  Architecture & Technologies: : Microsoft SQL Server, Debezium, Kafka, Node.js, MongoDB

  Responsibilities:

  • Managed the architecture and execution of a robust ETL pipeline to transfer data from Microsoft SQL Server to MongoDB, ensuring high data integrity and system reliability.
  • Oversaw the implementation of a real-time change data capture (CDC) solution using Debezium and Kafka, improving data availability and reducing latency.
  • Directed the development of a scalable Node.js application to process, transform,and format data for seamless delivery to a third-party server, ensuring compliance with external requirements.
  • Optimized data transfer performance by leveraging Kafka's message streaming, enabling near real-time updates and improving system efficiency.
  • Managed the automation of file creation and transfer processes post-data transformation, significantly increasing operational efficiency and reducing manual interventions.
  • Ensured data security and compliance by implementing encryption protocols during the transfer of data to third-party servers, adhering to industry standards.
  • Maintained high data quality by guiding the development of validation and error-handling mechanisms, reducing data anomalies and enhancing accuracy.
  • Enhanced the system's scalability and fault tolerance by leveraging Kafka's distributed architecture, ensuring smooth handling of large data volumes and minimizing downtime risks.

• SOPACT- Social Impact Platform

  Role: Software Architect

  Domain: Social, FinTech

  Architecture & Technologies: : PHP microservices, Salesforce integration, AWS cloud, PosgressSQL, React

  Responsibilities:

  • Developed a full-fledged web application from the ground up using PHP, MySQL, and React.js, enabling seamless data collection and user interaction through surveys.
  • Designed a dynamic reporting system that generates reports based on user inputs, with the ability to customize them according to specific requirements through a user-friendly interface.
  • Implemented a flexible report customization feature, allowing users to tailor reports with just a few clicks, without requiring technical knowledge, making the system highly accessible.
  • Optimized the database schema using MySQL to ensure efficient handling of large datasets and fast retrieval for real-time reporting.
  • Integrated real-time data validation during the survey submission process to ensure data accuracy and improve overall report quality.
  • Ensured scalability and maintainability of the application by using modular coding practices, allowing easy updates and enhancements as user needs evolve.
  • Focused on performance optimization, reducing load times and enhancing the application's responsiveness to deliver a seamless experience even with high traffic.

• U.S. Chapter 11 Bankruptcy Management

  Role: Lead Developer

  Domain: LegalTech / FinTech

  Architecture & Technologies: :PHP , Microservices, AWS cloud, Mysql,WordPress, React

  Responsibilities:

  • I architected and developed an ETL system using AWS SQS and PHP, where messages from SQS are dynamically processed and stored in the appropriate database tables. The solution is fully dynamic, eliminating the need for manual coding for each table. My code intelligently determines the correct table and automatically maps the incoming data, streamlining the process and improving efficiency