Ray Hill

New York, New York 917-***-**** adj021@r.postjobfree.com

SENIOR SQL DATABASE / REPORTING SPECIALIST

Developer in Financial Services

Senior Database Specialist using Microsoft SQL Server in the design and implementation of SQL Server databases. Wrote extensive stored procedures using Transact SQL to manipulate the data according to specifications in producing business user reports. Experienced with database design, data migration and transformation. Skilled in migrating from Microsoft Access to SQL Server, query tuning and performance optimization. Proven ability to successfully manage full lifecycles of large, complex schemas. Collaborative style relating well with both the business users and management in getting the job done.

Technical Proficiencies

Database Systems: MS SQL Server2005/2008/2012, MS SQL Server Management Studio, Oracle PL/SQL, PostgreSQL, Microsoft Access, Sybase, DB2

Programming: Transact SQL, VB/VBA, Java, Eclipse, COBOL/CICS, Assembler

Reporting Tools: BIRT (Business Intelligence Reporting Tool), Crystal Reports

Operating Systems: MS Windows Server 64 bit, 3270 IBM Mainframe

Core Competencies

Expert in Stored Procedure Coding/Data Analysis/Reporting, Data Migration-Transformation,

Query Tuning-Performance. Extensive knowledge of Brokerage/Banking Systems

Technical Experience

ABN AMRO Inc., New York, New York 2010 – 2017

VP - SQL Server Database and Reporting Specialist

Supported 2 business lines – Global Markets and Energy/Commerce/Transportation(ECT). Recruited to start-up a new Database/Reporting system from scratch after merger of Fortis Bank into ABN AMRO Bank.

Architected the infrastructure environment for database/reporting system.

Developed reporting to be able to bring in and track new products i.e. Icestar, generating product revenue and enhanced the product lisitngs for the company.

Migrated Microsoft Access system into a SQL Server/Stored Procedure/BIRT reporting platform.

Collaborated directly with project managers and business users of Global Markets and ECT business lines.

Wrote reconciliation processes for the Finance and Operations areas providing more efficiency, speed and assured compliance.

Partnered with Broadridge suite of 10 data files and corresponding DB definitions for market data.

Technical Environment Included: MS SQL Server 2008/2012, BIRT reporting, Crystal reporting, Microsoft Access 2011, VBA, FTP, SFTP, XFB, NDM

BNYMELLON Inc., New York, New York 1998- 2010

VP - Project Manager/Systems Analyst/Developer 2004 – 2010

AVP - Project Manager/Systems Analyst/Developer 2000 - 2004

Associate - Systems Analyst/Developer 1998 - 2000

Hired to support IT department and later promoted and selected to directly support the Securities Lending business unit while pursuing a Master’s degree in Banking.

Created Microsoft Access Database with over 300 reports for Securities Lending.

Responsible for daily table loading of 30 file feeds and reporting for 80 users.

Database supported 5 business areas – Loan Traders/Investment Traders/Compliance/Operations and Client Administration.

Wrote non-cash collateral reporting that allowed Securities Lending to do non-cash business.

Developed a Broker Dividend Claim system to receive dividends owed to Securities Lending.

Created Basel2 regulatory reporting systems to reduce capital requirements for BNYMELLON.

Migrated a Swiss Bank Securities Lending Access database reporting system.

Technical Environment Included: Microsoft Access 2000, 3270 IBM Mainframe, Sybase, NDM

GRUNTAL & CO., New York, New York 1997 – 1998

Senior Systems Analyst - Compliance and Legal

Wrote Visual Basic programs and created Microsoft Access tables/queries for the OTC Surveillance area.

Responsible for all design/maintenance of Microsoft Access system.

Set up daily FTP transmission downloads for OTC trade files.

Prior Programming Experience

CITIBANK/SMITH BARNEY: VB and CICS/Cobol mainframe/DB2 1993-1997

DEAN WITTER: CICS/Cobol mainframe/DB2 1991-1993

TIME WARNER: CICS/Cobol mainframe 1989-1991

PAINE WEBBER: Assembler/Cobol mainframe 1986-1989

Education

Masters, Banking, Mercy College 2001

BS. Psychology, Brooklyn College 1981

Training

Diploma, Oracle DBA, The Chubb Institute 2004

Certificate, Crystal Reports 2000

Diploma, Mainframe Assembler & Cobol, NYU 1983

Community Involvement

Coached Basketball for Manhattan Special Olympics 1999-2002

Contact this candidate