Financial Services and Customers

Listed below are some of the key financial systems developed by EasyWebWare, Inc

Nestlé USA

1. Financial Budgeting & Analysis System

The Financial Budgeting & Analysis System includes the accumulation, review, consolidation, budgeting, analysis and reporting of Profit & Loss (P&L), Balance Sheet (B/S), Exceptional Items, and other financial data. This system interfaces to SAP and the company consolidation and reporting application.

2. Cost Center Budgeting

The Cost Center Budgeting System, which is also called Overhead Budgeting, includes the accumulation, review, consolidation, budgeting, analysis, and reporting of forecast and actual departments overhead cost data. This system interfaces with the Financial Budgeting & Analysis System and receives cost data from the Plant system.

3. Long Term Planning

The Long Term Planning System, includes the accumulation, review, consolidation, budgeting, analysis and reporting for the company's five years planning process of ITS Profit & Loss (P&L), Balance Sheet (B/S) and other financial performance data.

4. Financial Consolidation & Reporting

The Financial Consolidation & Reporting System includes the consolidation, analysis and reporting of ITS Profit & Loss, Balance Sheet (B/S) and other financial performance data. This system generates over 300 reports and receives its data from the Financial Budgeting & Analysis System.

This list of applications is a testament to our accomplishment and successful projects.

NBC Universal

1. Universal Studios: Alta Web Site (inventory/shipping/sales) – This was done with ASP to produce a “Merchandiser Reporting System” via Internet. Designer and Developer of the system to automate inventory tracking. Environment: Windows NT, Essbase, SQL Server 7.0, Visual Basic 6.0, InterDev 6.0, VB Script, RDO,FTP Jscript, Access 97, unix-nt.

2. Planogram - The planogram is a key data source in the RIM (E3) replenishment system. Replenishment accounts for about 80-90% of RIM’s functionality. The current planogram process is a time consuming and error prone manual procedure. This attempt to automate parts of the planogram process will improve efficiency in managing product allocations as well as improve the accuracy and effectiveness of the replenishment process itself. This means that Direct Account Management will better manage the sales & distribution of products. Environment: VB , SQL , Access ,FTP unix-nt.

3. Exception reports - If a retailer store has no POS activity for a specific title, this may indicate a problem with the stock level of that title at the retail store. UMVD would like to measure and report for a retailer at a store level the individual titles that have had no POS activity over a variable selected time frame specified by the user. Each of the retailer accounts that UMVD works with will have different selection criteria for reporting. Environment: Excel , SQL DSS Microstrategy .

4. CPU tracking - The management of invoices from merchandising vendors is a part of the Category Management process. The Cost per Unit (CPU) merchandising process provides information from different vendors/retailers on a weekly and monthly basis. The CPU Report consists of three parts: a monthly visit frequency schedule report; a cost per unit merchandising, planning and tracking report ; and a summary report. This proposal is to further automate this process to capturing historical data as well as capturing merchandising vendor’s invoices via an automated system. Environment: Access, VB, SQL

5. NMS KMart - Access, FTP web-nt.

6. Open to buy - Excel, SQL DSS Microstrategy .

Deloitte Touche Tohmatsu

Tax Cost Estimator ATLAS (MS Excel, Lotus Notes);

The system included a Lotus Notes Database and Excel Add-in as user interface. The application can export information from Lotus Notes to Excel and import calculation results back from Excel. Through Excel interface user can manipulate tax data and prepare tax calculations. This project involved designing and coding Lotus Notes forms, views, actions; designing and coding Excel Add-In; with the ability to code and maintain system information stored in Excel Add-In;; also includes the ability to code and maintain mailing system in order to track status of tax requests

Foreign Compensation Template (MS Excel MS Access , Crystal Reports , MS Windows API)

The system included Excel as user interface and Access Database as back-end. The excel spreadsheets are sent to a respondent via Lotus Notes Mail, System has ability to collect information from returned spreadsheet putting it into an Access Database, refresh spreadsheets and again send back to the respondent

Electronic Questionnaire (MS Visual Basic , MS Access , Lotus Notes.

The system included a Lotus Notes Database and Access Database with Visual Basic user interface. The application is sent to a respondent via Lotus Notes Mail and had the ability to automatically mail client answers back to Arthur Andersen. This project involved programming the Questionnaire application; installing and configuring a Lotus Notes Server; designing and coding Lotus Notes forms and views; programming and setting up the Questionnaire application to link Lotus Notes Mail using VB/Link custom controls.

International Compensation System (MS Visual Basic , MS SQL Server , Crystal Reports, MS Windows API );

The system included creating tables, stored procedures, triggers, and rules. Next, developing interface between the front-end application and SQL Server using Remote Data Object. Additionally Windows NT and SQL servers were configured for demo environments and workstations were configured for remote and LAN access to SQL Server. Performance was improved significantly by relocating some time consuming processes from the front end onto SQL Server. It required writing several improved complex stored procedures for month end payroll calculation. When this work was done, overall system performance improved 5-7 times.

General Compensation Managing System (MS Access, MS SQL Server, MS Windows API);

Creating tables, stored procedures, triggers, and rules. Developed Access front-end and interface between the front-end application and SQL Server using Remote Data Object.

Timesheet/Reimbursement System (Intranet Version) (HTML DHTML, ASP, ADO MS Access).

Developed Timesheet/Reimbursement Application (Intranet application for filling out timesheets and reimbursement forms). The coding of web-site using HTML, CSS, ASP, VB Script, JavaScript and so on.

International Payroll system to keep track of complex international tax and personnel data. Also worked on various client-requested software systems. These tools utilized MS SQL, Access, VB, VBA, and Excel.

ACSC (Automobile Club of Southern California).

Y2K Application Manager for ACSC (Automobile Club). This product was coded in VB MS Access with VBA functions, and SQL Server . The application was used for Y2K compliance analysis of ninety-five production applications. Designed, coded, and implemented an analytical ActiveX based application for the corporate web site.

Computer Sciences Corporation

CSC project, “Jvpost”. Project was designed to keep tract of Costing databases including subsets of Contracts, inventories, and other cost centers. System was implemented in both desktop and a network environments with complete querying and reporting functionality. Project was written in Microsoft Access utilizing Ms Excel and VBA.

SBC

Cost analysis program which obtains statistics of DSL cost and revenues from various main frame and network environment(s) converting the data and loading it onto a SQL Server database. Front end was done in VB with a SQL server backend utilizing ftp, NT, VB and Microsoft SQL server.