SUMMARY:

• Over 16 years’ rich cross - cultural experience in Project Management, Oracle Database Administration and Consultancy Services.
• Deft in handling project management activities which include planning, design, scope management, estimation, resource administration and completion of project within specified parameters.
• A technocrat with a proven track record of delivering value to organisations by effective strategy planning, leading new initiatives / projects during the career span.
• An effective communicator with honed people management, relationship management, analytical and coordination skills.

AREAS OF EXCELLENCE INCLUDES:

Data & Information Architecture - Design and Data Modeling - Performance Tuning Backup and Recovery Strategies - Availability Solutions - Database Security Data Warehousing - Business Intelligence - Server Administration Project Management - Change Management - Risk Management / Optimization Replication - Distributed Databases - Disaster Recovery Solutions Database Design - System Design - Data Modeling

SKILLS:

• Experience in Agile methodologies (Scrum, Sprint Planning and execution, Kanban), Rational Unified Process(RUP),
• OOAD skills with design & development in Java, JMS, UML, Rational Rose, Web Services, SOAP and various other open source frameworks.
• Expertise in Managing, Leading, designing and developing components using over Application servers and platforms such as IBM Web Sphere, Weblogic
• Excellent in managing, mentoring, and coaching team members
• Strong documentation and reporting skills
• Excellent interpersonal, collaboration, and problem solving skills

TECHNICAL SKILLS:

• Data Warehouse Design
• Business Intelligence
• ETL and Data Integration
• Configuring OBIEE Dashboards
• Oracle Enterprise Manager (OEM)
• XML and Web Integration
• UNIX Shell Scripting
• Project Management
• Business Process Improvement
• UNIX, Solaris, HPUX, Tru64, AIX
• Windows NT, 2000
• Oracle 11g, Oracle 9i Internals, Oracle 10g
• Real Application Clusters (RAC)

CAREER SKETCH:

Project Manager Oracle OBIEE, Hyperion, ESSBase

Confidential

Responsibilities:

• Managed and Planned an Interim Solution to cater to Confidential \s current need for Supply Chain Management,and Sales Information
• Understanding and Documenting Confidential Business Process, Production, Supply Chain, CRM, Finance and Sales. Used Microsoft Visio to diagram the processes
• Coordinating with Primary Stake Holders to understand deficiencies in the current system, feedback on features they want to see in the new OBIEE environment. Stake Holders in APAC, Europe, and North America
• Translating the requirements to Development Team, and using Microsoft Project Manager to Prepare Gantt Chart to track Project Progress
• Used SDLC for the implementation of the Business Intelligence Project.
• Created a plan for UAT coordinating with the Development Team

Environment: ORACLE 11G, OBIEE, MS-ACCESS 2003,MS-PROJECT 2010,MS-VISIO 2010

Project Manager

Confidential

Responsibilities:

• Managed the efforts of developers, DBAs, business stake holders, training staff and business process Owners to achieve the best technology solutions
• Coordinated and lead the efforts of 15 primary participants in the project, located in 3 primary Locations with some business process owners and business stake holders located in France, Singapore and Abu Dhabi.
• Effectively coordinated the agenda, presentation materials and facilitated the discussions at the senior Management level (CFO, COO, CIO) for the periodic executive sponsor meetings
• Determined the migration method and plans for support post migration. Coordinated with systems teams (Windows, UNIX) to ensure successful implementation of project.

Environment: ORACLE 10,9,8,and 7.2 Data Guard, Oracle Financial 11.1, Solaris, Linux, Windows, PeopleSoft, Business Objects

Senior Oracle DBA

Confidential, Omaha, NE

Responsibilities:

• Designed (Erwin Modeler) and implemented new production databases
• Project lead for Major conversion project, involved liaising with external vendor and development team at Confidential . Converting HR App from Main Frame to Oracle, PeopleSoft.
• IBM AIX system engineering and configuration of enterprise class 7x24 mission critical servers. Provided System V packaging of some third-party software for deployment in the AIX environment. Third level support for AIX problems and outages
• Designed and implemented several 2 Node and 4 Node RAC database using ASM.
• Installed and Configured Oracle Data Guard Solution for several Production Databases at Confidential
• Initial build script development and maintenance
• Creation and maintenance of test schema
• Implementation into production database
• Database migration Oracle 8.1.7.4 to 10.2.0.1, including (manual) scripting for conversion of all database objects.
• Reverse engineering of all database objects
• Schema comparisons via SQL Developer, and Quest
• Support of Oracle database servers v9.2.x, 10.x, 10g RAC
• Backup and recovery via RMAN scripts and troubleshooting
• Monitoring of Oracle database; automated error notification
• SQL statement analysis and tuning
• Storage analysis and allocation
• Online index rebuilds and storage recovery
• Responsible for maintenance and improvement of production, archive Oracle database
• Responsible for data refreshes for production, development and test databases
• Responsible for storage usage of all databases, including rearrangements of the database logical structure and tables when needed
• Application development support to programmers on all aspects of database programming

Environment: ORACLE 10.2.0.1/9.2.0.7 /9.2.0.8 , Data Guard, AIX, Linux, DB Artisan 8.1.1

Senior Oracle DBA

Confidential, Boise, ID

Responsibilities:

• Production Support DBA for 171 hosts running AIX, Solaris and Linux. 72% Oracle 9i, and 24% Oracle 10g (10.2.0.2 and 10.2.0.3) RAC systems using ASM. 13 4 - way clusters and 3 2-way clusters. Largest database capacity 3.4TB and 9 over 1 TB.
• Configuring and Using Data Stage ETL tool for Confidential DW environment
• Upgrading Oracle 9.2.0.7 to either version 9.2.0.8 or version 10g
• Creating “Golden Copies” and using them to recover databases to a particular point in time.
• Extensive use of Oracle SQL Developer, DBArtisan and OEM to manage and administer databases.
• Cleaning up hung/old/defunct SAN (snapshot) backup using pre-defined scripts and obtaining a successful backup. Largest database backed up between 3 TB to 6TB (Data Warehouse Env)
• Creating Tablespaces/Partitions every month as part of the Monthly Tablespace/Partition maintenance.
• Creating Function based indexes, for example using functions such as rawtohex.
• Working with BI Analyst to deploy analytics objects associated with the Agile Datamarts, PLM Datamarts, and Cognos Connection
• Creating and Scheduling Jobs in OEM to automate recurring processes for the BI Team
• Generated & interpreted explain plan and tuned SQL queries.
• Deployed DDL, DML scripts and applied SQL patches during various releases in UAT, Preprod and production environments.
• Supported development team and worked on database adhoc requests.
• Ensured database security using appropriate roles and privileges.
• Refreshed schemas from one environment to another using exp/imp utilities.
• Restored tables, schemas in test environments from export backup’s based on business requirements.
• Cloned databases from one environment to another using RMAN backup.

Environment: ORACLE 10.2.0.1/9.2.0.7 /9.2.0.8 , Data Guard, AIX, Linux, DB Artisan 8.1.1

Senior Oracle DBA

Confidential, San Francisco, CA

Responsibilities:

• Provided 24x7 support on a rotation basis with another DBA.
• Generated AWR/Statspack report’s and tuned the instance on a regular basis based on database load.
• Monitored CPU usage and killed sessions running expensive SQL operations consuming high CPU.
• Troubleshooted database issues including backup failures, ORA errors etc.
• Generated & interpreted explain plan and tuned SQL queries.
• Traced user sessions and interpreted SQL trace files using TKPROF utility.
• Performed index monitoring and helped improve performance of queries using proper indexing strategy by interpreting explain plan and evaluating indexing reports.
• Migrated database characterset from US7ASCII to UTF8.
• Deployed DDL, DML scripts and applied SQL patches during various releases in UAT, Preprod and production environments.
• Supported development team and worked on database adhoc requests.
• Ensured database security using appropriate roles and privileges.
• Refreshed schemas from one environment to another using exp/imp utilities.
• Restored tables, schemas in test environments from export backup’s based on business requirements.
• Cloned databases from one environment to another using RMAN backup.
• Migrated 6 databases in preprod environment from old server to new server.
• Implemented CDC in ODS environment to capture DML changes from OLTP databases.
• Rebuilt database objects (tables, indexes) from one big tablespace to several small tablespaces in datawarehouse environment.
• Written shell scripts for monitoring and to generate business reports.

Environment: ORACLE 10.2.0.1/9.2.0.7 , Data Guard, HP-UX, TOAD, Linux, Windows 2000.

Systems Administrator / DBA

Confidential

Responsibilities:

• Administered Windows 2000 Servers and computers; SAP Basis and Oracle implementation.
• Created PL/SQL scripts for identifying free space in table spaces and populated various databases located at different locations.
• Designed and customized Oracle Forms 6i to be used with Oracle 9i database to capture data entered by participants registering for Pacific Banking Conference.
• Handled migration of database to Oracle 10G from Oracle 8i. Managed installation of an Oracle 8i Database and Oracle Designer 6i Repository on a Windows 2000 Server.
• Applied Oracle Server Patches to upgrade Oracle RDBMS; security checks at Oracle level using users, roles and privileges.
• Upgraded NBS databases from Oracle 8.1.7.4 to 9.2.0. Designed and installed Oracle Designer 6i Repository to be used in Oracle Designer Classes. Involved in problem solving for bugs, user’s error and other kind of problems.
• Designed, documented and implemented standards for securing file servers at NBS.
• Implemented SAP R/3 4.6c-IDES on SQL7, SQL 2000 and Oracle 8i.
• Created a comprehensive Security plan for the use of NBS.
• Successfully implemented a SAP system, and maintained the system for 6 years
• Letter of appreciation from SAP Project Sponsor for completing the project in time and within budget

Environment: Oracle 8, Oracle 9i, Oracle 10g, Solaris 2.6, RedHat Linux, Windows 2003, Perl Scripting

Network Engineer

Confidential

Responsibilities:

• Took care of maintenance of Novell Network and Web Servers. Involved in installation and maintenance of Oracle 8 installation.
• Installed, configured, and managed Oracle 8 Server. Managed a team of 5 Technicians.
• Managed E-Mail servers running Novell GroupWise and Backup solutions.
• Provided support for Cisco Switches, IIS Web Servers, Checkpoint Firewall.
• Identified solution to problem with excessive packets on Network due to the use of NetBIOS Protocol.

Environment: Oracle 8, Redhat Linux, Windows Advanced Server

Systems Engineer

Confidential, Mountain View, CA

Responsibilities:

• Rendered pre-sales support for Confidential suite of products across North America, this included making presentations and assisting in closing business deals.
• Engaged in installing and testing Oracle software to work with Confidential products.
• Successfully completed product demonstrations at trade shows and client locations across the West Coast of US.
• Handled installation and testing of Confidential products on Solaris, AIX and Linux platforms.
• Completed a series of product demonstrations in collaboration with Microsoft and Compaq in Seattle, Portland, San Francisco and San Diego.
• Provided support for network consisting of NT Servers, Workstations, Terminal Servers with Citrix Metaframe, Unix Servers (Solaris, AIX, and Linux), Shiva VPN, and Livingston Routers.

Environment: Windows, Redhat Linux, Solaris, AS/400

MIS Manager / Network Engineer

Confidential

Responsibilities:

• Managed the network design and implementation of their Novell servers and other networking devices.
• Successfully managed MIS team of 15 Engineers.
• Implemented and supported Novell 4.1 network including maintenance of Lotus Notes Server, cc: Mail and daily backups using Seagate Backup Executive.
• Successfully managed Novell 3.12 (250 users) to Novell 4.1 OS without any disruption to services. Applied the use of NDS to manage the network.
• Handled 30 Cisco 4000 Catalyst Switches, 5 Cisco 2900 Switches, Cisco 2600 Router.
• Provided support for WAN link between Malaysia, Montreal and Vancouver offices using 3COM Routers.