| Management Systems Consulting, Inc. |
Excellence in Computing
Honesty ~ Integrity ~ Loyalty ~ Respect |
|
Glossary of Computer Terms (5C) ****************************
**************************** *********************** Visit IQ-Home for your housing design needs:
*********************** Updated:03/08/2008 Copyright © 1996-2008 Management Systems Consulting, Inc. |
ERP Business Consultant/Data Architect/Project ManagerOffice: 800.856.3193 ~ Fax: 888.243.1843 ~ Cell: 407.963.0368Also See Personal Web at SkipStein.com Mr. Stein is President of Management Systems Consulting, Inc. based in Mr. Stein’s skills include the ability to take charge of projects, generate cohesive team participation and complete assignments in a timely manner. Since each task of a successful project depends on all previous and subsequent tasks, Mr. Stein has developed project management and team building skills while utilizing precedence and critical path method management techniques. Mr. Stein is also a capable programmer utilizing language technology of HTML/XML, Java, C++, Assembler, COBOL, PL/I and RPG. His experience with various computational frameworks, including Client Server, Distributed Data Warehousing, and Centralized Mainframe, provide a basis for the constant learning processes in which he conducts beta testing for major hardware & software companies, including Microsoft and IBM. Most recently, Mr. Stein has worked with Electronic Business Flow Management (EBFM) systems utilizing EDI and Web Commerce tools to implement business-to-business communications solutions in conjunction with International ERP systems deployments. During his career, Mr. Stein has enjoyed an in depth involvement with a varied set of technologies and utilized them to provide productive and cost effective business solutions. As a Project Manager, Mr. Stein has worked around the globe reaching from the Prudhoe Bay Alaska to CISA - Certified Information Systems AuditorSpoken Languages: Fluent: English ( Functional Project SummaryFinancial ~ HIPAA & Healthcare ~ Manufacturing/Distribution ~ Oil & Gas ~ Pharmaceutical ~ Retail ~ Telecommunications ~ Professional CredentialsManaged the Computer Resource Management Review (CRMR) for a major financial lending organization. Our CRMR services are geared toward clients with a need to determine the value of an IT Organization, business process or project. We review the operational effectiveness of the Computer Resources at the organization. The major components of the Information Technology (IT) organization and how they relate to the overall organization and management structure of the company are analyzed. With a view towards Sarbanes-Oxley (SOX) impact as well as cost effective return on investment (ROI), the total picture of how the IT organization contributes to the profitability and cost effective use of business resources. Effectiveness of IT staff and policies and procedures as well as IT Internal Controls and methodologies in use are evaluated. Implemented the Electronic Transaction Flow Management (ETFM) system to identify and address all electronic transaction processing for the company. Developed project plans for the EDI Gentran to webMethods conversion with integration to web services and order processing. Consolidate all financial order-to-cash and order-to-pay transaction activities plan and schedule. Conducted a Pre-SOX (Sarbanes-Oxley) audit review of corporate systems, functions and internal controls. Conducted overview and analytical review of all financial and operational systems as they pertain to revenue and balance sheet accounting and financial statement preparation. Focus on internal controls and implications of the approval/certification process as defined in Sarbanes-Oxley legislation. Worked with remediation teams to augment existing documentation, procedures and internal controls. Develop a methodology to move the organization toward COBIT/CMM system control levels. Managed a Sarbanes-Oxley project to develop internal controls systems for automated systems. Wrote business and operational procedures for change control and systems development. Coordinated pre-audit activities with independent auditors with Sarbanes-Oxley focus. Designed and planned the financial accounting control interfaces for JD Edwards accounts receivable automated cash application interfaces to process trade account payments via EDI 820 Remittance/Payment Advice transactions. Planned and set up the Accounts Payable automated account reconciliation process, procedures and financial institution data interfaces. Deployed outbound electronic payment processing for vendor payments and employee disbursements via EDI 820 Remittance/Payment Advice to financial institutions. Developed internal Accounts Receivable (A/R) processes to enable the receipt of ANSI X.12 EDI remittance advice transactions (RA820) into the JD Edwards OneWorld Accounts Receivable system for a leading manufacturer of windows, doors and molding products. The project included building interfaces to J D Edwards (JDE) OneWorld Enterprise Resource Planning (ERP) A/R system for trade customer payments and remittance data, implementing automated cash application processes for JDE OneWorld A/R and training internal resources for executing the necessary manual A/R cash application activities. The EDI interface was implemented utilizing IPNet Solutions data communications tools and Mercator transaction set mapping. Developed internal Accounts Receivable processes for an international household appliance manufacturer and distributor encompassing activities currently provided by a third party service. Implemented Harbinger EDI interfaces to JD Edwards A/R for trade customer payments and remittance data; established trade customer lockboxes, built an automated cash application process for JD Edwards A/R, and staffed/trained internal resources for executing the necessary manual A/R cash application activities. Project included banking lock box interfaces be developed with electronic funds transfer processing and automated remittance advice processing utilizing EDI X.12 standard transaction sets with adjustment activity reported on EDI X.12 transactions. Developed a project implementation plan to deploy the PeopleSoft Human Resources and Payroll system for a national retail chain over a hybrid Sun Solaris, NT and AS/400 network. This included working with vendor representatives and client personnel to maintain a project schedule. Conversion from previous Lawson system processed by an outside service organization was included in the project implementation Completed the implementation of PeopleSoft 6.0 Human Resource and Payroll system for a large resort management company. A complete and detailed project management plan and schedule was coordinated with the PeopleSoft implementation team. The system was implemented utilizing the Oracle (HP/UX) based version over a company wide NT 4.0 Intranet communications infrastructure. The project entailed coordination of user training, conversion from outside payroll services and customized reporting. PeopleTools and Cognos Report mapping tools were also fully deployed. Managed a major migration from midrange systems to an Oracle client server platform for a major international vacation ownership resort developer. The project encompassed the development of the business rules, migration strategy, architecture selection, contract negotiation, and implementation plan. Both Financial and Operational systems were included. An EDI interface was designed and developed to provide trading partner exchange data for the purpose of vacation week trades by resort owners. Managed a twelve-month project, which consisted of the complete design and construction of a data center, including the selection and installation of computer equipment and support facilities. In addition, application software was selected, enhanced and implemented for the health and welfare processing systems of the Michigan Conference of Teamsters’ Welfare Trust Fund. A PC based system to access a state wide multi-drop communications network was developed and supported by the DOS/VSE IBM host. The system was designed to enter data and update status of health and welfare insurance claims. Managed the data systems design and construction to establish a private label credit card company for a multi-billion-retail company. The project included the re-deployment of credit processing and the establishment of a complete credit card processing center to handle multiple private label credit cards. Transactional interfaces were developed to process credit card sales transactions from retail operations for the private label credit cards as well as other bank credit cards. Developed and deployed a DB2 based Year 2000 conversion methodology and support system to address COBOL and PL/I systems. The system fully scans and locates cascading data variables (CDV's) by constructing a relational data base model utilizing the DB2 Universal Data-Base. The system then processed the CDV's and encapsulates the necessary code with a windowing code set to enable the program to properly function when utilizing dates beyond December 31, 1999. Developed a disaster recovery plan for a large International Bank’s data processing operations. The plan encompassed several levels of possible disruptions of service. While still in the formative stage, a major electrical fire made the data center inaccessible to the Bank’s personnel. The plan was put into effect and alternate processing agreements were invoked, personnel assigned, and backup systems were deployed. Covering an outage period of three days, the Bank missed only two Federal Reserve deposits and was able to produce customer account trial balances to conduct daily business. Refined from ‘real life’ experience, the Bank was able to fully develop, test and deploy a comprehensive backup and disaster recovery plan. In conjunction with independent audit requirements and practices, a comprehensive security and backup system was implemented and tested for a major Maintained and developed numerous deposit and banking service support systems while working at a major International Bank including:
HIPAA & HealthCarePerformed analytical reviews and developed functional and technical design specifications to coordinated hospital, clinical, radiology and laboratory systems data flows to enhance a new Deductible Health Maintenance Organization (DHMO) billing processes. Coordinated between each of the subsystem teams to accelerate their data capture and process flows into an enhanced DHMO member billing process. Developed testing criteria and monitored testing and implementation. Worked with accounts receivable and adjudication functional teams to process data in a timely manner in order to produce billable results. Project anticipated return is a $1.4 million revenue increase in first six months. Managed the HIPAA Compliance EDI data base re-engineering project for a State Medicaid Management Information System (MMIS) to comply with all federal HIPAA rules that effect how health care claims and data must be processed to be HIPAA compliant. Constructed and issued a State Request for Proposal (RFP) for an EDI Translator as well as the Proposal Evaluation Documents. The data base re-engineering consisted of a structured ‘repository’ to map EDI data into and out from interfaced with the State’s existing MMIS systems. Developed HIPAA compliant EDI processes, systems interfaces, procedures and controls for a regional health care provider with membership exceeding 170,000 and provider network of over 3,000 primary care physicians and 5,000 specialty physicians and 100 hospitals. The Erisco/Facets system is the primary support systems for benefit enrollment and records. The Gentran NT Server was utilized in conjunction with Erisco/Facets support systems to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834, 835, 837 270/271 transactions. Trained support staff and developed procedures and documentation for ongoing operations and control systems. Managed a twelve-month project, which consisted of the complete design and construction of a data center, including the selection and installation of computer equipment and support facilities. In addition, Erisco/ClaimFacts application software was selected, enhanced and implemented for the health and welfare processing systems of the Michigan Conference of Teamsters’ Welfare Trust Fund. A PC based system to access a state wide multi-drop communications network was developed and supported by an IBM host. The system was designed to enter data and update status of health and welfare insurance claims. Manufacturing/DistributionCoordinate and manage the conversion of EDI resources and Order to Cash processing from a JD Edwards World to Oracle Enterprise One ERP system. Worked with deployment team to configure all E1 options and configurations for manufacturing, distribution and finance. Developed comprehensive data analysis and mapping for all transaction processing. Configured shipping and labeling systems in conjunction with Data Systems International (DSI) programs. Coordinated EDI and transactional interface in conjunction with an Enterprise One (JD Edwards) upgrade to release level 8.10 for a West Coast importer. Developed table/file extensions for auxiliary file processing to facilitate inbound and outbound transaction processing. Made recommendations for EDI functional capability upgrades. Implemented the Electronic Transaction Flow Management (ETFM) system to identify and address all electronic transaction processing for a parts distribution and supply company. Developed project plans for the EDI Gentran to webMethods conversion with integration to web services and order processing. Consolidate all financial order-to-cash and order-to-pay transaction activities plan and schedule. Managed and coordinated the EDI deployment of an International hard-goods manufacturer in conjunction with a JD Edwards OneWorld-XE implementation. Project efforts included coordination with multiple divisions across the Managed and coordinated third party interface requirements for an integrated hard-goods manufacturer during the conversion to and implementation of JD Edwards OneWorld-XE ERP system. Architected the data flow model to coordinate all transaction interfaces between third party modules, custom designed system and JD Edwards ERP system functions. Built intranet web based documentation system to identify all data flow models, documentation and procedures and interface requirements. Developed internal Accounts Receivable (A/R) processes to enable the receipt of ANSI X.12 EDI remittance advice transactions (RA820) into the JD Edwards OneWorld Accounts Receivable system for a leading manufacturer of windows, doors and molding products. The project included building interfaces to J D Edwards (JDE) OneWorld Enterprise Resource Planning (ERP) A/R system for trade customer payments and remittance data, implementing automated cash application processes for JDE OneWorld A/R and training internal resources for executing the necessary manual A/R cash application activities. The EDI interface was implemented utilizing IPNet Solutions data communications tools and Mercator transaction set mapping. Deployed a trading partner system for a major electronics company that electronically supplies a comprehensive set of data and information to the Strategic Supplier/Partners. The two prime objectives of the business model are increased inventory turns while increasing the Customers’ schedule flexibility in a zero stock-out, and Supplier managed MRP environment utilizing EDI and electronic commerce. The overall program objective is to share vital information with the Supplier/Partner to allow for the transitioning of the decision-making process from within the electronics company to the supply chain link with the greatest degree of control and flexibility; the electronics distribution channel. Coordinated the cross-divisional development and implementation of a clothing design and production order system for both domestic and Analyzed the accounting and sales order entry system for a national manufacturing and distribution company of petroleum-based products to establish trading partner electronic interfaces. Selected and installed electronic data exchange (EDI) software to interface to DEC/VAX based accounting systems to map order entry and sales information to standard ANSI X.12 EDI transaction sets. Developed the necessary programs and procedures to map the trading partner transaction sets to acceptable input data formats for input into the company’s accounting systems. Managed the MIS audit activities for public accounting clients in the financial and petroleum industries. This included the transactional testing of accounting practices and procedures and the compliance testing to FASB rules. The computer systems were tested for accuracy of transactional data with predicted results. Security procedures and disaster recovery plans were evaluated and tested. Managed the development of a comprehensive revenue and royalty distribution accounting system for a national oil and gas exploration and production company. The system accounted for lease record holdings for all royalty interests. Oil and Gas production values were input and allocated to leasehold interests and royalty computations made with subsequent royalty and revenue amounts distributed. Designed and developed a comprehensive revenue accounting system for an international petrochemical company that interfaced directly with the general accounting systems. The system captured revenue generated from field operations through refinery sales and computed the royalty proceeds to feed the royalty distribution subsystems. Managed the establishment of a scheduling system to support the Sohio Sea Lift Project in Implemented EDI capabilities and training in Europe for an International Pharmaceutical company on AS/400 platform and Harbinger EDI translation software via GEIS value added network and corporate WAN. Interfaced JD Edwards ERP software systems to European based warehouse operations and locally developed warehouse management systems. Trained project team in EDI functionality and interface standards and assisted in the development and deployment of the bridging application systems implementation. Acted as liaison project manager to Established full Electronic Data Interchange (EDI) services for an International Pharmaceutical company using Harbinger/Premenos EDI/400 and TrustedLink Enterprise (TLE) services. This included the interface to existing AS/400 distribution systems and the JD Edwards Financial and Distribution systems at multiple international locations. EDI services were established in support of both intra-company and external trading partner relationships. Full sales order, purchase order, receipt and manifesting processes were supported as well as shipping and delivery interfaces with international freight forwarders. Both ANSI X.12 and EDIFACTS standards were utilized. Implement EDI capabilities in conjunction with JD Edwards CUM-10 upgrade. EDI facilities brought Installed and implemented Sterling Commerce Gentran NT Server for a pharmaceutical manufacturing company dealing with over the counter medication manufacturing and supply to mass-marketing retailers. The implementation included deployment of the Oracle EDI Gateway interface to the Oracle Financial systems and training of company staff. Managed the worldwide accounting and MIS audit activities for a fourteen-division national retail corporation. This included the annual accounting systems reviews as well as work paper preparation and analysis for the annual stockholder audit. Reporting to the Vice Chairman of the company, several special projects were also completed, including the implementation of a twenty four thousand person payroll, conversion to new general ledger and financial reporting systems, and implementation of the accounting systems and procedures for the Hong Kong Far East operation. Implemented and maintained Lawson financial systems, including the General Ledger, Accounts Payable, Point of Sale and Distribution modules. An EDI network was utilized to download daily credit card sales that were consolidated to a central clearing operation improving cash flow. Pricing level detail, daily sales dollars and inventory movements were exchanged with the host system using standard ASCII transmission protocols. Restructuring the electronic data interchange (EDI) function at a billion-dollar retail company utilizing Designed and managed the construction of a major credit card processing center in the Implemented a national Point of Sale network for retail chain throughout the Eastern Seaboard, including sales, inventory, distribution, and personal & payroll systems. This greatly enhanced the amount of work that could be processed by any one individual and reduced the need to add any additional staff. Managed the integration of the use of PC workstations into the host-processing framework. Several PC based management and reporting systems were integrated into the corporate database on the host processor. Established credit card authorization, credit and collection integration with all Managed the deployment of a food service company’s implementation of NT Based SAP EDI for the application interface to a wholesale distribution chain. Coordinated the IDOC interface with Harbinger TLE, EDI translation software, for Purchase Order, Order Confirmation and Invoicing. Managed the application and user dialog interface to ensure accurate translation and subsequent order processing and distribution. Also coordinated the EDI processing for inter-company order fulfillment and distribution on a linked AS/400 Completed a migration to Oracle based ROSS ERP systems and full implementation of Sterling Gentran NT Server EDI interfaces to national retail chains for processing purchase orders and invoicing. The project required setup and testing with multiple large national retail chain store operations and order entry systems for the manufacturing, shipment and delivery of drug and pharmacological products. Development of a project implementation plan to convert a national sporting goods retail chain from an older AS/400 version of the Lawson Retail Merchandising System and Accounting System to a new JDA integrated Merchandising and Accounting system. Mr. Stein was also responsible for the ongoing support and maintenance of the NT and SNA Sever supporting Windows95 workstations throughout the organization, while the migration to the new system was in progress. The application system also encompassed full store level and warehouse distribution systems utilizing real time satellite communications linkage to support point of sale and merchandise transfer and receipt. Implement Gentran Server NT for a large beverage bottling company. Manage the migration from AS/400 Premenos to Completed a migration to Oracle based ROSS ERP systems and full implementation of Sterling Gentran NT Server EDI interfaces to national retail chains for processing purchase orders and invoicing. The project required setup and testing with multiple large national retail chain store operations and order entry systems for the manufacturing, shipment and delivery of drug and pharmacological products. Responsible for the systems integration into The Limited’s retail systems, of the 600 Lerner Shoppe’s across the country including the development a data base application to track the installation of the T1 based computer network and support terminals throughout the organization. The Point of Sale (POS) systems were upgraded across the country with new hardware and software as well as stock ledger integration with the distribution system. In addition, a project tracking system was used to manage the conversion and implementation of accounting cost and control systems from previously developed in house systems to the Limited’s standard systems. Established communication systems and facilities for an international long distance carrier to exchange Billing and Collection as well as Equal Access data with Developed a customized interface to transmit PIC (pre-designated Interexchange carrier) information between a long distance service provider and the local exchange companies (LEC’s) across the country while maintaining a customer billing data base constructed from the call detail recording records maintained by the switching equipment. This data represented thousands of ‘pay phones’ maintained by local companies and consisted of both calls paid by coin or by credit card. Implementation of an EDI (electronic data exchange) system that provided communications linkage to the local exchange companies (LEC’s) across the country to transmit local PIC (pre designated Interexchange carrier) data to the LEC for selection of a long distance service provider in the standard CARE data format designated by the LEC. This system utilizes a combination of SNA protocols to communicate with the LEC’s VTAM LU0 host protocols communicating to the MVS/ESA host based systems. The direct systems interface enabled the transmission of long distance carrier information to the LEC providing for a four to six week improvement in transaction processing time and improves the cash flow to the long distance service provider. Managed the installation of a Company CBX (computerized branch exchange) system replacing older switching equipment. Responsibilities included the programming of the CBX equipment, establishing hunt groups and pick up groups, development of a training manual and the training of over 300 staff in the use of the new equipment. Call detail recording data was captured and utilized to produce departmental charge back reports for equipment utilization, and long distance usage. The local CBX data was matched to long distance call detail recording data provided by the local long distance service provider. Developed a department allocation system for long distance charges based on call detail recording data provided by the LEC and the long distance service provider by means of locally produced magnetic media on a monthly basis to match the billing cycle. The system matched outbound long distance calls placed by each extension to a departmental file and computed the percentage of usage minutes to the total to provide a charge back model for departmental cost allocation.
|
Send mail to the Webmaster with questions or comments about this web site. |
