SUMMARY

• Ph.D. in mathematics; 3+ Years working experience in Data Analysis, Statistical Modeling and Simulation, Algorithms Realization.
• Expertise in SQL queries, SQL Plus, Stored Procedures, Functions, Triggers and Performance Analysis; Accessing and updating database, creating Indexes, Aggregating tables when required.
• Experience in developing data models and programs which will serve required functionality and custom needs.
• Experienced in working wif R, SAS or Matlab for Statistical Analysis, along wif Microsoft SQL Server or MySQL for various environments and business processes.
• Expertise in dealing wif large datasets wif R and LAPACK/BLAS. Experienced in multi - core computation and parallel methods to maximize calculation speed and efficiency.
• Deep understanding of Statistical Modeling, Multivariate Analysis and standard procedure. Familiar wifmodel testing, problem analysis, model comparison and validation.
• Expertise in Linux Shell Scripting and Parallel Computing. Familiar wif SSH secure shell and remote computing.
• Experience wif sensor data collection and conversion from experimental structures and real infrastructures. Responsible for data analysis based on sensor data such as tension, displacement, vibration and load. Carried out failure model analysis, fissure development prediction and maximum load analysis.
• Good problem solving skills. Expertise in working wif business users and colleagues as part of requirements gathering and converting their needs into technical solution and data models.
• Extensive experience in data visualization including producing tables, graphs, listings, and movies using various procedures and tools to support understanding or explanation of data and also final report.
• Great interest in Data Analysis. Employed data analysis tools in the daily life like bank bills management, grocery lists, schedule planning.
• Teaching and training experience in: Colege Algebra, Trigonometry, Calculus me, II, III, ODE and Statistics. Patient teacher and good at interpreting materials to students for fast and easy understanding.
• Strong analytical, communication skills that helps in communicating wif business users, development team and project management staffs.

TECHNICAL SKILLS

Database Tools: Microsoft SQL Server 2012/2014, MySQL

Data Modeling Tools: R, SAS, Matlab

Languages: SQL server, MySQL, R, SAS, Shell Scripting, Matlab, Fortran, VBA

Packages: Microsoft Office 2007/2010, SSH, R Markdown Reporting, R parallel, SAS BI service.

Operating System: Windows 8/7/XP, LINUX/Unix.

Others: MSOffice (Word, Excel, PowerPoint, Access), AutoCAD, Latex.

PROFESSIONAL EXPERIENCE

Confidential, Irving, Texas

Data Scientist

Responsibilities:

• Worked wif data source team and Client systems to obtain data, identify data issues, data gaps, identified and recommended solutions.
• Worked on data manipulation and analysis & accessed raw marketing data in varied formats wif different methods for analyzing and processing.
• Involved in performing extensive Back-End Testing by writing T-SQL queries and stored procedures to extract the data from SQL Database.
• Involved in data pattern recognition and data cleaning. Identify missing, invalid values and outliers, analyze and categorize variables of datasets.
• Worked wif BI team in data investigation, responsible for interpreting data variables, making instructions and also data dictionary.
• Checked data for distribution, classification, correlation and VIF etc, worked wif BI team for variable selection.
• Carried out Linear Regression Analysis wif R, investigated on the model for fitting/overfitting, significance, ruled out problems like Multicollinearity, Heteroscedasticity and Autocorrelation etc.
• Worked on principal analysis on datasets and model optimization, comparing and validation. Established our linear model for forecasting.
• Involved in trend analysis and segmentation analysis based on 12 years of market data. Provided graphic analysis report to illustrate market trend and object segment behavior.
• Utilized SQL server’s reporting services; SSRS and SSIS; to support reporting requirements.

Environment: R, T-SQL, SQL Server 2012, ERWIN data modeler, SSIS, SSRS, Linux Server.

Confidential, Richfield, MN

Sr. Data Analyst

Responsibilities:

• Used and supported database applications and tools for extraction, transformation and analysis of raw data.
• Worked wif end users to gain an understanding of information and core data concepts behind their business.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements.
• Identify Data Quality Controls review Business Requirements Document and attend project release meetings.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for analysis.
• Involved in extensive data validation by writing several complex SQL queries and involved in Back-End Testing and worked wif data quality issues.
• Worked on logistic regression analysis on credit datasets. Built logistic model to support Business department in determining credit issue.
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing SAS.
• Wrote simple and advanced SQL queries and scripts to create standard reports for senior managers.

Environment: SQL Server 2008, Informatica 8.1, Quality Center 8.2, SAS, TOAD, PL/SQL, Teradata V2R6, Windows Server 2008

Confidential, TX

Research Assistant, Ph.D. Candidate

Responsibilities:

• Experience in simulation code development, data generation, processing and analysis of 3D supersonic flow wif MVG. Carried out following stability analysis for understanding complex problem.
• Worked on clustering analysis on 30,000 data sets and profiling of turbulent flow data. Extended research to topology and physics analysis based on analysis results.
• Built predictive model wif linear regression analysis. Validated models wif model comparison and visualization methods. Compared results against wind tunnel test data and achieved good fitting results.
• Utilized mode recognition and FFT methods to process and filter signal and noise produced in computation results. Carried out time series analysis on time step datasets.
• Used ANOVA package in R to keep track of variables of turbulent flow and analyze influence of dimension and position on flow parameters.
• Employed Unix Shell Scripting and Parallel Computing for R and Fortran on Texas Advanced Computing Center (TACC) to guarantee efficient and successful computation of our case.
• Familiar wif computational numerical algorithms. Experienced in advanced high speed computing and efficiency improvement.
• Responsible for data visualization in both graphical form and motion pictures to analyze topology and support future research.
• Employed methods of interpolation, extrapolation and Fast Fourier Transformation to achieve clear working results which achieved quality similarity wif experiment data.
• Teaching Assistant: Colege Algebra, Trigonometry, Calculus me, II, III, ODE and Statistics

Environment: Unix/Linux, TACC ranger, R, Parallel Computing, Binary Datasets, Fortran, Cygwin, AutoCAD, Latex.

Confidential

Construction Project Investor

Responsibilities:

• Worked wif Tai’an City Construction Survey & Design Institute on the project survey and feasibility study.
• Responsible for communication and negotiating wif project related aspects on project loan, construction fee, design alterations, and unexpected events from the project.
• Worked on project cost along wif bank. Investigated on construction cost models from the bank and from Construction Company, compared the difference and made relational data sets.
• Completed program in Fortran to retrieve data from different construction models and make comparison. Assisted bank and simplified auditing process for similar construction projects.

Environment: Windows XP, Fortran