Data Sql

PRATHYUSHA

Professional Summary

. Certified SAS Professional having over 6 years of Programming and

Statistical Analyzing experience in Pharmaceutical industry, Banking,

Financial Services.

. Expert hands on knowledge of SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH,

SAS/ACCESS, SAS/ODS, and / SAS/SQL in UNIX, and Windows environments.

. Created Tables, Listings and Figures.

. Proficient in developing and debugging SAS/MACROS to access, extract,

modify, merge, and analyze financial data other SAS application for

data updates, data cleansing, and reporting.

. Working experience in SAS Access, SAS Connect, SAS/AF, SAS/ETL, PROC

Reports, SAS ENTERPRISE in Windows and UNIX environments

. Worked closely with Business in gathering requirements and

understanding the metrics required for generation of Reports, List out

puts for marketing teams.

. Involved in Clinical Trials in several Therapeutics areas.

. Worked in different phases of Clinical Trails.

. Good knowledge of Medical terminology and Clinical trials data

structure.

. Work experience on latest version of SAS 9.1.3.

. Efficient in generating reports using Data _NULL_, Proc Print, Proc

Report, Proc Mean, Proc Summary, Proc Freq, Proc Format, Proc SQL, and

Proc Access.

. Expertise in applying SAS procedures like Proc Means, Proc Freq, Proc

Sort, Proc Format, Proc Report, Proc Tabulate, Data _NULL_, Proc Print

and their multiple options Proc Import, and Proc Export for importing

and exporting data, Proc Contents and Proc Datasets to view the

contents of the SAS libraries.

. Wide-range experience in data manipulation and generating customized

reports with SAS data steps and procedures. Handled Merging Data and

created new datasets wherever necessary.

. Experience in writing/customizing macros to develop concise and

reusable code. Macro options mlogic, symbolgen, mprint, macrogen etc.

are used to debug the macro and macro variables.

. Possess statistical knowledge of descriptive models including various

sorts of mixed models and predictive solution models including linear,

multiple, polynomial and non-linear regression model.

. Well versed with creating HTML Reports for financial data using SAS ODS

facility, proc report and SQL pass through facility.

. Generation of data tables, patient data listing and reports using SAS ;

Preparation of statistical analysis plans; Contribute to statistical

section of clinical trial protocols; review of analysis of financial

trial data.

. Worked on SAS datasets using the ETL concepts to increase the overall

performance. Also familiar with the concepts of OLAP, Stored Procedures.

. Wide-range experience in data manipulation and generating customized

reports with SAS data steps and procedures.

. Responsible for Data extraction from several databases including

Oracle, SQL Server and flat files.

. Extensive experience in RDBMS like Oracle, SQL Server, Db2, MS Access.

. Extensive preparation of Ad-hoc reports.

. Working according to internal SOPs (Standard Operating procedures)

under constant quality control conditions.

. Possess strong ability to quickly adapt to new applications and

platforms.

. Ability to work in self directed environment and Very good team player

with excellent analytical and problem solving skills.

Skills

Statistical Software: SAS 8, SAS 9, SAS/BASE, SAS/STAT, SAS/SQL,

SAS/MACRO,

SAS/ACCESS, SAS/CONNECT,

SAS/ODS, SAS/ETL.

Business Intelligence: SAS Management Console, SAS Enterprise

Guide, OLAP Cube,Studio, SAS Add-In to MS

Office, SAS Information Map Studio, SAS stored process

Programming Languages: C, SQL, Java

Database: MS Access, Oracle 10G/9i/ 8i,

SqlServer 2000/2007,Teradata.

Word Processors: MS Word, Open Office, Page Maker.

Other Applications: HTML, FrontPage express, Power Point.

Operating Systems: UNIX, Windows 9x/2000, XP, NT, Windows Vista

Work Experience

Capital one Auto Finance, TX

Jun'09- Present

SAS Data Analyst

Responsibilities:

. Statistical Analysis of data to identify trends and relationships in

data, evaluating pros and cons on different delinquent portfolios and

generate MIS reports using SAS and coordinating with the Regional and

National Heads on regular intervals.

. Analyzing the data by using MS Excel, SQL, and SAS. Extensively worked

using Query Analyzer for querying the data base to fix the Data issue that

show up on the reports.

. Generated the List outputs for Marketing Teams that have the list of

customers to target as part of Campaigning.

. Involved in analyzing complex data structures to generate useful business

insights.

. Developed reporting to monitor business critical results.

. Worked with internal partners on statistics-related projects; and

supporting leadership team with data consultation, data gathering and data

analysis.

. Communicated with business customers to establish data requirements and

presented final analysis to customers.

. Worked on CRM (Consumer Credit Risk Management) to deliver monthly

reports relating to the Delinquency and charge-off accounts in Auto

finance.

. Implemented Master Dataset in CBS (credit bureau simplification) in order

to reduce complexity in daily and monthly Auto finance reports.

. Used Multi process Connect to perform disjoint units of work in parallel

for the purpose of reducing the total elapsed time necessary to execute a

particular task.

. Implemented code in Value Level Monitoring for financial data which gives

the trend of any anomalies in the data in the form of a graph.

. Assisting in the analysis, design, and development of tables, Excel files

and ad-hoc reports.

. Understood basic business analysis concepts for logical data modeling,

data flow processing and data base design.

. Monitoring the existing performance and to change the process for better

performance.

. Extracted data from existing data source and performed ad-hoc queries by

using SQL.

. Monitoring the existing performance of the Bank's internal departments

and to change the processes for better performance and customer

satisfaction.

. Achieving deadlines for timely submission of data analysis, reports by

performing data extractions and retrievals.

. Followed SDLC approach to move the code to Production. Performed QC

routines and shared results with business to get approvals.

. Interact with users, business analysts and other department heads to

gather information and requirements. Developed databases and specifying

specific data requirements.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/IMPORT

SAS/EXPORT, SAS/STAT, SAS/ACCESS, SAS/ODS.

Greater Atlantic Bank, Strasburg, VA

Jul'08- May'09

SAS Data Analyst

Responsibilities:

. Accessed and analyzed the data based on the requirement using SQL, SAS

and MS Excel.

. Analyzed the data using SAS/STAT procedures PROC FREQ, PROC MEANS, PROC

SUMMARY.

. Analyzed large data sets consisting of million records using PROC SQL,

PROC SORT, PROC PRINT, NODUPKEY, PROC TABULATE procedures.

. Prepared Ad Hoc reports based on the requirements from risk management

team by joining multiple database tables using PROC SQL JOINS.

. Tuning the SQL queries to get better performance from time to time.

. Modification of SAS code in windows environment based on the updated

specifications for improving the performance.

. Generated Ad-hoc reports to support business strategy using PROC PRINT,

PROC REPORT, and PROC SQL.

. Developed SAS programs based on the drafts specification document.

. The Cubes are built using the Teradata tables and created some

intermediate required data sets which will be joined using the Cube

Studio.

. Modification of existing SAS programs and created new programs using SAS

Macro variables to improve ease and speed of modification as well as

Consistency of results.

. Extraction of data from database using PROC SQL procedure to create SAS

data sets.

. Created various reports, analysis output and made them available to the

customers for easy access and understanding.

. Effectively worked with marketing team to define business processes and

information systems for support processes.

. Imported the data from flat files and MS Excel to SAS data sets.

. Used Proc Sort, Set, Update and Merge statements for creating, updating

and merging various SAS datasets.

. Used Macros within Base SAS code to write different macro variables to

get data from different data tables.

. Developed Macros using Data _Null_, CALL SYMPUT and %let statements to

generate macro variables that reflect the system date for creating the

time stamps on the report file names for documentation.

. Produced reports using Proc Summary, Proc Tabulate, also produced HTML

reports using ODS on monthly and weekly basis.

. Used the Proc Tabulate to generate ad-hoc reports.

. Participated in business meetings, daily update meetings and suggested

alternative methods and ways for easy handling of data.

Environment: SAS/Base, SAS/SQL, SAS/STAT, SAS/Graph, Excel, Windows

2000/Xp

Applied Clinical Intelligence, Bala cynwyd, PA.

Feb'07 - Jun '08

SAS Programmer

. Responsible for providing SAS programming and analysis support for

statistical analysis, documentation, and reporting for Phase I-III

clinical data.

. Created SDTM datasets using raw datasets.

. Created ADaM datasets from SDTM datasets.

. Imported the data into SAS datasets from Excel Spreadsheet, MS Access and

various delimited files using Proc Import to create ad hoc reports as per

the requirement of the higher management.

. Generated tables, listings and graphs from ADaM datasets.

. Created ISS and ISE datasets and implemented CDISC standards

. Generated and used MACROS extensively to create TFL's.

. Extensively used Statistical procedures like PROC Univariate, PROC

Summary, PROC means and PROC Gplot.

. Developed SAS programs for Edit checks also validated listings generated

and summary tables and various ad-hoc reports for drug study.

. Worked with Bio statistician to analyze the results obtained from various

statistical procedures like PROC GLM and t-test.

. Handled Dropouts and Missing Data by using traditional approach of

generating Last-Observation-Carried-Forward (LOCF) data.

. Conducted and generated the Regression, Correlation studies and Analysis

of Variance (ANOVA).

. Created transport files (.xpt) for NDA submissions.

. Created SAS/Views from Oracle database tables.

. Created HTML, RTF and PDF reports using SAS output delivery system ODS.

. Using SAS and SAS tools on the Clinical trials data, performed sorting

and merging techniques to prepare and validate data for the input data

sets, to get the required output and then writing the code using SAS

tools.

. The accuracy and integrity of clinical data were verified by performing

validation checks written in SAS and checked for data related errors,

outliers and missing values.

. Interacted with Clinical, Regulatory and Data Management colleagues to

coordinate collection and reporting of clinical trial result.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/IMPORT SAS/EXPORT,

SAS/STAT, SAS/ACCESS, SAS/ODS.

Andhra Bank, Hyderabad, India

Dec'05- Jan'07

Data Analyst

Responsibilities:

. Performed data analysis, statistical analysis, generated reports,

listings and graphs using SAS tools- SAS/Base, SAS/Macros, SAS/Graph,

SAS/SQL, SAS/Connect and SAS/Access.

. Responsible for locating appropriate databases for projects and

performing relevant analysis.

. Processed data collection to ensure proper quality of data.

. Maintained the daily error log for cleaning the data.

. Developed SAS macros for data cleaning, reporting and to support

routing processing.

Analyzed and interpreted numerical data from various sources organized

and summarized data for analysis.

. Presented numerical information in various formats. Created SAS

Customized reports using the Data _null_ technique.

. Generated graphs using SAS/GRAPH and the SAS Graphics Editor. Used Proc

Report to generate reports.

. Prolifically generated SQL queries for the reports.

. Successfully identified problems with the data, produced derived data

sets, tables, listings and figures, which analyzed the data to

facilitate correction.

Environment: SAS 8, SAS/SQL, SAS/BASE, SAS/MACROS, SAS/GRAPH, UNIX,

Windows.

Aurabindo Pharma, Hyderabad, India

Apr'04- Nov'05

SAS Programmer

Responsibilities:

. Read data from SQL server, Excel and flat files into SAS software.

Developed SAS code to clean the invalid data from the database.

. Created simple and complex queries, sub-queries, join, tables,

procedures & views using SQL.

. Prepared, processed and analyzed clinical data required for analysis of

clinical trials for Phase III and part of Phase IV studies with SAS

programming. Data was collected in CRF (clinical Report Form) and sent

to us as raw data.

. Modified existing SAS programs to fit new protocols or endpoints.

. Performed data validation before any final analysis.

. Created RTF output using ODS facility.

. Created safety and efficacy reports documenting experimental antibiotic

drugs.

. Reviewed Protocols and Reports for statistical integrity.

. Responsible for standardizing the data usage according to edit checks,

performing analysis and loading the data to the database for reporting.

. Involved in Edit Checks for cleaning up the data in data management.

. Extensive usage of Base/ SAS, SAS/ Macros and SAS/ Graph.

. Used PROC Tabulate and PROC Report to standardize the reporting

programs into macros.

Environment: Windows NT, UNIX, SQL, SAS/Base, SAS/ STAT, SAS/GRAPH,

SAS/ODS, SAS/AF, SAS/Macros, SAS/Connect.

Education

Bachelor of Engineering, AP, India.

Attended courses conducted by SAS - Advanced SAS Programming using

Enterprise Guide.

Contact this candidate