SUMMARY

• Over 7 years of extensive experience in SAS Business/Data Analysis and programming on different platforms - Windows and UNIX.
• Proficient in SAS/BASE, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Access, SAS/ODS, SAS/Stat and SAS/Graph.
• Strong programming experience in SAS EBI and DI Studio. Proficient experience in different Databases like Oracle, Microsoft SQL Server, Teradata and IBM DB2
• Strong experience in data extraction, manipulation, Analysis using SAS data.
• Good exposure on SAS Business Intelligence Tools like SAS OLAP Cube Studio 4.2 (To create OLAP Cubes), Information Map Studio 4.2 (To create information maps on data marts), Web Report Studio (WRS) 4.2 (To create web reports using Information maps), SAS Information Delivery Portal.
• Experience in analyzing teh claims data, future trends and summarized results to generate recommendations for management.
• Worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing, trending, mapping analysis and business driven data validation.
• Experience in Data analysis and Reporting in health care, finance and marketing sectors.
• Developed new or modified existing SAS programs to load data from teh source and create study specific datasets.
• Thorough grounding in all phases of data analysis, including definition and analysis of questions with respect to available data and resources, overview of data and assessment of data quality, selection of appropriate models and statistical tests and presentation of results.
• Significant experience in requirement gathering, building, designing and testing teh application to meet teh functional Design and Business Process Design.
• Strong experience with databases like Oracle, MS SQL Server 2000, DB2 and MS Access.
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process.
• Extensive experience to handle large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.
• Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks.
• Extensive knowledge of advanced SAS/STAT procedures.
• Extracting, transforming and loading data into data warehouse using SAS DI Studio for further analysis and reporting.
• Created complex web reports from SAS data and information maps using SAS Web Report Studio.
• Performed data extraction, analysis and published results using SAS Enterprise Guide.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• TEMPEffective team player with strong communication and interpersonal skills.

TECHNICAL SKILLS

SAS Tools: Base SAS 9.3/9.2/9 /8.2/8.1/6 (mainframe), SAS/Stat, SAS Macros, SAS/SQL, SAS ODS, SAS Graph, SAS Enterprise Guide, SAS Enterprise miner, SAS Business Intelligence (BI) platform and SAS EBI.

Reporting Tools: Base SAS versions 9.3/9.2/9/8/6, SAS Enterprise, SAS Graph, AXUM, MS-EXCEL, SAS BI Platform, MS-Visio, MS-PowerPoint.

RDBMS: SAS SQL, SAS Enterprise, SAS BI Platform, MS-ACCESS, Microsoft SQL Server, MySQL, Teradata, and Netezza.

Languages: SAS, SQL, Basic, HTML, PERL, Java, .Net

Platforms: Windows 95/98/XP/Vista/Win 7, Unix, SOLARIS, Linux (Red Hat, Debian, Ubuntu & Xandros), MAC OS, DOS, Windows NT/ 2000/2003/2008

Batch Server: Unix, Putty, SSH, SAS scripting

Web Server: MS-FrontPage, HTML, JavaScript, Linux, Apache Server

Networking: Windows 95/98/XP, Linux, Server+

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

Sr.SAS Developer/Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/STAT.
• Worked with SAS and Proc SQL to extract marketing demographics from a Teradata data warehouse for model testing, segmentation, scoring, and list management purposes.
• Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
• Developed, modified and generated Monthly Business Review (MBR) reports and Quarterly Business Review (QBR) reports summarizing business activity using Proc Univariate, Proc Copy, Proc Transpose, Proc Report, Proc Tabulate and Proc Summary.
• Impact analysis and reverse impact analysis using SAS DI. TEMPEffective use of SAS DI for History load management.
• Created financial mortgage data sets using Data steps, and DATA NULL
• Perform bank-wide Asset/Liability Management (ALM) activities which cover both Interest Rate Risk (IRR) and Liquidity Risk (LR).
• Designed several ETL jobs using SAS DI Studio to port teh ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging teh final data
• Created new financial tables and manipulated customer data by using various joins and merges and tan appended teh data (Proc append) from teh existing source tables containing millions of records.
• Assisted with communicating analytical results, findings and solutions to governance committees and business process owners and influences business analysis as well as create statistical reporting and financial analysis to forecast results for required stress test scenarios.
• Used SAS Proc SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
• Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Automated SAS jobs running on a daily, weekly and monthly basis in windows.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information
• Designing ETL jobs in SAS DI Studio
• Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
• Using Proc SQL to connect to Teradata and pull/derive teh required fields.
• Developed loss prediction model using Enterprise miner modeling solutions and SAS procedures.
• Involved in Physical modeling on Teradata such as creation of tables, indexes and views
• Created and delivered reports and presentations with key findings and recommendations.
• Provided technical support on SAS programming related to data manipulation and analysis.
• Wrote macros, developed concise SAS scripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops
• Exported SAS Reports to teh Excel Sheet by using ODS/Tagsets/ExcelXP to get teh output in multisheets.
• Developed and used scripts to schedule SAS Jobs.
• Customizing teh existing Macros according to teh need and requirement, testing and debugging teh Macros and creating more complex and reusable Macros.

Environment: SAS 9.3, SAS/Connect, SAS Macros, SAS/Access, Oracle, ALM, Windows, PERL, SQL Server, Linux, MS Office, HTML, SAS Enterprise Guide, SAS Stored Processes Web Application, SQL, HTML, Javascript and Teradata.

Confidential, Hopewell, New Jersey

Sr. SAS Developer/Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Design and develop, efficient tool for data integrity tracking.
• Maintained performance reports, creation of reports for online and batch application of various server and Involved in preparing executive Dashboards for senior level management
• Used SAS, SAS Macros, Procedures like SQL, Freq, Univariate, Summary, Means, Transpose, Arrays, Tabulate, and Sort to extract data, prepare integrated data base and its analysis
• Extracted data sets from server using Proc Import and created datasets in SAS libraries. Coding SAS programs with teh use of SAS/Base and SAS/Macros for ad-hoc jobs
• Reporting Scripts and SAS jobs will be modified to connect to DB2.
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide.
• Teradata tables and created Logical and Physical Data Models using Erwin design tool.
• Used various Tagsets options in SAS ODS Mark up engine (Excel XP, MS office, MSoffice2k) to deliver teh Formatted EG reports as XML /HTML sheets that could be opened with Excel directly.
• Integrate data from various system sources (flat files, CSV, text form, and other formats) using SAS
• Created Custom Stored Compiled Macro’s to halp Analysts export ‘formatted’ datasets to MS excel.
• Analysis, programming and creation of reports on existing strategies using SAS and SQL.
• Understanding various data sources to teh GRMS (Global Risk Management System).
• Extracting data from flat files using SAS Base and Macros. Involved in code changes for SAS programs on windows.
• Raised queries on teh existing Oracle and SQL Server databases to provide ad-hoc reports using SAS/SQL
• Configured SAS BI components and solved BI related issues.
• Revising a series of Oracle PL/SQL programs to SAS for extraction of data from Oracle in Enterprise Miner.
• Validating and profiling teh variables using SAS Base / Macros using proc freq, proc means, proc format and proc univariate.
• Provided analysis, development, and testing for SAS programs using Teradata datamart to consumer and small business areas for market analysis.
• Created batch and interactive applications utilizing SAS/Base, SAS/SQL, and SAS/Macros.
• Daily generate consolidated reports and alerts using SAS.
• Developed various SAS / AF screens to publish teh SAS Datasets and reports / graphs.
• Developed programs to create daily HTML reports using ODS and CSV reports using Proc Export.

Environment: SAS9.3/9.2, SAS/Base, Macros, SAS Access, SAS DI, SAS AF/SCL, SAS Enterprise Guide, Windows, Enterprise Miner, SAS/BI, SAS/ETL, SAS/Connect, Teradata, DB2, MS excel, HTML, Linux, SQL and Javascript

Confidential, St. Francisco, CA

Sr. SAS Developer/Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Developed SAS code to manipulate raw data and validate data integrity.
• Benchmarked teh TEMPeffectiveness of AML data. Identified teh potentials for performance improvement.
• Consulted with end users, subject matter experts and other stakeholders to delineate and analyze business requirements.
• Refreshing teh SAS data marts on weekly basis for different brands. Scheduling different process using SAS DI studio scheduler and crontabscheduler.
• Understand and analyze teh layout of COBOL file to get teh positions of variables in raw file, to create appropriate SAS formats, informats for variables and identify teh “occur” blocks in teh file.
• Extracted teh data from Binary EBCDIC format raw files by using proper EBCDIC and S370ff informats.
• Created source to target data mapping documents and ETL design document.
• Worked closely with data analysis team like statisticians to analyze business related data, generate custom reports, tables and listings.
• Working to build analytics capabilities using SAS BI platform. Developed ETL processes using SAS DI studio- developing, automating and testing source to target mapping.
• Teradata tables and created Logical and Physical Data Models using Erwin design tool.
• Worked within teh SAS BI Enterprise utilizing an Oracle database and Windows server environment.
• Provided support on SAS EBI platform, portal, OLAP Cubes and dashboards.
• Extensively used various Base SAS procedures like Proc SQL, Proc Datasets, Proc Format, Proc Print and Proc sort.
• Provided analysis, development, and testing for SAS programs using Teradata datamart to consumer and small business areas for market analysis.
• Used SAS DI Studio for ETL processes (DB2, Oracle, SQL Server, Teradata, Text files)
• Reading teh Packed decimal and Zoned decimal data in IBM mainframe format.
• Created data sets from variable length multi format files having more TEMPthan one layout in a single file.
• Created data sets by reading multiple “Occur blocks” from COBOL raw file.
• Documented business requirements for necessary customizations to teh new application and reviewed teh customized components with teh business and developer team.
• Created and delivered reports and presentations with key findings and recommendations.
• Performed data quality analysis using advanced SQL skills.
• Provide technical support on SAS programming related to data manipulation and analysis.
• Created different user defined functions for applying appropriate business rules

Environment: SAS/Base 9.3/9.2, SAS/Macros, SAS/Stat, SAS/Graph, SAS/Connect, Telnet, Putty, MVS, VSAM, ALM, JCL, Cobol, SAS Enterprise Guide, XML,XSLT, XSD, XPath, windows, HTML, TSO, Copy Books, Linux, Integration Technologies, Javascript, ISPF ES 9000, OS/390, and Korn Shell Scripting.

Confidential, CT

SAS Analyst/Developer

Responsibilities:

• Worked with business users to design and develop several ad-hoc reports and information maps using Proc Report and Proc Tabulate.
• Teh reports created include Monthly summary reports as well as detailed weekly reports.
• Connected to teh DB2 database and extracted teh relevant data (using LIBNAME or Pass-through facility) and tan processed teh data using business logic to produce reports. Made heavy use of Proc SQL, Proc Report and ODS for producing these complex reports.
• Developed online claims reporting system to retrieve client records and create SAS Proc tabulate tables, Proc Freq, Proc Means, and Proc Report.
• Creating excel pivot table reports using Cycle Time data. These reports consist of Benefit level data, claims level data. These reports are very useful to get a greater insight into teh further plan design.
• Extensively used SAS Data Steps, Statistical models, and Flowchart Design, Listing, Graphing, Summarizing and Reporting procedures.
• Performed variety of tasks including data extraction, manipulation, Analysis using claims data.
• Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining.
• Tested and executed marketing campaigns using SAS Marketing Automation.
• Used EDW processes for replacing teh existing data, updating and appending teh data and dis data is used for generating reports as per teh requirement.
• Created various transformation procedures by using SAS ETL and SAS Enterprise guide.
• SAS Procedures used are Proc Append, Macros, Import and Export, Proc Transpose, Proc Datasets.
• Collected and maintained teh customer information through CIS.
• Developed and deployed SAS OLAP cubes for browsing of financial data via teh SAS Information Delivery Portal.
• Proficient in sorting, merging and using different table lookup techniques to get teh required information to generate teh report.
• Produced reports and complex data analyses using SAS, including SAS/stats, extracted data from MVS and Oracle files using SAS/Views, SAS Proc SQL and SQL.
• Debugging SAS programs using data null, Put statements and using datastep debug.
• Generated automated graphs for monthly run using Proc Gplot. Exported these graphs to Pdf File using SAS/ODS.
• Customizing teh existing Macros according to need and requirement, testing and debugging teh Macros and creating more complex and reusable Macros.
• Used Enterprise Guide (EG) query builder to run queries against teh tables and sub setting teh data
• Exported SAS Reports to teh Excel sheet by using ODS/Tagsets/ Excel XP to get output in multisheets. Used several Style Options.
• Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.
• Expert in preparing Analysis Datasets, Tables, Listings, and Graphs according to teh Business Requirement.

Environment: SAS/9.2, SAS/Base, SAS/Connect, SAS Macros, SAS/Access, SAS/ODS, SAS/Marketing Automation, SAS/ETL, SAS/Access, SAS/SQL, Oracle, Windows, MS Office, JavaScript, HTML, windows, HTML, SAS Enterprise Guide, and Unix.