Data Project
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