Resume

Sign in

Data Sas

Location:
Hyderabad, Telangana, India
Posted:
January 20, 2017

Contact this candidate

AKHIL KUMAR

acydvx@r.postjobfree.com 703-***-****

PROFILE OVERVIEW

Around 8+ years of extensive experience in SAS Programming with strong emphasis on analysis, development, design, testing and implementation of various projects.

Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ ACCESS, and SAS/CONNECT in UNIX and Windows environments

Significant experience in requirement gathering, building, designing and testing the application to meet the functional Design and Business Process Design

Validated the SDTM/Adam standard datasets using OPEN CDISC Validation Tool to ensure the naming convention, format, controlled terminologies and values are consistent with the Implementation Guide

Strong experience with databases like Oracle, SQL Server, DB2 and MS Access

Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process

Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing

Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio

Strong ability to write SQL queries using PROC SQL

Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database

Experience in loading SAS Metadata Server with metadata from external packages for ETL development

Firm understanding of PROC OLAP and PROC INFOMAP to deliver solutions meeting complex business needs

Proficient with all basic and advanced SAS packages, procedures, data steps, basic/advanced macros, SAS stored processes, SAS BI tools, Proc SQL and SAS Visual Analytics dashboard building

Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, clustering etc. to gain insight into the data

Customize the variables to user-defined formats using PROC FORMAT in printing reports

Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks

Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT

Scripted Dynamic Data Exchange (DDE) functionality within SAS to transition data to build custom Excel dashboards and wrote VBA programs to automate daily generation and reporting updates

Hands on experience in SAS programming for extracting data from Flat files, Excel spread sheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility

Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis

Hands on experience working with SAS Enterprise Guide,Information Map Studio, Data Integration Studio and Web Report Studio

Extracting, transforming and loading data into data warehouse using SAS DI Studio for further analysis and reporting

Using SAS Stored Process Created Selection Screens and Dash Boards

Tableau Experience in enterprise environment including report / dashboard design, development, maintenance and support using various versions (9.x/8.x/7.x) of Tableau Desktop and Tableau Server.

Created complex web reports from SAS data and information maps using SAS WEB REPORT STUDIO

Performed data extraction, analysis and published results using SAS ENTERPRISE GUIDE

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/EG, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS V8, V9

Operating Systems: Windows 2000, XP, Windows NT, Unix/Linux (Red Hat), VM Ware, Unix Scripts

Programming Language: C,C++, SQL, SAS

Mainframe Skills: COBOL, SAS, ASSEMBLER, DB2, SQL

RDBMS: MS-SQL Server 2000/2005/2008, Sybase, DB2 MS Access.

Tools: MS Office,Microsoft Visio, Rational Rose, Quality Center, FTP Tool, Tableau

Concepts: SDLC, Object Oriented Analysis and Design, Unified Modeling Language (UML), Assembly and System Level Testing, exposure in Agile.

WORK EXPERIENCE

Sr.SAS Programmer

State Street, Boston, MA May 2015 to Tilldate

This project involved working with business analysts in obtaining the business rules and thereby creating and modifying customer lists based on different parameters such as address, loan amounts and customer loyalty. Generating reports for business users was one of the main responsibilities.

Responsibilities:

Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS

Using SAS Enterprise Guide build advanced querying, calculating computed columns, using filter, sorting, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generates summarization SAS datasets

Imported summarization SAS datasets from SAS Management Console to SAS Information Map Studio

Using Information Map Studio to build information maps structures

View Information maps from Web Report Studio or Information delivery portal

Using SAS Stored Process Web application to build Selection Screens and Dash Boards

Olap Cube Studio to build Olap cubes

Strong experience in using proc Sql method to pull data from different data bases like Oracle, Sql, and Teradata

Solid foundation in use of SAS macro, SAS/Connect, SAS/Access, SQL, Oracle, Teradata relational table structures and FTP interfaces between platforms and the UNIX environment

Experience in converting programs from one version of SAS to another version (Process of moving from SAS Version 8 to SAS Version 9)

Experiences using SAS Version 9 (especially the Business Intelligence Platform tools) SAS Enterprise Guide 4.0, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1, SAS Web OLAP Viewerfor Java, SAS Enterprise BI Server, Tomcat/ Apache

Ability to mentor or transfer skills to others

Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data

Reviewing business requirements for standard reporting

Identify AML current and potential risk, work with other departments to design new features and training programs in order to effectively mitigate risks

Using SAS Business Intelligence (BI) to drive the automation of standardized analytics

Generating SAS EG stored processes for product-specific analyses

Participating in the development of outcomes and process measures

Experienced in installing and configuring SAS Visual Analytics 7.1(including SAS LASR AnalyticServer).

Assisted in development of business plans to support the CCAR process and stress testing requirements while working with the business to assess and challenge the assumptions and forecasting approach

Identifying opportunities to productize standard reports

Advanced Querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generates SAS datasets

Imported SAS datasets from SAS Management Console to SAS Information Map Studio

Using Information Map Studio Stores instructions on how to access and combine relational data tables, calculating new data items, created multiple pre-defined filters

Build Quick Reports from Web Report Studio using Information maps, create filters, graphs, and customize reports

Using SAS Stored Process Created Selection Screens and Dash Boards

Decreased disk space by using SAS Visual Analytics results in minimizing the server cost

Builds Pivot tables from SAS Olap Cube Studio

All Reports Imported from web report studio, Stored Process and Information Map to Information Delivery Portal

Environment

SAS 9.1.3, SAS 9.2, SAS 9.3, SAS Enterprise Guide 4.0 & 4.2, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Visual Analytics, SAS Information Map Studio 3.1 & 4.2, SAS Information Delivery Portal, SAS OLAP CUBE Studio 9.1 & 9.2, Teradata, Oracle 8i, SQL, Linux RHEL 4, SASData Integration Studio 4.3, Windows.

SAS Programmer/ Analyst

Kinney Drugs, Gouverneur, NY June 2014 to May 2015

Kinney Drugs is a chain of over 110 drugstores and pharmacies throughout Central and Northern New York, as well as Vermont. Its headquarters is located in Gouverneur. The company was founded in 1903 by Burt Orrin Kinney, a native of Gouverneur.

Responsibilities:

Worked extensively on various SDTM domains such as Interventions - Exposure (EX), Comments (CM), Substance use (SU), Events - Adverse Events (AE), Medical History (MH), Disposition (DS), Clinical Events (CE), Protocol Deviation (DV), Findings - (EG), LB, IE and Vital signs (VS).

Independently develop and validate programs that generate SDTM datasets by using CDISC Standards.

Worked on Special Purpose Domains like Demographics (DM), Subject Elements (SE), Subject Visits (SV), Comments (CO) & their SUPPQUAL datasets.

Work on creating analysis datasets, defined variables of interest, study populations, visit window and baseline observations.

Generated Descriptive and Statistical summary outputs using Proc Means, Proc Freq, Proc Univariate and Proc Summary etc.

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

Generate safety (Adverse Events, Safety adverse events, Treatment emergent adverse events, Demographics, Vital Signs and Laboratory Findings) and efficacy tables using Proc Report.

Involved in the Production and QC of analysis plans, TLF mock-shell development, derived dataset specifications, programming specifications, and other process supporting documents.

Used regulatory requirements concerning industry technical standards (e.g., CDISC, 21 CFRPart 11, electronic submissions, etc.) and implications for the department.

Created complex and reusable Macros and extensively used existing macros and developed SASPrograms for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.

Assisted Bio-statistician in computing different statistics using p-values PROC TTEST, PROC FREQ (chi-square& fisher), PROC ANOVA, Proc Reg and PROC MIXED etc.

Generated RTF, HTML,Dashboards and PDF outputs for clinical study reports and integrated summaries for regulatory submissions.

Familiarly with ICH, GCP guidelines and Electronic Submission standards.

Used SAS/Graph procedures like Proc Gchart and Proc Gplot for graphical presentation of the statistical analysis.

Provide support to and mentor junior programmers and contractors.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/Assist, SAS/STAT, SAS ODS, SAS/GRAPH, SAS/IML, SAS V9.1.3/ 9.2, SAS Indexes, SAS Views, SAS MP-Connect, SAS Enterprise Guide, SAS Visual Analytics, Enterprise Miner, Excel, Tableau, Windows XP, UNIX.

SAS Analyst

Bharti Airtel – Mumbai, Maharashtra October 2011 to May2014

Bharti Airtel is an Indian global telecommunications services company based in New Delhi, India. It operates in 18 countries across South Asia, Africa, and the Channel Islands. Airtel provides GSM, 3G and 4G LTE mobile services, fixed line broadband and voice services depending upon the country of operation.

Responsibilities:

Processed data collection to ensure proper quality of data.

Maintained the daily error log for cleaning the data and report automation.

Developed SAS Macros for data cleaning, reporting and to support routine.

Prolifically generated SQL queries for the reports.

Implemented Predictive modeling and data mining techniques for retaining of customers.

Successfully identified problems with the data, produced derived data sets, tables, listings and figures, which analyzed the data to facilitate correction.

Presented numerical information in various formats. Created SAS Customized reports using the Data _null_ technique.

Analyzed and interpreted numerical data from various sources organized and summarized data for analysis.

Created reports using Enterprise Guide 4.3, PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.

Used SAS PROC SQL pass through facility to connect to DB2 and Teradata tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.

Environment: SAS 9.1.3, SAS Data Integration Studio 3.4, SAS/ACCESS, Enterprise Miner, Enterprise Guide 4.3, SAS/BASE, SAS/ MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/EG, DB2, BTEQ, Web Report Studio, Mainframe and UNIX.

SAS Programmer

Aditya Birla Financial Services – Mumbai, Maharashtra September 2009 – October 2011

The Aditya Birla Group is an Indian multinational conglomerate named after Aditya Vikram Birla, headquartered in the Aditya Birla Centre in Worli, Mumbai, India. It operates in 40 countries with more than 120,000 employees worldwide.Aditya Birla Financial Services Group (ABFSG) is the umbrella brand for all the financial services business of The Aditya Birla Group. ABFSG ranks among the top 5 fund managers in India (including LIC) with an AUM of US$23 billion.

Responsibilities:

Involved in the client interaction, requirements gathering, analysis and documentation

Participated in design discussions and prepared the required documents

Developed SAS programs with the use of Base SAS and SAS/Macros to implement new models

Enhanced and modified the existing SAS codes

Debugged Macro Errors

Analyzed large data sets consisting of millions of records

Imported data from different teams using NDM/FTP

Investigated data issues based on the defects and issues logged

Actively involved in all phases of the project life cycle. Involved in client interaction, requirements gathering, impact analysis, data quality analysis, estimating the required effort, design and hands on coding

Processed different kinds of inputs from the source files

Responsible for overseeing the design and development

Developed SAS programs using Base SAS and SAS/Macros

Extensively used SAS procedures like Print, Sort, SQL, Means, Summary, Freq etc. and extensively used DATA _NULL_ for reporting purposes

Moved data set across platforms (from PC to Mainframe and Vice Versa)

Generated reports in various client specified formats and provided documentation

Created output in CSV files and generated reports in excel spreadsheets

Imported data from different teams using NDM/FTP

Investigated data issues and improved the execution time

Implemented code review and unit test results review and code walkthrough process

Actively involved in conducting the system integration testing, regression testing, backend testing, user acceptance testing and end-to-end testing

Responsible for implementation planning for the production move

Helped prepare the test cases, test plans, and unit testing plans

Prepared release communications in a timely and effective manner to the appropriate audience

Extensive used the SAS functions such as DATE functions, NUMERIC functions, CHARACTER functions

Reviewed and streamlined outdated SAS code to eliminate errors and improve functionality

Optimized performance using Data Validation and Data Cleaning Statistical procedures like PROC FREQ, PROC MEANS, PROC FORMAT, PROC TRANSPOSE, PROC SUMMARY and PROC COMPARE

Served as a point of contact between the business users and technical members of the team

Environment: SASv9.1, Mainframes JCL, PL/SQL, COBOL, WinNT

SAS Developer

AXIS Bank - Bangalore, Karnataka June 2008 to September 2009

Axis bank, Bangalore, India is one of the nation's largest banking organizations, serving a broad range of consumer, commercial, corporate and institutional clients. The project involved fact based reports to immerge decision support process fast and reliable. The team was involved in extracting data from complex data warehouse and analyzed on forecasting and involved in summarizing and reporting it. Involved in implementation of required data, documents, and models to identify and solve problems required for decision process. It helped the decision makers for monitoring and analyzing the performance of the company financial loan data.

Responsibilities:

Interacted with business users and business analysts and prepared technical specs.

Extracted data from Oracle tables in UNIX. Extract huge volumes of data and uploaded into Oracle using SQL Loader

Created SAS datasets using Import Wizard and Proc SQL. Created user defined formats using Proc Format and Informants and data set was sorted using Proc Sort.

Extensively used SAS Macros, Proc Univariate, Proc Summary, Proc means, Automatic Variables and Proc options with LIST, OUT, MISSING options to perform various analysis.

Tracked campaign performance, performed market research and segmentation analysis using SAS, Excel to get the potential target customers and identify the market trend and opportunities

Interfaced with SAS/ACCESS to access, join, update, insert, and delete data from various tables.

Statistical analysis includes calculation of one-way and multi-way frequencies and table analysis using Proc Freq.

Develop, test, and maintain data and analytics needed for risk and finance models

Perform queries and used SAS/ODS to prepare reports using pre-existing templates directing SAS output to RTF, PDF and HTML to publish reports for business users group and load them in UNIX server.

Reports were created using Proc Tabulate, Proc Print, Proc Report and output the reports via ODS HTML to website and Proc Tabulate to create analysis tables.

Performed documentation of the SAS Code for the better understanding of the program.

Environment: SAS 8.x, (BASE, MACROS, CONNECT, SQL, GRAPH, ACCESS), SAS/ODS, Oracle, MS Excel, UNIX and Windows NT



Contact this candidate