Data Sas

Siva

Email: *************@*****.***

Phone: 682-***-****

EXECUTIVE SUMMARY:

* ***** ** ********** ** a SAS programmer/Anylst in Health Care Data Analysis, Pharmaceutical and Financial Analysis.

Strong experience in Macro programming with DB2, SAS/BASE, SAS/MACRO, SAS/CONNECT, SAS/ODS, SAS/GRAPH, SAS/SQL, SAS/STAT, SAS/ACCESS in WINDOWS, ORACLE and Teradata databases and UNIX environments.

Expertise in transforming data imported from disparate data sources into analysis data structures, using SAS functions, options, ODS, array processing, macro facility, and storing and managing data in SAS data files.

Worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing, trending, mapping analysis and business driven data validation.

Experience working in SAS Business Intelligence (BI) platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add-In, Dashboards, OLAP Cubes, DI Studio and Web Report Studio.

Extensive SAS programming experience in Design, Development, Implementations, Testing, Support, Maintenance & Upgrade or Promote and Migration of SAS Application.

Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.

Strong Project coordination including strategic planning, trend analysis, forecasting, variance analysis, database management.

Gained strong mapping knowledge in submission of data in CDISC SDTM format, based on CDISC SDTM Implementation guide.

Involved in creation and validation of datasets according of CDISC SDTM standards following specifications document.

Exceptional ability in problem solving, data analysis, complex reports generation with macro and data transfer between different environments.

Write, maintain, and support SAS Programs in SAS Base and Enterprise Guide.

Extensively worked with PROC SQL to extract data from Oracle database, load data into database, print sophisticated reports and Lists, Graphs etc.

Review accounts for potential fraud, assist customers to verify potential fraud activity, Balance risk factors with customer delight, Process fraud claims to report fraudulent activity.

Interface with Sales, Accounting, Merchant Support, and Customer Support teams to help

understand, resolve and (internally) communicate fraud or potential fraud issues, Support transaction monitoring, chargeback monitoring, and fraud analyst.

Extensively worked with Health care claims (Medical, Pharmacy) using CPT codes, ICD-9, NDC codes etc.,

Used Data integration studio to create jobs and deploy jobs for scheduling using various schedulers.

Have experience in using Job schedulers like Crontab, AT, Autosys and LSF scheduler.

Experience in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.

Responsible for Programming in SAS using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.

Worked with the marketing team and analyzed marketing data using SAS tools to generate reports, tables, listings and graphs.

Experience in Microsoft Office tools like MS Access, MS Word, MS PowerPoint, and MS Excel etc.

Excellent command in producing reports employing various SAS procedures like Proc Print, Proc Report, Proc Tabulate, Proc Mean, Proc Univariate, Proc Transpose, Proc Rank, Proc SQL, Proc Access and Data _NULL_.

Extensive experience in preparation of reports, tables, listings and graphs in HTML, PDF and RTF formats using Output Delivery System.

Motivate supportive, cooperative and a quick-learner. Strong communication skills and ability to work well in a team.

Extensive experience in Data collection, Design, Analysis and Reports.

Very good team player with excellent communication, analytical and problem solving skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, VBA, HTML, XML, VB Script, VB6.

Database: Oracle 10g, Teradata, Netezza, SQL Server 2000, MS Access.

SAS Tools: SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/ODS, SAS/REPORTS, SAS/ACCESS, SAS/STAT, SAS/EG, SAS v 9.3/8.2.

SAS Procs: Print, Means, Univariate, Correlation, Regression, SQL, Tabulate, Freq, Sort, Summary, Format, Import, Export, Transpose, Compare, Life Test, and Gplot.

Operating Systems: Windows XP/NT/2000/98, MS DOS, UNIX.

Others: Java, MSOffice (Word, Outlook), SPSS.

PROFESSIONAL EXPERIENCE:

SAS Programmer

Client : Bcbs – Tampa, FL May 2016 – Current

Responsibilities:

Worked extensively with Health care data (hospital, lab and physician), which includes various claims, membership details and demographics of the members.

Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data with the usage of quick filters for on demand healthcare information.

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.

Responsible for production updates (monthly, quarterly and semiannual) by processing client’s eligibility and claims data from different carriers through the ETL to Data warehouse.

Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.

Utilized SAS PROC SQL Pass through facility for data extraction, location and retrieval from the Oracle database.

Generated output files in text format, HTML & PDF format using SAS ODS.

Responsible for quick Debugging and resolving production issues on the Eligibility, Claims, Inpatient, Outpatient, Long Term Care and Pharmacy (Rx) etc datasets up on request.

Developed ad-hoc reports in production environment up on special request using SAS PROCEDURES like PROC PRINT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, PROC REPORT and PROC MEANS.

Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.

Created SAS INDEX’S by importing workable crosswalk data into SAS from various data types and formats like metadata, MS Excel and MS Access files, delimited text files, and comma separated values (CSV) files.

Have experience in using Job schedulers like Crontab, AT, Autosys and LSF scheduler.

Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting

Create Edit Checks to verify the accuracy of the data.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Involved in developing various fraud algorithms and validated existing algorithms against specification.

Independently perform data investigations. (Investigate code; utilize reporting environment, special requests, program mods, etc.).

Created reports based on the claims Medical and Pharmacy pulled using CPT, ICD-9 and NDC codes for various Diseases.

Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.

Involved in writing code using Base SAS & SAS/Macros to clean and validate data from oracle tables.

SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.

Extensively used company standard macros, generating graphs, listings, PDF and RTF files using various Base SAS Procedures.

Identify possible solutions for complex data issues/limitations, and work on Improvement of data quality.

Participate in UAT testing and maintenance of new products/methodologies.

Identify risks and report impact to teams in a timely manner.

Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.

Environment: UNIX, Windows NT, SAS 9.3, Oracle, DB2, SQL, PL/SQL, SAS/BASE, SAS/ MACROS, SAS/Enterprise guide, SAS/ACCESS, SAS/STAT, SAS/GRAPH, MS-Access.

SAS Programmer/Analyst

Client : CVS - Chicago, IL August 2015 – April 2016

Responsibilities:

Developed ad-hoc reports in production environment up on special request using SAS PROCEDURES like PROC PRINT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, PROC REPORT and PROC MEANS.

Worked extensively with Health care data (hospital, lab and physician), which includes various claims, membership details and demographics of the members.

Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data with the usage of quick filters for on demand healthcare information.

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.

Responsible for production updates (monthly, quarterly and semiannual) by processing client’s eligibility and claims data from different carriers through the ETL to Data warehouse.

Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.

Utilized SAS PROC SQL Pass through facility for data extraction, location and retrieval from the Oracle database.

Generated output files in text format, HTML & PDF format using SAS ODS.

Responsible for quick Debugging and resolving production issues on the Eligibility, Claims, Inpatient, Outpatient, Long Term Care and Pharmacy (Rx) etc datasets up on request.

Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.

Created SAS INDEX’S by importing workable crosswalk data into SAS from various data types and formats like metadata, MS Excel and MS Access files, delimited text files, and comma separated values (CSV) files.

Have experience in using Job schedulers like Crontab, AT, Autosys and LSF scheduler.

Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting

Create Edit Checks to verify the accuracy of the data.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Involved in developing various fraud algorithms and validated existing algorithms against specification.

Independently perform data investigations. (Investigate code; utilize reporting environment, special requests, program mods, etc.).

Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.

Involved in writing code using Base SAS & SAS/Macros to clean and validate data from oracle tables.

SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.

Extensively used company standard macros, generating graphs, listings, PDF and RTF files using various Base SAS Procedures.

Identify possible solutions for complex data issues/limitations, and work on Improvement of data quality.

Participate in UAT testing and maintenance of new products/methodologies.

Identify risks and report impact to teams in a timely manner.

Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.

Environment: UNIX, Windows NT, SAS 9.3, Oracle, DB2, SQL, PL/SQL, SAS/BASE, SAS/ MACROS, SAS/Enterprise guide, SAS/ACCESS, SAS/STAT, SAS/GRAPH, MS-Access.

SAS Developer

Client : Gateway Health – PA September 2012 – June 2015

Responsibilities:

Created complex and reusable macros and extensively used existing macros and developed SAS programs for data cleaning, validation, analysis and report generation.

Modifying incoming data using SAS code by reformatting, importing, sorting, merging and restructuring.

Maintaining the large datasets, combining data from various sources in varying formats to create SAS datasets and/or ASCII files.

Evaluated actual purchases, market shares, distribution, pricing, merchandising and promotional activities.

Accessing the client data using SAS from relational database like SQL server.

Created high level SQL data Tables using Proc SQL for Dashboard reporting.

Conducted analyses - linear/ logistic regression, segmentation/cluster analysis, factor analysis, and database/ data mining to identify significant differences in relationships among sources of retail data information.

Creating management decision support models and reports that derive to help in Decision making.

Handled Automation projects as required by the client and performance tune.

Analysis of various business related reports and Dashboard Management.

Creation of trends on various parameters cluster wise, zone wise and Region wise for comparative Analysis.

Executing weekly deliverables using existing code.

Generating Ad-hoc reports as per the business requirement.

Producing external files and reports employing various SAS procedures like Proc Print, proc contents, Proc Report, Proc Summary, Proc Freq, Proc sort & Proc SQL.

Environment: SAS 9.2, Base SAS, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, MS EXCEL, MS ACCESS and WINDOWS.

SAS Programmer/Analyst

Client : HDFC - Bangalore, India July 2010 – August 2012

Responsibilities:

Developed application for measuring financial performance of newly acquired accounts such as Forecast vs. Actual and developed SAS programs for generating reports on key financials, Income Statements and Balance Sheets.

Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Unix environment

Performed daily weekly and monthly campaigns as per the deliverable schedules.

Creating waterfall reports and analyzing data and creating ad-hoc's on deliverables.

Advanced analytics and reports created based on the criteria provided.

Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.

Created macro program to create Macro variables to pull data from oracle and SQL server for monthly daily data extracting.

Performed approvals for peer audit reviews on reports by analyzing data.

Developed SAS Macro programs to create ad-hoc reports.

Converted the financial data retrieved from vendors into SAS readable format and executed the datasets to produce necessary financial reports using SAS/STAT procedures such as PROC FREQ, PROC REPORT.

Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.

Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS data sets.

Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.

Used SAS Proc SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.

Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.

Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting

Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE. Used DBLOAD procedure to load data into the database effectively prepared and published various performance reports and presentations.

Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Environment: SAS 9.3, (BASE, MACROS, CONNECT, SQL, GRAPH) Oracle, MS Excel, and Windows.

SAS Developer

Client : Sonata - Hyderabad, India Aug 2009 – June 2010

Responsibilities:

Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data.

Worked extensively to generate SAS data sets, statistical reports, monthly reports, listings, safety reports for cross-functional.

Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database.

Extensively used PROC Import and PROC Export procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables.

Used SAS enterprise Guide to run statistical tests like ANOVA, Chi-square etc.

Created customer mailing lists for Direct Mailing and Telemarketing using PROC Forms.

Maintained and enhanced existing SAS Reporting programs using PROC Tabulate, PROC Report, PROC Print, ODS RTF, and ODS PDF for marketing campaigns.

Created Ad hoc reports for marketing managers using SAS Enterprise Guide.

Environment: SAS/Base, SAS/Macro, SAS/SQL, SAS/Stat, SAS/Graph, SAS/Access, SAS/ODS, MS Office, MS Access, SAS Enterprise Guide.

CERTIFICATIONS : SAS Certified Base Programmer for SAS 9.

Contact this candidate