SUMMARY

• Over 7 years of broad industry experience in data analysis and statistical inference. Design, development of Statistical models including data extraction and manipulation, writing macros and reporting on various projects for Real estate, Finance and Sales industries.
• Proficient inSAS/BASE, SAS/STAT, SAS/ETS, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/INSIGHTS, SAS/ASSIST, SAS/EG, SAS/ODS, SAS/CONNECT, SAS/ACCESS, SAS/DI and SAS/BI Tools.
• Hands on experience in financial/economic modeling and analysis.
• Handled large datasetsfor data extraction, transformationand applying business logic rules to incoming data.
• Comprehensive skills in working with SAS/BASE, SAS/SQL and SAS/MACRO in Windows environments.
• Skilled in merging SAS datasets, macro facility, preparing data, PROC step, producing reports, SAS formats, storing and managing data in SAS files.
• Expertise in advanced SQL programming for joining multiple tables, sorting data, SQL views and indexes.
• Generate new datasets from raw data files imported or modify existing datasets using SET, MERGE, MODIFY, UPDATE, SQL and APPEND.
• Experienced in random sampling using SAS functions and PROC SURVEYSELECT.
• Experienced in producing RTF, HTML and PDF files using SAS/ODS, well versed with creating HTML Reports for financial data using SAS ODS facility.
• Extensive experience in programming, debugging and report generation in SAS.
• Successfully using SAS Macro variables to improve efficiency and consistency of results.
• Thorough experience in data extraction and sorting from various databases like Oracle, DB2 and MS Access
• Solid understanding of statistical concepts and econometric techniques. Proficient use of various statistical procedures including PROC CONTENTS, PROC FREQ, PROC MEANS, PROCTABULATE, PROC REPORT, PROCGPLOT, PROC G3D, PROC BOXPLOT, PROCUNIVARIATE, PROC STDIZE, PROC MI, PROC CORR, PROC GLM, PROC ANOVA, PROC FACTOR, PROC PRINCOMP, PROC LOGISTIC, PROC CLUSTER, PROC VARCLUS, PROC TREEand other SAS/STAT or SAS/GRAPH procedures.
• Comfortable with working under deadlines.
• Excellent communication and interpersonal skills for task accomplishment.

TECHNICAL SKILLS

• SAS V9
• SAS/SQL
• SPSS
• Oracle
• SQL
• PL/SQL
• SQL Scripting
• Windows NT/XP
• UNIX Shell Script
• MS - Office
• MS-Access
• MS-Excel
• MS-Word
• PowerPoint
• FTP
• Html
• Java Script
• Visual Basic
• Delphi

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SAS Programmer

Responsibilities:

• Extracted data from the database using SAS/Access, SAS SQL procedures and created SAS data sets
• Calculated the real estate market metrics including house price growth to rental price growth ratio and real estate investment growth to GDP growth ratio.
• Created new datasets from raw data files and modified existing datasets using SET, MERGE, MODIFY, UPDATE and conditional statements.
• Extensively used SAS SQL procedure for join and union of tables.
• Applied SAS procedures such as PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC SUMMARY and PROC UNIVARIATE for checking missing values/outliers and producing statistical summary report.
• Analyzed Large database tables and huge SAS data sets, wrote monthly/weekly/daily summary reports on the real estate market.
• Developed and automated many SAS-SQL scripts processes for data file generations.
• Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.
• Demonstrated Aptitude at working on multiple projects simultaneously

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS Macros, SAS Enterprise Guide, SAS Visual Analytics

Confidential, Baton Rouge, Louisiana

SAS Developer

Responsibilities:

• Meetings with business stakeholders and end users to development segmentation strategies and add efficiencies to the campaign development and execution process
• Generate reports, listings and graphs using SAS /Base, SAS /Macro and SAS /Graph, SAS /SQL, SAS /Access, SAS /ODS and SAS /connect.
• Create SAS Stored Processes to use them from different client SAS applications.
• Managed data from SAS Management Console Studio and then mapping it from SAS Information Map Studio so it can be readily available for business stakeholders.
• Managed access/authorization and deploying jobs from SAS Management Console.
• Provided insights on effectively running of marketing campaigns including direct mail, email, mobile and other digital channels.
• Documented all programs and procedures to ensure an accurate historical record of work completed on assigned project.

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS Macros, SAS Enterprise Guide, SAS /Stored Process.

Confidential, New Orleans, Louisiana

Data Analyst/SAS Programmer

Responsibilities:

• Collected data of treatments from multiple sources, ELT (Extract, load and transform) data in data warehouses
• Extracting the data from various databases(Oracle, Excel) using SAS/ACCESS, SAS/CONNECT, SAS/SQL
• Cleansed datasets from different sources, handled their errors, and prepared them to use in SAS codes such as proc freq, data null, proc SQL, procformat (user defined format), proc means, proc tabulate, proc univariate; used Proc Sort with nodupkeys and noduprecs options to remove the duplicate records
• Checked the data validation using proc format or macros;
• Generated the datasets and TLGs using proc compare, proc freq, proc tabulate, proc gplot and SAS/Graph, created the Statistical reports using Proc Report, Data null and SAS Macro
• Extensively used Proc Sort, Proc Freq, Proc Means, Proc Summary and Proc Univariate to perform data descriptive analysis
• Marketing Segmentation Research using Conjoint Analysis, Correspondence Analysis, Multidimensional Scaling Analysis, Multidimensional Preference Analysis, Logistic Regression Analysis using SAS and SPSS

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros,Oracle

Confidential

SAS /SQL Programmer

Responsibilities:

• Implemented SQL to extract data from different relational database management systems and used SQL Assistant to analyze and query from the Oracle and manipulated Excel Macro to perform the repeated task
• Built relational database model and wrote structured queries in SQL and designed database in Microsoft Access
• Developed queries on the existing Oracle databases to provide ad-hoc requests
• Performed normalization analysis to detect the primary and non-primary key among all attributes
• Composed ad hoc report and documented SQL codes files for supervisor’s review

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS Enterprise Guide, Data Modeling, EER diagram, Oracle, MS Office, Confirmit, Html, Javascript

Confidential

SAS Programmer

Responsibilities:

• Model specification and variable selection.
• Collected data from various sources including online and offline questionnaire based interview
• PROC SQL was implemented intensively for joining tables.
• PROC REPORT, PROC TABULATE, PROC FREQ and PROC GPLOT was used to generate report and graphs.
• PROC TSCSREG was used for panel regression.
• Granger Causality Test was performed and residual vectors were read into SAS by using PROC IML.

Environment: Base SAS, SAS EG, SAS/Access, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, MS Office, Html, Javascript