OBJECTIVE

• To be part of a company, where I can make a valuable contribution to their ongoing success with my expertise in Data Analysis and be an asset to the company and achieve professional growth.

SUMMARY

• 8 years of experience in Analysis, Design, Development and Validation of various Datasets across various domains, and data visualization tools like Microsoft Power BI and SAS Visual Analytics.
• Expertise in analyzing data, generating reports, tables, listings and graphs using SAS in accordance with the Statistical Analysis Plan (SAP), Standard Operating Procedures (SOPs) and departmental guidelines.
• Extensive experience creating dashboards and reports using SAS/Visual Analytics
• Delivered BI reporting solutions in Microsoft Power BI
• Familiar with Business Analyst role, performed Gap Analysis acting as bridge between functional and technical teams
• Highly experienced in writing SQL queries to extract and analyze big datasets.
• Executed projects on BASE/SAS, SAS/MACROS, SAS/STAT, and SAS/SQL in Windows and UNIX environment.
• Extensive exposure to SAS programming in merging SAS data sets, macro facility, producing reports and SAS formats.
• Extensive experience in producing External files and customized reports using various SAS procedures like Proc Report, Proc Print, Proc tabulate, Proc Means, Proc Freq, Proc Univariate, Proc SQL, Proc Transpose and Data Null Technique.
• Experience in extracting data and creating SAS datasets from various sources like Oracle database, SQL Server database, Access database, Excel and flat files using import techniques.
• Experience in producing RTF, HTML and PDF formatted files using SAS/ODS to produce reports.
• Excellent communication skills, a very good team player. Ability to work independently under minimum supervision, in a fast paced environment and under deadlines.

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/SQL, SAS/STAT and SAS/ETL, SAS 9.1, SAS/ACCESS, SAS/ODS, SAS/Visual Analytics

Microsoft BI Suite: Microsoft Power BI, Excel, Pivot, Power Point Operating Systems Windows and UNIX Languages SAS, SQL, VB, HTML Databases Oracle 11g, SQL Server 2008

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SAS/Power BI/Business Analyst

Responsibilities:

• Worked on different projects involving various KPI’s, developed and improved existing reports and data interfaces using SAS
• Meeting with product owners, recording meeting minutes and preparing Functional Requirement Document
• Involved in Gap Analysis, Design phase of project, actively involved with Development phase
• Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations in Power BI desktop
• Modifying and analyzing data using DAX expressions like filters, Aggregate, Mathematical functions etc. in Power BI desktop
• Publishing reports via Power BI service
• Creating dashboards using various SAS/Visual Analytics objects, filters, parameters, and custom charts
• Loading and maintaining SAS/VA report tables on LASR server
• Format HTML, PDF, CSV and RTF reports, using SAS - output delivery system ODS.
• Extraction of data from Data Ware housing tables and Data marts.
• Extracting data from the database using SAS/ Access, SAS /SQL procedures and create SAS data sets.

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• Utilized Power BI to create reports and dashboards for various KPIs like Asset Utilization, Working Capital etc.
• Utilized Power Query to cleanse the data and various transformation as per project requirements.
• Implemented the DAX functions for various calculations for efficient data visualization in Power BI
• Using SAS stored process created selection screens, web reports and dash boards
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Involved in creating the In-Text tables for the TLF’s (tables, listings, figures). Created derived SAS datasets as appropriate.

Confidential, Indianapolis, IN

SAS Programmer

Responsibilities:

• Performed Analysis on complex claims within the Processing System.
• Used SAS/Assist to extract data from SAS Files and Oracle Data base.
• Created reports/dashboards using SAS Visual Analytics.
• Developed Stored Processes to distribute reports in a secure manner.
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.
• Effectively prepared and published various performance reports and presentations.
• Documented the Business requirements
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Performed Data analysis, mainly using Regression and ANOVA (Proc REG, Proc GLM, and Proc ANOVA).
• Generated SQL reports and Business Objects reports to maximize system capabilities for tracking and reporting information.
• Prepared and monitored progress on system changes requests.
• Created and maintained inventory reports.
• Involved in writing code using Base SAS & SAS/Macros to clean and validate data from oracle tables.
• Installation/Migration of SAS Software
• Conducted data investigation using SAS Enterprise Guide.

Confidential, NJ

SAS Programmer/Data Analyst

Responsibilities:

• Majorly worked with the data management team and was involved in handling documentation and submission processes
• Data processing and validations extensively done using SAS datasets.
• Involved in standardizing reporting procedures for graphical and tabular reports.
• Building permanent SAS Data sets involving different forms of data.
• Used different SAS techniques including sub setting, conditions, formatting etc .
• Worked on various SAS procedures to achieve the required functionality
• Reports various health care management metrics such as Number of readmissions, Patient category metrics, Patient demographics, Service delivery and drug utilizations etc.
• Research characteristics associated with member utilization patterns, self-care habits, and health behaviors.
• Used advanced SAS tools automate the reporting systems to generate daily and monthly reports.
• Documented, summarized and recorded data as per standard operating procedures (SOPs) and FDA regulations.
• Define department specific report requirements, profile data and develop data quality definitions.
• Conducted end user training for basic and advanced reporting skills.
• Creation of Universe Objects as per the Users requirements
• Wrote Output Delivery System SAS procedures to publish reports as HTML pages to the web.
• Used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT PROC TABULATE, PROC UNIVARIATE and PROC REPORTS.

Confidential

Regulatory SAS Programmer

Responsibilities:

• Developed programs for validation of tables and listings for clinical study reports according to CDISC standards..
• Created and maintained SAS datasets that are extracted from Oracle databases using SAS DATA STEP and PROC SQL.
• Used Sorting and merging techniques on the raw data sets for value added data reparation, to get the required Reports or Analysis data sets.
• Produced Ad-hoc reports as per requests.
• Involved in the support of Phase II and III clinical trials; Regulatory submissions.
• Worked on the safety (ISS) and efficacy (ISE) listings for the various studies, contributed to the development of standard operating procedures (SOPs).
• Created CRT (Case Report Tabulations) datasets using ODM model of CDISC standards for FDA/Global Submission.
• Used SAS ODS to generate the reports in RTF and EXCEL formats.
• Worked on multiple protocols and/or drug compounds at a time.
• Conducted analysis on the raw data to determine the quality and validity of data.
• Review of specifications, mock-up tables.
• Maintained appropriate study application documentation.
• Used Base SAS & SAS Macros to generate reports of clinical data and assisted in the validation of clinical data from Clintrial or other electronic sources.
• Performed QC (Quality Check) extensively on tasks performed by other team members and involved in data validation and data cleaning in all phases of Clinical studies.
• Program documentation on all programs, files and variables was performed for accurate historical record and also for future reference.