Summary:

• Over Seven years of strong reporting, analytical skill, with good experience in advanced SAS programming and skills in pulling data from a relational database. Experience in UNIX and PC environment.
• Extensive SAS programming experience with Base SAS, SAS Enterprise Guide, SAS Management Console, SAS Data Integration Studio, SAS Enterprise Miner.
• Experience on SAS Macros, SAS SQL, SAS Stat and SAS Graph in UNIX environment.
• Extensive experience on SAS libraries, Metadata Links Registration of database tables , User management, Metadata Objects, Stored Processes, Job Scheduling through Management console and Control M.
• Worked on SAS Grid Environment.
• Significant experience and strong skills in the data manipulation of hundreds of millions of records using SAS Base, SQL, SAS Connect and SAS macros
• Strong in UNIX and used all UNIX commands to manage SASprograms chcek-in/check-out , moving codes, build release scripts, data file movement
• Good Understanding of data modeling.
• Write, maintain and document SAS programs to obtain data from the databases using intermediate and advanced SAS programming techniques.
• Extensive experience with accessing data from mainframe, flat files, SQL Server, Oracle and Teradata.
• Extensive experience with accessing data from database including its functionality and structure: ORACLE, Teradata, MS SQL and MS Access.
• Strong programming skills in UNIX scripting, Proficiency in Excel, including writing macros in VBA.
• Significant experience with conducting programming and data quality checks and validation.
• Strong with performance improvement with very large datasets in SAS
• Database design knowledge, Ad hoc analysis experience, and experience working with large data volumes
• Knowledge of SAS performance improvement techniques and features and methodology for improving the performance of SAS programs / jobs.
• Using SAS/SQL for extract, transfer and load ETL methodology and processes
• In depth of knowledge of SAS Enterprise Guide.
• Creating, managing and optimizing tables, views and queries in a Teradata environment using Teradata, and UNIX.
• Considerable experience with best practices of SAS program documentation and versioning
• Resolution of user queries on adhoc basis and providing the support with best of knowledge.
• A team player with strong communication, interpersonal, analytical and logical abilities.
• Extensive experience in Banking and Finance domain Credit Card

WORK EXPERIENCE:

Brooks Brothers, New York, NYJuly 12 Till Date Data Analyst

Responsibilities:

Perform data analysis on large data volumes to support business decision making Working with business users or business systems analysts to understand requirements and translate them into technical specifications. Understanding of business and technical metadata, data lineage and data models and methods to document this metadata for both technical and business users Bringing large data i.e. millions of records from SAS and non-SAS Teradata and Oracle database data sources into a SAS environment and performing SAS data manipulations against the resulting sets. Devising or modifying application systems and procedures to optimize functional requirements including capacity, operating time, response time, and form of desired results Created stored process to register the tables and to provide user access. Developing highly efficient SAS code for use in automated data processing systems on Unix based platforms. Working with SAS Enterprise Guide, Base SAS/Macros, SAS Platform Metadata, SAS Stored Processes Developed efficient, well documented, readily comprehensible and modifiable SAS code using SAS/BASE and SAS/MACRO facility. Entering or copying documentation into Excel templates which will be used to upload metadata into one or more metadata repositories Assisting in creating, or enhancing existing user documentation on the use of metadata tools and types and scope of metadata available. Establish the appropriate security controls against the metadata repositories User interface development experience using SAS EBI and SAS OLA Wrote common macros that are used across multiple applications. Created stored process to generate extract based on different criteria. Creation of Base and DB2 libraries. Manage and execute test plan activities.

Environment:Base SAS v9.2, SAS/Macros, SAS/SQL, VBA,SAS Enterprise Guide v4.2, SAS/ACCESS,SAS/STAT, Teradata, ER Win, Windows XP, UNIX.

Bank of America , Wilmington, DEOct 11 July 12

SAS/ Data Analyst

Responsibilities:

Gather information, analyze data trends, identify root causes and develop work products. Determine and apply routine modeling theories and techniques for business request Analyze data processing result between existing and newly developed system for validation certification. Using SAS to create SAS Data sets, Compare data sets in Pre Post environment, Generate various reports as needed to support conversion between existing and newly developed system for validation certification Developed new or modified existing SAS programs for the Quality Assurance System Rewrite Project in SAS/UNIX environment. Calculate and analyze the capital requirements for securitization per current and proposed regulatory rules including Basel II or Basel III. Working with Unix shell scripting ksh scripting Defining and maintaining metadata that supports the data models Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets for statistical analysis, validation and documentation. Used procedures such as PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS. Basic knowledge of development and migration of reports using Tableau software. Ran ad-hoc queries/reports as per requested by the business stakeholders.

Environment:Base SAS v9.2, SAS/Macros, SAS/SQL, SAS OLAP Cube Studio 4.2, SAS Enterprise Guide v4.2, SAS/ACCESS, SAS/STAT, Windows XP, UNIX, Project Management, UE Studio.

Confidential

SAS/ Data Analyst

Responsibilities:

Write and test simple to complex SQL scripts to update production data. Develop and execute SAS/MACRO to monitor ongoing analyses, produce data listings, summary tables and graphs Transforming the resulting SAS datasets into specific text file formats and subsequently being able to manipulate the resulting text files with UNIX commands to include standard headers and trailers Utilize intermediate and advanced SAS techniques to produce complex reports. Creation of Jobs and scheduling of flows through Management Console. Automation of some of the manual user processes. Created stored process to register the tables and to provide user access. Developed efficient, well documented, readily comprehensible and modifiable SAS code using SAS/BASE and SAS/MACRO facility. Wrote common macros that are used across multiple applications. Created stored process to generate extract based on different criteria. Develop or refine modeling utility programs with SAS Macro and VB for the various stages of predictive modeling process. Creation of user groups and setting up access on libraries. Created SDLC documents Requirement Report, Design Report, Test Report including test cases and installation documents. Worked on quality center to upload the test cases and log the defects. Provided support during installation and after installation. Provided guidance and assistance to team members in resolving the issue.

Environment: SAS/BASE, SAS/MACRO, SAS/Access, Enterprise Guide, SAS/STAT, MS-Excel, Visio, ORACLE, Windows XP

Confidential

SAS Analyst

Responsibilities:

Develop SAS programs to extract, transform, clean and manage large data files Validate Existing Data Model and identify opportunities for removing redundancies Analyze system performance of existing process and improve performance Develop scripts, software programs and stored procedures SAS data sets to Flat Files, Excel spreadsheets. Unit testing with different possible conditions Converted SAS Reports into HTML and other formats using SAS/ODS. Wrote shell script programs to run SAS jobs in UNIX, and then scheduling the scripts using Cron tab, at specific day and time. Used Toad Data Analysts to connect to Oracle DB2 for data analysis Conduct Integrated testing of fragmented code and software by various developers Expert knowledge of Key Applications. Extensive IT Knowledge of implementing Technical Solutions using the skill sets mentioned above Provide analysis to determine availability of data and provide recommendations for reporting during report planning stages Identify data needs for reporting and work with Marketing Database Manager and IT to fill data gaps Provide SAS/SQL coding based on business requirements

Environment: SAS - Base SAS, Macros, SAS Connect on Windows and AIX, Unix Shell Scripts, DB2, Toad for Data Analysts, Subversion SVN, MS Office and Windows XP

TECHNICAL SKILLS: