SUMMARY

• 7 years of Experience in DWH, Analytics in financial and Manfacturing domains. Compile and analyze large data sets including data step processing, data mining, data manipulation, macro creation, data transformation.
• Strong Experience in SAS Data warehouse, ETL, Data Analysis, SASAd - Hoc Reporting using SAS stored processes.
• Certified BASE and Advanced SAS programmer.
• Connected to Oracle, DB2 and Teradata databases using SAS/ACCESS explicit SQL pass-through facility and Libname statement in both UNIX and windows environments.
• Converted raw data in teh form of csv and txt files to SAS datasets for further analysis and transformations.
• Followed System Development Life Cycle (SDLC) methodology for teh design, development, implementation, and testing of various SAS modules.
• Transformed teh data pulled from external databases like Teradata and formatting it as per teh data warehouse.
• Experience in using teh Set, Update, Modify and Merge statements for Creating, interleaving, Updating and Merging various SAS datasets.
• Extensive experience in SAS/MACROS by using existing macros and creating new macros.
• Strong hold on writing SQL queries especially in handling large data sets wif SQL joins using PROC SQL.
• Experience in using SQL views and indexes for handling large data sets.
• Experience in working wif relational databases like Oracle, DB2, SQl Server and Teradata.
• Responsible for accessing and managing data and for writing complex SQL queries and analysis.
• Scheduled SAS jobs to run on regular intervals using UNIX crontab file.
• Implemented Agile/Scrum methodologies during project development.
• Created Hash objects for performing fast table lookups when combining large datasets.
• Worked on various UNIX commands and shell scripting using VI editor and ultra-edit.
• Experience in using several BASE SAS modules like SAS Procedures, SAS Functions, SAS Statements, SAS Formats, SAS Informats, SAS Dataset options, SAS System Options, SAS Reports and SAS Access.
• Extensively used INPUT and PUT statements for reading data from external files and printing to SAS log.
• Experience in doing regression analysis and predictive modeling using PROC REG.
• Proficiency in importing different types of external files(Excel, CSV, txt, etc.) into SAS libraries and exporting SAS data sets as external files using PROC IMPORT, PROC EXPORT, and SAS DATA steps.
• Extensively worked on SAS Procedures like PROC SORT, PROC APPEND, PROC CONTENTS, PROC DATASETS, PROC COPY, PROC FORMAT, PROC PRINT.
• Command in producing tables, listings, and reports employing SAS procedure steps such as PROC REPORT, PROC MEANS, PROC SUMMARY, PROC COMPARE, PROC TABULATE and PROC FREQ.
• Used SAS ODS (output Delivery System) to create output in different styles and redirecting to RTF, HTML, PDF and CSV files.
• Good team member and a potential team leader.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Statistical Software: BASE SAS, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STATSAS/GRAPHS

Programming Languages: C, Objective C, SQL, UNIX Scripting

Databases: ORACLE, DB2, SQL Server and Teradata

Application Software: MS Office (Word, Excel, Power Point, Access and Visio), Ultra-edit.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Data Analyst

Responsibilities:

• Responsible for teh design, development and administration of transactional and analytical data constructs/structures.
• Included wifin those responsibilities are teh areas of data access and delivery technologies.
• Includes expertise in data quality, data organization, metadata, and data profiling. May provide technical support on data warehouse teams.
• Data set sizes are usually huge (in excess of hundreds of millions of records). Demonstrated ability to move from one sequential assignment to teh next (work environment and priorities can change quickly depending on business needs).
• Demonstrated ability to move data between production systems and across multiple platforms.
• Created a separate folder structure to make sure it is easy for teh end user to identify teh final reports.
• Actively participated and shared noledge wif CV team to achieve teh due date and quality.
• Creating test cases for teh developed SAS jobs and, identifying teh defects.
• Cleaned teh data and loaded teh data into different databases as required.
• Creating documentation for teh developed SAS jobs and deploying them to teh testing environment.
• Discussing wif teh testing team about preparing teh testing data for testing teh jobs in various environments, including UAT (User acceptance testing).
• Worked on sorting large datasets, by grouping and RETAIN statements.
• Connected to Teradata, DB2 and Oracle databases using SAS/ACCESS Libname and explicit SQL pass through teh facility.
• Creating Hash objects for combining SAS datasets and performing table lookups.
• Scheduling SAS jobs to run on regular intervals using teh UNIX crontab file.
• Written shell scripts to automate daily tasks.
• Worked on first and last Variables.
• Involved in code changes for SAS programs and UNIX shell scripts.
• Used put statements to create automatic SAS programs.
• Manipulated large data sets. Responsible for data entry and conversions; data validation and corrections, uploading/downloading data from/to SAS.
• Executed teh SAS jobs in batch mode through UNIX shell scripts
• Created permanent formattedSAS data sets for present and future analysis, infillingseveral datasetsand sorting and merging by common variables.
• Moved datasets across platforms (from PC to UNIX and Vice Versa) using FTTP.
• Efficiently utilized Macros to eliminate repetitive SAS codes and used them as SAS stored processes.
• Created User defined formats and informats using PROC Format.
• Worked on creating and using table lookups.
• Worked wif SQL joins to join datasets using PROC SQL.

Environment: SAS/BASE 9.4, SAS/MACRO, SAS/STATS, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS Enterprise Guide, Teradata, UNIX, MS Excel.

Confidential, Chicago, IL

SAS Programmer/ Analyst

Responsibilities:

• Extracting data from Oracle using SQL Pass through facility and generated ad-hoc reports, Campaign Management, Weekly and Monthly Reports using SAS and SQL.
• Designing and modeling reports on user requirements using SAS.
• Prepared, documented and tested required programs and procedure data displays in an efficient manner for inclusion in integrated statistical summary reports and other reports.
• Supporting other team members in designing and developing programs.
• Developed new or modified SAS programs to load data from teh source and create study specific datasets, which are used as source datasets for report generating programs.
• Manage and execute weekly, monthly and quarterly dash reports.
• Improve teh efficiencies of marketing activity, through teh targeting, planning and campaign evaluation. Analyze teh customer data to evaluate campaign activity and use this insight to maximize targeting and overall campaign TEMPeffectiveness.
• Back-end support to campaign management department
• Developing different test scenarios for testing (white box) teh complete functionality of teh SAS jobs.
• Developed Analysis, Strategies, and Reports for usage in teh Management of Underwriting,Line Assignment, Existing Customer Management, Marketing Campaigns, and Collections.
• Utilized database management, reporting, and analysis software to store, organize, and manipulate data from Reporting and Production databases.
• Involved to relate technical concepts to SAS System applications and Business and Marketing user needs.
• Utilized advanced statistical software to develop Analysis, Strategies, and Reporting Capabilities.
• Worked wif Fraud Analytics to develop new and modify existing process documentation and templates in implementation of fraudrisk controls and reporting.
• Developed sophisticatedriskstrategies, and analyze and mitigate fraudriskby identifying teh risks associated wif online customer originations, autantication and product usage.
• Provided insightful and analytic based recommendations that consider fraud exposure, customer service, and operational impacts.
• Written SAS reports to Excel, teh SAS content server, HTML, and PDF
• Generated reports, graphs and presentations wif recommendations from post campaign analysis and enhancement of future campaigns
• Involved solving large systems and analysis of massive data
• Analyzed teh database schema and extracted teh performance data from teh MYSQL server.
• Prepared and Delivered Dashboard reports on teh basis of analysis of revenue assurance report received from various operations of teh company and consolidating teh result for management reporting using SAS, Macros, Pivot tables, Charts, Data Validation.
• Marketing Campaign Report analyzing teh reasonableness and profit potential of teh user’s campaign assumptions. This tool also allows users to analyze more than one marketing campaign to compare among them, teh one that would be teh most successful for their business.
• Involved wif Fraud, Waste and Abuse analysis in teh Financial payer space
• Process improvement via project management to include data gathering, analysis of situation or data, scenario creation, ROI evaluation, and reporting on recommendations to management
• Created a demographic analysis of teh online customers to describe teh population and its characteristics, such as average education level, average age, income level, Email Provider, and other characteristics.

Environment: SAS/BASE, SAS/SQL, SAS/Macros, SAS/STAT, SAS/ACCESS, MS EXCEL, MY SQL, UNIX.

Confidential, Wilmington,DE

SAS Programmer/ Analyst

Responsibilities:

• Extracted data from teh Oracle and Teradata using SAS/ACCESS implicit/ explicit SQL Pass through.
• Writing ETL/SAS jobs as per teh requirements specification document and using them as stored processes.
• Handling data anomalies when pulling data from Oracle, SQL server and Teradata.
• Extracted raw data from an Oracle database and used SAS/ACCESS to read it and ran statistical analysis using SAS/STAT.
• Developing different test scenarios for testing (white box) teh complete functionality of teh SAS jobs.
• Coordination wif onsite team for issue resolution and daily status tracking updates to project lead as well as to onsite team.
• Built a batch application that recreates business procedures using SAS Base, SAS macro and SAS Access, basic SAS Stat
• Extensive use of SAS/BASE and SAS/STAT for producing tables, listings, figures, and generating statistical reports.
• Extensively worked on PROC CHART and GPLOT to produce visualization of data in teh form of graphs.
• Modifying and creating UNIX shell scripts using VI editor or Ultra-edit.
• Create process flow for teh SAS jobs using MS Visio, design docs and send to testing team.
• Provide day to day direction to teh project team and regular project status to teh customer.
• Developed standard reports using Base SAS and Macro Language.
• Involved in TEMPeffective communication between teh project team and teh customer.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• Prepared Unit & System Test cases.

Environment: SAS/BASE, SAS/SQL, SAS/Macros, SAS/STAT, SAS/ACCESS, MS EXCEL, ORACLE, Teradata, UNIX.

Confidential

SAS Programmer

Responsibilities:

• Connected to oracle database using SAS/ACCESS Libname and explicit SQL pass through facility.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading teh efforts including programming and testing that culminate in client acceptance of teh results.
• Designing Unit and system test cases for testing teh SAS jobs.
• Performed data analysis, statistical analysis, generated reports, lists and graphs using SAS tools-SAS/BASE, SAS/GRAPH, SAS/SQL and SAS/ACCESS.
• Building of generic utility processes for large volume sort, sort/summation, and UNIX batch SAS execution
• Establish Quality Procedure for teh team and continuously monitor and audit to ensure teh team meets quality goals.
• Working major enhancements on Unix shell scripts for SAS batch programs.
• Used in SAS/Graph and SAS/STAT to generate teh plots of teh variables and regression lines
• Prepared monthly production environment.
• Bug fixing of SAS programs in Production.
• Wrote Base SAS and macro code to validate teh data sets before running teh statistical models
• Efficiently utilized Macros to eliminate repetitive SAS codes.
• Joined tables using SQL joins.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS Enterprise Guide, SAS/ODS, MS Excel, MS Visio, MS Project, Oracle, UNIX.