We provide IT Staff Augmentation Services!

Sas Consultant Resume

3.00/5 (Submit Your Rating)

Wilmington, DE

SUMMARY

  • SAS programmer with 7+ years of professional experience in working with SAS and SAS tools with strong emphasis on SAS programming, data manipulation and data analysis for risk management, marketing, operations and financial departments of large enterprises.
  • Extremely energetic, detail oriented, organized team player with strong analytical abilities, communication skills, interpersonal skills, and problem solving skills.
  • Highly persistent and motivated with willingness to assume responsibility.
  • Experience in Base SAS (MACROS, Proc SQL, ODS), SAS/STAT, SAS/ACCESS, SAS/CONNECT and SAS/GRAPH in UNIX, Windows, and Mainframe environment.
  • Experience in modeling for risk rating and generate results/reports for upper management.
  • Experience in performing various business analyses like Market analysis, Customer behavior analysis.
  • Worked closely with management like Marketing managers, Product Managers, Financial managers, Operations managers etc., to analyze customer related data, generate custom reports, tables, and graphs.
  • Experience in generation of various canned periodic and ad - hoc reports for various analyses.
  • Experience in UNIX Korn Shell scripting for process automation.
  • Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
  • Thorough knowledge in SAS Programming, Merging SAS Data Sets, Macro Facility, Preparing data, SAS Procedures, Producing Reports, SAS Formats, SAS Functions, Storing and Managing data in SAS Files.
  • Experience in using SAS to read, import, and export to other data file formats, like XML files, Excel files, and flat files.
  • Experience in importing data from Oracle Server, DB2, and MS SQL Server.
  • Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, and MS Excel.

TECHNICAL SKILLS

SAS Tools: SAS 8/9, Base SAS (MACROS, Proc SQL, ODS), Advanced SAS, SAS/ACCESS, SAS/GRAPH,SAS/CONNECT, SAS EG.

Database Tools: TOAD 9.7.2, PL/SQL Developer 7.1.5.

Operating Systems: UNIX, MS-Windows XP/2003/2000.

Databases: Oracle 9i/10g/11i, DB2, MS SQL Server, TD SQL and MS Access.

Programming Languages: SAS, SQL, UNIX Korn Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

SAS Consultant

Responsibilities:

  • Worked with Data and Analytics COE Team to help leverage data and analytics across platforms.
  • Proficient in sorting, merging and using different table lookup techniques to get the required information to analyze data and generate the reports.
  • Provided technical support on SAS programming related to data manipulation and analysis.
  • Developed and used scripts to schedule SAS Jobs in Unix environment.
  • Variety of tasks including data extraction, manipulation, Analysis using Operations and Transactions Data (ETL).
  • Perform complex ad-hoc programming, analysis, and reporting.
  • Developing the UNIX shell scripts in order to run the report as a part of daily schedule.
  • Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
  • Develop/Modify shell scripts to run/automate SAS programs.
  • Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data.
  • Upload data to Teradata (Fastload, Multiload, etc.)

Environment: SAS 9.1.3/ 9.2, SAS/CONNECT, SAS Macros, SAS/ACCESS, Oracle 10g, Windows 7, MS Office, HTML, SAS Enterprise Guide, Unix, SQL, Teradata SQL Assistant.

Confidential, Wilmington, DE

Lead Quantitative Analyst

Responsibilities:

  • Working with Direct Mail Marketing Strategy team to develop strategies and track their performance
  • Created and delivered reports and presentations with key findings and recommendations.
  • Produced statistical reports for various business needs and expertise in data preparation, datacleaning, analysis, and reporting
  • Involved in requirement gathering and functional documentation preparation.
  • Based on the requirements and the specifications, created SAS programs for the generation of datasets.
  • Provided technical support on SAS programming related to data manipulation and analysis.
  • Exported SAS Reports to the Excel Sheet by using ODS/Tag sets/Excel XP to get the output in multi sheets.
  • Developed and used scripts to schedule SAS Jobs.
  • I have been doing variety of tasks including data extraction, manipulation, Analysis using Operations and Transactions Data (ETL).
  • Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
  • Develop/Modify shell scripts to run/automate SAS programs.
  • Customizing the existing Macros according to need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.
  • Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data.

Environment: SAS 9.1.3/ 9.2, SAS Macros, Oracle 10g, Windows 7, MS Office, HTML, SAS Enterprise Guide, SQL, Teradata.

Confidential, Austin, TX

Strategy Analyst

Responsibilities:

  • Worked with Global Risk Case Management Team to help leverage big data to profile transactions.
  • Provided technical support on SAS programming related to data manipulation and analysis.
  • Exported SAS Reports to the Excel Sheet by using ODS/Tagsets/ExcelXP to get the output in multisheets.
  • Developed and used scripts to schedule SAS Jobs.
  • Modify models to reflect any changes in business requirements and input data structure.
  • Variety of tasks including data extraction, manipulation, Analysis using Operations and Transactions Data (ETL).
  • Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
  • Develop/Modify shell scripts to run/automate SAS programs.
  • Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data.
  • Upload data to Teradata (Fastload, Multiload, etc.)

Environment: SAS 9.1.3/ 9.2, SAS/CONNECT, SAS Macros, SAS/ACCESS, Oracle 10g, Windows 7, MS Office, HTML, SAS Enterprise Guide, SAS Stored Processes Web Application, SQL, Teradata.

Confidential, Atlanta, GA

SAS Analyst

Responsibilities:

  • Worked with business users to design and develop several ad-hoc reports and information maps using PROC REPORT and PROC TABULATE. The reports created include Monthly summary reports as well as detailed weekly reports.
  • Connected to the DB2 database and extracted the relevant data (using LIBNAME or Pass-through facility) and then processed the data using business logic to produce reports. Made heavy use of PROC SQL, PROC REPORT and ODS for producing these complex reports.
  • Extensively used SAS Data Steps, SAS, Statistical models, and Flowchart Design, Listing, Graphing, Summarizing and Reporting procedures.
  • Performed validation the datasets through different procedures.
  • Proficient in sorting, merging and using different table lookup techniques to get the required information to generate the report.
  • Handled the tasks of writing reports and manipulating data by using UNIX platforms
  • Developed queries on the existing SQL server databases to provide ad-hoc reports using SAS/SQL.
  • Produced reports and complex data analyses using SAS, including SAS/stats, extracted data from Oracle files using SAS/Views, SAS ProcSQL.
  • Debugging SAS programs using data null, Put statements and using datastep debug.
  • Generated automated graphs for monthly run using ProcGplot. Exported these graphs to Pdf File using SAS/ODS.
  • Customizing the existing Macros according to need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.
  • Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data
  • Creating excel pivot table reports using Cycle Time data. These reports consist of Benefit level data, claims level data. These reports are very useful to get a greater insight into the further plan design.
  • Developing the UNIX shell scripts in order to run the report as a part of daily schedule.
  • Exported SAS Reports to the Excel sheet by using ODS/Tagsets/ Excel XP to get output in multisheets. Used several Style Options.
  • I have been doing variety of tasks including data extraction, manipulation, Analysis using Claims Data.
  • Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
  • Expert in preparing Analysis Datasets, Tables, Listings, and Graphs according to the Business Requirement.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, MS-Excel, SAS/ODS, Oracle, UNIX, and Windows NT,SAS Enterprise Guide, SAS Add-In to MS Office, SAS Information Map Studio, SAS Stored Process, and SAS Web Report Studio.

Confidential, Edina MN

SAS Programmer

Responsibilities:

  • Extensively interact with business analysts, IT services team, and Statisticians for developing SAS models for risk rating of commercial loans.
  • Involved in SDLC of the risk rating application. Documented requirement analysis, version upgrade, and migration across develop, test, and production environment.
  • Develop, test, and debug SAS programs to model Risk rating models for different types of commercial loans.
  • Modify models to reflect any changes in business requirements and input data structure
  • Extensively used SAS Macros for programming.
  • Followed an internal program validation and tracking methodology.
  • Generate test data for model validation.
  • Modify/develop Korn shell scripts to automate report generation and schedule tasks.
  • Program for statistical analysis of data for model calibration.
  • Work with business analysts to analyze and debug data issues. Use SAS programs and functions for data validation and cleansing.
  • Work extensively in sorting, merging, concatenating, and modifying SAS data sets
  • Use ODS to generate results in Excel, PDF, and HTML formats.
  • Involved in handling the ad-hoc reporting requirements.
  • Extensively use Data NULL to create XML files from SAS datasets.
  • Develop SAS datasets from Excel files, XML files, Oracle Server, and DB2 database.
  • Extract data from the source database using Proc SQL.
  • Use XML Mapper for creating SAS datasets from XML files
  • Design, document, implement, and maintain monthly & ad-hoc financial, marketing and operations analyses using SAS.
  • Conduct complex ad-hoc programming and analysis including statistical programming and analysis.
  • Develop and produce monthly reports summarizing business activity, delinquency & loss
  • Analyze business performance and productivity to identify obvious and subtle causes for improvement and deterioration.
  • Extract and summarize account and transaction level data for trend analysis and forecasting
  • Create application layers for web publishing and dispatching of reports.
  • Produce SAS datasets, flat files, and reports.
  • Extract data from the source database using Proc SQL.
  • Build logistic regression models using SAS EG for risk scoring on new campaigns and prospective customers
  • Develop Model to Predict Customer Response to launch of new products.
  • Develop and execute controlled tests to determine the impact of new programs, strategy changes, or procedural changes.

Environment: SAS 9, Base SAS (MACROS, Proc SQL, ODS), SAS/ACCESS, SAS/STAT, SAS/GRAPH, SAS Enterprise Guide 3.0, SAS Enterprise Miner, DB2, Oracle 9i (SQL, PL/SQL), UNIX, UNIX Korn Shell, MS-Windows XP, MS-Office

Confidential

SAS Programmer

Responsibilities:

  • Produce SAS datasets, flat files, and reports for various departments,
  • Create SAS data sets from Oracle database.
  • Extensively program for statistical analysis of data.
  • Develop and execute controlled tests to determine the impact of new programs and strategy changes on existing customers.
  • Implement advanced statistical approaches to develop predictive models and profiles.
  • Data mining to identify significant relationships among customer behaviors and descriptive characteristics.
  • Perform complex ad-hoc programming, analysis, and reporting.
  • Design, document, implement, and maintain monthly and ad-hoc financial and marketing analysis.
  • Develop and produce monthly reports summarizing business activity, delinquency & loss.
  • Maintain and enhance loss-forecasting models and delinquency roll rates.
  • Modified/developed korn shell scripts to generate periodic reports.

Environment: SAS 8, Base SAS (MACROS, Proc SQL, ODS), SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS Enterprise Miner, Oracle 9i (SQL, PL/SQL), UNIX, MVS, UNIX Korn Shell, MS-Windows XP, MS-Office

We'd love your feedback!