SUMMARY

• SAS data analyst with around 4+ Years of experience in the IT industry, specializing in SAS language.
• Worked on SAS/Base, SAS/Stat, SAS/SQL, SAS/Graph, SAS/Access, SAS/Connect and SAS Macros.
• Excellent command in producing reports employing various SAS Procedures and handling large databases to perform complex data manipulation using multiple files in SAS data steps.
• Created RTF, PDF and HTML listings, tables and reports using SAS ODS
• Compiled statistics, created detailed reports and graphs for management and customer
• Queried data from the host using the SAS PROCSQLpass through facility
• Used SAS to read from and write to another data files formats, including delimited files, DBF, MDB, Spreadsheet files and tab files.
• Developed SAS code to clean up invalid data from the database.
• Modified existing SAS Programs and created new programs using SAS Macro variables to improve ease and speed of modification as well as consistency of results
• Performed Data analysis using SAS, MS Excel, and MS Access.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Involved in Database Programming using Oracle,SQLServer.

TECHNICAL SKILLS

• UNIX
• Windows 7/8/8.1/10/Vista
• Linux
• MS Office Suite (Word
• Excel
• Outlook
• PowerPoint)
• MATLAB
• C/C++
• SAS SAS 9.X
• SAS 8.2
• (Base
• Stats
• Access
• Macros
• Connect
• Graph)SAS Procs Reports
• Print
• Means
• Summary
• Univariate
• Corr
• Tabulate
• Freq
• Compare
• Chart
• Sort.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

SAS/DataAnalyst

Responsibilities

• Created, Managed and Lead a large team for EDW integration/consolidation for performingdata analysis anddataquality testing
• Createddataquality testing strategy, managed multiple stakeholders, established process ondata quality testing
• Lead otherdatainitiatives like metadata creation & management,dataaccesses, end user migration and training.
• WroteSASprograms in UNIX platform.
• Responsible for importing, manipulating and generating weekly and monthly list reports usingSAS Enterprise Guide systems by using variousSASmacros and standard programming procedures.
• UsedSASextensively for Match merge, Appenddatavalidation, andDatacorrection and Cleansing.
• Run reporting programs and download the results into EXCEL and build pivot tables.
• Enhanced the functionality in database anddataware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Worked closely withdatamodelers for designing fact and dimensional tables, providingdataprofiling inputs, sharing metadata
• Extracteddatafrom Oracle and loadeddatainto Teradata for Reporting purpose.
• Proposed, lead the effort for the establishing the effort for thedataquality engine at theETLlevel.
• Generated customized reports using PROC REPORT, PROC TABULATE and PROC SQL.
• UsedSASDataStep logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis ofdata
• Assisted in investigating and applying newSASprogramming methods and techniques to enhance current systems.
• UsedSASODS to create HTML, RTF and PDF outputs files in the process of producing reports
• UtilizedSASto develop BOFA Home Mortgage proprietary tools which allowed systematic approaches to analyze the relative risk of two production populations based on mix adjusted attributes.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Assessment of thedataquality for masterdataand other transactionaldata, business rules collections atdatalevel by interacting with the business, creatingdataquality assessment framework, creatingdatasets, profiling thedata,datamining and takingdatadecisions to help the business.
• Supporting the IT project teams fordatamanagement requirements (metadata,data quality/retention/access management/training/datasanity/masking/PII/ NPI/ CreditData).
• Helped business users to migrate to newdataenvironment, helped them migrate analytical reports
• Lead effort on multipledataremediation challenges rising due to largedatamigration anddata mismatches between OLTP and new warehouse

Environment: SAS/Macros, PCSAS,SAS/SQL, Business Objects,SASEnterprise Guide,SAS/ACCESS,SAS/STAT, Visio.

Confidential, Tampa, Florida

SAS Programmer

Responsibilities

• Created and maintained SAS Datasets that are extracted from Pipe delimited Flat files.
• Mapping variables, defined variables, merging datasets and created derived datasets.
• Created HTML listings, tables and reports using SAS ODS
• Extensively used Base SAS, SAS/SQLand SAS/Macros.
• Creating summary Reports and Tabular Reports using Proc Report and Proc Tabulate.
• Created tables usingSQLquires and customized reports using ProcSQL.
• Validated summary tables, listings, datasets and graphs.
• Generated tables, which also involved in analyzing data and generating reports.
• Created datasets from flat files, excel worksheets.
• Extensively used procedures like Proc Export, Proc Summary, Proc Means, Proc Tabulate, Proc Datasets, Proc Freq, Proc Report and Data Null and other statistical procedures.
• Prepare test cases & perform Unit / Integration / Regression Testing. Assist Business during UAT.

Environment: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/Enterprise Guide, Oracle, Proc Print, Proc Report, Proc Export, Proc Import, Proc Means, Proc Sort, Proc Summary and ProcSQLetc.

Confidential

Data Analyst

Responsibilities:

• Divided company announcements into 9 main categories and more than 100 subcategories according to their business characteristics.
• Retrieved stock price data from the company database for data preparation.
• Modified data using SAS/BASE, SAS/SQL and Macros according to project specifications.
• Used PROC STDIZE to impute missing values.
• Performed complex statistical analysis using PROC UNIVARIATE to check the data distribution of normality.
• Conducted hypothesis tests to examine the impact of company announcements with PROC UNIVARIATE, PROC FREQ, PROC TTEST
• Developed SAS Macros to simplify SAS code and effectively reduce coding time.
• Troubleshoot, diagnose of issues raised by data manipulation.
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, SUMMARY and DATA NULL for producing statistical reports.
• Used SAS/ODS facility to create customized reports in HTML, PDF, RTF.
• Documented data reports and model results, communicated with the team manager to share the information in a timely manner.
• Involved with key departments to discuss the primary model requirements for the project.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, MS Excel.