Kishore Kumar K

Oracle APEX Developer with 4+ years of experience building and supporting healthcare web applications, including Study Hub, a product used by 1K+ active users. Proven in performance tuning (cut a critical page's server time from 15 to 5 minutes, about 67%), secure role-based access, ERP / Oracle EBS / Oracle Fusion integration, and legacy-to-APEX migration.

Certified

Oracle APEX Cloud Developer and OCI 2024 Generative AI Professional.

Engineer I at Syneos Health (2024-12 – Present)

Project: Study Hub (Healthcare, Internal Product, 1K+ active users)

• Design and develop multiple Oracle APEX modules for Study Hub, the organization's 2nd most used product, translating Figma designs into responsive pages through theme, template and CSS customization.
• Reduced a critical page's server processing time from 15 to 5 minutes (about 67%) through SQL and PL/SQL performance tuning.
• Built dynamic-column editable reports (200 columns, 1,000 rows) and converted Interactive Reports into editable reports using the Shuttle component and an add-new-row option.
• Used APEXlang to rename a field across 100+ impacted places in 15 minutes, then reviewed and pushed the changes to dev.
• Set up APEX Office Print (AOP) and APEX Office Edit (AOE) on a private server, enabling multi-format report downloads from templates (including Excel with Object Storage images) and in-app Word editing with auto-save.
• Implemented SSO and role-based security, grouping roles under personas and pages under page groups, driven by a live permission sheet.
• Automated permission loading with a Copilot Studio workflow that sends sheet data as JSON to an APEX REST API, with a review-and-commit wizard similar to Git.
• Integrated 5+ systems, including ERP, Oracle E-Business Suite (EBS) and Oracle Fusion: POST endpoints handle ETL and ELT data loads, and 6+ ORDS REST APIs (GET endpoints) serve data to downstream systems; built audit logging with triggers on every table and an optimized date-range search page.
• Developed PL/SQL packages, procedures, functions, compound triggers, cursors, views and staging tables; used REST Data Sources, validations, automations, scheduled jobs and APEX collections.
• Resolve production issues through ServiceNow; work across the full SDLC in Agile/Scrum sprints with code reviews, unit testing and Jira tracking.
• Support production deployments, including off-hours cutovers; completed 7+ releases successfully.

Full Stack Developer I at Syneos Health (2023-09 – 2024-12)

Project: Study Hub (Healthcare, Internal Product)

• Contributed to Study Hub from day one, replacing a legacy Planview-based system that was decommissioned and migrated to Oracle APEX.
• Designed and created database tables and built APEX pages for the new application.
• Migrated existing records into Oracle Database, preserving historical data across the cutover.
• Built full stack features using SQL, JavaScript, HTML and CSS, and developed REST integrations.
• Followed the SDLC and adopted Agile practices for the team, working in sprint cycles with regular reviews.

Intern / Associate Software Engineer – Trainee at Syneos Health (2021-12 – 2023-08)

Project: KPI Management (Healthcare, Internal Product)

• Built and tested modules for an internal KPI management application that tracks key performance indicators for each clinical study.
• Learned and applied Oracle APEX, SQL and PL/SQL to develop pages, forms, reports and database logic.
• Customized the APEX user interface with CSS and templates to improve usability.
• Wrote and tested SQL and PL/SQL for KPI data retrieval and reporting, working with senior developers through code reviews.

MCA (Online) – SRM Institute of Science and Technology, Chennai (2022-02 – 2024-07)

B.Sc. in Computer Science with Data Analytics – PSG College of Arts and Science, Coimbatore (2019 – 2022)