SUMMARY

• Experienced in various phases of SDLC from planning, requirement analysis, designing, development, testing, implementation and support of projects in production environment.
• Expertise in delivering Insights and Analysed Reports /Dashboards with high problem solving capability with strong attention to Detials following the system Processes.
• Expertise in customized analyticssolutions for both quantitative and qualitative data accumulation.
• Delivered strategies around understanding different personas, demographics and motivations of prospects through quantitative and qualitative data.
• Excellent interpersonal,organizational and oral/written communication skills contributing to project success in multi - tasking, fast paced with Creative Problem solving capability, Precise attention to detail and continuous process improvement approach in Agile environment.
• Experience in working with customers to determine their needs,gather,analyze and document requirments, communicate with customers throughout the development cycle,manage customer expectations,resolve issues and provide project status.

TECHNICAL SKILLS

SAS Tools: SASV9.1.3, SAS 9.2, SAS 9.4 Base SAS, SAS/SQL, SAS/MACROS, SAS DM, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/CONNECT, SAS/Web Report Studio, SAS/Arrays.

Reporting Tools: Base SAS versions 9.3/9.2/9/8/6, SAS Enterprise guide, SAS Graph, MS-EXCEL, Tableau, Qliksense, SAS BI Platform, MS-Visio, MS-PowerPoint, MS-Office suite.

Databases: Oracle, Microsoft SQL Server, MS-ACCESS, DB2, Teradata, Pega, Sybase, Hash Tables, Hadoop, SAP Business Objects, Hyperion

Languages: SAS, SQL, Qliksense, Tableau

Batch Server: Linux, Unix, Shell scripting

Platforms: Windows 95/98/XP/Vista/Win 7, Unix/Linux, Mainframe, AIX,PC SAS, SAS EG

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

BI Developer/ Reporting & Analytics

Responsibilities:

• Partnered with key stakeholders in order to frame business questions and develop analytical solutions to drive results And Perform focused statistical analysis to support business strategy.
• Worked with business users to identify the Areas of Improvements by creating Story Dashboards.
• Constructed highly visual and simplified executive and business user level application scorecards which underlined service functionality and operational metrics. developed KPI's for the Marketing team and Executive teams, and worked through lead generation activities such as email marketing, social networking, trade shows, and Paid media.
• Worked with third party Marketing Vendors and CRM Team and Provided Insights on Decision Making to Support Marketing Campaigns and improve Sales Metrics.
• Provided Deep insightful Reports/Dashboards to Business/Stake holders
• Performed complex database marketing activities, including list builds, reporting, and pre & post-campaign analysis
• Creates new on-going reports and dashboards using intermediate to advanced SAS and reporting tools (including Tableau, Qliksense.
• Analysed Cost Metrics like Cost per Lead, Cost per Premium and provided Insights on ROI from Marketing Spend to Premium collected inclusing key statistics and Trending Analysis.
• Create sales ROI dashboards including Key Statistics and Trending analysis
• Worked on Fraud Survillience report to minitor Policies.
• Worked with Web based Analytical tools to drive real time data and reports using Google Analytics and Adobe Analytics.
• Created Dashboards and Adhoc reports in Google Analytics and Adobe Analtyics.
• Designed, developed, implemented, and supported Published Tableau dashboards.
• Transitioned Tableau based Dashboards and Metrics to Qliksense using data load editor.
• Integrated data sources and databases with QlikSense, and designed and developed snow flake and star Schema data models and backend queries for presenting data.
• Performs ad-hoc data analytics upon requests from management and stakeholders.

Confidential, Birmingham, Alabama

Analyst

Responsibilities:

• Managed multiple concurrent project tasks simultaneously.
• Utilized Agile and Scrum methodologies to manage and implement complex open-source applications, customized solutions, and business intelligent systems.
• Worked with BAU to understand their reporting requirements and designed Specialised Reports to match the business needs.
• Provided Adhoc Analysis to Claims Managers on regular basis.
• Created new and modified SAS programs by analyzing the health care claims data for Reporting and Analysis.
• Developed web-based reports, scorecards, and dashboards using SAS Information Delivery Portal, Web Report Studio, Stored Processes, and SAS Server pages.
• Hands on experience in creating Quality Reports based on the Claims data.
• Developed and modified existing tables, views, stored procedures, functions.
• Created reports in Excel spreadsheets which are capable of doing automatic calculations.
• Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data.

Environment: SAS/Enterprise Guide, SAS/Base 9.3/9.4, SAS Macros, SAS/SQL, SAS/ETL, SAS/Graph, SAS/ODS, SAS/Stat, MS Access, Windows, Oracle 11g,MS Office, AIX, DB2, Pega, Sybase, Hadoop

Confidential

Consultant - Analytics

Responsibilities:

• Created and automated reports for Daily, Weekly, Monthly, Quarterly reports and statistical analysis reports in SAS/9.4 in Unix Environment.
• Worked on SAS Grid Manager, Base/SAS, SAS/EG, SAS/Webportal, SAS/Store Processes.
• Analyze trends and present analyses to support and to identify of health care fraud & abuse
• Analyze healthcare claims from different data sources and identify the data integrity issues
• Data analysis of medical claim history to substantiate fraud and abuse allegations
• Identify & present analysis on estimated over payments and other identified aberrant billing patterns
• Summarize and present complex patterns of fraud and abuse to internal and external customers
• Contribute knowledge relating to data platform & SAS technologies and be an expert in the team.
• Extracted data from DB2, Oracle, SQL Server and Sybase Databases using SQL.
• Created scripts in UNIX for file transfer from one server to another using SFTP and Winscp.
• Created SAS transport files and converted the Transport files into SAS Data Sets.
• Production Jobs monitoring and handling the job failures to keep all the reporting processes up and running.

Environment: SAS/Enterprise Guide, SAS/Base 9.3/9.4, SAS Macros, SAS/SQL, SAS/Arrays, SAS/ETL, SAS/Graph, SAS/ODS, SAS/Stat, MS Access, Windows, Oracle 11g,MS Office, Unix, Teradata, DB2, Sybase, Hash Tables.

Confidential

SAS Programmer/ Analytics

Responsibilities:

• Involved in Phase II Oncology Clinical Trails.
• Involved with Biostatistician, analysts and users on requirement gathering.
• Reviewed clinical study protocols, case report forms and statistical analysis plans for clinical trials.
• Verified accuracy and integrity of Clinical data by performing validation checks written in SAS and data cleaning by investing data related errors and missing values.
• Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis.
• Extensively used different SAS procedures such as PROC MEANS, PROC SORT, PROC FREQ, PROC COMPARE, PROC REPORT, PROC SQL, PROC GPLOT and Data NULL step cross-tabulations and statistical analysis procedures.
• Wrote programs using base SAS and SAS/Macros to extract data from oracle tables.
• Knowledge of CTMS, drug discovery and development, bioinformatics, ICH-GCP, drug protocol development, clinical trials, CDISC, SDTM, ADaM, clinical data management, CRF Design, EDC and Pharmacovigilance.
• Generated tables, listings and graphs including patients demography and characteristics, adverse events, laboratory etc.
• Collaborated with clinical researchers in the design of clinical trial selection of clinical endpoints, sample size requirements, protocol development, and Research and the Case Report Form design.
• Participated in writing of clinical trial reports and presenting of the trial results.

Environment: SAS/Enterprise Guide, SAS/Base 9.3/9.4, SAS/Macros, SAS/Arrays, SAS/SQL, SAS/ETL, SAS/Graph, SAS/ODS, SAS/Stat, MS Access, Windows, SQL Server, MS office, Unix and Teradata, Hash Tables

Confidential, Raleigh, NC

Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering of SAS reporting new and existing codes.
• Gathering requirements and documentation for unit test case development and defining and documenting the integration testing of new applications.
• Maintained performance reports, creation of reports for online and batch application of various servers and involved in preparing executive Dashboards for senior level management.
• Analysis included Behavioural Model, Customer Profiling, Trend Analysis, Predictive Modeling.
• Construct campaigns using a combination of Unica campaign, SQL based on inputs from the campaign owners
• Extracted data sets from server using Proc Import and created datasets in SAS libraries, Coding SAS Programs with the use of SAS/Base and SAS/Macros for ad hoc jobs.
• Worked with SQL, Macro and DI Studio ETL processes, extracted transformed and loaded data, mapped, scheduled and submitted job to Unix and Teradata environment.
• Created views on Oracle tables and indexes on SAS datasets to enhance the speed and performance of the SAS programs.
• Created shell scripts which would take arguments from the command line and create subdirectories to store the listing files, output files and graphs.
• Developed web-based reports, scorecards, and dashboards using SAS Information Delivery Portal, Web Report Studio, BI Dashboard, Stored Processes, and SAS Server pages.
• Developed methods to streamline analysis and present business critical information through a combination of SAS BI dashboards and web-based reporting.
• Assisted with the creation, support and scheduling of SAS programs within the reporting infrastructure.

Environment: SAS 9.1.3, SAS/BI, SAS/DI Studio, Olap cube, Information Map Studio, SAS/Base SAS/Macros, SAS/Access, SAS/Connect, SAS/SQL, SAS/Enterprise Guide, Oracle, DB2, Windows and Linux, Unix-AIX 6.1, Teradata, SAS forecast Studio.

Confidential, MN

SAS Programmer/ Analyst

Responsibilities:

• Worked in Phases of clinical trials for heart diseases and diabetes.
• Designed and implemented statistical reporting processes for clinical data analysis.
• Extensively used SAS/Macro facility to provide reusable programs that can be conveniently used time to time and created tables, listing and graphical reports.
• Generated output files in text format, HTML & PDF format using SAS ODS.
• Used SAS/ACCESS to extract data from Oracle and other relational databases for analysis.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL .
• Designed flow charts indicating the input datasets and the techniques that would be used (sort, merge, append) to get the desired output.
• Data Analysis and graphical presentation for various summary reports using Base SAS and SAS/Graph facility.
• Developed SAS programs for listing of tables for data review and presentation including adhoc reports, CRTs as per CDISC, patients listing mapping of safety database and safety tables.
• Created CRT (Case Report Tabulations) datasets using CDISC standards for submissions to the FDA.
• Performed data validation on the data sets and deleted repeated values using conditional data steps such as @@, if-then statements.
• Good working knowledge of Clinical Trials data like Demographic data, Discrepancy data, Adverse Events (AE), Serious Adverse Events (SAE), Laboratory data (Lab data), Physical and Vital Signs and Audit trials.
• Established and maintained a sound working relationship and effective communication within (worked with) Bio-Statistics and Statistical Reporting and Clinical Research and Database personnel.

Environment: Windows, SAS 9.1, SAS/BASE, SAS/STAT, SAS/MACROS.

Confidential

SAS Consultant

Responsibilities:

• Used SAS Base procedures like PROC FREQ and PROC UNIVARIATE to generate Safety tables (Adverse Events, Demographic listing) and quality tables for clinical study reports and regulatory submissions.
• Developed SAS macros for data cleaning and Reporting.
• Generated statistical analysis files, tables, listings, and graphs for clinical trial studies
• Involved in delivering output using SAS/ODS.
• Extracted data from databases and also flat files.
• Created html and PDF output files by using SAS ODS AND PROC REPORT, PROC TABULATE, DATA NULL AND PROC SQL to customize the reports
• Enhanced reports through the use of labels, SAS formats, user-defined formats, titles, footnotes and SAS system reporting options.
• Integrate Data from wide range of sources including in-house clinical data management systems, labs and contract research organizations and perform data cleaning with data steps using DLM, DSM, TRUNCOVER, MISSOVER etc.

Environment: SAS/ODS, SAS/SQL, SAS/REPORT, SAS/GRAPH, SAS/BASE, SAS/MACRO,SAS/ARRAYS, MS EXCEL, MS ACCESS.