State Street Information Technology(ZheJiang) Co., Ltd. is the Chinese branch of State Street Bank located in Hangzhou. My department, the Automation Innovation Lab, focuses on providing automated reporting solutions for the company's global departments, operating in a fully English environment.1. Automated Report Development: Develop automated data reports using tools such as Alteryx (advanced), Power Query (advanced), Power BI (advanced), VBA (proficient), VBS (advanced), Oracle SQL (intermediate), and Python (beginner).2. Using Power Query to process data from two banking systems, performing data cleaning and transformation tasks with a data volume of 8 million rows.3. Client Requirement Analysis and Documentation: Understand client needs and create business analysis documents (BA documents). Capable of fluent communication and interaction with foreign clients in English.4. Upgrading and Modifying Existing VBA Program Logic: Analyze the existing VBA program logic within the company and upgrade or modify the automation tools accordingly.5. Worked on projects involving Python automation of Excel reports.

As a Fortune 500 company,NTTDATA I am working for mainly focus on IT software outsourcing. I am assigned by NTTDATA(China) to another Fortune 500 German automobile manufacturing company(www.zf.com). My major work there is: VBA report automation, data analysis, oracle sql writting, MSACCESS programming and also a few software maintainance jobs.My working environment is full English. I need to communicate with German colleagues and the Romanian team in English to prepare automated data analysis reports and tools. High demands on English. I have been engaged in VBA programming and data analysis for more than 10 years and with rich experience, my current data analyzing level is advanced. I can almost fully meet cliets' needs in Excel VBA data analyzing and reporting. At the same time, I am still learning PowerBI by myself, and have been able to use DAX language to compile data analysis programs.

Work in China Foreign Exchange Trading Center as a senior VBA software engineer sent by Chinasoft International outsourcing company starting from September,2017. I am mainly in change of developing all kinds of trading data analysis reports for the center. The details of the work is to write complicated SQL sentences to extract millions of rows of trading record data from Center Oracle database to Excel, and use VBA skills to analyze data and transform them to required data reports.Starting from 2018, join the Foreign Exchange Assistant Development Team as a primary JAVA programmer in charge of writing Oracle SQL statements and stored procedures, Java programming, solving Java program defects. Now I have proficient use experience of eclipse, clear understanding of spring framework and JUnit unit testing. During the last year, 80% of my work tasks is about VBA data report developing and 20% is about java programing

Working as Analyst and Senior VBA developer in Group Survey department,ANZ. Use qualtrics software to build survey and analyze data. and 60 % worktime focusing on developing VBA application for this department.Responsible of survey form building, data analyzing and VBA automation work in ANZ Group Survey Department. Full English work condition and Communicate with other team members in Austrilia, Singapore and India through Emails, phones, video talk or face to face communication. Every Friday we have a global team video meeting.

With solid Excel VBA development experience of more than 6 years, analyze data from Credit RISK Business Systems Analysts and Market Risk Business Systems (such as REX, IBIS, Stealth, Clear par, Business Object, FMS ) daily and use VBA to automatically create daily, weekly and monthly reports to senior leaders. Talk directly with users to gather UBS BPS’ business requirements and turn these around into usable VBA report templates very quickly. Develop useful VBA applications or functions in Excel, PPT, Outlook, Access and Word for UBS BPS’ daily work. Manage large data files and apply analytic skills to represent overall status or trends; excellent skills of using formulas, conditional formatting, Charts, pivot tables, v-lookups, building macros and linking data and self-building functions Have developed more 50 VBA applications for UBS BPS department, successfully helped the daily work of this department and the current department audit project. Received the highly praise from UBS and the third party of Audit. During 2011, worked in Isoftstone for UBS Hong Kong branch to create outsourcing VBA applications.

Senior VBA Developer, MIS Team,Investment Bank BPO Project Work in iSoftStone As VBA developer, focus on trading data Process. (90% of daily work) Responsible for some data processing tasks’ running and maintaining with VBA macro I made (10% of daily work)Application I Developed:1) Daily Reconciliation Tool to automatically download 40 source files from various sources (emails in outlook, SharePoint web and share folders), reconcile data and import data into an access database, then final report was generated from access user interface. This automation reduced process time dramatically from 4 hours to 10 minutes. 2) A MIS Request Form template was developed from scratch in VBA. Using programming skills in macros, I developed an interactive spreadsheet in Excel that allows end-users to raise new requests to the MIS Team. The form can be sent automatically to MIS team and also saved on SharePoint. Reports will be run on schedule based on requests on the form. This form includes form events, methods, buttons, labels, list box and combine box, textbox paralleled action, data format verification, number limiting, even user’s authority check by SQL and report formatting.3) A Control Tool that ensures excel, access and outlook to work together. The tool will run a job on pre-set time without human intervention, the user will get an email at end of the job in order to know if all tasks are completed successfully.4) A lot of automation work are done using VBA to help other teams’ process improvement (PEx)..

VBA Developer and Translation Team Leader, Translation Team1) Managed a 5 people English translation and data report team for 5 years2) Lead a project that developed an application to replace repetitive translation work.3)Developed a VBA applications to replace regular equipment names in thousands of CAD drawings and excel worksheets, which saved 1/3 of the total work time4)Created an email group sending application from excel to outlook for company HR department.