PROFESSIONAL SUMMARY:

• SAS Architect with 11 years of IT experience that includes analysis, design, development, testing and implementation of applications in Financial, Telecom and Healthcare Industries.
• Technical expertise in Base SAS, SAS EG, SAS/MACROS SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/CONNECT in Windows& Unix environment.
• Extensively used ETL to Extract transform and load data from Oracle and Teradata systems.
• Possess expertise in utilizing SAS Functions, SAS Procedures, Macros and other SAS application for data updates, data cleansing, and reporting.
• Performed cleansing of imported data and converted them intoSASDatasets, merged datasets and created reports based onAd - hoc requirements.
• Extensively usedPROC SQLandSELECT sub-queriesto create various interim datasets and final report by connecting to the Teradata DB.
• UsedEnterprise Minerfor importing data and converting them into requiredSASdatasets. Also, used theSAS Forecast Studiofor appropriate analysis of data for different Forecasting models likeTime Series and Monte Carlo Forecasting.
• Performed analysis of data that includedCustomer Profiling,Segmentation,Trend Analysis,Predictive Modeling etc.
• Used variousStatistical ProcedureslikePROC MEANS, PROC FREQ, PROC REG and PROC GLMto analyze data and generate reports.
• Possess expertise in Data management, data extraction, manipulation, validation, and analyzing terabytes of data.
• Experience in transforming data imported from different data sources into analysis data structures, using SAS functions, options, ODS, macro facility and other SAS procedures.
• Experience in Developing and designing SAS Programs / Macros to access and analyze Banking data.
• Experience in working with large technical teams to understand requirements and to develop code based on SDLC procedures.
• Detail oriented, organize and enthusiastic to work in a fast paced and team oriented environment
• Possess strong communication skills and problem solving skills.

TECHNICAL SKILLS:

SAS Tools: SAS V9.3, SAS V9.2,Base SAS, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, ETL, SAS Forecast Studio, SAS Enterprise Guide and SAS VA.

Databases: Teradata, Sybase, Oracle 9i/10g/11i, MS SQL Server and MS Access

Operating Systems: UNIX, MS-Windows XP

Database Tools: TOAD 9.7.2, Teradata SQL Assistant

Programming Languages: SQL and UNIX Korn Shell Scripting.

WORK EXPERIENCE:

Confidential, New York

SAS Architect

Responsibilities:

• Involved in Business Requirements gathering for all the markets.The Business Requirements involved collecting information on Data source systems
• Data access issues across regions
• Calculation of Net New Money logic for each market
• Inclusion and Exclusion criteria for Wealth and Retails products
• Finalizing the SAS Reporting Format for each market.
• Documenting the NNM Flow Process, Calculation Logic, Timelines and the Gap Analysis for all the markets.
• Extracting the Customer Balances, Market Movements, Customer Upgrades and Downgrades data for all the market from the respective sources (Teradata ).
• Calculating the Net New money as per the logic defined by the respective markets.
• Ensuring the currency conversion of all markets to the USD.
• Creating dashboard using parameters, sets, groups and calculations.
• Creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Formatting the data according to the agreed upon formats.
• Generating the NNM Reports for the respective country contacts.
• Creating calculated fields, mapping and hierarchies.

Environment: SAS/BASE,SAS/MACRO,SAS/SQL,SAS Enterprise Guide, Tableau Desktop 8.2, Tableau Server 8.2 and Teradata Sql Assistant

Confidential, New York

SAS Architect

Responsibilities:

• Requirements gathering for the Reporting.
• Extracted data from Teradata using the Sql Pass Through facility.
• Coded the SAS Macros to extract the data, cleanse and analyze the data.
• Involved in extensive SAS Reporting to detect the fraud and to identify the credit risk customers.
• Managing and reviewingSAS Log Files and performance tuning.
• Designing Test Plans, Test Cases and performed System Testing.

Environment: SAS/BASE,SAS/MACRO,SAS/SQL,SAS Enterprise Guide, U E Studio, Sybase, Teradata, UNIX.

Confidential, New York

SAS Architect

Responsibilities:

• Understanding the current environment and requirements for the Code conversion.
• Converted the existing SAS macros with Sybase queries to SAS macros Teradata Queries.
• Understood the Sybase queries and translated them to the Teradata equivalent.
• Identified the limitations of Teradata with respect to performance and functions and accordingly optimized the queries.
• Tested the Teradata queries in SQL Assistant before embedding them in the SAS macros.
• Modified the existing SAS macros to include the SAS SQL wherever applicable to create SAS Datasets.
• Created CSV files out of the SAS Datasets and exported the files to Hadoop environment for further processing.
• The final data is dumped into SQL Server which again is used to populate the front end of the VISE (Visual Search Engine) platform.
• Explored and performed fine tuning and optimization of SAS codes and Teradata queries to bring the runtime of code from couple of hours to few minutes.
• Creating dashboard using parameters, sets, groups and calculations for generating the Credit Risk reports using Tableau 7.0 server edition.
• Creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard according to the Risk criterias.
• Generating the Credit Risk Reports on ad-hoc basis as per the client requirements.

Environment: SAS/MACRO,SAS/SQL,SAS Enterprise Guide, U E Studio, Sybase, Teradata SQL Assistant, SQL Server, Tableau v7, Hive, UNIX.

Confidential, New York

SAS Lead

Responsibilities:

• Responsible forclient-specific transactional data analysis, such as point-of-sales and ATM transactions, sales volume and profitability and performance indicators for debit and credit card programs.
• Developed new or modifiedSASprograms and usedSQL Pass ThroughandLibnamemethods to extract data from theTeradata DBand created study specificSASdatasets, which are used as source datasets for report generating programs.
• Identify relevant market trends based on a deeply analysis of payment industry information.
• Analyze and mine multiple client datato select statistically valid data samples, build, test, and implement predictive models by investigating appropriate methods and algorithms.
• Engage inquantitative analysis on many non-standard and unique business problemsusing computer-intensive data mining techniques (decision trees, neural networks, clustering, etc.) to deliver actionable output.
• Identify the most relevant criterion to segment individual customer bases for client banks in Latin America. Develop statistical modeling including:Chaid, Discriminant Analysis, Cluster Analysis
• Logistic Regressionto capitalize business opportunities of activation, usage and retention for strategic clients.
• Document all SAS programs developed and write other documentation as needed. Identify and share best practices for key topics.
• Evaluate analytical findings to ensure accurate interpretation of data and development of meaningful data mining results.
• Interpret business and statistical analysis to the team of consultants for use in decision-making
• Performed analysis that includedBehavioral model,Customer Profiling,Segmentation,Trend Analysis,Predictive Modeling andValidation.
• Perfomedquantitative analysis on many non-standard and unique business problemsusing computer-intensive data mining techniques including decision trees, neural networks and clustering to deliver actionable output.
• Identify the most relevant criterion to segment individual customer bases for client banks in North America. Develop statistical modeling including:Chaid, Discriminant Analysis, Cluster Analysis
• Applied Data Step logicsto Sort, Merge, Update and Interleave datasets for producing required analysis of data and usedSAS Business Intelligence (BI)to produce required Reports.
• Used variousStatistical ProcedureslikePROC FREQ, PROC REG, PROC MEAN AND PROC ANOVA to analyze data and generate reports.

Environment: SAS 9.3, SAS/BASE, SAS/ODS, SAS/Connect, SAS/MACRO, SAS/STAT, SAS/SQL, Teradata and Excel.

Confidential

SAS Senior Developer

Responsibilities:

• Tasks in Data Segmentation & Building a predictive Model (Score Card) using Data Integration Studio,
• Designing a Process in the repositories.
• Creating Metadata that defines Source, Target and Transformation.
• Report generation
• Deploy jobs for scheduling.
• Tasks in SAS management Console,
• Managing Resources throughout the Intelligence Value Chain
• Managing Job scheduler, Server and User manager.
• Application Monitoring & Management.
• Tasks in SAS include code development, testing and implementation. This involves Development work as well as Support/Maintenance activities

Environment: SAS 9.1.3, SAS Macros, SQL, UNIX, Toad, Teradata, Remedy.

Confidential

SAS Developer

Responsibilities:

• Requirement Analysis, Design and Building of Reports through SAS Enterprise Guide.
• Scheduling of Reports to run every quarter.
• Setting up of Automatic Email reminders to the concerned report users.
• Developtime series analysisand models usingMatlab, ExcelandSAS.
• Developed and analyzedperiodic forecasting reportsusing various MS Excel andSAStools.
• Developed and maintainedplanning modelsand reporting tools for the reports.
• Analyzed and buildRisk-MetricsusingSAS/IMLandSAS/ETSandBase SAS.
• ImplementedMonte-Carlo simulationtechniques forRisk-MetricsusingSAS/IML.
• Streamlined the data mining process from data extraction to model deployment for usingEnterprise MinerandSAS/ETL.
• GeneratedReports, Summary tables, Charts and Graphs for different users usingSAS/ASSIST.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/Assist, SAS/STAT, SAS DDE, SAS ODS, VBA for Excel, SAS/GRAPH, SAS/IML, ORACLE, SAS Enterprise Guide, Enterprise Miner, Excel and UNIX.

Confidential

SAS Developer

Responsibilities:

• Requirement Analysis, Design and building of various interfaces like Max Interface, EtrainInterface.
• People Information reporting Online Interface.
• Develop and maintain Business reports for People Capital Analysts and line Managers.

Environment: SAS 9.1.3, SAS AF, SAS Macros, Windows 2000

Confidential

SAS Developer

Responsibilities:

• Responsible for creation for designing and development.
• Used SAS and ASP to bring the features of SAS on to the web.
• Extensively used Base SAS and SAS AF for the ETL process.
• Implemented role level security features for the online reports.

Environment: Base SAS 9.12, SAS AF, SAS macros

Confidential

SAS Programmer

Responsibilities:

• Production Support for the Auto analyst Application.
• Enhancement Work like adding some code to include some functionality in the existing process.
• Maintenance Work that includes fixing the bugs.
• Unit testing and Module testing of the code before promoting it to SQA.

Environment: MAINFRAMES, BASE SAS, SAS MACROS, SAS SQL

Confidential

Statistical/SAS Programmer

Responsibilities:

• Importing data from Oracle database for Phase I clinical study data and employing PROC IMPORT to analyze data.
• Providing statistical SAS programming support, by producing analysis datasets, QC programs for pharmacokinetic (PK) studies
• Performing data validation on the Phase I clinical study and creating ad hoc reports.
• Using SAS/MACRO with DATA step, SET statements and PROC SQL to bring data into processing programs, and drawing statistical information for reporting through PROC FREQ, PROC UNIVARIATE, and PROC REGRESSION.
• Generating tables and listings for Patient Demography and Adverse Events data for Phase I and Phase II studies.
• Creating SAS datasets of clinical data from clinical databases
• Developing status and efficacy datasets, project specific macros and formats.
• Loading client data from other platforms and other software packages;.
• Preparing documentation describing all datasets and variables including derived variables.
• Performing data checks as needed, to ensure integrity and correctness of data displays.
• Programming customized data displays, (including data listings, summary tables and routine graphics) in accordance with approved statistical analysis plan and shell displays for clinical research studies.
• Performing data checks as needed to understand structure and content of data.

Environment: SAS 9.1.2, Oracle, SAS SQL, SAS Macros, MS Excel