SUMMARY

• Certified Base & Advanced SAS Consultant with over 7 years of experience in Data/Business Analysis, Programming and testing in diverse domains such as Finance, Healthcare and Marketing.
• Experience in data management, analysis and reporting using SAS.
• Proficient in importing and exporting raw data files, manipulating and transforming data, combining SAS data sets, creating basic detail and summary reports using SAS procedures and identifying and correcting data, syntax and programming logic errors.
• Experience in manipulation and standardization of data using SAS SQL, Macro processing and advanced programming using SAS such as array processing, hash objects, FCMP procedures.
• Experience in running macros, developing Test cases, test plans for SAS Modules, Regression testing and UAT.
• Proficient in importing and extracting data by connecting SAS systems to database and generating reports in HTML, EXCEL or PDF formats.
• Experience using SDLC methodologies like agile and waterfall development.
• Proficient in Microsoft office tools such as MS Word, MS Excel, Microsoft SQL, Oracle, MS Power point, Visio and Outlook.
• Excellent working experience with variety of operating systems like Windows, UNIX, Linux Macintosh, Ubuntu.
• Strong verbal and written Communication skills along with good programming and analytical skills.

TECHNICAL SKILLS

Data Analysis: SAS/Base, SAS/Access, MS SQL Server, MS - Excel, and Windows XP, SAS/SQL, SAS/Macro, SAS/STAT, SAS/Connect, SAS/Graph.

Programming Languages: C, C++, Java, SQL, Android

Operating Systems: Windows, Linux, Android, MAC, Ubuntu

Databases: SAS, Microsoft SQL server, MS Access, SQLite

Methodologies: SDLC, Agile Waterfall, RAD (Rapid application Development), OOPS (Object Oriented Programming)

Documentation: Project Plan, Requirements Analysis, Test cases, Reports

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. SAS Programmer Analyst

Responsibilities:

• Generated statistical analysis files, summary tables, listings and graphs using SAS/BASE, SAS/MACROS, SAS/GRAPH and SAS/STAT.
• Creating, maintaining and optimizing SAS programs to support Finance Analysis data process.
• Defining, Manipulation, Reporting, Storage of Clinical Data by using PROC SQL.
• Documenting all coding, methodology, assumptions, data issues and report results for each analysis.
• Utilizing research methods to analyze various data sets to support material financial adjustments for all Health First products.
• Preparing new datasets from raw data files using import techniques and modifying data sets using Set, Formats and Functions.
• Combining data sets using Merging, Concatenating and Interleaving techniques.
• Gathering data and conducting ad-hoc analyses as directed by other Finance Analysis team members and assist with the development of reports.
• Used SAS/ODS facility to generate reports and writing them to HTML, RTF or PDF files.
• Developing and improving efficiency of programs using SAS Macros.
• Debugging and fixing errors in SAS programs.
• Keeping abreast of New York Medicaid and Medicare reforms and their impact on the health plan and owner hospital performance.
• Participated in project meetings, presentations, and updating research findings.

Environment: SAS 9.3, SAS 9.4, SAS/BASE, SAS/SQL,MS SQL Server, MS-Excel, and Windows XP, SAS/SQL

Confidential, Baltimore, MD

Data Analyst

Responsibilities:

• Researching and analyzing the working of e-commerce websites and worked on developing a new website for the company.
• Used SAS 9.2 for managing the product database by importing and exporting the product data from various formats such as Excel, CSV and database files.
• Interpret data from company website and provide results.
• Customizing products on the existing website(Adding the products into specific categories and deleting them)
• Generated tables, listings, and graphs using PROC REPORT and PROC GPLOT.
• Created macros and used existing macros to develop SAS programs for clinical data analysis.
• Produced SAS outputs in RTF, PDF, CSV and HTML formats using Output Delivery System (ODS) facility.
• Utilized SAS to analyze real data provided by a Fortune 500 company
• Collected and reviewed industry and competitor data and built customized database
• Communicating and Discussing with Customers and directing their problems to the right person.
• Reviewed and ensured analysis data and programming code to meet regulatory and company standards.
• Planned pricing, display, and coupon promotion strategies and designed an interactive presentation
• Involved in requirements gathering and analysis of the system from a Customer-centric perspective.

Environment: SAS/Base, SAS/Access, MS SQL Server, MS-Excel, and Windows XP, SAS/SQLSAS/Macro, SAS/STAT, SAS/Connect, SAS/Graph.

Confidential, Rockville, MD

SAS Developer

Responsibilities:

• Design, analyze, code, develop and document the programs in order to satisfy the business requirements.
• Interpreting and analyzing health care data from various sources, including claims and authorization data, and recommend best approaches
• Involved in developing SAS program code using SAS/BASE, SAS/SQL, SAS/MACROS, and SAS/STAT to produce analysis datasets.
• Produced Ad hoc reports of various kind using PROC REPORT, PROC GPLOT, PROC TABULATE.
• Involved in generating ISS (Integrated Summary of Safety) analysis of Datasets and tables.
• Managing the data outputs as requested by the Medical monitors to evaluate the conduct of their studies.
• Investigating variations in data, finding their sources, causes and developing solutions.
• Participated in each phase of SDLC.
• Used SAS macros to create new programs and for modifying existing SAS programs to make them portable as well as to have consistency of results.
• Estimated the overall cost and schedule for the project.
• Effectively communicated the significance of project to a bigger audience.
• Produce and review reports as requested.

Environment: SAS/Base, SAS/SQL, SAS/Access, MS SQL Server, MS-Excel, and Windows XP, SAS/Macro, SAS/STAT.

Confidential

SAS Analyst

Responsibilities:

• Built models on contextual analytics tool for sentiment analysis of web based data.
• Extracted data from various sources and processed them using SAS programming.
• Develop and enhance complex programs and reports and document them.
• Importing and exporting data from CSV and PDF type files to be used for analysis.
• Used procedures such as PROC PRINT, PROC FREQ, PROC MEANS, PROC SORT, PROC TABULATE, and PROC REPORT.
• Modified existing datasets using Set, Merge, Sort, Format, Update, Conditional statements and procedures.
• Used SAS ODS to create PDF, HTML and RTF output files while using various methodologies to produce reports.
• Generating results into EXCEL sheet using ODS and PROC EXPORT procedures.
• Involved in decision making process in the use of methodologies, data analysis and data security.
• Understanding customer requirements and business and creating business models for providing Business insights on customer background.
• Code Walkthrough, Test cases and Test Plans.
• Attended client calls for business requirements and clarifications.

Environment: SAS9.3, SAS9.4, SAS/BASE, SAS/SQL, SAS/ACCESS, SAS/Macro, SAS/Graph, SAS/ODS, MS ACCESS, SAS/CONNECT, Windows, Oracle, UNIX.

Confidential

SAS Analyst

Responsibilities:

• Creating SAS programs to create and validate datasets, tables and listing outputs as per the specifications.
• Perform activities that require programming in SAS for analyzing the data.
• Extensive use of SAS BASE procedures such as PROC IMPORT/EXPORT, PROC PRINT, PROC SORT, PROC REPORT, PROC GCHART, PROC GPLOT, PROC UNIVARIATE.
• Create specifications under the client’s guidance.
• Identify and analyze the issues and implement preventive and corrective methods. Utilizing trouble shooting methods.
• Used PROC SCORE procedure to score the database with model scorecards.
• Used PROC SUMMARY procedure for summarizing the datasets and observations.
• Provide innovative ideas and suggestions for process optimization that result in improvement in quality and time and cost savings.
• Reviewing the protocol, Statistical analysis plans (SAP), CRF generation for tables, figures and listing outputs.
• Creating USE cases and performing Use Case analysis and completed User Acceptance Analysis.
• Was actively involved in meetings and team building events.
• Used good communication skills and interpersonal skills and dealing complex issues.
• Performed Functional Testing to make sure the functionality is working correctly.
• Code Walkthrough, Test cases and Test Plans.
• Documenting the process and all other information and debugging and fixing errors in SAS programs.

Environment: SAS/ BASE, SAS/SQL, SAS/MACRO, SAS/GRAPH, MS Office, Windows Server, UNIX