Summary
Overview
Work History
Education
Skills
Skills - Profile Based Skill Set And Proficiencies
Personal Information
Disclaimer
Timeline
Generic
Alok Gupta

Alok Gupta

Senior SAS Consultant
Mumbai

Summary

To succeed in an environment of growth and excellence and earn a job which provides me job Satisfaction and self development and help me achieve personal as well as organization goals.

MCA from VESIT College, Chembur, Mumbai-400074. Good analytical and communication skills.

Overview

10
10
years of professional experience

Work History

Senior SAS Consultant

Acxiom Technology (Reliance General Insurance)
10.2018 - Current
  • Collated the business requirement from stakeholders and creating dynamic reports using SAS EG using Oracle and SQL data sources


  • Automated and optimized jobs in SAS DI and SAS E Miner for CMDM process and scheduled it on bi monthly and quarterly basis using LFS


  • Generating match codes and clusters in SAS Dataflux Studio and DI based on business rules provided to us
  • Created customized reports and automated excel reports and sent on email to bulk users based on their hierarchy and data privacy level


  • Developed, enhanced and automated many existing MIS Reports using macros and SAS advanced programming technique of extracting the data from the source system

SAS Consultant (MDM Solution Consultant)

Acxiom Technologies LLP (IDFC Bank)
8 2016 - 08.2018
  • The project is developed using SAS Data Management Studio 2.5
  • Responsible for designing and developing the MDM soultion
  • Sucessfully implemented GST changes request in Current MDM Architecture
  • Developed real time webservices and batch job to cater any requirement from Client
  • Documented the entire development.

SAS Consultant in Risk Analytics Unit (Cross Sell)

HDFC Bank Ltd. (GRC Consultants Payroll)
01.2016 - 07.2016
  • To collect, analyze, and synthesize qualitative and quantitative information from multiple sources in support of the organization’s goals within a collaborative team environment
  • Responsible for Automation of campaigns in SAS
  • Providing data analysis support and feedback to supervisor and on specific assignments to product/policy/channels teams
  • Creating and analyzing Dashboards related to business tracking on monthly basis.(AL,PL,TW,CNC,BL)
  • CRM Uploads - Collecting the rollout bases, Arranging them in required format, Uploading the final eligible bases on server
  • Running Campaigns monthly basis – BL-10 Secs
  • Other Activities providing SAS id’s Cust id’s Account type, Cibil scores, Account numbers from the System
  • Providing Required datasets from big datasets by Flagging, Bucketing and sub setting, etc

Software Engineer

Mahaonline Ltd.
06.2014 - 12.2015
  • Standardizing Geographical names of Maharashtra
  • Seeding of UID in different Government Schemes
  • De - duplication of different Databases
  • Cleaning of different Database by SAS
  • Finding Anomalies and creating Report in different government Schemes
  • Clustering of different databases
  • Validating UID with verhoeff Algorithm and Usable Resident Data Hub Database
  • Develop, update, and streamline SAS programs, and Dataflux data monitoring jobs to improve data quality
  • Involved in data analysis, data cleansing and applying various quality rules on source data
  • Data Merging, Data Sub setting by using SAS programming and used SAS/MACRO for creating macro variable, macro programs to modify existing SAS program for ease of modification while maintaining consistency of results
  • Performs Quality Control to ensure that outputs meet quality standards and project requirements.

SAS Trainee

UID Maharashtra Team-DIT
12.2013 - 06.2014
  • Worked on Village Standardizations of Maharashtra Districts
  • Created Data Dictionary for Maharashtra UID Database
  • Data validation and Quality check of mentioned e-governance projects undergoing in Maharashtra
  • Worked on SAS to generate reports and standardization required in UID project.

Education

M.C.A -

B.Sc(IT) - undefined

H.S.C. - undefined

S.S.C. -

Skills

  • SAS Enterprise Guide

  • SAS Data Integration Studio

  • SAS Data Management Studio

  • SAS Enterprise Miner

  • SAS Viya

  • SAS Management Console

  • SAS Server Management (Multi Tier Architecture)

  • SAS Server License Renewal

  • SAS Data Quality QKB optimization

  • Oracle

  • MS SQL Server

  • Linux

  • Linux Server Management

  • Excel

Skills - Profile Based Skill Set And Proficiencies

  • Extensive knowledge of SAS/BASE, SAS/MACROS, SAS/SQL.
  • Data reading from various sources like Notepad, Excel, CSV, MS-Access, Oracle and other databases.
  • Data manipulating using various statements and functions.
  • SAS statements like MERGE, UPDATE, MODIFY, SET, INFILE, INPUT, INFORMATS, FORMATS, IF, WHERE, DO, etc.
  • SAS functions like SCAN, SUBSTR, TRIM, STRIP, INTCK, INTNX, MEAN, RANGE, NMISS, CEIL, FLOOR, ROUND, ABS, CAT, etc.
  • Familiar with REPORT generating procedures like PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC REPORT, PROC FORMAT, PROC TRANSPOSE, PROC APPEND, PROC TABULATE, etc.
  • Knowledge in Generating Output files in HTML, Excel and PDF using SAS/ODS.
  • Excellent analytical, presentation, communication skills and comfortable to work independently as well as in a team.
  • Willing to learn any technology according to company requirements.

Personal Information

  • Date of Birth: 01/01/1984
  • Gender: Male
  • Nationality: Indian

Disclaimer

I hereby declare that the above mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above mentioned particulars.

Timeline

Senior SAS Consultant

Acxiom Technology (Reliance General Insurance)
10.2018 - Current

SAS Consultant in Risk Analytics Unit (Cross Sell)

HDFC Bank Ltd. (GRC Consultants Payroll)
01.2016 - 07.2016

Software Engineer

Mahaonline Ltd.
06.2014 - 12.2015

SAS Trainee

UID Maharashtra Team-DIT
12.2013 - 06.2014

SAS Consultant (MDM Solution Consultant)

Acxiom Technologies LLP (IDFC Bank)
8 2016 - 08.2018

M.C.A -

B.Sc(IT) - undefined

H.S.C. - undefined

S.S.C. -

Alok GuptaSenior SAS Consultant