SUMMARY

• 7+ years of Experience in financial data analysis, healthcare data analysis to compile and analyze large data sets including data step processing, data mining, data manipulation, macro creation, data transformation.
• Strong Experience in SAS Data warehouse, ETL, Business Analysis, SASAd - Hoc Reporting.
• Good knowledge of importing data from Oracle, DB2 and Teradata using SAS/ACCESS explicit SQL pass-through facility and Libname statement in both UNIX and windows environments.
• Extensive experience in using the Set, Update, Modify and Merge statements for Creating, Sorting, Updating and Merging various SAS datasets.
• Experience in creating and using reusable macros for large handling data sets.
• Strong hold on SQL queries especially in handling large data sets with SQL joins using PROC SQL.
• Good experience in creating and using table lookups.
• Strong experience in writing complex SQL sub queries.
• Experience in scheduling SAS jobs using UNIX crontab file.
• Sound knowledge of Agile/Scrum methodologies.
• Good experience in creating Hash objects for performing table lookups.
• Thorough knowledge of various UNIX commands and shell scripting using VI editor.
• Thorough knowledge in SAS Procedures, SAS Functions, SAS Statements, SAS Formats, SAS Informats, and SAS Dataset options, SAS System Options, SAS Reports, and SAS Access.
• Proficiency in importing different types of external files(Excel, CSV, txt, etc.) into SAS libraries and exporting SAS data sets as external files using PROC IMPORT, PROC EXPORT, and SAS DATA steps.
• Thorough knowledge in SAS Procedures like PROC SORT, PROC APPEND, PROC CONTENTS, PROC DATASETS, PROC COPY, PROC FORMAT, PROC PRINT.
• Command in producing tables, listings, and reports employing SAS procedure steps such as PROC REPORT, PROC MEANS, PROC SUMMARY, PROC COMPARE, PROC TABULATE, PROC FREQ.
• Experienced in using SAS ODS to create output data sets and RTF, HTML, PDF, CSV files.
• Proficient in creating and maintaining many datasets using ARRAY, MERGE, UPDATE, SET and PROC SQL.
• Effective communications liaison between business and technical groups, creative and resourceful, problem solving with excellent decision-making capabilities.
• Self-motivated individual with strong technical & analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Statistical Software: BASE SAS, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/GRAPHS

Programming Languages: C, Objective C, Core JAVA, SQL, UNIX Scripting

Databases: ORACLE, DB2 and Teradata

Application Software: MS Office (Word, Excel, Power Point, Access and Visio)

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr.SAS Programmer / Analyst

Responsibilities:

• Performed daily, weekly, monthly and ad-hoc reports as per deliverable schedules.
• Used SQL pass through facility to connect to Oracle tables and created datasets using various SQL joins.
• Experience in data manipulations including the usage of basic standard SAS procedures such as Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary as well as traditional SAS data step programming in Unix Environment.
• Role involves liaising with the Business Planning Unit and with the Business Support Unit, to obtain requirements and data and segment customers to design and pitch specific financial products.
• Experience in bringing large data from SAS and non-SAS (Teradata or Oracle or DB2 database) data sources into a SAS environment and performing SAS data manipulations against the resulting sets. This includes ability to merge datasets and to write SAS Macros and generate list outputs/reports.
• Validating and testing all code for accuracy and efficiency.
• Completing necessary documentation to evidence the code matches requirements and that it meets department’s quality standards.
• Providing good time line estimates for coding based on functional specifications and manages expectations with business partners.
• Communicate with business contacts as necessary to help explain results.
• Creating Hash objects for combining SAS datasets and performing table lookups.
• Scheduling SAS jobs to run on regular intervals using UNIX crontab file.
• Written shell scripts to automate daily tasks.
• Involved in code changes for SAS programs and UNIX shell scripts.
• Created profiling reports for all the datasets created and also done standardization.
• Implementing various performance improvement techniques to reduce I/O, CPU time and memory usage.
• Extensively use of SQL for Queries, Joining, and Merging, Concatenation of different tables for data extraction from different databases.
• Creating and maintaining SAS datasets that are extracted from ORACLE database tables and convert them to SAS data sets.
• Extract raw data from files of different formats (csv, flat file) using Proc import and import wizard

Environment: SAS/BASE, SAS/MACRO, SAS/STATS, SAS/SQL, SAS/ACCESS, SAS/ODS,SAS Enterprise Guide, Teradata, Oracle, Db2,UNIX, MS Excel, MS Visio, MS Project.

Confidential, Tampa, FL

SAS Programmer/ Analyst

Responsibilities:

• Created profiling reports for all the datasets created and also done standardization.
• Responsible to integrate the new portfolios data into the reports.
• Responsible to work on the Adhoc Requests.
• Extracted event defining information from the Oracle and Teradata using SAS/ACCESS implicit/ explicit SQL Pass through and ran statistical analysis using SAS/STAT.
• Handling data anomalies when pulling data from Oracle and Teradata.
• Coordination with onsite team for issue resolution and daily status tracking updates to project lead as well as to onsite team.
• Built a batch application that recreates business procedures using SAS Base, SAS macro and SAS Access, basic SAS Stat
• Extensive use of SAS/BASE and SAS/STAT for producing tables, listings, figures, and generating statistical reports.
• Extensively worked on PROC CHART and GPLOT to produce visualization of data in the form of graphs.
• Create process flow for the SAS jobs using MS Visio and send to testing team.
• Provide day to day direction to the project team and regular project status to the customer.
• Developed standard reports using Base SAS and Macro Language.
• Involved in effective communication between the project team and the customer.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• Prepared Unit & System Test cases.

Environment: SAS/BASE, SAS/SQL, SAS/Macros, SAS/STAT, SAS/ACCESS, MS EXCEL, ORACLE, Teradata.

Confidential, Bridge Port, CT

SAS Programmer

Responsibilities:

• Developed SAS programs to create a customer mailing list for Direct Mailing and Telemarketing.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Performed data analysis, created reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures.
• Used PROC SQL Pass through Facility to work with ORACLE and DB2.
• Created new programs and modified existing programs.
• Generated graphs using SAS Report and SAS /GRAPH.
• Created reports using SAS /ODS and SAS /views from oracle database tables into different formats like HTML and RTF
• Worked with large customer response and sales data sets.
• Worked on creating SAS Data sets from flat files and merging data.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Data processing and validations were done extensively on the SAS datasets using edit check programs.
• Conducted individual account and household level analysis.
• Conducted significance tests and study response rates for different offers.
• Analyzed response and sale results and write up monthly summary on campaign performance.
• Created Data Models for different level of Marketing based on the reports.
• Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.
• Restructured SAS datasets using PROC TRANSPOSE procedure.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS Enterprise Guide, SAS/ODS, MS Excel, MS Visio, MS Project, Oracle, UNIX.

Confidential

SAS Programmer

Responsibilities:

• Worked with market segmentation, channel management and customer credit groups to benchmark company’s requirements and expectations.
• Created metadata objects by creating the data sources, targets and data transformations using the source, target and process designer of the SAS Data Integration Studio.
• Created Lookup, Fact and Dimension tables and Identifying the mapping data into specific domains as per the data model using SAS Enterprise Guide by creating the DATA and PROC steps as process tasks.
• Involved in the Administration of the user authentications, metadata repositories, job scheduling, stored processes, data cleansing.
• Experience in creating OLAP cubes for reporting of pre-summarized large datasets and decision support systems using SAS Data Integration Studio and publish the same for business users.
• Extensively used DATA NULL, TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, SQL and GPLOT procedures.
• Created and extracted Oracle tables from SAS and within Oracle by using PL/SQL using SAS/ACCESS and SAS/CONNECT.
• Produced multi-dimensional reports and tables using procedures PROC/REPORT, PROC/TABULATE, PROC/SQL and DATA NULL .
• Perform analysis of data for use in Cross-selling, created graphs using PROC GPLOT, GCHART. Created and updated permanent SAS formats for future analysis and reports.
• Analyzed market characteristics using SAS/STAT procedures that include, Proc Univariate, Proc Reg, Proc Logistic, Proc Cluster, etc.
• Developed and executed approaches regarding segment based analyses and customer value changes.

Environment: SAS 9.1, SAS/ODS, SAS Enterprise Guide 4.2, SAS Data Integration Studio, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, SAS/Stat, PL/SQL, Oracle, UNIX, MS Office, MS Access.

Confidential

Clinical SAS Programmer

Responsibilities:

• Provided SAS programming and statistical support to Clinical studies.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools- SAS /Base, SAS /Macros, SAS /Graph, SAS /SQL, SAS /Connect and SAS /Access.
• Programmed custom analytic studies from definition of diseases or drug usage and appropriate outcomes through creation of a summary file to production of tables and graphs
• Involved in the Pharmaceutical Data Analysis Reports extensively using Base SAS, SAS /Macros, SAS /Graphs and SAS /Reports (i.e.) with the help of Default Procedures and also involved in Programming of SAS for Clinical Research data using load/access process for phase 1, 2, 3 & 4 of Clinical Trials.
• Worked with Clinical Trials data like Demographic data, Discrepancy data, Adverse Events, Serious Adverse Events, Laboratory data, Physical and Vital Signs and Audit Trials.
• Developed data formatting and table generation programs necessary to support the reporting of the Clinical trial data to regulatory agencies.
• Written, tested and maintained programs used for reporting of data collected during Clinical trials.

Environment: SAS 8, SAS /Base, SAS /Macro, SAS /SQL, SAS /Graphs, SAS /STAT, SAS /Connect, Clinical Studies in Phase I trial and 5 Clinical Studies in Phase II, III, IV trials.