Information Systems Solutions Architect – Creative and Technical
Senior-level creative and technical expert in information systems planning, design, development and implementation. Technology director, systems integrator, programmer, project manager and creative director. Deep understanding of information systems architecture and security, user interface design, database design, applications programming, client / server technologies, business process automation, data warehouse design and management, and reporting. Work well independently and in team environment.
Microsoft Visual Studio, Windows Server/ IIS, SQL Server, SSIS, SSRS, SharePoint, Salesforce, Office, JQuery, Project & Visio; Infragistics Net Advantage; Dundas Data Visualization (Charting Components Dashboard); Linux Apache/ PHP, Adobe Creative Suite (Dreamweaver, Fireworks, In-Design, Illustrator, Photoshop, After Effects, Flash), Quark; Business Objects Crystal Reports.
Bachelor of Science in Computer Science
Confidential,White Plains, NY
Jan 2001 – Present Information Systems Solutions Architect / Consultant
NOTABLE PROJECTS LISTED BELOW
Provide Business Intelligence analysis, design and programming to support university in data warehouse and dashboard reporting initiative. Development responsibilities include information architecture design, planning and implementation, to ensure best practices for development workflow, reporting infrastructure, and user interface design.
Technologies: Windows Server, SQL Server, SharePoint, Visual Studio, Dundas Dashboard, SSRS, SSAS, Visio
Provide website programming to incorporate SEO, Google Analytics, Omniture page tracking and Synxis Reservations Booking Engine software in approximately 30 websites for hospitality businesses. Sites are developed in multiple languages (English, French, etc.). Responsibilities span taking designs from art department and developing per marketing department needs.
Build back-office web services infrastructure to handle HTML queries from various websites and return data tables for e-commerce distribution ordering system. Responsibilities span information systems architecture, database design, interface design, programming, testing and implementation.
Provide web application development to support marketing department. Responsibilities span interface design, web forms, data visualization (charting and dashboard design/ development), database design/ development.
I. Provide management consulting services to transfer knowledge of website architecture, network and hosting to internal management.
II. Build WinForms C# SQL-to-Excel export utility for web-based procurement system. Ensure compliance with system and train users.
Technologies: .NET, C#, WinForms, SQL Server 2008, Visual Studio 2010, MS Office 2007
III. Upgrade server side of ecommerce site to web services, JQuery, JSON, AJAX
IV. Design and program new business management system, replacing antiquated system. System performs order taking, web ordering, point-of-sale, accounts payable, production and management reporting. Building-in future-use database components, to roll-out application to other business units.
Technologies: .NET, WinForms, C#, XML, CSS, SQL Server 2005, Crystal Reports
V. Perform business systems analysis, project management, form design and programming, report design and programming for new business management system, replacing antiquated system. Design and program various reports integrating company’s production, financial and client services departments. Upgrade database from SQL Server 2005 to SQL Server 2008.
Technologies: Visual Studio 2008 (Basic & C#), Crystal Reports 2008, SQL Server 2008
VI. Design, program, host and maintain large wholesale bread ordering system, System interfaces with partner food-service companies as EDI ordering system (orders are fed through secure FTP site, customers are sent confirmations). Design and program web catalog used by sales staff to present product lines to prospective buyers, and those buyers to browse product online. Design and program Flash movies promoting web catalog, and enabling entry into it.
I. Analyze current environment/ requirements of large image files and shared documents for conversion to SharePoint 2010 Document Management System.
Technologies: SharePoint 2010, Windows Server 2008
II. Redesign two corporate intranet sites for headquarters and store managers. Create top-side navigation menu, standardizing and maximizing sites’ dynamic content area. Design simple attractive icons for navigation bar, making sites appealing and user friendly. Introduce database driven menu enabling maintenance of menu items via SQL Server (change from prior sites’ architecture which was based on static pages). Consult on security best practices limiting store access from store WAN only. Add Blackberry interface for district mangers. Test, train, implement, support.
III. Reprogram ecommerce components of website, upgrade financial online clearing capabilities with Chase, VeriSign and CertiTax. Work with networking personnel to ensure site is load-balanced across redundant application and database servers. Enhance admin section to enable internal production personnel to maintain product images and descriptions, and sales managers to maintain sales performance and investor relations data. Ensure system’s firewall and server SMTP gateways are anti-hacker/ anti-virus secure. Ensure backup.
I. Design/develop Windows Forms (WinForms) Business Management Solution enabling maintenance of companies, contacts, products, orders, and accounts payable.
Technologies: .NET, C#, WinForms, SQL Server, SSIS, SSRS, Visual Studio
II. Design data warehouse for implementation with new windows-forms Business Management System; Design, program and test extensive ETL packages, stored procedures and triggers to load/ maintain data.
Technologies: SQL Server 2008 (Business Intelligence/ SSIS), Visual Studio 2008
Confidential,Perform business systems analysis, project management, website design and programming for ecommerce site (under construction) promoting artwork of publication covers, vintage car and cigarette ads, query engine to search Playbill opening-night editions in full text. Design and program database to catalog performance content. Overseeing art scans and storage.
Confidential,Perform salesforce.com integration with back-office business management system; analyzed salesforce.com database and methods for importing and exporting data; developed automated EDI-like function to prepare bi-directional nightly file transfers between both databases; ensured salesforce.com and local back-office databases in sync; reported directly to company president and VP marketing.
Technologies: Salesforce.com; Visual Studio 2008, SQL Server 2008
Confidential,Create web landing pages to help track success of postcard ad campaigns for College of Liberal Studies. Provide marketing consulting on campaigns, including mailing list acquisitions (based on target demographics), postcard graphic design/ layout, management of printing and mailing, web traffic analysis.
Confidential,Create searchable hypertext PDF brochures, tied into large cooperative ad campaign with Starwood Hotels.
Technologies: HTML, Acrobat
Confidential,Create graphical HTML e-mail campaigns, fully XHTML-compliant (W3.org), manage strict Q&A testing to ensure emails open on all browsers (PC and Mac). Run email campaigns through DartMail™, reaching millions of customers. Encode emails with unique keys to track click-through responses.
Jul 1995 – Dec 2000 Confidential,Norwalk, CT
Partner / Multimedia Design-Developer
- Program numerous websites and interactive DVDs using Macromedia suite (Fireworks, Dreamweaver, Flash, Director) and Adobe Premier. Develop CRM application in FileMaker.
May 1992 – Jul 1995 Confidential,New York, NY
Programmer / Analyst
- Design and program in Informix 4GL "Client Services System" (front and back-office) which maintains database of all client accounts and interfaces with ADP Payroll. Support NYSE online trading application. Support monthly statements application.
Mar 1990 – May 1992 Confidential,New York, NY
Programmer / Analyst
- Migrate data center from Minneapolis, MN to Westbury, NY; program data transfer application enabling critical data transfers of store sales and inventory affecting all 1,500 stores. Develop point-of-sale programs for NCR registers.
May 1988 – Mar 1990 Confidential,Valhalla, NY
Programmer / Analyst
- Program SQL reports for large telephony management application for Fortune 500 clientele.
Jan 1985 – Sep 1985 Confidential,Kingston, NY
- Program C functions to test video adapter pre-market release. Uncover over 100 bugs.