SUMMARY

• Have 10+ years of experience in software development, Implementation, maintenance and support as a SAS Consultant/ Programmer, SAS/BI Developer and SAS BI Administrator, installer, and SAS/Visual Analytics Administrator and several BASE/SAS Products, SAS BI Reporting applications with profound experience in Financial, Banking Retail and Healthcare organizations.
• Experience as a SAS Administrator versions SAS 9.1, SAS 9.2, SAS/9.3.
• Experience in working with SAS DI, SAS/OLAP, SAS/IMAP, SAS/WRS, SAS/IDP, SAS/SMC, SAS/EG, SAS BI/Dashboard in SAS 9.1 & 9.2, 9.3 environments.
• Working Experience SAS on Unix, Mainframes, Windows Environments.
• Creating Stored process and creating prompts using Stored process and execute in SAS BI Applications.
• Experience in data cleaning techniques and transformations in SAS/Data Integration studio.
• Good working knowledge in SQL Programming.
• Good Experience in SAS Macros.
• Proficiency in SAS/Base, and SAS Stat with basic understanding of SAS
• Macros, and SAS/Graph.
• Expertise in using various SAS Procedures such as proc sort, proc format, Proc mean, Proc tabulate, Proc freq, and Proc Report.
• Data Extraction from varying sources, data manipulation and cleansing in support of analysis being performed.
• Strong experience in various SAS procedures like Proc Print, Import, Proc freq, Proc Report, proc SQL, Freq, Means, Sort, Univariate, Report, Contents, Chart, Print, Plot,
• Format, Transpose, SQL and Data NULL in generating reports.
• Troubleshooting of SAS Servers, libraries and security schemes.
• Experience in using SMC to create user and assign Access controls, create groups /roles.
• Configuration and maintenance of Users, Groups and Roles in SAS Metadata using SAS/SMC.
• Install SAS hotfixes client side and server side
• Memory statistics and performance issues.
• Backup and restore of SAS Metadata using backup utilities and promotion and replication.
• Handle day to day activities like creating user group/handling the roles etc.
• Monitor the performance, I/O and disk usage of AIX/Linux servers on which SAS Services are running
• Coordinate with SAS Institute for upgrades and deployment of new SAS applications.
• SAS/UNIX Server performance monitoring and tuning.
• SAS License renewal and apply SAS Service pack on SAS/UNIX Server.
• Experience in SAS Migrations (e.g.: - version 9.2 to 9.3)
• Knowledge SAS Backup and restore mechanism.
• Experience with Web sphere Provided Security and authentication for several business users for SAS BI applications.
• Creating Reports using SAS/Web Report Studio and Post reports in Portal for accessing Business users and give permissions for them as per priority.
• Strong BASE/SAS Programming experience.
• Experience in registering SAS/Datasets with SAS/Share Engine.

PROFESSIONAL EXPERIENCE

Confidential - Reston, VA

SAS Administrator

Responsibilities:

• Working with Stored process and Base SAS Programming.
• Create Reports.
• Make sure that all servers and applications are up and running.
• Connectivity of databases.
• Cataloging of databases.
• Mount/Unmount of file systems.
• Metadata Migration.
• User Management.
• Identifying Firewall issues.
• Working of Putty, Interactive and pc sas and All SAS BI Applications.
• Migration and Installation.

Confidential, Kansas City, MO

SAS EBI Architect

Responsibilities:

• Created SQL Queries using Netezza to load the data.
• Registered SAS files from views created by Netezza to give performance.
• Created reports using SAS/Web Report Studio.
• Schedule & run Reports using SAS/Web Report Studio.
• Posted Reports in SAS/Information Delivery Portal
• Create Information Maps.
• Created Prompts&filters using SAS/IMaps.
• Created prompts using Stored process using SAS Enterprise guide.
• Register SAS/Share tables.
• Design Dashboards of Bar charts and Dynamic Gauges.
• Create users and provide access all reports and dashboards to users
• Meta data security.
• Installation of SAS Applications.
• User permissions as per requirements.

Confidential, Phoenix, AZ

Responsibilities:

• Worked under SAS BI Platform.
• SAS BI 9.2 Platform Administration.
• Create Reports and posted in Information Delivery Portal.
• User management, Authentication
• Create Schemas using Hive.
• Create DDLs and HQLs using HIVE Queries
• Unit Testing.

Confidential, Phoenix, AZ

Responsibilities:

• Setup, Install, configure SAS BI Server.
• User management.
• Migration activities.
• Scheduling.
• Develop ETL process using DI Studio and scheduled Jobs & Created Cubes.

Confidential, Phoenix, AZ

Responsibilities:

• Monitor the Daily Jobs.
• Participate in setup &Install and configure
• Create Jobs Using DI Studio.
• Schedule Jobs using SMC
• Execute Monthly Jobs
• Resolve the issues if portal doesn't access
• Installation, administration, maintenance and support of SAS Enterprise BI Applications.
• Administrative Activities.
• Raise Tickets and solve the Problems in IMR, CMR's of Amex Processess.

Confidential

Responsibilities:

• Analyzed the Existing SAS programs to convert to Cobol.
• Developed Cobol Programs based on the Existing SAS Code.
• Optimized SAS Programs

Confidential

Responsibilities:

• Extracted Data from Oracle and SQL Server 2005
• Defining the process for data staging / ETL process flows.
• Decision on defining dimensions and measures for data mart
• Analyzing Confidential sample reports.

Confidential

Responsibilities:

• Analyzing SAS scripts, and JCL scripts. Change the Existing the SAS code and JCL code.
• Testing the SAS programs and JCL programs.
• Documentation and move code to the production.