SUMMARY

Senior financial reporting/data analyst with broad experience in data analysis and financial reporting with complicated, large scaled data sets. Advanced skills in SQL programming in data retrieval and manipulation (Oracle and SQL Server). Experience in financial data integrity, reconciliation and qualification analysis. Strong problem solving skills for data mismatching or discrepancy from processes or calculations.

Certified financial analyst with comprehensive knowledge in financial products, capital markets and investment instruments. Hands on experience on analyzing and processing financial data in supporting financial reports including liquidity regulatory reports, fixed income trading reports, derivative P&L reports, consolidate reports and management reports. Expertise in VBA, SQL, XML, SAS, C#, Unix programming.

EXPERIENCE

Citibank Long Island City, NY Jul 2014 – Apr 2015

Data Analyst/Report Developer (Consultant)

Supported liquidity broker/dealer trades and reports. Developed liquidity regulatory daily, monthly and quarterly reports. Support liquidity reporting productions. Resolved various problems in Access and Excel applications in financial reporting tool (EUC) development and production operations.

Analyzed liquidity reports’ requirements to data types, maps, and relations. Analyzed raw data structure and quality from different data sources. Designed data models and created related tables, queries and formula. Reconciled data in checking incorrect calculation results. Fixed errors in reference data, maps, or formula.

Created and enhanced Access applications in tables, forms, queries and macros. Created VBA modules for new functions or improve existing functions in data loads, transfers, processes, and calculations. Performed system tests and unit tests. Setup environment for UAT test and supported to UAT testers.

Created functional specifications, Application development procedures, Data process macros and queries procedure analysis, operation work flows, order of operations, and user guide of application tools, etc.

PNC Bank Pittsburgh, PA Oct 2013 – May 2014

Senior Data Analyst/Developer (Consultant)

Reviewed and modified Commercial Credit Risk Models redevelopment plans. Analyzed model structures, data flows, user interfaces, improve areas and effects. Corrected inaccurate plan items and add missed tasks. Performed conceptual design and logical design approval procedures.

Created documentations and system workflow diagrams for the models redevelopment. Evaluated and compared different vendor software packages in the procedure of Proof Of Concepts (POC).

Updated functional specifications with new features and functions collected from users. Created use cases and functional specifications of Credit Risk models in user interface physical design. Created Test Strategy/Test Plan and Test Cases/Test Scripts for QA/UAT team.

Standard and Poor’s New York, NY Oct 2012 – June 2013

Sr. Data Analyst/VBA Developer (Consultant)

Analyzed data structures and performed data validation, data type conversion, etc. to warren data quality.

Enhanced Excel templates and updated financial models to retrieve data from Oracle database, to generate forecasted financial data, to write back new data to database, and to produce financial reports in Web Services.

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 to retrieve from or write back financial data to database. Used XML, XPath, SQL in VBA modules for complicated functions and used SOAP, TOAD tools.

Citibank Long Island City, NY Jun. 2011 – Aug. 2012

Sr. Data Analyst/VBA Developer (Consultant)

Analyzed source data structure and report processing procedures. Designed and created VBA applications to perform data aggregation and consolidation, ensured consistent processing and accurate results.

Developed Excel VBA programs to automatically load XML, text or Access data into excel workbooks, to perform data manipulations and calculations. Then updated Access data with Excel calculated results.

Created macros to automate daily financial P&L reports. The applications automatically calculate values and P&Ls for fixed income and derivative trading reports, Economic Hedging reports, etc. Enhanced macros for regulatory reports (FAS 133) and Settlement reports. Created modules for securities hedge modeling.

Supported derivative accounting team and financial reporting team to resolve data and calculation problems.

Generated project documentations and wrote user guides to program operations and applications.

JPMorgan New York, NY Feb. 2011 – May 2011

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.

Performed data consolidation and qualification. 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. Made application to produce reports in Excel, PDF and/or PowerPoint file types according to users’ selection.

Wrote project documentation of functional specification, design methodology, and user guide etc.

Citigroup Long Island City, NY Jun. 2000 – Dec. 2010

Sr. Financial Reporting Analyst/Data Analyst

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.

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. Generate ad-hoc reports through data query from different data sources such as Access and SQL server.

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.

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.

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.

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.

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.

Citigroup New York, NY Oct. 1998 – May 2000

Database Administrator (DBA)

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. Performed various database tasks to keep it functioning well.

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.

Reconciled data among financial systems (MRS, DAS, GAAP, FDR, REGIS). Analyzed and solved problems in the database, such as erroneous attributes of variables. Performed data transitions between data systems.

Prudential Insurance Co Newark, NJ Jun. 1996 – Oct. 1998

Quality Assurance Analyst

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.

TECHNICAL SKILLS

Programming: VB, VBA, SQL, PL/SQL, C#, HTML, CSS, XML, VB Script, JavaScript, UNIX, SAS

Data Bases: MS Access (2007-2010), SQL Server (SSIS, SSRS), Oracle (OLAP), Essbase, Sybase

Software & Tools: MS Excel (2007-2013), Word, PowerPoint, Project, Visio, Business Object, FTP, MQC

EDUCATION

New York University Certificate of Financial Analyst July 2010

Chubb Institute Diploma in Computer Programming Aug. 1998

Baruch College of CUNY MBA in Finance May 1995

Contact this candidate