SUMMARY:

• SAS professional with an expertise in delivering high quality Data Warehousing and Reporting solutions to several clients under time and budget constraints.
• Adept at maintaining one version of data truth across the organization through flexible and efficient ETL processes and portraying the data into presentation ready reports.
• Rich experience with Data Analysis, Credit Risk analysis and Management reporting using SAS.
• Technical expertise with SAS/BASE, SAS/MACRO, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/SHARE, SAS/DMI and SAS/ODS modules.
• Rich hands - on experience using basic and advanced SAS procedures such as PROC SORT, PROC FREQ, PROC MEANS, PROC SUMMARY, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE, PROC SQL etc.
• Experience in programming SAS on different operating systems like Windows, OS-390/Z-OS, and UNIX.
• Rich experience in extracting data from DB2, Oracle, VSAM, SQL Server and Teradata.
• Expertise in building and maintaining ETL processes using SAS/BASE, SAS Enterprise Guide (SAS EG) and SAS Data Integration Studio (SAS DIS).
• In-depth understating of Relational and Multidimensional databases (Star and Snowflake schemas).
• Rich experience in creating DataMarts using SAS DI and defining incremental update processes.
• Rich hands-on experience in building OLAP Cubes and Information maps using SAS OLAP Cube Studio (SAS OCS) and SAS Information Map Studio (SAS IMS) for advanced reporting.
• Extensive experience with SAS reporting procedures PROC PRINT, PROC REPORT, PROC TABULATE, PROC GPLOT, PROC GBARLINE etc.
• Adept at using SAS reporting procedures with ODS Tagsets (ExcelXP, HTML, PDF etc.) using PANEL, ROW and COLUMN concept for creating presentation ready automated reports.
• Experience with SAS Web Report Studio (SAS WRS), SAS Add-In for Microsoft (SAS AM) and SAS Business Intelligence tools.
• Adept at developing SAS programs for Statistical Analysis and Modeling using GLM, REG, CORR, ANOVA, RANK, LIFETEST etc.
• Excellent functional knowledge of Banking and Finance domain.
• A result oriented team player with positive attitude, good communication and excellent problem solving skills.

TECHNICAL SKILLS:

Operating System: Windows 98/2000/NT/XP/Vista, Z-OS/OS390/Mainframes, AIX, UNIX

Database: DB2, Oracle 10g, Sybase IQ, MS SQL Server, VSAM, Teradata, MS Access

Languages: SAS 8,9.1,9.2,9.3, PL/SQL, SHELL (KSH), COBOL

SKILL: SAS/BASE, SAS/STAT, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/SQL, SAS/ACCESS and SAS/CONNECT, SAS/EG, SAS WRS/IMS/DIS/AMO

SAS Procedures: PRINT, MEANS, REPORT, SORT, FREQ, TABULATE, TRANSPOSE, IMPORT, EXPORT, SQL, COMPARE, REG, CORR, ANOVA, GLM, GPLOT.

Tools: IMS SQL Management Studio, Toad, PVCS 8.1.3, MS VISIO, HP OVSD 4.5, QC, VMware

WORK EXPERIENCE:

Confidential, CA

Data Analyst/SAS Programmer

Responsibilities:

• Worked with Data Architect and Business Analysts to understand and capture the requirement.
• Created S2T mapping and Technical Design documents using Microsoft Excel and Visio.
• Developed SAS DI ETL Jobs to extract and transform data coming from multiple source systems (Oracle, EDW, and SAS) in order to create Core, EDM and ABT Tables.
• Implemented complex business logic into SAS DI Jobs using Standard and User written transformations.
• Created SAS DI Jobs to execute BRM Rules (by connecting to BRM node) for systematic user action.
• Created reporting programs in SAS Enterprise Guide using SAS BASE and used macros, prompts, EG template, ODS etc.
• Created LSF flows in order to automate job runs using Time and File triggers.
• Worked on code and Object promotion from Development to Production.
• Worked on Unit, Integration and QA testing and provided post implementation support.

Environment: SAS/BASE 9.3, SAS Data Integration Studio 4.5, SAS/MACRO, SAS/ETS, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/STAT, SAS/SHARE, SAS Enterprise Guide 5.1, Oracle, Teradata

Confidential, TX

Data Analyst/SAS Programmer

Responsibilities:

• Analyzed existing SAS EG programs in order to understand the business logic.
• Actively monitored and supported SAS datasets containing transactional and customer data for DM and Non-DM marketing campaigns.
• Created new SAS programs and changed existing ones in order to accommodate changes to models and business strategies.
• Developed new SAS/STAT programs in order to provide descriptive analysis and recommendations for future risk and fraud management strategies.
• Created SAS programs using macros to split the dataset by marketing campaigns for reporting.
• Used SAS Procedures PROC TABULATE, PROC REPORT, PROC GBARLINE etc. using custom templates (derived from SASWEB and MEADOW) and generated presentation ready reports.
• Used ODS HTML and EXCELXP tagsets to convert Excel reports into HTML format.
• Worked on ad-hoc reports and root cause analysis.

Environment: SAS/BASE 9.3, SAS/MACRO, SAS/ETS, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/STAT, SAS/SHARE, SAS Enterprise Guide 5.1, SAS Enterprise Miner

Confidential, PA

Data Analyst/SAS Programmer

Responsibilities:

• Worked on project portfolio management (Crash Kappa) using data from Teradata source.
• Imported Excel, XML, Flat files and converted them to SAS format for Risk Analysis Reporting.
• Created SAS programs for table and column level transformations using Transpose, Sort, Join, Match Merge and other capabilities of SAS.
• Added new columns and generated surrogate keys to create unique record identifiers.
• Worked on Impact Analysis/Reverse Impact Analysis (data lineage) with DBAs during Metadata changes.
• Used a combination of SAS BASE and SAS Data Integration Studio (SAS ETL Studio) for ETL needs.
• Used SAS OLAP Studio and SAS Information Map Studio (SAS IMS) to create Information maps over OLAP by defining Detail, Summary and hierarchies for drill down reports.
• Created various reports using BASE SAS and tested Info Maps using SAS WRS.
• Actively monitored and loaded daily feeds received from various sources.
• Worked on performance tuning of ETL processes to reduce performance issues.

Environment: SAS/BASE 9.2, SAS/MACRO, SAS/ETS, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/STAT, SAS/SHARE, SAS Enterprise Guide 4.2, SAS IMS, SAS OLAP, SAS WRS, SAS EM, Teradata

Confidential, Michigan

SAS Programmer

Responsibilities:

• Worked on changing network parameters such as TLSFTP, DB name, FTP locations etc.
• Created sample DATAMARTS and OLAP Cubes using SAS DI, SAS IMS, and SAS OLAP.
• Changed the existing SAS Reports to new format approved by Ally Management.
• Updated ETL processes during the metadata changes in Oracle and DB2.
• For complete job responsibilities, kindly see the project below.

Confidential, Michigan

SAS programmer

Responsibilities:

• Worked with Mainframe team in processing VSAM files using SAS to make it ready for reporting.
• Created special FTP process by using FILENAME statement to receive file from Mainframe to PC while avoiding EBCDIC to ASCII conversion issues.
• Wrote SAS programs to read Fixed and Variable Format (RECFM=F & RECFM=V) VSAM Files and converting those to SAS format using VSAMREAD.
• Used Sequential and Direct access reading methods for KSDS (KEY=) by connecting directly to Mainframe.
• Extracted historical transaction data from DB2 and Look-up values from Copybooks to SAS Datasets.
• Used extracted data from all sources and performed cleaning and transformation using SAS procedures.
• Used cleansed data for generating reports for Risk management team.
• Extracted real-time transactional data from Oracle and generated time-wise login traffic reports.
• Generated daily, weekly and monthly reports and also worked on ad-hoc business requests.
• Provided support during Audit, Financial Year End processing and Disaster recovery drills.

Environment: Base SAS 9.1.3, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/Enterprise Miner, SAS AMO, HP OVSD, Z/OS, VSAM, DB2, Oracle, PL/SQL, MS Excel

Confidential

SAS Programmer

Responsibilities:

• Worked on merging all order, shipping and billing data (entered via different methods such as DB2, EDI XML, VSAM etc.) and created SAS datasets.
• Presented analysis to business users on different topics such as Back order creation, order trend, shipping costs, product unavailability, billing issue etc.
• Provided data to Analytics team for developing optimal marketing strategies and sales prediction models.
• Monitored data replication and fixed SAS Job failures.