Post Job Free

Resume

Sign in

Sql Server Business Intelligence

Location:
Roslindale, MA
Posted:
December 12, 2023

Contact this candidate

Resume:

ad1w10@r.postjobfree.com

linkedin.com/in/steve-sherman-18890410

STEVE SHERMAN

Greater Boston, MA

617-***-****

Bachelor of Arts, University at Albany, SUNY

Northeastern University

Data Warehousing

ETL/ELT Data Pipelines (Informatica, SQL

Loader)

SQL/PLSQL/TSQL

Data Modeling

Database Design and Administration

Microsoft SQL Server/SQL Server 2019

SQL Server Management Studio (SSMS)

Oracle / TOAD for Oracle / SQL Developer /

SQL*Plus

Linux/Unix Systems

Business Intelligence Tools (Jasper BI,

Tableau)

Data Analysis and Management

Snowflake (AWS)

Git/Bitbucket

Agile Development Methodologies

Cloud Data Platforms (Azure, AWS)

Data Quality Tools (Master Data

Management)

DevOps CI/CD Principles

Software Development Life Cycle (SDLC)

SSIS (SQL Server Integration Service)

Requirements Analysis/Gathering

Software Project Management

Enterprise Architecture

XML

Problem-Solving

Analytical Skills

Communication

Leadership

Teamwork

Customer Service Orientation

Business Analysis

Adaptability

Innovation

Strategic Thinking

Time Management

Stress Tolerance

Information Technology

Microsoft Office Proficiency

As an IT Executive deeply versed in database reliability and data warehouse development, I am recognized for my strategic problem-solving skills and ability to enhance trading platform stability. My career is highlighted by delivering critical SQL and Oracle database solutions that fuel business intelligence and excel in client service delivery. My strategic initiatives have consistently resulted in improved system efficiency, robust security measures, and innovative performance monitoring methods, all articulated in a straightforward, easy-to-understand manner. At the forefront of technical innovation, I bring a meticulous yet precise approach to database architecture, successfully leading high-stakes Microsoft audits and comprehensive data lifecycle management. I've established a track record for optimizing data operations and providing client-centric support, underscored by transparent leadership in transformative projects that ensure smooth technical management and strategic data governance.

Combining a pioneering spirit with tactical execution, I consistently enhance operational workflows, elevate data integrity, and empower decision-making—always with an eye toward clear, accessible communication. I am ready to bring a relentless drive and profound technical acumen as a pivotal contributor to database and data warehouse advancements, delivering complex, uncomplicated, and easily comprehensible solutions. Strategic Data Solutions Expert

System Reliability Engineering

Data Warehouse Innovation Architect

Performance Optimization Specialist

'Steve embodies the fusion of strategic vision and technical prowess. His commitment to database integrity and keen analytical insights are unmatched, catalyzing significant advancements in our data infrastructure. A maestro of data analytics and an architect of robust reporting systems, Steve has been pivotal in refining operational efficiencies and unlocking new business potentials. His leadership is not just exemplary; it's transformative, steering global teams towards unparalleled success in the complex terrains of database reliability and data warehouse innovation.'

- Excerpt from a recent peer assessment.

Engineered critical solutions for high-impact performance and availability issues within the Vestport1 trading platform, driving database resilience and ensuring seamless client operations.

Orchestrated the advanced implementation of SQL Server SQL Agent jobs, driving index management and statistical operations, propelling system efficiency on SQL2016 and SQL2005 platforms.

Played a strategic role in Microsoft's performance and security audits, leading database view refactoring and establishing fortified security protocols, setting new benchmarks for compliance.

Developed and implemented an intricate job schedule for purging legacy business objects, integral to maintaining database hygiene and ensuring optimal system performance.

Authored sophisticated database health check scripts for preemptive performance management, becoming the standard for early issue identification and mitigation. Provided expert-level database support, employing complex SQL solutions for production challenges, upholding exceptional client satisfaction and business continuity.

Executed ad-hoc queries and data extractions with precision, showcasing exceptional adaptability and skill in meeting a spectrum of project demands. 2021 - 2023 Staff Database Reliability Engineer

Vestmark, Inc.

Education

Technical Skills

Soft Skills

Executive Summary

'Visionary Database and Analytics Architect: Blending Passion with Precision for Peak Performance

Professional History

Parkway Soccer. Coach/Instructor

Led the evolution of a sophisticated payor data warehouse, leveraging Oracle PL/SQL mastery to craft reporting solutions, empowering client-driven decisions. Translated intricate client reporting requests into strategic insights and actionable report designs, bridging the gap between data complexity and business intelligence.

Pioneered optimization of report queries and data warehouse load procedures, significantly reducing response times and streamlining user experiences. Forwarded the data warehouse evolution, ensuring robust infrastructure and agile responsiveness to dynamic business needs and client services. Directed the data modeling and administration of over 500 SQL Server and Oracle databases, catalyzing enterprise-wide enhancements and setting industry-leading data governance standards.

Delivered high-caliber application support, formulating complex SQL and PL/SQL solutions markedly refining data reporting and extraction processes. Initiated and perfected custom scripts for data quality management, maintaining the integrity of client databases through meticulous scrubbing and updates. Innovated and refined SQL queries and views, utilizing cutting-edge tools for performance, and improving system response, and search functionalities. Revolutionized Fidelity Investments' Equity Investment Management Technology, creating T-SQL and PL/SQL stored procedures that facilitated sophisticated quantitative analysis.

Directed J2EE web portal projects, elevating user experience for the Massachusetts Executive Office of Health and Human Services through strategic interface enhancements.

Commanded QA operations and test cycle coordination, fostering robust data processing environments for top-tier financial services firms. Orchestrated QA strategies for JP Morgan Chase, driving robust stress and load testing operations for high-value client/server applications. 2020 - 2021 Senior Reporting Analyst and Data Warehouse Developer HealthEdge

2010 - 2020 Database Developer, DBA, ETL Developer, Support Developer Broadridge

2006 - 2010 Database Developer

Fidelity Investments / Veritude

2006 - 2006 Senior Analyst/Project Lead/QA Analyst CGI-AMS

2003 - 2006 Senior Project Manager/QA Lead Analyst/Database Developer/Systems Analyst

Ciber Global / HTC Global Services

2000 - 2003 Senior Project Manager/Database Developer/QA Project Manager/Systems Analyst

Ajilon / LHH Recruitment Solutions

Volunteer



Contact this candidate