Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 914 views

    Resume

    Uploaded by

    johnseq
    Resume for John Sequeira, Database Developer and Technical Lead for Business Intelligence, Data Warehousing, Quickbase, ASP.NET, SQL Server, CRM

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Resume

    Uploaded by

    johnseq
    914 views6 pages
    Resume for John Sequeira, Database Developer and Technical Lead for Business Intelligence, Data Warehousing, Quickbase, ASP.NET, SQL Server, CRM

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Resume for John Sequeira, Database Developer and Technical Lead for Business Intelligence, Data Warehousing, Quickbase, ASP.NET, SQL Server, CRM

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    914 views6 pages

    Resume

    Uploaded by

    johnseq
    Resume for John Sequeira, Database Developer and Technical Lead for Business Intelligence, Data Warehousing, Quickbase, ASP.NET, SQL Server, CRM

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 6
    At a glance
    Powered by AI
    John Sequeira has over two decades of experience in web development, database engineering, and IT consulting. He has expertise in a wide range of technologies including Microsoft, Oracle, SQL, PHP, and more. He also has experience designing and implementing e-commerce, CRM, and data warehousing systems.

    John Sequeira has a Bachelor's degree in Applied Physics from Cornell University. He also attended the University of California's Physics Ph.D. program before beginning his career in IT consulting.

    John Sequeira has expertise in areas such as data warehousing, decision support, CRM, e-commerce, content management, digital asset management, mobile systems, web farms, search engine optimization, and more.

    http://www.jsequeira.

    com
    johnseq@pobox.com
    617-674-7543

    John Sequeira designs and develops all aspects of data driven, e-commerce web sites,
    from high level business requirements gathering to low level database and web site
    performance tuning. He has extensive experience in database engineering and fault
    tolerant e-commerce architectures. He has a keen appreciation for business needs in
    addition to technological requirements, and a rare ability to deliver pragmatic solutions
    that fit with the client's infrastructure, skills, timeframe and budget.

    John has over two decades of programming experience. Current expertise includes:

    Microsoft Unix/Linux Cross-Platform


    MSSQL2005/2008 Oracle 11g/PL-SQL Advanced Javascript/jQuery
    SSIS/OLAP/MDX Apache 1.x, 2.x Perl, mod_perl, Tcl, PHP
    SSRS/Crystal Reports Linux/Bash Java/JSP
    ASP/ASP.NET Rewrite,proxy modules LexisNexis Interaction CRM
    LINQ, TFS Sybase ASE XML/XSLT
    ASP.NET MVC MySQL, SugarCRM Postgresql, Quickbase

    He has a Bachelor's degree in Applied Physics from Cornell University and attended the
    University of California's Physics Ph.D. program before beginning a career in IT
    consulting. He has completed advanced training in database technology and has worked
    with SQL Server and Oracle platforms. He has been involved in several books in Web
    and Database technology; please see Publications for more details.

    He has designed and implemented dozens of complex web technology projects in the
    following areas:

    • data warehousing/OLAP • decision support


    • CRM • e-commerce
    • content management • digital asset management
    • mobile systems/wireless • high availability web farms
    • search engine optimization • ajax/mashups
    Major clients include:

    • Microsoft • Fidelity Ventures


    • Weber Shandwick • Ropes and Gray
    • Simon and Schuster • Cision
    • SC Johnson • Trust for Public Land
    • Cushman and Wakefield • Adteractive

    * RECENT PROJECTS

    ETL Developer

    2008
    Downtown Boston Law Firm

    Sole developer of CRM/Accounting system data integration project using Microsoft ETL
    toolset ( SSIS/SQL 2005/ASP.NET). Project included data dictionary reverse
    engineering, automated load process, and web-based change reporting.

    CRM Architect

    2007-2008
    NYC-based Real Estate Firm

    Worked as lead technical architect on global CRM deployment to 12,000 users.


    Responsibilities included requirements gathering and documentation, design of data
    integration topology between CRM, Sharepoint and accounting system, lead team of 6
    consultants and in-house staff to implement large-scale data migration, and customization
    of CRM platform. All technologies on Microsoft platform ( ASP.NET, SQL Server,
    SSIS)

    Quickbase/Data Integration

    2003-Present
    Trust For Public Land

    Worked on web integration of Quickbase-hosted data for a variety of non-profit websites


    and projects including
    • www.conservationalmanac.org
    • www.conservationcampaign.org
    • www.tpl.org
    • communitypreservation.org

    The website integration/mashup code delivered for these projects used the Quickbase
    Javascript API, the .NET API, and Perl API, and direct HTTP access. The functionality
    included straightforward table embedding as well as CSS/HTML theming using both
    server-side code and Javascript/jQuery. Third-party geocoding mashups were
    implemented with Google Docs and Google Maps. Additionally implemented special
    custom-branded version of Quickbase.com website so that website visitors could use
    Quickbase navigation tools without reimplementing functionality on third-party website.

    .NET/C#/ASP.NET Lead Developer

    2008-Present
    Swimfish Consulting

    Lead team developing financial-services-targeted sales-force-automation extension to


    CRM product Lexis-Nexis InterAction using ASP.NET. Data sources included XML-
    over-HTTP as well as SQL Server. Implemented heterogeneous (dataset,SQL,XML) data
    access using LINQ, heavy use of client side processing with jQuery.

    CRM Technical Lead

    2007
    Loan Origination Firm

    Lead architect for CRM platform selection on 2,500 user SugarCRM implementation.
    Initial responsibilities included requirements gathering, RFP preparation, vendor due
    diligence, RFP response scoring, and documentation. Once platform was chosen, lead
    data integration efforts between CRM system and Oracle 10g-based accounting systems
    using pl/sql packages.

    ETL/BI Developer

    2005-2007
    Supply Chain Startup

    Database developer of medical inventory management ASP's hosted analytics


    application, including design of data model, data aggregation architecture, ETL process
    and reporting framework.

    Technologies include ASP.NET, SQL Server, OLAP Server

    ENTERPRISE CONTENT MANAGEMENT

    October 2002-2003
    Fidelity Investments
    Swimfish Consulting – http://www.swimfish.com

    Lead architect for visioning and web strategy engagement for Human Resources unit of
    Fortune 500 financial services firm. Project involved gathering business and
    technical requirements for short and long term development plan by
    interviewing both business groups and technical staff within company.
    Responsible for assessing architectural implications of business needs and
    reconciling those with existing technical infrastructure within company. Phase 2
    of project involves implementation of development roadmap using the
    Interwoven Teamsite Content Management System.

    ARCHITECTURAL REVIEW/EXTRANET DEVELOPMENT

    March 2002-2004
    Adteractive

    Initial engagement involved code review and write-up of a plan for achieving fault
    tolerance using mirrored data centers and SQL Server log shipping. Also included
    assessing the suitability of using MSSQL Server OLAP Services as a reporting platform
    for clickstream warehousing application.

    The project evolved into general purpose Transact-SQL query performance tuning as
    well as new web application development for an extranet reporting application using
    ASP/PerlScript.

    ENTERPRISE APPLICATION INTEGRATION (EAI)

    February 2002-2003
    Financial Services Company

    Lead architect/developer on application integration project linking NetAge CRM package


    with Intraspect KM application. Implemented single-signon using Apache/mod_perl
    rewriting reverse proxy, and 2-way data synchronization between Oracle and MS SQL
    Server 2000 systems.

    CLICKSTREAM DATA WAREHOUSING


    March 2001-July 2001
    The Princeton Review - http:// www.review.com

    Sole developer of clickstream analytic data warehousing application for high-traffic (50M
    hits/mo) web site implemented on Microsoft Analysis Services and SQL Server 2000.
    Application consisted of significant extraction, transform, and load (ETL) processes
    written in Perl, VBS, and Data Transformation Services (DTS). Wrote object oriented
    middle tier which transformed MDX queries into XML-based WDDX packets for display
    by Cold Fusion user interface.

    Project was completed to spec and ahead of schedule, with zero critical defects reported
    by QA department. Responsibilities were then expanded to include refactoring a targeted
    email marketing application and general web site/SQL performance tuning. After
    reviewing web site architecture for scalability issues, recommended and prototyped an
    Edge-Side Include (ESI) caching reverse proxy using an Apache/mod_perl to cache as
    much of the site's dynamic content as possible.

    Engagement included significant knowledge transfer (4+ weeks) consisting of both


    informal mentoring, professional documentation for all custom software components. In
    addition, conducted classroom-based training on Microsoft data warehouse technology
    and methods for company's entire development staff.

    ENTERPRISE APPLICATION INTEGRATION (EAI)

    August 2001
    Swimfish Consulting – www.swimfish.com/

    Conducted feasibility study concerning integration of Siebel SFA platform and Intraspect
    document management solution for large financial services company. Study involved
    reviewing documentation and interviewing vendor engineering staff to deliver vision
    document of potential application integration scenarios. 30+ page deliverable included
    deployment diagrams and project estimates, and considered the impact of corporate
    security policies, directory integration, and replication topologies.

    DATA WAREHOUSING

    Summer 1998 - Spring 2000


    Gamma Software - http://www.gammasoftware.com

    Separate projects involved implementing data warehousing database design and intranet
    reporting application for telecom infrastructure provider and venture capital management
    consulting firm. System architecture included both relational and online analytic
    processing components using Microsoft SQL & OLAP Servers.

    * EDUCATION
    1992 B.S., School of Applied & Engineering Physics, Cornell University, Ithaca NY

    1993-1994 Ph.D. candidate, Department of Physics University of California, Santa


    Barbara

    You might also like