We provide IT Staff Augmentation Services!

Oracle Scm Techno-functional Consultant Resume Profile

NC

Professional Profile

A professional that combines expert skills in Technology, Supply Chain and Strategic Management to discover new opportunities and optimize existing business processes. Leverages versatile experience in systems architecture, database engineering, performance optimization as well as Supply Chain domain knowledge to provide effective system design, integration, implementation and maintenance. Sharp analytical skills provide quick resolution to system issues.

Technical Skills

  • Oracle Database 7.3.x/8i/9i/10g/11g/12c
  • Oracle Golden Gate
  • Grid/ASM/RAC/ACFS
  • Oracle 11i/R12
  • Oracle Transportation Management System OTM 6.3
  • Solaris 7/8/9/10
  • HPUX Superdome
  • Java
  • Big Data Greenplum, VLDB
  • Oracle Enterprise Manger 9i/10g/11g/12c
  • DataGuard
  • Oracle Streams
  • OAM
  • RHEL 3/4/5/6
  • Veritas CFS
  • J2EE ejb, Servlets,jsp
  • Perl Scripting
  • NIS
  • Korn Shell Scripting
  • Oracle Application Server 4.0.x/9iAS/10g
  • Advanced Replication
  • Oracle Developer 6i/9i
  • Weblogic 11R1/Fusion
  • Netbackup
  • BPEL/BPM/SOA/OBIEE
  • Tivoli Framework
  • F5/SSL
  • DNS

Supply Chain Management SCM Skills

  • Demand Planning/Forecast
  • Reorder-point Analysis
  • Lead Time management
  • UOM Setup
  • Intercompany Receipts
  • Shipping Networks
  • Interface API
  • Transportation Management System OTM
  • Inventory Optimization
  • Order Quantity Analysis
  • Shipping Execution
  • Move Orders
  • Planning Collection Setup
  • Transportation Analysis
  • S OP
  • ABC Inventory Planning
  • Replenishment Strategy
  • Distribution Planning
  • Subinventory Planning
  • Item Setup
  • Plan Creation/Management
  • Transportation Execution
  • SRM/CRM
  • Fleet Management

Business Management/Leadership Skills

  • Order-to-Cash Cycle Analysis
  • Business/Supply Chain Alignment execution
  • Team Building
  • Cash-to-Cash Cycle Analysis
  • Vendor/Supplier Collaboration
  • Marginal Cost/Revenue Analysis
  • Effective Communication

PROFESSIONAL EXPERIENCE

Confidential

Oracle SCM Techno-Functional Consultant

Techno-Functional consultant responsible for the ground-up supply chain design and implementation of pharmaceutical retail/wholesaler. Directed S OP processes defined inventory processes to include replenishment methodology performed demand forecasting/analysis developed supply and distribution plans using multiple constraints. Implemented Oracle R12 SCM modules: Inventory, Order Management, Shipping Execution and ASCP. Configured concurrent managers applied patches cloned system customized workflows using PL/SQL. Upgraded 11g Release 1 database to Release 2 ensured system reliability through backup/recovery scheme performed proactive and reactive database tuning. Set up system monitoring and alert notification through Enterprise manager.

Confidential

Oracle Integrator/Architect

Technical Lead of team responsible for the deployment and integration of an array of Oracle technologies across the IRS in furtherance of its modernization objectives. Deployed and maintained multiple instances of Oracle database 9i, 10g and 11g to support various data capture requirements ranging from OLTP to Datawarehousing. Installed, configured and administered Oracle grid computing components such as: Oracle Streams, Oracle RAC and Oracle Enterprise Management Agents. Resource in the installation, configuration and administration of Oracle middleware solution components: Oracle Application Server OAS , and the Oracle Identity Management. Instituted an Oracle performance measurement and correction paradigm based on the Method R methodology and Oracle center of excellence best practices characterized by daily monitoring of AWR reports, SQL statement optimization/tuning, and improved efficiency through scalability. Mentor junior members of the team.

Confidential

Oracle Apps DBA/Architect

Technical lead and performance engineer for the Known Shipper Management System: responsibilities include providing direction for the efficient deployment of Oracle technology in meeting the objectives of the organization as stated by management. Implemented, configured and customized the CRM module as part of the application development. Supported and provided database engineering services OLTP and Data warehousing for the shared business applications platform. Duties as technical lead included: implementing, configuring and maintaining the Oracle e-business suite of applications, deploying and configuring J2EE applications on Oracle application servers, integrating client services with single-sign on SSO . SOA/BPEL infrastructure implementation to integrate disparate legacy applications. Implemented custom workflow processes to address business requirements. Designed, developed, and implemented methodology to upgrade the database supporting the e-business suite of applications from 9i to 10g. Performed Oracle Applications upgrade from 11.5.8 to 11.5.10. Configured Oracle Services and Transparent Application Failover to ensure availability of system. Configured and implemented Oracle streams, Advanced Queue, and Data guard to support distributed and disparate applications. Duties as performance engineer include identifying problem SQL in real time, tuning and resolving causes of such poorly performing SQL analyzing wait events periodically to forecast potential causes of contention reviewing system reports daily to ensure efficiency. Collection, review and analysis of AWR and statspack reports daily. Mentored other team members from a professional and technical perspective.

Confidential

Oracle Apps DBA

Implemented a new instance of Oracle e-business 11i to include: installation, setup/configuration of system administration module, concurrent managers, workflow and maintenance of relevant services. Upgraded an existing instance of e-business 11.5.7 to 11.5.9 as a fix for various applications issues and also to introduce new functionality to the user community. Incorporated in this is the upgrade of the database from 9.0.1 to 9.2.0.5. Designed and developed a business intelligence solution to include: a data guard system, Oracle Discoverer9i/10g. Installed, configured and maintained various releases of OracleiAS to include: 9I and 10g. Maintained the LDAP/internet directory OID : this included the setting of domain wide system policies, migration of users from a prior release of Oracle Internet Directory to a newer release by the export/import methodology. Developed a portal content management procedure using the PDK. Implemented iStore module as part of an integrated CRM solution. Installed, configured and maintained Oracle express server, Oracle express web agent and Oracle Financial Analyzer for use by business intelligence analysts.

Developed PL/SQL packages used in data migration effort and as part of the bespoke program. Developed RMAN backup and recovery strategy to support SLA of zero downtime. Investigated and rectified database waits, locks and bottlenecks adversely affecting the proper functioning of the system.

Confidential

Oracle Apps DBA

Responsible for the installation and technical implementation of the financials module of the Oracle applications to include: General Ledger, Accounts Receivables, Accounts Payables, Order Management and Inventory Management. Responsibilities also included workflow administration.

Designed and developed the architecture for the hosting environment to include HA: Sun cluster 3.0 and Oracle9i RAC. Participated in Conference Room Pilot sessions to discuss approach for implementation and migration of Legacy data. Developed custom/bespoke PL/SQL programs utilized in the migration of data from Financials order and non-order-- Legacy system into Oracle applications using Oracle supplied interface and custom built tables. Implemented Change management methodology for patch application and versioning of application code. Cloned the application and database servers for use in multiple environments. Installed and maintained Oracle Discoverer 4i in conjunction with the Business intelligence module of Oracle applications as part of the business intelligence solution. Installed, implemented and integrated Oracle CRM as part of integrated e-business solution. Designed effective workflows for the Order management system as part of the implementation. Tuned application servers for optimal performance, by eliminating I/O bottlenecks and connection concentration. Resolved database bottlenecks by examining and analyzing statspack output. Configured and implemented the System Administration module of the Oracle applications. This included defining responsibilities, creating users, defining and configuring printers, defining and managing concurrent programs and managers. Monitored daily notifications and statuses using Oracle Applications Manager. Designed and developed replication scheme for existing legacy system. Developed web PL/SQL programs as part of the implementation of Oracle Portal.

Confidential

Systems Architect/Database Engineer

Technical lead in the installation and implementation of the Oracle e-business suite modules implemented include: Financials, Order Management, Purchasing and Inventory Management. Implementation of Oracle financials 11.5.8 included: Configured Concurrent managers to serve batch jobs. Configured Load balancers and implemented Multi-org and Multi-currency installations. Maintained Oracle e-business suite environment using Oracle provided tools such as: adadmin, AutoPatch, adctrl and Oracle Applications manager. Performed capacity planning and change/patch management for the e-business environment. Optimized and fine - tuned database and Application servers for maximum performance and efficiency. Installed/Configured and maintained Oracle Portal Configured OC4J containers on application servers. Performed upgrade and cloning of application and database servers. Designed and implemented a backup and recovery scheme using RMAN. Designed and implemented a CMM methodology. Implemented Oracle Parallel Server and advanced replication for high availability and redundancy.

Confidential

Database Engineer/Consultant

Key member of the technical implementation and integration of Oracle 11.5.5 e-business suite. Investigated and rectified performance bottlenecks associated with wait events, high resource SQL statements, latch contention and poor disk striping. Performed upgrade of Oracle Financials 11.5.5 to 11.5.7 and cloning of application and database servers. Designed and developed data warehouse/data mining effort. Developed extraction and transformation procedures using PL/SQL. Provided direction to developers in tuning inefficient SQL statements and PL/SQL programs used in customization. Performed UNIX system administration task to include: network configuration and troubleshooting storage management and patching of OS. Responsible for TAR logging and management with Oracle support for bugs and patch updates.

Confidential

Database Administrator

Involved in the full life cycle development of CHCSII, a medical tool for the Department of Defense. Involved in data modeling and physical database implementation. Reversed engineered several data stores and applications from sources such as: Access and SQL server using Erwin data modeler. Ensured data reliability by developing and implementing backup and recovery strategies for existing production databases using RMAN. Provided strong leadership in software versioning, change management and web technologies. Developed complex Oracle packages to satisfy business requirements for e-mail notifications using Sun javamail and Oracle supplied TCP packages. Maintained distributed databases using Oracle Advanced Replication in diverse geographical areas. Developed ETL procedures using PL/SQL. Supported developers with SQL and PL/SQL development. Logged and maintained TAR with Oracle Support.

Confidential

Database Administrator

Translated business requirements into data models for various the shipping exchange marketplace. Designed and implemented a data warehouse for use by senior management and business analysts. Developed ETL procedures and processes for the data warehouse and data marts using PL/SQL. Developed disaster recovery strategies for the operational database and data warehouse using RMAN. Performed proactive and reactive tuning for both transactional and data warehouse performance using various performance tuning techniques. Performed capacity planning to anticipate database growth due to increase in transaction and user community. Supported developers with the development of reports for decision makers.

Confidential

Database Administrator/Senior Consultant

Responsible for the full life cycle development of a purchasing management system for the Department of Defense. Participated in user requirements gathering and data model design. Translated logical database design to the physical database. Led the effort to create a distributed system using the Master-snapshot architecture based on Oracle Advanced Replication. Installed and configured Operating system Solaris, NT as needed at client sites. Configured and maintained databases ensured data reliability through efficient backup and recovery strategy. Installed, configured and administered Oracle application servers as part of application migration from PowerBuilder to a web-based architecture.

Hire Now