SUMMARY

• Over 7 years of Experience in analysis, design, development, testing, implementation, maintenance and support as a SAS and SQL programmer/analyst with profound experience in finance and insurance industries.
• Experience in SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS,SAS/ODS, SAS/EG and SAS/ETL Studio.
• Expertise in developing SAS applications for reporting and ETL process.
• Excellent command in analyzing data and producing reports by employing various SAS Procedures and modifying existing SAS programs and creating new SAS programs using SAS techniques.
• Extensive experience in creating SAS Datasets and manipulating the data for the preparation of reports, tables, listings and graphs.
• Experience in importing data from flat files, and exporting data to excel and csv files by using Proc Import and Proc Export respectively.
• Generated reports using PROC Report and DATA NULL for customized report writing
• Good experience in storing and managing data in SAS files, merging SAS Data sets, using ARRAYS and MACROS, SAS procedures, SAS FORMATS, and SAS INFORMATS
• Expertise in using Relational DBMS like Access Oracle,Teradata,DB2, SQL - Server database systems.
• Experience in data cleaning, editing, and data purification in SAS data steps
• Experience in using various functions for both text and numeric data as needed
• Experience in implementing data warehousing solutions
• Effective team player with strong communication & interpersonal skills and self-motivated .
• Individual with strong technical & analytical ability

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SAS Developer/Programmer

Responsibilities:

• Extensively used proc SQL and proc GPLOT for creating ad-hoc reports and graphs as per the requirements of the users.
• Used Proc SQL to retrieve data from databases like Oracle, Teradata, DB2 and SQL Server .
• Expertise in using Teradata SQL assistant and SQL plus for writing quires to pull the data from different tables.
• Used SQL functions like AVG(), MAX(), MIN (), and GROUP BY to bring the summary of the data.
• Used SQL statements like CASE for more efficiency.
• Used SQL JOINS to get the desired data from multiple tables.
• Generated listing in Ad-hoc upon request by client/vendor using SAS and SQL Involved in scheduling the processes using Autosys tool for the UNIX shell scripts.
• Wrote JCL(job control launuage) for production jobs to send weekly run output to mailbox.
• Made changes in JCL to solve space issues by saving data in tape instead of disk.
• Used File aid for data research, data compare and data validation.
• Extracted data from unix to mainframe and mainframe to windows by using FTP.
• Modified existing SAS programs and created new programs using SAS macro variables to improve Ease and speed of modification as well as consistency of results.
• Used SAS EDI 9.2 for creating reports.
• Extensively used SAS procedures Print, Sort, SQL, Mean, Freq etc.
• Used AutoSys Job Information Language (JIL) through a command-line interface to create generic modules, which will access database and execute generic SQL.
• Used SAS DI 4.2 for creating reports.
• Created statistical reports by using SAS JMP and JMP add-ins in excel.
• Used EG 4.3 to create stored processes for web reports .
• Developed and modified EUC codes based on user requirements.

Environment: SAS/Base9.2,SAS/ReflectionX,SAS EG5.1,Unix, SAS/SQLSAS/AF,SAS/Macro,SAS/Stat,SAS/Connect,SAS/Access,SAS/Graph, SAS/ODS, SAS/Internet,SAS/ETL,Ms-Excel, Oracle 8i,Teradata, DB2,Teradata SQL Assistant,HP Quality Center,Aprimo,QTP, AutoSys.

Confidential - Wilmington, DE

SAS Developer / Analyst

Responsibilities:

• Extracted data from different sources like Oracle, Teradata and DB2 using SAS/Access, SAS /SQL procedures and created SAS reports.
• Expertise in using Teradata SQL assistant and SQL plus for writing queries to pull the data from different tables
• Experience in loading SAS datasets and flat files to Teradata by writing fast load scripts.
• Involved in writing code using Base SAS and SAS/Macros to extract clean and validate data from oracle and Teradata tables.
• Developed reports using SAS procedures such as PROC FREQ,PROC REPORT, PROC TABULATE, PROC MEANS, PROC SUMMARY, PROC SURVEYSELECT and DATA NULL for analysis.
• Experience in Merging/joining SAS Datasets, Concatenating and Interleaving.
• Good experience in Data Cleaning, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on Windows and UNIX.
• Experienced in creating RTF, EXCEL, PDF, HTML formatted files by using SAS ODS procedure.
• Flat files are converted to SAS data sets by using SAS/STAT procedures for analysis.
• Extensively worked on various RDBMS like Teradata, Oracle,DB2.
• Delivered Ad-Hoc Reports to the customers based on the fly requirements.
• Created new SAS Macros to work with multiple arrays and data sets and can also work with previously existing macros.
• Used SAS for extraction, transformation, loading(ETL) data to databases.
• Used Proc sql functions such as Group by,min(),max(),sum(),having to summary and analysis the data.
• Created data sets and reports by using SAS/Base and SAS Enterprise guide for UAL,OBTM etc marketing campaigns by accessing Teradata and Oracle.
• Used SAS BI tools such as SAS EG,SAS DI studio and stored procedures to produce wed reports.
• Done UAT and testing for accuracy and function of programs.
• Transferring data or files to 3rd party vendors through MDES.
• Wrote Unix shell scripting and used crontab to automate the SAS jobs.
• Maintaining the Cron jobs and automation of the SAS programs.
• Extensively communicated with the Campaign manager, Business Analyst and Testing team during the execution of the Campaigns.

Environment: SAS/Base9.2, SAS EG 4.3,SAS/AF,SAS/EDI,SAS/Macro,SAS/StatSAS/Connect,SAS/Access,SAS/Graph, SAS/ODS, SAS/Internet, Ms-ExcelTeradata, DB2 and UNIX (AIX),HP Quality Center, QTP, AutoSys.Mainframes, SAS MC 9.2,SAS JMP

Confidential, St.Louis, MO

SAS Developer/Analyst

Responsibilities:

• Performed 'Invest' level bank-specific analysis on large data sets including Proprietary Information, such as customer demographics, activity, spends levels and financial information.
• Developed analytic production and ad hoc requests/reports to be used in credit card activation and usage decision-making.
• Responsible for client-specific transactional data analysis, such as point-of-sales and ATM transactions, sales volume and profitability and performance indicators for debit and credit card programs.
• Enhancement of the current consulting offering through the development of more statistically advanced analyses using specific data-mining tools such as SAS software.
• Responsible for providing the consulting team with data preparation, data analysis and statistical modeling using SAS as a primary tool.
• Executed data crunching, write codes, merge/purge/ and split data, and do ad hoc queries/cut data programming in SAS
• Created and consolidated reports using several internal and external sources through the development of standard macros.
• Used EG 4.3 to create stored processes for web reports and also create ad-hoc reports in unix and window.
• Used SAS EDI for data cleansing, extraction, transformation, loading.
• Depending on the business requirements, created different data models from different sources like Teradata,Oracle,DB2,Sybase.
• Reports were created using business objects.
• Worked on EUC codes.
• Generated codes in order to develop and deliver current business solutions through the automation of consulting processes to create more efficiency within the team.
• Generated financial reports by using OLAP.
• Data preparation, cleaning, manipulation, and visualization.
• Extract data from relational databases .
• Developed, updated, and maintained current SAS programs using SAS tools for Windows in a user support environment.

Environment: UNIX, SAS, SAS/BASE 9.2, SAS/ODS, SAS/Connect, SAS/ETL SAS/MACRO, SAS/STAT, SAS/SQL, PROCEDURES, TERADATA,ORACLE, Access, Excel, DB2,SYBASE.

Confidential, Chicago, IL

SAS Programmer

Responsibilities:

• Used SAS v8.2 on Sun UNIX environment and Programming in SAS base and Macros.
• Extracted required data from IBM mainframe to local SAS Environment by SAS FTP and sync sort
• Developed and modified programs in SAS under UNIX environment using SAS/BASE.
• Used SQL pass through to work on Teradata.
• Developed Queries using PROC/SQL to retrieve the data based on the matching columns.
• Developed JCL’s to execute the SAS programs under mainframe environment (OS390).
• Used SAS procedures and preparing daily, monthly, yearly reports.
• Worked with SAS/ODS, HTML to produce dynamic web interfaces from SAS programs
• Used SAS import and Access to import external files. Worked with SAS/Graph to produce graphical reports.
• I have worked on healthcare data and created reports for different teams.
• Involved in risk and portfolio analysis
• Prepared ad-hoc reports and convergence curves of different parameters
• Analyzed data using different procs like ANOVA,GLM and LOGISTIC
• Involved in coding for GUI with SAS/AF, SAS App Dev studio. and SCL

Environment: BASE SAS, SAS/AF, SAS/MACRO, SAS/STAT, SAS/GRAPHSAS/CONNECT,SAS/ACCESS, Ms-Excel, SAS/ODS, Oracle 8i,Teradata, UNIXWindows and IBM Mainframes.

Confidential, Hartford, CT

SAS Programmer

Responsibilities:

• Design and Develop different report templates based on the user specifications.
• Develop reports using PROC REPORT, DATA NULL and SAS MACRO.
• Adhoc reports were created using the SAS procedures.
• Created reports using ODS statements and PROC TEMPLATE to generate different output formats like
• HTML, PDF and EXCEL to view them in the web browser.
• Running report programs and download the results into EXCEL for data analysis.
• Produced Graphical reports showing PIE and BAR charts for analysis while providing the drill down capabilities.
• Used SQL and PROC SQL to work with DB2.
• Moved data sets across platforms from PC to UNIX and Vice Versa.
• Extensively used SAS/BASE, SAS/CONNECT, SAS/SQL, SAS/ODS,SAS/STAT,SAS/GRAPH,SAS/ACCESS and SAS/MACROS for programming.

Environment: SAS 8.1, JCL, SQL, BASE/SAS, SAS Macro, SAS/ ACCESS, SAS/CONNECT, SAS/ODS, SAS/ SQL, SAS/ENTERPRISE MINER, MVS, AIX, Windows NT

Confidential

Responsibilities:

• Understanding the Business and its Requirements.
• Gathering the requirements from user.
• Modifying data using SAS/BASE and Macros.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Gathered user requirements and business need for users.

Environment: Base SAS, MS Excel, Unix,Oracle