ravi89sachdeva@gmail.

com
RAVI SACHDEVA +91 7678481684 / 9711901918
Maj lis Park, Adarsh Nagar , Delhi-33
(Base SAS Certified)

To pursue a challenging career and be a part of progressive organization that gives a

Career Objective scope to enhance my knowledge and utilizing my skills towards the growth of the
organization and to excel in this progressive software/analytics environment to my top
potential.

CAREER SUMMARY

Overview ➢ A result oriented Data analytics professional with overall exp of 6.5 years and around
5 years of experience as a SAS Programmer with INCEDO, TRAVEL-ENZA PVT LTD and
NAGARRO SOFTWARES in the area of Financial analytics, data visualization, data
validation, data profiling , cleansing .
➢ Currently working with INCEDO as a Senior Business Analyst
➢ Worked on BASE and ADVANCED SAS in Banking and Health care Domain
➢ Experience in SAS Programming, Reporting and Data Management
➢ Experience in analysis and sanity checking, validating and manipulating complex
data using DATA-step Programming, SAS Procedures, SAS Functions and
SAS/Macros.
➢ Knowledge of Basic UNIX commands
➢ Knowledge of SAS STAT procedures like PROC FREQ, PROC MEANS, PROC
SUMMARY.
➢ Knowledge of SAS procedures for creating Graphs and Charts like Proc Plot , Proc
Gplot, Proc Gchart, Proc SGPlot etc.
➢ Develop new or modify existing SAS programs to load data from the source and create
study specific datasets
➢ Knowledge of Simple Linear Regression Model
➢ Analysing raw data, drawing conclusions & developing recommendations
➢ Perform validation on derived datasets by following the standard operating
procedures during the validation process to check data accuracy
➢ Writing efficient SQL, SAS codes for data extraction and manipulation from huge
Data sources.
➢ Basics of Excel skills like Pivot Tables, HLookup & VLookup etc.
➢ Strong leadership, problem-solving, planning, team-building and project management
skills
➢ Interacting extensively with onshore counterparts on requirement gathering, analysis
and documentation
➢ Creating Dashboards & Reports with decent graphics and publishing it on a Shared
Drive
Professional Skills ➢ SAS EG 5.1 , 7.1 (SAS Enterprise Guide)
➢ SAS 9.4 for windows
➢ SAS DI Studio 4.4
➢ SAS SMC
➢ SAS Web Report Studio
➢ Platform Manager/Flow Manager
➢ MS Office (PowerPoint, Word, Outlook, Excel)
➢ MS Windows 7,8,8.1,10
➢ MS Windows server 2008 , 2012
➢ Office 365

PROJECT SUMMARY

Organization: INCEDO Projects: Genentech Data OnBoarding Workstream

TECHNOLOGIES Role: Senior Business Analyst
Domain: Life Sciences
Duration:
SEP 2019 – Present Responsibilities:

Platform & Tools: ➢ Importing the data shared by client into SAS for analysing and then exporting the
Base SAS , SAS v9.4 for desired reports after analysis.
windows, SAS EG 7.1 ➢ Hands on experience in SAS programming in unix / windows environment and EG
tool
➢ Planning, writing, designing and executing SAS programs, analyze Pharma
secondary market research data, including any or all the following Data loading,
validation & alerts, profiling, analysis datasets, tables, listings, and graphs, error
handling, develop standard macros and/or tools in SAS for data analysis
➢ Maintaining, verifying, and ensuring the quality and accuracy of all assigned output
and project requirements
➢ Maintain quality of the code developed by self and the team by ensuring that SAS
programs developed for specific projects is effectively portable to other protocols
(Reusable code)
➢ Worked on IMS DDD, XPO data, NSP, NPA, Oncology Patient data and 867
Supplier level data from vendors like Value Centric
➢ Interpreting, analyzing and reconciliation of Sales data obtained from a
variety of sources.
➢ Develop new or modify existing SAS programs to load data from the source and
create study specific datasets/extracts
➢ Writing efficient codes from scratch on Ad-hoc requests
➢ Analysing raw data, drawing conclusions & developing recommendations
➢ Deploy scheduling to execute the SAS code using Enterprise Guide and SAS
Management Console
➢ Working on DI Studio Transformations like Append , Table loader , extract etc
➢ Creating Standard Reports and Fortnightly Reports
➢ Generate reports either in HTML, EXCEL, CSV, PDF or RTF formats according to
the client specifications
➢ Fetching the data from different data sources, cleaning and summarizing the data
Organization: TRAVEL- using SAS & SQL (aggregate functions, subqueries, joins & case when-then)
ENZA PVT LTD ➢ Using SET, MERGE, JOIN, SORT, APPEND, CONCATENATE techniques and combine
the data sets
Duration: ➢ Using TRANSLATE, TRANWRD, SCAN, TRIM, TODAY, SUBSTR, COMPRESS,
April 2017 – Present INTCK,INTNX,WEEKDAY,PUT,INPUT,CATT to transform the data
➢ Reviewing productivity data reports, monthly and weekly status reports for
Platform & Tools: clearing account reconciliation.
Base SAS , SAS v9.4 for ➢ Delivering reports to clients using Shared drive
windows, SAS EG 5.1,
SAS DI Studio 4.4

Projects: Swipe Repayment Analysis

Role: SAS Analyst
Domain: Banking

Responsibilities:

➢ Importing the data shared by client into SAS for analysing and then exporting the
desired reports after analysis.
➢ Interpreting, analyzing and reconciliation of data obtained from a variety of
sources.
➢ Develop new or modify existing SAS programs to load data from the source and
create study specific datasets/extracts
➢ Analyse the lead data to understand monthly expenditure amount of the
customers and did customer segmentation and doing Credit risk analysis
➢ Writing efficient codes from scratch on Ad-hoc requests
➢ Analysing raw data, drawing conclusions & developing recommendations
➢ Deploy scheduling to execute the SAS code using Enterprise Guide and SAS
Management Console
➢ Working on DI Studio Transformations like Append , Table loader , extract etc
➢ Troubleshooting of SAS Web Report Studio
➢ Creating Standard Reports and Fortnightly Reports
➢ Extensive use of PROC SQL, PROC PRINT, PROC SORT, PROC FREQ, PROC MEANS,
PROC SUMMARY, PROC SGPLOT to perform analysis of the datasets using queries,
joining and altering tables using SAS EG
➢ Generate reports either in HTML, EXCEL, CSV, PDF or RTF formats according to
the client specifications
➢ Fetching the data from different data sources, cleaning and summarizing the data
using SAS & SQL (aggregate functions, subqueries, joins & case when-then)
➢ Using SET, MERGE, JOIN, SORT, APPEND, CONCATENATE techniques and combine
the data sets
➢ Using TRANSLATE, TRANWRD, SCAN, TRIM, TODAY, SUBSTR, COMPRESS,
INTCK,INTNX,WEEKDAY,PUT,INPUT,CATT to transform the data
➢ Reviewing productivity data reports, monthly and weekly status reports for
clearing account reconciliation.
➢ Delivering reports to clients using Shared drive
Organization: NAGARRO
SOFTWARES Project Name: Family Welfare Analysis
Role: Associate
Domain: Health Care
Duration:
March 2014 – March Responsibilities:
2017
➢ Worked with Nagarro for around 3 years in Health care domain
Platform & Tools: ➢ Importing the data shared by client into SAS for analysing and then exporting the
Base SAS , SAS v9.3 for desired reports after analysis
windows, SAS EG 5.1, ➢ Expertise in Analytics, which includes Requirement study for projects,
SAS DI Studio Documentation, writing SAS codes from scratch and updating existing system as
per requirements.
➢ Experience in data integration based on different sources, cleaning, manipulation,
by using different components from Base SAS, SAS PROCS, SAS SQL and
Functions like INPUT, PUT, SUBSTR, INDEX, SCAN, FIND, DAY, MONTH, YEAR,
MDY, INTCK, INTNX, COMPBL, COMPRESS, TRIM, STRIP, CAT, CATS,CATX,
SUM ,REVERSE etc
➢ Strong and efficient in data manipulation, health care data analysis, data mining
and creating dashboards
➢ Experience in data management, cleaning, reporting and integration using SAS
Programming skills
➢ Accountability for quality, timeliness and efficiency for the work assigned
➢ Strong leadership, problem-solving, planning, team-building and project
management skills
➢ Experience in SAS Coding, Reporting, Data Management and Data Mining
➢ Data management skills like Merging or Joins, Handling missing values, Reading
Raw data files, Handling programming errors, Accessing and Managing data,
Appending, Concatenating and Interleaving of SAS Datasets
➢ Developed various outputs in the form of RTF, HTML, PDF files using SAS ODS
facility
➢ Requirements gathering and analysis of business requirement document
➢ Producing customized Dashboards and Reports for Performance Optimization
➢ Doing Research and providing better solutions to the clients

Organization: Orient
Technologies Pvt Ltd

Duration:
Jul 2012 – Feb 2014
➢ Installation of Software and Troubleshooting of all Windows Operating Systems
➢ Monitoring and Troubleshooting Network and All Windows Operating Systems
Platform & Tools:
➢ Coordination with Service providers and Vendors
Outlook 2010
➢ First level DNS, DHCP, Printer Management, Server Support
➢ Installation and Troubleshooting of MS office
➢ Maintained technical knowledge in networking area, operating system (Server and
PC)
 PERSONAL SUMMARY

Educational Summary Qualification University/ Year of

Percentage/CGPA
Board Passing
B. Tech Kurukshetra 2011 71 Percent
(CSE) University

XII CBSE 2006 63 Percent

X CBSE 2004 72 Percent

Personal Details DOB Gender Marital

Languages Spoken
Hobbies
Status
17Apr1989 Male Single English Watching Web
Hindi Series ,
Playing
Badminton &
Volleyball