SUMMARY

• Certified SAS Professional with 8 years of working experience in HealthCare, financial and Pharmaceutical industries.
• Experience working in SAS BI platform with Enterprise Guide 4.2/5.1, SAS Web Report Studio 3.1/4/2, SAS Information Map Studio 3.1/4.2, SAS Information Delivery Portal, SAS Add-in for Microsoft Office, SAS Stored processes on 9.2/9.3
• Proficient in SAS/Base, SAS/Macro, SAS/SQL, SAS/Connect, SAS/STAT, SAS/Access, SAS/Graph, SAS ETL studio, SAS/EG, SAS/AF and SAS/ODS in UNIX and Windows environments.
• Supporting and maintaining different applications like SAS Enterprise Guide, SAS OLAP Cube Studio, SAS DI Studio, SAS Information Map Studio, SAS Information Delivery Portal, SAS Web Report Studio.
• Worked closely with Business users in gathering the requirements for project documentation and generated reports. Involved in all stages of SDLC Software Development Life Cycle .
• Expertise with various SAS procedures like Proc Means, ProcFreq, Proc Sort, Proc Format, Proc Report, Proc Tabulate, Data NULL , Proc Print, Proc Summary, Proc SQL, Proc Import, Proc Export for importing and exporting data, Proc Contents and Proc Datasets to view the contents of the SAS libraries.
• Experience in data cleansing, data archival, data migration, data manipulation and generating customized reports with SAS data steps and procedures on various environments.
• Created various output styles based on the business requirements using ODS statements.
• Worked on SAS datasets using the ETL concepts to increase the overall performance andfamiliar with the concepts of OLAP, Stored Procedures.
• Responsible for Data extraction from several databases including Oracle, SQL Server and other external files.
• Extensive experience in RDBMS like Oracle, SQL Server, DB2, MS Access, Teradata.
• Demonstrated high energy, professionalism, strong problem solving, decision-making and interpersonal skills. Possess leadership skills as well as the ability to work independently and on a team.
• Experience on creating web reports using SAS Web report studio on both front end and back end.
• Ability to work in self-directed environment and very good team player with excellent analytical and problem solving skills.
• Have theoretical Knowledge on SAS Visual Analytics tool and also have good knowledge on SAS 9.4 updates and upgrades for SAS 9.4 BI tools.

SKILLS

TECHNICAL SKILLS:

PROFESSIONAL EXPERINCE

Confidential

SAS BI Developer

Confidential is a global medical technology company that manufactures and sells medical devices, instrument systems and reagents. As a SAS BI developer supported the BD diagnostics organization to provide technical BI skills in the analysis, design, development and production support of BD Diagnostics' BI solutions primarily supporting SAS BI with future technical transition to SAP BI environment.

Responsibilities:

• Gathering, compiling and analyzing business requirements for reporting related requests translate high level business requirements into design specifications and manage changes to specifications in SAS applications.
• Managing assigned SAS production support work for established reporting applications and processes enabling delivery of detail reporting and analytics associated with critical business functions.
• Serve as a technical subject matter expert working with internal customers which includes Integrated Supply Chain i.e. Manufacturing and Planning Customer Facing i.e. Sales and Service Shared Services i.e.Finance and HR and Product Innovation i.e. Quality and R D and other team members to develop reporting solutions in SAS with future transition development skills to SAP BW.
• Performing software development for Data Warehousing computer systems within standard BD environments. Develop code according to specifications and conduct technical unit testing and systems testing.
• Providing accurate estimation of the level of effort required for various assigned tasks and provides work estimates to overall project plans.
• Generating SAS EG stored processes with static and dynamic prompts for product-specific analyses.
• 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.
• Pulling the data in SAS using Proc SQL and refresh the data mart on daily, weekly and monthly basis.
• Importing SAS datasets, OLAP Cubes in SAS Information Map Studio .Using instructions on how to access and combine relational Data tables, calculating new data items, created multiple pre-defined filters.
• Building Quick Reports from Web Report Studio using Information maps, create filters, graphs, and customize reports.
• Produced various reports based on frequency On-Demand, Daily, Weekly, Monthly, Annually, etc. Extensively used SAS ODS to create the PDF and EXCEL reports.
• Worked with data conversion and loading history data from SAP R/3 to SAP ECC in the Everest project and handling cutover issues.
• Worked on scheduling the jobs and also monitored the jobs in the production environment.
• Also engaged in SAS peer code review, after completing every code, and checked for SQL standards and complete documentation and maintained a record on the share-point.

Environment: SAS/Base 9.1.3, SAS/EG 4, SAS/Macro, SAS/Access, SAS/Connect, SAS/ODS, SQL server, SAS/OLAP CUBE Studio, SAS BI Dashboard, SAS Stored Processes Web Application, SAS Management Console, SAS Web Report Studio, Oracle 11g, SQL Server Management Console, SAS Enterprise BI Server.

Confidential

Sr. Business Technical Analyst/Lead

Confidential. provides managed care services exclusively for government sponsored health care programs, focusing on Medicare and Medicaid. As a Senior Business Analyst lead in the development of complex adhoc reports and involved in special projects requiring a high degree of confidentiality and expert knowledge of multiple departments within the company. I have also been involved in HEDIS reporting to NCQA.

Responsibilities:

• Evaluated financial impact of implemented initiatives and prepared using SAS EG and presented detail and summary level reports including data driven business recommendations and alternatives.
• The main responsibilities in this position are to enable process and trend analysis and provide recommendations for the implementation of new/revised operational and/or reporting processes.
• Developed ad-hoc reports using SQL Pass through, libname Statements and PROC SQL to interact with different RDBMS like Oracle, SQL server.
• Analyzed data using PROC FREQ, PROC MEANS, PROC Transpose and PROC PLAN to effectively and efficiently coordinate quality activities and improve performance metrics of organizational goals.
• Performed activities to comply with annual HEDIS data collection and analysis, preparing recommendations to increase rates as appropriate.
• Planned, organized and managed the design, development and analysis of a wide variety of Telephonic Outreach Programs.
• Used SAS/GRAPHS to build reports with drill through capability.
• Extensively used ODS HTML, ODS PDF, ODS RTF to prepare, compile, review and submit monthly and quarterly reports for quality committee meetings.
• Participated in the development, review and updating of various reports in the department using SAS Macros.
• Created PROMTs in SAS EG to provide parameters as necessary.
• Developed P4P database, MIP database and CM database using Microsoft Access and debugged various SAS Macros in producing the member mailing letters in PDF format from SAS.
• Update the databases and maintain the databases for any user issues, modifications and concerns in the forms reports and data errors.
• Performed statistical analysis to analyze the performance of various member outreach programs and various PIP's.
• Created process flow jobs in EG for the better understanding to the client and generated reports as required to handle business.
• Used Transformations that are provided in SAS EG to develop process flow to generate reports to handle business requirements.
• Used GMAPS to generate reports that are used for the better representation of the data.

Environment: SAS/Base 9.3, SAS/EG 5.1, SAS/Macro, SAS/Access, SAS/Connect, SAS/UNIX, SAS/ODS, SQL server, SAS/OLAP CUBE Studio.

Confidential

SAS BI Developer

Confidential provides deposit, lending, cash management and investment services to more than 5 million consumer and small business customers across 16 states in U.S. This Project involves supporting the Marketing and Sales groups with Data replatedAdhoc requests, building/maintaining data mart and generating reports.

Responsibilities:

• Created Global Market View SAS Datamart and designed star schema for efficient querying and reporting. Automated the Monthly, Quarterly and Half yearly Production process using shell scripts and setup cron jobs to schedule them on the UNIX box. Experience working with different kinds of data like Dun and Bradstreet and Harte Hanks to do analysis on customers and identifying new opportunities. Analyzed different internal data like Campaign, Opportunity and supported adhoc request from business. Regularly involved in Data preparation, Data manipulations and formatting to support the statisticians with their models. Regularly used SQL Pass through, libname Statements and PROC SQL to interact with different RDBMS like Oracle, Teradata. Created Stored Processes for the business to generate different adhoc reports based on the parameters popups. Have experience creating information maps, which would be utilized by web report studio and BI Dashboards to generate dynamic reports. Built reports using Web Report Studio and Information Delivery Portal. Created adhoc Reports using SAS Add-in for Microsoft Office. Designed and developed Stored Processes and Macros with SAS/EG to support ad hoc requests. Used Multiple Transformations in SAS DI Like CDC, SCD Type2, Spliter, Transpose and Etract, Join, Merge and Lookup Transformations etc., Built Lots of Custom transformations to handle business requirements. Built OLAP Cubes on the datasets and as well created custom measures using MDX language for handling business requirements. Created IMAPS on Cubes as well as on SAS tables using custom measures, filters, conditional formatting to create reports later on. Created WEB Reports and Dasboards using WRS and BI Dashboards.
• Generated simple statistics of the data using PROC MEANS, PROC FREQ and data analysis.
• Created XLSX, XLS pivot tables and reports using PROC EXPORT and DDE Techniques for analysis.

Environment: SAS 9.2, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/Access Oracle / Teradata , SAS/Connect, Stored Process, SAS/Information Map Studio, SAS/Web Report Studio, SAS Add-in for MS Office, SAS/STAT, SAS/EG, Excel, UNIX HP-UX , Windows

Confidential

SAS/SQL Programmer

Involved in creating efficient method of reviewing information from company data database and generating various reports which is a key parameter related to understanding the status of regional business, supporting business in performing analysis decision making and performed analysis on data using SAS code on high risk patients and reported the data to the health care professionals, improved client services by preventing errors, providing a real-time data and updating record.

Responsibilities:

• Interacted with business users, business analysts and translated business requirements into technical specifications.
• Responsible for writing SAS programs using Base SAS and SAS/Macros to create SAS reports.
• Extensive study, design, development and testing were carried out in the Oracle Environment
• Extensively involved in getting data from oracle database using SQL pass- through. Involved in writing code using SAS/ Base SAS/Macros for creation of analysis datasets.
• Performed data cleansing to eliminating duplicate and inaccurate data.
• Developed and executed SAS SQL queries for merging, concatenating and updating large volumes of data.
• Generated high quality reports and listings in HTML, EXCEL and PDF formats using SAS /ODS.
• SAS/Enterprise Guide software was used for file and program management purposes.
• Creating various transformation procedures by using SAS 9.1, SAS Data Integration Studio, and SAS Enterprise guide.
• Using the Enterprise Guide Stored Processes, updating and developing macro programs code.
• Customizing Indicators, Indicator Data in BI Dashboard according to the requirement.
• Knowledge about the SAS Metadata Server and Data Warehousing development
• Used SAS OLAP Cube Studio and build OLAP Cubes and Created Custom measures using MDX.
• Designed ETL process to meet the requirement of data demand.
• Created required Data marts, OLAP Cubes, IMAPS using SAS DI Studio,SAS OLAP Cube Studio, IMAPS to fulfill reporting requirements.
• Scheduled SAS DI Jobs using LSS Scheduler.
• Worked on analyzing the code in Stored Processes and used these stored process in WRS to generated reports for the business.

Environment: SAS/Base 9.1, SAS/EG 4.0, SAS/Macro, SAS/Access, SAS/Connect, SAS/UNIX, SAS/ODS, SAS/Macros, ORACLE 9i, TOAD, SQL, MS Excel, Autosys, SAS/OLAP CUBE Studio, SAS/DI Studio, SAS/IMAPS, SAS/WRS.

Confidential

SAS Programmer

Confidential Tool builds on the SAS campaign management software, which is used to select specific target groups and define a campaign, in other words which customers should be contacted, when, about what and through which channels. Once the target group has been selected, the campaign is launched through different channels, depending on which is the best way of reaching the target group. The bank currently has four channels for direct sales: eBanking, direct mail, customer portal branch and Outbound.

Responsibilities:

• Support Team members in Day to Day Operations for different aplications which Contains Daily Monitoring of the Batch Jobs
• Build the Information Maps using Meta Data.
• Creating jobs to populate target data with source data using data transformations.
• Extensively used SQL Join, SAS Splitter, SAS Sort, SAS Ran.
• Performed Data Validation, Extract, Fact table look up, User written code Transformation to specify the code to load the tables.
• Extensively used PROC SQL, PROC SUMMARY, PROC APPENED, PROC SORT.
• Analyzed various tables using Data manipulation techniques like merging, appending and sorting.
• Generating reports Listing, Summary, Frequency, Correlation, etc. by using Report transformations List data, Summary Statistics Report, Frequency Report, Correlation-Report, Distribution Analysis .
• Defining stored process.
• Involving in creating cubes with fact tables and dimension tables in data warehouse environment.

Environment: Windows, Sql Server, DB2, SAS 9.1, SAS Information Map Studio, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Delivery Portal

Confidential

Biostatistician

Confidential. is a research-driven, global, fully integrated pharmaceutical company. The Company is a leader in India in the discovery of new molecules and is focused in the areas of inflammation Asthma/COPD, etc and metabolic disorders Diabetes, Obesity, etc .

Responsibilities:

• Provided multi-skilled, mid level support for the Statistical functions of the organization
• Worked on 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.
• Transferred and migrated data from one platform to another to be used for further clinical analysis. Extracted data from Oracle using SQL Pass through facility or Libname method and generated ad-hoc reports.
• Collected, analyzed and prepared statistical reports from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Prepared, documented and tested required programs and procedure data displays in an efficient manner for inclusion in integrated clinical, statistical summary reports and other reports.
• Supported other team members in designing and developing application programs.

Environments: WINDOWS, SPSS, MS Excel