SUMMARY

• Data Analysis/Predictive or Statistical Modeling: query and mine large data, time series analysis, generalized linear model, linear and logistic regression, multivariate regression analysis, neural networks, hypothesis testing, ANOVA, MANOVA
• Over 8 years of IT industry experience in software development using Windows SAS (PC SAS), UNIX SAS.
• Proficient in SAS/BASE, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Access, SAS/ODS, SAS/STAT and SAS/GRAPH
• Proficient in DATA STEP programming and SAS functions like SUBSTR, INDEX, SCAN, COMPRESS, COMPBL, STRIP, INTNX, INTCK, CAT etc.
• Extensively used SAS procedures such as PROC SORT, PROC MEANS, PROC SUMMARY, PROC FREQ, PROC TABULATE, PROC REPORT, and PROC PRINT for producing customized reports and external files.
• Strong SAS programming background for creating, maintaining existing code, adhoc reporting and supporting the reporting functions.
• Generated reports using PROC REPORT, DATA NULL and PROC TABULATE for customized report writing.
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and managing data.
• Have strong experience in carrying out marketing campaigns and evaluation of customer information.
• Expertise in analyzing and coordinating audit data, generating reports and tables.
• Leverage technology and business process skills to generate innovative solutions to solve client business problems.
• Created RTF, PDF, and HTML listings, tables and reports using SAS/ODS.
• Sound knowledge of probability and statistics
• Excellent working knowledge of SAS WPS, SAS Enterprise Guide 4.1/5.1, SAS studio 9.4
• Created reports in SAS and exported to Excel spreadsheets, and other applications
• Involved in extracting data from XML files, flat files, CSV, Dat files, and relational databases, transforming the data and loading into the DW.
• Experience with database manipulation (ETL) and SQL programming and reporting.
• Extensive experience in preparation of tables, listings, and graphs.
• Expertise in statistical, quantitative and analytical data in financial sector.
• Good at migrating SAS datasets and SAS applications from Unix <=>NT
• Experienced in producing external files and customized reports using various SAS procedures like Proc Print, Proc Report, Proc Tabulate, Proc Means, Proc Summary, Proc SQL, Proc Freq, Proc univariate, Proc transpose, Proc Rank, Proc Access and data Null techniques.
• Computing platforms: UNIX, Windows, Mac
• Statistical software/ Programming languages: SAS, SAS/WPS, SPSS, SQL, ACCESS, VBA
• Microsoft application: Excel, Word, Access, PowerPoint and Outlook

TECHNICAL SKILLS

SAS Skills: SAS Clinical, Base SAS, SAS/Macro, SAS/SQL, SAS/Graph, SAS/ODSSAS/Access, SAS/WPS and SAS Studio

SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, Reg, SQL, Copy, Freq, Forms, Upload, Download, Formats

Operating Systems: Windows 8/7/95/98/00/NT, UNIX

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Independently executes data analysis and modeling projects from project/sample design, reception and processing of data, performing analyses and modeling to final reports/presentations, communication of results and sales support.
• Query and mine large data sets, connecting data from disparate sources to identify insights and patterns; apply both statistical and business knowledge to ensure accuracy of insights
• Conduct intermediate statistical analysis, such as linear and logistic regression, ANOVA, time - series analysis, and classification models
• Utilizes advanced statistical techniques to create high-performing predictive models and creative analyses to address business objectives and client needs.
• Contribute to advanced statistical analysis, such as development of production-ready algorithms, neural networks and decision trees
• Provides technical sales support, which may include various analyses and the preparation and presentation of analytical results.
• Summarize findings in written and verbal reports to key stakeholders
• Play an active role in preparing and presenting complex written and verbal reports, findings, and presentations
• Tests new statistical analysis methods, software and data sources for continual improvement of quantitative solutions.
• Creates clear and easy to understand reports and/or PowerPoint decks for client meetings or third party collaborations.
• Verbally presents analysis ideas, progress and results to internal managers, external partners and customers.
• Communicates with internal groups on data specifications and with IT engineers on model/algorithm implementation.
• Assures compliance with regulatory and privacy requirements during design and implementation of modeling and analysis projects.

Environment: SAS, SPSS, SAS/WPS, SAS/SQL, Excel, Word, PowerPoint

Confidential, Seattle, WA

Data analyst, SAS programmer

Responsibilities:

• Attend client calls for business understanding and clarifications.
• Modify the existing application according to the Customer Service Request
• Extract raw data from an Oracle database and use SAS/ACCESS to read it and run statistical analysis using SAS
• Investigate and identify proper record/data sources or issues, extract the data with SQL, use PL/SQL procedures, triggers and functions and correct the data, update data feeds from external sources, populate applications for each data point and validate incoming/outgoing critical data to bring customer data to the highest standards and ensure consistency among databases
• Work closely with business groups to provide business solutions and to develop ad hoc reports per the user’s requirement
• Enhance the existing business reports by incorporating new business variables
• Develop, modify, and generate Monthly Business Review (MBR) reports summarizing business activity
• Upload data into the warehouse application on monthly basis
• Review and modify SAS Programs, create customized ad-hoc reports, process data for publishing business reports, automate and distribute designed business reports on schedule in various formats
• Develop SAS programs to extract, validate and transform data from different data sources using SAS procedures such as PROC Format, Proc Means, Proc Freq and Proc Univariate
• Test the application for new code
• Extensively used PROC SQL for highly advanced matching and merging between large datasets

Environment: ACCESS database, SPSS, SAS/SQL and SAS Programs.

Confidential

Technical IT Consultant and SAS programmer

Responsibilities:

• Validated Economic, Financial and Market Risk Models. The models include time series models, multivariate models, logistic regression, linear models, non-linear models, simulation models, value-at-risk models (VaR), generalized linear models and other statistical models,
• The validation work entails the following activities:
• Evaluate conceptual soundness of the modeling methodology
• Examine appropriateness of both quantitative and qualitative assumptions underlying the model.
• Assess quality of the data for model development as well as inputs to the model
• Test implementation accuracy of the model
• Perform tests to assess performance of the model
• Perform ongoing research and develop benchmark models based on alternative modeling methodologies and ensure the models are in line with industry best practices and meet regulatory requirements.
• Make recommendations to the stakeholders or models owners (government, business, insurance, hospitals) on the approval of the models or other corrective actions based on the independent validation results. Document validation results and findings/recommendations in a validation report.
• Assist the Model owners to ensure that all the models are validated according to the existing validated procedures/standards.
• Based on the results of model validation, recommend improvements to the model or the model development process and identify material improvement opportunities in the models being validated.
• Responsible for completing draft reports and submission of all necessary documentation related to validation assignments to model owners; ensure accuracy and completeness of archived information and related documentation to allow independent third party review of the validation work performed.
• Establish communication with model owner/developers to understand model rationale and issues; maintain relationship with key contacts as identified for each validation.
• Communicate findings from validation work to stakeholders.
• Maintain collaborative relationship with clients
• Recommend and enforce improvements to tests/methods in order to fulfill internal validation needs and to align (if applicable) with industry practices
• Comply with economic policies, procedures and regulatory requirements where applicable.
• Keep abreast of industry and regulatory developments and evolving expectations.

Environment: SAS, SPSS, Excel, ACCESS, VBA

Confidential

IT Consultant, Data analysis and SAS programmer

Responsibilities:

• Constructed, cleaned, and documented large datasets for various socio-economic projects using SAS, SPSS and Excel
• Created metadata analysis on various gathered data from heterogeneous sources
• Analyzed research data and estimated economic models using different statistical techniques
• Wrote SAS and SPSS for data manipulation for use in statistical packages for statistical analyses
• Prepared various charts and graphs for all economic data and drafted appropriate articles implemented statistical sampling techniques in various settings including univariate, bivariate, multivariate methods with extensive use of logistic regression
• Produced reports in excel using SAS add-in and Proc Report
• Extensively used Proc SQL and SAS Macros for application automation
• Coded extremely complex SAS Data step and proc including the advanced techniques and the use of the available options to serve the ever evolving and dynamic business reporting needs
• Involved in aggregating data residing on the vast network of distributed servers with all forms of data storage.

Environment: Base SAS, SAS MACROS, SAS CLINICAL, SAS/GRAPH, SQL and SPSS

Confidential

Data analysis and IT head

Responsibilities:

• Programmed and synthesized large data sets including data manipulation and transformation
• Developed strategies to analyze appropriate data to meet the objectives and implemented solutions
• Implemented statistical or econometric modeling for strategic/policy/business decisions with extensive use of time series analysis, multivariate analysis, linear regression and logistic regression.
• Using the statistical models developed, predicted market outlook, risk exposure and conducted scenario analysis.
• Assisted with the development, maintenance, and on-going support of risk models, economic models and business decision models.
• Reporting to the Senior Manager of Loyalty Analytics, facilitated decision making and improving the performance of the loyalty program and team through the analysis and interpretation of data and reports.
• Provided statistical and data analysis support and training to students using different computer software - SAS, SPSS, Access, Excel.
• Stayed on top of best practices in reporting and analytics.
• Presented program results and proactively recommend improvements to business/producer stakeholders.

Environment: SQL, SAS, ACCESS, Excel, Word