Project Guide for Oracle Rac Implementation

Document Sample
Project Guide for Oracle Rac Implementation Powered By Docstoc
					                                           Leonard A. Wickens
                                len@lenwickens.ca, rampantdragon@gmail.com
                Msn:len@lenwickens.ca, Yahoo: oopscorp, Skype: rampantdragon, Twitter:@rampantdragon
                               Toronto: 1-416-628-3705, Vancouver: 1-604-628-5705

Leonard Wickens offers extensive experience in the Information Technology arena. His technical
expertise, can-do attitude and flexibility to do what it takes to get the job done, have afforded
Leonard the opportunity to be an in-demand subject matter expert for most of his career. A
true consultant, Leonard can step into projects during any phase, as perform as a Developer,
Data Analyst, Database Administrator or Architect, Technical Lead or Project Manager. He has
successfully managed projects managing up to 50 direct reports, often with multi-national
teams and/or taken over failing projects and brought them back on track to success. He is
constantly upgrading Technical and Management Skills and is currently studying PMBOK Guide
and other resources to take pmp exam

OPERATING SYSTEMS

UNIX (Solaris, AIX, HPUX) including Clusters                   20+ yrs          Current
Linux (including clusters)                                     8 yrs            Current
WINDOWS XP, 2008, Vista, Windows7                              15 yrs           Current


MS Project                                                     10 + yrs         Current
DB2                                                            9 yrs            2009
JAVA J2EE JavaScript                                           6 yrs            Current
PHP /HTML/Perl/                                                5 yrs            Current
Oracle Apex                                                    5 yrs            2010
MS SQL SERVER                                                  8 yrs            2010
ORACLE RDMS (RAC) up to 11g                                    20 + yrs         Current
Oracle Forms/Reports 10g/11g                                   7 yrs            Current
Oracle Replication & Streams                                   10 yrs           Current
Oracle Warehouse Builder                                       4 yr             2008
Oracle Discoverer BI EE                                        4 yrs            2008
Oracle Application Server (OAS) Fusion 11g                     8 yrs            Current
Oracle Applications                                            4 yrs            2009
Oracle Identity Management/LDAP/Access Manager                 6 yrs            2010
Oracle SCM (Stellent)                                          3                2008
PL/SOL                                                         15+ yrs          Current
UNIX SHELL SCRIPTS                                             20+ yrs          Current
Informatica                                                    4 yrs            2007
ERWIN                                                          10+ yrs          Current
Server design and implementation                               10 yrs           Current
ESB and Oracle BPEL                                            3 yrs            Current
                                 Leonard A. Wickens




PROFESSIONAL EXPERIENCE
Nova Scotia Liquor Commission (NSLC) Oracle Senior DBA and Audit Architect Sep 10- Oct 10

        Review 108 Oracle Windows POS Systems
        Reviewed all settings, monitoring, patching, INI settings
        Review Entire Systems settings to improve performance
        I Solved and made recommendations for Oracle DB 10g-11g on remote patching
         management, backup and recovery
        Make recommendations for future changes in systems and procedures
Environment: Oracle 10g-11g , Windows, linux, vmware, remote management

Société des alcools du Québec (SAQ) (ORACLE Consulting) Sep 10- Sep 10

        Facilitator to resolve issues they had with move to OneWorld sp24
        I assisted in defining issues and getting Support from Oracle Support
        Review Entire Systems settings to improve performance
        I Solved and made recommendations for Oracle DB 11g, Websphere, Webmethods,
        Make recommendations for future changes in systems and procedures
        I managed and Coordinated with 6 different internal teams
Environment: Oracle 10g-11g RAC, Websphere, Jazz, JDE OneWorld, Webmethods, AIX,
Custom Code, Oracle Identity Management/Access Manager

Imex Systems (Ford Motors USA) Architect, Migration Consultant, Project Manager Oct 09 –
Apr 10

          Migration 500 forms 200 reports from 6i to 10g Forms and reports
          Java, JavaScript and ProC design and implementation
          Critical Project started 8 weeks late with same required delivery dates
          Managed Onshore team 10 analysts, offshore team 20 Analysts resourced all local
           and international resources, contracts and requirements
          Managed team internationally remote (50% remote) and on multiple sites
          Designed, architected and wrote build books for all Development and Test Servers,
           (Oracle RAC, VMWare, Linux clusters) also mentored staff doing installation, (both
           on and offshore)
          Organized project plan and methodology, Charter, Scope and Deliverables and
           presented to Senior Client Management
          Integrated Identity management/Access Manager for forms with Fords internal
           solution
          consolidated data centre and moved all servers to virtual servers
          Integrated Application into Ford's ESB at several points, designed Java wrappers
           around legacy code
          Integrated new upgraded software, with Oracle Application E Business Suite 12i
          Created and mentored project methodologies
                                       Leonard A. Wickens
                             len@lenwickens.ca, rampantdragon@gmail.com
             Msn:len@lenwickens.ca, Yahoo: oopscorp, Skype: rampantdragon, Twitter:@rampantdragon
                            Toronto: 1-416-628-3705, Vancouver: 1-604-628-5705

          Implemented project control and feedback systems, Issue control, negotiating
           schedule (no processes at start)
          Setup and resourced QA processes and Team
          Created Reports in BI Publisher
          Coordinated with Senior Managers on Ford Project Team and other projects
          Coordinated with other IT and user departments to manage requirements and
           timelines
            Environment: Oracle 9i-11g RAC, Oracle Application Server 10g Forms and Reports
           10g, Linux SUSE/Fuse, ESX VMWare, ESB, Symbol scanners, .Net Mobile
           devices., Shell Scripting, Microsoft Project, Oracle SCM, Mantis Bug system,
           SOA/Web Service integration, Oracle Apex, PowerPoint, Access, MS Project

City of Hamilton (IT) Oracle RAC and Spatial Specialist May 09 – Oct 09

          Brought in to assist them due to staff shortages and lack of knowledge.
          Cleanup spatial systems and implement purge and archiving solutions to keep 28
           years of data available.
          Planning and integration/moving of new Oracle Infrastructure into enterprise data
           center
          Integrated the various spatial systems for job based data transfer, SOA/Web Service
           type design
          Java, JavaScript for job control and SOA/Web Service
          Integrated with DB2 bought data source.
          Worked on Enterprise SAN team, recommendations and implementation of HP 512
           SAN
          Prepared, and presented change requests and monitored
          Migrated, implemented Web Billing system, (parking tickets etc)
          Designed and wrote processes for fail-over, recovery and backup systems for Oracle
           RAC.
          Also upgraded and migrated both Oracle RAC and SqlServer cluster systems.
            Environment: Oracle 9-11g RAC, ESX VMWare Oracle Application Server
           Intergraph TrackForce, DB2 ,Shell Scripting, Windows Admin, Infrastructure sizing,
           EDI, SAN

Imex Systems (Ontario Ministry of Labor) Architect, Migration Consultant, Project Manager
Jan 09 –May 09

          Was brought in to complete an Oracle forms/reports conversion that was running
           over budget and time. Coordinated with client, got buy-in on what had to be done
           to get sign-off.
          Managed on site and off site Team, 10 resources
          Presented project plans and other project documentation to Senior Management
          Java and ProC design and implementation
          Created/Converted Reports To BI Publisher
                                 Leonard A. Wickens



          SOA/Web Service design to allow new system to be used as resource
          Wrote build books for all Servers, (Oracle RAC,Solaris) also mentored staff doing
           installation,
          Installation of Oracle Identity Management/LDAP/Access Manager for new system
          Designed and wrote processes for fail-over, recovery systems for Oracle RAC.
            Environment: Oracle 7-11g RAC, Oracle Forms and Reports, Pro C, Oracle
           Application Server Shell Scripting, Solaris Admin, LAMP, PowerPoint, Access, MS
           Project, MS Office

Bridgewater Systems Architect, Developer, Mentor Sep 08 – Dec 08

          Wireless Provisioning and Concurrent Billing Software
          Converted advanced replication to Oracle Streams completely scripted conversion
           and green installs over 20,000 lines of code
          Integrated changes in databases into Billing and provisioning database, to allow
           changes without downtime. First end client Verizon Wireless.
          Designed recovery and rollback in the scripts without downtime.
            Environment: LDAP, Oracle 9-11g RAC, Solaris, Oracle Advanced replication, Shell
           Scripting, Pl/sql development, Oracle Streams, VMWare.

Nexams International Project Manager, Systems/Data Architect and Migration Consultant
May 07 – Aug 08

          Architected conversion of over 900 forms, 1000 reports from forms 3 to forms 10g,
           400 tables, Oracle 7 to 11g database and 400 C programs (Pro C) to new C and Java
           versions.
          Managed on site and off site Team, 10 resources
          Presented project plans and other project documentation to International Senior
           Management
          Implementation of change management and integrated North American Change
           Management with international system
          Integrated new systems with legacy billing and sales.
          Moved to and designed Enterprise data center Infrastructure for the new servers,
           ups, generators, power distribution, SAN, racks, network switches This also
           involved the decommisioning of Microvax servers and all planing for outages etc
          Moved to new Data center for DR and fail-over 30 miles away, black fiber between,
           Power requirements, generators etc,
          Identified resourcing shortfalls and found and hired new resources
          BPEL SOA/Web Service design for future growth and system integration
          Upgrade and converted Open VMS 7.34 Oracle to Red Hat Linux on Oracle 11g
          Oracle RAC on HP blades running on ESX VMWare.
          Designed and Implementation of Oracle Identity Management Suite/Access
           Manager, with Novell LDAP and Microsoft AD
          Discoverer setup up sales dashboard.
                                      Leonard A. Wickens
                            len@lenwickens.ca, rampantdragon@gmail.com
            Msn:len@lenwickens.ca, Yahoo: oopscorp, Skype: rampantdragon, Twitter:@rampantdragon
                           Toronto: 1-416-628-3705, Vancouver: 1-604-628-5705

          Created/Converted Reports To BI Publisher
          Oracle SCM prototype and design.
          Converted DCL scripts to pl/sql and/or shell scripts
          ETL and setting up DW on DR servers
          Converted EDI from OpenVms to Linux
          Integrated to Oracle Applications 11i Manufacturing with upgrade..
          Oracle Financial Analyzer 11i, setup, design and mentoring
          Also designed and advised on disaster recovery site and operation
           Environment: IBM 450 and HP blade servers. , LDAP, SSO, Oracle 7-11g RAC,
           Apache, Project Management, Oracle Apex, Java, Oracle Application Server. AIX,
           Linux, VMWare. .Net, SOA/Web Service Oracle Discoverer. LAMP, SAN
           implementation, PowerPoint, Access, MS Project, MS Office

Strategem Technologies, Mansion.com, Singapore Project Manager Enterprise Data Architect
Oct 06 – May 07

          Managed on site and off site Team, 250 resources
          Presented project plans and other project documentation to International Senior
           Management
          wrote all Project documentation including project plans and integrated and review
           ed all other reports
          Created/Converted Reports To XML Publisher(BI Publisher)
          Created change management system(remedy) mentored management and then
           was the chairman of change committee
          Assessed Products for purchase and integration with current environment
          ETL and Data Warehouse for tracking
          Moved to New Enterprise data center Infrastructure for the new servers, ups,
           generators, power distribution, SAN, racks, network switches This also involved the
           decommissioning old servers Key part was plan for no outages while switchover
          ESB, SOA/Web Service implementation between new systems and legacy
          Java wrapper design to implement ESB
          Created/Converted Reports To BI Publisher
          LAMP systems design, development and testing
          Implementation of Sun SSO with Oracle Identity Management/Access Manager
          Converted MySql and SqlServer to Oracle Grid 10g
          Replaced Window Servers with Sun Clusters
          Sharepoint for Documentation
          Multi OS and Multi Language development environment
          Oracle Financial Analyzer 11i setup, and mentoring
          Oracle E Business Suite 11i
          Microstrategy version 9
           Environment: Oracle 10g Grid RAC,Oracle Application 11i Windows 2000-2003,
           Oracle Streams, Oracle Replication, DataGuard, LDAP, SSO, Mobile Java app, Bea
           Application Servers, Project Management, Java, C++,.Net Custom Software,
                                  Leonard A. Wickens



           PHP/HTML, SqlServer 2005, Oracle Apex, AIX,MySql, Linux. Solaris 10.Tangosol
           Coherence, Oracle Warehouse Builder, Oracle Discoverer BI, Sellent installation ,
           Development server UNIX administration, LAMP, SAN implementation,
           PowerPoint, Access, MS Project, MS Office

EDS, Alberta Transportation Senior Architect and Project Manager Dec 05 – Sept 06

          Custom built Spatial Databases
          Resource on Oracle issues and problems.
          Manager upgrade project in support of Databases
          Managed on site and off site Team, 10 resources
          Presented project plans and other project documentation to Senior Management
          Database Team member of Change Committee, Remedy system, prepared,
           monitored and closed changes. Prepared training materials and SME
           documentation
          Design and installation of ASM supporting RAC on clients SAN
          Member of ESB team planing implementation and growth
          Installation of Clients first fail over system.
           Environment: Oracle 8i-10g Spatial RAC, Windows 2000-2003, Oracle Streams,
           Oracle Replication, DataGuard, .Net, Oracle Application Servers, WSAD,
           Websphere, Oracle Warehouse Builder, Oracle Developer(forms/reports)
           IAM/Tivoli integration, Oracle Discoverer Project Management, , Government
           Contract. PowerPoint, Access, MS Project, MS Office

Casino Web Cam, Costa Rica Database and Infrastructure Consultant,
Technical and Operations Director May 05 – Dec 05

          Kept Casino in operation 99.99% uptime
          Managed on site and off site Team, 55 resources
          Presented project plans and other project documentation to International Senior
           Management
          Managed Complete Server refresh project with minimal downtime
          Created change management system(remedy) mentored management and then
           was the chairman of change committee, required coordinating with international
           clients
          1000's of customer accounts with billing and transactions for international
           customers.
          redesigned Database for stability and performance
          Designed, moved to remote, new Enterprise data center with 100 servers, ups,
           generators, power distribution, Enterprise SAN, racks, network switches This also
           involved the decommisioning of old servers
          Implementation of fiber switch network for Enterprise SAN
          Full LAMP stack integrated with Oracle Production systems
          ESB/SOA/Web Service design and implementation plan
                                       Leonard A. Wickens
                             len@lenwickens.ca, rampantdragon@gmail.com
             Msn:len@lenwickens.ca, Yahoo: oopscorp, Skype: rampantdragon, Twitter:@rampantdragon
                            Toronto: 1-416-628-3705, Vancouver: 1-604-628-5705

          Built & Mentored a team of technicians to maintain the systems 24/7
          Microstrategy version 9
          Working with clients around the World.
           Environment: Oracle 9i-10g RAC, Redhat 4 Linux cluster, Apache, Project
           Management, Java (Resin), Mobile flash client,.Net gaming software Custom
           Software (C++, Php, etc) , LAMP, Oracle Id manager Infrastructure/Access Manager
           implementation, Enterprise SAN. PowerPoint, Access, MS Project, MS Office

Canadian Wheat Board, Winnipeg SDLC Consultant, Application Architect, & Project
Manager/PMO Oct 04 – May 05

          Assisted teams in redoing BA and SA and design phases.
          Managed on site Team, 9 resources
          Presented project plans(infrastructure and Enterprise) and other project
           documentation to Senior Management
          Tracked projects to ensure they were complying Enterprise PMO and architecture
           standards and reports
          Attended Weekly project status meetings as PMO rep and reported to steering
           committees
          Member of change committee, for Corporate standards, mentored contract project
           managers on Change processes, presented and adapted processes to requirements
          Discoverer Dashboard, for financial projections.
          Managed implementation of SDLC Standards and practices enhancement, including
           negotiating with 32 projects and project managers
          Implemented Oracle Development Standards (PL/Sql and Forms)
          implemented Web Services Development and deployment standards ESB/SOA
          Senior Architect for Supply Chain Re-engineering project Oracle SCM
          Involved in all aspects from farmer to delivery processes
          Enhanced Corporate Standards and Practices.
           Environment: Oracle Discoverer, Oracle 9i-10g RAC, CVS, DB2 tuning, Oracle Forms
           and Reports 9i, Oracle designer, Oracle Warehouse Builder Informatica, PM/ Team
           Lead, SDLC, Websphere, Java, BPEL, ESB, .Net, Sybase, Peoplesoft, XML
           Stellent(Oracle SCM) CMS, SOA/Web Service, Oracle Identity Management/Access
           Manager SAN, storage network. PowerPoint, Access, MS Project, MS Office

Medusa Medical Technologies Ltd, Halifax, Project Manager Systems/Database ArchitectMay
04 – Sep 04

Assignment was to completely document (ERD’s etc) the current SQL Server System and update
it to industry standards (3NF etc). This involved creating over 3000 foreign keys etc. Also add
about 50% new functionality. Then convert the entire system to use Oracle and redesign for an
Application Service provider role. Software is multi-tier and used in ambulances, by EMT's, to
automate data collection and replace paperwork. This entire project was under extremely tight
deadlines as Medusa had contractual deadlines to deliver to customers. Access 2000 migration
                                   Leonard A. Wickens



            Environment: SqlServer 2000, Oracle 9i-10g, Oracle Migration Toolkit, Linux, .Net,
            VB.net, Mobile Client for use in Ambulances, ERWIN, Jdeveloper, Wireless

IBM Global Services, (Alberta Wellnet Project/Alberta Ministry of Health) Edmonton
Systems/Database Architect Jan 04 – Feb 04

            Environment: Rational Rose, RUP, WSAD, Websphere, Websphere Studio, Visual Age
            Java, DB2 UDB EEE, SQL, MQ Series, Lotus Notes, Healthcare (Hospital Lab and
            Pharmacy systems), DB2 tuning and extraction AIX, UNIX Shell Scripting, Oracle
            Applications 11i

Rampant Dragon Media, Belize, (telecommute project from Canada) Systems/Database
Architect Project Manager Jan 03 – Dec 03

Designing Websites, Supporting Systems and Databases for New Online Gambling and Internet
promotions Company. This required RAD sessions; Use Cases and Data Flows to be documented
and then converted into a system design and project Plans (including time lines, staffing
requirements, and budgets. These were prepared for the clients VC presentations; I also took
part in the VC presentations Design and implementation of new Enterprise data center with 50
servers, ups, generators, Enterprise SAN, racks, network switches, including costing and
implementation plan
            Environment: ORACLE 8i/9i Oracle RAC, DB2 UDB, SQL Server, Red Hat Linux Cluster,
            Solaris, Erwin, Oracle designer 9i, Websphere, Oracle Applications Server, Perl, PHP,
            Shell Scripting, PL/SQL scripting, and SQL development, cms,wsad, Tivoli.

World Gaming PLC, Antigua Systems/Database Specialist Project Manager May 02 – Oct 02

            Assessed current technologies and make recommendations based on their OLTP
            increasing 300% 7/24 99.999 uptime required
            Design and move to offsite of new Enterprise data center Infrastructure with 150
            servers, ups, generators, power distribution, Enterprise SAN, racks, network
            switches This also involved the decommissioning of old servers, Key part was
            plan for no outages while switchover
            Environment: ORACLE 8i/9i Oracle RAC, SqlServer Linux Cluster, Solaris 8, Erwin,
            Pl/SQL packages, Oracle designer 9i< Oracle developer (forms/reports), Websphere,
            Perl, Shell Scripting, PL/SQL scripting, and SQL development Oracle Identity
            Manager. Change committee chairman

General Electric Consulting (major Client Coke Cola International), Toronto, Canada Oracle
Specialist Project Manager Oct 01 – Apr 02

            Environment: ERWIN, ORACLE 8i/9i, Java, Websphere, J2EE, PL/SQL, Solaris *, OEM,
            Quest software packages, Shell Scripting PL/SQL scripting, and SQL development,
            Oracle Warehouse Builder..
                                       Leonard A. Wickens
                             len@lenwickens.ca, rampantdragon@gmail.com
             Msn:len@lenwickens.ca, Yahoo: oopscorp, Skype: rampantdragon, Twitter:@rampantdragon
                            Toronto: 1-416-628-3705, Vancouver: 1-604-628-5705

Hydro One (formerly Ontario Hydro), Toronto, Canada Database Specialist/DBA Jun 00 – Jun
01

           Environment: ERWIN, PeopleSoft, Oracle Applications, ORACLE 8i, 9I, DB2 UDB EEE,
           DB2 390, NT, Cognos, Informatica, VB, Oracle Warehouse Builder, Oracle Discoverer,
           Peoplesoft Conversions and administration, Server (OAS), OFA, Websphere,
           SqlServer, J2EE, true 64 UNIX and HPUX, OEM, Remedy. Perl, Shell Scripting, PL/SQL
           scripting, and SQL development. HP 512 SAN Implementation

Baxter International Toronto, Canada Manager Technical Services Project Manager Nov 99 –
Jun 00

BcTel, Burnaby, BC, Canada Project Manager Oct 99 – Nov 99

prior work Clients: Various

           I have over 20 years of experience providing project management, design, support
           and development to various small client projects, which range from one to 18
           months in duration? Designing, programming and implementing client/server and
           GUI applications and technologies. My experience is divide equally between
           development and production support. The majority of my experience is as a DBA or
           Solution/Data Architect. Petro Canada credit risk systems for 2600 retail dealers.


EDUCATION & Certifications

       2010 PMI/PMP in progress
       1992 MBA Program (Information Technologies)
       1983 Bachelor of Science (Computer Science)
       1997 Oracle Certified Professional

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:356
posted:7/16/2011
language:English
pages:9
Description: Project Guide for Oracle Rac Implementation document sample