SUMMARY

• 8+ years of experience in SAS programming with strong emphasis on Data analysis and Reporting in Financial, Marketing and Pharmaceutical Industries.
• Extensive noledge of different financial models, marketing project and documentation.
• Extensive experience in developing reports for marketing analysis, portfolio analysis, collection strategy, and business strategy and performance analysis.
• Experience in providing business insights in customer segmentation, market analysis, forecasting, competitor analysis, product development and financial analysis.
• Working noledge of data extraction from Oracle clinical database and flat files as SAS views and datasets using SAS Access, SAS/Infile, SAS/Import and SAS/SQL.
• Extensive experience with BASE SAS, SAS/MACROS, SAS/ODS, SAS/SQL, SAS/STAT, SAS/ACCESS in teh Windows and UNIX environments.
• Experience in following teh company’s Standard Operating Procedures (SOP’s), Business Requirement Specification (BRS) and Functional Requirement Specification (FRS) documents while developing teh SAS programs to produce reports.
• Implemented, created new and modified existing SAS Programs to load data from teh various source, create study specific datasets and generate reports.
• Expertise in cleaning and resolving data issues and Merge data from different sources onto a single integrated dataset.
• Performed validation and verification on developed SAS programs and teh reports.
• Expertise in using various SAS report generating procedures like Proc Report, Proc SQL, Proc Freq, Proc Means, Proc Tabulate, Proc Transpose and Proc Print.
• Highly proficient in Statistical Analysis including Univariate analysis, Regression, ANOVA, Graph and Plot.
• Developed reports in different formatted files PDF, RTF, HTML using SAS/ODS.
• Attended project team meetings, worked with teh Business analysts, Marketing managers, Statisticians as appropriate and submitted teh final reports to teh Project manager.
• Experience in handling and working on multiple projects at one time and willing to take on extra responsibilities to get work done.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Excellent work ethics, self - motivated and teh attitude to constantly strive to mould to teh dynamic requirements of teh competitive workplace.
• Excellent analytical and problem solving skills.

TECHNICAL SKILLS

SAS Tools: SAS 9.1/ 9.1.3, SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/REPORTS, SAS/MACRO, SAS/ODS and SAS/GRAPH.

SAS Procedures: Print, Append, Means, Univariate, SQL, Report, Freq, Sort, Summary, Format, Transpose, Compare, Contents, Import, Export, Tabulate, Gplot and Gchart

Databases: Oracle, MS-Access, MS-Excel and SQL Server.

Operating Systems: Windows 98/2000/XP, Vista, Win7, 8, UNIX.

Others: Ms-Access, MS-Excel, MS-Word, MS-PowerPoint, MS-Project Management, Email & Internet.

PROFESSIONAL EXPERIENCE

Confidential - Dallas, TX

Business Analyst

Responsibilities:

• Worked closely with team up with Segment Marketing to understand/document direct mail and email campaign requirements.
• Participated in preparation of overall project plan as it relates to successful management of teh Direct Marketing strategy.
• Helped to developed campaign populations for targeted marketing campaigns for multiple marketing channels.
• Worked with Database Manager to ensure all Direct Marketing drop dates are met.
• Made teh results actionable for Marketing Campaign Planning, Strategic Planning, and Sales groups.
• Integrated results of teh Marketing Mix Analysis and other advanced analyses into Marketing Campaign planning process.
• Assisted in teh creation of quantitative and qualitative primary research.
• Extracted teh data from a data warehouse and create ad-hoc reports, tables, and graphs in tight schedule according to Business needs.
• Extensively used SAS MACRO, PROC FREQ, PROC REPORT, PROC REG, and PROC ANOVA to perform teh statistical analyses.
• Used various procedures such as PROC TABULATE, PROC MEANS and PROC REPORT to generate tables, listings, graphs and reports.
• Used PROC COMPARE to compare teh data before and after editing.
• Used SAS DATA NULL and PUT statements to create teh customized reports.
• Used FTP to download SAS Formatted Data into EXCEL and CSV format.
• Used base SAS and SAS/SQL to generate tables.
• Used SAS ODS to create HTML, RTF and PDF outputs files in teh process of producing reports.
• Analyzed and interpreted significant results based on data summaries and presented teh findings.

Environment: SAS 9.2, SAS/ODS, SAS/SQL, SAS/Macro, BASE/SAS, SAS Enterprise Guide, SAS/MACRO, SAS/ACCESS, SAS/ODS, MS-Office, Marketing Plan Pro, Windows 7.

Confidential - Pittsburgh, PA.

SAS Programmer

Responsibilities:

• Converted teh monthly, quarterly reports from ad-hoc database to new data warehouse using SAS, SQL and Macros with better and accurate values.
• Analyzed data and prepare statistically sound projections of revenue, expenses, and ROI incorporating variable projects.
• Experience in creating reports in SAS Enterprise Guide v4.2/4.3
• Utilized SAS/ACCESS to extract data from relational databases for analysis.
• Modified existing datasets using data statements such as SET, MERGE, UPDATE and PROC SORT.
• Designed, developed, tested and debugged new MACROS and modified teh existing macros according to teh enhancements in teh business.
• Worked on edit check programs to maintain data consistency and data validation.
• Production Job Scheduling and Monthly Run.
• Worked on ad-hoc requirements and later converted them as monthly and quarterly reports.
• Developed and maintained teh regular codes and made some amendments as per teh business changes.
• Written TEMPeffective new codes to get teh required analytical summary data.
• Developed programs for cleaning, transforming and modifying teh data daily.
• Used base SAS and SAS/SQL to generate tables.
• Generated teh production reports and submitted with key observations and recommendations.

Environment:, SAS 9.1.3, SAS/Macro, SAS/ODS, SAS/SQL, SAS/STAT, Excel, Proc SQL, PC SAS, UNIX.

Confidential - Beaverton, OR.

Data Analyst

Responsibilities:

• Created reports for online and batch applications for various servers.
• Modified data using SAS/BASE and Macros.
• Prepared new datasets from raw sets files using Import Techniques.
• Prepared graphs using teh modified data for business analysis.
• Decreased teh run time of teh existing SAS programs by eliminating redundant DATA steps by using WHERE statements instead of IF statements and using PROC FORMAT to format SAS variable values instead of multiple IF statements.
• Validated SAS data sets using PROC MEANS, PROC FREQ and PROC UNIVARIATE.
• Used select/when statements wherever possible instead of if/then else statements to increase teh efficiency.
• Called several previous written SAS macros to create tables, and listings.
• Tested and debugged existing MACROS.
• Created tables and reports according to applicable SOPs as well as project’s Data Management Plan (DMP).
• Developed dynamic SAS programs, modified existing programs and produced Reports using BASE SAS, SAS/MACROS, and SAS/STAT & GRAPHS.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL techniques for analysis.
• Extensive experience in Data Manipulation and Analysis using SQL QUERIES, SET, MERGE, PROC TTEST, PROC ANOVA and Update techniques.
• Proficient in handling Program files, Log files, Listing files and Data sets.
• Presented teh results and statistical reports in PowerPoint for Region Sales Managers.
• Performed manual testing on applications and wrote Test Procedures to validate teh key aspects of application.

Environment: SAS 9.1, Microsoft office 2003, Microsoft Project Management, Windows XP.

Confidential - Princeton, NJ

Clinical SAS Programmer

Responsibilities:

• Involved in data analysis step of Phase II clinical trial to determine teh efficacy and safety of drugs.
• Provided Clinical & Statistical programming support for Clinical Data Managers and Statisticians.
• Ensured data quality & integrity.
• Programmed edit checks as specified in teh Data Validation Manual (DVM).
• Generated Error reports and Alert messages, including error messages for missing data.
• Wrote code using Base SAS & SAS/Macros to extract data from oracle tables using SAS/ACCESS, and SQL Pass-Through Facility.
• Generated various clinical reports, tables and developed data entry validation programs for Phase II clinical trial studies.
• Created SAS transport (.xpt) files and converted teh transport files into SAS Data Sets.
• Created and validated Macros for teh study of Integrated Summaries of Safety (ISS) and Integrated Summaries of Efficacy (ISE) for FDA regulatory submissions.
• Generated reports using Procedures such as TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using MEANS, FREQ, and UNIVARIATE and also computed teh p-values for Group comparisons.
• Extensively used SAS/Macros facility to provide outputs, log destinations.
• Combined data sets from different sites, calculated totals & percentages, titles & footnotes.
• Generated tables, listings and graphs, including Patient Demography and Characteristics, Adverse Events, and Laboratory.
• Extensively used CDISC standards such as SDTM, ADaM for drug development process.
• Developed data management study documentation including Case Report Forms, CRF Completion Guidelines, and annotated CRFs.
• Extensively used SAS/ODS to create RTF, HTML and PDF documents.
• Handled error to ensure delivery of a consistent program within teh protocol.

Environment: SAS 9.1, MS Excel and Windows XP.

Confidential

Data Analyst /SAS Programmer

Responsibilities:

• Performed various data management activities like pre-processing of data, writing SQL queries, edit check programming, and statistical analysis using Base SAS and various other tools, such as SAS/SQL, SAS/MACRO, SAS/STAT, SAS/CONNECT, and SAS/ACCESS.
• Developed SAS programs for extracting teh Oracle Database into SAS datasets using SQL Pass through facility.
• Used PROC IMPORT and IMPORT WIZARD to generate datasets from Excel sheets.
• Conducted analysis on teh raw data to achieve teh safety and efficacy objectives of teh study using various SAS procedures such as FREQ, MEANS, UNIVARIATE, TTEST, CORR, and REG.
• Developed and validated SAS programs following teh information stated in Statistical Analysis Plan (SAP).
• Produced safety tables as well as efficacy analysis included Adverse Events, Vital Signs, Laboratory Values, and Concomitant Medications.
• Involved in validating SAS programs developed by other programmers for teh efficacy and safety tables.
• Involved in generating teh summary tables required in submission of ISS and ISE as per FDA regulation.
• Generated reports using PROC FREQ, MEANS, PRINT, TABLUATE and REPORT.
• Implemented edit checks utilizing SAS MACROS.
• Created Case Report Tabulation for both standard and new domains.
• Contributed to teh development of Standard Operating Procedures (SOPs).

Environment: SAS 9.1, UNIX.