Real Estate Management

Weining Wang

** ******* **. **********, ** ****9 / 201-***-**** / *********@*******.***

Summary of Work Experience

Extensive experience in implementing and supporting financial applications in asset management domain

Experienced Business Analyst in fixed income, equity investment and commercial real estate areas

In-depth knowledge of business workflow in financial asset management

Extensive experience in customer facing, results delivery and vendor management

Proven success in planning, managing and implementing life cycle of IT projects

Areas of Expertise

Highly experienced in financial application support II

Experienced IT business analyst

Extensive knowledge in asset management domain

Subject Matter Expert in Commercial Real Estate applications

IT project planning, testing and implementation

Highly Experienced liaison in managing and supporting user groups

SQL query and database management, Business Objects reporting system management

FTP / Fixed connection setup, configuration and troubleshooting

IT disaster recovery planning and conducting

Work Experience:

Hywin US Capital Management, LLC. – New York, NY

IT Manager in Application and System Support 01/2017 – present

Plan and manage to implement IT systems for investment groups, partner with application vendors and service providers, overseeing the system and application implementation, upgrades. Conduct new application development, QA and user testing. Manage the setup of Windows/Linux servers and databases. Manage to setup file transfer and reconciliation processes. Provide support to applications and end users.

New York Life Investments, NYLIM IT – New York, NY

Business Analyst / Sr. Application Support Analyst II 05/2008 – 12/2016

A leading member in Production Support team, as focal point of contact in providing support to financial applications across investment groups (Fix Income; Security Investment; Commercial Real Estate; Private Equity Investment, Alternative Investment, and Financial Operation and Administration).

Led new application implementation, major application upgrades. Led user UAT parallel testing. Designed testing scenarios for major upgrades and application deployment (Geneva System; Blackrock Aladdin; Charles River IMS, InvesTran; YARDI; Salesforce; ARGUS; LMS - Mortgage Loan System; Eagle PACE System; Compass System, SAP Business Objects).

As Business Analyst in analyzing and eliciting business requirements to initiate IT projects for investment groups. Developed business & functional requirements documentations and use cases for project implementation. Designed test plans, scenarios, testing scripts and procedures, led UAT testing processes.

-Managed to initiate, design and implement ‘Cash Manager’ application. The new application standardized and generalized cash transaction processes, consolidated functionalities of legacy systems, enhanced reporting and workflow capabilities.

-Led to implement ‘Mortgage Deal Manage’ application. The new system eliminated excessive document exchange among Commercial Real Estate field offices when underwriting, submitting and closing mortgage loan deals.

-Managed to develop and implemented ‘Document Management’ application. It realized the archiving of bulk mortgage loan documents in electronic version, improved document searching capability, and reduced the storage space.

Analyzed root cause, troubleshoot and resolved application issues escalated from end users.

Liaised between developers and business stake holders for technical solutions.

Used enterprise job scheduling tools (CA D-Series, IBM Streams) to setup batch processes, setup dependencies among processes. Monitored and troubleshoot failures.

Led migration of YARDI, Mortgage Loan Management System (LMS) and commercial property evaluation system (ARGUS) from version to version.

Led implementation of InvesTran for Private Equity Investment group. Setup system structure, database server, application and Web servers. Provided support to user groups using InvesTran. Setup/configure interfaces between InvesTran and data warehouse. Setup batch process and reconciliation.

Led implementation of Advent Geneva system, setup system structure as required. Migrated equity and fixed income security type portfolio and accounts under Geneva framework. Setup and maintain Geneva in-bond, out-bond interfaces. Setup and support recon file transfer and processes. Provided support to users.

As Subject Matter Expert in commercial real estate, worked with business groups in designing data migration, QA testing and verification strategies. Provided support to end users on database migration, batch processing and reporting. Developed reports with Crystal Reports.

Interfaced with development teams and business areas to prepare business contingency scripts for disaster recovery practices.

Maintained and updated application Runbooks as knowledge base for supporting team members and user training.

As security Liaison to carry on MAR/SOX in compliance with information system security standards. Worked with internal and external auditors to analyze security gaps, then imposed security settings to IT systems. Certified users’ access to various systems, prepared reports/evidences for auditing activities.

Interviewed, analyzed, documented then formed project plans for Commercial Real Estate investment group. Troubleshoot root cause of application errors, resolved data processing and reporting issues. Modified and improved data/reporting processes requested by business clients. Provided technical solutions to accommodate new business functions.

Initiated, executed FTP data/file transfer process with transmission team for reconciliation file delivery between business areas and breakage firms/banks. Setup, monitored ACH and NACHA process.

Designed, tested and implemented ACH payment process and application. Provided daily support to the system – troubleshooting the fund transfer errors, modifying stored procedures and system settings to accommodate the change requests from business areas.

New York Life Investments, NYLIM IT – New York, NY

Sr. Associate - System Analyst 05/2001 – 05/2008

Designed and implemented Single Family Pool mortgage loan system for Real Estate group, which is a Web browser based application for Real Estate users to manage residential mortgage loans. Designed, developed tables, views and stored procedures in database.

Managed to set up Commercial Mortgage Loan database. Configuration and data maintenance such as database performance and health monitoring and tuning.

Participated in designing and creation of real estate property management database for property managers to enter, track and run reporting.

Led the designing and implementation of workflow for nightly process, the processes are run on the scheduler every night.

Participated in design of data extracts from Mortgage Loan system to be loaded into data warehouse system.

New York Life Insurance Company, Real Estate Group - New York, NY

System Consultant -> Sr. System analyst -> Director, Systems 05/1996 – 05/2000

Setup and managed MS SQL database servers and Sybase servers. Converted Real Estate Group’s Mortgage Loan Management System running on legacy system to MS SQL server. Worked with management team and application developers to design the database structure in term of business logic.

Planned, designed and setup single network server system to a multi-server environment in facilitating then expanding of business needs. Evaluated, installed and configured application software packages. Provided hardware and software support to various financial investment groups.

Provide daily support to program developers and application users. Configure and troubleshoot network connections. Setup remote connectivity for field offices.

Winterthur Reinsurance Company, System Administration Group - New York, NY

System Consultant, 1993 – 1996

Planned and developed company’s network from single server to multiple server system.

Led to convert company’s financial management and insurance underwriting system from legacy HP 300 system to CICS - a LAN based DBMS.

EDUCATION: Stevens Institute of Technology. Hoboken, NJ

Master of Electronic Engineering

Shanghai University. Shanghai, China

B.S. in Electronic Engineering

COMPUTER SKILLS: MS Office Suit (MS Access, Excel, Word, Power Point, MS Access), MS SQL Server, SharePoint, Biztalk Server, Scheduling Tools, QuickBook, Crystal Reports, Business Objects, Linux, etc.

Contact this candidate