SUMMARY

• Base SAS, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS , SAS/ODS,SAS/CONNECT,SAS/Grid Manager ,SAS DDE , SAS/ODS RTF, .csv, .html , implicit / explicit do loop control, functions, formats, informats, hash tables, date time handling
• vvvvvvTeradata SQL Assistant Queryman , BTEQ, MLOAD, FASTLOAD, FASTEXPORT, TPUMP, Statistics, Index, Explain, TSET, MultiTool.
• SAS:
• ETL Tool : Informatica 9.X , SAS DI STUDIO

SAS BI:

• SAS OLAP STUDIO, SAS INFORMATION MAP, SAS WEB REPORT STUDIO, MANAGEMENT CONSOLE.

IBM Mainframe MVS:

• DB2, VSAM, IMS, SQL, COBOL, Easytrieve Plus, SPUFI, QMF, JCL, CA7, TSO/ISPF, Changeman, Panvalet, Endeavor and File-Aide.
• Orale9i/10g DB: Enterprise Manager, SQL Plus, Data Pump and Designer.
• SQL Server-2k: Enterprise Manager, Query Analyzer.
• MS-Office 2000 Pro Access, Word, Excel, Power-Point , Visio, and MS-Project.
• Lotus Notes, C, C , Micrografx Flow Charter
• Windows 9x, 2000/2003 Pro Server, XP, NT, UNIX and FTP.

PROJECTS

Confidential

SAS CONSULTANT

• This project is mainly into validating data between DB2 database to Teradata database.
• Involved in reengineering multiple DB2 sql to Teradata sql and optimize them to reduce the runtime
• Performance tuning, including collecting statistics, analyzing explains determining which tables needed statistics. Increased performance by 35-40 in some situations
• Responsible for converting SAS scripts, SQl queries, testing in Dev, keep track of UAT testing and moving into production.
• Expertise in primary index selection for uniform data distribution across the AMPs and compress columns for efficient utilization of available disk space
• Responsible for creating and testing Store procedures in SAS
• From SAS jobs, developed CSV files and reported to management with the use of Excel Templates, Excel macros, Pivot tables and functions, as well as creating daily reports activity onsite through the creation of a Teradata.
• Identify process needs and improvement opportunities, develop solutions, get them accepted and coordinate their execution in a continuous improvement environment.
• Extensively used SAS macros and executing Unix command thru SAS Codes
• Worked on SAS Add-in/SAS IDP for Microsoft office to bring the data to Ms Excel from SAS datasets and by executing STP.
• Used SMC SAS Management Console to export/import to STPs to different environments.

Confidential

SOFTWARE ENGINEER

• Work closely with the product manager and process manager community on the development, execution, monitoring, and evaluation of marketing strategies with the strongest focus on execution.
• Using SAS macros for supporting data analysis/mining needs for the business.
• Procedures to produce the standardized data display
• Responsible for proper coding, documentation and validation of SAS programs/macros/
• Using Teradata utilities BTEQ, FASTLOAD to pull/load data from Teradata database for developing model and validate the data prior to it.
• Provide support of customer management data projects, processes, analysis and reporting.
• Contribute directly to Bank customer management business by working on strategy execution and delivery for the business.
• Work directly with business users/requirements.
• Using SAS Base to generate the report using Procedure PROC PRINT, PROC REPORT
• Involved in helping Statistician to build a model by extracting data from different sources
• Provide status update on test execution and campaign validation.
• Extensive experience working in an Agile development environment.

Confidential

SOFTWARE ENGINEER

• Involved in project called Global New Accounts GNA which extract credit card applicant and candidate information and get direct, possible and No matches based on their Account Number, Name and Address for 13 markets.
• Involved in analysis, design, development, code, testing, and documentation and support activities for client business requirement.
• Project involves in extracting information from Mainframe, Sybase and Sql Server using

SAS Base Proc SQL

• Generated new SAS Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Used Macros to read, validate, parse and import file from different folders.
• Used Informatica Data Quality IDQ to parse and assign scores based on matching rule.
• Wrote Korn and shell scripts to submit the series of Jobs on UNIX and for transfer the data, reports and SAS programs from one location to another location.

Confidential

SAS CONSULTANT

• Provided structured programming analysis, design, development, code, testing, documentation, implementation, and quality assurance during enhancement, maintenance, and/or production support activities for various client business application solutions.
• Created ad hoc, Macros and Stored Procedures for ETL Interfaces Programs.
• Used SQL join, Splitter, Extract, loader, Sort, Summary, validation and SCD Type2 loader Transformation in SAS DI Studio.
• Used SAS to reports employing various Base SAS procedures, like null , ODS, Proc Print, Proc Report, Proc Summary, Proc Univariate, Proc Freq, Proc Mean, Proc Transpose, Proc SQL, Proc GREPLAY.
• Creating SAS dataset from tables in Database. Retrieved the Trade data from flat files, DB2, Teradata database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management using Excel Pivot table.
• Used Teradata utilitis like MLOAD, FASTLOAD, FASTEXPORT, TPUMP to load data.
• Migrated data from Mainframe COBOL, JCL, DB2, SQL Server to files and generate reports with the help of SAS.

Confidential

SAS CONSULTANT

• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Created and Maintained Teradata Databases, Users, Tables, Views, Macros and Stored Procedures, SQL Assistant Queryman , SQL DDL, SQL DML, SQL DCL.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Utilized Base SAS provide reports using Excel Pivot table to end-users.
• Used SAS to reports employing various Base SAS procedures, like null , ODS, Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Mean, Proc Transpose, Proc SQL.
• Applied Morino upgrades, fixes and user-written SAS modifications to database. Maintained user-written components and created external feeds using SAS.

Confidential

SYSTEM ANALYST

• Produced monthly and ad hoc reports/graphs for system charges and system performance.
• Designed and Developed ETL interfaces codes and test cases on Teradata and Mainframe MVS/TSO.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Base SAS Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Prepared, documented and tested required programs and procedure data displays in an efficient manner for inclusion in statistical summary reports and other reports
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Using SAS procedures and preparing daily, monthly, yearly reports.

Confidential

MAINFRAME CONSULTANT

• Created and Maintain Databases, Users, Tables, Views, Macros and Stored Procedures on Teradata using: Teradata Administrator WinDDI , SQL Assistant Queryman , BTEQ, MLoad, Fastload, FastExport, TPUMP and Explain.
• Easytrieve Plus and SAS.
• Compare file data with database data and generate the discrepancy report using
• Developed and supported of batch using COBOL, VSAM on IBM DOS VSE/ESA, DB2, Easytrieve Plus, JCL, FTP, Base SAS, TELON, XPEDITER, DFSORT, FILEAID.
• Created Unix scripts to execute Teradata SQL, BTEQ, MLoad, Fastload, and FastExport jobs for ETL process.
• Extracting required data from IBM mainframe to local Base SAS Environment by SAS FTP and sync sort.

Confidential

MAINFRAME CONSULTANT

• Migrated data between legacy system and Mainframe DB2. Maintain dictionary objects and database table's creation
• Involved in Application development/support utilizing COBOL, MVS/TSO, JCL, SQL, DB2, ENDEVOR, PANVALET, EASYTRIEVE and IMS.
• Supported and built the Connect Direct NDM /FTP connectivity to assure validity of Data Transfer Created/edited unload and load jobs DB2 and VSAM .
• Maintained functionalities including report generation, taxation, journalization, DB2, interfacing, settlements for Customer Billing Support System CBSS .