Experience

Synmeta LLC

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• SAS Programmer / Statistical Assistant

  • May 2018 - Present

  Responsibilities: • Extracted data from the database using SAS/Access, SAS SQL procedures and created SAS data sets . • Created new datasets from raw data files and modified existing datasets using SET, MERGE, MODIFY, UPDATE and conditional statements. • Extensively used SAS SQL procedure for join and union of tables. • Applied SAS procedures such as PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC SUMMARY and PROC UNIVARIATE for checking missing values/outliers and producing statistical summary report. • Developed and automated many SAS-SQL scripts processes for data file generations. • Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML. • Demonstrated Aptitude at working on multiple projects simultaneously Show less



PRA Health Sciences

• United States
• Research Services
• 700 & Above Employee

• SAS Programmer

  • Oct 2017 - Apr 2018

  Responsibilities: • Divided company announcements into 9 main categories and more than 100 subcategories according to their business characteristics. • Retrieved stock price data from the company database for data preparation. • Modified data using SAS/BASE, SAS/SQL and Macros according to project specifications. • Used PROC STDIZE to impute missing values. • Performed complex statistical analysis using PROC UNIVARIATE to check the data distribution of normality. • Conducted hypothesis tests to examine the impact of company announcements with PROC UNIVARIATE, PROC FREQ, PROC TTEST • Developed SAS Macros to simplify SAS code and effectively reduce coding time. • Troubleshoot, diagnose of issues raised by data manipulation. • Extensively used SAS procedures such as PRINT, REPORT, TABULATE, SUMMARY and DATA _NULL_ for producing statistical reports. • Used SAS/ODS facility to create customized reports in HTML, PDF, RTF. • Documented data reports and model results communicated with the team manager to share the information in a timely manner. • Involved with key departments to discuss the primary model requirements for the project. Show less



LevaData

• United States
• Appliances, Electrical, and Electronics Manufacturing
• 1 - 100 Employee

• SAS Programmer

  • Oct 2014 - Jul 2015

  Responsibilities: • Collected and analysed cross-references and assemblies of Claim Financial data from diverse sources (Including but not limited to Indemnity Payments, Expense Payments, deductible refund, Penalty Interest Payments, Recovery payments, workers compensation periodic payments, sight drafts) for identifying anomalies, interrelationships, trends, and/or patterns. • Developed and performed analysis that show past and current trends for property and casualty claims and provided management with detailed analysis of these production results through summary reports and graphs. • Developed data analytical databases from complex financial source data. Performed daily system checks and used data mining methodologies such as classical regression, logistic regression, association rules and sequence analysis, cluster analysis for finding anomalies, patterns and correlations within large data sets. • Created and delivered reports and presentations with key findings and recommendations. • Provided technical support on SAS programming related to data manipulation and analysis. • Wrote macros, developed concise SAS scripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops. • Exported SAS Reports to the Excel Sheet by using ODS/Tag sets /Excel XP to get the output in multi sheets. • Developed and used scripts to schedule SAS Jobs. • Customizing the existing Macros according to the need and requirement, testing and debugging the Macros and creating more complex and reusable Macros Show less



Kal Informatics Pvt Ltd

• Base SAS programmer

  • Sep 2013 - Sep 2014

  Responsibilities • Review and analyse the business requirements and specifications for the intended system solution. • Developed SAS programs for Data cleaning, Data mining and Reporting and to support routing processing. • Generated Summary Tables, Listings, Figures, and validation of outputs. • Generate HTML, PDF and RTF reports, using SAS - output delivery system ODS. • Extract data from Data Ware housing tables and Data marts using SQL Procedures and generate SAS datasets. • Used Sorting and merging techniques on raw data sets for value added data preparation, to get the required Reports. • Conducted Quality Assurance tests on tasks performed by other team members and involved in data validation and data cleaning. • Used Proc SQL to retrieve, update and report on information from SAS data sets and other database products. • Modification of existing SAS programs and creation of new programs using SAS Macros. • Coordinating production of monthly, quarterly, and annual performance reports categorized in various fields of interest for senior management. Created permanent formatted SAS data sets and used SAS/BASE and its modules for pre-processing data, data analysis, and statistical analysis. Created, documented, and maintained project specific format library and updated the formats catalog with necessary user-defined formats required to generate tables and listings. • Ability to quickly debug SAS compiling errors, to review SAS code and quickly identify areas of concern. • Gathered the requirement business team and analyzed the data. • Performed program documentation on all programs, files and variables for accurate historical records and for future references. Show less