Emmanuel David Email & Phone Number

Bridgewater, Nj

Administer JDA Arthur Planning, JDA Arthur Allocations, ANT Buyer's Toolbox, Epicor (NSB) Sales Audit, Crystal Reports Server, IBM Datastage and Autosys applications. Troubleshoot and resolve issues for business users, make enhancements, document how-to's. Create management and executive reports. Designed & implemented many of the interfaces for the JDA MMS implementation using IBM Datastage. - Created ETL interfaces using IBM Datastage to load merchandise hierarchy, POS sales, price change data to the POS, Sales Audit, MMS and Lawson systems and E-Commerce application eliminating custom programming. Used CA Autosys to schedule/execute the tasks.- Directed POS vendors Micros Retail to create interfaces into Sales Audit for layaway conversion and eCommerce conversion. Configured Epicor Sales Audit to load data from POS.- Maintain Knowledgebase of known solutions to problems.- Created C# application to tokenize/de-tokenize credit card data using nuBridges application.- Converted and consolidated many Access/Excel based reports into enterprise grade reports reducing the number of single reports using DB2 and SQL Server data, Crystal Server, scripts.- Replaced legacy reports emailed daily to 220 stores with Crystal Server 2008 based reports and ASP.NET based report portal to serve up daily reports. The interface to access reports was cleaner, the email box was freed from clutter and used for email only. Added bar coding to existing reports so that carton receipts can be scanned in. Re-designed character mode reports to GUI based PDF reports by creating a report engine using Crystal reports. - Automated many Excel and Access based reports to run in batch mode to reduce time and personnel to produce them.- Consolidated many single function NSB Smartlook reports to multiple function reports reducing the number of reports produced and manual work to summarize them.- Liaison between outsourced Oracle DBA and other vendors for system related problems.

Managed the NSB Sales Audit application daily operations . Designed and implemented the interfaces for the rollout of the Datavantage Xstore POS system. Automated many manual processes to improve efficiencies within sales audit and inventory control department. Sr. SYSTEMS ANALYST- Performed the entire sales audit system configuration required to support the Datavantage Xstore system. - Directed Datavantage for creating the translate interfaces. Performed Q & A of the transaction data. Performed end-to-end testing of the system for Merchandising (JDA), Settlement (Paymentech), GL (Lawson) for US, Canada, Mexico and ecommerce environments. This saved the company money that would be spent on NSB professional services.- Worked with team to upgrade the Sales Audit system from V2.0 to V4.0. Created automated scripts to automatically install the applications. Converted all the reports.- Managed/administered the NSB Sales Audit system for daily operations, developed new reports and modified existing financial and operations reports using Smartlook, Excel and other tools making the Sales Audit and IT departments more effective in providing information- Automated many daily processes to improve the effectives of the Retail support team. This saved the company money, time and shipping costs.- Designed and developed streamlined reports for the merchandising team, using data from JDA MMS and Retail Data Mart- Shared knowledge by creating a solutions knowledgebase with a full text search capability for the team to share and use.- Created a prototype store-level inventory application for the PDA, interfacing with MMS.- Provided technical support for all the stores which included hardware, operating system, POS and JDA MMS application support.

Managed and upgraded Windows NT 4.0 network to Windows 2003 Small Business Server network. - Configured server with dialup Internet access, Symantec Antivirus 8.1, Veritas Backup Exec 9.0, Exchange Server, MS Office 2003. Migrated data and email to the new server.- Installed Tape drive, CD burner and configured Backup Exec for automated backups.- Configured network to use a cable modem instead of dialup.- Registered domain name and configured email accounts for new domain.

Performed a variety of in-house projects ranging from network management, report development, product development, technical writing and optimizing processes.- Implemented WhatsUp Gold (Network management and monitoring program) to monitor 1000+ customer routers. Used SNMP to monitor disk space, exchange queues, network utilization and other thresholds. Integrated with Clarify, MRTG, knowledgebase and the asset database for context sensitive information for a node. Setup portal to for customers to view their site information and it allowed help desk technician’s access from home using the web. This resulted in a very effective 24/7 help desk and it was a showcase of the company’s capabilities.- Developed browser based knowledgebase and asset database used for the Network Operations Center using VB and MS Access. Used multimedia to make the knowledgebase more effective. - Using Seagate Crystal Reports, created operations reports for customers from Clarify CRM and modified financial and operations reports for Solomon IV system. - Developed documentation (user and admin, training, help files) for TelAlert Enterprise & CM.- Developed ASP, Outlook, Word and Excel forms to streamline many in-house processes. - Developed enterprise reporting application rollup reporting for merchandising application used worldwide by major retailers to report on planogram compliance for IRI (Information Resources Inc). Developed the installation guide, user guide and troubleshooting guides.- Developed CE application to track inventory in restaurants and integrated it with Menulink.- Developed Windows CE based bar code scanning and printing application using Zebra printers.- Developed interactive training content using Power Point for Cisco AVVID IP phone based time management system called ExtendTime.

Team member that developed the report engine that produced affirmative action documentation. Optimized and simplified report generation that resulted in a big performance boost.- Designed and developed asynchronous report engine using C#, Crystal Reports 9.0, MS SQL Server 2000 and the .NET framework to generate PDF reports.- Optimized reports and trained developer on SQL to convert 100 of the existing reports.

Developed electronic documentation authoring system and wrote documentation for new help desk that could be published on the web and used multimedia to reduce training time.- Interviewed knowledge experts, documented solutions, classified findings in an Access database.- Generated HTML documentation from database to the intranet using VB6 application, which had multimedia, hyperlinked and had full text search.- Documented the WAN rollout extensively for field engineers.

Developed database driven system for remotely accessing disaster recovery documentation.- Developed disaster recovery documentation for Novell, NT and Unix systems.- Developed ASP and Crystal Reports front end to access disaster recovery information from home.

Worked with the Pegasystems consulting team to implement the Pegasys CRM application and developed procedures that resolved day-to-day problems.- Gathered requirements, documented functional specs and data dictionary components.- Developed import scripts to load data from FTP feeds using Oracle SQL*Loader. Developed stored procedures to perform nightly Oracle updates. Migrated call center data from MS Access to Oracle.- Developed automated installation script to roll out client applications.- Developed Access forms for verifying data in database.- Installed Seagate/Crystal Info report server and clients. Combined and optimized 100 management reports into 10 compound reports using Seagate Info and improved performance and ease of use.

- Clarify CRM implementation team member that evaluated, selected and implemented the package.- Department VAX system administrator / programmer.- Integrated Clarify to NCR Link, Knowledge Bridge.- Created/developed email and fax programs to electronically send service requests to vendors and reduce technician phone hold time.- Developed management distributed reports and report engine using Crystal Reports for unattended daily reports.- Knowledge authoring in Top Of Mind and Knowledge Bridge for efficient problem resolution.- Developed utility library using DCL, VB and DOS scripts for technicians to perform repetitive tasks.- Setup enterprise monitoring and notification tools called Sentry.- Performed technical interviews on the phone to hire support center staff.

Implemented Clarify CRM Clear Support module for the help desk.- Gathered requirements, developed functional specs.- Installed Clarify Clear Support using SQL server, Actuate for Clarify reports.- Customized the system using Clarify tools, and developed integration code for CTI screen pops.