Dynamic and Result-oriented SAS Programmer with extensive years of SAS programming experience covering all aspects of SAS processes - analysis, design, testing and validating, including advanced statistical methodologies applied in the Information and Healthcare industry. Rich background in creating SAS datasets, macro definitions, debugging programs, and documentation. Served as a primary SAS lead in integrating multiple applications, conducting GAP analysis, adapting to new systems and platforms and converting data from complex datawarehouse systems towards innovative solutions.
SAS Enterprise guide, SAS Information Map Studio, SAS Web Report studio, SAS Management Console, Teradata SQL Assistant, ENDEVOR, IBM Utilities, FILEAID, SPUFI
SAS SPDS, Teradata, DB2, Oracle, SQL Server
UNIX, Mainframe, Windows XP, Windows Vista/7, Windows 10
Base SAS9, Advanced SAS9, SAS V8, R (Basics), SQL, Teradata, Cobol, EAZYTRIEVE, JCL, SYNCSORT, HTML
MS Office Tools:
Excel, Word, Power point, Visio, OneNote
Sr. SAS BI Lead and Data Analyst, 01/2015 to Current Bluecross Blueshield of MN – Eagan, MN
Certified Advanced SAS9, Base SAS9 and SAS9 BI-Content Developer by SAS Institute with 8 years and 11 months of expertise in analysis, design, development, testing and validating SAS applications on UNIX, Mainframes and Windows platforms.
Possess extensive knowledge in enhancing, modifying, maintaining applications, data processing, data collection, data merging, data sub-setting, quantitative and qualitative data analysis using BASE SAS, Advanced SAS, BI SAS objects, SAS/STAT, SAS/CONNECT, SAS ODS, SAS/ACCESS and SAS/GRAPHS.
Optimize performance using data validation and data cleansing statistical procedures like PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC REPORT, PROC TABULATE and PROC SUMMARY.
Design macro programs and AUTOCALL macro library for ease of modification while maintaining consistency of results.
Demonstrate proficiency in accessing wide range of databases such as Teradata, SAS SPDS, Oracle, DB2 and SQL server.
Worked on SAS BI tools like SAS Enterprise Guide, SAS Information Map Studio, SAS Stored Process, SAS Web Report Studio, SAS Information Delivery Portal and SAS management Console.
SAS Tech Lead and Data Analyst, 10/2013 to 12/2014 Bluecross Blueshield of MN – Eagan, MN
Project Title BCBSMN Datawarehouse CRIB replacement Operating Systems OS 390, Windows, Unix, Mainframes Programming Languages and tools Base SAS, Advanced SAS, SQL, JCL, Cobol, DB2, Teradata.
Worked with business owners and functional departments to identify key data elements that was monitored on an on-going basis to ensure a high level of Data quality within the Warehouse.
Coordinated with the clients and business analysts regarding clarifications on the requirements.
Prepared the data mapping and developed scenarios to facilitate verification & validation of data migration from DB2 to Teradata data sources.
Analyzed the requirements and prepared the technical specification documents.
Designed the software solution in accordance with the requirement specifications by generating statistical reports using PROC FREQ and PROC MEANS.
Facilitated the development activity with the offshore developers.
Liaised between the offshore and client on the major deliverables developed in SAS Enterprise Guide and Mainframes.
Utilized SAS/ODS to create reports in PDF, RTF and HTML format.
Used PROC IMPORT to convert raw data files in different formats to SAS data sets.
Performed several statistical functions using SAS/STAT procedures and created One-way and Multi-way tables.
Utilized the FASTLOAD/MULTILOAD options to bulk load the SAS tabular data into Teradata tables for consumer claims report generation.
Harnessed SAS/CONNECT feature to transfer complex data between MVS Z/OS to UNIX using RLINK COMAMID=TCP REMOTE=NODE and PROC UPLOAD option.
Coordinated the quality assurance activity with the software testing team.
Implemented the solution in the live environment upon successful testing.
Performed validation and provided warranty support after the application went live.
SAS Tech Lead, 01/2012 to 09/2013 Bluecross Blueshield of MN – Eagan, MN
Project Title BCBSMN - Claims Migration Duration Operating Systems OS 390, Windows, Unix Programming Languages Base SAS, Advanced SAS, Teradata, SQL ROLES AND RESPONSIBILITIES
SAS Developer, 01/2010 to 12/2011 Location – Chennai, India
Project Title EDPR Trade Database Migration Duration Hardware IBM 3090 Operating Systems OS/390, MVS, MS - Windows Programming Languages VS COBOL II, SAS, EAZYTRIEVE, JCL ROLES AND RESPONSIBILITIES
SAS Developer, 11/2007 to 12/2009 Location – Chennai, India
Hardware IBM 3090 Operating Systems OS/390, MVS-ISPF, MS - Windows Programming Languages JCL, Base SAS, EAZYTRIEVE, HTML ROLES AND RESPONSIBILITIES
Designed, developed and maintained web-based applications written in [Name of Programming Language].
Developed front-end and back-end of web applications.
Made recommendations and developed technical design for new application features.
Oversaw implementation of application developments.
Identified and corrected performance issues.
Implemented pixel-perfect designs that exceeded user expectations.
Collected data around every transaction and turned it into tools that helped users.
Built and refined powerful machine learning models that automated decisions, prioritized work and changed the behavior of products in real time.
Advanced SAS 9 certification from SAS Institute. Base SAS 9 certification from SAS Institute. BI SAS 9 Content Developer certification from SAS Institute. Base SAS certification from Cognizant. Advanced SAS certification from Cognizant. DB2 Universal Database V8.1 Family certification from IBM. JCL Certification from Brainbench. Business Communication Certification from Brainbench. COBOL II Certification from Brainbench. VSAM Certification from Brainbench. : Completed course on R programming authorized by Johns Hopkins University.
*Completed 3 months course on Project management by Cognizant.
Master: Business Administration, Business Administration
DE: Project Management, Sikkim Manipal University - Sikkim Project Management
Bachelors of Technology: Mechanical Engineering, College of Engineering (Cochin University) - Kerala Mechanical Engineering
XII: Toc-H Public School Assisi Vidyanikethan Public School - Kochi, Kerala
Toc-H Public School Assisi Vidyanikethan Public School
Job Titles Held:
Sr. SAS BI Lead and Data Analyst
SAS Tech Lead and Data Analyst
SAS Tech Lead
Advanced SAS 9 certification from SAS Institute. Base SAS 9 certification from SAS Institute. BI SAS 9 Content Developer certification from SAS Institute. Base SAS certification from Cognizant. Advanced SAS certification from Cognizant. DB2 Universal Database V8.1 Family certification from IBM. JCL Certification from Brainbench. Business Communication Certification from Brainbench. COBOL II Certification from Brainbench. VSAM Certification from Brainbench. : Master : Business Administration , DE : Project Management , Bachelors of Technology : Mechanical Engineering , XII :
Create a job alert for [job role title] at [location].