Sunday January 21st 2018

Categories

Insider

Archives

Changing a Traditional information system to adapt new technologies for effective decision making

This is about an experience of an anonymous writer of this post describing his/her hands on experience in upgrading company’s information to adapt to new technologies for effective decision making and resultantly growth of the company. This post also reveals that how the hands on experience sets the foundations of understanding new technologies, needs and seamless coordination between management and technology.

When I joined the company in 1995 most of the accounting data was recorded in Manual registers ledgers / spreadsheets consequently extensive time was spent on preparing reports and making timely decisions.

In 1996, I initiated utilization of MS Access and led the logical data modeling of the Altech, and gradual implementation of RDMB format in MS Access. The data in MS Excel flat files was imported into MS Access and transformed into RDMS format. Created tables to store Master data about all accounts including customers, suppliers, employees and entity related to Altech business. Designed tables to record financial and material transactions and coordinated with Accounts departments to create general ledger and related reports in Crystal reports 8-9.

In 2000 this data base was upgraded to SQL Server 7 utilizing MS Access as front end using Access data project. All the data entry forms and reports were upgraded accordingly. From 2000 to 2002 all the data was centralized in a SQL Server database on server. This facilitates the in-depth business analyses through Crystal reports 9-10 and fast and correct data entry using MS Access Forms.

During the approximately 10 year of my first job, I learned and mastered several concepts of data management such as changing dimensions, notably how to keep track of historical data. For example every month company’s 300 production employees were rotated into different departments and issue was to produce employee historical reports. Database was extended to keep the monthly production activities of employees. New reports were developed in Crystal Reports in Crystal Reports 10 for example complete individual employee performance for any time span, departmental performance. Labor cost by production activities.

Automated the posting of inventory data to financial ledgers for example as soon as new raw material received it was stored in inventory table and updates vendor accounts and material accounts.

My first job set the foundation of database technologies, logical data modeling techniques like entity relationship diagram and translating these into physical model. Understanding of transact SQL Statements, Data input strategies and mastering Crystal reports software for preparing meaningful information, data cleansing/scrubbing and when to use to text files for data and spread sheets.