We provide IT Staff Augmentation Services!

Sas Bi Analyst/developer Resume

Southfield, MI

Summary of qualifications:

  • Over 7+ years of experience in analysis, design, development, testing in SAS(V 6.0/8.2/9.1/9.2/9.3 )
  • Experience in the Banking sector performing analysis of marketing campaigns.
  • Experienced with affinity card marketing campaigns and cross sell campaigns.
  • Extensive experience in SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/EG and SAS BI Tools such as SAS Enterprise Guide, SAS Management Console, SAS Stored Processes Web Application, SAS Information Map Studio, SAS Web Report Studio, SAS Information Delivery Portal, SAS BI Dashboards, SAS Content Server, SAS Application Servers.
  • Good command on configuration of SAS Business Intelligence platform including Metadata server oriented architecture and IOM server management on windows platform and network configuration required for the installation of SAS BI tools at Enterprise level.
  • Experienced in extracting data from various databases like Oracle, SQL server, DB2 etc. using SQL Pass through Facility.
  • Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
  • Developed ETL processes in SAS for different database platforms.
  • Expertise in using SAS ODS to create HTML, RTF and PDF for creating customized and adhoc reports.
  • Experienced in creating, storing reusable Macro modules as well as invoking stored macros.
  • Extensive experiences of editing and debugging procedures for data cleansing, correction, transformation and program validation.
  • Worked on statistical analysis, reporting, ad-hoc analyses/reports.
  • Excellent analytical, inter-personal & communication skills with experience in interacting with clients, multiple user groups and managing development teams. Ability to work in a fast paced environment and under deadlines.

Technical skills:

Operating Systems: Windows NT/XP/2000/2003

SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/ACCESS, SAS/ETL, SAS /Graph, SAS/OLAP Server, SAS IntrNet, SAS BI platform, SAS EG, SAS EBI, SAS add-in MO, SAS WRS.

Business Intelligence: SAS Management Console, SAS Enterprise Guide, OLAP Cube Studio, SAS Add-In to MS Office, SAS Information Map Studio, SAS Web Report Studio, SAS stored process.

Application s/w Packages; MS Office, Microsoft Visio, MS Project SAS Procedures sort, transpose, copy, summary, report, means, freq, tabulate, print, univariate, reg, corr, ttest, export, import, cport, cimport, glm, mixed, graph, gplot, sql, anova, format, template, contents, format, catalog, datasets, download, dbload, append, lifetest, compare

PROFESSIONAL EXPERIENCE:

Client: Confidential, Southfield, MI

Role: SAS BI Analyst/Developer

Confidential is an indirect auto finance company, working with car dealers nationwide to enable them to sell cars to consumers on credit regardless of their credit history. The project assists Dealer Support group.

Responsibilities:

  • Developed complex programming to extract and manipulate data.
  • Created reports that provide the insightful analysis to business to optimize the high volume decisions.
  • Used Proc SQL Libname and PROC SQL Pass-through methods to access data on Oracle database.
  • Validate and test all code for accuracy and efficiency and moved it into Production.
  • Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROC FREQ, PROC CONTENTS and PROC DATASETS to generate different reports and run metrics on different data sets.
  • Conducted Ad Hoc analysis to support business strategy
  • Developed SAS programs based on the draft spec document
  • Delivered reports via portal using BI tools like SAS Web Report Studio, SAS Information Delivery Portal and Stored Process Web Application
  • Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results
  • Wrote different joins and merges to create reports based upon the requirements given.
  • Written time and resource efficient code using PROC SQL.
  • Analyzed the transformed data using SAS BI tools such as SAS Enterprise Guide 4.2, and SAS Add-in for Microsoft Office.

Environment: SAS 9.3/9.2, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 5.1/4.3, SAS Add-In for Microsoft Office, SAS Stored Processes Web Application, SAS Web Report Studio SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Management Console 9.2,, Windows.

Client: Confidential, Columbus, OH

Role: SAS BI Application Developer

Confidential is an American multinational banking corporation of securities, investments and retail. It is the largest bank in the United States by assets and market capitalization. It is a major provider of financial services. The project assists several chase online service products. Using the data from db2, Oracle and SQL server, analyzed and created reports for the business. Our team used SAS 9.2, SAS EG 4.3 and BI tools to extract data and created reports which helped the business analysis.

Responsibilities:

  • Accessed data from the databases using the SQL pass through facility and developed the reports that meet business requirements.
  • Written and modified SAS code to create reports and increase runtime performance of the code.
  • Extensively developed stored processes using SAS Enterprise Guide 4.3.
  • Created complex reports using stored processes through SAS Enterprise Guide.
  • Delivered reports via portal using BI tools like SAS Web Report Studio, SAS Information Delivery Portal and Stored Process Web Application.
  • Written SAS code and modified the existing scripts to transform data using data step.
  • Used different statistical procedures like PROC SUMMARY, PROC TABULATE, PROC MEANS and PROC FREQ for analysis and report creation.
  • Written SAS MACROS for the code to reduce its length and increase its reusability.
  • Used PROC SQL procedure, connected to different databases via pass through facility to execute SQL queries using the databases.
  • Used PROC EXPORT, PROC IMPORT, PROC TRANSPOSE, PROC PRINT and PROC CONTENTS for SAS Reporting.
  • Created reports for Microsoft Office using SAS Add-in for Microsoft Office.

Environment: SAS 9.2, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 4.3, SAS Add-In for Microsoft Office, SAS Stored Processes Web Application, SAS Web Report Studio SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Data Integration Studio 4.2, SAS Management Console 9.2,UNIX, Windows.

Client: Confidential, OH

Role: SAS BI Application Developer

Confidential is a leading non-profit managed care company based in Dayton, Ohio. Confidential has grown to be the largest Medicaid managed care plan in Ohio and one of the largest in the country, serving more than 800,000 members in Ohio and Michigan. This project assists in providing the healthcare claims and memberships data, using EBI suite for ad hoc analysis and reporting.

Responsibilities:

  • As a member of team handled all aspects of the configuration, development, and implementation of the clients SAS Enterprise Business Intelligence environment.
  • Used SAS Management Console 9.2 for importing tables (by creating server, schema, and library) from the Oracle Warehouse and worked on various Plug-ins of Management Console.
  • Used SAS Data Integration Studio 4.2, extracted old format data and transformed them to the current version datasets.
  • Designed Information Maps using Information Map Studio 4.2 by joining tables without using SQL queries and used those maps in the Web Report Studio for creating customized reports.
  • Analyzed the transformed data using SAS BI tools such as SAS Enterprise Guide 4.2, and SAS Add-in for Microsoft Office.
  • Developed new Stored Processes consisting of modified SAS programs using SAS Enterprise Guide 4.2.
  • Extensively written SAS Macros within the SAS code for creating prompts to be used in stored process.
  • Created sophisticated reports of the processed data using SAS Web Report Studio, SAS Information Delivery Portal, and Stored Process Web Application.
  • Created Dashboards using SAS BI Dashboard 4.2 for the users to monitor key performances of enterprise.
  • Tested SAS code in both Unit Testing and Integrated Testing scenarios.
  • Strong interpersonal and leadership skills including monitoring the SAS BI platform security.
  • Actively participated in Production support and provided solutions to end users.

Environment: SAS 9.1.3/9.2, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 4.2, SAS Add-In for Microsoft Office, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 4.2, SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Data Integration Studio 4.2, SAS Management Console 9.2, SAS BI Dashboards 4.2

Client: Confidential, Atlanta, GA

Programmer

Confidential had an Enterprise Data Warehouse for holding the data of all the customers and employees. This multi-dimensional data warehouse had the information about the salaries and other information of all the employees, billing and other services offered to the business and residential customers. This data was used for different purposes, the main purpose being raising campaigns to hold the valuable customers and prevent the existing customers from leaving Cingular. We the SAS team had to pull the data from different sources to generate lists for the campaign raising purpose. We also helped the client to calculate revenues on a weekly basis for different products.

Responsibilities:

  • Involved in the design and development of databases different data models and ERDs according to the user specifications in the development of databases for small applications.
  • Involved in the administration of the enterprise data warehouse using warehouse administrator.
  • Written SAS code for developing data sets from raw data files received in text format. This included cleaning data.
  • SAS/ENTERPRISE GUIDE software was used for file and program management purposes.
  • Connected to Oracle and pulled data into SAS data sets using SQL pass through facility.
  • Wrote different joins and merges to create reports based upon the requirements given.
  • Written time and resource efficient code using PROC SQL.
  • Written queries in Teradata SQL assistant to retrieve data from Teradata tables.
  • Written macros to automate the code so that they generate reports on the invocation of the macro which helped to save time and manual intervention.
  • Extracted, transformed, and loaded data using SAS/ETL.
  • Used PROC SORT to sort the data according to the requirement.
  • Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROC FREQ, PROC CONTENTS and PROC DATASETS to generate different reports and run metrics on different data sets.
  • Created tables, views in Teradata and Oracle as well as indexes and keys on different columns.

Environment: Base SAS, SQL, PL/SQL, Teradata SQL assistant, Mainframes, UNIX, SAS, Visual Basic, SAS/EG, SAS Warehouse.

Client: Confidential

Role: Software Analyst

This project involved implementing consumer lending module for marketing & performance information department of Confidential . Marketing department creates a mailing list of consumers for Direct Mailing and Telemarketing offers, and measures the performance of those campaigns. I was working under a new project called E-Mail Marketing. Customer management obtains segments and analyzes customer profiles based upon variables of interest in data mart and data warehouse.

Responsibilities:

  • Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data.
  • Created customer mailing lists for Direct Mailing and Telemarketing using Proc Forms.
  • Extensively used Proc Import and Proc Export procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables.
  • Maintained and enhanced existing SAS Reporting programs using Proc Tabulate, Proc Report, Proc Print, ODS RTF, and ODS PDF for marketing campaigns.
  • Created Ad hoc reports for marketing managers using SAS Enterprise Guide.
  • Used Proc SQL Libname and PROC SQL Pass-through methods to access data on Oracle database.

Environment: Windows XP, SAS Enterprise Guide, Base SAS, SAS Macros, SAS/Access, Oracle, SQL.

Hire Now