Sidney Orr

POB 519, Redwood Estates, CA 95044

(w) 408.596.0147 (skype:) 408.335.7371 (or sidneyorr)

sidneyorr@yahoo.com    or   sidney.orr@oracle.com

Summary

 

A versatile, collegial IT professional, sensitive to cost-effectiveness and experienced with a wide range of businesses and data architectures. Especially able as a liason between technical and non-technical colleagues. Experienced online conferencing and desktop sharing.  Always strong in life-cycle strategic initiatives.  Substantial data management/architecture experience, industry experience in Higher Education, Asset Management, Utilities, Finance, Manufacturing/supply chain, Health Care and Biological Sciences. Especially strong in real-time collabortive analysis, requirements gathering/client relations, reporting, generic middleware: EAI EDI ACH ETL; Batch scheduling, data mining, and RDBMS experience in depth.  Recent experience in Power Distribution Systems i.e., SPL OMS, OMS Web Interfaces,  generic Business Intelligence  (BI), reporting, warehousing & SPL BI,  testing (functional, system, regression), test case design and documentation, recent experience in billing and supply chain businesses processes and algorithms. SPL CC&M/Cordaptix (customer demographics, billing, and assets). Extensive experience with Oracle Financials internals, esp. Fixed Assets (FA).

Technical skills

 

·     Databases and Data Management: RDBMS: I have had a DBA job title several times; most recently with OneNetwork below.  Oracle through 10i, MS SQL-Server, DB2 (have  working knowledge of DML, DDL in Mysql, Progress, Sybase &  Informix) ,  strong generic EAI/ETL esp. with Datastage and hand-coded sqlldr,  and experienced and well understood: object-relational database design, SQL DML/DDL, and, and typical application objects; e.g., tables, views, stored procedures, triggers, synonyms, etc., strong data mapping, esp. ACH and EDI documents, and a strong working knowledge HTML,  XML schemas, XSL transformations for XML to XML, and SOAP functionality, with Altova XMLSPY and similar XML IDEs

·     ERP/CRM/CIS:  CC&B/Cordaptix (primarily for utilities “V” functionality esp. batch), Peoplesoft CIS and Peoplesoft Revenue Manager (primarily batch scheduling functional/technical skills, usually in supply chain, inventory customer master and items business processes), QAD (primarily EDI-driven financials and supply chain with dos & gui QAD portal environment).

·     Desktop/Client Software: Ascential Datastage TX & non-TX IDEs, SQL Developer, SQL Navigator, Toad, Winsql, WsFtp, Visio- esp for UML & system symbols, MS Office applications: Project, Excel, Word, Outlook, Power Point, Access (and Open Office 1.n workalikes), PDF, PS Elements 2θ4, Photoshop 7/CS2, Erwin, UML, PGP for windows and Unix, SSH suite esp. Sftp, Change Management: CVS, Visual Source Safe (VSS) & ISIL CM, Scheduling: UC4 (desktop/client+mainframe) & Autosys (client+mainframe)

 ·     Platforms/Environments: Linux (esp. Enterprise Red Hat),  Unix Sun & HPUX, Windows, IBM S390 Mainframes, n-tier, (fluent with a common several dozen Unix primitives - ls, telnet, ps, cp, mv, grep, ftp, more, pwd, vi, vim, pico etc. Have used and developed in Unix environments for > 15 years)

·     Mainframe Experience: TSO, ISPF, QMF queries and procs, CLIST, REXX (incl. ISPF and embedded SQL APIs), CICS macro/command, InterTest, Xpeditor, DBEDIT, roscoe, datacom/db, ca/dataquery,

·     Languages: SQL, PL/SQL, TRANSACT-SQL, PERL, PHP, , REXX. – primarily regular expressions &. CGI, COBOL, C, UNIX C/korn shell, Knowledge of Java JSP/J2EE (architectures) and XML schemas for specialized lines of business. 

Experience / Contracts / Employment

 

 

Technical Manager/Functional Architect

April 2006 – present

                     (employee)

     

 

  Oracle Utilities Global Business Unit.

·     Outage Management System (OMS) – real-time power distribution systems; 2-D display; middleware interfaces – esp. for automated meter reading (AMR); and business intelligence (BI) data warehousing  - fact-dimension data modeling – outage breakdown statistics; environment: unix/linux (in vmware instances), working knowledge of WSDLs, XSLT, & J2EE for AMR middleware, oracle 10, sql developer, Java θ Eclipse IDE. Working knowledge of J2EE: designed data base objects, incl. triggers for Automatic Meter Reading (AMR) and some JDBC for data management (synchronize OMS model customer meters CU_METERS with AMR meter staging table, AMR_CU_METERS); developed database invocation of (unix/linux) host script via batch process; working knowledge of UTL_DBWS package for web services invocation from (pl/sql) stored procedures.

·     Utilities Customer care and Billing Application Support, BA/SA support for SPL clients, for “V” business model (customer information, premise, account,

 metering, interfaces,  workflow, batch, rates, billing, sales & marketing, field activities. Business & Project Management, MS Project - emphasizing specific  SPL methodologies. BI (business intelligence) data warehousing: fact-dimension data modeling for financials breakdown statistics.

 

 

EDI Analyst

Aug. 2005 – March 2006

                      (contractor)

 

Sandisk Corp, Sunnyvale, CA

·     EDI system support: Purchasing, Invoicing, Shipping, Point-Of-Sale docs and related workflow analysis, QAD ERP simulations, Progress queries, and test plans to support primarily X12 EDI financial and supply chain transactions (primarily 810, 850 and 852 – purchase orders, sales orders, invoices, point-of-sale information) and corresponding EDIFACT docs. Trading Partner configuration and problem resolution, and resolution of customer vs. vendor, parts master and item cross-reference issues in Gentran and QAD.

 

 

 

Senior Programmer Analyst / Systems Integrator / Testing Analyst

Sept. 2004 – July 2005 

                      (contractor)

 

Areva Transmission and Distribution; San Jose, CA

·     Developed system test procedures and performed system testing for e-terrasettlements product – an application for settling trades in energy markets. (GUI functionality, middleware EAI & EDI utility test plans, system integration – esp. JBOSS/WAR change management (VSS).

·     DBA (hand-coded ETL)  support mapping external (trading partner, financial settlements) data to targets, loading and cleansing with SQLLOADER, MS excel, DOS .bat files technology

·     Settlements charges and Billing cycle configurations for the California Independent System Operator (CAISO, i.e., XML schema maintenance, XML-Oracle schema synchronization with xmlspy and xlst tools.

·     Provided SDLC support for the CAISO implementation. Co-authored the system installation guide, which also included the installation and configuration of JRun, JBOSS, JDK, Oracle, Sql Server, and Mathematica.

 

Systems Analyst/Technical Writer

June 2004 - July 2004

 (contractor) 

 

Beverly Corporation; Ft. Smith, Arkansas

·     A majority of time interviewing senior analysts, team leads, management, for details of mainframe-based processes, in formal, and semi-formal, recorded sessions, guided by scripts, but completely inflexible, and able to develop comfortable and productive relationships with all business client colleagues

·     Sarbanes-Oxley Documentation, Interviews For COBIT Controls, Analysis, Remediation, Robust English

·     RUP-influenced system analysis: who+what+when+where+how+evidence

·     Subject Matter Expert: DB2, Oracle, Cobol, Panvalet/Panapt, Roscoe, CA/Dataquery, UNIX/AIX

·     Healthcare Systems Analysis, Requirements, GAP analyses, EDI/HL7 Application Analysis

 

Utilities Systems Analyst/Developer

Jan. 2004 – April 2004

 (contractor)

 

City Of Sacramento; Sacramento, CA

·     Interviewing system and business managers, gathering requirements for batch interfaces for critical business processes for financial, meter, and field order processes.

·     SPL CIS (PeopleSoft) Implementation: Reengineering Legacy Utilities Billing systems.

·     SPL PeopleSoft CIS Functional Areas: Payments/Remittances, Meter Reading Upload/download, Service Agreements, Field Activities/Orders, Mass Updates.

·     PS web server, Process Scheduler, Application Server re-configuration & naming conventions, esp. directory trees, to support customized applications.

·     Batch window definition, testing, documentation, training, coordinate with business users.

·     Interface development: Payments-Remittances; Meter Reading/Mapping, communication with external clients via ACH (payments/remittances, ETL specifications SQLLDR scripts for GL datamart accounts reporting) and EDI (vendor / trading partner maintenance, supply chain transactions )

·     Workflow/Field Service Order Analysis, GAP analyses of PS Workflow vs county business processes.

·     Technical Writing following UML emphasis on roles & RUP emphasis on system behavior.

  

Consulting Systems Analyst/Developer

Aug 2003- Nov. 2003

 (contractor)  

 

Seniors Only Financial; San Mateo, CA

·     Desktop productivity tools.

·     In a very small business,  collected and implemented Client requirements for Goldmine Schema and developed Presentation Enhancements.

 

Senior Systems Analyst

May 2003 – July 2003

 (contractor)

 

ADP; San Ramon, CA

·     Interviewing legacy system developers and managers - long removed from the systems, recreating old processes and dataflows, fitting to modern tools collaboratively

·     Legacy Systems SDLC for Automobile Claims Process incl. salvage, inventory, labor costing/workflow via EDI files

·     Heavy Technical Writing in PMM2-3 Environment, following modified UML, RUP methodology

·     Heavy Cobol/CICS analysis with Intertest, Roscoe, CA/dataquery

 

Senior Utilities Systems Analyst/Developer

Oct. 2000 – May 2003

 (contractor)

 

PG&E; San Francisco, CA

·     SPL CIS (CorDaptix) Implementation

·     Achieved superior client relations, from collaborative work over a long period, reengineering from scratch, a CIS system with a full range of enterprise functions, and a full range of colleagues – many purely business and many purely technically-oriented; with constant editorial review and feedback via email, and formal document specifications walkthroughs.

·     Legacy Systems Reengineering SDLC (mainframe Cobol, DB2 -> new world) – primarily metadata architecting EAI “wrappers” for legacy EDI and ACH, and other flat-file data. Uni-directional (ETL) scripting with SQLLDR, Datastage, Perl for mass updates datamarts.

·     SPL CIS CorDaptix Functional Areas of the “V” (ERP) data model : Payments/Remittances, Meter Reading Upload/download, Service Agreements, Field Activities/Orders, Mass Updates

·     Datamart development emphasis: transient, daily-materialized snapshot aggregates of transactions

·     Successful design, build, deployment of two dozen + applications-interfaces-systems

·     Broad Scope Of Applications SDLC responsibility: Mass Updates, Demographics & DSS reports, Warehousing design and build for Informatica, Brio, and Crystal repositories and tools.

·     Broad Scope of Technology: O-O EAI, Middleware with SSH & PGP w. Perl wrappers, Mainframe, Unix, Windows-NT Servers

·     Broad Range Of Clientele : Internal and External (i.e., Dun And Bradstreet, Calif. Dept. Of Justice)

·     Authored & led JADs re a Full Range of Technical Documentation following UML/RUP process technology and coordinated large module development, incl. Extensive use of MS Project and tasks definition, sizing, deliverables, metrics. 

(Some PG&E references: Jess Altuna, Gena Hanson, Ruth Sylagyi, several others on request)  

 

DBA/Developer/Systems Analyst

Jan. 2000 – Sept. 2000

(contractor)

 

OneNetWork; Los Gatos, CA

·     P2B, B2B Ecommerce Stored Product Development

·     The primary business-analyst-developer for an ACH-genre product, coordinating a small group of business analysts and designers, as well as data administration and data base management.

·     Oracle DBA and SQL-Server DBA supporting Development (sole DBA in enterprise) created and managed multiple instances in each environment. (heavy pl/sql and transact-sql development, Perl for data cleansing and ACH and EDI file parsing and uploading to target Oracle staging tables)

·     SDLC: modeling, documentation, black box-> white box decomposition for stored-value visa-branded cards. Extensive use of MS Project and tasks definition, sizing, deliverables, metrics. 

·     DSS, ad-hoc, QA reporting, production ETL design, esp. giftcard debits/credits aggregation and staging table schema design.

·     Stored-Value VISA-MC-branded database design: schema, all database objects and APIs for Coldfusion Presentation (giftamericard stored value card product, and net shopping mall products)

·     HP IPS (Integrated Payment System) Configuration And Testing primarily amidst Sun Solaris environment

·     System Operator (stored-value cards sys. management and liaison with partner banks esp. Keybank)

 

Valuestar, Oakland, Calif. (contractor)

Oct. 1999 – Jan. 2000

 (contractor)

 

 

·     Sr. Systems Analyst, Database/EAI Developer, Project DBA

·     Team leader of a small group of data mapping specialists, mentoring, and refining workflow, and providing technical assistance in a variety of software and hardware situations. Extensive use of MS Project and tasks definition, sizing, deliverables, metrics. 

·     Data mapping & transformation with EAI, for target Oracle rdbms instances, from source flat files

·     Application Development with Oracle Forms, Oracle Designer & Developer

·     ETL scripting & business requirements for operational dimensional datamart of provider certification info

·     UML environment gather, refine, & document use case info for integrated national Certifications metadata

 

 

Stanford University, Stanford California (employee)

SLAC:

(employeeθ contractor)

 Oct. 1989 –June 1995;

Campus ITSS:

  Jan. 1997 - Oct. 1999  

                   (employee)

 

·     Principal Application Software Systems Developer (employee)

·     Responsible to a separate business organization, though based in a technical group, to coordinate, gather requirements, and implement enhancements to  real- financial modules, batch processes, and problem reporting and fixes from the manufacturer, following detailed discussion with vendor support analysts.

·     Oracle Financials, primarily Fixed Assets (FA) and (GL) SDLC: installation, configuration, migration. Communication with external vendors – management of incoming/outgoing EDI files for FA.

·     Genomic data cleansing, normalization, loading, and schema design for  genomic datamarts of researcher/colleague and gene expression data (see publications below) via Oracle SQLLDR

·     Peoplesoft Environment:  Peoplesoft financials (GL, asset management,  generic supply chain business processes), Tools/Application Designer (Field/Record design), SQR reports, Process Scheduler, Reporting Server, Configuration Manager, Query

·     Business Analysis, scripting for Ad Hoc & DSS Reporting, Data Cleansing for Business Clients, Supply Chain analyses and reporting of trading partner, and item master cross-reference issue resoolution

·     Mentor less-experienced colleagues; collaborate with many & varied business clientele

·     Structured SDLC, early user of UML technology for analysis, documentation

Oracle technology, esp. Perl w. CGI, DBI for Genomics research (see publications below)

Stanford Linear Laboratory: Telecommunications Analyst

·     Telecom System Workflow SDLC (move, add, change, pager, repair, cabling telecomm services)

·     End-to-End system responsibilities: Presentation/data entry screens, Middleware, Back-end

·     Reengineered From vsam & flat files to Oracle Rdbms

·     Peoplesoft Tools (HR-schema, SQR, Application Designer: field/record design, batch process scheduling)

·     Built, Designed, Operated a robust, stable transaction and reporting application for entire tenure

·     Host-Northern Telecom Switch Interface development

·     Enterprise Management Systems Committee member 

 

 

 

Safeway Inc., Oakland, Calif. Sr. Analyst  tech lead: training database development: physical & logical database design, ER & DFD data modeling, capacity planning, tech support for training environment/database and trainers. (environment: DB2, QMF, COBOL II, REXX, Erwin, Project Workbench (PWW), MS Access)

March '95- Jan. '96

(contractor)

 

PG&E, San Francisco, Calif. Sr. Analyst: programmer/analyst for client-server development of Tree Maintenance/Inventory system: complete life-cycle development of conversion from and enhancements to legacy system: ER, DFD data modeling, reports, stored procedures, triggers. (environment: MS SQL Server, BCP, MS Access, OLE 2.0, Windows NT 3.1, Transact SQL, FTP PC/TCP suite, MS ADT, MS Upsizing tool, Lotus Notes, VSAM, DB2, COBOL II, TSO/ISPF, Wylbur, Project Workbench)

 

July '94- March '95

(contractor)

 

 IBM Corp., San Jose, Calif. Sr. Programmer Analyst: Storage Systems Division: ad-hoc DSS reports and data cleaning reports for storage products shipments and supply chain management; (environment: QMF, OS/2, Windows 3.1, ESSBASE, Lotus 123, Lotus Notes, SQL/DS, DB2, SAS and SAS/SQL interface for reports development,  ISPF Dialog Manager, REXX, DB2/2, IOS3270 )

 

January '94 - July '94

(contractor)

 

Intel Corp., Santa Clara, Calif. Sr. Programmer Analyst: Design, programming, technical support for Intel's corporate video room and audio bridge (Allegro, Northern Telecom) reservation system: business process analysis, performance tuning; DSS /ad hoc reporting and reporting with statistical packages; user liason. I was the primary technical support for the system with ~6 full-time schedulers. I also helped port the mainframe system data base & reports to the MS Server/Sybase/MS Access environment. (environment: TSO/MVS/DB2, CICS (command & macro), QMF,  COBOL, Erwin, Windows, MS Access, Visual Basic, MVS /TSO, ISPF dialog manager, REXX) 

 

August '92 - Jan. '94

(contractor) 

 

Wells Fargo Bank, San Francisco, Calif. DBA/Data Administrator: Automated Transactions Group,  project DBA/DA, physical and logical schema and index design to support automated-operator system via COBOL II, of real-time IO, and QMF  reports; query tuning with "explain" and related tools and PM. (environment: DB2, COBOL, CICS, QMF, ISPF, TSO, CLIST, REXX, VM/CMS) 

 

January '92 - April '92

(contractor)

 

California Medical Review, Inc. San Francisco. Tech Lead, DBA/DA; configured RDBMS products; tech lead VSAM- to SQL/DS and EDI data base conversion team; developed business models, documentation standards, many reports via SPSS and SQL hand-coded etl techniques, and prototype applications for health care systems, including extensive support for Health Care Financing Administration (HCFA) requirements. (environment: ADW CASE, QMF, SPSS,  OS/2, EDI, SQL/DS, DOS/VSE, ISPF, Cobol.

April 1991 - Dec. '91

(contractor)

 

 

For complete earlier experience, please see also http://www.orlovitz.org

 

Education

 

University of California at Los Angeles (UCLA)

1970

 

Los Angeles, CA

·     B.A., English

 

California State College, Dominguez Hills

1970-1975

 

Dominguez Hills, CA

·     M.A. Program, English

 

University of California at Los Angeles (UCLA)

1975-1978

 

Los Angeles, CA

·     Graduate courses in Educational Research, TESL, Linguistics, Computer Science

 

Publications

 

http://genome-www.stanford.edu/Saccharomyces/nar2000.pdf   (genomics – oracle data bases designs )

 

·     A Concordance to the Poems of Ben Jonson. Ohio University Press. 1978.

(Co-Authored with Steven R. Bates)

 

·     A Concordance to the English Poems of Andrew Marvell. University of North Carolina Press. 1975.

(Principal programmer and editorial and production assistant for the author, G. Guffey)

 

·     A Concordance to the Poems of Thomas Traherne. University of California Press. 1973.

Principal programmer and editorial and production assistant for the author, G. Guffey

 

·    An established artist in the past decade, and a standimng invitee to the Venice Biennale…

Featured Artist,  Mid-2003 onward, and  Featured Artist/Works many times at artsig.com (orlovitz)–  one of the largest peer-reviewed art galleries in the world – also well-reviewed and popular galleries at artwanted.com  - pursuant to interests in digital art and computer graphics ). An att blog with commentary and better art at http://dofaust.deviantart.com

 

 

 

 

 

 

 

 

 

 

 

 

 

 

setstats1