SUMMARY

• Strong reporting, analytical skill, with good experience in advancedSASprogramming and skills in pulling data from a relationaldatabase. 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.
• Experience in Business Analytics with IT skills, Project Management and Project Coordination role
• Significant experience and strong skills in the data manipulation of hundreds of millions of records usingSASBase, SQL,SASConnect andSASmacros
• Experience in data structures, data manipulation, application development, and automation.
• Strong in UNIX and used all UNIX commands to manageSAS by Coupon Companion Plugin">programs (chcek0 - in/check-out), moving codes, build release scripts, data file movement
• Highly skilled in financial risk modeling, particularly with respect to credit scorecards, Basel II credit parameter models, methods for economic capital and stress testing.
• Experience with CMS-1500 &CMS-1450/UB-04data and claim forms;EDIX12 837
• Expert knowledge of database & data warehouse platforms, SQL (Teradata, Oracle, SQL Server), Business Intelligence Applications/OLAP (MicroStrategy, Business Objects, Cognos, Epiphany, Crystal Reports), direct marketing campaign management (Unica Affinium), desktop reporting tools MS Office Suite (Excel, Access, Word, PowerPoint)
• Good Understanding of data modeling.
• Experience in developing SAS procedures, macros, and applications for data cleaning, programming, reporting, and documentation.
• Write, maintain and documentSASprograms to obtain data from the databases using intermediate and advancedSASprogramming techniques.
• Extensive experience with accessing data from mainframe, flat files, SQL Server, Oracle and by Coupon Companion Plugin">Teradata .
• Extensive experience with accessing data from database including its functionality and structure: ORACLE, Teradata, MS SQL and MS Access
• Experience with T-SQL query development, including the ability to write moderately complex and efficient queries, functions, and stored procedures utilizing joined and derived tables, linked server databases, and other complex objects
• Significant experience with conducting programming and data quality checks and validation.
• Strong with performance improvement with very large datasets inSAS
• Database design knowledge, Ad hoc analysis experience, and experience working with large data volumes
• Knowledge ofSASperformance improvement techniques and features (and methodology) for improving the performance ofSAS by Coupon Companion Plugin">programs / jobs.
• UsingSAS/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 ofSASprogram 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)

TECHNICAL SKILLS

Statistical Packages: SAS 8.x 9.x (Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS), SAS Enterprise Guide.

Databases: SQL,Teradata,DB2

Languages: SAS, SQL, C, C++, Core JAVA.

Platforms: Windows and UNIX.

Others: ClearCase, ClearQuest, MS-Visio MS office, MS Visio, MS Project Management, Ultra Editor Studio, VBA macros.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SAS Analyst

Responsibilities:

• Coordinates the activities of the team (Customer & internal) ensuring roles and responsibilities are well defined and understood, and project team and other stakeholders are kept abreast of the project’s status.
• Program and execute SAS programs in UNIX
• Quickly understanding complex data structures, profile data, and develop meaningful data extracts
• Develop sophisticated data pulls using SQL
• Created training materials and classes to train new analysts in all aspects of the job including SAS and Excel (MS Office)
• Extracted data from SQL Server database using store procedures and VBA programming.
• Design, develop, and maintain custom SQL queries, functions, stored procedures
• Develops and maintains Data Governance policies, processes and standards templates
• Defines and maintains Data Governance compliance and operational metrics
• Develops and executes audits to ensure compliance with Data Governance practices
• Creating, modifying and improving stored procedures, UDFs, triggers, etc. Basic database programming skills are required in SQL Server 2005/2008
• Created VBA module in Access to merge and insert records to Oracle Table Final Table from Access.
• The ODS had a daily ETL Process to move data from DB2 Mainframe to DB2 UDB Environment. This is done using Informatica Maps automated by UNIX scripts
• Understanding of Basel-II and Basel-III capital adequacy accord
• Collaborates with data owners and data stewards to resolve data quality and data governance compliance issues.
• Prepares and maintains status reports, dashboards, and data objects consolidated metrics
• Identifies areas for improvement and makes training recommendations
• Assists Data Governance Lead with administrative and data governance activities
• Ensures data quality processes are implemented
• Designed, developed and implemented the automation of the sales commission system utilizing UNIX 10.20 scripting, UNIX 10.20 cron job scheduling
• Coordination of internal stakeholders on project related matters (requirement definition, issue resolution, etc.)
• Design, development and administration of transactional and analytical data constructs/structures.
• 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 Oracledatabase) 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
• Formulating and communicating credit risk perspective on new product proposals, using basic ratio analysis and spreading.
• 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.
• Working on SAS BI tools like SAS DI Studio, SAS Enterprise Guide
• 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.3, SAS/Macros, SAS QC, Visio, SAS/SQL, PC SAS, SAS Enterprise Guide v4.2, SAS/ACCESS, SAS/STAT, SAS AML, SAS E-Miner, SSAS, MS Office, Teradata, Shell scripting, ER Win, Windows XP, Sybase, HTML, XML,ClearQuest, AUTOSYS, Business Objects, VBA,Cognos,UNIX/LINUX.

Confidential, Wilmington, DE

SAS/ Data Analyst

Responsibilities:

• Involved in gathering detailed, specific, accurate, unambiguous business requirements and functional specifications.
• Primary focus was Mortgage Risk Management, Credit risk and Loan Origination Modeling.
• Performed statistical analysis and data management on study data by utilizing appropriate statistical methods using SAS and SAS tools.
• Proactively communicate and collaborate with clients or business units to analyze information needs and functional requirements and deliver the following artifacts: Business Requirements Document, Use Cases, GUI, Screen and Interface designs.
• Gathered Requirements and Automated Client-Customized E-Commerce Order and List Credit Risk Scoring Solutions for Direct Marketing Clients using Perl, Java, JavaScript, XML, HTML, FTP, PGP Encryption, Unix Shell Scripting, Regular Expressions, Corn, Autosys, Python, APIs, MYSQL, PHP, and SAS in both Linux and Windows Environments.
• Working with key stakeholders to obtain their buy-in when proposing for process changes and having proper sign-off documentation
• Configuration of authentication using Active Directory, Keyshare between Linux servers, Scheduling cron jobs
• Designed, developed and implemented a monthly automated Tax data extract program to extract, compile, sort and transfer the resulting data files to the corporate tax department for monthly tax reporting and payment for State and Federal Tax returns utilizing Oracle PL/SQL, UNIX 10.20 scripting and UNIX 10.20 corn job scheduling.
• Working on Data source identification & mapping, Data profiling, Data analysis & evaluation, Data quality & remediation
• Determine and apply routine modeling theories and techniques for business request
• Served as content specialist in a platform migration from a desktop Excel-based reporting system to a Teradata/ Microstrategy-based relational database system.
• Used SAS Enterprise Guide to access and manipulate Teradata and oracle Databases.
• Testing and debugging of all ETL and Teradata objects in order to evaluate the performance and to check whether the code is meeting the business requirement.
• 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.
• Support business and data quality teams to perform tactical and strategic resolution facilitation of high priority data related issues
• Understanding of data architectures and tool sets that enhance data transparency to enable data lineage, data profiling and data quality metrics
• 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
• Informatica was used to extract data into Oracle DW Database and Cognos was used for Drill Down Reporting.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets for statistical analysis, validation and documentation.
• Apart from Informatica, routines or parsers were written in Java to extract and load data into the Oracle DW.
• 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, ETL( Informatica 6.2), SAS OLAP Cube Studio 4.2, SAS Enterprise Guide v4.2, SAS/ACCESS, SAS/STAT, Windows XP, MS Office,,XML,Hyperion/Brio, Ab initio,Visio,ClearCase, IBM Mainframes, UNIX/LINUX, MVS, C++,Microstrategy, Project Management, Cognos,VBA, UE Studio.

Confidential, San Diego, CA

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
• Assist data stewards to ensure data assets comply with all governance policy, regulations, agreements, and business rules .Enhance enterprise conceptual data model
• Profile data to find anomalies, characteristics, correlations, and other “interesting” factoids about data
• Derive and document meaningful business findings resulting from data analysis
• Present data analysis findings appropriate to either business or technology data stakeholders
• Document specific data analysis techniques for use by data stakeholders as part of a data analysis toolkit
• Mentor data stakeholders in data analysis techniques
• Effectively communicate data quality metrics and performance indicators to data stakeholders
• Assist data stewards with data asset full life cycle management, minimize short-term exploitation where it may damage long-term value of the data asset
• 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 advancedSAS techniques to produce complex reports.
• Creation of Jobs and scheduling of flows through Management Console.
• Automation of some of the manual user processes.
• Wrote queries on the Teradata database to provide ad-hoc reports using SAS/SQL.
• Designing Unix Framework for executing File system to handle ETL processing under Teradata database Environment
• Performed initial analysis for "pro-active" risk management programs such as pool loan sales and mortgage insurance purchases;
• Working with Kronos Scheduling, Kronos Timekeeping and Shell Scripting Concepts.
• 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, PC SAS, SAS/Access, SAS AML, SAS E-Miner, Enterprise Guide, SAS QC,SAS/STAT, MS-Excel, Visio, IBM Mainframes ORACLE, C++,Clear Case, Clear Quest, Visio, Shell Scripting, MVS,VBA, AUTOSYS, Windows XP

Confidential

SAS Analyst

Responsibilities:

• DevelopSASprograms to extract, transform, clean and manage large data files
• Working with data architects, logical data modelers and line of business specific data owners in maintaining the standards and consistency of the data sourcing, data quality and data distribution
• Handling Management Information and Reporting work for Commercial Insurance part of Claims team in areas of Recoveries, Settlements, Motor, Property and Liabilities, Monthly claims data processing and Adhocs (Daily/Weekly/Monthly).
• Identification and maintenance of functional and technical data quality standards and rules
• Identification of data quality issues and an understanding of the data remediation processes
• Validate Existing Data Model and identify opportunities for removing redundancies
• Analyze system performance of existing process and improve performance
• Generated Pivot Table and VBA Excel reports for customers.
• 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.
• Was involved with country finance teams to resolve issues related to Basel-1 & Basel-2 calculation, RWA results analysis, LGD / PD / Maturity defaulting, data rejections due to datawarehouse validations and data sourcing.
• 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.
• Developed a MS Excel spreadsheet programs (VBA) for employee evaluation and operational downtime reporting.
• Extensive IT Knowledge of implementing Technical Solutions using the skill sets mentioned above
• Provideanalysis to determine availability of data and provide recommendations forreporting during report planning stages
• Identifydata needs for reporting and work with Marketing Database Manager and ITto fill data gaps
• ProvideSAS/SQL coding based on business requirements

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