SUMMARY

• SAS Programmer with over 8 years of experience in designing, developing, testing & validating applications Financial, Banking, Media, Health Insurance
• Proficiency with Base SAS, SAS Macros, SAS/Access, SAS/Connect, SAS/SQL, SAS/STAT, SAS/Assist, SAS/Graph, SAS/ODS.
• Successfully handled responsibilities for extracting internal/external data from databases and flat files, merging SAS data sets, also optimized the performance using data validation, data cleaning using statistical procedures like PROC FREQ, PROC MEANS, and PROC UNIVARIATE.
• Conversion of SAS Datasets to various file types including HTML, Excel, PDF flat files, PDF, RTF formats using SAS/ODS.
• Used SAS/SQL to merge data files, combine data sets and tables, and transform data
• Successfully conducted testing of the developed codes to meet the business and technical requirements
• Used SAS Procedures such as SUMMARY, FREQ, MEANS, UNIVARIATE, SORT, PRINT, TABULATE, GPLOT, GCHART and REPORT, in order to compute elementary statistical measures, and produce data listings, tabulations & graphical displays
• Used DATA NULL FILE and PUT statements to create the customized reports.
• Created reports in the style format using ODS statements and PROC TEMPLATE.
• Developed SAS macros to generate graphs and reports based on combined datasets, performed statistical analyses with output delivery procedures
• Experience in performing Ad Hoc Queries for various application and reports on a daily basis using complex SQL Queries.
• Strong analytical, modeling, communication & presentation skills
• Involved in complete Software Delivery Life Cycle (SDLC) in large data warehouse environment.
• Experience in using SAS to read, write, import and export to another data file formats, including Spread sheet, Microsoft Excel and access tables.

TECHNICAL SKILLS

Statistical Software: Base SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/Access, SAS/Assist, SAS Enterprise Guide

SAS Procedures: Sort, Transpose, Tabulate, Print, Contents, Means, Chart, Plot, Univariate, Summary, anova, logistic, glm, mixed, Reg, SQL, Copy, gslide, upload, download, Printto, Datasets, Format, Boxplot, freq.

Tools: MS Access, Excel, Word, PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Data Analyst/SAS Developer

Responsibilities:

• Worked with large customer response and sales data sets and presented results to the users. Simultaneously tested the integrity of the mails, addresses in the database.
• Experience in designing, developing, and maintaining synchronous and asynchronous internal and external interfaces and associated secure data transfer protocols and mechanisms
• Generated SAS/MACROS and stored procedures for reusability and to minimize data processing
• Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and SAS/MACROS
• Analysis: Data preparation, analyze variables, create variables, development and comparison of multiple segmentation models, profit calculations and optimization of selected model, creating and modifying reports
• Coordinate with business and other IT developers to understand requirements and develop optimized solution
• Created new programs and modified existing programs.
• Validation of input character data using Proc FREQ and numeric data using Proc UNIVARIATE
• Read files from multiple data sources and get them into a SAS data set.
• Output data in multiple formats like text files, html files, etc.
• Combined multiple data sets into one by concatenating, interleaving data sets by One - to-One merge or by updating one data set with values from another.
• Widely used SAS procedures to summarize data
• Utilized organizational, interpersonal and communication skills to plan and accomplish goals.
• Worked with a team-oriented approach to project management and problem resolution.

Environment: SAS, SAS/BASE, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS/SQL, Excel/Access, Windows - XP.

Confidential, Golden Valley, MN

Sr. SAS Developer

Responsibilities:

• Documented the Business Process and Business Functionality, and translated them to requirement specifications document via specific tool
• Extract the data from raw txt files, and different database like (Oracle, Sybase) through LIBNAME and SQL Pass through facility
• Developed stored processes, information maps and web reports using SAS Enterprise Guide, SAS Information Map Studio and SAS Web Report Studio
• Worked on existing and developing new store processes in SAS EG on SAS eHP portal in all environments severs
• Extensively used Advance Macros for developing store process in SAS portal
• Used DB visualizer to analyze and query from the ORACLE and SYBASE
• Used SAS Data Step logics to Sort, Merge, Stack, Update, Array, Retain and Interleave datasets for producing required analysis of data and used SAS Business Intelligence to produce required Reports.
• Used Excel tag set xp to create multiple worksheet in XML version of report in MS Excel
• Used various MACRO functions such as MPRINT, SYMBOLGEN, MLOGIC to Debug store process and SAS code
• Create different types of output files in different format like PDF, EXCEL, HTML and TEXT DELIMINATED FILE
• Extensively performed Data Cleansing during the ETLs Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros

Environment: SAS, SAS/BASE, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESS, SAS/SQL, Excel/Access, Windows - XP.

Confidential, Deerfield, IL.

SAS Programmer/Analyst

Responsibilities:

• Worked on generic prescription utilization statistical data.
• Familiarized with cGMP’s, and regulatory requirements of the company.
• Read files from multiple data sources and get them into a SAS data set.
• Output data in multiple formats like text files, html files, etc.
• Combined multiple data sets into one by concatenating, interleaving data sets by One-to-One merge or by updating one data set with values from another.
• Extensively use of ODS (Output Delivery System).
• Widely used SAS procedures to summarize data.
• Created own SAS and SQL based queries in SAS.
• Proactively used Microsoft Office programs and tools required to generate custom reports in excel.
• Used SAS/Stat software for Statistical Analysis, procedures, and reports. Created Summary Reports and Tabular Reports using Proc Report.
• Also worked on Spotfire to identify the patient statistics in the clinical study.
• Perform all responsibilities in accordance with company policies, procedures, federal regulations, and safety requirements.
• Utilized organizational, interpersonal and communication skills to plan and accomplish goals.
• Worked with a team-oriented approach to project management and problem resolution.
• Provide Statistical Programming teams with technical solutions and organizational support to resolve complex problems within budget and timeline constraints, while assuring high quality standards.
• Contribute to the design and review vendor proposals and supported back-end analysis
• Actively manage outsourced activities to assure they met timeline, budget, and quality expectations.
• Lead and develop processes and global tools that increase the efficiency and ability of the Statistical

ENVIRONMENT: SAS/BASE, SAS/GRAPH, SAS/MACRO, SAS/STAT, WINDOWS N

Confidential

Senior SAS Programmer

Responsibilities:

• Worked on different Phases of clinical trails including pre and post marketing surveillance studies with different pharma clients like Pfizer, Abbot, Wythe, NIMS etc. to help them assess/evaluate the safety and efficacy of the study drug.
• Creating safety and efficacy TFL’s (like Adverse Events, Demographic listing, Vital Signs, Dose discontinuations, Reason for withdrawal by treatment etc.) using BASE/SAS, MACROS, SAS/GRAPHS, SAS/STAT.
• Testing raw data for out layers or data inconsistencies using univariate and frequency procedures.
• Working with data management team to help resolve data inconsistencies, redundancies and duplications.
• Creating various tables using data manipulation techniques like merging, appending, concatenating, transporting and sorting using different statistical procedures like sort, transport, tabulate, means, freq, anova, ttest etc.
• Generating summary reports for drug data, adverse events, serious adverse events, quality of life questionnaire, laboratory data, discontinuation data and dosage data using proc report, proc template and proc summary.
• Running descriptive statistics for demographic data based on statistical analysis plan and table shells.
• Writing programs for data validation by checking data distribution, consistency of statistical values generated as part of normal quality procedure.
• Generating output files in the form of listing, HTML, RTF and PDF formats using SAS ODS.
• Coordinating with the team leader and the senior statistician.