Summary

• Extensive experience in handling complex processes using SAS/BASE, SAS/MACROS, SAS /SQL, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/ACCESS, SAS/CONNECT
• Developed SAS Programs to generate new datasets from raw data files using Import Techniques and modified existing datasets using SQL, Set, Merge, Sort, Update, Formats and Functions.
• Performed Data Analysis validation and created the programs as per the specifications required to run the reports.
• Experience in Modifying existing SAS programs and creating new SAS Programs using SAS Macro to improve ease and speed of modifications as well as consistency of results.
• Strong expertise in SAS procedures, reporting and Summary procedures.
• Capable of utilizing data management techniques like Merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step.
• Followed Software Development Life Cycle SDLC methodology for the design, development and testing of various SAS modules.
• Performed PROC SQL joins and worked with PROC SQL set operators to combine tables horizontally and vertically.
• Extensive experience in using relation database management systems RDBMS like Access, Oracle, SQL server and Sybase.
• Strong experience in coding using SAS/SQL, Procedures/Functions and SAS macros.
• Responsible for accessing and managing data and for performing complex queries and analysis.
• Proficient in drawing flowcharts indicating the input data sets, sorting and merging techniques to get the required report.
• Extensively worked on Windows and UNIX environments.
• Good exposure to Health Care data both Eligibility and Expenses and HIPAA Transactions.
• Very good knowledge of ANSI 4010, ANSI 5010, ICD-9 and ICD-10.
• Skilled in writing automated SAS tasks and converting SAS Datasets to various file types including HTML, Excel, PDF, Word as well as converting various file types to SAS Datasets.
• Fine-tuned the programs developed by previous programmers to increase the performance and enhance the efficiency in memory usage, control data storage space, and followed efficient strategies.
• Proven ability to support multiple projects under deadlines often with competing priorities and complexities.
• Excellent organizational, teamwork, presentation, problem solving, decision making and interpersonal skills.
• Ideas exhibiting a can do attitude and seeing problems solvable.
• Can work as an Individual and as a team member comfortably.

Technical Skills

SAS Tools: SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/ODS, SAS/ACCESS, SAS/STAT, SAS/SQL, SAS/CONNECT, SAS/ACCESS and SAS/EG.

Database: Oracle, SQL Server, DB2, MS Access and Sybase.

Operating Systems: Windows XP/7, UNIX and Linux.

Other Technologies: MS Office, Informatica, Mainframes, Lotus Notes, MS Outlook.

Professional Experience

Confidential

SAS Consultant

• Developed and maintained standard programs and utilities to process healthcare data and prepared the data for analytical reporting.
• Interacted with assigned business analysts and project managers to perform work outlined
• Generated highly customized reports using SAS Macro facility, Proc Report, Proc Tabulate and Proc SQL.
• Redesigned SAS Code for better performance and better execution speed.
• Strong experience with queries, inner and outer joins, merging, inserting rows, updating large datasets and removing duplicates.
• Performed SAS programming using techniques as SAS Base, SAS Macros, data manipulation techniques, and statistical procedures e.g., Proc Means, Proc Freq, Proc Report .
• Performed statistical analysis, wrote SAS code for data management and reporting, and performed validation including testing SAS code.
• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macros, SAS/SQL, SAS/Graph, SAS/Connect and SAS/Access.
• Created project specific Macros, Template and Format catalogue.
• Developed, tested and maintained daily/monthly/quarterly reports.
• Debugged and validated programs for logical/ syntax errors in accordance to company guidelines.
• Extensively used SAS /Macro facility to provide reusable programs that can be conveniently used time to time and created tables, listing and graphical reports.
• Generated output files in text format, HTML PDF format using SAS ODS.
• Used SAS/ACCESS to extract data from Oracle and other relational databases for analysis.
• Developed reports using PROC REPORT, PROC TABULATE, and DATA NULL .
• Participated in daily Stand ups.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/GRAPH, SAS/ACCESS, Oracle, Windows 7, UNIX, MS Outlook, MS Office and Lync.

Confidential

SAS Programmer Analyst/Developer

• Worked with the business users in creating a business requirement document BRD for the Data warehouse design to accommodate third party data.
• Retrieved the data from flat files, oracle database with the SQL pass-through facility and created SAS data sets for Analysis.
• Experience in writing UNIX shell scripts, which are used as a source to run SAS batch programs and generate log files, list files and reports in desired directories by passing parameters.
• Worked with MISSOVER and TRUNCOVER options to read the datasets with missing values.
• Performed data management functions including manipulation, validation, review and export to database.
• Developed various SAS Macro programs to analyze the data and to improve the reusability of the codes.
• Used SAS system macros for error handling, code validation, date stamping of log files, collected files to a given directory and scheduling.
• Created SAS Customized Reports using the Data Null technique.
• Created Analysis datasets, and performed validation before report generation using base SAS programming.
• Effectively utilized PROC SQL, PROC MEANS and PROC REPORT for data analysis and generating reports.
• Used SAS Enterprise Guide to create one way frequency reports, list report, and summary statistics, table analysis.
• Ran Ad-Hoc Reports for various business requirements.
• Responsible for accurate and timely data analysis and submissions.
• Estimated and performed feasibility analysis on every service request and accordingly negotiated and prioritized client requests after discussion with the Onsite Coordinator.

Environment: SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, SAS/GRAPHS, Teradata SQL, SQL Server, SAS Enterprise Guide, Windows XP and UNIX.

Confidential

SAS Developer

• Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT and SAS/ACCESS. Used SAS/ACCESS to read datasets from, Databases, Flat files, also read and write other PC File formats.
• Created SAS programs using Base SAS, SAS/Macros and SAS/SQL to generate custom reports and Ad-hoc reports.
• Generated SAS/MACROS and stored procedures for reusability and to minimize data processing.
• Extensively used SQL statement functionalities for analysis of large datasets and for data manipulation.
• Monitored and managed the data feeds into the data warehouse as well as extraction transformation and loading. Created permanent formatted SAS data sets for present and future analysis.
• Extensively worked on detecting, describing and verifying defects, bug tracking and modifying the existing datasets for the improvement of the existing system.
• Validated data from the star schema in data warehouse to transactional database.
• Created and modified shell scripts on UNIX to schedule the program to run on daily, weekly and monthly basis.
• Wrote Shell Scripts performing various steps like running a SAS code, emailing the output files, removing and copying files, archiving files for historical data and zipping up files to send to external locations as attachments in emails.
• Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and SAS/MACROS.
• Created SAS Reports using SAS Enterprise Guide.
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
• Developed Mappings between Source and Target and loaded the data and Validated Data for missing values and based on the requirements.

Environment: SAS V 9.2, SAS 9.1.3, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/SQL, DB2, Mainframes, Informatica, Windows XP/7, UNIX, MS Office and Lotus Notes.

Confidential

Data Analyst

• Analyzed business requirements, applications, data source systems, reporting and analytical requirements to provide solutions that support the business needs.
• Documented the business, functional and technical requirements that are complete, comprehensive and unambiguous, to ensure business users and development staff understand the intent of the request.
• Designed application solutions, data models, source to target map documents, data dictionaries, and Metadata to support a user friendly data and analytic environment.
• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Produced quality customized reports by using PROC TABULATE, REPORT and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Report generation using many SAS procedural statements, SAS/MACROS, and data null steps.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.

Environment: SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS Power Point, Sybase, MS Access, MS Outlook, Windows XP and UNIX.

Confidential

SAS Programmer

• Involved in developing, testing, and writing programs and reports in SAS according to specifications as required.
• Used SAS/ACCESS to read datasets from, Databases, Flat files, also read and write other PC File formats.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Generated highly customized reports using SAS macro facility, Proc Report, Proc Tabulate, PROC SQL, Proc GLM and Proc IML.
• Performed data cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC RANK, and macros in SAS.
• Validated, documented and tested component programs in an efficient manner for inclusion in integrated reports.
• Developed, analyzed and designed SAS programs in UNIX platform.
• Worked with the specified marketing teams to clearly identify the selection criteria needed for each list.
• Ran ad-hoc queries/reports as needed and analysis is done as requested.

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, Oracle, MS Office, UNIX, Windows XP and MS Outlook.