Parav Sharma

Project Name: Client Companies Portfolio Management (CCPM)

Client: Transunion

Domain: Corporate Services

Responsible for Working in the Following Modules: -

• Companies Filing Risk Management.
• Client Churn Analysis.
• Weekly Shelf Invoices Calculation.

Roles and Responsibilities:

• Importing the data shared by client into SAS for analyzing and then exporting the desired reports after analysis.
• Analyze the Filings data to understand Weekly/Monthly Filings submission of the Companies and did Client Segmentation and found the defaulter companies of the clients.
• Analyzing data coming from data sources and performing the Data validation, Data cleaning and Data manipulation by SQL and SAS functions.
• Analyze the payment data to find out the companies whose filings has been submitted but the invoices is not paid and prepared the reports.
• Generate reports either in HTML, EXCEL, PDF or RTF formats according to the client specifications on a regular basis
• Extensive use of PROC SQL, PROC PRINT, PROC SORT, PROC FREQ, PROC MEANS, PROC CONTENT, PROC GCHART, PROC PLOT to perform analysis of the datasets using queries, joining and altering tables using SAS EG.
• Using SCAN, TRIM, TODAY, SUBSTR, REVERSE, LAG, COALESCE, COMPRESS, INTCK, INTNX, PUT, INPUT, CAT to transform the data.

Project Name: Credit Card Management

Domain: Banking

Responsible for working in the following modules:

• Churn Analysis
• Risk Management

Roles and Responsibilities:

• Fetch the raw data and apply some sanity checks on masked data and then create SAS data.
• Analysis of excessive data that are not in use from long time by using Dictionary. Tables and Memory Optimization Tool.
• Analyze the lead data to understand monthly expenditure amount of the customers and did customer segmentation and doing credit risk analysis.
• Analyze the customer data and did the churn analysis of the customers who left the bank/quit the services offered by the bank.
• Interaction with the client to understand the requirement of the project and required Updates.
• Code modification based on the ad hoc requests.
• Used ODS to generate report as HTML, PDF and RTF with titles and footnotes.

• Responsible for Data Visualization, Database Development and Management , Dashboards (Tableau, Excel ) for multiple clients.
• Design and development of SAS code whenever there is an ad hoc requirement.
• Analyzed performance metrics to identify opportunities to increase sales.
• Performing the sanity checks.
• Reporting using ODS.

• Understanding client requirements and provide different solutions.
• Pre-processing of data, data extraction, validation & manipulation, removing duplicates
• Writing SAS codes for analysis of Production data for Customer Segmentation.
• Use PROC SQL, Data Cleaning, Merge, Sorting, Macros & ODS to generate reports.

• Reviewed reports and individual transactions which appeared suspicious to uncover possible fraudulent activity.
• Analyzed large amounts of data to find patterns of fraud and anomalies.
• Summarized all key information regarding investigation into detailed report for delivery to client.
• Collaborated with team members to discuss fraud trends and brainstorm methods to combat this type of crime.