SUMMARY:

• Around 6+ Years as Analyst/programmer with experience in software development, design, analysis, coding, implementation, maintenance and support as a SAS Programmer/Developer/Analyst with profound experience in Financial Industry.
• Expert in doing Pre and post Campaign Analysis: Support marketing planning process by proactively performing in - depth, what-if analysis to identify campaign opportunities.
• Based on findings, make recommendations to Customer Segment Senior Marketer regarding who (segment, sub-segment, select criteria) should be targeted/not targeted, what products should be marketed, and which channels should be utilized.
• Experienced in conducting analysis based on SAS Enterprise Guide and Visual Analytics and predictive modelling on SAS Enterprise Miner
• Experience in reporting, modeling, and data analysis and data manipulation.
• Worked with large data sets (50+ million records) and transactional data.
• Experienced in various phases of SDLC from planning, requirement analysis, designing, development, testing, implementation and support of projects in production environment.
• Expertise in Business Process Documentation.
• Experience in Base SAS, SAS/STAT, SAS/MACRO, SAS/GRAPH,SAS/SQL, SAS/ODS and SAS/ACCESS on Windows and Unix platforms and competence in carrying out statistical analysis of large scale data.
• Experience in design and development of ETL processes for Data Integration studio(DI),projects to perfrom data loads.
• Expertise in using various statistical procedures in SAS such as like PROC SQL,PROC SORT, PROC FREQ, PROC PRINT, PROC MEANS,PROC IMPORT/EXPORT, PROC TRANSPOSE, PROC UNIVARIATE, PROC CORR, PROC REG, PROC GLM, and PROC ANOVA.
• Generate custom reports using PROC SORT, PROC PRINT, PROC REPORT.
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT
• Experience in working with SAS Enterprise Guide Software (4.1 version) for reporting and analytical tasks
• Extensive knowledge of advanced SAS/STAT procedures including Multivariate Analysis, Regression, ANOVA, Graph and Plot
• Extensive experience in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on UNIX and Windows Environments.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility
• Experience in creating the SAS datasets by merging, concatenating, interleaving and validating datasets and TLG’s based on company requirement and resources.
• Experience in data manipulation, data wrangling, and statistical Analysis.
• Extensive experience in generating reports and creating summaries according to the specifications of Statistical Analysis plan (SAP) and Standard Operating Procedures (SOP).
• Expertise in generating reports in PDF, RTF and HTML formats using Output Delivery System (ODS).
• Experience working on different applications using Oracle, MS SQL Server, Teradata, IBM DB2, MS Access, MS Excel.
• Excellent interpersonal, organizational and oral/written communication skills contributing to project success in multi-tasking fast paced environment.
• Experience in working with customers to determine their needs, gather, analyze and document requirements, communicate with customers throughout the development cycle, manage customer expectations, resolve issues and provide project status.

TECHNICAL SKILLS:

SAS Tools: SASV9.1.3, SAS 9.2, SAS 9.3,Base SAS, SAS/SQL, SAS/MACROS, SAS DM, SAS/STAT, SAS /GRAPH, SAS/ODS, SAS/ACCESS, SAS/CONNECT, SAS/Forecast Studio, SAS Web Report Studio, SAS Data Integration Studio.

Reporting Tools: SAS BI Platform, Base SAS versions 9.3/9.2/9/8/6, SAS Enterprise, SAS Graph, AXUM, MS-EXCEL, MS-Visio, MS-PowerPoint.

Oracle, Microsoft SQL Server, MS: ACCESS, DB2, Teradata, Mainframe

Languages: SAS, SQL, Basic, HTML

Batch Server: UNIX, Putty, SSH, SAS scripting

Platforms: Windows 95/98/XP/Vista/Win 7, UNIX, Mainframe, PC SAS

PROFESSIONAL EXPERIENCE:

Confidential, Northbrook, IL

SAS Data Analyst

Responsibilities:

• Worked closely with project managers in gathering requirements from end users and developed report layouts using SAS EG, SQL.
• Developing SAS queries to pull members present and historical data from different DW.
• Extracted data from Teradata and manipulated the data using PROC SQL and even performed joins on datasets.
• Analyzed data using PROC FREQ and PROC SUMMARY.
• Used Teradata SQL assistant and TOAD for research requests.
• Supporting analytic functions, creating business intelligence infrastructure and providing SAS production support.
• Worked on the campaigns for both Book of Business and Client specific requirements.
• Experience with Aprimo Relationship Manager (ARM) to gather requirements for executing the campaign.
• Extensively worked on all Vendor Transition campaigns (FDRO, PA, Quantity limits, EES, Pharmacy network disruptions) during the welcome season.
• Updated the work instructions for several campaigns and cross trained other analysts on campaigns like Standard value formulary and FDRO requests.
• Performed second QC on the code & vendor files generated by other analysts to ensure proper execution. worked extensively to generate vendor files for PDL (ACF/ACSF, FDRO), Standard Value Formulary Disruption, PA, Quantity Limits, DSA/NCQA, Health Exchange Formulary, Enhanced Exclusive Specialty (EES), pharmacy terminations etc.
• Submitted several work around requests for updated requirements and delivered the vendor files.
• Accessed External files and created permanent SAS data sets.
• Targeting the people through emails, letters after data got pulled from the databases according to business requirements.
• Extensively used SAS MACROS for code reusability and used different options like SYMBOLGEN, MPRINT, MLOGIC for debugging.
• Analyzed data using PROC FREQ and PROC SUMMARY.
• Used ODS features for outputting SAS data into XLS, TXT and PDF formats.
• Parallel tested the DQI code and compared the data prior to implementing the code in production.

Environment: SQL, SAS/SQL, SAS EG 7.1, SAS GRID, SAS/BASE, SAS/ETL, SAS/MACRO, SAS, Teradata-SQL assistant, Oracle DB, VMware Horizon client, MS Office, Unix.

Confidential, San Diego, CA

SAS Data Analyst

Responsibilities:

• Provide analytical support/reporting on Marketing campaigns and test efforts (Returns On Investment (ROI) and Prepare data for processing, check for inaccuracies and create campaign tactics when applicable.
• Performed data analysis and development for the Customer Offers and Targeting team, using SAS Enterprise Guide, SAS Grid, Unix, Teradata, and Proc SQL.
• Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.
• Provide all monthly/weekly Key Performance, Trend, Post Campaign reports and analysis to measure effectiveness of marketing campaigns
• Buffer Integrated suite of web applications that offers intuitive, drag-and-drop interactions, rapid, highly visual responses, and role-based access to functionality is done by SAS Visual Analytics.
• Designed and developed data visualization and reporting solutions using MS EXCEL to make effective business decisions.
• Designing SAS Visual Analytics (VA) reports using VA Data builder, VA Explorer, VA Designer, VA Viewer and creating custom reports in SAS VA.
• Manipulated the data and modified the code wherever necessary using SAS functions and Proc SQL statements, formats, informats using SAS EG.
• Developed Python programs to support reporting activities and created new Python functions to improve the overall process.
• Development and execution of SAS/SQL code to define customer populations to be targeted in marketing campaigns.
• Worked with Data Prep team of Small business marketing for creating the data for various Marketing campaigns.
• Participated in marketing campaign list production including Direct Mail, Salesforce and Segmentation files for consumer, commercial and small business customers.
• Research data elements to be used for targeting using database metadata.
• Identify relationships and trends in data, as well as any factors that could affect result of the campaign.
• Audit campaign populations to insure marketing requirements are met.
• Work with business contacts to gather requirements needed for the campaign.
• Scheduled and automated the SAS jobs monthly using SAS EG scheduler task.
• Responsible for generating several adhoc operational reports using SAS EG for various business areas like the claims, enrollment, provider, customer advocacy, case management, finance areas.
• Generating SAS EG stored processes for product-specific analyses.
• Imported Data for analysis using Python to develop charts and visualizations to find anomalies.
• Developed SAS programs with the use of SAS EG and SAS/Macros for ad hoc jobs created reports based on the needs of the business users.
• Involved in writing code using Base SAS & SAS/Macros to clean and validate data from oracle tables.
• Involved in developing various fraud algorithms and validated existing algorithms against specification
• Used SAS import procedure to generate temporary and permanent SAS data sets from txt, csv and excel data sets.
• Developed new or modified SAS programs and used SQL Pass thru and Libname methods to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs.
• Solutions validated incoming data and performed notifications when jobs complete. The order data thus loaded into SQL server and was used to generate reports using SSRS
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Worked in highly pressured technical environment to extract, analyzed, transformation, loading and implement queries using SQL plus, Teradata SQL assistant and Oracle. Research Documentation and analysis.
• Performed data analysis and development for the Consumer Banking Data Management team, using SAS Enterprise Guide, SAS Grid, Unix/Linux, Teradata, and Proc SQL.
• Used SAS/SQL queries against the Teradata Data Warehouse (the 'W') and MDP, applying selection criteria and suppression/exclusion logic according to campaign requirements.
• Performed data analysis and development for the Customer Offers and Targeting team, using SAS Enterprise Guide, SAS Grid, Unix, Teradata, and Proc SQL.
• Validating data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT etc. and SAS ODS facility.
• Developed Unix Korn shell scripts to automate recurring processes and routine administration tasks.
• Extensively used statistical procedures such as ANOVA, Regression Analysis, Trend Analysis, Cluster Analysis and Principle Component Analysis.
• Design of ETL process to meet the requirement of data demand.
• Creating and maintaining required Data marts and OLAP Cubes using SAS DI Studio and SAS OLAP Cube Studio to fulfill reporting requirements.
• Production Job Scheduling using SAS DI Studio.
• Played a key role in data analysis and data modeling (model design, development, and model implementation) using SAS.
• Used procedures like PROC FREQ, PROC Means, PROC Sort, PROC Print, PROC Tabulate, PROC UNIVARIATE and PROC Report

Environment: Base SAS, SAS Macros, SAS EG, SAS/Access, SAS/ASSIST, SAS/STAT, SAS/GRAPH, SAS Visual Analytics(SAS VA), SAS/IML, ORACLE, SAS V9.1.3, SAS V9.2, Teradata, SAS Cube Studio, SQL, SAS Data Integration Studio, SAS Enterprise guide, Excel, Windows XP, UNIX.

Confidential, Baltimore, MD.

SAS Data Analyst

Responsibilities:

• Extracted the data from the files that are received as delimited and fixed files
• Extract data from IBM mainframe and create pipes delimited flat files and reports as per requirements. Analyzes data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC LOGISTIC, PROC REG, and PROC ANOVA.
• Constructed dashboards, reports, and analyses/forecasts of ad campaigns and marketing channels using Microsoft Excel and BI tools to help the Marketing Director improve adspend, freeing up numerous labor-hours per week while reducing our market response time.
• Created and optimized advertising campaigns on search engines, social media, display networks, auction sites, and eCommerce marketplaces.
• Developed and interpreted business requirements to create and execute Teradata SQL and SAS code extracting customer campaign lists for various direct marketing campaigns from the Confidential internal databases.
• Done Visual representation of reports using SAS Visual Analytics.
• Proficient in working with Base SAS, SAS EG and all the procedures which are in SAS.
• Generated Summary Tables, Listings and Graphs to support clinical study reports by using Base SAS, SAS/STAT, SAS/MACRO SAS EG and SAS/GRAPH.
• Prepared datasets by mining data from various data sources - SQL Server, DB2 using SAS Base, SAS EG, SAS/Access, SAS/SQL procedure.
• Used SAS EG in multi-user environment for intermediate data manipulation, analysis and summary statistics.
• Used SAS EG, Macros to develop dynamic SAS programs to extract, validate data for Statistical analysis.
• Performed ETL using SAS DI Studio 4.9 in Netezza environment
• Developed and maintained multivariate statistical models in Python to predict customer behavior and to profile customer potential.
• Developed risk and performance based reports using SAS VA
• Responsible to create and modify JCL and to create and run SAS Mainframe jobs and analyze SAS Mainframe reports. Works with internal and external users to define requirements and coordinated user management and developer expectations.
• Responsible for Extract, manipulate & load Flat files, VSAM files & Text files for IBM Mainframe O/S.
• Extensively worked on Korn Shell Scripts running certain daily jobs to modify them as per new ETL standards and process flow changes.
• Wrote Korn Shell Scripts performing various steps like running a SAS code, emailing the output files, removing and copying files, archiving files for historical data and zipping up files to send to external locations as attachments in emails
• Developed UNIX fast load shell scripts to schedule the load of vendor flat files on daily, weekly and monthly basis to corporate data warehouses
• Wrote reusable macros to automate the recurring reports in SAS, and also wrote Korn-Shell scripts for running SAS programs in batch mode on Unix
• Performed data analysis and development for Enterprise Marketing, using PC SAS, Unix, Oracle, Teradata, and Proc SQL.
• Wrote and modified UNIX shell scripts to accommodate the new process and methodology.
• Worked with various data like EBCDIC, ASCII and Binary formats and extensively used different kinds of in formats to read these data files.
• Extracting data from the database using SAS DI, SAS SQL procedures (using Oracle DB2 and Teradata), create SAS data sets, JMP Scripts which involved organizing, profiling and define metadata .
• Performing Data validation on OLAP cubes by running MDX Scripts and T-SQL Scripts
• Extensively written Teradata SQL Scripts for Data manipulation.
• Used SAS Macros and procedures like Proc SQL, Proc Transpose, Proc Univariate, Proc Means, Proc Freq.
• Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Teradata DB.
• Used SAS DI Studio to extract data from Oracle, Teradata and SQL server
• Extracted data coming from different corporate and perform Ad-Hoc queries using Teradata SQL Assistant.
• Converted the client’s data to standard format by using SAS formats, Date functions, Character functions, Numeric functions, special functions and SAS in-formats.
• Checked the validity of the received data from the facility or the physician.
• Analysis included data reports, logistic regression, generalized linear models, SQL queries to DB2 platform, variable distribution reports.
• Implemented reports to automate daily, weekly, monthly, and yearly jobs in production web environment by using of SAS IntrNet.
• Conducted QA for macros generated by other programmers using Macro options MLOGIC, SYMBOLGEN, MPRINT, MACROGEN etc.
• Created DB2 SQL stored procedures for updating tables in the database.
• Worked with JCL scripting and Korn Shell Scripting.
• Project execution on time while meeting strict timelines and budget requirements.
• Responsible for converting the business rules to SAS datasets and to load the data in to the data warehouse.
• Worked on ETL tasks for control and monitoring daily, monthly and quarterly jobs.
• SQL, PROC FORMAT, SAS data step merge, SAS statements and formats.
• Generate reports using PROC REPORT, PROC TABULATE and NULL data set option that are used by the decision making team.
• Worked with SAS/access engine and proc import for retrieving and importing the data.
• Involved in writing code using BASE SAS and SAS/Macros to extract clean and validate data from oracle tables.

Environment: SAS/BASE, MACROS, SAS EG, SAS/ACCESS, SAS VA, Teradata, MS Excel, ETL, UNIX, Windows NT, Windows XP, ORACLE, IBM Mainframe

Confidential, Overland Park, Kansas

SAS Programmer/Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering of SAS reporting new and existing codes.
• Gathering requirements and documentation for unit test case development and defining and documenting the integration testing of new applications.
• Maintained performance reports, creation of reports for online and batch application of various servers and involved in preparing executive Dashboards for senior level management.
• Used SAS, SAS/Macros, Procedures like SQL, Freq, Summary, Means, Transpose, Arrays, Tabulate and Sort to extract data, Prepare integrated data base and its analysis.
• Analysis included Behavioural Model, Customer Profiling, Trend Analysis, Predictive Modeling.
• Construct campaigns using a combination of Unica campaign, SQL based on inputs from the campaign owners
• Extracted data sets from server using Proc Import and created datasets in SAS libraries, Coding SAS Programs with the use of SAS/Base and SAS/Macros for ad hoc jobs.
• Developed programs to created daily HTML reports using ODS and CSV reports using Proc Export.
• Worked with SQL, Macro and DI Studio ETL processes, extracted transformed and loaded data, mapped, scheduled and submitted job to Unix and Teradata environment.
• Created views on Oracle tables and indexes on SAS datasets to enhance the speed and performance of the SAS programs.
• Created shell scripts which would take arguments from the command line and create subdirectories to store the listing files, output files and graphs.
• Developed web-based reports, scorecards, and dashboards using SAS Information Delivery Portal, Web Report Studio, BI Dashboard, Stored Processes, and SAS Server pages.
• Developed methods to streamline analysis and present business critical information through a combination of SAS BI dashboards and web-based reporting.
• Assisted with the creation, support and scheduling of SAS programs within the reporting infrastructure.

Environment: SAS 9.1.3, SAS/BI, SAS/DI Studio, Olap cube, Information Map Studio, SAS/Base SAS/Macros, SAS/Access, SAS/Connect, SAS/SQL, SAS VA, SAS/Enterprise Guide, Oracle, DB2, Windows and Linux, Unix-AIX 6.1, Teradata, SAS forecast Studio.

Confidential, Delaware

SAS Analyst

Responsibilities:

• Analysis and testing Requirements.
• Created Test Cases for the team
• Created various scenarios to verify and compare results between two systems
• Report defects and discuss details with Project managers
• Responsibilities included interaction with subject matter expert, and preparation of test plan, which specifies testing overview, testing approach, testing strategy, roles and responsibilities and scope of testing.
• Write, track, manage, execute and prioritize Test Cases.
• Creation and maintenance of Test Reports & Test Data.
• Attended weekly status meeting and provide detailed status report
• Involved in Test Plans and Test Cases.
• Good working knowledge on web services.