We provide IT Staff Augmentation Services!

Data Architect Resume Profile

Summary

Advanced Information Technology professional with over 16 years of Senior Oracle Database Administration Middleware Architecture/Engineer, Hyperion, Seibel, JDEdwards,PeopleSoft and E-Business Suite experience. Strong Java development. Current in all the latest releases of Oracle, High Availability, RAC, Data guard, Streams and Grid Controller, Fusion Middleware and E-business Suite and Application Server. Technical Leader, advisor to other projects DBA's. Specialize in managing large multi-tera byte Data Warehouses and Data marts, in high demand environments. Expertise includes Database Security and Performance Tuning. Strong Project Management Skills, SDLC, and Data Architect experience. Strengths include developing process definition, infrastructure change and policy development. Solutions are secure, maximize performance and anticipate enterprise-wide implementation. Adept with Project Life Cycle approaches and Testing Methodology. Excellent people, instructional and organizational skills. Routinely deliver projects within budget and on schedule. Results driven, deliver information technology that achieves a competitive edge in the market place. Solid experience in a variety of industries.

Skill

  • Data Warehouse Management
  • Data Architecture and Analysis
  • Oracle Database Administrator 24 x 7 production support
  • Database Tuning
  • Oracle Advanced Security Features
  • Oracle Application Framework
  • Oracle Application Server Admin High Availability, Apache, Tomcat, Web Logic Server and WSTL scripting, JBoss
  • Oracle Fusion Ware Layer Architect
  • Oracle Identity Manager, Oracle Identity Federation, Sun Identity Manager, Oracle Waveset, Oracle Context Manager,
  • OID, Single Sign On, Oracle Virtual Directory,
  • Oracle Access Manager, Geo-Spatial, XML,
  • Oracle 11g SOA Business Suite
  • Middleware High Available architect Failover and Clustering, Coherence
  • Peoplesoft, Oracle E-Business Suite/Oracle Portal, ODSI Admin Console
  • Hyperion Financial Management, Planning, Financial Data Quality Management, Financial Reporting Studio, Smartview, Essbase
  • Oracle Cluster Ware. OCFS and ASM
  • RMAN
  • Object Oriented Languages
  • Project Lead Life Cycle Development
  • Agile Development Environment
  • Testing/ Quality Assurance
  • Oracle Database Admin High Availability RAC, Dataguard, Streams and Grid Controller
  • Storage Management, Database Replication tools, EMC SRDF, Quest Shareplex, Veritas and IBM Propagator, Informatica, Golden Gate
  • Support Seibel and PeopleSoft Environments
  • Data Security Modules, Data Vault, Audit Vault
  • Oracle Identity Manager, Oracle Identity Federation, Oracle Context Manager,
  • OID, Single Sign On, Oracle Virtual Directory,
  • Oracle Access Manager, Waveset, Geo-Spatial, XML, Real Application Testing, Change Management,
  • Oracle Fusion Ware Layer
  • Oracle E-Business Suite Oracle Business Intelligence Informatica Peoplesoft Oracle Portal Exadata
  • Java
  • C language
  • SQL Server Database Admin/ High Availability
  • Microsoft Active Directory
  • MySQL Database Admin/ High Availability
  • T-SQL
  • .Net
  • MS Analysis Server SSAS/ DTS pkgs/ Integration SSIS/ Reporting SSRS
  • Share Point
  • InfoPath
  • DB2, DataStage
  • Teradata
  • Sybase
  • AIX / HP-UX
  • Linux/ Sun
  • Windows NT/ Server
  • VAX/VMS

Technologies

  • /C /C , Korn/Bourne Shell Scripting, Oracle Call Interface, Java, Perl, C , Oracle PL/SQL, MS T-SQL, .Net, Oracle Pro C, IBM SQL, ASP, JSP, HTML, J2EE, PHP, XML, knowledgeable with Cobol Visual Basic , Dream weaver Coldfusion
  • Oracle 12c, Real Application Clusters RAC, XML architect, Real Application Testing, Provisioning, Configuration Change Management, RMAN, Grid Controller, Data Pump, Data Guard, Flashback Database, Advanced Oracle Security, Advanced Replication, Partitions, Oracle Access Manager, Geospatial, Database Cloning, Golden Gate v11.1.1, Transparent Data Implementations, Kerberos. Backup/Recovery, Application Patches, Exadata v3
  • MS SQL Server 2008, MS Reporting Analysis Services 2008, Oracle Migration Workbench, DB2 UDB 10.0, Access 2007, DB3, MySql 6.0 High Availability, Informix 11.5, TeraData 13.0 and Sybase 12.5
  • Webpage development, AJAX, eclipse IDE, SOAP, REST, JavaScript,, Cascading Style Sheets CSS DB2 Stored Procedure, SOA
  • HP-UX 11.0, AIX 7.0, LINUX, Red Hat 6.0, Sun Solaris 5.10, MS Windows 7, MS Windows Server 2008, MS Active Directory 2003, DEC VAX/VMS, SANS, Veritas, and EMC disk arrays
  • Oracle Identity Management 9.1.0.2, Web Logic Server 11g, Hyperion Essebase 11g, Informatica, Coherence, Oracle Data Service Integrator, Oracle Internet Directory OID , Virtual Directory, Oracle Single Sign On SSO , Oracle Access Manager Oracle Business Intelligence 11.1.3.5 Peoplesoft 9.1, Oracle E-Business Suite 12.1.3 Informatica 9.1 , Oracle Fusionware 11g, Oracle Application Server 12i Oracle 12i modules Financials, Customer Relations, Master Data, Procurement, Product Life Cycle Project Management JBoss 7.0 Sun Identity Manager, Oracle Waveset Apache MS IIS Novell Network Oracle Net ssh LDAP ODBC telnet ftp and rpc
  • Oracle Waveset, CA Identity and Access Management 12.5, Agile, Erwin Data Modeler, TOAD, Power Architect/Designer, Oracle Version Control, Primavera, Power Builder, QMF, Syncsort, PVCS Version Control, SPSS, MS Office Suite 2007, SAIS, Rogueware Software, Unified Modeling Language UML , Web Matrix, Code Charge, Oracle Forms 11g, Oracle Reports 11g, Oracle J-Developer 11g, Oracle SOA Suite, Oracle SQL Developer, MS Visual Developer, SharePoint Server 2007, InfoPath 2003, Microsoft Operations Manager, patrol, big brother, Cygwin, cacti, nagios and putty

Confidential

Project Description

Senior Oracle 11g, Data Architect

  • Fusion Middleware Architect, Identify and Access Management, Advanced Oracle Security and Performance Tuning, Multi TB environment, JAVA development, SDLC.
  • Migrated SAP environments to exadata environment. Generating data architecture for an Oracle 11g environment. Generating pl/sql code to support ETL functiona, and maintain data architecture.Installed, configured and migrated Exadata release 3. Installed and Configured OIM 11g.

Confidential

Project Description

Senior Oracle 11g, Data Architect

  • Fusion Middleware Architect, Identify and Access Management, Advanced Oracle Security and Performance Tuning, Multi TB environment, JAVA development, SDLC.
  • Developing Web apps using Dreamweaver, Coldfusion 10. Web app supports high volumn US postal customers. Generating data architecture for an Oracle 11g environment. Generating pl/sql code to support ETL functiona, and maintain data architecture. Used hibernate and Spring framework.

Confidential

Project Description

Senior Oracle 11g, Data Architect

  • Fusion Middleware Architect, Identify and Access Management, Advanced Oracle Security and Performance Tuning, Multi TB environment, JAVA development, SDLC.
  • Migrated Oracle Forms and Reports Server 10g, onto Oracle Forms and Reports 11g. Upgraded Oracle 10g to Oracle 11g Database Server. Migrated 80 legacy forms and tested. Configure Oracle High Avalability. System ran on Windows 2008 R2 Database Server. JAVA development used spring and hibernate framework..

Confidential

Project Description

Senior Oracle 11g, Data Architect

  • Fusion Middleware Architect, Identify and Access Management, Advanced Oracle Security and Performance Tuning, Multi TB environment, JAVA development, SDLC.
  • Developing Oracle 11.2 Hi-Available for key OTLP application's. Developing plsql orcle objects, query tunning. Developing normalized Data Architecture. Implementing advanced security featurs. Deployed audit and data vault. Utilizing BI Publisher to track key metrics, support quality improvement. Performing Oracle sys support. JAVA development used spring and hibernate framework..

Confidential

Project Description

Senior Oracle 11g, Data Architect

  • Fusion Middleware Architect, Indentify and Access Management, Advanced Oracle Security and Performance Tuning, Oracle wave set, Multi TB environment, JAVA development, SDLC.
  • Deployed E-Business Suite 12.1.3 on AIX 6.3 Operating System. Delpoyed Oracle Business Intelligence Enterprise Edition 11.1.3.5 on AIX 6.3 Operating System. Deployed Hyperion/Essbase 11g. Installed Informatic 9.1 on AIX 6.3 environment. Deployed Oracle RDBMS 11.2 on 6.3 Operating System. Installed OC4J Stand alone Server on AIX 6.3 environment. Overcame numerous hurddles, in the Oracle install software, that Oracle support had not considered. Installed Oracle Identity Manager 9.1.0 to improve access policy management. This allows Omnicare to leverage the most current E-Business and OBIEE technology. System included weblogic server 10.3.5, fusionware enterprise manager, BI server, BI publisher, Informatica, Hyperion Essbase and real-time decisions. Wrote tailored Java code to support specilized reports, utilized Jdeveloper and eclipse. Developed PL/SQL Oracle Objects. Prototyped Golen Gate for clients consideration . Proposed architecture that streamed Oracle Databases, promises to reduce over head and costs by 75 . JAVA development used spring and hibernate framework..

Confidential

Project Description

Senior Oracle 11g, Data Architect

  • Fusion Middleware Architect, Indentify and Access Management, Advanced Oracle Security and Performance Tuning, JAVA development, SDLC.
  • Migrated dev, test and production 11.5.1 E-Business Suite Server between Oracle 10g onto Oracle 11g. Developed migration plan to port data between the legacy system and the new database. Federal office utilized HR funtionalitly in the E-business Suite. Developed user acceptance plan. Incorporated ASM and Golden Gate functionality. JAVA development used spring and hibernate framework..

Confidential

Project Description

Senior Oracle 11g, Data Architect

  • Fusion Middleware Architect, Indentify and Access Management, Oracle Waveset, Advanced Oracle Security and Performance Tuning, Multi TB environment, JAVA development, SDLC.
  • Developed a business continuation plan. Setup Oracle Identity Management 9.1.0 to facilitate access policy management. Upgraded 9i Oracle environment to 11g. Implemented disaster recovery solution incorporating DataGuard, RAC, ASM and GoldenGate technologies. Datagard protects against unplanned outages, while goldengate facilitates planned outages. Wrote a Java / PL/SQL interface to manage access provisioning. This database supports online transactional processing. small business users. Intuit offers a suite of web enabled accounting tools, database is about 500GB in size, and expect growth to approach 1TB. System ran on Solaris. Application tier ran Apache web servers. Coordinated with business users and developed user acceptance plans. JAVA development used spring and hibernate framework..

Confidential

Project Description

Senior Oracle 11g, Data Architect

  • Fusion Middleware Architect, Indentify and Access Management, Advanced Oracle Security and Performance Tuning, Multi TB environment, JAVA development, SDLC, Oracle Waveset.
  • Transitioned Ally Financial off an older Sun LDAP Directory Service. Removed vulnerability in the legacy workflow, which involved sys admins making operating system level changes, sysadmin inadvertently made changes that brought down a production system. Created a new webapp that automated access policy management. Utilized Oracle Access Manager to make changes at the OS level in a more secure fashion. Proposed use of Oracle Role Management. Wrote a tailored Java and PL/SQL interface that manages user access provisioning.
  • Database supports Oracle 11g Identity Management and Access Management,SOA Busienss Suite,SSO, AIA Oracle Fusion Middleware clustering, Databases are running on Linux environments. Developing Identity management environment for Ally Financial Services and IBM, utilizing CA products. Overhauling IBM's Identity Management, meet compliance criteria. Assiting with system migration of GMAC resources into IBM managed environments. Oracle 11g High Available, RAC, Advanced Replication. Utilizing HP-UX, AIX, Solaris, Windows and Linux servers. JBoss. EMC and Veritas Disk Arrays. Providing 24 x 7 production support. JAVA development used spring and hibernate framework..
Confidential
Project Description

Senior OAS 11g, Data Architect

  • Fusion Middleware Architecture, Advanced Oracle Security and Performance Tuning, Multi TB environment, JAVA development, SDLC
  • UNFI provides warehouse and distribution for Whole Foods groceries. Database supports Manhattan Application software, with the functions of receiving and invoicing dry and perishable goods. Application utilizes bar code scanners and voice recognition software. Implemented advanced security including encryption, authentication and data integrity methodologies. Developed and deployed 11g Oracle Fusion Middleware functionality. Oracle 11g Identity Management and Oracle11g Identity Federation, to provide enterprise wide user identity. Architecting and implementing an Oracle 11g High Available RAC System running on AIX 6L environment. EMC storage arrays. Implemented Golden Gate. Providing 24 x 7 Data Base administrative support. JAVA development used spring and hibernate framework..
Confidential
Project Description

Senior OAS 11g, Seibel8.1 Administration, Data Architect, Oracle Fusion Layer Middleware, Security and Performance Tuning, JAVA development, SDLC

Developing HIPPA compliance criteria. Independent Health provides medical insurance coverage. Supporting a Siebel 7.8 to 8.1 upgrade project. Wrote Java PLlSQLinterfaces. Developed and deployed the 11g Oracle ApplicationFusion Middleware layer, products, including Web Logic server, apache and tomcat. Oracle11g Identity Management and 11g Oracle Identity Federation, to provide enterprise wide user identity. Configured Single Sign On. Architecting and implementing an Oracle 11g RAC System running on AIX 6L environment. Installed Audit Vault and Data Vault. Providing Data Base administrative support. Managed Web Logic Server. JAVA development used spring and hibernate framework..

Confidential
Project Description

Senior OAS 11g, Oracle E-Business Suite 11i, Data Architect, Oracle Fusion Middleware Architect, Security and Performance Tuning, JAVA development, SDLC

Providing application and development support for an Oracle 11.5.1 Financials environment. Supporting Accts payable, Accts Receivable, Project, HRMS, General Ledger and customed tailored financials interface. System running on AIX 5L environment. Installed Audit Vault and Data Vault. Assisted MSD in meeting security criteria in their financial regulatory department. Oracle Identity and Access Manager, Providing Data Base administrative support. Managed Oracle Web Logic Server. Wrote Java PL/SQL interfaces. JAVA development used spring and hibernate framework..

Confidential
Project Description

Senior OAS 11g, Oracle E-Business Suite11i, Data Architect, Oracle Fusion Middleware layer, Security and Performance Tuning, Supported 10 TB's of data, JAVA development, SDLC

Providing application and development support for an Oracle 11.5.1 Financials environment. Supporting Accts payable, Accts Receivable, Project, HRMS, General Ledger and customed tailored financials interface. System running on Solaris 10, M9000 environment and Exadata. Application supports SDDC, Transportation Command at Scott AFB. The application tracks accruals in the Billions of dollars. Additionally, the environment supports SECRET classified data. Assiting with a migration plan into Oracle 11g and 12i. additionally leveraging Oracles high availabilty and Web Logic. Oracle Identity 9.1.0 and Access Manager, Single Sign On, Recommended the use of Oracle's Unbreable Linux, and commodity based servers, to further reduce system OS and hardware costs by 70 to 80 . Providing Data Base administrative support. Managed Oracle Web Logic Server. Wrote Java/PL/SQL interfaces. JAVA development used spring and hibernate framework..

Confidential
Project Description

Senior OAS 11g, Oracle E-Business 12i,Oracle Fusion Middleware layer, Data Architect, Security and Performance Tuning, 10 TB's of data, JAVA development, SDLC

15 Million project with the Constellation Brands to install RAC 11g and Application Servers onOracle Unbreakable Linux . MS SQL Server migration project, installed rdbms, clusterware, rman, real application testing, configuration change management, provisioning, dataguard, streams, xml, asm and advanced 11g High Availability functionality. Migrating 150 legacy applications into 11g RAC. Installed Exadata. Assisting Constellation Brands with the selection of E-Business Suite, JD Edwards, Siebel and Peoplesoft, applications to meet business needs. Leveraging Oracle Content Manager and Oracle Idenity Manage 9.1.0. About 10 tera-bytes involved in the migration. Performing 24 x 7 database support. Providing training on grid controller and 11g high availability functionality. Identified data architectural change, to leverage database efficiencies, and minimize millions in hardware costs. Configured Oracle User Enterprise Security, OID in 11g environment. Managed Web Logic Server. Wrote Java PL/SQL interfacfes. JAVA development used spring and hibernate framework..

Confidential

Project Description

Senior OAS 11g, Data Architect, Oracle Fusion Middleware layer, Security and Performance Tuning, JAVA development, SDLC

Installed Oracle Identity Federation Manager, for a Defense Contractor in Restin, VA. Deployed and tuned an Oracle XML Server. Mentored staff on its use and developed administration documentation. Managed Oracle SOA server. Managed Weblogic Servers. Redhat OS. JAVA development used spring and hibernate framework..

Confidential

Project Description

Senior OAS 11g, Data Architect, Oracle Fusion Middleware layer, Security and Performance Tuning, Supported 70 TB's of data, JAVA development, SDLC

5 Million project with the State of Michigan to install RAC 11g on Solaris 10 and Sun Clusters. Sun Oracle Database Machine and Exadata. 9i migration project, installed rdbms, clusterware, rman, real application testing, configuration change management, provisioning, dataguard, streams, xml, asm and advanced 11g High Availability functionality. Migrating 75 x 9i development and 35 x 9i production instances into 11g RAC. About 70 tera-bytes involved in the migration. Performing 24 x 7 database support. Providing training on grid controller and 11g high availability functionality. Identified data architectural change, to leverage database efficiencies, and minimize millions in hardware costs. Configured Golden Gate Replecation software, conducted proof of concept against Oracle Streams. Configured Oracle User Enterprise Security, OID in 11g environment. Managed Web Logic server. Wrote Java PL/SQL interfacfes. JAVA development used spring and hibernate framework..
Confidential

Project Description

Senior OAS 10g, Oracle 11i E-Business Suite, Data Architect, Oracle Fusion Middleware layer, Security and Performance Tuning, Supported 70 TB's of data, JAVA development, SDLC

24 x 7 Production Support for Sql Server and Oracle. Developing 35 Million project to migrate 9i databases into Oracle 10g RAC and Linux. Sarbannes Oxely compliance. Prototyping RedHat Linux/ Oracle 10G RAC, utilizing EMC disk arrays. Developing migration plan to migrate over a 100 x Oracle 9i instances into Oracle 10G RAC. Currently, procurring hardware and software. Project plans to implement migration. Second phase facilitate migration across all of Citi's Data Centers. Identified oppurtunities to tighten database security. Administered Oracle 11i Application Servers and E-business suites. Oracle OID, Virtual Directory, SSO, Access Manager. MS Active Directory. Oracle Access Management. Proto-typed 11g RAC, high availability, asm and rdbms on AIX platforms. Configured Oracle User Enterprise Security, OID in 10g environment. Managed Apached and Tomcat web servers. Wrote Java PL/SQL interfacfes. JAVA development used spring and hibernate framework..
Confidential

Project Description

Senior OAS 10g, Data Architect, Oracle Fusion Middleware layer, Oracle DBA, supported 15 TB's of data, JAVA development, SDLC 8 months

Over saw development and deployment of Mobile Advertising application, that deliver banners to mobile phones. Brand new revenue stream and Yahoo. The jumptap application utilizes open source technologies including RedHat, Apache, Tomcat, MySQL and Oracle 10g RAC. Configured Database Backups, Replecation disaster recovery procedures. The open source technology generates considerable savings in licensing fees. These technologies provide comparable and even better performance in deference to thier licensed conterparts. Implemented monitoring services including patrol, cacti and nagios. Assisted with User Acceptance planning, insure service level agreements were being met. Efforts insured that application will reach production on schedule and under budget. Migrated 10g RAC into 11g RAC. Managed Golden Gate server, to replicate data off of primary database server to to support report processing. Configured Oracle User Enterprise Security, OID in 10g environment. Wrote Java PL/SQL interfacfes. JAVA development used spring and hibernate framework..

Confidential

Project Descrption Senior OAS 10g and Oracle Fusion Middleware layer, Oracle E-Business Suite 11i, Data Architect, Security and Performance Tuning,

Supported 50 TB's of online data , JAVA development, SDLC 6 months 24 x 7 Production Support for Sql Server and Oracle. Supported E-Business Suite Financials. Exaimed Edwards Jones Database practices and procedures. Found 10 million in unrealized return on investment. Identified more efficient use of database license costs, reduced these expenditures by 40 . Identified deficiencies in the data architecture to increase database capacity by eight fold and maintain efficient data access. Proposed better organization of the dba's to promote better use of these resources. DBA's expressed better job satisifaction and less burn-out. Off-hour demand on their time will be greatly reduced. Trouble-shooting production errors is more stream-lined. The original orginazation had the dba's divided into three teams. Consequently the DBA's could only practice a third of their skill sets. Improved application development support. Each DBA has a manageble number of applications to support and can better tune the database to meet application needs. DBA's could now fit technical training into their schedule. New organization better conform to Sarbannes Oxely compliance. Identified oppurtunities to tighten database security. The orginal organization was extremely clumsy and time consumming coordinating routine tasks between the teams. Found opportunities to retire unnecssary and expensive software. Created a proof of concept Golden Gate services to replicate data to support reporting. Administered Oracle 11i Application Servers and E-business suites. Oracle OID, Virtual Directory, SSO, Access Manager. MS Active Directory. Proto-typed 11g RAC on RedHat 5.2. Managed IIS, Apache and Web Logic Server. Wrote Java PL/SQL interfacfes. JAVA development used spring and hibernate framework..

Hire Now