Tips for Successful Data Migration.

1. Maintain your sense of humor.
2. Expect delays and/or road blocks.
3. Run the data migration using traditional project principles.
4. Secure alignment and approval from steering committee and stakeholders as changes occur.
5. Appreciate the inter-dependencies.
6. Understand your business process, data, system and application landscape. (Devil is in the details)
7. Get the right software tools.
8. Use the right resources.
9. Plan for down time.
10. Perform at least two dry runs (Wash Rinse Repeat)
11. Develop risk mitigation plan.
12. Communicate your plan early and socialize with all impacted users.

"Disclaimer: The views and opinions expressed here are my own only and in no way represent the views, positions or opinions - expressed or implied - of my employer (present and past) "
"Please post your comments - Swati Ranganathan"

Intelligent part numbers! Why and Why Not, Can PLM / ERP systems help?

All companies that make and sell products have to make this decision very early on. Some companies might not have the maturity or business processes in place when this decision needs to be made. Changes to policies done at a later time could result in additional complications so most companies chose to remain on their current policy and process.

Intelligent part numbers are used to clearly identify the type of part, its commodity or sometimes even the location of use in the overall product. Typically companies develop a matrix mapping commodity to specific sequences of part numbers. For example 12-???? Could represent sheet metal, 13-??? could represent PCBs and so on.

Unintelligent part numbers on the other hand are based on ERP/PLM system’s ability to automatically generate the next higher number.

Companies that develop intelligent part numbers can clearly distinguish between top level products and lower level assemblies easily, in addition be able to develop logic to drive procurement, review and approval cycles based on part number sequences.

Developing part number sequences can be costly, they require manual setup, customization of applications (ERP, PLM etc.) and require due diligence on the part of engineers to follow a defined process. Depending upon the rules, the business groups must pay attention to number of possible parts for a given commodity (by projecting in to the future) and also plan on adding new commodities as the need arises. Typically this could require an additional head count to manage the process and tools. In my experience, a lot of engineers would rather focus on innovation and turn out their designs and go quickly from concept to prototype to production release and not be bogged down by having to pull a new number and update their documentation and slow things down.

Unintelligent part numbers provide engineers with the ability to conceptualize their design and generate new numbers easily with minimal data in the beginning and quickly release their designs and then provide additional data. Often engineers might not know what the right commodity / material needs to be when they are working on a concept. This lack of knowledge typically results in non value added work in recreating parts with the right material and commodity if they had made a mistake. Unintelligent part numbers do have a drawback which is that it doesn’t provide any information on the part type or any other data.

As ERP & PLM systems have matured, most have introduced a classification scheme / module with which parts can be classified. Typically classification systems capture information like whether the part is OEM or not, commodity, material, assembly or not, compliant or not (for RoHS, WEE, Reach etc.), Critical part or not, in addition the description can be broken down to clearly identify the parts. For e.g., socket head cap screw could be classified into a class of screws with a sub group of socket head or not and so on.

So if we can get so granular and capture all the information we need, we could use the classification system to drive activities like procurement based on commodity, ABC coding by commodity / part class and conditional workflows for ECO cycles based on part type and whether a full review is required or not. In addition, there are other uses like knowledge management and capturing the right questions when quality issues occur based on type of part/product.

New part creation could be streamlined by checking against classification schema and existing parts to see existing parts can be re-used. This re-use has a lot of benefits. I have seen/heard of benchmarks done by a number of companies where they have found that the cost of a part through its lifecycle (concept to obsolescence) is around $3000 to $5000.

Implementing a classification system is more complex than implementing intelligent part numbers. If you chose to do this mid stream, you will need to launch a data quality / clean up program to ensure data integrity and adherence to rules of classification and then launch this activity.

In summary, there is no easy answer for the debate on intelligent vs. unintelligent part numbers. Classification systems provide a lot of merit which outweigh the effort required clean up existing data and setup a new system.

"Disclaimer: The views and opinions expressed here are my own only and in no way represent the views, positions or opinions - expressed or implied - of my employer (present and past) "
"Please post your comments - Swati Ranganathan"

Unified Task Dashboard! Utopia?

In an earlier post, I had listed a number of emerging or new TLA's (three letter acronyms) in the enterprise application space like ERP, PLM, PDM, CRM, SCM, SRM, BPM etc...As the usage of these of applications and technologies mature within different organizations, users will soon have a set of task dashboards which outline the tasks they have been assigned within each of these applications and when it is due.

this begs the question, if we can integrate applications and have strategies like data integration / master data integration why cant we integrate the applications and create a unified task dashboard?

Most of the integrated software vendors could provide this capability but companies which have chosen best of breed applications will struggle with this unless they learn to federate and build services which can kick off / complete tasks and seamlessly integrate the applications and provide their users with one interface.

This could impact user adoption and greatly increase speed to proficiency of users and is rarely considered during software selection, planning and implementation!

"Disclaimer: The views and opinions expressed here are my own only and in no way represent the views, positions or opinions - expressed or implied - of my employer (present and past) "
"Please post your comments - Swati Ranganathan"

Primer to ERP

Enterprise resource planning (ERP) is a company-wide computer software system used to manage and coordinate all the resources, information, and functions of a business from shared data stores.

The origins of ERP lie with MRP systems which was primarily focused on production planning, inventory control and manufacturing processes. Over the last 20 years, the industry has matured and adopted a number of best practices and has significantly increased the scope and functionality offered. Today the higher end ERP systems offer an integrated package or a suite of functionality which includes Product lifecycle management, Supply chain management (e.g. Purchasing, Manufacturing and Distribution), Warehouse Management, Customer Relationship Management (CRM), Sales Order Processing, Online Sales, Financials, Human Resources, and Decision Support System.

In a number of companies, ERP systems form the backbone of the IT application infrastructure. In terms of architecture most ERP systems have 3 tiers, a presentation layer, a business logic layer and a database layer. Some of the software vendors offer a number of options for the presentation layer like windows based GUI or a web based interface. In terms of business logic or application layer, proprietary code is used in addition to some common standards. Programming might have to be done in the proprietary language…recently most of the vendors have embraced J2EE standards and allow programmers access to their APIs to enhance capabilities.


Some of the benefits of ERP systems include
(1) real time information for all functional areas of the enterprise
(2) data standardization and accuracy
(3) best practices and one location for all business process execution
(4) analysis and reporting to support strategic planning

Popular ERP Vendors
• Microsoft Dynamics
• Oracle e-Business Suite
• SAGE
• SAP Business One
• Infor Global Solutions
• NetERP from NetSuite
• Lawson Software
Overall revenue of the ERP software market is in excess of $21.4 billion worldwide. This is a huge space, with a lot of consolidation occurring. As SaaS adoption grows, hosted solutions are becoming increasing competitive and look very attractive to CIO’s under pressure to reduce costs.
This is a mature space and a number of software providers offer a wide portfolio of capabilities which encompass the whole enterprise including
(1) financials (general ledger, accounts payable, accounts receivable, cost accounting, project accounting, fixed assets…)
(2) human resources (workforce management, payroll, benefits, personnel management, training)
(3) sales management
(4) quality management
(5) Supply chain management
(6) Manufacturing management (product costing, shop floor control, production planning…)
(7) Quality management
(8) Field service and repairs

In addition, most of the ERP software vendors have invested heavily into technologies/modules to support PLM, CRM, and Portals to increase their footprint within customers by offering integrated solutions.

"Disclaimer: The views and opinions expressed here are my own only and in no way represent the views, positions or opinions - expressed or implied - of my employer (present and past) "
"Please post your comments - Swati Ranganathan"