Stephen Lantz Email & Phone Number

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

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

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

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.

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

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

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

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

• 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

• 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