SUMMARY

• SAS Programmer with over 7 years’ experience in research, development and implementation of various applications for teh pharmaceutical and CRO industries.
• Proficient in variousSAStools likeSAS/Base,SAS/Stat,and SAS/GRAPH.
• Good experience in storing and manipulating data inSASfiles by MERGE, JOINS, COMBINING, SORTING, TRANSPOSING AND FUNCTIONS LIKE CHARACTER, NUMERIC, DATE, TIME, CONVERSION FUNCTIONS etc.
• Worked with teh management team and teh client to understand teh technical specs and requirement gathering and then presenting teh reports.
• Hands on experience in using quantitative approach to solve analytical problems.
• Prepared technical specs for project. Designed logical flow of SAS programs to validate teh requirements.
• Hands on experience with SAS/BASE, SAS/MACRO, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT and SAS/ODS procedures.
• Experience in utilizing SAS Procedures (PROCREPORT, PROCFREQ, PROCTABULATE, PROC MEANS, PROCSUMMARY, PROCAPPEND, PROCTRANSPOSE, PROCEXPORT, PROCIMPORT, PROC FORMAT, PROC UNIVARIATE, MERGE and SET statements.)
• Extensive experience transferring data across platforms (Mainframe, UNIX, and PC) based on teh business and reporting needs.
• Vast experience in presentation using SAS, Excel, PivotTables, DDE for presenting teh end results.
• 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.
• Experience in loading SAS Metadata Server with metadata from external packages for ETL development.
• Experienced in MS SQL Server configuration, performance tuning, client/server connectivity, query
• Designed several ETL jobs using SAS DI Studio to port teh ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging teh final data
• Good knowledge in scripting T - SQL Queries, complex Stored Procedures, User Defined Functions (UDF) and database Triggers.
• Experienced in Oracle supplied packages, dynamic SQL, records and PL/SQL tables.
• Conceptual knowledge of marketing mix, segmentation and association rules, market basket analysis, test and control groups, sample size criteria, hypothesis testing etc. in marketing domain.
• Experience in loading SAS Metadata Server with metadata from external packages for ETL development.
• Involved in preparing and reviewing BRD, FRD documents to serve development and reporting.
• Experience in coding mathematical expressions in SAS as per teh requirement using legacy and new functions
• Extensive experience in Teradata tools & utilities like SQL Assistant, BTEQ, FastExport&TPump for business analytics and reporting on massive Enterprise Data Warehouse
• 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

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

PROFESSIONAL EXPERIENCE

Confidential, West Hartford, CT

SAS BI Analyst

Responsibilities:

• Developed programs using teh Libname statement &SAS Views to extract & report error statistics
• Developed teh Spectrum Business Credit Score application. Calculated teh coefficient factor using selected Experian Credit data elements to derive teh business risk score.
• Updated business specifications, created system flow charts and prepared test plans.
• Used Microsoft Access and Excel to provide output analysis data
• Imported data from SQL Server and Excel to SAS datasets. Performed data research forecasting models into production by using Base SAS, SAS Macros, PROC SQL and many other SAS tools
• Assisted architecture team in moving layers of teh EDW from Oracle to Teradata for using SAS In Database technology
• Analytical function applied across data in multiple sources (Hadoop, Teradata and Excel).
• Wrote Teradata code / SQL to enable teh ETL processes to meet demanding business requirements, including BTEQs, Fast Loads, Multi Loads, and Fast Exports
• Involved in establishing connections to different data sources (SQL Server, Vertica, Teradata, SAP, Salesforce, Azure Cloud, and web site data) and pulling relevant data from these source systems for data modelling.
• Used SAS datasets to create reports using Proc Print and Reports. Also used Proc Transpose, Proc Tabulate, Proc Import, Proc Freq and Proc SQL
• Performed teh automated data driven testing using WinRunner
• Performed functional, GUI, and Security testing using different checkpoints with teh WinRunner scripts
• Generated parameterized reports and cascaded parameterized reports.
• Executed data validation Stored Procedures in SSIS Packages in Business Intelligence Development
• Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call
• Performed detail analytics while producing financial reports so that teh financial data is checked and are accurate
• Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets

Environment: SAS/BASE, SAS/ODS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, TOAD, UNIX, MS SQL Server, Teradata 12, 13.x SQLPLUS, Java and ULTRA Edits

Confidential, Jefferson City, MO

SAS Consultant

Responsibilities:

• Integrated business needs and technology solutions to solve data and reporting challenges.
• UsedSAS Data Integration Studioto build DataMarts from enterprise data sources instructor based course from SASInstitute.
• Developed and maintained daily, weekly, monthly processes.
• Designed, developed, and programmed, daily dashboard reports.
• Streamlined existing SAS code for table look-ups.
• 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.
• Wrote different joins and merges to create reports based upon teh requirements given.
• Used PROC IMPORT to convert raw data files in different formats to SAS data sets.
• Combined data vertically using SET statements, PROC APPEND and SET operators in PROC SQL.
• Developed SAS Macro programs to create Ad-hoc reports.
• Automated SAS processes on UNIX to deliver data.
• Utilized SAS/ODS to create reports in PDF, RTF and HTML format.
• Presented SAS papers in SAS conferences.

Environment: SAS 9.2/9.3, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 4.3/5.1, SAS Add-In for Microsoft Office, SAS Stored Processes Web Application, SAS Data Integration Studio (ETL tool)4.3/ 4.4 SAS Web Report Studio SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Management Console 9.2, Windows

Confidential, NYC, NY

Audit Software Professional/SAS Consultant

Responsibilities:

• Strongly served teh data requests of varied nature pertaining to operational risk, management risk, policy enforcements, regulatory oversight, Investor portfolio management.
• Adeptly performed Data Management for teh Business Unit: data profiling and cleansing of business unit's assets data using SAS.
• Served as a direct point of contact with teh end user to understand teh requirement and develop technical solutions to deliver in terms of quality, time and accuracy
• Automated teh creation of Excel pivot tables from SAS data sets using SAS/Macro and VBA
• Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
• Developed SAS stored procedures and views to provide BI analysis and insights
• Involved in developing and maintaining documentation of operational processes and data mappings
• Used Excel templates and VBA to generate custom reports from data in SAS tables.
• Worked on modifying teh screen definition files to update teh content of teh screens that are presented onSASModelRiskManagement
• Modifying or adding newdimensionson theSASModelRiskManagement based on requirement from end-users
• Coordinated teh comprehensive deployment ofSASModelRiskManagement on compute, metadata, mid-tier and VA servers in consultation withSASInstitute PS(Professional Services).
• Prepared several regulatory reports in standard formats as specified using SAS
• Involved in fine tuning teh code to reduce teh churn time and improve teh efficiency
• Designed and coded ETL processes with varied source systems like Oracle, SQL Server and flat files
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
• Coded extremely complex SAS Data step and procs including teh advanced techniques and teh use of teh available options to serve teh ever evolving and dynamic business reporting needs
• Involved in creation of flat files out of database tables
• Involved in aggregating data residing on teh vast network of distributed servers with all forms of data storage
• Tested JCL and PROCS for Auto Reconciliation jobs for a month and compared reports, flat files and VSAM files from test and production environments
• Extensively used SAS/DDE to generate formatted Excel sheets maintaining data integrity from SAS output data sets
• Exported large SAS data sets (more than 300 variables) to MVS external files to be sent to external vendors using SAS and SAS/Macro
• Hands on experience in moving SAS data sets from UNIX to PC environments using FTP.
• Used SQL Pass thru method to load teh manipulated data from DB2 tables into SAS data sets
• Developed an application using Base SAS, SAS/Macro, Proc SQL and Proc Contents to generate concise data profiling reports

Environment: Microsoft SQL Server 2012/2008/2005 , SAS 9, SAS/SQL, SAS/MACROS, SAS/BASE, SAS/GRAPH, Teradata 12, 13.x SAS/STAT, SAS/ETL, TSO, MVS, VSAM, DB2, Teradata, SAS/ENTERPRISE GUIDE, ISPF, VBA

Confidential

SAS Programmer

Responsibilities:

• Modified data using SAS/BASE and Macros.
• EmployedtechniqueslikesortingandmergingontherawdatasetsandcodedthemusingProcSQLand
• SAS Macro facility to get teh required output.
• Prepared graphs using teh modified data for business analysis.
• Used SAS/ACCESS to gather data from RDBMS like TERADATA.
• Coordinating teh 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 teh use of SAS/BASE and SAS/Macros for Ad-hoc reports.
• SAS scripts on UNIX are run, and teh output datasets are exported into SAS.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Maintained SAS statistical analysis for teh products purchased every month.
• Run reporting programs and download teh results into EXCEL and build pivot tables.
• Presented teh 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, MS Access, Excel and TERADATA.

Confidential

Data Analyst

Responsibilities:

• Developed programming to extract and manipulate data
• Created reports that provide teh insightful analysis to business to optimize teh high volume decisions
• Used Proc SQL Libname and PROC SQL Pass-through methods to access data on Oracle database
• Validate and test all code for accuracy and efficiency and moved it into Production
• 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
• Conducted Ad Hoc analysis to support business strategy
• Developed SAS programs based on teh draft spec document
• Delivered reports via portal using BI tools like SAS Enterprise Guide and Stored Process Web Application
• 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
• Wrote different joins and merges to create reports based upon teh requirements given and Written time and resource efficient code using PROC SQL
• Created adhoc reports and complex enterprise reports (drill down, drill through reports, parameterized
• Conducted database management, performance measurement and performance tuning for newdatabases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and Index Tuning Wizard.
• Reports and cascading report) using SQL Server Reporting Services and Report Manager.
• Analyzed teh transformed data using SAS BI tools such as SAS Enterprise Guide 4.2, 5.1 and SAS Add-in for Microsoft Office.

Environment: SQL Server 2008/2005, SAS/BASE, SAS/ODS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, TOAD, UNIX, MS SQL Server, SQLPLUS, Java.