PROFESSIONAL SUMMARY:

• 8 years of experience as aSASAdministration and developmentinSAS9.2,9.3 and SAS 9.4 on UNIX/Linux operating systems.
• Knowledge and experience in usingSASBusiness Intelligence tools such asSASEnterprise Guide 6.1 andSASEnterprise Miner.
• Extensive hands on experience onSASBI onSAS9.4, 9.3 & 9.2 administration, includingSAS Connect server,SASMetadata Server,SASManagement Console,SASOLAP Server,SASObject Spawner, OLAP Studio, Data Integration Studio, Web Report Studio and Enterprise Guide.
• Experience with SAS DDPO business tool, clients - Financial Management Studio, Data Integration Studio, Visual Analytics and other common SAS clients like SAS EG.
• Basic understanding of TABLEAU tool, experience using in Healthcare Industry.
• Worked with variousSASBI Tools Such as Enterprise Guide, OLAP Cube Studio, Information Map Studio, Information Delivery Portal, Web Report Studio, & Management Console
• Experience in Installation and configuringSASAccess interface drivers for DB2, Oracle and Teradata 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.
• 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 inSASData Integration (DI) studio, andSASBI suite.

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

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

PROFESSIONAL EXPERIENCE:

Confidential

SAS Consultant

Responsibilities:

• Solution architect for implementation of SASDDPO(Demand Planning, Consensus Planning, Inventory optimization)
• Change agent for introducing and adopting collaborative demand planning (CDP) process using SAS as technology platform.
• Strengthened collaboration between sales, marketing, product lines, and factories by actively conducting quarterly and monthly reviews for alignment on supply & demand plans
• Standardized planning process across North America by documenting the processes, creating standard operating procedures (sops)
• Client Installation Enterprise Guide, Enterprise Miner,SASManagement Console, Financial Management Studio, Data Integration in Windows 7
• Performed Data analysis, statistical analysis, generated reports, listings and graphs usingSASTools SAS/Base.
• Involved in creating and handling ETL jobs using client tools like SNOW and IBM Tivoli.
• Lead on-shore support team for SAS GRID Transition from client and provide further KT to offshore support team.
• Tested and administeredSASGRID, new tools and modules,GRIDconfiguration and Linux environment
• House Keeping activities for maintainingSASServers, Trouble shooting and Logging issues.
• Designed and developed routines, tools and usingSASEG/BaseSASto support ad hoc reports including automation in theSASWeb Report Studio

Environment: SAS9.4 & 9.3,SAS/Connect,SASMacros,SAS/Access, Perl, Windows, Linux, MS Office, HTML,SASEnterprise Guide,SAS FMS, SAS DI and Teradata

Confidential, MI

Sr. SAS Grid Admin

Responsibilities:

• SAS9.4 installation on Linux 64 Unixgridenvironment along with clustered Metadata.
• Administered differentSAS9.4GRIDenvironment and applications singSASManagement Console.
• Installed & ConfiguredSAS9.3Gridon the same hardware as a POC for upgrade project.
• Tested and administeredSASGRID, new tools and modules,GRIDconfiguration and Linux environment
• Performed Data analysis, statistical analysis, generated reports, listings and graphs usingSASTools SAS/Base,SAS/Macro andSAS/Graph,SAS/SQL,SAS/Access.
• Client Installation Enterprise Guide, Enterprise Miner,SASManagement Console, OLAP Cube Studio in Windows 7
• Successfully completed migration fromSAS9.3 EBI toSAS9.4 EBI.
• Responsible for maintenance and troubleshooting of theSASV9.1.3 & V9.2 environment
• InstalledSASAccess interface drivers for both SQL server and oracle
• Migrating Metadata fromSAS9.1.3 to 9.3
• Installation ofSASVA with common storage to avoid Data transfer.
• Installed & ConfiguredSASAccess to Netezza DB on all the SDLC Environments.
• Installed LSF/GridManager on the UNIX server & Platform Computing Client Software.
• Involved in creating ETL jobs inSASData Integration (DI) based on Technical Solution Document.
• Prepared shell scripts for starting and stoppingSASservices like Metadata server, Object Spawner, Connect server, Share server, etc. and also mid-tier services likeSASapplication service, Weblogic SASManaged server.
• House Keeping activities for maintainingSASServers, Trouble shooting and Logging issues.
• Installation ODBC drivers and creatingSASlibraries for DB2, Oracle, SQL Server & Green plum.
• Designed and developed routines, tools and usingSASEG/BaseSASto support ad hoc reports including automation in theSASWeb Report Studio
• Maintaining allSASconfiguration files, what they do, how are they related and how to modify in all 3 SASEBI environments.

Environment: SAS9.4 & 9.3,SAS/Connect,SASMacros,SAS/Access, Perl, OO Per, Oracle, ALM, Windows, PERL, SQL Server, Linux, MS Office, HTML,SASEnterprise Guide,SASStored Processes Web Application, SQL, HTML, JavaScript and Teradata

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.
• 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.

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)

Confidential, Phoenix, AZ

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, Medisoft, Eclinical Works, Python.

Confidential, MA

Sr. 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.

Confidential

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