• Developed Branch Request Databases (Access/Email automation) for supporting various Tax Information functions related to banking and investment financial products
• Created VBA Automation (Excel and Access) End User Computing products to execute critical analysis and processing functions related to Tax Information Reporting and Vendors
• Create Excel VBA Script for Remote DB manipulation, bulk Printing automation, design vba dashboard, data source internal portals and sites (use dc.js, d3.js and HTML5)
• Support internal and IRS audits, as well as any other special audits
• Participate in self-assessment testing, MCA and SOX controls • Create many Mainframe data transfer, complex query (SQL) and analysis VBA tools for support Tax analysts procedure
• Examine legacy processes and procedures, complete Process Re-engineering, Re-design and Process Automation
• Created and tested(QA) web app (dashboard) back end and front end scripting for Website(PHP, Javascript, Html)