SUMMARY

• SAS Certified Base SAS Professional with over Eight years of experience in the analysis, architecture design and development of different applications using SAS in Banking, Telecom and Insurance industries.
• Experience in SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/QC, SAS/ETS.
• Experience in developing SAS procedures, macros, and applications for data cleaning, programming, reporting, and documentation.
• Experience in SQL Server, Sybase, Oracle, MS Access, Excel, Visual Basic and VC++.
• Extensive programming experience with proc SQL, proc report, proc freq, proc tabulate, proc transpose, proc plot, proc chart, proc datasets, proc format, proc compare, proc append, proc import, proc export, proc explode, proc print, proc transpose, proc print, proc report, proc retain, proc drop, proc keep, date manipulations, informats, formats and SAS/STAT procedures.
• Extensive experience with concatenating, interleaving, and merging SAS datasets.
• Experience in writing JCL programs for batch submissions.
• Expertise in using DB2, Oracle and Sybase database systems.
• Expertise in writing utility macros
• Experience working on different operating systems (UNIX, Windows) and on different operating systems working on Mainframes(OS390)
• Working on SAS BI tools like SAS DI Studio, SAS Enterprise Guide
• Experience in writing UNIX Shell Scripts for Batch Processing and JCL programs for Batch submissions.
• Experience in writing JCL programs to communicate with the MVS operating system.
• Experience in implementing data warehousing solutions.
• Experience in problem solving and delivering practical solutions.
• Can work as an Individual and as a team member comfortably.

TECHNICAL SKILLS

Statistical Software: SAS (Base SAS, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ODS, SAS/ACCESS,SAS/IntrNET,SAS/ETL, SAS/GRAPH, SAS/ENTERPRISE GUIDE)

Versions: V6.12,V8, V9.1.3,V9.2.

Operating Systems: Windows 95/98/2000/NT/XP, UNIX, DOS, IBM OS/390

Languages: SQL, PL/SQL, COBOL, JCL, Visual Basic, C, C++

Databases: Access, Oracle, Sybase, SQL - Server.

Software Packages: MS Office, Crystal Reports, Developer 2000, MATLAB, AutoCAD 2000

Web Technologies: HTML, Java Script, Front Page

PROFESSIONAL EXPERIENCE

Confidential, TN

Sr.SAS Programmer Analyst

Responsibilities:

• Application development including Analysis, Design, Testing and Implementation of key Customer Reporting Applications in Clinical IT.
• Design Object relation diagrams, Process flow diagrams and Object models, And write, test and document computer programs, subroutines, and scripts to meet project objectives.
• DevelopSASprograms to extract, transform, clean and manage large data files
• Validate Existing Data Model and identify opportunities for removing redundancies
• Analyze system performance of existing process and improve performance
• Develop scripts, software programs and stored procedures
• SAS data sets to Flat Files, Excel spreadsheets. Unit testing with different possible conditions
• Converted SAS Reports into HTML and other formats using SAS/ODS.
• Wrote shell script programs to run SAS jobs in UNIX, and then scheduling the scripts using Cron tab, at specific day and time.
• Used Toad Data Analysts to connect to Oracle DB2 for data analysis
• Conduct Integrated testing of fragmented code and software by various developers
• Expert knowledge of Key Applications.
• Extensive IT Knowledge of implementing Technical Solutions using the skill sets mentioned above.
• Implementation for Business Problems and Enhancements and recommending solutions.
• Strong System Optimization Techniques for New and Existing Applications
• Coordinate project team activities to meet objectives within prescribed deadlines

Environment: SAS 9.2 - Base SAS, Macros, SAS Connect on Windows and AIX, Unix Shell Scripts, DB2, Toad for Data Analysts, Subversion SVN, MS Office and Windows XP

Confidential, OH

SAS Developer/Analyst

Responsibilities:

• Using SAS v9.2 on Sun UNIX environment and Programming in SAS base and Macros.
• Interacted with assigned business analysts and project managers to perform work outlined .
• Participated in daily stand-ups (SCRUM)
• Accessed multiple databases using SAS and provided ongoing reporting that supported information-based decision making, measured the execution of DODD strategy, and identified opportunities for improving existing processes.
• Background in formalized process controls for change management.
• Knowledge of AGILE software development methodology.
• Strong interpersonal and leadership skills.
• Developed, tested and maintained daily/monthly/quarterly report.
• Met regularly with Job and Family Services management and analysts to determine, interpret and program solutions to the information needs of the branches.
• Investigated and defined system capabilities, evaluated current and potential system technology needs for performance.
• Documented policies and procedures required for supporting system enhancements.
• Worked with SAS/ODS, HTML to produce dynamic web interfaces from SAS programs.

Environment: Base SAS, SAS/Macro, SAS/SQL, SAS/Connect, SAS/AF, SAS/Graph, SAS/Access, SAS/Stat, IBM Mainframe, Windows NT and UNIX.

Confidential, Wilmington, DE

SAS Programmer

Responsibilities:

• Used SAS v8.2 on Sun UNIX environment and Programming in SAS base and Macros.
• Scheduling the DI Studio Jobs.
• Extracted required data from IBM mainframe to local SAS Environment by SAS FTP and sync sort.
• Used UNIX Shell Scripting for batch processing.
• Developed and modified programs in SAS under UNIX environment using SAS/BASE.
• 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.
• Involved in risk and portfolio analysis
• Prepared ad-hoc reports and convergence curves of different parameters
• Analyzed data using different procedures 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/GRAPH, SAS/ CONNECT, SAS/ACCESS, Ms-Excel, SAS/ODS, Oracle 8i, UNIX, and Windows NT, IBM Mainframes

Confidential, Overland Park, KS

SAS Analyst

Responsibilities:

• Extracting large data from Oracle to SAS data sets by extensive use of PROC SQL
• Extracting tables from Teradata using SQL and also converting flat files to SAS datasets
• Created SAS datasets in local SAS directory.
• Coding to convert different geographical values into numeric values for use in the program and to implement different transformation techniques.
• Introduced new variables with the existing variables based on business logics of Sprint
• Writing macros to develop a concise code.
• Raised queries on the existing databases to provide ad-hoc reports using SAS/SQL
• In these datasets duplicate records are taken off if any present
• Depending on the report to be generated specific dates or specific locations records are only extracted.
• Merging the datasets to provide the users with the data in the required form
• These merged datasets are transformed and loaded into SPDS using SAS/ETL
• Interacting with other team members and lead to discuss the required developments to be made in coding to improve the functionality and effectiveness.
• Generated analysis reports, graphs using SAS/Reports and SAS/ODS to produce RTF and HTML report.
• Maintained the entire project and its contents using SAS/Enterprise guide and SAS/ETL.
• Responsible for the maintenance of the multi dimensional database using SAS ware house administrator

Environment: BASE SAS, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/EG, SAS/ACCESS, SAS/WA, SAS/ETL, SAS/ODS, MS-Excel, Oracle 8i, Teradata, UNIX, and Windows NT

Confidential, Atlanta, GA

SAS programmer

Responsibilities:

• Analyzed current Mainframe environment
• Migrated and made changes in SAS programs, to make them work in Unix without losing their functionality
• Migrated SAS datasets(6 million records) from Mainframe to Unix
• Coded new SAS programs in Unix using SAS/base
• Schedule SAS programs in Tivoli to replicate Mainframe scheduling environment
• Wrote shell scripts and awk scripts to track running jobs
• Wrote SAS programs in UNIX using the VI editor and was also involved in executions of them from different servers using the ssh and rsh.
• Scheduled jobs using crontab file
• Wrote different queries to retrieve the data and joins to get the data based on matching columns using PROC SQL
• Created, updated and maintained tables views and indexes
• Written different bteq scripts for loading the tables in teradata from flat files
• Used sql Assistant in Teradata to run the queries as per the ad-hoc requests
• Wrote Macros to develop a concise code
• Modified the existing SAS programs to save time and resources
• Wrote JCL programs for submission of different SAS programs and data in batch files to the mainframes(OS390)
• Developed a Visual Basic application and passed the macros from SAS to VB to calculate the risk factors and variables involved in marketing
• Used sdsf for determining the input, output and held status of jobs
• Used different SAS procedures like proc tabulate, proc report, proc sort for different utilities
• Created ad-hoc reports and graphs as per the requirements of the users
• Prepared well documentation of the process for maintenance purpose

Environment: Unix (HP-UX11), SAS (V6.09 on Mainframe, V6.12 on Unix and V8 (in Mainframe and Unix), Shell Scripts, awk scripts, BASE SAS, SAS MACROS, SAS/ACCESS, SAS/CONNECT, SAS-SQL, MVS, JCL, Teradata, Oracle