Pankaj Luthra Punj Lloyd Limited Punj Lloyd House 17-18, Nehru Place Mobile: 9811313113 pankajluthra@punjlloyd.com pankajluthra25@rediffmail.com Career Objective Only two words to define myself is "I CAN" To learn, to contribute, to grow and to serve, I strongly believe that "make your will good, to make your organization's goodwill". I am an individual with a strong desire to contribute my best to a given work situation and To build a successful career as an ERP Techno-functional Consultant and help improvising ERP solutions with dedicated efforts. Company Profile: Punj Lloyd Limited is a leading Engineering, Procurement & Construction Company. The company is a well-known name in the field of Pipelines, Tankages & Composite Construction, Hydro cracker units, Process Plants, Cryogenic Tanks, Telecom, and Insulation. Company has established its presence globally in the short span of 12 years and presently engaged in projects in Indonesia, Abu-Dhabi, Qatar, Turkey, Kazakhistan. British Safety Council has awarded "Five Star" certificate to the company for its diligent work in the Field Of Safety. Punj Lloyd is having a 500 user group working in Oracle Apps About Myself & I am a commerce graduate and after that I did my MBA with dual specialization in My job Information technology and Marketing during my MBA I got selected through campus interview for Punj Lloyd Limited and since June 2001 I am working with Oracle Applications previously we were using 10.7 character mode version and latest we are with version 11.5.5.As we are using number of oracle modules, this includes Oracle Purchasing, Oracle Inventory, Oracle Payables, Oracle General Ledger, Oracle Assets, Oracle Projects, Oracle Receivables, Oracle Alerts, Oracle Cash Management. As the flow from making of requisition to the final posting in General Ledger module is very clear and as a Technical head of my company which includes 4 technical persons, I am responsible for developing reports for all said modules, defining reports in the system, customizations, handling multiple errors functionally and technically for Purchasing and Inventory module, training to the users for Purchasing and Inventory modules, new in-house developments from time to time, Defining alerts in the system to capture every part of the system functionally and technically, with in this period of time I work with (Forms 4.5/6.0/6i/9i, Reports 2.5/6.0/6i/9i, PL/SQL, SQL*PLUS, Oracle 7.x/8.x/9.x back end, TOAD, Application server 9i, Developer suite 9i, Oracle Discoverer, except this I always take initiative for multiple research and developments in my area to satisfy my users so that they can do their work efficiently and effectively and always keep updating myself to gain more and more knowledge of my area of work Career Highlights From June-2001 to till date: 3 years of experience in both front end (includes data-flow) and back end includes ( Customizing reports, ( Alerts, ( Development of new reports as required, ( Defining the reports in apps, (for Oracle Purchasing, Oracle Inventory, Oracle Receivables, Oracle Payables, Oracle Fixed Assets, Oracle General Ledger modules of Oracle Applications) ( Developments of reports in Oracle Discoverer, ( Writing procedures, ( Triggers, ( In house developments of existing and new software as and when required ( Training to the users in purchasing and Inventory module of apps ( Forms 4.5/6.0/6i, ( Reports 2.5/6.0/6i/9i, ( PL/SQL, ( SQL*PLUS, ( Oracle 7.x/8.x/9.x back end, ( TOAD. ( I am also responsible for New developments of all in house developed packages like Payroll system, ( Purchase Order Tracking System (POTS) which interfaced to our ERP - Oracle applications was implemented in the company by M/s Arthur & Anderson in 1997. From October-2002 to April-2003: As a Core Team Member Technical, I was Involved in Migration from 10.7 to 11i for Punj Lloyd Ltd., India, / Re-implementation for Spectra Punj Lloyd Ltd., India, previously that was in release 11 and fresh implementation for PT. Punj Lloyd, Indonesia, Punj Lloyd Indonesia, Punj Lloyd Abu-Dhabi of Oracle-Applications in collaboration with IBM, India, During which my main job is to ( Migrate all the reports from 10.7 (reports 2.5) to new version 11I (reports 6i) with changes required according to multi-org setup and defining them all in the new system, ( Migration of alerts and change it all accordingly, ( Development of new reports and alerts for all the entities, ( Data uploading through procedures and macros in different modules, ( Assign the reports to different users, ( Customization of Oracle assets form, ( Training to the users at our different locations in Oracle Purchasing Module and Oracle Inventory Module Responsibilities ( Responsible for Doing Study of the Existing Reports and Forms. Writing the document During Migration regarding the customize part in it by matching it with the standard Reports and Forms. Discussing with the user regarding their problem; facing with existing system, Writing the Specification of their requirement, getting the approval of the Specification from the users. After getting the approval of the specification from the user responsible for Coding, Testing and Training the user. ( Migration of existing reports 2.5 defined in release 10.7 to reports 6i (release 11.5.5) with changing them according to multi-org compliance and customized the new reports of different modules for all operating units ( Migration of alerts and change it accordingly and write number of new alerts (event & periodic) for all the operating units and for all the modules ( Having a knowledge of forms customization and can customize the forms as per the requirement ( Implemented Oracle Discoverer 3.1 and Learn to work with that after that Developed new reports in discoverer for the higher management ( Data uploading through macros and procedures ( Got an opportunity to get the knowledge of Maximo integration with Inventory module of Apps and write few reports sitting with the Maximo persons after that prepare a report showing a flow of data on every stage starting from Maximo-B2B-Apps-B2B-Maximo ( Compiling of old in house developments in developer reports 2.5 and forms 4.5 to the newer one of developer forms and reports 6i, with a changes required like alteration of table structures, adding new forms and reports to it ( Visit Different Locations/Projects of Punj Lloyd to give training to the site users in 11i(Oracle Purchasing & Oracle Inventory Modules) ( Wrote database triggers and procedures to maintain the process as per the flow of the company Routine ( Customizing and developing reports for all the modules we are using which includes Responsibilities ( Oracle Purchasing ( Oracle Inventory ( Oracle Receivables ( Oracle Payables ( Oracle Fixed Assets ( Oracle General Ledger ( Oracle Projects ( As a module owner of Inventory I am also responsible for all routine jobs of Inventory module includes defining of items, Periods and Organizations, receiving of materials, transfer of material as required on sites, making reports and also keep track of the back end process and gives training to the users as and when required ( Customizing and developing Alerts for all the above Oracle Modules ( Developing & managing Reports on Discoverer. ( System Administration responsibilities which includes ( Defining users ( Defining responsibilities ( Assigning responsibilities ( Defining reports ( Defining alerts in Oracle-apps ( Administration of PO Tracking System, it is a software integrated with Oracle-apps used to track the PO's and Requisitions ( User creation ( Grant proper rights to users ( Organizing User Training ( Updation ( Report Customization ( Developing forms, reports using Oracle Forms 6i/9i, Reports 6i/9i Technical Exposure Training provided at corporate level through Punj Lloyd Ltd in the following modules((Release 10.7 GUI): ( Oracle Inventory ( Oracle Purchasing ( Oracle Alerts ( System Administration Activities Training provided at corporate level through Punj Lloyd Ltd in the following modules((Release 11i) ( Oracle Inventory ( Oracle Purchasing ( Oracle Discoverer 3.1 ( Oracle Alerts ( System Administration Activities Qualification ( Post Graduate Diploma in Business Management (1999-2001) from Lal Bahadur Shastri Institute of Management and Technology, (LBSIMT) Bareilly ( B.Com from Bareilly College, M.J.P Rohilkhand University, Bareilly ( Six-month course in computers from Cistems School of Computing, Bareilly Dual Specialization Information Technology and Marketing Computer Operating System : MS-DOS, Window3.1/95/98/NT Proficiency E-Commerce : HTML,Frontpage-98, Dreamweaver ERP Modules : Oracle Purchasing, Oracle Inventory, Oracle Payables, Oracle Discoverer 3.1, Oracle Fixed Assets, Oracle General Ledger, Oracle Projects, Oracle Alerts, System Administration Activities, Lotus notes Languages : PL/SQL Developer suites : Oracle Forms 4.5, 6.0, 6i, 9i Oracle Reports 2.5, 6.0, 6i, 9I Oracle Discoverer3.1 Extra ( Won first prize for the best article of Institute's magazine "Insight" Curricular Activities ( Stood second in essay competition organized by L.I.C., Bareilly ( Won first prize in presentation of Sales & Distribution Management (Topic: How to promote the sale of pencils of a hypothetical company) ( Second prize winner in drawing competition conducted by Rotary Club, Bareilly ( Active participant in modelling shows, stage dramas in the Institute & else where in Bareilly ( Active member of the "ALLIANCE", students' body of LBSIMT Social Concerns ( Organized a Pulse Polio campaign in rural area of Bareilly ( Active participant in organizing Blood Donation campaign in collaboration with I.M.A. in the Institute campus Personal Data Date Of Birth : 11th May 1976. Father's Name : Mr.S.K Luthra (working in Life Insurance Corporation, Bareilly) Interests : Drawing, Internet-surfing, exploring Oracle Applications Strengths : I never get tired with extra burden of work. I am hardworking and ready to accept any challenge as and when given to me in my life Weakness : I am impatient when I see wrong things happening in front of me Address for Correspondence Pankaj Luthra (Sr. Officer-MIS) Punj Lloyd Limited Punj Lloyd House 17-18, Nehru Place New Delhi- 1100 19 6200555 Pankaj Luthra