email@example.com Phone: 817-***-**** US CITIZEN
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
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.
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
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