Ken Bagaloyos

About Ken Bagaloyos

I\'m a Data Engineer with a B.S. in Business Management from Rutgers University and a strong track record of driving both business results and technical impact. Early in my career, I honed my performance and leadership skills at Vector Marketing, where I was promoted to Branch Manager and led the West Essex County office to the #1 rank in the Northeast Region with over in sales.After graduation, I entered the automotive industry, where I became a top-performing consultant, generating in profit and ranking in the top 5% nationally for customer satisfaction.I’ve since transitioned into data, where I’ve built end-to-end ETL pipelines, deployed AI tools to automate workflows, and created impactful dashboards that drive millions in adoption and retention. My work blends technical rigor with business insight.

Experience

1. Data Analyst

   PERSUIT®

   Aug 2022 — Present · New York, NY, US

   Architected an AI tagging solution using Python, MongoDB, and Google Gemini, deployed using Kubernetes, to enrich legal RFP data. Automated a 100% manual labeling task previously done by Customer Success teams, improving efficiency, consistency, and allowing them to focus on higher-value priorities.Built and maintained scalable, end-to-end reporting ETL pipelines transferring data from NoSQL (MongoDB) to SQL, enabling seamless integration into API (PERSUIT) or BI integrations (Qlik) enhancing reporting capabilitiesOptimized and redesigned ETL pipelines by removing ORM and low-level Python abstraction bottlenecks, cutting data latency from 6 hours to 1.5 hours to ultimately 10 minutes allowing the acceleration of analytics for internal teams and external clients.Migrated MS SQL database to PostgreSQL, achieving a 40% reduction in costs by eliminating proprietary licensing and leveraging open-source scalability.Optimized data integration into Qlik Cloud from diverse sources (APIs and SQL databases), improving loading speeds by 20% and enabling more efficient data analysisCentralized business logic by consolidating scattered formulas from APIs and BI tools into the ETL process and developing a comprehensive data dictionary, establishing a single source of truthImplemented automations, unit tests, and logging for ETL and CI/CD processes, introducing timely notifications for system warnings or failures and reducing diagnostic times by over 70%Developed visualizations, dashboards, and Qlik automations for tracking business KPIs and measuring North Star Metric, and other reporting purposes, saving up to 5 hours per week on manual reporting tasksCreated numerous external-facing dashboards, including insights, benchmarking, and real-time business reviews, significantly streamlining client reporting and interactions with law firms, saving clients up to 3 days on manual reporting

Education

• Rutgers University

  Bachelor of Science - BS, Business Administration and Management, General

Skills

• Direct Sales
• Revenue & Profit Growth
• Work Ethic
• Sales Presentations
• Interpersonal Communication
• Sales Growth
• Negotiation
• Sales
• Networking
• Time Management
• Entrepreneurship