SUMMARY

• 7+ years of experience as a SAS Administration and development in SAS9.2,9.3 and SAS 9.4 on UNIX/Linux operating systems.
• Knowledge and experience in using SAS Business Intelligence tools such as SAS Enterprise Guide 6.1 and SAS Enterprise Miner.
• Extensive hands on experience on SAS BI onSAS9.4, 9.3 & 9.2 administration, includingSAS Connect server,SASMetadata Server,SASManagement Console,SASOLAP Server,SASObject Spawner, OLAP Cube Studio, Data Integration Studio, Web Report Studio, Information Map Studio and Information Delivery Portal.
• Experience in Installation and configuringSASAccess interface drivers for DB2, Oracle, Teradata and MS SQL servers on a UNIX Environment.
• Installation of multipleSAS9.4 instances on grid and clustered environment with Load balancing optimization on Linux and Window environments.
• Extensive experience in Migration ofSASprior version (9.3 & 9.2) to new SAS 9.4 including Different OS.
• SASVisualanalyticsinstallation and data retrieval optimization from Greenplum toSASLASR Server.
• Implemented efficient data access between Big data andSASpart of Textanalytics.
• Implemented Clustered mid - tier using F5 load balancing forSASBI platform. Experienced in JBOSS andSASWeb Application Server (WAS) management.
• SASDevelopment experience using baseSASand DI studio along with Dataflux for data quality.
• Experience in BaseSAS9.4,SAS/Macros,SAS/SQL,SAS/Assist,SAS/Connect,SAS/STAT, SAS/Access,SAS/GRAPH,SAS/ETS,SASETL andSAS/ODS.
• Extraction and creation of data tables usingSAS/Access,SAS/SQL from large scale databases.
• Expert in using PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE, DATA MERGE, SORT to generate ad-hoc and customized reports.
• Hands on experience and thorough understanding ofSASEnterprise Business Intelligence toolset and its configuration on windows platform
• Expertise in SAS Data Integration (DI) studio, andSASBI suite.
• Experience in loadingSASMetadata Server with metadata from external packages for ETL development.
• Expertise in resolving issues withGridEnvironment,SASMetadata server, Object Spawner, SPDS, OLAP, Workspace server, Stored Process Server, Content server and Web application servers.

TECHNICAL SKILLS

Operating Systems: Windows 20 Server, Windows XP / 2000 Professional, Windows NT4 Server/Workstation, Windows / 98, Unix 11.x

SAS Tools: SASEnterprise Guide, PCSAS, UnixSAS, SASExpertiseSASv, 9.3SAS/BASE,SAS/MACROS,SAS/STAT,SAS/GRAPH, SAS/SQL, SAS/ETL,SAS/ACCESS,SAS/ODS, SASProcedure, SAS retail Forecasting

SAS Procedures: PRINT, TRANSPOSE, CONTENTS, MEANS, CHART, PLOT, TABULATE, SUMMARY, SORT, SQL, FORMAT, FREQ, UNIVARIATE, IMPORT, EXPORT & DATASETS

Databases: DB2, Netezza, Oracle, SQL Server, Informix, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SAS EBI Developer

Responsibilities:

• Migration fromSAS9.3 EBI toSAS9.4 EBI.
• Responsible forSAS9.2 EBI PlatformAdministratorwhich runs on 30 Linux hosts.
• Client Installation Enterprise Guide, Enterprise Miner,SASManagement Console, OLAP Cube Studio in Windows 7
• Involved in designing job flows usingSASData Integration to extract data from source systems, perform required transformations and load back to target.
• Creating metadata repositories for each department and Giving access rights.
• Backup and restore metadata, scripts to start and stopSASBI services, backing up WebDav.
• Provided technical support to end users onSAS,SASEnterprise Miner,SASEnterprise Guide,SAS Data Integration Studio andSASBI Suite.
• UpdatingSASlicenses, applyingSAShot fix patches on UNIX environment, fix existing bugs and to keep theSASBI Server environment up and running and bug free
• Involved in creating ETL jobs inSASData Integration (DI) based on Technical Solution Document
• Worked extensively in sorting, merging, concatenating and modifyingSASdata sets in different environments Windows and Unix.
• Responsible for Programming inSASusing BaseSAS, Macro Facility, Proc SQL,SASProcedures, SASFunctions,SASFormats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.
• Generated HTML, RTF, PDF and text reports using ODS statements and performed data analysis usingSASBase, TERADATA 12. And Microsoft Excel.
• Created automated FTP's, automated Email macros usingSASand UNIX to desktop for analysis.
• Helped various team members in setting upSASEnterprise Guide environment.
• Developed new Macros for report generation usingSAS/Macros as per the customer's requirements.
• Monitor environment for performance and proper operation.
• Job scheduling usingSASManagement console and monitoring jobs using Process flow manager and using commands on Unix.
• Extracted data from the database usingSAS/Access,SASSQL Procedures and createSASdata sets.
• Tracking applicableSAShot fixes and creating implementation plans for respectiveSASmodules and applications
• Installation of Confidential WebSphere & creating nodes, clusters, setting up IHS forSASInformation Delivery Portal

Environment: SASBase 9.4/9.3,SAS/Macros, Enterprise Guide,SAS/STAT,SAS/ODS,SAS/Access, SASData Integration Studio,SASManagement console,SASInformation Map Studio,SASWeb Report Studio,SASModel Manager, putty and Unix (Sun Solaris Unix environment), Unix Shell Scripting, Oracle 10g, Confidential Clearcase, and Clear Quest

Confidential

Sr. SAS Programmer

Responsibilities:

• Developed and automated aSASprogram to successfully extract, update data to database and send reports through Email because of data source changing.
• Convert data from EDI and RSP file to txt format and load data intoSASdata sets and find daily rejections then send Email with Macro.
• Used LSF Platform Suite built intoSASto complete the work flow automatically.
• Created complex and reusable Macros and extensively used existing macros and developedSAS Programs for Data Cleaning, Validation, Analysis and Report generation
• DevelopedSASMACRO codes for data manipulation, data analysis, statistical analysis and routine report generation.
• Created severalSASprograms in accordance with Standard Operating Procedures (SOP) and Statistical Analysis Plan (SAP).
• UsedSASMacros andSASSQL to query data and to obtain results which were generally stored as delimited text.
• Used differentSASprocedures in phase III trial including statistical analysis methods.
• Created Integrated Summary of Safety (ISS) and Integrated Summary of Efficacy (ISE) reports documenting experimental drugs, usingSAS.
• Created information maps and web reports usingSASWeb Report Studio.
• Extracted data from different sources like Oracle and text files usingSAS/Access,SASSQL procedures and createdSASdatasets.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques usingSAS/Base.
• Provided technical support onSASprogramming related to data manipulation and analysis.
• Wrote macros, developed conciseSASscripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops
• Created various transformation procedures by usingSASETL andSASEnterprise guide.
• SASProcedures used are Proc Append, Macros, Import and Export, Proc Transpose, Proc Datasets.
• UsedSASEnterprise Guide to access data, to manage data, to create reports and to validate data and data mining.

Environment: SASV9.3/9.4,SASEG,SASOLAP Cube Studio,SASWeb Report Studio, SAS/ ACCESS, SAS/ CONNECT, SAS/Macro,SAS/SQL,SAS/GRAPH,SAS/STAT, Excel, Access, Med iSOFT, Eclinical Works, Python.

Confidential

Sr. SAS Developer

Responsibilities:

• Involved in the complete development, testing and maintenance of the application.
• Performed statistical analysis, and generate reports, listings and graphs usingSAS/Base, SAS/Macros,SAS/Stat,SAS/Graph,SAS/SQL,SAS/ODS andSAS/Access
• Extensively used various BaseSASprocedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort for reporting purposes. UsedSASprocedures for Importing and Exporting data to MS-Excel
• Modified/developedSAScodes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiableSAScode usingSAS/ Base andSAS/ Macro facility.
• IntegratedSASdatasets into Excel using Direct Data Exchange, usingSASto analyze data, statistical tables, listings and graphs for reports.
• UsedSAS/ ODS to format HTML and RTF reports.
• SASmacros for data cleaning, reporting and to support routing processing.
• Created and maintained ad hocSASprograms/Macros for the validation, Extraction, Presentation, manipulation, analysis, and reporting.
• Optimized existing code for efficiency and automation ofSASPrograms to improve reporting efficiency.
• Report generation using manySASprocedural statements,SAS/MACROS, and data null steps.
• SASwas used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analysis.

Environment: BaseSAS, MacroSAS,SAS/Graph,SAS/Stat,SAS/SQL,SAS/Access,SAS/EG, SAS/Connect,SAS/ODS UNIX (VI Editor, Shell Scripts), Microsoft Excel, Oracle

Confidential

SAS Developer

Responsibilities:

• Performed Data management, manipulation usingSASTools - SAS/Base,SAS/Macros and SAS/SQL
• Developed predictive models and conducted statistical analysis usingSAS. Applied Proc Means, Proc Freq, logistics, summary, transpose, univariate and compare.
• Performed data preparation and transformation usingSASprocedures to ensure data quality
• Used SASand SQL to perform ETL from Oracle and Teradata databases and createdSASdatasets,SAS macros, Proc/data steps andSASformats as required.
• Worked on existingSAS/Macros for data validation by checking data distribution & comparing to standard data. DevelopedSASprograms for several verticals including risk & marketing teams.
• Data processing and validations extensively on theSASdatasets using edit check programs.
• Dealing datasets using SQL joins and unions for the scenarios raised with the project.
• Finding the duplicate records from the large volumes of data using 'Distinct' keyword and assigning indexes for the Key variables using SQL.
• Collaborate with multiple users in the company forSASprogramming documentation.
• Developed reports as per business requirements and created various reports like summary reports, tabular reports, excel reports etc.
• Converted programs from Teradata SQL toSASto automate the monthly production processes.
• Developed new/modified macros for report generation usingSAS/Macros as per business requirements.
• Responsible for the annotation of Case Report Forms(CRFs)tasks assigned bySASmanagement
• Used BaseSASprocedures such as, Proc Report andSAS/Graph for designing statistical summary tables and graphs
• Involved in multiple projects and interacted with otherSASProgrammers, Statisticians and data managers to analyze data
• Formatted HTML, XML, ASCII, CSV, EXCEL, PDF and RTF reports, usingSAS- Output Delivery System (ODS)

Environment: SAS9.1.3,SASAdd-in Microsoft office, WindowsSAS, UNIX, MS SQL, SAS/ACCESS, TERADATA.