Sr Oracle It Business Analyst Resume
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 AnalystResponsibilities:
- 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