We provide IT Staff Augmentation Services!

Sr Oracle It Business Analyst Resume

4.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

Over 20 years of work experience in IT projects in India, Europe & USA with specialization in large implementation projects for Supply Chain Planning and Finance, Security, Infrastructures and Databases. Worked with various clients like Manufacturing, Retail, Federal Government.

EXPERTISE AREAS:

  • Confidential /GOP/ Confidential /APCC Solution Architect/Lead
  • E - Business Technical Architect/Technical Lead/ Oracle Apps DBA
  • Enterprise Resource Planning Solution Architecture
  • Program/Project Management
  • Complex Project Delivery
  • ERP Project Lead/Management/development
  • IT Application Management/Development
  • Oracle Custom Development
  • Oracle Solution Design Workshop for Global Design

SKILL:

Databases: Oracle 11gR2, R12

Development/Productivity Tools: Oracle Developer/PL SQL/Reports/Unix Shell Script/MS Project/Power Point/MS Excel/MS Visio/SQL Developer

Oracle Apps Modules: GL/AP/AR/Order Management/ Confidential /OPM/WIP/BOM/INV Third Party SCP Applications

Programming Languages: C/Pro C/PL SQL/Oracle Forms/Reports/Unix Shell Script/Java

PROFESSIONAL PROJECT EXPERIENCE:

Confidential

Sr Oracle IT Business Analyst

Responsibilities:

  • Lead the Implementation of Oracle Confidential and Confidential .
  • Analyze the business process with existing Confidential and align with current Confidential implementation.
  • Lead the Confidential Integration
  • Lead the Confidential Implementation and POST Go Live Support

Confidential

Solution Architect/Functional Lead

Responsibilities:

  • Design Review Sessions with Key Stakeholder
  • Formalize and Design PPT requirement questions and feedback and followup
  • Finalize Fit GAP analysis and freeze the Scope with Client side Lead
  • Develop prototype/CRP for confirmation of requirement and GAP
  • Lead the RICE Development with offshore team and develop MD050/BR100
  • Review and sign off of Design Document
  • UAT and Final Sign off and Go Live and Post Go Live Support

Confidential

Project Manager/Technical manager

Responsibilities:

  • Project manager for R12 Upgrade from 11i for Order to Cash
  • Technical Manager for AMS and offshore/onshore development

Confidential

Director

Responsibilities:

  • Confidential Forecasting with Replenishment Planning Solution
  • Reviewed the current Confidential implementation with Replenishment system and recommendation for lowering the projected Inventory

Confidential

Technical Solution Lead/Apps DBA

Responsibilities:

  • Implementation/Re implementation of Confidential Demand Management, Confidential, Order Management, IO
  • Stabilized their Current Confidential for performance (over 70% improvement)
  • Confidential Hierarchy Changed/Re implemented as per new requirement for interfacing with Confidential
  • Upgraded Confidential to 12.2.4.1 and other VCP technology stack to 12.2.4 from 12.1.3
  • Confidential Forecast Tuning after upgrade and Hierarchy Change

Confidential

Sr Oracle IT Business Analyst

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 Confidential 7.1.3.4/12.2.1 Upgrade to 12.2.2
  • Installation and technical architect Confidential //SNOAPCC/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.
  • Confidential Legacy Collection from JDE 9 to VCP 12.2.2 to forecasting in Confidential with 12.2 new feature monthly bucket.
  • Configure Confidential work flow/Engine/Separate Confidential application tire using web logic for collaborator workbench.
  • Configure Confidential for optimal performance for web tier/database/engine run
  • Configure Confidential 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
  • Implementation of Confidential with Oracle ODI and OBIEE
  • 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 USPS by involving domain, testing, infrastructure to ensure that the customer experiences HP customer eccentric
  • 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 Confidential 7.1.3.4 with SSO and multi-node 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 table space for 2 ERPs with RAC/Multi-Node Load balance/ ASO/ANO.
  • Feasibility study and Implement Rolling Linux patching with Zero downtime in multi-node architecture for all USPS's ERP application using PCP/Database Service/E-Business Node Affinity
  • Implement Network Traffic encryption for PCI compliance for Stamp Fulfillment ERP

E-Business Support

Confidential

Responsibilities:

  • Lead Oracle Applications DBA/PM for Export Control ERP Databases (24X7 Production Support)
  • Over 8 Years of 24/7 Production Support in E-Business 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 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

Oracle E-Business (Oracle applications) Developer/Analyst

Responsibilities:

  • Develop and Customize E-Business Reports as per Business Requirement
  • Troubleshoot and support Post Implementation
  • Develop Custom Interface to automate various business processes
  • Customize Business process to enhance the existing implementation
  • Define new organization and operating units to add more business units into the system.
  • Implement Australia set or books for bringing Australia business into Oracle (Multiple Sets of Books)
  • Develop and automate various monitoring of WIP job completion, costing errors for pro active monitoring
  • Support Database and also maintenance of development by cloning the E-Business.
  • Automate alerts for Critical process using Oracle E-Business Alerts and Custom developed package
  • Develop and Web Based Monitoring portal for Database and Application Services

Confidential

Consultant

Responsibilities:

  • Analyze current system and develop ER diagram
  • Develop Custom code and testing and Documentation

We'd love your feedback!