Aarthi Arunachalam - Consulting - http://maxpages.com/itconsultants/Aarthi

Summary
Aarthi has 4 Years of experience in Design, Analysis, Development, Maintenance of Complex Database Applications. She has expert knowledge of implementing applications using Progress Database, Visual Cyber Query , Symix and MFG PRO.
She has the following skills:

System feasibility study & design and development for application software.

Support and Training for End Users.

Interaction with the Clients onsite and in other locations.

She has good communication skills and is a team player.

SKILLS:
Operating Systems: WindowsNT/95, SCO UNIX, Windows3.11, and DOS
Hardware: IBM PC, Pentium
MRP: MFG PRO 8.5E/8.6E
RDBMS/4GL: PROGRESS 8.3b/8.2c/8.2b/8.1a/8.0
Languages: Progress 4GL, C, and Visual Basic5.0
Office Automation : Microsoft Office
Other Tools: Visual Cyber Query, Visual Source Safe 5.0/4.0, ED for Windows3.8, vsFlexGrid

EXPERIENCE:

May 99 to Till date
Client: Onstream, Longmont,CO
Consultant, Object Resources Inc, KS
Onstream works on an Online Database to monitor and control the Shipping transactions using MFG/Pro software. They use external software, Visual Cyber Query, to generate user specific reports in excel format.
Visual Cyber Query, termed as VCQ, is a reporting tool, which produces reports based on the database it is connected to. It supports any relational and non-relational database. It helps ease any complex reports utilizing its advanced features on dynamic file creation, multiple file relations and Two Pass reporting technique. It links to the online system and creates equivalent reports, which can later be modified to the user’s convenience.
As the MFG/Pro system does not support the reports in xl format where the user has access to modify to the requirement, few of the reports are generated in VCQ to ease the user modify the details as needed. The VCQ tool is connected to the Production database of MFG/Pro thereby producing same result when running report in VCQ and in MFG/Pro.

Role on the Project:
Worked on VCQ for reports that are generated in MFG/Pro with user specific requirements.
Reports developed are:

Consolidated Shipment Trials in a date range.

Booking Transactions.

Shipment Transactions on Weekly basis, Period basis and on Daily

basis of transaction

Invoice revenue.

Balance sheet on monthly basis in a date range.

Graph on Customer Type & total shipped qty.

Developed flat files in the VCQ Data Dictionary that is used for

temporary storage of data for reports on Shipment .

Transactions by Period and Balance Sheet by month.

Verified the results with those in MFG/Pro and studied the program

coding and structure in Progress8.3b for MFG/Pro reports.
Team Size: 4

Environment: Visual CyberQuery 2.10, MFG/Pro 8.5/8.6E, Progress 8.3b, Pentium II Processor, MS Windows98/NT.

Feb 98 to March 99
Client: PS Industry Group, UK
KAPES Maintenance – Customization
Responsibility : Software Developer
Kapes (Knowledge Aided Planning and Estimation Systems) is an online automotive manufacturing process planning software. This is for MRP package developed as an interface to any ERP system like SYMIX or MFG PRO. This is used in shop and production floor. The large industry group like Marconi, FORD, Bajaj, GEC, Jaguar Cars, Rolls Royce etc. uses this software, The main modules used as utility tool are Production planning, Estimating and Costing. The system aims at solving growing problem faced by manufacturers and to control their supply chain of costs.
Kapes maintains a database for parts from raw material till packaging. It also maintains data about various costing parameters and related entities for Production planning and estimating.

Using these data, the system can produce and maintain accurate process plans and costing estimates with flexible procedures to cater for various Industries. Recently, this product has won the award, 'IT Product of the year - 1997' in Manufacturing Industry Achievement Award - one of the highest honors in the Engineering Industry, United Kingdom.

With the existing KAPES Version9, customer specific requirements and additional modules are developed and implemented. End users of Marconi and FORD groups using KAPES Version9 had functional requirements to modularize few existing modules and ease the application usage. The main customization is done in Routing and costing modules.
Role:
Onsite development and system requirement study were made in PS Industry, UK for a period of one-month. Interaction for system study and knowledge transfer for the FORD changes was made with the Clients in India. The timeline and the methodology used was discussed and implemented.

Invalid Costing reports at the node level of the Contract Issued Bill of Material data using Progress 4GL.

Indented Bill of Material structured reports for the Costing Parts using vsFlexGrid tool.

Ensure on the validity of the parts used in BOM structure while Costing using additional data definitions for the Parts details.

Management for the Operation Concurrency groups of the operations involved in Costing, Import and Upgrade modules

Provided flexible navigation in Routing Selection module where the routings/parts are selected in 10 levels categorized on their usage and in Finder module to trace parent-child traversal.

Developed new modules like Units Of Measure Maintenance and its impact on Costing related modules in Kapes

Handled training programs and was responsible for leading a team of 2 in Costing related modules
Team Size: 4

Environment: Progress 8.2c, Windows NT/95.

Oct 97 to Jan 98
Client: PS Industry Group, UK
KAPES Porting
For the end users using Oracle database, the existing KAPES Version9 functionality and data manipulation are modified to support Oracle database. The changes are made in various modules in KAPES. Optimization is made in indexing for Data retrieval.
Role: Onsite discussion and development with clients on various modules in KAPES was made in PS Industry, UK for a period of 3 months. Handled functional changes in Costing and Routing modules to support Oracle dataserver.
Team Size: 4

Environment: Progress 8.2b, Oracle 7.x, Windows 95.

Feb 97 to Sep 97
Client: PS Industry Group, UK
KAPES Maintenance
Responsibility: Software Developer
The existing KAPES product is modularized to the customer specific requirements. The main customization is done in Routing and Costing modules. The requirements aim at enhancing the current functionality for better User Interface and provide user level access to the existing modules.
Role: Onsite Client interaction was done for a period of 2 months in Planning Systems, UK for system requirement and demonstration.

Enhanced Costing process of BOM parts list by including additional costing parameters and in Contract Issue modules

Designed and developed OPLM module for CASE Corp. and Security module for user group access to various modules in KAPES

Redefined DB design for related modules on BOM & Costing and routings to support new modules into Kapes

Handled Configuration control for Kapes and was responsible for leading a team of 4 handling Costing & Estimation related modules
Team Size: 4
Environment: Progress 8.2b, Windows 95.

Jan 96 to Jan 97
PS Industry Group, UK
KAPES Version 9(Knowledge Aided Planning and Estimating System)
This project is a reengineering version of Kapes Version8 developed in FORTRAN with Unix environment. For better User Interface and advancements, the product is improved to Graphical Interface design.
Role:

System study with the previous version of KAPES is made in SCO UNIX OS environment for analysis and design development of various modules.

Reports generation in costing module using Progress 4GL

Developed various modules like Finder support for different entities, BOM Explosion and Costing, Contract issue on Costed BOM structure, Routing Selection, Import & Export of base data and routings, maintenance in Production planning.

Developed DB design for Finder module
Team Size: 8
Environment: Progress 8.1, SCO UNIX, and Windows 95/3.11

Aug 95 to Dec 95
Assistant System Analyst, Microcon International LTD
Automated System Administration
The objective is to maintain and monitor the in-house transactions in a Software Industry like the details of Software, Projects, Stocks, Accessories etc.,
Role: Complete design, implementation and coding of the project
Team Size: 1
Environment: Visual Basic5.0, MS Access97, and Windows 95

Education:
MS Software Systems, Birla Institute of Technology & Science,
Bachelors in Electronics

IT Resources
9401 W. Indian Creek Pkwy., Suite 1100
Overland Park	Kansas	66210
USA
(913) 438-7140 ext. 112
Fax (913) 438-7130
patty.w@orimail.com

Sign Guestbook

View Guestbook

Visitors: 01448

Page Updated Wed Jan 26, 2000 12:42pm EST