Lei Zhang

Sr. Financial Engineer at Fannie Mae

Location
Washington D.C. Metro Area
Industry
Information Technology and Services
Previous
  1. AMSoft International, Inc.,
  2. Sabre Airline Solutions
Education
  1. Carnegie Mellon University
86connections

Join LinkedIn and access Lei's full profile. It's free!

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you know in common
  • Get introduced
  • Contact Lei directly

Background

Experience

Sr. Financial Engineer

Fannie Mae
– Present (5 years 2 months)Washington D.C. Metro Area

• Communicated with upstream data warehouses and downstream consumers to ensure data consistency within multiple systems.
• Created data validation and transforms rules for profile creation, ensure data profile accurately reflect business requirements.
• Provided support for development team during system design, data analysis and testing. Converted business requirements into design specifications for development team, enable development team to understand and implement the business requirements accurately.
• Converted and communicate data and modeling requirements between data and modeling teams, ensure smooth data flow between systems.
• Created independent testing tools using shell scripts, C++, SAS and PLSQL
• Created amortization schedule for various mortgage product using SAS programming, performed validation to the system output.
• Analyzed business operation of Risk Management Analysis daily data analysis and reporting. Created project scope document, requirement document and process flow.

Sr. Consultant

AMSoft International, Inc.
(4 years 2 months)

Sr. Consultant

Sabre Airline Solutions
(6 years 2 months)

• Provided architectural review and guidance on system and database design for Sabre Streamline suite products. Developed and maintained logical and physical models using Oracle Designer and ERWin.
• Designed and implemented backup/recovery strategy, performed database maintenance and tuning for American Airline Sabre Streamline databases in multiple AA hub airports, which support the daily scheduling for over 15,000 airport ramp and passenger services employees.
• Conducted DBA and System Administrator training class for multiple clients.
• Designed and developed interface programs to exchange data between HR systems, provided various airlines with the ability to synchronize data in multiple systems and across different platforms. The interface programs provided accurate and consistent employee schedule and anomaly updates, which are essential to employee time tracking and pay calculation purpose.
• Created various batch data update processes to support data modification requirements when airlines changed operating process or operational structure.
• Created and tuned Oracle PL/SQL packages for different data processing applications, reduced network IO and provided better application performance.
• Created data import/export utility that allows user to import external data into systems.
• Designed and developed Oracle reports for multiple airline. The reports are widely used for daily resource planning and operation scheduling.

Skills

  • ETL
  • Data Warehouse...
  • Database Management
  • Database Administration
  • Oracle
  • Financial Reporting
  • PL/SQL
  • Unix
  • UNIX Script
  • Abinitio
  • C
  • C++
  • System Testing
  • Test Management
  • Agile Testing
  • Project Planning
  • See 1+  See less

Education

Carnegie Mellon University

Master, MIS

View Lei's full profile to...

  • See who you know in common
  • Get introduced
  • Contact Lei directly

Not the Lei Zhang you're looking for? View more

Insights


People Also Viewed


LinkedIn member directory - Browse members by country

  1. a
  2. b
  3. c
  4. d
  5. e
  6. f
  7. g
  8. h
  9. i
  10. j
  11. k
  12. l
  13. m
  14. n
  15. o
  16. p
  17. q
  18. r
  19. s
  20. t
  21. u
  22. v
  23. w
  24. x
  25. y
  26. z
  27. more