We provide IT Staff Augmentation Services!

Sas Programmer / Bi Developer Resume

2.00/5 (Submit Your Rating)

Washington, DC

SUMMARY:

  • SAS Institute Certified BASE SAS Programmer with 14 years of experience in analysis, design, development, testing and documenting of various projects for Government agencies and Private sectors.
  • Extensive experience in BASE SAS, SAS Enterprise Guide, Data step programming, SAS MACROS, SAS/STAT, SAS/SQL, SAS/ODS.
  • Extensively used various SAS procedures, functions, options, SAS Macros and Proc SQL as part of programming.
  • Extensive experience with SAS BI Tools like SAS Enterprise Guide, SAS DI Studio, SAS Web Report Studio, and SAS OLAP cube Studio, SAS Information Map Studio, Dashboard, SAS Information Delivery portal, SAS Management Console.
  • Experience in writing in SQLs to extract/manipulate data on RDBMS databases.
  • Involved in extraction, transformation and loading data using SAS DI Studio.
  • Experience in creating stored processes using SAS Enterprise Guide.
  • Created various Information maps, OLAP cubes, Web reports, Dashboards.
  • Experience in error handling and validation of reports especially during ETL process.
  • Updated and documented programs according to requirements using SAS Enterprise Guide.
  • Experience in SAS on UNIX and Windows.
  • Delivered several deliverables in time.
  • Significantly contributed for receiving ‘Excellent’ ratings and grades during CPAR evaluations.
  • Quick learner, highly organized, dedicated with positive attitude, self - motivated and committed in individual and in teamwork.
  • Strong analytical, communication, interpersonal & organizational skills.

TECHNICAL SKILLS:

SAS Skills: SAS V9, SAS/BASE, SAS/STAT, SAS/MACROS, SAS/ACCESS, SAS/GRAPH, SAS/SQL,SAS/ODS, Proc Report, Proc Print, Proc tabulate, Proc Means, Proc Summary, ProcFreq, Proc Uni-Variate, Proc contents, Proc Summary, Proc SQL

Databases: Microsoft SQL Server, Oracle and Teradata

Reporting Tools: SAS

Business Intelligence: SAS Enterprise BI Platform 9.3, DI studio, OLAP Cube studio, EnterpriseGuide

Operating System: UNIX, Windows

Other: MS-Office (MS-Excel, MS-Access, MS-PowerPoint, MS-Word and MS-Outlook), MS SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

SAS Programmer / BI Developer

Job Responsibilities:

  • Written guidelines to organize the SAS folders and contents and also suggested naming convention for SAS folders and SAS programs, Datasets, Logs, Outputs and Reports.
  • Validated the TAGR tool for the functionality and accuracy every time when it was modified.
  • Loaded grants data from excel files into TAGR tool.
  • Updated TAGR Requirements breakout/release contents document.
  • Validated Missing Audit datasets and found some discrepancies and helped in fixing those issues.
  • Reviewed Entity Risk Review SAS Programs to make those programs more efficient and more readable.
  • Organized the folders and contents on SharePoint according to user’s requests.
  • Interaction with users on daily basis and as needed.
  • Assisted in creating Detail Data requirements.
  • Created Data dictionary, Logical and Physical Data models.
Confidential, Arlington, VA

SAS Programmer/BI

Job Responsibilities:

  • Currently working on HUD BSP contract.
  • Updated existing SAS Web Report Studio and HTML reports according to requirements using Web Report Studio and SAS Enterprise Guide.
  • Created technical specifications, several new Web reports like Key Metrics, Loss Mitigation and Foreclosure with Workout Ratio, Active cases by month and Default Data reports etc. from SAS Web Report Studio by utilizing SAS datasets, OLAP cubes and information maps.
  • Written stored processes to create various HTML reports like SFDMS reporting and Active loans report, overall state tracking and overall MSA tracking reports etc.
  • Created new OLAP cubes and modified existing cubes with new measures and new dimensions using SAS Enterprise Guide and SAS OLAP cube Studio.
  • Created various ETL jobs using transformations using SAS DI Studio.
  • Written programs for several new assignments and requirements like HOC Dashboard, TRS II reports, incorporating new default status codes and Default Data cube etc. by going through provided Business Rules.
  • Updated and documented programs according to requirements using SAS Enterprise Guide.
  • Created Information maps with descriptive labels and with derived measures using SAS Information Map Studio.
  • Created stored processes using SAS Enterprise Guide and reports and Dashboards for posting on to SAS Information Delivery portal.
  • Delivered several deliverables in time.
  • Experience with all SAS BI Tools like SAS Enterprise Guide, SAS Web Report Studio, SAS OLAP cube Studio, SAS Information Map Studio, Dashboard, SAS Information Delivery portal, SAS Management Console.
  • Knowledge in setting up User accounts and User groups using SAS Management Console.
  • Ability to understand quickly about user’s requests and knowledge in all the programs and system that helps to respond quickly to user’s requests.
  • Used SAS data loader for Hadoop
  • Extensive experience in error handling and validation of reports especially during ETL process.
  • Extensively used various SAS procedures, functions, options, SAS Macros and Proc SQL as part of programming.
  • Very good knowledge in Single Family Housing Data like Defaults, Foreclosures, Foreclosure Conveyance, Insurance in Force, Loss mitigation, partial claim etc.
  • Made programs efficient by reducing processing/extracting time and effort.
  • Written Job flows so that bunch of programs can be executed by executing a Job flow.
  • Undergone training in System Administration and OLAP Administration.
  • Significantly contributed for receiving ‘Excellent’ ratings and Grades during CPAR evaluations.
Confidential, Columbia, MD

SAS Programmer/Report Developer

Job Responsibilities:

  • Worked on DECC Contract.
  • Created various claims based management reports on quarterly, half yearly and yearly basis, and also created ad-hoc reports.
  • Analyzed and developed SAS programs, created technical specifications, documented programs, unit test cases, scripts and performed unit testing on those to fix program issues, errors, performance issues and delivered those in time.
  • Written SQL queries for SAS/Measures Engine comparisons and validations.
  • Knowledge in PQRS (Physician Quality Reporting System) measures, numerator and denominator.
  • Experience knowledge in healthcare terminology like Eligible Professionals, ICD-9, ICD-10, CPT-I, CPT-II, HCPCS codes.
  • Worked on ERx (Electronic Prescription) measure, created a report of NPIs who are not eligible to receive incentive bonus and a report of NPIs who are eligible for Payment Adjustment (Penalty).
  • Involved in the ERx content validation and produced the correct results those matched exactly with the other vendor's results.
  • Edited the existing programs according to the business requirements provided.
  • Created SAS datasets by Importing the excel data files and extracting data from Oracle DB and used those SAS datasets as source data.
  • Written Job execution plan and deployment plan.
  • Understood and strictly followed the client policies, procedures and guidelines.
  • Created derived datasets from raw datasets using Set, Merge, Sort, Update, Formats, Functions and conditional statements.
  • Successfully Generated Reports, Graphs using various procedures like Proc Freq, Proc Report, Proc SQL, Proc Tabulate, Proc Univariate and Proc GPLOT.
  • Undergone CMS (Centers for Medicare and Medicaid Services) Security Training and followed CMS policies and regulations at all times.
  • Extensively dealt with Proc Report, Sort, Contents, Freq, Univariate, Means, SQL and also used Proc compare, append, copy along with some SAS/STAT procedures.
Confidential, Deerfield, IL

SAS Programmer/Report Developer

Job Responsibilities:

  • Generated reports, listings and graphs using SAS Tools that include SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, and SAS/Access from derived datasets.
  • Worked on a PHASE II safety/efficacy study, strictly followed Company’s SOPs, Protocol, the Statistical Analysis Plan and other specifications in analysis and programming.
  • Created raw data sets, reports by extracting data from oracle database tables using SQL Pass through Facility.
  • Developed the program specifications, documented the programs and created testing and validation documents.
  • Extensively involved in Clinical Data Management by performing edit checks.
  • Extensively worked with fellow technical staff validate the reports, programs and provide suggestions to enhance the reports and to fix the report issues.
  • Performed validation of SAS programs by writing independent code using Proc SQL, by printing intermediate datasets, by physical verification or by checking title and footnote statements as per the protocol guidelines.
  • Dealt with different raw data sets including CONS, LABS, VITALS, ECG in phase II and phase III trials and created structured data sets by calculating variables like age and duration from the existing variables.
  • Extensively used SAS Macro Facility to create codes for reusable programs that were used from time to time, used debugging macros and automatic macro variables
  • Produced customized listings and summary reports using various procedures and formatted HTML and RTF reports using SAS/ODS (output delivery system).
  • Performed program documentation on all programs, files and variables for accurate historical record and the final reports were converted to word format for clinical review.
  • Extensively dealt with Proc Report, Sort, Contents, Freq, Univariate, Means, SQL and also used Proc compare, append, copy along with some SAS/STAT procedures.
Confidential, Deerfield, IL

SAS Programmer/Analyst

Job Responsibilities:

  • Analyzed the Clinical data of Phase II and Phase III.
  • Created analysis datasets from raw datasets using Set, Merge, Sort, Update, Formats, Functions and conditional statements.
  • Successfully Generated Reports, Tables, Listings, Graphs using various procedures like Proc Freq, Proc Report, Proc Tabulate, Proc Univariate, Data null, and Proc Gplot.
  • Experienced in validation of Tables, Listings, Graphs and Analysis Datasets using Proc compare and departmental standard macros.
  • Extracted, validated and generated SAS data sets from Oracle applied ‘SQL Pass through Facility’.
  • Produced Tables, Listings and Graphs for Integrated Summaries of Efficacy (ISE) and Safety (ISS).
  • Performed data management functions including manipulation, validation, review and export to database.
  • Participated in Clinical Data Management by performing edit checks.
  • Used several company macros to avoid repetitive codes and also modified them.
  • Used SAS ODS for generating reports in specific output formats like RTF, PDF and HTML etc.
  • Generated ad-hoc reports as necessary for studying specific trend/ causal effects.
  • Documented and Annotated CRFs according to the protocol along with the Statistician.
  • Involved in preparation of ODS extraction, data mapping, data cleaning, preparation of data extraction and transformation.
  • Prepared clinical data listings and summaries for statistical analysis and analyzed clinical data using SAS system.
  • Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
  • Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphics, and statistical analyses.
  • Supported the research staff for technical and programming help. Worked with Bio statistician to analyze the results obtained from various statistical procedures like PROC ANOVA, GLM.
  • Produced quality customized reports by using PROC TABULATE, REPORT and SUMMARY, Also provided descriptive statistics using PROC Means, Frequency, and Univariate.
Confidential

SAS Programmer/Report Developer

Responsibilities:

  • Generated reports using SAS.
  • Analyzed and documented the reporting requirements and reporting technical specifications.
  • Modified the existing SASreports as per new requirements and to improve performance.
  • Extensively involved with the users in testing the reports.
  • Trained the users in using the built reports.
Confidential

Jr. Programmer / Support

Responsibilities:

  • Created technical specifications to modify existing programs to meet the modification requests and documented accordingly.
  • Analyzed reports and documented.
  • Provided support for existing programs after go live.
  • Involved in unit testing and created testing documents.

We'd love your feedback!