Senior SAS Analyst Resume Profile

Experience Summary

Over 8 years of SAS experience, specializing in Advanced Analytics Programming and Reporting, Customer Intelligence, Marketing and Sales Analytics.
Expert in Information Technology, with extensive experience in all stages of project lifecycle including requirement analysis, program design, development, debugging testing.
Worked in varied domains such as HR Outsourcing Defined Benefits, Defined Contribution and Health Group Benefits , Insurance and Banking Financial Services.
Worked in various operating environments such as Mainframe, Windows and UNIX.
Implemented end to end production scheduling environment for automating SAS jobs.
Effective in cross-functional and global environments to manage multiple tasks assignments concurrently.
Experienced in basic project management activities such as Project Planning, drawing estimates, project metrics tracking, defect tracking and defect prevention analysis.

Technical Skills

SAS SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, SAS/ODS
Reporting Tools SAS Enterprise Guide 4, QlikView 11
Databases and Tools IBM DB2 8.0
Operating Systems MVS/ Z OS, UNIX, Windows
Programming Language SAS 9, SQL, JCL, UNIX Shell Scripts, DOS Batch Scripts
Version Control Systems Endeavor
Scheduling Tools Control M, ESP
Office Tools Microsoft Office, Microsoft Visio

Professional Experience

Confidential

Senior SAS Analyst

Responsibilities:

Built basic dashboard using QlikView to provide 360 degree view of client.
Built a complete end to end system to automate stabilized reports using ESP, batch scripts, Base SAS, stored procedures and SAS Macros.
Married internal data warehouse data with data acquired from Census Bureau, Geolytics and Experian and categorized the market by segment, geography, demography.
Worked with various vendor data such as D B, SNL to analyze market share, branch prospects, etc., that provides strategic information that steers the process of expanding the footprint or the branch penetration.
Worked with multiple Line of Businesses such as Credit Cards, Deposits and Direct Lending to run campaigns to cross sell products among existing clients and to acquire new clients.
Supported Enterprise Sales Analytics Team in sales analytics and running various sales campaigns.
Technology/Software: SAS9, SAS Enterprise Guide 4, DB2, Batch Script, ESP, QlikView.

Confidential

Senior SAS Analyst

Responsibilities:

Built reports that provided data in certain aggregated views either distributed geographically or segment-wise based on need and leads to the Strategic Analyst of associated Line of Business for decision making and forecasting.
Worked with various stakeholders in building logic for house holding and segmentation.
Built various leads lists that provide prospects that can be targeted for various sales and or regulatory campaigns.
Worked on process improvement, performance optimization, defect tracking and defect prevention analysis for reports in production.
Worked in building and validating center assignment process.

Technology/Software: SAS9, SAS Enterprise Guide 4, DB2

Confidential

Senior SAS Analyst

Responsibilities:

Extracted web data of customer behavior over a period of time and created lead list for various outbound marketing campaigns broadly classified as New member service, Quoted not sold and Deepening Relationship.
Involved in designing and developing the business logic.
Involved in various phases of Project analysis, design and Creating Test case.
Reviewed coding and unit testing results, integration testing and UAT results.
Converted some of the existing programs from SAS Mainframe to UNIX/ SAS Enterprise Guide.
Involved in scheduling of jobs for production run.
Technology/Software: SAS9, SAS Enterprise Guide 4, JCL, DB2, Mainframe, UNIX

Confidential

Senior SAS Analyst

Responsibilities:

Analyzed the trend of change in product purchase under various aspects such as Probable Maximum Loss regions, Switchboard, etc. to forecast the line of business.
Created dashboards that shows the pattern under various views based on the dimensions new, lost and change.
Involved in various phases of Project Impact analysis, design and Creating Test case.
Reviewed coding and unit testing results, integration testing and UAT results.
Scheduled the reports to run periodically based on the range of study.
Technology/Software: SAS9, SAS Enterprise Guide 4, JCL, DB2, MS Access, Mainframe, UNIX