Summary
Overview
Work History
Education
Skills
Database Software
Operating Systems
Database Tools
Applications Tools
Languages
Timeline
Generic

ANDREW ASHER

Summary

Accomplished Senior SQL Server Developer with extensive experience at Signature Bank, specializing in data warehouse design and ETL processes. Proven ability to enhance data quality and streamline operations, leveraging strong problem-solving and communication skills to deliver impactful business intelligence solutions. Expert in SQL Server architecture and data modeling, driving successful project outcomes.

Overview

28
28
years of professional experience

Work History

Senior SQL Server Developer / DBA

Signature Bank / Flagstar Bank
NYC
01.2020 - 04.2025
  • Company Overview: Environment: SQL Server 2017 - 2019, VMS 2019, Tableau.
  • Leaded all aspects of database administration and design for the applications development teams, including data modeling, backups, replication, log shipping and recovery.
  • Designed and implemented a disaster recovery plan.
  • Extensive data warehouse design, modeling and implementation experience Star and Snowflake.
  • Developed parallel ETL processes using SSIS to ensure conformity, compliance with minimal redundancy, translated business rules and functionality requirements into ETL procedures.
  • Managed SSIS packages reside in SQL Server Catalog.
  • Created dynamic process to read files and create table schemas with correct data types on fly using Python.
  • Design and develop the technical/functional specification for ETL development and implement using SSIS. Analyze dependencies for workflow for various ETL processes, handle exception, and maintain logs.
  • Developed SQL Analysis Services (SSAS, extending OLAP Cubes, Dimensions and Data Source Views.
  • Create Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
  • Responsible for project planning, scope management, resource estimation, metrics definition, change control process, define data quality process and standards, verification and validation.
  • Designed, developed, tested and documented hundreds of T-SQL scripts and stored procedures.
  • Environment: SQL Server 2017 - 2019, VMS 2019, Tableau.

Senior SQL Server and Data Warehouse Developer

Moody’s Analytics
NYC
04.2018 - 01.2020
  • Company Overview: Environment: SQL Server 2017 - 2019, Python, Pandas, Power BI Desktop Professional Edition, Tableau 10.
  • Extensive data warehouse design and modeling experience Star and Snowflake.
  • Developed ETL processes using SSIS to ensure conformity, compliance with minimal redundancy, translated business rules and functionality requirements into ETL procedures.
  • Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to various corporate groups accessing the data.
  • 5+ years of experience in Systems Analysis, Design, Development and Implementation of various applications including Web and Client/Server Application development using Microsoft .NET Framework, C#.NET, ASP.NET.
  • Expertise in Visual Studio .Net environment and Microsoft .Net Framework2.0/3.0/3.5/4.0.
  • Created dynamic process to read files and create table schemas with correct data types on fly using Python and Pandas Data Frame solution.
  • Designed and implemented SSAS Cubes across multiple data marts using OLAP methods in Business Object for users to access reporting as it’s needed.
  • Design and develop the technical/functional specification for ETL development and implement using SSIS. Analyze dependencies for workflow for various ETL processes, handle exception, and maintain logs.
  • Designed and built data archiving process for a yearly movement of 1+ billion rows using SSIS (SQL Server.
  • Create Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
  • Responsible for project planning, scope management, resource estimation, metrics definition, change control process, define data quality process and standards, verification and validation.
  • Developed reports using SSRS 2017 - 2019.
  • Designed, developed, tested and documented hundreds of T-SQL scripts and stored procedures.
  • Environment: SQL Server 2017 - 2019, Python, Pandas, Power BI Desktop Professional Edition, Tableau 10.

Lead SQL Server DBA / Developer

EVO Payments and Credit Cards Processing Inc
Melville
07.2014 - 03.2018
  • Company Overview: Environment: SQL Server 2005 / 2008 / 2012 / 2014 / 2016, Tableau 10, Power BI Desktop.
  • Team leader of three data warehouse developers to build enterprise-class level data warehouse platform.
  • Hands-On Data Warehouse developer. Developed an enterprise-class data warehouse solutions more than 60 Terabytes in size, data marts and other business intelligence solutions for corporate and division business leaders.
  • Participate in all phases of the development lifecycle: gathering requirements, analyzing data quality and business rules, dimensional modeling and database architecture, developing Extract-Transform-Load processes using SSIS, and data presentation to the end-user using SSAS OLAP Cube technology.
  • Work with various user groups in designing and developing SSRS Reporting for eSafe Credit Card Processing Platform.
  • Design and implement data warehouse architecture for the corporate circulation data warehouse that became the standard for divisional data warehouses. Subsequent data marts, extracts and reports were sourced from architecture of conformed facts and dimensions.
  • Develop SSIS packages 2012-2016 using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
  • Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
  • Create Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
  • Develop Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and Data Source Views.
  • Extensively involve in the SSAS storage and partitions, aggregations, and calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Involve in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings.
  • Environment: SQL Server 2005 / 2008 / 2012 / 2014 / 2016, Tableau 10, Power BI Desktop.

Senior SQL Server DBA / Developer

VOLT INFORMATION SCIENCES
NYC
07.2001 - 07.2014
  • Company Overview: Environment: SQL Server 2000 / 2005 / 2008 / 2012 / Oracle 9i / 10g, Informatica.
  • Designed and implemented SSAS Cubes across multiple data marts using OLAP methods in Business Object for users to access reporting as it’s needed.
  • Developed ETL using SSIS to ensure conformity, compliance with minimal redundancy, translated business rules and functionality requirements into ETL procedures.
  • Developed complex mappings in Informatica & Datastage to load the data from various sources into the Data Warehouse, using different transformations/ Stages like Joiner, Transformer, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
  • Expertise in tuning existing mappings, identifying and resolving performance bottlenecks at various stages.
  • Developed ETL maps and shell scripts to clean and load data into Data mart.
  • Devised custom Cognos OLAP Cube and associated Cognos reports used by all U.S. branch offices to view up-to-date workload and employee performance statistics. Managed all aspects of requirements definition, documentation, and implementation.
  • Developed ETL scripts to enable daily processing of 8-10 GB data sets into data warehouse.
  • Created and configured SQL Server Analysis Services database which introduced company to a multidimensional tracking of subscriber’s special statistical techniques using SQL and Excel.
  • Developed reports using SSRS 2005 - SSRS 2012. Converted DTS 2000 to SSIS 2005 / 2008 / 2012.
  • Designed and built data archiving process for a yearly movement of 10+ billion rows using SSIS (SQL Server Integration Services), SQL-DMO, DTS (Data Transformation Services) Object Model with COM/COM+ components.
  • Designed, developed, tested and documented hundreds of T-SQL stored procedures, functions, triggers, DTS packages and jobs for enterprise company websites and products.
  • Continual review of SQL (consideration of memory, CPU, I/O, locks and indexes) that negatively impact query-processing time.
  • Assisted fellow database staff and applications staff in development, testing, implementation and maintenance of mainly SQL Server 2000/2005/2008/2012 and .NET software systems.
  • Provided after-hours training seminars teaching standard and advanced SQL Server programming.
  • Environment: SQL Server 2000 / 2005 / 2008 / 2012 / Oracle 9i / 10g, Informatica.

SQL Server Developer

The Princeton Review
NYC
09.2000 - 06.2001
  • Company Overview: Environment: SQL Server 7.0 / 2000.
  • Designed new databases to fulfill business needs and requirements including processes and procedures.
  • Built integration processes for migrating data from Oracle platforms, SQL Server platforms and excel spreadsheets via DTS.
  • Was fully responsible for entire server farms NT Server builds including patches and maintenance; the migration of data through firewalls and of course performance tuning, backups, restores etc…
  • Upgraded over 10 servers from SQL Server 7.0 to 2000 Enterprise and Standard edition.
  • Automated backup and recovery processes throughout the environment.
  • Redesigned databases for E-commerce site, taking searching response time from 18 seconds to 500 ms.
  • Wrote scripts to use BCP to transfer data from other database environments like Oracle.
  • Provided 3 different high availability SQL Server 2 node clustered environments for various applications.
  • Setup and manage transactional replication as high availability solution.
  • Environment: SQL Server 7.0 / 2000.

Senior Programmer / Analyst

Prudential Securities Inc.
NYC
08.1999 - 08.2000
  • Company Overview: Environment: VBScript, JavaScript, XML, Visual Basic 6.0, ASP 2.0, SQL Server 6.5 / 7.0, MTS and IIS 4.0.
  • Worked with ongoing implementation and customization a client / server web system that is enable Financial Advisors to enter orders, see critical client information, track orders status from their desktop, deliver customized data to selected Futures Institutional Clients.
  • The system provides a cost effective, fast and professional way to send data and reports to key clients and it is designed utilize the latest Internet technology, and relies on the Microsoft Internet solution.
  • Security, speed and providing custom information to clients the main key of the system.
  • Participated in developing a Web system using Visual InterDev 6.0 based on Active Server Pages (ASP 2.0).
  • Developed Three-Tier COM and DCOM Object Models using Visual Basic 6.0.
  • Worked on implementation security components using Digital Certificates and Secure Sockets Layer (SSL 3.0).
  • Coded, tested, debugged, implemented and modified different parts of the system.
  • Built front and back end machines using Windows NT Server 4.0, Service Pack 5.0 and customized components.
  • Maintenance, troubleshooting, support for product to clients.
  • Environment: VBScript, JavaScript, XML, Visual Basic 6.0, ASP 2.0, SQL Server 6.5 / 7.0, MTS and IIS 4.0.

Programmer / Analyst

Darby Corporate Solutions (DCS)
09.1997 - 08.1999
  • Company Overview: Customized software and network solutions provider.
  • Worked as a team leader for following Web and Client-Server Applications.
  • Technology: Three-Tier COM and DCOM Object Models.
  • OOP Class and Collection Models.
  • MS Visual Basic 6.0 & ADO 2.0 Object Model.
  • MS VBA 5.0 with Word 97 document templates.
  • MS Visual InterDev 6.0.
  • MS Visual C++ 6.0 with Win32, ATL and MFC.
  • MS TreeView & ListView ActiveX controls.
  • MS TabStrip ActiveX control.
  • Data Dynamics ActiveBar control.
  • Sheridan ListBar ActiveX control.
  • Sheridan DataGrid 4.0 ActiveX control.
  • GreenTree DataMask ActiveX controls.
  • MS Visual Basic 6.0 Data Report.
  • Crystal Reports 7.0 RDC with OLE SubReport object.
  • Crystal Reports 7.0 Report Router model.
  • Crystal Reports 7.0 SmartViewer ActiveX control.
  • Customized software and network solutions provider.

Education

BS - Computer Science

CUNY
NYC
01.1997

Skills

  • SQL Server Architecture
  • DBA
  • Business Intelligence
  • Warehousing tools
  • Unit testing
  • Process documentation
  • Data mapping
  • Data warehouse project development
  • Planning
  • Data modeling
  • Maintenance
  • Enhancements
  • Problem-solving
  • Communication skills
  • Software product development
  • Software application development
  • Collaboration
  • Business requirements analysis
  • System architecture understanding
  • Goal-oriented
  • Data set management

Database Software

  • Microsoft SQL Server 2017-2019
  • SQL Azure
  • MS Access 97-2019
  • Snowflake

Operating Systems

  • MS Windows Server 2019
  • MS Windows 11

Database Tools

  • SQL Server 2000-2019 SSAS (Cube, MDX)
  • SQL Server 2005-2019 SSIS
  • SQL Server 2005-2019 SSRS
  • PowerDesigner 6.1
  • RedGate 7
  • Tableau 10
  • Power BI

Applications Tools

  • MS Visual Studio 97 – 2017
  • MS Internet Information Services 8.5 / 10
  • MS Site Server 3.0 Commerce Edition
  • MS Transaction Server 2.0
  • MS Index Server

Languages

  • T-SQL
  • SQL
  • PL/SQL
  • .NET
  • Visual Basic 6
  • C/C++
  • JavaScript
  • HTML
  • VBScript
  • ActiveX Script

Timeline

Senior SQL Server Developer / DBA

Signature Bank / Flagstar Bank
01.2020 - 04.2025

Senior SQL Server and Data Warehouse Developer

Moody’s Analytics
04.2018 - 01.2020

Lead SQL Server DBA / Developer

EVO Payments and Credit Cards Processing Inc
07.2014 - 03.2018

Senior SQL Server DBA / Developer

VOLT INFORMATION SCIENCES
07.2001 - 07.2014

SQL Server Developer

The Princeton Review
09.2000 - 06.2001

Senior Programmer / Analyst

Prudential Securities Inc.
08.1999 - 08.2000

Programmer / Analyst

Darby Corporate Solutions (DCS)
09.1997 - 08.1999

BS - Computer Science

CUNY

Similar Profiles

  • Nardev Ramsaran

    Nardev RamsaranNardev Ramsaran

    Fraud Review and Control Analyst at Flagstar Bank/Signature BankFraud Review and Control Analyst at Flagstar Bank/Signature Bank

  • Beata Tews

    Beata TewsBeata Tews

    Director of Foreign Exchange Operations – VP at Flagstar Bank, FSB Formerly Signature BankDirector of Foreign Exchange Operations – VP at Flagstar Bank, FSB Formerly Signature Bank

  • Cindy Hidalgo

    Cindy HidalgoCindy Hidalgo

    Commercial Loan Operations Associate at Signature Bank acquired by Flagstar Bank, N.ACommercial Loan Operations Associate at Signature Bank acquired by Flagstar Bank, N.A

  • Pradeep Sathi

    Pradeep SathiPradeep Sathi

    Senior SQL Server and Azure SQL DBA at Arch Capital Services IncSenior SQL Server and Azure SQL DBA at Arch Capital Services Inc

  • Venkata Palety

    Venkata PaletyVenkata Palety

    Sr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems IncSr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems Inc

CREATE PROFILE
ANDREW ASHER