SUMMARY

• Strong SAS Certified Administrator 8 years of experience in UNIX, AIX, Linux, Windows and implementation of various projects for Banking industries.
• Execute the necessary actions to achieve and maintain the optimal performance, reliability and availability of the SAS platform.
• Provided help - desk support, production support, Tech support, administration.
• Troubleshot SAS Applications issues in user environment and provided technical solutions to business user needs.
• Manage the SAS platform in single server version.
• Manage the SAS platform in multiple server/tier version.
• Manage the SAS platform in a multi-node Grid environment with Linux operating system for productive and non-productive environments.
• Experience with SAS Environment Manager and Platform RTM.
• Integration with thirdparty tools such as Bitbucket, JGrid, Spark.
• Experience with security and authentication issues and SSO (related to source data access, as well as the integration of SAS with tools such as LDAP/Kerberos).
• Expert level skills in SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/CONNECT, SAS/SHARE, SAS/ACCESS, SAS/ODS, SAS/SQL, SAS ENTERPRISE GUIDE AND SAS/MACRO.
• Upgrades, patches, renew SAS licenses, maintenance - performance monitoring and tuning of SAS environments.
• Extensive hands on experience on SAS BI on SAS 9.1.3, SAS 9.2, SAS 9.3, SAS Grid 9.4 Administration including SAS Metadata Server Cluster, SAS connect, SAS OLAP server, SAS Metadata server, SAS Object Spawner, SAS Management console, Enterprise guide, OLAP studio, Data integration studio, Web report studio, SAS connect server and LSF.
• Good experience in analyzing, resolving production issues and performing business analysis functions.
• Experience as on-call production support. Experience with very large databases as Hadoop, Teradata, Oracle, DB2, MS SQL server environment.
• Good experience in SAS Programming and business analysis.
• Created reports using SAS ENTERPRISE GUIDE.
• Extensive install, configure and support experience in SAS/Access, Interface to Oracle, Teradata, DB2, Sybase, Postgress, JDBC, ODBC.
• Excellent installation, configuration experience of SAS9.4 in Linux environment.
• Strong experience in writing queries and SAS jobs against SQL server.
• Experience in maintaining a large multi-platform SAS environment it includes SAS Business intelligence tools and SAS application tier.
• Good experience in metrics, reporting and predictive analysis systems and applications.
• Good experience in write, maintain and support SAS Programs in BASE SAS and Enterprise guide.
• Good experience in using SAS Web applications as Information Delivery Portal, Web Report Studio, SAS Studio.
• Administered SAS BI tools and base SAS on UNIX environment.
• Strong experience in SAS ETL and design as extracting data from raw data files, excel spreadsheets and external RDBMS tables.
• Worked with multi-platform across multiple environments.
• Experience in killing jobs.
• Good experience in developing SAS metadata Repositories.
• Good experience in Active directory Authentication, Kerberos and PAM.
• Good experience with Shell Scripting.
• Administered the SAS start-up and stop scripts and the status of the server services.
• Good experience in working with Hadoop on Linux using command line.
• Experienced in troubleshoot services that are not running and restarting the servers.
• Good experience in adding and removing users.
• Experience in installing SAS software and patches in UNIX / Linux environment.
• Good experience in system analysis and strong knowledge of relational database design and support.
• Strong participates in creation, implementation of project designs and implementation of standards.
• Participated in infrastructure support activities such as system integration, application configuration, security management and change/ release management.
• Good experience with Base SAS and its procedures.
• Familiarity with Teradata SQL.
• Creation and implementation of SAS Stored Process based on Html web languages, integration with RTM monitoring and other datasources.
• Extensive experience in Microsoft Office Suite.
• Experience scheduling jobs using crontab, autosys and SAS Platform Suite (LSF).
• SAS Code optimization to spread across the GRID nodes.
• Strong written skills and experienced in the development of abstracts, presentations and publications.
• Excellent organizational, teamwork, presentation and communication skills.
• Determined quick learner, self-starter and effective troubleshooter and committed to continuous learning.

TECHNICAL SKILLS

SAS Tools: Base SAS 9.1.3, SAS 9.2, SAS 9.3, SAS Grid 9.4, EBI, SAS Graph, SAS STAT, SAS ODS, SAS MACROS, SAS/SQL, SAS/GRAPH, SAS/FSP, SAS/AF, SAS/SHARE, SAS/CONNECT, SAS/EIS, SAS/SHARE NET, SAS Financial Management FM, SAS Activity Business Management ABM, SAS JMP, SAS/IntrNet, MDDB Server common products, SAS Integration Technologies, SAS Business Intelligence, SAS OLAP Cube Studio, SAS Management Console, SAS DI Studio, SAS WEB Report Studio, SAS Information Map Studio, Enterprise Miner, SAS/ACCESS Interface to ODBC, SAS/ACCESS Interface to OLE DB, SAS Enterprise Guide 8.3, SAS Stored Process, LSF.

SAS Procedures: Tabulate, Report, Print, Printto, Contents, Means, Freq, Univariate, Summary, SQL, Datasets, Copy, Chart, Sort, Transpose, Registry and Format, Metadata.

Database: Oracle, Hive, MS Access, Teradata, SQL Server, Sybase, DB2.

Languages: SAS Base, SAS Macro Language, SQL, Shell script, HTML, Phyton 3.7.

Others: MS Office 2003, MS Excel, MS Word, MS Power Point, Cloudera Manager 5.4, Hadoop, Hive, Hue, SAS Grid 9.4, SAS Management Console, SAS Environment Manager, LSF, Cognos, QlikView, Tableau.

Operating System: Windows, UNIX, Linux, Mac OS.

PROFESSIONAL EXPERIENCE

Confidential

SAS Application Manager

Responsibilities:

• Drive the evolution, upgrade and maintenance of SAS data processing and analytics platform.
• Ensure the correct design and evolution of the solutions that are created and run in SAS by collaborating with business users.
• Run a community of practice that ensures the best practices in process design and maintainability across all business areas.
• Support the business during all phases of development process and analysis, design, construction, testing, and implementation as well as provide user and operational support on applications to business users.
• Utilize in-depth specialty knowledge of applications development in SAS to analyze complex problems/issues, provide evaluation of business process, system process, and industry standards, and make evaluative judgement.
• Recommend and develop security measures in post implementation analysis of business usage to ensure successful system design and functionality.
• Consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems.
• Responsible for managing the upgrade of SAS 9.4 M4 to SAS Grid 9.4 M6 in Linux Red Hat environment.
• Participating in business review meetings to gather requirements to design Application.
• Working closely with the project development team and End-User community in coordinating with the bug fixes.
• Participating and creating test plan documents, writing test scenarios and test cases for testing of the SAS application.
• Responsible for resolving all technical issues related to the SAS upgrade Migration to Linux platform, also addressing concerns of Business Stewards which potentially arise due to the SAS upgrade.
• Involved in promoting SAS/Access Interfaces to Hadoop, Teradata, DB2, ODBC and Oracle.
• Participating in business review meetings to gather requirements to design Application.
• Working closely with the project development team and business analysts in coordinating with the bug fixes.
• Participating and creating test plan documents, writing test scenarios and test cases for testing of the SAS application.
• Responsible for resolving all technical issues related to the SAS upgrade Migration to Linux platform.
• Address issues for all Developers which potentially arise due to the SAS upgrade.
• Report to the Project Manager on the day-to-day tasks of the SAS upgrade Project.
• SAS Platform Administrator with high impact in multiple business processes.
• SAS Grid 9.4 Administrator multi-tier with more than 1200 concurrent processes.
• Administration of more than 500 SAS resources like Libraries, Folders, Data Integration Jobs and Miner Projects.
• Setup and administration of more than 100 SAS libraries like Base,SPDS Teradata and Oracle engines using SAS Access Interface.
• Deployment and technical support to more than 450 SAS Jobs in Scheduling Manager (LSF).
• Configuration and maintenance of 4 SAS Grid Queues in order to attend different business users, Batch jobs, SASGSUB processes and Miner projects.
• Backing up and restoring SAS within a SAS Grid Manager environment and on managing all SAS Grid Manager Nodes from a centralized location.
• Leveraging and understanding parallel processing and job submission capabilities of SAS Grid Manager in relation to usage of SAS Enterprise Miner, SAS Data Integration, SAS Add-In for Microsoft Office and SAS Enterprise Guide.
• Create and configure libraries and permissions for Users and groups of users and assign logins. Designing, implementing and maintaining the security framework (access rights and privileges, user roles/groups, etc) consistent with SAS Best Practices.
• Worked on administration and configuration of SAS Enterprise Miner Java Web and SAS Environment Manager.
• Integration with Bitbucket repositories.
• SAS licenses renewal and metadata updates.
• Check status and operate servers in SAS Grid Platform.
• Monitor server activity and administer logging related with SAS Services and LSF daemons.
• Manage users’ access.
• Identify, analyze, document and correct issues detected in SAS Grid Platform.
• Monitor SASGSUB processes status using LSF and SASGSUB commands.
• Run Scheduled SAS Data Integration jobs in SAS Management Console.
• Collaborate with TI Team, SAS Team for the implementation of Change Requests in the SAS Grid Platform.
• Design, develop and implement a SAS program to monitor the data size folders, in order to avoid that users, exceed the size allowed per business area; in PROD environment.
• Measure and size the impact and risks of changes made to SAS Grid Platform.
• Configure new LSF and SAS Grid Nodes to SAS 9.4 Grid M6 Production environment.
• Configure new SAS Server in SAS Grid 9.4 M6.
• Configure new LSF Queues.
• Configure maxslots for LSF nodes.
• Install and Configure SAS 9.4 Grid M6 on Linux Red Hat 7 for UAT environment.
• Install and Configure LSF 9.1.3 on Linux Red Hat 7 for UAT Environment.
• Documentations.

Environment: (Windows, Citrix and Red Hat Linux 6, 7): SAS 9.4 M6, SAS Grid, SAS Cluster Metadata Server, SAS/Macros, SAS-Data Integration Studio, SAS Enterprise Guide 8.2, SAS Enterprise Miner, SAS Management console, SAS Add-in for Microsoft Office, SAS Studio, RTM Platform.

Confidential

SAS Administrator / SAS Developer

Responsibilities:

• Assigned to SAS Administration project to Confidential client.
• Monitoring and administration of SAS platform.
• Attention incident operational areas (Customer Strategy, Fraud, Risk, etc.) for SAS applications.
• Shell scripting (intermediate) UNIX.
• Creating metrics for monitoring server performance of SAS applications.
• Creation of monitoring reports to the business areas.
• Migrating SAS Platform 9.3 to 9.4
• Troubleshooting layered SAS (Metadata Object Spawner, Workspace Server) services.
• SAS Platform Administrator with high impact in multiple business processes.
• SAS Grid 9.4 Administrator multi-tier with more than 1,300 concurrent processes.
• Administration of more than 2,000 SAS resources like Libraries, Folders, Pages and Portlets on Information Delivery Portal, BI Dashboard, Web Reports, Information Maps, OLAP, Data Integration Jobs, Cubes and Miner Projects.
• Setup and administration of more than 300 SAS libraries like Base, SPDS, Hadoop, Teradata and Oracle engines using SAS Access Interface to.
• Do all administrative task for SPDS like starting/stopping SPDS services, adding users to SPDS domain and grant permissions.
• Deployment and technical support to more than 300 SAS Jobs in Scheduling Manager (LSF).
• Configuration and management of SAS data sources in Visual Analytics and grant permissions to memory tables for around 50 Visual Analytics Reports.
• Configuration and maintenance of 5 SAS Grid Queues in order to attend Power users, BAU jobs, High Users, Miner projects and Low users.
• Backing up and restoring SAS within a SAS Grid Manager environment and on managing all SAS Grid Manager Nodes from a centralized location.
• Leveraging and understanding parallel processing and job submission capabilities of SAS Grid Manager in relation to usage of SAS Enterprise Miner and/or SAS Enterprise Guide.
• Create and configure libraries and permissions for Users and groups of Users and assign logins. Designing, implementing and maintaining the security framework (access rights and privileges, user roles/groups, etc) consistent with SAS Best Practices.
• Conduct root cause analysis, problem management, incident management, short- and long-term corrective action on SAS tools and SAS programs related to SAS Grid and SAS EBI/EDI platforms based on ITIL methodology.
• Worked on administration and configuration of SAS Web Report Studio and Information Delivery Portal to create new users and authorizations and configuring Mail Servers.
• Implemented the change request/incident from the SAS tech support/business users whenever an update/incident has occurred in the SAS Grid environment relate to SAS EBI and analytical applications based on ITIL.
• Lead level 3 technical support for SAS Grid computing environment
• SAS licenses renewal.
• Involved in the Sizing of the SAS Platform and the SAS installation
• Upgrade from SAS 9.4 M4 to SAS 9.4 M6
• Participated in project planning and proof-of-concepts involving SAS and third-party components.
• Documentations and Technical memories.

Environment: (Windows and Red Hat Linux): SAS 9.4, SAS Grid, SAS/Macros, SAS-Data Integration Studio, SAS Enterprise Guide, SAS Enterprise Miner, SAS Management console, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Add-in for Microsoft Office, SAS Visual Analytics, SPDS.

Confidential

ENGINEER INTERMED ANALYST / SAS Administrator / SAS Developer.

Responsibilities:

• Monitoring and administration of SAS platform.
• Attention incident operational areas (Customer Strategy, Fraud, Risk, etc.) for SAS applications for 600+ users.
• Shell scripting (intermediate) UNIX.
• Creating metrics for monitoring server performance of SAS applications.
• Creation of monitoring reports to the business areas.
• Migrating SAS Platform 9.2 to 9.3.
• Troubleshooting layered SAS (Metadata Object Spawner, Workspace Server) services.
• Application of governance rules to the platform (limited number of sessions per user, notifications high resource consumption, custom user access levels)
• Responsible of the design and creation of all the metadata structure aligned to the requirements of the project
• Attending all SAS related meetings with SAS users and technical leader.
• Follow up for issues with SAS Institute.
• Monitoring the Status and Operation of SAS Metadata Servers.
• Manage metadata repositories.
• Identify the properties and functionality of SAS servers.
• Monitoring, Logging, and Troubleshooting SAS Servers.
• Administering Users, manage connection profiles, ACT, ACLs and manage roles.
• Register users, groups and SAS tables in the metadata.
• Administering Data Access.
• Promote metadata and associated content.
• Management of SAS Portal, Pages, Portlets, SAS Stored Process, Web Reports and SAS OLAP Cubes.
• Advise and support of the SAS users, including SAS developers, SAS Analytical and SAS Report users related to SAS environment.
• SAS Enterprise Miner and SAS Enterprise Guide Clients Installation.
• Configuration of SAS Libraries to DB2, Oracle and ODBC.
• Install hot fixes for SAS Base and SAS Enterprise Guide.
• L3 technical support for SAS Platform and SAS Applications.
• Training related to SAS topics.
• Coordinate work teams to execute authorized changes (RFCs) to the SAS platform.
• Install SAS servers in processing layer in Linux operating system and productive environment.
• Create technical installation memories, operation guides and manuals.

Environment: (AIX 6 / AIX 7): SAS 9.1 and 9.2, SAS/Macros, SAS-Data Integration Studio, SAS Enterprise Guide, SAS Enterprise Miner, SAS Management console, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Information Delivery Portal, SAS/Access to DB2, SAS/Access to Oracle, SAS/Access to Informix, SAS/Access to ODBC, SAS Add-in for Microsoft Office, SPDS.

Confidential

SAS Administrator

Responsibilities:

• SAS Base.
• SAS Macro Language.
• Enterprise Guide.
• Web Stored Process Server.
• Management Console.
• Worked in SAS users personalization for BANAMEX

Environment: (Windows Server): SAS 9.2, SAS/Macros, SAS-Data Integration Studio, SAS Enterprise Guide, SAS Enterprise Miner, SAS Management console, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Information Delivery Portal, SAS/Access to DB2, SAS/Access to Oracle, SAS/Access to ODBC, SAS Add-in for Microsoft Office, SPDS.