Oracle Hyperion Dba

PROFILE SUMMARY

Comprehensive accomplishments in IT involving database development, analysis and administration, and full-stack software engineering; systems analysis, programming, and web development. Oracle Magazine's ACE. Speaker at Oracle Open World.

QUALIFICATIONS

Database Engineering and ETL Development and Architecture

Over twenty years of successful installation, upgrades, migrations and HA performance optimization of Oracle and Microsoft SQL Server, including database, instance, I/O, ETL models, OS and Storage Stack, and SQL tuning.

Backup and Recovery/Disaster Recovery (BR/DR) implementation in Unix, Linux, and Windows platforms.

Artificial Intelligence (AI) and Machine Learning (ML) Models

Comprehensive AI knowledge and algorithms with machine learning methods and techniques in Oracle Machine Learning Chatbots, discriminative/generative, supervised/unsupervised ML models, CLIPS, Coreograph/NAO robotics visual programming.

Software Engineering

Hands-on coding expertise in full-stack development and production database engineering, including datawarehousing scenarios (DSS/EIS), using IBM RUP, CMMI, SADT, XP, Agile, Spring, Scrum, Web Services, Java, J2EE, Oracle ADF and .NET.

Full stack intelligent designer, data modeler, and architect (Normalization, ERX, IDF1X, Crow's Foot, Barker, UML).

Management and Technical Writing

Supervision of small-to-large DBA, development and business analysis teams, as program lead, including definition, planning, provisioning, resource / timeline management; (SDLC, SADT, RE, ILM, IAM, ITIL, BPM); PMI’s PMP training.

Research paper author with great documentation expertise.

Research

Competitive research expertise in full-stack software engineering with focus on software reengineering and refactoring via the RETPN Reverse Engineering Paradigm; physics, math, and probability; genetic / biological databases; AI, and Machine Learning.

Statistical Methods

Quantitative, Statistical, Financial Math, Biostatistics, and BI Analyses, utilizing SAS, R, S, SPSS, MathLAB, PRM, and Excel.

EXPERIENCE

2002-Present Principal Consultant, ADN R & D, New York, NY

09/15 - Present Independent Researcher, ADN, New York, NY.

Performs independent academic and data science research, AI, and machine learning, probability, statistics, and mathematical methods on STEM apps. Utilizes OVB, Oracle SQL, PL/SQL, Java, R, AWS, Python.

08/16-06/17 Professor / Business Analyst, NJCU, Jersey City, NJ.

Executed various business, purchasing, and curriculum analyses. Taught Software Engineering, Operating Systems Concepts (based on Linux kernel) and Artificial Intelligence courses. Utilized Oracle Virtual Box, Oracle SQL, PL/SQL, R, C/C++, Linux shell scripting, Coreograph robotics, Tableau, and Excel.

10/14-01/15 Sr. Database Engineer / Lead DBA. Galaxy Systems, Somerset, NJ.

Completed Oracle12c/11g VPD database installations, configurations, upgrades, model deployment, custom backup and recovery, performance tuning, database networking, and stored PL/SQL packages development, including Informatica ETL and XML for Oracle data provisioning onto AWS. Utilized Erwin, ODI, ODM.

09/13-01/15 DBA Architect and DMA Consultant, Wells Fargo, Charlotte, NC.

Wrote RFI for Exadata database laying out machine administration practices for administration, including Oracle12c Grid Infrastructure, ASM, and RAC database, and GoldenGate/Oracle ODI practices.

09/12-05/13 Oracle DBA/Architect and IBM contractor, Horizon BCBS, Newark, NJ.

Tuned Oracle MDM and Oracle TDE databases in DEV, SIT, and UAT environments. Wrote extensive data transformation code for Informatica MDM, Data Qualtity, and self-service reporting DataMart on encrypted databases. Monitored message-driven data pipeline utilizing Informatica PowerCenter, GG, and ODI. Wrote PL/SQL packages. Utilized Marketo, PostGreSQL, Oracle FailSafe, and encrypted RMAN code for BR/DR.

03/12-07/12 Software QA Engineer, Verizon, Basking Ridge, NJ.

Imported requirements documents into Rational Repository using ReqPro. Utilized SharedPoint, AWS, SQL*Server, Oracle SQL Developer, and MS Office, while monitoring Informatica metadata for DataMart data quality reporting and encoded data provisioning.

04/10-07/10 DBA, Fox TV Stations (Secaucus, NJ).

Implemented and executed migration of Oracle10g production servers from ZFS to UFS file system. Created an Oracle database SMO. Collaborated with team in data recovery. Performed corporate SQL Server inventory.

09/09-05/10 Systems Engineer / PA, IDP (Little Falls, NJ).

Provided BR/DR/BC technical support. Utilized FDR Upstream, Reservoir, Director, Windows, Linux, Oracle11g, RMAN, SQL Server 2005/2008, VMWare, and C++.

11/08-02/09 Lead Oracle DBA, VMS (New York, NY).

Administered media, marketing, radio, and TV databases. Responsible Oracle RAC administration on Linux, including, BR and tuning OBIEE cluster database, and GoldenGate replication. Monitored Oracle Streams AQ processes and replication and relevant self-microservices. Utilized AWS and Oracle PL/SQL.

EXPERIENCE (continued)

11/07-01/08 Live DBA, Merill-Lynch (New York, NY).

Provided successful on-demand production support using PL/SQL stored procedures, functions, triggers, and anonymous blocks, including message queuing based trading microservices and GG db replication.

06/07-11-07 OCP Instructor, Oracle University (NJ, NY).

Trained to teach and taught Oracle database OCP courses. Utilized GoldenGate and ODI as part of OCP DBA curriculum development.

02/07-04/07 Consultant Database Engineer, IDC Global (New York, NY).

Upgraded / maintained both real estate's ORPI (France) BI reporting system using PL/SQL stored procedures and Maklerv (Germany) data model's polyglot metadata using Erwin and assisting on Informatica Data Integration and custom data provisioning. Performed PL/SQL data transformation.

09/05-01/06 Oracle DBA, Time Warner (New York, NY).

Administered production, test, and development Oracle data warehouses and Time database instances with process monitoring for Data Guard via OEM. Prepared patch documentation and applied patches. Wrote PL/SQL and RMAN packages. Utilized Vignette, PostGreSQL, and Informatica for document catalog and facilitation of Oracle Text management.

06/05-08/05 Consultant DBA, Daily News / AP (NJ,NY).

Configured and administered Oracle Grid Computing environment with many targets, custom groups, farms, and blackout schedules. Created Data Guard databases. Utilized EMC Clarion

09/04-05/05 DBA, IBM /EBCBS), (NY / Remote).

Administered LPAR AiX4.3/5.2L GPFS Cluster/Windows-based Oracle 8i/9i databases. Designed, implemented, and executed migration plan for EBCBS medical data warehouse. Utilized Oracle utilities. Created several multi-block size databases using connection pooling. Utilized BMC Patrol, Marketo, Informatica MDM, Erwin, Java, SOAP, WSDL, UDDI, WS, Oracle Messaging Gateway, and OEM.

04/04-09/04 DBA, TDW (Jersey City, NJ). Implemented and tested RMAN-based BR/DR shell scripts on a Hitachi SAN-based Oracle environment. Utilized Solaris compression, Erwin, Oracle Data Guard, OEM, and PostGreSQL.

12/02-09/03 Lead Oracle DBA, eWayDirect (Norwalk, CT).

Managed several Oracle9i/8i databases and created new databases and migrated instances to Oracle9i. Wrote storage AVON Oracle marketing package. Utilized Eclipse to maintain Oracle Java code, including email Java packages used for direct marketing. Created custom data reporting transformation to align to client's Informatica MDM metadata.

09/01 - 03/02 Assistant VP – DBA / Tech. Analyst, Deutsche Bank AG, New York, NY.

Administered, tuned, and monitored over 45 VLDB Oracle replicated databases in the Static Data Management data warehouse, ICON and eSPEAR, using materialized views, MV groups and data warehouse jobs [with Informatica MDM metadata], and PL/SQL. Utilized OEM, Solaris, and Oracle Advanced Replication.

12/99 – 02/01 Lead Technical Developer / Sr. Oracle DBA, Bowne & Co, New York, NY.

Designed, implemented, and developed Oracle-based systems with highest level of quality assurance while maintaining data models, metadata and leading programs for global customers. Utilized Oracle, SQL Server, PostGreSQL, Informatica MDM to administer specific key-value metadata of data models originally created using Erwin and Oracle Designer.

EDUCATION

Universidad del Norte, Barranquilla, Colombia (1987)

BS Systems Engineering (184 USA undergraduate credits), 1981-1987.

New Jersey Institute of Technology (1992,1997)

MS Computer Science, NJIT, Newark, NJ (30 graduate credits), 1990-1992.

PhD Computer Science (103 graduate credits plus 18 dissertation credits), 1992-1997 and 2004.

Montclair State University (2006)

MBA Management Information Systems (graduate credits: MBA: 57; Computer Science: 18; Statistics: 6), 1990-2006.

CERTIFICATIONS

Oracle Certified Professional (OCP DBA), CSS HRizons DBA/HRizonsCode certifications, IBM HIPAA Certified Consultant.

KEY PROJECTS

Time Warner, Verizon, and Horizon BCBS Production Support; Daily News Grid; TD Ameritrade BR/DR; Onvia Globalization; BOA Merrill Lynch MLAM; Bowne's iDoc; AT&T ABN; Empire BCBS Database Upgrade; Panasonic Benefits, FMC ACGINV.

TECHNICAL SKILLS

Databases and Applications

Oracle 6/7/8/8i/9i/10g/11g/12c/18c Servers, Oracle NoSQL, Oracle Database12c/18c/19c on Cloud, AWS RDS, Apex, PostgreSQL,

Ingres QUEL, Oracle EM Grid/Cloud Control, Oracle RAC and Clusterware, Microsoft SQL* Server 6.5/7.0/2000, SQL Enterprise Manager, Azure, FoxPro, Access, dBASE, Paradox, FileMaker, Berkeley DB, OracleDB, LIMS, R, SAS, AQ/Websphere MQ, Vignette, Oracle Financials. SQL Developer, Oracle Data Integrator, Golden Gate, Oracle Express, Discoverer, Oracle Warehouse Builder, Informatica, OBIEE, T-SQL, SQL EM, Toad, MongoDB, JSON. Cassandra, CQL, Hadoop, HDFS, and MapReduce.

TECHNICAL SKILLS (continued)

Data Modeling

Oracle Designer, SQL Developer DM, Erwin, Systems Architect, ER Studio, Rational Rose, UML, IDEF1X, STP.

Web and Application Servers / Middleware

Oracle9i App Server, Oracle iAS, Microsoft IIS, WebLogic, Oracle WebCenter/Portal, Coherence, Websphere, JBoss, JRun.

Storage

EMC, Legato, RMAN, Veritas Volume Manager, Oracle Replication Manager, Hitachi SAN, ASM, ADVM.

Languages

Java, C, Visual C++, gnu C++, C#, Visual Basic, VBA, Pascal, FORTRAN, Basic, COBOL, S, R, SAS, Python.

Web and Scripting

JavaScript, VBScript, Oracle Portal, XML, HTML, Lotus Script, Java, asp.net, .NET, PSP, JSP, WebCenter, Perl, C#.

IDE and 4GL Tools

JDeveloper, Eclipse, Oracle Developer Suite/Forms/Reports, Microsoft Visual Studio, SOA Suite, PowerBuilder.

Software Engineering

Rational RUP, Rational Requisite Pro, Object-Oriented and Aspect-Oriented Software Development, CCM, SADT, Agile.

OS / Virtualization

Windows Servers, Oracle/RH/SUSE Linux, Solaris10/11, VMWare, IBM AiX, HP-UX, Windows 7/XP/98/95, Unix 5R4, Xen, Apple MacOS X (Panther, Yoshemite, El Capitán) MacOS Sierra, and iOS, Android, VM CMS, Oracle Virtual Box, Microsoft HyperV, IBM AiX LPAR/PPAR, Solaris Containers and PPARs, IBM OS390/zLinux, Coherence, ZFS, UFS. Solaris and Linux Containers, Dockers, Kubernetes.

Hardware

Intel-Based x86/i3/i5/i7, Lenovo, IBM RS/6000, Sun, HP, Compaq Alpha and Dell Servers, DEC/VAX, Apple Mac, IBM System/36, IBM 43XX, AT&T StarServer, NCR Towers, IBM S3X, AS/400, Oracle Exadata.

Data Communications

Windows NT/2000 Networking, SQL*Net/Net80, Fast and 10/100/1000/10K Gigabyte Ethernet Networks, ODBC/JDBC Database Connectivity, Novell, AppleShare, FDDI, HTTP, GIOP/IOOP, TCP/IP, UDP, SSL, FTP.

Miscellaneous

SPSS, MS Project, MS Office, Visio, DCOM, GitHUB, SVN, Visual SourceSafe, TimeLine, Vignette, Redshift, VOIP, ActiveX-OLE, Flash, Oracle Text/interMedia, Oracle Hyperion, Oracle ESB, Spatial, Lotus Notes, AutoCAD, PhotoShop, Illustrator, Quark Xpress, Oracle Machine Learning, Spring, Scrum, Google Chatbots, Oracle Cloud, AWS, Aurora, Azure.

ANTHONY D NORIEGA

- 33 Ireland Ave, Edison, NJ 08837 - 732-***-**** (c) - 646-***-**** - ***************@*****.*** - *********@*****.*** -

ilinkedin.com/in/anthonydnoriega · f anthonydnoriega – B noriegaaoracleexpert.blogspot.com

1 of 2

2 of 2

Contact this candidate