Peningo Systems, Inc.
Resume of Candidate: PEN167
Rate: email us at info@peningo.com for rate information or call 914-921-3102
Oracle Security Consultant
Summary:
• Oracle Fusion Middleware Architect on Oracle Fusion Middleware/Weblogic Server 11gR2, OAM 11gR2, OIM, OVD, OHS, SOA, OBIEE 11g, OID, OIM
OSSO, OAAM, OIF, DIP, AD, ADFS performing designing architecture, integration, administration and implementation
• Experienced with Administration of Oracle Application Server10g(10.1.3) and 11g(11.1.1.7).
• Experienced with upgrading OAS from 10g to Oracle Fusion Middleware 11g
• Experienced in troubleshooting, installation, patching, upgrading, security analysis and monitoring products such as Oracle Fusion Middleware,
Weblogic, OID, OAM, SSO, OAM and OAS Oracle Portal.
• Experience with installing configuring Enterprise Manager for management of Oracle Middleware, Solaris, Linux and AIX
• Senior Oracle Apps DBA/Architect for Oracle 11i(11.5.10)/R12(12.1.3) E-Business Suite with Modules and technologies like GL, OM, AR, AP, BOM,
VCP, FA, HRMS, INV,SCM, WIP, Project Costing, Projects, T&L, iSupplier, iRecruitment, WorkFlow, Portal, DMZ, Advance topologies, Citrix/Cisco/F5 Load
Balancers, SSL Certificates, ReverseProxy, WebCache, OTA, XML gateway, SOA, OSB, OAM, OIM, OID, OVD, WebGate, AccessGate, OBIEE Integration with
EBS R12, all on current technology version stack
• Oracle E-Business Suite R12 (12.1.3) implementation Modules such as GL, FA, AP, AR, OM, PO, VCP, HRMS, BOM, INV, SCM, iSupplier, iRecruitment,
WIP, Project Costing
• Oracle E-Business Suite integration with OAM, OID, AD, Portal, SSO, SOA, OBIEE
• Oracle E-Business Advance topologies with Load balancer, DMZ, reverse proxy for iSupplier and iRecruitment
• Experienced with Oracle Application server portal 11g/10g/9i
• Oracle Database 9i/10g/11gR2 RAC /Dataguard Specialist – certified in all versions of Oracle Database on Oracle Exadata X2-2 and Application on
Exalogic
• Delivering Oracle solutions on cloud platform by building VMs, VPC and Private, Public , and community clouds
• Certified in Oracle, Sun, Linux and BMC Patrol
• As a Solutions Architect, involved in designing, sizing, tuning the Enterprise database and EPR infrastructure for Sun, EMC, Logicalis, Agilysis, and
HP, as part of pre-sales, implementation and post-sales process.
• International Chair/Webinar Chair for OracleRACSig.org
OVERVIEW
• Over 18 years of experience in Information Systems and Database Administration
• Well experienced as a Database consultant, performance specialist, professional trainer and mentor
• Kick started Oracle E-Business Suite R12 on Amazon EC2 and developed best practices for patching, cloning and backup and recovery.
• Experienced with Architecting, Installing, Configuring Oracle Fusion Middleware 11g, Weblogic Server, OAM 10g/11gR1/R2, OSSO, OID, OVD, OIM,
SOA, DIP, Webgate and integrating with Oracle E-business Suite R12
• Experienced with Administration of Oracle Application Server10g(10.1.3) and 11g(11.1.1.7).
• Involved in architecture and upgrading from 10g to Oracle Fusion Middleware 11g
• Experienced in troubleshooting, installation, patching, upgrading, security analysis and monitoring Oracle Fusion Middleware, Weblogic, OID, OAM,
SSO, OAM and OAS Oracle Portal.
• Experience with installing configuring Enterprise Manager for management of Oracle Middleware, Solaris, Linux and AIX
• Experienced with building SOA/OSB infrastructure on Oracle Fusion Middleware 11g
• Architected the solution, Installed and configured Oracle OAM 11gR2 and defined policies for authentication and authorization, integrated OID with
Microsoft Active Directory
• Installed configured Oracle 11g for forms, reports, discoverer, BI publisher on Oracle Fusion Middleware/Weblogic 11g platform and integrated with
OAM 11g.
• Built and delivered VMs on Amazon Cloud for Oracle E-Business Suite R12, OBIEE and Oracle Weblogic servers.
• Helped to develop backup and recovery strategy for applications and database on virtualization platform.
• Involved in building security model, VPC for databases on Cloud platform.
• Experienced in building private, public and community clouds for Oracle applications
• Experience with Oracle 11i (11.5.10)/R12(12.1.3) e-Business Suite DBA, Cloning, Patching , Autoconfig, Oracle9iAS/AS10g clustering, OBIEE,
Discoverer, webcache, Portal, OC4J and Parallel Concurrent Processing. Mentored DBAs on Oracle Applications 10.7 to 11i upgrades.
• Extensive experience with Oracle 10g R2/11g Database, Real Application Clusters (RAC) on Sun, Oracle and Veritas Clusters 3.5/5.0, and raw FS and
CFS, OCFS, Oracle 8i Parallel Server to RAC Upgrade, Replication, DataGuard, performance tuning, data warehousing, Materialized Views, Oracle Streams,
Advanced Queuing backup and recovery using RMAN
• Performance tuning expert on various ERPs like Oracle, SAP, PeopleSoft, Siebel
• Experienced in managing Oracle statistics and copy form one landscape to another
• Experience with Oracle database compression and saved about 3TB space in a 10 TB environment and improved performance overall.
• Involved in Linux systems and Unix(HP-UX, AIX, Solaris) systems administration for Oracle 10g/11g RAC
• Experienced with implementing SOA high availability solutions on Oracle Application Server 10g(10.1.3.1) for Banner Applications and installed and
configured BPEL and ESB
• Worked on large multi-terra byte databases on Oracle
• Systems Management specialist for UNIX and Windows. Implemented BMC Patrol for about 50 Servers, 70 databases and SAP
• Introduced Veritas Cluster and CFS and Oracle9i/10g/11g RAC which improved the way of doing business at BOTCC
• Developed a practice document for Activant for their Oracle Applications 11.5.8/12i on RAC with Cisco load balancer and PCP
• Presented Technical Seminars and White Papers
WHITE PAPERS
• Installation procedure for Oracle9i RAC on Single node – Linux
• How to Install and configure Oracle 11i e-Business Suite on Linux and Windows
TECHNICAL SEMINARS
• Oracle 9i New Features for DBAs - A Technical Review- twice at Roselle, IL
• Oracle 9i New Features for DBAs - A Technical Review- twice at Naperville, IL
• Oracle 11i E-business Suite Implementation- A Technical Review- Roselle, IL
CERTIFICATION
OCP, Oracle DBA Oracle 10g/9i/8i/8/7.3 – Oracle Corporation
Managing Oracle on Linux – Certified by Oracle
BMC Patrol Administrator for UNIX - BMC Corporation
Sun Certified Solaris Administrator I - Sun Microsystems
MENTORING/TEACHING
• Part of www.oracleracsig.org community forum.
• Part-time instructor at GIST (gistcenter.com)
• Mentored/taught Oracle 9i/10g/11g DBA , Real Application Clusters, Data Guard , Oracle 11i/R12 DBA, Unix, Linux courses for beginners and DBAs
• Mentored/taught Oracle 11i e-Business DBA Courses and upgraded Oracle Applications form 10.7 to Oracle 11i e-business suite for Apps DBAs
• Preparing Course Material for Oracle 10g/11g Database/RAC/10gAS/OFM 11g
EDUCATION/TRAINING
• Master of Business Administration in Project Management from Keller Graduate School of Management, DeVry University
• Bachelor of Engineering from Bharathiar University, India
• Diploma in Computer Management
• BMC Patrol Administrator (UNIX, NT & oracle KM) conducted by BMC software
• Solaris 8 administration – conducted by Sun Microsystems
Numerous Trainings from Oracle Corporation for all kinds of Oracle Products including Oracle 11i and Oracle 9i
Hardware
HP Net Server 5/100 LH/LHII/LH Pro, HP-9000 Compaq Proliants
Sun Sparc u10s, 250, 450, 6500, E10K, F15K, F25K, E6900 DEC-Alpha
Microsoft Clusters Dell PowerEdge IBM RS/6000 SP IBM P5-520
Operating Systems
HP-UX 10.20/11i Digital UNIX 4.0D Sun Solaris 2.7/8 SCO UNIX 4.0
Windows NT /2000 IBM-AIX 5.3/6.1 Suse 7.2 Linux Novell 3.11
Veritas DBE/AC 3.5 Sun Cluster 3.x RedHat Advanced Server 2.1
Redhat ES/AS 3/4 Veritas Storage Foundation Cluster File System 5.0
Databases
Oracle AS 10g/11g (10.1.0.4)/9i (Rel 2)/8i/8/7.3 Oracle9i Lite(5.0.2) MS SQL Server 6.5/2000 IBM Websphere 7.0
MS Access 97
Languages
C Java Pro*C SQL & PL/SQL PSL (Patrol Scripting)
Tools
BMC Patrol 3.2/3.3/3.4 Developer 11g Designer 2000 Erwin3.5.2
Oracle X/Open, XA ETL Oracle 9iAS Oracle iFS 1.02
Backup Exec 6.11 Hitachi TP Broker SQL-BackTrack RMAN
Oracle Jdeveloper Axio Crystal Reports 5.0 CORBA
MS Cluster Server 1.0 Oracle Express Lotus Notes 4.6 Kintana Oracle Enterprise Manager (OEM) Oracle Failsafe Manager 2.1.3
Network Manager 5.1 Network User 5.1 Oracle Discoverer OC4J
Veritas Backup exec 8.5. Veritas Net Backup 4.5 Oracle FM11g OBIEE
Informatica Powercenter 7.1Hyperion Weblogic 10.3.6
Packages
TabWare 2.07(ERP) Oracle Applications 11i(11.5.10)/R12(12.1.3) Siebel (CRM),
Oracle Collaboration Suite 9.0.4 (Rel. 2) IBM Websphere, Peoplesoft, SAP
PROFESSIONAL EXPERIENCE
Oracle Architect 11/2007- Present
EBS/SOA/IAM DBA/Architect 02/2013 - Present
APPS DBA/Architect of Oracle E-business R12 implementation team and played the Infrastructure Architect role in start to completion for modules
Such as GL, FA, AP, AR, OM, PO, VCP, HRMS, BOM, INV, SCM, WSH, WIP, iSupplier, iRecruitment , Project Costing
Architected and built the Oracle EBS R12 system on 4-node RAC cluster and 2-node application server with Load Balancer
Configured RAC and EBS R12 with Scan ip and tuned RAC for optimal performance
Architected and Built Advanced Oracle EBS topology for iSupplier with DMZ and reverse proxy
Involved in EBS management activities like Patching, cloning, PCP, Integration, etc.
Architected and Built Oracle Fusion Middleware, SOA and OSB on a DMZ later to ftp files to external partners and integrated with Oracle EBS R12
(12.1.3)
Installed and configured Oracle Enterprise Manager (OEM) 12c, a Oracle Fusion Middleware/Weblogic 11g version with OHS runs on OEL 6 and
deployed agents on multiple nodes and configured monitoring
Architected and built Oracle Identity and Access Management with Oracle Access Manager (OAM), Oracle Internet Directory (OID), Active Directory
(AD)
Built the security policies in OAM11gR2 and integrated it with WebGate and AccessGate
Developed filters to migrate accounts from Active Directory to OID, Built OVD to integrated with Unix/Linux server authentication using Oracle
Authentication Services 11.1.1.3 and PAM (Pluggable Authentication Module)
Integrated Oracle EBS R12 and OBIEE 11.1.1.7 with Oracle Identity Access management for Single-sign on using WebGate and AccessGate
Integrated OID with Active Directory by developing the filters and integrated with EBS R12
Involved in Administration of Oracle Application Server10g(10.1.3) and 11g(11.1.1.7).
Involved in troubleshooting, installation, patching, upgrading, security analysis and monitoring Oracle Fusion Middleware, Weblogic, OID, OAM,
SSO, OAM and OAS Oracle Portal.
Experience with installing configuring Enterprise Manager for management of Oracle Middleware, Solaris, Linux and AIX
Environment: : RedHat Linux 6.3, Oracle EM Cloud Control12c (12.1.0.2.0), Weblogic 10.3.6, Oracle Database 11.2.0.3, Oracle E-Business Suite 12.1.3,
Oracle SOA Suite 11.1.1.7.0, RCU, OBIEE 11.1.1.7, OEPE 12.1.1.2.1, OAM 11gR2 11.2.0.0, OID 11.1.1.6, OIM 11.1.2.0, OVD, OIF
Building a world class demo platform: 11/2012- Present
Built a hybrid cloud demo with on premise and Amazon AWS, integrating Oracle EBS R12, Peoplesoft, Siebel with Oracle Identity and Access
Management. This is monitored using Oracle Grid control 11g.
Environment: : OEL 5.7, Oracle EM Cloud Control12c (12.1.0.2.0), Oracle Fusion Middleware 11g, Weblogic 10.3.6, Oracle Database 11.2.0.3, OAM
11gR2, SOA, OIM, OID, OVD, EUS, Peoplesoft 8.3, Siebel,
Database Architect 08/2012- Nov 2012
Developed a plan for Oracle database RAC upgrade and hardware refresh on RedHat 6.3
Implemented the upgrade plan for Oracle Real Application Cluster (RAC) to 11.2.0.3 and promoted from 2-node to 3-node cluster on a new
hardware
Installed and configured Oracle Enterprise Manager (OEM) 12c, a Oracle Fusion Middleware/Weblogic 11g version with OHS runs on Solaris 10 and
deployed agents on multiple nodes and configured monitoring
Tuning the RAC database for optimal performance
Environment: : RedHat Linux 6.3, Oracle EM Cloud Control12c (12.1.0.2.0), Weblogic 10.3.5, Oracle Database 11.2.0.3
Integration Administrator / Architect 03/2012- 07/2012
As Fusion Middleware Architect Reviewed, architected, integrated and Implemented the OAM 11g, IAM 11gR2, OHS, SOA, OID, SSO, Forms/Reports,
Discoverer/Oracle BI Publisher/APEX 11g, EUS security on Oracle Fusion Middleware 11g and Weblogic cluster platform
Installation configuration of Oracle OAM 11gR2 and defining policies for authentication and authorization, integrating OID with Microsoft Active
Directory
Upgraded
Installed configured Oracle 11g for forms, reports, discoverer, BI publisher on Oracle Fusion middleware/Weblogic 11g and integrated with OAM
11g.
Deploying various home grown applications on Weglogic 11g Server platform
Installed and configured Oracle Enterprise Manager (OEM) 12c on high availability nodes with SLB (Secured Load Balancer)
Installed and configured and maintained Oracle Database 11.2.0.3 on Exadata Platform X2-2
Helped to migrate and configure MAFTIGER database to Amazon web services and setup the DR solutions using Amazon EC2.
Develop necessary infrastructure environments, tools and integration plans and provide the calendar from 2011 till 2022.
Provide the all resource requirements, Software licensing requirements and budget requirements for the global initiative.
Architected and planned and executed upgrading from 10g to Oracle Fusion Middleware 11g
Involved in troubleshooting, installation, patching, upgrading, security analysis and monitoring Weblogic, OID, OAM, SSO, OAM and OAS Oracle
Portal.
Installed and configured Enterprise Manager for management OEM 12c for Oracle Middleware, Solaris, Linux and AIX
Environment: RedHat Linux 5.1, Oracle Fusion Middleware/ Weblogic Server 11g, , Oracle OAM 11gR2(11.1.2.0.0), OID, OSSO, SOA, BPEL, OFM 11g,
Oracle AS10g 10.1.3.3.0 Portal, OEM 12c, Oracle BPM, OBIEE 11g, Oracle Forms/Reports/Discoverer/Oracle BI publiserh/Apex 11g, Oracle Database
11.2.0.3, Oracle Exadata X2-2
Infrastructure Architect 09/2011- 02/2012
Review the Global Single Instance (GSI) plan for McDonalds R12 global implantation an roll out to 39 countries till 2022 and recommend the
infrastructure milestones
The plan includes OBIEE, Hyperion, Oracle BPM, IBM WebSphere, MQ Series environments
Review and recommend upgrade path and implement security architecture for OFM, SSO, OID, OAM, OFM along with ADFS upgrade.
Developed authentication and authorization policies for the global SSO for Oracle products
Develop necessary infrastructure environments, tools and integration plans and provide the calendar from 2011 till 2022.
Provide the all resource requirements, Software licensing requirements and budget requirements for the global initiative.
Environment: IBM AIX 6.1, Oracle E-Business Suite R12(12.1.3), Oracle OID, OSSO, SOA, BPEL, OAM, OFM 11g, AD, ADFS Oracle AS10g 10.1.3.3.0, OEM,
Oracle BPM, IBM InfoSphere Datastage, OBIEE 10.1.3.4.1, Informatica Power Center R8.6.1, HP PPM 7.1, IBM MQ Series, IBM Websphere 7.0
Oracle RAC Architect 06/2011- 8/2011
Designing Oracle RAC cluster for their new EMC Documentum application
Installed, configured the around 14 four and two node Oracle 11g R1 clusters on IBM AIX 6.1
Configured ASM on AIX and EMC systems and storages.
Migrated the databases from single node to the RAC cluster and ASM
Installed and configured Oracle Enterprise Grid Control 11g
Designed Dataguard solution for them with 4nodes production to 2node DG.
Mentored the internal DBAs and brought them up to speed on the new database infrastructure.
Environment: IBM AIX 6.1, Oracle 11.1.0.7, Oracle Grid 11g
Seaton Corp, IL Oracle Streams/AQ Administrator 04/2011- 5/2011
Oracle Streams and Advanced Queuing performance tuning,
Oracle Streams and Advanced Queuing capacity analysis for number of messages per second and recommendation for next for 6 months to 3 years
Reviewed and tuned RAC load performance for AQ
Virtualization of servers and road map to building private cloud for the TGS IT
Security analysis and recommendation to improve security in the virtualization environment.
Environment: Sun Solaris 10, Oracle 10g (10.2.0.8)/11g (11.2.0.2), Oracle Streams/Advanced Queuing.
Northwestern University, IL Oracle Database Administrator 02/2011- 4/2011
Involved in strategic consulting, reviewed Infrastructure consolidation and recommended the IT strategy and road map for 3 to 5 years.
Consolidation of applications, databases, servers and storages.
Virtualization of servers and road map to building private cloud for the TGS IT
Security analysis and recommendation to improve security in the virtualization environment.
Environment: IBM AIX 5.3/6.1, Sun Solaris 10, PeopleSoft 8.9, Oracle 10g (10.2.0.4), MS SQL Server 2005, MySQL 5.
Appko/Amazon EC2, CA Cloud Architect 10/2010- 01/2011
Kick started Oracle E-Business Suite R12 and developed best practices on Oracle Enterprise Linux and Oracle VM using templates
Developed patching, cloning and backup strategy for Oracle E-business R12(12.1.3) on Amazon EC2 Cloud and Appko Cloud.
Developed strategy for cloud/virtualization migration and implementation best practices
Built and delivered machine images for Appko for Oracle E-Business Suite R12, OBIEE and Oracle Weblogic servers.
Helped to develop backup and recovery strategy for applications and database on virtualization platform.
Involved in building security model, VPC, Elastic IP for databases on Cloud platform.
Experienced in building private, public and community clouds for Oracle applications
Set up the test servers on Amazon for Oracle E-Business Suite R12 and Oracle 10g databases using AMIs
DeVry University, IL Oracle Database Administrator 06/2008- 09/2010
Managed, monitored and administered Oracle 11i Application running Oracle Student System (OSS)with OID, Single Sign-on and portal
Performance monitoring and maintenance of Oracle Database, Oracle Application server Portal, Oracle E-Business suite
Involved in 11i upgrade, portal, single sign-on, oid, database upgrade etc.
Implemented DELTA project and migrated Oracle Student System to Banner Student and implemented 5-node RAC database and Dataguard.
Installed and configured SOA high availability solutions on Oracle Application Server 10g(10.1.3.1) for Banner Applications and installed and
configured BPEL and ESB.
Installed, Configured, managed and maintained Oracle Fusion Middleware 11g Suite that includes forms/reports, OID, SSO, AD, OSSO, DIP and
integration with EBS
Installed and configured EM Grid Control 11g to monitor Oracle Fusion Middleware. Configured EUS (Enterprise User Security) on EM Grid Control
and assigned the authorization and authentication policies.
Involved in setting up Oracle Enterprise Manger grid to monitor all enterprise databases and server to monitor system and its performance
Environment: Sun Solaris 10, Oracle AS 10g, Oracle 11i (11.5.10) Oracle 10g (10.2.0.4), EMC Storage, BPEL, Alfrasco, Luminous, Banner Student, IBM
Websphere 7.0
Street Corporation, MA Oracle 10g Database Architect 11/2007- 05/2008
Involved in design and architecture of 5-node Oracle RAC 10g (10.2.0.3) database of size 10TB on Sun OS 5.10 and Veritas Storage Foundation
cluster file system 5.0 and also involved in upgrading the entire infrastructure to new hardware 4-node to 5-node cluster.
Tuned the Oracle Real Application Cluster for the interconnect traffic and other RAC related wait event and improved the performance in a highly
complex hybrid cluster environment
Analyzed and Tuned various complex SQLs in a RAC environment and reduced the execution time to one third
Designed the Oracle Statistics collection scheme for a 10 TB database and also designed a utility to move statics to inconsistent environments
from production.
Designed and implemented Oracle compression techniques which saved about 3TB space in a 10 TB environment and improved the query
performance drastically.
Involved in design of Disaster recovery solutions for RAC Environment
Environment: Sun OS 5.10, Sun E6900, Oracle 10g(10.2.0.3), EMC Storage, Oracle RAC, Veritas Storage cluster file system 5.0 (5-node RAC)
dB Professionals, IL Oracle Database/Applications Architect 12/1998-10/2007
Responsible for establishing the technical framework for their both their remote services division and project management group. Provided client
contact management on high-end database technology initiatives.
The Clearing Corporation, IL Oracle Administration 05/2007-10/2008
Design, plan and implement Oracle 9i to 10gR2 upgrade
Install, configure Oracle 10gR2 database on par with Oracle Best practices
Install, configure and administer Oracle RAC on 10g R2 and configure according to Oracle best practices.
Involved in tuning the system to maximize the performance
Environment: Sun Solaris 10, Oracle 10g (10.2.0.3), EMC Storage
Rotary International, Chicago PeopleSoft Performance Tuning 05/ 2007-08/2007
Migrated Platform from Sun Solaris to IBM AIX for PeopleSoft System
Implemented Oracle 10g(10.2.0.4) RAC on IBM AIX 5.3
Review the Oracle and PeopleSoft performance and recommended the improvements
Review the backup and recovery strategy for PeopleSoft and Oracle
Capacity planning, Disaster recovery and high availability strategy and implementation
Environment: IBM AIX 5.3, Oracle 10.2.0.4, PeopleSoft 8.1
TSC, Chicago Oracle/Peoplesoft Performance Tuning 08/2007-02/2008
Review the Oracle and Peoplesoft performance and recommened the improvements
Tune the SQL reports and improve their performance to meet SLAs
Review the backup and recovery strategy for Peoplesoft and Oracle
Capacity planning, Disaster recovery and high availability strategy and implementation
Environment: Sun OS 5.8, Oracle 8.1.7, PeopleSoft 8
Sun Professional Services
GE Corporate, NY Oracle and Sun Datacenter Consolidation 03/2007-04/2007
Data center consolidation involving three Oracle 11i/12i E-Business Suite applications, one PeopleSoft 8.9 Sun Fire 15K and Sun Fire 25K
Patching, Cloning of Oracle Applications 11i
Setting up Parallel concurrent processing and load balancing of Application servers
Capacity planning, Disaster recovery and high availability strategy and implementation
Environment: Sun OS 5.8, Sun Fire 15K, Fire 25K Oracle 11.5.10/12i Oracle 9i/10g EMC Storage, PeopleSoft 8.9, IBM Aix 5.3, IBM Websphere
Nuance, IL Oracle Administration 12/2006-02/2007
Design, plan and implement Oracle 9i to 10gR2 upgrade
Install, configure Oracle 10gR2 database on par with Oracle Best practices
Install, configure and administer Oracle RAC on 10g R2 and configure according to Oracle best practices.
Involved in tuning the system to maximize the performance
Environment: RedHat Linux 4 ES, Oracle 10g (10.2.0.3), EMC Clarion
CVS Pharmarcy, CA Oracle and Sun Bench Marking 10/2006-11/2006
Designed and Built a Data warehousing bench mark clustering using Oracle 10g R2 and Oracle Cluster Ware
Involved in tuning the system to maximize the performance
Environment: Sun OS 10, Sun Fire 15K, Fire 25K, Hitachi Storage
EMC Professional Services
Excel Logistics, PA Oracle 11i and EMC DR solution 09/2005
Strategic Consulting for Disaster recovery planning for Oracle 11i E-Business Suite involving EMC SRDF solution
Worked with EMC and implemented EMC solution.
Tuned database SGA size and SQL scripts for data processing and loading
Environment: Sun OS 5.8, Oracle 11.5.10, EMC Storage
Sun Professional Services
Hartford, MN Oracle 9i and Sun Migration 08/2005
Reviewed the database architecture and suggested the performance improvements. Provided the database current capacity and growth advice.
Tuned database SGA size and SQL scripts for data processing and loading
Environment: Sun OS 5.8, Oracle 9.2.0.5, EMC Storage
NASD, MD Oracle 9i and Sun Capacity planning 06/2005
Consulted for capacity and growth planning and migration aspects of 12terrabyte database on Oracle 10g RAC and suggested on upgrade plans.
Suggested best practices, and performance recommendations for the current architecture
Tuned complex SQLs and improved the data load performance
Environment: Sun OS 5.8, Oracle 9.2.0.5/10g(10.1.0.4), EMC Storage
JP Morgan Chase Manhattan, NY Oracle 9i and Sun Capacity planning 03/2005
Review the Oracle 9i/Sun Architecture and recommend the configuration changes for best practices, and performance recommendations
Sized the database services for the future growth
Environment: Sun OS 5.8, Oracle 9.2.0.5, EMC Storage
MRAS (GE) Rochester, NY Oracle 11i and Sun Cluster Tuning 01/2005
Review the Oracle 11i databaseArchitecture and recommend the configuration changes for best practices, and performance recommendations
Environment: Sun OS 5.8, Veritas Cluster, Oracle 11i E-business Suite 11.5.9, Oracle 8.1.7.4, Oracle 9iAS rel.1, EMC Storage
HSBC Rochester, NY Oracle 9i RAC and Sun Cluster Expert 06/2004
Review the Oracle 9i RAC Architecture and recommend the configuration changes for best practices
Worked with Oracle Corp. and provided the current configurations and improvements
Supported on-site DBA for the successful Production migration from Oracle 8i OPS to 9iRAC on Sun Cluster 3.1 and RAW file system
Reviewed and suggested to convert from 32-bit oracle to 64-bit oracle
Environment: Sun OS 5.8, SunCluster 3.1, Oracle 9.2.0.4, Sun Global Filer, 9iAS rel.1, EMC Storage
Paetec Rochester, NY) Oracle 11i/9i RAC and Sun Cluster Expert 06/2004
Review the Oracle 9i RAC Architecture and recommend the configuration changes for best practices
Suggested the improvements for the optimal performance of Oracle Database on RAC
Installed configured and verified high availability and Disaster recovery solutions for Oracle 11i E-business Suite (9i RAC and SRDF)
Suggested and implemented the Cisco load balancer configuration for web server and forms metric server for Forms server.
Suggested best Practices for Oracle 11i E-business suite on RAC, Parallel Concurrent Processing (PCP), web server, discoverer, cloning, Patching
and maintenance.
Mentored on-site DBA on Oracle 9i RAC/9iAS portal and Self Service Modules and 11i E-business Administration
Environment: Sun OS 5.8, Sun Cluster 3.1, Oracle 11i E-business Suite 11.5.9, Oracle 9.2.0.4, Sun Global Filer, 9iAS rel.1, EMC Storage
TSC Chicago, IL Oracle/Peoplesoft Infrastructure review 03/2005
Reviewed the Oracle 8i/peoplesoft Architecture and recommend the configuration changes for best practices, and performance recommendations
Tuned the OS, database, Storage and SQL query for the Peoplesoft application
Environment: HP-UX 11.0, Oracle 8.1.7.0, Peoplesoft 7.0
Vignette, TX OracleAS 9i/DB 10g RAC Mentoring 08/2004
Installed and configured Oracle 10g Clustered database
Mentored DBAs on Oracle 9iAS / Oracle AS 10g clustering and high availability concepts and solutions
Installed and configured Oracle AS 10g with high availability clusters as prototype
Installed and configured Oracle 10g RAC (10.1.0.3)
Prepared the test system to integrate Oracle AS 10g with Oracle 11i E-Business suite.
Mentored them on Oracle AS 10g integration with oracle 11i E-business suite (CRM, HR, OM modules).
Environment: Sun OS 5.8, IBM AIX, Oracle 11i E-business Suite 11.5.9, Oracle 9.2.0.4, Oracle DB 10g RAC, Oracle AS 10g
Activant Austin, TX Oracle 11i E-Business Suite Administrator 08/2003- 03/2004
Lead Architect for the infrastructure for 11i E-business suite on 3 tier Architecture. (2web nodes, 2 appserver and 2Database nodes on RAC )
Configured Cisco load balancer for web server and forms metric server for Forms server.
Installed configured and deployed 11i E-business suite on Oracle 9i RAC and Linux
Developed Practice for Oracle 11i E-business suite on RAC, Parallel Concurrent Processing (PCP), cloning, Patching and maintenance.
Administered and troubleshot issues on Workflow, Notification Mailer, PO, INV, CRM, iSupplier, Standard Managers etc.
Trouble shot Concurrent manager issues and optimized their performance
Reviewed and optimized the performance for web, application server, and discoverer and Database servers.
Administered Discoverer 4i
Installed and configured the Technology stack for 9iAS portal, i-comp, BIS with Discoverer 4i
Installed, Configured and integrated 9iAS/10G portal/single sign-on (SSO) with 11i on Linux
Developed backup and recovery strategy and procedure using RMAN.
Cloned the application from Production to TEST and Development
Managed and applied patches on the application and database tiers.
Mentored on-site DBA on Oracle 9i RAC/9iAS portal and 11i E-business Administration
Environment: RedHat Advance Server 2.1, Oracle 11i E-business Suite 11.5.8, Oracle 9.2.0.4, Oracle Cluster Manager 9.2.0.4, ocfs 1.0.9.4, Discoverer 4.16,
9iAS rel.1, ADI, Taxware, 9iAS 1.0.2.2/10G, EMC Storage
University of Wisconsin at Lacross IL Oracle 9iAS Administrator 07/2003
Reviewed the 9iAS Technical implementation and offered solution for optimal performance.
Troubleshoot the CPU spin on java.exe by setting up the database connection pool
Tuned the environment for optimal performance.
Mentored 3 DBAs on Oracle 9i RAC, Veritas Cluster, Replication and Oracle 9i
Environment: Windows 2000, Oracle 9iAS Rel. 2, Oracle 9i, OC4J, Microfocus COBAL, Java, BC4J
Board of Trade Clearing Corporation IL Oracle Specialist 06/2002 – 5/2003
Educated management and system administrators on CFS Vs RAW. Changed the RAC team from RAW to new generation CFS on Veritas (Veritas
DBE/AC 3.5)
Sized hardware and upgraded Oracle 8i Parallel Server to Oracle 9i RAC Release 2 RAC with Data Guard in test, development and production
environment using Sun Solaris, Veritas DBE/AC 3.5 and Veritas CFS
Tuned RAC Performance and application performance using STATSPACK
Gathered statistics and analyzed them for better performance using OEM Performance pack, BMC tools
Administration, backup, recovery and tuning of development, test and production databases
Installed and configured BMC Patrol Software with UNIX and Oracle KM
Multi master advanced replicatin on Oracle 8i and migrated it to Oracle 9i
Creating Materialized Views for better query performance.
Mentored 3 DBAs on Oracle 9i RAC, Veritas Cluster, Replication and Oracle 9i
Environment: Sun OS 5.6, Sun Cluster 3.0, Veritas DE/AC 3.5, Veritas Netbackup 4.5, Oracle 8i/9i, BMC Patrol 3.4, Oracle KM 8.4, SQL Backtrack, IBM
Websphere
Delta Faucet, IN Linux Admin for Oracle Collaboration Suite 05/2003
Involved in Architecture, Design, planning of Oracle Collaboration Suite on 3 nodes with mail store on 9iRAC
Environment: Redhat Advance Server 2.1, Oracle9i Rel.2, Oracle Collaboration Suite 9.0.3, Oracle9iAS, OC4J, J2EE
Bruce & Associates, IL Oracle 11i Applications DBA 12/2001 – 01/2002
Provided high level consulting on Oracle 10.7 to Oracle Applications 11i e-business suite migration, capacity planning, sizing and infrastructure
Installed & configured Oracle Applications 11i e-business Suite on Multi-node Windows 2000, with multi-Org andMulti-language support.
Supported their Oracle 10.7 to Oracle 11i e-business migration, cloned using Kintana
Deloitte and Touche Solutions, IL Oracle Specialist 02/2002 – 06/2002
Provided high level consulting on Oracle Applications 11i e-business suite, capacity planning, sizing and infrastructure. Gave directions to
Deloitte’s Chicago solution center for their Oracle Application Initiatives
Configured and administered Sun Solaris and Windows 2000, prepared the OS for the Oracle 11i Implementation
Implemented multi-node, multi-language support Databases
Sized hardware, installed, configured and performance tuned Oracle Applications 11i e-business Suite (single and multi node) on Sun Solaris &
Windows 2000
Consulted on upgrades from Oracle Applications 10.7 to 11i
Backup and recovery for Oracle 11i E-business suite on Solaris and Windows
Mentored 6 people on installation procedures of Oracle Applications 11i and Oracle 8.17 databases on Sun Solaris and Windows 2000 servers
Environment: Sun Enterprise 220R, Compaq DL 580, Sun Solaris 8.0, Windows 2000 Server, Oracle Applications 11.5.6 (Platinum 5.1), Oracle 8.1.7, Forms
and Reports 6i, Veritas Backup Exec 8.5
SPRINT, KS Senior DBA (Consultant) 07/1999-11/2001
Sprint ION (Integrated On demand Network) had about 20 applications, each interacted with the Oracle database through IB (Info broker) using
CORBA
As an ION production/development/testing Oracle DBA, I installed, created and administered their Oracle 8 & 8i development, SIT, product test and
training databases
Responsible for creating, administering, maintaining, backup, recovery and performance tuning for about 50 Oracle databases. Designed physical
& logical structures; performed capacity planning of the ION databases; BMC Patrol administration for Oracle KM and advanced replication of Oracle
databases. Installed and configured SQL-Backtrack from BMC for Oracle
Implemented BMC Patrol monitoring solutions on servers and Oracle databases
Involved in developing data purging process for ION
Prepared technical white paper “IB/Hitachi TP-Broker/ Oracle interaction“ regarding systems interacts using MTS Server, X/Open systems and
Oracle XA functionality
Involved in architecture, set up, configuration and administration Oracle 8i Parallel Server (OPS) using Sun OPS cluster
Involved in the architecture team’s creation of the IIS data warehouse by collecting data from may databases in Oracle and mainframe. Loaded the
data warehouse using ETL (Extract, transform and Load)
Involved in analyzing the validity of data using Axio software
Managed production CRM (Siebel) database of 2 terabytes
Involved in data migration for Sprint ION for 5 versions
Involved in migration from MS SQL Server 2000 to Oracle 8i - Oracle Workbench
Environment: Oracle 8i, SUN OS 5.7, E10k, Windows NT 4.0, AIX 5L 5.1, BMC Patrol 3.4, Oracle KM 8.1, PSL, DBArtisan 5.3, Oracle iFS 1.02, Erwin 3.5.2,
Hitachi TP Broker, CORBA, Oracle X/Open, XA functionality, ETL, ETT, MS SQL Server 2000
CyberSoft Technologies Inc., Houston, TX Consultant 06/2000 – 07/2000
Sized hardware, installed and configured Oracle Applications 11.0.3 for their ASP (Application Service Provider) initiatives
Environment: Dell PowerEdge, Windows NT 4.0 Service Pack 4, Oracle 8.1.6, Oracle Financials 11.0.3, Oracle Application Server 3.0.1, Oracle Forms
Server, Jinitiator 1.8
Navy Federal Credit Union, VA Consultant 04/1999-06/1999
As a Senior DBA, created multiple 24x7 oracle databases in MS cluster environment. Managed them using Oracle Fail Safe Manager. Provided
backup and recovery using Networker Administrator, Networker User, Oracle EBU and Backup Exec
Wrote batch files and SQL scripts to automate hot backup, cold backup and import/export using scheduler and writing control file for loading ASCII
files using SQL* Loader. Installed, administered and customized BMC Patrol and configured the parameters. Training two junior DBAs
Supported database sizes ranging from 5GB to 20GB
Environment: Oracle 7.3.4, Windows 3.51 & NT 4.0, Oracle Fail Safe Manager2.1.3, MSCS Cluster Administrator 1.0, Networker Administrator 5.1,
Netoworker User 5.1 Veritas Backup Exec 6.11, Oracle EBU 2.2, imp73, exp73, SQL*Loader, BMC Patrol 3.3, Oracle KM 8.1, PSL
TYCO (AMP Inc), PA. Consultant 12/1998 – 03/1999
AMP has about 70 international severs (in different flavors of UNIX and NT) running about 76 Oracle database instances. Also, Oracle parallel
server ran on DEC-TRU Cluster. Used BMC Patrol to monitor all servers and databases and SAP Applications thorough a single console. It was
integrated with HP open view using PET (Patrol Event Translator)
Installed, configured and customized BMC Patrol and different knowledge modules on AIX, HP-UX, SUN, DEC and NT platforms and in the Oracle
databases
Configured and monitored Patrol on Oracle Parallel Server by installing Oracle parallel server KM
Automation database activities using Patrol. Set up the state change actions such that it emailed or paged the DBA when the production database
was down
Prepared the master list of all monitored parameters and set up the baseline value for database parameters in Oracle KM for the databases.
Set up archive log and cleaned it up once its destination was 40% full
Supported database size ranging from 50GB to 200GB
Integrating HP open view with Patrol using PET (Patrol Event Translator)
Writing shell scripts, SQL scripts, PSL scripts, user training and knowledge transfer
Environment: Oracle 7.3 & 8.05, Windows NT 4.0, Digital UNIX V4.0D, AIX 4.3, Sun Solaris 2.6, BMC Patrol 3.2, SAP, Oracle KM 7.2, PSL,
Kellogg Company, MI Consultant 06/1998 – 12/1998
This project comprises of product stability, sensory and chemistry applications. These modules are supporting the R&D of the Kellogg Company. These
applications already exist and are regenerated to make it Y2K and Kellogg Global Standards Compliant.
Creating test database and importing production data
Creating production database and validating the data for new database changes
Performance tuning of the database
Creating database scripts to modify the database
Creating auditing tables and preparing auditing using database triggers
Analyze the existing system and convert it into the global Year2000 and Kellogg Standards Compliant
Environment: Oracle 7.3, Designer/2000, Developer/2000, Windows NT, Digital UNIX V4.0D, Import and export utility
IT Re-engineering Pte Ltd., Singapore. Consultant 01/1997 – 03/1998
This is an integrated software product called PERFORM SCM which includes Purchasing Module, Inventory Module and Sales Module
Oracle database administration , backup, recovery, installation and administration of Oracle Webserver
Physical and logical database design for this application with tuning considerations
Leading a 6 member team, setting the documentation and programming standards
Modules integration and Web enabling of this product
Involved in Solaris 2.5 administration. Installing, managing security, and maintaining the Solaris 2.5 on Sun Sparc Enterprise 2 server
Installed and configured MS-SQL Server 6.0/6.5 databases, created the objects, assigned proper security and setup database connectivity
Environment: Oracle 7.3, MS SQL Server 6.0/6.5, Oracle Webserver 2.1, Oracle Enterprise Manager 1.3, Designer/2000 1.3, Developer/2000 1.4w, Windows
NT, Windows95, Solaris 2.5 BMC Patrol Administrator
SINGNET, Singapore Consultant 09/1997
Involved in the installation of BMC patrol product and its Oracle KM and UNIX KM for SINGNET, a subsidiary of Singapore Telecom. BMC Patrol is
used for system administration and database administration
Database administration, installing BMC Patrol administrator software and user training
Environment: BMC Patrol Software, Sun Solaris 2.6, Oracle 7.3, PSL (Patrol Scripting language)
Mobil Corporation, Singapore. Consultant 10/1997
Involved in the installation of Tabware product and its various modules like equipment, event tracking, work order, scheduling, preventive
maintenance, inventory, purchasing, invoice matching, supplier tracking, graphical analysis, security and setup on Oracle 7.3 databases. It is an ERP
package for petrochemical refineries
Database administration, installing TabWare products on Oracle 7.3 database and user training
Environment: Oracle 7.3, TabWare 2.07(ERP Package), and Windows 3.1
AMSBACH Offshore Services Pte Ltd., Singapore Consultant 05/1997-07/1997
This module is for a shipping company. Worked on Purchase Module and Shipment Module which are integrated.
Database administration of production and development sites. Maintained the production database, backup and recovery, performance tuning of
application and database, leading a 4 member team, design, development and integration and implementing and user training
Environment: Oracle 7.3.2.3, Designer/2000, Developer/2000, Windows NT, and Windows95
TITANOR Singapore Pte Ltd., Singapore Consultant 01/1997-04/1997
Worked on Purchasing and Job costing Modules
Database administration of production and development sites
Maintaining the production database, backup and recovery
Performance tuning of application and database
Designing, developing, integrating, implementing and user training
Environment: Oracle 7.3.2.3, Designer/2000 1.3, Developer/2000, Windows NT, and Windows95
Glaxo Wellcome Pte Ltd., Singapore Consultant 02/1996-01/1997
This system comprises of three major modules namely Payroll, Medical and Training - all integrated together.
Database administration, backup, recovery, database security, writing triggers, stored procedures and packages
Program specification, coding and unit testing
Implementation of this project at Glaxo Welcome, Singapore
User training and system modifications for user acceptance
EISA 486, UNIX SVR 4.0, and Novel NetWare 3.11
Environment: Oracle 7.0, Forms 4.5, Reports 2.5, Graphics 2.5
NCIT, India Software Engineer 09/1993-01/1996
Database administration, backup & recovery, maintaining database security, writing triggers, stored procedures and packages
Program specification, coding and unit testing
Environment: Oracle 6.0/7.0, SQL*Forms 3.0, SQL*Reports 5.0, SQL* Menu 5.0, UNIX SVR 4.0, Windows3.11
 | |  | |  | |  | |  | |  | |  |