SUMMARY

• SAS Advance and Base certified with Over 7 years of robust professional work experience in Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Application Development and Reporting with SAS
• Understanding of the client's vision, goals, limitations, data sources and time lines
• Firm grasp over understanding of business needs and strategies to develop reliable and effective solutions Experience in using data steps in SAS for creating, maintaining and manipulating datasets.
• Experience in using various statistical procedures in SAS such as PROC SQL, PROC Sort, PROC Freq, Proc Univariate, PROC Means, PROC Transpose, PROC TTEST and PROC Import.
• Experience in BASE SAS v 8.2/9.2/9.1/9.3 , SAS/MACRO, SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/EG, SAS/BI and SAS/CONNECT in UNIX,
• Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results.
• Advanced SQL skills with ability to code complex queries to load, clean, format & store data
• Clear understanding of data modeling principles like star and snow - flake schema, dimensional data model, 3nf etc
• Designed several ETL jobs + data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data
• Ability to code complex MDX code for OLAP cubes to have a tradeoff between storage space and performance
• Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, Clustering etc to gain insight into the data
• Excellent experience with export SAS Results to different format, such as XML, Excel using SAS/Export, SAS/ODS for reporting and presentation.
• Experience in preparation of reports, tables, listing and graphs using SAS/Base, SAS/Macros, SAS/GRAPH and SAS/STAT. Experience in developing SAS procedures and Macros.
• Self-motivated individual with strong technical & analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and managing data.
• Extensive programming experience with PROC SQL, PROC REPORT, PROC ACCESS, PROC FORMAT, PROC TABULATE. Extensive experience in SAS/STAT procedures such as PROC REG, PROC GLM, PROC FREQ, PROC MEANS, PROC MIXED, and PROC UNIVARIATE.
• Perform data analysis using SAS/STATS procedures such as Proc MEANS, PROC FREQ, PROC TEST etc.
• Have experience in different databases like Oracle, SQL Server, DB2, MySql and Teradata.
• Extensive experience in Teradata tools & utilities like SQL Assistant, BTEQ, FastExport & TPump for business analytics and reporting on massive Enterprise Data Warehouse
• Strong skills in requirements gathering, analysis and ETL design, coding, debugging
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc

TECHNICAL SKILLS

SAS skills: Base SAS, SAS/Macro, SAS/Connect, SAS/SQL, SAS/STAT, SAS/BI, SAS/Graph, SAS/IntrNet, SAS/ODS, SAS/Access, SAS Enterprise Guide, Enterprise Miner, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio and Management Console.

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

Databases: MS Access, SQL Server, MySQL, Teradata, Oracle

Operating Systems: Windows, Unix, Linux and Mac

Software packages: MS Word, Advanced MS Excel, MS PowerPoint, SQL Plus

Reporting Tools: Base SAS versions 9.3/9.2/9/8/6, SAS Enterprise, SAS Graph, MS-Excel, SAS BI Platform

PROFESSIONAL EXPERIENCE

Confidential, Salt Lake City, UTAH

Sr. SAS Programmer/ Analyst

Responsibilities:

• Developed and designed SAS programs/macros to analyze marketing data and creating files, tables, listings, and graphs.
• Used SAS, SQL, XML, PL/SQL and Windows batch programming techniques to code the technical specifications apply business logic and produce automated reporting solutions
• Create detailed business and technical documentation for individual projects
• Maintain and contribute to the modulated software development environment for loss prevention
• Work individually and as part of a team to put forth ideas pertaining to technical and analytical solutions
• Advanced analytics and reports created based on the criteria provided.
• Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on requirements.
• Used SAS procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT in order to understand and prepare the data
• Automated the existing audit reviews and production.
• Performed approvals for peer audit reviews on reports by analyzing data.
• Developed SAS Macro programs to create ad-hoc reports.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Used SAS PROC SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
• Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
• Created dynamic Macro arrays by SQL and with data step programs.
• Delivery of customized information to users within and beyond the enterprise using SAS portal
• Modeling of data using SAS/STAT using Logistic Regression.
• Performed data preparation, graphical presentation, Statistical Analysis, Testing, Validation, reporting, and documentation using SAS tools and SAS Portal.
• Extracted data from different sources like Teradata, Excel files and text files using SAS/Access, SAS SQL procedures and Proc import functions.

Environment: SAS 9.3, SAS/Access, SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, Oracle, MS Office, and Unix

Confidential, Cary, NC

SAS BI Developer

Responsibilities:

• Created Global Market View SAS Datamart and designed star schema for efficient querying and reporting.
• Integrating raw data from various sources to test inputs files required for modeling portfolio performance by designing, developing and maintaining new SAS based processes.
• Regularly used libname Statements and PROC SQL to interact with different RDBMS like Oracle, Teradata.
• Created Stored Processes for the business to generate different ad hoc reports based on the parameters passed.
• SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.
• Customizing and enhancing the existing ETL process.
• Developing metric checks for various source system files to analyze monthly and quarterly data trends using Proc SQL and SAS/STAT procedures.
• Supporting development and production teams by identifying and reporting data quality issues for achieving error less results.
• Fine tuning and performing code enhancements to reduce run time and improve efficiency.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• Built reports using Web Report Studio and Information Delivery Portal.
• Automated Reports using SAS Add-in for Microsoft Office.
• Designed and developed code with SAS/EG to support ad hoc requests.

Environment: SAS 9.2, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/Access (Oracle / Teradata), SAS/Connect, SAS/Information Map Studio, SAS/Web Report Studio, SAS Add-in for MS Office, SAS/STAT, SAS/EG, Excel, UNIX (HP-UX)

Confidential, Charlotte, NC

SAS Developer

Responsibilities:

• Created SAS dataset from tables in Database using SAS/Access and Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Wrote various queries using SAS/Base, SAS/SQL and SAS/MACRO for creating reports according to the Users requirement.
• Converted ORACLE data tables into SAS data files using SAS SQL Pass through Facility, and uploaded SAS data files into ORACLE tables using SAS Dbload procedure.
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc for reporting purposes. Used SAS procedures for Importing and Exporting data to MS-Excel.
• Transformations using Base SAS Procedures and Functions.
• Migrated Main Frame JCL jobs into Unix Shell Scripting for running SAS nightly jobs.
• Extensively used ETL to load data from DB2, SQL server, oracle, Flat files and XML as sources to Oracle Data warehouse as target.
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various types of transformations such as Expression, Aggregator, Filter, Joiner, Update strategy and Lookup (Connected and Unconnected) to load the data.
• Extensively involved in designing and developing of Star Schema Model for Data Store.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Have knowledge about Informatica Sever tools - Informatica Repository Manager and Informatica Server Manager.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, Informatica 6.1, DB2, Java, Cognos, SQL, Teradata V2R4 (MLOAD, FLOAD, Fast Export, BTEQ), XML, IBM AIX 5.3, Unix, Shell Scripting, WINSQL, Ultra editor, Oracle 8i/9i, SQL Server 2000, Mainframe, SunOS 5.8, DTS, Erwin, and Windows XP.