We provide IT Staff Augmentation Services!

Sr.sas Programmer/ Analyst Resume Profile

Rolling Meadows, IL

Summary

  • 6 plus Years of Industry Experience in using SAS for Data Management and reporting in financial , logistic and medical domain.
  • Have implementation projects from Technical side and also have worked with the clients to gather requirements.
  • Strong Project coordination including strategic planning, trend analysis, forecasting, variance analysis, database management.
  • 100 Project completion on time while meeting strict timelines and budget requirements.
  • Core SAS Programmer with experience in SAS tools like Base/SAS, SAS/Macros, SAS/SQL, and SAS/ODS.
  • Extensive SAS programming experience in Design, Development, Implementations, Testing, Support, Maintenance Upgrade or Promote and Migration of SAS Application.
  • Exceptional ability in problem solving, data analysis, complex reports generation with macro and data transfer between different environments.
  • Expertise in transforming data imported from disparate data sources into analysis data structures, using SAS functions, options, ODS, array processing and storing and managing data in SAS data files.
  • Experience in Share point and Microsoft Office tools like MS Word, MS PowerPoint, and MS Excel etc.
  • Experience in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
  • Excellent problem solving skills for delivering useful and compact solutions.
  • Always keen and eager to face up to challenges by means of innovative ideas.
  • Motivate supportive, cooperative and a quick-learner. Strong communication skills and ability to work well in a team.
  • Quick learner with ability to understand job requirements employs new ideas, concepts, methods, and technologies.
  • Strong Knowledge on writing and modifying the SAS Macros.
  • Developing SQL queries to generate daily, weekly, monthly and quarterly reports and used SAS Macros to and system options to automate the process

TECHNICAL SKILLS:

  • SAS Tools: BASE/SAS v8.0 v9.1, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/AF, SAS/ACCESS, SAS/Connect, SAS/Enterprise Guide, SAS/ETL.
  • Programming Languages: SQL, PL/SQL.
  • RDBMS : Oracle , DB2,Teradata.
  • Operating Systems: Windows, UNIX, Mainframes.

Professional Experience:

Confidential

Role: Sr.SAS Programmer/ Analyst

Roles Responsibilities:

  • Supporting Marketing Campaigns for consumer cards and Small Business Services.
  • Customer Segmentation and Targeting likely responders for profitable campaigns
  • Slice/ Dice Complex data with SAS macro/ SQL and Advance Excel Techniques and develop Customer Statement for various LOB depicting overall performance of departments handling the respective projects.
  • Analyze Requirements, system development Testing for New Automation capabilities
  • Continuously looking for areas for improvement in existing system.
  • Mean and Standard deviation for all continuous variables using Proc Means.
  • Created data sets by using BASE SAS and SAS macro's in large SAS databases.
  • Data Collected using time study techniques for in-depth quantitative and qualitative analysis.
  • Fulfillment of production tables, export/ import survey data from vendor using SAS flat files.
  • Provided business logic by understanding the SAS program code and vice versa.
  • Performed data validation using SAS procedures to ensure data quality and consistency.
  • Maintained and enhanced existing SAS reporting programs.
  • Performed documentation of the SAS Code for the better understanding of the program.
  • Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Environment: SAS, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/ODS, Mainframes and Windows 2003/XP.

Confidential

Role: Sr.SAS Programmer/ Analyst

Roles Responsibilities:

  • Study of Client requirements and draft them into system specific requirements.
  • Worked closely with project managers, statisticians, database management personnel and other associated members of the team.
  • Responsible for data cleaning, data validation, identification and resolving any data inconsistencies and discrepancies to standardize the data.
  • Extracted data from different sources like Teradata, Excel and test files using SAS Access facility and SQL scripts Interface and Reports and providing the status to PM on weekly basis.
  • Reviewing the milestone dates with the client as when the UAT will be done.
  • Modified and developed SAS reporting programs for marketing campaigns to meet business requirements and created mail lists for direct mailing.
  • Developed SQL queries to generate daily, weekly, monthly and quarterly reports and used SAS Macros to and system options to automate the process
  • Creating programs implementing various logics involved behind data loading, client reporting, and data manipulations using SAS 9.0 programming language.
  • Planned, designed and developed test plans, scenarios and test cases, and ensured traceability between test cases and business requirements and technical specifications.
  • Continuously looking for areas for improvement in existing system.
  • Giving the Quality Sign off on the reports.
  • Reviewing analysis and test plan documentation for complex interfaces
  • Efficiently wrote SAS Macros and used company macros for daily programming

Environment: SAS, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/ODS, Oracle, Teradeta, UNIX, and Windows 2003/XP.

Confidential

Role: Data Analyst

Roles Responsibilities

  • Reviewed existing literature on Medicare, Medicaid and models dealing with Medicaid fraud
  • Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.
  • Modified existing SAS programs for facilitating migration from Mainframes to Oracle data engine.
  • Used SAS/ASSIST to extract data from SAS Files and Oracle Data base.
  • Involved in writing code using Base SAS SAS/Macros to clean and validate data from oracle tables and conducted data investigation
  • Involved in Data mining using Enterprise Miner for various health care datasets such as Eligibility, Inpatient, Outpatient, Long Term Care and Pharmacy Rx .
  • Involved in developing various fraud algorithms and validated existing algorithms against specification
  • Generated formats using PROC FORMAT for frequently used variables such as CPT Current procedural terminology , HCPC, DRG Diagnosis related group , Program type, type of claim, type of service, diagnosis code, Adjustment Indicator etc.
  • Used SAS import procedure to generate temporary and permanent SAS data sets from txt, csv and excel data sets.
  • Created various Graphs using SAS/GRAPH, SAS/GPLOT and SAS/INSIGHT.
  • Validating data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT etc. and SAS ODS facility.
  • Extensively used statistical procedures and predictive modeling techniques such as ANOVA, Regression Analysis, Trend Analysis, Cluster Analysis and Principle Component Analysis.
  • Conducted QA for macros generated by other programmers using Macro options MLOGIC, SYMBOLGEN, MPRINT, MACROGEN etc.
  • Performed documentation of the SAS Code for the better understanding of the program.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/ASSIST, SAS/STAT, SAS/GRAPH, SAS/IML, Enterprise Miner, ORACLE, Main Frames, Excel, Windows XP, UNIX.

Hire Now