SUMMARY:

• Nine Years of experience in Data warehousing and Analytics.
• Versatile experience with data application platforms ranging from Data Management, Data Integration, Data analytics, Data understanding and Data visualization.
• Expert in HealthCare Analytics and Clinical Analytics.(Hospital Data, Claims Data, Provider Data, Clinical Trial Data)
• Experience in implementing analytics in amazon cloud (AWS) using Bigdata Hadoop and SAS.
• Exposure in latest BI technologies like Big Data Hadoop, Tableau, R, SAS VA etc..
• Played different roles like Applications developer, TeamLead, Managerial role, Onshore Lead etc.
• Global Exposure in working at client locations of USA, UK and Thailand.
• Expert in designing and implementing solutions using SAS BI Technologies. (SAS BASE/MACROS,SAS GRID,SAS SPDS,SAS DI Studio, SAS WRS, SAS Information Map Studio, SAS Visual Analytics)
• Extensive programming experience with Base SAS, SAS MACROS, SAS SQL.
• Experience in SAS Model fitting and Model validation.
• Exposure in Machine Learning and Data Mining concepts.
• Designing and implementing the ETL and Reporting solutions using Base SAS, SAS Macros, SAS SQL, SAS DI studio, SAS EG, and SAS Management Console.
• Monitoring the performance of the DI jobs and implementing the solutions to improve the performance.
• Automated and enhanced many Critical Processes.
• Experience in installing and Configuration/Migration of SAS 9.4.(Mufti Machine Installation SAS GRID and SAS VA)

TECHNICAL SKILLS:

Datawarehousing tools: SAS DI, SAS WRS, SAS GRID, SAS SPDS, SAS BASE/MACROS.

Visualization and Bigdata: Hadoop, Tableau, SAS Visual Analytics, Amazon Cloud(AWS),R

Languages: C & DS, Java,SAS.

Operating Systems: Windows 98, Windows XP, UNIX

Web Technologies: HTML, Java Script

Query languages: SQL, PL/SQL

Database: Oracle 9i

PROFESSIONAL EXPERIENCE:

Confidential

Clinical Data Management

Responsibilities:

• Collaborate with business and technology departments to gather requirements, document and define deliverables
• Design and code for standard ADaM implementation.
• Creating utilities for Integration of Oracle LSH and SAS for end to end clinical trail system.
• Generation of tables and listings.
• Designing ETL and Reporting solutions using Oracle Life Sciences Wareshouse Suite which comprises of LSH and DMW.

Environment: Oracle LSW and SAS

Confidential

SAS Consultant

Responsibilities:

• Architect the solution for bigdata analysis using SAS and Hadoop.
• Design data load strategy to Hadoop HDFS.
• Stream the data from events processed to Bigdata.
• Explore the bigdata technology using Hive, Impala, Cloudera.
• Design and Implement Bigdata analysis using SAS Visual Analytics explorer.
• Exlpore the Bigdata visualizations using tableau.
• Install and Configure Visual Analytics in multi Machine.
• Loading In - memory tables using SAS Visual Analytics.
• Reports design and build using SAS Visual Analytics.
• Worked onsite at SAS Thailand for 3 weeks for SAS VA configuration for Kbank.
• Worked onsite at SAS UK for 3 months for SAS VA reporting at deutsche bank (Market Risk Module)

Environment: SAS Visual Analytics and Bigdata Hadoop.

Confidential

Lead Consultant

Responsibilities:

• Collaborate with business and technology departments to gather requirements, document and define deliverables for payor suite configuration.
• HealthRules™ Configuration: Benefit Configuration, Pricing Configuration, Provider Setup,Account Setup, Plan Design, Product Setup, Billing Cycle Configuration, Supplier Contract Configuration, Re-insurance Configuration, etc.
• Understanding analyzing the data model of Health Rules answers. “Health Rules answers “ is state-of-the-art data warehouse, built for business intelligence.
• Creating Reports and Visualizations based on the business requirements of the client on top of Health Rules Data Warehouse.
• Developing Client Relation and identifying the challenges in the Process. Proposing new dashboards and visualizations that help in converting health rules data to Insights for decision making.

Environment: Health Edge, SAS, Crystal Reports Unix

Confidential

Technical Lead

Responsibilities:

• Identify and segment populations.
• Find new ways to lower costs, improve outcomes, and improve individual and population health status.
• Monitor and measure the outcomes.
• Implement multi parallel processing architecture.
• Lead the SAS Grid Migration project from offshore.
• Converted SAS SPDS code to SAS Grid (Base SAS code) code for the existing algorithms
• Optimizing the SAS code to harness the capabilities of SAS Grid.
• Design and Implement Huge Data Processing strategies.
• Evaluate all existing populations and available data to improve identification & stratification.
• Developing Client Relation and identifying the challenges in the Process.
• Responsible for deliverables to client from offshore team.
• Creating strategies and Developing solutions by coordination with Offshore team (Bangalore).
• Resource and Task planning for offshore.
• Exploring and discussing optimization opportunities with Clients.
• Automating any existing ETL algorithms to minimize the manual effort.
• Tuning the performance of various rule engines to reduce execution times.
• Develop and maintain data preparation and validation routines to support and create data mining algorithms.
• Analysis, design, & development of new or improved eVisor rule sets.

Environment: SAS DI, SAS SPDS, BASE SAS, SAS MACROS, SAS SQL, SAS Grid. Unix

Confidential

Offshore Lead/ Team Lead

Responsibilities:

• Designing ETL and Reporting solutions using SAS BI tools includes SAS DI studio,SAS Macros, SAS SQl, Base SAS.
• Support business analysis team in model fitting and validation.
• Designing SAS jobs for forecasting rules using the function mathematical formulas in functional requirement spec.
• Developing strategies for huge data processing which is present external systems like Teradata.
• Analysing and visualizing data in order to distinguish patterns and recognize trends.
• Develop and maintain data preparation and validation routines to support and create data mining algorithms.
• Weekly Status Reports to Higher Management.
• Metrics Tracking, Engagement Specific Reports, Resource Management.
• Maintaining PMP,CMP,QMP for the Project.
• Providing Performance feedback to the resources.
• Involving in Recruitment drives.
• Keeping the team Morale.
• Following Project Plan Tacking Necessary Actions to deliver the project on schedule.
• Developing Client Relation and identifying the challenges in the Process.
• Responsible for deliverables to client from offshore team.
• Creation of the Design documents for ETL and Reporting.
• Assisting the team in implementing ETL and Reporting solutions.
• Design of ETL Jobs and job templates using SAS BI tools.
• Monitoring the performance of the SAS jobs and implementing the solutions to improve the performance.
• Identify and segment populations.
• Find new ways to lower costs, improve outcomes, and improve individual and population health status.
• Monitor and measure the outcomes.
• Design and Implement Huge Data Processing strategies.
• Evaluate all existing populations and available data to improve identification & stratification.
• Developing Client Relation and identifying the challenges in the Process.
• Responsible for deliverables to client from offshore team.
• Creating strategies and Developing solutions by coordination with Offshore team (Bangalore).
• Resource and Task planning for offshore.
• Exploring and discussing optimization opportunities with Clients.
• Automating any existing ETL algorithms to minimize the manual effort.
• Tuning the performance of various rule engines to reduce execution times.
• Develop and maintain data preparation and validation routines to support and create data mining algorithms.
• Analysis, design, & development of new or improved eVisor rule sets.

Environment: SAS DI, SAS SPDS, BASE SAS, SAS MACROS, SAS SQL, SAS BI suite Unix

Confidential

Lead Developer

Responsibilities:

• Designing and implementing the ETL and Reporting solutions.
• Preparing ETL and Reporting Plans and assigning it to the team as per plan.
• Giving daily status to the onsite coordinators showing the progress of the tasks.
• Creation of the Design documents for ETL and Reporting.
• Assisting the team in implementing ETL and Reporting solutions.
• Creation of ETL Jobs and job templates using DI.
• Monitoring the performance of the DI jobs and implementing the solutions to improve the performance.
• Generating tables, listings, summary reports that plays a prominent role for to Identify the safety and efficacy of the drugs.
• Creating analysis datasets.
• Data Profiling, Data cleaning and data validation using SAS Regular expressions.
• Transforming the industry standard to CDISC standard using our own developed process with excel sheet, VBA, and SAS Macros.
• Generating tables, listings, summary reports that plays a prominent role for to Identify the safety and efficacy of the drugs.
• Data migration from VAX system to windows and developing transport files.
• Extracting data from external systems and developing SAS analysis datasets.
• Developing reusable SAS macros that can be used as tools for Data Management, Data Analysis and Reporting.
• Creating utilities using unix shell scripting.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL.