PROFESSIONAL SUMMARY:

• Sr. Data Analyst/SAS Programmer with 7 years of experience in design and model development using SAS to compile and analyze large data sets including data step processing, data mining, data manipulation, macro creation, data transformation, variable construction & optimization
• Extensive exposure on every steps of entire project life cycle including data collection, query, modifying and analysis, summary of findings, communicating strategic insight and presentation of results and documentation of the processes.
• Extensive experience in arranging and participating in meetings with Business Users and suggesting recommendations for improving system performance.
• Proficient in SAS/Base, SAS/Macros, SAS/Connect, SAS/SQL and SAS/ODS.
• Proven skills in, data archival, data migration, ad - hoc reporting, and coding using SAS on various environments like Windows & UNIX.
• Worked with SAS Procedures such as PROC SQL, PROC REPORT, PROC ACCESS, PROC SORT, PROC TRANSPOSE, PROC MERGE, PROC PRINT, PROC REPORT, PROC TABULATE etc.
• Involved in all stages of SDLC (Software Development Life Cycle).
• Extensively worked on various RDBMS like Teradata, Oracle, DB2 and SQL Server.
• Knowledge and experience in Microsoft Office tools like MS Access, MS SharePoint, MS word, MS PowerPoint, MS Excel.
• Experienced in using SAS ODS to create RTF, HTML, PDF, CSV files.
• Hands on experience writing UNIX shell scripts and automating job using Crontab.
• Proven abilities in establishing effective task priorities as a team player with result oriented attitude.
• Experience working with large database to perform complete data retrieval, manipulation using multiple input files using SAS data steps
• Generated summary reports using Excel PIVOT Tables.
• Excellent leadership, communication, analytical, problem solving skills

TECHNICAL SKILLS:

Statistical Software: SAS V9.3, Base SAS, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ODS,SAS/ACCESS, SAS/STAT, SAS Enterprise Guide, SPSS, R, Minitab, Tableau

Programming Languages: Visual Basic 6.0, FoxPro, PL/SQL

RDBMS: Teradata, Oracle9i/10g/11g, MySQL, SQL Server 2012,MS Access

Operating Systems: Windows 8, Windows XP, Mavericksand Unix.

Office Tools: MS Office 2013(Access, Excel, Word, PowerPoint, Outlook), MS Visio

SAS Procedures: Print, Frequency, Means, Summary, Tabulate, Chart, Gchart, Plot, Gplot, Univariate, Corr, Contents, Append, Datasets, Format, Sort, Transpose, Report, SQL, ANOVA, REG, Logistic, GLM, Macro, Import/ Export

WORK EXPERIENCE:

Sr. SAS Programmer

Confidential, Wilmington, DE

Responsibilities:

• Conducted comprehensive analysis and evaluations of business needs and provided analytical support for policy and process change recommendations to quantify financial, operational and reputational impacts to influence decisions.
• Worked with Operations partners and leaders to ensure new developments will be deliverable and executable in an Operations environment, generated complete and accurate category reports, developed crosstabs, summary spreadsheets, pivot tables, v-lookups and charts etc.
• Built automated controls in SAS to monitor daily and monthly call limits at account and customer level
• Created data schema and architecture of data warehouse for standardized data storage and access
• Used Unix SAS, SQL, Oracle, Teradata and MS Office analysis tools to complete analysis requirements
• Created SAS data sets by extracting data from Oracle database and flat files using Proc SQL, Proc Import, SAS Data Step, cleaned, validated and manipulated data by SAS and SQL.
• Analysis, programming and creation of reports on existing strategies using SAS and SQL. Merging large data sets according to the requirement, generate the reports using SAS/ODS and analyze those results.
• Receive, validate, and manipulate customer data information for file uploads from all inputs as well as support data extractions for campaigns, reports, and analysis.
• Designed, implement, track, and report on new strategies in a Test vs. Control environment and followed a disciplined analysis approach to ensure recommendations taken to Senior Management result in correct decisions.
• Standardized on-going reports and created ad hoc reports.
• Perform updating data by weekly and monthly and maintain, manipulating the data for database management. Used the SAS/MACROS for the monthly production.
• Worked on credit risk analysis to figure out the customers to offer new Credit Cards. Helped the analytics and data services for the development of the new business logic.
• Coordinated with other team, technical assistance and trouble shooting and attending project team meetings. Supported Project Teams as assigned during project life cycle.

Environment: SAS 9.2, SAS Enterprise Guide 4.2, SAS/Macros, SAS/Graph, SAS/Access, SAS/STAT, SAS/ODS, SAS/SQL, Oracle 11g, MS Excel, Shell Scripts, UNIX, TSYS,Autosys & Windows.

Confidential, IL

Sr. Data Analyst - SAS

Responsibilities:

• Analyzed company’s data and identified threshold for mailing marketing materials.
• Evaluated census variables and segmented zip code in US based on major demographics.
• Carried out factor and K-means cluster analysis using SPSS and found out important factors that influence.
• Developed various modeling techniques such as Linear Regression, Logistic Regression, CART, Random Forest, and MARS - compared their performance using decision tree and gains chart.
• Proposed MARS modeling technique to contact prospects who are most likely to buy insurance within the marketing budget that produced 75% more in incremental revenue.
• Reduced mailing quantities by 25% and still able to get 89.6% of the total sales and also suggested alternative cut point for maximum sales.
• Extensively used and created SAS/Macros for the efficiency and accuracy. Implemented best programming practices to meet the industry standards and for easy debugging.
• Debugged existing macro code to find and fix the issues in the current reports. Created new macros to automate the creation of daily, weekly and monthly reports based on the time stamp of the data.
• Store and distribute results in different formats HTML, PDF, RTF using SAS ODS, PROC REPORT.
• Created and automated SAS scripts that run at specific schedule and email the results to stakeholders.
• Implemented data cleaning techniques using PROC FREQ, PROC PRINT, DATA NULL, PROC MEANS, PROC TABULATE, and PROC SQL.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Used existing UNIX shell scripts and modified them as needed to process SAS jobs, search strings, execute permissions over directories etc.

Environment: SAS 9.2, Windows 7, UNIX AIX, Base SAS, PC SAS, SAS/SQL, SAS/GRAPH, MS Excel, database Oracle.

Confidential, MA

SAS Analyst

Responsibilities:

• Investigated missing data and data anomalies in SAS data sets.
• Wrote analysis plans including specifications for tables, listings, and graph.
• Manipulated large data sets, data validation and corrections, uploading/downloading data from multiple sources.
• Created graphs using PROC PLOT. Created permanent formatted SAS data sets for present and future analysis, infilling several datasets and sorting and merging by common variables.
• Developed reports using DATA NULL and PUT statements.
• Write macros to improve efficiency of the SAS programs.
• Create listings, tables, and graphs using SAS procedures.
• Created UNIX shell scripts for job automation.

Environment: SAS/ODS, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/Access, SAS/Connect, SQL, MS Excel, Shell Scripting, Windows & UNIX.

Confidential

SAS Data Analyst

Responsibilities:

• Extracted, transformed, and loaded data using SAS.
• Wrote macros to develop a concise and reusable code.
• Converted large data from Oracle to SAS data sets by using SQL pass through and Libname facility.
• Wrote queries on the existing Oracle databases server to provide ad-hoc reports using SAS/SQL.
• Extensively used PROC PRINT, PROC REPORT and PROC TABULATE for reporting.
• Merged the datasets to provide the users with the data in the required form.
• Interacted with other team members and lead to discuss the required developments to be made in coding to improve the functionality and effectiveness.
• Generated analysis reports, graphs using SAS/Reports and SAS/ODS to produce Excel and HTML reports.
• Created ad-hoc reports and graphs as per the requirements of the users
• Submitted SQL Queries and SAS codes in UNIX shell to validate data.

Environment: SAS/BASE, SAS/GRAPH, SAS/ACCESS, MS-Excel, SAS/ODS, Oracle, UNIX and Windows NT.