Hardayal Singh
E-**, Vaishali Nagar, Jaipur,
Rajasthan
CONTACT NUMBERS - M: 91-935*******
E - Mail: ************@*****.**.**
EXPERIENCE SUMMARY
Currently working as a Techno functional Consultant at WeDig Technologies Pvt Ltd, Jaipur. Having 6.6 + years of Total IT experience .Good communication and interpersonal skills. Quick learner and flexible to work on any project. Effective communicator with strong analytical, relationship management and people management skills.
PROFESSIONAL HIGHLIGHTS
• Over 6 + Years of IT experience in Design, Development and Implementation of software projects.
• 3+ years of experience in implementation and customization of OM, INV, WIP,BOM modules of Oracle Applications ERP/E-Business Suite (EBS).
• Experience in developing and modifying reports using Oracle Reports 6i,Forms 6i, Discoverer 4i/9i/10g.
• Experience in Unit testing, Integration Testing, Production Support and Maintenance of RICE Components.
• Proficient in writing stored procedures, packages, functions & triggers using PL/SQL.
• Well versed with client server environment and tools like Developer/2000,SQL*Loader, Discoverer and TOAD.
• Capable to work on multiple tasks and also to work independently with minimum supervision with people from all levels of corporate management.
SKILLS SUMMARY
Oracle Applications 11i (OM, INV, WIP,BOM, Oracle Shipping, Logistics and expertise in India Localization.
Operating Systems WINDOWS NT/XP
Languages C, SQL, PL/SQL
RDBMS Oracle 9i/8.x,10g
Tools SQL*PLUS, SQL*Loader, Toad ,9i GUI Tools Developer 2000, Oracle Reports6i, Discoverer 4i/9i/10g , Oracle Application Framework
Web Based Expertise In:
ASP, (ASP.NET), C#, LAMP (PHP, Mysql, Apache, JS, Ajax…)
Web Server Used:
Apache, IIS
Language Uses:
C#, PHP, ASP, (ASP.NET), Visual Interdev, HTML
Scripting Language Used:
Java Script, VB script (with ADO, IIS & MTS)
Payment Getway API:
PayPal VeriSign, Pay Seal (ICICI), Authroze.Net, Money bookers, QBMS, Tpro, UPS, FedEx, DHL
Tools & Technology Used:
jQuery, Ajax, Smarty, PEAR, DB_Table, Html Quickform, SOAP, SSL, Different CMS, Google GWT, XML, Curl etc..
Project Management Method:
Agil (scrum, xp), PhpCollab
EDUCATIONAL QUALIFICATIONS:
M.Sc (IT) MANIPAL IT EDUCATION 2004.
Oracle Certified Professional (OCP) Oracle Inc. 2005
Diploma in Web Technology STG, Jaipur 2001
WORKING EXPERIENCE
Period Position Company Total Experience
1. 08/2004 to 08/2006 Web Developer Planet Web Solutions (P) Ltd. 2 Years
2. 08/2006 to 05/2009 Oracle/SQL Developer Rigel Microsys Pvt Ltd 2.10 Years
3. 06/2009 TO Till date Techno Functional WeDig Technologies (P) Ltd. 1.7 Years
Consultant
PROJECTS:
Project#1
Project : Support of Oracle applications (11i) (Secure Meters Ltd)
Role : Team Member
Project Description:
Support of Oracle OM, INV, WIP,BOM, and India Localization of all modules and technical customizations primarily reports generation, Data conversion, interfaces..
Roles and Responsibilities:
1. Support of Oracle manufacturing and order management modules like inventory level
setups, Organizations, locations, subinventories, item master, categories, physical inventory, WIP and BOM setups ,OM.
2. Responsible for Analysis, design, development, customizing, interfacing, testing and integration of OM, INV,WIP,BOM.
3. Designed and customized reports using Oracle Reports Builder 6i in SCM Modules: Sales Order Report with Contract Details/Holds Release Report/Product Transaction Listing by Product
4. Experienced in working with order management interfaces like Order Import interface and also in using other interfaces like Customer-conversion interfaces etc.
5. Involved in creation of Concurrent programs, executables, flex fields and Value sets.
Project#2
Project : Post Support of Oracle applications (11i)
Client : Derewala Jewels Pvt Ltd.
Role : Team Member
Project Description:
Post-Implementation of Oracle Manufacturing involving technical customizations primarily reports generation, Data conversion, interfaces. Modules, OM ,INV, BOM.
Roles and Responsibilities:
1 Customized Oracle applications11i (11.5.9.Designed and Developed Interface Program (Inbound) to transfer data from feeder system to various interface tables of Receivables viz. customer Interface tables etc using SQL*Loader and SQL Scripts. These SQL Scripts consist of various validations done while importing flat file to the target system.
2 Developed various Extract programs (Outbound), which extracts data to the server from OM, INV, and INV tables as per the business needs. Which is finally, mailed to various Business authorities for their references and FTP’ed to a file server by a Unix Script.
3 Registered Concurrent Programs like SQL * Loader, PL/SQL Stored Procedures and SQL*Plus for the Interfaces which I developed.
4 Involved in Enhancements of custom objects to meet the business requirements and integrate them with Oracle Applications.
5 Involved in creation of Custom Module and all the objects required for new module.
6 Involved in creation of Concurrent programs and Value sets.
7 Was involved in fixing the issues occurred during the production.
8 Working with end users to resolve the functional and technical specific issues.
Projects#3
Project : Purchasing & Sales
Customer : Rigel Microsys Pvt Ltd,
Project Type : Development
Environment : Oracle 8i, Developer 6i (Forms & Reports), PL/SQL, Windows NT
Role : Developer
Project Description:
The significance of this project is maintaining details of purchase of raw materials through bid.First we place the bid and based on the bid the suppliers put the different quotations based on the company standards. The suppliers then send the goods with company standards with in time. If the suppliers once again send the goods it their own cost. The suppliers also send the goods within the time period. Financial department people pay the amount by checks. This project includes various reports like quotation orders, purchase orders, goods returns for daily, weekly and monthly wise.
Roles and Responsibilities:
(1) Developed reports based on user specifications.
(2) Tested and implemented changes to PL/SQL code.
(3) Used SQL * PLUS to analyze data and validate results of Oracle forms and reports.
Project#4
Project Name : Invoicing System
Client : Rigel Microsys Pvt Ltd
Industry : Software
Project Type : Development
Environment : Oracle 8i, Developer 6i (Forms & Reports), PL/SQL, Windows NT
Role : Developer
Project Description:
Sales Management includes Invoicing. The selling routine is not considered complete until money due is realized from the customer will have to be sent an invoice. Once an order has been fulfilled and the goods have been dispatched to the customer, the next step is to prepare and send the invoice.
Roles and Responsibilities:
(1)Developed new reports based on user specifications.
(2) Tested and implemented changes to PL/SQL code.
(3) Used SQL * PLUS to analyze data and validate results of Oracle forms and reports.
(4) Provided and documented database structures as needed for future development
Project#5
Project Name : Office-Automation
Client : Planet Web Solutions
Industry : Web Based Application
Project Type : Development
Environment : Java, Oracle 9i, PL/SQL, Windows NT
Role : Team Member
Project Description:
Application was facilitated to keep all Personal Information As well as Official Information of employees and corporate trainees. It also calculates the Salary and whatever the Transaction Are created in the company.
Roles and Responsibilities:
(1) Created Tables, Constraints, Indexes, Synonyms, and Views.
(2) Write PL/SQL code for employee’s module.
(3) Starting up and shutting down the database.
(4) Provided and documented application & database structures as needed for future development
Project#6
Project Name : Project Management System
Client : Planet Web Solutions
Industry : Web Based Application
Project Type : Development
Environment : Asp, Sql Server 2k, Windows NT
Role : Web Developer
Project Description:
Project management System providing better services for any software company and its employees to maintain employee's daily task, their status, their working details and reports.
Roles and Responsibilities:
(1) Managing application development activities through designing, coding and implementing solutions.
(2) Designed online control panel for admin modules.
(3) Write SQL code for admin modules.
Other Web Based Projects:
http://www.louisebrooksphotography.com
http://ftv.co.in/
http://seattlefashiontv.com/
http://www.sportsvids.com
http://www.capitalfm.co.ke
http://www.myyearbook.com
http://www.silverjewelrytv.com/
http://ineedto.com.au
http://www.truckspareparts.com.au
http://www.metrowize.com
http://www.silverjewelrytv.com/
http://www.jewelsforme.com
http://www.autoselect.com
http://www.processlibrary.com
http://www.giftyourvalentine.com/
http://www.eurodivingzone.com
http://www.stealth-email.net/stealth_email/
http://www.sniperspy.com/
http://www.mobile-spy.com/
http://www.tonymulcahy.com/
http://www.detectent.com
http://www.gemsbead.com/
http://www.gemsbead.com/
http://www.gemssearch.com
PERSONAL DETAILS:
CURRENT SALARY ND (inform on process)
Expected Salary Negotiable
Time to leave 2 Week
Language Known English, Hindi (Native)
Location Preferred Anywhere
Place:Jaipur
Date: (Hardayal Singh)