Technology Solution Architect - Oracle Applications Resume
SUMMARY:
- Over 16 years of work experience in IT projects in India, Europe & USA with specialization in large and complex program management covering entire spectrum of Supply Chain Planning and Finance, Security, Infrastructures and Databases.
- Last Project He was with one of big 5 Consulting firm as Technology Solution Architects for value chain planning area.
- He also worked in Investment Management domain before moving into securities services.
- He has managed large multi - year, multi-million dollar program that is sourced from multiple suppliers across various geographical locations (both offshore and near shore). As a guiding principle, has always practiced rules depicted in Project Management Book of Knowledge.
- He has worked for 12 years in US and Europe for various assignments.
SPECIALTIES:
- Experience of successfully executing multiple technical upgrade and implementation for Oracle eBusiness version 12.2.2/12.2.1/12.1.3/11.5.10.2/11.5.9. Hands on execution of multiple complex large scale implementations and complex delivery involving multiple layers of tech refresh.
- Experience of successfully creating technology blueprint by collaborating with various stakeholders (Business SME, Corporate technology, IT Operations) in customer organization. Also created and presented cost benefit analysis, IT infrastructure (logical and physical) layout, project funding model for Coos to defend project budget and program benefits.
- Experience of successfully managing complex program consisting of multiple vendors and customers’ various business and technical teams. The program consists of multiple projects including development & maintenance, application & infrastructure support projects and testing projects
- Experience as working as technical Project manager for multiple projects from initiation to successfully completion.
- Experience in managing Large scale Oracle Application Implementation with domain expertise in Supply Chain Planning, Oracle Financial, Procurement
TECHNOLOGY AND PROJECTS SUMMARY:
- Oracle Applications Upgrade and Implementation
- Release 12.2.2 with Value Chain Planning (VCP) and Demantra 12.2.2 with APCC/ OBIEE 11g/Weblogic/ eBusiness Online Patching/ Legacy Collection from JD Edward 9
- Implement OPM (Oracle Process Manufacturing) release 11.5.10.2 in an existing Oracle Financial for Pharmaceuticals industries
- Implement Oracle Single Sign-on with Active Directory for Oracle Applications with
- Demantra OBIEE with Oracle RAC and Multi Node Load Balanced
- Upgrade from 11.5.9/11.5.10.2 to 12.1.3 with Order Management / Financial/Oracle RAC/
- Multi node load balance/Database 11gR2 with ASO/ANO and encryption and
- PCI (payment card industry) in scope application.
- Implement and Upgrade from 10.7 to 11.0.3/Customize and automate business process
- Multi Country/Multiple Sets of Books Implementation in a single global instance
- Oracle Application Platform Migrations
- Platform Migration from Solaris to Linux using Transportable table space for
- Oracle Apps Release for Multi TB database and complex Multi Node load balanced application
- Platform migration from mainframe using oracle tools as the conversion platform for large utility company
- Parallel Concurrent Processing for Oracle Application in RAC and multi application tier environment
- Implement zero downtime rolling patching for oracle apps using RAC/Load
- Balancer/ PCP/ Database services
TECHNICAL SKILLS:
Databases and tools: Oracle Database 9i, 10g, 11gR2, R12g, Multiple upgrades to Release 11hR2 with Real Application Cluster (RAC), Oracle Enterprise Manager (Grid Control) 12c., Demantra 7.3.1.4/ 2.2.2 ,, Weblogin
OBIEE: Oracle forms 10g, Oracle Workflow, Oracle Reports, PL/SQL, Oracle Application Custom(RICE) Development
ITIL and Change Management: Implement ITIL using Remedy Application for Pharmaceutical Industries
Design Methods: Oracle Application Implementation Methodology (AIM), ITIL
Languages: Oracle PL/SQL, Unix/Linux Shell, Java 1.2, JSP, Servlets, XML, HTML, JDBC, COBOL, C/C++, PASCAL
RDBMS: Oracle, RDB
Tools: and Utilities: Oracle Forms, Oracle Reports, Load Runner, Confidential Performance Center, Remedy, DESIGNER 2000, Microsoft Visio, Oracle Discoverer 9i, Oracle Enterprise Manager, Oracle Application Server (9iAS), TOAD, MS Project, MS Visio, Oracle, Apps 10.7/11.0.3/11 i/R12, Remedy Help DeskOBIEE
RELEVANT EXPERIENCE:
Confidential
Technology Solution Architect - Oracle Applications
Responsibilities:
- End to end process flow for New Planning Process
- Cost benefit analysis
- Client interactions for the new process flow
- Technology blueprint for the new architecture
- Organization change management guideline for the entire supply chain process
- Managing a team of 20
- Managing offshore Delivery process for the projects
- Transition planning and support towards achieving steady state.
- Multi node Installation and Upgrade of Ebusiness 12.2.1 and 12.2.2 / Online Patching architect
- Installation and architect Demantra 7.1.3.4/12.2.1 Upgrade to 12.2.2
- Installation and technical architect APCC/OBIEE 11.1.1.0.6 with integration to VCP 12.2.2
- Maintenance and Project support for project development/test/production
- Architect disaster and recovery solution .
- Demantra Legacy Collection from JDE 9 to VCP 12.2.2 to forecasting in Demantra with 12.2 new feature monthly bucket.
- Configure Demantra work flow/Engine/Separate Demantra application tire using web logic for collaborator workbench.
- Configure Demantra for optimal performance for web tier/database/engine run
- Configure Demantra Work flow to run engine and email.
Confidential
Lead Technology Architect
Responsibilities:
- Understands Current business process and support to analyze the deficiency and probable impact and cost benefit for the long term for technology upgrade
- Transition planning for all legacy applications
- Impact assessment on technical infrastructure
- Developing an appropriate test strategy covering developers, users and market participants
- Delivery, Planning and estimate of various ERPs and prioritize it
- Provide support to bring the best of solutions to Confidential by involving domain, testing, infrastructure to ensure that the customer experiences Confidential customer centricity
- Build strong relationships internally and externally and manage expectations of stake-holders - account managers and client partners onsite, horizontal point of contacts, customer program managers and executive management
- Create and sustain a culture of delivery excellence, continuous improvement and innovation
- Address RFPs and RFIs from customer
- Created a high performance team to grow the portfolio while delivering to high levels of customer satisfaction
- New implementation Oracle Demantra 7.1.3.4 with SSO and multinode along with OBIEE
- Upgrade of 2 Large ERPs from 11.5.10.2/11.5.9 with 10g RAC to 12.1.3 with 11g and RAC
- H/W migration along with Linux Migration using Transportable tablespace for 2 ERPs with RAC/Multi Node Loadbalance/ ASO/ANO.
- Deasibility study and Implement Rolling Linux patching with Zero downtime in multi node architectire for all USPS's erp application using PCP/Database Service/eBusiness Node Affinity
- Implement Network Traffic encryption for PCI compliance for Stamp Fulfillment ERP.
Confidential
Program Manager
Responsibilities:
- Lead Oracle Applications DBA/PM for Export Control ERP Databases (24X7 Production Support)
- Over 8 Years of 24/7 Production Support in eBusiness Suite
- Responsible for all Export Control ERP Database Support and EC Oracle Databases (120 ERP Instances and 400 Other databases)
- Responsible for Export Control ERP database supports.
- Maintained / Provided support for development/enhancement/projects
- Maintained dev/test/staging instances for Maintenance Life cycle
- Maintained and supported Cloning/Patching/Security patches/upgrades/
- Automated cloning using 10g grid
- Shared appltop implementation/conversion
- Scheduled periodic performance Review/ follow up with stakeholder for maintaining their expectation
- Performance review for Customer Service Level Agreement (SLA) and periodic review and presenting to upper management
- Configured and maintained High Availability architecture using VERITAS cluster
- Periodic certification for High Availability for SOX certification
- Trained and Maintained resources
- Supported for development projects and closely scheduling resources for Functional projects and engagement.
- Escalation Management and reporting to GE management for continuous improvement
Confidential
Project Manager Manager and Strategic Adviser
Responsibilities:
- Analyze the requirement for implementing Enterprise system for Pharmaceutical Plant
- Selection of Vendor for the technology and managing proposal
- Manage The implementation from Initiation to Completion
- Streamline existing Enterprise system towards Corporate IT direction
- Implement Single Sign-on for all existing IT system to implement security guidelines as laid out by corporate IT
- Define the post go-live support infrastructure
- Implement ITIL process using Remedy Management system
Confidential
Lead Developer
Responsibilities:
- Primary responsibility was to develop a Web-based solution to monitor proactively and effectively us HTML thin client.
- Requirement Study: Wrote technical specification
- Prototyping: Was involved in building a prototype to demonstrate solution capabilities
- Development: Involved in review of design and technical specs. Guided other team member through code review and testing.
Confidential
Lead developer and Oracle Application DBA/Techno Functional
Responsibilities:
- Data Warehouse/Data Mart Material forecasting
- Australia Implementation (Design and Implement Security, Oracle general Ledger)
- Australia Landed Cost Inclusion in Purchasing Receipt (Order Management)
- Australia Internal Order Invoice (Order Management)
- Australia Order Fulfillment Automation/Implementation for Guthy Renker (Order Management)
- Designed and Developed Automatic Email Notification System (Application Object Library)
- Conversion to Multiple Operating Unit and reporting set of books for multi country implementation
- Project for 11i migration (from 11.0.3 to 11i)
- Automated Bank Upload and reconciliation (General Ledger)
- Automated Invoice upload and matching with purchase order (Accounts Payable)
- Designed and Implemented Disaster Recover /Fail-Over System and also minimize production down time (DR Policy and Implementation)
- Oracle Application Database Upgrade to 8i (Server Partitioned Mode)
- Automated WIP Completion Transaction (WIP Module, Average Costing)
- Automated WIP Move Transactions (Oracle Work In Process)
- Automated Order Fulfillment Processing into oracle (Order Fulfillment Automation)
- Oracle Application Upgrade from 10.7 to 11.0.3 (Apps Upgrade)
