Oracle Apps Technical
Confidential
مجموع سنوات الخبرة :17 years, 1 أشهر
As Systems engineer, I am in charge complete Oracle EBS as platform, with responsibility for the support of financial systems including Consolidation, Inter Company journals of Oracle ERP, Manage the monthly and annual financial closing process in conjunction with the different support teams. Managing project deliverables with onsite & offshore consulting teams and Reviewing existing processes & systems and accordingly implementing measures for ensuring higher operational efficiency
• Excellent track record of working in close coordination with cross-functional IT support Team such as HR, Finance, Procurement DBA’s & TS teams for analysis/resolution of functional and technical issues.
• Manage/Involved all aspects of the Applications Administration & Management (System & Application) and Production Support including deployment and migration activities from Development through Testing to go-live.
• Managed various Projects related IT implementation projects including process re-engineering & Upgrade project methodology framework
• Handled large-scale projects and interacted effectively with business and stakeholders to translate business requirements into IT deliverables. Demonstrated Project Management Methodologies and projected strong interpersonal skills leading to effective team building and delivering projects on time and within budget.
• Lead the requirements gathering workshops to drive unique global footprint for each of the different business units: Finance, HR, Procurement & Subsidies
• Assisted the project manager on mission-critical software development and production support projects
• Involved setting up of Workflow Notification Mailer for inbound and outbound processing, Workflow administration.
• Production Support, Conversions, Upgrades, System Administration, Change Control, Audits, BCP, Disaster Recovery related to Oracle EBS.
• Demonstrated the ability to interact with all levels of management. Consult with business management to identify and prioritize opportunities (projects and enhancements) to enhance the use of applications in support of their business objectives.
• Organizes, prioritizes, coordinates, and administers the activities and workload of the application support/development team.
Played Managed the following Activities / Projects whilst at Qatar Airways are outlined below: -
Oracle EBS Application (12.1.3 To 12.2.5) & DB (11.2.3 To 12 c) Up-gradation (Current Project) -
Upgradation of Oracle ERP application form 12.1.3 to 12.2.5. As project lead involved in project phases planning, Project Documentation (Current in planning stage Project target dates Sep 2017)
Oracle ERP Cloud Implementation - Avail the market trend, Option/Modules available and to gather information of success for implemented/migrating of EBS to cloud by involving vendor (Oracle) and engaging partners and present the stats to CIO for proposal of cloud for EBS.
Oracle DB Up-gradation from 10g to 11g for Oracle ERP Database - Upgradation of Oracle ESB Database from 10g to 11g. As project lead involved in project phases planning, Project Documentation and leading users and development teams through functionality testing, performance testing, custom modules testing, testing/review of interfaces and resolving technical & functional issues by involving development teams, DBA to work together and involving Oracle support (wherever required) for closer of issues to ensure smooth production upgradations .
Oracle ERP Application Up-gradation from 12.0.3 to 12.1.3 - upgradation of Oracle ERP application form 12.0.3 to 12.1.3. . Planning project phases and leading users and development teams through functionality testing, performance testing, custom modules testing, testing/review of interfaces and resolving technical & functional issues by involving all the teams
Oracle ERP Application & DB Migration-
For more information refer to CV
Project No. : 1
Client : Confidential
Role : Oracle Apps Technical Consultant
Oracle Apps Modules : PO, INV, OM, GL, AP, AR (Finance)
Scope: The application aimed at helping British Telecom users to buy the accessories online required for installations and up gradation. The application provided users with a view about the various types of accessories required and the discounts offered to them. The project aimed to implement Oracle ERP Applications suite for all the modules of Financial and Manufacturing Domain. The project involved converting legacy data to Oracle, developing inbound & outbound interfaces, customization of forms & reports and developing extensions. AIM Methodology was adopted for process handling and documentation.
Responsibilities :
• Studied and analyzed AIM documents (MD.050)
• Developed customized forms (6i) using Custom Library, Application APIs on WinNT and UNIX
• Deployed new forms, reports, packages, requests, request sets and SQL-Loader scripts
• Adapted AR invoices to EFC status (Reports 6i)
• Undertook customization and development of the following PLSQL interfaces: AP, Import of electronic invoices (Payables Open Import Interface), GL and AP Vendors
• Undertook production and maintenance of documentation
Project No. : 2
Client : Mercury Marine
Role : Oracle Apps Technical Consultant
ERP : Oracle Applications Implementation & Development
Scope: Mercury Marine, located in US, is leading manufacturer of recreational marine propulsion engines and having manufacturing units in Suzhou, China. The project aimed to implement Oracle ERP Applications suite for all the modules of Financial and Manufacturing Domain. The project involved converting legacy data to Oracle, developing inbound & outbound interfaces, customization of forms & reports and developing extensions. AIM Methodology was adopted for process handling and documentation. 2 integration tests (SIT): one exclusive conversion testing and user acceptance testing (UAT) were conducted to ensure accuracy and stability
Responsibilities :
• Studied and analyzed given AIM Documents (MD.050)
• Developed customized forms (6i), using Custom Library, Application APIs on WinNT and UNIX
• Deployed new forms, reports, packages, requests, request sets, SQL-Loader Scripts
• Adapted AR invoices to EFC status (Reports 6i)
• Handled customization and development of the following PLSQL interfaces:AP, Import of electronic invoices (Payables Open Import Interface), GL and AP vendors
• Handled registration of Tables and DFFs in the forms development
• Developed test cases, installed scripts and migrated documents
• Performed SIT, reviewed UAT plan and ensured proper coverage
• Converted PO Quotation Interface by feeding quotation from the vendors into an external purchasing system
• Imported quotations through PO open interface tables
• Monitored validation of data by custom program, loading to interface tables and submission of standard import “Import Price Catalog”
Client : TeliaSonera Stockholm, Sweden
Role : Oracle Apps Technical Engineer
ERP : Oracle Applications Development
Oracle Apps Modules : GL, AP, AR (Finance) & PO (Mfg)
RDBMS : Oracle 9i
Scope: TeliaSonera is a leading telecommunications company in the Nordic & Baltic region and also holds strong position in mobile communications in Eurasia, Turkey and Russia. TeliaSonera offers reliable, innovative and easy-to-use services for the transmission and packaging of sound, images, data, information, transactions and entertainment. The telecommunications markets are undergoing a rapid migration from fixed to mobile and Internet-based services. TeliaSonera is therefore focusing their service portfolio by reducing the number of traditional fixed services and broadening our range of mobile and Internet-based services, while simultaneously, taking steps to bring costs to a competitive level.
Responsibilities :
• Developed and customized reports & interfaces
• Created Value Sets, KFF and DFF
• Generated reports and forms extensions for Finance modules
Industry : Manufacturing (Electronic Chips)
Period : Aug 2006 to May 2007
Organization : ICS, Bangalore
Name Project : Computerized Integrated Manufacturing and Allied Systems CIMAS
Environment : Oracle 9i, PL/SQL, Developer/2000, Forms 5.0 and Reports 3.0
Role : Oracle Programmer
Reporting to : Manager
RDBMS : Oracle 9i
Description:
This was a Comprehensive Project meant for Integrated On-line computerization of a Job shop type as well as standard products Manufacturing Company. This was a total on - line computer software solution encompassing all the activities of a manufacturing unit like Accepting Customer Inquiry, Equipment Quotation Generation, Bill of Materials Preparation, Estimation, Sales Order Generation, Job Order Generation, Purchase Order Generation, Dispatch, Vendor Rating, Material Management, Payroll etc. This project was consisted of 10 modules - Engineering, Estimate, Purchase, Stores, Inspection & Quality Assurance IQA, Dispatch, Finance and Payroll. This system was developed to streamline the organizations information flow and to eliminate many of the redundant manual operations. Provisions were made to provide all necessary MIS reports and to prepare and maintain ISO-9001 documents.
Contribution: Design and Developed Forms and Reports, Coding, Unit Testing, System Testing, Implementation and Documentation.
Features Used: For Oracle 9i Server as back-end:
• Database Trigger
• Stored Package & Procedure
• Views, Sequences etc
DEVELOPER/2000: Used almost all important features, some are mentioned below:
• Functions and procedures,
• Almost all important Form triggers and Built-in packages,
• MDI application with multiple window and canvas interfaces,
• Dynamic LOV, Programmatically Record Group handling,
• Generation of Forms 6i from Forms 5.0 etc.
• Developing Forms 6i Library to use as common object,
• Designed highly complicated Reports using all important typical features of Reports 6i like Placeholder & Formula columns, conditional Report Layouts, Group filters and Report Triggers etc
Course Board/University Percentage of Marks Year of Passing B.Tech (ECE) Jawaharlal Nehru Technological University. Hyderabad, Andhra Pradesh, India. 59.58 2008
Diploma in Engineering (ECE) Technical Board of Andhra Pradesh, India 64.53 2002
S.S.L.C Board of Public Examination Andhra Pradesh, India. 69.56 1998
