Sql Server Data

Wen-Yi (Brian) Mei

**** ********* ***** ******, ***** 75252

469-***-**** **********@*****.***

https://www.linkedin.com/in/brian-wenyi-mei-85207348

Summary

Senior programmer and data analysis professional with strong analytical and problem solving skills in delivering value added, cost effective IT solutions.

Extensive experience in all stages of the software development lifecycle (SDLC) across a variety of architectures and platforms.

Strong expertise in re-engineering legacy applications, system migration, and data migration..

Experience in analyzing physical and logical data model, database designs, ETL solutions, business intelligent reporting, developing stored procedures, view, triggers and SQL query optimization.

Technical Skills

Languages/Scripts: Python, JavaScript, HTML, CSS, XML, PowerBuilder, C#, Java, C/C++, awk, shell

Relational Databases: Sybase ASE and SQL anywhere, SQL Server (SSRS, SSIS & SSAS), Oracle, MySQL,

Protocols: TCP/IP, HTTP, HTTPS, FTP, SMTP

Platforms: UNIX/Linux/Solaris, Microsoft Windows

Other tools: Excel, Access, TOAD, PL/SQL, Eclipse, Visual Studio

Experience

Brinks Inc., Coppell, Texas Mar 2012 – Dec 2016

Engineer II (Nwk, Sys, SW)

For global secure logistic business needs, developed, and maintained an in-house project, which includes shipment tracking, inventory management status, calculating costs, generating invoice and providing multiples client with status reports via e-mail or text. This project consisted of using PowerBuilder PFC, Sybase SQL anywhere and SQL Server located in more than 70 sites.

Coordinated a company-wide migration of Window 2003 Server to Window 2012 - includes multiple applications in a large VM global farm (40 countries with 120 servers), improving system maintenance.

Developed a monitoring tool to help process all the services and data transferred between multiple servers via Python, ensure data integrity.

Creating business logic and monitoring procedures in embedded SQL, stored procedures or trigger, ensure data quality, SOX compliance and providing data auditing.

Maintained shipment status web report in Perl and MySQL, ensure customer confidence.

Installed, configured and administration of SQL anywhere database in more than 70 sites globally.

Merrill Lynch, Jersey City, NJ Aug 1994 – Dec 2011

Vice President/Sr. Developer (Dec 2010 – Dec 2011)

For the liquidity risk department, designed, developed and maintained the Collateral Asset Management System (CAMS) that supports both derivative and repo products. It is used to hedge counter-party credit exposure and automates the process of calculating margin calls.

Improved system reliability by reducing system errors by 20%.

Implemented various optimization techniques to reduce the batch processing time by 50%.

Completed the migration of a legacy Sybase/PowerBuilder application to a web application running on .Net Framework (ASP.NET, JavaScript, HTML, CSS, JQuery, AJAX, C#) and SQL Server platform. This helped reduce support and maintenance costs by 50%.

Prepared detailed function specifications and use cases, after discussions with stakeholders and documenting their requirements.

Assistant Vice President (Aug 1994 – Dec 2010)

Migrated collateral management project legacy PowerBuilder application to a Java based web application. Architected MVC design model using JSF framework and iBatis data mapping to separate front controller, business rules, and presentation.

Merrill Lynch (Continued)

Provided day to day support for collateral managers by addressing ad-hoc queries and providing critical real time information, which helping to reduce portfolio risk.

Lead architect in developing the repo margining system, calculating the repo margin calls and providing various forecasting reports and trade detail information, for multiple regions, across various products.

Implemented a real time "straight through process" for automated settlement of security and cash collateral. The architecture involved using IBM MQ Series and message driven EJBs to send real time XML messages to different settlement systems, and processing the acknowledgement messages from the various systems.

Developed a web-based report distribution system that generates and distributes different types of PDF reports on a pre-determined schedule via email and fax. This system helped to reduce operational costs by eliminating the need to manually distribute up to 1500 reports at month end. This system was built using Java, JavaScript, JSP, Servlets and CCS in IBM Web Sphere server.

Integrated various data feeds from different feed providers (trade, price, positions, etc.). Those were used in trade exposure and margin call calculation. Performed optimization of the data load process to reduce batch processing time by 20%.

Implemented and supported commodity deal processes to integrate with the risk exposure calculation engine.

Provided day to day support to collateral managers by addressing ad-hoc queries and providing critical real time information, which helped to reduce portfolio risk.

Used C/C++, Sybase (DB Lib) to develop a series of report for global futures operations and financial group.

Supported very large, complex, and functionally rich PowerBuilder Applications, which included cash ledger, trade receive and delivery, and varied reports in Sybase ASE / Solaris environment.

Worked very extensively in Sybase store procedures, which contained most of the business logic, such as market value calculation for equity, corporate and government bonds, and FX rate exchange conversion.

Previous Experience

Merrill Lynch, Consultant, Somerset, NJ

Developed “Financial Foundation Service Re-architecture” project by using C/C++ X/Motif, and Oracle SQL, Pro* C, PL/SQL, on Sun Solaris 5.2.

AT&T, Consultant, Somerset, NJ

Used C/C++ to implement a components class library to encapsulate the detail and complexity of the X/Xt/Motif widget set and Oracle SQL, Pro*C, PL/SQL to include data formatting and validation rules for a telephone trouble tracking system on Sun Solaris environment.

Price Waterhouse, Consultant, New York City, NY

Developed a DLL library in conjunction with Microsoft Excel SDK library to convert data back and forth between FORTRAN Engine and Front End Regression Analysis applications (Phase II).

Sandvik Process Systems, Programmer Analyst, Totowa, NJ

Implemented a control panel to facilitate a real time package sorting conveyer system in X Window / Motif. Used TCP/IP to connect UNIX and front end system to collect data and messages stored in Informix database for reporting and monitoring.

Price Waterhouse, Programmer Analyst, Morristown, NJ

Developed a TAX Provision system which generated working papers and federal and state corporate income tax schedules. Utilized Microsoft Excel, C and Clipper.

Designed and implemented an APEX (Audit Planning Expeditor) system to increase the efficiency of the audit process by storing, organizing, summarizing, and reporting data to assist the auditor in making judgments.

Designed and implemented a DLL support library for a Regression Analysis statistical modeling system that facilitated analytical reviews. Utilized Microsoft Window SDK, C, FORTRAN, Microsoft Excel and IMSL Statistic Library.

Education

M.S. Computer & Information Science, New Jersey Institute of Technology, Newark, NJ

Contact this candidate