|
pktyagi (ID: 269529)
|
|
|
Programming & Databases
|
|
Earnings (Year):
$0
|
|
|
|
|
Summary
|
| Member Since: |
March 14, 2001 | 0 quotes in last 30 days
| Last Signed in: February 09, 2008
|
| Location: |
Columbia, South Carolina | United States |
| Would work on site: |
Yes |
| Earnings (All Time): |
$0 |
Earnings by Skill (Year): |
| Programming & Databases |
$0 |
| Database Design |
$0 |
| Embedded Development |
$0 |
| Programming |
$0 |
| Smart Phone Applications |
$0 |
| Web Programming |
$0 |
|
Feedback |
| Rate: |
Min. Rate: $40.00 | Min. Budget: $0.00 |
Work Terms |
| Industries: |
No information provided |
|
|
Highlights
|
|
May 01 to Current
Project: IT Support & maintenance (BaaN ERP, Web tools and various other software)
Client: Howden Buffalo Inc., Camden SC, USA
Description:
As a programmer analyst and a part of centralized IT department supporting the IT stream.
Role: The following responsibilities are involved:
· Customization and new development in BaaN ERP and company's web site.
· Maintenance in BaaN system and handling of daily requests/problems that come from different locations or site users & employees.
· Design and development of reports and other programs for various departments and vendors using BaaN tools and Web based tools.
· Integration of web site, BaaN ERP and other third party software.
· Data extracting and uploading to/from BaaN system & web server.
Environment: BaaN IV C4 & C3, BaaN Tools, Dreamweaver, JSP, VB/ASP, ASP.Net, PHP, JavaScript, Oracle PL-SQL, HTML, MS Sql-Server, WINNT, Unix
Jan 03 to March 03
Project: Web Development and Maintenance.
Client: Vistatitle.com, CO, USA
Description:
As an independant contractor, did analysis, programming, testing and implementation.
Role: The following responsibilities are involved:
·Analysis, design, customization and new development on the web site.
.Database setup and table maintenance.
.Data Maintenance and bug fixing on the web server.
. Secured socket layer setup for the website in order to put website on secured layer.
Environment: Dreamweaver, PHP 4, JSP, JavaScript, MySQL, HTML, WIN 98, Linux, Apache web server
Mar 01 to May 01
Project: Customer Support using various software
Client: Herbal life, Los Angeles CA and Spectria Inc., Long Beach CA, USA
Description:
Supported the clients in troubleshooting during implementation of ERP and other software systems.
Role: The following responsibilities were involved:
· Prepared data. Did testing and maintenance.
· Developed Interface program design and development. Automated some of the critical programs.
· Developed Report and did performance tuning in standard programs.
Environment: Oracle Apps 11.0, Unix, Developer 6i, BaaN Tools.
Jan 01 to Feb 01
Project: Oracle DBA supports
Client: Honeywell Turbo, Torrance CA, USA
Description:
Supported the Oracle DBA activities. In the absence of one of the Oracle DBA I performed the general duties of Oracle DBA in the association of another Oracle DBA. Role:
The following responsibilities were involved:
· Did data Maintenance in Oracle database and Data-warehousing.
· Handled Daily Routine Jobs like Systems log checking, performance monitoring, Data Export/Import and Data Upload using SQL-Loader.
· Did Oracle Client Installations and maintained the database users, Tables & grants.
Environment: Oracle 8.05
Nov 00 to Dec 00
Project: Porting and Maintenance of PL-X .com
Client: Patent License & Exchange INC. Pasadena CA, USA
Description:
Maintained and tested web applications for PL-X.com, creating an online community for trading patents, ideas and IPR in a virtual marketplace. Technologies used include Java Servlets, JSP and JDBC. We ported the PL-X.com from Netscape Application Server 4.0 to Iplanet6 Application Server.
Role:
The following responsibilities were involved:
· Modified PL-SQL procedures and Java source code for the porting requirement.
· Did debugging and tested all the programs.
· Did maintenance using the Iplanet6 Application Builder and Application Server.
Environment: Oracle 8i, IAS6, Java, Java Servlets, JavaBeans, JSP and JDBC
Aug 00 to Oct 00
Project: Sales Management System
Client: EPSON AMERICA INC., Long Beach CA, USA
Description:
They use Oracle Web server technology and Oracle Applications. They have developed their own 'Sales Management System' using Oracle tools like Reports 3.0 and PL-SQL Cartridge procedures. This system is a great tool for the Sales department and they can access this system from anywhere using the Intranet/Internet system. Their expectation from the existing system needed some changes as per changes in business processes and they had to develop additional functionality over the existing system. We designed and developed the some new functionality and added them to the existing system. We used PL-SQL Cartridge and Reports 3.0 to get the job done. It includes the development of reports and transaction forms development in the new functionality added.
Role
The following responsibilities were involved while implementation:
· Was involved in the designing of new functionality.
· Developed various query forms, reports and batch programs using PL-SQL Cartridge procedures and Report 3.0.
· Tested all the programs and did integrated testing of the system.
Environment: Oracle 7.1, Oracle Reports 3.0, and PL-SQL Cartridge
April 99 to July 00
Project: Data Conversion & Interfaces (WTC Baan System)
Client: Western Tube & Conduit Corp., Long Beach California (USA)
Baan-Roadshow Interface:
An external software systems "Roadshow" is a strong tool for transport/delivery department. Roadshow provide efficient reports, route maps and scheduling for the delivery of customer's orders on particular date. This system expects two data file one for customer details and other for sales orders information. These Two ASCII data files get exported from BaaN to this system by using interface sessions and C programs. After processing all this information Roadshow system generate a report with scheduling of delivery. Details from this report are being uploaded into temporary user defined table, which is useful in providing details and printing Baan pick-list report during the shipping of orders.
ERP System-WMS Interface:
They use their own WMS (Warehouse movement system) and hence the need for an interface between BaaN ERP system and WMS system. In WMS system they use RF handheld devices to capture the inventory movement and maintain delivery data by using bar code scanning system. Using this interface user just used RF Handheld device to scan bar codes and other data, and through some hardware mechanism & protocol the data is transferred in form of ASCII files to BaaN ERP server. "C" language Programs provide interface screen and file handling on these RF devices. Then BaaN ERP API interface sessions upload these data files and updated inventory along with maintaining delivery data in BaaN ERP system.
Barcode Generation: For warehouse and locations movements' purpose a tag generation module has been implemented, this generates unique tag number for each item/bundle and prints Barcode for the generated tag numbers.
Beside these activities there were many report customization in Finance and Distribution modules in BaaN ERP system.
Role: The following responsibilities were involved while implementation:
· As a senior programmer I was involved in the designing of the WMS system. I redesigned the system to make it technically feasible, efficient and simple using the minimum number of resources.
· Prepared of process flow of WMS system.
· Wrote technical specifications for the system.
· Made the setup among BaaN, Bar-code scanner and Telnet server.
· Developed interface Programs in C language, BaaN API session's reports and forms for required interfaces.
· Did customization of reports and forms in standard BaaN sessions and Oracle system.
· Maintained separate file system for Bar-code scanner and pulled data for this file system from BaaN by using the BaaN Exchange schemes.
· Was Involved in User acceptance testing and Export/import of new/customized session from testing environment to production environment.
· Gave training to users about the new WMS system.
Environment: BaaN IV C4 Tools, C and SQL-Server
Apr 98 to Mar 99
Project: Kampsax Baan Project Aug 98 – March 99
Client: Kampsax Technologies, Denmark And Help Desk System, Polaris Noida
Description:
Report and Batch programs Developments for printing & maintenance of Purchase Orders, Sales Quotations, Hours accounting, Project Planning overview and Sales Invoices. Handle the Export and import of patches for the same.
Role: As a part of team I did Analysis and coding for the new reports and batch
Programs (update sessions) required for Purchase Orders, Sales Quotations, Planned PRP productions orders, purchase orders and Project planning overview. Did testing and documentation of new reports & batch programs developed. Also To support data migration from ASCII files to Baan system, Baan exchange schemes have been written.
Environment: Oracle 7.3 and Baan IV C2 Tools
Feb 96 to Mar 98
Title: GF Custodial System
Client: Citibank N.A. INDIA
Description:
The GLOBAL FINANCE Custodial system caters to the custodial services offered by CITIBANK to its clients who are large financial institutions like Local Financial Institutions (FI), Local Mutual Funds, Foreign Institutional Investors, GDR Investors, and issuers. The system addresses the functional areas like Trade Instructions and settlements, Vault Management and data entry, Registration and Objections handling, Corporate Actions and Benefits, Host system interfaces, Queries / MIS / Customer communications, Follow-up with Companies and brokers.
Role: I did System Study to understand the functional requirement and Analysis for some modules like Vault management and Objection handling. As a part of team I was involved in Designing of Objection handling module to design the functionality of Bad delivery cell. Also, as a Principal Programmer was involved in the coding of various modules of the system to develop new functionality and customization of existing functionality. As a part of interaction with the Users, I was involved in User Acceptance Testing and handled Implementation and Post Implementation monitoring & Support.
Environment: Oracle 7.1 on HP 9000, Forms 3.0, Forms 4.5,Reports 2.5, PL-SQL and Pro*C.
|
|
Skills
|
| Years of Experience: |
No information provided |
| Highest degree: |
Master's Degree |
| Software Skills: |
No information provided |
| Additional Skills: |
C, Java, JSP, MYSQL, SQL Server, ASP.Net, JavaScript,Unix, VB/ASP, PHP, Oracle PL/SQL, PRO*C, Developer/Desinger, Dreamweaver, HTML, DHTML, Visual Studio, Oracle Reports, Oracle Forms, BaaN ERP, Adobe Photoshop, MS-Excel, MS Word, WIN NT, Windows 2000, ADO, Front Page, SQL Plus, BaaN Tools |
| Tested Skills: |
 |
| The Freelancer has not taken any Skill Tests. |
|
|
Work Terms
|
|
No information provided
|
|
|
| |
|
|
|
|
|
<
|
The Freelancer has not uploaded images.
|
>
|
|
|
|
My Account URL
|
|
Contact this Freelancer Now!
The Freelancer has opted to hide his/her contact information.
|
|
Instant Messenger
|
|
The Freelancer has not entered IM information.
|
|
Global Region
|
| Country: |
|
United States |
| GMT: |
|
|
| Local Time: |
|
|
|
|
|
|
|
| Profile |
|
|
|
