SUMMARY:

• Quality Control, Execution, and Maintenance such as Debugging, Enhancements, Testing of all delivered Production Code
• Strong understanding in various statistical concepts such as ANOVA, Pearson, chi-square test, T-Test, correlation, Regression Analysis and Multivariate Analysis
• Experience in all phases of Software Development Life Cycle SDLC including Requirements, Analysis/Design, Development and Testing
• Data warehouse, ETL- Extraction/Transformation/Loading, data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation.
• SQL Server 2008, DB2 and Tera data
• Experienced in developing code for the database applications to interact with the databases in Oracle,
• Created reports in PDF, HTML, XML, and RTF using SAS/ODS statements and data null .
• Extensive experience on SAS procedures like such as transpose, compare, append, import, export, SUMMARY, FREQ
• In-depth knowledge in SAS BI Tools, Such as SAS/DI, SAS/EG
• Expert in preparing code to Interface with Teradata, SQL database with UNIX and Windows operating systems
• Efficient usage of SAS tools such as SAS/Base, SAS/Access, SAS/Connect, SAS/SQL, SAS/STAT, SAS/Graph and SAS Macro
• Expertise in data step programming abilities for data manipulation, processing, quantitative, qualitative analysis and report generating.
• Over seven years of proven expertise in statistical analysis and strong modeling in Finance and Health care industries.
• Optimizing performance using various data validation and data cleaning methods on campaign data using statistical procedures
• Providing input in developing specifications of analysis datasets, validation plans and other related documents and determining, researching SAS software upgrades and related system maintenance issues
• Used advanced SAS tools to automate the reporting systems to generate daily and monthly reports for advanced premium, policy risk-in-force count , monthly claim count, claim recovers, claim outstanding reserves, paid claim reports, outstanding loss, agent commission etc
• Experienced with requirements analysis, development, testing, execution, maintenance, documentation, and archival of SAS reports
• provide more meaningful information vital to the overall strategies
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and
• Excellent communication, analyzing and report writing skill with ability for effectively communicate results of statistical analysis to diverse audience

Technical Skills:

• SAS Programming: SAS 9.3, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/CONNECT, SAS BI Tools, SAS Enterprise Guide 5.1
• Database: DB2, Teradata, Oracle10g,my SQL
• Operational Tools: UNIX, Windows 98/2000/XP
• Office Tools : MS office suite, Ultra Edit V11.2, ExamDiffPro, Lotus Notes, snagIt8.0

Professional Experience:

Confidential

Position: SAS Business Analyst

• Worked on extracting data from Oracle, DB2 servers to build data model to FRB submission
• Provided Statistical Analysis support for loans date using SAS/STAT and SAS/GRAPH
• Knowledge of cross-platform computing environment using SAS ,UNIX and relational database like DB2, Teradata
• Validating data and creating reports using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT etc. and SAS ODS facility
• Different Excel functions, tools used to generate Dashboards for higher management
• Expertise in analyzing the credit bureau data with FICO values and helps business to see growth in pricing changes, this helps to develop new campaigns and strategies
• Conducted edit check and validated the reports according to the Client and Advisors requirement for mortgage and asset management in the product development
• Assisted clients and partner integrators in data mining very large databases
• Handling and remodeling large complex data to get desired output
• Campaign optimization, analysis and tracking the campaign success, Generating Regular, Ad-Hoc Reports of CRM, MIS and Segmentation reports using SAS Tools and Oracle
• Extensively generated Monthly standard reporting using MS EXCEL and Pivot tables to calculate the fields' statistical summary
• Statistical validation of the forecast results using error estimation techniques
• Interpreting the results then report and present findings based on the trends in the data
• Respond appropriately and promptly to quality-assurance issues and concerns

Environment: SAS 9.3, SAS/BASE, SAS/MACRO, SAS/SQL, UNIX

Confidential

Position: SAS Analyst/ Programmer

Responsibilities:

• Respond and resolve ad hoc requests from application and business users
• Involving in various discussions with the team/client for business requirements, developing estimated timelines or updating management on deviations to these estimates
• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis
• Developed reports as per business requirements and created various reports like summary reports, tabular reports
• Extensively used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORT
• Used SAS extensively for match merge, append data validation, and data correction and cleansing
• Responsible for maintenance and enhancements in reporting systems using SAS/BASE, SAS/MACRO, SAS/SQL, SAS/PL SQL and SAS/GRAPH
• Interact with Business Analysts to understand Functional requirements and developed Technical specifications
• Create database objects like tables, views, indexes, sequences and triggers
• Convert different file formats XML, XLS, and CSV into Flat-files and load them into staging tables
• Write SAS scripts to handle high volume data manipulation and loading on to oracle/Teradata databases
• Development of standard SAS macros to be used throughout out the marketing campaigns
• Create electronic data sets i.e. SAS transport files for electronic submissions to the marketing vendor
• Created SAS Macros and SAS Graphics, and used PROC Report to generate reports
• Preliminary data validation is performed using PROC Compare of Base SAS
• Loading the results generated into a database called treatment contact history so that the campaign is tracked of the actual results
• Extensive usage of ODS statement for creating RTF, HTML and Excel files
• Implement ETL using SQL Loader, SAS and SQL / PLSQL
• Write wrapper UNIX Shell scripts for execution of BTEQ and SAS scripts using CRONTAB and AUTOSYS options
• Perform extensive end-to-end Code Testing
• Performs database imports, exports and data synchronization across the environments
• Develop new reports and modify existing reports as per the client requirements
• Production maintains, support and enhancements to existing applications

Environment: SAS 9.3, SAS/BASE, SAS/MACRO, SAS/SQL, UNIX

Confidential

Position: SAS Analyst / developer

Responsibilities:

• Created Analysis date set for staffing report using SAS/SQL, SAS/MACROS
• Campaign optimization, analysis and tracking the campaign success, generating regular and ADHOC reports for CRM, advisor and client using SAS Tools
• Reviewed and Developed SAS Program according to client request for opportunity management reports
• Generated market on demand MOD reports according to advisor's need using SAS/STAT, SAS/ODS and PROC REPORT
• Coordinated with Platform and Data supporting team to ensure the data integrity
• Extensively used SAS procedures like PROC FREQ, PROC MEANS and other statistical calculations for the data validation
• Generated reports to serve clients using a combination of stored processes, OLAP cubes, web reports and port lets
• Extracted data from the database using SAS/ACCESS, SAS/CONNECT and SAS/SQL procedures and created analysis data sets.
• Developed MACROS to generate monthly and quarterly reports as per the advisors proposal for the client request
• Re-structured the Data sets using PROC TRANSPORT procedure
• Performed data analysis, created reports with extensive use BASE SAS, SAS/MACRO and SAS/EG to clean and validate data
• Performed documentation and indentation of SAS code for the better understanding of the program
• Utilized data set options like keep, drop, rename, and compress as a part of storage efficiency and missover, truncover options in reading the raw data files

Environment: SAS 9.2, SAS/BASE, SAS/MACRO, SAS/SQL, UNIX

Confidential

Position: SAS developer

Responsibilities:

• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Assisted analytics teams to export SAS Enterprise Miner and Enterprise Guide code and make necessary changes to work in batch mode
• Involved in writing code using Base SAS, SAS/Macros and SAS Enterprise Guide to clean and validate data from oracle table.
• Extensively used SAS procedures like means, frequency and other statistical procedures for data
• validation
• Extensively generated Monthly standard reports using MS Excel and Pivot tables, spread sheet to generated calculated fields for derived matrices
• Performed Statistical Analysis with statistical procedures using Base SAS and SAS/STAT
• Data processing and validations on the SAS datasets using edit check programs.
• Developed binning criteria for continuous and categorical variables using Information Value IV criteria
• Developed Decision trees, logistic regression and neural networks using SAS Enterprise Miner and

Base SAS

• Restructured SAS datasets using PROC TRANSPOSE procedure
• Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML.
• Understanding of Inpatient Prospective Payment, Hospital Outpatient and payment mechanism
• Extensively used SAS web studio to generated Adhoc reports for business partners
• worked with large customer transaction data sets and generated graphs using SAS Report and SAS

Environment: SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS Enterprise Guide, Windows, UNIX

Confidential

Position: SAS Health

Responsibilities:

• Handled complex health care data to develop and produce standard and ad hoc reports
• Performed Teradata bases to extract and prepare data for analysis and reporting
• Involved in standardizing reporting procedures for graphical and tabular reports data extracted from Teradata database.
• Coordinated with internal and external customers in determining appropriate analysis plans and data extraction code specifications
• Wrote Output Delivery System SAS Procedures to publish reports as HTML pages to the web assisted data mining team to extract data patterns and trends from health care data
• Used procedures like PROC Freq, PROC Means, PROC Sort, PROC Print, PROC Tabulate, PROC UNIVARIATE and PROC Report
• Adapted code according to the client requirements and implemented necessary code updates for production reports.
• Experienced in risk adjustment reports for patient characteristics will necessitate higher utilization of medical services
• Generated summary reports using Microsoft office Excel and pivot table
• Data Fixing and Batch monitoring and performing troubleshooting of various issues ranging from batch programs

Environment: SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/GRAPH, SAS Enterprise BI Server SAS/ACCESS, SAS SAS/CONNECT

Confidential

Position: SAS/Statistical Analyst

Responsibilities:

• Maintaining large datasets, combining data from various sources in varying formats to create SAS datasets and / or ASCII files by using set and merge for generating Reports and Graphs
• 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
• Performed extraction, transformation and loading from large Teradata tables using PROC/SQL insert into statement
• Performed statistical data analysis, generated reports, listings and graphs using SAS/Base, SAS/Macros, SAS/SQL and SAS/Access
• Created reports in the style format RTF, PDF and HTML using ODS statements
• Worked with complex datasets to extract customized reports using procedures such as SQL, FREQ, SORT, REPORT and MEANS creating a preferred list of customers as per the given requirements
• Created cubes to display the report in multi dimensional view
• Created information map to display these cubes in the Web application
• Ran the SAS jobs in the UNIX environment
• Created the SAS job to run nightly to create the updated SAS datasets using SAS/data Integration studio
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies

Environment: SAS/BASE, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/CONNECT, Windows, UNIX