SUMMARY

• Experienced SAS Programmer with 6+ years of experience in working with SAS and SAS tools emphasizing on analysis, design, developing, testing and implementation of various projects for financial and health care industries on windows and Unix environment. Analytical, methodical and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business needs and spirit to add value to your organization.
• Experience in the field of SAS (9.2, 9.1.3, 9.1, 8.2 versions) Programming / Business Analysis and Data Analysis in Finance/Insurance projects.
• Excellent experience working with finance data including Basel II, Regulatory or Credit Risk experience, marketing, fraud detection etc.
• Experience in all phases of Software Development Life Cycle (SDLC) including Requirements, Analysis/Design, Development and Testing. Expert in defining BI Standards, Best Practices, Code Review, DW standards and production support.
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process. Experience in Data Modeling and involved in creation of Star Schema and Snowflake dimensional data marts.
• Strong expertise in RDBS and SQL programming for data management. Strong experience with databases like Sybase, DB2, Oracle, Teradata, MS SQL Server and MS Access. Strong expertise in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL PASSTHRU facility.
• Experience in Integration of various Data Sources like MS - Access, Excel, Flat and CSV Files.
• Experience in processing large datasets with billions of records for data transformation including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Experience writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis. Experience in performing Ad Hoc Queries for various application and reports on a daily basis using complex SQL Queries.
• Expertise using SAS/BASE, SAS/MACRO, SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/GRAPH, Excel, MS Office tools.
• Expertise in using various SAS procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT. Experience in Consumer Profiling, Customer Segmentation, Regression Analysis and Sales Forecasting.
• Proficient in developing procedures, functions and stored packages using PL/SQL
• Experience in performing ad hoc queries and User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis.
• Proven ability to work under pressure, prioritize and meet deadlines. Open to dynamic work environment and ability to work collaboratively with business analysts, testers, developers and other team members in the overall enhancement of software product quality

TECHNICAL SKILLS

Statistical Packages: SAS 9.3

SAS Tools: SAS/BASE,SAS/MACRO,SAS/GRAPH, SAS/XML,SAS/STAT,SAS/SQL,SAS/ODS,SAS/ACCESS

Database: Oracle, SQL, PL/SQL, MS-Access

Operating Systems: Windows, Unix

Languages: SQL, KSH

PROFESSIONAL EXPERIENCE:

Confidential, Florence, SC

Sr SAS Consultant

Responsibilities:

• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Generated reports for Basel II reporting. Captured data from business areas at a detailed level and consolidated into higher-level portfolios using SAS and reports were generated.
• Worked on gathering, analyzing and documenting business requirements
• Used SAS PROC SQL to extract data from different relational database management (SQL Server, Oracle, and DB2) systems.
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Also cleaned the data using SAS code (SAS Macros) and VB Script and develop SAS Code on UNIX according to the specifications.
• Coordinated with external/ internal auditors (SOX, IT, etc) for validating of the Basel Reporting applications.
• Written KSH FTP scripts to FTP files to the specific path in the UNIX environment.
• Developed macros to validate the pre existing model to be used on any data set for future use, using PROC MEANS, PROC UNIVARIATE and other procedures
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS/Base, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort and Update, Formats, Functions and conditional statements.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL .
• Performed Data analysis mainly using Regressio/n and ANOVA (Proc REG, Proc GLM, and Proc ANOVA) for risk management and assessment.
• Worked on SAS Enterprise Guide for performing data analysis and creating stored processes.
• Extensively worked on Korn-Shell scripts for running sas programs in batch mode on Unix.
• Developed Stored Processes to distribute reports and in a secure manner.
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.
• Worked with business leads to coordinate monthly operations schedule for Basel Reporting production operations
• Involved in JAD sessions for gathering business requirements and documentation to reduce the complexity of business process.
• Effectively prepared and published various performance reports and presentation.

Environment: SAS/BASE, SAS/ETL, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, MS Excel, MS Access, MS Visio, MS Project, SQL server,Oracle9i, UNIX, WINDOWS 2000, Enterprise Guide

Confidential, Columbia, SC

SAS Data Analyst

Responsibilities:

• Analyzed various databases containing sales, titles, account, region and other data related to the releases of various titles with post migration activity.
• Used SQL Assistant 7.1 to analyze and query from the Teradata DB.
• Developed new or modified SAS programs and used SQL Pass Through and Libname to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs.
• Analysis included Behavioral model, Customer Profiling, Segmentation, Trend Analysis, Predictive Modeling, Lift modeling and Validation, Optimizing open-ended offers, etc.
• Imported raw data files in excel format in SAS and subsequently created SAS Datasets and performed data manipulations on the datasets.
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.
• Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Teradata DB. Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data.
• Documentation, presentation, data reports and model results to the team/manager. Effectively prepared and published various performance reports and presentations
• Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.

Environment: SAS/Base, SAS/STAT, DB2, Sybase, SQL Assistant 7.1, SAS/SQL, SAS 9.1.3, UNIX, Windows XP Professional, Business Object 6.5

Confidential, Raleigh, NC

SAS Programmer/Analyst

Responsibilities:

• Experience in conducting business requirements reviews, and walk through and customer interviews.
• Excellent in writing Business Requirements Document (BRD), Use Case Specifications, Functional
• Specifications, Systems Design Specification (SDS), Systems Requirements Specification (SRS), Data
• Dictionary, Workflows.
• Handled Customer Segmentation based on the number of Vehicles and the model / make of the vehicle.
• Established the credit and control norms for the end users while they are placing new orders, using datafrom financial data marts provided by Credit Risk Management application project.
• Generated datasets & cleaned raw data containing missing values and special characters like “@”.
• Performed Data Cleansing during ETL’s Extraction and Loading Phase by creating complex reusableMacros.
• Extensively used SQL Query statements and PROC SQL in the MACRO for creating new datasets forspecific State and Indexing and Appending various datasets.
• Created new State datasets for Territories, Policies, States, Vehicles, Drivers etc. and other key domains.
• Analyzed various Tiers of specific states and the Tier Factors that reflect the final Deviation producedthrough the calculation in the Premium.
• Loaded various Old and New Rates data file retrieved from the Actuarial department in specific format inSAS through the import mechanism.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director forstress testing and UAT (User Acceptance Testing)
• Documented methodology, data reports and communicated with the Project Team / Manager to shareknowledge.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ODS, AIX UNIX, Mainframe, IMS DBMS, SAS ETL, Excel

Confidential

SAS Analyst/Data Modeler

Responsibilities:

• Extract data from IBM mainframe and create pipes delimited flat files and reports as per requirements.
• Uses BASE SAS, Macros, and SAS SQL for advanced programming and production support.
• Involves in migration project of converting SAS jobs from ver8 to ver9. Create SAS coding and conversion standards. Prepares new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Supports the business process changes and traceability matrix using content management and version control. Conducts meetings with PM, developers and data architect to reduce the complexity of business process.
• Stores and distributes results in different formats (HTML, PDF, RTF) based on different user groups.
• Documents methodology, data reports, and model results, and communicated with project team/manager to share knowledge. Modifies macros for report generation using SAS Macros as per the requirements and FTP reports to On Demand landing areas.
• Extensively uses Data Null and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files.
• Supports the business process changes and traceability matrix using content management and version control. Partner with the technical areas in the research and resolution of system and User Acceptance Testing.
• Works with complex datasets to extract customized reports using PROC SQL, PROC SORT and PROC REPORT, PROC TABULATE for creating a preferred list of customers as per the given requirements from business analysts.

Environment: SAS Base 9.1, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/ACESS and SAS/CONNECT, Oracle, Sybase, SQL server, DB2, ETL, Windows XP, UNIX, MS Visio, Lotus Notes