PROFESSIONAL SUMMARY

SAS Certified Professional with 9 years of experience in IT working for Pharma and Banking projects.

Exposed to US market with extensive data knowledge in IQVIA datasets such as NPA, NSP, DDD, HCOS, LAAD and Patient data.

Strong SAS programming skills and expertise in SAS/Base, SAS/Macro, SAS/SQL, SAS/EG, SAS/Access, SAS/Stat

Hands on experience of SAS Enterprise Guide, SAS AML 6.3 solution.

Worked on complete life cycle of projects from Initial design phase to Production handover.

Good Knowledge in building SAS Jobs using SAS DI, SAS Macros and SAS Stored Processes for business reports.

Experience in Data Extraction, Data Validation, Data Transformation, Analysis, Design, and Report Development using SAS and other BI tools.

Exceptional ability to utilize various SAS procedures for building end user reports.

Trained agile practitioner, and currently delivering the projects using AGILE methodology.

A consistent track record of successfully employing best business practices that improve efficiency, Reduce operating costs while increasing productivity.

Fine analytical, inter-personal & communication skills with experience in interacting with clients, multiple user groups and managing development teams. Ability to work in a fast paced environment and under deadline.

Technical Skills

SAS Tools : BASE SAS, SAS/Macros, SAS AML 6.3, SAS Data Integration Studio, SAS/SQL, SAS Management Console, SAS Enterprise Guide, SAS/STAT, SAS/Access, SAS VA

Database : Oracle, Teradata

Utilities : MS-Office

Operating System : Windows, Mainframes, Unix

Functional area : Fraud Analytics, Customer Sanctions, Segmentation analysis, launch tracking analysis, Secondary desk research expert

EXPERIENCE SUMMARY

Working at IQVIA from June-2020

Worked at Allegis Group from May-2019 to June-2020

Worked at AIG from Dec-2017 to Oct-2018

Worked at DSS from Dec-2015 to Dec-2017

Worked at Capital One from Mar-2013 to Dec-2015

Academic Qualifications

Master of Computer Applications(MCA) from Sri Venkateswara University, Tirupati, India

Project # 1:

Project Profile

Organization & Client : IQVIA India Pvt Ltd.

Role : SAS Consultant

Duration : June 2020 till date

Environment and skillset: SAS 9.4, SAS SQL, Oracle, SQL server Roles & Responsibilities:

In this organization I worked as a SAS Consultant for pharma client. Exposed to US market with extensive data knowledge and hands on experience in IQVIA datasets such as NPA, NSP, DDD, OneKey, LAAD and Patient data.

Extensive experience in performance reporting for products across therapeutic areas and across different levels within institutions.

Analysing large datasets and producing deliverables to answer key business questions involving diverse markets including diabetes, vaccine etc.

Supporting IQVIA pre-sales team with the data manipulation and data analysis using sales and prescriber data.

Building case studies for the expansion of client engagements and creating efficient processes to optimize and scale-up the existing projects

Experienced in wide array of studies including ROI assessment, brand performance reporting and other ad-hoc analytical and reporting projects

Designed and developed monthly as well as quarterly reports for US geography that provided actionable insights to the clients and helped in their decision-making process on day-to-day basis.

Project # 2:

Organization & Client : Allegis Group

Role : SAS Analyst

Duration : May 2019 to June 2020

Environment and skillset: SAS 9.4, SAS AML 6.3, SAS EG, SAS Macros, SAS DI Studio, Oracle Roles & Responsibilities:

In this organization I worked as a SAS Analyst for a banking client in the areas of Anti Money Laundering and Financial Crime for the Customer Sanctions project which is based on SAS AML 6.3 where I am responsible to maintain the AGP process and to enhance the capabilities of RTTM .

Build and update AML scenarios using Scenario Administrator

Create Header files and update the backend macro programs

Deliver the build components of each sprint and for the releases.

Develop new SAS DI jobs and SAS Macros for World check data load.

Responsible for creating test strategy and execute all the test cases in UAT.

Creating business reports and generates emails using SAS scripts.

Using SQL pass-through to extract data from Oracle.

Develop, test and maintain SAS ETL jobs data in Core and KC.

Enhance Fraud Analytics reporting capabilities.

Create the new scenarios and update the existing scenarios based on the business requirement.

Understand the existing AML tables stored on Oracle.

Using various procedures to generate User reports.

Enhance AGP process by fixing the errors of SAS programs of AML.

Prepare Technical design document, Operations guide and deployment instructions.

Practice Agile and Interact with client during daily scrum meetings and update the status.

Project # 3:

Organization : DSS

Role : Sr. Analyst

Duration : Dec-2015 to Dec-2017

Environment and skillset: SAS/BASE, SAS/SQL, SAS/MACROS, SAS EG, Teradata Roles & Responsibilities:

In this organization I am responsible to build a new initiative to upgrade the system from product level profitability to customer level profitability. This project is developed for credit card and retail bank data. The Source data come from Teradata EDW and then we extract this data to generate all the P&L components which we use to generate profitability at customer level. We consider risk data to analyse revolving and delinquent behaviour of the customer. As of now we are generating the business reports manually, so it going to be automated. We are validating data before generating business reports. To enhance this project we are working on Mortgage and Small Business data.

Design the Database architecture using star schema to generate Final tables with all Profit and Loss Components by reading the source data

Reading and extracting the data from flat files.

Built SAS programs and Macros to read data for the respective tables of each Business and derive needed PNL variables using their formulae.

Creating HTML reports to publish on share points by using ODS and Proc report.

Analyse the existing data standards (variables and Formats) of Teradata.

Transforming the data to create new variables to generated user reports.

Developing macro codes which need to execute on Monthly basis.

Using various procedures to generate User reports.

Validating the data using means, summary and compare procedures.

Removing data discrepancies and then reloading the data using SAS EG.

Analyse the existing SAS jobs and reuse those jobs to build new ones if needed.

Actively participating in team meetings and providing suggestions to enhance project outputs.

Project # 4:

Organization & Client : Capital One

Role : Senior Coordinator

Duration : Mar 2013 to Dec 2015.

Environment and skillset: SAS 9.2, SAS/BASE, SAS/MACROS, SAS/ODS, Oracle, Teradata

Roles & Responsibilities:

This project was developed to integrate credit data from two different databases and to redevelop the existing Business reports. In this process the data extracts will be transformed into smaller SAS datasets in order for them to be successfully integrated into the downstream processes that need them. In this project we need to take care of the structure of corresponding data sets to integrate. We need to carefully consider variable names and variables types. In order to achieve this we need to develop 76 SAS jobs which are responsible for Integration and report generation.

Understanding the tables and their properties.

Understanding Existing SAS jobs which develop reports.

Understanding the Business and its Requirements.

Ensure Minimum disruption to regular reporting.

To analyze the existing jobs and reuse those jobs to build new ones.

Using various procedures to generate User reports.

Developed macro codes to build effective Jobs.

Performed program documentation on all programs, files and variables for accurate historical record and for future reference.

Developed SAS macros for data cleaning and reporting and to support routing processing

1

Contact this candidate