GEORGE LEUNG

*** **** *** ****** *******: 917-***-****

Ramsey, New Jersey 07446 E-mail: admhcb@r.postjobfree.com

Summary

A Senior Database Developer with extensive database development experience in design, development, performance and tuning, optimization and data modeling. Highly organized with strong attention to detail, forward thinking, well organized with excellent communication skills. Possesses drive with motivation, to be a self-starter, which anticipates problems and takes a heavily proactive approach to responsibilities. Through my experience working in the Top financial firms in the New York Area, I have collaborated my business knowledge with multi-asset classes, such as Equity, Derivatives, Fixed Income, Futures/Options, Risk Management. Projects have been completed successfully while keeping myself hands-on in the development.

Technical

Databases: Sybase 12.5/15.3, Sybase IQ, SQL Server 2005/2008/2012/2016, MySQL, MariaDB

Languages: T-SQL PL/SQL, Perl 5,TCL, C#, Unix Shell, XML, Java

Operating Systems: Unix, Windows

Software: Crystal Report, Microsoft Office, MS Project, Business Objects, Tableau

Experience

Mizuho Group, Remote June 2020 – Present

Independent Consultant – Senior Database Developer

Full development life cycle, includes gathering requirements from stakeholders, development, testing, release to production and technical documentation

Develop SQL Server Stored Procedures to Load Regulatory Reporting, 2052a data from various source systems

Develop Tidal Agent jobs to run Daily/Weekly/Monthly jobs

Performance and Tuning for slow running stored procedures using methods Query Analyzer, Execution Plans, SQL Hint

Modify existing SSIS packages when feed requirement changes

Git/Bit Bucket for Source Control and branching

Daily Scrum/Agile environment

Radiology Partners, Remote April 2019 – March 2020

Independent Consultant – Senior Database Developer

Full development life cycle, includes gathering requirements from stakeholders, development, testing, release to production and technical documentation

Develop SQL Server Stored Procedures to Load Clinical and Billing data from various source systems

Develop SQL Agent jobs to run Daily/Weekly/Monthly jobs

Ensure that all Stored Procedures are in a Standardize format to be able to debug and capture failures for each step in a error log table.

Create adhoc reports using advanced SQL

Modify existing SSIS packages when feed requirement changes

Create custom reports for Finance Data Warehouse to be used to compare Imagine Intelligence Data with Data Warehouse

Perform root cause analysis on internal and external data and processes to answer specific business questions and find opportunities for improvement

Working with partners including the Architecture, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs

Collaborating with other teams to design, develop data tools that support both operations and data application use cases

Building processes supporting data transformation, data structures, metadata, dependency and workload management

Investigate missing charges/transactions from Imagine Intelligence and Data Warehouse

Performance and Tuning for slow running stored procedures using methods Query Analyzer, Execution Plans, SQL Hint

Create dynamic SQL in stored procedures driven my data in tables.

Manage deployment process during release cycles

Git/Bit Bucket for Source Control and branching to develop, release, hotfix, master

Beam Living, New York, New York April 2018 – April 2019

Independent Consultant – Database Development Lead

Manage database team for Real Estate properties for Stuyvesant Town, Peter Cooper Village and Kips Bay

Develop Stored Procedure for SSIS package to Extract Transform and Load feeds from source database to our Production databases

Create and use Temporal tables to store historical data in SQL Server 2016

Develop Complex queries n Stored Procedures using SQL Server to manage Property data which includes Property, Building, Units, Residents, Building Amenities, Current Unit Rate

Performance and Tuning for slow running stored procedures using methods Query Analyzer, Execution Plans, SQL Hint

Create dynamic SQL in stored procedures driven my data in tables.

Manage deployment process during release cycles

Use GIT/Bit Bucket for Source Control and branching to develop, release, hotfix, master

TradingScreen, New York, New York September 2016 – March 2018

Consultant – Database Management Lead

Working within the Data content team to convert and migrate from our legacy Sybase Database to MySQL (MariaDB).

Migration from MySQL to SQL Server 2016

Working heavily with temporal tables to compare historical data

Develop Complex queries n Stored Procedures using SQL Server

Create dynamic SQL in stored procedures driven my data in tables.

As part of migration, my role is to reconcile the data from our legacy platform to our new platform, by creating comparison report using SQL and Excel so that both the Global Analyst team and myself to review.

Configure and onboard new exchanges for all or specific asset classes that we did not support at the time, but our clients would like to trade on and create feeds by using SIX Telekurs. Bloomberg, Reuter and IDC feeds to include on our platform.

Database development includes, complex SQL queries, Performance & Tuning and Optimization.

Auto-Generate RICs/Bloomberg/Bloomberg Composites using stored procedures

Support our OMS system when Global Client Support(GCS) and/or our Global Data Analysts with clients has issues with data

Work directly with Analysts in developing new requirements for TradingScreen OMS

Develop Data Model using Enterprise Architect.

Provide code review to all database related development prior to deployment

Define SQL best practices in development

Use Tableau to generate reports for our Analysts

Use Jira as development tool

Use GIT/Bit Bucket for Source Control and branching to develop, release, hotfix, master

Barclays Capital, New York, New York October 2012 – August 2016

Consultant – Database Management Lead – Central Compliance

Led a team of three developers working on performance management by optimizing existing database.

Trade Surveillance/Compliance Reporting Equities Data Warehouse/Business Intelligence

Data and Business analyst within markets surveillance.

Worked on multiple programs in support of Trade Surveillance capabilities across Markets Surveillance, Information Barrier Surveillance and Retail Surveillances

Re-evaluated existing stored procedures to optimize and tune performance on slow running procedures. Reduced several long running batch jobs from 30 minutes to under 30 seconds

Developed Perl scripts to handle archiving process to reduce data on live database to archive database. Reduced database size to retain only 93 days versus the existing 15 months. This will reduce the database size from 600GB to 150GB

Code review of all stored procedures from developers to ensure peak performance prior to release into production.

Reorganized all Autosys jobs so that there is less contention against the database

Sybase Exit project, including migrating Sybase to SQL Server 2008. Rewrote Sybase Stored procedures to SQL Server Stored procedures.

Migrated data from Sybase to SQL Server

Developed manual ETL Process using Unix Shell Scripts, Perl, BCP to load data from flat files to staging DB and created stored procedures to load data from staging tables to permanent tables

Processed data feeds using Workflow Manager in Informatica 9.1

Created new stored procedures to monitor processes and to determine contention on the server.

JP Morgan Chase & Co., New York, New York May 2010 – October 2012

Senior Database Developer Lead

Developed and maintained product implementations to functional and technical specifications.

Worked within a defined quality assurance process, which includes Unit test, UAT and regression testing to develop complex test plans so that changes made did not cause problems to the existing system.

Investigated, debugged and resolved issues with pricing derivative products.

Liaised with Traders, Developers and Business Analysts globally to understand requirements and identify technical solutions for Equity, Derivatives and Market Risk.

Develop complex stored procedures for Equity Derivatives Pricing and Risk management platform

Performance Management and Tuning database for optimal performance

Optimize slow running stored procedures

Create UNIX shell and PERL scripts to load data from raw files into the databases

Developed PERL scripts for pattern matching and for use of regular expression

Peer review all stored procedure before releasing to Production

Develop user interface using C# to Quantitative team view

Lead PWG(Peer Work Group) across multiple teams in discussing open issues and resolutions

Light Java and C# development and maintenance on existing scripts for QLIB (Quantitative Libraries)

SCRUM – Agile Development

Environment: Sybase 12.5/15, Unix, XML, Java, C#

Innovest Systems, LLC, New York, New York August 2008 – September 2009

Database Development/Content Management (Consultant)

Convert client data to be compatible to our database using SQL Server 2005 and Sybase 15

Develop Sybase and SQL Server stored procedures for retrieving data to the user Interface.

Data analysis – compared data and reconcile reports using Crystal Reports and Excel.

Created mapping documents to transform clients raw data to Sybase and SQL Server.

Create Customized Client Statements and Invoices using Crystal Reports

Create stored procedures and functions to be used in Crystal Reports

Modify existing XSL scripts to enhance Innovest’s Accounting Software.

Create XML script for scheduling tasks such as file processing, scheduled reports.

Create XML scripts to create new fields to Innovest’s UI.

Performance and Tuning to new and existing Sybase and SQL Server Stored Procedures.

Environment: Sybase 15, SQL Server 2005, SQL Server Management, Crystal Reports 9, XSL, XML

Legg Mason, Stamford, Connecticut April 2006 – August 2008

Project Leader - Database Development/Data Management (Consultant)

Managed a CRM system called Fund.Space used by our Sales Team

Work with business groups in design and implementation of new reports in Crystal Reports

Review new requirements/specifications with the business and make recommendations on design and layout for new projects

Support developers in designing new requirements from Business and Sales desk

Development on mPlatform/mWholesaler for CRM applications on Blackberry.

Communicate with Vendor SalesPage on enhancement of Fund.Space application

Senior Database Programmer

Lead developer in design and migration of CRM and Sales Reporting system

Migration CRM from Unitrac to FundSpace, which includes designing new database from Sybase 15 to SQL Server 2005 (Full conversion).

Create Adhoc queries and stored procedures

Performance and tuning and optimization

Develop Sybase and SQL Server stored procedures for backend reporting

Creates SSIS packages to use as a ETL tool to load data from files

Create reports using SSRS

Work directly with Business Management team to gather and develop requirements

eSpeed, New York, New York January 2005 – April 2006

Senior Database Programmer(Consultant)

Designed and maintained database design for Cantor Market Data in Sybase IQ and Sybase ASE

Create daily trade and tick reports for Fixed Income, specifically for UST,Government bonds by using Sybase, Unix shell and some Perl

Created a data warehouse for our historical treasury data in Sybase IQ

Work closely with business group to create new requirements and specifications on new projects/products.

Support team with all database aspects as in development and educating.

TD Waterhouse Group, Jersey City, NJ July 2004 – January 2005

Senior Database Programmer / Technical Analyst(Consultant)

Support Order Management System(OMS) by analyzing all the SQL Server and Sybase stored procedures and C++ programs to gain full understanding of an order process. This includes routing orders to exchanges, commission charges, order requirements, acknowledgements from the exchanges.

Work with team members to create routers to CBOE, ISE and BRASS exchanges to route FIX messages.

Work closely with business analyst to develop Business Requirement Documents(BRD) for TD Waterhouse new trading feature for Complex Options, such as Butterfly, Spread, Straddles and Buy-Writes.

Create test orders for router certification test.

Develop, maintain and enhance Sybase stored procedures for the OMS system.

Goldman Sachs & Company, New York, NY January 2004 – July 2004

Senior Programmer (Consultant)

Developer/analyst in a distributed system/application development team developing, enhancing, and supporting core fixed income and firm wide client reference data systems.

Successfully managed and executed system enhancement and development projects, while hands-on in programming and production support.

Proactive in anticipating, identifying, and rectifying problems and anomalies.

Act as a liason between business users and the technical staff to develop technical specifications for newly assigned projects and enhancements to the existing system

Creating adhoc reports for users written with Sybase stored procedures.

Create unix shell scripts to create automated processes for data integrity.

Use Autosys to run batch jobs, also include jil scripts.

Lehman Brothers, Jersey City, NJ March 2003 – January 2004

Senior Programmer (Consultant)

Juno Online Services, New York, NY April 2000 – December 2001

Senior Database Developer/Programmer CRM System – Database Technology

Nomura Securities Inc., New York, NY April 1999 – April 2000

Assistant Vice President/Senior Sybase Developer – Risk Management

Bank of New York, New York, NY September 1996 – April 1999

Assistant Treasurer – Investment Technology

Teleport Communications Group, Staten Island, NY August 1994 – September 1996

Programmer Analyst – Technology

Wilco Systems, New York, NY January 1994 – August 1994

Programmer Analyst – Technology

IMS Business Systems, New York, NY January 1993 – December 1993

Systems Engineer – Network Technology

Education

St. Peter’s College Jersey City, New Jersey MBA, International Business/MIS: May 1997

Pace University New York, NY BS, Computer Science/Minor in Math: September 1991

References

Available upon request.

Contact this candidate