Built 15+ Power BI dashboards and reports used by stakeholders across all Gap brands worldwide, connected to SQL Server for live data. Ran requirements gathering and UAT with business stakeholders.
John Ivan David
Sacramento, CA
Technical Analyst with five years of experience supporting enterprise business applications, system integrations, and digital tools initiatives, with a proven ability to deliver GxP-validated applications in biotech manufacturing.
How I got here.
Wrote Python integrations against vendor REST APIs, supported Azure data pipeline development (Data Factory, Databricks, Data Lake, Logic Apps), and automated manual data refresh processes with Power Automate, saving 6 analyst hours per week.
Owned technical onboarding for 5 new partner integrations on Indeed APIs, serving as sole point of contact from kickoff through production launch.
Managed 7 concurrent partner deployments in Salesforce CRM and supported the deployment of REST API integrations for data exchange, resolving escalations with Product, Engineering, Sales, and Client Services.
Lead developer for Tulip Interfaces in a GxP-regulated environment, mentoring 4 team members and setting development standards under 21 CFR Part 11.
Took the Tulip eCleaning Logs App from a single-site pilot to 9 buildings across three release waves, digitizing GMP cleaning documentation for 50+ operators and eliminating 50,000+ paper logs annually. Gathered URS from 5 stakeholder groups, wrote specs for developers, handled Go-Live and Hypercare, and trained 20+ end users.
Change Owner on 3 planned events, including the Wave 2 features release and the Tulip LTS Platform Upgrade. Wrote GxP validation documentation, wrote and executed 150 test scripts in ValGenesis, and managed change records in Veeva Vault with SMEs from cross-functional teams.
Advised the Roche Singapore Tech Ops team in weekly meetings and ran a live knowledge-transfer session with the Roche Switzerland Data & Analytics Lead.
Ran Scrum for a 4-person team (standups, sprint planning, demos, retrospectives) while also working as a developer and business analyst simultaneously.
Administered Salesforce CRM tracking 3,000+ GxP-compliant manufacturing devices and user access, supporting validation workflows and audit-ready data governance.
Gap Inc.
Technical Business Analyst Contract
Indeed
Technical Analyst Contract
Genentech
Data & Analytics Engineer Contract
Built for regulated environments.
Regulated Systems
GxP Validation & Compliance21 CFR Part 11Computer System Validation (CSV)Change ControlSystem Testing & Validation
Data & Development
PythonSQLPower BIPower AutomateREST APIsMicrosoft Azure (Data Factory, Databricks, Data Lake, Logic Apps)Git
Methods
Requirements Gathering (URS)User Stories & Acceptance CriteriaUATScrum MasterStakeholder Management
San Jose State University
Bachelor of Science in Business AdministrationManagement Information Systems
Languages
BasicProficientFluent
Let's talk.
Available for technical analyst and validation roles — remote or on-site in Northern California.