Sr. Sas Bi Lead And Data Analyst resume example with 13+ years of experience
Jessica
Claire
resumesample@example.com
(555) 432-1000,
Montgomery Street, San Francisco, CA94105
:
Professional Summary
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.
Skills
Tools:
SAS Enterprise guide, SAS Information Map Studio, SAS Web Report studio, SAS Management Console, Teradata SQL Assistant, ENDEVOR, IBM Utilities, FILEAID, SPUFI
Databases:
SAS SPDS, Teradata, DB2, Oracle, SQL Server
Operating System:
UNIX, Mainframe, Windows XP, Windows Vista/7, Windows 10
Languages:
Base SAS9, Advanced SAS9, SAS V8, R (Basics), SQL, Teradata, Cobol, EAZYTRIEVE, JCL, SYNCSORT, HTML
MS Office Tools:
Excel, Word, Power point, Visio, OneNote
Education
, Expected in ā ā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. : - GPA:Completed course on R programming authorized by Johns Hopkins University.
*Completed 3 months course on Project management by Cognizant.
, Expected in ā āMaster:Business Administration - GPA:Business Administration
College of Engineering (Cochin University), KeralaExpected in ā āBachelors of Technology:Mechanical Engineering - GPA:Mechanical Engineering
Toc-H Public School Assisi Vidyanikethan Public SchoolKochi, KeralaExpected in ā āXII: - GPA:
Work History
Cognizant Technology Solutions - Sr. SAS BI Lead and Data Analyst San Bruno, CA, 2015 - Current
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.
Cognizant Technology Solutions - SAS Tech Lead and Data Analyst San Juan, PR, 09/2013 - 11/2014
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.
Bluecross Blueshield Of MN - SAS Tech Lead City, STATE, 2012 - 08/2013
Project Title BCBSMN - Claims Migration Duration Operating Systems OS 390, Windows, Unix Programming Languages Base SAS, Advanced SAS, Teradata, SQL ROLES AND RESPONSIBILITIES
Location - SAS Developer City, STATE, India2010 - 11/2011
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
Location - SAS Developer City, STATE, India10/2007 - 11/2009
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.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.
Resume Overview
School Attended
Sikkim Manipal University
College of Engineering (Cochin University)
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
SAS Developer
SAS Developer
Degrees
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.