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 the 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 the 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 the application to meet the 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.
• Effective 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, Charlotte, NC

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. Effective 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 the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data
• Created new financial tables and manipulated customer data by using various joins and merges and then appended the data (Proc append) from the 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 the 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 the Excel Sheet by using ODS/Tagsets/ExcelXP to get the output in multisheets.
• Developed and used scripts to schedule SAS Jobs.
• Customizing the existing Macros according to the need and requirement, testing and debugging the 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, NYC, NY

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 the 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 the 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 help 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 the 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 the 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 the 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 the 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, East Providence, RI

Sr. SAS Developer/Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Developed SAS code to manipulate raw data and validate data integrity.
• Benchmarked the effectiveness of AML data. Identified the potentials for performance improvement.
• Consulted with end users, subject matter experts and other stakeholders to delineate and analyze business requirements.
• Refreshing the SAS data marts on weekly basis for different brands. Scheduling different process using SAS DI studio scheduler and crontabscheduler.
• Understand and analyze the layout of COBOL file to get the positions of variables in raw file, to create appropriate SAS formats, informats for variables and identify the “occur” blocks in the file.
• Extracted the 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 the 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 the Packed decimal and Zoned decimal data in IBM mainframe format.
• Created data sets from variable length multi format files having more than 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 the new application and reviewed the customized components with the 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, Atlanta, GA

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.
• The reports created include Monthly summary reports as well as detailed weekly reports.
• Connected to the DB2 database and extracted the relevant data (using LIBNAME or Pass-through facility) and then processed the 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 the 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 the existing data, updating and appending the data and this data is used for generating reports as per the 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 the customer information through CIS.
• Developed and deployed SAS OLAP cubes for browsing of financial data via the SAS Information Delivery Portal.
• Proficient in sorting, merging and using different table lookup techniques to get the required information to generate the 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 the existing Macros according to need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.
• Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data
• Exported SAS Reports to the 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 the 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.