Ru-Fang Tan Email & Phone Number

Plano, Texas

Plano, TX

• Using programming and analytical tools including SQL, Teradata, GitHub, JIRA tool to develop and maintain SQL scripts for regular processes.
• Work on Home Loans BI Stress Test Reporting Team as a DA (Data Analyst) for loading key data sources and executing the process with SQL skills.
• Work on reconciliation of FR Y-14M (Monthly Capital Assessments and Stress Testing Forms) reports and the FR-Y9C report using advanced SQL and Excel skills.
• Performed Validation for historical data loading, identified data mismatch and provided the analysis for review.
• Involved in understanding new business requirements, worked enhancements for existing reports and performed UAT testing.
• Prevention of faults by inspecting and testing the process and result (QA). Communicate and present data to management for quality control.

• Research and develop the latest computer software skill for IT department. Job duties include writing prototype and provide solutions for other groups in Penney’s IT department. The example projects as following:
• JCPenney B2B Gateway (Administrator of BizManager BizLink)
• Use Invois applications to exchange files between business partners. Inovis BizManager BizLink is a Java application that provides secure exchange of business documents (EDI, XML, and flat files) over the Internet or.
• Business Continuance Plan (BCP) – for B2B Gateway
• The objective of this Recovery Plan is to facilitate and assist JCPenney IT in resuming critical operations, processes and functions, its technology, and support operations in a timely and organized manner to continue.
• XML files Transfer between two partners

Developed commercial payroll system using C/C++.Job duties include developing code to create and modify company, department, and employee information, process payroll calculation and print employees' paycheck information, and generate various federal, state and local tax forms. Maintain windows-based payroll programs using Borland C/C++ for Tax update.

Developed Payroll Tax and Year End Tax systems using Clipper.Generated various customized payroll reports and forms based on different companies' requests. The job also included researching TurboTax programs and working with their developers to create new programs. Wrote programs to handle year-end processing and print W2 forms.