We provide IT Staff Augmentation Services!

Sas Programmer Resume

0/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • Over 7 years of extensive experience in SAS performing advanced programming and BI Development including data extraction and manipulation, writing macros and reporting, with major financial institutions.
  • Extensive experience as a SAS programmer with SAS/BASE, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/ETL, SAS ODS & Enterprise Guide (EG)
  • Extensive experience in using SAS Enterprise Guide in developing stored processes and performing statistical analysis.
  • Strong knowledge of testing methodologies at all stages of Software Development Life Cycle (SDLC)
  • Experienced in preparation of SAS datasets, Tables, Listings, Graphs, Reports, and summaries according to requirements and Standard Operating Procedures (SOPs)
  • Experienced in building OLAP cubes, web reports, dashboards and Portlets using SAS BI tools.
  • Expert level skills in SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/SQL and MACRO.
  • Experienced in utilizing SAS Procedures, Macros and other SAS applications for data updates, data cleansing and reporting.
  • Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks.
  • Experience in using SAS to read, import, and export to other data file formats, including delimited files
  • Experience in generation of various periodic and ad - hoc reports for various analyses
  • Thorough knowledge in SAS Programming, merging SAS Data Sets, Reading Flat File into SAS, SAS Functions, Preparing Data to generate Reports using PROC REPORT and PROC TABULATE
  • Extensive experience working with different databases including Oracle, Teradata, DB2 and MS SQL Server. Highly motivated, Organized Team player with excellent analytical and communication skills.

TECHNICAL SKILLS

SAS Skills: SAS/BASE, SAS/GRAPH, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/ CONNECT

Database: Oracle/8x/9x/10g, Sybase, Teradata, MS-Access, MS SQL Server, DB2 and Netezza

Languages: SQL, PL/SQL, Shell Scripting, Tools SAS Enterprise Guide, Web Report Studio, Information Map Studio, OLAP Cube Studio, SAS Management Console, Information Delivery Portal, SAS Add-In for MS Office, JMP, Tableau

Operating: Windows (XP/7) and UNIX

Others: MS Office, MS Project, Power Point, Excel, Outlook and Access

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

SAS Programmer

Responsibilities:

  • Developed SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs. Modified the existing programs according to the new business rules.
  • Work cross functionally with all departments of the service center to solve purchase order, invoice and inventory discrepancies (supply chain Management)
  • Apply Forecasting and Analytical Methodologies, and contribute to its ongoing continuous improvement.
  • Participate in application design and architecture discussions and assess the impact and applicability of forecasting to client's business problem solutions.
  • Complete all levels of application testing and Q&A, and prepare all required documentation;
  • Extensively used SAS procedures like Print, Sort, SQL, Means, Summary, Freq etc.
  • Ran the monthly and quarterly maintenance jobs on the mainframe.
  • Worked within the SAS BI Enterprise utilizing an Oracle database and Windows server environment
  • Documented the run instructions for two different processes in a project.
  • Participated in designing, coding, testing, debugging and documenting SAS Programs
  • Created RTF, PDF, HTML, LISTING, etc. using Output Delivery System (ODS)
  • Extensively used various SAS Data Step functions, SAS procedures, and SQL to write reports logics for SAS Stored Processes
  • Converting existing Cognos reports to SAS web reports by creating SAS Information Maps and using those maps for creating SAS web reports using SAS Web Report Studio.
  • Created SAS Customized Reports using the Data Null technique for FDA evaluations.
  • Developed routine SAS macros to create tables, graphs and listings for inclusion in Clinical study reports and regulatory submissions and maintained existing ones.
  • Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
  • Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining. Validated programs and databases.
  • Created SAS programs using Proc Report, Proc Summary to generate reports on patients who deviate from protocol specifications.
  • Served close with the statistician and make sure everything is in right place.
  • Used various ODS outputs depending on the client requirements and provided with a fine framework for FDA submission

Environment: Base SAS, SAS MACRO, SAS Enterprise Guide, UNIX, SAS GRID, Visual Analytics SAS/SQL, SAS/STAT, SAS/GRAPH, and Windows

Confidential - Charlotte, NC

SAS Programmer

Responsibilities:

  • Developed complex SAS macros to simplify SAS code and effectively reduce coding time
  • Interacted with Risk Managers and Analysts to define targeted customer segments
  • Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
  • Extract, transform and load datasets with basic modeling variables for each segment type Using PROC IMPORT and SQL queries, imported data from Oracle database into SAS files
  • Manipulated and updated the tables as per specifications
  • Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and macros in SAS
  • Formulated action plans and presented key information regarding profit dynamics to the senior management in the Bank
  • Maintained consistency of SAS variables formats and sorted various datasets using PROC SORT and merged them using MERGE
  • Maintain and enhance existing SAS reporting programs for marketing campaigns.
  • Produce SAS Graphical reports showing Trend Analysis charts for campaign
  • Worked on CONVERSION of SAS code originally in ORACLE to TERADATA compatible SAS code.
  • Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning.
  • Prepared ad-hoc reports, documenting SAS work, and directing SAS outputs to RTF and HTML files through SAS ODS facility
  • Developed loss prediction model using Enterprise miner modeling solutions and SAS procedures.
  • Used PROC/SQL and SQL -pass-through mechanisms
  • Assisting in the analysis, design, and development of tables, Excel files and ad-hoc reports.
  • Understood basic business analysis concepts for logical data modeling, data flow processing and data base design.
  • Interface with users, business analysts and other department heads to gather information and requirements. Developed databases and specifying specific data requirements.
  • Involved in writing the TDR's and FDR's for any new change or enhancement

Environment: SAS 9.0, SAS/Base, SAS/Macro, SAS/SQL, SAS/OLAP, SAS Enterprise Guide, SAS/STAT, Web Reports Studio, MS-Excel, SAS GRID, Visual Analytics and UNIX Sun Solaris.

Confidential - Memphis, TN

SAS Programmer/Analyst

Responsibilities:

  • Extracted raw data from the warehouse and created SAS data sets that are required for the project analysis using SAS/Access and SAS/Connect.
  • Extensively used PROC FREQ, PROC TABULATE, PROC MEANS, PROC SUMMARY, PROC CONTENTS, PROC REPORT, PROC COMPARE and PROC UNIVARIATE.
  • Extensively used Teradata tables for SAS datasets.
  • Wrote various SQL queries, PROC TRANSPOSE and PROC COMPARE procedures.
  • Developed and improved the efficiency of programs through the use of SAS macros and SAS/SQL.
  • Listings, derived datasets, and control checks. Program the integration of databases from multiple studies or sources.
  • Writing Procedural Language SQL (PL/SQL) query for data manipulation and data analysis.
  • Created new and modified existing SAS programs to load data from the source and create specific datasets, which are used as source datasets for report generating programs.
  • Modified standard programs to generate data sets for statistical data analysis, generate listings, summaries.
  • Wrote wrapper Unix Shell scripts for execution of SQL / PLSQL and SAS scripts from Unix.
  • Slicing and dicing the data from unorganized data files. • Extensively using PROC GPLOT and PROC GCHART for generating graphs and plots.
  • Formatted HTML, RTF and PDF reports, using SAS Output Delivery System (ODS).
  • Worked on Ad-hoc, monthly reports on a regular basis using SAS EG 4.3.
  • Wrote code using SAS/Base and SAS/Macros to extract clean and validate data from flat file, Excel file.

Environment: SAS EG 4.3, SAS/Base 9.2, SAS/Graph, SAS Script, SAS server Winscp, SAS/ETL, Teradata SQL Assistant, SQL, SAS Macro Coding, Teradata, RDBMS, Toad, MS Access and MS Excel.

Confidential - Washington, DC

SAS Programmer

Responsibilities:

  • Working on the Troubled Debt Restructuring project for the RBS Citizens Bank of Rhode Island using SAS 9.2 environment.
  • Writing advanced SAS programs involving macros, SQL joins merges, prompts and building Enterprise Guide projects.
  • Translate user data and reporting requirements into SAS programming language.
  • Performing Ad-hoc querying, reporting and data management.
  • Working with relational databases such as DB2 and MS-Access and SAS storage server SPDS.
  • Working with different kinds of financial data including credit cards, student loans, small business, and treasury, automobile.

Environment: SAS 9.2, Enterprise Guide 4.3/4.2, ODS, DB2, SAS GRID, UNIX, Visual Analytics, SPDS, MSAccess, Windows 7

Confidential

SAS programmer

Responsibilities:

  • Analyzed the data based on the requirement
  • Analyzed large data sets consisting of million records
  • Creating a customer statistical mailing list for Direct Mailing and Telemarketing. Worked with large customer response and sales data sets.
  • Maintain and enhance existing SAS reporting programs for marketing campaigns.
  • Maintain SAS analysis for the products purchased every month.
  • Conduct individual account and household level analysis.
  • Conduct significance tests and study response rates for different level of Marketing based on the reports.
  • Modified existing SAS programs and created new programs using SAS Macro to improve ease and speed of modification as well as consistency of results.
  • Extracted data from warehouse using SQL procedure and created SAS data sets.
  • Performed Data cleaning, Formatting, Cluster analysis, and regression analysis for normality using SAS.
  • Created reports using analysis output and export them to the web to enable the Customers to have access through SAS Integration.
  • Extensively used SAS procedures Print, Sort, SQL, Mean, Freq etc.

Environment: SAS/ Base, SAS/Macros, SAS/Stat, SAS/Connect, SAS/Access, SAS/Graph, SAS/ODS, MsExcel, Oracle 8i, Unix, Pl/SQL Developer.

We'd love your feedback!