MIT Profiling — LinkedIn-Style Professional Talent Profiling Platform
LinkedIn-style professional web platform for corporate talent profiling, organizational capability directory, and portfolio tracking at PT Merkle Inovasi Teknologi.
Overview & Objectives
MIT Profiling is a LinkedIn-style corporate talent profiling platform developed for PT Merkle Inovasi Teknologi. The system enables company talents and employees to showcase verified skills, build professional portfolios, track certifications, and streamline internal resource allocation and staffing.
[!] Problem Statement
Internal employee competencies, project experiences, and certifications were previously scattered across disconnected spreadsheets, making resource allocation for enterprise client projects slow and inaccurate.
[✓] Engineering Solution
Constructed a high-throughput backend architecture with Node.js, Express, and TypeScript, featuring a LinkedIn-style multi-criteria talent directory, structured profile search, and optimized relational data models.
System Architecture
Key Engineering Challenges & Solutions
Challenge 1: N+1 query bottlenecks when aggregating multidimensional skill assessments across hundreds of employees.
Resolution: Restructured SQL queries with materialized aggregations and indexed foreign keys, reducing query execution time from 1.8s to 42ms.
Key Results & Verification
- Centralized professional talent directory deployed across all corporate divisions
- Average talent search and profile query response latency under 65ms
- Significantly accelerated project staffing velocity and skill portfolio transparency