SAS Programming: Write, maintain, and support SAS Programs in SAS Base, SAS Advance (Proc Sql & Macro) through Enterprise Guide & Linux environment.

· Handling full control on SAS Management Console 9.2 & 9.4 .

· SAS Libraries creation and connection with different data sources as ODBC ini.

· Handled LSF &SASDEMO Scheduler for job and OS based scheduling.

· Knowledge on Scheduling and batch server.

· Handled System and Application downtimes.

· Participate in the production software deployments, upgrades, backup strategies.

· Software/hardware integration planning and will coordinate troubleshooting and make recommendations for the configuration of the SAS application.

· Research best practices and provide pre- and post-implementation documentation.

· Maintain awareness of new SAS releases, patches and upgrades.

· Monitor storage growth and work with user areas to develop purge criteria.

· Coordinate with other IT groups on performance, storage issues, etc.

· Administration of user access and security.

· Performance tuning of both Server and Workstations
Implementation of upgrades and patches to both Server and Workstations.

· Monitoring of servers. Archiving and back-up planning.

Installation of SAS tools on client machine as SAS Add-In.

· Requirement document preparation as per the higher management reporting requirements.

· Coding of SAS scripts for Extraction of data from delimited flat files using Base SAS and SAS/Macros and PROC SQL.

· Generating reports as per clients request using Base SAS, proc report. Required Datasets creation for reporting. Involved in testing the correctness of the data before the delivery.

· Gathering Specification documents and following the SAP (Statistical Analysis Plan).

· Ensures that the programming for Derived data sets, tables, listings and graphs.

· Designed statistical summary tables, listings and graphs, including Patient Demography and Characteristics of Adverse Events, Laboratory tables etc.

· Works with Statistician to develop requirements documents, and develop the code for analysis models.

·

· Involved in converting into SAS datasets from flat files, and excel data as per requirement.

· Manage the data process and create Datasets using SAS/BASE.

· Cleaning of data using data step and SAS/Base Procedures.

· Creating statistical tabulated reports on data by using SAS/STAT.

· Import the data using Proc Import and pass-through procedures with Proc Sql.

· Creating required data format using PROC FORMAT.

· Development of study specific SAS Macros.

· Customize outputs using Output Delivery System (ODS).

· Validates the original SAS program by writing independent SAS code (double programming) and tracks the resolution of issues.

·

· Developed reports using PROC REPORT, PROC TABULATE and PROC SUMMARY.

· Used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT and PROC REPORT, PROC DATASETS, PROC TRANSPOSE, PROC FORMAT, PROC COMPARE.

· Involved on HIPAA (Health Insurance Portability and Accountability Act) was enacted by the U.S.

• Online Enrolment & Payroll Processing (For Fortune 500 US Companies), Workers Compensation Paper Claims, US Health Insurance -Generation Of EOB (Explanation Of Benefit).
• Validate date of the Medi-card (Medical Reimbursement debit card).

· Entering the Direct Deposit Form & Employee Election form for the Employee enrolled in cafeteria plan (section 125).

• Client project in Cafeteria plan at sand Martin (Business Promotion)

SAS SQL Procedure: SQL Pass –Through query, Select, Create, Join, Union

Working in Excel (Pivot Table , Data filter & using Macro for scrubbing

• Working in FSA(Flexible Spending Account) for United states America

Role is SAS Developer & Administrator related activities and also interacting with USA team and end user to resolve their query for data analysis and connection related etc. Data size management activities on Unix – Linux server.

The analytics department has a Data received from different regional areas for the regular customers transactional data. Base SAS, SAS/STAT, Macros and Proc SQL are used to analyze the data. Reports are generated according to the user requirement. Adhoc requests are served to create SAS datasets. Most of the time the sources for this data extraction will be delimited flat files and MS excel and access files. Generating reports by region wise, branch wise, period wise and loan wise.

TRI-AD provides the same custom employee benefits administration solutions like 401K Plan & CDHP (Consumer-driven health plan),high-level expertise to mid-sized companies at a reasonable cost.