Robert Diekmann Email & Phone Number

Fair Oaks, Ca, Us

Fair Oaks, Ca, Us

Sr Oracle Developer acting as a data Architect for California Student Aid Commission (CSAC) reverse engineering and documenting Oracle legacy systems.

Oakland, California, Us

+ 2014 - Nov 2022 - Full time Blue Shield of California IT employee - Development team lead for all projects ** Worked on exporting 1.5 tb sql-server CaseTrakker care management CRM system to Salesforce CRM. Responsible for writing export SQL and processes to move needed data from care management CRM to SaaS Snowflake data warehouse. ** Worked on adding new Medi-Cal ( Home Health (HHP) and Enhanced Customer Management (ECM) programs ) to the Care management data warehouse and created reporting Oracle dimensions and fact tables to enable needed reporting for these new additions. ** Worked on several BlueShield's Big Data projects as an IT analyst, Date Modeler and subject matter expert for Care Management data. ** Designed and created and have been maintaining Oracle Data warehouse connecting several medical management DBs ( CaseTrakker, Optum, Magellan ) together with master member database (Facets 150m record depository) for medical management reporting and analytics. I am a SME and team lead on these technologies. ** Altered Facets PL/SQL procedures to alter behaviors for new claim processing ** Designed and created Oracle authorization process to accept multiple provider auths and convert them into Oracle data mart format. Built front end filter process to pre-filter claims prior to moving through claim process. System significantly improved claim throughput process. ** Designed and created ETL between CaseTrakker SQL Server CRM application and Oracle 11g Data mart (now 19c). ** Reverse engineered the CaseTrakker SQL server Schema and translated it to an Oracle format for above ETL ** Designed and implemented reporting metrics and other transforms to the Oracle data mart to improve reporting and mine important analytic data from the CaseTrakker system. ** 2014 April - 2013 September - Aditi consulting inc, contracted to BlueShield to analyze and create a reporting capability against SQL Server CRM for the medical management division.

San Francisco, California, Us

+ 2012 – 2013, Contractor - Apex Systems, Inc: 15 month contract Wells FargoCurrent assignment to maintain and improve INfOR Outbound Marketing 1+tb. data warehouse and its ETL processes for an internal CRM database and reporting system.* Quarterly development to add new tables and columns to ETL and data warehouse to keep up with primary CRM system development releases.* Partitioning of data warehouse tables to improve maintenance and performance.* Rewriting/adding PL/SQL functions and packages to ETL process. Major project to enhance performance of ETL nightly data transfers and ETL reliability. Have so far reduced ETL runtime by over 2hrs nightly with phase 2 implementation increasing this to 4hrs nightly for an overall 150% improvement.* SQL mentor and writer for team and analysts

San Francisco, California, Us

+ Contractor - INT Technologies: 18 month contract Wells Fargo * Designed and implemented rule-based multi line of business PL/SQL database purge system in 1+tb. Oracle 11g 24/7 mission critical CRM and its 1+tb. Analytics Data warehouse: approximately 22 mil. records purged monthly on each system. Purge application implementation resulted in significant ROI due to significantly reduced organic growth, higher performance and easier maintenance (prior to the purge some objects were too big to be worked on in a 12 hr. window). * Reverse engineered and documented INfOR CRM including ER and data dictionary. * Created PL/SQL reports via scheduled and DB triggered email as needed by internal business and performance team. * Audit group and peer SQL support and mentoring * Advocate for strong Oracle technology utilization, group went from almost no Oracle out of box capability to active tuning, table partitioning, compression, PL/SQL programming and significant utilization of Oracle technologies. When my contract ended the systems were smaller, faster, more resilient and better managed.

+ 2009 - 2010 Employee for Objective Systems Integrators (OSI - Split from Agilent) + 2009 - 2008 Consultant for Longview Software Roger Hosier (current OSI CTO) * Designed and built Oracle-web based CRM system. System consisted of a web-based customer assistance center and internal “CASE”, “change request”, “library” and “help desk”. * Designed and built a high security HR Oracle database system and web application including corporate employee salary and comp system and employee review interface. System used Oracle 11g grid with encryption and low level Oracle data access policies and greatly streamlined internal employee review process. * Implemented Oracle PL/SQL business process reporting which significantly improved internal business process goal reporting and customer support SLA tracking. * Implemented New Share Point corporate web. Developed templates for all departments and migrated data from existing legacy web sources to new structure. * Implemented engineering group Wiki system using Share Point. Migrated several thousand engineering technical pages into new system.+ 2007-2008, Contractor for Longview Software setting up newly splitout Objective Systems Integrators from Agilent * Wrote new IT web-based help desk. Helped write and setup internal IT support process and policy based in part on this tool. * Extensively revised OSI’s internal Clarify CRM interfaces and processes as well as the customer facing CRM web interfaces. * Managed day to day operations of OSI’s Clarify system and set up and documented necessary support processes. * Designed and wrote data purge algorithms to purge 500 gigabytes of “Agilent” data from the transferred CRM systems. * Designed, managed and implemented Clarify CRM system split-out and transfer from “Agilent Technologies” in Colorado to OSI’s new data center in California.

Santa Clara, Ca, Us

+ 2000-2007, Agilent Technologies – Communications Division + Jan 1995 - Jan 2001 · OSI Technologies - bought by AgilentCRM Administrator / developer. Technical lead for acquisition CRM team* Consolidated telecomm division (from Siebel, Vantive, Auto Answer and other legacy CRM systems to a single Clarify CRM system, significantly modified schema and Clarify to accommodate change). Huge ROI and significant customer and employee benefit.* Wrote custom Oracle & Java dynamic web client used by customers such as Sprint, AT&T, Vodafone, and many others.* Oracle (design & implemented): DB tuning, advanced SQL data mining and web based reports.

IT software systems manager / process analyst - lead team of 6 IT team members who supported all OSI information systems. * Specified and purchased Clarify CRM (Amdocs) and Oracle Financials * Web projects (design & implemented): JAVA Oracle customer & Employee web portals * Oracle (design & implemented): schema improvement, DB tuning and auto monitoring reports, PL/SQL integration with Clarify DB, DB purge, SQL data mining and reporting on Clarify CRM platform.

C programmer, process analysis, team lead – medical information systems Btrieve DB