SUMMARY:

• SAS Base Certified Programmer with 10+ years of experience in Design, Development, Data Analysis, Testing and Support of Reporting Applications, Data Management and Reporting in Financial, Marketing and Campaign Management domains.
• Extensive experience implementing Data Warehousing on Client/Server Technologies using SAS Base, SAS/Macros, SAS/Access, SAS/Graph, SAS/STAT, SAS/Connect, SAS Enterprise Guide 4.3/5.1, SAS ODS, SAS Web Report Studio, Integration Technologies on UNIX/Linux, MainFrames (MVS) and Windows NT/2000 operating systems.
• Involve in requirements elicitation, communicate with stakeholders, understanding the business requirements into Business Requirement Document and translate their requirements into Technical Requirement Document.
• Hands on experience in Migrating / conversion SAS versions using SAS Migration Utility and SAS Development Wizard.
• Excellent experience in applying efficient techniques to manage huge volumes of data with millions of records (size ranges - 80 to 450 million).
• Good experience in connecting to various databases and extracting data from Oracle 10g/11.0, SQL Server 2005/2008 Teradata 13.10/14.0, Informix - XPS, MS Access 2000 and DB2.
• Experience in creating database objects - Tables, Views, Inline views, Functions, Procedures, Cursors, Sub-Queries, Triggers, Synonyms, Sequences, Packages in Oracle 10g/11.0 and SQL Server 2000/2005.
• Sound knowledge in data warehousing concepts - Database Design, Normalization, Star Schema, Snowflake Schema, slowly changing dimensions and data modeling.
• Excellent experience in Analyze and Interpret results, Clean and Prune data, Validating data and perform Unit Testing and User Acceptance Testing.
• Ability to quickly debug SAS compilation errors, peer code review and identify areas of concern.

TECHNICAL SKILLS:

SKILL: SAS Base 6.12/8.x/9.x, SAS/Macro, SAS/SQL, SAS/STAT, SAS/Access, SAS/Graph, SAS/Connect, Enterprise Guide 4.3/5.1 and Integration Technologies.

Operating Systems: UNIX (IBM-AIX, HP-UX, Sun Solaris), Red Hat Linux 8, IBM - OS/390, Windows 3.x/9x/2000/NT/XP, MS DOS

Databases: Oracle 8i/9i/10g, MS-SQL Server 2000/2005, MS Access, Informix - XPS, DB2, Teradata V2R5/V2R6/13.10

Database Utilities: Teradata - SQL Assistant (Queryman), BTEQ, FLoad / MLoad / FastExport / TPump, TOAD, SQL-Developer.

ETL and Reporting: Informatica - Power Center 5.1/6.2, Cognos, Business Objects, Tableau 8.0/ 9.3

Scripting Languages: Shell Script (Korn Shell), Awk, PVCS, and AutoSys JIL

WORK EXPERIENCE:

Confidential, Richmond, VA

Sr. SAS Analyst

Responsibilities:

• Responsible to understand the client’s Line of Business, Database Architecture, Logical and Physical data models, Consumer Lending - Default process and Loan Life Cycle.
• Extracted Auto Sales data from Oracle and SQL Server databases using implicit / explicit methods create tables and efficiently load data for reporting.
• Write complex SQL scripts and SAS macros to automate manual process to read data from large Excel files and produce datasets every month.
• Write SAS programs to validate and verify data and provide SAS support to create adhoc Reports on request by business users.

Environment: SAS 9.4 on UNIX/Linux, Windows 7.0, SAS Base, SAS/Macros, SAS/ACCESS, SAS/Graph, SAS SQL, SAS Enterprise Guide 6.1, Ultra Edit, MS Office 2013.

Confidential, Plano, TX

SAS Data Information Analyst

Responsibilities:

• Responsible to understand the businesses, translate to technical requirements, design ETL processes and build Dashboards for Sales and Originations teams.
• Provide SAS support to the Sales and Origination teams to produce complex and business critical reports for Confidential Auto Finance.
• Extracted Auto Sales data from Oracle and SQL Server databases using implicit / explicit methods, create tables on Teradata, and efficiently load data for reporting.
• Write complex SQL scripts and SAS macros to automate manual process to read data from large Excel files and produce datasets every month.
• Create Indexes for variables on huge SAS datasets to improve performance while reading large volumes of data frequently.
• Connect to multiple data sources including Teradata and SQL Server and design Dashboards taking advantage of Tableau functions, data blending, parameters and action filters.
• Publish Dashboards on Tableau server and aware the end users on how to better visualize data using Tableau.
• Perform analysis on Dealer Performance using Excel Charts and Graphs and automated the manual process using Excel Macro.
• Write Shell scripts to automate daily jobs, creating monthly folders, preserve monthly datasets, log and list files and when the job complete, sends emails alerts to the users.
• Create adhoc reports and validate data using Excel functions, VLOOKUP and PIVOT Tables.
• Involved in peer reviews, testing of the code written and documenting different processes.

Environment: SAS 9.3 on UNIX/Linux, SAS Base, SAS/Macros, SAS/ACCESS, SAS Enterprise Guide 5.1, Teradata 14.10, Oracle 10g/ 11.0, SQL Server 2008, Tableau 9.3, MS Office 2010, Excel VBA scripting.

Confidential, Cincinnati, OH

SAS Programmer / Analyst

Responsibilities:

• Responsible to understand the client’s Line of Business, Database Architecture, Logical and Physical data models, Indirect Auto Consumer Lending process and Loan Life Cycle.
• Provide SAS support to Analytical & Portfolio Management group to produce and automate Consumer Lending Dashboard reports.
• Write SAS macros to automate building SAS datasets and write VBA macros for every day Dashboard Reporting.
• Write SAS programs to validate and verify data and provide SAS support to create adhoc Reports on request by business users.
• Develop Test Plans and Test Cases to ensure Data Quality and to produce expected results.

Environment: SAS 9.4 on UNIX/Linux, Windows 7.0, SAS Base, SAS/Macros, SAS/ACCESS, SAS/Graph, SAS SQL, SAS Enterprise Guide 6.1, Ultra Edit, Blue Zone, MS Office 2013,, Excel VBA, Excel Pivot Tables.

Confidential, Plano, TX

SAS Data Information Analyst

Responsibilities:

• Responsible to understand the client’s line of businesses, complex Database structures, account level model monitoring and BAU reporting.
• Data Management - Extract data from Auto Data warehouse (Teradata) tables/views using implicit / explicit methods and create tables to load data into reporting tables.
• Wrote complex SAS macros to automate manual process that reads data from large Excel files and produce datasets every month.
• Executed Parallel Processing using SAS/Connect to improve efficiency and increase CPU usage on SAS Grid Environment.
• Create Indexes for variables on huge SAS datasets to improve performance while reading large volumes of data frequently.
• Write / modify Bash shell scripts that automate creating monthly folders, preserve monthly datasets, log and list files while the process runs every month.
• Perform code reviews to ensure proper design, standard, content and functionality.

Environment: SAS 9.3 on UNIX/Linux, Windows 7.0, SAS Base, SAS/Macros, SAS/ACCESS, SAS SQL, SAS/Connect, SAS Enterprise Guide 5.1, Teradata 13.10, Tableau 9.0, Ultra Edit, WinSCP, MS Office 2010.

Confidential, Charlotte, NC

SAS Programmer Analyst

Responsibilities:

• Understand the Marketing Database Information system, complex metadata structures, and Campaign engine process and campaign list execution.
• Provide SAS support to the Marketing team to produce adhoc reports for Auto and Bank customers and Cross-Sell segments.
• Wrote quality check programs to make sure the final output files sent over to various vendors are consistent and accurate as per the business agreements.
• Applied - Hash Tables, SQL Joins and Proc Format lookup techniques to build datasets from huge tables.
• Used data dictionary tables to fetch metadata information and automated few existing manual processes.
• Import data from Excel, SQL server, Flat files and created reports in Tableau for quick analysis and visualization.
• Provide recommendations on the available existing reports and suggest opportunities to improve reporting solutions.

Environment: SAS 9.3 on UNIX/Linux, Windows XP/7.0, SAS Base, SAS/Macros, SAS/ACCESS, SAS SQL, SAS/Connect, SAS ODS, SAS Enterprise Guide 5.1, Tableau 8.0, SQL Server 2005, Oracle 10g.

Confidential, Charlotte, NC

SAS Programmer Analyst

Responsibilities:

• Involved in gathering specifications, design and build warehouse data model and various ETL and reporting processes as per client business requirements.
• Developed programs and modified existing programs passing SAS macro variables to improve ease and efficiency as well as consistency.
• Data Management - Extract data and connect Teradata database either using Libname or SQL Pass through Facility, transform and load data into the data warehouse tables.
• Create and execute SAS programs on UNIX / Linux to perform exception load into SAS warehouse datasets, for the campaigns that has exceptional values in the SIEBEL tables.
• Create Indexes to improve performance of programs using small subsets of data from large SAS datasets.
• Production support - interact with Business Analysts to correct data errors, review log files, identify errors/warnings, create and execute SAS scripts to fix the failed load processes.
• Involved in SAS migration from 9.1.3 to 9.2 using SAS Migration Utility and generate migration analysis report.
• Keep manager informed on important developments, potential problems and related information necessary on software migration.

Environment: SAS 9.1.3/9.2 on UNIX/Linux, Windows NT/2000, SAS Base, SAS/Macros, SAS/ACCESS, SAS SQL, SAS/Connect, SAS ODS, SAS Enterprise Guide 4.3, SAS Web Report Studio, Teradata - SQL Assistant 13.10, WinSCP, MS Office Suite 2003, Excel VBA scripting.

Confidential, Columbus, OH

SAS / Database Programmer

Responsibilities:

• Responsible for understanding the business requirement analysis, design, development and data model of the application.
• Developed, tested and maintained weekly/monthly/quarterly reports by creating and updating SAS data marts for Retail Banking Divisions.
• Review and understand existing Packages, Stored Procedures, Functions, Triggers, Views and Cursors in PL/SQL.
• Write simple to complex SQL queries efficiently using Sub-Queries, Join conditions and correlated Sub queries.
• Converted existing PL/SQL scripts, Procedures and Functions to SAS programs. Extracted text and csv files using INPUT & INFILE statements and created SAS data files to produce reports.
• Developed customized reports using Proc Report, Proc Template, Proc Summary and Proc Transpose.
• Created / modify scripts to automate batch processing using KORN Shell (ksh) and used PVCS to keep track of version history of source code.
• Preparation of test cases and execution of Unit Testing, Regression Testing and Business Acceptance Testing (BAT).

Environment: SAS 9.1.3 on UNIX (AIX), Windows NT, SAS Base, SAS/Macros, Oracle 9i/10g, SAS SQL, TOAD, SAS Enterprise Guide 3.0, UNIX Shell Scripting (Ksh), MS Excel, PVCS.

Confidential, Charlotte, NC

SAS Programmer/Analyst

Responsibilities:

• Gather business requirements and involved in design the warehouse model and build warehouse tables from various data sources into SAS, to provide efficient access to the business users.
• Perform data validation using Proc Contents, Proc Download, Proc SQL and Proc Compare.
• Fetch metadata information using Proc SQL dictionary tables and Performed Enterprise Guide administrative tasks like creating libraries in SAS/EG.

Environment: SAS 9.1.3 on UNIX, Windows NT, SAS Base, SAS/Macros, SAS/ACCESS, SAS/Connect, SAS Enterprise Guide 3.0, SQL Server 2000/2005, Oracle 9i/10g, Teradata - SQL Assistant V2R5/V2R6.

Confidential

SAS Programmer

Responsibilities:

• Write SAS Programs using Base SAS and SAS Macros to create SAS datasets for Analysis.
• Validate using Proc Freq for categorical variables and Proc Univariate for continuous variables.
• Write SQL queries and Sub-queries on Brio Query tool to access huge volumes of data.

Environment: SAS 8.2 on UNIX (AIX), MS-Excel, SAS Base, SAS/Macro, SAS ODS, Oracle 8i/9i, SAS SQL, SAS/ Enterprise Guide 3.0, NDM, Brio 5.0.

Confidential

SAS Programmer

Responsibilities:

• Provided statistical programming support for Data Mangers and Statisticians, using SAS Base and SAS Macro facilities, involving data transformation (sort, merge) utilities, computational procedures, options, functions and formats, used within Macros, PROC steps, DATA steps and ODS statements.
• Created member list reports for RCI European members based on their transactions (Exchange, Cash, Deposits and Requests).

Environment: SAS 6.2 on Mainframes (OS/390), UNIX, SAS/Macro, SAS SQL, SAS/Graph, SAS/ Enterprise Miner, MVS/TSO, JCL, VSAM, COBOL, DB2, MS Excel, MS Access.