PROFESSIONAL SUMMARY:

• Certified SAS Professional in Base SAS, SAS Platform Administration, SAS BI Content Developer and SAS Visual Analytics 7.3 Reporting and Design with 7 years of experience in various industries like Financial, Healthcare & clinical domains.
• Possessed sound knowledge in SAS Servers and Workstation’s Installations & Configurations of various SAS Products (SAS 9.1.3, 9.2, 9.3 and 9.4) in SAS EBI, EDI, Forecast, Enterprise Miner (EM) & Model Manager (MM), TM, Customer Intelligence (CI) in Single and Multi - Machine and Visual Analytics (VA 6.1 to 7.3) Distributed and Non-Distributed Architecture on Windows, UNIX and LINUX environments.
• Possessed sound knowledge on migration of data to grid environment using Copying, Promoting, Importing, Exporting, and Analyzing of Metadata. possessed sound knowledge on MIGRATION UTILITY using migration tools like IMPORT, EXPORT command
• Experienced in administering the SAS platform in single, multi-servers and in a multi-node grid environment.
• Experience and knowledge in using Base SAS, SAS Enterprise Guide, SAS Enterprise Miner, SAS stored process, SAS/MACROS, SAS/SQL SAS/ODS, SAS/GRAPH, SAS/STAT, SAS/ORACLE, SAS/CONNECT, SAS/ACCESS and SAS/SHARE. Deep knowledge in Data Warehousing concepts.
• Experience in administering SAS Grid environment using SAS Management Console and SAS LSF
• Worked closely with SAS Experts during SAS 9.4 installation and configuration.
• Familiar with FDA regulations, GMP, ICH, GCP and GLP, Knowledge of CDISC models like SDTM mapping and ADAM experience and managed SAS CDI. Hands on DAP
• Have Fine grip on PAM and LDAP servers.
• Worked on TERADATA and utility domains. Optimization of Queries in aTeradatadatabase environment.
• Specialized in analytics, data management for business functions like Market Risk, Credit Risk, Liquidity Risk, Basel III andCCAR.
• Identified and procured potential business opportunities aroundCCARby developing client relationships in the regional /international market while focusing on delivering state of the art solutions.
• Good understanding of the SAS Web tier and SAS Server Tier Architecture in GRID environment with excellent troubleshooting skills. Have Health Care Domain Knowledge.
• Experienced in Clinical Trials Data (phase I to IV) like Demographic data, Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), Physical and Vital Signs etc.
• Knowledge of CRT Dataset Creation from clinical trial data, CDISC and MedDRA for regulatory submissions.
• Experience in utilizing SASProcedures, Macros, and other SASapplication for data updates, data cleansing, reporting and knowledge in Claims Data Analysis.
• Expert level skills in SAS/BASE and advanced SAS, Experience in SAS/STAT procedures such as REG, GLM, ANOVA, MIXED, FREQ, MEANS, UNIVARIATE, LIFETEST etc.
• Hands on experience in performing client installations of various SAS products like SAS Enterprise Guide, SAS Enterprise Miner, SAS Add-in and SAS Model Manager on users’ machines.
• SAS EG 6.1 (Enterprise Guide) with Knowledge of BO And Architecting SAS environments
• Created Software Development Life Cycle (SDLC) document and excelled in the process of Change Management, Release management and Configuration processes.
• Strong knowledge on LINUX and SHELL Scripting, Worked as BASE SAS programmer.
• Hands on experience using BI tools like SAS Data Integration Studio and SAS Marketing Operations Management.
• Experience in managingHadoopclusters using Cloudera Manager Tool.
• Strong experience and knowledge in using clinical trial data like Demographic data, adverse event data, serious adverse event data, laboratory data and vital signs.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Data Analyst / Solutions Design Engineer

Responsibilities:

• Setting up SAS 9.4 (SAS Visual Analytics 7.3) Server in Windows environments.
• Taking care of regular maintenance of SAS Admin related activities and supporting to the team of 16 developers and 5 power users and 200+ business users.
• Troubleshooting the server and application issues and fixing it.
• Version upgrade from SAS Visual Analytics 6.4 to 7.3.
• Meetings with business users to understand the business requirements, disparate data sources (SQL Server and raw data files)
• Participation in business review meetings to gather requirements to design\generate reports and graphs.
• Creation of Hourly, Daily Weekly, Monthly, Bi-Monthly, Quarterly and Yearly reports to find out the issues generated by system from Logs, Alerts, Mails etc.
• Implemented Row-Level Permissions\Security for 200+ Users.
• Build and publish dashboards to analyze different service and products lines of the client.
• Working closely with the project development team and End-User community in coordinating with the bug fixes.
• Responsible for resolving all technical issues related to the SAS upgrade Migration.
• Helped in the preparation of CCAR reporting schedules (ex. FRY 14A/Q/M & 9C)
• Maintained a working knowledge of the Comprehensive Capital Analysis and Review "CCAR" and RWA, PPNR.
• Coordinated data set up in production for CCAR regulatory activities with RWA and PPAR.
• Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.
• Participated in data modeling, data analysis and requirement documentation.Extensive experience in Financial Service industry related t - Credit Risk, Market Risk, Market Risk, Credit Risk, Liquidity Risk, Basel II/III, CCAR.
• Responsible to perform migrating of metadata from SAS 9.2 to a SAS 9.4 GRID environment.
• Involved in promoting SAS/Access Interfaces to Oracle and SQL Servers
• 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
• 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
• Worked in Teradata environment and prepared datasets and libraries along with tables in it.
• Worked on LINUX and SHELL SCIPTING. Strong knowledge in Data Warehousing Concepts.
• Coordinating with the security team very often and providing servers for the MS patches and rebooting for the, scheduled time. worked on SPDS implementation/ support sidd lambda
• Experience in documenting data mapping from source to target.
• Worked during weekend maintenance activities orTeradatapatch update
• Responsible for monitoring CPU usage, Disk usage, and system resources.
• Hands on experience in scheduling software version upgrade task on client servers and license renewing.
• Interacting with different Support teams like UNIX Administration, Database Administration, Production Job Scheduling Team, Middleware Team and others to meet SAS Developer’s access and connectivity requirements.
• Closely worked with SAS Experts at the time of SAS Installation and configuration performed on the SAS Grid Servers. Worked on Data Warehousing for developing dash boards for BA

Environment: BASE SAS 9.4, SAS Enterprise Guide 6.1, SAS Management Console 9.4, SAS Enterprise Miner 13 SAS Model Manager 12.3, SAS Add - in Microsoft office and SAS DI Studio in WINDOWS 7, XP AND RHEL 6.4.

Confidential

STATISTICAL PROGRAMMER AND SAS GRID Content Administrator

Responsibilities:

• Experience in installing, configuring and administering any issues related to SAS Enterprise guide, SAS Enterprise miner, SAS DI studio and SAS Stored process.
• Experience working in the SAS GRID Environment. Ability to configure Queues/Policies in SAS GRID environment. Have hands on experience in SAS EBI like information map studio, web report studio, information delivery portal.
• Scheduled servers for the implementations and maintained servers with the client requirements.
• Performed tasks for software installations, windows security patch installations and license renewal on LINUX SERVERS. Worked on Data warehousing. Worked on Analysis, Development, Design, Testing and Reporting of ETL tools
• Troubleshooting SAS server issues such as system access and password problems, file system filled issues, enterprise guide or miner throwing errors to users, changing IP address of virtual machines etc.
• Experience in providing access to users to SAS and various SAS products for daily activities. Also provided access to the team and different work groups when needed and provided access to the agents for various roles and sub roles for performing their activity in marketing operations management.
• Updated CCAR model template related to Wholesale CRE Specialized Lending LOB
• Part of team responsible for the Management, execution and submission of CCAR reporting.
• Managed CCAR program deliverables documentation, maintained library of CCAR related documentation.
• Perform stop, start and status check of services asp.net and user feed services after installations.
• Strong understanding about how SAS interacts with third party software such as databases (DB2, SQL SERVER, ORACLE), web application servers, etc. strong knowledge on SAS HPA architecture
• Understanding of how to apply hot patches, service packs and do version upgrades.
• Worked as Server Type Owner (STO) for Linux and windows and driven process of ESR implementations by accessing ESMT and coordinating with TAEs and project team and fixing the dates.
• Monitoring and troubleshooting SAS servers and processes, including error messages by using system logs or server logs or setting logging options as well as options within SAS Management Console (SMC)
• Worked on security issues. Aware of checking logs and resolving issues.
• Dealt with storage issues in windows web server in production. Has capacity to preplan and be prepared with available space before any reports or backup is to be performed.
• Used SAS DI studio for data transformation and has ability to schedule and deploy code from SAS DI.
• Experience in developing service level agreements (SLAS) between the users to address the level of support.
• Improve performance metrics and availability of MOM tool by continuously checking splunk for any errors and resolving and logging and performance issue.
• Worked as Incident and Problem coordinator for short time in service team for incidents, requests and problem tickets raised by business partners and end users related to the marketing work bench, digital asset library, changes in the UI Frame work, process designer and schema designer in marketing operations management system.
• Hands on experience in using HPSM for working on incidents and opening problem records and known errors. Performed root cause analysis to provide solutions to the problems.
• Performed full functional checkout, business checkout and regression testing after releases, implementations and installations.
• Generated weekly and monthly status reports to the project and business team for existing problem records in HPSM and maintained documentation for all processes implemented.
• Extensively used SAS SQL to query and subset data, summarize and present data, combine tables using joins and merges and created and modified tables.
• Created Stored Process in SAS Enterprise Guide and executed stored process for the generation of reports.
• Conceptual understanding of designing and executing marketing campaigns with SAS CI Studio.
• Understanding of working of web applications (web report studio, information delivery portal, SAS BI dashboard) on the middle tier.
• Experience in working with client server (Windows and Linux) environments to perform activities after implementations like start, stop and checking status for metadata, object spawner, analytics platform, grid monitor service and process manager for SAS applications like SAS MA, MO &MOM.
• Experience in working with developers encountering issues while coding and testing existing programs using BASE SAS, SAS/MACRO, SAS/SQL SAS ENTERPRISE GUIDE.
• Assisted in configuring web report studio and defining and creating SAS information maps for authorized users.
• Have a working knowledge of relational databases that are being utilized

Environment: BASE SAS v 9.2 & 9.3, SAS Enterprise Guide, SAS DI Studio, SAS Management Console, SAS Enterprise Miner, SAS Web Report Studio, SAS Stored Process, SAS MA, MO & MOM in WINDOWS AND LINUX.

Astra Zeneca, BANGLOR E

Clinical Statistical Programmer

Responsibilities:

• Created and maintained SAS Datasets extracted from Database.
• Worked with different clinical trials data, Demographic, Adverse Event (AE), Serious Adverse Event (SAE), Laboratory, and Physical examination.
• Produced analysis datasets for generating Reports.
• Created Tables, Listings, Graphs and customized reports using various procedures PROC Report, PROC Tabulate, Data null and PROCGPLOT.
• Involved in creation of CRT datasets transport files and associating documentation as a part of FDA submissions
• Involved in writing the SAS code to help in the process of Quality control by implementing various statistical procedures PROCFREQ, PROCMEANS, PROCUNIVARIATE and PROCSUMMARY, PROC Transpose, PROC SQL and PROCPRINT.
• Wrote SQL Queries to debug duplicate values and missing values.
• Used the SAS Macro facility to modify existing departmental macros and to replace repetitive codes.
• Extensively used SET, MERGE, UPDATEstatements and PROC SQL for adding new variables or observations, creating subsets or modifying datasets.
• Produced quality customized and ad hoc reports by using PROC TABULATE, REPORT and SUMMARY and also provided descriptive statistics using PROC MEANS, FREQ.
• Produced RTF, PDF and HTML formatted files using SAS/ODS.
• Documented data sets using specifications worked out in conjunction with senior manager.
• As a clinical data associate performed UAT on EDC Software and reported the edit checks.
• Performed Quality Control, Data Validation and Edit Checks using various Procedures and Macro facility.
• Wrote SAS Programs for the edit checks that were detected manually.
• Participated in team meetings to discuss best programming practices. Established and maintained sound working relationship and effective communications within Biostatistics, Statistical Reporting, and the Data Management group.

Environment: SAS v9.1, SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/ACCESS.

Confidential

SAS EBI Developer

Responsibilities:

• Responsible the SAS EBI 9.1 & 9.2 platforms that run on Development, QA, and Prod environments including BI security and managing Read/Write privileges of users and supports 24/7, Responsible for production of Risk Model outputs as well as related reports during and after the production cycle.
• Developed and implemented real-time error-capturing code in SAS for production environment Displaying various reports and model results on SAS Web Report Studio via SAS stored process for diverse bank departments.
• Supported a total of 4 departments with 25 people for their needs in terms of data and/or reports.
• Develop and maintain documentation of the system configuration, procedures, and apply hotfixes and maintenance releases to SAS 9.1.3 & 9.2 as well as SPD Server & client SAS products
• Design and develop routines, tools and using SAS EG/Base SAS to support ad hoc reports including automation in the SAS Web Report Studio.
• Make the full implementation of Risk models into DEV, QA, & Prod environments and version them by using Version Control software, Configure and conduct performance-tuning of general SAS programs in SAS BI platform 9.1 & 9.2.
• Communicate and jointly work with IT departments, database administrators and business lines Create data schemas and data models to extract data from various databases across the organization, and Compare the SAS model logics for the business units and support them via Ad Hoc reporting based on their needs.
• Worked on advanced statistical methods of analysis and software packages like Base SAS, SAS/MACROS, SAS/STAT, SASEnterprise Guide and Miner in helping and solving different problems and ad-hoc requests in the Organization.
• Automated the process of reporting which indicated metrics on profitability of different customer groups, profitability of different using SAS/BASE, SAS/MACRO, SAS/STAT, and SAS/GRAPH.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT.
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/STAT, SAS/AF and SAS/GRAPH.
• Worked and interacted through the project with business team on Web Report Studio to develop business reports
• Used SAS DI Studio v 4.6 for data transformations and has ability to schedule and deploy code from SAS DI.
• Generated high quality reports in the form of listing, HTML, XML, RTF and PDF formats using SAS ODS.
• Extensively used SAS SQL to query and subset data, summarize and present data, combine tables using joins and merges and created and modified tables.
• Worked extensively with Data mining using enterprise miner.
• Created Stored Process in SAS Enterprise Guide and executed stored process for the generation of reports.
• Performed Data Cleaning for data attributes by backfilling the historical period data with current existing data.
• Achieved good experience working with massive databases (hundreds of terabytes) validating them with different statistical tests and also experience in marketing related modeling applications, database marketing, and predictive analytics

Environment: SAS/BASE v 9.0 & 9.1, SAS Enterprise Guide, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, MS WINDOWS 2000 and ORACLE.

Confidential

SAS Developer / Data Analyst

Responsibilities:

• Designing, implementing, and executing the change control and promotions tasks in SAS.
• Participated in generating tables, listings and figures to support submission to FDA.
• Strong understanding of CRT (Case Report Tabulation) data sets based on CDISC SDTM and ADAMS Submission Data Standards.
• Establishing best practices and guidelines for SAS BI usage
• Provide guidance and assistance to SAS Developers on operational and technical issues; interfacing with the SAS Institute for Support on administrative and system issues
• Creating and implementing upgrade plans
• Occasional after hour support when system OS and hardware maintenance and applying SAS hot fixes and upgrades occur.
• Strong knowledge of the operating systems that SAS is installed on, such as memory management, file system
• Architecture, CPU utilization etc.
• Conceptual understanding of SAS Customer Intelligence Studio, SAS Information Map Studio.
• Performed Data Validation and Data Cleaning using procedures like Proc Freq, Proc Means, and Proc Univariate.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools- SAS EG, SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Modifying, Debugging and Creating SAS Macro programs.
• Schedule periodic maintenance outages; e.g., combine patch application to minimize downtime
• Update the SAS standard referenced in the documentation section.
• Develop service level agreements between the users to address the level of support
• Host or participate in an internal SAS users group
• Do a dry run installation in the Research and Development environment first
• Review the organization's security model because this may prevent various components from working
• Successfully identified problems with the data, produced derived data sets, tables, listings and figures, which analyzed the data to facilitate correction.
• Performed survival analysis by using Proc Life test, generated Kaplan- Meier plots.

Environment: SAS/ BASE v 8.1 & 8.2, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, MS EXCEL Windows XP.