Ravi Sachdeva Email and Phone Number
Result oriented with good exposure in the field of Analytics ( Banking , OTT Platform , Pharma/HealthCare ) .Proficient in Microsoft Azure , ADF , Azure DataBricks , ADLS GEN 2 , PySpark , SQL , PowerBI , SAS, Python, Hive.
Exl
View- Website:
- exlservice.com
- Employees:
- 20487
-
Senior ConsultantExl Sep 2021 - Present -
Senior Business Analyst(Sas)Incedo Inc. Sep 2019 - Sep 2021Gurgaon, Haryana -
Sas ProgrammerTravel-Enza Pvt Ltd Mar 2017 - Sep 2019New Delhi Area, IndiaProject : Swipe Repayment Analysis (Credit Card Banking Domain)➢ Importing the data shared by client into SAS for analysing and then exporting the desired reports after analysis. ➢ 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➢ Fetching the reports from SAS Web report Studio ➢ 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 UNIVARIATE, 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
-
Business Analyst(Sas)Nagarro Mar 2014 - Mar 2017Gurgaon, IndiaProject : Family Welfare Analysis (HealthCare Domain)Worked with Nagarro for around 3 years out of which 1.3 years into Tech support and 1.7 years into SAS in Health Care Domain➢ Importing the data shared by client into SAS for analysing and then exporting the desired reports after analysis➢ Expertise in Analytics, which includes Requirement study for projects, 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➢ 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 -
System AdministratorOrient Technologies Pvt. Ltd. Jul 2012 - Dec 2014New Delhi Area, IndiaBelow are the Day to Day tasks carried out -Handle daily technical support activities on desktop support, data network and server management.Walk customers through installing applications and computer peripherals-Ask targeted questions to diagnose problems-Guide users with simple, step-by-step instructions and Train end users on usage of computer hardware and software-Conduct remote troubleshooting-Customize desktop applications to meet user needs-Adhere to policies as per corporate manuals and directives.-Interact with staff on desktop problems and their resolution.-Install and test desktop software applications and internet browsers-Test computers to ensure proper functioning of computer systems.-Monitoring and Troubleshooting Network and All Windows Operating System -Monitoring Symantec Antivirus Server update and Installation Client Package.-Ensure that company IT assets are maintained responsibly.-Coordination with Service providers and Vendors.-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).
Ravi Sachdeva Skills
Ravi Sachdeva Education Details
-
Kurukshetra UniversityA+
Frequently Asked Questions about Ravi Sachdeva
What company does Ravi Sachdeva work for?
Ravi Sachdeva works for Exl
What is Ravi Sachdeva's role at the current company?
Ravi Sachdeva's current role is Experienced in AWS | Tableau | PySpark | SAS | SQL | Python.
What schools did Ravi Sachdeva attend?
Ravi Sachdeva attended Kurukshetra University.
What skills is Ravi Sachdeva known for?
Ravi Sachdeva has skills like Microsoft Office, Microsoft Word, Advanced Sas, Sas, Sas Enterprise Guide, Microsoft Powerpoint.
Who are Ravi Sachdeva's colleagues?
Ravi Sachdeva's colleagues are Tarun Saxena, Dheeraj Gupta, Anulekha Virupaksha, Ashutosh Mishra, Rishabh Agarwal, Lovelyn Regner, Nitin Bhatt.
Not the Ravi Sachdeva you were looking for?
-
-
-
Ravi Sachdeva
Udaipur -
Ravi Sachdeva
Software Engineer @Amazon | Ex-Tcs Digital | Talk About Tech & Personal FinanceBengaluru
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial