SUMMARY

• 7 years of professional work experience in Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Application Development and Reporting with SAS.
• Understanding of the client’s vision, goals, limitations, data sources and time lines.
• Knowledge of health care data systems and clinical coding.
• Work experience with SASand/or SQL creating queries, extracting and analyzing large data sets.
• Programming experience in EDC(Rave) andSAS, PL/SQL.
• Experience in utilizing SAS Procedures (PROCREPORT, PROCFREQ, PROCTABULATE, PROC MEANS, PROCSUMMARY, PROCAPPEND, PROCTRANSPOSE, PROCEXPORT, PROCIMPORT, PROC FORMAT, PROC UNIVARIATE, MERGE and SET statements.)
• C, Python 2.x,KornshellGit source control, Linux programming at the system call level.
• Extensive experience transferring data across platforms (Mainframe, Unix, PC) based on the business and reporting needs.
• Vast experience in presentation using SAS, Excel, PivotTables, DDE for presenting the end results.
• Hands on experience with SAS/BASE, SAS/MACRO, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT and SAS/ODS procedures.
• Report generation on providers using Proc Tabulate, Proc UNIVARIATE, Proc MEANS and Proc REPORT.
• Proven skills in SAS Base (data step and proc) and SAS Macro fulfilling on demand business needs.
• Good at understanding ofSAS data warehousing tool SAS Data Integration Studio.
• Advanced SQL skills with ability to code complex queries to load, clean, format & store data.
• Working knowledge of Teradata, Data Management, VBA and Tableau.
• Clear understanding of data modeling principles like star and snow - flake schema, dimensional data model, 3nf etc.
• Experience working with data in regional databases andadvanced knowledge of SQLandrelational databases.
• Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data.
• Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, Clustering etc to gain insight into the data.
• Skilled in analytical and business reporting using SAS, MS Office, VBA and RDBMS technologies.
• Experience working in visualization - SAS Visual Analytics.
• Experience in loading SAS Metadata Server with metadata from external packages for ETL development.
• Experience in coding mathematical expressions in SAS as per the requirement using legacy and new functions.
• Extensive experience in Teradata tools & utilities like SQLAssistant, BTEQ, FastExport&TPump for business analytics and reporting on massive Enterprise Data Warehouse.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Vast experience in presentation using SAS, Excel, PivotTables, DDE for presenting the end results.
• Good Knowledge of statistics and drug development process
• Excellent proficiency in programming with SAS
• Experience working with CDISC SDTM and ADaM compliant data sets
• Knowledge about Migration ofReports from Cognos 8.2 to 8.3.
• Strong skills in requirements gathering, analysis and ETL design, coding, debugging.
• Coding SAS programs with the use of SAS/BASE and SAS/Macros for Ad-hoc reports.
• Developed SAS macros to create tables, graphs and listings.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data.
• Good knowledge in scripting T-SQL Queries, complex Stored Procedures, User Defined Functions (UDF) and database Triggers.
• Minimum time to self-sufficiency in any environment.
• Excellent communication and report writing skills, with the ability to effectively communicate results of analytics to diverse audience.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.

TECHNICAL SKILLS

SAS Tools: SAS 9.3, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS SAS/CONNECT, SAS/GRAPH, SAS/ENTERPRISE GUIDE, SAS OLAP CUBE STUDIO, SAS/ENTERPRISE MINER, SAS/INFORMATION DELIVERY PORTAL, SAS VA,SAS DI.

Databases: Oracle 9X/8.x, MS SQL Server 2000/2005, Teradata 12/13.x DB2, MS Access, Informix

Commercial Tools: Informatica, Expediter, FileAid, Rapid SQL, Crystal Reports, Hyperion, ERWin, Roscoe, RCS.

Operating System: WINDOWS XP/NT/Vista, UNIX(AIX), MVS.

Programming Languages: C, C++, SQL, VBA, VB 6.0, Java, HTML, XML, Bourne Shell

Reporting tools: Crystal Report, Hyperion, MS SQL Server Reporting Services, Tableau, Cognos.

PROFESSIONAL EXPERIENCE

Confidential, Menomonee Falls, WI

SAS BI ANALYST

Responsibilities:

• Performed data extraction from multiple sources like Teradata, Facets.
• Extensive use of SAS, SQL, Teradata by handling complex joins and conditions.
• Proficient in SAS Procedures.
• Automating the existing SAS Code by upgrading the performance and efficiency of the code.
• Had dealt with VBScript in the code.
• Authored SAS programs using macros, SQL for data management.
• Conducting Ad-Hoc reports when and ever required and delivered under extreme time limits.
• Proficient in using Base SAS, SAS EG.
• Used SAS Data Integration Studioto develop various job processes for ETL (Extract, transform and load) data warehouse database.
• Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROC FREQ, PROC CONTENTS and PROC DATASETS to generate different reports and run metrics on different data sets
• Created dynamic Macro arrays by SQL and with data step programs.
• Developedefficient,well-documented,readilycomprehensibleandmodifiableSAScodeusingSAS/Base and SAS/ Macro facility.
• Reports Generation in PDF and EXCEL.
• Assisting other team members in clarifying their queries if required.

Environment: SAS 9.3, ENTERPRISE GUIDE 5.1, SAS Information Map Studio, CISCO TIDAL, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, SAS/REPORT, SQL Server,SAS Visual Analytics,SAS Grid,SAS Data Integration Studio (ETL tool) 4.4,UNIX, UltraEdit, IBM Tivoli

Confidential, Houston, TX

SAS BI ANALYST

Responsibilities:

• Performed data extraction and data management from multiple sources
• Developed and implemented strategies to integrate data from over 40 loan-servicing organizations into theSAS data warehouse
• Streamlined existing SAS code for table look-ups
• Created an automated monthly forecast report for dollars and number of accounts that rolled from current to delinquent using SAS/Macro,ExcelandVBA
• Compiled datasets for building attrition and risk models inSAS
• Performedad hoc analysisof data sources for all external and internal requirements
• Participated in refinement and technical documentation of database reporting requirements
• Analyzed the loan data to generate portfolio statistics report usingSAS, summarizing accounts by Fico bucket, market segment and account status
• Created analytical reports that drills down various performance metrics of existing collection strategies by key collection performance drivers including debt balance, recovery score, payment history and demographics
• Formulated procedures for data extraction, transformation and integration of mortgage data
• Conducted assessment to ensure data quality and completeness with validation techniques
• Participated in critical review and revision of existing systems for updates and enhancements
• Extensively usedSAS on UNIXplatform to develop custom business solutions
• Collaborate with business area to understand business needs, capture supporting requirements and resolve issues
• Involved in creating Data Marts and performing data validation for scorecard modeling and customer segmentation using logical/physicalDMandTeradata-ETLprocedures
• Extracted metrics for Risk Management team fromTeradataserver usingPROCSQLinSASand modified it usingBase SAS andSAS Macrosto present in required format
• Convert business requirements into technical specifications using available tools and technologies
• Design the needed aggregations, transformations and mapping of the data entities to suite the build and execution phases of the applications
• Maintain and contribute to the modulated software development environment for loss prevention
• Work individually and as part of a team to put forth ideas pertaining to technical and analytical solutions
• Routinely deal in with large internal and vendor data and perform performance tuning, query optimizations and production support forSAS, Oracle 11g
• Responsible for troubleshooting and delivering outputs usingPROD/DEV/QAenvironments
• Develop test cases/plan for individual project assignments of Loss Prevention reporting using ID Portal
• Involved in preparing Data Quality Review Plan (DQRP) to adhere to the internal specifications
• Provide production support and retrospective version control on the application on ad hoc basis
• Implement the needed fuzzy logic in pattern mapping and segregation of the customer profiles using SAS programming techniques

Environment: SAS 9.3, ENTERPRISE GUIDE 5.1, SAS Information Map Studio, CISCO TIDAL, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, SAS/STAT, SAS/REPORT, SQL Server, UNIX, UltraEdit, IBM Tivoli

Confidential, Mount Laurel, NJ

SAS PROGRAMMER

Responsibilities:

• Used SAS and SQL to perform ETL from Oracle and Teradata databases and created SAS datasets, SAS Macros, Proc/data steps and SAS formats as required.
• Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets.
• UsedSASPROCSQLpassthroughfacilitytoconnecttotablesandcreatedSASdatasetsusingvariousSQL joins such as left join, right join, inner join and full join.
• Data processing and validations were done extensively on the SAS datasets using edit check programs.
• Developedreportsasperbusinessrequirementsandcreatedvariousreportslikesummaryreports,tabular reports, excel reports etc.
• Converted programs from Teradata SQL to SAS to automate the monthly production processes.
• Developed new/modified macros for report generation using SAS/Macros as per business requirements.
• Developing and analyzing key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL .
• Designed and created SAS datasets from various sources like Excel datasheets, flat files, Oracle.
• Worked on various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS Etc. to develop solutions.

Environment: SAS/ODS, SAS9.2, SAS Grid, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/Access, SAS/ Connect, SAS/Stat, Teradata, MS Excel, MS Access

Confidential

SAS PROGRAMMER

Responsibilities:

• Modified data using SAS/BASE and Macros.
• EmployedtechniqueslikesortingandmergingontherawdatasetsandcodedthemusingProcSQLand
• SAS Macro facility to get the required output.
• Prepared graphs using the modified data for business analysis.
• Used SAS/ACCESS to gather data from RDBMS like TERADATA.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used to update reports.
• UsedSASDataIntegrationStudiotodevelopvariousjobsprocessesforextracting,cleansing,transforming, integrating, and loading data into Data marts and Data warehouse database.
• 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 reports.
• SAS scripts on UNIX are run, and the output datasets are exported into SAS.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Maintained SAS statistical analysis for the products purchased every month.
• Run reporting programs and download the results into EXCEL and build pivot tables.
• Presented the results and statistical reports in PowerPoint for marketing staff.

Environment: SAS/BASE,SAS/STAT,SAS/SQL,SAS/MACRO,SAS/ACCESS,SAS Data Integration Studio,SAS/ODS,MSAccess,Excel, TERADATA.

Confidential

SAS PROGRAMMER

Responsibilities:

• Provided ad-hoc data analysis and reporting support for Sales and Marketing using Base SAS.
• Developed SAS/MACRO to standardize the report and chart generation for re-use with PROCTABULATE, PROCREPORT, and PROCAPPEND etc.
• SASMacroswasusedingeneratingreportswithlargebutrepetitiveprograms,whichonlyrequirevariable changes were run in loops to save time and effort.
• Wrote Macros in SAS to develop a concise code for data cleaning and reporting.
• Developed SASmacros to create tables, graphs and listings.
• Created SAS customized files in HTML, PDF, RTF and Flatfiles using the DATA NULL technique.
• Created reports with multiple graphs and chart displays into a single Excel spreadsheet.
• Created individual RTF files for summarizing the results and also to document the metadata.
• Performed data manipulations on data stored in Oracle using SQL Assistant and PROCSQL.
• Used SAS/ODS for effectively deliver the outputs in HTML and PDFformats.
• Imported SAS data from Excel and Txtfiles to SAS Datasets.

Environment: SAS V6.12 (Base, Macros, SQL), SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/STAT, Excel, Access, Oracle 8i, PL/SQL, UNIX, Windows NT