Résumé & references
Robert Diekmann · Senior Data Architect · Oracle PL/SQL Engineer · Development DBA
30+ years building Oracle warehouses and web applications. Open an employer for project details and excerpts from written recommendations on my LinkedIn profile.
Technical depth & leadership
- Traditional Oracle warehouse design using Kimball and Inmon approaches, including facts, dimensions, star schemas and integration with enterprise reporting.
- End-to-end information management: application data capture, ETL pipelines, warehouse ingestion, metadata, lineage and downstream reporting.
- Development DBA work: schema design, SQL/PLSQL tuning, indexing, partitioning assessment, bulk processing and operational troubleshooting.
- PL/SQL, SQL Loader, Informatica and Dell Boomi experience; supporting Python and AI-assisted analysis, testing and documentation.
- Technical and team leadership, developer mentoring, coding/modeling standards, Agile delivery and Jira stories.
- Work across business, architecture, clinical, analytics, development and QA teams to make technical decisions understandable.
Professional experience
California Department of Justice · 2026 · 7 monthsReference: Manoj Gopalakrishna · Senior Technical Analyst
CALIFORNIA DEPARTMENT OF JUSTICE · SACRAMENTO
DOJ project experience
Senior Oracle Developer / Data Architect
Consultant through Delegata / Promantis · January–July 2026
I joined as technical lead, helped restore project momentum and moved the work toward acceptance. The focus: a consistent, traceable path from complex legacy data to a dependable target architecture.
Architecture approved
Designed and gained DOJ approval for a Bronze/Silver/Gold Oracle architecture connecting 14 large, remote legacy firearms systems.
Bronze framework delivered
Designed, coded, tested, demonstrated and delivered the DOJ-accepted Bronze framework, with configuration-driven source movement and change capture.
Silver/Gold processing designed
Designed person-centered assembly, matching and reconciliation, with lineage and controls that block authorization until uncertain matches are resolved.
The delivery also included Bronze and Silver prototypes. Operational Bronze processing, prototype work and later Gold application goals are distinct.
Installation, training and support. Delivered Bronze and Silver installer packages and helped DOJ staff install the software on their own systems through training and hands-on support. The handoff combined code with practical knowledge for the receiving team.
More about the engineering approach
The architecture provided a consistent path from source to final output, safe restarts and a complete audit history. The delivered Bronze framework included logging, diagnostics, testing and operational controls.
The Silver/Gold design brought together person-centered records, explicit matching rules and reconciliation for uncertain matches. The emphasis was on preserving business meaning and making decisions traceable. Rule-driven ingestion, checkpoint matrices and promotion logic supported deterministic, restartable movement and controlled advancement through the synchronization design. I worked with DOJ and partner teams on event models, operational workflows and data contracts.
Value for a client: technical leadership that connects architecture with working code, clear evidence and an explainable handover.
Professional reference
Manoj Gopalakrishna
Senior Technical Analyst for the FITSM Gun Modernization Project at the California Department of Justice.
[email protected]
Contact preference: Please contact Manoj by email first, before arranging a phone interview.
California Student Aid Commission · 2023–2025 · 1.5 yearsReference: Dora Acker · my manager and CSAC Chief Information Officer (CIO)
Understand a system before you change it
California Student Aid Commission · November 2023–March 2025
Reverse-engineered a complex Oracle grant-processing system and authored a 450-page reference supporting modernization and audit readiness.
Explore the CSAC work
Uncovered data flows, dependencies and PL/SQL business logic. Reconciled conflicting tribal knowledge through interviews, then documented the system with schema diagrams, lineage maps, flowcharts and dependency matrices so technical and business teams could work from a shared understanding.
- Mapped ingestion, staging, rules processing and reporting across Cal Grant, Dream Act/DACAA, Chafee and other grant programs.
- Clarified batch workflows, schema interactions and transformations dependent on Department of Education data.
- Identified opportunities to improve ETL workflows, schema organization and cross-system integration.
- Gave leadership, development, QA and business teams a shared view of end-to-end processing.
The work combined technical investigation with interviews to resolve conflicting accounts of system behavior.
Written recommendations
Excerpts from LinkedIn recommendations.
Dora Acker · My manager and CSAC CIO
My manager and Chief Information Officer (CIO) at the California Student Aid Commission · Recommendation dated February 21, 2025
“Robert has been an invaluable member of the IT Application Services team, particularly excelling in reverse engineering the system to produce documentation.”
“Collaborating with the team's subject matter experts, Robert excelled in delivering the CSAC Applications ITSD Overview Manual.”
“He is highly proactive, an excellent team player, and deeply committed to his responsibilities.”
Blue Shield of California · 2014–2023 · 9 yearsReferences: Gian Montesini (my manager); Jomond Wong, PMP, CSM (project manager)
Make captured data ready for reporting
Blue Shield of California · 2014–2023
Built nightly PL/SQL ETL and a star-schema Care Management warehouse for approximately 800,000 members; served as technical lead and subject matter expert for facts, dimensions and ETL.
Explore the Blue Shield work
- Designed, built and maintained Oracle Care Management facts and dimensions, with a nightly ETL written from scratch against the CaseTrakker source system.
- Integrated CaseTrakker CRM, clinical, demographic, member, utilization, claims, Medicare and provider data for care outreach, analytics and reporting.
- Built the enterprise medical-management data mart during the initial 2014 consulting engagement and expanded it in the subsequent employee role.
- Provided business/reporting SME support and worked with architecture, clinical and analytics teams to align data structures with their needs.
- Built ETL for Medicare/Medi-Cal and regulatory reporting.
- Used Dell Boomi for the first 837 export supporting community care-management vendor payments.
- Engineered and tuned nightly PL/SQL integration with an enterprise warehouse covering 3M+ current and historical members, resolving member keys and delivering company-wide data at nightly freshness.
- Used partitioning and bulk-processing patterns in high-volume PL/SQL and Informatica pipelines.
- Performed schema tuning, SQL/PLSQL optimization and performance troubleshooting.
- Mentored the ETL/warehouse team and established coding and modeling standards to improve consistency and maintainability.
Written recommendations
Excerpts from LinkedIn recommendations.
Gian Montesini · My manager
My manager at Blue Shield of California · Recommendation dated October 24, 2022
“He is quick to understand requirements and translate them into actionable items.”
“Robert speaks his mind and is not afraid to "become part of the solution" as needs arise.”
“In addition to his technical skills, he is very good at recognizing others for their contributions and establishing strong working partnerships.”
Jomond Wong, PMP, CSM · Project manager
Project manager at Blue Shield of California · Recommendation dated July 21, 2022
I worked extensively with Jomond on most of my later Blue Shield projects.
“He is thoughtful in his responses and breaks down complex technical idea/solutions to the business resources without any sense that he is "talking down" to them.”
“He actively listens to every member of the project team and business resources.”
“Robert is adaptable to new situations and changing environment at both the corporate and project level.”
Wells Fargo · 2010–2013 · 3 years
Keep processing efficient as data grows
Wells Fargo · 2010–2013
Optimized SQL/PLSQL and ETL for the nationwide ATM CRM Help System.
Explore the Wells Fargo work
Built a rule-based PL/SQL retention engine to manage obsolete CRM and analytics-warehouse data and control organic growth.
- Maintained and improved the Oracle backend of the INFOR CRM system and its warehouse.
- Rebuilt and tuned nightly ETL to improve stability and throughput.
- Used warehouse partitioning to support maintenance and performance.
- Reverse-engineered and documented the CRM data model.
- Created automated PL/SQL reports for business and performance teams.
- Performed schema design, Development DBA tuning and SQL/PLSQL optimization.
The work connected application performance, warehouse maintenance and nightly data movement.
OSI
Objective Systems Integrators (OSI) / Agilent / HP · 1995–2010 · 15 yearsReferences: Duane Boeck (Master DBA); Jeff Lombardi (long-term manager); Stuart Haven (manager)
Capture and use information through the web
Objective Systems Integrators (OSI) / Agilent / HP · 1995–2010
I started with Objective Systems Integrators (OSI), which was later acquired by Agilent. This career period spans my work across OSI, Agilent and HP, through acquisition and organizational changes.
Built web applications for capturing, sharing and using support information, backed by Oracle. This included an award-winning internal support application and web-based reporting.
Explore the OSI / Agilent / HP work
Consolidated Siebel, Vantive, Auto Answer and other telecom CRMs into Clarify through major Oracle redesign. Built an Oracle/web environment with CRM, portal, document library/wiki and IT help desk. Led development, mentoring, standards and DBA design/tuning.
- Designed and maintained customer and employee support portals using Apache/Tomcat and PL/SQL backed by Oracle.
- Built Oracle data marts linking CRM information to enterprise reporting, including reporting instances created by reverse engineering source systems.
- Customized Clarify CRM and the internal customer change-request system.
- Consolidated telecom CRM systems and supported the later separation of Clarify from Agilent into the spun-off OSI environment.
- Managed IT software development and process analysis in the original OSI period, then continued technical leadership through acquisition and spin-off changes.
Across these phases, the emphasis was complete support information systems: web capture, customer assistance, shared documents, search and reporting.
Written recommendations
Excerpts from LinkedIn recommendations.
Duane Boeck · Master DBA
Master DBA at OSI / Agilent · Recommendation dated August 23, 2013
I worked extensively with Duane on Oracle database work.
“He is very knowledgeable as a pl/sql programmer and understands how writing pl/sql code interacts with the database.”
“Working with Robert on different projects, I found him very motivated to find the best solution to getting the project completed and on schedule.”
Jeff Lombardi · Long-term manager
My manager at OSI / Agilent · Recommendation dated May 11, 2012
Jeff was my manager for most of the 14 years I worked at OSI and Agilent.
“I found him to be very creative in developing solutions with keeping the end customer in mind.”
“He developed successful applications for my support team to use as well as our end customers.”
“Robert helped drive a positive change in direction for our customers as well as our employees.”
Stuart Haven · Manager
One of my managers at OSI / Agilent · Recommendation dated April 13, 2012
“He has great skill in solving problems and seeking for solutions that are simple and elegant.”
“He works well as a team player, mentoring other team members to develop their skills and knowledge.”
“His understanding of Oracle and the internal processes is excellent and has helped him to solve many problems.”
3NetEarlier pharmaceutical systems · 3Net
Helped build a pharmaceutical information system using C++ and Btrieve database libraries, and managed an IT development team. This earlier experience broadened my background in application data capture, information management and team leadership.
Education
California State University, Chico
B.S. Computer Science · Math/Science; Machine Intelligence & AI
Robert Diekmann's Dev Demo Platform