Resume

Sign in

Report Writer/ Data Analyst

Location:
Flower Mound, TX
Posted:
June 17, 2018

Contact this candidate

Resume:

Xijia Ni

**** ******** **., ****** *****, Texas *5022

ac5wne@r.postjobfree.com Phone: 817-***-**** US CITIZEN

CAREER SUMMARY

Ten years of IT experience and One year of Accounting/Finance/Payroll experience, including programming in SQL Server, Crystal Report, Have worked with Microsoft SQL Server 2008, Crystal Reports 2008, Excel 2013. Experienced in SQL, Crystal Report 2008, Visual Home, Excel 2013, Yardi, and Great Plains Dynamics

PROFESSIONAL EXPERIENCE

Dallas Housing Authority – IT Business Report Developer – (2/2006-1/2018)

DHA provides quality, affordable housing to low-income families and individuals through the effective and efficient administration of housing assistance programs

Design, develop, and edit a variety of operational reports using SQL, Crystal Report, Excel and other related

tools for both current housing management system and financial system. Imports and exports data to and from

reports per other user’s requests. Develop the executive decision support system that represents financial data

and housing operation data in real time mode. Provide technical expertise to assist other colleagues for their data

reports and programming services. Analyze data for errors and makes appropriate recommendations and

correction. Demonstrates full life cycle project management methodologies in the implementation, upgrading,

and ongoing support of the financial system. Analyze all Public and Indian Housing-Public Information Center

Data. Assist in data error correction. Performs all supportive duties related to the PIH-PIC submission process.

Post and update documents on the Intranet or Internet. Prepared Ad Hoc reports on the new system as Needed

Dallas Housing Authority – Programmer Analyst (Contractor) – (8/2005-2/2006)

Create financial reports with Crystal Reports, Excel, Microsoft SQL Server 2000, and Microsoft Great Plains Dynamics. Prepared ad hoc reports as needed like Audit of Vendor Payments, Purchasing Payment For Minority Vendor, etc.

FUNimation Entertainment – Financial Analyst/Payroll (Contractor) – (6/2004 – 7/2005)

A brand management company and one of the nation’s largest independent home video entertainment companies.

Created monthly and quarterly sale and royalty reports and special Ad Hoc reports for finance department. Royalty is calculated based on cash received during the period. Often time customers would short pay on invoices, so adjustment are necessary to be done to reflect appropriate units and dollar amount. Activities included the extraction of data from host ERP system for download to the PC. Tools used in analysis and report creation were MS Excel, and specifically VLookup, and PivotTables. Analysis included the correction of any report discrepancies. Maintained/developed tables and queries in MS Excel to report actual monthly and quarterly reports.

EDUCATION

Shanghai Technical University, Shanghai, China – Finance Degree – 1984-1988

Temple College, Temple, TX – Computer Information Degree – 1993-1995

North Lake College, Irving, TX – Associate Accounting Degree – 2003-2004

TECHNICAL SUMMARY

Computer Databases: SQL Server 2008

Computer Languages: SQL, Crystal Reports 2008

Computer Software: Excel 2013, Visual Home, MS Word 2010, Great Plains Dynamics, Yardi, MS Office



Contact this candidate