Business Intelligence, ETL, Data Modeling, Database MSQL Development, Data Warehouse, VBScrip & .NET Development, Business Analysis, Project Management
Master of Computer Science & MBA, University of Virginia
B.S., Computer Science, Beijing University
Ullico Inc., Silver Spring, MD 2007 - Present
Senior Information System Analyst
Business Intelligence * Implemented ETL packages to process large data files from the Third Party Administrators (TPAs) with millions of records in SSIS. Worked with Database administors to enhance the performance by adjusting indexes and foreign keys. * Development ETL packages to load real-estate loan origination information from a Windows-based system to a web-based online loan service system. Validated the load with SQL queries and reports. * Created SSIS packages to populate Data Warehouse facts and dimension tables from the Lawson financial system. * Developed and maintained the company financial statements including Balance Sheets and Income Statements and KPI dashboard reports using the BI tool QlikView. * Designed and implemented QlikView data models, loading scripts, and object dimensions and expressions. * Designed and modified both logical and physical data models for an online agent portal system using Erwin. * Developed CastIron orchestrations for daily bank transaction processing. Scheduled and administrated the orchestrations through the use of the web administration console. * Coded the MSSQL stored procedures, and T-SQL routines within or used by SSIS.
Business Analysis & Project Management * Conducted user requirements analysis, documented business and function requirements. Produced test cases and conducted unit and system tests. * Utilized the principles and methodology of Software Development Life Cycle and Agile Development during the software development and management process. * Managed program source code and documents with Visual SourceSafe.
Software Development * Developed sophisticated VBA programs to allow end users to manage the dimension and rollup information for financial reports. The output from the VBA program was imported into the BI tool. * Designed and developed .Net programs to handle the running and emailing of monthly insurance Inforce, premium and claim reports. * Developed VBScript programs to extract information from QlikView objects through the use of QlikView SDKs. * Coded DOS batch files to allow users to invoke real-time reloading for the Property & Casualty financial reports through a link on the report website.
E-Tech Solutions Inc., Bethesda, MD 1999 - 2007
Data Modeling & Software Development * Modeled the data structure for online employee self-service website including personal information, employment, benefits enrollment, and performance appraisal information. * Designed and developed a web-based benefits enrollment and performance management systems using Visual Studio, VB.NET, XML, SQL Server and Stored Procedures. Served as the system architect and lead developer. The system was used by a non-profit organization with over 900 employees. * Developed and maintained an employee recruiting system for a public relations firm with 400 employees. The system was developed with PHP and MySQL under Linux.
System Administration * Conducted system security audits, implemented firewalls, encryption, automatic log scanning tools, and intrusion detection programs. * Automated the jobs for file transmission, log rotation, file backups, database synchronization with Shell Scripts under Linux.
PriceWaterhouseCoopers, L.L.P., Fairfax, VA 1998 - 1999
Government Consulting Group
Senior Associate * Documented requirements and implemented ADP HRIS and Payroll system. Developed reports in MS Access. * Gathered and documented user requirements in an RFP engagement for a