SUMMARY:

• Oracle Certified DBA with over twenty two years of IT experience in a large enterprise systems environment support mission critical systems and applications. A high degree of demonstrated technical excellence across multiple database technologies and computing platform technical specialties.
• Technology specialist with experience in financial, manufacturing, retail, mobile, outsourcing industries. Expertise in project management, pre sales, proposals, data center operations, server sizing, database design, administration, upgrades, migrations of applications across teh platforms, application development, team management, provisioning of hardware, consolidating satellite data centers, problem analysis, trouble - shooting, prioritization skills, ability to handle multiple tasks simultaneously, work TEMPeffectively as an individual contributor as well as in a team environment along with excellent verbal and written communication skills. Understand business systems and impacts of infrastructure on business operations. Installs, maintains, upgrades, troubleshoots, tests and supports Oracle database and applications technologies.
• Extensive experience in Oracle database, E-Business & Fusion middleware / SOA Suite, in global environments including working with off-shore and on-shore based teams on development and production support of all core technologies with ability to converse with business and technical team members. Provided technical consulting and sales support services
• Skilled Pre-Sales consultant with diverse noledge in providing comprehensive support for Oracle database (RAC/non-RAC), Oracle EBS (Single tier / Multi-tier), Oracle Fusion Middleware (Cluster / Non-Cluster) & oracle appliances (Exadata, Exalogic & Exalics).

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i/8i/ 8.0.5, Oracle V7.x

Applications: Oracle EBS / Oracle Financial Application R12, 11i R10.7, R11 & 11i, Oracle Fusion application, 10gAS & 9iAS

Tools: SQL*Forms, SQL*Reports, SQL*Menus, SQL*Dba, SQL*Loader, DB Artisan, Oracle*Forms, Oracle*Reports, Oracle*Graphics, Oracle Web Server, Oracle Designer 2000, Oracle Webdb, Server Manager, Export/Import, DB Vision, BMC Patrol, Oracle Inter Office, Oracle Enterprise Manager, Oracle Power Objects, Oracle Video Server, Microsoft Exchange, Oracle Network Manager, Oracle Discoverer 2000, Oracle Financial, OEM Packs, MTS Distributed Database, RMAN, SQL*Loader, Migration Utility, Embarcadero tools, Data Warehousing, DB Artisan, Erwin Data Modeler, TOAD.

Languages & Technologies:  C/C++, SQL, PL/SQL, FoxPro, COBOL, Assembly, UNIX Shell Scripting, Perl

O/S & H/W: Redhat Linux, Oracle enterprise linux, Sun Solaris, Solaris for Intel, AIX RISC/6000, SCO Unix, Unisys SVR4, HP Unix 10.2 & 11,VaxVMS, Novel Netware, Unix Ware, Windows-NT/95/98/ME/XP, RISC/6000, SUN E3500, Dell 4600, Intel x86, HACMP, CLUSTER, EMC, Mainframe

Confidential, Chicago, IL

Sr. Principal Consultant

Technical Environment: Oracle Glodengate, Oracle Data Integrator, Oracle enterprise metadata management, Data governance/Data quality, Oracle Veridata, Oracle Glodengate Studio, Oracle Exadata, Oracle Exalogic, HP UNIX RISK & Itanium, Linux, Oracle/9i/10g/11g/12c, Multi-node RAC, SAN, Data Guard,, Oracle10g/11g AS, Oracle ERP 11i, Oracle ERP R12, Business Intelligence, Data warehouse, load balancer, Oracle Enterprise Manager, Demantra, ASCP, Discover, VCS, fusion middleware SOA/B2B, Hadoop HDFS, Cloudera, Mongo DB, NoSQL database, Kafka, Casandra AWS, Azure, OPC, SQL Server, DB2 & Teradata

Responsibilities:

• As a Principal Sales Consultant I is accountable to drive Oracle Data Integration pre-sales for teh upper Midwest region of teh USA, and to support Oracle GlodenGate, Oracle Data Integrator, Oracle Enterprise Metadata Management, Big Data Preparation Cloud Service and Oracle Enterprise Data Quality. Develop an integrated solution which met customer needs

• I play an instrumental role in numerous multi-million dollars deals and collaborate with Executives and decision makers supporting Enterprise, National and SMB accounts. I work with Data Integration Sales Representatives to plan and prioritize opportunities and with Oracle sales teams to provide leadership support.
• My responsibilities include teh delivery of presentations of teh overall Data Integration solution and leadership of customer discovery and white-board sessions, and I work closely with teh internal Sales Teams to architect a complete Oracle red-stack solution.
• Additionally, I initiate and manage Proof-of-Concepts for GlodenGate and Data Integrator, provide technical guidance in enterprise licensing agreement discussions, and assist teh Sales Representative with complex licensing scenarios. 
• Other duties include teh promotion of data integration solutions at customer events, and I host hands-on-lab workshops and training sessions, and contribute to teh testing and launches of new products.
• I has developed considerable expertise in teh Big Data capabilities of GlodenGate and Oracle Data Integrator, and has worked with HDFS, Hive, HBase, Kafka, Flume, Spark and Cassandra.
• I've also conducted a proof-of-concept loading data from an on-premise Oracle database to Amazon AWS Redshift using Oracle GlodenGate.

Confidential, Lisle, IL

Principal Consultant

Technical Environment: Oracle Exadata, Oracle Exalogic, HP UNIX RISK & Itanium, Linux, Oracle/9i/10g/11g/12c, Multi-node RAC, SAN, Data Guard,, Oracle10g/11g AS, Oracle ERP 11i, Oracle ERP R12, Business Intelligence, Data warehouse, load balancer, Oracle Enterprise Manager, Demantra, ASCP, Discover, VCS, fusion middleware SOA/B2B.

Responsibilities:

• Assessed project statement of Work (SOW), produced detailed documentation and teamed with program manager to identify and capture project tasks and requirements.
• Monitored projects and presented progress to senior management and participated in weekly client update.
• Facilitated overall and-user and system administrator training.
• Supervised, trained and directed team of technical engineers through full project lifecycle relaying teh project vision, objectives and activities.
• Developing and redesigning product to meet goals and objectives of organization
• Conducting research on new products and evaluating specific requirements of customer
• Coordinating training sessions for sales and marketing staff
• Associating with marketing and sales professionals to develop and implement TEMPeffective marketing plans.
• Developing product road maps and migration strategies
• Maintaining good relationships with internal and external business partners
• Working with customers to ensure smooth delivery and implementation of software solutions
• Participated in pre-sales strategy planning as well as demonstrating solutions for ERP and supply chain policies

Confidential, Naperville, IL

Principal Consultant

Technical Environment: HP UNIX RISK & Itanium, Linux, Oracle/9i/10g/11g/12c, Multi-node RAC, SAN, Data Guard,, Oracle10g/11g AS, Oracle ERP 11i, Oracle ERP R12, Business Intelligence, Data warehouse, load balancer, Oracle Enterprise Manager, Demantra, ASCP, Discover, VCS, fusion middleware SOA/B2B.

Responsibilities:

• Responsible for installation, upgrades, patches, TAR support, concurrent manager administration

• Cloning R12, 11i databases using through oracle applications and rapid clone technique
• Appling teh OS patches for Linux R12,11i and Oracle Application patches and upgrade teh Application
• Tuning Application Modules, Upgrade Performance Best Practices, Tuning teh Database Tier, Tuning teh Concurrent Manager, Network and Desktop Client Tuning, Tuning & Troubleshooting teh Apps Tier, Middletier Tuning
• Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
• Oracle SOA/Fusion Middleware Team lead.
• Provide Cross Functional and Cross Location Project Management Support
• Implement fusion middleware SOA for many clients cluster and non-cluster environment.
• Setup B2B with their trading partners with SSL implementation.
• Integrate SOA with EBS.
• Installed OFSAA in multi-tier architecture with Web logic Server. Updated base release with new patches
• Create and manage clustered ADF / Coherence environment with middleware / weblogic.
• Install Webcenter, UCM, BIP, OAM, Webgates & OID.
• Configure Single Configuring Single Sign-On with Oracle Access Manager (OAM) 11g.
• Integrate SSO with EBS and configure OAM for applications.
• Use Oracle IFS Manager & OEM to setup and configure Oracle Internet File System (IFS)
• Build roadmap and design strategy for current and new clients.
• Responsible for putting together teh structure and foundation of teh ERP Service Line, which includes setting up of standards, policies and procedures, in-house Oracle EBS training, sales and services, provide Oracle Application DBA technical expertise, etc.
• Building ERP Service Line Repository
• Mentoring and working with internal colleagues on training them on using teh Oracle E-Business Suite software.
• Provide onsite and offsite Oracle Applications DBA technical skills to clients.
• Implemented / Upgrade latest Oracle E-Business Suite software, R12.1.3.
• Work with on-shore and off-shore to assign their task for teh their night shift and co-ordinate with day-time off-shore team to assign work tickets and everyday production and non-production issues
• Support and maintain multiple Oracle Applications 11i & R12 instances including multi-node RAC production and other third party and supporting databases.
• Upgraded Oracle Application from 11.5.9 to 12.1.2.
• Upgrade 10g database to 11gR2 in RAC environment for third party and supporting databases.
• Perform 2-tier and 3-tier clones of Oracle Applications 11i & R12 instances.
• Apply database and applications patches.
• Reviewed new hardware and technologies like Exadata, Exalogic and Exelytics and recommend to customers as needed.
• Some of these tools and utilities being used for monitoring & management, Alerts Manager, Oracle Enterprise Manager, Workflow Administrator, and Oracle Diagnostics
• Has experience on many EBS modules AP, GL, AR, FA, AP, AR, BOM, ASCP, PO, CRM, HR & self service
• Install and configure Oracle Business Intelligence 10g & 11g with following components: Distributed Configuration Management, Business Intelligence Discoverer, and Application Server Containers for J2EE, Application Server Reports Services, Application Server Web Cache, Oracle HTTP Server & Process and Management Notification.
• Offering pre-sales support to sales reps and agents.

Confidential, Chicago, IL

Sr. Oracle Application DBA

Technical Environment: HP UNIX RISK & Itanium, Oracle/9i/10g/11g, Multi-node RAC, Data Guard,, Oracle9i/10g AS, Oracle ERP 11i, Oracle ERP R12, Business Intelligence, Data warehouse, load balancer, Appworx, HAWC & Oracle Enterprise Manager, Documentum, Demantra, ASCP, Discover, VCS, Veritas, SAN

Responsibilities:

• Work with on-shore and off-shore to assign their task for teh their night shift and co-ordinate with day-time off-shore team to assign work tickets and everyday production and non-production issues

• Support and maintain 12 Oracle Applications 11.5.9 & 12.1.2 instances including multi-node RAC production and other third party and supporting databases.
• Upgraded Oracle Application from 11.5.9 to 12.1.2.
• Upgrade 10g database to 11gR2 in RAC environment for third party and supporting databases.
• Create build and design doc for 11g database upgrade & R12 EBS upgrade.
• Manage Oracle Wallet.
• Production Support (On-log queue management)
• Monitor and manage offshore Production and non-production DBAs.
• 24-7 production support on rotation.
• Create & review production release before implement.
• Create design & build docs for teh new technology components and products.
• Migrate SSO/OID from 9i to 10g.
• Upgrade Demantra to 7.2.0.2 with SSO configuration.
• Install upgrade and configure 10gAS with SSO and load balancer.
• Support data ware house database and warehouse builder.
• Migrate documentum from RISC to Itanium.
• Monitor RMAN catalog report of all production and non-production backups.
• Perform quick and full tech validations as needed of EBS, 10gAS, OEM and Databases
• Migrate databases from HP UNIX RISC to HP UNIX Itanium RAC.
• Clone database and middle tier.
• Migrate third party application database from 9i to 10g.
• Implemented Oracle Business Intelligence (BI) in Test and Production Environment.
• Support BI, Demantra and Third party application applications.
• Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems.
• Worked on EBS R12 Financial modules Accounts Payable, Accounts Receivable, Fixed Assets, and General Ledger.

Confidential, Bridgewater, NJ

Senior Consultant

Technical Environment: Solaris 8, Oracle 8i/9i/10g, Oracle9i/10g AS Portal, Oracle ERP 11i

Responsibilities:

• Team Leader to a group of 4 DBA's (3 offshore and 1 onshore)

• Manage on-shore and off-shore DBAs as per projects and support.
• Oracle 8i, 9i and 10g Database Administration and Management on Solaris and Windows NT environments.
• Production, development & test support of ERP 11i10 with separate instance of supply chain also running 11i10.
• Ongoing administrative jobs on teh production, test and development environment.
• Installation and Administration of Oracle Applications 11i.
• Database migration, upgrade and patch implementation
• Upgraded Oracle Application from 11.5.8 to 11.5.10.2
• Upgrade Oracle Database to 10gR2 from 9iR2.
• Installed & configured 10g AS Portal.
• Performed data migration from 9iAS to 10AS Portal data.
• Involved in hardware upgrade decisions.
• Implemented SSO and SSL for 10G AS Portal.
• Create & import wallet for SSL.
• Administrate portal and AS using Enterprise manager for 10g AS, OID Admin & Webcache admin.
• Clone Test, Development and Training instances from Production by using adclone
• Configured Physical Standby Database (Data guard) from two Production Oracle Databases.
• Lead role in new system acquisitions and migrations
• Implemented RMAN Backup & Recovery strategy.
• Database/Application performance tunings.
• Patch implementation for application as well as databases as required.
• Implemented Oracle EM Grid Control to monitor and tune Oracle Databases.
• Perform disaster recovery and in some case switch from production to hot side where data guard is in place.
• B2B and BPEL setup.

Confidential, San Antonio, TX

Technical Environment: Linux, Oracle 9i/10g, Oracle 10gAS Portal.

Responsibilities:

• Installed 9.2.0.4 database.

• Upgrade to 9.2.0.5.
• Create metadata repository using repca tool in 9.2.0.5 database.
• Installed 10gAS (9.0.4.0) Infra structure & Middle tier on DMZ.
• Upgrade Infra, Middle tier & Metadata repository to 9.0.4.1.
• Enable SSL using Oracle Wallet Manager (OWM)
• Applied portal export/import patch.
• Export pages & data from OOD and import it on teh local servers.
• Change portal url as per requirement.

Confidential, Chicago, IL

Technical Environment: Solaris 8, Linux, Oracle 8i/9i/10g.

Responsibilities:

• Upgrade database to teh specific version first for teh security 68 patch.

• If necessary create a new home and upgrade or migrate database later.
• After migration or upgrade, Security 68 patch implementation.
• Update all teh necessary files if Oracle home TEMPhas change including third party backup and monitoring utilities.
• After patching implemented listener protection.
• Load in-house developed application, which require perl and java in Oracle database for gathering administrative information from teh database.
• Load or Create Java system into teh oracle database if necessary.
• Check pre-requisites for upgrade as they has almost all teh releases and versions are running.
• Take down time; inform users or owners for application testing after all teh upgrade in place.
• Make sure to upgrade and patch within teh time window.
• Monitor production and development events.
• Production & Development support.
• Oracle upgrade & installation.
• Data guard / Standby implementation & monitor.
• Co-ordinate with users for their new requirements and amendments.

Confidential, Naperville, IL 

Senior Consultant

Technical Environment: Solaris 8, Oracle 8i/9i/10g, Oracle9i/10g AS Portal, Application 11i

Responsibilities:

• Ongoing administrative jobs on teh production, test and development environment.

• Installation and Administration of Oracle Applications 11i.
• Database migration, upgrade and patch implementation
• Upgraded Oracle Application from 11.5.8 to 11.5.9.
• Installed & configured 10g AS Portal.
• Implemented SSO and SSL for 10G AS Portal.
• Create & import wallet for SSL.
• Administrate portal and AS using Enterprise manager for 10g AS, OID Admin & Webcache admin.
• Configured Physical Standby Database (Data guard) from two Production Oracle Databases.
• Implemented RMAN Backup & Recovery strategy.
• Database/Application performance tunings.
• Patch implementation for application as well as databases as required.
• Shell scripting for cron jobs & some customization in already created scripts.

Confidential, Chicago, IL

Consultant

Technical Environment: Solaris 2.6, Oracle 8i/9i

Responsibilities:

• Complete a review of teh CCS (Legacy System), RMTS (Oracle) & Yardi (Oracle) System schemas to ensure all elements are mapped, dat teh relationships are understood and dat any code table values are translated to CHA equivalent values.

• Review Gap Analysis in teh CHA Data Cleansing Analysis Report against teh Yardi System to determine if teh elements exist in teh new housing management application.
• Compare RMTS (Relocation Management Tracking System) Yardi System schema. If they are significantly different, define tables separate from RMTS dat will become teh foundation for converting data to teh Yardi System.
• Define changes to existing and/or creation of new CCS extracts to support teh conversion of Unit data.
• Update/supplement rules dat should be implemented in scripts by teh CHA QA/QC team to validate teh extracted data and provide error reports to allow data to be cleansed by CHA technical and non-technical CHA resources. Rules include: Numeric, Date, Reference, Regular Expression Value Matching (masks), in-domain, out-of-domain, required.
• Installed Oracle 9i & 9iAS Portal for Yardi Application.
• Management, design, user requirement gathering, and development of Data Warehouse using Oracle 8i, 9i and 10g databases and portal.
• Created separate databases for test and development environment.
• Design online and offline backup and strategy.
• Administrate three-tier & client-server applications.
• Performed space management and application response.
• Complete set of document delivers to CHA with problem and resolutions.

Confidential, Brookfield, WI 

Consultant

Responsibilities:

• Extensively involvement in project design and development.

• Installation of Oracle RDBMS version 8, 8i & 9i database in Clustered environment on HP-Unix of Oracle Application Release 11i on Sun Solaris/Windows NT& Microsoft SQL Server 2000 in Windows NT/2K.
• Configure Applications to work with SQL Server & Oracle Databases.
• Applying financial and self-services patches (Including Latest Patch sets) to application and database.
• Installing/creating/configuring Oracle databases and 9iAS.
• Developing and managing team in teh development of a portal using Oracle 9iAS and 9iDS tools - Oracle Designer, Oracle Warehouse Builder, Oracle Reports, Oracle Discoverer, Portal reports, etc. Heavy PL/SQL stored procedures and triggers; some Java stored procedures.
• Performed single byte to multi byte data conversion
• Convert and load character sets into utf8 databases
• Tune Applications, Databases & Operating systems to get maximum performance.
• Tuned SQL statements by tracing sessions using SQL Trace and converting trace files using TKPROF. Prepared / scheduled Analyze scripts for computing statistics on heavily used tables. Database monitoring / performance tuning through OEM, performance tuning Pack.
• Administration, Performance tuning and optimization; Distributed database; High Availability; Installation, Upgrade and Migration; Application Design, Development, and Implementation; Backup and Disaster Recovery; E-Business Suite Implementation for oracle Financial Applications; Project Management and Application Design Methods; Technical Team Management; oracle Gateway Configuration; System Administration for both UNIX and NT platforms.
• Support/Tuning of Production Databases. Used UTLBSTAT / UTLESTAT & Statpack for collecting statistics.
• Used RMAN & EBU to take backups.

Confidential, Milwaukee WI

Responsibilities:

• Installation & configuration of Oracle software including System Administration duties.

• Install Application R11i on HP-UX and Windows NT.
• Successfully upgrade Oracle Application from R10.7 & R11 to R11i (OM OE, AR, GL, AP, PO, INV) on HP-UX.
• Configured, Supported SQL on Windows 2000 Server
• Optimized data access by tuning redo logs, temporary tables and oracle parameters; Optimized system load by using Parallel Query option, usage of Partition tables, Bitmap indexes, Descending indexes, Direct Path, Export/Import transportable table spaces, Function-based indexes, Materialized views, Parallel analyze, Parallel bitmap, Star query optimization, Parallel DML, Parallel Index build, Minimal Network traffic, Heavy I/O usage, redo logs, rollback segments and large amount of memory; copied large volume of data from legacy system to oracle using Extraction
• Teh data warehouse system is tuned to allow several large processes to run at maximum throughput.
• Interact & connect some application was required for Data ware housing, to connect database was reside on different platform and was not an Oracle utility, I configured ODBC to get connected.
• Migrated Oracle 7.3 to Oracle 8i release 2 and did fresh installation on HP-UX cluster.
• Implements new feature of Oracle 8i.
• Establishing and maintaining sound backup and recovery policies and procedures
• Implementing and maintaining database security
• Performed database tuning and performance monitoring
• Tune SQL statement for faster I/O
• Re—Organized Indexes as per requirements
• Planed and implemented of security, users access and privileges for database objects/application data
• Create and Manage Read only Snapshots and materialized views.
• Extract data from some other Databases like Access 97 and upload into teh Oracle Database.
• Planning growth and changes (capacity planning)
• Performing technical trouble shooting and giving consultations to development teams
• Maintained and supported Financial Warehouse, Certification Training, Time Reporting, Training Catalog, Safety Rates and EDI applications Databases.
• Installed, configured and migrated Oracle software /RDBMS (Migrate from 7.3.4 to 8.1.7 64-bit)
• Configure automated backups and housekeeping jobs through Cron.
• Troubleshoot contention, fragmentation and as other problems came regarding connectivity, space, security, application issues etc.
• Performed SQL and PL/SQL and create and update packages and procedures as per application requirement.

Confidential, Wilmington, DE

Responsibilities:

• Installed, configured and migrate/upgrade Oracle software and RDBMS on AIX with HACMP cluster environment & Sun Solaris OS.

• Worked as a technical team member implementing teh Oracle Suite including all teh financial, Manufacturing and HR modules.
• Established and maintained sound backup and recovery policies and procedures
• Implemented and maintained database security
• Supported some critical applications like Netview, Expert Advisor & Tivoli Enterprise Management.
• Provided senior level Oracle DBA services focusing on database administration, SQL performance tuning and Advanced Tuning
• Upgraded all databases from 7.3.4 to 8.0.6 .
• Auditing teh Database (Defined value based and activity based auditing to investigate suspicious database activities as per management needs).
• Create and Manage hot standby databases by cron jobs
• Backup & Recovery (used automated backup veritas and netview on OS level and used Enterprise Manager Backup on 7.3.4 and on 8.0.6 using RMAN.
• Installed and configured oracle on clustered environment (HACMP)
• Designed and developed backup strategies and data recoverability including disaster recovery
• Configured Backup and housekeeping jobs through Autosys
• Create and manage objects such as tables, views and indexes to ensure teh recoverability of teh database structure (DDL), perform table level and index re-orgs, plan and manage storage parameters for tables and manage all application specific recovery logs.
• Implement oracle Financial Application v10.7SC, v11.0 and v11i and provided solutions for upgrade, patch, performance and data warehouse modules.

Confidential 

Senior Oracle Consultant

Responsibilities:

• Oracle Installation and Configuration (Oracle 8I, 8x and 7x Application Release 10.7SC)

• Applying and Maintenance of RDBMS Server Patches, Oracle Application Product Patches and 10SC Client Product Patches.
• Upgrade of Oracle Applications Release 10.7 to 11.0.3
• SQL*NET Configuration using SQL*Net Easy Configuration, Net8 Configuration and Network Manager.
• Replicated Oracle Databases as per client requirements like multi master replication, Advance Replication and simple replication using database link at client side.
• Database User/Security Management
• Optimized Resource Usage
• Planned Backup and Recovery Strategy
• Auditing Teh Database
• Created databases using utf8 for unicoding to support internationalization
• Forms & Reports Conversion to latest release.
• Restoration Of Database After a Crash
• Monitored and optimized Teh Performance of teh Database using utlbstat /utlestat and some other tools.
• Maintained Physical & Logical Backups On Teh Tape / Device
• Training (Conducted various corporate levels training)
• Application Development Using D2K and OWS.
• Oracle Financial Installation (Oracle Application Release 10.7 and 11)
• Technical Support to local and multinational clients on various Oracle Products.
• Also engaged as an instructor in Ora-tech Education Services Private Limited, which provides education services of different Oracle tools and RDBMS like Oracle 7.x & 8.x.
• Create & update reports using D2K and generate HTML as per requirement on teh fly.
• Used PL/SQL cartridge for some web based applications.
• Migration of Oracle databases from open vms to NT/UNIX (HP, Solaris 2.6).