Yogendra Kumar
Oracle Apps Technical Consultant
Mobile: +91-800*******
E-mail: u3nway@r.postjobfree.com u3nway@r.postjobfree.com
Career Objective:
Seeking a challenging and innovative position in Information technology to pursue a bright career while being flexible and resourceful. I can use my Intelligence in such a way that I can be helpful to achieve the goal of organization. I am seeking a challenging technical position in a pleasant working environment, which will permit me to continue practicing and expanding my skill set and knowledge base to be a part of an esteemed IT organization and to work with full dedication, sincerity and honesty in order to add on the profitability of the organization.
Key Skills:
Worked on XML Publisher and Oracle Apps Reports., D2K Oracle Forms & Reports
Worked with Modules like AOL, GL, AP, PO, AR, iExpense, Oracle Alerts module.
Extensively worked on development and customizations of reports and Interfaces.
Experience in Post Production Support
Development of Stored Procedures and Functions.
Worked on AIM Methodology Docs (MD70).
Developed Out bound interfaces and Inbound Interface
Registering Reports, Forms, Tables, Procedures, Sql*Loader in Oracle 11i applications
Exposure to Oracle Workflow Builder.
Positive work attitude and self motivated to work independently and as well as in team.
Summary of Experience & Exposure
Presently working with AWC Software Pvt Ltd Noida since 18-Feb-2008 To Till Date as a Associate Technical Consultant extensive experience in design and development of Information Systems for various applications.(Forms & Reports), Oracle 8i/9i, 11i PL/SQL.
Software Skills
Oracle Database : Oracle 9i & 8i
Technical Tools/ Technologies
• Oracle Reports Developer 6i
• SQL*Plus
• PL/SQL
• SQL*Loader
• XML reports.
• Oracle Alerts
• UTL_FILE
• Oracle Forms Developer 6i
Project #0
Client : Panasonic, Noida
Role : Technical Consultant
Period : 8 Dec 2011 to Till Date
Modules : PO, po_summary_report,XML Report, AP, GL, PA
Environment : Oracle Applications R 12, Sql * Loader, Developer 6i
Description: : Running Project
Custom Reports:
Developed PO, Receipt & Invoice Report
Developed PO Cancellation Report by Vendor Wise
Project #1
Client : Omaxe, New Delhi
Role : Technical Consultant
Period : Oct 2010 to 5 Dec
Modules : PO, AP, GL, PA
Environment : Oracle Applications 11.5.10, Sql * Loader, Developer 6i
Description:
Responsibilities:
Development of Reports and Customized Reports.
Prepared the MD70’s from MD050 for different objects.
Writing PL/SQL Programs for implementing validation rules and loading data from staging
Tables to Interface Tables.
Defining value sets, Executables and concurrent programs of the application.
Executing concurrent programs from PL/SQL.
Custom Reports:
Developed PO, Receipt & Invoice Report
Developed PO Cancellation Report by Vendor Wise
Developed Report for Purchase orders for matching type
Developed Supplier Payment Report by using XML Publisher
Customization of Reports:
Printed Requisition Report with Account Description.
Purchase Report Detailed Itemwise to know Purchases for a given period to take Management Decision.
Production Issues:
Enable Document sequences for AP module.
Resolve Accounting issues in PA module.
Resolve standard interface issues.
Trouble shooting and bug fixing.
Bank Setup and Opening check Series.
Payment term Setups
Defined Lookups in AP
Defined Document Sequences for AP Invoices.
Interfaces:
Developed a Outbound Interface with bank to show the Supplier details Including Payment details with check for range of dates.
Worked on Standard Purchase Order Interface to upload puchase orders from Legacy system to oracle PO base tables.
Worked on Auto Invoice Interface.
Conversion:
Worked on Vendor Conversion.
Project #2
Project Ñame : Support Project
Client : Motherson Sumi System Ltd.
Noida, Sector - 6, C1
Module : AP, AR, GL, iExpense
Period : Jan 2010 to Sep 10.
Roles & Responsibilities:
Post-Production Support Activities:
• Unpaid Expense Report dumps as per business requirements.
• Defined CVR rule/Security rule as per business requirements.
• Developed BLANKET purchase release reports to displays the information about the release details. Standard Purchase Order
• Wrote Pl/SQL code for extraction of data as per business requirements.
• Defined Lookup Type for suppliers.
• Invoice Validation Issues
• Run Sql scripts provided by Oracle to send invoice/Payment details to Oracle to get data fix.
• Resolved “Zero Payment Issues” for a Particular Supplier
• Resolved Reconciliation Issues.
• Invoice Cancellation/Void Payment as per BAU.
• Preparing Technical Design documents.
• PL/SQL method of submitting Concurrent Programs
• Creation Of value sets in various Modules applications
• Expertise in Inbound Interfaces using SQL*Loader and Outbound Interface using UTL_FILE
• FSG REPORTS
Interfaces:
• GL-Interface
• Loaded journal data from feeder system into 11i base table with the help of GL_INTERFACE.
Project #3
Project Name : Support for Oracle Apps 11i
Client : Religare, Noida
Duration : Feb 2009 to Dec 2009
Modules : AOL, AP, AR, GL, Oracle Alerts
Roles & Responsibilities:
Post-Production Support Activities:
• Involved in iExpense Setups.
• Delete The Concurrent Programs
• iExpense Workflow error resolution.
• Extraction of dump in Flat file for Active Policy in iExpense as per business requirement.
• Extensively used AOL for user creation and creating new responsibilities
• Defined CVR rule/Security rule as per business requirements.
• Using the Out bound Interface.
• Wrote Pl/SQL code for extraction of data as per business requirements.
• Invoice Validation Issues
• Worked on PO Approval Hierarchy
• Create the Custom table and register in Oracle apps
• Extensively used AOL for user creation and creating new responsibilities
• Enabled Descriptive Flex field as per requirement
• Resolved “Zero Payment Issues” for a Particular Supplier
• Invoice Cancellation/Void Payment as per BAU.
• Preparing Technical Design documents.
• Preparing Unit Test Document and performing the unit test plans.
• Created custom Alerts using Oracle Alert manager
• Defined Expense Report Templates.
• Define Payment Programs, Payment Formats, And Internal Banks & Bank Accounts.
• Defined Transaction Sources and Types.
• Extensively used to write custom packages.
• PL/SQL method of submitting Concurrent Programs
• Involved in registration of concurrent programs, executables, request groups, values sets, request sets in AOL.Involved in Preparation of Unit test plan document and testing.
Report Development:
• Cash Voucher
• Bank Voucher
• Journal Voucher
Interfaces:
• Developed an interface to upload sales invoice in AR using Auto Invoice and wrote package to upload data into interface tables like RA_INTERFACE_LINES.
Project #4
Client : ISL Mukerian
Module s : AOL, AP, AR, GL, Oracle Alerts
Name : Production Support of Oracle Apps 11i
Period : Feb 2008 to Jan 2009
Roles & Responsibility:
Production Support issues (Financial Module)
• Issues resolution for GL_INTERFACE during sub ledger import.
• Issues resolved for AR Interface table
• Expense report template Setups.
• Performed Accounts Payables Set Ups, Setting up PO matching option, invoice tolerances, distribution options, terms, holds etc. Setting up Payment methods, Expense Report Templates etc.
• Involved in setting up of Auto Payments, Suppliers, system options.
• Defined Transaction Types, Transaction Sources, Receipt Class, Receipt Method, Receipt Sources and Receivable Activities.
• Define Invoice Attributes – Payment Terms, Distribution Set, Pay Groups
• Developed Out Bound Interface
• Handling activities like GL Transfer, Posting in GL, Period closing, Etc. for month end closing of books.
• Forms registrations and Report registrations
Interfaces:
• Designed an interface to transfer all the Journal data from legacy into Oracle General Ledger tables using GL_INTERFACE and Journal Import Program.
Educational Qualification:
10th from U.P. Board Allahabad With 63%.
12th From U P. Board, Allahabad With 55%.
BCA from Vidhyarathi Institute of Professional & Studies(VIPS), Gwalior, Affiliated by MCRPV Bhopal (M.P.) with 62 %
MCA Running from IBMR Pune Affiliated by university of Pune.
Strength:
• Positive Thinking attitude with focus on achieving goals.
• Passion to learn new things and ability to grasp the subject.
• Always ready to work in team and adaptable to all situations
Technical Qualification:
Tally Certificate of training From M.S.M.E Development Institute, Indore under Managerial Development
(MDP Programme) Government of India by Ministry of Micro, Small & Medium Enterprises in Gwalior [M.P] Gwalior
Technical Skills:
Oracle10g: function, Join, DCL & TCL Command, Views ,Pseudo Columns, Trigger, OLAP, Materialized view,11g(SQL*PLUS & PL/SQL) Server ,SQL Server 2005 , SQL Server 2008(view, Clauses, Function, Operators Trigger)
Operating Systems: MS-DOS, UNIX, Linux , WINDOWS 95/98/2000/NT/XP.
Languages : C, C++, JAVA , PL/SQL, C#,
Project:
3 Months worked as a Trainee in Blues Tele Technologies Pvt. Ltd, Gwalior
Personal Details:
Name : Yogendra Kumar
Father’s Name : Shri B R Verma
Marital Status : Single
Nationality : Indian
Linguistic Proficiency : English, Hindi
Passport Number : H6357843 (valid Passport till 2019).
I Here by declare that the above mentioned details complete and correct to my knowledge.
Place : Gurgaon
Date : 15-Dec- 2011 (Yogendra Kumar)