Business Analysis
Requirements gathering, stakeholder interviews, process mapping, business rules, acceptance criteria, impact analysis and translation between business and technology.
Available for projects
Luiz Gonzaga de Araújo
Senior Business Analyst & Senior Oracle PL/SQL Developer
I turn complex business rules into integrated, auditable and sustainable Oracle solutions.
Technology professional with 8+ years of experience in high-complexity environments, combining business analysis, Oracle PL/SQL development, process automation, integrations and hospital-operations expertise.
Oracle PL/SQL • Business Analysis • ERP Tasy • APIs • Automation • Governance
oracle · pl/sql · session
live
1-- ERP -> external API integration
2CREATE OR REPLACE PROCEDURE sync_orders(
3 p_batch IN NUMBER,
4 p_hash OUT VARCHAR2
5) IS
6 -- incremental load + audit
7BEGIN
8 FOR r IN (
9 SELECT id, payload, updated_at
10 FROM stg_orders
11 WHERE batch = p_batch
12 AND status = 'PENDING'
13 ) LOOP
14 post_json(r.payload);
15 log_event(r.id, 'OK');
16 END LOOP;
17 COMMIT;
18END;
19/
build 12.2 · schema HISexec: 42 rows · 118 ms
Professional indicators
8+
years of experience
7
selected professional cases
12k+
accounts in documented automated flow
34k+
records in outpatient processing
Volumes shown represent the operational history of documented flows and not exclusive attribution of authorship.
About me
Business and technology in the same decision process
I'm a Senior Business Analyst and Senior Oracle PL/SQL Developer, with experience in technology applied to high-criticality hospital, administrative and financial processes.
My work combines functional analysis and technical development. I take part in the complete lifecycle of each demand: problem understanding, requirements gathering, business-rule mapping, impact analysis, solution design, development, testing, homologation, documentation, change management, deployment and support.
I have solid experience with Oracle Database, SQL and PL/SQL, including complex queries, packages, procedures, functions, triggers, sequences, jobs, asynchronous processing, exception handling, logs and auditing.
I act as a bridge between users, business areas, vendors and technical teams, seeking solutions that are executable, traceable, secure and sustainable.
Services
What I deliver on technology projects
Seven complementary work fronts, from business understanding to sustaining critical solutions in production.
Oracle PL/SQL Development
Development and maintenance of queries, packages, procedures, functions, triggers, sequences, views and jobs in Oracle environments.
Optimization and Performance Analysis
Query diagnosis, execution-plan analysis, logic review, reduction of unnecessary processing and identification of causes of slowness or inconsistency.
System Integrations
Integrations between ERP, REST APIs, Web Services, external services and asynchronous routines, with handling of status, errors, responses and reprocessing.
Process Automation
Automation of financial, clinical, administrative, billing, collection, authorization, auditing and access-management flows.
ERP Tasy and Hospital Processes
Functional and technical analysis of processes involving the patient journey, billing, authorization, auditing, accounts, collection and hospital-ecosystem integrations.
Governance and Documentation
Technical and functional documentation, change management, logs, audit trails, acceptance criteria, risk analysis, homologation and controlled deployment.
Skills
Areas of expertise with anonymized examples
Filter by interest and open each skill to see how it materializes into real, always anonymized cases.
Selected projects
Anonymized cases from corporate healthcare environments
All projects have been anonymized to preserve confidentiality, information security and the intellectual property of the organizations involved.
Way of working
From the real problem to sustaining the solution
- 01Discovery
Understanding the problem, context, stakeholders, constraints and business goal.
- 02Elicitation
Process mapping, requirements, rules, exceptions and impacts.
- 03Design
Architecture, data model, flows, integrations and acceptance criteria.
- 04Development
Oracle PL/SQL implementation, integrations, error handling and logs.
- 05Validation
Technical tests, business tests, homologation and regression analysis.
- 06Deployment
Documentation, change management, versioning, rollback plan and go-live.
- 07Support
Monitoring, root-cause analysis, fixes and continuous evolution.
"An automation is only complete when its rule is understood, its behavior is traceable and its operation can sustain it."
Professional trajectory
A decade working in corporate environments
- 2023 - Present
Senior Consultant
Work on Oracle PL/SQL solutions, ERP Tasy, integrations, automations, billing, authorization, collection and critical processes.
- 2022 - 2023
Senior Development Analyst
Development and support of integrations, automations, requirements analysis and data routines in a high-complexity environment.
- 2021 - 2022
Consultant and Developer
Functional and technical consulting, development of routines, reports, customizations and homologation.
- 2020 - 2021
ERP Implementation Consultant
Process mapping, parameterization, integration tests, training, go-live and stabilization.
- 2019 - 2020
Systems and Support Technician
Systems support, incident handling and operational continuity in a critical environment.
Education
Academic and technical background
MBA in IT Management
FIAP
2025 – 2026
Systems Analysis and Development
Instituto Federal de Educação, Ciência e Tecnologia de São Paulo (IFSP)
2017 – 2019
Electronics Technician
CEP Tancredo Neves
2013 – 2015
LinkedIn
Let's connect
Visit my LinkedIn to see my full trajectory, experience, recommendations and professional posts.
Contact
Let's talk about technology, processes and Oracle solutions
I'm open to professional opportunities, consulting projects and challenges involving business analysis, Oracle PL/SQL, ERP Tasy, integrations and process automation.
This site does not use a fake contact form. All communication happens directly by email or LinkedIn, ensuring transparency about the channel used.