SUMMARY

• More than 15 years (1998 - present) of working experiences with federal government contracts and financial institutions.
• Provided proficient services and aptitude skills in Management Information Systems, Critical thinking skills, solid work ethic and problem solving skills. Accomplished Financial/Business applications projects effective and efficient. Capability to express the IT processing and results to financial/business users and expressed some financial/business rules for IT people to understand. With good communication skills and understood the tasks requirements, Got clients satisfied my efforts and contributions.
• Provided the Business/Data analytic, processed the Data Qualification, Verification, Standard. Designed database schema, data dictionary and data warehouse. Processed the Extraction, Transform and Load the source data to useful data. Integrated, migrated and implemented the useful data to targeted data.
• Hands on development experiences for the application projects included business analysis, source/matrix data analysis, ETL, database/data warehouse, GUI Access, statistics analytics,statistics exploration, and BI Reporting, demonstrations, documentations, training and delivery.

TECHNICAL SKILLS:

SAS: Base SAS, Advanced SAS with SAS SQL, SAS Macro, SAS Statistics Modeling, SAS Graphic. SAS EG, SAS Visual Analytics 9.4 (Data Preparation, Data Exploration, Report Design, Report Review and Graphic Design), SAS Studio, SAS BI and Dashboard. SAS EM, SAS management console, SAS Data Flux, DI Studio.

DATABASE: Database Architecture, Oracle SQL, PL/SQL, MS Access, MS SQL, MS T-SQL SSIS

GUI: VB, VBA/Excel Module Report Business Object (Crystal Report), MS Access Report, SSRS; DocuDirecter, DocuAnalyzer; SharePoint; HTML/ XML/XBRL

OS: MS Window/Windows Server 2012, UNIX, Linux;

Big Data: knowledge of Hadoop Architecture, HDFS, MapReduce. Hadoop with SAS Architecture/Servers

FINANCIAL ACCOUNTING SKILLS: GAAP,SEC, FAR, Financial and Accounting data consistency and reconciliation, General Ledge, Assets, Equality and Liability, Revenue, Cost, Budgeting, Cash flowing, A/P, A/R, Billing, Inventory, Financial Interest and Ratio, Financial Assets and Securities. XBRL generated Financial Reports.

PROFESSIONAL EXPERIENCE

Statistics SAS Programmer

Confidential

Responsibilities:

• Have been working for large financial data warehouse, complex financial database projects.
• Analyzed Oracle-designed data marts for source data.
• Generated applications by using SAS tools and integrated datasets.
• Developed statistics models, and financial statistics reports.
• Generated and validated QA testing on SAS modules system for all developing application modules.
• Generated project documents and supported the team members with research and communication.
• Provided team with years experience of SAS to query database and hands on SQL expertise.
• Played an important role in completing the projects more effectively and efficiently.
• Used the updated SAS Visual Analytics 9.4 open page components of Data Exploration and Report Designer to generate the analytics visual analytics reports and visualized analytics exploration.
• Utilized the SAS Data Preparation, Graphics Design, and Report View components.
• Acknowledged the SAS Management Consol and SAS Visual Analytics Administrative functions.

SAS PROGRAMMER AND DEVELOPER

Confidential

Responsibilities:

• Advanced experience using SAS EG, SAS Processing, SAS Visual Analytic, SAS/database administrator, SAS management console, knowledge of SAS data Flux, Version Control.
• Designed the SAS modules and generated SAS codes on SAS Proc SQL, SAS Macro, Base SAS and Advanced SAS steps, procedures, SAS graphic procedures, SAS report procedures, SAS ODS systems, data mining procedures, database programming and data analytics, ETL procedure to support the Entity Risk Review project. Combined the SAS techniques and RDBMS skills to process very complexion financial ad hoc requirements, and generated the results on effectively and efficiently.
• Analyzed and researched the source data from data architecture and schedule’s level, analyzed the different source data systems (internal and external). Identified the different source data definitions and source data usage limitation, which could affect the data integration results. Provided and helped the team members understood.
• Analyzed and evaluated the existing integrated environment including the Oracle database, SAS Meta database, SAS application as well as Graphic User Interface components.
• Updated the application modules’ version. Embedded and integrated these new generated optimized codes on the existing modules in order to enhance and update the applications functions.
• Prepared technique documents for data modeling, ETL and data mining procedures.
• Quickly learned the business requirements, source data systems, and ability to transferred them into the implementation processing and application functions.
• Provided technical expertise. Adapted to the team environment and worked effectively, communicated complex technical procedures to non-technical team members.

BUSINESS/ STATISTICS

Confidential

Responsibilities:

• Analyzed TEXT/HTML/XML/XBRL data filings components and unstructured source data for document filing on the system, and provided suggestions and references to support the project of data mining implementation execution.
• Analyzed financial data statements on both traditional financial reporting format/definitions and on the XBRL format/definitions for users reviewing which under the guiding of GAAP; and explained the differences between these two format reports.
• Used designed taxonomy to markup variant samples of filings/per decades which based on the business rules. The marked up samples initially guided the automation processing.
• Designed the validation flowing charts
• Worked on QA functions, and provided automated marked outputs feedback and suggestions.
• Analyzed the APPS filings by classification of ABS. provided project support. Extracted large text format data and transformed and loaded the text format data for further analytic and review.
• SAS Visual Analytics, BI and SAS Enterprise Miner tools for proposal usage.

SAS PROGRAMMER

Confidential, VA

Responsibilities:

• Processed data modeling and architecture; performed statistical analysis on SAS presentation reports.
• Manipulated SAS data for various statistic processes and generated output reports (proc reports, proc tabulate, proc gplot/gchart) using SAS Output Delivery System (ODS) to generate reports in different formats (HTML, PDF, Excel, RTF etc.), SAS stored processes, and information maps.
• Worked on developing data extraction, data integration, data quality and data management processes in SAS environment. Accessed data, created/recreated data structures, generated sub-data sets, and merged data sets to optimize solutions. Analytic financial data by SAS VISUAL ANALYTICS tool.
• Required knowledge and using several SAS applications studio tools, which included SAS EG, SAS DI studio, SAS BI, SAS Visual Analytics, SAS Information Map Studio, and SAS Enterprise Miner. SAS XML Mapping, SAS Web Report Studio, SAS OLAP Cube Studio, SAS Information Delivery Portal and SAS Management Console, SAS JMP. Worked on SAS projects on both Window and Unix Systems.

SAS programmer

Confidential

Responsibilities:

• Handed on working for SAS (v9.2) programming and various problems solving skills with SAS data step. Proc step, macro, SQL and statistic model procedures.
• Accessed data, created/recreated data structures, generated the sub data sets and merged data set by optimized solutions.
• Processed around data modeling and architecture to cross functional groups. Performed statistical analysis on SAS proc’s and reports.
• Manipulated SAS data for the different statistic procedures and generated different output reports (proc reports, proc tabulate proc gplot, etc), used SAS Output Delivery System (ODS) to presented reports in different formats (HTML, PDF, Excel, RTF etc.). SAS Macro, SAS SQL, MS VBA of (Access, Excel), and MS Macros of (Access, Excel), SAS statistical models (Ttest, Anova, Correlation, Regression etc.)
• Worked the SAS projects on both Windows and UNIX systems.

DATABSE SYSTEM ENGINEER

Confidential, VA

Responsibilities:

• Created and designed the database system by hardware and software.
• Generated database/data warehouse architecture; designed logically and physically database; performance data qualification check, input, implementation, analytic presented, output, and verification. Maintained and turned RDBMS within the MS development environments.
• Created the Graphic User Interface (GUI), Design Query and Reports systems, Graphic systems, and Web functions. Wrote scripts to manipulate data.
• Made configurations between databases and application software systems.
• Created documents, DEMO, and online HELP tools for projects.
• Provided attention to details with strong problem solving skills.
• Incorporated financial matrix data with business rules to generate complex financial analysis, financial calculations, and process of billions of dollars values on matrix data format. Implement these processing by writing a large number of programming codes.
• Created the RPW Adjustment Model project and automated methods tool to process source data, effectively and efficiently producing output reports.
• Created a project model analyzing the source (Revenue, Pieces and Weight) and control data tool, model’s architecture design, system logic, physical design, model’s data structure design (based on business rules), and all routines and subroutines.
• Created the Roll Forward Model Input Table Loading project tool. Generated the model by using highly complex business control data (about twenty sheets) as well as several hundred matrix data (200 Classes x 2000 Components). The whole project contained nine output analysis report sheets, two user interfaces, and several support sheets.
• Maintained an existing CRA model tool and added new functions to the output analysis reports. Analyzed the source data and business control data. Evaluated performance of the existing CRA model.
• Analyzed the existing Incremental Cost Model including: input, business control, output data; and generated data flow charts for users.

Key Words: Financial analyzing and statements, VBA descript, Module Coding and functions, Costing, Revenue, Ratios, Statistics, Graphic User Interfaces and Financial Analysis Report, database Processing, MS Access database, Dynamic Query, Forms, Reports, MS Visio, MS Office 2007(Access, Excel, PowerPoint, Words, Outlook, etc.), SAS installation, SAS data step, proc report, proc summary, SAS macro ODS and Proc SQL, Data Modeling.

ACCOUNTING SYSTEM ANALYST

Confidential

Responsibilities:

• Analyzed existing financial transaction reporting systems, financial data’s attributes, structures and the accountants’ customer servicing.
• Developed automated database application tools for accountants to process and research data.
• Designed the new database on different data to store the restructured transformed data.
• Created the automatic GUI tool for accountants’ access and process ad hoc queries for transaction data research.
• The automated database tools provided accountants to generate researching financial reports effectively and efficiently.

Key Words: ETL, DocuDirecter, DocuAnalyzer, Ms Access, Ms Excel, VBA, Database, Data and financial Credit transaction procedure analysis, Ad Hoc Query, Dynamic Query, SQL, Analyzing Report, Forms, Macros and functions design. Extract, transform and load data from transactional system.