Oracle Applications Support - SUNOVION
(2016-02 - 2018-03)
Sunovion Pharmaceuticals Inc. develops and markets pharmaceutical products. The company offers products for central nervous system disorders, such as insomnia, schizophrenia, bipolar depression, and epilepsy disorders; attention deficit hyperactivity and binge-eating disorders; and respiratory conditions, including asthma, allergy, and chronic obstructive pulmonary disease areas.
Sunovion Pharmaceuticals
Inc. was formerly known as Sepracor Inc. and changed its name to Sunovion Pharmaceuticals Inc. in October 2010. The company was founded in 1984 and is headquartered in Marlborough, Massachusetts. As of October 20, 2009, Sunovion Pharmaceuticals Inc. operates as a subsidiary of Dainippon Sumitomo Pharma America Holdings, Inc.
- Ensured constant application availability by performing health check which includes monitoring of application servers and its associated processes
- Monitored concurrent program execution in terms of performance and program failures, taking necessary actions on program failures such as execution of manual runs
- Involved in developing new objects and migrated the recent developed codes using change management process, testing and implementation in test environment, prepare test results doc
- Worked on incidents raised and resolved it within SLA Timing
- Worked with business on Functional testing and implementation of new changes
- Intimate on program failures which requires business to work on the data files
- Managed Quarterly, half yearly and annual activities to complete as per timelines and client requirements
- Involved in various activities such as cloning, disaster recovery, password change activity, patching which are integral activities
- Coordinated with DBA and respective teams such as SI, SOA, Revitas on the monthly maintenance activities
- Coordinated with infra teams such as UNIX, networking/security, messaging teams for various requests such as on program failures, onboarding/off boarding of resources
- Captured all the concurrent program failures for the current month, prepared sox reports and sent to higher management for SOX compliance
- Updated/Maintained all the relevant technical documents/required trackers as and when required
- Prepared status reports and attended meetings with client technical team and business to understand their expectations and work accordingly, good knowledge on service now tool
- Worked with oracle support on critical issues for continued business functions
- Worked on performance issues encountered after database migration (1.2.0.3 to 11.2.0.4), sorted out the cause behind the issue, worked on the solution and ensured smooth business flow
- Worked with DBA on the performance issues of the concurrent programs
- Prepared knowledge base (KEDB) documents to consolidate all the issues that occurred
Oracle Applications Support - HELIOS
(2015-08 - 2016-01)
Helios was established as an independent, separately branded company. Helios provides ICT solutions and services to Medscheme and its partner medical schemes in the areas of administration and health risk management. Helios boasts a leading edge technology platform together with transactional systems which rank amongst the best in the world, which include hosting, switching, administration, health risk management and clinical applications.
The systems are robust and scaleable and supported by highly skilled, passionate ICT staff that form the cornerstone of its business success. Helios leverages off economies of scale to provide cost effective, quality and reliable services and continuously strives to provide optimum and sustainable results for its stakeholders. Helios provides the Nexus and UMS systems, as well as network support and website hosting, for the Group and external clients.
Helios holds a 51% shareholding in healthcare software specialist Allegra.
- Worked on all the finance related issues that are logged as tickets on daily basis
- Implemented new changes in production environment based on finance team approval
- Prepared technical documents for new changes that are implemented in production
- Performed code analysis for performance of sql queries
- Prepared KEDB repository for all the issues occurred in finance modules for easier support
- Attended technical meetings on weekly basis to understand the business requirement and to follow up with the progress
Oracle Applications 11.5.10 Upgrade Consultant - Netapp
(2014-02 - 2015-08)
NetApp, Inc., formerly Network Appliance, Inc., is a computer storage and data management company headquartered in Sunnyvale, California. The company's latest partnership, billed as "Imagine Virtually Anything", involves collaboration with Cisco and VMware to offer customers an end-to-end Secure Multi-tenancy Design Architecture that provides enhanced security in cloud environments.
- Involved in impact analysis to identify the objects to be retrofitted or upgraded
- Conducted analysis include schema wise comparison, forms, index analysis
- Analyzed Standard impacted Objects which are modified and Obsoleted in the Oracle (11.5.9 to 11.5.10.2)
- Identified the custom objects which are impacted due to standard impacted objects
- Upgraded objects which includes Packages, Functions, Procedures, menus, reports
- Retrofitted menus by adding new sub menus and functions according to new functionality in 11.5.10
- Performed end to end testing to ensure the functionality of the modules
- Provided assistance to support team during go live for post go live activities
- Developed XMLP reports based on the customer requirements
- Tested the reports for different test scenarios
- Updated MD 70 with the code changes for the reports developed
- Migrated to test environments and solved the issues raised
- Moved Objects upgraded into many phases like SIT1, SIT2, UAT1, UAT2
- Solved multiple issues during the above phases
- Worked on new requirements in IProcurement module like Enabling PF number in non-catalog request page
- Enabled purchasing news region in shopping home page
- Created header message in non catalog request page
- Configured Supplier site LOV display of all values
- Configured Purchasing news – globally use html in shopping home page
- Solved multiple issues in iExpenses module
- Enabled 'Expenses preferences' functionality in iexpenses page
- Removed 'My allocations' which is a new feature in 11.5.10
- Removed the 'Time and labor' functionality in html responsibilities
- Worked on multiple issues during various phases like UAT and post go live
- Worked with oracle to solve critical issues during go live
- Created test cases according to the test plans to ensure the functionality
- Updated MD 70 for the new code changes performed
- Involved in patch analysis to provide the solution feasibility reports for the issues during go live
Oracle Applications R12 Support - Sonoco
(2013-05 - 2014-02)
Sonoco is a multi-billion dollar global provider of consumer packaging, industrial products, protective solutions and display and packaging services. From its headquarters in Hartsville, S.C., and more than 335 operations in 33 countries, produce packaging for a variety of industries and many of the world's most recognized brands, serving customers in 85 nations. Support on Oracle Applications - Order Management, Purchasing, Inventory, BOM, WIP and MES.
- Provided Support on Setup change request to meet the client requirement
- Performed Data conversion, identified the issues and got them resolved
- Handled interface issues in Advanced Shipment Notice (ASN), Transport Management System (TMS), Material Transactions and Shipping Transactions
- Analysed and resolved issues with pending transactions in month end period close
- Helped in handling Mobile Supply Chain Application (MSCA) transactions
- Coordinated with client and assisted the team in resolving issues through call and taking remote system
- Performed Patch upgrade - Identified the impacted objects and creation of test cases
- Handled Data Corruption in all Order Management and Inventory
- Analysed the product Bug and worked with Oracle Corporation to fix the Issue, if required discussed with Oracle Support team through Web conference
- Implemented Change Management Process – CR creation, raising tasks, moving codes and data fix
Oracle E Biz R12 Upgrade Consultant - Sapient
(2012-08 - 2013-12)
