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