Candidates About

 

B Y Ramakrishna

Experience Summary

·         Oracle Applications (EBS) Sr. Technical Consultant

·         Having 15 years’ experience as an IT Professional and 13 yrs. using Oracle 11i / R12.

·         Roles performed -Team Lead, Senior Technical Consultant, Analyst and Developer 

 

Technical Skills

 

Oracle Apps / E-Business Suite: 11i & R12	ü    Implementation experience performing Technical work (Implementation, Rollout, Support, Conversion, Migration and integrations) ranging the different versions of oracle ERP applications 11i and R12. (Oracle EBS) ü     Experience with full lifecycle implementations, extension, design and development (RICE / CEMLI) around Supply Chain Management, Procurement, Distribution, Manufacturing and Finance ü     Proficient in functional and technical aspects of Oracle Modules - Financial (GL, AR, AP, CM, SLA), i-Expenses, Supply Chain Management (SCM) Modules, Oracle Distributions (Purchasing (PO), Inventory, Order Management (OM) and Shipping (WSH), OTC, Warehouse Management System (WMS), Trading Community Architecture (TCA), Oracle Service Contracts(OKS), Oracle Discrete Manufacturing (WIP, BOM, MRP, QA), Knowledge of Oracle Projects, Alert Manager (ALM), Sys Admin, Workflow, OAF and AOL. ü    Experienced in order to Cash(OTC) and Procure to Pay(PTP) Cycles. ü    Experienced in Performance Tuning. ü    Upgrades; Migrations, Rollouts, Customizations and Extensions; Interfaces, integrations and Data Conversion. ü    More than 6 Full life-cycle implementations of Oracle E-Business Suite ü    Extensively used Oracle Application implementation methodology (AIM) ü    Extensive knowledge of Oracle Apps tools, CEMLI, RICE and shell scripting. ü    Knowledge of Web Center, Control-M Job setup and scheduling. ü    Knowledge of Service Now, JIRA Ticketing systems and SVN Version Control System. ü    Exposure to Oracle Retail Suite (ReIM, RMS9 and RMS14, SIM)
Oracle Tools/Components:	Oracle Forms, Reports, SQL*Plus, SQL*Loader, Oracle Discoverer, Oracle Workflow, XML Publisher, Unix Shell Scripting, OAF Personalization and Customizations. Knowledge of OBIEE, APEX, EDI, ODI, SOA, Web Center and ADF.
	Misc.: JIRA, GIT, SVN Version control system, Service-Now, TSRM, SQL Navigator, Toad, MS VSS, Smart FTP, MS Visual Basic, MS Access, Putty,
Languages:	SQL & PL/SQL , Java, HTML / XML
OS:	UNIX (Sun/Solaris), LINUX, MS-Windows & MS-DOS

 

Projects

 

Project Profile: Production Support of R12 SCM, Finance and Oracle Retail Suite (Invoice Management)

Client:    Nordstrom, Seattle, WA. (Nov’16 – Till Date)

Role: Oracle Support Engineer

Environment: Oracle 11g, SQL, PL/SQL, R12 EBS, ReIM, EDI, RMS14, SIM, RIB, Unix, Control-M

 

·         Working in R12 SCM and Finance(Payables, GL), Oracle Retail Invoice Management in Production support and Development.

·         Working in the production support of EBS Payables integrated with Mainframe system and RMS.

·         Perform trouble shooting production issues (Day to Day production Support)

·         Working on Control-M Batch job processes involving Unix Shell Scripts, Pro*c and PL/Sql scripts.

 

Previous Experience:

 

Project Profile: Production Support ERP R12

Client: COX Enterprises, Inc., Atlanta, GA (Through Accenture) – (Aug’16 – Oct’16)

Role: Oracle Support EngineerTechnical Consultant

Environment: Oracle 11g, SQL, PL/SQL, R12.2.4

 

·         Perform trouble shooting production issues (Day to Day production Support) and provide technical and techno-functional support for existing oracle E-Business modules;

·         Analyze support tickets related to Oracle i-Expenses, Oracle Projects (PA), General Ledger(GL), Oracle Payables (AP), Order Management (OM), etc.

·         Actively involved in system Administration, Application Object Library (AOL), Oracle Workflow Administration related works and issues.

·         Maintain the work as per standards using SVN, Version Control system.

·         Respond to the customer tickets for the issues related to OAF Personalization, XML Publisher Reports, Oracle Forms and Reports and UNIX shell Scripting program issues.

·         Handling the issues arising during the data flow between the Integrated Systems. E-Business System is integrated with other systems using Oracle SOA. Integration programs include third party software such as, e.g. Atlas to Oracle, WEB Center Capture, Verifier, Imaging.

• Worked on Service Requests with Oracle Support team to resolve bottleneck issues

 

Project Profile: Implementation and Post Production Support of ERP R12.1.3

Client: AWR Group (Al-Rostamani), Dubai, UAE (Apr’15 – Jun’16)

Role: Oracle Senior Technical Consultant

Environment: Oracle 11g, SQL, PL/SQL, R12.1.3

 

• Al-Rostamani Group (AWR Group) operates in several industries including automobiles sales and service, real estate, logistics, IT, Trading, Manufacturing of luxury and retail items. Lumina are one of the subsidiary company of AWR, which is involved in manufacturing of lighting equipment.  
• Also, acted as Team lead, involved in Assessment of Time lines for different objects of Technical work, guided the team in completion of work in stipulated timeframes, updating the client with project status on regular basis.
• Developed Oracle conversions include custom conversions from Legacy applications (BI Cause way) to Oracle AP (Suppliers, Open Invoices), INV (Item master), AR (Customer master, AR Open invoices, Receipts API), CE APIs (Bank, Brach, Bank Account), GL Interface, BOM (Master Data for BOM and Routings) and WIP (Jobs).
• Technical work - involved in implementation of Finance (GL, AR, AP, CM), OTC, Distribution and Manufacturing modules (PO, INV, OM, WMS, WIP, BOM, MRP, QA and Shipping). .
• Developed many xml reports as part of implementation.
• Migration of Master data, Transactional data, and development of reports for various modules are part of technical work handled during the implementation.
• Also involved in post-production support activities.

 

 

Employer	:	Apps Business IT Solutions Pvt. Ltd., India
Period	:	July 2009 to Mar 2015
Designation	:	Project Lead (Technical)

 

Project Profile: Support and Rollout of ERP R12.1.2

Client: Petrofac Information Services, Chennai, India. (Mar’14 – Mar’15)

Role: Oracle Senior Technical Consultant

 

• Petrofac works on a full-fledged implementation constituting Human Resource (HRMS - Payroll, OTL), Finance (AR, AP, GL, CM) Projects, Purchasing, Manufacturing and Distribution Inventory modules (OTC, PO, INV, OM, WMS, WIP, BOM, MRP, QA and Shipping).
• Technical work involved Technical Support to Day to day business, working on Oracle project, bug fixing, reports development, Custom Objects development and Roll out work.
• Custom objects worked on includes Reports, Form Personalization, Client Extensions apart from Code pack preparation, shell scripts, Version History maintenance (SVN) and Ticketing system of Global Service Desk (GSD) maintained by IBM.
• Work also included Assigning the team with Tickets, Giving Time frame for tickets based on complexity, updating the SVN with completed objects, maintaining version history.
• Involved in legacy conversion to ERP P2P, OTC, Item Master and Interface development and product support, workflow customizations and AME Setups.
• Provided oracle Views to the OBIEE team to develop OBIEE Reports.
• Tuning of Oracle Views used for OBIEE, to increase the report performance.

 

Project Profile: Implementation of R12.1.3

Client: Essel Infra Projects Ltd, India. (Jun’13 – Mar’14)

Role: Technical Team Lead

 

• A full-fledged implementation constituting Purchasing, Inventory, Project Contracts and Finance modules (GL, AR, AP). The Customer Care and Billing (CC&B), MDM, WAM modules of Oracle Utilities should be integrated with E-Business Suite.
• Technical work involved Data migration for Oracle Utilities, Data Migration for E-Business Suite, large number of reports development, Custom Objects development and post production support.

 

Project Profile: Oracle Support and Development (R12)

Client: Trans-Asia Ltd, India. (Aug’13 – Nov’13)

Role: Team Lead

 

• Trans-Asia is using R12 version of E-Business Suite. They need Customizations in PO Approval Workflow and Quote Approval Pages. Also, they need the Leave approval workflow to be modified as per their requirement.
• Technical work involved Customization to the Quote Approval Process and HRMS Leave Approval Workflow and customization to the Quote OAF Page.

 

Project Profile: End to End Implementation and Support Project (R12.1.3)

Client: PWANI Oil Products, Kenya. (Jun’12 – May’13)

Role: Technical Lead

 

• A full-fledged implementation constituting Purchasing, Distribution, Inventory, Manufacturing and Finance modules (GL, AR, AP, CM, PO, INV, OM, OTC, TCA, MES, WIP, BOM, MRP, QA and Shipping).
• Technical work involved Data migration, Oracle project discussion, large number of reports development, Custom Objects development and post production support.
• Worked on Bank Statements import and reconciliation using SWIFT940.
• Custom objects developed includes Average Cost Update program, Sales order Import, EFT Payment Instructions, Sub-Distribution (Drop Ship) program, Program to Integrate Weigh Bridge with Oracle Application and a custom program to maintain Import/Export Sales Information (TREO) for Kenya Revenue Authority (KRA).

 

Project Profile: Implementation and Post Production Support. (R12)

Client: SASTRA, India. (Mar’12 – May’12)                                                                                                     

Role: Oracle Consultant

 

• The development work constitutes OAF Personalization and Workflow. Purchase Order Notification and Purchase Requisition Notifications are to be customized as per client requirement. Enabling DFF in Purchase Order form and displaying the fields in the Purchase notification was another extension work performed.

 

 

 

Project Profile: Development of Oracle Reports, Extensions and Interfaces

Client: Al-Shirawi , Dubai. (Dec’11 – Feb’12)

Role: Oracle Team Lead (Offshore)

 

• Performed the role of Offshore Team Lead as well as involved in the development work. Maintaining the status reports and participating in the internal status meetings to review the work progress, etc.

 

Project Profile: Upgrade Project from 11i to R12

Client: Intelligroup, India. (Now NTT Data). (Sep’11 – Nov’11)

Role: Technical Lead.

 

·         Upgrade from 11i to R12 and Development of Reports and Data Conversions.

• The objective of Technical Team was to identify the custom objects in 11i which needs to be remediated, analyse the custom objects, remediate them as per requirement and migrate them to R12 Instance.
• Performed the role of offshore Team lead, monitoring the Team, assigning objectives and timeframe for the team, maintaining the status reports that needs to be sent to client on site, conducting daily status meetings with offshore team and participating in status meeting with onsite team, assisting the team in completion of work and giving the deliverables on time to the client

 

Project Profile: Support and Development of ERP 11i

Client: Al-Shirawi, Dubai. (May’11 – Aug’11) (Overlapping dates with previous Project)

Role: Oracle Technical Consultant

 

• Developed multiple Reports and PL-Sql programs.  Performed the role of on-site co-ordinator. Sending Project Weekly Status, attending weekly status meetings, Requirement gathering and Analysis of new development work, Assigning the work to the team in off-shore, monitoring the off-shore team work, assisting the team in completion of work and giving the deliverables on time to the client.

 

Project Profile: Rollout and Development Project for R12 Finance and Purchasing Modules.

Client: TAGHLEEF Industries LLC, Dubai. (Jan’11 – Aug’11)                                                                        

Role: On-Site Co-Ordinator

 

• This project is rollout of Oracle Applications R12 Finance (GL, AR, AP) and Purchasing Modules. Also, It involves new implementation of Manufacturing and distribution modules (PO, INV, OTC, OM, MES, WIP, BOM, MRP, QA and Shipping) to one of the Sites.
• Developed multiple Reports, interfaces, Conversions. 
• Developed Extension program for Average Cost Update of Layer costing method.
• Involved in developing plsql package to import Discrete job information from legacy to Oracle Application to create jobs, Complete jobs.

 

Project Profile: Extensions in ERP 11i

Client: Aljomaiah Automotive Company, Saudi Arabia. (Aug’10 – Dec’10)

Role: Oracle Senior Technical Consultant

 

·         This project Involved in development of an interface between Oracle Applications 11.5.10.2 CRM Module and Third party, FICO CDA (Capstone Decision Accelerator). Module used primarily is CRM.

Project Profile: Implementation of R12 Finance, Supply Chain and Manufacturing Modules.

Client: S Kumar Group, India. (May’10 – Aug’10)

Role: Oracle Technical Lead

 

·         As Project Technical Lead, analysed customer needs and identified appropriate technical solutions for an Oracle Apps R12 implementation of Oracle Finance, Supply Chain in SMHPCL of S Kumar Group. 

·         Involved in implementation of Finance (GL, AR, AP), Distribution and Manufacturing modules.

·         Worked closely with a variety of users from the operating line in order to understand their requirements.  Designed solutions that met the customer expectations.

 

Employer	:	Larsen and Toubro InfoTech Ltd., India
Period	:	May 2008 to Jun 2009
Designation	:	Project Lead

 

Project Profile: Support and Development in ERP 11i

Client: Flowserve, Europe. (May’08 – Jun’09)

Role: Oracle Project Lead (Technical)

• As project leader, delivered on schedule a large-scale Oracle ERP development activity with complex reports and data interfaces. Helped to recruit new consultants, mentored junior staff and supervised teams of up to 4 on client assignments such as
• Support Related Development for All Modules of Flowserve- Pumps Division-Global Enterprise Shared Services.
• Development Work for Change Requests raised by Support Team.
• Development and Customization of Reports / Interfaces / Conversions /XML Reports/Form Customizations, etc.

Employer	:	ICompliance, USA
Period	:	Feb 2007 to Sep 2007
Designation	:	Senior Technical Consultant

 

Employer	:	GTL Limited, India, IGTL, USA
Period	:	Apr 2004 to Jan 2007
Designation	:	Associate Consultant and Senior Technical Consultant

 

Project Profile: Support and Development in ERP 11.5.10

Client: PR Newswire, New Jersey, USA. (Jul’06 – Sep’07)

Role: Oracle Applications Consultant

• Ensure that technical developments are designed and implemented to support the integrated, global nature of the firm and thereby provide the desired benefits across the enterprise.
• Need to keep track of the Cases raised by the Clients and Functional Team
• Applying code fix and data fix, if required also used the standard API’s for issues logged.
• Worked with the functional team to provide the technical solutions
• Updated Technical Specification (MD070) depending on Functional requirement (MD050) for interfaces development and reports using AIM
• Used XML Publisher for developing reports in various formats such as PDF, Excel, RTF, etc, as per the requirement of the Key Users.

Project Profile: Support and Development 11.5.10

Client: IGTL, Texas, USA. (Jan’06 – Jun’06)

Role: Oracle Technical Consultant

 

·         Support and Development work, data conversion, Reports and Interfaces using Oracle Purchasing, Inventory, Receivables and OM Modules

·         Writing technical documents. Implementing solution to cater to the required changes in the application as per the requirement analysis. Developed Interfaces in AR and INV Modules.

·         Design and Development of Reports in PO, INV, AR and OM (OTC) Modules.

 

Project Profile: Implementation of 11i in Finance, SCM and Manufacturing Modules.

Client: Dresser Valves, India. (Mar’05 – Dec’05)

Role: Oracle Technical Consultant.

 

·         Undertaking development and customization activities in relation to technology projects, enhancements and application maintenance & development, technical customization, systems technical integration and reporting development.

·         Liaison with functional analysts and other colleagues in IT on the development of requirements analysis, business cases, project scopes and project plans for the introduction of relevant technology solutions.

 

Project Profile: Implementation Project in 11i Finance, SCM and Manufacturing Modules.

Client: Sharada Terry Products, Coimbatore. (Oct’04 – Feb’05)

Role: Oracle Technical Consultant

 

·         Involved in end to end implementation of the project.

·         Developed Reports, Interfaces, Extensions and Data Migration.

 

Project Profile: Implementation of Oracle Financials, Distributions and Manufacturing Modules. 11.5.9

Client: Continental Engines, India. (Apr’04 – Oct’04)

Role: Oracle Technical Consultant

 

·         Involved in end to end implementation of the project.

·         Developed Reports, Interfaces, Extensions and Data Migration.

 

Employer	:	Spider Systems Pvt. Ltd., India
Period	:	Mar 2003 to Apr 2004
Designation	:	Technical Consultant

 

·         Developed Reports, Interfaces, Extensions and Data Migration.

 

Other projects undertaken in India from Oct 1998 – Feb 2003 using Oracle, Forms, Reports, SQL Loader, SQL, PL/SQL, Java Script, Microsoft visual Basic and HTML

 

Employer: Charter Global Software India Pvt. Ltd., India

Period: Jun 2000 to Feb 2003

Designation: Software Programmer

 

Employer: Defence Electronics Research Laboratory, India

Period: Oct 1998 to May 2000

Designation: Software Programmer

 

Education

<td s

·         GNIIT from National Institute of Information Technology