Summary of Experience:

• Strong SAS Administrator 8 years of experience in UNIX- SOLARIS, AIX and implementation of various projects for pharmaceutical industries and Banking industries.
• Provided help-desk support, production support, Tech support, administration.
• Troubleshot SAS Applications issues in user environment and provided technical solutions to business user needs.
• Expert level skills in SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/CONNECT, SAS/SHARE, SAS/ACCESS, SAS/ODS, SAS/SQL, SAS ENETRPRISE GUIDE AND SAS/MACRO.
• Did software upgrades, patches, maintenance- performance monitoring and tuning of SAS environments.
• Extensive hands on experience on SAS BI on SAS 8, SAS 9.1.3, SAS 9.2, SAS 9.3 Administration including SAS connect, SAS internet server, SAS OLAP server, SAS Metadata server, SAS Object Spawner, SAS Management console, Enterprise guide, OLAP studio, Data integration studio, Web report studio, SAS performance forecast server, SAS connect server.
• Good experience in analyzing, resolving production issues and performing business analysis functions.

• Used SAS DI studio to consolidate and manage enterprise data from a variety of source systems, applications and technologies.
• Experience as on-call production support. Experience with very large databases VLDB on oracle, DB2, 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, Terradata.
• Excellent installation, configuration experience of SAS9.3 in UNIX environment.
• Strong experience in writing queries and SAS jobs against SQL server.
• Used SAS DI studio to cleanse, migrate, synchronize, replicate and promote data for applications and business services.
• Good experience in developing power point presentations.
• 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 9.2 web applications called information delivery portal, web report studio.
• Administered SAS BI tools and base SAS on UNIX environment.
• Good experience in designing SAS Architectures.
• Strong experience in SAS ETL and design as extracting data from raw data files, excel spreadsheets and external RDBMS tables.
• Developed a visual report writer in VB, VBA as an MS Excel add-in module
• Worked with multi platform across multiple environments.
• Experience in killing jobs.
• Good experience in developing SAS metadata Repositories.
• Good experience in Active directory Authentication 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 Oracle on Unix 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 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.
• Extensive experience in Microsoft word, excel, PowerPoint and outlook.
• 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 Summary:

• SAS Tools: Base SAS 8.2, SAS 9.1.3, SAS 9.2 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 EG 4.0, SAS/ETL
• SAS Procedures: Tabulate Report, Print, Printto, Contents, Means, Freq, Univariate, Summary, SQL, Datasets, Copy, Chart, Sort, Transpose, Registry and Format.
• Database: Oracle, MS Access, Teradata, SQL Server, FoxPro, DB2.
• Languages: C, C ,.net, C , VB.NET, VB, VBA, SQL, PL/SQL, COBOL, PL1, JAVA, J2EE, SAP R/3 ABAP, Fortran, HTML, XML, PERL, JCL
• Others: MS Office 2003, MS Excel, MS Word, MS Power Point PP , Lotus Notes, Crystal Reports, Java Script, VB Script, PERL Script, VB, VBA, AS/400.
• Operating System: Windows 2000/NT/XP, UNIX, Linux, Mac OS, Z/OS, MVS Mainframe , MVS/TSO, ISPF

Detailed Experience:

Confidential

Sr. SAS EBI Admin/ETL consultant

Responsibilities:

• Responsible for managing the upgrade of SAS 9.2 on AIX 5.3 to SAS 9.3 in AIX 6.1 OS 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 AIX platform, also addressing concerns of all Developers 150 which potentially araise due to the SAS upgrade
• Involved in promoting SAS/Access Interfaces to DB2, SQL Servers, Mainframe,
• Netezza on the newly build 9.3 setup by re-configuring it's SASROOT host specific files and tested with SAS End-User community 150 by working with separate groups
• Responsible for all the SAS End-User community on daily basis and serve their day- to-day functional and technical needs on SAS Enterprise Server platform
• Responsible for managing the upgrade of SAS 9.1.3 on Windows to SAS 9.2 in AIX operating environment
• 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 AIX platform
• Address issues for all Developers which potentially araise due to the SAS upgrade
• Report to the Project Manager on the day-to-day tasks of the SAS upgrade Project
• Responsible for administering current SAS 9.1.3 on Windows platform
• Responsible for supporting current SAS 9.1.3 Production System Administration
• Involved in promoting SAS / Access Interface to DB2, SQL Servers, Mainframe on the newly build 9.2 setup by re-configuring it's SASROOT host specific files and tested with SAS User community by working with separate groups
• Customized by implementing SAS Batch scripts to make jobs run via Autosys
• Trained the user community PC SAS and SAS Foundation 9.1.3 on using the new SAS Enterprise 9.2 functionality
• Meet with the Business/Technical/SAS Developers- Users and Business Analysts and understand their data sources and establish/build connectivity layers using SAS Management Console and grant appropriate permissions at group level for Users to be able to connect both external and internal connections to SAS
• Responsible for all the End-User community on daily basis and serve their day-to-day functional and technical needs on SAS Enterprise Server platform

Environment: SAS EBI Enterprise Business Intelligence 9.1.3, 9.2, 9.3, SAS 9.2, Enterprise Guide EG 4.1, 4.3 , SAS OLAP Cube Studio, SAS Management Console,SAS Web Report Studio, Enterprise Miner, SAS JMP, Windows 2003 Enterprise Edition, UNIX AIX 5L , Korn Shell, OS390, SAS Access, SAS/SQL, SAS/AF, SAS/ETL, SAS/ETS, SAS/FSP SAS/Intranet, SAS Data Integration Studio 4.2, 3.4, SAS/Graph, SQL, Teradata, Mainframe, AS400, SQL Server, MS Excel, MS Excel Macros, SQL, SAS STATS

Confidential

Sr. SAS Adminsitrator

Responsibilities:

• Maintaining SAS Server Environment.
• Install, setup, configure, migrate and maintain servers on UNIX environment.
• Provided technical and help-desk support.
• Performed metrics and reporting.
• Solved many tickets on the spot and fixed issues.
• Overseeing a SAS user community.
• Executedcomplex queries of large SQL/My SQL tables efficiently.
• Provided on call support for helpdesk problem resolution.
• Worked with onsite and offshore SAS developing team.
• Worked with end users.
• Supported SAS existing Applications.
• Always monitor the metadata server environment.
• Provided support for SAS customers by trouble shooting problems with SAS applications/environment and provided technical solutions to business user needs.
• Work with user issues/debug problems to resolution.
• Install SAS 9.x software on large servers/multi-tier environments.
• Provided end user support for SAS 9.2 GRID PLATFORM.
• Responsible for ticket management and created reports for project manager.
• Created users and assign them role in the management console.
• Involved in migrations, upgrades and performed version upgrades for both server and client components.
• Monitor the metadata server and moniter the SAS Grid environment.

Environment: SAS 9.2, 9.3, Teradata, DB2, SAS Enterprise Guide, MS Excel, Data integration Studio DI , OLAP Cube studio, Cognos BI , Information Map studio, Management Console, SAS Access, SAS SQL, SAS AF, SAS Stat, SAS Graph , Mainframe , UNIX

Confidential

SAS Administrator.

Responsibilities

• SAS Implementation and configuration of SAS 9.2 Enterprise BI Version and SAS 9.1.3 BI Version, SAS Data Integration Studio, Management Console, Enterprise Guide, OLAP Cube Studio. Web Report Studio, Information Map Studio.
• Support in daily job scheduling, jobs monitoring using SAS Management Console, the Flow Manager in the Platform LSF Process Manager under UNIX Server environment.
• Migrating from SAS 9.1 Bi Version to SAS 9.2 Enterprise BI version.
• Created and creating SAS ODS reports using SAS EG, SAS SQL, and OLAP Cubes.
• Converted WEB Focus queries into SAS Queries and reports.
• Created Information Maps using Information Map Studio.
• Validating reports and there figures with other department and Excel reports.
• Providing support to internal customers like Client Care, Sales, Analytics of future business, SAP BW data support for ETL and analytics on data.
• For improving the business I did worked Statistical analytics modeling.
• Used Enterprise Miner to develop Time series Analysis for future targets of marketing business.
• Created and creating OLAP Cubes using dimensions and fact tables, Details tables.
• Data migration from various operating systems Mainframe, UNIX, Windows 2003 to PC SAS.
• Automations of Daily jobs, weekly WoW jobs, quarterly QoQ jobs and yearly YoY jobs and improving the time performance of jobs to getting output.
• Specified Global Options in SAS Data Integration Studio 4.2
• Metadata Import and Export for SAS Data Integration Studio 4.2
• Using SAS Metadata Bridge to import Common Warehouse Meta model CWM into SAS Data
• Integration Studio 4.2.
• Data Conversions and data migration SAS 8.2 mainframe versions to Windows Pc SAS 9.1.3.
• Historical, regular, and Adhoc reports development from old versions to new environment with SAS BI, and Cognos BI.
• Created roles, users. Groups, authorization and permissions as SAS admin.
• Used DI Studio for ETL jobs for databases SQL Server, ESSBase, SAP BW, Oracle and Teradata and other CSV and text files.
• Working on migration SAS 8.2, SAS 9.1.3 to SAS 9.2 version to all existed, new reports and queries.
• Data warehousing ETL jobs and Data Marts from SAP BW, Oracle, Essbase, Teradata, DB2 and OLAP cubes development with Star Schema methodology with Fact tables and dimension tables using Data Integration Studio DI 4.2 and OLAP Cube Studio.

Environment: SAS 9.2 Enterprise Business intelligence EBI , SAS 9.1.3 BI suite, Enterprise Guide, Enterprise Miner, Data integration Studio DI 4.2, OLAP Cube studio 9.1, Cognos BI , Information Map studio, Management Console, SAS Access, SAS/SQL, SAS/AF, SAS/ETL , WEB Focus, Oracle, SQL Server, Teradata, SAP BW, DB2, Windows, UNIX, Mainframe, AS/400, WEB Focus. MS Excel, MS Excel Macros, SQL.

Confidential

SAS Adminsitrator

Roles Responsibility:

• Performed Installation, upgrade, migration and configuration of SAS EBI and their related components
• Such as SAS metadata, libraries, Web portals, OLAP cubes and SAS/AMO
• Responsible for Maintenance, technical support and troubleshooting of SAS EBI environments.
• Enacted performance tuning and capacity management
• Implemented hot fix and other day-to-day SAS BI administration tasks
• Worked with IT and business users to resolve support and technical issues
• Provided support to the business community.
• Contributed to coordination and planning of SAS BI related activities
• Wrote Unix Shell script for batch processing and other hot-fixes.
• Maintained the SAS performance in the UNIX-AIX servers.
• Performs platform capacity planning and management
• Provided 24x7 support

Environment: Windows XP, UNIX-AIX, SAS 9.1 EBI tools OLAP cube, Information Map Studio, AMO, LSF scheduler, EG, Management Console, Information Portals, Web report Studio, SAS Forecast server and Enterprise miner , SAS 9.2 EBI tools OLAP cube, Information Map Studio, AMO, LSF scheduler, EG, Management Console, Information Portals, Web report Studio, SAS Forecast server and Enterprise miner

Confidential

SAS Administrator/ Programmer

Responsibilities:

• Manage daily production and ensure the effective and timely resolutions of any problems including communicating the status to the customer community.
• Responsible for the administration of SAS web applications, SAS OLAP, Base SAS and SAS connect
• Recommend environment and configuration enhancements that improved SAS performance
• Administered SAS EDI, EM and Model manager.
• Provides hands-on SAS administrator training to two SAS programmers which will enable a seamless transition of responsibilities at the completion of the project.
• Maintained and monitored data loads into SAS within production environment and triaging issues.
• Provided technical support, help- desk support.
• Implemented back-up and recovery strategy.
• Checked production jobs, makes corrections and reruns.
• Performed testing of new SAS releases in test prior to migration to production.
• Created users and assign them role in the management console.
• Applied all the SAS patches and hot fixes available.
• Monitored SAS server and resources and ability to make adjustments to jobs when needed.
• Responsible for manipulating and analyzing clinical data, performing statistical analyses using SAS developing SAS macros to generate tables, listings and graphs and producing output files for use in reports or for use by physicians, statisticians and analytic staff.
• Designed and developed reusable SAS code to prepare data for analysis.
• Created and maintained SAS programs for data management and statistical analysis.
• Provided secondary review of others output, and created and maintained necessary documentation.
• Engaged in the development of SAS programs, macros and other techniques to improve efficiencies in reporting.
• Coordinated with team members to help meet timeline objectives.

Environment: SAS V8/V9 SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/MACROS, SAS/ODS , oracle, Mainframes, MS Excel, windows, LINUX.