SUMMARY

• Expertise in Excel VBA for automation of data processing, financial reports generation, financial modeling, and securities pricing. Advanced knowledge in Excel formulas, functions, forms, tables and graphs. Experience in Access VBA in data manipulations from tables, forms, queries, reports and/or from other data sources.
• Advanced skills in SQL programming to retrieve and manipulate data from databases. Highly effective in financial data integrity, reconciliation, and qualification. Hands-on experience in financial reporting/data processing system enhancement and development. Strong skills in QA analysis and UAT testing.
• Certified financial analyst with comprehensive knowledge in financial products, financial analysis, capital markets and investment instruments. Hands on experience on fixed income product and derivative valuations.
• Experienced financial reporting analyst with demonstrated capability in processing large scale of data to produce financial reports. Solid skills in P L calculations, financial statement, variance, and trend analysis.

TECHNICAL SKILLS

• Programming: VB, VBA, SQL, PL/SQL, C , HTML, CSS, XML, VB Script, VB.Net, C, UNIX, SAS
• Data Bases: MS Access 2007-2010 , SQL Server SSIS, SSRS , Oracle OLAP , Essbase, Sybase
• Software Tools: MS Excel 2007-2013 , PowerPoint, Outlook, Business Object, Visio, SharePoint, MQC

EXPERIENCE

Sr. VBA Developer/Data Analyst Consultant

• Create and enhance Access applications in tables, forms, queries and macros. Create VBA modules for new functions or improve existing functions in data loads, transfers, processes, and calculations.
• Support Liquidity trading and regulatory daily, monthly and quarterly reports. Analyze data structure and quality. Resolve various problems in Access and Excel applications occurring in financial reporting tool EUC development and production operations.
• Perform unit test and system test for modules, macros, queries and other functions in EUC development.
• Create documents of application user guide, Application development procedures, Data process macros and queries procedure analysis, Operation work flows, etc.

Environment: MS Access, Excel, VBA, SQL, PowerPoint, Outlook, SharePoint, Business Object

Confidential

Sr. Software/VBA Developer Consultant

• Worked in Commercial Credit Risk Models Redevelopment CCMR project. Performed conceptual design and logical design approval procedures.
• Reviewed and modified project plans. Analyzed model structures, Credit Risk Rating processes, data flows, user interfaces, improve areas and effects. Created documentations and system workflow diagrams for CCMR.
• Evaluated and compared different vendor software packages in the project phase of Proof Of Concepts POC .
• Collected user requirements for functions, non-functions, and new features in CCMR user interface recreation.
• Created use cases and functional specifications of Credit Risk models in user interface physical design. Created Test Plan/Test Strategy and Test Cases/Test Scripts for QA team.
• Using Excel VBA to implemented Credit Risk Rating application user interfaces and process procedures.

Environment: MS Excel 2013 , VBA, Project, Visio, SharePoint, Lotus Notes, XML, Web Services

Confidential

Sr. VBA Developer Consultant

• Analyzed the structure of XML Web Service. Created new Excel VBA Add-In to utilize new Web Service functionality to support website based Rating services. Retrieve from or write back financial data to Web.
• Enhanced Excel templates and updated financial forecasting model to fit with new Add-In to generate forecasted financial data. Then save the data back to database through XML Web Services.
• Created application security mechanism, checking user login credentials and creating the service usage logs.

Environment: Excel 2010 VBA, XML, SOAP, C , XML Web Services, SQL Oracle , Toad

Confidential

VBA Developer/P L Report Analyst Consultant

• Analyzed report data structure and processing procedures. Designed and created VBA automation applications.
• Developed Excel VBA programs to automatically load XML, text or Access data into excel workbooks and to perform data manipulations. Feedback Excel data to Access and update Access data by VBA.
• Created macros for financial P L reports to support securities and derivative accounting operations. Automatically calculate values and P Ls for fixed income derivative trading reports including interest rate swaps, swaptions, FX, etc. , Economic Hedging reports, etc. Enhanced macros for regulatory reports, and created modules for securities hedge modeling.
• Supported financial reporting teams to resolve data and calculation problems occurred in financial reports.
• Generated project documentations and wrote user guides to program operations and applications.

Environment: Excel 2007 VBA, Access 2007 VBA, C , XML, SQL, Visio, Fixed income derivatives, FX

Confidential

VB/VBA Developer Consultant

• Designed user interface and programmed in Visual Basic for automating financial reports for Investment Bank. The interface is flexible to dynamically adjust for up to 10 reporting decks and each for unlimited reports.
• Using VBA directly linked the report templates with different databases, including Essbase, Business Object, Access, and other internal data sources, retrieving data and producing the reports automatically.
• Made application to produce reports in Excel, PDF and/or PowerPoint file types according to users' selection.
• Standardized the report structure and formats, and improved the processes for the automation, including pivot tables, dynamic ranges, data auto-refresh, etc. The application can automatically filter data and dynamically generate user selected report packages.
• Wrote project documentation of functional specification, design methodology, and user guide etc.

Environment: VB 6, Excel 2007 VBA, Access 2007 , Essbase, SharePoint, Business Object, SQL Access

Confidential

Sr. Financial Reporting Analyst

• l Programmed Excel VBA modules and functions to automate data processing and data analysis. Created financial models for financial analysis, forecasting, and planning. Through automation, reduced data processing time by 25 , improved financial analysis procedures and reduced errors to the minimal.
• l Created financial models for securities pricing, including term structure bond pricing, equity pricing through free cash flow, option pricing, Monte Carlo simulation, option on bonds, option on FX, and so on.
• l Created and maintained HTML and CSS files for management report pages on management database website.
• l Implemented project in Oracle OLAP and Portal system development. The enhanced system reduced data down load time by at least 80 and increased system efficiency over 400 based on the processing volume.
• l Created testing plan and test cases for new Pearl Business Object reporting system development. Performed thorough tests for all standard financial reports in the Pearl system, reported more than 200 defects and helped programmers to solve problems. Contributed to make the project complete on time.
• l Created and maintained over 800 reporting books in the Management Database. Prepared and produced key management reporting deck. Generated up to 16,750 pages of financial reports monthly for CFO group.
• l Generate ad-hoc reports through data query from different data sources such as Access and SQL server.
• l Provide monthly and quarterly financial analysis for Financial Control. Ensured all factors, formula and calculations are correct. Performed variance and trend analyses based upon actual, prior period, and plan data. Prepared and produced mid-year forecast and annual plan reports.
• l Performed data qualification: reconciled the financial data against source data, resolved inconsistencies or discrepancies analyzed, identified and corrected errors in entities, measures, formula, formats and names in the reporting system. Continuously reduced and cleared data errors in the Management Database.

Environment: VB 5/6, Excel VBA, Access, SQL, PL-SQL, HTML, CSS, XML, Business Object

Confidential

Database Administrator DBA

• l Maintained GAAP Financial Database. Opened / Closed accounts, units, types and periods in the databases. Created and updated the mappings of accounts, units, entities and organization hierarchy trees. Ensured highest-level of financial data quality. Cleared all errors in the database.
• l Ran various monthly and quarterly financial reports. Reduced report processing time by about 25 . Produced ad-hoc reports as needed. Manipulated and updated UNIX Korn shell programs for ad-hoc reports.
• l Reconciled data among financial systems MRS, DAS, GAAP, FDR, REGIS, etc. . Frequently found errors or mistakes in the received data or documents, avoided many potential problems. Analyzed and solved problems
• in the database, such as erroneous attributes of variables.

Environment: Windows, UNIX, C, K-shell script, SQL for Sybase

Confidential

Quality Assurance Analyst

• l Software development and QA analysis. Requested and tested data. Debugged intermediate values for troubleshooting errors. Reported most defects in the testing team. Provided very detailed explanations to help programmers quickly identify and clear the errors.

Environment: Windows, Main Frame, C, VB5, DB2, Access, CICS, MQC