Data Sas

OBJECTIVE

A competent professional with *+ years of experience in Business Analysis Gained comprehensive knowledge of SAS Base-Programming, merging, managing missing values, reading raw data files, creating data structures, accessing and managing data, appending, concatenating, and interleaving of SAS datasets. Expertise in SAS/BASE, SAS/MACRO, SAS/SQL and SAS/ODS (RTF, PDF, EXCEL). Exposure in importing Excel and Access files using LIBNAME, PROC IMPORT, PROC SQL. An effective communicator with analytical, inter-personal,

Organizational & mentoring skills

WORK EXPERIENCE

Consultant, Landmark group Pvt Ltd Feb 2020 To Till Date

Created various Hand-Holding Plans for customer retention across various segments for

the India Business.

• Performed market basket analysis to study the customer behavior so as target him

based on his shopping behavior (Goal :- Win back customers)

• Performed EDA for First Timers for reducing the churn and make them repeat within

same Fiscal Year.

Performed analysis across Tier 2 stores for improving their business

• Tier 2 stores were not performing well, hence a deep-dive was done to understand the

kind of customers visiting Tier 2 Stores

• Various KPI’s were observed at different demographics of customer to study the

customer behavior

• This was basically a strategic project for deciding the products which would perform

well in the Tier-2 cities resulting into a Revenue Lift.

Customer Targeting for Festive Seasons as well as End Of Seasons Sales

• Targeting customers based on their demographics, similar shopping patterns.

Software Associate, Cheil India Pvt Ltd. Mar-2018 To Feb 2020

Working as Software Associate and taking care of reports generation from various sources using SAS and SQL programming. Collecting data from various sources including raw formats and extracting data from data bases for report generation. Reports automation using SAS macros.

•Base SAS – It is used for data manipulation and cleaning raw data..

•SAS Macros – Reports automation using SAS macros.

•SQL – Extracting data from Sql databases.

•Dashboards – Creating dashboard having charts and graphs for better visualization.

•MIS Reporting by using Excel at operational and client level.

•Generating timely and accurate report for analysis.

•Creating MIS /Dashboard report and presenting it to the concern Department.

•Implement and analysis data to create daily, Weekly, Monthly And Quarterly report.

•Generating & maintaining day to day MIS data and update the management.

•Dashboards – Creating dashboard having charts and graphs for better visualization.

•Extensive usage of Excel (Aggregate Function, VLOOKUP, HLOOKUP, Pivot Table Table)

•Conditional formatting, data validation, sorting & filtering data.

TECHINCAL COMPETENICIES

Tools: SAS Macro Language and Advanced SAS Programming, SAS EG,

•Database Language - My SQL. SQL Server.

•Programming Language – SAS.

•BI Tool: Tableau, Power BI, Excel Dashboard

•MS Office – MS Excel, PPT etc.

•

Education

MA in Economics IGNOU Delhi

M.Com Magadh University, Gaya, Bihar

B.Com Nalanda Open University. Patna, Bihar

12th S N Sinha College, Aurangabad, Bihar

10th Chilhki High School, Amba

Personal information:

Father name: Basant Singh

Date of Birth: 15,Jan,1990

Marital Status: Single

Language : English, Hindi

Signature: Gautam Kumar Singh

Date:

Contact this candidate