Resume
GD SRIKANTH
Oracle Apps Technical Consultant
Email: gdsrikanth@gmail.com
Mobile: +91- 789 333 6996
Professional Summary:
• Having 13+ years of experience in IT Profession. This includes one-year client facing experience in U.K. Overall 8+ years as an Oracle Apps Technical Consultant in Design, Analysis, Development and Implementation of various commercial applications in ERP using Oracle Applications R12, Oracle 9i/10g, Forms 6i/10g and Reports 6i/10g and 4 years of relevant experience in ITIL Domain (Change Management) and Networking.
• Worked on SCM, HRMS and Financial modules when required.
• Areas of expertise include SQL, PL/SQL and RICE Components.
• Good Functional Knowledge on Procure to Pay and Order to Cash cycles.
• Worked on Sub Modules:
Account Payables(AP),
General Ledger(GL),
Accounts Receivables (AR),
Purchasing Order(PO),
Order Management (OM),
Inventory(INV),
Human Resources Management System (HRMS).
• Expertise in System Administration Responsibility and Application Object Library (AOL) Responsibility to Application User Setup, Defining Responsibilities, Value Sets, Flex Fields, Registering Concurrent Programs, Menus, Reports.
• Involved in development of Forms and Reports and Customization of Forms and Reports from various modules.
• Developed Technical designs (MD070, CV060) and Migration Document (MD120) for different reports, Interfaces and Conversions.
• Experience in Inbound Data Migration using SQL* Loader/ External Table and Outbound Interface using UTL_FILE packages.
• Experience with Oracle and Other Utilities: TOAD, SQL *Plus, SQL*Loader.
• Having experience in Development of XML Publisher Reports.
Educational Qualification:
• Bachelor of Science with Specialization in Mathematics, Physics and Electronics, from Andhra University with an aggregate of 72%, first class with distinction.
• Council of Higher Secondary Education (CHSE, +2) from Orissa Board, Bhubaneswar, with an aggregate of 72%, first class with distinction.
• Secondary School Certificate from Board of Secondary Education, Hyderabad, with an aggregate of 80%, first class with distinction.
Working Experience:
• Currently associated as an Assistant Consultant with Tata Consultancy Services Limited from March 2018 to till date.
• Worked as Technical Analyst with Infosys Ltd from December 2007 to February 2018.
• Worked as a Senior Phone Banking Officer with ADFC Pvt. Ltd. (Sister Concern of HDFC BANK) from December 2005 to December 2007.
Application Software:
ERP Tools : Oracle Apps 11i (11.5.9/11.5.10), R12(12.2.3)
RDBMS : Oracle 10g and Oracle 9i
Languages : SQL, PL/SQL
Tools : TOAD, SQL *Plus, SQL *Loader
UI Tools : Forms 6i/10g and Reports 6i/10g
Reporting Tools : XML Publisher
Operating Systems : MS Windows 95/XP/7
Professional Experience: (In Descending)
Project #1:
Designation : Technical Consultant
Client : Sainsbury’s(UK)
Project : HRMS Interface
Environment : Oracle Applications R12
Duration : Sep’15 – Till Date
Sainsbury’s is the second largest chain of supermarkets in the United Kingdom. The holding company, J Sainsbury plc, is split into three divisions, Sainsbury’s Supermarkets Ltd, Sainsbury’s Convenience Stores Ltd (Sainsbury’s Local), and Sainsbury’s Bank. The group’s head office is in the Sainsbury’s Store Support Centre in Holborn Circus, City of London.
Responsibilities:
Custom Programs:
• Supplier Conversion – Used standard API’s for Supplier creation in Oracle EBS.
• Customer Conversion – Used standard API’s for Customer creation in Oracle EBS.
• AR Invoice Interface – Used standard API’s for Customer creation in Oracle EBS.
• HRMS Data Anonymization – Used standard API’s for masking HRMS Employees information in Oracle EBS.
• Developed an Outbound Interface using Multithreading
Developed a program with outbound extract in xml format output which involves multithreading concept. The employee and payroll information are components in this project.
Project #2:
Designation : Technical Consultant
Client : UL (Underwriters Laboratories)
Project : UL Business Transformation
Environment : Oracle Applications R12, Reports10g/Forms10g
Duration : Jan’12 – Aug’15
UL (Underwriters Laboratories) is a safety consulting and certification company. UL is a global independent safety science company offering expertise across five key strategic businesses: Product Safety, Environment, Life & Health, Knowledge Services and Verification Services since 1894. UL is currently undergoing a major transformation in the way it will do its business. This transformation will help the company to expand its business and also will enable it to manage both its non-profit organization and its for-profit organization.
Responsibilities:
Custom Programs:
• Developed Price List Conversion program:
This program would load price lists from external source to staging tables using External table concept and then would load into interface tables after validating the data. This program can be re-used whenever a price list needs to be uploaded into the system.
• Responsibility Load Automation:
This program would load responsibilities from external source to staging tables and from staging table to base tables. Also, this program would assign responsibilities to the users. This program can be re-used whenever responsibilities need to be loaded.
• Developed a script to push the Outbound File to third Party FTP Site:
This program will push the outbound file to third party FTP site. The pl/sql program extract the file to local directory. The shell script pushes the file to client’s FTP site.
Reports using XML Publisher:
• Customized Order Letter using BI Publisher (.xml) with Data template: The customer facing document, Order letter is created using Data template based on the business requirements. Different rtf templates are created to support multiple languages.
• Customized Quote Letter using BI Publisher (.xml) with Data template: The customer facing document, Quote letter is created using Data template based on the business requirements. Different rtf templates are created to support multiple languages.
• Prepared the MD070s from MD050 for different objects.
Reports using Reports Builder:
• Customized Invoice Letter using Reports Builder (.rdf) with Data template: The generation of invoice letter in AR using Bill Presentment Architecture (BPA) and as well using the Customized program. With rdf as Execution method and different rtf templates are created to support multiple languages.
Project #3:
Designation : Technical Consultant
Client : UL (Underwriters Laboratories)
Project : UL Support
Environment : Oracle Applications R12, Reports10g/Forms10g
Duration : Dec’10 – Dec’11
UNDERWRITERS LAB, INC. UL is a very well-known and a monopolist in the field of safety
certifications not only in the USA but throughout the world. The implementation was done by
IBM and Infosys handles the maintenance and support. Primary expectations are 24/7 support
and change requests. Some major enhancement projects also were undertaken by Infosys. Infosys
supports the Oracle Apps as a whole with UL. There are very few or almost no manufacturers
who are not customers of UL. It is almost impossible selling a product, especially electrical and
electronics, in the USA without the label of UL on it. The association of Infosys with UL has
been very good and Infosys has attained lots of appreciations and awards from the UL.
• Developed Control files to load data into tables.
• Worked on development and customization of reports.
• Defined Concurrent Programs, Executables, value sets.
• Executing concurrent programs from PL/SQL.
• Developed interfaces
• Development of Interface Programs to import the data from flat files to Oracle Apps base tables using SQL*Loader.
• Development and Customization of Reports based on client requirements.
• Preparing of designing and developing technical documentations for interfaces and reports.
• Development of Executables, Concurrent Programs, Parameters and Value Sets.
• Registering reports and procedures in oracle applications by using concurrent program.
• PL/SQL method of submitting concurrent programs.
• Written stored procedures and functions using PL/SQL.
• Developed new reports and customized the reports as per client requirements.
• Worked on an inbound interface program to transfer the data into Oracle base tables from the flat file.
• Worked on Outbound Bound Interface to transfer data from database to into flat files.
• Created different types of Values sets in various modules of the application.
• Developed SQL*Loader control files for loading data from data files to Staging tables.
• Writing PL/SQL Programs for implementing validation rules and loading data from staging tables to Interface Tables.
• Transferring the data from interface table to base table using Oracle standard import program.
Project#4:
Designation : Change Manager
Client : AT&T
Environment : ITIL Domain, AOTS, REMEDY, GPS
Duration : Aug’09 – Sep’10
Description:
AT&T Inc. is an American multinational telecommunications. AT&T is the largest provider both of mobile telephony and of fixed telephony in the United States, and also provides broadband subscription television services. AT&T strictly follows ITIL process for their day to day business and our project is to maintain and to give support to their existing applications.
Responsibilities:
• Handling the entire process individually ensuring prospering SLAs are met from a Change and reporting perspective.
• Preparing Technical Assurance Review (TAR) reports on a weekly basis and organizing the TAR Call with Life Cycle Management, Project Management and Service Delivery Management teams to confirm the proceeding of change controls.
• Announcing the updates on past Weeks Change controls along with the appropriate closure codes on weekly Project status call with an explanation on Unsuccessful records.
• Attending the Client Architecture and Engineering call to follow the schedules and requirements of upcoming change control requests.
• Scoring the Change controls to appropriate Change Advisory Boards depending on the Complexity, Risk and Criticality of the Change and representing them on Change Advisory Board calls with appropriate approvals in order to get them Authorized.
• Updating Change implementing resources, Project Managers, MSS, NQI, eVPN, DTAC, Avaya and MLAN Engineering teams about the change approvals and authorizations in a timely fashion to make sure everything is in place before the change activity starts.
• Preparing Weekly notification reports to acquire the count on the total number of Changes in the client environment and their success rate and Urgent rate etc.
• Distributing the finalized Agenda for Test Assurance Review additional changes and Host the TAR fallow up call during the weekend to make sure all the late walk-ins are properly scheduled.
• Documenting the Monthly statistics in the form of a Power point with the help of raw data pulled from Business Objects link with additional graphs and diagrams for a clear and easy understanding of SLAs and their misses.
• Attending Monthly Client Governance Call to update the client about success rate, Urgency, Major changes scheduled, Change related incidents and Process improvements for that particular month.
• Being an active part of interaction with all the Key players and Key teams involved for a change activity throughout the course of its request, processing, implementation and Closure to capture any modifications within the change.
• Attending Additional Calls for failed changes like backed out successful, Backed Unsuccessful, Unsuccessful changes and CRIs to avoid recurrence of such situations for similar activities in future.
Project #5:
Designation : ASR Provisioner
Client : LEVEL(3) COMMUNICATIONS
Environment : IP Provisioning-Service Activations, REMEDY
Duration : May’08 – June’09
Responsibilities:
• Accountable for getting end to end telecom services (Private line, VPN, Internet, etc.) designed for customers of Level3 communications as per defined SLAs from client for TAT, Quality.
• Service activation and decommissioning of Private line and Frame-Relay circuits.
• Configuring Edge routers for various Bandwidths i.e. DS1 to OC 192 and 10MB to 10GigE.
• Investigate offerings or technologies that may be leveraged to optimize circuit performance (e.g. capacity, latency, stability, etc.).
• Taking additional responsibilities of a Team lead and SME at offshore this includes escalation and Issue handling.
Project #6:
Designation : Junior Phone Banking Officer
Client : ADFC Pvt. Ltd. (Sister Concern of HDFC BANK)
Environment : Banking Domain
Duration : Dec’05 – Dec’07
Responsibilities:
• Resolving customer grievances by handling inbound calls.
• Customer request processing by using interactive voice response system which includes online payments.
• Processing Debit Card and Net Banking Pin Online generation requests.
• Stopping of Payment of cheques upon Customer Request.
• Transaction Processing for Customer Details upon Request.
• Promoting Banking policies by cross selling the bank products to the Customers.
• Updating the financial reports and submitting to the higher authorities.
• Responsible in reaching the targets in Cross Selling.
Awards and Recognition’s:
• Received SPOT award from Infosys Ltd for Apr’ 10, Jun’11 and Mar’13 for the consistent performance in the team.
• Received ‘Performer of the Month Dec’ 08 from Infosys Ltd.
• Received Spark award as a Speaker and Master of Ceremony on Nov’11.
Training’s and Certifications:
• Change management
• Configuration management
• Incident management
• Process management
• PL-SQL internal certification
Personal Details:
• Date of Birth: 09-Jan-1985
• Marital Status: Married
• Passport Number: N9117567
• Owned website: http://www.ebsguide.com/
• YouTube channel: Srikanth GD
GD Srikanth