Summary:

• Experience in the Client/Server Technology, Designing and Developing SAS Applications and working with tools like Base SAS, SAS/Macros, SAS/ODS, SAS Libraries, SAS/Graph, SAS/Access, SAS/SQL, SQL Server, Oracle 9.0, UNIX.
• Firm understanding of SAS Programming and List Processing. Utilize technical skills with SAS, SQL, and Database concepts to develop, test and control reports as required. Ability to turn business requirements into Technical Design specifications and documents, SAS Programs, and SQL Queries as appropriate. Capable of working with cross-functional teams to manage projects, determine prioritization, and create appropriate timelines.
• Extensively worked with Health care claims Medical, Pharmacy using CPT codes, ICD-9, NDC codes etc.,
• Development and Implementation of Process Improvements. Demonstrate the ability to self-manage and multitask in a dynamic, ever-changing environment.
• Proficient in Oracle Database, SQL Server, DB2.
• Data Analysis using SQL, Teradata SQL Assistance.
• Professional Experience with Import Various External Data Files into SAS Dataset / SAS Library by Using SAS/ACCESS, SAS/INFILE, SAS/IMPORT, SAS/SQL.
• Proficient in using ODBC to Connect SAS System with Relational Database Management Systems, Such as DB2 and Oracle to Retrieve Data and Create SAS Datasets.
• Worked with Risk Management team in predictive future risks by analyzing past data.
• Excellent Experience with Export SAS Results to Different Format, Such as XML, Excel Using SAS/EXPORT, SAS/ODS for Reporting and Presentation.
• Experience in Data Analysis using SAS statistical procedures.
• Excellent Presentation Skills by Using Microsoft PowerPoint, Data Flow Chart, SAS Table, SAS Graph, SAS Chart.
• Scheduled and monitored jobs across environments using SAS Management Console.
• Formal Education and Solid Broad Knowledge in Computer Science, Focus on Relational Database Systems and Programming, Worked with BA and Marketing Business owners in understanding requirements, Research and Analysis for a List campaign.
• Extensive Experience in Microsoft Office Suite, Include Microsoft Word, Excel, Access, PowerPoint, Outlook, and Project.
• Excellent Organizational, Teamwork, Presentation and Interpersonal Skills.
• Applying Critical Thinking, Problem Solving, and Decision Making Skills, to Dismantle Complex Problems and Optimize Solutions.

Technical Skills:

• SAS Tools : SAS/BASE 9.3/9.2/9, SAS/MACRO, SAS/SQL, SAS/EG, SAS/STAT, SAS/Access,
• SAS/Connect, SAS/ODS.
• SAS BI Tools : SAS Enterprise Guide, Base SAS, SAS Data Integration Studio, SAS Management Console, SAS BRM,
• Database : Oracle, DB2, SQL server, Teradata.
• GUI tools : Toad, Teradata SQL Assistance, AQTv9.
• Operating Systems : Windows 95/98/XP, UNIX.
• Development Tools : MS Office Word, Excel, Power Point .

Professional Experiences:

Confidential

Developer/Data Analyst

Responsibilities:

• Involved in code migration from PC SAS to SAS EG.
• Understand the existing code and make changes for more performance tuning.
• Develop code for automating FILMS project, which creates final Journal entry for set of requirements.

Environment: PC SAS 9.2, SAS Enterprise Guide 5.1, IBM DB2, MS-Office.

Confidential

SAS Programmer/Data Analyst

Responsibilities:

• Use SAS/BRM to integrate all the business rules and then invoke them back into SAS DI jobs.
• Perform Source system analysis on the available source data, which was needed as part of RTE Data Model design.
• Design job flows using SAS/DI to extract data from source systems, perform required transformations and load back to target.
• Worked on Technical Solution Document, which included ETL designs for the SAS DI development.
• Prepared Functional Solution Document as part of Revenue Attribution based on the Business requirement document provided.
• Involved in design and development of entire life cycle of Revenue Attribution project.
• Design base tables structure, which will also be used for reporting purpose as well as in RTE.
• Created ETL jobs in SAS DI based on Technical Solution Document. These jobs included coded algorithm and rules created in SAS BRM.
• Working extensively in sorting, merging, concatenating and modifying SAS Data sets in different environments 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 print, proc sort.
• Thorough knowledge in SAS Programming, 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 Teradata applied SQL Pass through Facility.
• Retrieving Millions of Records Using different Procedures.
• Job scheduling using SAS Management Console and monitoring jobs using Process Flow Manager and using commands on Unix.
• Involved in code migration across multiple environments. Maintenance of all the Table scripts needed during Migration.
• Played a vital role as SAS DI lead to guide Offshore Team.
• Done code and data validations while moving across multiple environments.
• Involved in production support L1 support working on issues raised on production jobs.
• Working knowledge on LSF monitoring and support.

Environment: SAS DI studio 4.6, SAS Management Console 9.3, SAS EG 5.1, SAS/Macros, SAS/SQL, Oracle, Unix, MS Office.

Confidential

Data Analyst/ Admin

Responsibilities:

• Analyzing business workflow, system needs and document business logic and system processes.
• Effectively worked with users to define business processes and information systems for supporting those processes.
• Understand and decipher a functional specification document written by the List Business Analyst. Work on complex system modifications or portions of new applications.
• Leverage exciting code to make it more efficient and automated.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and
• Statistical analyses.
• Created new programs and modified existing programs.
• Knowledge on User SAS software installation support/troubleshooting.
• Provide Production support and resolve issues rose on Production Environment.
• Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data and data mining. Used Enterprise Guide to retrieve data stored in SQL Server.
• Knowledge on SAS mid-tier servers.

Environment: SAS EG 4.3 , SAS MANAGEMENT CONSOLE 9.2 , SAS/SQL, SAS/MACROS, SAS/STAT, UNIX and MS-Office.

Confidential

SAS Programmer/ Data Analyst

Responsibilities:

• Worked extensively with Health care data hospital, lab and physician , which includes various claims membership details and demographics of the members.
• Built an analytical data mart for the predictive analysis team for predicting future utilization measures.
• Coded, modified and automated existing programs writing complex MACROS for improving efficiency.
• Created reports based on the claims Medical and Pharmacy pulled using CPT, ICD-9 and NDC codes for various Diseases.
• Used procedures like PROC IMPORT for getting data into SAS from different formatted files like Excel, CSV file, .txt files etc.,
• Presented statistical results with the help of pie diagrams and bar graphs using SAS/STAT.
• Extensively used SAS MACROS, PROC SQL, PROC TRANSPOSE, ARRAYS and Microsoft Excel.
• Worked on creating Membership files writing a logic that brings in only continuously enrolled members.
• Extracted data from various databases DB2, Oracle into SAS using SQL pass-through facility for creating various reports required based on the requirements.
• Coded for Metabolic-Syndrome project for predictive analysis team, where members with different risk factors of the disease were identified with their respective Diagnosis, Procedure and NDC codes.
• Worked with huge data for pre-diabetes project, where based on past data future occurrence of the diabetes is predicted.
• Validated a pre-sales package created by another SAS programmer.
• Ran some reports for compliance rates of the members with particular rules given by the Business user.
• Leveraging the exciting codes that can be used in processing, developing, maintaining and analyzing data more efficiently
• Produced statistical reports for various business needs and expertise in data preparations, data cleaning and analysis.
• Worked on the post campaign response reports along with other programmer.
• Created summary tables and listed outputs.
• Worked with presentation and reporting procedures like FORMAT, REPORT, PRINT, SORT etc.,

Environment: SAS EG 4.3, SAS/Macros, SAS/SQL, SAS/Stat, SAS/Connect, SAS/Graph, Unix, Oracle, MS Office and DB2.