Data Sas

Priyanka Ramya

Mobile:732-***-**** E-mail:*****************@*****.***

SAS professional with over 5+ years of experience in working with complex data, analyzing client programs and providing an efficient solution through data analytics of large datasets, solving them through statistical process by implementing, deployment and implementation of SAS in financial, health care and insurance companies. Worked extensively on refining large volume of data through ETL process, data migration and SQL Pass through facility. Experience includes development of Statistical/Data models, web applications, data mapping, Data Quality, Data Modeling, Data Management, Data Integration and Business Intelligence projects. Dedicated and motivated with excellent organizational skills, team player combined with managerial skills effective to work in an industry.

Professional 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 Modeling, 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.

Core development experience in creating user interface applications using SAS/AF.

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)

WORK EXPERIENCE

Denken Solutions Inc., Irvine CA Jan ’16 – Present

SAS Developer

The project was about the credit risk analysis of new and existing customers. I was involved in migration of data from data warehouse servers to application environment, transforming the required tables and flat files into SAS datasets and formation of SAS analysis datasets and reports, performing complex data manipulation using multiple files in SAS data steps and to produce reports employing various SAS procedures.

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.

Worked on both UNIX and Windows platforms utilizing SAS. Programming statistical reports and developing SAS/AF applications.

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.

Fannie Mae, Herndon VA Aug ’14 – Dec ‘15

SAS Developer

The project analyzed short-term and mid-term credit needs of its consumer in order to analyze purchasing power of its consumer and subsequently embrace business activities such as database marketing, credit policy, management reporting, analysis, information support and working with the business partners for marketing campaigns to provide data to different marketing channels by filtering consumers based on offer eligibility criteria.

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.

Designed and Maintained SAS and Tableau reports as per client request.

Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery.

Created Tableau scorecards, dashboards, Heat maps using show me functionality.

Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.

Created high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.

Reviewing SAS SCL code for their SAS/AF GUI reporting application and SAS code recommendations for performance enhancements.

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.

Kaiser Permanente, Burbank, CA May’13 – Jun ‘14

SAS Programmer / Data Analyst

Kaiser Permanente is on the leading Healthcare Service Providers for Medicare and Medicaid Industries in USA. The Data Warehouse project was designed for maintaining Membership Data along with data from third party Clients. I was involved in Active Healthcare membership reports, Line of business segmentations, Open enrollment membership termination reports using Business Intelligence tools for Market Strategy. Our team also implemented business model for KPIF healthcare reform project.

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.

GE Healthcare, Hyderabad, India Aug’11 – Mar ‘13

SAS Programmer

GE Healthcare is one of leading providers for Medical Insurance Plans in India. The project involved maintenance of existing GE Data Warehouse in correspondence to addition of new business logic as per updating to existing plans to stay up with changing trends in Insurance Market. The company offers diverse medical benefit plans, behavioral health coverage, pharmacy benefits, standalone case and disease management, and other products and services that form the core of its health advocacy strategy.

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.

EDUCATION:

MASTERS OF COMPUTER SCIENCE, TEXAS A&M UNIVERSITY - KINGSVILLE.

BACHELORS OF TECHNOLOGY IN COMPUTER SCIENCE AT JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY (INDIA)

References available upon request

Contact this candidate