Stephen Lantz

Stephen Lantz Email and Phone Number

Senior Database Developer at Blueport Commerce @ Blueport Commerce
Stephen Lantz's Location
Wells, Maine, United States, United States
About Stephen Lantz

Lead engineer with 20 years designing & developing enterprise scalable database-driven software solutions. Articulate technical leader with expertise in mentoring other developers with full Scrum Agile methodology. Certified ScrumAlliance ScrumMaster. Creative problem solver with ability to rapidly analyze business needs, providing balanced and appropriate solutions to both strategic and tactical enterprise challenges.Specialties: SQL Server 8-15.0, PostgreSQL 9.5+, GCP, Advanced TSQL/PLpgSQL Development, Complex Query and Index Optimization, Profiler and Execution Plan Analysis, Triggers and Message Queues, SSIS, SSRS, SQL Agent Job scripting, Database Deployment Methodologies, Star/Snowflake EDW, C#, .NET Core, MVC, ADO.NET, Golang, React, JavaScript, Node.js, jQuery/Ajax, GoCD, TFS/VS, GitHub, GitLab, Jira, Docker, Test Driven Design

Stephen Lantz's Current Company Details
Blueport Commerce

Blueport Commerce

View
Senior Database Developer at Blueport Commerce
Stephen Lantz Work Experience Details
  • Blueport Commerce
    Senior Database Developer
    Blueport Commerce Nov 2020 - Present
    Boston, Ma, Us
    • Develop, maintain, optimize and troubleshoot GCP PostgreSQL and heterogeneous source TSQL ETL• On team responsible for maintaining high volume live retail commerce websites• Automated data IO pipelines via intricately layered SQL Agent Job schedules• Execution plan analysis for query plan and index optimization• Data Transformation and IO in SSIS and PowerShell• Centralizing and streamlining new retailer on-boarding implementation• Supporting and mentoring junior development efforts• Cross functional collaboration across teams and departments
  • Arrowstreet Capital
    Senior Application Developer
    Arrowstreet Capital Aug 2016 - Oct 2020
    Boston, Ma, Us
    • Implement complex rules-based data normalization solutions to support continuous financial trading decisions• Develop advanced TSQL and C# with mastered toolset use (SSMS, Visual Studio, TFS, Release Management, etc.)• Spearhead initiative building .NET CORE MVC React Database Application for Research Business Users• Innovate high performance C# CLR procedures to clean/build financial signal data from heterogeneous sources• Create new reports and enhance existing reports using custom HTML generation via CLR procedures• Coordinate test plan development with QA team and rapidly resolve any issues identified during testing• Coordinate Production software releases with Operations team• Use JIRA and TFS for source control and change tracking
  • Warner Bros. Games
    Senior Database Developer
    Warner Bros. Games Mar 2014 - Jul 2016
    Burbank, Ca, Us
    • High transaction OLTP database development in SQL Server 2008 and PostgreSQL• Golang service development experience, Docker container/image use, and GoCD pipeline development• Lead contributor in database design, procedural code development, and performance tuning• Work closely with other key leads in Agile development context to steer and advise on physical data models• Deliver core database components with an emphasis on Identity Authentication and e-Commerce systems• Daily development of advanced stored procedures, functions, triggers in high volume enterprise systems• Regularly developed in PostgreSQL and Java while prototyping platform build concepts• Independent problem solver while working collaboratively with other teams to define best practices• Create and maintain Atlassian Confluence documentation
  • Blacksmith Applications
    Senior Sql Developer
    Blacksmith Applications Apr 2011 - Feb 2014
    Lawrence, Ma, Us
    • Design and development of large scale SSIS solutions leveraging advanced TSQL business logic.• Database performance tuning and index/execution plan optimization.• Load-balancing and disaster recovery planning.• Mentor junior developers and work with business analysts for successful solutions.• Deployment and support of database applications through full SDLC.
  • Igt
    Senior Software Engineer
    Igt May 2008 - Mar 2011
    London, Gb
    • Create, modify and maintain complex business logic with advanced TSQL and C#• Frequent stored procedure development with database index tuning• SSIS ETL development and support for SQL warehouse groups• SSRS procedure and report development, deployment and support• Perform technical lead activities and take mentor role for junior and mid-level developers• Design, develop, test and document enterprise critical platform provisioning software• Provide technical expertise to produce OOD specifications from internal requests• Maintain, collaborate, track and build within TFS software development environment
  • Qinetiq
    Database Systems Integration And Etl Apogen Technologies Consultant
    Qinetiq Oct 2007 - Mar 2008
    Farnborough, Hampshire, Gb
    • Lead engineer in DTS package migration to SSIS• Oracle 9i development for Production Crystal Reports• Provide regular status presentations and needs analysis for key personnel• Author and regularly generate SQL Server production Reporting Services reports• Perform essential stored procedure and VB code enhancement to payroll time keeping system• Technical resource for Lead Developers on SQL Server and Office Web Components
  • Vericore, Llc
    Senior Technology Officer
    Vericore, Llc Sep 2002 - Sep 2007
    Us
    • Lead architect and developer of innovative enterprise CRM software system used by 50+ personnel• Model, design, develop and maintain highly normalized (6NF) Production Databases• Strong experience in Hierarchical Data Structures and Dynamic GUI Generation• Extensive experience in application testing and database performance tuning
  • Apps4Biz
    Senior Software Developer
    Apps4Biz Aug 1999 - Aug 2002
    Au
    • Worked closely with Architect as lead developer in building manufacturing ERP/MRP distributed web application• Experience includes advanced OOD, complex COM object development, MTS implementation and debugging• Designed, developed and maintained SQL Server 7.0/2000 tables, stored procedures, functions and triggers• Designed, developed and tested comprehensive database reverse engineering utility• Drove refactor initiative of MS Access migration to SQL Server• Experience in setting up company network on NT 4.0 Servers
  • The Groden Center
    Mis/Cis Technical Architect And Developer
    The Groden Center Sep 1997 - Nov 1999
    • Architect and developer of client-server MIS/CIS for non-profit organization• MIS in use by 50+ personnel in administrative, management and clinical disciplines• Managed ongoing development and enhancements, security and workstation setup• System included many clinical tools for analysis and behavioral data reporting as well as full MIS function• Guide key stakeholders through all phases of software development and release processes
  • The Groden Center
    Program Evaluator & Clinical Group Trainer
    The Groden Center Nov 1995 - Aug 1997
    • Conducted formal clinical trainings for groups of 20+ personnel• Responsible for enterprise work flow analysis, performance improvement and quality assurance• Produced database driven annual reports via all institutional outcome indicators• Developed with Access and Excel 8.0 to automate sophisticated clinical/statistical processes for psychologists• FileMaker Pro projects included complex group scheduling application and document inventory database

Stephen Lantz Skills

T Sql Ssis C# Javascript Ssrs Microsoft Sql Server Sql Software Development Object Oriented Design Oracle Sdlc Databases Vb.net Transact Sql

Stephen Lantz Education Details

  • Clark University
    Clark University
    Computer Science (Concentration)

Frequently Asked Questions about Stephen Lantz

What company does Stephen Lantz work for?

Stephen Lantz works for Blueport Commerce

What is Stephen Lantz's role at the current company?

Stephen Lantz's current role is Senior Database Developer at Blueport Commerce.

What is Stephen Lantz's email address?

Stephen Lantz's email address is st****@****ail.com

What is Stephen Lantz's direct phone number?

Stephen Lantz's direct phone number is +170227*****

What schools did Stephen Lantz attend?

Stephen Lantz attended Clark University.

What skills is Stephen Lantz known for?

Stephen Lantz has skills like T Sql, Ssis, C#, Javascript, Ssrs, Microsoft Sql Server, Sql, Software Development, Object Oriented Design, Oracle, Sdlc, Databases.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.