SUMMARY

• Over 7+ years of experience in Statistical Analysis, Reporting with Domain knowledge of Insurance, Pharmacy, Financial, and Banking industries.
• Experience in handling complex processes using SAS/BASE, SAS/MACROS, SAS /SQL, SAS/GRAPH, SAS/STAT, SAS/ODS, SAS/ACCESS, SAS Enterprise Guide, SAS DI Studio, SAS OLAP Cube Studio, SAS Web Report Studio.
• Development and Customization of SAS programs for Extraction, Transformation, Loading (ETL) and Data Analysis.
• Performances tuning using techniques like %INCLUDE shared code, MACRO Subroutines, USER Written Functions using PROC FCMP.
• Strong SAS/ACCESS experience to import data from various databases like MS - SQL Server, ORACLE tables into SAS using IMPLICIT and EXPLICIT pass-through facilities.
• Technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management experience.
• Produced Tables, Listings and Graphs (TLG) for the analyzed data.
• Used SAS DIRECT I/O for large datasets to achieve higher read-write speeds on SAS Dataset processing.
• Produced data in various output formats including HTML, RTF, PDF and PS using SAS ODS.
• Strong ANSI SQL experience in tuning code using techniques like Temporary tables and Indexes.
• Experience with Advanced statistical modeling.
• Descriptive statistics experience and understanding of statistical terminology and concepts.
• Data warehousing expertise and experience with querying large RDBMS tables (Data Mining).
• Worked in all phases of Software development Life-Cycle (SDLC).
• Experience in writing test cases, conducting testing, Data quality evaluations and verifying results (peer review).
• Experience in updating and creating documentation of code, guidelines, and high level systems documentation.
• Experience with Gathering requirements from end users.
• Mentored other team members by knowledge transfers, conducting one-on-one training in SAS and SQL.
• Exceptionally well organized. Ability to quickly adapt to new applications and platforms.
• Strong work ethics, positive attitude, analytical and communication skills.

TECHNICAL SKILLS

SAS skills: Base SAS, SAS/Macro, SAS/Connect, SAS/SQL, SAS/STAT, SAS/BI, SAS/Graph, SAS/IntrNet, SAS/ODS, SAS/Access, SAS Enterprise Guide, SAS Enterprise Miner, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio, SAS Forecast Studio, SAS DI Studio and Management Console.

SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, Reg, SQL, Copy, Freq, Forms, Upload, Download, Formats.

Databases: Access, SQL Server, MySQL, Teradata, Oracle.

Software packages: MS Office, Advanced MS Excel, MS PowerPoint, SQL Plus.

Reporting Tools: Base SAS versions 9.4/9.3/9.2, SAS Enterprise, SAS Graph, SAS BI Platform, MS-Visio, MS-Excel and MS-PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, Canton, MI

System Analyst / Data Analyst

Responsibilities:

• Research, analyze, identify and evaluate data from assigned problems to evaluate existing and potential trends and issues using SAS software.
• Assist in the development and implementation of drug utilization/drug use management and review programs, medication therapy management and with emphasis on CMS Star Ratings.
• Develop, implement and maintain reporting on clinical analysis. Support vendor management frame work for PBM.
• Quality check pharmacy data for accuracy and compliance.
• Recommend, communicate, and implement solutions to pharmacy claim processing issues and remediation.
• Provides guidance concerning business implications of application development projects.
• Involved in testing of applications, data and reports.
• Worked on Technical Solution Document, which included ETL designs for the SAS Data Integration (DI) development.
• Involved in designing job flows using SAS DI to extract data from source systems, perform required transformations and load back to target.
• Provided technical support to end users on SAS, SAS Enterprise Miner, SAS Enterprise Guide, SAS DI Studio and SAS BI Suite.
• Involved in creating ETL jobs in SAS DI based on Technical Solution Document.
• Working extensively in sorting, merging, concatenating and modifying SAS data sets in different environments like Windows and Unix.
• Extracted data from the database using SAS/Access, SAS SQL Procedures and create SAS data sets.
• Solid understanding and proficient use of various Procedures like Proc SQL, Proc Summary, Proc Report, Proc Freq, Proc Means, Proc Contents, Proc Dataset, Proc Append, Proc Import, Proc Export, Proc Print, Proc Sort.
• Responsible for Programming in SAS using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.
• Extracted, performed validation and generated SAS data sets from Oracle, Teradata applied SQL Pass through Facility.
• Developed new Macros for report generation using SAS/Macros as per the customer's requirements.
• Retrieved millions of records using various Procedures.
• Involved in code migration across multiple environments, maintenance of all the Table scripts needed during migration.
• Done code and data validations while moving across multiple environments.

Environment: SAS Base 9.4/9.3, SAS/Macros, Enterprise Guide, SAS/Stat, SAS/ODS, SAS/Access, SAS Data Integration Studio, SAS Management console, SAS Information Map Studio, SAS Web Report Studio, SAS Model Manager, Oracle, IBM Clear Case and Clear Quest.

Confidential, Watchung, NJ

SAS Programmer

Responsibilities:

• Used PROC/SQL to fetch tables from Teradata warehouse.
• Merged tables by using PROC SORT.
• Random sampling using PROC SURVEYSELECT.
• Performed logistic regression on each variable and then delete the redundant ones.
• Used APPEND to generate the outcome variable table.
• Checked outliers and missing values using PROC UNIVARIATE and PROC FREQ.
• Macros were employed for data transformation and filling up missing values.
• PROC VARCLUS was used to check the collinearity among explanatory variables.
• Performed logistic regression on newly selected variables.
• Created LIFT probability table and GAIN chart.
• Model monitoring and verification

Environment: UNIX /Windows, SAS/BASE 9.2, SAS/STAT, SAS/ODS, SAS/GRAPH, SAS/REPORT, MS Excel, Essbase, SQL.

Confidential, Charlotte, NC

SAS Analyst

Responsibilities:

• Designed analytical solutions to provide accurate tracking of containers which resulted in smooth transition to automated tracking.
• Successful in identifying the problem areas and improved equipment management decision making.Led initiatives to determine inefficiencies and optimize movement of containers resulting in considerable savings in operating costs.
• Identified key measures for calculating empty equipment costs using location costs in evacuation paths and analyze available data to get daily stock.
• Created smart quality control solutions and worked closely with technology groups to resolve issues with upstream data.
• Worked with Teradata to process huge volumes of data to convert into solutions which are easily consumed by reporting and analytical users.
• Created design proposals & relevant documents for implementation of large scale ETL solutions.
• Assisted business partners and colleagues for business related queries and was the point of contact for the off shore team.
• Highly skilled in SAS metadata and partnered with data mart owners to validate data sanctity and investigate issues.
• Performance tuning of SAS components and Automation of manual processes.
• Worked on SAS/MQ interfacing and Crontab for job scheduling.
• Managed production support for critical processes and resolved complex execution issues and production problems on critical scenarios.
• Mentored new team members for technical / process documentation as per needs of project methodology.

Environment: Base SAS 9.3, SAS/Macros, Teradata, SAS/Access, UNIX, Message Queue Series, LSF Scheduler, Business Objects, Crontab

Confidential, Union, NJ

SAS Programmer

Responsibilities:

• Created reports of various types which include sales, consumption and usage all fuel types and services offered by the company to the fleet core.
• Monthly transaction data and annual balances of the credit accounts for all types of credit cards are reported in the month-end reports.
• Used SAS ODS and Proc Export steps to create all the reports as user interface was completely based on the Windows environment
• SAS Macros was used in generating reports with large but repetitive programs, which only require variable changes were run in loops to save time and effort.
• Raw data files in Excel and RTF formats in SAS for invariably short or unrelated data requested for a report was used to append or merge in SAS to obtain desired reports.
• Experienced in handling Terabytes of records and manipulating them through SAS.
• Analysis included Fleet Size Analysis, Segmentation, Predictive Modeling, etc.
• 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 Oracle DB.
• Used SAS data step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data to produce required reports.
• Created various summary reports of total sales, regional sales and account sales of various partners.
• Documentation, presentation, data reports and model results to the team/manager.
• Used various statistical procedures like Proc Freq, Proc Reg to analyze data and generate reports.
• Communicated with various personnel in the sales group and the statistical group for specific reports and presentations to new and existing clients.

Environment: SAS 9.3, SAS/Base, SAS Macros, SAS ODS, SAS/Graph, SAS Enterprise Guide, SQL, MS Access, Excel, Windows and Unix.

Confidential, Mellon, NY

SAS Programmer / Analyst

Responsibilities:

• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Unix environment
• Created macro program to create Macro variables to pull data from Oracle and SQL server for monthly data extracting.
• Performed daily weekly and monthly campaigns as per the deliverable schedules.
• Creating waterfall reports and analyzing data and creating ad-hoc on deliverables.
• Advanced analytics and reports created based on the criteria provided.
• Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Automated the existing audit reviews and production.
• Performed approvals for peer audit reviews on reports by analyzing data.
• Developed SAS Macro programs to create ad-hoc reports.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Importing all Reports from Web Report Studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• 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.
• Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
• Created dynamic Macro arrays by SQL and with data step programs.
• Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting.
• Created reports using Proc Report, Proc Tabulate, ODS statements and Proc Template to generate output formats in HTML, Excel, PDF and RTF.
• Documented the code and algorithms logically.
• 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 9.2, SAS/Access, SAS/Base, SAS/Macros, SAS/Stat, SAS/Graph, SAS/SQL, SAS BI, SAS Web Reporting Studio, SAS DI Studio, Oracle, MS Office, Window and Unix.

Confidential, CA

SAS Developer / Analyst

Responsibilities:

• Performed QA/QC of Tables, Listings & Graphs (TLGs), CSRs and SAS code to ensure the production of high quality statistical outputs in a timely fashion.
• Created analysis datasets, assesses quality of data analysis programs, and develops automated analysis tools where appropriate.
• Assessed the quality of analysis data and performs cross-study analyses.
• Used internal macros to automate statistical table, figure, and listing production.
• Worked on multiple studies at the same time.
• Reviewed draft and final production runs for project to ensure quality and consistency.
• Maintained complete and auditable documentation of all programming activities.
• Followed good programming practices.
• Participated with and in cases leading process and technical improvement initiatives.
• Performed general duties as required to support company objectives.

Environment: SAS 9.2, SAS/Base, SAS/Macro, SAS/SQL, SAS/Stat, SAS/Graph, SAS/Access, SAS/ODS, MS Access, MS Office.