SUMMARY

• SAS ETL developer with more than 7 years of experience in analyzing, designing and developing Extraction, Transformation and Load (ETL) processes for building a data warehouse, OLAP cubes for reporting and other various data integration projects to build data marts from enterprise data sources and fully integrate the SAS Business Intelligence suite.
• Experience in architecting the data marts, OLAP cubes for fast & flexible reporting of pre - summarized large datasets and decision support systems using SAS Data Integration Studio, Enterprise Guide and OLAP Cube studio for the business users.
• Extensive experience in using various SAS modules-SAS/Base, SAS/Stat, SAS/Macros, SAS/Access, SAS/Connect, SAS/Graph, SAS/ODS and SAS/SQL on Windows and UNIX environments in order to accomplish Data Analysis and preparation of SAS datasets, multi-dimensional reports, tables, listings, summaries and graphs according to the corporate guidelines and project requirements.
• Extensively used PL/SQL to query Oracle database using EXPLICIT SAS/SQL pass-through facility.
• Experience in Unix Shell Scripting.
• Created Pivot tables in Excel and charts/tables in PPT files using the OLAP cubes for the business users using the SAS Add-in for MS Office plug-in facility.
• Expertise in creating the mapping models for mapping the business models with star schema logical database model using SAS Information Map Studio and store them in the metadata server that helps the business users to be self sufficient for generating their reports/analytics using SAS Information Delivery portal & Web Report Studio.
• Experience in data cleansing and benchmarking the metadata jobs in the test environment before releasing to production using the SAS Data Integration Studio, Data validation transformations and SAS Data Integration Studio package facility.
• Possess outstanding analytical and problem solving skills. Proactive, Innovative, Challenge Oriented.
• Possess the ability to demonstrate both as an individual and as part of a team with excellent communication, interpersonal skills and ability to handle multiple projects at one time.
• Excellent working experience using SAS to perform Data Pre-processing and Dataset Preparation for particular statistical analysis.
• Always energetic to learn new skills, multiple responsibilities concurrently, extremely organized and efficient. Handles complex issues professionally.
• Well-developed interpersonal skills, ability to communicate, relate, offer assistance, and handle stressful situation with competence.

TECHNICAL SKILLS

SAS Tools: SAS Data Integration Studio 4.3, SAS Enterprise Guide 5.1 SAS Management console 9.3, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Add-in for Microsoft Office, SAS Information Delivery Portal, Base SAS, SAS/SQL, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/ODS

Databases: Oracle, Teradata, SQL Server, MS Access, DB2.

Application: Putty, Tactica, Ultraeditor.

Operating Systems: Unix, Windows 9x/2000/NT, XP

PROFESSIONAL EXPERIENCE

SAS Data Analyst

Confidential, FL

Responsibilities:

• Data is received in PC files like CSV, txt or in other DSD file formats. Performed extraction, transformation and loading of data using SAS Base programs.
• Imported data into SAS using LIBNAME (IMPLICIT) and did In data processing using PROC SQL (EXPLICIT) Pass-Thru facility for specific input data feeds while connecting to relational data source like Teradata.
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC REPORT.
• Experience in Unix Shell Scripting.
• Performed Adhoc Analysis and coding for creating on demand business reports.
• Documented data reports and model results, and communicated with project team/manager to share issues and knowledge.

Environment: (Windows and UNIX): SAS 9.4, SAS/Macros, SAS Enterprise Guide 6.1, MS Access, Teradata and MS Excel.

SAS Developer

Confidential, San Antonio, TX

Responsibilities:

• Developing ETL processes to integrate multiple data sources into structures used for reporting and analytics.
• Worked with CIG-EDW data warehouse containing banking related data.
• Used various SAS DI studio transformations like Append, Extract, Rank, SCD Type I Loader, SCD Type II Loader, Sort, SQL Join, Surrogate Key Generator, Transpose, File reader, File Writer and table Loader.
• Modified existing datasets using Set, Merge, Update, Sort, and conditional statements.
• Using PROC SQL pass-through, wrote SQL queries to analyze large data sets.
• Documented data reports and model results, and communicated with project team/manager to share issues and knowledge.
• Enterprise Data Warehouse and mapping data from multiple sources (including MS SQL Server, flat files, Excel), building and implementing the data flows and loading the data into a SAS Analytical/Reporting data mart.
• Created Macros in order to generate reports on a daily and monthly basis and developed new macros for report generation as per the client’s requirements.
• Securely handled highly confidential and customer data complying with company’s procedure and policy.
• Experience in Unix Shell Scripting.
• Analyzed large data sets consisting of million records and tuned the SQL queries to get better performance.
• Assisting in data validation for the client enterprise data warehouse and Ad Hoc reporting.
• Pull data from data warehouse to prepare customized reports to help the client understand risk and opportunity for decision making.

Environment: (Windows and UNIX): SAS 9.1.3, SAS 9.4, SAS/Macros, SAS/SQL, SAS-Data Integration Studio, SAS Enterprise Guide 3&4, SAS Management console 9.1, SAS Information Map Studio, SAS Web Report Studio, SAS Add-in for Microsoft Office, MS Access, Oracle and MS Excel.

SAS programmer

Confidential, Richmond VA

Responsibilities:

• Create new metadata objects to integrate the existing SAS ETL data transformation code into SAS Data Integration Studio using the source, target and process designers to perform various data transformations and store the datasets into the data warehouse and a data mart.
• Experience in architecting, administration and maintenance of metadata repositories (Foundation, Custom & Project based) using SAS Management Console, data sources, target datasets. Data transformations using SAS Data Integration Studio and maintenance of the same according to the data models.
• Used various SAS DI studio transformations like Append, Extract, Rank, SCD Type I Loader, SCD Type II Loader, Sort, SQL Join, Surrogate Key Generator, Transpose, File reader, File Writer and table Loader.
• Worked extensively on various SAS modules such as SAS Data Integration Studio, SAS Base, SAS Enterprise Guide V4, SAS MACRO, SAS ACCESS, PROC IMPORT, PROC EXPORT, PROC SQL, PL/ SQL, SAS SQL-Pass Through, Oracle9i, Teradata, Microsoft Excel and Microsoft Word.
• Worked on merging of the existing SAS ETL code as Metadata job objects and stored into the custom repositories of SAS Data Integration Studio.
• Worked with SAS OLAP cube designer to build OLAP cubes in order to facilitate high performance analysis, flexible pre-summarization data and easy reporting of large volumes of customer data with an ability to view trends over time and other dimensions.
• Performed complete development and unit testing of the newly created ETL code in test environment and bench mark newly created metadata jobs before integrating to the data warehouse in order to build efficient data marts.
• Generated HTML, RTF, PDF and text reports using ODS statements and performed data analysis using SAS Base and Microsoft Excel.
• Performed multidimensional data analysis and reports using the cubes to produce reports.
• Created Pivot tables in Excel and charts/tables in PPT files using the OLAP cubes for the business users using the SAS Add-in for MS Office plug-in facility
• Expertise in creating the mapping models for mapping the business models with star schema logical database model using SAS Information Map Studio.
• Worked on administration and configuration of SAS Web Report Studio and Information Delivery Portal to create new users and authorizations and configuring the Mail Servers for the same.
• Extracting data from Oracle database using PL/SQL, Excel files, CSV files, used as an input for SAS programs to create Access databases, and hard copy reports. Used SAS Macros to minimize SAS code lines and for ease of maintenance.

Environment: (Windows and UNIX): SAS 9.1.3, SAS/Macros, SAS-Data Integration Studio, SAS Enterprise Guide 3&4, SAS Management console 9.1, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Add-in for Microsoft Office, SAS/SQL, Oracle 9i, Teradata, MS Access and MS Excel.

SAS Developer

Confidential, Bethesda, MD

Responsibilities:

• Involved in developing SAS programs for data transformations of the data received from different operational sites to maintain a data warehouse. Data is received in PC files like CSV, txt or in other DSD file formats. Performed extraction, transformation and loading of data using SAS Base programs.
• Extensively used PROC SQL for the analysis of large datasets and for data manipulation like Indexing and Appending various datasets.
• Experience in Architecting the metadata repositories directory structure and security using the SAS Management Console.
• Used various SAS DI studio transformations like Append, Extract, Rank, SCD Type I Loader, SCD Type II Loader, Sort, SQL Join, Surrogate Key Generator, Transpose, File reader, File Writer and table Loader.
• Imported data using LIBNAME and PROC SQL Pass-Thru facility for specific input data feeds while connecting to remote data sources like Teradata and Oracle (PL/SQL) databases.
• Produced efficient datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset match merging techniques of SAS/BASE.
• Generated HTML, Listings and reports for presenting the findings of various statistical procedures using procedures like REPORT, PRINT, GRAPH and FREQ.
• Generated HTML, RTF, PDF reports using ODS statements.
• Created SAS programs using SAS/ANOVA, SAS/REG, SAS/Means, SAS/Freq for Statistical calculations.
• Performed Adhoc Analysis and coding for creating on demand business reports on a weekly, monthly and quarterly basis.
• Monitored and managed the data feeds into the data warehouse as well as extraction transformation and loading. Created permanent formatted SAS data sets for present and future analysis..
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures
• Extensively used PROC SQL with sub-queries to generate various reports by connecting to the Teradata DB.

Environment: (Windows and UNIX): SAS 9.1.3, SAS/Macros, SAS-Data Integration Studio, SAS Enterprise Guide 3&4, SAS Management console 9.1, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Add-in for Microsoft Office, SAS/SQL, Oracle 9i, Teradata, MS Access and MS Excel.

SAS programmer

Confidential, Wilmington, DE

Responsibilities:

• Interacting extensively with end users on requirement gathering, analysis and documentation.
• Involved in credit risk assessment modelto calculate risk factor for individual clients.
• Developed complex SAS Macros & Stored Procedures in UNIX AIX O/S to simplify SAS code and effectively reduce coding time.
• Imported data from relational database (ORACLE) into SAS using LIBNAME and PROC SQL Pass-Through facility.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g. SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE
• Effectively prepared and published various performance reports and presentations
• Developed Ad-hoc reports using SAS Enterprise Guide.
• Created efficient SAS programs using SAS Macros and validated the same to optimize the resource utilization and faster processing.
• Developed SAS programs for quality checks.
• Involved in validating other programmer's code.
• Developed utility macros for standard reports and validations.
• Enhanced reports through the use of labels, SAS formats, user-defined formats, titles, footnotes and SAS System reporting options.

Environment: (UNIX & Windows): SAS Enterprise Guide 3, SAS/Base, SAS/Macros, SAS/ACCESS, SAS/Connect, SAS/SQL, Oracle 9i, MS/Excel.