OBJECTIVE: To obtain a Business Analyst/Data Analyst/SAS Programmerposition that utilizes my expertise in providing innovative solutions for complex information needs in Financial and Credit Card Industry

PROFESSIONAL SUMMARY

• Experienced Advanced SAS Certified Programmerwith 7 plus years of experience of SAS Programming expertise in Data Collection, Data Analysis, Data Validation, Creation of Reports possess specific experience in Financial, Credit Card Industry and Healthcare
• Extensive experience with SAS Base, SAS/MACROS, SAS/STAT, and SAS/ODS in Windows and UNIX environments
• Strong programming Skills SAS, Oracle and thorough knowledge of interfaces
• Experience in exporting data to external data sources such as DBMS tables, PC files, spreadsheets, and delimited external files using PROC EXPORT
• Good Knowledge of various Grouped reports, List Reports, Cross Tab Reports, Chart Reports using Cognos application
• Extensively involved in Clinical Data Analysis and preparation of SAS Datasets, reports, tables, listings, summaries and graphs using SAS/BASE, SAS/STAT and SAS/GRAPH according to Statistical Analysis Plan SAPs , Standard Operating Procedures SOPs and departmental guidelines
• Experience in validation and quality assurance of SAS programs developed
• Experience with IBM Teradata SQL Assistant, Oracle, and IBM Mainframe QMF SAS applications in development, reviewed SQL Queries conditioning of accounts for each releases
• Good statistical knowledge of descriptive models including various sorts of mixed models and predictive solution models including linear, multiple regression models
• Good knowledge of QA methodologies and SDLC in FDA validated environment
• Can work independently or in a group to accomplish the task required, excellent analytical and problem solving skills ability to multi task under pressure

TECHNICAL SKILLS:

• Operating Systems: MS DOS, Windows 98/2000/XP/Vista, UNIX, IBM Mainframe 3270
• Databases: Oracle 9i,Teradata SQL Assistant, QMF,MS Access,DB2
• Languages: SAS,PL/SQL,SQL PLUS, Teradata SQL Assistant, QMF UNIX,MS OFFICE SUITE,MS Project ,SAS Base, SAS/Stat, SAS/SQL,SASEnterprise Guide Languages
• Business Intelligence Tools: COGNOS 10 BI Tools Report Studio, Analysis Studio, Query Studio, Cognos Connection

PROFESSIONAL EXPERIENCE:

Confidential

SAS Programmer

Projects: Involved in preparation of testenvironment, datapreparation, data analysis, Posted foreign and domestic transactions in DARTNET Applications, Campaign creation in Web based Front End Application for the Bank of America Mobile Payment Apps for Smart Phones/Mobile Gadgets, Visa Signature new product launch for AAA Affinity Partners, Collateral Conversion of Credit Cards. Validated Current/Future Promotion screens for different SPCATS in the Mainframe for Purchases, Balance Transfers, Cash Advances.

Responsibilities:

• Experience in Data Manipulation procedures such as SAS Formats/Informats, Merge, Proc Append, Proc Datasets, Proc Sort and Proc Transpose
• Having excellent command in producing reports employing various SAS procedures like Proc Print, Proc Report, Proc Tabulate, Proc Mean, ProcFreq,ProcUnivariate, Proc Transpose
• Queried the databases using Teradata SQL Assistant TSA and joined tables for back end functionality as per the requirement Interacted with Business Analysts and Software Developers for bug reviews and participated in QA meetings
• Created various types of Grouped reports, List Reports, Cross Tab Reports, Chart Reports using Cognos
• Generated various Grouped reports, List Reports, Cross Tab Reports, Chart Reports using Cognos
• Executed queries in QMF and web based DARTNET tool and SAS applications for front end testing
• Performed Conditioning of Test Accounts for each releases in IBM Mainframe Platform
• Created SAS Codes and Macros for validating the vendor files
• Extracted source data from DB2 via Mainframe SAS,SQL Pass Thru Facility
• Analyzed Business Requirement Document LLDs and HLDs of both clients systems from technical and business perspectives
• Queried QMF in IBM Mainframe Environment for data analysis
• Used FTP File Transfer Protocol to transfer files across platforms
• Analyzed the web based Product Offering Engine financial applications for the creation of credit card campaigns involved in Mobile Payment Application

Applications and Environment:

IBM Mainframe 3270 MBNA IS Host Explorer, TSO/ISPF,QMF,SAS,DB2,BLAZE,POE Product Offering Engine interface is in a UNIX environment and connects to INFORMIX database ,CS Web Superstation, FM File Maintenance ,POINTS,TSS,CICS,JCL,CS Web Card Services Web ,DARTNET Query Management Tool ,Teradata SQL Assistant,DB2

Confidential

SAS Programmer

Responsibilities:

• Experience in Data Manipulation procedures such as SAS Formats/Informats, Merge, Proc Append, Proc Datasets, Proc Sort and Proc Transpose
• Having excellent command in producing reports employing various SAS procedures like Proc Print, Proc Report, Proc Tabulate, Proc Mean, ProcFreq,ProcUnivariate, Proc Transpose
• Generated various Grouped reports, List Reports, Cross Tab Reports, Chart Reports using Cognos
• Analyzed the web based product offering engine financial applications
• Validated, edited and executed SAS codes stored in SAS and used PROC COMPARE and other procedures for data manipulation
• Queried QMF in IBM Mainframe Environment for data analysis
• Experience in cleaning and resolving data issues merging data from different sources into a single integrated data set
• Used Excel application for Graphs, Charts, Macros, Pivot Tables, Functions for data analysis
• Used FTP File Transfer Protocols to transfer files across platforms
• Generated various types of Grouped reports, List Reports, Cross Tab Reports, Chart Reports using Cognos
• Queried the databases using Teradata SQL Assistant TSA and joined tables for reports as per the requirement
• Executed queries in QMF and web based DARTNET tools and SAS applications for data analysis and validation

Applications and Environment:

IBM Mainframe 3270 MBNA IS Host Explorer, SO/ISPF,QMF,SAS,DB2,BLAZE,POE Product Offering Engine is in a UNIX Environment and connects to an INFORMIX database ,CS Web Superstation, FM File Maintenance ,POINTS,TSS,CICS,JCL,CS Web Card Services Web ,DARTNET Query Management Tool ,Teradata SQL Assistant,DB2

Confidential

SAS Developer

Involved inClinForceTM software analysis which is capable of generating random codes using both Static and Dynamic Randomization Algorithms

Responsibilities:

• Developed SAS data sets for analysis prepared statistical reports
• Responsible for creating mockup tables and listing for statistical analysis, Ad-hoc Report Creation, generating tables, listings for Phase II-III clinical drug trial studies.
• Develop new or modify macros for report generation using SAS Macros as per the statistician's requirements.
• Produced safety tables, listings and Ad-Hoc reports for review by Clinical Team using SAS BASE SAS/STAT/GRAPH and SAS Proc FREQ, SORT, GLM, REPORT, TABULATE, UNIVARIATE, MEANS, TRANSPOSE, SUMMARY .
• Produced listing, summary, tables using different SAS/reporting tools like Proc Report, Proc tabulation

ENVIRONMENT: MS-SQL, SAS V8.2, SAS V9.1, SQL,Windows NT

Confidential

SAS Developer

The aim of the project is to provide the SAS production support and enhancement of the system for business change requirements and involved in Oncology and Dermatology studies

Responsibilities:

• Created SAS data sets for analysis report writing for clinical trials
• Performed validation of analyzed data sets, listings and reports
• Involved in Phase II and Phase III oncology and dermatology studies
• Moved data sets across platforms from PC to UNIX Vice Versa . Imported and converted data files from Excel, Word, Text Based Data files into SAS Data Sets for analysis.
• Responsible for providing SAS programming and analysis support for Phase III clinical study.
• Worked with Statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analysis and extensively used PROC Report and PROC Tabulate to create reports.
• Creating standard reports to use across studies and creating base programs to set up data.

ENVIRONMENT: SAS V8.2, SAS V9.1, Windows NT,UNIX

Confidential

SAS Developer:

Description: This software includes interfaces to multiple entities such as Packaging, Clinical Data management, etc, which monitors drug discovery pipeline. Randomization, which is at the core of clinical trial, is a process of assignment of treatment. There are two types of randomization, Static and Dynamic. ClinForceTM is capable of generating random codes using both Static and Dynamic Randomization Algorithms.

Responsibilities:

• Responsible for creating mockup tables and listing for statistical analysis, Ad-hoc Report Creation, generating tables, listings for Phase II-III clinical drug trial studies.
• Develop new or modify macros for report generation using SAS Macros as per the statistician's requirements.
• Produced safety tables, listings and Ad-Hoc reports for review by Clinical Team using SAS BASE SAS/STAT/GRAPH and SAS PROC FREQ, SORT, GLM, REPORT, TABULATE, UNIVARIATE, MEANS, TRANSPOSE, SUMMARY .
• Produced listing, summary, tables using different SAS/reporting tools like Proc Report, Proc tabulation and data null as per the requirement.
• Provided QA and extracted data from existing data sources and perform ad hoc queries.
• Responsible for developing programs using proc SQL and extracting data from ORACLE tables.

ENVIRONMENT: MS-SQL, SAS V8.2, SAS V9.1, Windows NT

Confidential

SAS Programmer

Analyzed the clinical trial application for Laboratory data analysis and queried the data bases for data validation

Responsibilities:

• Reviewed the test specifications,SOP,test documentation and performed data mapping validation
• Developed SAS Datasets, Reviewed case report forms, case report tabulations and SOPs for phase I and phase II clinical trials
• Validated the health care tables and wrote queries to test the applications
• Performed Quality assurance review on data tabulation and tables
• Validated the SAS tables for analysis for testing clinical applications, performed data quality checks
• Queried using SQL data analysis and validation
• Created custom reports using the system query tools

ENVIRONMENT: SAS V8.2, SAS V9.1, and Windows NT

Confidential

SASDeveloper

Responsibilities:

• Maintained familiarity with the protocol, annotated CRFs and statistical analysis plans of assigned projects
• Developed SAS Datasets, Reviewed case report forms and SOPs for phase I clinical trials
• Performed data quality checks, data validation, data mapping for both test data and production data
• Validated the SOPs that would clearly identify the scope, specific tasks and responsibilities
• Utilized the case templates to document and track test procedures for clinical applications
• Set up a fully functional SAS unit capable of tackling external projects
• Responsible for the system study, analysis, design, development, coding, generation of reports using SQL, MS-Access, testing and documentation

ENVIRONMENT: SAS V8.2, Windows NT, SQL, and ORACLE9i

Confidential

SAS Programmer

Responsibilities:

• Created SAS data sets for analysis using PROC SQL, performed data quality checks, validation, data mapping preparation on both test data and production data for phase I clinical trails
• Responsible for developing programs using PROC SQL and extracting data from ORACLE tables.
• Created annotated listings as per Report Programming Specifications RPS
• Created documentation for Mapping Specifications in MS Excel and hyperlinked the datasets
• Participated in the Learning Management System SOPs Training
• Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis
• Produced safety tables, listings and Ad-Hoc reports for review by Clinical Team using SAS BASE SAS/STAT/GRAPH and SAS Proc FREQ, SORT, GLM, REPORT, TABULATE, UNIVARIATE, MEANS, TRANSPOSE, SUMMARY

ENVIRONMENT: SAS V8.2, Windows NT, PC SAS, and Novell Netware

Confidential

Statistician

Responsibilities: Development of statistical analysis includes coding the data sets, computation of percentage distributions, graphs, comparison of rates, tabulation and validation of data reports by statistical applications

ENVIRONMENT: BASE SAS, SPSS, EpiStat, Epi Info, and Windows NT