Shaurya Shahi Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

I&D Cloud Data Platform

Mumbai, Maharashtra

ETL− Processed data of 1 Million+ Records and helped create SAS VIYA dashboardby mapping client requirements.− Formulated Detailed data store (DDS) and created ETL flows for the same withtwo staging levels:o 1st level of Staging (STG) had filters to filter out data discrepancieso 2nd level of staging (DIL) had append functions to merge differenttables with help of SQL joins− Created custom Libraries for ETL consisting of Macros to be used as reusableand… Show more ETL− Processed data of 1 Million+ Records and helped create SAS VIYA dashboardby mapping client requirements.− Formulated Detailed data store (DDS) and created ETL flows for the same withtwo staging levels:o 1st level of Staging (STG) had filters to filter out data discrepancieso 2nd level of staging (DIL) had append functions to merge differenttables with help of SQL joins− Created custom Libraries for ETL consisting of Macros to be used as reusableand dynamic functions.− Coded macros in SAS for data Cleansing to be processed during ETL flows.UNIT TESTING− Carried unit tests on formulated DDS and linked DIL jobso Coded macros for filtering, developing, and removing anydiscrepancies which were discovered during Unit testing.o Unit testing observations worked in a close loop with clients toremove discrepancies− Created Joins and logic for merging different datasets in DIL and DDS stages.DATAMARTS− Identified different data sources to collect data for dashboards and mergingthem to create large and complex data sets.− Created data-marts for Policy, Auto & Claims Line of business.− Wrote custom transformations for reading & writing on External Files & onXML Datasets.SAS− Maintained work DBs by archiving old data. Monitored available space forworkspace DB and requested allocation of additional space in blocks of 500GB.− Created dashboards, weekly, monthly reports using SAS Viya to generatedifferent reports for dashboards.− Involved in data pre-processing techniques such as data cleaning, visualizingdata, identifying outliers and making data ready for preparing learning models. Show less

Mumbai Area, India

− First Level Resolution of incidents for Storage & Backup environment of twoglobal multi-business Media groups.− Fault and tolerance monitoring of storage environment & Backup managementof data on incremental basis.− Managing database and scheduling periodic backups as per client’srequirements.− Monitoring & predict the impending issues in the storage & backup domain ofclient’s data.

B.E In Electrical & Electronics, Electrical And Electronics Engineering, 7.12

Activities and Societies: Senior design member of TEAM ADREALINE RACING: a collegiate group under SAE INDIA which designs and fabricates.

Xii, Electrical And Electronics Engineering, 76.6

X, High School/Secondary Diplomas And Certificates, 95

Activities and Societies: Secured 10 out of 10 GPA in Board Exams