PROFILE SUMMARY:

• Over 8 years of experience in SAS programming as well as the SAS BI Suite and around 3 years as SAS lead.
• Extensive experience on SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/CONNECT on Windows, UNIX environment.
• Extensively used SAS to extract, transform and load data into warehouse.
• Proficient with SAS procedures, PROC TABULATE, TRANSPOSE, SQL, MEANS, FREQ, SORT, CORR, UNIVARIATE, FORMAT, REPORT, SUMMARY, APPEND, CONTENTS.
• Proficient with PROC CHART, PROC GCHART, PROC GPLOT.
• Extensive experience with concatenating, interleaving and merging SAS datasets.
• Used SAS ODS to deliver output in different formats (HTML, RTF and PDF).
• Proficient in creating custom reports.
• Well versed with all SAS functions that include Base SAS, SAS/Macros, SAS/ACCESS, SAS/ASSIST, SAS/CONNECT, SAS/GRAPH and SAS/STAT and in Unix and Windows environments.
• 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.
• Coded and tested SAS program to create Summary Reports.
• Developed SAS programs using Proc Tabulate, Proc Report and Data Null.
• Strong skills in Oracle, MS Access and creating data sets and macro variables using Proc SQL.
• Good communication skills, ability to work in a team and highly motivated.
• Well versed with Software Life Cycle and Data Warehouse Life Cycle.
• Expertise on various BI Suite tools like: SAS Enterprise Guide, SAS Management Console, SAS Stored Process Server, SAS Web Report Studio and SAS Information Delivery Portal.

TECHNICAL SKILLS:

SAS BI Tools: Enterprise Guide,Base, Macros, Graph, Access, Stat

Management Console: Web Report Studio, Information Delivery Portal

Operating Systems: Windows NT, XP, UNIX, MS Dos

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

Utilities: MS: Office 2003 and 2007

PROFESSIONAL SUMMARY:

Confidential, Littlerock

Environment: SAS/Base, SAS/Macros, SAS/Access. SAS Enterprise Guide

Lead Programmer

Responsibilities:

• Interacting with onsite coordinator and client.
• Requirement gathering and understanding the specs.
• Task Estimation and develop frame work for reporting
• Prepare Web based reports as well as Dash reports
• Assigning work to team as per work - plan.
• Providing technical assistance to the team.
• Giving SAS training to the new resources.
• Review the assigned tasks of the team.
• Verifying the test result by checking the Actual result with the expected result.
• Maintain proper back plan for each resource tasks
• Get the approval from the client for completed tasks.
• Involve in production implementation activities.

Confidential, Littlerock

Environment: SAS/Base, SAS/EG, Dashboard 4.3

Lead Programmer

Responsibilities:

• Created Packages using SAS Stored Process.
• This package has different datasets, which will be used as indicator in Dashboards.
• All the indicators are clubbed into single dashboard corresponding to each project.
• All the efforts are exported into excel format when selected through dashboard.

Confidential, Littlerock

Environment: SAS/Base, SAS/Macros, SAS/Access. SAS/EGMAINFRAME FOCUS, Web-Focus

Lead Programmer

Responsibilities:

• Interacting with onsite coordinator and client.
• Requirement gathering and understanding the specs.
• Task Estimation
• Assigning work to team as per work-plan.
• Providing technical assistance to the team.
• Understanding Mainframe FOCUS applications recoded into SAS
• Testing Performance of SAS application compare to FOCUS applications
• Verifying the test result by checking the Actual result with the expected result.
• Maintain proper back plan for each resource tasks
• Get the approval from the client for completed tasks.
• Involve in production implementation activities.
• Post production jobs monitoring

Confidential

Environment: SAS EG, SAS/Base 9.2, SAS/Macros, SAS/Access,Teradata

Sr. SAS Programmer

Responsibilities:

• Understanding scientific data across clinical documents
• Documenting the development plan and Quality check steps
• Query and Analyzing the data from information warehouse
• Data preparation
• Data cleaning and validation
• Creation and modification of relevant attributes
• Aligning the attributes position, naming convention, label and formats
• Creating the final report with client specification formats
• Quality checks
• Steps are followed as per development plan
• Code standardize and annotation
• Check/uncheck the Quality check documents by monitor the logic, constrains, attributes position, naming convention, label, formats etc…
• Codes and results are followed as per Quality standards then sharing to clients through SharePoint

Confidential

Environment: SAS/BASE, Macro, SQL, Oracle MS Excel 2007 & 2009.

Sr. SAS Programmer

Responsibilities:

• Access remote files by using Filename statement, FTP Access Method.
• Count the number of observations based on line of business and other key variables
• Creating required datasets by using extracted data based on different products and markets.
• Calculating disruption frequencies based on line of business by using Freq applications .
• Performing the referral code analysis for each line of business.
• Calculating frequencies based on referral codes.
• Combine different data sets by using Merge or join Statement.
• Calculating Descriptive statistical results
• Generating alerts based on UCL and LCL values.
• Writing Automated Email generation code in SAS to receive the alert information.
• Monitoring Report process.

Confidential

Environment: SAS/BASE, Macro, SQL, Mainframes, Oracle.

Sr. SAS Programmer

Responsibilities:

• As a team member,
• Access remote files by using Filename statement, FTP Access Method.
• Creating required data sets based on application requirement.
• Applied transformations for structuring the data by using SAS procedures, Functions & Merge Statement.
• Experienced in using Proc SQL, Proc Print, Proc Append, Proc Means &Proc transpose, Proc report.
• Played Key role in Generating and Delivering Listings Reports.
• Generated reports in ODS, HTML, RTF formats.