SUMMARY

• Base SAS Certified with over 9 years of extensive experience in SAS programming on Windows Platform, also having knowledge in updating, data extraction, transformation and loading to data warehouse
• Experience in Data analysis and Reporting in health care and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of marketing and health care data and in the production of reports, tables, graphs and listing.
• Developed new or modified existing SAS programs to load data from the source and create specific datasets.
• Significant experience in requirement gathering, building, designing and testing the application to meet the functional Design and Business Process Design
• Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis.
• Involved in coding and pulling data from various oracle tables using ODBC connection.
• Customize the variables to user - defined formats usingPROC FORMATin printing reports.
• Experience in working with SASEnterprise Guide Software for reporting and analytical tasks
• Excellent knowledge about drop, keep, retain, and date manipulations, formats, in-formats
• Excellent knowledge of SAS/ODS to export SAS results into different formats including RTF, HTML, PDF, XML
• Ability to provide quality deliverables and learning as per the standards.
• Experience inSAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, in Windows environments
• Experience in validating SAS Datasets, Tables, Listing and Figures using Proc Compare Procedure.
• Having excellent command in producing reports employing various SAS procedures like Proc Print, Proc Report, Proc Tabulate, Proc Mean, Proc Freq, Proc Univariate, Proc Transpose, and Data NULL
• Used SAS Macros extensively in the creation of new programs as well as the modification of existing programs to improve ease and consistency of results.
• Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly
• Highly self-motivated and goal-oriented professional to work individually in a team environment.

TECHNICAL SKILLS

Operating Systems: MS Windows, Unix

Language: SAS 9.2, 9.4, SQL, Objective C.

SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS, SAS /Graph Database MS-Access, Oracle, Metadata Other Technologies Microsoft Office (Word, Excel, PowerPoint, Outlook)

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Statistical Programmer

Responsibilities:

• Maintained complex and reusable Macros and extensively used existing macros and developed SAS Programs.
• Planning and coordinated statistical programming activities on study level May integrate databases from multiple studies or sources
• Involved in Analysis & Marketing Team to make business decisions
• Interacting extensively with end users on requirement gathering, analysis and documentation
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements.
• Generating Tables, Graphs and Listings for inclusion in Clinical study reports and regulatory submission;
• Interacts with Data Management and Biostatistics staff and other SP team members to negotiate timelines, responsibilities, and deliverables.
• Modified macros for report generation using SAS Macros as per the statistician’s requirements.
• Working modification as per company standard macros study level
• Design, develop and review the SAS programs from the scratch and modified/updated existing programs.
• Handled Ad-hoc requests with minimal guidance.
• Assists with development, implementation, maintenance, and user support of programming tools within Statistical Programming
• Performs other duties as directed by SP management.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Coordination with Study team and Team members.
• Used standard and global macros for specific needs to improve the quality of work.

Environment: SAS9.4, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS,, SAS/MACROS, WINDOWS10.

Confidential, CA

SAS Analyst

Responsibilities:

• Provided assistance for health care projects through SAS statistical and analysis software tools
• Supported SAS Programming activities for membership and claims data and involved in software development life cycle of the project.
• Work on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Create new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Co-coordinating with Centers of Medicare and Medicaid Services (CMS) to annually calculate the mortality measure based on Medicare enrollment data for public reporting.
• Developed an automation technique for scheduling SAS jobs using advanced SAS Macro code.
• Reduce programming time by developing reusable SAS programs which in corporate data step views and DATA steps that write SAS programs
• Designed and developed continuous outcomes reporting for multiple intervention programs.
• Coordinated with technical teams for research and evaluation of healthcare and operational problems.
• Determine the resources used by the SORT procedure and avoid unnecessary sorts by using appropriate indexes, data set options, BY statement options, and the CLASS statement.
• Ability to perform data entry validation, Report generation and quality assurance.
• Developing projects including designing, coding, implementation and maintenance using technologies such asSAS, PROC SQL, PROC FREQ, PROC MEANS and PROC REPORTS.
• Mange reporting team includingSASAnalyst, Report Developers, Data Analysts.
• Work closely with departments to validate/confirm data for official announcements to risk management committee.
• Collecting the data from CMS Release Notes.
• Worked as different claims i.e. Diabetic Measure, Advance care plan, Asthma Assessment, Brest cancer resection, Flue shot measure etc.
• Working with health care coding conversion with ICD, ICD10 as well as CPT and HCPCS.
• Working together with Finance, Pricing and Operations to implement various Projects, Analysis, and Reports.
• Implemented project management methodology in daily work activates.
• Protected health information as per the HIPPA rule.

Environment: SAS9.4,SAS/BASE,SAS/STAT,SAS/SQL,SAS/MACRO, SAS/ODS, MS-OFFICE(Excel).

Confidential, PA

SAS Programmer

Responsibilities:

• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Generated Tables, Graphs and Listings for inclusion in Clinical study reports and regulatory submission;
• Modified company standard macros as per study level
• Developed programs from the scratch and also modified/updated existing programs.
• Provided SAS programming support to Statisticians and Data Managers to develop Clinical Reports.
• Responsible for writing and debugging statistical programming and documented programming procedures.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Used SAS ODS to generate TFLs as per shell.
• Used standard and global macros for specific needs to improve the quality of work.

Environment: SAS9.2, SAS/BASE, SAS/GRAPH, SAS/SQL, SAS/ODS,, SAS/MACROS, WINDOWS7

Confidential - Herndon, VA

Application SAS Developer

Responsibilities:

• Experience in extracting data and creating SAS datasets from various sources like Oracle database, Access database, Excel and flat files using Import techniques.
• Used ODS to display outputs in HTML, CSV or other file formats.
• Maintenance of reports and enhancements done through Change Management process.
• Experience in PROC SQL joins and PROC SQL set operators to combine tables horizontally and vertically.
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE PROC REPORT and PROC COMPARE
• Created Macros and developed SAS programs for Data cleaning, Validation, Analysis and Report generation using newly created as well as existing macros.
• Extracted data from Oracle views using various SAS/Access methods including Libname statements and the SQL Pass Through facility.
• Used data step options like KEEP, DROP, RENAME, IF, WHERE, COALSECEC, when reading raw data files.
• Acted as a resource to team in providing SAS programming support as well as completed any Additional tasks needed to meet project deadlines.
• Used programming tools such as SAS BASE V9.3 (Windows and UNIX), SAS MACRO, SAS ACCESS, PROC SQL, SAS SQL-Pass Through, Microsoft Excel, and Microsoft Word.

Environment: SAS/ Base, SAS/ Macros, SAS/ Stat. SAS/SQL, SAS/ ODS, MS office, Windows and UNIX

Confidential

Sas Analyst

Responsibilities:

• Was involved in developing new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Was involved in extraction of data from Oracle and created datasets.
• Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Transformations using Base SAS Procedures and Functions.
• Responsible for the cleaning, reformatting, analysis and loading the data into the database.
• Produced RTF, MS WORD and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
• Developed SAS Macros for reduction of program length and for faster execution.
• Combined and grouped datasets using concatenation and merging.
• Involved in developing Unix Korn Shell wrappers to run various dependency graphs.
• Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA NULL for analysis.
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes

Environment: SAS/ Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, Oracle 9i, PL/SQL, MS Excel and Unix.

Confidential

Jr. SAS programmer

Responsibilities:

• Analyzed the data based on the requirement
• Analyzed large data sets consisting of million records
• Creating a customer statistical mailing list for Direct Mailing and Telemarketing. Worked with large customer response and sales data sets.
• Maintain and enhance existing SAS reporting programs for marketing campaigns.
• Maintain SAS analysis for the products purchased every month.
• Conduct individual account and household level analysis.
• Conduct significance tests and study response rates for different level of Marketing based on the reports.
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Extracted data from warehouse using SQL procedure and created SAS data sets.
• Performed Data cleaning, Formatting, Cluster analysis, and regression analysis for normality using SAS.
• Created reports using analysis output and export them to the web to enable the Customers to have access through SAS Integration.
• Extensively used SAS procedures Print, Sort, SQL, Mean, Freq etc.

Environment: SAS/ Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/Access, SAS/Graph, SAS/ODS, Ms-Excel, Oracle 8i, Unix, Pl/SQL Developer.

Confidential

Software Developer

Responsibilities:

• Universal application for the best deals without wasting time. It has the best deals from sites like Double Take Deals Your Best
• Deals, etc. and deliver them to user with focused categories like Food, Home, Health, Services, Travel, Gadgets, Sports, Children
• And Fashion. It has simple search function to hone in on specific keywords and find exactly what user needs. If user is not ready to buy he can save them and come back later. It is easily navigable, intuitive interface and amazing deals.
• Application will notify the user if any new or specific deal is added.

Environment: Xcode IDE (4.x), iOS (4.x to 6.x), Cocoa Touch, Objective C, Core Graphics, MapKit, SOAP