SUMMARY

• Professional experience in SAS (9.4, 9.3, 9.2, 9.1, 8.2 versions) programming, Requirement analysis, data mapping and data analysis using SAS software in WINDOWS and UNIX platforms.
• SAS Experience includes Base SAS, data mapping, defining ETL processes, Data Quality, Data Modelling, Data Management and Business Intelligence projects.
• High - level experience in Base SAS, SAS/Macros and SAS/SQL
• Worked on large datasets containing over 20+ million records.
• Work experience includes analyzing and documenting business requirements, interactions with Business Users, Marketing Group, Project Team and QA Analysts.
• Effective Experience in Data Analysis, Data Requirement Analysis and Data Mapping for ETL process. Extracting data from flat files, Excel spreadsheets and tables using LIBNAME and SQL PASSTHRU facility.
• Strong Experience in using numerous SAS procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
• Used SAS Visual analytics to create dynamic reports and graphs.
• Created SAS visual analytics dashboards to create user friendly reports in various domains.
• Worked on Data Merging, Data Sub-setting with the use of PROC SQL, MERGE and SET statements
• Extensively used macros, joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple databases.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Hands on experience in working with SAS Tools and SAS Enterprise Guide Software for working on large datasets, data transformation and reporting.
• Advance Expertise working on advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis.
• Experience in SAS/MACRO, creating macro variables, macro programs, modifying existing SAS programs and debugging macro programs.
• Extensively used PROC SQL and MACROS with SELECT sub-queries to generate various reports by connecting to the Teradata DB.
• Proficient in different Advance MACRO Options such as MPRINT, SYMBOLGEN, MLOGIC, SYSFUNC
• Proficient in Data Modeling and Predictive Analysis.
• Performed Data Extraction, Data Transformation and Data Loading using SAS/ETL
• Worked on ad hoc queries and User Acceptance Tests (UAT) for several reports on a daily, weekly or monthly basis.
• Ability to manage and manipulate databases, adapt and learn new technologies with strong communication, self-motivated attitude and interpersonal skills.
• Experience in problem solving and delivering practical solutions.

TECHNICAL SKILLS:

Operating System: Windows 98/2000/NT/XP/Vista/7/8/10, UNIX, Mac OS X

Database: MS-Access, MS-Excel, Oracle, SQL Server

Languages: SAS (Advance level), SQL, C,C++, Visual Basic

SAS Tools: SAS/Base, SAS/Macro, SAS/SQL, SAS/Report, SAS Enterprise Guide, SAS/Graph, SAS/Access, SAS/Connect, SAS/STAT, SAS/AF, SAS/STAT, SAS Web Report Studio

Other Tools: Tableau, Microsoft Office (Word, Excel, PowerPoint, Outlook)

PROFESSIONAL EXPERIENCE

Confidential., Irvine CA

SAS Developer

Responsibilities:

• Involved in work with various business users and multiple business units for collecting requirements, enhancing the existing process and functionality.
• Created graphs using PROC GPLOT, PROC GCHART and permanent formatted SAS data sets for analysis.
• Experience on working in XML, creating Tag Sets, Cleansing of existing data and converting them into productive SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Calculated one-way frequencies, multi-way frequencies for counts of variables and table analysis using PROC FREQ with LIST, OUT, MISSING options.
• Modified variables to user-defined Formats using PROC FORMAT in printing reports.
• Generated reports in the HTML, RTF and PDF formats using SAS ODS and SAS/GRAPH.
• Modified and developed SAS Programs, SAS Macros for analyzing financial data. Statistical analysis of files, tables, listings, and graphs.
• Refining existing data and develop them into useful SAS Datasets, merged datasets and depending on Ad-hoc requirements reports are created.
• Performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Modified Raw datasets with a missing values using MISSOVER and TRUNCOVER.
• Worked on existing and developing new store processes in SAS Enterprise Guide.
• Extensively used PROC PRINT, PROC REPORT, and PROC TABULATE for reporting. Used other SAS Procedures such as PROC SQL (queries), PROC APPEND, MERGE, SAS MACROS, Import and Export. To modify Teradata and Oracle tables SQL Pass through Facility is used.
• Created, executed and monitored data quality assurance processes.
• Produced ad-hoc queries, reports and analysis as per the requirements.

Environment: Tableau7.0/8.0, SAS/BASE, SAS 9.2, SAS 9.3, SAS/SQL, SAS/EG, SAS/CONNECT, ORACLE, MS Excel, SAS/Macro.

Confidential, Herndon VA

SAS Developer

Responsibilities:

• Responsible to work on expanding data warehouse tables and identifying the reports which are generated through several SAS and SQL codes.
• Involved in developing analytic specifications through participation in project teams or meetings with clients for ongoing project and ad hoc requests
• Worked with large data sets (20+ million records) using SQL Pass Thru method.
• Programming and collecting data from various oracle tables using Unions and Joins.
• Executed data cleansing by analyzing and eliminating duplicate data and inaccurate data using PROC FREQ, PROC SORT, PROC UNIVARIATE, and macros in SAS.
• Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database.
• Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABUTAE and PROC SQL.
• Created high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
• Extensively involved in the development of ETL processes for extracting data from different data sources, data transformation and loading the data into data warehouse for data mart operations.
• Extensively worked on Base SAS, SAS Enterprise Guide, SAS/MACRO, Excel reporting.
• Modified program for Ad-hoc reporting in Enterprise Guide using Query Builder, BASE SAS programming, SAS/SQL and SAS/MACRO.
• Experienced in detecting, describing, verifying defects, bug tracking and modifying the existing datasets for the improvement of the existing system.

Environment: SAS BASE, SAS 9.1, SAS 8.2, SAS SQL, SAS/EG, SAS MACRO, ORACLE, SAS CONNECT, SAS/ODS, MS Excel.

Confidential, Burbank, CA

SAS Programmer / Data Analyst

Responsibilities:

• Design new datasets from raw data files using Import Techniques and converted existing datasets using Set, Merge, Sort, Update and conditional statements.
• Performed data analysis on change data capture and NET-change jobs for updating transactional membership and claims data in data warehouse.
• Collaborated with different key departments to analyze areas and discuss the primary and model requirements for the project.
• Developed scheduling scripts to monitor the execution of daily, monthly, quarterly and yearly reports using ETL Control.
• Extensively used BASE SAS, SAS/MACROS and generated reports using SAS TABULATE, PROC REPORT, MEANS and SUMMARY.
• Evaluated various tables using data manipulation techniques like Merging, Appending and Sorting. Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC SORT, PROC FREQ, PROC COMPARE, PROC UNIVARIATE, and SAS/MACROS.
• Exclusively used macros, joining data sets, indexing, data aggregation, sub-setting multiple records, creation and modification of views.
• Executed changes in raw data using several SAS options and multiple programming calculations
• Outlined several tables using Data manipulation techniques like merging, appending and sorting.
• Produced new and modified SAS programs to extract Teradata data base using SQL Pass Through and Libname methods.
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share knowledge.
• Worked on Data stage to create previous and current image of membership data for comparison and load to test warehouse for business testing. Used Data stage for performing change data capture (CDC) on membership data.
• Created Mappings between Source and Target, loading data, Data validated for missing values based on the requirements.
• Generated highly ordered reports using SAS macro facility, PROC Report, PROC Tabulate, and PROC SQL.

Environment: SAS/BASE, SAS 9.3, SAS 9.2, SAS/SQL, SAS/CONNECT, SAS/ODS, SAS/Enterprise Guide 4.3, ORACLE, MS Excel, SAS/Macro.

Confidential

SAS Programmer

Responsibilities:

• Worked on technical specs for projects and Developed logical flow of SAS programs to validate the business requirement.
• Converting the SQL tables to SAS and implementing the models for analysis.
• Managing and Optimization of Data Base to run large datasets
• Modified SAS base code to generate reports and performs ETL process (data loading, validation) extraction, transformation and loading to analytical database.
• Evaluate the data using multiple statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, and PROC UNIVARIATE.
• Managed complex datasets to extract customized reports and creating list for business analysts using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC PRINT and PROC MEANS.
• Worked on several MACRO Options such as MPRINT, SYMBOLGEN, MLOGIC to Debug and store.
• Used SQL Query statements and PROC SQL in the MACRO for creating new datasets for specific State and Indexing and appending various datasets.
• Created RTF, PDF, HTML, LISTING, etc. using Output Delivery System (ODS)
• Involved in preparation, validation, processing, and maintenance of clinical data. Maintain standard data collection instruments, databases, format libraries, and edit specifications.

Environment: SAS/BASE, SAS 9.2, SAS 9.1, SAS/SQL, SAS/ODS, SAS/Enterprise Guide 4.3, ORACLE, MS Excel, SAS/Macro.