Resume

Sign in

Data Project

Location:
Columbus, Ohio, United States
Posted:
January 29, 2018

Contact this candidate

Resume:

Venkata Prasad Sandu

Mobile Number: 501-***-****

Email: ac38pc@r.postjobfree.com

Profile Summary:

Over 10 years of experience in Database and Data Warehouse Applications Developing along with Business Intelligence technology and Data Visualization using SAS and Tableau.

Good knowledge analytical experience using Actuarial Science in US Banking and Healthcare verticals.

Responsible for coordinating and managing projects in support of claim pricing utilizing accepted actuarial standards, methodologies.

With the guidance of the Director of Actuarial Services or other team members, determines appropriate analyses to be conducted for projects to make recommendations to achieve goals.

Prepares and analyzes actuarial data on a monthly and quarterly basis, then communicates key observations and trends based on the analysis to the Director of Actuarial Services.

Hands on experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau.

Strong Expertise in using Tableau software as applied to BI Data analytics, reporting and dashboard projects.

Extensive Experience in various Tableau Desktop Reporting Features like Measures, Dimensions, Folder, Hierarchies, Live/Extract, Filters, Table Calculations, calculated fields, Sets, Groups, Parameters, Forecasting, Blending and Trend Lines.

Extensive knowledge in various reporting Objects like facts, Attributes, Hierarchies, Filters, Sets, Groups, Parameters in Tableau.

Combined reports & views into interactive Dashboards in Tableau desktop and presented to Program Managers, Business users and End Users.

Expertise in design & development of various Reports and Dashboards using various Tableau Visualizations like Dual Axis, Bar Graphs, Box & Whiskers Plot, KPI Scorecards, Scatter Plots, Pie-Charts, Heat Maps, Gantt Charts, Bubble Charts, Tree Maps, Funnel Charts, Box-Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to business requirements.

Worked extensively on Data blending, and different table calculations for different scorecards, Performance Tuning Tableau Reports, published dashboards on Tableau Public.

Run Base,SAS/Access,SAS/STAT,SAS/Graph,SAS/STAT,SAS/DI studio and SAS/EG.

Capable of processing large sets of structured, semi-structured and and unstructured data supporting systems application architecture.

Able to assess business rules, collaborate with stakeholders and perform source-to-target data mapping, design and review.

Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing. Experience optimizing ETL workflows.

Knowledge on Ecosystems like Hive, Pig, Sqoop, Map Reduce, Flume, Oozie, Spark and capturing data from existing databases that provide SQL interfaces using Sqoop.

Having very good analytical and coding skill as well as project management skills.

Built Connectivity between SAS to Vendor tools and Open Source systems

Pulling Hadoop files into sas and Convert as a sas datasets

Design document to develop new algorithm for Analytics

Design analytic frame as per Adhoc-Queries for Analysics

Cube designing as per analysis and reporting

Migration of sas application and SAS datasets

Create and Maintain transport files which is running on various systems

Develop and Modify predefined Macro applications

Extensive experienced in coding to create list tables, Cross tab, chart and plots using SAS/BASE,Graph and ODS and optimizing programs by using advanced SAS Programming techniques for development.

Experienced in producing detail and summary reports using PRINT, REPORT, MEANS and SUMMARY procedures

Extensive experience in working with Base SAS (MACROS, Proc SQL, ODS), SAS/ACCESS, and SAS/GRAPH in Windows, and Mainframe environment

Experience in working with multiple databases like Oracle, DB2 and Teradata

Experience in development of documentation like Technical Specifications from BRD and Process/Program flow

Thorough knowledge in SAS Programming, 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

Have very good knowledge on Health Care Insurance domain and statistics.

Involved in all phases of Project Life Cycle.

Expertise on various BI Suite tools like: SAS Enterprise Guide, SAS DI,SAS Management Console, SAS Stored Process Server, SAS Web Report Studio and SAS Information Delivery Portal.

.

Career Path:

Working as Sr.Associate at Cognizant USA, since Sep 2015 to till date.

Working as Programmer analyst at Tetrasoft Inc USA, since Jun 2014 to Sep 2015.

Working as Team Lead at Tetrasoft India, since April 2010 to Jun2014.

Worked as SAS Programmer Analyst at Genpact India Ltd, Bangalore, from March 2009 to April 2010.

Worked as SAS Developer at Satyam Computers Services, Hyderabad, from December 2007 to December 2008.

Worked as SAS Programmer at Sirsai Pvt Ltd, Chennai from June 2005 to November 2007.

Certifications:

Certified Base Programmer for SAS 9 from SAS Institute, USA

Certified SAS Advanced Programming for SAS 9 from SAS Institute, USA

Professional Training:

Undergone training on SAS BI Tools from Satyam Computer Services, India

Undergone training on Project Management, FPA (Functional Point Analysis), Risk Management in Tetrasoft.

Undergone training on Cognos10.2 in BCBS.

Educational background:

Master Degree in Mathematics from Andhra University.

B.Sc (Computers) from Nagarjuna University.

SKILL SET

SAS

Base, Macros, Graph, Access, Stat

SAS BI Tools

SAS/EG, SAS/DI, Dashboard 4.3, Information Map Studio, Web Report Studio and OLAP Cube Studio

Hadoop

Hive, Pig, Sqoop, Spark, Impala, Map reduce.Spark,

Special skills

Cognos,R, Tableau.

Databases

Oracle,Teradata and DB2.

Utilities

MS-Office 2003 and 2007

Professional Work Profile

1.PROJECT TITLE

Risk weighted assets(RWA) Reporting&Analysis

INDUSTRY

Banking

CLIENT

JPMorgan Chase&Co

DURATION

Jan 2017 – Till date

ROLE

Sr.Associate

Technologies Used

SAS/EG,SAS/BASE,Tableau

PROJECT DESCRIPTION:

The Market Risk RWA Reporting team is part of the RWA Reporting & Infrastructure group within the Regulatory Capital Management Office (RCMO).

Market Risk RWA Reporting is responsible for producing firm-wide market risk regulatory capital reports and governing the market risk capital data controls process.

Additionally, the group supports quantitative impact studies (QIS) for regulatory agencies; ad-hoc analysis requests for LOBs, business partners, senior management,

and regulators; and, the implementation of the Basel rules.

The Market Risk RWA Reporting Group is responsible for producing, analyzing and explaining risk-weighted assets (RWA) under the Basel 2.5 rules across multiple

legal entities. The RWA results are reported to Line of Business (LOB) controllers and Corporate Financial Reporting;

and used to facilitate forecasting and allocation of capital charge to LOBs.

Responsibilities:

Worked closely with statisticians on several Risk/Actuarial projects such as risk computations and mitigation strategies

Performed data analysis including pricing, risk adjustment and population analytics.

Implement Advance Internal Rating Based – AIRB Basel model for Chase Student Loan and Mortgage Banking portfolio

Automated the process to calculate Risk Weighted Asset –RWA, based on parameter estimates of Probability of Default (PD), Loss Given Default (LGD) and Exposure at Default (EAD) models.

Produced monthly trend analysis report and charts to monitor variability in key fields from the Financial Data Warehouse (FDW).

Analyzed Ad Hoc requests / reports whenever they are asked for

Produced quarterly and year-end risk indications for all line of business Coordinated with the Business team to conduct internal checks, controls and analysis

Provided variance explanation on RWA changes quarter to quarter.

Managed the calculation, consolidation, reporting and explain of Market Risk RWA.

Reviewed the test results before sending it to client.

Developed various dashboards, used Context filters, Sets while dealing with huge volume of Data.

Created views using various axes like Individual Axes, Dual Axes and Blended Axes.

Used Trend Lines, Reference Lines and Annotations to describe the Data.

Created Data extracts for better performance and accessing Data offline.

Used parameters and input controls to give users control over certain values.

Implemented Data blending with multiple Data sources on a single worksheet for Data analysis.

2.PROJECT TITLE

Speciality Reporting

INDUSTRY

Health Care PBM

CLIENT

CVS Health

DURATION

Oct 2016 – Dec 2016

ROLE

Sr.Associate

Technologies Used

SAS/EG, SAS/DI, SAS/Stored process, SAS/BASE,Tableau

PROJECT DESCRIPTION:

CVS Specialty is the specialty pharmacy division that provides specialty pharmacy services for individuals with chronic or genetic diseases who require complex and expensive drug therapies. CVS Health operate 24 retail specialty pharmacy stores and 11 specialty mail order pharmacies, making them the largest specialty pharmacy in the United States

Responsibilities:

Automating manual process and optimized existing programs.

Interact with the Business subject matter experts and determine business questions and data requirements.

Developed new QBR reports based new data and also worked on enhancement of existing QBR reports.

Improve operational efficiency by automating and integrating programs and increased reusability

Review the test results before sending it to client.

Designed and publishing visually rich and intuitive Tableau dashboards for executive decision making.

Created Sets, Groups and Data Bins as per user requirements.

Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.

Provided visual/graphic analysis based on Data content.

Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.

Implemented new features in Tableau 8.2 to the existing workbooks and dashboards.

Developed various dashboards, used Context filters, Sets while dealing with huge volume of Data.

Created views using various axes like Individual Axes, Dual Axes and Blended Axes.

Used Trend Lines, Reference Lines and Annotations to describe the Data.

Created Data extracts for better performance and accessing Data offline.

Used parameters and input controls to give users control over certain values.

Implemented Data blending with multiple Data sources on a single worksheet for Data analysis.

Created and Published Tableau Dashboards into Tableau Server

3.PROJECT TITLE

Rationalization and Automation

INDUSTRY

Health Insurance

CLIENT

Horizon Blue Cross Blue Shield

DURATION

Jan 2016 – Aug 2016

ROLE

Sr.Associate

Technologies Used

SAS/EG, SAS/DI, SAS/Stored process, SAS/BASE,Tableau.

PROJECT DESCRIPTION:

Horizon Blue Cross Blue Shield, USA is a major health insurance provider for the region. Responsible for producing reports from various sources to provide the department /division with actionable information or business intelligence. Working with marginal oversight, the incumbent is responsible for performing complex research, analysis, and reporting of network utilization, cost containment and key operational information.

Responsibilities:

Responsible for developing stored process and DI jobs and update the existing reports.

Interact with the Business subject matter experts and determine business questions and data requirements.

Review assigned tasks and provide feedback to onsite and offshore.

Review the test results before sending it to client.

Designed and publishing visually rich and intuitive Tableau dashboards for executive decision making.

Created Sets, Groups and Data Bins as per user requirements.

Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.

Provided visual/graphic analysis based on Data content.

Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.

Implemented new features in Tableau 8.2 to the existing workbooks and dashboards.

Developed various dashboards, used Context filters, Sets while dealing with huge volume of Data.

Created views using various axes like Individual Axes, Dual Axes and Blended Axes.

Used Trend Lines, Reference Lines and Annotations to describe the Data.

Created Data extracts for better performance and accessing Data offline.

Used parameters and input controls to give users control over certain values.

Implemented Data blending with multiple Data sources on a single worksheet for Data analysis.

Created and Published Tableau Dashboards into Tableau Server

4.PROJECT TITLE

Medicare Finance Reconcilation

INDUSTRY

Health Insurance

CLIENT

HealthFirst

DURATION

Sep 2015 – Jan2016

ROLE

Sr.Associate

Technologies Used

SAS/EG, SAS/BASE, SAS/Macro, Proc SQL,Tableau

PROJECT DESCRIPTION:

The reconciliation process is meant to maximize accuracy of payments to the Centers for Medicare & Medicaid Services (CMS). It is an automated, integrated system that improves processing efficiencies, speeds the resolution of discrepancies and enhances management reporting.

Responsibilities:

Compared the files submitted to the state and the response files received from CMS for identifying the errors and issues in the claim/ pharmacy files. This validation process involves thorough checking of Provider, member, pharmacy and other related files to find the root cause of the problems.

Supported the production data submissions on a weekly/monthly basis to NY State and/or CMS as required by reporting schedule determined by state.

Responsible for handling both internal and external errors in data submission process. Error records must be managed and corrected according to organizational policies and procedures.

Responsibilities include documenting development requirements, reviewing specifications, creating test plans, process flow charts and reviewing the user-acceptance test data.

Developed various analytics reports from multiple data sources by blending data on a single worksheet in Tableau.

Created dashboards by extracting data from different sources using parameters and calculations.

Involved in creating Tree Map, Heat Map, calculated fields, mapping and hierarchies.

Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging different sources.

Performed Tableau type conversion functions when connected to relational data sources.

Developed dashboard reports on the Tableau Server so that the end users having access to the server can view the data.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Played an important role in coordination with the entire team and managing the time estimates for the entire project.

5.PROJECT TITLE

Arkansas Health Care Payment Improvement Initiative Provider Reports (EPR)

INDUSTRY

Health Insurance

CLIENT

Arkansas Blue Cross Blue Shield (ABCBS), Littlerock, USA

DURATION

Jun 2012 - Sep 2015

ROLE

Lead Programmer

Technologies Used

SAS/EG, SAS/BASE, SAS/Macro, SAS/GRAPH, Proc SQL, DB2.

PROJECT DESCRIPTION:

Arkansas Blue Cross Blue Shield, USA is a major health insurance provider for the region. AHCPII (Arkansas Health Care Payment Improvement Initiative) was developed as a joint effort between Arkansas Medicaid, Qualchoice and Arkansas Blue Cross and Blue Shield its affiliates and subsidiaries. A core component of this multi-payer initiative is episodes of care; an episode is the collection of care provided to treat a particular condition over a given length of time.

Multi-Payer system required various types of reports. These reports contain information about the cost, quality and utilization performance of a particular Principal Accountable Provider (PAP). The reports include this information for all of the episodes of patient care where that provider is designated a PAP.

Responsibilities:

Requirement gathering and understanding the specs.

Identified all providers which are enrolled in BCBS network.

Each and every provider wise to pull all related information for cost and services for all episodes.

Find out overall average cost for same episode among all providers. Based on average cost categorize all provides into groups.

If provider cost for specific episode falls below average cost then treated as cost effective provider.

If it falls above average then treated as risk category. and if falls in average cost then treated as safe category

List out providers who charges falling below average cost and then reward those providers in quarterly basis.

List out providers who charges falling above average cost and then send notice to all providers stating that minimize cost according to set threshold which is average cost of all providers.

Developed report considering quality of services and cost of services to generated graphs to represent the provider performances.

Repersented provider performance with respect to cost and quality of services in pictorial representation.

Tost cost and avg cost represents cost of single provider vs cost of all providers in the BCBS network.

Worked with large data sets to develop or modify dashboard reports models to fit project needs.

Analyzed trends within claims to quickly assess areas for improvement or growth

Analyzes data output to identify and interpret trends or patterns in complex data sets

Task Estimation and develop frame work for reporting.

Providing technical assistance to the team. Review the assigned tasks of the team.

Verifying the test result by checking the Actual result with the expected result reviewing the test results before sending it to client.

6.PROJECT TITLE

CPCi Reports

INDUSTRY

Health Insurance

CLIENT

Arkansas Blue Cross Blue Shield (ABCBS), Littlerock, USA

DURATION

Oct 2014 – Jan 2015

ROLE

Lead Programmer

Technologies Used

SAS/EG, SAS/BASE, SAS/Macro, Proc SQL, DB2 and Unix.

PROJECT DESCRIPTION:

The CPCI reports contain information about the subscriber, provider and payment data related to the CPCi payment. A new report will be generated for each clinic or provider NPI along with the payee and payment information.

Responsibilities:

Gathering requirements from onshore.

Worked with large data sets to develop or modify dashboard reports models to fit project needs.

Support the actuarial team to develop reports, applications, and other necessary activities to meet client expectations

Build dashboard reports using SAS and prepare data feed for the dashboards.

Summarized Total Cost & Utilization Overview for each provide/hospital wise.

Generated/automated Hospital Utilization/ Outpatient Hospital Utilization

Generated/automated Physician Utilization/ Pharmacy Utilization

List out utilization of adult wellness services-Gynecological exams/Cancer incidence type and age.

List out no of patients visited provider in particular claim period.

For each care category the avg allowed cost for year will be determined using only attributed patients who have claimed in the specific category.

To determine avg spend for each category we take avg allowed cost per year of all attributed patients irrespective of their claim status in the specific category

pulled enrollment data from EDW tables for current month and created reports in PDF format.

List out all members who are enrolled and paid care management fee

To identify major health risk by conducting periodical health checkup for these enrolled members

Understanding the Technical Specs.

Prepared low Level Design documents based on given Business specifications.

Developing report code and generating the reports.

Provide status report on the progress of work to Onsite and offshore RM.

Reviewing the test results before sending it to client/onsite.

Post production jobs monitoring.

7.PROJECT TITLE

Branching Flexibility Reports

INDUSTRY

Health Insurance

CLIENT

Arkansas Blue Cross Blue Shield (ABCBS), Littlerock, USA

DURATION

Jan 2014 – Dec 2014

ROLE

Lead Programmer

Technologies Used

SAS/EG, SAS/BASE, SAS/Macro, SAS/Stored Process, Proc SQL, DB2, HTML, VB.NET.

PROJECT DESCRIPTION:

Enhance the existing programs which run through stored processes servers, in the enhancement process using an interface screen the users should be able to select the required branching levels and generate the reports for the selected values/levels in PDF and EXCEL formats.

Responsibilities:

Gathering requirements from onshore.

Automated/developed programs and converted web based stored process to avoid manual intervention to run weekly/monthly/quarterly/yearly programs

Developed summary/detailed reports in form of PDF/Excel based on user selection.

Preparing low Level Design documents based on given Business specifications.

Developing SAS report code and generating the reports.

Provide status report on the progress of work to Onsite and offshore RM.

Reviewing the test results before sending it to client/onsite.

8.PROJECT TITLE

Focus to SAS Conversion

INDUSTRY

Health Insurance

CLIENT

Arkansas Blue Cross Blue Shield (ABCBS), Littlerock, USA

DURATION

Apr 2010 – July 2012

ROLE

SAS Programmer

Technologies Used

SAS/Base, SAS/Macros, SAS/Access, SAS/EG,

MAINFRAME FOCUS, Web-Focus

PROJECT DESCRIPTION:

Arkansas Blue Cross and Blue Shield (ABCBS) is a major health insurance provider

in the region and is member of the Blue Cross and Blue Shield Association.ABCBS was using FOCUS and WEB FOCUS as their reporting tools. The company decided to

change the FOCUS reports into SAS Report environment for better business decisions. Total 81 Focus and Web-Focus report programs were converted from FOCUS into SAS.

Responsibilities:

Interacting with onsite coordinator and client.

Requirement gathering and understanding the specs. Task Estimation

Assigning work to team as per work-plan.

Providing technical assistance to the team.

Understanding Mainframe FOCUS applications recoded into SAS

Testing Performance of SAS application compare to FOCUS applications

Verifying the test result by checking the Actual result with the expected result.

Maintain proper back plan for each resource tasks

Get the approval from the client for completed tasks.

Involve in production implementation activities.

Post production jobs monitoring.

9.PROJECT TITLE

Claims Adjudicate and Reject Ad-hoc Analysis

INDUSTRY

Health Insurance

CLIENT

Medco

DURATION

Mar 2009 – Apr 2010

ROLE

Sr.SAS Programmer

Technologies Used

SAS EG, SAS/Base 9.2, SAS/Macros, SAS/Access, Teradata

PROJECT DESCRIPTION:

Medco is a leading pharmacy benefit manager (PBM), with the largest mail order pharmacy operations. Serving people with chronic conditions and who need medications on an ongoing basis to improves the health and reduces the total cost

of care for clients and their members by providing clinically-based solutions for addressing Drug - Drug iterations and Drug Utilization Reviews (DUR) like over use,

misuse and under use of prescription drugs. Claims adjudicate and reject analysis are primarily severe for account managers to settlement the bill accomplished respective organizations.

Responsibilities:

Understanding scientific data across clinical documents

Documenting the development plan and Quality check steps

Query and Analyzing the data from information warehouse

Data preparation

oData cleaning and validation

oCreation and modification of relevant attributes

oAligning the attributes position, naming convention, label and formats

Creating the final report with client specification formats

Quality checks

oSteps are followed as per development plan

oCode standardize and annotation

oCheck/uncheck the Quality check documents by monitor the logic, constrains, attributes position, naming convention, label, formats etc…

Codes and results are followed as per Quality standards then sharing to clients through SharePoint.

10.PROJECT TITLE

CAS POS Disruptions Tracking

INDUSTRY

Banking

CLIENT

American Express

DURATION

Dec 2007 – Jun 2008

ROLE

SAS Programmer

Technologies Used

SAS/BASE, Macro, SQL, Oracle MS Excel 2007 & 2009.

PROJECT DESCRIPTION:

When a card is swiped at a merchant Point of Sale (POS), details go to Credit Authorization System (CAS) requesting approval. If CAS is unable to approve a transaction, it refers the same to Authorization Approval (AA). If AA also is not able to approve a transaction, it is called a disruption. Such transactions then may be manually approved. Deduplication is a scenario which occurs at POS when for the same transaction, the card is swiped 2-3 or maybe more times. Usually, due to some reason or the other, there may be a response timeout or some other issue which results in the card being swiped again. In the CAS database, such transactions are referred to as duplicate transactions

Here project objective is Control data quality across control duplicates in global database designing .Actual database application does not count the duplicate transactions in disruption data as it would give a wrong picture of the number of disruptions taking place. Transaction code 78 (please refer to the description of the trans_cd variable in the Global Database Information section) indicates batch approvals. There are the ones which do not take place instantly/online; the ones where the merchant makes a copy of the card number and the other relevant details on a approval sheet. For the US market, the application does not take into account the disruptions which occur for transactions having trans_cd equal to 78. This was done so after discussions with business partners.

Responsibilities:

Access remote files by using Filename statement, FTP Access Method.

Count the number of observations based on line of business and other key variables

Creating required datasets by using extracted data based on different products and markets.

Calculating disruption frequencies based on line of business by using Freq applications.

Calculating frequencies based on referral codes.

Combine different data sets by using Merge or join Statement.

Calculating Descriptive statistical results

Generating alerts based on UCL and LCL values.

Involve in production implementation activities.

Writing Automated Email generation code in SAS to receive the alert information.

11.PROJECT TITLE

CAS POS Disruptions Tracking

INDUSTRY

Banking

CLIENT

American Express

DURATION

Dec 2007 – Jun 2008

ROLE

SAS Programmer

Technologies Used

SAS/BASE, Macro, SQL, Oracle MS Excel 2007 & 2009.

PROJECT DESCRIPTION:

Consumer Account Monitor Reporting is the process for getting external credit bureau data for American Express’s USA & Canada based existing & new Consumer and Corporate card customers from various bureaus. This process tries for refreshed credit bureau information for American Express’s entire customer base in 10 different cycles (Called cycle A to J) on the interval of three days. A CAMR cycle is run on every third day, starting from the 28th day of month and complete on 24th day of next month for all of customer base. Ideally every third day from the request to bureau in the form of request file, the bureaus send back the required information back to Account Monitor’s system of American Express in the form of response files. The response file data is then converted into cyclical files, which are then used for updating the Accounts Monitor database. Finally, all American Express downstream systems obtain the required bureau information from the Accounts Monitor database.

Applications are developed on the basis of terms & conditions which consumer/ corporate records are to be considered for the business purpose.

Responsibilities:

Access remote files by using Filename statement, FTP Access Method.

Creating required data sets based on application requirement.

Applied transformations for structuring the data by using SAS procedures, Functions & Merge Statement.

Experienced in using Proc SQL, Proc Print, Proc Append, Proc Means &Proc transpose, Proc report.

Generated reports in ODS, HTML, RTF formats.



Contact this candidate