Machine Learning Data Warehouse

U.S. Citizen

Professional Summary

SAS (Statistical Analysis System) Certified Advanced Programmer and SAS Certified Base Programmer with over 20 years of working experiences in federal government contracts and financial institutions.

Effectively used SAS tools and platforms to process big data by SAS VIYA DMML (Data Model and Machine Learning).

Accomplished Financial / Business projects effectively and efficiently.

Capably expressed IT processing and results to financial / business users clarifying financial / business rules for comprehension of IT professionals.

Good communication skills understanding clients’ task requirements.

Provided Business/Data analysis, processed Data Qualification, Verification, Standard, Designed database schema, data dictionary and data warehouse.

Hands-on development experiences for application projects including business analysis, source/matrix data analysis, ETL, Generated the data warehouse by RDBMS Databases (Oracle, MS SQL), MS Access. Created the statistics analytics explorations, BI Reporting, demonstrations, documentations, training and delivery.

Technical Skills

SAS: SAS VIYA, Base SAS, Advanced SAS(v9.4) with SAS SQL, SAS Macro, SAS Statistics Modeling, SAS Graphic. SAS EG, SAS Visual Analytics (Data Preparation, Data Exploration, Report Design, Report Review and Graphic Design), SAS Studio, SAS BI and Dashboard. SAS EM, SAS management console, SAS Data statistical methods, data mining and machine learning models, Python/SAS CAS,

SAS(9.4) SPRE, SAS Viya and SAS VDMML(Visual Data Mining and Machine Learning), SAS 9.4 and SAS Viya, SAS drive platforms, Python, Numpy

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

GUI: VB, VBA/Excel Modules and Reports: Business Object(Crystal Report), SQL and PL/SQL, Proc SQL, MS Access, Ad Hoc Queries, and Reports SSRS; DocuDirecter, DocuAnalyzer; SharePoint; HTML/ XML/XBRL

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

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, Commercial and Federal billing, Inventory, Financial Interests and Ratio, Financial Assets and Securities, Analyzed financial data on XBRL, Generated Financial reports.

Education

MA, Administration Management in Financial Accounting Major, Bowie State University, MD

EE, Computer Application, Ji Ling University of Technology, Ji Ling Province

Certification

SAS Certified Advanced Programmer for SAS 9 (No: AP009176v9) (2013)

SAS Certified Base Programmer for SAS 9 (No: BP031409v9) (2013)

Oracle Professional Certified on SQL PL/SQL (No: H0CDTT09A1) (2002)

Completed SAS Certificate Trainings on SAS Viya Home platform (2020 -2021)

SAS Platform Administration: Getting Started

Self-Service Data preparation in SAS Viya and SAS Viya: Basics (v8.5)

Forecasting Using Model Studio in SAS Viya

SAS Visual Analytics for SAS 9.4

SAS Federation Server- Accessing and Vitalizing Enterprise Data

SAS Professional Association in the Washington, DC area

Mortgage Loan Originator with Virginia Licensed from 2022-2024

Professional Experiences

Property Manage / SAS Developer Herndon VA July 2020 to now

• As a Property Manager for rental properties, I oversee tenant relations, property marketing, lease negotiations, and ensure property maintenance. My responsibilities include managing financial aspects, addressing tenant concerns, and ensuring compliance with regulations to optimize property profitability and tenant satisfaction. I excel in communication with clients and servicing their needs.

• I actively utilize base SAS, advanced SAS, SAS Macro, SAS SQL, and SAS Viya for data processing and analytics. This involves tasks such as data transaction/ETL, data preparation, data mining, data imputation, and statistical analysis. I generate data modules using regression/logistic models, prediction modules, and various machine learning algorithms. Additionally, I partition modules into training, testing, and validation data sets, selecting the best module as output for projects using SAS Viya module pipelines procedures.

• I have also incorporated AI tools, including ChatGPT, into project workflows to enhance efficiency and effectiveness.

SAS PROGRAMMER

AdSTM inc. / Client: NHTSA Washington DC, Sept. 2019 - June 2020

Provided the SAS data analytics capabilities on the project and analyzed varying states highway transportation safety and traffic data and datasets.

Developed solutions including complete projects, proof of concepts. Worked with teams to understand and defined project security, data and operational requirements. Provided knowledge transferred to others and demo for team members via SAS EG and statistics graphics outputs

Effectively worked with business analysts, development leads, researchers and technical staff to analyzed business requirements and provided guidance on using appropriate SAS tools and SAS coding techniques including statistical methodologies and data manipulation.

Based on varying formats raw data, created ETL procedures, and made data cleaning and data mining analyzing. Saved qualified datasets on the SAS v9.4 metadata servers.

Analyzed datasets’ data and generated the ad hoc results through made SAS codes on SAS Step, Statistics Procedures, varying Functions, SAS Macro, and SAS SQL.

Generated the visualized analytics explores and reports via the SAS Visual Analytic Studio.

Created data models on machine learning algorithms.

Generated QC statistics reports for cross reviewing on the different levels processed outputs. Generated the required technical documentations

Made some configuration by using SAS Management Console.

STATISTICS SAS PROGRAMMER AND ANALYST

Ascella Technology, Inc. / Client of SEC, DERA Washington DC, Sept. 2016 - Aug. 2017

As the key member worked for big data and complex econometrics financial analytics projects.

Analyzed the source data loaded by Oracle-designed data warehouse and analyzed the architectures of the Oracle data marts and their database dictionaries.

Generated integrated datasets and analytics Ad Hoc outputs. Created SAS codes on Step, Procedures, Macro, SQL, Functions and evaluated results by using statistics algorithms.

Developed statistics models, and financial statistics reports.

Generated QA testing and validated through generated SAS reviewing modules for all developing application modules.

Provided team with years experiences of SAS in query database and hands on SQL expertise.

Generated project required technical documents

SAS PROGRAMMER AND DEVELOPER

Vector Technical Resources /Client: Dept. of Education, ERR Washington DC, Feb.- Oct. 2015

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 complicated financial ad hoc requirements, and generated the results.

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.

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 into the existing modules enhancing and updating the application functions.

Prepared technical documents for data modeling, ETL and data mining procedures.

Quickly learned business requirements, source data systems, and transferred them into the implementation processing and application functions.

Provided technical expertise. Adapted to the team environment and worked effectively, communicating complex technical procedures to both technical and non-technical members.

BUSINESS/ STATISTICS ANALYST

Predictive Analytic Corporation, LLC. / Client: SEC, Chantilly VA, Oct. 2013 - Dec. 2014

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 statement reporting format/definitions and on the XBRL format/definitions for users’ review under the guidance of GAAP; and explained the differences between these contrasting formats reports.

Used designed taxonomy to markup variant samples of filings/per decades based on the business rules.

Designed the validated flowcharts

Worked on QA functions, and provided automated marked outputs feedback and suggestions.

Analyzed the APPS filings by classification of ABS. Extracted large text format data and transformed and loaded the text format data for further analysis and review.

SAS Visual Analytics, BI and SAS Enterprise Miner tools for proposal usage.

SAS PROGRAMMER

Nutech Computer Systems Inc. Rockville MD, Dec. 2012 - Sept. 2013

Hands-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-datasets and merged data set via optimized solutions.

Processed data modeling and architecture into cross functional groups. Performed statistical analysis on SAS procedures and reports.

Manipulated SAS data for the different statistic procedures and generated different output reports (proc reports, proc tabulate, proc gchart/proc gplot etc), used SAS Output Delivery System (ODS) to present reports in different formats (HTML, PDF, Excel, RTF etc.). SAS Macro, SAS SQL,

SAS statistical models (ttest, Anova, Correlation, Regression etc.), MS VBA of (Access, Excel)

DATA, DATABASE ENGINEER

Contractor worked for FHWA Research Center, Mclean VA, Nov. 1998 - Dec. 2012

Achievement: Provided database techniques and skills to create the “Project Database Application System Tools/Software”. The projects database application tools provided varies models’ data, they also provided dynamic queries. It could generate the output data on both screens and standard reports. The tools also contained several analyzed methods tabs, image photos, and research reporting summary for references. The Graphic User Interface (GUI) was designed for users to fetch models’ data and information easily.

Generated and designed the database system via 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 GUI, Design Query and Reports systems, Graphic systems, and Web functions.

Set configurations between databases and application software systems.

Created documents, DEMO, and online HELP tools for projects.

CHIEF PROJECT ANALYST

Foster Associate Inc. /Client: USPS Bethesda MD, Oct. 2007 - Dec. 2009

• Achievement: Led the analysis of business datasets and developed automated financial analysis and processing models' tools for USPS projects. Provided users with analysis, processing, implementation, and comparison capabilities for complex financial data analysis. Integrated business rules setting and financial data statistic analysis into the models' tools. Designed GUI tools for easy entry conditions, facilitating selection of financial source data and periods (monthly, quarterly, semi-annual, and annual). Generated, consolidated, and reconciled financial reports efficiently, demonstrating meticulous attention to detail and strong problem-solving skills.

• Incorporated financial matrix data with business rules to perform complex financial analysis and calculations, processing billions of dollars' worth of values in matrix data format through extensive programming.

• Created the RPW Adjustment Model project and automated methods tool to process source data, effectively producing output reports.

• Developed a project model analyzing source data (Revenue, Pieces, and Weight) and control data, including architecture design, system logic, physical design, data structure design based on business rules, and all related routines and subroutines.

• Established the Roll Forward Model _ Input Table Loading project tool, utilizing complex business control data and matrix data to generate nine output analysis report sheets, two user interfaces, and several support sheets.

• Maintained and enhanced an existing CRA model tool, incorporating new functions into output analysis reports, evaluating performance, and analyzing source and business control data.

• Analyzed the existing Incremental Cost Model, examining input, business control, and output data, and generating data flow charts for user understanding.

• Produced demo documents using PowerPoint to guide users on utilizing the tools effectively.

Contact this candidate