Mar 2021 – Nov 2023 · 2 yrs 8 mos · India · Remote

• Data extraction using SAS import, Data scrubbing using SAS function (Compress, Strip, Trim, Scan, substr, index W, index, intck, intnx)
• Data Analysis using Proc SQL, Proc freq, Proc mean, First. Last., Nodup, Nodupkey. Proc sort.
• SAS Macros for automating the program.
• Identify loyal customers for last 3 consecutive months and to identify the loyalty bonus of those customers who have swiped above a threshold.
• Monthly/Quarterly/Yearly report, using Sas ODS generating the report as per the required format (PDF, Text, excel etc.)

Mar 2019 – Apr 2020 · 1 yr 1 mo · New Delhi, Delhi, India · On-site

• Importing the data from SRP and OSMS tool into SAS for analyzing and then exporting the desired reports after analysis.
• Analyzing data coming from data sources and performing the Data validation, Data cleaning and Data manipulation by procSQL and SAS functions, SAS procedure.
• Analyze the premium payment data to find out the clients whose inception has started but premium has not been paid.
• Using SCAN, TRIM, TODAY, SUBSTR, REVERSE, LAG, COALESCE, COMPRESS, INTCK,
• Preparation of master sheet at the end of every month using SAS ODS and procedure.

Aug 2018 – Feb 2019 · 6 mos · NewDelhi

• Analyzed customer satisfaction score and prepared
• charts as per the service provided to particular
• customer.
• Prepared monthly report of customer as per the
• service and their service satisfaction score.
• Skills Uses: Advance excel, Vlookup, Trim,
• Concatenate, Index, Filter, Analysis, Charts.,Pivot