PROFESSIONAL SUMMARY:

• Over 11+ years of IT experience and as SAS Reporting Analyst having 10+ years of experience in analysis, design, development, testing and implementation of applications in Financial, Telecom and Healthcare Industry . Worked in Marketing side for Confidential .
• Technical expertise in Base SAS, SAS Enterprise Guide, SAS/MACROS SAS/SQL, SAS Enterprise Miner, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/IntrNet, SAS/CONNECT and SAS/ODS etc 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.
• Technical expertise in developing dashboards in SAS Visual Analytics from various data sources.
• Possess expertise in Data management, data extraction, manipulation, validation, and analyzing huge volume 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:

ETL & Reporting Tools: SAS/MACROS, SAS/SQL, SAS Visual Analytics RDBMS: Teradata V2R6.2, Oracle 8i/9i/10g, SQL Server, DB2, MS Access.

DB Tool: SQL*Loader, TOAD, Teradata SQL Assistant

Languages: SQL, Unix Shell Scripting.

Modeling Tools: Erwin, MS Visio

WORK EXPERIENCE:

Confidential, New York

SAS Analyst

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 ).
• Used SAS Visual Analytics for creating visualizations (created reports).
• Calculating the Net New money as per the logic defined by the respective markets.
• Ensuring the currency conversion of all markets to the USD.
• Formatting the data according to the agreed upon formats.
• Generating the NNM Reports and uploading it in the Share point portal for the respective country contacts and the stakeholders to access.

Environment: SAS/BASE,SAS/MACRO,SAS/SQL,SAS Enterprise Guide, SAS Visual Analytics, Teradata Sql Assistant, UNIX.

Confidential, New York

SAS Reporting Analyst

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 Reporting Analyst

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.

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

Confidential, New York

SAS Developer

Responsibilities:

• Requirements gathering
• Extracting and Reading SAS Datasets
• Applying transformations and calculation logic to the extracted data.
• Loading the transformed data into the Teradata Datawarehouse.
• Performing quality checks before and after loading the data.

Environment: SAS 9.1.3, Ab Initio (GDE 3.12.5.2, Co>Op 3.12.3), Teradata V2R6, TOAD, UNIX.

Confidential

SAS Developer

Responsibilities:

• Designing a Process in the repositories.
• Creating Metadata that defines Source, Target and Transformation.
• Report generation
• Deploy jobs for scheduling.
• 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, Ab Initio (GDE 3.12.5.2, Co>Op 3.12.3), 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.

Environment: SAS 9.1.2, SAS Enterprise Guide 4, Windows 2000.

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

Confidential

Web Designer

Responsibilities:

• Importing products information from Oracle database for the Retail website pages .
• Writing code in PHP and MySQL for Custom Website Development
• Prototyping and implementing new themes as directed by Marketing.
• Responsible for maintaining the company’s front & back - end Retail website.
• Testing of applications in Development and QA environments.
• Minor database management (create/alter/drop/triggers) on MySQL and Oracle.

Environment: PHP, Mysql, HTML, Javascript and Oracle