================================================================ JULIANNE BISHOP Phone: (415) 387-2942 Email: ITProfessional@JCBishop.net ================================================================ SENIOR SOFTWARE DEVELOPER Ten years of software development and project lead experience in Fortune 500 corporations and small private firms; in the facility services, market research and consulting industries. Demonstrated expertise in Microsoft technologies including Visual Basic, COM, Active-X, ADO, SQL Server, Visual Studio, Visual InterDev, and Visual Source Safe; proficiency with various web technologies including IIS, ASP, VBScript, JavaScript, and HTML. Designed, developed and rolled out building engineering preventive maintenance system, which was used to support 300+ large facilities nationwide, for clients such as Wells Fargo and the World Trade Center in New York. Managed direct reports and contractors to enhance, upgrade and support system. Collaborated with senior management and internal and external customers to design and implement mission critical business support systems. Re-engineered and developed client/server COM and web based survey engine currently being used to conduct large online market research studies for various clients including Fortune 500 corporations. PROFESSIONAL EXPERIENCE ---------------------------------------------------------------- SOFTWARE DEVELOPMENT CONSULTANT (Contract Position) Hagberg Consulting Group - Foster City, CA 2003 ---------------------------------------------------------------- * Upgraded complex survey and reporting interfaces to utilize new SQL Server 2000 relational database model. Collaborated with database administrator and other staff to refine and optimize new database model. * Improved efficiency of ASP and SQL code. Optimized code execution; implemented modular structures and methods; reduced code redundancy; enhanced scalability; improved on-line performance and reduced resources required to run system. * Enhanced system with the addition of error logging and system support tools and interfaces. Improved ability to maintain system and reduced development resources needed for system support. ---------------------------------------------------------------- WEB DEVELOPER (COM, Application and Internet Development) Socratic Technologies, Inc. - San Francisco, CA 2000-2002 ---------------------------------------------------------------- Lead developer responsible for the construction of core, mission critical applications as well as various smaller internal business products for an internet based Marketing Research firm. * Re-engineered and enhanced proprietary survey engine software. Conducted end user requirements analysis; designed and implemented relational databases; designed and developed hierarchical object model and constructed associated middle tier COM object; developed functional specifications for internal interfaces; designed and developed Web based templates for survey presentation layer and developed on-line programmer documentation for COM object. * Reduced survey production costs, improved survey time to market and enhanced on-line performance of survey software through the design and development of client/server COM based survey engine which could be easily programmed and customized for specific client requirements. * Designed and implemented scalable, relational data store for survey data resulting in improved data integrity; reduced costs for back end data set and report generation; designed and developed Tabulations Spec Writer to automate WinCross spec generation thereby further reducing data and reporting costs. * Designed and developed system to centrally manage survey and panelist data for both in-house and client panels. Project responsibilities included business requirements discovery and analysis; design and implementation of relational database, functional specifications for internal interfaces, design and development of associated middle tier COM object and integration of COM object with web based survey software. * Enabled consolidated tracking and analysis of panelist survey activity; improved ability to analyze longitudinal data and enhanced the ability to quickly and accurately pull sample from panels. * Reduced administrative costs for panel rewards fulfillment through the development of COM interfaces to support real time automated incentive tracking and rewards fulfillment. ---------------------------------------------------------------- PROJECT LEADER AND VISUAL BASIC DEVELOPER ABM Industries, Inc - San Francisco, CA 1993-2000 ---------------------------------------------------------------- Project Leader responsible for Engineering Division applications and projects. Worked directly with senior management of Engineering Division regarding development, enhancement and support of the division's proprietary applications. * Designed and developed system to catalogue and automate scheduling of preventive maintenance for building equipment; system was distributed to 300+ individual customer sites nation wide. * Migrated stand alone preventive maintenance system to a central VPN platform with a consolidated SQL Server backend database to enable consolidated reporting across facilities. * Enhanced Engineering systems to comply with the division’s ISO 9002 standards. Developed system to monitor and report on ISO 9002 compliance. * Designed and developed reporting and graphing modules using Crystal Reports, VBA and OLE Automation with MS Word and Excel. * Designed and developed system to record, report and analyze building energy usage. * Acted as project manager in charge of setting up IT infrastructure for ABM Engineering Services’ World Trade Center branch. Responsibilities included overseeing installation of T1 lines, acquisition of equipment, data setup and conversion and integration of systems. * Researched and created reports and participated in presentations on various topics including Software Asset Management, Total Cost of Software Ownership and Distributed Computing. ---------------------------------------------------------------- BRANCH ADMINISTRATOR (Database Support) The ROLM Company. - San Francisco, CA 1991-1993 ---------------------------------------------------------------- * Designed, created & maintained relational databases and user interfaces for large sales branch pertaining to an installed base of over 600 customers, as well as current and historical installation projects and prospects. * Automated report generation and improved maintenance and accuracy of customer and project data/ received $300 cash award in recognition of development efforts. * Performed data conversions between host computer and PC. * Provided PC support including but not limited to installation of software, configuring and upgrading PCs, trouble shooting PC hardware and software problems, and software training. EDUCATION Computer Learning Center, San Francisco, CA Certificate in Computer Programming; Graduate with Honors University Of California At Berkeley, Berkeley, CA Bachelor of Arts TECHNICAL SUMMARY Languages/Technologies: Visual Basic 3.0 through 6.0, Visual Basic for Applications (VBA), ASP, VBScript, JavaScript, HTML, COM, ADO, DAO, ODBC, OLEDB Database: SQL Server 2000 & 7.0, Access 2.0 through Access 2002, ANSI and Transact-SQL Development Tools: Crystal Reports, Visual Studio, Visual InterDev, Visual Source Safe, Homesite Operating Systems: Windows 2000, Windows NT, Windows 9x Other: 3 Tier client/server Architectures, Object Oriented Programming (OOP), Relational Database Design & Modeling, End User and Business Requirements Analysis, Project Management. Web Site: www.JCBishop.net