SUMMARY:

• Oracle certified IT professional with 20 year’s industry experience in a variety of roles ranging from Confidential, integration specialist and technical consultant to Oracle Applications, Database and Fusion middleware administrator.
• Participated in: all phases of the Systems Development Life Cycle (SDLC); implementation & integration of ERP, engineering & business applications; development of Information Technology strategies; evaluation of emerging technologies and tools.
• Lead IT strategic and operational planning to achieve business goals by fostering innovation, prioritizing IT initiatives, and coordinating the evaluation, deployment, documentation, and management of current and future IT systems across the organization.
• Directed development and execution of an enterprise - wide disaster recovery and business continuity plan. Provided production support of commercial off-the-shelf (COTS) applications for engineering (oil & gas), publishing and education industry using in-premises, off-premises (cloud) and managed services (OMCS) model. Maintained current knowledge of Oracle & MS SQL Server tools and technologies.

TECHNICAL SKILLS:

Oracle Enterprise Apps: E - Business Suite, PeopleSoft, Governance Risk & compliance (GRC), Configuration Controls Governor (CCG), Hyperion (FDM & EPM)

Engineering Application: EDM Suite of Drilling applications; Peloton's Wellview; P2 s eVin & Procount, Landmark s Aries, TOW; Schlumberger s OFM. Flow-Cal

Boundary Apps: Ecosys EPC, Virtual Trader, More4Apps, EIS, Vertex, Automic UC4, Talemetry, BOLO Reporting Tools Oracle Business Intelligence (OBI), TIBCO Spotfire, SSRS

Databases: Oracle DB (8i,9i,10g,11g,12c), Microsoft SQL Server (05,08,12,14), Big Data, Hadoop

Middleware: Oracle Fusion Middleware, Tomcat, Apache, Oracle Application server

Oracle Tools: Discover, Warehouse Builder, JDeveloper, SQL developer, Golden Gate, Business Process Management (BPM), OEM, RMAN, UPK, OSB, ASM, RAC,AIA, ODI, SOA Non-Oracle Tools HP-PPM (Kintana), HP Application Lifecycle Management, Informatics, Clear Case, Toad, CVS, MS Visual Studio, Share point, IBM InfoSphere (DataStage), LDAP server Oracle Eng sys Oracle Database Appliance (ODA) X5-2

Languages: PL/SQL, Java, COBOL, Shell scripting, MS Visual Basic, Delphi, Pascal, WLST, OS Red Hat Linux, Oracle Linux, Sun Solaris, Oracle Solaris, Windows

PROFESSIONAL EXPERIENCE:

Principal

Confidential

Responsibilities:

• Provide vision and leadership for developing and implementing information technology initiatives, recommend and support cost-effective technology solutions for all aspects of the organization. 
• Coordinate and facilitate consultation with stakeholders to define business and systems requirements for new technology implementations.
• Ensure continuous delivery of IT services through oversight of service level agreements with end users and monitoring of IT systems performance

Sr. Oracle Consultant

Confidential

• Worked with Oracle Engineers to Rack & Stack Oracle Database Appliance (ODA) X5-2 in Data Centers
• Upgrade Oracle EBS 11i application and 11gR2 DB to R12.2 EBS and 12c Database on ODA
• Cloned Production EBS, IBM Maximo and other application & Databases to Test/dev & staging
• Code migration from UAT to PROD and applied Patch in prod and non-prod Environment
• Configured attunity change data capture to populate SQL Server data warehouse using Oracle as source
• Installed MS SQL server 2014 Database servers, configured SQL links between Oracle and SQL
• Implemented OEM 12C to administer oracle & non-oracle technologies (Databases, AppTier and hosts)
• Day-to-day production support of Oracle EBS, Performance tuning
• Review application technical document to verify compliance with architectural requirements & standards
• Works with other database and systems operations teams across the enterprise to ensure efficient and effective delivery and support of LINUX and Windows based services.

Sr. Oracle Consultant

Confidential

• Participated in migration of oracle databases (informatics, Volts, Tobin) from AIX to Linux
• Executed SQL scripts and compiled audit reports required end of months as per SOX requirements
• Performed instance and application tuning to improve performance Procount business reporting.
• System and database support during migration of Assets into PROCOUNT database
• Performed task required during upgrade from wellview 9 to wellview 10
• Maintain and support SAP, SQL and oracle databases for ERP and engineering applications
• Executed Day-to-Day database maintenance and business user support activities task

Confidential  

• Worked with management to oversee implementation of disaster recovery solution
• Coordinated with teams across the different colleges during disaster recovery testing procedures.
• Upgrade OBI and EPM (Oracle Fusion Campus Solutions Intelligence for PeopleSoft)
• Developed strategy to upgrade PeopleSoft (HR, FIN, CS) modules to latest version
• Participated in the meeting to migrate to oracle supper cluster and 12C databases
• Prepared roadmap for enterprise reporting encompasses informational & analytical reporting
• Day to Day support as systems DBA, cloning, patching, backup& recovery, performance tuning

Oracle APPS DBA

Confidential

Responsibilities:

• Involved in all phases of Oracle EBS implementation project and production support activities
• Provided infrastructure, architecture and database support to development, technical & functional teams
• Supported apps deployed on WebLogic & Tomcat and their integration with other application using SOA
• Hand-on experience on WebLogic server architecture, admin, configuration and troubleshooting issues
• Troubleshoot EBS issues related to cloning, patching, concurrent manager, configuration and workflow
• Coordinated among functional and technical teams to setup and test Disaster Recover solution
• Experience in AIA, SOA composite deployment, web services, SOAP, OHS, Clustering, Security
• Administered and maintained PCP (2-node Concurrent Managers), EBS Printer, context file, autoconfig
• Coordination with Oracle Managed Cloud Services (OMCS) for production support and maintenance
• DBA experience and understanding of oracle SSO, OEM, Grid Control, RAC, DMZ, load balancing Application Development Framework (ADF), Oracle Application Framework (OAF) and ad-Utilities

Oracle APPS & Fusion DBA

Confidential

• Involved in architecture and infrastructure tasks of Oracle EBS and Fusion Middleware applications
• Provided support to development, technical & functional teams from O2C (order-to-close)
• Coordinated with Oracle Consulting services (OCS) and Oracle Managed Cloud services (OMCS) to troubleshoot functional and technical issues and coordinate to implement resolution
• Supported performance and QA teams to conducted UAT, regression, integration and performance testing
• Maintained and administered SOA composites and SOA Databases in Prod and non-prod environments

Sr. Oracle DBA

Confidential

• Managed data migration projects from legacy systems to ERP systems, gathered client’s business requirement, performed gap analysis, develop data mapping procedures and tuned conversion procedures
• Implemented virtual private database, transparent data encrypting (TDE) and PL/SQL procedures using obfuscation toolkit to encrypt sensitive data to meet Payment Card Industry (PCI) requirements
• Configured flashback data archive a low-cost, high-performance, secure, and seamless history data management system that replaced complex application logic, database triggers and redo log mining