sas consultant
Wellsfargo
Total years of experience :2 years, 4 Months
• Responsibilities to understand the business requirements to changes into the reports, planed and implemented business policies, control access to data and capabilities, user’s environment establishment.
• To manage permission for SAS visual data recovery, metadata server and application server.
• Responsible to Manage the ODBC connection through SAS VDD.
• Responsible to Manage, maintaining and monitoring the Job scheduling through SQL, windows and SAS DI.
• Created WRS reports from OLAP cube studio and Info map studio.
• Generated filters In Infomap studio as per requirements
• Handling the data analysis, data mining and data validation on database level using SQL Server.
• Good knowledge over DWH concepts and Dimensional modeling. (Star schema, snowflake schema).
• Designing of Source and target, Creation of Jobs using SAS DI Studio with the help System defined and User Defined transformations.