Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
California State University ,
Chico
Download Resume Format
Ruby Robert
309 Mohawk Way
Fair Oaks, CA 95001
Home: 916-534-9876
Email:ruby.robert@comcast.net
California
: Sacramento area or remote access
Objective
A
technology lead, systems analyst / systems designer / implementer role. Oracle tuning, database purge, reengineering
systems, improving Oracle applications
which need additional functionality or
need to work more efficiently, complex real time reporting: High tech complex
Oracle based solutions from ideas phase to running processes. 10g and 11g DBs (1-2
TB), high availability, ETL, and sensitive data experience.
overview
I
have worked 20+ years with Oracle and Oracle based technologies. I specialize in designing, programming, and
implementing Oracle 10g and 11g advanced database applications, tuning and
reporting on Oracle systems, many over a terabyte in size. Generally, I have been a team lead / project lead
in small distributed groups, implementing solutions to business-defined needs
ranging from full system implementations to reverse engineering systems so that
add-on technologies could be developed. I
have reverse engineered systems such as Epiphany, Clarify, Siebel CRM and
Oracle Financials, and have created numerous complex database systems from
scratch. I am an expert in data mining
and reporting via custom built web portals and email delivered PLSQL generated
reports with Excel and XML attachments as well as HTML content. I have implemented ISO 9000 reporting as well
as more advanced statistical trending models.
In most cases, I have also been responsible for administering the
systems I have built.
Current Skills matrix
·
Analyst, designer, programmer: CRM and other systems processes,
Oracle systems design and implementation, Oracle database design and
implementation, wide range of advanced programming skills.
·
Oracle data mining (Advanced PL /SQL, SQL and DB programming).
·
Oracle database design (Oracle 7, 8, 9i, 10g, and 11g).
·
Web: site design, implementation, and programming
(Java Beans, Javascript, XML, DHTML,
L…).
·
CRM expert (16 + years continuous CRM
experience).
·
Project management: Have managed and implemented numerous
complex technical projects typically requiring minimum down time on “high
availability” systems.
Experience
·
2010 – Present Contractor INT Technologies: 18 mth contract WellsFargo
Ø Projects
§ Designed, built and implemented advanced PL/SQL database purge
system in 1.4 terabyte Oracle 11g System.
System is 24/7 mission critical CRM workflow with full BCP and data
warehouse. Purge/archive volume is 30k
records daily via rule based program.
§ Ongoing tuning replacing complex join syntax with optimized pl/sql
functions and procedures. Reworking ETL
and main line code to identify and improve performance and harden system.
§ Table partitioning – ongoing effort to partitions tables in system
over 1 gig in size.
§ Participating in migration project to move Epiphany workflow CRM and
analytics data warehouse to 11g Oracle Platform.
§ Creation of ad hock reporting vial auto delivered email as needed by
internal business
·
2008-2010 Employee for Objective Systems Integrators (OSI)
Ø Duties
§ CRM System Administrator / Project manager
§ HR System Administrator / Project manager
§ SharePoint Administrator / Project manager
§ Applications consultant
Ø Projects
§ Designed and built replacement CRM system for OSI. System consists of a customer assistance front-end,
technical document library with Google-like search, Technical Assistance “CASE”
system, development “change request” system and an internal Help Desk. Database schema and all interfaces are custom
built by myself and a DBA. System was in
customer and employee testing with enthusiastic acceptance when company was
bought and outsourced.
§ Designed and built a high security HR Oracle database system for OSI
including corporate employee salary and comp system and employee review interface.
System used Oracle 11g grid system with 128 bit encryption and low level data
access policies. Schema and PLSQL / Java
web interface were designed and custom built by myself and a DBA and are used
by all employees and HR.
§ Implemented engineering group Wiki information system with tie in to
the new SharePoint system. Migrated
several thousand engineering technical pages into Wiki.
§ Implemented New SharePoint corporate information system. Developed templates for all departments and
migrated data from existing sources to new structure.
§ Implemented 20 email delivered dynamic management reports from Clarify
CRM to OSI management based on manager team memberships and development
responsibilities. Reports were written
in PLSQL and sent directly from the Oracle back plane and were delivered to
responsible managers before weekly meetings. Reports were instrumental in streamlining
overall “change request” customer case loads by over 50%. Report success and architecture resulted
directly in the implementation of the HR and CRM systems described above.
·
2007-2008 Contractor for Objective Systems Integrators (OSI)
Ø Projects
§ Wrote new IT web based Help Desk interface for use by all OSI
employees. 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.
§ Restructured CRM processes and tools to work with new OSI business
model and needs.
§ Designed and wrote data purge algorithms to purge 500 gigabytes of
non-OSI data from the transferred CRM systems Oracle schema.
§ Designed, managed and implemented Clarify CRM system split out and
transfer from Agilent Technologies in Colorado
to OSI’s new data center in Roseville ,
California .
·
2000-2007 Agilent Technologies
Ø Duties
§ Communications division CRM IT process expert, CRM system manager,
team lead.
§ Systems analyst: Helped plan, design and consolidate Agilent
division around a holistic CRM solution based on advanced 10g Oracle database
and tightly integrated custom client / web systems.
§ Process analyst: Helped design “best practices” CRM business
processes and worked strongly to implement a customer centric CRM process. Agilent system consisted of end to end
systems including direct custom customer and employee web access and
integrated Clarify CRM system.
§ Web system design and implementation expert: Java server, Java, JSP,
Java Beans, dynamic HTML, design and programming.
§ Oracle design and implementation expert: Oracle schema design and
implementation, DB tuning, advanced DB programming, advanced SQL data mining.
§ Clarify CRM expert: SME process expert, forms and schema coding,
migration (upgrade) and tuning.
§ CRM systems consolidation – team lead: Designed, coded and
implemented migrations from Siebel, Vantive, Auto Answer and other legacy
systems into Clarify CRM / custom Oracle schema.
·
1995-2000 Objective
Systems Integrators (OSI)
Ø Duties
§ IT software systems manager
§ System / process analyst
§ Web system design and implementation
§ Clarify CRM and Oracle Financials system manager
·
1991 -1995 3Net Systems
Ø Duties
§ C / C++ programmer, process analysis, team lead – medical
information systems
Education
Bachelor of Science
Computer Science –
Math Science Option Graduated
1991
Contact
Info
·
Robert F. Diekmann
·
US Naturalized Citizen-grew up
and have lived full time in US. Born in
Canada
·
Phone: Home:
916-967-9618 Cell: 916-640-6603
·
Email: thediekmanns@comcast.net
·
Address: 8791 Mohawk Way,
Fair Oaks, California, USA, 95628
Salary
Sr. Level - Consulting ok but fulltime preferred. Salary information and verification available upon request.
Download Resume Format
0 comments:
Post a Comment