SUMMARY:

• Over 20 years of experience centered on all phases of software development lifecycle: project management, system analysis, data modeling, database administration and application support.
• Experienced with Database Administration, Data Mart and Data Warehouse.
• Oracle Certified Professional and Master of Science in Computer Methodology.
• Customer - oriented, multitasking, flexible and team-player.

TECHNICAL SKILLS:

Hardware/Storage: HP/UX; IBM AIX; Sun Solaris; Windows; Netapp; EMC

Software/Operating Systems/Language: Ventyx Asset Suite (Passport) with Work Management, Purchasing, Contract Management, Accounts Payable, Design Engineering and Inventory modules; Installations, upgrades, enhancements/support of Oracle packages and stored procedures; database refreshes; Passport Security; Passport region configuration; Passport Architecture Build; CAWA batch job monitoring, management and scheduling; Oracle 11g and 12c (RMAN, TOAD, SQL PLUS); Physical and Logical Standby; ITIL; COBOL; UNIX Shell Script Language (korn); Oracle Enterprise Manager(OEM); SQL*Loader; SQL*NET; PL/SQL; SQL; Weblogic 10.3.5; CA Workload Automation; BMC Remedy (ITSM); Seapine Software (Test Track); MS Office(Access, Excel, Word).

PROFESSIONAL EXPERIENCE:

Confidential, North Vancouver, BC

Oracle DBA and Ventyx Passport Consultant

Responsibilities:

• Support BC Hydro as the Environment Lead for Supply Chain Systems.
• Provide day-to-day and on-call support by investigating and resolving complex system problems
• Administer Ventyx Passport systems including application, database and web servers in a client/server, enterprise environment.
• Participate in Passport Upgrade, Architecture Build 12 and Oracle 12 Upgrade projects.
• Meet clients weekly to discuss issues and prioritize workload.
• Coordinate enterprise system implementations to ensure interfaces work as designed.
• Utilize Remedy ITSM to manage incident, problem as well as change management tickets.
• Download and apply bug fixes from vendors such as Ventyx and Oracle.
• Monitor databases to ensure response time is reasonable by using Oracle Enterprise Manager.
• Migrate programs in production, development and test regions. Also manage licences.
• Provide backup, recovery and performance tuning of Oracle 11g and 12c databases.
• Work cooperatively with other personnel such as Infrastructure, SAP, Fujitsu and Data Warehouse.

Oracle DBA and Indus Passport Administrator

Responsibilities:

• Worked as the Team Lead in the Passport Global Administrator’s Team for BC Hydro.
• Provided system administration and problem resolution support for Supply Chain Systems.
• Administered user accounts by processing computer authorization forms.
• Coordinated database refresh schedules with SAP, GIS DAD and Data Warehouse (PDW) teams.
• Managed incident and problem tickets by using Service Centre and PPM (ITG).
• Managed problem tickets with software vendors and applied emergency patches (EPs)
• Participated in the testing and implementation of system changes and enhancements.
• Managed licenses for Passport as well as PVCS (for source control).
• Migrated programs with x-migrate to meet auditor’s requirement.
• Involved with Procurement-to-Pay (P2P), FSR, Year End Conversion (YEC), Portalj Upgrade, Disaster Recovery (DR), Architecture Build 8 (AB8) and Server Virtualization (VM) projects.

Oracle DBA and Peoplesoft Administrator

Responsibilities:

• Provided on-call and 24x7, day-to-day DBA support for BC Hydro and BCTC.
• Administered highly available, multi-server/multi-module Peoplesoft environments.
• Managed user accounts, upgraded databases and applied CPU patches.
• Conducted performance tuning and enforced data security for ERP systems.
• Assessed, applied and tested vendor (Oracle and Peoplesoft)-provided bug fixes.
• Worked on Operational Data Store as well as Data Warehouse with various business reporting tools.
• Adapted ETL processes to accommodate changes in source systems.
• Wrote stored procedures with PL/SQL, SQL PLUS and TOAD to generate reports.
• Performed unit and integration testing to ensure data quality as well as integrity.
• Maintained logical and physical data models with Erwin.

Consultant/ETL Developer, RDBMS Administration

Responsibilities:

• Worked on Data Warehouse project for Confidential utilizing Informatica, Oracle, and SQL Server.
• Wrote functional and technical specifications in a multi-vendor environment (IBM and HP).

Oracle Data Warehouse Developer/ DBA

Responsibilities:

• Administered backup and recovery procedures for mission critical production databases in an Oracle/HP/SQL Server environment.
• Monitored databases with OEM (GUI based tool) and conducted performance tuning.
• Automated jobs with Autosys to extract, transform, and load data warehouse.
• Participated unit, system and integration test utilizing stored procedures as well as triggers.
• Created, installed and maintained development, QA and production databases.
• Provided On-call duties for responsible databases to allow 24x7 accessibility.
• Used Erwin to develop logical and physical data models.
• Monitored database growth and server resources to ensure optimum performance.
• Assisted business analysts and developers on database design and data integration.
• Wrote UNIX shell scripts (ksh) and PL-SQL statements to migrate as well as replicate databases.

Oracle Application DBA

Responsibilities:

• Developed and maintained Oracle Forms and UNIX shell scripts.
• Monitored jobs and performed backups in an OLTP, 24x7 production environment.
• Enforced data security rules by using stored procedures, constraints and triggers.
• Led year 2000 project in an enterprise-wide, distributed environment.
• Provided ad-hoc reports and collected application statistics for CRM/marketing related applications.

Senior Programmer/Analyst

Responsibilities:

• Converted data from Sybase to Oracle database for web-based applications.
• Evaluated software packages and recommended Oracle Designer 2000 for data modeling.
• Established system requirements to address business issues and provided project plans.

Other Technical

Responsibilities:

• Developed and coded X.25 portion of EDI package for international applications.
• Integrated PC packages into user applications and conducted user training.
• Gathered, analyzed, and translated user requirements into functional specifications.
• Modified and tested FORTRAN, COBOL programs and associated EXECs on IBM.
• Participated in budget preparation and supervised few people.
• Evaluated, procured, installed IBM PCs and peripherals.