SUMMARY

• SAS Certified Programmer with 9 years of professional experience in SAS, SQL, Data Analysis, Data Mining, and Decision support solutions and Reporting in various projects for Banking industries.
• Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ODS, SAS Enterprise Guide & Tableau.
• Experience with SQL, writing queries, using Left Join, Right Join, Outer Join and Union.
• Strong expertise in reporting and summarizing data using PROC PRINT, PROC CONTENTS, PROC REPORT, PROC MEANS, PROC SQL and PROC FREQ.
• Experience in validating the data sources, extraction of data, applying transformation logic, and loading the data in the target tables DB2 and Teradata using Informatica.
• Efficiently working with all types of input files like XL files, CSV file, Text files and manipulate it and converting them into Database table , SAS Datasets , Flat files like Text Files , excel, CSV, PDF files as per the Business user requirement.
• Experience in accessing RDBMS databases such as Oracle using TOAD, PLSQL, Oracle SQL Developer, Teradata, DB2 and SQL Server and create Database Tables, SAS Datasets, and text & excel files.
• Directly pulling customer data from Teradata SQL Assistance, PLSQL & Oracle Toad.
• Worked with BSA/AML monitoring application team.
• Worked with Consumer Banking department especially with Mortgage, Retail Banking, Credit Card & Anti Money Laundering (AML) teams.
• Creation of Business requirement document (BRD) and Project flow for each project based on business need for respective Line of Business.
• Quality Control, Execution, and Maintenance (Debugging, Enhancements and Testing) of all delivered Production Code.
• Ability to work in fast paced environment with little or no documentation, able to employ new ideas, concepts, methods, and technologies.

TECHNICAL SKILLS

SAS Skills: SAS/EBI, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/MACROS, SAS/ODS, SAS/GRAPH

Operating Systems: MS Windows /98/2000/XP/7/VISTA, UNIX Sun Solaris, LINUX

Languages: SAS, SQL, Shell Script

SAS Procs: SQL, PRINT, REPORT, MEANS, UNIVARIATE, TABULATE, FREQ, CHART, SORT, SUMMARY, CONTENTS, FORMAT, IMPORT AND EXPORT, APPEND, TRANSPOSE, COMPARE

Database: Oracle, Teradata, SQL Server, DB2, MS Access

PROFESSIONAL EXPERIENCE

Confidential - Minneapolis MN

Senior SAS Programmer / Senior Data Analyst

Responsibilities:

• Translate Business Strategy into Business Requirement Document (BRD) & take approval from stakeholders.
• Writing SAS & SQL code to extract data from different databases like Oracle, Teradata, SQL Server by using SQL Pass through and Libname statement.
• Working on Marketing Campaign relates to Mortgage & Home equity. Receive daily leads from external vendor, extract the required fields from databases for the lead, manipulate it, suppress it & create final output file for Email & Direct Mail Campaign. Work with different stakeholders for successful running of Campaign.
• Extracting data from different databases and manipulate it & create a final output file in Excel, Text & CSV as per user request.
• Provide detailed customer information from different sources to case file on regular basis.
• Create output file like Text, Excel, SAS Dataset & Database tables as per the Business Requirement Document.
• Create Audit step to make sure data is error free and as per the request.
• Create output file by using Proc Report, Proc Print, Proc Freq, Proc Means, Proc Contents, Proc Univariate, Proc Datasets, and Proc Append etc.
• Send the final output files to Business teams by using SFTP.

Confidential

Senior SAS Programmer / Senior Business Analyst

Responsibilities:

• Worked with Consumer Banking team especially with Mortgage, Retail Banking, Credit Card & Anti Money Laundering (AML) teams ass Business Analyst as well as SAS Programmer
• Responsible for creating data files for targeted Customer Marketing Campaigns (Email campaign, Direct mail campaign) and customer communications. Complete projects from start to finish (translating business strategy into technical requirements (BRD), generating prospective Customer lists, conducting internal audits, and creating customer profile, suppression and distribution reports).
• Interact with different stakeholders like marketing managers, Strategy team, Accounting team, Risk team to execute targeted customer marketing campaigns across multiple channels including direct mail, email, Statements. Ability to learn the business, study internal data and understand Bank procedures for executing a customer marketing campaign often with tight deadlines.
• Create Business Requirement Document (BRD) and Project Flow in an easy understandable format & take approval from the stakeholders.
• Writing SAS & SQL codes to extract the customer & non-customer data from the database (Oracle, Teradata and SQL Server), manipulate data & convert into different output files to vendors for customer marketing campaign.
• Receiving files from different vendors on regular basis like Text, Excel, CSV etc., manipulate the data & convert them into Oracle, Teradata & DB2 tables, SAS Datasets & external flat files as per requirement. Using Functions, Formats to convert data as per request.
• Extracting data from different databases & manipulate it & create output file in Excel for accounting team.
• Automate & schedule a job in UNIX Environment & sent email to team on the status.
• Create Audit steps to each program to make sure data is error free.
• Worked with BSA/AML monitoring Application team. Getting suspicious activity trigger file from other department on daily basis and provide the detailed information about each suspicious activities on daily basis.
• Worked on Anti Money laundering team to write a program using SAS, SAS EG and create a SAS Data Sets and Data Base Tables for all the customers know your customer (KYC) information, for all business banking accounts opened on daily basis. Created a SAS program to track the suspicious money laundering activity on regular basis & send file to reporting team for further processing.
• Analyze and evaluate data from new and existing operational processes that support AML KYC policies and control.
• Assisted and provided information to support suspicious activity reports (SAR).
• Create final output file as per the Business Requirement Document & send the output file to vendors or Accounting team through SFTP
• Developed SAS Programs for Data Cleaning, Validation, and Analysis and Report generation. Test and debug existing macros using macros debug options like Merror, Serror, Mlogic, Mprint and Symbolgen.
• Generating the various SAS report through procedures like Proc Print, Proc Report, Proc Freq, Proc Means, Proc Tabulate, Proc Transpose, Proc Sql, and Proc Univariate.
• Using SAS/ODS to create Excel, CSV, HTML, Text and PDF outputs files for reporting.
• Participate in the team meeting to discuss the new requirements, campaign programs and the reporting formats.
• Actively involved in designing and developing daily, weekly, monthly, quarterly and yearly ETL (Extract, Transform and Load) processes by using Informatica for different business streams and wrote complex Korn Shell script to automate ETL processes and send out a notification emails to concerned people.
• Extracting data from Different sources, Transformation & Load to DB2, Oracle and Teradata.
• Interact with different teams for the project execution.

Environment: SAS/BASE 9.4, 9.3, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/EG, SAS/ODS, SAS/ACCESS, SAS/CONNECT, SAS Enterprise Guide, FileZilla, WinSCP, Putty, SQL Server Management Studio, Oracle, Teradata, Teradata SQL Assistance, Oracle Toad, DB2, SQL Server, Windows XP, UNIX, Informatica, Notepad++, SharePoint & etc.