Ravi Sachdeva Email & Phone Number

Gurgaon, Haryana

New Delhi Area, India

Project : 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

Gurgaon, India

Project : 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

New Delhi Area, India

Below 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).