Resume for Edmund T. Landgraf



Edmund T. Landgraf (415)-425-8655 (w/m)(866)-209-7487 (vm/fax)San Francisco Bay Areaed@Profile:Senior technologist combining superior managerial, strategic, technical, and tactical abilities in the business of software design, development, and deployment.Key Skills:Excellent, cross-functional, team management skills.Intricate, detailed knowledge of enterprise suite of Microsoft products.Solid, in-depth experience with Unix/Linux-based applications, tools, and technologies.System architecture analysis, design, implementation, and support.Large-scale model creation of business processes, application objects, & data relationships.EducationCornell University, Bachelor of Science, Computer Science, Department of EngineeringSpecializations: Database theory & applied Artificial IntelligenceMinors: Psychology, Operations Research, & Asian Studies University of California, Berkeley, Math and Computer Science courses.George Mason University, Graduate Computer Sciences courses.Professional InterestsEvolution, use, and implementation of modeling tools and code generation.Speaker, Software Modeling, Software Development Forum, SJ, CA.Distributed, asynchronous, component based architectures.Role of business and technology in sustainable human growth.Technologies(skill level unrated): , C, C shell, C#, DDL, DML, Entity Framework, Erwin, HTTP, LINQ, Lisp, mySQL, Pascal, SQL, SQL Server, Visual Studio, VB, UML, VBscript, XSD, XSL, XSLT, XML.Experience:GearSorter December 2010 - present(on contract) Offshore Manager/Developer/ArchitectManage two offshore developers working between 9pm and 4am from Sunday – Thursday. Rebulid app as a pure MVC3, Jquery, JqueryUI, EF, and SQL Server. Work exclusively in Visual Studio 2010. Developed check in policies to go against work items; tying requirements to code.Develop all Entity Framework modelsUse Table by Type and Table by Inheritance to modify EF model to better represent objects in the application (e.g. “Trip” is represented by a number of tables, but the “Trip” object combines all those tables into one representation)Develop various views and stored procedures to augment EF model.Write basic LINQ queries. Use LINQpad to test queries.Responsible for the entire architecture. Example include:Use services to expose just the functions of the controllers you want. Also sets up for being consumed by web servicesSupport for multiple authentication providers (e.g. internal, FB, Twitter, etc.).Design for consuming external product catalogs from outdoor product vendorsEnvision and layout a plan for extending GS into the social space (e.g. “like” a gear selection, or “Joe just picked the Nordica 55 backpack for his upcoming: Alaska 2012 trip”Prepare technical pitch for investorsMockup UI with various object calls. Pseudo code many object methods to help offshore develolpers.E.g. checkTripLength (fetch tripName, check trip length, if length is > 20, display x else display Y, etc.)GearSorter February 2007 – December 2010(on contract) Architect/Designer/Modeler/Requirements/Specification(Phase I – 9 months)Work with founder to develop concept to produce three artifacts: a functional specification (using MS Word), a data model (using Erwin 7), and a set of UI mockups (using Visio). Functional specification broke up application functionality into seven core components. FS written to be handed off to a software shop for immediate development with near zero wait time.Design over 30+ tables in AllFusion Erwin r7.1 incorporating both logical and physical views. Setup scripted referential integrity, data domains (via the domain dictionary), user defined properties, validation rules, and default values linking to SQL Server 2005.Create over 30 screens of annotated user interface mockups, each referencing both the functional specification and the data model. Mockups included callouts highlighting object attributes & methods, business rule logic, and applied and derived use cases.Presented five different UI component suites to client demonstrating how each control could be used to fulfill functional specification. (Phase II – 18-24 months)Design and build ontology to support the outdoor retail space.Allow for multiple contributors to the ontology via a self-service model (e.g. stakeholders can login and add/edit/delete)Support multiple representations of the ontology. Create a subset of web services to be consumed by mobile applications (e.g. iPhone) Design a web services layer to support consumers and subscribers.Re-design and expand initial database from 30 tables to 85. The number of relationships expressed between core objects has been increased threefold Design to implement using Visual Studio 2010, HTML, AJAX, C#, .NET 3.5, SQL 2008/10.Design the application architecture and object model. With founder, create specification (using a custom, table driven approach in Sharepoint 2007) of over 350 items.(Phase III – 24 months – launch)Expand database to 110 tables. Begin ETL workSetup and create process to use Team Foundation Server 2010Manipulate XML to create custom work item templates to support requirements and project management.Build custom workflows to support our offshore developersSetup check-in policies to match code against requirementsConfigure automatic build servers, input test cases, perform regression testing.Teach Agile/SCRUM and manage development efforts of offshore developers.Publish Linq to Entity model, pseduocode custom methods in C#, attach custom methods to sql server procs, and manage all changes into both the data and object model. Pancreatic Cancer Foundation (PanCAN)December 2007 – June 2010Lead Architect (Architect/Designer/Manager/Modeler)(with Tarika Technologies)Multi-year project beginning with gap assessment and concluding with the development of a new, custom, clinical trials and client relationship management system (CT/CRMS) Create various workflow documents (Visio, based loosely on UML) to play back to the client to ensure alignment on current processes (i.e. use visual aids to be sure you have the business modeled correctly). Create a set of 65+ detailed mockups over 12 months that included all front end screens for the two, previously undeveloped, core applications; a clinical trials management system and a customer service, client relationship component.Write a set of business rules (non-technical) associated with each mockup. Review with client and iterate. Design a state of the art, 4 tier architecture (all Microsoft), focusing heavily on the separation of the business and service layers. Design complete database (Erwin 7.1, SQL Server 2008) (78 tables) and implement all views (to join the model). Use LINQ against these views and write zero stored procedures.Work with development partner (Tarika) to develop business layer objects (implemented in C# and .net 3.5) over top of database. Review base object model with development partner (Tarika). Review each objects’ attributes and methods. Explain which SQL views would need to be called to achieve the outputs of each object method. Show the direct and indirect mappings between database columns and object attributes.Markup user interface mockups with arrows and callouts specifying which functions are to be called on which screens.Analyze LINQ calls and make many optimizations. Use parts of the Microsoft Application Blocks to not “reinvent the wheel” and use existing, established, open source components where available. Build it cheaper and faster while improving quality.Design a sub component of the system to interface with a 3rd party software vendor, currently used by PanCAN to manage much of its core business. Submit sub component’s design to 3rd party vendor for approval from vendor’s API team. Create an additional layer to loosely couple communications between the two systems such that if the 3rd party software were to fail (or communication link fail), the clinical trials system would continue to function in a limited capacity.Create a simple syncing process triggered when the communication link between 3rd party system and CT/CRMS goes up or down.Client facing project manager. Work with development partner (Tarika) to schedule resources, escalate issues, drive to resolution, and generally proactively engage to maintain and/or adjust project schedule. Basic timeline and client communication management.Work with development partner (Tarika) to create fixed price bid for PanCAN. Private Health ManagementJune 2008 – January 2009CRM Design & Implementation ConsultantReport directly to President to outline PHM’s needs for a single vendor, commercially available, CRM system. Analyze current PHM processes of creating, moving, storing, and sending electronic documents (text, spreadsheet, or presentation) around existing clients, unqualified and qualified leads, and “in the pipeline”.Submit three (3) CRM vendors comparing and contrasting each on a number of agree upon criteria important to PHM.Assist with creating workflows and business rules inside the chosen CRM solution.Work with PHM project manager to find CRM implementation provider. Evaluate implementation’s provider knowledge of CRM and make recommendation for selection.Assist in designing an integration strategy between an EMR vendor and PHM’s chosen CRM vendor.Analyze large, vendor provided, XML feeds. Detected and corrected numerous errors and submitted enhancements for optimization. Restructuring XML data feed for vendor (resulting in far less data being sent and a much quicker data transfer). Convert XML feeds into single relational database (de-serialized). Create simple XSLT conversion routines for outputting various HTML based representation of the database. Used Altova XML Spy (2008) to assist managing the schema mappings. Conversion routine had an exception processing component that allowed client to view and act on excepted data. Designed an update strategy for a feed assisted database, one in which some tables are updated by client (PHM) while others are updated automatically from the vendor’s XML feed. Create addition SQL views over the feed assisted database to provide support CRM system (via CRM custom web screens). Design the integration and the user interface mockups (Visio) between the CRM system and the feed assisted database. Wells Fargo December 2007 – December 2008(on contract with Strategic Resources Alliance) Senior SharePoint Implementation Architect Interview and analyze responses from other WF business units and craft a strategic and tactical plan for introducing, training, and deploying Sharepoint.Conduct over one dozen (12) training sessions on Sharepoint design and features highlighting how the product could be used to both better advance their own work while contributing to a secure collaboration platform among co-workers. Subject matter expert in Sharepoint to drive the second phase of the Knowledge Management project within Wells Fargo Business Unit (Small Business). Act as technical project manager responsible for execution, vendor management, and expert knowledge of the rollout process of Sharepoint. Take the generic Sharepoint (WF) template and build out, customize, test, and deploy to over 200 members of Small Business in a 13 month period.Part of the executive Sharepoint Core Team to review progress, goal attainment, issues, resolutions, for the WF Small Business Sharepoint implementation.Create a SQL Server database to accept file attributes of all the files in the business unit. Collect then run queries based on file type (e.g. word, excel), date created, date modified, size, and access. Use the analysis to help better configure/use Sharepoint.Setup security, access, and roles in Sharepoint. Strike a balance between the need for (leaf node) teams to collaborate freely and on the fly with management’s need for structure and auditing.SiteCore August 2007 – December 2007(on contract) Sr. Developer TrainerComplete Level 1 & Level 2 developer training at SiteCore USA’s headquarters in Novato, CA. Obtain Sitecore Level 1 & Level 2 developer certifications. Train or co-train one (1) week Level 1 & Level 2 Sitecore Developer certifications to Novato customers.Prostate Cancer Foundation (PCF)2006 - 2007(on contract) Architect/Designer/Manager/ModelerFrom the success of PDF’s clinical trials management system (below), built a complete functional specification and a full set of administrative UI mockups. Engaged SF-based design firm for front end wireframes and UI artifacts.Modified the PDF data model (using ErWin 4.1.4) to accommodate enhancements and additions. Built in additional support for sponsors and caregivers.Added core functionality to support trial sponsors using the site. Allows sponsors to be able to update trial contact and location support. Added interactive glossary, therapeutics manager, trial location wizard, role based security, managed data repositories, and clinical trials alerts.Parkinson’s Disease Foundation (PDF)2005 - 2006(on contract) Architect/Manager/Designer/DeveloperRe-architect version 1.0 of PDF’s clinical trials management system (). Analyzed current system shortcomings, wrote proposal, managed team (India), wrote functional specification, replaced and redesigned administrative UI screens, added multi-lingual support, setup bug tracking and issue resolution, planned launch, trained personnel, and supervised all aspects of code development. Replaced existing database and developed new database model using ErWin 4.1.4. Wrote backend SQL code, developed coding standards, setup global data access methods, performed PHP code reviews, and managed project plan and deliverables schedule.Delivered entire redeveloped system for 1/5th of original cost in just over 7 months.Stentor Inc2005Senior Database ArchitectUpdated/created functional requirements (FRS) based on marketing requirements (MRS). Built regression tests to support FRS/MRS query rules using Nunit. Moved some query validation out of SQL and into a C# wrapper.Installed and integrated partner’s HL7 processing engine and database filing application. Used HL7/web services application to populate 2 million record db. Discovered, tracked, and (mostly) resolved contention/locking issues between in-house Stentor’s iSite server and partner’s applications.Built test plan to monitor/guarantee query performance across multiple hardware configurations. Extended in-house performance tool to run automated tests against customer specific benchmarks. Built a set of configuration scripts to manage distribution of SQL server databases. Wrote ETL procedures to extract data from large customer’s db’s (>60G).Extensive review of all SQL for next product release. Identified bottlenecks in dozens of stored procedures. Optimized indexes, views, and renormalized some parts of db.Engaged in database deployment track to plan upgrade path for current customers.Manage shared data model using Erwin between Stentor and partner. Setup Erwin ModelMart to break model out for multiple database designers (US/Canada).Built multiple Visio diagrams showing data flow inside Stentor’s apps. Environment: SQL Server 2000, C#, PerForce, Nunit, Spotlight for SQL, Erwin, .NET C#, C++. Sharepoint.ARIA Software/Walther Solutions Inc.2003-2004Senior ConsultantBuilt and tested various components of ARIA’s WebManager written in Visual C#. Wrote extensive SQL to support backend data synchronization piece. Coded ARIA UpdateService, a C# web service to support data updates from local ARIA servers. Moved data model from Sql Server (diagrams) to Erwin and built pre/post sql scripts, setup index generation, and created a logical from the physical model. Implemented a versioning system to distribute and track development, test, and build SQL databases (using script management).Managed entire testing cycle of portal development with Axosoft’s Ontime 2004. Tracked, assigned, and resolved over 100 bugs/requests/during 2 month dev cycle.Built data synchronization piece and backend DB support of new web portal (). Implemented for largest SF immigration firm. System uses XSD’s to define data structures. XSD’s allow for data structure changes to be made available to clients and is critical for our hosted web reporting service.Scope, spec, document, plan, and execute custom data conversion from internal system to ARIA. Required extensive SQL manipulation using DDL and DML, designed custom set of mapping tables, coordinated customer review procedures and feedback, and facilitated client testing. Built system in-house and implemented at customer site at Minneapolis. Performed various bug fixes, small application enhancements, acted as last tier of technical support for difficult issues. Tuned and rewrote various stored procedures. Wireless Generation2002-2003(on contract) Data Integration SpecialistLead the design and implementation of a collection, verification, and export application delivering e-books into a mobile, palm based, reading assessment product (press release: mClass:Reading). Extract data from over 12 publishers each using unique formats, eventually building a universal XML schema. Process over 1000 books, using text, CSV, XML, Access, SQL Server, and Oracle 9i. Deliver a set of five tools to allow non-technical personal to add additional books without additional developer assistance.Odopod Inc.2002(on contract) Database Architect/EngineerWork with two large international media companies to implement a successor to a popular music file sharing program that adds and retains users while generating revenue.Initial design done by external research company. Used design specification to create both data model and application layer. Provided for synchronous and asynchronous data access to clients, balanced trade-offs of computed versus stored data, and tuned ODBC layer connecting SQL server with Director.eBoomerang Inc.2000-2001Chief ArchitectComponent-based platform delivering management and analysis of product returns for manufacturers, distributors, and suppliers of the demand-supply chain.Identified market opportunity, modeled common business problems, designed system architecture, and evangelized technical vision.Built multiple prototypes implementing business rules engine, simple Bayesian knowledge collector, and cross XML/web-based component services.Designed SQL Server database using Erwin 4.1.0. Created separate subject areas for external customer/partner integration.Built key technical and marketing documents. Published white paper on eB software.Excellent understanding of marketplaces, exchanges, collaborative design, ERP, CRM, supply chain (SCM), WMS, logistics and storefront systems.TransactPlus, formerly Gigamind Inc.1999-2000Chief Architect?Defined Internet strategy to transform a Fortune 50 legacy product on a global B2B services network into a secure transactional message delivery provider over the Internet.?Analyzed competitors, market, and existing technology assets to co-develop positioning and plan for next generation of product.1998-1999Chief ArchitectThe first Web-based property management and communications service for the residential rental housing industry.?Built product from concept to prototype through first production release. Completed initial database work in Oracle 9i both in PLSQL and Java (inside Oracle)?Designed and built software architecture and product focused on rules configuration, self-service administration, large-scale database support, community collaboration, and infrastructure for patented web-crawling technology.?Project manager of engineering team involved in database and middleware development of core product. Primus Knowledge Solutions 1999-2000 (on contract: SuperNova Consulting)ICommerce (formerly Breakthrough Software) 1998(on contract: SuperNova Consulting)Amerix1997-1998(on contract: SuperNova Consulting)District of Columbia, Human Services1996-1997(on contract: SuperNova Consulting)HCIA 1995-1996(on contract: SuperNova Consulting)Crestar/SunTrust Bank1995(on contract: SuperNova Consulting)Philip Morris Inc1994-1995(on contract: SuperNova Consulting)American Management Systems1992-1994Sybase Inc.1990 (Intern)Personal InterestsBicycle touring: California, Colorado, South America, Canada, Mexico, Alaska, Central America, India, NepalCornell Silicon ValleyUltimate Frisbee: Greer Park Lunch, South Bay, San Francisco, PortlandBreakbeat DJ: playing in SF, LA, NY, and northern Nevada.References: Available upon request. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download