SAS,SQL,UNIX

Deepti Kushwaha

****.******@*****.***

Cell # 614-***-****

https://www.linkedin.com/in/deepti-kushwaha-954078bb

Professional Summary:

SAS Institute Certified Advance SAS® Programmer.

7+ years of professional experience in SAS Programming/Data Analysis with responsibilities in application design/development using SAS 9.1.3,9.2,9.3,9.4 in SAS GRID Environment.

Currently working on SAS 9.3 migration to SAS 9.4 from Solaris to Linux environment.

3 years of experience of SAS Grid Administration involving activities like applying patches, licenses renewal, metadata security,

user accesses, scheduling, LSF and SPDS Administration etc.

Experience in SAS/BASE, SAS/MACROS, SAS/ODS, SAS/REPORT, SAS/ACCESS, SAS/STAT, SAS /GRAPH, SAS/SQL, SAS /Hadoop.

Experience working in SAS Business Intelligence platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add-In and Web Report Studio.

Proficient in data manipulations, report/graph generations using the data steps with varies SAS functions, procedures, macros and ODS facilities.

Experience in SAS with Oracle, DB2, Hadoop, Teradata, Sql Server and SPDS using SAS/Access interface connectivity.

Experience in process automation, ETL, documentation, and quality control.

Extensive SAS Program development experience. Recent assignments involved data analysis, design, development, enhancement and support of huge SAS data marts (2PB)

Strong knowledge of Database query language SQL and Unix Shell scripting.

Strong exposure to Business and Data analysis, design and training of users. Ability to work independently and in a team environment and ability to absorb technical knowledge quickly.

Ability to build productive relationships with colleagues across all functional and technical disciplines, providing focused Business and Project Management, handling multiple projects at the same time.

Believe in continual improvement of processes and change management.

Worked on Onsite Offshore model for 3 years.

Professional Highlights:

Developed scripts and macros to migrate Indexes and Catalogs from Solaris (SAS 9.3) to Linux (SAS 9.4)

Designed,developed and deployed various reports like Storage Monitor, user monitoring, job submitted on Grid per month, Monthly Job Execution time which is shared with Higher Management for Capacity planning in VISA Inc.

Worked Extensively on SPDS Performance to reduce user job execution time in VISA Inc. Job that used to take days now execute in Hours.

Designed and Developed utility to find Defunct, Orphan jobs, non SAS Grid jobs that can be killed to keep SAS Grid functional and healthy in VISA Inc.

Certifications:

SAS 9 Certified (Base, Advanced).

Technical Skills:

SAS Software: SAS EG, SAS/Base, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/ODS

SAS/Grid Manager, SAS Grid Computing with LSF, SAS Stored Procedures, SAS Web Report Studio, SAS Management Console, SAS Information Studio, SAS DI Studio

Programming Languages: SAS 9.3 (AIX, Windows),SAS 9.4, SQL

Scripting Language: Shell, Bash,HQL

Office Tools: MS Office, MS PowerPoint.

Database: Oracle (8.1.7, 8i, 9i), DB2, SPDS 4.5.,SQL Server,Netezza.Teradata

Operating Systems: Windows 96/98/2000, XP, NT,VISTA, UNIX(AIX, Linux, Solaris)

BI Tools: SAS BI,Tableau.

Internet Technologies: HTML, XML

Professional Experience:

SAS Analyst /Administrator April 2016- Present

Blue Shield of California, SFO, CA

Consultant

Responsibilities:

Working as a SAS Administrator of SAS EBI platform for Solaris/SAS 9.3 migration to Linux/SAS 9.4.

Developed scripts and macros to migrate Indexes and Catalogs from Solaris (SAS 9.3) to Linux (SAS 9.4).

Created automated scripts for performance monitoring, storage monitoring, data usage of SAS processes and resources on Linux environment.

SAS/Access configuration to various databases and database platforms including Oracle, SQL server, Netezza.

Created training manuals and conducted training sessions for users about Solaris/SAS 9.3migration to Linux/SAS9.4

Modified and migrated existing production processes to significantly reduce processing time.

Developed AD group driven User on boarding and Metadata security.

Performed System testing/UAT on the new system.

Environment: SAS 9.3 (TS1M2), SunOS 5.10 (SUN 64), SAS 9.4 (TS1M3), Linux (LIN X64), Enterprise Guide 5.1/7.1,

SAS Information map studio 4.3/4.4, Oracle, SQL server, Netezza

SAS Analyst /Administrator Aug’2013-March'2016

VISA. Inc., Foster City, CA

Consultant

Responsibilities:

Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE for producing ad-hoc and customized reports.

Write Hive query to extract and summarize data in Hadoop.

Carried out data extraction, analysis and data manipulation using PROC SQL, PROC SORT, and PROC REPORT to create reports as per business requirements.

Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS/Base, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.

Created Stored Processes to publish reports on web report studio for the business users.

Effective operation of the Central Analytics Environment (CAE).

SPDS Administration and optimization.

LSF Administration like adding nodes and queues.

Worked on SPDS migration from SPDS 4.5 to 5.1.

Worked on modifying ACLs script for granting access on SPDS libraries.

Create Libraries, Users, Roles, and Groups at metadata using SAS Tools like Management Console. Adding, modifying and deleting SAS users and user privilege.

Defining user /groups /libraries in SPDS.

Worked on various Grid Maintenance for renewing Licenses, applying patches and Hot fixes.

Performs daily health checks of the Server, applications, scripts, and infrastructure and troubleshoot critical problems.

Taken part actively to develop POC for SAS9.3 to SAS9.4 migration project enabling SAS access to Hadoop ecosystem.

Worked on implementation of incremental SPDS data backups.

Automate/Schedule process using DI Studio/SAS Management Console.

Develop tools using SAS Code and Shell Script to monitor server performance and storage utility.

Developed utility to find defunct, orphan jobs on CAE SAS Grid.

Optimize existing SAS processes/Codes.

Work with Business Community (350+ users) to ensure most effective use of environment.

Involved in User Training.

Resolving Trouble Ticket/Change request logged by business user via remedy.

Environment: - SAS v9.2,v9.3 SAS/MACRO, SAS/SQL,,AIX 7.1, Windows XP, Enterprise Guide 5.1., UNIX Shell scripting, SPDS

5.1, DB2,Teradata, SAS Grid, LSF, SAS WRS, SAS Stored Process, SAS BI tools, Cloud era Hadoop H5.3.2,SAS

HPA,Tableau

Pharma Stats, Toronto Jan'2010- July'2013

SAS Programmer (Remote)

Project Objective was to deliver a generic, scalable, robust solution that enables creation and delivery of Datasets for Clinical trial study. The project is mainly involved in creating and developing Reports for clients. Patient data are collected from different clients and analyzed according to the client specifications.

Responsibilities:

Efficiently accessing /pulling data from multiple internal and external sources using different SAS techniques.

Developed data sets for analysis and documented programming specifications.

Cleaning, transforming, and auditing the data, organizing it in an optimized format to allow fast, easy access and to do analysis on it.

Created reports using PROC MEANS, SET, MERGE, FREQ and other different procedures as and when necessary.

Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, Formats, and Functions.

Generated statistical analysis files, summary tables, categorical tables, listings and graphs for Phases of clinical trial studies using various SAS modules.

Used SAS ODS facility to create HTML, RTF and PDF output files in the process of creating reports.

Data Extraction from the Oracle thru SAS/Access interface connectivity and Data Manipulation and generates the reports for further analysis.

Pull data for Statistical team for analysis.

Experienced in doing analysis according to Analysis Data Model (ADaM) and prepared the Study Data Tabulation Model (SDTM).

Extracted data from various databases using SQL pass through facility.

Creating technical and user documentation.

Created patient profiles for clinical personnel review.

Strictly followed the established Protocol, Case Report Form (CRF) and performed validation of data to identify illogical data entries.

Preparation of test cases & execution of Unit Testing and System Testing.

Environment: - SAS v9.2, BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ACCESS, SAS/STAT, SAS/GRAPH, Oracle, Sql Server

Information Technology Service, TISCO India Jan'2003– Feb ’2004.

Programmer/Analyst

Centralized Employees Personal Information System - Tata Steel is India's largest integrated private sector steel company. The objective of this project is to develop a centralized information system that deals recruitment, placement, performance, evaluation and career development of the firm's employees including their personnel record keeping to provide the required data to the management .I was responsible for programming and testing the system to meet the needs of client requirement and provide technology support. We had to generate a personal information system that collects, process, stores and distributes information of the firm’s employee who is distinguished by their personal number.

Human Resource Information Area (HRIA) - HRIA is a project containing various modules related to generate payroll of the TISCO employee’s running on the mainframe system in ITS, software division of TISCO .The projects also aims at providing the information to the business users and management based on their requirement .Objective of the project is to provide application maintenance, enhancement and support for the production system. This includes responding to the request that are raised by the HRIA operations group and also by the business users.

Screen Displays - To develop a screen displays of the existing modules which provides options DISPLAY, INSERT,

MODIFY, DELETE, REFRESH AND EXIT for the online transaction between application and users. It is an interface between the application program and the terminal so that user can directly insert a data, modify a data or delete a data from the database. Before that for retrieving any data or inserting any data or update any data in database one has to raise a SQL query in db2 but the CICS screen displays provide online transactions.

Responsibilities:

Involved in all phases of SDLC from requirement, design, development, testing and documentation.

Code changes according to the new requirement.

Capturing User Requirement to determine program specifications which include input and output layouts

Load and run the program in test environment to check for the functionality.

Collects data from all out locations from flat files generated from oracle system.

Developing code using COBOL, JCL and DB2 for inserting personal data of an employee, modifying a data, deleting employee’s personal record.

Developing physical map and symbolic map. Maps are coded using BMS assembler macros.

Developed a sample data to test the program and check for the functionality and fixing the code if the output is not correct.

Coding the program for transferring data to and from program which involves writing of standard COBOL Code with special CICS commands to invoke CICS services.

Involved in the analysis, design and development of the entire interface’s to develop online entry screen.

Added new tables in the existing database and fields in the existing tables.

Unit testing the different modules and creating samples data to check the output, fixing the code if the output is not correct.

Environment: -MAINFRAME, COBOL, DB2, JCL, CICS, Microsoft Word, Excel, Windows XP.

Education:

Masters in Computer Application from Uttar Pradesh Technical University in 2003, India.

Bachelor of Arts (Mathematics, Statistics) from Banaras Hindu University in 2000, India.

References:

Available on request.

Contact this candidate