SUMMARY

• 6 years of experience as a SAS Programmer/ SAS Analyst, involved in financial analysis and data warehousing.
• Expert in using PROC SQL, PROC Report, PROC Freq, PROC Summary, PROC Access, PROC Means, PROC TRANSPOSE, PROC Tabulate, PROC GPLOT, PROC Chart, PROC Datasets, PROC Format, PROC Import, Data Null techniques and PROC Export.
• Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/STAT and SAS/ODS.
• Proficient in DATA STEP Programming and SAS functions like SUBSTR, INDEX, SCAN, COMPRESS, COMPBL etc.
• Extensive experience in SAS Business Intelligence(BI), SAS Financial Management (FM), Campaign Management (CM), SAS Management Console and SAS Management Console 9.1 Enterprise Guide (EG 4.0).
• Experience in design and developing of SAS programs to analyze and generate Files, Tables, Listings, graphs, validations, documentation.
• Involved in extracting data from XML files, flat files, CSV, DAT files, relational databases, transforming teh data and loading into teh DW.
• Experience in creating web page applications using HTML, CSS.
• Experience in SAS/ACCESS to export, transfer and load (ETL) data, data warehousing and business intelligence concepts including SQL, PL/SQL languages.

TECHNICAL SKILLS

SAS Skills: SAS 9.x/8.x,SAS/EG, Base SAS, SAS/MACROS, SAS/GRAPH, SAS/SQL, SAS/ODS, SAS/ETL, SAS BI and SAS Data Integration Platform, SAS EBI, SQL Server, SAS/Access, SAS/Connect.

SAS Procedures: Sort, Means, Freq, Print, Tabulate, Report, Summary, Transpose, Contents, Format, Chart, Plot, SQL, Copy, gplot, gchart, Template, Compare, Import, Export, etc.

Applications: MS Office - Access, Excel, Power Point, & Word, Photoshop

Operating Systems: Windows 9x/XP/7/8, LINIX

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SAS Programmer

Responsibilities:

• Involve in SAS/ODSto produceRTF and HTML reports.
• Involved in meetings and projects wif business users, project managers & developers to automate, upgrade or expand applications that accomplish business operations and goals.
• Updated and modified teh production code according to teh dynamic requirements
• Developed Utility Macros and extensively used existing macros for Validation, Analysis, Report generation and Integration of Data.
• Worked wif large customer response and sales data sets and presented results to teh users, simultaneously tested teh integrity of teh mails, addresses in teh database.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns. Involved in teh code review to make sure teh output is as we expected and teh efficiency is met.
• Extracted teh data from Oracle database.
• Cleaned and optimized teh existing teh process by reducing significant amount of time
• Develop SAS/MACRO for writing complex Macros facility to decrease teh redundancy of extensively used SAS scripts and to increase teh flexibility of teh code.
• Create a temporary table in SESSION schema use PROC SQL pass EXEXUTE to give users an authority to access or modify table using EXEXUTE (GRANT)
• Develop proprietary statistics tool to test how teh marketing campaigns fared. dis included measuring teh sales lift attributable to a specific marketing campaign, comparing similar campaigns across multiple tracking windows etc.
• Automated teh standard reporting wifSAS BI.
• Extensively usedProc Print, Proc Report,andProc Tabulatefor reporting and communicated analysis results to teh marketing team.
• Involve in various SAS functions such asProc SQL(queries), Proc Append, Merge, Macros, and Import and Export.
• Involve inSQLPass through facility to create and update Teradata and Oracle tables.
• Developed and used scripts to schedule SAS jobs.Developed queries on teh existingOracleandSQL serverdatabases to providead-hoc reportsusingSAS/SQLfor marketing department use. Coordinated analyses involving customer information, campaign response data, and demographics.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ODS, Excel, Access, Windows, WinSCP, Oracle, SQL Server, SAS Enterprise Guide, SAS Add-In to MS Office, SAS Stored Process.

Confidential - Raleigh, NC

SAS DEVELOPER

Responsibilities:

• Involved SAS/BASE, SAS EG, Macros to develop dynamic SAS programs to extract, validate data for Statistical analysis.
• Developed SAS programs using SAS Enterprise Guide for tabulation counts, correlations and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Developed SAS Base procedures FREQ, SQL, SORT, TABULATE, and MEANS to analyze teh data.
• Optimized, automated and production daily / weekly / monthly scripts for increased efficiency and intelligence.
• Performed statistical data analysis, generated reports and graphs using SAS/Base, SAS/Macros, SAS/SQL, SAS/Access and SAS/Graph.
• Generated reports using Microsoft Excel Pivot tables.
• Created ad hoc reports, match merge and created graphs by using SAS/GRAPH base. Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
• Transacted wif various formats of data; flat files, CSV, XLS; to create and maintain large datasets.
• Implemented Set, Merge and SAS/SQL to perform suppressions and exclusions on teh data.
• Developed reporting procedures using PROC REPORT, PROC TABULATE and DATA NULL .

Environment: Windows XP, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise Guide, SAS BI.

Confidential

SAS DEVELOPER

Responsibilities:

• Actively involved in design and implementation of application software using primarily SAS system and analyzed existing application software and recommended improvements.
• Predictive Modeling Using Decision Trees, Predictive Modeling Using Regression, Predictive Modeling Using Neural Networks and other tools
• Designed flowcharts indicating teh input data sets and teh techniques that would be used (sorting, merging, etc.) to get teh desired output.
• Developed SAS macros for data cleaning and reporting.
• Present numerical information in various formats. Created SAS customized report using teh Data null technique.
• Merging, Indexing, appending and sorting teh data sets using various SAS procedures and other SAS tools
• Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data
• Created customer mailing lists for Direct Mailing and Telemarketing using PROC Forms
• Extensively used PROC Import and PROC Export procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables
• Maintained and enhanced existing SAS Reporting programs using Proc Template Styles, PROC Tabulate(Styles), PROC Report(Styles), PROC Print(Styles), ODS RTF, and ODS PDF for marketing campaigns

Environment: Windows XP, PC SAS 9.2, SAS Enterprise Guide, Base SAS, SAS Macros, SAS/Access, SQL, ODS RTF, SAS Management Console, SAS Web Report Studio, SAS BI Dashboard, MS-Office.

Confidential

SAS DEVELOPER

Responsibilities:

• SAS Administration
• SAS Management Console- SAS user administration, Data Source Administration
• SAS Programming and Development
• Supported standard reporting and production projects.
• Designed, built and tested a series of SAS programs for teh transfer and validation of reports.
• From SAS jobs, developed CSV files and reported offshore progress to management wif teh use of Excel Templates, Excel macros, Pivot tables and functions.
• Created daily HTML reports using SAS\ODS.
• Programs updating / modification / migration and documentation.
• Actively involved in reading txt files in to SAS, creating SAS datasets, analyzing large SAS datasets, generating delimited files and writing SQL load script to load teh data in to SQL Tables.
• Managed data integration development tasks in collaboration wif other technical teams
• Used ER diagrams to ensure teh referential integrity between primary keys and secondary keys
• Understanding of teh business requirement of external source systems and performs cleaning, standardization.

Environment: Windows XP, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise Guide, SAS ODS.