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 Financial/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 Teradata programming for data management. Strong experience with databases like DB2, Oracle, Teradata, MS SQL Server and MS Access.
• Strong expertise in SAS DI environment with metadata servers and repository for mapping from source data.
• 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 profiling and applying business logic rules to incoming data.
• SAS Data Integration studio (SAS DI) application source code optimization for controlled jobs from Oracle
• 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, SQL assistant Teradata, Excel, MS Office tools.
• Experienced in target table define and design, transformation of data along with testing and code export in SAS DI environment.
• Experience in writing stored processes to promote code to SDD from SAS environment in SAS DI studio
• Experience in performing ad hoc queries and User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis.
• Jobs organization in SAS DI area from source to target environment and documentation
• 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 DI studio

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, S.C

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.
• SAS DI admin experience with promotion of data and back up maintained tasks with data servers
• Worked on gathering, analyzing and documenting business requirements
• Used SAS PROC SQL to extract data from different relational database management (Teradata, Oracle) 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.
• Oracle data mapping in creating enterprise data ware house with SAS DI environment
• 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.
• Application of Teradata sql assistant tool programming for data manipulation and extraction
• 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.
• Creation of metadata from source tables to derived database with SAS DI environment
• 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.
• SAS DI usage for data transfer from local servers to remote servers in DI studio application
• 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, Toad, SAS DI studio,Oracle9i, UNIX, WINDOWS 2000, Enterprise Guide

Confidential, Columbia, S.C

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, Teradata SQL Assistant 7.1, SAS/SQL, SAS 9.1.3, UNIX, Windows XP Professional, Business Object 6.5

Confidential, Raleigh, N.C

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 data from financial data marts provided by Credit Risk Management application project.
• Performed Data Cleansing during ETL’s Extraction and Loading Phase by creating complex reusable Macros.
• Extensively used SQL Query statements and PROC SQL in the MACRO for creating new datasets for specific 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 produced through the calculation in the Premium.
• Loaded various Old and New Rates data file retrieved from the Actuarial department in specific format in SAS through the import mechanism.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)
• Documented methodology, data reports and communicated with the Project Team / Manager to share knowledge.

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 8.1, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/ACESS and SAS/CONNECT, Oracle, SQL server, Windows XP, UNIX, MS Visio, Lotus Notes