Professional Summary:

• Senior SAS professional with around 6 years of experience in developing software applications for Pharmaceutical, Financial, Health Care and Insurance sectors. Experience working in SAS Business Intelligence BI platform with Enterprise Guide 4.1/4.2/4.3/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 2.1/4.2, SAS Stored Processes on 9.3 Extensive experience supporting different applications like SAS Enterprise Guide, SAS OLAP Cube Studio, SAS Data Integration Studio, SAS Information Map Studio, SAS Information Delivery Portal and SAS Web Report Studio. Proficient in SAS v8.2/9.1.3/9.2/9.3, SAS/BASE, SAS/MACROS, SAS/Connect, PROC SQL, SAS/Access Oracle/Teradata and SAS/ODS. Experience in working with SAS on different platforms like UNIX LINUX, AIX, HP/UX, SOLARIS and WINDOWS 9x/2K/NT/XP. Extensively worked on various RDBMS like Teradata, Oracle, DB2, SQL Server.
• Extensive working knowledge of Good Clinical Practice GCP , Good Programming Practice GPP , Code Of Federal Regulations 21 CFR part 11 and clinical terminology.
• Experience in Business Evaluation and Analysis. Extensive Experience in arranging and participating in meetings with Business Users and suggesting recommendations for improving system performance. Proven skills in data cleansing, data archival, data migration, ad-hoc reporting, and coding using SAS on various environments. Involved in all stages of SDLC Software Development Life Cycle . Thorough Knowledge and experience in Microsoft Office tools like MS Access, MS word, MS PowerPoint, MS Excel. Experience in handling software development, enhancements, testing and documentation. Excellent communication and interpersonal skills. Proven abilities in establishing effective task priorities as a team player with result oriented attitude.

TECHNICAL SKILLS:

Statistical Software: SAS/BASE, SAS/MACRO, PROC SQL, SAS/Access, SAS/EG, SAS/STAT, SAS/Access, SAS/CONNECT, SAS/ODS Business Intelligence: SAS Management Console, SAS Data Integration Studio, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Report Studio, SAS Information Delivery Portal, Enterprise Guide and SAS Add-In for Microsoft Office Database: Teradata, Oracle, DB2, MS-SQL Server 2000, MS Access. Operating Systems: UNIX, MS Windows 95, 98, 2000, NT, XP , MS-DOS, MVS. Web Development: ASP, HTML, DHTML, XML, JavaScript. Development Tools: MS Office Word, Excel, Power Point, Access OOD Suites: Microsoft Visio, UML.

PROFESSIONAL EXPERIENCE:

Confidential

SAS Developer Description:

The Newyork State Department of Health NYSDOH implemented NICS National Instant Criminal background Check System is used by Federal Firearms Licensees to instantly determine whether a prospective buyer is eligible to buy firearms and explosives.

Responsibilities:

• Worked with Business team to analyze and understand the changes involved for the new business needs. Analyzed the oracle data warehouse to design the ETL process and implement the Business logic required using Data Integration Studio. Extensively used SQL Pass thro for pulling data from Oracle and SQL Server Designed and developed code using SAS/EG for various NICS Reports. Created Stored Processes for the business to generate different ad hoc reports based the parameters passed. Involved in developing web forms for an internal application using web technologies namely HTML and JavaScript. Have experience in creating information maps which would be utilized by web report studio to generate static reports. Worked with large datasets to produce tables, figures and listing reporting for Various NICS reports. Manipulated and updated the tables per specifications. Created new datasets from raw data files using import techniques and modified existing datasets using set, merge, sort, update and conditional statements Performed complex statistical analysis using PROC MEANS, PROC FREQ.
• Environment: SAS/BASE, SAS/MACROS, PROC SQL, SAS Enterprise Guide, Information Delivery Portal, Stored Process Web Application, MS Excel, UNIX SOLARIS , Putty, WinSCP, SAS/Access Oracle and SQL

Confidential

SAS Consultant Description:

The North Carolina Department of Revenue DOR contracted with CGI to implement integrated Tax Information Management System TIMS . The goal of the engagement is to assist DOR create a modernize tax administration organization that leverages technology to improve customer service, accelerate taxpayer compliance, generate additional revenues for state government operation, and meet new challenges.

Responsibilities:

• Actively worked on the development needs of the TIMS Reports. Responsible for Jira tickets that were raised by end users and actively resolved the issues. Designed and developed code using SAS/EG for various Taxation Reports. Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create reports as per the business requirements. Imported data using SQL Pass-Thru facility to reduce the processing time. Developed SAS macros to simplify SAS code and efficiently reduced coding time. Used proc report and various procedures to build the desired reports. Extensively used SAS ODS to create the customized reports in PDF, Excel. Developed complex reports using Proc Report and incorporated ODS destinations with all required customized formats. Extensively created SAS stored process for the reports to publish them in web using Information Delivery Portal.
• Built Information maps using Information map studio which were utilized Information Delivery Portal.
• Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Oracle DB.
• Initially created tables and views in Oracle and used a BI/Query model for local users to access the data tables and reports.
• Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.
• Automated the Monthly, Quarterly and Half yearly Production process using shell scripts and setup corn jobs to schedule them on the UNIX box. Environment: SAS/BASE, SAS/MACROS, PROC SQL, SAS Enterprise Guide, Information Delivery Portal, Information Map Studio, MS Excel, UNIX SOLARIS , Putty, Windows, SAS/Access Oracle Confidential SAS Consultant Description: CVS Caremark is a health care provider with a vast IT structure. This project involved support for the Hercules development and testing of the same application to accommodate new changes and requirements.

Responsibilities:

• Actively worked on the development needs of the Hercules stabilization. Provided updates to the senior team members on the analysis of different testing cycles. Responsible for heat tickets that were raised by end users and actively resolved the issues. Proactively provided improvement and optimization ideas on the design on the data warehouse.
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.
• Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Teradata DB.
• Initially created tables and views in Teradata and used a BI/Query model for local users to access the data tables and reports.
• Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.
• Involved in Documentation, presentation, data reports and model results to the team/manager.

Environment: SAS/BASE, SAS/MACROS, PROC SQL, SAS/STAT, SAS Enterprise Guide, MS Excel, UNIX SOLARIS , Windows, Teradata, SQL Server, SAS/Access Oracle, Hercules, Mainframes Confidential SAS Consultant Description: BCBS is one of the largest health care providers in Florida. This Project involves supporting the Actuarial and Analytics group with building ETL processes, reports to accommodate their new business needs.

Responsibilities:

Worked with Business team to analyze and understand the changes involved for the new business needs. Analyzed the oracle data warehouse to design the ETL process and implement the business logic required using Data Integration Studio. Hands on experience working on health care data including revenue, membership, claims and cost of health care data. Built automated process to pull data from Oracle and load the resulting Flat files into Access and SQL Server. Responsible for running of productionalized programs on monthly, quarterly basis. Extensively used SQL Pass thro for pulling data from Oracle and SQL Server Designed and developed code using SAS/EG. Built Cubes using OLAP cube studio which were utilized in Web Report Studio and Information Delivery Portal. Hands on experience in using Enterprise Guide for building Stored Process. Automated reports using SAS Add in for Microsoft Office. Extensively used Humming bird for FTP purposes. Environment: SAS/BASE, SAS/MACROS, PROC SQL, SAS/STAT, SAS Enterprise Guide, SAS DI Studio 4.2, SAS OLAP Cube Studio, Web Report Studio, Information Delivery Portal, Excel, UNIX SOLARIS , Windows, Oracle, SQL Server, SAS/Access Oracle, Humming Bird Exceed

Confidential

SAS BI Developer

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 corn 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 thro, libname Statements and PROC SQL to interact with different RDBMS like Oracle, Teradata. Created Stored Processes for the business to generate different ad hoc reports based on the parameters passed. Have experience creating information maps which would be utilized by web report studio to generate static reports. Built reports using Web Report Studio and Information Delivery Portal. Automated Reports using SAS Add-in for Microsoft Office. Designed and developed code with SAS/EG to support ad hoc requests. 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 SQL/SAS Programmer Responsibilities:

• Produced various graphical reports such as Bar Charts, Line Plots, Profiles Chart, Scatter plots using SAS/GRAPH.
• Worked on Phases I, II III clinical trials.
• Designed and implemented statistical reporting processes for clinical data Phase I and II analysis.
• Performed Program Documentation on all programs, files and variables for accurate historical record and for future reference.
• Created and maintained SAS programs to generate derived datasets and required summary reports.
• Develop SAS programs to generate randomization lists, statistical reports and graphs.
• Worked with presentation and reporting procedures like FORMAT, REPORT, PRINT, SORT, etc.
• Participated in designing, coding, testing, debugging and documenting SAS Programs and Macros.
• Used SAS procedures like Transpose, Summary and contents.
• Was involved in validation of tables, listings and datasets using procedures like PROC COMPARE and PROC FREQ.
• Using SAS statements like DLM, DSD, and COMMA9. TRUNCOVER, MISSOVER to get rid of erroneous data.
• Performed Data Analysis on the data sets using PROC MEAN, PROC FREQ and PROC TRANSPOSE.

Environment: SAS /BASE, SAS /MACROS, SAS/CONNECT, SAS/ACCESS, SAS/SQL, SAS/GRAPH, MS Excel, SQL Server, Windows NT.