SUMMARY

• Accomplished Data analyst professional with 9+ years of experience in strong design, coding, problem solving, analysis and testing on various applications using SAS, SQL Server, Oracle, Python, MS - Excel and Tableau on Windows and UNIX platform in development and analytics support.
• Proficient in SAS/BASE V9.2 to V9.4, 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.
• Experience working onSAS Data Integration (DI) studio and SAS Business Intelligence (BI) Tools such asSASEnterprise Guide,SASInformation Map, OLAP Cube Studio and SASWeb Clients
• Hands on experience in financial/economic modeling and analysis.
• Handled large datasets for data extraction, transformation and 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 TREE and other SAS/STAT or SAS/GRAPH procedures.
• Comfortable with working under deadlines.
• Excellent communication and interpersonal skills for task accomplishment.

TECHNICAL SKILLS

• SAS V9.4
• SAS/SQL
• SAS/DI
• SAS/BI 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, Washington, DC

Data Analyst

Responsibilities:

• Performed sophisticated ad-hoc or BAU custom analyses against members’ engagement data using SAS 9.4 to support client
• Developed and implemented MS SQL Server codes, stored procedures, views, functions and triggers
• Analyzed Large database tables and generated monthly/quarterly summary reports on member behavior data
• Developed and automated many SAS-SQL scripts processes for data file generations.
• Developed Tableau visualizations and dashboards using Tableau Desktop
• Conducted meetings with client and end users to develop segmentation strategies and improved efficiencies to the campaign development and execution process
• Managed and maintained SFTP configuration for multiple internal and external providers and vendors
• Performed application migration, upgrade and environment configuration change
• Documented programs and procedures to ensure an accurate historical record of work completed on assigned project.
• Provided technical support/advice to data management team
• Extracted data from the database using SAS/Access, SAS SQL procedures and created SAS data sets

Environment: Base SAS V9.4, SAS Enterprise Guide, MS SQL Server, SAS/SQL, SAS/ODS, SAS Macros, Tableau

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.
• 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 V9.4, 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 V9.4, 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 V9.2, 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 V9.2, 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 V9.1, SAS EG, SAS/Access, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, MS Office, Html, Javascript