Daniel Odulo Odulo Enterprises 1307 Charmwood Square San Jose, CA 95117-3610 Daniel at Odulo dot com www.Odulo.com/daniel Voice 408-379-5551 Toll Free 866-My-Odulo Fax 720-293-4880 Senior Business Data Consultant / Database Application Developer / Database Architect Objective: MS SQL Server, ASP, .NET, and MS Access Database Application Development Summary: 10+ years of computer experience, 6+ years experience in design, development, and implementation of custom database application solutions. Experience in the following systems/tools: • ASP, VBScript • .NET (ASP.NET, VB.NET, C#) • MS SQL Server 2000 • MS Access 2.0 through 2003 and VBA • Database Architecture • Windows NT 4.0, 2000, XP, 2003 Srvr. • Full Lifecycle Application Development • EDI, DBASE (for data mining) • Oracle (through ODBC) • Pointman (a legacy system) • MS Excel • HTML, PERL, FrontPage, C, Java Script Professional Associations: Ex Vice President – Silicon Valley WebGuild (www.WebGuild.org) (for 1 year); Co-Chair e-Business perspectives SIG of the SV WebGuld (for 6 months). Experience: Contracting / Consulting - Santa Clara County, California Sr. Database Developer/Architect / Application Developer (1996 to Present) * Customers include: BioCentury, AFNI Inc, AcroMetrics, Xicor, Inc., Intraware, Inc., Cunningham Communication, Inc., SGS-Thomson Microelectronics, Inc., Creative Point, Inc., Valin Corporation, and others. * Designed, developed, and implemented custom database applications, to wit: * In-house database application for a biotech publishing company to manage proprietary company data and generate publication texts. * Web e-commerce application for a commercial insurance company to provide, for a fee, proof of insurance certificates to its clients and their lenders. * Automation for call center rep’s desktop for a national call center. * Multi-store e-Commerce solution -- A fully dynamic high-end e-Commerce solution for multi-store hosting. * An on-line event registration service -- A fully dynamic multi-event registration system with payments and advanced reporting. * Bio-tech production management application. * POS Tracking and Revenue / Gross Margin Analysis and Reporting package -- A Financial Analysis package for a semiconductor manufacturer. Modules included: * Commission and Split Commission Calculating and Reporting allowing for calculation and payment of a complex two-tier commissions process * "Meet Comp" authorization, tracking, and reporting system * Return Merchandise Approval and Reporting application -- Allowed finance to track the fiscal impact of RMAs, included a Manual Invoices module * Parts Tracking and Management System for a semiconductor manufacturer -- Allowed tracking and management of a four-tier inventory structure * Perpetual Inventory tracking system -- Allowed the finance department to accurately estimate distribution's inventory * Materials Shipping application -- A shipping package for a manufacturing company, including analysis reports, data migration, developed a Shipping Room stand-alone front end in VB5, custom label printing using Crystal Reports, etc. * Non-Conforming Material Management Database -- Developed a package for a manufacturing company * Employee Payroll and Training Database -- Fixed and improved the application for a manufacturing company * Invoicing, Rolodex, Contact Management, DJ, and E-Mailing applications -- Also developed a number of other applications * Data Mining from and Interfaces with EDI, Oracle, MS SQL, Excel, dBase Projects Reference Client: BioCentury, San Carlos CA Solution: Company News application. Environment: MS SQL Server 2000, MS Access 2003. Time span: February 2006 to (ongoing). Details: An in-house database application for a biotech publishing company to manage proprietary company data and generate publication texts. Manages a number of sets of data, some extremely complex, and assists with generating publication text for the weekly magazine. Client: Select Commercial Insurance Services, San Carlos CA Solution: Certificate of Property Insurance e-Commerce Site. Environment: ASP .NET, VB .NET, Crystal Reports, MS Win 2003 Server, MS SQL Server 2000, MS Access 2000. Time span: December 2005 to (ongoing). Details: Web e-commerce application for a commercial insurance company to provide, for a fee, proof of insurance certificates to its clients and their lenders. Client: AFNI, Inc., Tucson AZ Solution: Automation for call center rep’s desktop. Environment: OpenSpan Composite Studio Time span: November 2005 to December 2006 Details: Reps in an outsourced call center have to interact with numerous web, windows, and legacy applications, provided by the client. Call center has no control of these applications and can not modify them. Usage is extremely clunky, requiring frequent re-logins, duplicate data entry on every call, and navigation through complex systems to obtain basic data. Automations were developed to: automate all logins and keep reps logged in at all times, automatically transact with multiple applications when base data was provided, scrape needed data from various applications and provide on a single UI, etc. Client: Odulo Enterprises Solution: Odulo e-Commerce - www.odulo.com/consulting/Products/eCommerce.html Environment: ASP, MS SQL Server 2000, VBScript, Transact SQL, .NET, Web Services. Time span: 2002 to (ongoing). Details: An enterprise e-commerce engine which is capable of hosting the e-commerce sales channel for multiple clients utilizing the same engine and one or multiple installations of the application. This is a multi-tier solution, with RDBMS in MS SQL Server, and the web server of MS IIS. The application layer is split between Transact SQL and VBScript, with some on the new web-services layer, and .NET Win-Forms application. Follow the link above for more info. Current and past customers include: MyEcoFamily, Orchard Valley Coffee Roasting, Inc., Vardy’s Jewelers, Inc., Clear Silence Art Gallery. Client: Odulo Enterprises Solution: Odulo Events - www.Odulo.com/events Environment: ASP, MS SQL Server 2000, VBScript, Transact SQL Time span: 2000 to 2004. Details: A very powerful online events registration system. This is a two-tier solution, with RDBMS in MS SQL Server, and the web server of MS IIS. The application layer is split between Transact SQL and VBScript. Follow the link above for more info. Current customers include: InterFrench - www.LExecutiveClub.com, Yeahman Productions – www.Yeahman.com Client: AcroMetrix Corporation, Inc. Application: Blood Screening Panels manufacturing Environment: MS Access 2000 Time span: 2002. Details: The client was manufacturing biological samples for customers and affiliates worldwide. These samples were only identified with an ISBT code 128 barcode, thus each and every sample needed to be logged during batch filling. I designed and developed a solution to allow for a fast, efficient, and reliable way to manage all information pertaining to this project. Panel information, part numbers, lot numbers, member ID numbers, and all other relevant information could now be easily entered using customized smart input screens, and barcodes are then scanned directly in-to the system. The application is multi-user and fully secure to guarantee data safety, and is intended to be an information management tool for the manufacture, shipping and tracking of the individual panel members. See customer’s testimonial at http://www.Odulo.com/consulting/testimonials.html Client: Odulo Enterprises Solution: Power Contact - http://www.Odulo.com/contact.asp Environment: ASP, MS SQL Server, VBScript, Transact SQL Details: A dynamic registration based privacy email form, allows one to open an account, and include a link to this contact page with their username, allowing visitors to send the customer an email without ever disclosing their email address. Client: Yeahman Productions Solution: Indian Summer Registration Details: Designed, developed, implemented, and managed an interactive web-based registration system with a SQL Server back-end and e-payment capabilities for a large international five-day event. Developed secure interactive on-line reports, many with data editing capabilities, for the staff to process and interact with the data. Developed an MS Access solution to handle sign-ins and last minute reporting and analysis at the event location. See http://www.Odulo.com/consulting/projects/web/indiansummer for more info and customer’s testimonial at http://www.Odulo.com/consulting/testimonials.html Client: Xicor, Inc. Application: Revenue and Reporting Environment: MS Access Other systems: Oracle, EDI, dBase, MS Excel Details: Designed, developed, and implemented a revenue and a reporting application for the finance department with numerous modules. The applications are multi-user and fully secured with user-level access and some event logging. The Revenue application collects POS data from EDI, Oracle through ODBC, MS Excel, and flat and formatted text files. The data is normalized and processed. The Meet-Comp module allows complete analysis of the meet-comps, bill-backs, credit memos on the bill-backs, and powerful reporting. The Commissions module allows for a complex split commission process to be performed on the sales data for the purpose of paying rep commissions. Post-split data is exported to a reporting database application, which allows for complex revenue and gross-margin reporting and data exports. Client: Xicor, Inc. Application: RMA Environment: MS Access Other systems: Oracle, dBase Details: Designed, developed, and implemented an RMA tracking and reporting application for the finance department. The application allows for entry end detailed tracking of RMAs, performing bill-backs, and advanced reporting. Also included a Manual Invoices module, which also provided advanced reporting functionality. Client: Intraware, Inc. Application: Finance Environment: MS Access Details: Designed, developed, and implemented a sales tracking and management application for the finance department. Allowed import of sales data from the data warehouse, processing of this data, and reporting on it. Client: Xicor, Inc. Application: Inventory Management Environment: MS Access Other systems: Oracle Details: Designed, developed, and implemented a Parts tracking and management application for the finance department. Allowed tracking and management of a four-tier inventory structure. Client: Xicor, Inc. Application: Perpetual Inventory Environment: MS Access Other systems: Oracle, dBase Details: Designed, developed, and implemented a Perpetual Inventory tracking and reporting application for the finance department. Allowed the finance department to accurately estimate distribution’s inventory. version 04, 2006