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.• Compare data between MSP servicing system and Stress Test Reports. Analysis the difference and root cause.• Write and maintain complex project documents and record detailed procedures.• Developed Python programs for manipulating the data reading from Teradata and generate reports for data analysis.• Using Python programs to process the large datasets and data files and then convert as useful tables for Data Analysis.

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 an Extranet. • 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 as a viable and stable business entity. • XML files Transfer between two partners• Convert Delimited flat file document to the positional flat file between two business partners through XML using Microsoft BizTalk Server. Send XML files between two partners through HTTP/HTTPS, AIC, etc. with Reliable Messaging Receipt setting. Project involves BizTalk messaging, Active Server Pages, SQL, Visual Basic and Java programming.• Maintain and program Terminal Server (Cash Register) using Microsoft C/C++/C#.• Job duties include developing code to improve the speed of Cash Register.

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 changes. Create setup program for both single and network versions by using InstallShield5. Create database tables, and generating various payroll reports using Visual C/C++ and the Microsoft Access database manager.

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.